API tools faq
paste
Chilo

inputbarang.php

Chilo
May 28th, 2012
95
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.06 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. if(isset($_GET['act']) && $_GET['act'] == 'input')
  3. {
  4. echo '<h2><img src="../gambar/barang.png" width="44" height="44"/> Master Barang</h2>';
  5. echo '<hr>';
  6. echo '<fieldset><legend><b>Form Input Barang</b></legend>';
  7. echo '<td>&nbsp;</td>';
  8. echo "<form enctype=\"multipart/form-data\" name='form1' method='post' action='home.php?module=inputbarang&act=input_brg'>
  9. <table border='0'>
  10. <tr>
  11. <td>Jenis Barang</td>
  12. <td>: <select name='jenis'><option value='0'>Pilih Jenis</option>";
  13. $query = "SELECT * FROM tbl_jenis";
  14. $hasil = mysql_query($query);
  15. while ($data = mysql_fetch_array($hasil))
  16. {
  17. echo "<option value=$data[kode_jenis]>$data[jenis_barang]</option>";
  18. }
  19. echo "
  20. </select>
  21. </td>
  22. <td>&nbsp;</td>
  23. <td>&nbsp;</td>
  24. <td>&nbsp;</td>
  25. <td>ID Barang</td>
  26. <td>: <input type=text name=id_barang></td>
  27. </tr>
  28. <tr>
  29. <td>Nama Barang</td>
  30. <td>: <input type=text name=barang></td>
  31. <td>&nbsp;</td>
  32. <td>&nbsp;</td>
  33. <td>&nbsp;</td>
  34. <td>Jumlah Barang</td>
  35. <td>: <input type=text name=jumlah></td>
  36. </tr>
  37. <tr>
  38. <td>Tanggal Pengadaan</td>
  39. <td>: <input type=text name=pengadaan id=tanggal></td>
  40. $(function() {
  41. $(\"tanggal\").datepicker();
  42. <td>&nbsp;</td>
  43. <td>&nbsp;</td>
  44. <td>&nbsp;</td>
  45. <td>No. Inventaris</td>
  46. <td>: <input type=text name=nomor></td>
  47. </tr>
  48. <tr>
  49. <td>Lokasi Barang</td>
  50. <td>: <select name=\"idlokasi\" id=\"idlokasi\"><option value='0'>Pilih Lokasi</option>
  51. ";
  52. $qryjurusan = mysql_query("select * from tbl_jurusan");
  53. while($datajurusan=mysql_fetch_array($qryjurusan)){
  54. echo "<option value=\"$datajurusan[kode_jurusan]\">$datajurusan[nama_jurusan]</option>";
  55. }
  56. echo "
  57. </select>
  58. </td>
  59. <td>&nbsp;</td>
  60. <td>&nbsp;</td>
  61. <td>&nbsp;</td>
  62. <td>Foto</td>
  63. <td>: <input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"400000\"><input name=\"fupload\" type=\"file\"></td>
  64. </tr>
  65. <tr>
  66. <td>Status</td>
  67. <td>: <select name=\"idstatus\" id=\"idstatus\"><option value=\"0\">Kondisi</option>
  68. <option value=\"Baik\">Baik</option>
  69. <option value=\"Rusak\">Rusak</option>
  70. </select>
  71. </td>
  72. </tr>
  73. <tr>
  74. <td>&nbsp;</td><td>&nbsp; <input type=submit name=submit value=Tambah>
  75. <input type=reset name=reset value=Batal onclick=\"javascript:history.go(-1)\"></td>
  76. </tr>
  77. </table>
  78. </fieldset>
  79. </form>";
  80.  
  81. }
  82. elseif(isset($_GET['act']) && $_GET['act'] == 'input_brg')
  83. {
  84. $lokasi_file= $_FILES["fupload"]["tmp_name"];
  85. $nama_file = $_FILES["fupload"]["name"];
  86. $tipe_file = $_FILES["fupload"]["type"];
  87. $direktori = "../img_upload/$nama_file";
  88. if(move_uploaded_file($lokasi_file, $direktori))
  89. {
  90.  
  91. }
  92. $sql=mysql_query("INSERT INTO tbl_barang SET id_barang ='$_POST[id_barang]',
  93. jenis_barang ='$_POST[jenis]',
  94. nama_barang ='$_POST[barang]',
  95. jml_brg ='$_POST[jumlah]',
  96. tgl_pengadaan ='$_POST[pengadaan]',
  97. no_inventaris ='$_POST[nomor]',
  98. foto ='$nama_file',
  99. jurusan ='$_POST[idlokasi]',
  100. status ='$_POST[idstatus]',
  101. user ='$_SESSION[id_user]'") or die (mysql_error());
  102. header('location:home.php?module=inputbarang');
  103. exit();
  104. }
  105. elseif(isset($_GET['act']) && $_GET['act'] == 'edit')
  106. {
  107. //query untuk prose update/edit barang
  108. $_SESSION['id_barang'] = $_GET['id'];
  109. $sql = mysql_query("SELECT * FROM tbl_barang WHERE id_barang='$_GET[id]'");
  110. $arr = mysql_fetch_array($sql);
  111. echo '<h2>Edit Data Barang</h2>';
  112. echo '<fieldset><legend>Form Edit Data Barang</legend>';
  113. echo "<form enctype=\"multipart/form-data\" name='form1' method='post' action='home.php?module=inputbarang&act=edit_brg'>
  114. <table border='0'>
  115. <tr>
  116. <td>Jenis Barang</td>
  117. <td>: <select name='jenis'>";
  118. $query = "SELECT * FROM tbl_jenis";
  119. $hasil = mysql_query($query);
  120. while ($data = mysql_fetch_array($hasil))
  121. {
  122. if($data['kode_jenis'] == $arr['jenis_barang'])
  123. {
  124. $selected = "selected=\"selected\"";
  125. }
  126. else
  127. {
  128. $selected = "";
  129. }
  130. echo "<option value='$data[kode_jenis]' $selected>$data[jenis_barang]</option>";
  131. }
  132. echo "
  133. </select>
  134. </td>
  135. <td>&nbsp;</td>
  136. <td>&nbsp;</td>
  137. <td>&nbsp;</td>
  138. <td>ID Barang</td>
  139. <td>: <input type=text name=id_barang value='$arr[id_barang]'></td>
  140. </tr>
  141. <tr>
  142. <td>Nama Barang</td>
  143. <td>: <input type=text name=barang value='$arr[nama_barang]'></td>
  144. <td>&nbsp;</td>
  145. <td>&nbsp;</td>
  146. <td>&nbsp;</td>
  147. <td>Jumlah Barang</td>
  148. <td>: <input type=text name=jumlah value='$arr[jml_brg]'></td>
  149. </tr>
  150. <tr>
  151. <td>Tanggal Pengadaan</td>
  152. <td>: <input type=text name=pengadaan value='$arr[tgl_pengadaan]'></td>
  153. <td>&nbsp;</td>
  154. <td>&nbsp;</td>
  155. <td>&nbsp;</td>
  156. <td>No. Inventaris</td>
  157. <td>: <input type=text name=nomor value='$arr[no_inventaris]'></td>
  158. </tr>
  159. <tr>
  160. <td>Lokasi Barang</td>
  161. <td>: <select name=\"idlokasi\" id=\"idlokasi\">
  162. ";
  163. $qryjurusan = mysql_query("select * from tbl_jurusan");
  164. while($datajurusan=mysql_fetch_array($qryjurusan)){
  165. if($datajurusan['kode_jurusan'] == $arr['jurusan'])
  166. {
  167. $selected2 = "selected=\"selected\"";
  168. }
  169. else
  170. {
  171. $selected2 = "";
  172. }
  173. echo "<option value=\"$datajurusan[kode_jurusan]\" $selected2>$datajurusan[nama_jurusan]</option>";
  174. }
  175. echo "
  176. </select>
  177. </td>
  178. </tr>
  179. <tr>
  180. <td>Foto</td>
  181. <td>: <input type=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"400000\"><input name=\"fupload\" type=\"file\"></td>
  182. </tr>
  183. <tr>
  184. <td>&nbsp;</td>
  185. <td> <img src='../img_upload/$arr[foto]' /></td>
  186. </tr>
  187. <tr>
  188. <td>Status</td>
  189. <td>:
  190. <select name=\"idstatus\" id=\"idstatus\"><option value=\"0\">Kondisi</option>";
  191. if($arr['status'] == 'Baik')
  192. {
  193. echo " <option value=\"Baik\" selected=\"selected\">Baik</option>
  194. <option value=\"Rusak\">Rusak</option>";
  195. }
  196. else
  197. {
  198. echo " <option value=\"Baik\">Baik</option>
  199. <option value=\"Rusak\" selected=\"selected\">Rusak</option>";
  200. }
  201. echo "
  202. </select>
  203. </td>
  204. </tr>
  205. <tr>
  206. <td>&nbsp;</td><td>&nbsp; <input type=submit name=submit value=Tambah>
  207. <input type=reset name=reset value=Batal onclick=\"javascript:history.go(-1)\"></td>
  208. </tr>
  209. </table>
  210. </fieldset>
  211. </form>";
  212. }
  213. elseif(isset($_GET['act']) && $_GET['act'] == 'edit_brg')
  214. {
  215. $lokasi_file= $_FILES["fupload"]["tmp_name"];
  216. $nama_file = $_FILES["fupload"]["name"];
  217. $tipe_file = $_FILES["fupload"]["type"];
  218. $direktori = "../gambar/$nama_file";
  219. if(move_uploaded_file($lokasi_file, $direktori))
  220. {
  221.  
  222. }
  223.  
  224. if(empty($lokasi_file))
  225. {
  226. $sql=mysql_query("UPDATE tbl_barang SET id_barang ='$_POST[id_barang]',
  227. jenis_barang ='$_POST[jenis]',
  228. nama_barang ='$_POST[barang]',
  229. jml_brg ='$_POST[jumlah]',
  230. tgl_pengadaan ='$_POST[pengadaan]',
  231. no_inventaris ='$_POST[nomor]',
  232. jurusan ='$_POST[idlokasi]',
  233. status ='$_POST[idstatus]',
  234. user ='$_SESSION[id_user]'
  235. id_barang ='$_SESSION[id_barang]'") or die (mysql_error());
  236. header('location:home.php?module=inputbarang');
  237. exit();
  238. }
  239. else
  240. {
  241. $sql=mysql_query("UPDATE tbl_barang SET id_barang='$_POST[id_barang]',
  242. jenis_barang ='$_POST[jenis]',
  243. nama_barang ='$_POST[barang]',
  244. jml_brg ='$_POST[jumlah]',
  245. tgl_pengadaan ='$_POST[pengadaan]',
  246. no_inventaris ='$_POST[nomor]',
  247. foto ='$nama_file',
  248. jurusan ='$_POST[idlokasi]',
  249. status ='$_POST[idstatus]',
  250. user ='$_SESSION[id_user]'
  251. WHERE id_barang ='$_SESSION[id_barang]'") or die (mysql_error());
  252. header('location:home.php?module=inputbarang');
  253. exit();
  254. }
  255. }
  256. elseif(isset($_GET['act']) && $_GET['act'] == 'delete')
  257. {
  258. //query untuk prose penghapusan data
  259. $sql=mysql_query("DELETE FROM tbl_barang WHERE id_barang='$_GET[id]'") or die (mysql_error());
  260. header('location:home.php?module=inputbarang');
  261. exit();
  262. }
  263. else
  264. {
  265. unset($_SESSION['id_barang']);
  266. echo '<h2>Daftar Data Barang</h2>';
  267. echo '<hr>';
  268. echo '<a href=home.php?module=inputbarang&act=input>Tambah Data Barang</a>';
  269. isset($_GET['hal']) ? $hal = $_GET['hal'] : $hal = 1;
  270. $batas = 4;
  271. if(! isset($hal))
  272. {
  273. $posisi = 0;
  274. }
  275. else
  276. {
  277. $posisi =($hal-1) * $batas;
  278. }
  279. //proses tampil data barang
  280. $tampil_data = mysql_query("SELECT * FROM tbl_barang ORDER BY id_barang ASC limit $posisi, $batas") or die ('Mysql Error'.mysql_error());
  281.  
  282. // cek jumlah data dalam tabel database
  283. $jml_data = mysql_num_rows ($tampil_data);
  284.  
  285. // jika ada data
  286. if($jml_data > 0)
  287. {
  288.  
  289. echo '<fieldset><table border="1">
  290. <tr>
  291. <th>No.</th>
  292. <th>ID Barang</th>
  293. <th>Jenis Barang</th>
  294. <th>Nama Barang</th>
  295. <th>Jlh. Barang</th>
  296. <th>Tgl. Pengadaan</th>
  297. <th>No. Inventaris</th>
  298. <th>Unit Barang</th>
  299. <th>Kondisi Barang</th>
  300. <th>Foto Barang</th>
  301. <th>Aksi</th>
  302. </tr></fieldset>';
  303. $no = $posisi + 1 ;
  304. while($data_user = mysql_fetch_array($tampil_data))
  305. {
  306. if($no%2==0) $bg='#cccccc'; else $bg ='#99FFCC';
  307. echo "<tr bgcolor='".$bg."'>
  308. <td>$no</td>
  309. <td>$data_user[id_barang]</td>
  310. <td>$data_user[jenis_barang]</td>
  311. <td>$data_user[nama_barang]</td>
  312. <td>$data_user[jml_brg]</td>
  313. <td>$data_user[tgl_pengadaan]</td>
  314. <td>$data_user[no_inventaris]</td>
  315. <td>$data_user[jurusan]</td>
  316. <td>$data_user[status]</td>
  317. <td>$data_user[foto]</td>
  318. <td><a href=home.php?module=inputbarang&act=edit&id=$data_user[id_barang]><img src='../gambar/My Computer_2.png' width=\"17\" height=\"17\" /> Edit</a> |
  319. <a href=home.php?module=inputbarang&act=delete&id=$data_user[id_barang]><img src='../gambar/close.png' width=16 height=16/> Hapus</td>
  320. </tr>";
  321. $no++;
  322. }
  323. echo '</table>';
  324. $qrypaging = mysql_query("select * from tbl_barang");
  325. $jmlpaging = mysql_num_rows($qrypaging);
  326. if($jmlpaging > $batas)
  327. {
  328. $linkpaging = $jmlpaging - $batas;
  329. if($linkpaging < $jmlpaging) $linkpaging -= 1;
  330. for($i=1; $i<=$linkpaging;$i++)
  331. {
  332. if($hal != $i)
  333. {
  334. echo " <a href='home.php?module=inputbarang&hal=$i'>$i</a>";
  335. }
  336. else
  337. {
  338. echo " $i";
  339. }
  340. }
  341. }
  342. }
  343. else
  344. {
  345. echo '<p>Data Tidak ditemukan</p>';
  346. }
  347. }
  348. ?>
  349. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  350. <html xmlns="http://www.w3.org/1999/xhtml">
  351. <head>
  352. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  353. <title></title>
  354. </head>
  355. <script language="JavaScript">
  356. function konfirmasi(id_barang)
  357. {
  358. tanya = confirm('Anda yakin ingin menghapus barang '+ id_barang + '?');
  359. if (tanya == true) return true;
  360. else return false;
  361. }
  362. </script>
  363. <script type="text/javascript" src="jquery.min.js"></script>
  364. <script type="text/javascript" src="jquery.ui.min.js"></script>
  365. <script language=javascript>
  366. $(document).ready(function(){
  367. $("#tanggal").click(function(){
  368. $(this).datepicker();
  369. })
  370. });
  371. <body>
  372. </body>
  373. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!