PageRenderTime 41ms CodeModel.GetById 15ms RepoModel.GetById 1ms app.codeStats 0ms

/application/modules/spending/views/print_rekap.php

https://bitbucket.org/bo_hmb/bo_hmb
PHP | 225 lines | 188 code | 35 blank | 2 comment | 6 complexity | a3ecf609c7755a22e079deada9f41570 MD5 | raw file
Possible License(s): Apache-2.0, MIT, LGPL-2.1, MPL-2.0-no-copyleft-exception, GPL-2.0 
    

  1. <!DOCTYPE html>
    2. 

  2. <html>
    3. 

  3. <head>
    4. 

  4. <link rel="shortcut icon" href="<?php echo base_url() ?>assets/img/logo.png" /> 
    5. 

  5.   
    6. 

  6. <title>DATA REKAP</title>
    7. 

  7.   
    8. 

  8.     <style>
    9. 

  9.       
    10. 

  10.         table{
    11. 

  11.               
    12. 

  12.         border-collapse: collapse;
    13. 

  13.               
    14. 

  14.         /*width: 100%;*/
    15. 

  15.               
    16. 

  16.         /*margin: 0 auto;*/
    17. 

  17.           
    18. 

  18.         }
    19. 

  19.           
    20. 

  20.         table th{
    21. 

  21.               
    22. 

  22.         border:1px solid #000;
    23. 

  23.               
    24. 

  24.         font-weight: bold;
    25. 

  25.               
    26. 

  26.         text-align: center;
    27. 

  27.           
    28. 

  28.         }
    29. 

  29.           
    30. 

  30.         table td{
    31. 

  31.               
    32. 

  32.         border:0px solid #000;
    33. 

  33.               
    34. 

  34.         padding: 3px;
    35. 

  35.               
    36. 

  36.         vertical-align: top;
    37. 

  37.           
    38. 

  38.         }
    39. 

  39.     </style>
    40. 

  40. </head>
    41. 

  41. <body>
    42. 

  42. <!-- kop -->
    43. 

  43. <table>    
    44. 

  44.     <tr>           
    45. 

  45.         <th style="border:0px solid #000;"><img src="<?php echo base_url() ?>assets/img/logokop.png" class="img-responsive" alt="" height="50" width="50"></th>
    46. 

  46.         <th style="border:0px solid #000; width: 150px"></th>
    47. 

  47.         <th style="border:0px solid #000; width: 80%"> 
    48. 

  48.             <h2 style="text-align: center; font-weight: bold;">DATA REKAP</h2>
    49. 

  49.         </th>
    50. 

  50.     </tr>
    51. 

  51.     <tr>
    52. 

  52.         <th style="border:0px solid #000;"></th>
    53. 

  53.         <th style="border:0px solid #000; width: 150px"></th>
    54. 

  54.         <th style="border:0px solid #000; width: 80%"> 
    55. 

  55.             <!-- <h5 style="text-align: center;">Start <?php echo $x=date('d-m-Y', strtotime($date_star)) ?>  to <?php echo $x=date('d-m-Y', strtotime($date_to)).' From '.$bank.' Bank' ?></h5> -->
    56. 

  56.         </th>
    57. 

  57.     </tr>
    58. 

  58. </table>
    59. 

  59. <hr>
    60. 

  60. 

  61. 

  62. <h3 style="text-align: center; font-weight: bold;">INCOME</h3>
    63. 

  63. <br>
    64. 

  64. <table>    
    65. 

  65.     <tr>           
    66. 

  66.         <th style="width:20px;">No</th>
    67. 

  67.         <th style="width:80px;">Bank</th>
    68. 

  68.         <th style="width:90px;">Cabang</th>
    69. 

  69.         <th style="width:90px;">No. Faktur</th>
    70. 

  70.         <th style="width:240px;">Nama Jamaah</th>
    71. 

  71.         <th style="width:80px;">Tanggal Bayar</th>
    72. 

  72.         <th style="width:110px;">Jumlah Bayar</th>
    73. 

  73.         <th style="width:250px;">Catatan</th>
    74. 

  74.         <th style="width:150px;">Nama Agen</th>
    75. 

  75.     </tr>
    76. 

  76. 

  77.     <?php $nomor=1; foreach($detail_in as $row) { ?>
    78. 

  78.         <?php 
    79. 

  79.         if ($row->tgl_keberangkatan == '') {
    80. 

  80.             $tgl='';
    81. 

  81.         } else if ($row->tgl_keberangkatan == '0000-00-00') {
    82. 

  82.             $tgl='Tabungan';
    83. 

  83.         } else {
    84. 

  84.             $tgl= date('d M Y', strtotime($row->tgl_keberangkatan));
    85. 

  85.         }
    86. 

  86. 

  87.          ?>
    88. 

  88.         <tr>                                                
    89. 

  89.            <td style="border:1px solid #000;text-align: center;"><?php echo $nomor ?></td>
    90. 

  90.            <td style="border:1px solid #000;"><?php echo $row->via_bank ?></td>
    91. 

  91.            <td style="border:1px solid #000;"><?php echo $row->nm_cabang ?></td>
    92. 

  92.            <td style="border:1px solid #000;"><?php echo $row->no_faktur ?></td>
    93. 

  93.            <td style="border:1px solid #000;"><?php echo $row->nm_lengkap ?></td>
    94. 

  94.            <td style="border:1px solid #000;"><?php echo $x=date('d-m-Y', strtotime($row->tgl_bayar)) ?></td>
    95. 

  95.            <td style="border:1px solid #000;text-align: right;"><?php echo 'Rp. '.$t=number_format($row->jml_bayar,0,',','.') ?></td>
    96. 

  96.            <td style="border:1px solid #000;"><?php echo $row->catatan ?> <?php echo $tgl ?></td>
    97. 

  97.            <td style="border:1px solid #000;"><?php echo $row->nm_marketing ?></td>
    98. 

  98.         </tr>   
    99. 

  99.     <?php $nomor++;}?> 
    100. 

  100. 

  101. </table>
    102. 

  102. 

  103. <br>
    104. 

  104. <h3 style="font-weight: bold;">Rekapitulasi</h3>            
    105. 

  105. <table>    
    106. 

  106.     <tr>          
    107. 

  107.         <!-- <th style="width: 20px;">No</th>         -->
    108. 

  108.         <th style="width: 150px;">Bank</th>
    109. 

  109.         <th style="width: 150px;">Total Pembayaran</th>
    110. 

  110.     </tr>
    111. 

  111. 

  112.     <?php $total=0; $nomor=1; foreach($sum_in as $row) { 
    113. 

  113.             ?>
    114. 

  114.         <tr>                                                
    115. 

  115.            <!-- <td style="border:1px solid #000;text-align: center;"><?php echo $nomor ?></td> -->
    116. 

  116.            <td style="border:1px solid #000;"><?php echo $row->via_bank ?></td>     
    117. 

  117.            <td style="border:1px solid #000;text-align: right;"><?php echo 'Rp. '.$t=number_format($row->count_jml_bayar,0,',','.') ?></td>      
    118. 

  118.         </tr>   
    119. 

  119.     <?php $total = $total + $row->count_jml_bayar ; $nomor++;}?> 
    120. 

  120.         <tr>
    121. 

  121.             <td style="border:1px solid #000;">Total</td>
    122. 

  122.             <td style="border:1px solid #000;text-align: right;"><?php echo 'Rp. '.$t=number_format($total,0,',','.') ?></td> 
    123. 

  123.         </tr>
    124. 

  124.         
    125. 

  125. 

  126. </table>
    127. 

  127. <br>
    128. 

  128. <table>    
    129. 

  129.     <tr>          
    130. 

  130.         <!-- <th style="width: 20px;">No</th>         -->
    131. 

  131.         <th style="width: 150px;">Nama Jadwal</th>
    132. 

  132.         <th style="width: 150px;">Total Pembayaran</th>
    133. 

  133.     </tr>
    134. 

  134. 

  135.     <?php $tot=0; $nomor=1; foreach($sum_by_schedule_in as $row) { 
    136. 

  136.             ?>
    137. 

  137.         <tr>                                                
    138. 

  138.            <!-- <td style="border:1px solid #000;text-align: center;"><?php echo $nomor ?></td> -->
    139. 

  139.            <td style="border:1px solid #000;"><?php echo $row->nm_jadwal ?></td>     
    140. 

  140.            <td style="border:1px solid #000;text-align: right;"><?php echo 'Rp. '.$t=number_format($row->count_jml_bayar,0,',','.') ?></td>      
    141. 

  141.         </tr>   
    142. 

  142.     <?php $tot=$tot+$row->count_jml_bayar; $nomor++;}?> 
    143. 

  143.         <tr>
    144. 

  144.             <td style="border:1px solid #000;">Total</td>
    145. 

  145.             <td style="border:1px solid #000;text-align: right;"><?php echo 'Rp. '.$t=number_format($tot,0,',','.') ?></td> 
    146. 

  146.         </tr>
    147. 

  147. 

  148. </table>
    149. 

  149. 

  150. 

  151. 

  152. <h3 style="text-align: center; font-weight: bold;">EXPENDITURE</h3>
    153. 

  153. <br>    
    154. 

  154. <table>    
    155. 

  155.     <tr>           
    156. 

  156.         <th style="width: 10px;">No</th>
    157. 

  157.         <th style="width: 90px;">Tanggal Faktur</th>
    158. 

  158.         <th style="width: 190px;">Jenis Faktur</th>
    159. 

  159.         <th style="width: 180px;">Nama Jadwal</th>
    160. 

  160.         <th style="width: 320px;">Item</th>
    161. 

  161.         <th style="width: 310px;">Deskripsi</th>
    162. 

  162.         <th style="width: 150px;">Diterima Oleh</th>
    163. 

  163.         <th style="width: 50px;">From Bank</th>
    164. 

  164.         <th style="width: 100px;">Total Biaya</th>
    165. 

  165.     </tr>
    166. 

  166. 

  167.     <?php $nomor=1; foreach($detail_ex as $row) {
    168. 

  168.         ?>
    169. 

  169.         <tr>                                                
    170. 

  170.            <td style="border:1px solid #000;"><?php echo $nomor ?></td>
    171. 

  171.            <td style="border:1px solid #000;"><?php echo $x=date('d-m-Y', strtotime($row->tgl_faktur)) ?></td>
    172. 

  172.            <td style="border:1px solid #000;"><?php echo $row->jenis ?></td>
    173. 

  173.            <td style="border:1px solid #000;"><?php echo $row->nm_jadwal ?></td>
    174. 

  174.            <td style="border:1px solid #000;"><?php echo $row->item ?></td>
    175. 

  175.            <td style="border:1px solid #000;"><?php echo $row->deskripsi ?></td>
    176. 

  176.            <td style="border:1px solid #000;"><?php echo $row->diterima ?></td>
    177. 

  177.            <td style="border:1px solid #000;"><?php echo $row->from_bank ?></td>
    178. 

  178.            <td style="border:1px solid #000;text-align: right;"><?php echo $t=number_format($row->sub_harga,0,',','.') ?></td>
    179. 

  179.         </tr>   
    180. 

  180.     <?php $nomor++;}?> 
    181. 

  181.     <tr>
    182. 

  182.         <td></td>
    183. 

  183.         <td></td>
    184. 

  184.         <td></td>
    185. 

  185.         <td></td>                
    186. 

  186.         <td></td>                
    187. 

  187.         <td></td>                
    188. 

  188.         <td></td>                
    189. 

  189.         <td  style="border:1px solid #000;text-align: center;">Total</td>
    190. 

  190.         <td  style="border:1px solid #000;text-align: right;"><?php echo $t=number_format($main->total_biaya,0,',','.');?></td>
    191. 

  191.     </tr>
    192. 

  192. </table>
    193. 

  193. <br>
    194. 

  194. <table>
    195. 

  195.     <?php $no=1; foreach ($detail_group as $row) { ?>
    196. 

  196.     <tr>
    197. 

  197.         <td style="border:1px solid #000;"><?php echo $no; ?></td>
    198. 

  198.         <td style="border:1px solid #000;"><?php echo $row->jenis; ?></td>
    199. 

  199.         <td style="border:1px solid #000;text-align: right;"><?php echo $t=number_format($row->total_biaya,0,',','.') ?></td>
    200. 

  200.     </tr>
    201. 

  201.     <?php $no++; } ?>
    202. 

  202.     <tr>
    203. 

  203.         <td style="border:1px solid #000;text-align: center;" colspan="2">Total</td>
    204. 

  204.         <td style="border:1px solid #000;text-align: right;"><?php echo $t=number_format($main->total_biaya,0,',','.');?></td>
    205. 

  205.     </tr>
    206. 

  206. </table>
    207. 

  207. <br>
    208. 

  208. <h3 style="text-align: left; font-weight: bold;">REKAPITULASI</h3>
    209. 

  209. 

  210. <table>
    211. 

  211.     <tr>
    212. 

  212.         <td style="border:1px solid #000;">Pemasukan</td>
    213. 

  213.         <td style="border:1px solid #000;">Pengeluaran</td>
    214. 

  214.         <td style="border:1px solid #000;">Margin</td>
    215. 

  215.     </tr>
    216. 

  216.     <tr>
    217. 

  217.         <td style="border:1px solid #000;text-align: right;"><?php echo 'Rp. '.$t=number_format($tot,0,',','.') ?></td>
    218. 

  218.         <td style="border:1px solid #000;text-align: right;"><?php echo 'Rp. '.$t=number_format($main->total_biaya,0,',','.');?></td>
    219. 

  219.         <td style="border:1px solid #000;text-align: right;"><?php echo 'Rp. '.$t=number_format($tot - $main->total_biaya,0,',','.') ?></td>
    220. 

  220.     </tr>
    221. 

  221.     
    222. 

  222. </table>
    223. 

  223. 

  224. </body>
    225. 

  225. </html>
    226.