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