API tools faq
paste
Advertisement
Guest User

laporan

a guest
Dec 13th, 2019
118
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 44.92 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. $desa = odbc_exec($konek,"SELECT * FROM Ta_Desa");
  3. $tgl = odbc_result($desa,'Tahun');
  4.  
  5. ?>
  6. <!-- Content Wrapper. Contains page content -->
  7. <div class="content-wrapper">
  8. <!-- Content Header (Page header) -->
  9. <section class="content-header">
  10. <h1>
  11. Monitoring Anggaran Desa Hebat
  12. <small><?php echo $tgl ?></small>
  13. </h1>
  14. <ol class="breadcrumb">
  15. <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
  16. </ol>
  17. </section>
  18.  
  19. <!-- Main content -->
  20. <section class="content">
  21. <div class="row">
  22. <div class="col-xs-12">
  23. <div class="box">
  24. <div class="box-header">
  25. <h3 class="box-title">VALIDASI LAPORAN KEUANGAN</h3><!-- <div class="pull-right"> <a href="cetak_laporan.php" target="_blank" class="btn btn-primary"><i class="fa fa-print"> Cek Jurnal</i></a></div> -->
  26. </div>
  27. <!-- /.box-header -->
  28. <div class="box-body">
  29. <form method="POST">
  30. <div class=" col-md-5" >
  31.  
  32. <select name="nagari" id="nagari_pil" class="form-control chosen-select" data-placeholder="Pilih Nagari..." >
  33. <option value="">Klik disini untuk Pilih Nagari </option>
  34. <?php
  35. $desa = odbc_exec($konek,"SELECT * FROM ref_Desa order by Kd_Kec");
  36. while($data=odbc_fetch_row($desa)){
  37. $kd = odbc_result($desa,'Kd_Desa');
  38. $nm = odbc_result($desa,'Nama_Desa');
  39. echo"<option value='$kd'> [$kd] $nm </option>";
  40. }
  41. ?>
  42. </select>
  43. </div>
  44.  
  45. </form>
  46.  
  47. <script type="text/javascript">
  48. $(document).ready(function() {
  49. $("#nagari_pil").change(function() {
  50. $("form").submit();
  51.  
  52. })
  53. })
  54. </script>
  55.  
  56. <?php
  57. if (isset($_POST["nagari"])) {
  58. $id = $_POST['nagari'];
  59. header("Location: ?page=lapkeu&Kd_Desa=$id ");
  60. }
  61.  
  62. if(isset($_GET['Kd_Desa'])){
  63. $kd_desa = htmlspecialchars($_GET['Kd_Desa']);
  64. }
  65. ?>
  66. <?php
  67. if(empty($kd_desa)){}
  68. else{
  69. ?>
  70. <div class="text-right " id="gambar" style="display:none">
  71. <img src="images/oke.png" width="100px" >
  72. </div>
  73.  
  74. <!--<div class="pull-right"> <a href="cetak_pembukuan.php?kd_desa=<?php echo $kd_desa ?>" target="_blank" class="btn btn-primary"><i class="fa fa-print"> Cetak Laporan</i></a></div>-->
  75. <br>
  76.  
  77. <?php
  78. $desa = odbc_exec($konek,"SELECT * FROM Ref_Desa where Kd_Desa='$kd_desa'");
  79. $dd=odbc_fetch_row($desa);
  80.  
  81. ?>
  82.  
  83. <div class="col-md-12">
  84. <br><br>
  85.  
  86.  
  87. <?php
  88. #Buku Pembantu Bank (BPB)
  89. #DEBET
  90. #Mutasi
  91. $mutasi = odbc_exec($konek,"SELECT sum(Nilai) as debet FROM Ta_Mutasi where Kd_Mutasi='2' and Kd_Desa='$kd_desa'");
  92. $cmutasi = odbc_fetch_row($mutasi);
  93. $mutasi1 = odbc_exec($konek,"SELECT sum(Nilai) as debet1 FROM Ta_Mutasi where Kd_Mutasi='3' and Kd_Desa='$kd_desa' and year(Tgl_Bukti)<= Tahun");
  94. $cmutasi1 = odbc_fetch_row($mutasi1);
  95. $tbp = odbc_exec($konek,"SELECT sum(Jumlah) as pjumlah FROM Ta_TBP where KdBayar='2' and Kd_Desa='$kd_desa'");
  96. $ctbp = odbc_fetch_row($tbp);
  97. $sts = odbc_exec($konek,"SELECT sum(Jumlah) as jumlah1 FROM Ta_STS where Kd_Desa='$kd_desa'");
  98. $csts = odbc_fetch_row($sts);
  99.  
  100. #saldo
  101. $sa = odbc_exec($konek,"SELECT * FROM Ta_SaldoAwal where Kd_Rincian='1.1.1.02.' and Kd_Desa='$kd_desa'");
  102. $csa = odbc_fetch_row($sa);
  103. $sad = $csa["Debet"] + $csa["Kredit"];
  104.  
  105. $deb = $cmutasi['debet'] + $cmutasi1['debet1'] + $ctbp['jumlah'] + $csts['jumlah1'] + $sad;
  106.  
  107. #KREDIT
  108. #Mutasi
  109. $mutasi3 = odbc_exec($konek,"SELECT sum(Nilai) as kd FROM Ta_Mutasi where Kd_Mutasi='1' and Kd_Desa='$kd_desa'");
  110. $cmutasi3 = odbc_fetch_row($mutasi3);
  111. $mutasi4 = odbc_exec($konek,"SELECT sum(Nilai) as kd4 FROM Ta_Mutasi where Kd_Mutasi='4' and Kd_Desa='$kd_desa' and year(Tgl_Bukti)<= Tahun");
  112. $cmutasi4 = odbc_fetch_row($mutasi4);
  113. $kre = $cmutasi3['kd'] + $cmutasi4['kd4'];
  114.  
  115. #BPB
  116. $bank = $deb - $kre ;
  117. #--------------------------------------------------------------------------------------------------------------------------------------#
  118.  
  119. #Buku Pembantu Tunai (BPT)
  120. #DEBIT
  121. #saldok
  122. $sak = odbc_exec($konek,"SELECT * FROM Ta_SaldoAwal where Kd_Rincian='1.1.1.01.' and Kd_Desa='$kd_desa'");
  123. $csak = odbc_fetch_row($sak);
  124. $sak = $csak["Debet"] + $csak["Kredit"];
  125. #Sppj Pot
  126. $spjpot = odbc_exec($konek,"SELECT sum(Nilai) as debet FROM Ta_SPJPot where Kd_Desa='$kd_desa'");
  127. $dspjpot = odbc_fetch_row($spjpot);
  128. #Sppj Pot
  129. $spppot = odbc_exec($konek,"SELECT sum(Potongan) as debet FROM Ta_Pencairan where Kd_Desa='$kd_desa'");
  130. $dspppot = odbc_fetch_row($spppot);
  131. $tbp1 = odbc_exec($konek,"SELECT sum(Jumlah) as jumlah2 FROM Ta_TBP where KdBayar='1' and Kd_Desa='$kd_desa'");
  132. $ctbp1 = odbc_fetch_row($tbp1);
  133. $pnj = odbc_exec($konek,"SELECT sum(Nilai) as ppnj FROM Ta_SPJSisa where Kd_Desa='$kd_desa'");
  134. $cpnj = odbc_fetch_row($pnj);
  135.  
  136. $td = $cmutasi3['kd'] + $ctbp1['jumlah2'] + $dspjpot['debet'] + $dspppot['debet'] + $cpnj['ppnj'] + $sak;
  137.  
  138. #KREDIT
  139.  
  140. $pcr = odbc_exec($konek,"SELECT sum(tp.Jumlah) as pjmlh FROM Ta_Pencairan tp where tp.Kd_Desa='$kd_desa'");
  141. $cpcr = odbc_fetch_row($pcr);
  142.  
  143. $pajak = odbc_exec($konek,"SELECT sum(Jumlah) as jml FROM Ta_Pajak where Kd_Desa='$kd_desa' ");
  144. $dpajak = odbc_fetch_row($pajak);
  145.  
  146. $tk = $cmutasi["debet"] + $csts['jumlah1'] + $dpajak['jml'] + $cpcr['pjmlh'];
  147. //BPT
  148. $tunai = $td - $tk ;
  149.  
  150. #--------------------------------------------------------------------------------------------------------------------------------------#
  151.  
  152. #Saldo Pajak
  153. #DEBET
  154. $dp = $dspjpot["debet"] + $dspppot["debet"];
  155. #KREDIT
  156. $kp = $dpajak["jml"];
  157. $pjk = $dp -$kp ;
  158. #--------------------------------------------------------------------------------------------------------------------------------------#
  159.  
  160. #Buku Kas Umum (BKU)
  161. $bku = $bank + $tunai;
  162. #--------------------------------------------------------------------------------------------------------------------------------------#
  163. #SALDO DILUAR PAJAK
  164. $sldpjk = $bku - $pjk ;
  165. #--------------------------------------------------------------------------------------------------------------------------------------#
  166.  
  167. #Saldo Pembukuan
  168. #Debet
  169. $atbp = odbc_exec($konek,"SELECT sum(Nilai) as jtbp FROM Ta_TBPRinci where mid([Kd_Rincian],1,1)='4' and Kd_Desa='$kd_desa' ");
  170. $catbp = odbc_fetch_row($atbp);
  171. $ju = odbc_exec($konek,"SELECT sum(tjur.Kredit) as jud FROM Ta_JurnalUmumRinci tjur LEFT JOIN Ta_JurnalUmum tj ON tjur.NoBukti=tj.NoBukti
  172. where tjur.Kd_Rincian='4.3.6.01.' and tjur.Kd_Desa='$kd_desa' and tj.Posted='1'");
  173. $cju = odbc_fetch_row($ju);
  174. $juuu = odbc_exec($konek,"SELECT sum(tjur.Kredit) as juud FROM Ta_JurnalUmumRinci tjur LEFT JOIN Ta_JurnalUmum tj ON tjur.NoBukti=tj.NoBukti
  175. where tjur.Kd_Rincian='6.1.1.01.' and tjur.Kd_Desa='$kd_desa' and tj.Posted='1'");
  176. $cjuuu = odbc_fetch_row($juuu);
  177. $tbrpn = odbc_exec($konek,"SELECT sum(Nilai) as totpendsilpatbp FROM Ta_TBPRinci where Kd_Rincian='6.1.1.01.' and kd_desa='$kd_desa'");
  178. $ctbrpn = odbc_fetch_row($tbrpn);
  179.  
  180. #Kredit
  181. $spp = odbc_exec($konek,"SELECT sum(ddtp.Nilai) as jspp FROM Ta_SPPBukti ddtp LEFT JOIN Ta_Pencairan ddts ON
  182. ddtp.No_SPP=ddts.No_SPP where ddtp.Kd_Desa='$kd_desa' and year(ddts.Tgl_Cek) <= ddtp.Tahun ");
  183. $cspp = odbc_fetch_row($spp);
  184.  
  185. $spj = odbc_exec($konek,"SELECT sum(nilai) as jspj FROM Ta_SPJBukti where Kd_Desa='$kd_desa' and year(Tgl_Bukti)<= Tahun");
  186. $cspj = odbc_fetch_row($spj);
  187.  
  188. $mutasi5 = odbc_exec($konek,"SELECT sum(Nilai) as kd5 FROM Ta_Mutasi where mid(kd_rincian,1,1)='5' and Kd_Desa='$kd_desa' and year(Tgl_Bukti)='$tgl'");
  189. $cmutasi5 = odbc_fetch_row($mutasi5);
  190.  
  191. $jurke = odbc_exec($konek,"SELECT sum(debet) as totjurke FROM Ta_JurnalUmumRinci where mid([Kd_Rincian],1,1)='5' and Kd_Desa='$kd_desa'");
  192. $cjurke = odbc_fetch_row($jurke);
  193.  
  194. $tbpr5 = odbc_exec($konek,"SELECT sum(Nilai) as tottbpp FROM Ta_TBPRinci where mid([Kd_Rincian],1,1)='5' and Kd_Desa='$kd_desa'");
  195. $ctbpr5 = odbc_fetch_row($tbpr5);
  196.  
  197.  
  198.  
  199. $pd = $catbp["jtbp"] + $cju["jud"] + $cjuuu["juud"] + $cmutasi1['debet1'] + $ctbpr5["tottbpp"] + $ctbrpn["totpendsilpatbp"];
  200. $pk = $cspj["jspj"] + $cspp["jspp"] + $cmutasi5['kd5'] + $cjurke["totjurke"] ;
  201. $pembukuan = $pd - $pk;
  202.  
  203. #--------------------------------------------------------------------------------------------------------------------------------------#
  204.  
  205.  
  206. #Sisa Panjar
  207. #SPP
  208. $sppS = odbc_exec($konek,"SELECT sum(Ta_Pencairan.Jumlah) as jjl FROM Ta_Pencairan, Ta_SPP where Ta_Pencairan.No_SPP=Ta_SPP.No_SPP and Ta_Spp.Jn_SPP='UM' and Ta_Pencairan.Kd_Desa='$kd_desa' ");
  209. $csppS = odbc_fetch_row($sppS);
  210. #SPJ !tahun
  211. $sisaspj = odbc_exec($konek,"SELECT sum(Jumlah) as sisaspj FROM Ta_SPJ where Kd_Desa='$kd_desa' and year(Tgl_SPJ)<>'$tgl'");
  212. $csispj = odbc_fetch_row($sisaspj);
  213.  
  214. #SPJSISA
  215. $spjs = odbc_exec($konek,"SELECT SUM(Nilai) as sisa FROM Ta_SPJSisa where Kd_Desa='$kd_desa' and year(Tgl_Bukti)='$tgl'");
  216. $cspjs = odbc_fetch_row($spjs);
  217.  
  218. $sisas = $cspj["jspj"] ;
  219. $ksh = $csppS["jjl"] - $cspj["jspj"] - $csispj["sisaspj"] ;
  220. $sisa = $ksh - $cspjs['sisa'] ;
  221. #--------------------------------------------------------------------------------------------------------------------------------------#
  222.  
  223. #data lainnya ( Tanggal Bukti Tidak Sesuai dengan Tahun Anggaran )
  224. $dtl = odbc_exec($konek,"Select sum(table1.Nilai) as t1jumlah, sum(table2.Jumlah) as t2jumlah, sum(table3.Jumlah) as t3jumlah, sum(table4.Jumlah) as t4jumlah,
  225. sum(table5.Jumlah) as t5jumlah, sum(table6.Nilai) as t6jumlah, sum(table7.Nilai) as t7jumlah
  226. , sum(table9.Debet) as t9jumlah, sum(table10.Jumlah) as t10jumlah, sum(table11.Jumlah) as t11jumlah FROM
  227. (
  228. Select * FROM Ta_Mutasi tm where Kd_Desa='$kd_desa' and year(tm.Tgl_Bukti)!='$tgl') as table1 full outer join
  229. (
  230. Select * FROM Ta_Pencairan tp where Kd_Desa='$kd_desa' and year(tp.Tgl_Cek)!='$tgl' ) as table2 ON table1.Kd_Desa=table2.Kd_Desa Full outer join
  231. (
  232. Select * FROM Ta_STS ts where Kd_Desa='$kd_desa' and year(ts.Tgl_Bukti)!='$tgl' ) as table3 ON table1.Kd_Desa=table3.Kd_Desa FULL Outer Join
  233. (
  234. Select * FROM Ta_Pajak tpa Where Kd_Desa='$kd_desa' and year(tpa.Tgl_SSP)!='$tgl' ) as table4 ON table1.Kd_Desa=table4.Kd_Desa Full Outer Join
  235. (
  236. Select * FROM Ta_TBP tt Where Kd_Desa='$kd_desa' and year(tt.Tgl_Bukti)!='$tgl' ) as table5 ON table1.Kd_Desa=table5.Kd_Desa Full Outer Join
  237. (
  238. Select * FROM Ta_SPJBukti tspj Where Kd_Desa='$kd_desa' and year(tspj.Tgl_Bukti)!='$tgl' ) as table6 ON table1.Kd_Desa=table6.Kd_Desa Full Outer Join
  239. (
  240. Select * FROM Ta_SPPBukti tspp Where Kd_Desa='$kd_desa' and year(tspp.Tgl_Bukti)!='$tgl' ) as table7 ON table1.Kd_Desa=table7.Kd_Desa Full Outer Join
  241.  
  242. (
  243. Select * FROM Ta_SaldoAwal tsa Where Kd_Desa='$kd_desa' and year(tsa.Tgl_Bukti)!='$tgl' ) as table9 ON table1.Kd_Desa=table9.Kd_Desa Full Outer Join
  244. (
  245. Select * FROM Ta_SPJ tps Where Kd_Desa='$kd_desa' and year(tps.Tgl_SPJ)!='$tgl' ) as table10 ON table1.Kd_Desa=table10.Kd_Desa Full Outer Join
  246. (
  247. Select * FROM Ta_SPP tpp Where Kd_Desa='$kd_desa' and year(tpp.Tgl_SPP)!='$tgl' ) as table11 ON table1.Kd_Desa=table11.Kd_Desa");
  248. $cdtlop = odbc_fetch_row($dtl);
  249. $jumlahsisadata = $cdtlop["t1jumlah"] + $cdtlop["t2jumlah"] + $cdtlop["t3jumlah"] + $cdtlop["t4jumlah"] + $cdtlop["t5jumlah"] + $cdtlop["t6jumlah"] + $cdtlop["t7jumlah"] + $cdtlop["t9jumlah"] + $cdtlop["t10jumlah"] + $cdtlop["t11jumlah"];
  250. #--------------------------------------------------------------------------------------------------------------------------------------#
  251. #Saldo LRA
  252. $lra = $sldpjk + $sisa;
  253.  
  254. #selisih LRA dengan Pembukuan
  255. //$selisih = $pembukuan - $sldpjk ;
  256. $hasil_cek2=explode("|",($lra."|".$pembukuan));
  257. $selisih=($hasil_cek2[0]-$hasil_cek2[1]);
  258.  
  259. //$selisih = $lra - $pembukuan;
  260.  
  261. ?>
  262.  
  263.  
  264.  
  265. <?php
  266. echo "<center>";
  267. echo "[" . $dd["Kd_Desa"] . "]" . $dd["Nama_Desa"];;
  268. echo "<br/>";
  269. echo "Tanggal Divalidasi : " . date("d/m/Y");;
  270. echo "</center>";
  271. ?>
  272. <br>
  273.  
  274.  
  275.  
  276. <table class="table" >
  277. <tr style="border-top:2px solid black; border-bottom:2px solid black;">
  278. <th style="width:10px; border-left:2px solid black;">A.</th>
  279. <th colspan="2">Saldo Buku Kas Umum (BKU) </th>
  280. <th style="border-right:2px solid black;" colspan="6">Rp. <?php echo number_format($bku,2,",","."); ?></th>
  281. </tr>
  282. <tr>
  283. <td style="border-left:2px solid black;">&nbsp; </td>
  284. <td>1. Saldo Buku Pembantu Bank</td>
  285. <td style="border-right:2px solid black;" colspan="6">: Rp. <?php echo number_format($bank,2,",","."); ?> </td>
  286. </tr>
  287. <tr>
  288. <td style="border-left:2px solid black;">&nbsp; </td>
  289. <td>2. Saldo Buku Pembantu Tunai</td>
  290. <td style="border-right:2px solid black;" colspan="6">: Rp. <?php echo number_format($tunai,2,",","."); ?> </td>
  291. </tr>
  292.  
  293. <tr style="border-top:2px solid black; border-bottom:2px solid black;">
  294. <th style="border-left:2px solid black;">B. </th>
  295. <th colspan="2">Saldo Pajak</th>
  296. <th style="width:15%"> Rp. <?php echo number_format($pjk,2,",","."); ?> </th>
  297. <th style="border-right:2px solid black;" colspan="5">&nbsp;</th>
  298. </tr>
  299.  
  300. <tr style="border-top:2px solid black; border-bottom:2px solid black;">
  301. <th style="border-left:2px solid black;">C. </th>
  302. <th colspan="3">Saldo Diluar Pajak (A-B)</th>
  303. <th style="border-right:2px solid black;" colspan="5"> Rp. <?php echo number_format($sldpjk,2,",","."); ?></th>
  304. </tr>
  305.  
  306. <tr style="border-top:2px solid black; border-bottom:2px solid black;">
  307. <th style="border-left:2px solid black;">D. </th>
  308. <th colspan="3">Sisa Panjar</th>
  309. <th style="border-right:2px solid black;" colspan="5">Rp. <?php echo number_format($sisa,2,",","."); ?></th>
  310. </tr>
  311.  
  312. <tr style="border-top:2px solid black; border-bottom:2px solid black;">
  313. <th style="border-left:2px solid black;">E. </th>
  314. <th colspan="4">Saldo LRA (C+D)</th>
  315. <th style="border-right:2px solid black;" colspan="4">Rp. <?php echo number_format($lra,2,",","."); ?></th>
  316. </tr>
  317.  
  318. <tr style="border-top:2px solid black; border-bottom:2px solid black;">
  319. <th style="border-left:2px solid black;">F. </th>
  320. <th colspan="4">Saldo Pembukuan</th>
  321. <th style="border-right:2px solid black;"colspan="4">Rp. <?php echo number_format($pembukuan,2,",",".") ?></th>
  322. </tr>
  323. <tr>
  324. <td style="border-left:2px solid black;" colspan="2">&nbsp; </td>
  325. <th colspan="3">Selisih Saldo LRA dengan Pembukuan :</th>
  326. <th style="border-right:2px solid black;" colspan="3">Rp. <?php echo number_format($selisih,2,",",".") ?></th>
  327. </tr>
  328.  
  329. <!-- keterrangan dari bku -->
  330.  
  331. <tr class='ketbku'>
  332. <td style="border-left:2px solid black;">&nbsp;</td>
  333. <td >Keterangan </td>
  334. <th colspan="6" style="border-right:2px solid black;" >&#9830; Saldo Buku Kas Umum Minus</th>
  335. </tr>
  336. <tr class='ketbank'>
  337. <td style="border-left:2px solid black;">&nbsp;</td>
  338. <td >&nbsp; </td>
  339. <th colspan="6" style="border-right:2px solid black;">&#9830; Saldo Buku Pembantu Bank Minus</th>
  340. </tr>
  341. <tr class='ketbank'>
  342. <th style="border-left:2px solid black;" > &nbsp;</th>
  343. <td >Solusi </td>
  344. <td colspan="6" style="border-right:2px solid black;">: <font color="red">Pastikan Pengimputan Transaksi Bank Sudah Benar Sesuai dengan Apa yang Tertulis Pada Buku Rekening Bank.</font></td>
  345. <tr class='kettunai'>
  346. <td style="border-left:2px solid black;">&nbsp;</td>
  347. <td >&nbsp; </td>
  348. <th colspan="6" style="border-right:2px solid black;">&#9830; Saldo Buku Pembantu Tunai Minus</th>
  349. </tr>
  350. <tr class='kettunai'>
  351. <th style="border-left:2px solid black;" > &nbsp;</th>
  352. <td >&nbsp; </td>
  353. <td colspan="6" style="border-right:2px solid black;">: <font color="red">Pastikan Nilai Pencairan SPP Tidak Melebihi Jumlah Penarikan Pada Menu Mutasi Kas Pengambilan.</font></td>
  354. </tr>
  355. <tr class='kettunai'>
  356. <th style="border-left:2px solid black;" > &nbsp;</th>
  357. <td >Solusi </td>
  358. <td colspan="6" style="border-right:2px solid black;">: <font color="red">Pastikan Pengimputan Transaksi Bank Sudah Benar Sesuai dengan Apa yang Tertulis Pada Buku Rekening Bank.</font></td>
  359. </tr>
  360.  
  361.  
  362.  
  363. <!--<tr class="sisapanjar">
  364. <td style="border-left:2px solid black;">&nbsp; </td>
  365. <th >Sisa Panjar</th>
  366. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;">SPP</th>
  367. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;">Pencairan</th>
  368. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;">SPJ</th>
  369. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;">Sisa Panjar</th>
  370. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;">Pengembalian Panjar</th>
  371. <th style="border-left:1px solid black; border-right:2px solid black; border-top:1px solid black; border-bottom:1px solid black;">Panjar Yanag Belum Di Setor</th>
  372. </tr>
  373. <tr class='sisapanjar'>
  374. <td style="border-left:2px solid black;">&nbsp; </td>
  375. <th >&nbsp;</th>
  376. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($csppS["jjl"],2,",",".");?></th>
  377. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($csppS["jjl"],2,",","."); ?></th>
  378. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($sisas,2,",",".");?></th>
  379. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($ksh,2,",","."); ?></th>
  380. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($cspjs['sisa'],2,",","."); ?></th>
  381. <th style="border-left:1px solid black; border-right:2px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($sisa,2,",","."); ?></th>
  382. </tr>-->
  383.  
  384. <tr class='sisapanjar1'>
  385. <td style="border-left:2px solid black;">&nbsp;</td>
  386. <td >Penyebab </td>
  387. <th colspan="3">&&#9830; Tanggal Bukti Tidak Sesuai dengan Tahun Anggaran</th>
  388. <th colspan="2"><a href="?page=table&Kd_Desa=<?php echo $kd_desa ?>"><i>Lihat Detail .....</i></a> </th>
  389. <th style="border-right:2px solid black;" >: <?php echo number_format($jumlahsisadata,2,",",".") ?> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</th>
  390. </tr>
  391.  
  392. <?php
  393.  
  394. $ppsp = odbc_exec($konek,"Select ts.Jumlah as jp, tj.Jumlah as js, ts.no_spp as nospp From ta_SPP ts left join ta_SPJ tj on ts.no_spp=tj.no_spp where ts.kd_desa='$kd_desa' order by ts.no_spp ASC ");
  395. $no=1;
  396. while($psp = odbc_fetch_row($ppsp)){
  397.  
  398. $sspp = $psp['jp'] - $psp['js'];
  399. $nosppp = $psp['nospp'];
  400.  
  401. $spjs = odbc_exec($konek,"select Nilai as nilai from ta_SPJSisa where kd_desa='$kd_desa' and no_spp='$nosppp' and Nilai!='$sspp' ");
  402. while($cspjs = odbc_fetch_row($spjs)){
  403.  
  404. $slsh = $sspp - $cspjs['nilai'];
  405. $totslh += $slsh;
  406.  
  407. }
  408. }
  409. ?>
  410.  
  411. <tr class='sisapanjar2'>
  412. <td style="border-left:2px solid black;" colspan="2">&nbsp; </td>
  413. <th >&#9830; Pengembalian Sisa Panjar Tidak Sama dengan Sisa Panjar</th>
  414. <th colspan="2">&nbsp;</th>
  415. <th colspan="2"><a href="?page=pembanding&Kd_Desa=<?php echo $kd_desa ?>"><i>Lihat Detail .....</i></a> </th>
  416. <th style="border-right:2px solid black;" >: <?php echo number_format($totslh,2,",",".") ?> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</th>
  417. </tr>
  418.  
  419. <tr class='sisapanjar3'>
  420. <td style="border-left:2px solid black;" colspan="2">&nbsp; </td>
  421. <th >&#9830; Data Sampah Sisa Panjar</th>
  422. <th colspan="4">&nbsp;</th>
  423. <th style=" border-right:2px solid black;" >&nbsp;</th>
  424. </tr>
  425.  
  426. <tr class='sisapanjar1'>
  427. <th style="border-left:2px solid black;" > &nbsp;</th>
  428. <td >Solusi </td>
  429. <td colspan="5">: &#9830; <font color="red">Lihat Lagi Data Yang Salah dengan Klik <i>Lihat Detail</i>, Perbaiki Tanggalnya Sesuai dengan Tahun Anggaran.</font></td>
  430. <th style=" border-right:2px solid black;" >&nbsp;</th>
  431. </tr>
  432. <tr class='sisapanjar2'>
  433. <th style="border-left:2px solid black;" > &nbsp;</th>
  434. <td >&nbsp; </td>
  435. <td colspan="5">: &#9830; <font color="red">Perbaiki Kembali Pengembalian Sisa Panjar</font></td>
  436. <th style=" border-right:2px solid black;" >&nbsp;</th>
  437. </tr>
  438. <tr style="border-bottom:2px solid black; border-left:2px solid black;" class='sisapanjar3'>
  439. <th style=" border-left:2px solid black;" > &nbsp;</th>
  440. <td >&nbsp; </td>
  441. <td colspan="5">: &#9830; <font color="red">Hapus Data Sampah Sisa Panjar</font> <a href="?page=daftarsampah"><i> Klik Disini </i></a></td>
  442. <th style=" border-right:2px solid black;" >&nbsp;</th>
  443. </tr>
  444.  
  445.  
  446. <!-- Silpa -->
  447. <tr class="silpa">
  448. <td style="border-left:2px solid black;">&nbsp; </td>
  449. <th >&nbsp;</th>
  450. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;" colspan="2">Pembiayaan 1 (PMB 1)</th>
  451. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;">Jurnal (JNL)</th>
  452. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;">Selisih PMB1 - JNL</th>
  453. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;">Saldo Awal (SA)</th>
  454. <th style="border-left:1px solid black; border-right:2px solid black; border-top:1px solid black; border-bottom:1px solid black;">Selisih PMB 1 - SA</th>
  455. </tr>
  456. <?php
  457. #saldo awal untuk silpa
  458. $sas = odbc_exec($konek,"SELECT sum(Kredit) as jkrsas FROM Ta_SaldoAwal where (Kd_Rincian='3.1.2.01.' and Kd_Desa='$kd_desa') OR Kd_Rincian='3.1.1.01.' and Kd_Desa='$kd_desa'");
  459. $csas = odbc_fetch_row($sas);
  460. $jkrsas = odbc_result($sas,"jkrsas");
  461. #Pembiayaan 1
  462. $pba = odbc_exec($konek,"SELECT sum(Anggaran) as jpba FROM Ta_RABRinci where Kd_Rincian='6.1.1.01.' AND Kd_Desa='$kd_desa'");
  463. $cpba = odbc_fetch_row($pba);
  464. $jpba = odbc_result($pba,'jpba');
  465. #Jurna Umum
  466. $jsas = odbc_exec($konek,"SELECT sum(jur.Kredit) as jjsas FROM Ta_JurnalUmumRinci jur LEFT JOIN Ta_JurnalUmum ju ON
  467. jur.NoBukti=ju.NoBukti
  468. where jur.Kd_Rincian='6.1.1.01.' AND jur.Kd_Desa='$kd_desa' AND year(ju.Tanggal)='$tgl' AND ju.Posted='1'" );
  469. $cjsas = odbc_fetch_row($jsas);
  470. $jjsas = odbc_result($jsas,'jjsas');
  471.  
  472. #Selisih Saldo Awal dengan Pembiayaan
  473. //$ssap =$jpba - $jkrsas ;
  474. $hasil_cba=explode("|",($jpba."|".$jkrsas)); // explode untuk memecah menjadi string
  475. $ssap=($hasil_cba[0]-$hasil_cba[1]);
  476. #Selisih Pembiayaan dengan Jurnal
  477. $hasil_cek=explode("|",($jpba."|".$jjsas));
  478. $sspj=($hasil_cek[0]-$hasil_cek[1]);
  479. ?>
  480. <tr class="silpa">
  481. <td style="border-left:2px solid black;">&nbsp; </td>
  482. <th >Silpa </th>
  483. <th colspan="2" style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($jpba,2,",","."); ?></th>
  484. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($jjsas,2,",","."); ?></th>
  485. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($sspj,2,",","."); ?></th>
  486. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($jkrsas,2,",","."); ?></th>
  487. <th style="border-left:1px solid black; border-right:2px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($ssap,2,",","."); ?></th>
  488. </tr>
  489.  
  490. <?php
  491.  
  492. #pembanding pembiayaan 1 dengan jurnal
  493. $dsa = odbc_exec($konek,"select * from
  494. (select tj.SumberDana, sum(tj.Kredit) as jKredit
  495. from Ta_JurnalUmumRinci tj LEFT JOIN Ta_JurnalUmum tu ON tj.NoBukti=tu.NoBukti where tj.Kd_Desa='$kd_desa.' and tu.Tanggal='2019' and tu.Posted='1'
  496. and tj.Kd_Rincian='6.1.1.01.' group by tj.SumberDana) as table1,
  497. (select tr.SumberDana, sum(tr.Anggaran) as jAngg
  498. from Ta_RABRinci tr where tr.Kd_Desa='$kd_desa' and tr.Kd_Rincian='6.1.1.01.' group by tr.SumberDana) as table2
  499. where table1.Sumberdana=table2.SumberDana ");
  500. $no=1;
  501. while($data=odbc_fetch_row($dsa)){
  502. $spjn = odbc_result($dsa,'jAngg')-odbc_result($dsa,'jKredit');
  503.  
  504.  
  505. ?>
  506. <tr class="silpa">
  507. <td style="border-left:2px solid black;">&nbsp; </td>
  508. <th >&nbsp;</th>
  509. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;" width="100px"><?php echo $data['Kd_Rincian']; echo $data['SumberDana'];?> </th>
  510. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;">: <?php echo number_format($data['jAngg'],2,",","."); ?></th>
  511. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($data['jKredit'],2,",","."); ?></th>
  512. <th style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($spjn,2,",",".") ?></th>
  513. <th style="border-top:1px solid black; border-bottom:1px solid black;">&nbsp;</th>
  514. <th style="border-right:2px solid black; border-top:1px solid black; border-bottom:1px solid black;">&nbsp;</th>
  515. </tr>
  516. <?php } ?>
  517.  
  518.  
  519. <tr style=" border-left:2px solid black;" class="silpa1 silpa">
  520. <td>&nbsp;</td>
  521. <th>Penyebab </th>
  522. <td colspan='7' style=" border-right:2px solid black;">: &#9830; Silpa Belum Jurnal atau Jurnal Silpa Belum Diposting, atau</td>
  523. </tr>
  524. <tr style=" border-left:2px solid black;" class="silpa1 silpa">
  525. <td>&nbsp;</td>
  526. <th>&nbsp; </th>
  527. <td colspan='7' style=" border-right:2px solid black;">&nbsp; &#9830; Tanggal Jurnal Tidak Sama Dengan Tahun Anggaran, atau</td>
  528. </tr>
  529. <tr style=" border-left:2px solid black;" class="silpa2 silpa">
  530. <td>&nbsp;</td>
  531. <th>&nbsp; </th>
  532. <td colspan='7' style=" border-right:2px solid black;">&nbsp; &#9830; Silpa Jurnal Tidak Sama dengan Pembiayaan 1, atau</td>
  533. </tr>
  534. <tr style=" border-left:2px solid black;" class="silpa3 silpa">
  535. <td>&nbsp;</td>
  536. <th>&nbsp; </th>
  537. <td colspan='7' style=" border-right:2px solid black;">&nbsp; &#9830; Silpa Saldo Awal Tidak Sama dengan Pembiayaan 1</td>
  538. </tr>
  539.  
  540.  
  541. <tr style=" border-left:2px solid black;" class="silpa">
  542. <td>&nbsp;</td>
  543. <th>Solusi </th>
  544. <td colspan='7' style=" border-right:2px solid black;">: <font color="red" > Silpa Harus Di Buktikan atau Di Catat Sebagai Saldo Awal Bukan Sebagai Penerimaan Desa</font> </td>
  545. </tr>
  546. <tr style="border-left:2px solid black;"class="silpa2 silpa">
  547. <td>&nbsp;</td>
  548. <th>&nbsp; </th>
  549. <td colspan='7' style=" border-right:2px solid black;">: <font color="red" > Pastikan Silpa Pada Pembiayaan 1 Harus Sama dengan Saldo Awal dan Jurnal </font></td>
  550. </tr>
  551. <tr style="border-left:2px solid black;"class="silpa3 silpa">
  552. <td>&nbsp;</td>
  553. <th>&nbsp; </th>
  554. <td colspan='7' style=" border-right:2px solid black;">: <font color="red" > Pastikan Silpa Pada Pembiayaan 1 Harus Sama dengan Saldo Awal </font></td>
  555. </tr>
  556.  
  557. <tr style="border-bottom:2px solid black; border-left:2px solid black;"class="silpa1 silpa">
  558. <td>&nbsp;</td>
  559. <th>&nbsp; </th>
  560. <td colspan='7' style=" border-right:2px solid black;">: <font color="red" > Pastikan Jurnal Telah di Posing dan Tanggal Jurnal Harus Sama dengan Tahun Anggaran Sekarang </font></td>
  561. </tr>
  562.  
  563. <!-- Pajak -->
  564.  
  565. <tr class="pajak">
  566. <td style="border-left:2px solid black;">&nbsp; </td>
  567. <th >Pajak Bank</th>
  568. <th colspan="2" style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;">Pajak Bank (PB)</th>
  569. <th colspan='2' style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;" >Jurnal (JN)</th>
  570. <th colspan='2' style="border-left:1px solid black; border-right:2px solid black; border-top:1px solid black; border-bottom:1px solid black;" >Selisih PB-JN</th>
  571. </tr>
  572. <?php
  573.  
  574. #pembanding pajak dengan jurnal
  575. $mjp = odbc_exec($konek,"SELECT sum(tm.Nilai) as jnilai FROM Ta_Mutasi tm where tm.Kd_Rincian='7.1.1.05.' AND tm.Kd_Desa='$kd_desa'");
  576. $dmjp=odbc_fetch_row($mjp);
  577. $mjjj = odbc_exec($konek,"SELECT tj.Kredit FROM Ta_JurnalUmumRinci tj where tj.Kd_Rincian='7.1.1.05.' AND tj.Kd_Desa='$kd_desa'");
  578. $no=1;
  579. ;
  580. $jnilai = odbc_result($mjp,'jnilai');
  581. $jkred = odbc_exec($mjjj,'Kredit');
  582. $sjnpb = odbc_result($mjp,'jnilai') - odbc_result($mjjj,'Kredit');
  583. ?>
  584.  
  585. <tr class="pajak">
  586. <td style="border-left:2px solid black;">&nbsp; </td>
  587. <td >&nbsp;</td>
  588. <td colspan="2" style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($jnilai,2,",","."); ?></td>
  589. <td colspan='2' style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($jkred,2,",","."); ?></td>
  590. <td colspan='2' style="border-left:1px solid black; border-right:2px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($sjnpb,2,",","."); ?></td>
  591. </tr>
  592.  
  593. <tr style=" border-left:2px solid black;" class="pajak">
  594. <td>&nbsp;</td>
  595. <th>Penyebab </th>
  596. <td colspan='7' style=" border-right:2px solid black;">: &#9830; Mutasi Kas Pajak Bank Belum di Jurnal, atau</td>
  597. </tr>
  598. <tr style=" border-left:2px solid black;" class="pajak">
  599. <td>&nbsp;</td>
  600. <th>&nbsp; </th>
  601. <td colspan='7' style=" border-right:2px solid black;">&nbsp; &#9830; Nilai Jurnal Pajak Bank Tidak Sama dengan Pajak Bank, atau</td>
  602. </tr>
  603. <tr style=" border-left:2px solid black;" class="pajak">
  604. <td>&nbsp;</td>
  605. <th>&nbsp; </th>
  606. <td colspan='7' style=" border-right:2px solid black;">&nbsp; &#9830; Kesalahan pemilihan rekening pada saat input mutasi kas->admin bank, yang seharusnya admin bank, tapi yang dipilih adalah pajak pph lainnya</td>
  607. </tr>
  608. <tr style=" border-left:2px solid black;" class="pajak">
  609. <td>&nbsp;</td>
  610. <th>Solusi </th>
  611. <td colspan='7' style=" border-right:2px solid black;">: <font color="red" > Jika kesalahan pemilihan rekening silahkan ubah lagi rekening mutasi kas -> admin bank, klik ubah, ganti rekening yang salah tsb, dari Pajak PPh lainnya menjadi rekening Admin Bank, dan tidak perlu lagi melakukan jurnal, karena jurnal dibuat jika ada transaksi di menu mutasi kas -> admin bank yang menggungkan rekening pajak pph lainnya</font> </td>
  612. </tr>
  613. <tr style=" border-left:2px solid black;" class="pajak">
  614. <td>&nbsp;</td>
  615. <th> </th>
  616. <td colspan='7' style=" border-right:2px solid black;">: <font color="red" > Jika transaksi tersebut benar-benar Pajak Bank maka Harus di Jurnal dan Pastikan Nilai nya Sama dengan Nilai Pajak Pada Buku Bantu Bank</font> </td>
  617. </tr>
  618. <tr style=" border-left:2px solid black;" class="pajak">
  619. <td>&nbsp;</td>
  620. <th> </th>
  621. <td colspan='7' style=" border-right:2px solid black;">: <font color="red" > Pastikan Rekening yang digunakan pada jurnal adalah :</font> </td>
  622. </tr>
  623. <tr style=" border-left:2px solid black;" class="pajak">
  624. <td>&nbsp;</td>
  625. <th>Debet </th>
  626. <td colspan='7' style=" border-right:2px solid black;">: <font black="red" > Akun LRA - </font> <font color="red" >(Rekening Belanja Admin Bank/Nama lainnya sesuai yang disediakan oleh admin kabupaten), dan Kode Rekening Ini Sama Dengan Kode Rekening Admin Bank Yang Ada di Menu Parameter -> Rekening Kas Desa dengan nilai yang sama dengan Nilai Total Pajak Pada Laporan Buku Pembantu Bank</font> </td>
  627. </tr>
  628. <tr style=" border-left:2px solid black;" class="pajak">
  629. <td>&nbsp;</td>
  630. <th>Kredit </th>
  631. <td colspan='7' style=" border-right:2px solid black;">: <font black="red" > Akun PFK - </font><font color="red" > Rekening Potongan Pajak PPh Lainnya, dengan nilai yang sama dengan kolom debet (belanja Admin)</font> </td>
  632. </tr>
  633. <tr style=" border-left:2px solid black;" class="pajak">
  634. <td>&nbsp;</td>
  635. <th> </th>
  636. <td colspan='7' style=" border-right:2px solid black;">: <font color="red" > Pastikan Rekening Belanja Admin tersebut sudah dianggarkan dalam Anggaran sebelumnya, Jika belum ada, Silahkan Hubungi Admin Kabupaten </font> </td>
  637. </tr>
  638.  
  639. <!-- Perbandingan Pencairan dengan SPP Rinci -->
  640. <tr class="spsp">
  641. <td style="border-left:2px solid black;">&nbsp; </td>
  642. <th >Nilai Pencairan Tidak Sama dengan SPP </th>
  643. <th colspan='1' style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;" >No SPP</th>
  644. <th colspan='1' style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;" >Pencairan</th>
  645. <th colspan='2' style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;" >SPP Rinci</th>
  646. <th colspan='2' style="border-left:1px solid black; border-right:2px solid black; border-top:1px solid black; border-bottom:1px solid black;" >Selesih</th>
  647. </tr>
  648.  
  649. <?php
  650. $spsp = odbc_exec($konek,"SELECT table1.Jumlah as tj, table1.No_SPP as tnos, table2.Nilai as tn, table2.No_SPP as tns FROM (
  651. SELECT * FROM Ta_Pencairan where Kd_Desa='07.2012.'
  652. ) as table1 left join (
  653. SELECT sum(Nilai) as nilai, No_SPP as no_spp FROM Ta_SPPRinci where Kd_Desa='07.2012.' group by No_SPP
  654. ) table2 on table1.No_SPP=table2.No_SPP");
  655. while($dspsp = odbc_fetch_row($spsp)){
  656. $slshspsp = odbc_result($spsp,"tj") - odbc_result($spsp,"tn");
  657. if($slshspsp =='0'){
  658.  
  659. }else{
  660. ?>
  661.  
  662. <tr class="spsp">
  663. <td style="border-left:2px solid black;">&nbsp; </td>
  664. <td >&nbsp;</td>
  665. <td colspan='1' style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo $dspsp['tnos']; ?></td>
  666. <td colspan='1' style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($dspsp['tj'],2,",","."); ?></td>
  667. <td colspan='2' style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($dspsp['tn'],2,",","."); ?></td>
  668. <td colspan='2' style="border-left:1px solid black; border-right:2px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($slshspsp,2,",","."); ?></td>
  669. </tr>
  670. <?php }} ?>
  671.  
  672. <tr style=" border-left:2px solid black;" class="spsp">
  673. <td>&nbsp;</td>
  674. <th>Penyebab </th>
  675. <td colspan='7' style=" border-right:2px solid black;">: &#9830; Nilai Pencairan Tidak Sama dengan SPP</td>
  676. </tr>
  677. <tr style=" border-left:2px solid black;" class="spsp">
  678. <td>&nbsp;</td>
  679. <th>Solusi </th>
  680. <td colspan='7' style=" border-right:2px solid black;">: <font color="red" > Hapus Pencairan SPP yang Bermasalah dan Ulang Lagi Pencairan</font> </td>
  681. </tr>
  682.  
  683. <!-- Jurnal Pajak Salah -->
  684.  
  685. <tr class="pjkslh">
  686. <td style="border-left:2px solid black;">&nbsp; </td>
  687. <th >Jurnal Pajak Salah</th>
  688. <th colspan='2' style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;" >No Bukti</th>
  689. <th colspan='2' style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;" >Kode Rincian</th>
  690. <th colspan='2' style="border-left:1px solid black; border-right:2px solid black; border-top:1px solid black; border-bottom:1px solid black;" >Jumlah</th>
  691. </tr>
  692.  
  693. <?php
  694. //SELECT rb.nobukti, rb.Kd_Rincian, rb.Debet FROM Ta_JurnalUmumRinci rb where rb.Kd_Rincian='4.3.6.01.'
  695.  
  696. $pjkslh = odbc_exec($konek,"SELECT rb.nobukti as nobuk, rb.Kd_Rincian as kdr, rb.Debet as deb FROM Ta_JurnalUmumRinci tjjj left join Ta_JurnalUmumRinci rb on
  697. tjjj.NoBukti=rb.NoBukti cross join Ref_Bunga rf
  698. where rb.Kd_Desa='$kd_desa' and substring(tjjj.Kd_Rincian,1,1)='7' and rb.Kd_Rincian != '5.2.5.99.' and rb.Kd_Rincian != '5.2.5.06.' and rb.debet <> 0 and mid(rb.Kd_Rincian,1,1)!='3' ");
  699. while($dpjkslh = odbc_fetch_row($pjkslh)){
  700. $pslh = odbc_result($pjkslh,'deb');
  701.  
  702. ?>
  703.  
  704. <tr class="pjkslh">
  705. <td style="border-left:2px solid black;">&nbsp; </td>
  706. <td >&nbsp;</td>
  707. <td colspan='2' style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo $dpjkslh['nobuk']; ?></td>
  708. <td colspan='2' style="border-left:1px solid black; border-right:1px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo $dpjkslh['kdr']; ?></td>
  709. <td colspan='2' style="border-left:1px solid black; border-right:2px solid black; border-top:1px solid black; border-bottom:1px solid black;"><?php echo number_format($pslh,2,",","."); ?></td>
  710. </tr>
  711.  
  712. <?php } ?>
  713.  
  714. <tr style=" border-left:2px solid black;" class="pjkslh">
  715. <td>&nbsp;</td>
  716. <th>Penyebab </th>
  717. <td colspan='7' style=" border-right:2px solid black;">: &#9830; Salah dalam menginputkan nilai pada jurnal pajak, atau</td>
  718. </tr>
  719. <tr style=" border-left:2px solid black;" class="pjkslh">
  720. <td>&nbsp;</td>
  721. <th> </th>
  722. <td colspan='7' style=" border-right:2px solid black;">: &#9830; Salah dalam memilih rekening pada jurnal pajak</td>
  723. </tr>
  724. <tr style=" border-left:2px solid black;" class="pjkslh">
  725. <td>&nbsp;</td>
  726. <th>Solusi </th>
  727. <td colspan='7' style=" border-right:2px solid black;">: <font color="red" > Pastikan Jurnal ini dibuat dalam jurnal baru, bukan digabung dengan jurnal Silpa : </font> </td>
  728. </tr>
  729. <tr style=" border-left:2px solid black;" class="pjkslh">
  730. <td>&nbsp;</td>
  731. <th> </th>
  732. <td colspan='7' style=" border-right:2px solid black;">: <font color="red" > Pastikan Rekening/kode rincian yang dipilih dalam menjurnal pajak bank sesuai dengan rekening belanja admin yang ada pada menu Parameter -> Rekening Kas Desa, pada kolom Admin Bank : </font> </td>
  733. </tr>
  734. <tr style=" border-left:2px solid black;" class="pjkslh">
  735. <td>&nbsp;</td>
  736. <th> </th>
  737. <td colspan='7' style=" border-right:2px solid black;">: <font color="red" > Pastikan Rekening yang dipilih dalam menjurnal pajak bank sesuai dengan yang disarankan, yaitu : </font> </td>
  738. </tr>
  739. <tr style=" border-left:2px solid black;" class="pjkslh">
  740. <td>&nbsp;</td>
  741. <th>Debet </th>
  742. <td colspan='7' style=" border-right:2px solid black;">: Akun LRA - <font color="red" >(Rekening Belanja Admin Bank/Nama lainnya sesuai yang disediakan oleh admin kabupaten), dan </font>Kode Rekening Ini Sama Dengan Kode Rekening Admin Bank Yang Ada di Menu Parameter -> Rekening Kas Desa <font color="red" >dengan nilai yang sama dengan Nilai Total Pajak Pada Laporan Buku Pembantu Bank</font> </td>
  743. </tr>
  744. <tr style=" border-left:2px solid black;" class="pjkslh">
  745. <td>&nbsp;</td>
  746. <th>Kredit </th>
  747. <td colspan='7' style=" border-right:2px solid black;">: Akun PFK - <font color="red" > Rekening Potongan Pajak PPh Lainnya, dengan nilai yang sama dengan kolom debet (belanja Admin)</font> </td>
  748. </tr>
  749. <tr style=" border-left:2px solid black;" class="pjkslh">
  750. <td>&nbsp;</td>
  751. <th> </th>
  752. <td colspan='7' style=" border-right:2px solid black;">: <font color="red" > Pastikan Rekening Belanja Admin tersebut sudah dianggarkan dalam Anggaran sebelumnya, Jika belum ada, Silahkan Hubungi Admin Kabupaten </font> </td>
  753. </tr>
  754. <tr style="border-bottom:2px solid black; border-left:2px solid black;" >
  755. <td colspan='8' style=" border-right:2px solid black;">&nbsp;</td>
  756. </tr>
  757. </table>
  758. <tr>
  759. <td style="border-left:2px solid black;">&nbsp; </td>
  760. <td> <h4><font color="red">(Pastikan Saldo Bank Sudah sama dengan yang ada di buku rekening / Rekening Koran)</font> </h4></td>
  761. </tr>
  762. </div>
  763. <?php } ?>
  764. </div>
  765. <!-- /.box-body -->
  766. </div>
  767. <!-- /.box -->
  768. </div>
  769. <!-- /.col -->
  770. </div>
  771. <!-- /.row -->
  772. </section>
  773. <!-- /.content -->
  774. </div>
  775. <!-- /.content-wrapper -->
  776.  
  777. <script>
  778. $(document).ready(function() {
  779. if ('<?php echo $jumlahsisadata;?>'==0) {$(".sisapanjar1").css("display","none");}
  780. if ('<?php echo $totslh;?>'==0) {$(".sisapanjar2").css("display","none");}
  781. if ('<?php echo $jumlahsisadata;?>'==0) {$(".sisapanjar3").css("display","none");}
  782. if ('<?php echo $ssap;?>'==0 && '<?php echo $sspj;?>'==0) {$(".silpa").css("display","none");}
  783. if ('<?php echo $sjnpb;?>'==0) {$(".pajak").css("display","none");}
  784. if ('<?php echo $pslh;?>'==0) {$(".pjkslh").css("display","none");}
  785. if ('<?php echo $slshspsp;?>'==0) {$(".spsp").css("display","none");}
  786. if (<?php echo $bku;?> >= 0) {$(".ketbku").css("display","none");}
  787. if (<?php echo $bank;?> >= 0 ) {$(".ketbank").css("display","none");}
  788. if (<?php echo $tunai;?> >= 0 ) {$(".kettunai").css("display","none");}
  789.  
  790. if ('<?php echo $jumlahsisadata;?>' != '0' || '<?php echo $sjnpb;?>' != '0' || '<?php echo $ssap;?>' != '0' || '<?php echo $sspj;?>' != '0' ||
  791. '<?php echo $selisih;?>' != '0' || '<?php echo $slshspsp;?>' !='0' || '<?php if(empty($slsh)) echo '0'; else echo $slsh;?>' !='0' || '<?php echo $pslh;?>' !='' || '<?php echo $bku;?>' <'0' || '<?php echo $bank;?>' <'0' || '<?php echo $tunai;?>' <'0' ) {
  792. $("#gambar").css("display","block"); $("#gambar img").attr('src','images/silang.png');}
  793. else {
  794. $("#gambar").css("display","block"); $("#gambar img").attr('src','images/oke.png');
  795. }
  796. if ('<?php echo $jjsas;?>'!=0) {$(".silpa1").css("display","none");}
  797. if ('<?php echo $sspj;?>'==0) {$(".silpa2").css("display","none");}
  798. if ('<?php echo $ssap;?>'==0) {$(".silpa3").css("display","none");}
  799. if ('<?php echo $jjsas;?>'!=0) {$(".silpa4").css("display","none");}
  800. if ('<?php echo $jjsas;?>'!=0) {$(".silpa5").css("display","none");}
  801.  
  802.  
  803. })
  804.  
  805. </script>
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!