API tools faq
paste
Advertisement
NetCut

update

NetCut
Feb 20th, 2019
142
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.44 KB | None | 0 0
raw download clone embed print report
  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. while ($row = mysqli_fetch_array($data)) {
  69. $rows[]=$row;
  70. }
  71. foreach ($rows as $row) {
  72. $sql = mysqli_query($koneksi, "INSERT INTO sub (nota, permintaan, nama_barang, tanggal, id_user, koordinator, nama, jenis_barang , id_barang,satuan)
  73. VALUES ($row['trx'],$row['permintaan'],$row['nama_barang'],$row['tanggal'],$row['id_user'],$row['koordinator'],$row['nama'],$row['jenis_barang'],$row['id_barang'],$row['satuan'])");
  74. }
  75. $query = mysqli_query($koneksi, "DELETE FROM semi WHERE trx='$id'");
  76. if($query == true){
  77. header('Location: ./admin.php?hlm=transaksi');
  78. die();
  79. } else {
  80. echo'onclick="return konfirmasi()"';
  81. }
  82. }else {
  83. ?>
  84. <form method="post" action="" class="form-inline" role="form">
  85. <div ><br></div>
  86. <div class="form-group">
  87. <label for="nota" class="col-sm-2 control-label">No. Nota</label>
  88. <div class="col-sm-2"><div class="col-sm-2">
  89. <input type="text" name="trx" class="form-control" value="<?php echo $_SESSION['nama']."-".$_SESSION['koordinator']."-". date("d")."-".date("M") ?>" readonly>
  90. </div>
  91. </div>
  92.  
  93. <div class="pull-right">
  94.  
  95. <label for="koordinator" class="col-sm-4 control-label">Koordinator</label>
  96. <div class="col-sm-4">
  97. <h3>
  98. <?php echo $_SESSION['koordinator']; ?>
  99.  
  100. </h3>
  101. </div>
  102. </div>
  103. </div>
  104. <div class="pull-right">
  105. <button type="submit" name="submit2" class="btn btn-primary">Simpan</button>
  106.  
  107. <form action="" method="post" role="form" class="form-inline">
  108. <a href="./admin.php?hlm=transaksi" class="btn btn-danger btn-s "><span class=" pull-right"> Batal </span></a>
  109. </div>
  110. <br/><hr/>
  111. <form method="post" action="" class="form-inline" role="form">
  112. <div class="form-group">
  113. <label for="id_barang" class="col-sm-3 control-label">Kode Barang</label>
  114. <div class="col-sm-4">
  115. <input type="text" name="id_barang" class="form-control" id="id_barang" placeholder="Masukkan Kode Barang" onkeyup="autofill()" >
  116. </div>
  117. </div>
  118.  
  119. <div class="form-group">
  120. <label for="nama_barang" class="col-sm-4 control-label">Nama Barang</label>
  121.  
  122. <div class="col-sm-4">
  123. <input type="text" class="form-control" id="nama_barang" name="nama_barang" placeholder="Masukkan Nama Barang" onkeyup="autofill2()" >
  124. </div>
  125. </div>
  126. <div class="form-group">
  127.  
  128. <label for="permintaan" class="col-sm-4 control-label">Permintaan </label>
  129. <div class="col-sm-4">
  130. <input type="text" name="permintaan" class="form-control" id="permintaan" placeholder="Masukkan Jumlah" value="" >
  131. </div>
  132. </div>
  133. <hr>
  134. <div class="form-group">
  135. <label for="jenis_barang" class="col-sm-3 control-label">Jenis Barang</label>
  136. <div class="col-sm-4">
  137. <input type="text" name="jenis_barang" class="form-control" id="jenis_barang" value="" placeholder="" readonly required>
  138. </div>
  139. </div>
  140.  
  141. <div class="form-group">
  142. <label for="jumlah" class="col-sm-4 control-label">Jumlah Yang Tersedia</label>
  143.  
  144. <div class="col-sm-4">
  145. <input type="text" class="form-control" id="jumlah" name="jumlah" placeholder="-" value="" readonly required>
  146. </div>
  147. </div>
  148. <div class="form-group">
  149.  
  150. <label for="satuan" class="col-sm-2 control-label">Satuan</label>
  151. <div class="col-sm-4">
  152. <input type="text" name="satuan" class="form-control" id="satuan" placeholder="-" value="" readonly required>
  153. </div>
  154. </div>
  155.  
  156. <button type="submit" name="submit" class="btn btn-success">Tambah</button>
  157. <hr>
  158. <div ><input type="text" class="hidden" name="id_sub" id="id_sub"></div>
  159. </form>
  160. <div >
  161.  
  162. <table class="table table-bordered">
  163. <thead>
  164. <tr class="info">
  165. <th width="5%">No</th>
  166. <th width="10%">Nota</th>
  167. <th width="10%">Kode Barang</th>
  168. <th width="22%">Nama Barang</th>
  169. <th width="10%">Jenis</th>
  170. <th width="10%">satuan</th>
  171. <th width="10%">permintaan</th>
  172. <th width="20%">Tindakan</th>
  173. </tr>
  174. </thead>
  175.  
  176. <tbody>
  177. <?php
  178. $id_user = $_SESSION['id_user'];
  179. $sql = mysqli_query($koneksi, "SELECT * FROM semi where id_user='$id_user' ORDER BY id_user DESC");
  180. if(mysqli_num_rows($sql) > 0){
  181. $no = 0;
  182.  
  183. while($row = mysqli_fetch_array($sql)){
  184. $no++;
  185. echo '
  186.  
  187. <tr>
  188. <td>'.$no.'</td>
  189. <td>'.$row['trx'].'</td>
  190. <td>'.$row['id_barang'].'</td>
  191. <td>'.$row['nama_barang'].'</td>
  192. <td>'.$row['jenis_barang'].'</td>
  193. <td>'.$row['satuan'].'</td>
  194. <td>'.$row['permintaan'].'</td>
  195. <td>';
  196. echo'
  197.  
  198.  
  199. <script type="text/javascript" language="JavaScript">
  200. function konfirmasi(){
  201. tanya = confirm("Anda yakin akan menghapus data ini?");
  202. if (tanya == true) return true;
  203. else return false;
  204. }
  205. </script>
  206.  
  207. <a href="?hlm=transaksi&aksi=edit&id_semi='.$row['id_sub'].'" class="btn btn-warning btn-s">Edit</a>
  208. <a href="?hlm=transaksi&aksi=hapus&submit=yes&id_semi='.$row['id_sub'].'" onclick="return konfirmasi()" class="btn btn-danger btn-s">Hapus</a>
  209.  
  210. </td>';
  211. }
  212. }
  213.  
  214. ?>
  215.  
  216. </tr>
  217.  
  218. </tbody>
  219.  
  220. </div>
  221.  
  222. </div>
  223.  
  224. </form>
  225.  
  226.  
  227.  
  228.  
  229.  
  230. <?php
  231. }
  232. }
  233. ?>
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!