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> |