@extends('layouts.antet')

@section ('content')

    <table class="table table-condesed" width=100%  >
      <tr>
        <td style="vertical-align:top" width="50%">
    <table class="table">
     
      <td width=50%>
          Client: <strong>{{ $solicitare->nume }}</strong>   <br>
          Nr contract: <strong>{{ $solicitare->nr_contract }}</strong>   <br>
          Data contract: <strong>{{ dateFormatAfisare($solicitare->data_contract) }}</strong>   <br>
          Valoare credit (LEI): <strong>{{ number_format($solicitare->valoare_credit,2) }}</strong> <br>
          Dobanda anuala : <strong>{{ number_format($solicitare->procent_dobanda,2)." %" }}</strong> <br>
          Durata imprumut (luni): <strong>{{ number_format($solicitare->perioada_de_creditare,0) }}</strong> <br>
          <br>
          Rata lunara (LEI): <strong>{{ number_format($ratalunara,2) }}</strong> <br>
          Luni de plata: <strong>{{ number_format($solicitare->perioada_de_creditare,0) }}</strong> <br>
          Suma totala platita (LEI): <strong>{{ number_format($grafic->sum('ratalunara'),2) }}</strong> <br>
            din care dobanda (LEI): <strong>{{ number_format($grafic->sum('dobanda'),2) }}</strong> <br>
      </td>
  </tr>
</table>
</td>
<td style="vertical-align:top" width="50%">
              <table class="table table-condesed" style="border-collapse: collapse; "  width=100%   >
                 <tr>
        <td align ="center" colspan="4">
          <h2><strong>Grafic de rambursare</strong></h2>
         
      
      </td>
            <tr style="border-bottom:1pt solid black; border-top:1pt solid black; page-break-inside: avoid !important;">
              <th align ="center" colspan="4">
                 Rezumat pe ani
              </th>
            </tr>
            <tr style="border-bottom:1pt solid black; page-break-inside: avoid !important;">
              <th align ="center" width="20%">
                    Anul
                </th>
                 <th align ="center" width="20%">
                    Credit cumulat
                </th>
                <th align ="center" width="20%">
                    Dobanda cumulata
                </th>
                <th align ="center" width="20%">
                    Comision de gestiune
                </th>
                <th align ="center" width="20%">
                    Credit In Sold
                </th>
               
               
            </tr>
    
                  
                     <tr style="border-bottom:1pt solid black; page-break-inside: avoid !important;"> 
                       <th align="center" width="25%">
                          
                      </th>
                      
                      <th align="center" style="vertical-align:top"  width="25%">
                         
                      </th>
                      <th align="center" style="vertical-align:top"  width="25%">
                     
                         
                      </th>
                      <th align="center" style="vertical-align:top"  width="25%">
                      {{ number_format(round($grafic->sum('principal'),2),2) }}
                         
                      </th>
                         
                      </tr>     
                    
                    @foreach($grafic->groupby('anul')  as $rata)
                      
                      <tr style="border-bottom:1pt solid black; page-break-inside: avoid !important;"> 
                      <td align="center" width="20%">
                       {{ $rata[0]->anul }}
                      </td>
                     <td align="center" style="vertical-align:top"  width="20%">
                      {{ number_format(round($rata->sum('principal'),2),2) }}
                         
                      </td>
                      <td align="center" style="vertical-align:top"  width="20%">
                       {{ number_format(round($rata->sum('dobanda'),2),2) }}
                                              
                      </td>
                     <td align="center" style="vertical-align:top"  width="20%">
                       {{ number_format(round($rata->sum('comision_de_gestiune'),2),2) }}
                                              
                      </td>
                     
                      <td align="center" style="vertical-align:top"  width="20%">
                      {{ number_format(round($rata->min('soldprincipal'),2),2) }}
                      </td>
                         
                      </tr>
                     
                    @endforeach 
              </table>
            </td>
           </tr>
          </table>
<hr>
 <div >
           
    </div>  
   
<table class="table table-condesed" style="border-collapse: collapse; " width=100%  >
            
            <tr style="border-bottom:1pt solid black; border-top:1pt solid black; page-break-inside: avoid !important;">
              <th align ="center" width="10%">
                    Nr Crt
                </th>
               <th align ="center" width="10%">
                    Data Platii
                </th>
                <th align ="center" width="15%">
                    Credit
                </th>
                 <th align ="center" width="15%">
                    Dobanda
                </th>
                 <th align ="center" width="15%">
                   Comision de gestiune
                </th>
                <th align ="center" width="15%">
                    Total De Plata
                </th>
               
                
                <th align ="center" width="15%">
                    Credit In Sold
                </th>
               
               
            </tr>
    
                  
                     <tr  style="border-bottom:1pt solid black; page-break-inside: avoid !important;"> 
                       <th align="center" width="10%">
                          
                      </th>
                      <th align="center" width="10%">
                          
                      </th>
                      <th align="center" style="vertical-align:top"  width="15%">
                      {{ number_format(round($grafic->sum('principal'),2),2) }}
                         
                      </th>
                      <th align="center" style="vertical-align:top"  width="15%">
                          {{ number_format(round($grafic->sum('dobanda'),2),2) }}
                      </th>
                      <th align="center" style="vertical-align:top"  width="15%">
                          {{ number_format(round($grafic->sum('comision_de_gestiune'),2),2) }}
                      </th>
                     <th align="center" width="15%">
                          {{ number_format(round($grafic->sum('ratalunara'),2),2) }}
                      </th>
                      
                      <th align="center" style="vertical-align:top"  width="15%">
                      {{ number_format(round($grafic->sum('principal'),2),2) }}
                         
                      </th>
                         
                      </tr>     
                    
                    @foreach($grafic->groupBy("datascadentalucratoare")  as $rata)
                      
                      <tr  style="border-bottom:1pt solid black; page-break-inside: avoid !important;"> 
                      <td align="center" width="10%">
                       {{ number_format(round($rata[0]->nr_crt,0),0) }}
                      </td>
                       <td align="center" width="10%">
                       {{ dateFormatAfisare($rata[0]->datascadentalucratoare) }}
                      </td>
                       <td align="center" style="vertical-align:top"  width="15%">
                      {{ number_format(round($rata->sum("principal"),2),2) }}
                      </td>
                      <td align="center" style="vertical-align:top"  width="15%">
                       {{ number_format(round($rata->sum("dobanda"),2),2) }}
                      </td>
                      <td align="center" style="vertical-align:top"  width="15%">
                       {{ number_format(round($rata->sum("comision_de_gestiune"),2),2) }}
                      </td>
                      <td align="center" width="15%">
                       {{ number_format(round($rata->sum("ratalunara"),2),2) }}
                      </td>
                      <td align="center" style="vertical-align:top"  width="15%">
                      {{ number_format(round($rata->sum("soldprincipal"),2),2) }}
                      </td>
                         
                      </tr>
                      
                    @endforeach 
              </table>
  
            
     <hr> 
     
      <table class="table table-condesed" width=100% > 
                 <tr>
                  <td  width="15%">
                       
                  </td>
                  <td  width="30%" align="left" >
                   <strong>ACCESS CAPITAL IFN SA,</strong>
                  </td>
                   <td  width="10%" >
                
              </td>
                   <td width="30%" align="center" >
                    <strong>Imprumutat,</strong>
                  </td>
                <td  width="15%" >
                
              </td>
          </tr> 
          <tr>
                  <td  width="15%">
                       
                  </td>
                  <td  width="30%" align="left" >
                   Prin:
                  </td>
                   <td  width="10%" >
                
              </td>
                   <td width="30%" align="center" >
               
                  </td>
                <td  width="15%" >
                
              </td>
          </tr>
           <tr>
                  <td  width="15%">
                       
                  </td>
                  <td  width="30%" align="left" >
                   Nume: Stefan Nicoara
                  </td>
                   <td  width="10%" >
                
              </td>
                   <td width="30%" align="center" >
               
                  </td>
                <td  width="15%" >
                
              </td>
          </tr>
          <tr>
                  <td  width="15%">
                       
                  </td>
                  <td  width="30%" align="left" >
                   Functia: Director general
                  </td>
                   <td  width="10%" >
                
              </td>
                   <td width="30%" align="center" >
               
                  </td>
                <td  width="15%" >
                
              </td>
          </tr>
      </table>                
     
  

  
  
@stop