@component('mail::message',[
						 "tabel"=>$tabel,
						 "antetTabel"=>$antetTabel,
						 "titluRaport"=>$titluRaport,
						 "groupBy"=>$groupBy,
						 "totalBy"=>$totalBy,
             "user"=>""
						 ])
    <center> <h3> {!! nl2br($titluRaport) !!} </h3></center>
 

Buna ziua,

 

In baza contractului de credit {{$contract[0]->nr_contract}}/{{dateFormatAfisare($contract[0]->data_contract)}} incheiat cu Access Capital IFN SA va informam despre obligatiile de plata lunare, detaliate in nota de calcul atasata.

Va rugam sa efectuati demersurile necesare pentru ca suma mentionata sa fie disponibila în contul indicat la data scadentei, respectiv {{dateFormatAfisare($contract->max("data_scadenta"))}}.

 

 

Multumesc!   

       
<table class="table" border="1" style="border-collapse: collapse; " width=100%>
  <tr style="border-bottom:1pt solid black; page-break-inside: avoid !important;">
  @foreach ($antetTabel as $col)
  <td {{"align=center width=".$col["width"]."" }} >
  {{$col["denumire"]}}
  </td>
  @endforeach
  </tr>
  @foreach($tabel as $rand)
  @if(count($groupBy)>=1) 
  <tr style="border-bottom:1pt solid black; page-break-inside: avoid !important;">
  <td {{"align=left width=".$col["width"]." colspan=".count($antetTabel)  }} > 
  {{$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"]]}}
  </td>
  </tr>
  @foreach($rand as $randGrup)
  <!-- GRUP 2 -->
  @if(count($groupBy)>=2)                
  <tr style="border-bottom:1pt solid black; page-break-inside: avoid !important;">
  <td {{"align=left width=".$col["width"]." colspan=".count($antetTabel) }}  > 
  {{$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"]]}}
  </td>
  </tr>
  @foreach($randGrup as $randGrup1)
  <!-- GRUP 3 -->
  @if(count($groupBy)>=3)
  <tr style="border-bottom:1pt solid black; page-break-inside: avoid !important;">
  <td {{"align=left width=".$col["width"]." colspan=".count($antetTabel) }} > 
  {{$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"]]}}
  </td>
  </tr>
  @foreach($randGrup1 as $randGrup2)
  <!-- GRUP 4 -->
  @if(count($groupBy)===4)
  <tr style="border-bottom:1pt solid black; page-break-inside: avoid !important;">
  <td {{"align=left width=".$col["width"]." colspan=".count($antetTabel) }} > 
  {{$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"]]}}
  </td>
  </tr>
  @foreach($randGrup2 as $randGrup3)
  <tr style="border-bottom:1pt solid black; page-break-inside: avoid !important;">
  @foreach ($antetTabel as $col)
  <td {{"align=".$col["align"]." width=".$col["width"]."" }} > 
  @if($col["type"]==="Date")
  {{dateFormatAfisare(collect($randGrup3)[$col["col"]])}}
  @else
  @if($col["type"]==="Number")
  {{number_format(collect($randGrup3)[$col["col"]],2)}}
  @else
  {{collect($randGrup3)[$col["col"]]}}
  @endif
  @endif
  </td>
  @endforeach
  </tr>
  @endforeach
  @if($totalBy)
  <tr style="border-bottom:1pt solid black; page-break-inside: avoid !important;">
  @foreach ($antetTabel as $col)
  @if($col["col"]==$groupBy[3]["col"])
  <td {{"align=".$col["align"]." width=".$col["width"]."" }} > 
  {{$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"]]}}</td>
  @else
  <td {{"align=".$col["align"]." width=".$col["width"]."" }} > 
  @if(in_array($col["col"],$totalBy))  
  {{number_format(round(collect($randGrup2->flatten()->values()->all())->sum($col["col"]),2),2)}}
  @endif 
  </td>
  @endif
  @endforeach
  </tr>
  @endif
  @else
  <!-- GRUP 4 -->
  <tr style="border-bottom:1pt solid black; page-break-inside: avoid !important;">
  @foreach ($antetTabel as $col)
  <td {{"align=".$col["align"]." width=".$col["width"]."" }} > 
  @if($col["type"]==="Date")
  {{dateFormatAfisare(collect($randGrup2)[$col["col"]])}}
  @else
  @if($col["type"]==="Number")
  {{number_format(collect($randGrup2)[$col["col"]],2)}}
  @else
  {{collect($randGrup2)[$col["col"]]}}
  @endif
  @endif
  </td>
  @endforeach
  </tr>
  @endif
  @endforeach
  @if($totalBy)
  <tr style="border-bottom:1pt solid black; page-break-inside: avoid !important;">
  @foreach ($antetTabel as $col)
  @if($col["col"]==$groupBy[2]["col"])
  <td {{"align=".$col["align"]." width=".$col["width"]."" }} > 
  {{$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"]]}}</td>
  @else
  <td {{"align=".$col["align"]." width=".$col["width"]."" }} > 
  @if(in_array($col["col"],$totalBy))  
  {{number_format(round(collect($randGrup1->flatten()->values()->all())->sum($col["col"]),2),2)}}
  @endif 
  </td>
  @endif
  @endforeach
  </tr>
  @endif
  @else
  <!-- GRUP 3 -->
  <tr style="border-bottom:1pt solid black; page-break-inside: avoid !important;">
  @foreach ($antetTabel as $col)
  <td {{"align=".$col["align"]." width=".$col["width"]."" }} > 
  @if($col["type"]==="Date")
  {{dateFormatAfisare(collect($randGrup1)[$col["col"]])}}
  @else 
  @if($col["type"]==="Number")
  {{number_format(collect($randGrup1)[$col["col"]],2)}}
  @else
  {{collect($randGrup1)[$col["col"]]}}
  @endif
  @endif
  </td>
  @endforeach
  </tr>
  @endif
  @endforeach
  @if($totalBy)
  <tr style="border-bottom:1pt solid black; page-break-inside: avoid !important;">
  @foreach ($antetTabel as $col)
  @if($col["col"]==$groupBy[1]["col"])
  <td {{"align=".$col["align"]." width=".$col["width"]."" }} > 
  {{$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"]]}}</td>
  @else
  <td {{"align=".$col["align"]." width=".$col["width"]."" }} > 
  @if(in_array($col["col"],$totalBy))  
  {{number_format(round(collect($randGrup->flatten()->values()->all())->sum($col["col"]),2),2)}}
  @endif 
  </td>
  @endif
  @endforeach
  </tr>
  @endif
  @else
  <!-- GRUP 2 -->
  <!-- GRUP1 -->
  <tr style="border-bottom:1pt solid black; page-break-inside: avoid !important;">  
  @foreach ($antetTabel as $col)
  <td {{"align=".$col["align"]." width=".$col["width"]."" }} > 
  @if($col["type"]==="Date")
  {{dateFormatAfisare(collect($randGrup)[$col["col"]])}}
  @else
  @if($col["type"]==="Number")
  {{number_format(collect($randGrup)[$col["col"]],2)}}
  @else
  {{collect($randGrup)[$col["col"]]}}
  @endif
  @endif
  </td>
  @endforeach
  </tr>
  @endif
  @endforeach
  @if($totalBy)
  <tr style="border-bottom:1pt solid black; page-break-inside: avoid !important;">
  @foreach ($antetTabel as $col)
  @if($col["col"]==$groupBy[0]["col"])
  <td {{"align=".$col["align"]." width=".$col["width"]."" }} > 
  {{$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"]]}}
  </td>
  @else
  <td {{"align=".$col["align"]." width=".$col["width"]."" }} > 
  @if(in_array($col["col"],$totalBy))  
  {{number_format(round(collect($rand->flatten()->values()->all())->sum($col["col"]),2),2)}}
  @endif 
  </td>
  @endif
  @endforeach
  </tr>
  @endif
  @else
  <!-- FARA GRUP -->
  <tr style="border-bottom:1pt solid black; page-break-inside: avoid !important;">
  @foreach ($antetTabel as $col)
  <td {{"align=".$col["align"]." width=".$col["width"]."" }} > 
  @if($col["type"]==="Date")
  {{dateFormatAfisare(collect($rand)[$col["col"]])}}
  @else
  @if($col["type"]==="Number")
  {{number_format(collect($rand)[$col["col"]],2)}}
  @else
  {{collect($rand)[$col["col"]]}}
  @endif
  @endif
  </td>
  @endforeach
  </tr>
  @endif
  @endforeach
  <!-- TOTAL GENERAL -->
  @if($totalBy)
  <tr style="border-bottom:1pt solid black; page-break-inside: avoid !important;">
  @foreach ($antetTabel as $key=>$col)
  @if($key==0 && !in_array($col["col"],$totalBy))
  <td {{"align=".$col["align"]." width=".$col["width"]."" }} > 
  {{"TOTAL GENERAL "}}
  </td>
  @else 
  <td {{"align='right' width=".$col["width"]."" }} > 
  @if(in_array($col["col"],$totalBy))  
  {{number_format(round(collect($tabel->flatten()->values()->all())->sum($col["col"]),2),2)}}
  @endif 
  </td>
  @endif
  @endforeach
  </tr>
  @endif
</table>
@endcomponent