/donjo-app/views/keuangan/tabel_laporan_rp_apbd_isi.php

https://github.com/OpenSID/OpenSID · PHP · 254 lines · 243 code · 11 blank · 0 comment · 13 complexity · 3adc2cab9f3ebb9de3b6f034ea09536f MD5 · raw file 

    

  1. <style>
    2. 

  2. 	table.blueTable {
    3. 

  3. 		border: 1px solid #1C6EA4;
    4. 

  4. 		background-color: #EEEEEE;
    5. 

  5. 		width: 100%;
    6. 

  6. 		text-align: left;
    7. 

  7. 		border-collapse: collapse;
    8. 

  8. 	}
    9. 

  9. 	table.blueTable td, table.blueTable th {
    10. 

  10. 		border: 1px solid #AAAAAA;
    11. 

  11. 		padding: 3px 2px;
    12. 

  12. 	}
    13. 

  13. 	table.blueTable tbody td {
    14. 

  14. 		font-size: 13px;
    15. 

  15. 	}
    16. 

  16. 	table.blueTable tr:nth-child(even) {
    17. 

  17. 		background: #D0E4F5;
    18. 

  18. 	}
    19. 

  19. 	table.blueTable thead {
    20. 

  20. 		background: #1C6EA4;
    21. 

  21. 		background: -moz-linear-gradient(top, #5592bb 0%, #327cad 66%, #1C6EA4 100%);
    22. 

  22. 		background: -webkit-linear-gradient(top, #5592bb 0%, #327cad 66%, #1C6EA4 100%);
    23. 

  23. 		background: linear-gradient(to bottom, #5592bb 0%, #327cad 66%, #1C6EA4 100%);
    24. 

  24. 		border-bottom: 2px solid #444444;
    25. 

  25. 	}
    26. 

  26. 	table.blueTable thead th {
    27. 

  27. 		font-size: 15px;
    28. 

  28. 		font-weight: bold;
    29. 

  29. 		color: #FFFFFF;
    30. 

  30. 		text-align: center;
    31. 

  31. 		border-left: 2px solid #D0E4F5;
    32. 

  32. 	}
    33. 

  33. 	table.blueTable thead th:first-child {
    34. 

  34. 		border-left: none;
    35. 

  35. 	}
    36. 

  36. 	.bold{
    37. 

  37. 		font-weight: bold;
    38. 

  38. 	}
    39. 

  39. 	.highlighted{
    40. 

  40. 		background-color: #FFFF00 !important;
    41. 

  41. 	}
    42. 

  42. </style>
    43. 

  43. <div class="table-responsive">
    44. 

  44. <table class='blueTable' width='100%'>
    45. 

  45. 	<thead>
    46. 

  46. 		<tr>
    47. 

  47. 			<th colspan='4'>Uraian</th>
    48. 

  48. 			<th>Anggaran      (Rp)</th>
    49. 

  49. 			<th>Realisasi     (Rp)</th>
    50. 

  50. 			<th>Lebih/(Kurang)(Rp)</th>
    51. 

  51. 			<th>Persentase    (%)</th>
    52. 

  52. 		</tr>
    53. 

  53. 	</thead>
    54. 

  54. 

  55. 	<?php foreach ($pendapatan as $l): ?>
    56. 

  56. 		<tr class='bold'>
    57. 

  57. 			<td colspan='4'><?= $l['Akun'] ." ". $l['Nama_Akun']?></td>
    58. 

  58. 			<td align='right'></td>
    59. 

  59. 			<td align='right'></td>
    60. 

  60. 			<td align='right'></td>
    61. 

  61. 			<td align='right'></td>
    62. 

  62. 		</tr>
    63. 

  63. 		<?php foreach ($l['sub_pendapatan'] as $s): ?>
    64. 

  64. 			<tr class='bold'>
    65. 

  65. 				<td><?= $s['Kelompok']?></td>
    66. 

  66. 				<td colspan='3'><?= $s['Nama_Kelompok'] ?></td>
    67. 

  67. 				<td align='right'><?= number_format($s['anggaran'][0]['pagu'])?></td>
    68. 

  68. 				<td align='right'><?= number_format($s['realisasi'][0]['realisasi']+$s['realisasi_bunga'][0]['realisasi'])?></td>
    69. 

  69. 				<td align='right'><?= number_format($s['anggaran'][0]['pagu']-($s['realisasi'][0]['realisasi']+$s['realisasi_bunga'][0]['realisasi'])) ?></td>
    70. 

  70. 				<td align='right'><?= $s['anggaran'][0]['pagu'] != 0 ? number_format(($s['realisasi'][0]['realisasi']+$s['realisasi_bunga'][0]['realisasi'])/$s['anggaran'][0]['pagu']*100, 2) : 0 ?></td>
    71. 

  71. 			</tr>
    72. 

  72. 			<?php foreach ($s['sub_pendapatan2'] as $q): ?>
    73. 

  73. 				<?php if (!empty($q['anggaran'][0]['pagu'])): ?>
    74. 

  74. 				<tr>
    75. 

  75. 					<td></td>
    76. 

  76. 					<td colspan='2'><?= $q['Jenis'] ?></td>
    77. 

  77. 					<td><?= $q['Nama_Jenis'] ?></td>
    78. 

  78. 					<td align='right'><?= number_format($q['anggaran'][0]['pagu']) ?></td>
    79. 

  79. 					<td align='right'><?= number_format($q['realisasi'][0]['realisasi']+$q['realisasi_bunga'][0]['realisasi']) ?></td>
    80. 

  80. 					<td align='right'><?= number_format($q['anggaran'][0]['pagu']-($q['realisasi'][0]['realisasi']+$q['realisasi_bunga'][0]['realisasi']))?></td>
    81. 

  81. 					<td align='right'><?= $q['anggaran'][0]['pagu'] != 0 ? number_format(($q['realisasi'][0]['realisasi']+$q['realisasi_bunga'][0]['realisasi'])/$q['anggaran'][0]['pagu']*100, 2) : 0?></td>
    82. 

  82. 				</tr>
    83. 

  83. 				<?php endif; ?>
    84. 

  84. 			<?php endforeach ?>
    85. 

  85. 		<?php endforeach ?>
    86. 

  86. 		<tr class='bold highlighted'>
    87. 

  87. 			<td colspan='4' align='center'>JUMLAH PENDAPATAN</td>
    88. 

  88. 			<td align='right'><?= number_format($l['anggaran'][0]['pagu'])?></td>
    89. 

  89. 			<td align='right'><?= number_format($l['realisasi'][0]['realisasi']+$l['realisasi_bunga'][0]['realisasi'])?></td>
    90. 

  90. 			<td align='right'><?= number_format(($l['anggaran'][0]['pagu']) - ($l['realisasi'][0]['realisasi']+$l['realisasi_bunga'][0]['realisasi']))?></td>
    91. 

  91. 			<td align='right'><?= number_format(($l['realisasi'][0]['realisasi']+$l['realisasi_bunga'][0]['realisasi'])/($l['anggaran'][0]['pagu'])*100, 2)?> </td>
    92. 

  92. 		</tr>
    93. 

  93. 	<?php endforeach ?>
    94. 

  94. 

  95.   <tr>
    96. 

  96. 		<?php foreach ($belanja as $b): ?>
    97. 

  97. 			<tr class='bold'>
    98. 

  98. 				<td colspan='4'><?= $b['Akun'] ." ". $b['Nama_Akun']?></td>
    99. 

  99. 				<td align='right'></td>
    100. 

  100. 				<td align='right'></td>
    101. 

  101. 				<td align='right'></td>
    102. 

  102. 				<td align='right'></td>
    103. 

  103. 			</tr>
    104. 

  104. 			
    105. 

  105. 			<?php if ($jenis != 'bidang'): ?>
    106. 

  106. 				<!-- Belanja per kelompok -->
    107. 

  107. 				<?php foreach ($b['sub_belanja'] as $b1): ?>
    108. 

  108. 					<tr class='bold'>
    109. 

  109. 						<td><?= $b1['Kelompok']?></td>
    110. 

  110. 						<td colspan='3'><?= $b1['Nama_Kelompok'] ?></td>
    111. 

  111. 						<td align='right'><?= number_format($b1['anggaran'][0]['pagu'])?></td>
    112. 

  112. 						<td align='right'><?= number_format($b1['realisasi'][0]['realisasi']+$b1['realisasi_spj'][0]['realisasi']+$b1['realisasi_bunga'][0]['realisasi'])?></td>
    113. 

  113. 						<td align='right'><?= number_format(($b1['anggaran'][0]['pagu'])-($b1['realisasi'][0]['realisasi']+$b1['realisasi_spj'][0]['realisasi']+$b1['realisasi_bunga'][0]['realisasi'])) ?></td>
    114. 

  114. 						<td align='right'><?= $b1['anggaran'][0]['pagu'] != 0 ? number_format(($b1['realisasi'][0]['realisasi']+$b1['realisasi_spj'][0]['realisasi']+$b1['realisasi_bunga'][0]['realisasi'])/$b1['anggaran'][0]['pagu']*100, 2) : 0 ?></td>
    115. 

  115. 					</tr>
    116. 

  116. 					<?php foreach ($b1['sub_belanja2'] as $b2): ?>
    117. 

  117. 						<?php if (!empty($b2['anggaran'][0]['pagu'])): ?>
    118. 

  118. 							<tr>
    119. 

  119. 								<td></td>
    120. 

  120. 								<td colspan='2'><?= $b2['Jenis'] ?></td>
    121. 

  121. 								<td><?= $b2['Nama_Jenis'] ?></td>
    122. 

  122. 								<td align='right'><?= number_format($b2['anggaran'][0]['pagu']) ?></td>
    123. 

  123. 								<td align='right'><?= number_format($b2['realisasi'][0]['realisasi']+$b2['realisasi_spj'][0]['realisasi']+$b2['realisasi_bunga'][0]['realisasi']) ?></td>
    124. 

  124. 								<td align='right'><?= number_format(($b2['anggaran'][0]['pagu'])-($b2['realisasi'][0]['realisasi']+$b2['realisasi_spj'][0]['realisasi']+$b2['realisasi_bunga'][0]['realisasi']))?></td>
    125. 

  125. 								<td align='right'><?= $b2['anggaran'][0]['pagu'] != 0 ? number_format(($b2['realisasi'][0]['realisasi']+$b2['realisasi_spj'][0]['realisasi']+$b2['realisasi_bunga'][0]['realisasi'])/$b2['anggaran'][0]['pagu']*100, 2) : 0 ?></td>
    126. 

  126. 							</tr>
    127. 

  127. 						<?php endif; ?>
    128. 

  128. 					<?php endforeach ?>
    129. 

  129. 				<?php endforeach ?>
    130. 

  130. 			<?php else: ?>
    131. 

  131. 				<?php foreach ($belanja_bidang as $b1): ?>
    132. 

  132. 					<tr class='bold'>
    133. 

  133. 						<td><?= substr($b1['Kd_Bid'],8) ?></td>
    134. 

  134. 						<td colspan='3'><?= $b1['Nama_Bidang'] ?></td>
    135. 

  135. 						<td align='right'><?= number_format($b1['anggaran'][0]['pagu'])?></td>
    136. 

  136. 						<td align='right'><?= number_format($b1['realisasi'][0]['realisasi']+$b1['realisasi_spj'][0]['realisasi']+$b1['realisasi_bunga'][0]['realisasi'])?></td>
    137. 

  137. 						<td align='right'><?= number_format(($b1['anggaran'][0]['pagu'])-($b1['realisasi'][0]['realisasi']+$b1['realisasi_spj'][0]['realisasi']+$b1['realisasi_bunga'][0]['realisasi'])) ?></td>
    138. 

  138. 						<td align='right'><?= $b1['anggaran'][0]['pagu'] != 0 ? number_format(($b1['realisasi'][0]['realisasi']+$b1['realisasi_spj'][0]['realisasi']+$b1['realisasi_bunga'][0]['realisasi'])/$b1['anggaran'][0]['pagu']*100, 2) : 0 ?></td>
    139. 

  139. 					</tr>
    140. 

  140. 					<?php foreach ($b1['sub_belanja'] as $b2): ?>
    141. 

  141. 						<?php if (!empty($b2['anggaran'][0]['pagu'])): ?>
    142. 

  142. 							<tr>
    143. 

  143. 								<td></td>
    144. 

  144. 								<td colspan='2'><?= substr($b2['Kd_Keg'],8) ?></td>
    145. 

  145. 								<td><?= $b2['Nama_Kegiatan'] ?></td>
    146. 

  146. 								<td align='right'><?= number_format($b2['anggaran'][0]['pagu']) ?></td>
    147. 

  147. 								<td align='right'><?= number_format($b2['realisasi'][0]['realisasi']+$b2['realisasi_spj'][0]['realisasi']+$b2['realisasi_bunga'][0]['realisasi']) ?></td>
    148. 

  148. 								<td align='right'><?= number_format(($b2['anggaran'][0]['pagu'])-($b2['realisasi'][0]['realisasi']+$b2['realisasi_spj'][0]['realisasi']+$b2['realisasi_bunga'][0]['realisasi']))?></td>
    149. 

  149. 								<td align='right'><?= $b2['anggaran'][0]['pagu'] != 0 ? number_format(($b2['realisasi'][0]['realisasi']+$b2['realisasi_spj'][0]['realisasi']+$b2['realisasi_bunga'][0]['realisasi'])/$b2['anggaran'][0]['pagu']*100, 2) : 0 ?></td>
    150. 

  150. 							</tr>
    151. 

  151. 						<?php endif; ?>
    152. 

  152. 					<?php endforeach ?>
    153. 

  153. 				<?php endforeach ?>
    154. 

  154. 

  155. 			<?php endif; ?>
    156. 

  156. 

  157. 

  158. 			<tr class='bold highlighted'>
    159. 

  159. 				<td colspan='4' align='center'>JUMLAH BELANJA</td>
    160. 

  160. 				<td align='right'><?= number_format($b['anggaran'][0]['pagu'])?></td>
    161. 

  161. 				<td align='right'><?= number_format($b['realisasi'][0]['realisasi']+$b['realisasi_spj'][0]['realisasi']+$b['realisasi_bunga'][0]['realisasi'])?></td>
    162. 

  162. 				<td align='right'><?= number_format(($b['anggaran'][0]['pagu']) - ($b['realisasi'][0]['realisasi']+$b['realisasi_spj'][0]['realisasi']+$b['realisasi_bunga'][0]['realisasi']))?></td>
    163. 

  163. 				<td align='right'><?= number_format(($b['realisasi'][0]['realisasi']+$b['realisasi_spj'][0]['realisasi']+$b['realisasi_bunga'][0]['realisasi'])/($b['anggaran'][0]['pagu'])*100, 2)?> </td>
    164. 

  164. 			</tr>
    165. 

  165. 		<?php endforeach ?>
    166. 

  166. 	</tr>
    167. 

  167. 	<tr>
    168. 

  168. 	<tr class='bold highlighted'>
    169. 

  169. 		<td colspan='4' align='center'>SURPLUS / (DEFISIT)</td>
    170. 

  170. 		<td align='right'><?= number_format(($l['anggaran'][0]['pagu'])-($b['anggaran'][0]['pagu'])) ?></td>
    171. 

  171. 		<td align='right'><?= number_format(($l['realisasi'][0]['realisasi']+$l['realisasi_bunga'][0]['realisasi'])-($b['realisasi'][0]['realisasi']+$b['realisasi_spj'][0]['realisasi']+$b['realisasi_bunga'][0]['realisasi'])) ?></td>
    172. 

  172. 		<td align='right'><?= number_format((($l['anggaran'][0]['pagu'])-($b['anggaran'][0]['pagu']))-(($l['realisasi'][0]['realisasi']+$l['realisasi_bunga'][0]['realisasi'])-($b['realisasi'][0]['realisasi']+$b['realisasi_spj'][0]['realisasi']+$b['realisasi_bunga'][0]['realisasi'])))?></td>
    173. 

  173. 		<td align='right'><?= number_format((($l['anggaran'][0]['pagu'])-($b['anggaran'][0]['pagu']))/(($l['realisasi'][0]['realisasi']+$l['realisasi_bunga'][0]['realisasi'])-$b['realisasi'][0]['realisasi']+$b['realisasi_spj'][0]['realisasi']+$b['realisasi_bunga'][0]['realisasi'])*100, 2)?></td>
    174. 

  174. 	</tr>
    175. 

  175. 	</tr>
    176. 

  176. 	<tr>
    177. 

  177. 	<?php foreach ($pembiayaan as $p): ?>
    178. 

  178. 	  <tr class='bold'>
    179. 

  179. 	    <td colspan='4'><?= $p['Akun'] ." ". $p['Nama_Akun']?></td>
    180. 

  180. 			<td align='right'></td>
    181. 

  181. 			<td align='right'></td>
    182. 

  182. 			<td align='right'></td>
    183. 

  183. 			<td align='right'></td>
    184. 

  184. 		</tr>
    185. 

  185. 

  186.     <?php foreach ($p['sub_pembiayaan'] as $p1): ?>
    187. 

  187.       <tr class='bold'>
    188. 

  188.         <td><?= $p1['Kelompok']?></td>
    189. 

  189.         <td colspan='3'><?= $p1['Nama_Kelompok'] ?></td>
    190. 

  190.         <td align='right'><?= number_format($p1['anggaran'][0]['pagu'])?></td>
    191. 

  191.         <td align='right'><?= number_format($p1['realisasi'][0]['realisasi'])?></td>
    192. 

  192.         <td align='right'><?= number_format(($p1['anggaran'][0]['pagu'])-($p1['realisasi'][0]['realisasi']))?></td>
    193. 

  193.         <td align='right'></td>
    194. 

  194.       </tr>
    195. 

  195.       <?php foreach ($p1['sub_pembiayaan2'] as $p2): ?>
    196. 

  196. 				<?php if (!empty($p2['anggaran'][0]['pagu'])): ?>
    197. 

  197.         <tr>
    198. 

  198.           <td></td>
    199. 

  199.           <td colspan='2'><?= $p2['Jenis'] ?></td>
    200. 

  200.           <td><?= $p2['Nama_Jenis'] ?></td>
    201. 

  201.           <td align='right'><?= number_format($p2['anggaran'][0]['pagu'])?></td>
    202. 

  202.           <td align='right'><?= number_format($p2['realisasi'][0]['realisasi'])?></td>
    203. 

  203.           <td align='right'><?= number_format(($p2['anggaran'][0]['pagu'])-($p2['realisasi'][0]['realisasi']))?></td>
    204. 

  204.           <td align='right'></td>
    205. 

  205.         </tr>
    206. 

  206. 				<?php endif; ?>
    207. 

  207.       <?php endforeach ?>
    208. 

  208.     <?php endforeach ?>
    209. 

  209. 	<?php endforeach ?>
    210. 

  210. 

  211. 	<?php foreach ($pembiayaan_keluar as $pk): ?>
    212. 

  212.     <?php foreach ($pk['sub_pembiayaan_keluar'] as $pk1): ?>
    213. 

  213.       <tr class='bold'>
    214. 

  214.         <td><?= $pk1['Kelompok']?></td>
    215. 

  215.         <td colspan='3'><?= $pk1['Nama_Kelompok'] ?></td>
    216. 

  216.         <td align='right'><?= number_format($pk1['anggaran'][0]['pagu'])?></td>
    217. 

  217. 				<td align='right'><?= number_format($pk1['realisasi'][0]['realisasi'])?></td>
    218. 

  218.         <td align='right'><?= number_format(($pk1['anggaran'][0]['pagu'])-($pk1['realisasi'][0]['realisasi']))?></td>
    219. 

  219.         <td align='right'></td>
    220. 

  220.       </tr>
    221. 

  221. 

  222.       <?php foreach ($pk1['sub_pembiayaan_keluar2'] as $pk2): ?>
    223. 

  223. 				<?php if (!empty($pk2['anggaran'][0]['pagu'])): ?>
    224. 

  224.         <tr>
    225. 

  225.           <td></td>
    226. 

  226.           <td colspan='2'><?= $pk2['Jenis'] ?></td>
    227. 

  227.           <td><?= $pk2['Nama_Jenis'] ?></td>
    228. 

  228.           <td align='right'><?= number_format($pk2['anggaran'][0]['pagu'])?></td>
    229. 

  229. 					<td align='right'><?= number_format($pk2['realisasi'][0]['realisasi'])?></td>
    230. 

  230. 	        <td align='right'><?= number_format(($pk2['anggaran'][0]['pagu'])-($pk2['realisasi'][0]['realisasi']))?></td>
    231. 

  231.           <td align='right'></td>
    232. 

  232.         </tr>
    233. 

  233. 				<?php endif; ?>
    234. 

  234.       <?php endforeach ?>
    235. 

  235. 		<?php endforeach ?>
    236. 

  236. 	<?php endforeach ?>
    237. 

  237. 

  238. 	<tr class='bold highlighted'>
    239. 

  239. 		<td colspan='4' align='center'>PEMBIAYAAN NETTO</td>
    240. 

  240. 		<td align='right'><?= number_format(($p1['anggaran'][0]['pagu'])-($pk1['anggaran'][0]['pagu']))?></td>
    241. 

  241. 		<td align='right'><?= number_format(($p1['realisasi'][0]['realisasi'])-($pk1['realisasi'][0]['realisasi']))?></td>
    242. 

  242. 		<td align='right'><?= number_format(($p1['anggaran'][0]['pagu'])-($pk1['anggaran'][0]['pagu'])-(($p1['realisasi'][0]['realisasi'])-($pk1['realisasi'][0]['realisasi'])))?></td>
    243. 

  243. 		<td align='right'></td>
    244. 

  244. 	</tr>
    245. 

  245. 

  246. 	<tr class='bold highlighted'>
    247. 

  247. 		<td colspan='4' align='center'>SILPA/SiLPA TAHUN BERJALAN</td>
    248. 

  248. 		<td align='right'><?= number_format((($l['anggaran'][0]['pagu'])-($b['anggaran'][0]['pagu']))+(($p1['anggaran'][0]['pagu'])-($pk1['anggaran'][0]['pagu']))) ?></td>
    249. 

  249. 		<td align='right'><?= number_format((($l['realisasi'][0]['realisasi']+$l['realisasi_bunga'][0]['realisasi'])-($b['realisasi'][0]['realisasi']+$b['realisasi_spj'][0]['realisasi']+$b['realisasi_bunga'][0]['realisasi']))+(($p1['realisasi'][0]['realisasi'])-($pk1['realisasi'][0]['realisasi']))) ?></td>
    250. 

  250. 		<td align='right'><?= number_format(((($l['anggaran'][0]['pagu'])-($b['anggaran'][0]['pagu']))-(($l['realisasi'][0]['realisasi']+$l['realisasi_bunga'][0]['realisasi'])-($b['realisasi'][0]['realisasi']+$b['realisasi_spj'][0]['realisasi']+$b['realisasi_bunga'][0]['realisasi'])))+(($p1['anggaran'][0]['pagu'])-($pk1['anggaran'][0]['pagu'])-(($p1['realisasi'][0]['realisasi'])-($pk1['realisasi'][0]['realisasi']))))?></td>
    251. 

  251. 		<td align='right'></td>
    252. 

  252. 	</tr>
    253. 

  253. </table>
    254. 

  254. </div>
    255.