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