/modules/Report/Resources/views/cash/report_excel.blade.php

https://gitlab.com/laher01/factu40 · PHP · 246 lines · 193 code · 47 blank · 6 comment · 41 complexity · b076974aac6277c3f06355fda4659c96 MD5 · raw file 

    

  1. <!DOCTYPE html>
    2. 

  2. <html lang="es">
    3. 

  3.     <head>
    4. 

  4.         <meta charset="UTF-8">
    5. 

  5.         <meta name="viewport" content="width=device-width, initial-scale=1.0">
    6. 

  6.         <meta http-equiv="Content-Type" content="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=utf-8" />
    7. 

  7.         <meta http-equiv="X-UA-Compatible" content="ie=edge">
    8. 

  8.         <title>Document</title>
    9. 

  9.     </head>
    10. 

  10.     <body>
    11. 

  11.         <div>
    12. 

  12.             <h3 align="center" class="title"><strong>Reporte Documentos</strong></h3>
    13. 

  13.         </div>
    14. 

  14.         <br>
    15. 

  15.         <div style="margin-top:20px; margin-bottom:15px;">
    16. 

  16.             <table>
    17. 

  17.                 <tr>
    18. 

  18.                     <td>
    19. 

  19.                         <p><b>Empresa: </b></p>
    20. 

  20.                     </td>
    21. 

  21.                     <td align="center">
    22. 

  22.                         <p><strong>{{$company->name}}</strong></p>
    23. 

  23.                     </td>
    24. 

  24.                     <td>
    25. 

  25.                         <p><strong>Fecha: </strong></p>
    26. 

  26.                     </td>
    27. 

  27.                     <td align="center">
    28. 

  28.                         <p><strong>{{date('Y-m-d')}}</strong></p>
    29. 

  29.                     </td>
    30. 

  30.                 </tr>
    31. 

  31.                 <tr>
    32. 

  32.                     <td>
    33. 

  33.                         <p><strong>Ruc: </strong></p>
    34. 

  34.                     </td>
    35. 

  35.                     <td align="center">{{$company->number}}</td>
    36. 

  36.                     <td>
    37. 

  37.                         <p><strong>Establecimiento: </strong></p>
    38. 

  38.                     </td>
    39. 

  39.                     <td align="center">{{$establishment->address}} - {{$establishment->department->description}} - {{$establishment->district->description}}</td>
    40. 

  40.                 </tr>
    41. 

  41.             </table>
    42. 

  42.         </div>
    43. 

  43.         <br>
    44. 

  44.         @if(!empty($records))
    45. 

  45.             <div class="">
    46. 

  46.                 <div class=" ">
    47. 

  47.                     @php
    48. 

  48.                         $acum_total_taxed=0;
    49. 

  49.                         $acum_total_igv=0;
    50. 

  50.                         $acum_total=0;
    51. 

  51.                       
    52. 

  52.                         $serie_affec = '';
    53. 

  53.                         $acum_total_exonerado=0;
    54. 

  54.                         $acum_total_inafecto=0;
    55. 

  55. 

  56.                         $acum_total_free=0;
    57. 

  57. 

  58.                         $acum_total_taxed_usd = 0;
    59. 

  59.                         $acum_total_igv_usd = 0;
    60. 

  60.                         $acum_total_usd = 0;
    61. 

  61.                     @endphp
    62. 

  62.                     <table class="">
    63. 

  63.                         <thead>
    64. 

  64.                             <tr>
    65. 

  65.                                 <th>#</th>
    66. 

  66.                                 <th>Tipo Doc</th>
    67. 

  67.                                 <th>Número</th>
    68. 

  68.                                 <th>Fecha emisión</th>
    69. 

  69.                                 <th>Doc. Afectado</th>
    70. 

  70.                                 <th>Cliente</th>
    71. 

  71.                                 <th>RUC</th>
    72. 

  72.                                 <th>Estado</th>
    73. 

  73.                                 <th class="">Moneda</th>
    74. 

  74.                                 <th>Total Exonerado</th>
    75. 

  75.                                 <th>Total Inafecto</th>
    76. 

  76.                                 <th>Total Gratuito</th>
    77. 

  77.                                 <th>Total Gravado</th>
    78. 

  78.                                 <th>Total IGV</th>
    79. 

  79.                                 <th>Total</th>
    80. 

  80.                             </tr>
    81. 

  81.                         </thead>
    82. 

  82.                         <tbody>
    83. 

  83.                             @foreach($records as $key => $value)
    84. 

  84.                             <tr>
    85. 

  85.                                 <td class="celda">{{$loop->iteration}}</td>
    86. 

  86.                                 <td class="celda">{{$value->document_type->id}}</td>
    87. 

  87.                                 <td class="celda">{{$value->series}}-{{$value->number}}</td>
    88. 

  88.                                 <td class="celda">{{$value->date_of_issue->format('Y-m-d')}}</td>
    89. 

  89.                                   @if(in_array($value->document_type_id,["07","08"]) && $value->note)
    90. 

  90. 

  91.                                         @php 
    92. 

  92.                                             $serie = ($value->note->affected_document) ? $value->note->affected_document->series : $value->note->data_affected_document->series;
    93. 

  93.                                             $number =  ($value->note->affected_document) ? $value->note->affected_document->number : $value->note->data_affected_document->number;
    94. 

  94.                                             $serie_affec = $serie.' - '.$number;
    95. 

  95. 

  96.                                         @endphp
    97. 

  97.                                         
    98. 

  98. 

  99.                                     @endif
    100. 

  100.                                 <td class="celda">{{$serie_affec }} </td>
    101. 

  101.                                 <td class="celda">{{$value->customer->name}}</td>
    102. 

  102.                                 <td class="celda">{{$value->customer->number}}</td>
    103. 

  103.                                 <td class="celda">{{$value->state_type->description}}</td>
    104. 

  104.                                
    105. 

  105.                                 @php
    106. 

  106.                                   $signal = $value->document_type_id;
    107. 

  107.                                   $state = $value->state_type_id;
    108. 

  108.                                 @endphp
    109. 

  109. 

  110.                                 <td class="celda">{{$value->currency_type_id}}</td>
    111. 

  111.                              
    112. 

  112.                                 <!-- <td class="celda">{{$signal == '07' ? "-" : ""  }}{{$value->total_exonerated}}</td>
    113. 

  113.                                 <td class="celda">{{$signal == '07' ? "-" : ""  }}{{$value->total_unaffected}}</td>
    114. 

  114.                                 <td class="celda">{{$signal == '07' ? "-" : ""  }}{{$value->total_free}}</td>
    115. 

  115.                                 <td class="celda">{{$signal == '07' ? "-" : ""  }}{{$value->total_taxed}}</td>
    116. 

  116.                                 <td class="celda">{{$signal == '07' ? "-" : ""  }}{{$value->total_igv}}</td>
    117. 

  117.                                 <td class="celda">{{$signal == '07' ? "-" : ""  }}{{$value->total}}</td> -->
    118. 

  118. 

  119.                                 
    120. 

  120.                                         
    121. 

  121.                                 <td class="celda">{{($signal == '07' || ($signal!='07' && $state =='11')) ? "-" : ""  }}{{$value->total_exonerated}} </td>
    122. 

  122.                                 <td class="celda">{{($signal == '07' || ($signal!='07' && $state =='11')) ? "-" : ""  }}{{$value->total_unaffected}}</td>
    123. 

  123.                                 <td class="celda">{{($signal == '07' || ($signal!='07' && $state =='11')) ? "-" : ""  }}{{$value->total_free}}</td>
    124. 

  124. 

  125.                                 <td class="celda">{{($signal == '07' || ($signal!='07' && $state =='11')) ? "-" : ""  }}{{$value->total_taxed}}</td>
    126. 

  126.                                 
    127. 

  127.                                 <td class="celda">{{($signal == '07' || ($signal!='07' && $state =='11')) ? "-" : ""  }}{{$value->total_igv}}</td>
    128. 

  128.                                 <td class="celda">{{($signal == '07' || ($signal!='07' && $state =='11')) ? "-" : ""  }}{{$value->total}}</td>
    129. 

  129.                             @php
    130. 

  130.                               
    131. 

  131.                                 $serie_affec =  '';
    132. 

  132.                               
    133. 

  133.                             @endphp
    134. 

  134.  
    135. 

  135.                             </tr>
    136. 

  136.                             @php
    137. 

  137.                             if($value->currency_type_id == 'PEN'){
    138. 

  138.                                 /*$acum_total_taxed +=  $signal != '07' ? $value->total_taxed : -$value->total_taxed ;
    139. 

  139.                                 $acum_total_igv +=  $signal != '07' ? $value->total_igv : -$value->total_igv ;
    140. 

  140.                                 $acum_total += $signal != '07' ? $value->total : -$value->total ;*/
    141. 

  141. 

  142.                                 /*$acum_total_exonerado += $signal != '07' ? $value->total_exonerated : -$value->total_exonerated ;                                            
    143. 

  143.                                 $acum_total_inafecto += $signal != '07' ? $value->total_unaffected : -$value->total_unaffected ;
    144. 

  144.                                 $acum_total_free += $signal != '07' ? $value->total_free : -$value->total_free ;*/
    145. 

  145. 

  146. 

  147.                                 if(($signal == '07' && $state !== '11')){
    148. 

  148. 

  149.                                     $acum_total += -$value->total;
    150. 

  150.                                     $acum_total_taxed += -$value->total_taxed;
    151. 

  151.                                     $acum_total_igv += -$value->total_igv;
    152. 

  152. 

  153.                                     
    154. 

  154.                                     $acum_total_exonerado += -$value->total_exonerated;
    155. 

  155.                                     $acum_total_inafecto += -$value->total_unaffected;
    156. 

  156.                                     $acum_total_free += -$value->total_free;
    157. 

  157. 

  158. 

  159.                                 }elseif($signal != '07' && $state == '11'){
    160. 

  160. 

  161.                                     $acum_total += 0;
    162. 

  162.                                     $acum_total_taxed += 0;
    163. 

  163.                                     $acum_total_igv += 0;
    164. 

  164. 

  165.                                     $acum_total_exonerado += 0;
    166. 

  166.                                     $acum_total_inafecto += 0;
    167. 

  167.                                     $acum_total_free += 0;
    168. 

  168. 

  169.                                 }else{
    170. 

  170. 

  171.                                     $acum_total += $value->total;
    172. 

  172.                                     $acum_total_taxed += $value->total_taxed;
    173. 

  173.                                     $acum_total_igv += $value->total_igv;
    174. 

  174. 

  175.                                     $acum_total_exonerado += $value->total_exonerated;
    176. 

  176.                                     $acum_total_inafecto += $value->total_unaffected;
    177. 

  177.                                     $acum_total_free += $value->total_free;
    178. 

  178.                                 }
    179. 

  179. 

  180. 

  181.                             }else if($value->currency_type_id == 'USD'){ 
    182. 

  182.                                 
    183. 

  183.                                 if(($signal == '07' && $state !== '11')){
    184. 

  184. 

  185.                                     $acum_total_usd += -$value->total;
    186. 

  186.                                     $acum_total_taxed_usd += -$value->total_taxed;
    187. 

  187.                                     $acum_total_igv_usd += -$value->total_igv;
    188. 

  188. 

  189. 

  190. 

  191.                                 }elseif($signal != '07' && $state == '11'){
    192. 

  192. 

  193.                                     $acum_total_usd += 0;
    194. 

  194.                                     $acum_total_taxed_usd += 0;
    195. 

  195.                                     $acum_total_igv_usd += 0;
    196. 

  196. 

  197. 

  198.                                 }else{
    199. 

  199. 

  200.                                     $acum_total_usd += $value->total;
    201. 

  201.                                     $acum_total_taxed_usd += $value->total_taxed;
    202. 

  202.                                     $acum_total_igv_usd += $value->total_igv;
    203. 

  203. 

  204.                                 }
    205. 

  205. 

  206.                                 
    207. 

  207.                             }
    208. 

  208.                             @endphp
    209. 

  209.                             @endforeach
    210. 

  210.                             <tr>
    211. 

  211.                                 <td colspan="8"></td>
    212. 

  212.                                 <!-- <td >Totales</td>
    213. 

  213.                                 <td>{{$acum_total_exonerado}}</td>
    214. 

  214.                                 <td>{{$acum_total_inafecto}}</td>
    215. 

  215.                                 <td>{{$acum_total_free}}</td> -->
    216. 

  216.                                 <td >Totales PEN</td>
    217. 

  217. 

  218.                                 <td>{{number_format($acum_total_exonerado, 2)}}</td>
    219. 

  219.                                 <td>{{number_format ($acum_total_inafecto, 2 )}}</td>
    220. 

  220.                                 <td>{{number_format($acum_total_free, 2)}}</td>
    221. 

  221. 

  222.                                 <td>{{$acum_total_taxed}}</td>
    223. 

  223.                                 <td>{{$acum_total_igv}}</td>
    224. 

  224.                                 <td>{{$acum_total}}</td>
    225. 

  225.                             </tr>
    226. 

  226.                             <tr>
    227. 

  227.                                 <td colspan="8"></td>
    228. 

  228.                                 <td >Totales USD</td>
    229. 

  229.                                 <td></td>
    230. 

  230.                                 <td></td>
    231. 

  231.                                 <td></td>
    232. 

  232.                                 <td>{{$acum_total_taxed_usd}}</td>
    233. 

  233.                                 <td>{{$acum_total_igv_usd}}</td>
    234. 

  234.                                 <td>{{$acum_total_usd}}</td>
    235. 

  235.                             </tr>
    236. 

  236.                         </tbody>
    237. 

  237.                     </table>
    238. 

  238.                 </div>
    239. 

  239.             </div>
    240. 

  240.         @else
    241. 

  241.             <div>
    242. 

  242.                 <p>No se encontraron registros.</p>
    243. 

  243.             </div>
    244. 

  244.         @endif
    245. 

  245.     </body>
    246. 

  246. </html>
    247.