@extends('layouts.antet')

@section ('content')

             <center> <h3> {{$titluRaport}} </h3></center>
   
      <table class="text-sm table table-condesed" border="1" style="border-collapse: collapse;" width=100%>
            <thead>
            <tr style=" page-break-inside: avoid !important;">
              <th align ="center" rowspan="3" width="3%">
                Nr crt
              </th>  
              <th align ="center" rowspan="3" width="5%">
                  Tip risc <br>
                  Serviciul datoriei
              </th>
              <th align ="center" rowspan="3" width="7%">
                  Nume client
              </th>
               <th align ="center" rowspan="3" width="5%">
                  Nr contract<br>
                  Data contract<br>
                  Tip valuta
              </th>
               
              <th align ="center" rowspan="3"  width="5%">
                  Penalitati
              </th>
              <th align ="center" rowspan="3"  width="5%">
                  Alte comisioane
              </th>
               <th align ="center" rowspan="3"  width="10%">
                  Tip creanta
              </th>
              <th align ="center" rowspan="3" width="10%">
                  Total
              </th>
              <th align ="center" rowspan="3" width="10%">
                  Sub 0
              </th>
              <th align ="center" rowspan="3" width="5%">
                  0 - 15
              </th>
              <th align ="center" rowspan="3"  width="5%">
                  16 - 30
              </th>
              <th align ="center" rowspan="3" width="5%">
                  31 - 60
              </th>
              <th align ="center" rowspan="3" width="5%">
                  61 - 90
              </th>
              <th align ="center" rowspan="3" width="5%">
                  Pete 90
              </th>
            </tr>
          
            
            </thead>
       			
                    @foreach($tabel->groupBy("tiprisc") as $tiprisc)
                            
                          <tr style="page-break-inside: avoid !important;">
                            <td align="left" colspan="13" width="100%">
                              Tip risc :{{$tiprisc[0]->tiprisc}}    
                            </td>
                          </tr> 
                    
                            @foreach($tiprisc as $contract)
                            
                            <tr style="page-break-inside: avoid !important;"> 
                              <td align ="center" rowspan="3"  width="3%">
                                  {{$i++}}
                              </td>
                             <td align ="center" rowspan="3"  width="5%">
                                  {{$contract->tiprisc}} <br><br>
                                  {{$contract->serviciuldatoriei}}
                              </td>
                              <td align ="left"  rowspan="3" width="7%">
                                  {{$contract->nume}}
                              </td>
                               
                               <td align ="center" rowspan="3"   width="5%">
                                  {{$contract->nr_contract}}<br>
                                  {{dateFormatAfisare($contract->data_contract)}} <br>
                                  {{$contract->tipvaluta}}
                              </td>
                               
                              
                              <td align ="right"  rowspan="3" width="5%">
                                  {{number_format($contract->penalitati,2)}}
                              </td>
                              <td align ="right"  rowspan="3" width="5%">
                                  {{number_format($contract->altecomisioane,2)}}
                              </td>
                          
                               <td align ="left" width="10%">
                                  Capital
                              </td>
                              <td align ="right" width="10%">
                                  {{number_format($contract->principal,2)}}
                              </td>
                              <td align ="right" width="10%">
                                  {{number_format($contract->psub_0,2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($contract->p0_15,2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($contract->p16_30,2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($contract->p31_60,2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($contract->p61_90,2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($contract->ppeste_90,2)}}
                              </td>
                           
                           </tr>
                            <tr style="page-break-inside: avoid !important;"> 
                              
                               <td align ="left" width="10%">
                                  Dobanda
                              </td>
                              <td align ="right" width="10%">
                                  {{number_format($contract->dobanda,2)}}
                              </td>
                              <td align ="right" width="10%">
                                  {{number_format($contract->dsub_0,2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($contract->d0_15,2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($contract->d16_30,2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($contract->d31_60,2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($contract->d61_90,2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($contract->dpeste_90,2)}}
                              </td>
                           
                           </tr>
                            <tr style="page-break-inside: avoid !important;"> 
                               <td align ="left" width="10%">
                                  Coms. de gestiune
                              </td>
                              <td align ="right" width="10%">
                                  {{number_format($contract->comisiondegestiune,2)}}
                              </td>
                              <td align ="right" width="10%">
                                  {{number_format($contract->csub_0,2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($contract->c0_15,2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($contract->c16_30,2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($contract->c31_60,2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($contract->c61_90,2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($contract->cpeste_90,2)}}
                              </td>
                           
                           </tr>
                           <tr style="page-break-inside: avoid !important;">
                            <td align="left" colspan="13" width="100%">
                             
                            </td>
                          </tr> 
                           @endforeach 
                  
                   <tr style="page-break-inside: avoid !important;">
                    
                     <td align="left"  colspan="4" rowspan="3" width="20%">
                       TOTAL {{$tiprisc[0]->tiprisc}}
                       </td>
                       <td align="right" rowspan="3" width="5%">
                          {{ number_format($tiprisc->sum("penalitati"),2)}}
                      </td>
                      <td align="right" rowspan="3" width="5%">
                          {{ number_format($tiprisc->sum("altecomisioane"),2)}}
                       </td>
                    
                               <td align ="left" width="10%">
                                  Capital
                              </td>
                              <td align ="right" width="10%">
                                  {{number_format($tiprisc->sum("principal"),2)}}
                              </td>
                              <td align ="right" width="10%">
                                  {{number_format($tiprisc->sum("psub_0"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tiprisc->sum("p0_15"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tiprisc->sum("p16_30"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tiprisc->sum("p31_60"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tiprisc->sum("p61_90"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tiprisc->sum("ppeste_90"),2)}}
                              </td>
                           
                           </tr>
                            <tr style="page-break-inside: avoid !important;"> 
                               <td align ="left" width="10%">
                                  Dobanda
                              </td>
                              <td align ="right" width="10%">
                                  {{number_format($tiprisc->sum("dobanda"),2)}}
                              </td>
                              <td align ="right" width="10%">
                                  {{number_format($tiprisc->sum("dsub_0"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tiprisc->sum("d0_15"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tiprisc->sum("d16_30"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tiprisc->sum("d31_60"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tiprisc->sum("d61_90"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tiprisc->sum("dpeste_90"),2)}}
                              </td>
                           
                           </tr>
                            <tr style="page-break-inside: avoid !important;"> 
                               <td align ="left" width="10%">
                                  Coms. de gestiune
                              </td>
                              <td align ="right" width="10%">
                                  {{number_format($tiprisc->sum("comisiondegestiune"),2)}}
                              </td>
                              <td align ="right" width="10%">
                                  {{number_format($tiprisc->sum("csub_0"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tiprisc->sum("c0_15"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tiprisc->sum("c16_30"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tiprisc->sum("c31_60"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tiprisc->sum("c61_90"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tiprisc->sum("cpeste_90"),2)}}
                              </td>
                           
                           </tr>
                           <tr style="page-break-inside: avoid !important;">
                            <td align="left" colspan="13" width="100%">
                             
                            </td>
                          </tr> 
                         @endforeach  
                   <tr style="page-break-inside: avoid !important;" >
                    
                     <td align="left"  colspan="4" rowspan="3" width="20%">
                       TOTAL GENERAL
                       </td>
                       <td align="right" rowspan="3" width="5%">
                          {{ number_format($tabel->sum("penalitati"),2)}}
                      </td>
                      <td align="right" rowspan="3" width="5%">
                          {{ number_format($tabel->sum("altecomisioane"),2)}}
                       </td>
                   
                               <td align ="left" width="10%">
                                  Capital
                              </td>
                              <td align ="right" width="10%">
                                  {{number_format($tabel->sum("principal"),2)}}
                              </td>
                              <td align ="right" width="10%">
                                  {{number_format($tabel->sum("psub_0"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tabel->sum("p0_15"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tabel->sum("p16_30"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tabel->sum("p31_60"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tabel->sum("p61_90"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tabel->sum("ppeste_90"),2)}}
                              </td>
                           
                           </tr>
                            <tr style="page-break-inside: avoid !important;"> 
                               <td align ="left" width="10%">
                                  Dobanda
                              </td>
                              <td align ="right" width="10%">
                                  {{number_format($tabel->sum("dobanda"),2)}}
                              </td>
                              <td align ="right" width="10%">
                                  {{number_format($tabel->sum("dsub_0"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tabel->sum("d0_15"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tabel->sum("d16_30"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tabel->sum("d31_60"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tabel->sum("d61_90"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tabel->sum("dpeste_90"),2)}}
                              </td>
                           
                           </tr>
                            <tr style="page-break-inside: avoid !important;"> 
                               <td align ="left" width="10%">
                                  Coms. de gestiune
                              </td>
                              <td align ="right" width="10%">
                                  {{number_format($tabel->sum("comisiondegestiune"),2)}}
                              </td>
                              <td align ="right" width="10%">
                                  {{number_format($tabel->sum("csub_0"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tabel->sum("c0_15"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tabel->sum("c16_30"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tabel->sum("c31_60"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tabel->sum("c61_90"),2)}}
                              </td>
                              <td align ="right" width="5%">
                                  {{number_format($tabel->sum("cpeste_90"),2)}}
                              </td>
                           
                           </tr>
               </table>
    
      
     <br>
     <table class="table table-condesed" width=100% > 
                 <tr>
                  <td  width="15%">
                       
                  </td>
                  <td  width="30%" align="center" >
                   DIRECTOR GENERAL,<br><br>
                   {{$company->director_general}}
                   <br><br>
                    _________________________
                  </td>
                   <td  width="5%" >
                
              </td>
                   <td width="30%" align="center" >
                     DIRECTOR ECONOMIC,<br><br>
                    {{$company->contabil_sef}}
                   <br><br>
                    ___________________________________
                  </td>
                <td  width="15%" >
                
              </td>
          </tr> 
      </table>  
     
      @stop