Hallo! Selamat Datang di Marketplace produk digital, Freelancer terbaik di indonesia (67493 Members, 783 Products, 5291 Topic, 12956 Comments)

nambah menu bayar buat bulan apa? di sisilah KTSP 2006

Dibuat
Login Terakhir 4 Bulan lalu,
Telah Dilihat 1671 Kali
Aban_sobana Mengatakan : Sultan Account
  1. mohon bantuanya mas robi saya akan menambahakan menu tambahan bayaran bulan ke ke berapa. di bagian pembayaran
  2.  
  3.  
  4. tampilanya seperti ini, cuman terkendalan di bagian script phpnya.
  5.  
  6.  
  7. <?php
  8. if ($_GET[act]==''){
  9. ?>
  10. <div class="col-xs-12">
  11. <div class="box">
  12. <div class="box-header">
  13. <h3 class="box-title">Pembayaran Keuangan Siswa </h3>
  14. <form [removed]='padding:4px'>
  15. <?php
  16. echo "<option value=''>- Pilih Jenis Biaya -</option>";
  17. $biaya = mysql_query("SELECT * FROM rb_keuangan_jenis");
  18. while ($k = mysql_fetch_array($biaya)){
  19. if ($_GET[biaya]==$k[id_keuangan_jenis]){
  20. echo "<option value='$k[id_keuangan_jenis]' selected>$k[nama_jenis]</option>";
  21. }else{
  22. echo "<option value='$k[id_keuangan_jenis]'>$k[nama_jenis]</option>";
  23. }
  24. }
  25. ?>
  26. </select>
  27. <select name='kelas' [removed]='margin-top:-4px' class='btn btn-info btn-sm' value='Lihat'>
  28. </form>
  29. </div><!-- /.box-header -->
  30. <div class="box-body">
  31.  
  32. <?php
  33. if (isset($_GET['sukses'])){
  34. echo "<div class='alert alert-success alert-dismissible fade in' role='alert'>
  35. <button type='button' class='close' data-dismiss='alert' aria-label='Close'>
  36. <span aria-hidden='true'>×</span></button> <strong>Sukses!</strong> - Data telah Berhasil Di Proses,..
  37. </div>";
  38. }elseif(isset($_GET['gagal'])){
  39. echo "<div class='alert alert-danger alert-dismissible fade in' role='alert'>
  40. <button type='button' class='close' data-dismiss='alert' aria-label='Close'>
  41. <span aria-hidden='true'>×</span></button> <strong>Gagal!</strong> - Data tidak Di Proses, terjadi kesalahan dengan data..
  42. </div>";
  43. }
  44. ?>
  45.  
  46. <form action='' method='POST'>
  47. <input type="hidden" name='kelas' value='<?php echo $_GET[kelas]; ?>'>
  48. <?php
  49. $j = mysql_fetch_array(mysql_query("SELECT * FROM `rb_keuangan_jenis` where id_keuangan_jenis='$_GET[biaya]'"));
  50. $th = mysql_fetch_array(mysql_query("SELECT * FROM rb_tahun_akademik where aktif='Ya'"));
  51. echo "<table id='example1' class='table table-bordered table-striped'>
  52. <thead>
  53. <tr><th width='30px'>No</th>
  54. <th>NIPD</th>
  55. <th>NISN</th>
  56. <th>Nama Siswa</th>
  57. <th>Kelas</th>";
  58. if ($_GET[kelas] != '' AND $_GET[biaya] != ''){
  59. if ($j[total_beban] != '0'){
  60. echo "<th>Status</th>";
  61. }
  62. }
  63.  
  64. echo "<th width='140px'>Action</th>
  65. </tr>
  66. </thead>
  67. <tbody>";
  68.  
  69. if ($_GET[kelas] != '' AND $_GET[biaya] != ''){
  70. $tampil = mysql_query("SELECT * FROM rb_siswa a LEFT JOIN rb_kelas b ON a.kode_kelas=b.kode_kelas
  71. LEFT JOIN rb_jenis_kelamin c ON a.id_jenis_kelamin=c.id_jenis_kelamin
  72. LEFT JOIN rb_jurusan d ON b.kode_jurusan=d.kode_jurusan
  73. where a.kode_kelas='$_GET[kelas]' ORDER BY a.id_siswa");
  74. }
  75. $no = 1;
  76. while($r=mysql_fetch_array($tampil)){
  77. $t = mysql_fetch_array(mysql_query("SELECT sum(total_bayar) as total FROM `rb_keuangan_bayar` where id_keuangan_jenis='$_GET[biaya]' AND kode_kelas='$r[kode_kelas]' AND nisn='$r[nisn]' AND tahun_akademik='$th[id_tahun_akademik]'"));
  78. if ($j[total_beban] <= $t[total]) { $status = 'Lunas'; $class = 'green'; }else{ $status = 'Belum Lunas'; $class = 'red'; }
  79. echo "<tr><td>$no</td>
  80. <td>$r[nipd]</td>
  81. <td>$r[nisn]</td>
  82. <td>$r[nama]</td>
  83. <td>$r[nama_kelas]</td>";
  84. if ($_GET[kelas] != '' AND $_GET[biaya] != ''){
  85. if ($j[total_beban] != '0'){
  86. echo "<td><i [removed]='padding:60px; color:red'>Silahkan Memilih Jenis Biaya dan Kelas Terlebih dahulu...</center>";
  87. }
  88. ?>
  89. </div><!-- /.box -->
  90. </form>
  91. </div>
  92. <?php
  93. }elseif($_GET[act]=='detail'){
  94. if (isset($_POST[proses])){
  95. $th = mysql_fetch_array(mysql_query("SELECT * FROM rb_tahun_akademik where aktif='Ya'"));
  96. $query = mysql_query("INSERT INTO rb_keuangan_bayar VALUES('','$_POST[a]','$_POST[b]','$_POST[c]','$th[id_tahun_akademik]','$_POST[bayar]','".date('Y-m-d H:i:s')."')");
  97. if ($query){
  98. echo "[removed][removed]='index.php?view=pembayaransiswa&act=detail&biaya=$_POST[a]&nisn=$_POST[c]&sukses';[removed]";
  99. }else{
  100. echo "[removed][removed]='index.php?view=pembayaransiswa&act=detail&biaya=$_POST[a]&nisn=$_POST[c]&gagal';[removed]";
  101. }
  102. }
  103.  
  104. $d = mysql_fetch_array(mysql_query("SELECT * FROM `rb_siswa` a JOIN rb_kelas b ON a.kode_kelas=b.kode_kelas where a.nisn='$_GET[nisn]'"));
  105. $j = mysql_fetch_array(mysql_query("SELECT * FROM `rb_keuangan_jenis` where id_keuangan_jenis='$_GET[biaya]'"));
  106. $t = mysql_fetch_array(mysql_query("SELECT sum(total_bayar) as total FROM `rb_keuangan_bayar` where id_keuangan_jenis='$_GET[biaya]' AND kode_kelas='$d[kode_kelas]' AND nisn='$_GET[nisn]'"));
  107. $sisa = $t[total]-$j[total_beban];
  108. if ($j[total_beban] <= $t[total]) { $status = 'Lunas'; $class = 'success'; }else{ $status = 'Belum Lunas'; $class = 'danger'; }
  109. echo "<div class='col-xs-12'>
  110. <div class='box'>
  111. <div class='box-header'>
  112. <h3 class='box-title'>Data Pembayaran Keuangan Siswa</h3>
  113. <a class='pull-right btn btn-sm btn-warning' href='index.php?view=pembayaransiswa&biaya=$_GET[biaya]&kelas=$d[kode_kelas]'>Kembali</a>
  114. </div>
  115. <div class='box-body'>";
  116.  
  117. if (isset($_GET['sukses'])){
  118. echo "<div class='alert alert-success alert-dismissible fade in' role='alert'>
  119. <button type='button' class='close' data-dismiss='alert' aria-label='Close'>
  120. <span aria-hidden='true'>×</span></button> <strong>Sukses!</strong> - Data telah Berhasil Di Proses,..
  121. </div>";
  122. }elseif(isset($_GET['gagal'])){
  123. echo "<div class='alert alert-danger alert-dismissible fade in' role='alert'>
  124. <button type='button' class='close' data-dismiss='alert' aria-label='Close'>
  125. <span aria-hidden='true'>×</span></button> <strong>Gagal!</strong> - Data tidak Di Proses, terjadi kesalahan dengan data..
  126. </div>";
  127. }
  128.  
  129. echo "<div class='col-md-12'>
  130. <form action='' method='POST'>
  131. <table class='table table-condensed table-hover'>
  132. <tbody>
  133. <tr><th width='120px' scope='row'>Nama Kelas</th> <td>$d[nama_kelas]</td></tr>
  134. <tr><th scope='row'>Nama Siswa</th> <td>$d[nama]</td></tr>
  135. <tr><th scope='row'>Jenis Biaya</th> <td>$j[nama_jenis]</td></tr>";
  136.  
  137. if ($sisa < 0){
  138. echo "<input type='hidden' value='$j[id_keuangan_jenis]' name='a'>
  139. <input type='hidden' value='$d[kode_kelas]' name='b'>
  140. <input type='hidden' value='$_GET[nisn]' name='c'>
  141. <tr><th scope='row'>Bayar Sisa</th>
  142. <td><input type='text' name='bayar' value=''> Bayar Bulan : <input type='date' name='date' value=''> <input type='submit' name='proses' value=' Proses'></td></tr>";
  143. }
  144.  
  145. if ($j[total_beban] > '0'){
  146. echo "<tr><th scope='row'>Total Beban</th> <td>Rp ".number_format($j[total_beban])."</td></tr>
  147. <tr><th scope='row'>Total Bayar</th> <td>Rp ".number_format($t[total])."</td></tr>
  148. <tr class='alert alert-$class'><th scope='row'>Sisa</th> <td>Rp ".number_format($t[total]-$j[total_beban])." <small class='pull-right'>$status</small></td></tr>";
  149. }
  150.  
  151. if ($j[total_beban] == '0'){
  152. echo "<tr><th scope='row'>Total </th> <td>Rp ".number_format($t[total])."</td></tr>
  153. <input type='hidden' value='$j[id_keuangan_jenis]' name='a'>
  154. <input type='hidden' value='$d[kode_kelas]' name='b'>
  155. <input type='hidden' value='$_GET[nisn]' name='c'>
  156. <tr><th scope='row'>Bayar</th> <td><input type='text' name='bayar' value=''> <input type='submit' name='proses' value='Proses'></td></tr>";
  157. }
  158.  
  159. echo "</tbody>
  160. </table>
  161. </form>
  162. </div>
  163.  
  164.  
  165. <table id='example' class='table table-bordered table-striped'>
  166. <thead>
  167. <tr>
  168. <th [removed]='width:80px !important'><center>
  169. <a class='btn btn-danger btn-xs' title='Delete Data' href='index.php?view=pembayaransiswa&act=detail&biaya=$_GET[biaya]&nisn=$_GET[nisn]&hapus=$r[id_keuangan_bayar]'><span class='glyphicon glyphicon-remove'></span></a>
  170. </center></td>";
  171. }
  172. echo "</tr>";
  173. $no++;
  174. }
  175.  
  176. if (isset($_GET[hapus])){
  177. mysql_query("DELETE FROM rb_keuangan_bayar where id_keuangan_bayar='$_GET[hapus]'");
  178. echo "[removed][removed]='index.php?view=pembayaransiswa&act=detail&biaya=$_GET[biaya]&nisn=$_GET[nisn]';[removed]";
  179. }
  180.  
  181. echo "<tbody>
  182. </table>
  183. </div>
  184. </div>
  185. </div>";
  186. }
  187. ?>
  188.  
  189.  
Ada 1 File Kiriman :
1. save_jpg.png (33 KB)

Ada 4 Jawaban

PHPMU.COM Support
commented on 01 Sep 2016 06:59:47
  1. Assalam, Kalau sudah dibuat seperti screenshot yg dikirimkan,..
  2. selanjutnya pastikan sudah dibuat juga filed penampung bulan di table rb_keuangan_bayar mas,..
  3. nanti di query insert jangan lupa menyisipkan data bulan yg dikirimkan juga, mungkin jadi seperti ini :
  4. mysql_query("INSERT INTO rb_keuangan_bayar
  5. VALUES('','$_POST[a]','$_POST[b]','$_POST[c]','$th[id_tahun_akademik]','$_POST[bayar]','$_POST[date]','".date('Y-m-d H:i:s')."')");
Aban_sobana
commented on 01 Sep 2016 13:51:48
  1. kalau insert saya udah berhasil cuma masalah di tampilkanya... maklum saya baru belajar php
  2. gagal ga tampil2.
Terdapat 1 File dilampirkan :
1. save1_jpg.png (34 KB)
Aban_sobana
commented on 01 Sep 2016 13:52:19
  1. screnshot 2
Terdapat 1 File dilampirkan :
1. save4_jpg.png (125 KB)
Aban_sobana
commented on 01 Sep 2016 13:52:44
  1. data tidak tampil..
Terdapat 1 File dilampirkan :
1. save3_jpg.png (32 KB)
Maaf, Untuk Memberikan Komentar Anda Harus Login !!!