API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 29th, 2014
292
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 29.98 KB | None | 0 0
raw download clone embed print report
  1. $csql = "SELECT DISTINCT 'H' AS tipe,a.kd_program AS kode2,CONCAT('<b>',a.kd_program,'</b>') AS kode,'' AS kode1, CONCAT('<b>',a.nm_program,'</b>') AS uraian,
  2. (SELECT SUM(nilai) FROM trdrka WHERE kd_kegiatan IN (SELECT kd_kegiatan FROM trskpd WHERE kd_program = a.kd_program)) AS anggaran,
  3. IFNULL((SELECT SUM(nilai) FROM (SELECT a.tgl_bukti,a.kd_skpd,a.jns_spp,b.kd_kegiatan,b.kd_rek5,b.nilai FROM trhtransout a INNER JOIN
  4. trdtransout b ON a.no_bukti = b.no_bukti)z WHERE z.kd_skpd = a.kd_skpd AND
  5. z.kd_kegiatan IN (SELECT kd_kegiatan FROM trskpd WHERE kd_program = a.kd_program)
  6. AND z.jns_spp IN ('1','2','3') AND MONTH(z.tgl_bukti) = '$nbulan'),0) AS real_up_ini,
  7. IFNULL((SELECT SUM(nilai) FROM (SELECT a.tgl_bukti,a.kd_skpd,a.jns_spp,b.kd_kegiatan,b.kd_rek5,b.nilai FROM trhtransout a INNER JOIN
  8. trdtransout b ON a.no_bukti = b.no_bukti)z WHERE z.kd_skpd = a.kd_skpd AND
  9. z.kd_kegiatan IN (SELECT kd_kegiatan FROM trskpd WHERE kd_program = a.kd_program)
  10. AND z.jns_spp ='4' AND MONTH(z.tgl_bukti) = '$nbulan'),0) -
  11. IFNULL((SELECT SUM(IFNULL(rupiah,0)) FROM (SELECT a.tgl_sts,a.kd_skpd,a.jns_trans,a.kd_kegiatan,b.kd_rek5,b.rupiah FROM trhkasin_pkd a INNER JOIN
  12. trdkasin_pkd b ON a.no_sts = b.no_sts)t WHERE t.kd_skpd = a.kd_skpd AND
  13. t.kd_kegiatan IN (SELECT kd_kegiatan FROM trskpd WHERE kd_program = a.kd_program) AND t.jns_trans = '51' AND MONTH(t.tgl_sts) = '$nbulan')
  14. ,0)AS real_gaji_ini,
  15. IFNULL((SELECT SUM(nilai) FROM (SELECT a.tgl_bukti,a.kd_skpd,a.jns_spp,b.kd_kegiatan,b.kd_rek5,b.nilai FROM trhtransout a INNER JOIN
  16. trdtransout b ON a.no_bukti = b.no_bukti)z WHERE z.kd_skpd = a.kd_skpd AND
  17. z.kd_kegiatan IN (SELECT kd_kegiatan FROM trskpd WHERE kd_program = a.kd_program)
  18. AND z.jns_spp IN('6','5') AND MONTH(z.tgl_bukti) = '$nbulan'),0) -
  19. IFNULL((SELECT SUM(IFNULL(rupiah,0)) FROM (SELECT a.tgl_sts,a.kd_skpd,a.jns_trans,a.kd_kegiatan,b.kd_rek5,b.rupiah FROM trhkasin_pkd a INNER JOIN
  20. trdkasin_pkd b ON a.no_sts = b.no_sts)t WHERE t.kd_skpd = a.kd_skpd AND
  21. t.kd_kegiatan IN (SELECT kd_kegiatan FROM trskpd WHERE kd_program = a.kd_program) AND t.jns_trans = '52' AND MONTH(t.tgl_sts) = '$nbulan')
  22. ,0)AS real_brg_js_ini,
  23. IFNULL((SELECT SUM(nilai) FROM (SELECT a.tgl_bukti,a.kd_skpd,a.jns_spp,b.kd_kegiatan,b.kd_rek5,b.nilai FROM trhtransout a INNER JOIN
  24. trdtransout b ON a.no_bukti = b.no_bukti)z WHERE z.kd_skpd = a.kd_skpd AND
  25. z.kd_kegiatan IN (SELECT kd_kegiatan FROM trskpd WHERE kd_program = a.kd_program)
  26. AND z.jns_spp IN ('1','2','3') AND MONTH(z.tgl_bukti) < '$nbulan'),0) AS real_up_ll,
  27. IFNULL((SELECT SUM(nilai) FROM (SELECT a.tgl_bukti,a.kd_skpd,a.jns_spp,b.kd_kegiatan,b.kd_rek5,b.nilai FROM trhtransout a INNER JOIN
  28. trdtransout b ON a.no_bukti = b.no_bukti)z WHERE z.kd_skpd = a.kd_skpd AND
  29. z.kd_kegiatan IN (SELECT kd_kegiatan FROM trskpd WHERE kd_program = a.kd_program)
  30. AND z.jns_spp ='4' AND MONTH(z.tgl_bukti) < '$nbulan'),0) -
  31. IFNULL((SELECT SUM(IFNULL(rupiah,0)) FROM (SELECT a.tgl_sts,a.kd_skpd,a.jns_trans,a.kd_kegiatan,b.kd_rek5,b.rupiah FROM trhkasin_pkd a INNER JOIN
  32. trdkasin_pkd b ON a.no_sts = b.no_sts)t WHERE t.kd_skpd = a.kd_skpd AND
  33. t.kd_kegiatan IN (SELECT kd_kegiatan FROM trskpd WHERE kd_program = a.kd_program) AND t.jns_trans = '51' AND MONTH(t.tgl_sts) < '$nbulan')
  34. ,0)AS real_gaji_ll,
  35. IFNULL((SELECT SUM(nilai) FROM (SELECT a.tgl_bukti,a.kd_skpd,a.jns_spp,b.kd_kegiatan,b.kd_rek5,b.nilai FROM trhtransout a INNER JOIN
  36. trdtransout b ON a.no_bukti = b.no_bukti)z WHERE z.kd_skpd = a.kd_skpd AND
  37. z.kd_kegiatan IN (SELECT kd_kegiatan FROM trskpd WHERE kd_program = a.kd_program)
  38. AND z.jns_spp IN('6','5') AND MONTH(z.tgl_bukti) < '$nbulan'),0) -
  39. IFNULL((SELECT SUM(IFNULL(rupiah,0)) FROM (SELECT a.tgl_sts,a.kd_skpd,a.jns_trans,a.kd_kegiatan,b.kd_rek5,b.rupiah FROM trhkasin_pkd a INNER JOIN
  40. trdkasin_pkd b ON a.no_sts = b.no_sts)t WHERE t.kd_skpd = a.kd_skpd AND
  41. t.kd_kegiatan IN (SELECT kd_kegiatan FROM trskpd WHERE kd_program = a.kd_program) AND t.jns_trans = '52' AND MONTH(t.tgl_sts) < '$nbulan')
  42. ,0)AS real_brg_js_ll
  43. FROM trskpd a WHERE a.kd_skpd = '$lcskpd' ";
  44.  
  45. $hasil = $this->db->query($csql);
  46. $lcno = 0;
  47. $totang = 0;
  48. $totgjini = 0;
  49. $totgjll = 0;
  50. $totgjsd = 0;
  51. $totbrini = 0;
  52. $totbrll = 0;
  53. $totbrsd = 0;
  54. $totupini = 0;
  55. $totupll = 0;
  56. $totupsd = 0;
  57.  
  58. foreach ($hasil->result() as $row)
  59. {
  60.  
  61. $jmspj = $row->real_gaji_ini + $row->real_gaji_ll + $row->real_brg_js_ini + $row->real_brg_js_ll + $row->real_up_ini + $row->real_up_ll;
  62.  
  63. if(!empty($row->anggaran)){
  64. $lcprogram = $row->kode2;
  65. $cRet .="<tr>
  66. <td align=\"left\" width=\"11%\" style=\"font-size:8px\">$row->kode".$this->tukd_model->dotrek($row->kode1)."</td>
  67. <td valign=\"top\" align=\"left\" width=\"26%\" style=\"font-size:8px\">$row->uraian</td>";
  68. $cRet .="<td align=\"right\" width=\"6%\" style=\"font-size:8px\"><b>".number_format($row->anggaran)."&nbsp;</b></td>
  69. <td align=\"right\" width=\"5%\" style=\"font-size:8px\"><b>".number_format($row->real_gaji_ll)."&nbsp;</b></td>
  70. <td align=\"right\" width=\"5%\" style=\"font-size:8px\"><b>".number_format($row->real_gaji_ini)."&nbsp;</b></td>
  71. <td align=\"right\" width=\"5%\" style=\"font-size:8px\"><b>".number_format($row->real_gaji_ini+$row->real_gaji_ll)."&nbsp;</b></td>
  72. <td align=\"right\" width=\"5%\" style=\"font-size:8px\"><b>".number_format($row->real_brg_js_ll)."&nbsp;</b></td>
  73. <td align=\"right\" width=\"5%\" style=\"font-size:8px\"><b>".number_format($row->real_brg_js_ini)."&nbsp;</b></td>
  74. <td align=\"right\" width=\"5%\" style=\"font-size:8px\"><b>".number_format($row->real_brg_js_ll+$row->real_brg_js_ini)."&nbsp;</b></td>
  75. <td align=\"right\" width=\"5%\" style=\"font-size:8px\"><b>".number_format($row->real_up_ll)."&nbsp;</b></td>
  76. <td align=\"right\" width=\"5%\" style=\"font-size:8px\"><b>".number_format($row->real_up_ini)."&nbsp;</b></td>
  77. <td align=\"right\" width=\"5%\" style=\"font-size:8px\"><b>".number_format($row->real_up_ini+$row->real_up_ll)."&nbsp;</b></td>
  78. <td align=\"right\" width=\"6%\" style=\"font-size:8px\"><b>".number_format($jmspj)."&nbsp;</b></td>
  79. <td align=\"right\" width=\"6%\" style=\"font-size:8px\"><b>".number_format($row->anggaran - $jmspj)."&nbsp;</b></td>";
  80. $cRet .="</tr> ";
  81.  
  82. $csql2 = "SELECT 'H' AS tipe,a.kd_kegiatan AS kode2,CONCAT('<b>',a.kd_kegiatan,'</b>') AS kode,'' AS kode1 ,CONCAT('<b>',a.nm_kegiatan,'</b>') AS uraian,
  83. (SELECT SUM(nilai) FROM trdrka WHERE kd_kegiatan = a.kd_kegiatan) AS anggaran,
  84. IFNULL((SELECT SUM(nilai) FROM (SELECT a.tgl_bukti,a.kd_skpd,a.jns_spp,b.kd_kegiatan,b.kd_rek5,b.nilai FROM trhtransout a INNER JOIN
  85. trdtransout b ON a.no_bukti = b.no_bukti)z WHERE z.kd_skpd = a.kd_skpd AND
  86. z.kd_kegiatan = a.kd_kegiatan AND z.jns_spp IN ('1','2','3') AND MONTH(z.tgl_bukti) = '$nbulan'),0) AS real_up_ini,
  87. IFNULL((SELECT SUM(nilai) FROM (SELECT a.tgl_bukti,a.kd_skpd,a.jns_spp,b.kd_kegiatan,b.kd_rek5,b.nilai FROM trhtransout a INNER JOIN
  88. trdtransout b ON a.no_bukti = b.no_bukti)z WHERE z.kd_skpd = a.kd_skpd AND
  89. z.kd_kegiatan = a.kd_kegiatan AND z.jns_spp ='4' AND MONTH(z.tgl_bukti) = '$nbulan'),0) -
  90. IFNULL((SELECT SUM(IFNULL(rupiah,0)) FROM (SELECT a.tgl_sts,a.kd_skpd,a.jns_trans,a.kd_kegiatan,b.kd_rek5,b.rupiah FROM trhkasin_pkd a INNER JOIN
  91. trdkasin_pkd b ON a.no_sts = b.no_sts)t WHERE t.kd_skpd = a.kd_skpd AND
  92. t.kd_kegiatan IN (SELECT kd_kegiatan FROM trskpd WHERE kd_program = a.kd_program) AND t.jns_trans = '51' AND MONTH(t.tgl_sts) = '$nbulan')
  93. ,0) AS real_gaji_ini,
  94. IFNULL((SELECT SUM(nilai) FROM (SELECT a.tgl_bukti,a.kd_skpd,a.jns_spp,b.kd_kegiatan,b.kd_rek5,b.nilai FROM trhtransout a INNER JOIN
  95. trdtransout b ON a.no_bukti = b.no_bukti)z WHERE z.kd_skpd = a.kd_skpd AND
  96. z.kd_kegiatan = a.kd_kegiatan AND z.jns_spp IN('6','5') AND MONTH(z.tgl_bukti) = '$nbulan'),0)-
  97. IFNULL((SELECT SUM(IFNULL(rupiah,0)) FROM (SELECT a.tgl_sts,a.kd_skpd,a.jns_trans,a.kd_kegiatan,b.kd_rek5,b.rupiah FROM trhkasin_pkd a INNER JOIN
  98. trdkasin_pkd b ON a.no_sts = b.no_sts)t WHERE t.kd_skpd = a.kd_skpd AND
  99. t.kd_kegiatan IN (SELECT kd_kegiatan FROM trskpd WHERE kd_program = a.kd_program) AND t.jns_trans = '52' AND MONTH(t.tgl_sts) = '$nbulan')
  100. ,0) AS real_brg_js_ini,
  101. IFNULL((SELECT SUM(nilai) FROM (SELECT a.tgl_bukti,a.kd_skpd,a.jns_spp,b.kd_kegiatan,b.kd_rek5,b.nilai FROM trhtransout a INNER JOIN
  102. trdtransout b ON a.no_bukti = b.no_bukti)z WHERE z.kd_skpd = a.kd_skpd AND
  103. z.kd_kegiatan = a.kd_kegiatan AND z.jns_spp IN ('1','2','3') AND MONTH(z.tgl_bukti) < '$nbulan'),0) AS real_up_ll,
  104. IFNULL((SELECT SUM(nilai) FROM (SELECT a.tgl_bukti,a.kd_skpd,a.jns_spp,b.kd_kegiatan,b.kd_rek5,b.nilai FROM trhtransout a INNER JOIN
  105. trdtransout b ON a.no_bukti = b.no_bukti)z WHERE z.kd_skpd = a.kd_skpd AND
  106. z.kd_kegiatan = a.kd_kegiatan AND z.jns_spp ='4' AND MONTH(z.tgl_bukti) < '$nbulan'),0) -
  107. IFNULL((SELECT SUM(IFNULL(rupiah,0)) FROM (SELECT a.tgl_sts,a.kd_skpd,a.jns_trans,a.kd_kegiatan,b.kd_rek5,b.rupiah FROM trhkasin_pkd a INNER JOIN
  108. trdkasin_pkd b ON a.no_sts = b.no_sts)t WHERE t.kd_skpd = a.kd_skpd AND
  109. t.kd_kegiatan IN (SELECT kd_kegiatan FROM trskpd WHERE kd_program = a.kd_program) AND t.jns_trans = '51' AND MONTH(t.tgl_sts) < '$nbulan')
  110. ,0) AS real_gaji_ll,
  111. IFNULL((SELECT SUM(nilai) FROM (SELECT a.tgl_bukti,a.kd_skpd,a.jns_spp,b.kd_kegiatan,b.kd_rek5,b.nilai FROM trhtransout a INNER JOIN
  112. trdtransout b ON a.no_bukti = b.no_bukti)z WHERE z.kd_skpd = a.kd_skpd AND
  113. z.kd_kegiatan = a.kd_kegiatan AND z.jns_spp IN('6','5') AND MONTH(z.tgl_bukti) < '$nbulan'),0) -
  114. IFNULL((SELECT SUM(IFNULL(rupiah,0)) FROM (SELECT a.tgl_sts,a.kd_skpd,a.jns_trans,a.kd_kegiatan,b.kd_rek5,b.rupiah FROM trhkasin_pkd a INNER JOIN
  115. trdkasin_pkd b ON a.no_sts = b.no_sts)t WHERE t.kd_skpd = a.kd_skpd AND
  116. t.kd_kegiatan IN (SELECT kd_kegiatan FROM trskpd WHERE kd_program = a.kd_program) AND t.jns_trans = '52' AND MONTH(t.tgl_sts) < '$nbulan'),
  117. 0) AS real_brg_js_ll
  118. FROM trskpd a WHERE a.kd_skpd = '$lcskpd' AND a.kd_program = '$lcprogram' AND a.jns_kegiatan <>'4'";
  119.  
  120. $hasil2 = $this->db->query($csql2);
  121. foreach ($hasil2->result() as $row2){
  122. $lckegiatan = $row2->kode2;
  123. $jmspj = $row2->real_gaji_ini + $row2->real_gaji_ll + $row2->real_brg_js_ini + $row2->real_brg_js_ll + $row2->real_up_ini + $row2->real_up_ll;
  124. if(!empty($row2->anggaran)){
  125. $cRet .="<tr>
  126. <td align=\"left\" width=\"11%\" style=\"font-size:8px\">$row2->kode".$this->tukd_model->dotrek($row2->kode1)."</td>
  127. <td valign=\"top\" align=\"left\" width=\"26%\" style=\"font-size:8px\">$row2->uraian</td>";
  128. $cRet .="<td align=\"right\" width=\"6%\" style=\"font-size:8px\"><b>".number_format($row2->anggaran)."&nbsp;</b></td>
  129. <td align=\"right\" width=\"5%\" style=\"font-size:8px\"><b>".number_format($row2->real_gaji_ll)."&nbsp;</b></td>
  130. <td align=\"right\" width=\"5%\" style=\"font-size:8px\"><b>".number_format($row2->real_gaji_ini)."&nbsp;</b></td>
  131. <td align=\"right\" width=\"5%\" style=\"font-size:8px\"><b>".number_format($row2->real_gaji_ini+$row2->real_gaji_ll)."&nbsp;</b></td>
  132. <td align=\"right\" width=\"5%\" style=\"font-size:8px\"><b>".number_format($row2->real_brg_js_ll)."&nbsp;</b></td>
  133. <td align=\"right\" width=\"5%\" style=\"font-size:8px\"><b>".number_format($row2->real_brg_js_ini)."&nbsp;</b></td>
  134. <td align=\"right\" width=\"5%\" style=\"font-size:8px\"><b>".number_format($row2->real_brg_js_ll+$row2->real_brg_js_ini)."&nbsp;</b></td>
  135. <td align=\"right\" width=\"5%\" style=\"font-size:8px\"><b>".number_format($row2->real_up_ll)."&nbsp;</b></td>
  136. <td align=\"right\" width=\"5%\" style=\"font-size:8px\"><b>".number_format($row2->real_up_ini)."&nbsp;</b></td>
  137. <td align=\"right\" width=\"5%\" style=\"font-size:8px\"><b>".number_format($row2->real_up_ini+$row2->real_up_ll)."&nbsp;</b></td>
  138. <td align=\"right\" width=\"6%\" style=\"font-size:8px\"><b>".number_format($jmspj)."&nbsp;</b></td>
  139. <td align=\"right\" width=\"6%\" style=\"font-size:8px\"><b>".number_format($row2->anggaran - $jmspj)."&nbsp;</b></td>";
  140. $cRet .="</tr> ";
  141.  
  142. $csql3 = "SELECT 'S' AS tipe,a.kd_kegiatan AS kode2,CONCAT(a.kd_kegiatan,'.') AS kode,a.kd_rek5 AS kode1,a.nm_rek5 AS uraian,
  143. nilai AS anggaran,
  144. IFNULL((SELECT SUM(nilai) FROM
  145. (SELECT a.tgl_bukti,a.kd_skpd,a.jns_spp,b.kd_kegiatan,b.kd_rek5,b.nilai FROM trhtransout a INNER JOIN
  146. trdtransout b ON a.no_bukti = b.no_bukti)z WHERE z.kd_skpd = a.kd_skpd AND
  147. z.kd_kegiatan = a.kd_kegiatan AND z.jns_spp IN ('1','2','3') AND MONTH(z.tgl_bukti) = '$nbulan' AND z.kd_rek5=a.kd_rek5),0) AS real_up_ini,
  148. IFNULL((SELECT SUM(nilai) FROM
  149. (SELECT a.tgl_bukti,a.kd_skpd,a.jns_spp,b.kd_kegiatan,b.kd_rek5,b.nilai FROM trhtransout a INNER JOIN
  150. trdtransout b ON a.no_bukti = b.no_bukti)z WHERE z.kd_skpd = a.kd_skpd AND
  151. z.kd_kegiatan = a.kd_kegiatan AND z.jns_spp ='4' AND MONTH(z.tgl_bukti) = '$nbulan' AND z.kd_rek5=a.kd_rek5),0)-
  152. IFNULL((SELECT SUM(IFNULL(rupiah,0)) FROM (
  153. SELECT a.tgl_sts,a.kd_skpd,a.jns_trans,a.kd_kegiatan,b.kd_rek5,b.rupiah FROM trhkasin_pkd a INNER JOIN
  154. trdkasin_pkd b ON a.no_sts = b.no_sts)t WHERE t.kd_skpd = a.kd_skpd AND
  155. t.kd_kegiatan = a.kd_kegiatan AND t.jns_trans = '51' AND MONTH(t.tgl_sts) = '$nbulan' AND t.kd_rek5 AND a.kd_rek5)
  156. ,0)AS real_gaji_ini,
  157. IFNULL((SELECT SUM(nilai) FROM
  158. (SELECT a.tgl_bukti,a.kd_skpd,a.jns_spp,b.kd_kegiatan,b.kd_rek5,b.nilai FROM trhtransout a INNER JOIN
  159. trdtransout b ON a.no_bukti = b.no_bukti)z WHERE z.kd_skpd = a.kd_skpd AND
  160. z.kd_kegiatan = a.kd_kegiatan AND z.jns_spp IN('5','6') AND MONTH(z.tgl_bukti) = '$nbulan' AND z.kd_rek5=a.kd_rek5),0) -
  161. IFNULL((SELECT SUM(IFNULL(rupiah,0)) FROM (
  162. SELECT a.tgl_sts,a.kd_skpd,a.jns_trans,a.kd_kegiatan,b.kd_rek5,b.rupiah FROM trhkasin_pkd a INNER JOIN
  163. trdkasin_pkd b ON a.no_sts = b.no_sts)t WHERE t.kd_skpd = a.kd_skpd AND
  164. t.kd_kegiatan = a.kd_kegiatan AND t.jns_trans = '52' AND MONTH(t.tgl_sts) = '$nbulan' AND t.kd_rek5 AND a.kd_rek5)
  165. ,0)AS real_brg_js_ini,
  166. IFNULL((SELECT SUM(nilai) FROM
  167. (SELECT a.tgl_bukti,a.kd_skpd,a.jns_spp,b.kd_kegiatan,b.kd_rek5,b.nilai FROM trhtransout a INNER JOIN
  168. trdtransout b ON a.no_bukti = b.no_bukti)z WHERE z.kd_skpd = a.kd_skpd AND
  169. z.kd_kegiatan = a.kd_kegiatan AND z.jns_spp IN ('1','2','3') AND MONTH(z.tgl_bukti) < '$nbulan' AND z.kd_rek5=a.kd_rek5),0) AS real_up_ll,
  170. IFNULL((SELECT SUM(nilai) FROM
  171. (SELECT a.tgl_bukti,a.kd_skpd,a.jns_spp,b.kd_kegiatan,b.kd_rek5,b.nilai FROM trhtransout a INNER JOIN
  172. trdtransout b ON a.no_bukti = b.no_bukti)z WHERE z.kd_skpd = a.kd_skpd AND
  173. z.kd_kegiatan = a.kd_kegiatan AND z.jns_spp ='4' AND MONTH(z.tgl_bukti) < '$nbulan' AND z.kd_rek5=a.kd_rek5),0) -
  174. IFNULL((SELECT SUM(IFNULL(rupiah,0)) FROM (
  175. SELECT a.tgl_sts,a.kd_skpd,a.jns_trans,a.kd_kegiatan,b.kd_rek5,b.rupiah FROM trhkasin_pkd a INNER JOIN
  176. trdkasin_pkd b ON a.no_sts = b.no_sts)t WHERE t.kd_skpd = a.kd_skpd AND
  177. t.kd_kegiatan = a.kd_kegiatan AND t.jns_trans = '51' AND MONTH(t.tgl_sts) < '$nbulan' AND t.kd_rek5 AND a.kd_rek5)
  178. ,0) AS real_gaji_ll,
  179. IFNULL((SELECT SUM(nilai) FROM
  180. (SELECT a.tgl_bukti,a.kd_skpd,a.jns_spp,b.kd_kegiatan,b.kd_rek5,b.nilai FROM trhtransout a INNER JOIN
  181. trdtransout b ON a.no_bukti = b.no_bukti)z WHERE z.kd_skpd = a.kd_skpd AND
  182. z.kd_kegiatan = a.kd_kegiatan AND z.jns_spp IN('5','6') AND MONTH(z.tgl_bukti) < '$nbulan' AND z.kd_rek5=a.kd_rek5),0) -
  183. IFNULL((SELECT SUM(IFNULL(rupiah,0)) FROM (
  184. SELECT a.tgl_sts,a.kd_skpd,a.jns_trans,a.kd_kegiatan,b.kd_rek5,b.rupiah FROM trhkasin_pkd a INNER JOIN
  185. trdkasin_pkd b ON a.no_sts = b.no_sts)t WHERE t.kd_skpd = a.kd_skpd AND
  186. t.kd_kegiatan = a.kd_kegiatan AND t.jns_trans = '52' AND MONTH(t.tgl_sts) < '$nbulan' AND t.kd_rek5 AND a.kd_rek5)
  187. ,0)AS real_brg_js_ll
  188. FROM trdrka a WHERE a.kd_skpd = '$lcskpd' AND a.kd_kegiatan ='$lckegiatan'";
  189.  
  190. $hasil3 = $this->db->query($csql3);
  191. foreach ($hasil3->result() as $row3){
  192. $totang = $totang + $row3->anggaran;
  193. $totgjini = $totgjini + $row3->real_gaji_ini;
  194. $totgjll = $totgjll + $row3->real_gaji_ll;
  195. $totgjsd = $totgjsd + $row3->real_gaji_ini +$row3->real_gaji_ll ;
  196. $totbrini = $totbrini + $row3->real_brg_js_ini;
  197. $totbrll = $totbrll + $row3->real_brg_js_ll;
  198. $totbrsd = $totbrsd + $row3->real_brg_js_ini + $row3->real_brg_js_ll;
  199. $totupini = $totupini + $row3->real_up_ini;
  200. $totupll = $totupll + $row3->real_up_ll;
  201. $totupsd = $totupsd + $row3->real_up_ini + $row3->real_up_ll;
  202. $jmspj = $row3->real_gaji_ini + $row3->real_gaji_ll + $row3->real_brg_js_ini + $row3->real_brg_js_ll + $row3->real_up_ini + $row3->real_up_ll;
  203. if(!empty($row3->anggaran)){
  204.  
  205. $cRet .="<tr>
  206. <td align=\"left\" width=\"11%\" style=\"font-size:8px\">$row3->kode".$this->tukd_model->dotrek($row3->kode1)."</td>
  207. <td valign=\"top\" align=\"left\" width=\"26%\" style=\"font-size:8px\">$row3->uraian</td>";
  208. $cRet .="<td align=\"right\" width=\"6%\" style=\"font-size:8px\">".number_format($row3->anggaran)."&nbsp;</td>
  209. <td align=\"right\" width=\"5%\" style=\"font-size:8px\">".number_format($row3->real_gaji_ll)."&nbsp;</td>
  210. <td align=\"right\" width=\"5%\" style=\"font-size:8px\">".number_format($row3->real_gaji_ini)."&nbsp;</td>
  211. <td align=\"right\" width=\"5%\" style=\"font-size:8px\">".number_format($row3->real_gaji_ini+$row3->real_gaji_ll)."&nbsp;</td>
  212. <td align=\"right\" width=\"5%\" style=\"font-size:8px\">".number_format($row3->real_brg_js_ll)."&nbsp;</td>
  213. <td align=\"right\" width=\"5%\" style=\"font-size:8px\">".number_format($row3->real_brg_js_ini)."&nbsp;</td>
  214. <td align=\"right\" width=\"5%\" style=\"font-size:8px\">".number_format($row3->real_brg_js_ll+$row3->real_brg_js_ini)."&nbsp;</td>
  215. <td align=\"right\" width=\"5%\" style=\"font-size:8px\">".number_format($row3->real_up_ll)."&nbsp;</td>
  216. <td align=\"right\" width=\"5%\" style=\"font-size:8px\">".number_format($row3->real_up_ini)."&nbsp;</td>
  217. <td align=\"right\" width=\"5%\" style=\"font-size:8px\">".number_format($row3->real_up_ini+$row3->real_up_ll)."&nbsp;</td>
  218. <td align=\"right\" width=\"6%\" style=\"font-size:8px\">".number_format($jmspj)."&nbsp;</td>
  219. <td align=\"right\" width=\"6%\" style=\"font-size:8px\">".number_format($row3->anggaran - $jmspj)."&nbsp;</td>";
  220. $cRet .="</tr> ";
  221.  
  222.  
  223. }
  224. }
  225.  
  226.  
  227. }
  228. }
  229.  
  230. }
  231.  
  232. }
  233.  
  234. $cRet .="
  235. <tr>
  236. <td valign=\"top\" align=\"center\" style=\"font-size:8px\" ><b>&ensp;&ensp;JUMLAH</b></td>
  237. <td align=\"center\" style=\"font-size:8px\"></td>
  238. <td align=\"right\" style=\"font-size:8px\"><b>".number_format($totang)."&nbsp;</b></td>
  239. <td align=\"right\" style=\"font-size:8px\"><b>".number_format($totgjll)."&nbsp;</b></td>
  240. <td align=\"right\" style=\"font-size:8px\"><b>".number_format($totgjini)."&nbsp;</b></td>
  241. <td align=\"right\" style=\"font-size:8px\"><b>".number_format($totgjsd)."&nbsp;</b></td>
  242. <td align=\"right\" style=\"font-size:8px\"><b>".number_format($totbrll)."&nbsp;</b></td>
  243. <td align=\"right\" style=\"font-size:8px\"><b>".number_format($totbrini)."&nbsp;</b></td>
  244. <td align=\"right\" style=\"font-size:8px\"><b>".number_format($totbrsd)."&nbsp;</b></td>
  245. <td align=\"right\" style=\"font-size:8px\"><b>".number_format($totupll)."&nbsp;</b></td>
  246. <td align=\"right\" style=\"font-size:8px\"><b>".number_format($totupini)."&nbsp;</b></td>
  247. <td align=\"right\" style=\"font-size:8px\"><b>".number_format($totupsd)."&nbsp;</b></td>
  248. <td align=\"right\" style=\"font-size:8px\"><b>".number_format($totgjsd+$totbrsd+$totupsd)."&nbsp;</b></td>
  249. <td valign=\"top\" align=\"right\" style=\"font-size:8px\"><b>".number_format($totang-$totgjsd-$totbrsd-$totupsd)."&nbsp;</b></td>
  250. </tr>
  251. <tr>
  252. <td valign=\"top\" align=\"center\" style=\"font-size:8px\" rowspan=\"22\">&ensp;</td>
  253. <td align=\"left\" style=\"font-size:8px\" colspan=\"2\">Penerimaan :</td>
  254. <td align=\"center\" style=\"font-size:8px\"></td>
  255. <td align=\"center\" style=\"font-size:8px\"></td>
  256. <td align=\"center\" style=\"font-size:8px\"></td>
  257. <td align=\"center\" style=\"font-size:8px\"></td>
  258. <td align=\"center\" style=\"font-size:8px\"></td>
  259. <td align=\"center\" style=\"font-size:8px\"></td>
  260. <td align=\"center\" style=\"font-size:8px\"></td>
  261. <td align=\"center\" style=\"font-size:8px\"></td>
  262. <td align=\"center\" style=\"font-size:8px\"></td>
  263. <td align=\"center\" style=\"font-size:8px\"></td>
  264. <td valign=\"top\" align=\"center\" style=\"font-size:10px\" rowspan=\"22\">&nbsp;</td>
  265. </tr>";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!