API tools faq
paste
Advertisement
mipdevp

tr_belanja_kegiatan2.php

mipdevp
Feb 20th, 2020
518
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.74 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. $a = !empty($_GET['a']) ? $_GET['a'] : "reset";
  3. $id = !empty($_GET['id']) ? $_GET['id'] : " "; //Untuk Update dan Delete
  4. $id_tr_bku = !empty($_GET['id_tr_bku']) ? $_GET['id_tr_bku'] : " ";
  5.  
  6. $kdb = koneksidatabase();
  7. $a = @$_GET["a"];
  8. $sql = @$_POST["sql"];
  9. $tgl_awal = @$_POST["tgl_awal"];
  10. $tgl_akhir = @$_POST["tgl_akhir"];
  11. $id_bidang = @$_POST["id_bidang"];
  12. $id_program = @$_POST["id_program"];
  13.  
  14. switch ($a) {
  15. case "reset":
  16. curd_read();
  17. break;
  18. default:
  19. curd_read();
  20. break;
  21. }
  22. mysqli_close($kdb);
  23.  
  24. function curd_read()
  25. {
  26. global $kdb;
  27. $hasilselect = sql_select_tr_belanja_kegiatan(); //ini Judul Table
  28. $i = 1;
  29. ?>
  30. <div class="row">
  31. <div class="col-xs-12">
  32. <div class="box box-danger">
  33. <div class="box-header">
  34. <h3 class="box-title">Buku Kas Umum Bendahara</h3>
  35. <hr />
  36. <p>LAPORAN PERIODE</p>
  37. <div class="row">
  38. <div class="col-lg-6">
  39. <button type="button" class="btn btn-success" data-target="#modal-default" data-toggle="modal"> <i class="fa fa-plus-circle"></i> Ubah Periode </button>
  40. <a href="./menu/cetak-laporan-pajak.php?tgl_awal=<?php global $tgl_awal;
  41. echo $tgl_awal; ?>&tgl_akhir=<?php global $tgl_akhir;
  42. echo $tgl_akhir; ?>" target="_blank" class="btn btn-danger"><i class="fa fa-cloud-download" title="Download Form Bimbingan Kosong"></i> Cetak</a>
  43.  
  44. <a class="btn btn-warning" href="?menu=buku-kas-umum&a=reset"> <i class="fa fa-rotate-left"></i> Reset </a>
  45. </div>
  46. </div>
  47. <hr>
  48. <p>LAPORAN PER PROGRAM</p>
  49. <form class="form-horizontal" action="index.php?menu=buku-kas-umum" method="POST">
  50. <div class="row">
  51. <div class="col-lg-5">
  52. <div class="form-group">
  53. <select class="form-control select2" name="id_program" style="width: 100%;" data-placeholder="Klik Program...">
  54. <?php
  55. global $kdb;
  56. $sql = "SELECT * FROM `m_program` where publish ='T'";
  57. $hasil = mysqli_query($kdb, $sql) or die(mysqli_error($kdb));
  58. while ($baris = mysqli_fetch_array($hasil)) {
  59. $value = $baris['id_program'];
  60. $caption = $baris['nama_program']; ?>
  61. <option value="<?php echo $value ?>">
  62. &nbsp; <?php echo $caption; ?> &nbsp;
  63. </option>
  64. <?php
  65. } //Penutup While Select
  66. ?>
  67. </select>
  68. </div>
  69. </div>
  70. <div class="col-lg-3">
  71. <input class="btn btn-success" type="submit" name="action" value="CARI">
  72. <a class="btn btn-success" href="#"> <i class="fa fa-cloud-download"></i> CETAK </a>
  73. </div>
  74. </div>
  75. </form>
  76. <!-- buat download laporan pajak yang belum dan sudah -->
  77. </div>
  78. <div class="box-body">
  79. <table id="example1" class="table table-bordered table-striped">
  80. <thead>
  81. <tr>
  82. <th>No</th>
  83. <th>User</th>
  84. <th>Tanggal</th>
  85. <th>Bukti</th>
  86. <th>Uraian</th>
  87. <th>Catatan</th>
  88. <th>Anggaran</th>
  89. <th>Keterangan</th>
  90. <!-- <th>Pajak</th>
  91. <th>Aksi</th> -->
  92. </tr>
  93. </thead>
  94. <?php
  95. $i = 1;
  96. while ($baris = mysqli_fetch_array($hasilselect))
  97. //Pembuka While
  98. {
  99. ?>
  100. <tr>
  101. <td><?php echo $i; ?></td>
  102. <td><b>Bidang</b> <?php echo $baris['nama_bidang']; ?></td>
  103. <td><?php echo date('d/m/Y', strtotime($baris['tgl_anggaran'])); ?></td>
  104. <td><?php echo $baris['no_buktianggaran']; ?></td>
  105. <td><b></b> <?php echo $baris['nama_belanja']; ?> dalam <b> Kegiatan</b> <?php echo $baris['nama_kegiatan']; ?></td>
  106. <td><?php echo $baris['ket']; ?></td>
  107. <td align="right"><?php echo number_format($baris['nominal_anggaran'], 2); ?></td>
  108. <!--
  109. <td>Rp. <?php echo $baris['pajak_lain']; ?></td> -->
  110. <td><?php if ($baris['publish'] == "T") {
  111. echo '<span class="label label-success">Pajak dibayar</span>';
  112. } else {
  113. echo '<span class="label label-danger">Pajak belum dibayar</span>';
  114. } ?>
  115. </td>
  116. </tr>
  117. <?php
  118. $i++;
  119. } //Penutup While
  120. ?>
  121. </table>
  122. <!--Modal ubah periode-->
  123. <div class="modal fade" id="modal-default">
  124. <div class="modal-dialog">
  125. <div class="modal-content">
  126. <div class="modal-header">
  127. <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  128. <h3 class="modal-title" id="myModalLabel">Periode Buku Kas Umum</h3>
  129. </div>
  130. <div class="modal-body">
  131. <form class="form-horizontal" action="index.php?menu=buku-kas-umum" method="POST">
  132. <div class="box-body">
  133. <div class="form-group">
  134. <div class="col-sm-12">
  135. <div class="input-group date">
  136. <div class="input-group-addon">
  137. <i class="fa fa-calendar"></i>
  138. </div>
  139. <input type="text" name="tgl_awal" class="form-control pull-right" id="awal" placeholder="Tanggal awal" required="" data-date-format="yyyy-mm-dd">
  140. </div>
  141. </div>
  142. </div>
  143. <div class="form-group">
  144. <div class="col-sm-12">
  145. <div class="input-group date">
  146. <div class="input-group-addon">
  147. <i class="fa fa-calendar"></i>
  148. </div>
  149. <input type="text" name="tgl_akhir" class="form-control pull-right" id="akhir" placeholder="Tanggal akhir" required="" data-date-format="yyyy-mm-dd">
  150. </div>
  151. </div>
  152. </div>
  153. <div class="form-group">
  154. <div class="col-sm-12">
  155. <div class="input-group date">
  156. <div class="input-group-addon">
  157. <i class="fa fa-cube"></i>
  158. </div>
  159. <select class="form-control select2" name="id_bidang" style="width: 100%;" data-placeholder="Klik bidang..." required="">
  160. <?php
  161. global $kdb;
  162. $sql = "SELECT * FROM `m_bidang` where `publish`='T'";
  163. $hasil = mysqli_query($kdb, $sql) or die(mysqli_error($kdb));
  164. while ($baris = mysqli_fetch_array($hasil)) {
  165. $value = $baris['id_bidang'];
  166. $caption = $baris['nama_bidang']; ?>
  167. <option value="<?php echo $value ?>">
  168. &nbsp; <?php echo $caption; ?> &nbsp;
  169. </option>
  170. <?php
  171. } //Penutup While Select
  172. ?>
  173. </select>
  174. </div>
  175. </div>
  176. </div>
  177. <div class="modal-footer">
  178. <input class="btn btn-success" type="submit" name="action" value="CARI">
  179. </div>
  180. </form>
  181. </div>
  182.  
  183. </div>
  184. </div>
  185. </div>
  186. <?php
  187. mysqli_free_result($hasil);
  188. }
  189. ?>
  190. <?php
  191. function koneksidatabase()
  192. {
  193. include('./koneksi/koneksi.php');
  194. return $kdb;
  195. }
  196.  
  197. function sql_select_tr_belanja_kegiatan() //$hasil
  198. {
  199. global $kdb;
  200. global $tgl_awal;
  201. global $tgl_akhir;
  202. global $id_bidang;
  203. global $id_program;
  204. if ($tgl_awal == "" and $tgl_akhir == "") //pencarian berdasarkan periode tanggal
  205. {
  206. $sql = "SELECT a.*,b.*,c.*,d.*,e.* FROM `m_bidang` as a, `m_program` as b, `m_kegiatan` as c, `m_belanja` as d,`tr_bku` as e where a.`id_bidang`=b.`id_bidang` and b.`id_program`=c.`id_program` and c.`id_kegiatan`=e.`id_kegiatan` and d.`id_belanja`= e.`id_belanja` order by MONTH(tgl_anggaran) asc";
  207. } elseif ($id_program != "") {
  208. $sql = "SELECT a.*,b.*,c.*,d.*,e.* FROM `m_bidang` as a, `m_program` as b, `m_kegiatan` as c, `m_belanja` as d,`tr_bku` as e where a.`id_bidang`=b.`id_bidang` and b.`id_program`=c.`id_program` and c.`id_kegiatan`=e.`id_kegiatan` and d.`id_belanja`=e.`id_belanja` AND b.`id_program` = '$id_program' order by MONTH(tgl_anggaran) asc";
  209. }
  210. $hasil = mysqli_query($kdb, $sql) or die(mysqli_error($kdb));
  211. return $hasil;
  212. }
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!