Advertisement
NetCut

before_update

Feb 20th, 2019
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.34 KB | None | 0 0
  1. <?php
  2. if( empty( $_SESSION['id_user'] ) ){
  3.  
  4. $_SESSION['err'] = '<strong>ERROR!</strong> Anda harus login terlebih dahulu.';
  5. header('Location: ./');
  6. die();
  7. } else {
  8.  
  9. if( isset( $_REQUEST['submit'] )){
  10. switch($aksi){
  11. case 'edit':
  12. include 'semi_edit.php';
  13. break;
  14. case 'hapus':
  15. include 'semi_hapus.php';
  16. break;
  17. }
  18. $id_barang = $_REQUEST['id_barang'];
  19. $nama_barang = $_REQUEST['nama_barang'];
  20. $id_semi = $_REQUEST['id_semi'];
  21. $trx = $_REQUEST['trx'];
  22. $tanggal = date('Y-m-H');
  23. $jenis_barang = $_REQUEST['jenis_barang'];
  24. $satuan = $_REQUEST['satuan'];
  25. $permintaan = $_REQUEST['permintaan'];
  26. $nama = $_SESSION['nama'];
  27. $koordinator = $_SESSION['koordinator'];
  28. $id_user = $_SESSION['id_user'];
  29. $sql = mysqli_query($koneksi, "INSERT INTO semi (trx,id_barang,nama_barang,tanggal,jenis_barang,satuan,permintaan,nama,koordinator,id_user) VALUES ('$trx','$id_barang','$nama_barang','$tanggal','$jenis_barang','$satuan','$permintaan','$nama','$koordinator','$id_user')");
  30. if($sql == true){
  31. header('Location: ./admin.php?hlm=transaksi&aksi=baru');
  32. die();
  33. } else {
  34. echo 'ERROR! Periksa penulisan querynya';
  35. }
  36. }
  37. if( isset( $_REQUEST['submit2'] )){
  38. switch($aksi){
  39. case 'edit':
  40. include 'semi_edit.php';
  41. break;
  42. case 'hapus':
  43. include 'semi_hapus.php';
  44. break;
  45. }
  46. $id_transaksi = ['id_transaksi'];
  47. $tanggal1 = date ("M-Y");
  48. $id_user = $_SESSION['id_user'];
  49. $nama = $_SESSION['nama'];
  50. $koordinator = $_SESSION['koordinator'];
  51. $nota = $_SESSION['nama']."-".$_SESSION['koordinator']."-". date("d")."-".date("M");
  52. $sql2 = mysqli_query($koneksi, "INSERT INTO transaksi (id_transaksi,nota,nama,koordinator,tanggal,id_user) VALUES ('$id_transaksi','$nota','$nama','$koordinator','$tanggal1','$id_user')");
  53. $id = $_REQUEST['trx'];
  54. $data = mysqli_query($koneksi,"SELECT trx,nama_barang,satuan,permintaan,tanggal,id_user,jenis_barang,id_barang,koordinator,nama,id_sub
  55. FROM semi WHERE trx='$id'");
  56. $d = mysqli_fetch_array($data);
  57. $id_sub = $d['id_sub'];
  58. $trx = $d['trx'];
  59. $nama_barang = $d['nama_barang'];
  60. $permintaan = $d['permintaan'];
  61. $tanggal = $d['tanggal'];
  62. $id_user = $d['id_user'];
  63. $koordinator = $d['koordinator'];
  64. $nama = $d['nama'];
  65. $jenis_barang = $d['jenis_barang'];
  66. $id_barang = $d['id_barang'];
  67. $satuan = $d['satuan'];
  68. foreach ($data as $value) {
  69.  
  70.  
  71. $sql = mysqli_query($koneksi, "INSERT INTO sub (nota, permintaan, nama_barang, tanggal, id_user, koordinator, nama, jenis_barang , id_barang,satuan)
  72. VALUES('$trx', '$permintaan', '$nama_barang', '$tanggal', '$id_user', '$koordinator', '$nama', '$jenis_barang', '$id_barang','$satuan' )");
  73. }
  74. $query = mysqli_query($koneksi, "DELETE FROM semi WHERE trx='$id'");
  75. if($query == true){
  76. header('Location: ./admin.php?hlm=transaksi');
  77. die();
  78. } else {
  79. echo'onclick="return konfirmasi()"';
  80. }
  81. }else {
  82. ?>
  83. <form method="post" action="" class="form-inline" role="form">
  84. <div ><br></div>
  85. <div class="form-group">
  86. <label for="nota" class="col-sm-2 control-label">No. Nota</label>
  87. <div class="col-sm-2"><div class="col-sm-2">
  88. <input type="text" name="trx" class="form-control" value="<?php echo $_SESSION['nama']."-".$_SESSION['koordinator']."-". date("d")."-".date("M") ?>" readonly>
  89. </div>
  90. </div>
  91.  
  92. <div class="pull-right">
  93.  
  94. <label for="koordinator" class="col-sm-4 control-label">Koordinator</label>
  95. <div class="col-sm-4">
  96. <h3>
  97. <?php echo $_SESSION['koordinator']; ?>
  98.  
  99. </h3>
  100. </div>
  101. </div>
  102. </div>
  103. <div class="pull-right">
  104. <button type="submit" name="submit2" class="btn btn-primary">Simpan</button>
  105.  
  106. <form action="" method="post" role="form" class="form-inline">
  107. <a href="./admin.php?hlm=transaksi" class="btn btn-danger btn-s "><span class=" pull-right"> Batal </span></a>
  108. </div>
  109. <br/><hr/>
  110. <form method="post" action="" class="form-inline" role="form">
  111. <div class="form-group">
  112. <label for="id_barang" class="col-sm-3 control-label">Kode Barang</label>
  113. <div class="col-sm-4">
  114. <input type="text" name="id_barang" class="form-control" id="id_barang" placeholder="Masukkan Kode Barang" onkeyup="autofill()" >
  115. </div>
  116. </div>
  117.  
  118. <div class="form-group">
  119. <label for="nama_barang" class="col-sm-4 control-label">Nama Barang</label>
  120.  
  121. <div class="col-sm-4">
  122. <input type="text" class="form-control" id="nama_barang" name="nama_barang" placeholder="Masukkan Nama Barang" onkeyup="autofill2()" >
  123. </div>
  124. </div>
  125. <div class="form-group">
  126.  
  127. <label for="permintaan" class="col-sm-4 control-label">Permintaan </label>
  128. <div class="col-sm-4">
  129. <input type="text" name="permintaan" class="form-control" id="permintaan" placeholder="Masukkan Jumlah" value="" >
  130. </div>
  131. </div>
  132. <hr>
  133. <div class="form-group">
  134. <label for="jenis_barang" class="col-sm-3 control-label">Jenis Barang</label>
  135. <div class="col-sm-4">
  136. <input type="text" name="jenis_barang" class="form-control" id="jenis_barang" value="" placeholder="" readonly required>
  137. </div>
  138. </div>
  139.  
  140. <div class="form-group">
  141. <label for="jumlah" class="col-sm-4 control-label">Jumlah Yang Tersedia</label>
  142.  
  143. <div class="col-sm-4">
  144. <input type="text" class="form-control" id="jumlah" name="jumlah" placeholder="-" value="" readonly required>
  145. </div>
  146. </div>
  147. <div class="form-group">
  148.  
  149. <label for="satuan" class="col-sm-2 control-label">Satuan</label>
  150. <div class="col-sm-4">
  151. <input type="text" name="satuan" class="form-control" id="satuan" placeholder="-" value="" readonly required>
  152. </div>
  153. </div>
  154.  
  155. <button type="submit" name="submit" class="btn btn-success">Tambah</button>
  156. <hr>
  157. <div ><input type="text" class="hidden" name="id_sub" id="id_sub"></div>
  158. </form>
  159. <div >
  160.  
  161. <table class="table table-bordered">
  162. <thead>
  163. <tr class="info">
  164. <th width="5%">No</th>
  165. <th width="10%">Nota</th>
  166. <th width="10%">Kode Barang</th>
  167. <th width="22%">Nama Barang</th>
  168. <th width="10%">Jenis</th>
  169. <th width="10%">satuan</th>
  170. <th width="10%">permintaan</th>
  171. <th width="20%">Tindakan</th>
  172. </tr>
  173. </thead>
  174.  
  175. <tbody>
  176. <?php
  177. $id_user = $_SESSION['id_user'];
  178. $sql = mysqli_query($koneksi, "SELECT * FROM semi where id_user='$id_user' ORDER BY id_user DESC");
  179. if(mysqli_num_rows($sql) > 0){
  180. $no = 0;
  181.  
  182. while($row = mysqli_fetch_array($sql)){
  183. $no++;
  184. echo '
  185.  
  186. <tr>
  187. <td>'.$no.'</td>
  188. <td>'.$row['trx'].'</td>
  189. <td>'.$row['id_barang'].'</td>
  190. <td>'.$row['nama_barang'].'</td>
  191. <td>'.$row['jenis_barang'].'</td>
  192. <td>'.$row['satuan'].'</td>
  193. <td>'.$row['permintaan'].'</td>
  194. <td>';
  195. echo'
  196.  
  197.  
  198. <script type="text/javascript" language="JavaScript">
  199. function konfirmasi(){
  200. tanya = confirm("Anda yakin akan menghapus data ini?");
  201. if (tanya == true) return true;
  202. else return false;
  203. }
  204. </script>
  205.  
  206. <a href="?hlm=transaksi&aksi=edit&id_semi='.$row['id_sub'].'" class="btn btn-warning btn-s">Edit</a>
  207. <a href="?hlm=transaksi&aksi=hapus&submit=yes&id_semi='.$row['id_sub'].'" onclick="return konfirmasi()" class="btn btn-danger btn-s">Hapus</a>
  208.  
  209. </td>';
  210. }
  211. }
  212.  
  213. ?>
  214.  
  215. </tr>
  216.  
  217. </tbody>
  218.  
  219. </div>
  220.  
  221. </div>
  222.  
  223. </form>
  224.  
  225.  
  226.  
  227.  
  228.  
  229. <?php
  230. }
  231. }
  232. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement