@foreach($tabel as $rand)
@if(count($groupBy)>=1)
|
{{$groupBy[0]["type"]==="Date"
?$groupBy[0]["denumire"].": ".dateFormatAfisare(collect($rand->flatten()->values()->all()[0])[$groupBy[0]["col"]])
:$groupBy[0]["denumire"].": ".collect($rand->flatten()->values()->all()[0])[$groupBy[0]["col"]]}}
|
@foreach($rand as $randGrup)
@if(count($groupBy)>=2)
|
{{$groupBy[1]["type"]==="Date"
?$groupBy[1]["denumire"].": ".dateFormatAfisare(collect($randGrup->flatten()->values()->all()[0])[$groupBy[1]["col"]])
:$groupBy[1]["denumire"].": ".collect($randGrup->flatten()->values()->all()[0])[$groupBy[1]["col"]]}}
|
@foreach($randGrup as $randGrup1)
@if(count($groupBy)>=3)
|
{{$groupBy[2]["type"]==="Date"
?$groupBy[2]["denumire"].": ".dateFormatAfisare(collect($randGrup1->flatten()->values()->all()[0])[$groupBy[2]["col"]])
:$groupBy[2]["denumire"].": ".collect($randGrup1->flatten()->values()->all()[0])[$groupBy[2]["col"]]}}
|
@foreach($randGrup1 as $randGrup2)
@if(count($groupBy)===4)
|
{{$groupBy[3]["type"]==="Date"
?$groupBy[3]["denumire"].": ".dateFormatAfisare(collect($randGrup2->flatten()->values()->all()[0])[$groupBy[3]["col"]])
:$groupBy[3]["denumire"].": ".collect($randGrup2->flatten()->values()->all()[0])[$groupBy[3]["col"]]}}
|
@foreach($randGrup2 as $randGrup3)
@foreach ($antetTabel as $col)
|
@if($col["type"]==="Date")
{{dateFormatAfisare(collect($randGrup3)[$col["col"]])}}
@else
{{collect($randGrup3)[$col["col"]]}}
@endif
|
@endforeach
@endforeach
@if($totalBy)
@foreach ($antetTabel as $col)
@if($col["col"]==$groupBy[3]["col"])
| {{$groupBy[3]["type"]==="Date"
?"TOTAL ".dateFormatAfisare(collect($randGrup2->flatten()->values()->all()[0])[$groupBy[3]["col"]])
:"TOTAL ".collect($randGrup2->flatten()->values()->all()[0])[$groupBy[3]["col"]]}} |
@else
@if(in_array($col["col"],$totalBy))
{{round(collect($randGrup2->flatten()->values()->all())->sum($col["col"]),2)}}
@endif
|
@endif
@endforeach
@endif
@else
@foreach ($antetTabel as $col)
|
@if($col["type"]==="Date")
{{dateFormatAfisare(collect($randGrup2)[$col["col"]])}}
@else
{{collect($randGrup2)[$col["col"]]}}
@endif
|
@endforeach
@endif
@endforeach
@if($totalBy)
@foreach ($antetTabel as $col)
@if($col["col"]==$groupBy[2]["col"])
| {{$groupBy[2]["type"]==="Date"
?"TOTAL ".dateFormatAfisare(collect($randGrup1->flatten()->values()->all()[0])[$groupBy[2]["col"]])
:"TOTAL ".collect($randGrup1->flatten()->values()->all()[0])[$groupBy[2]["col"]]}} |
@else
@if(in_array($col["col"],$totalBy))
{{round(collect($randGrup1->flatten()->values()->all())->sum($col["col"]),2)}}
@endif
|
@endif
@endforeach
@endif
@else
@foreach ($antetTabel as $col)
|
@if($col["type"]==="Date")
{{dateFormatAfisare(collect($randGrup1)[$col["col"]])}}
@else
{{collect($randGrup1)[$col["col"]]}}
@endif
|
@endforeach
@endif
@endforeach
@if($totalBy)
@foreach ($antetTabel as $col)
@if($col["col"]==$groupBy[1]["col"])
| {{$groupBy[1]["type"]==="Date"
?"TOTAL ".dateFormatAfisare(collect($randGrup->flatten()->values()->all()[0])[$groupBy[1]["col"]])
:"TOTAL ".collect($randGrup->flatten()->values()->all()[0])[$groupBy[1]["col"]]}} |
@else
@if(in_array($col["col"],$totalBy))
{{round(collect($randGrup->flatten()->values()->all())->sum($col["col"]),2)}}
@endif
|
@endif
@endforeach
@endif
@else
@foreach ($antetTabel as $col)
|
@if($col["type"]==="Date")
{{dateFormatAfisare(collect($randGrup)[$col["col"]])}}
@else
{{collect($randGrup)[$col["col"]]}}
@endif
|
@endforeach
@endif
@endforeach
@if($totalBy)
@foreach ($antetTabel as $col)
@if($col["col"]==$groupBy[0]["col"])
|
{{$groupBy[0]["type"]==="Date"
?"TOTAL ".dateFormatAfisare(collect($rand->flatten()->values()->all()[0])[$groupBy[0]["col"]])
:"TOTAL ".collect($rand->flatten()->values()->all()[0])[$groupBy[0]["col"]]}}
|
@else
@if(in_array($col["col"],$totalBy))
{{round(collect($rand->flatten()->values()->all())->sum($col["col"]),2)}}
@endif
|
@endif
@endforeach
@endif
@else
@foreach ($antetTabel as $col)
|
@if($col["type"]==="Date")
{{dateFormatAfisare(collect($rand)[$col["col"]])}}
@else
{{collect($rand)[$col["col"]]}}
@endif
|
@endforeach
@endif
@endforeach
@if($totalBy)
@foreach ($antetTabel as $key=>$col)
@if($key==0 && !in_array($col["col"],$totalBy))
|
{{"TOTAL GENERAL "}}
|
@else
@if(in_array($col["col"],$totalBy))
{{round(collect($tabel->flatten()->values()->all())->sum($col["col"]),2)}}
@endif
|
@endif
@endforeach
@endif