@extends('layouts.antet')

@section ('content')
       <br>
      <table class="table table-condesed text-sm" border="1" style="border-collapse: collapse;" width=100%>
            <thead>
            <tr>
              <td align="center" colspan="8">
             <center> <h3> Balanța {{$selectie}}<br> {{$selectie2}}</h3></center>
              </td>
            </tr>  
              @if (!$balantadetaliata)
            <tr >
              <th align ="center" rowspan="2" width="5%">
                   <center>Nr crt.</center>
              </th>
              <th align ="center" rowspan="2" width="29%">
                    <center>Partener</center>
              </th>
               <th align ="center" colspan="2" width="22%">
                   Anterior
              </th>
              <th align ="center" colspan="2" width="22%">
                   Rulaj in perioada
              </th>
              
              <th align ="center" colspan="2" width="22%">
                   Sold final
              </th>    
             <!--   <th align ="center"  rowspan="2" width="5%">
                    <center>Cont</center>
              </th> -->
            </tr>
            <tr style=" page-break-inside: avoid !important;">
            
             
               <th align ="center"  width="11%">
                    <center>Debit</center>
              </th>
              <th align ="center"  width="11%">
                    <center>Credit</center>
              </th>
               <th align ="center"  width="11%">
                    <center>Debit</center>
              </th>
              <th align ="center"  width="11%">
                    <center>Credit</center>
              </th>
               
               <th align ="center"  width="11%">
                    <center>Debit</center>
              </th>
              <th align ="center"  width="11%">
                    <center>Credit</center>
              </th>
            </tr>
            @endif
          </thead>
          <tbody>
       				<!-- <table class="table table-condesed" style="border-collapse: collapse;" width=100%>     -->
                          @foreach($balanta->sortBy('denumire',SORT_STRING) as $partener)
                            @if (!$balantadetaliata)
                            <tr style="height:30px; page-break-inside: avoid !important;"> 
                             <td align="center" width="5%">
                              {{$i++ }} 
                             </td>
                             <td align="left" width="29%">
                              {{$partener->denumire }} 
                             </td>
                             
                            
                              <td align="right" width="11%">
                                {{ number_format($partener->rulajAntD,2)}}
                            </td>
                            <td align="right" width="11%">
                                {{ number_format($partener->rulajAntC,2)}} 
                             </td>
                           <td align="right" width="11%">
                                {{ number_format($partener->rulajD,2)}}
                            </td>
                            <td align="right" width="11%">
                                {{ number_format($partener->rulajC,2)}}
                             </td>
                            
                              <td align="right" width="11%">
                                {{ number_format($partener->soldFinalD,2)}}
                            </td>
                            <td align="right" width="11%">
                                {{ number_format($partener->soldFinalC,2)}}
                             </td>
                         
                           </tr>
                           @endif
                           @if ($balantadetaliata)
                            </tbody>
               </table>
                           <br>
                                  <table class="table table-condesed text-sm" border="1" style="border-collapse: collapse;" width=100%>
                                    <thead>
                                  <tr style=" page-break-inside: avoid !important;">
                                  
                                    <th align ="center"  width="5%">
                                          <center>Nr crt.</center>
                                    </th>
                                    <th align ="center" width="21%">
                                          <center>Document</center>
                                    </th>
                                   
                                    
                                    <th align ="center"  width="21%">
                                          <center>Explicatie</center>
                                    </th> 
                                    <th align ="center"  width="10%">
                                          <center>Cont</center> 
                                    </th> 
                                    <th align ="center"  width="10%">
                                          <center>Data</center> 
                                    </th> 
                                    <th align ="center"  width="11%">
                                      Rulaj Debit    
                                    </th>
                                    <th align ="center"  width="11%">
                                       Rulaj Credit   
                                    </th>
                                     <th align ="center"  width="11%">
                                       Sold  
                                    </th>
                                   
                                  </tr>
                                </thead>
                                <tbody>
                                  @foreach($balantadetaliata->groupBy("luna") as $docLuna)
                                  @foreach($docLuna as $doc)
                                    <tr style=" page-break-inside: avoid !important;">
                                   
                                    <td align ="center"  width="5%">
                                          <center>{{$j++}}</center>
                                    </td>
                                    <td align ="left" width="21%">
                                          {{$doc->tip_document}}<br>
                                          {{$doc->nr_document." / ".dateFormatAfisare($doc->data_document)}}
                                    </td>
                                     <td align ="left"  width="21%">
                                          {{$doc->expl}}
                                    </td> 
                                     <td align ="center"  width="10%">
                                         {{$doc->cont_partener}}
                                    </td> 
                                     <td align ="center"  width="10%">
                                          {{dateFormatAfisare($doc->data_document)}}
                                    </td> 
                                     <td align ="right"  width="11%">
                                          {{$doc->debit!=0?number_format($doc->debit,2):''}}
                                    </td>
                                    <td align ="right"  width="11%">
                                          {{$doc->credit!=0?number_format($doc->credit,2):''}}
                                    </td>
                                    <td align ="right"  width="11%">
                                        
                                          {{number_format($doc->sold,2)}}
                                       
                                    </td>
                                    
                                     
                                  </tr>
                                  @endforeach
                                   <tr style=" page-break-inside: avoid !important;">
                                   
                                    <td align ="center"  colspan="5" width="67%">
                                         
                                    
                                       <strong>   Total rulaj {{$docLuna->max("lunalitere") }} </strong>
                                    </td>
                                    
                                     <td align ="right"  width="11%">
                                       <strong>   {{number_format($docLuna->sum("debit"),2)}} </strong>
                                    </td>
                                    <td align ="right"  width="11%">
                                        <strong>  {{number_format($docLuna->sum("credit"),2)}} </strong>
                                    </td>
                                    <td align ="right"  width="11%">
                                        
                                       <strong>   {{number_format($doc->sold,2)}} </strong>
                                       
                                    </td>
                                    
                                     
                                  </tr>
                                  @endforeach
                                  <tr style=" page-break-inside: avoid !important;">
                                   
                                    
                                    <th align ="center" colspan="5" width="26%">
                                         TOTAL
                                    </th>
                                   
                                     <th align ="right"  width="11%">
                                          {{number_format($balantadetaliata->sum("debit"),2)}}
                                    </th>
                                    <th align ="right"  width="11%">
                                          {{number_format($balantadetaliata->sum("credit"),2)}}
                                    </th>
                                    <th align ="right"  width="11%">
                                        
                                          {{number_format($doc->sold,2)}}
                                       
                                    </th>
                                    
                                     
                                  </tr>
                                  </tbody>
                                </table>
                           @endif
                           @endforeach 
                   
                   @if(!$balantadetaliata)
                    <tr style="height:50px; page-break-inside: avoid !important;" >
                    
                     <th align="left" colspan="2" width="34%">
                       TOTAL GENERAL
                       </th>
                       
                        <th align="right" width="11%">
                          {{ number_format($balanta->sum("rulajAntD"),2)}}
                      </th>
                      <th align="right" width="11%">
                          {{ number_format($balanta->sum("rulajAntC"),2)}}
                       </th>
                     <th align="right" width="11%">
                          {{ number_format($balanta->sum("rulajD"),2)}}
                      </th>
                      <th align="right" width="11%">
                          {{ number_format($balanta->sum("rulajC"),2)}}
                       </th>
                       
                        <th align="right" width="11%">
                          {{ number_format($balanta->sum("soldFinalD"),2)}}
                      </th>
                      <th align="right" width="11%">
                          {{ number_format($balanta->sum("soldFinalC"),2)}}
                       </th>
                     <!--  <td align="right" width="5%">
                        
                      </td>  -->
                    </tr>
                  </tbody>
               </table>
                    @endif
    
      
     <br>
    <table class="table table-condesed" width=100% > 
                 <tr>
                  <td  width="15%">
                       
                  </td>
                  <td  width="30%" align="center" >
                   ADMINISTRATOR,<br><br>
                   {{$company->director_general}}
                   <br><br>
                    _________________________
                  </td>
                   <td  width="10%" >
                
              </td>
                   <td width="30%" align="center" >
                     DIRECTOR ECONOMIC,<br><br>
                    {{$company->contabil_sef}}
                   <br><br>
                    ___________________________________
                  </td>
                <td  width="15%" >
                
              </td>
          </tr> 
      </table>  
      @stop
<!-- </body>
</html> -->