Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $s='';
- if(isset($_GET['act']) && $_GET['act'] == 'input')
- {
- $s.= '<h2><img src="../gambar/barang.png" width="44" height="44"/> Master Barang</h2>';
- $s.= '<hr>';
- $s.= '<fieldset><legend><b>Form Input Barang</b></legend>';
- $s.= '<td> </td>';
- $s.= "<form enctype='multipart/form-data' name='form1' method='post' action='home.php?module=inputbarang&act=input_brg'>
- <table border='0'>
- <tr>
- <td>Jenis Barang</td>
- <td>: <select name='jenis'><option value='0'>Pilih Jenis</option>";
- $query = "SELECT * FROM tbl_jenis";
- $hasil = mysql_query($query);
- while ($data = mysql_fetch_array($hasil))
- {
- $s.= "<option value=$data[kode_jenis]>$data[jenis_barang]</option>";
- }
- $s.= "
- </select>
- </td>
- <td> </td>
- <td> </td>
- <td> </td>
- <td>ID Barang</td>
- <td>: <input type=text name=id_barang></td>
- </tr>
- <tr>
- <td>Nama Barang</td>
- <td>: <input type=text name=barang></td>
- <td> </td>
- <td> </td>
- <td> </td>
- <td>Jumlah Barang</td>
- <td>: <input type=text name=jumlah></td>
- </tr>
- <tr>
- <td>Tanggal Pengadaan</td>
- <td>: <input type=text name=pengadaan id=tanggal></td>
- $(function() {
- $('tanggal').datepicker();
- <td> </td>
- <td> </td>
- <td> </td>
- <td>No. Inventaris</td>
- <td>: <input type=text name=nomor></td>
- </tr>
- <tr>
- <td>Lokasi Barang</td>
- <td>: <select name='idlokasi' id='idlokasi'><option value='0'>Pilih Lokasi</option>
- ";
- $qryjurusan = mysql_query("select * from tbl_jurusan");
- while($datajurusan=mysql_fetch_array($qryjurusan)){
- $s.= "<option value='$datajurusan[kode_jurusan]'>$datajurusan[nama_jurusan]</option>";
- }
- $s.= "
- </select>
- </td>
- <td> </td>
- <td> </td>
- <td> </td>
- <td>Foto</td>
- <td>: <input type='hidden' name='MAX_FILE_SIZE' value='400000'><input name='fupload' type='file'></td>
- </tr>
- <tr>
- <td>Status</td>
- <td>: <select name='idstatus' id='idstatus'><option value='0'>Kondisi</option>
- <option value='Baik'>Baik</option>
- <option value='Rusak'>Rusak</option>
- </select>
- </td>
- </tr>
- <tr>
- <td> </td><td> <input type=submit name=submit value=Tambah>
- <input type=reset name=reset value=Batal onclick='javascript:history.go(-1)'></td>
- </tr>
- </table>
- </fieldset>
- </form>";
- }
- elseif(isset($_GET['act']) && $_GET['act'] == 'input_brg')
- {
- $lokasi_file= $_FILES["fupload"]["tmp_name"];
- $nama_file = $_FILES["fupload"]["name"];
- $tipe_file = $_FILES["fupload"]["type"];
- $direktori = "../img_upload/$nama_file";
- if(move_uploaded_file($lokasi_file, $direktori))
- {
- }
- $sql="INSERT INTO tbl_barang values ('$_POST[id_barang]',
- '$_POST[jenis]',
- '$_POST[barang]',
- '$_POST[jumlah]',
- '".date("Y-m-d", strtotime($_POST[pengadaan])."',
- '$_POST[nomor]',
- '$nama_file',
- '$_POST[idlokasi]',
- '$_POST[idstatus]',
- '$_SESSION[id_user]'";
- die($sql);
- /*
- check sql kamu dan pastikan dgn input langsung pake phpmyadmin
- kalau hasilnya error.. coba cari apa input yg harus masuk dan edit
- $sql di atas
- */
- $r=mysql_query($sql) or die (mysql_error().$sql);
- header('location:home.php?module=inputbarang');
- exit();
- }
- elseif(isset($_GET['act']) && $_GET['act'] == 'edit')
- {
- //query untuk prose update/edit barang
- $_SESSION['id_barang'] = $_GET['id'];
- $sql = mysql_query("SELECT * FROM tbl_barang WHERE id_barang='$_GET[id]'");
- $arr = mysql_fetch_array($sql);
- $s.= '<h2>Edit Data Barang</h2>';
- $s.= '<fieldset><legend>Form Edit Data Barang</legend>';
- $s.= "<form enctype='multipart/form-data' name='form1' method='post' action='home.php?module=inputbarang&act=edit_brg'>
- <table border='0'>
- <tr>
- <td>Jenis Barang</td>
- <td>: <select name='jenis'>";
- $query = "SELECT * FROM tbl_jenis";
- $hasil = mysql_query($query);
- while ($data = mysql_fetch_array($hasil))
- {
- if($data['kode_jenis'] == $arr['jenis_barang'])
- {
- $selected = "selected='selected'";
- }
- else
- {
- $selected = "";
- }
- $s.= "<option value='$data[kode_jenis]' $selected>$data[jenis_barang]</option>";
- }
- $s.= "
- </select>
- </td>
- <td> </td>
- <td> </td>
- <td> </td>
- <td>ID Barang</td>
- <td>: <input type=text name=id_barang value='$arr[id_barang]'></td>
- </tr>
- <tr>
- <td>Nama Barang</td>
- <td>: <input type=text name=barang value='$arr[nama_barang]'></td>
- <td> </td>
- <td> </td>
- <td> </td>
- <td>Jumlah Barang</td>
- <td>: <input type=text name=jumlah value='$arr[jml_brg]'></td>
- </tr>
- <tr>
- <td>Tanggal Pengadaan</td>
- <td>: <input type=text name=pengadaan value='$arr[tgl_pengadaan]'></td>
- <td> </td>
- <td> </td>
- <td> </td>
- <td>No. Inventaris</td>
- <td>: <input type=text name=nomor value='$arr[no_inventaris]'></td>
- </tr>
- <tr>
- <td>Lokasi Barang</td>
- <td>: <select name='idlokasi' id='idlokasi'>
- ";
- $qryjurusan = mysql_query("select * from tbl_jurusan");
- while($datajurusan=mysql_fetch_array($qryjurusan)){
- if($datajurusan['kode_jurusan'] == $arr['jurusan'])
- {
- $selected2 = "selected='selected'";
- }
- else
- {
- $selected2 = "";
- }
- $s.= "<option value='$datajurusan[kode_jurusan]' $selected2>$datajurusan[nama_jurusan]</option>";
- }
- $s.= "
- </select>
- </td>
- </tr>
- <tr>
- <td>Foto</td>
- <td>: <input type='hidden' name='MAX_FILE_SIZE' value='400000'><input name='fupload' type='file'></td>
- </tr>
- <tr>
- <td> </td>
- <td> <img src='../img_upload/$arr[foto]' /></td>
- </tr>
- <tr>
- <td>Status</td>
- <td>:
- <select name='idstatus' id='idstatus'><option value='0'>Kondisi</option>";
- if($arr['status'] == 'Baik')
- {
- $s.= " <option value='Baik' selected='selected'>Baik</option>
- <option value='Rusak'>Rusak</option>";
- }
- else
- {
- $s.= " <option value='Baik'>Baik</option>
- <option value='Rusak' selected='selected'>Rusak</option>";
- }
- $s.= "
- </select>
- </td>
- </tr>
- <tr>
- <td> </td><td> <input type=submit name=submit value=Tambah>
- <input type=reset name=reset value=Batal onclick='javascript:history.go(-1)'></td>
- </tr>
- </table>
- </fieldset>
- </form>";
- }
- elseif(isset($_GET['act']) && $_GET['act'] == 'edit_brg')
- {
- $lokasi_file= $_FILES["fupload"]["tmp_name"];
- $nama_file = $_FILES["fupload"]["name"];
- $tipe_file = $_FILES["fupload"]["type"];
- $direktori = "../gambar/$nama_file";
- if(move_uploaded_file($lokasi_file, $direktori))
- {
- }
- if(empty($lokasi_file))
- {
- $sql="UPDATE tbl_barang SET id_barang ='$_POST[id_barang]',
- jenis_barang ='$_POST[jenis]',
- nama_barang ='$_POST[barang]',
- jml_brg ='$_POST[jumlah]',
- tgl_pengadaan ='$_POST[pengadaan]',
- no_inventaris ='$_POST[nomor]',
- jurusan ='$_POST[idlokasi]',
- status ='$_POST[idstatus]',
- user ='$_SESSION[id_user]'
- id_barang ='$_SESSION[id_barang]'";
- $r=mysql_query($sql) or die (mysql_error().$sql);
- header('location:home.php?module=inputbarang');
- exit();
- }
- else
- {
- $sql=mysql_query("UPDATE tbl_barang SET id_barang='$_POST[id_barang]',
- jenis_barang ='$_POST[jenis]',
- nama_barang ='$_POST[barang]',
- jml_brg ='$_POST[jumlah]',
- tgl_pengadaan ='$_POST[pengadaan]',
- no_inventaris ='$_POST[nomor]',
- foto ='$nama_file',
- jurusan ='$_POST[idlokasi]',
- status ='$_POST[idstatus]',
- user ='$_SESSION[id_user]'
- WHERE id_barang ='$_SESSION[id_barang]'") or die (mysql_error());
- header('location:home.php?module=inputbarang');
- exit();
- }
- }
- elseif(isset($_GET['act']) && $_GET['act'] == 'delete')
- {
- //query untuk prose penghapusan data
- $sql=mysql_query("DELETE FROM tbl_barang WHERE id_barang='$_GET[id]'") or die (mysql_error());
- header('location:home.php?module=inputbarang');
- exit();
- }
- else
- {
- unset($_SESSION['id_barang']);
- $s.= '<h2>Daftar Data Barang</h2>';
- $s.= '<hr>';
- $s.= '<a href=home.php?module=inputbarang&act=input>Tambah Data Barang</a>';
- isset($_GET['hal']) ? $hal = $_GET['hal'] : $hal = 1;
- $batas = 4;
- if(! isset($hal))
- {
- $posisi = 0;
- }
- else
- {
- $posisi =($hal-1) * $batas;
- }
- //proses tampil data barang
- $tampil_data = mysql_query("SELECT * FROM tbl_barang ORDER BY id_barang ASC limit $posisi, $batas") or die ('Mysql Error'.mysql_error());
- // cek jumlah data dalam tabel database
- $jml_data = mysql_num_rows ($tampil_data);
- // jika ada data
- if($jml_data > 0)
- {
- $s.= '<fieldset><table border="1">
- <tr>
- <th>No.</th>
- <th>ID Barang</th>
- <th>Jenis Barang</th>
- <th>Nama Barang</th>
- <th>Jlh. Barang</th>
- <th>Tgl. Pengadaan</th>
- <th>No. Inventaris</th>
- <th>Unit Barang</th>
- <th>Kondisi Barang</th>
- <th>Foto Barang</th>
- <th>Aksi</th>
- </tr></fieldset>';
- $no = $posisi + 1 ;
- while($data_user = mysql_fetch_array($tampil_data))
- {
- if($no%2==0) $bg='#cccccc'; else $bg ='#99FFCC';
- $s.= "<tr bgcolor='".$bg."'>
- <td>$no</td>
- <td>$data_user[id_barang]</td>
- <td>$data_user[jenis_barang]</td>
- <td>$data_user[nama_barang]</td>
- <td>$data_user[jml_brg]</td>
- <td>$data_user[tgl_pengadaan]</td>
- <td>$data_user[no_inventaris]</td>
- <td>$data_user[jurusan]</td>
- <td>$data_user[status]</td>
- <td>$data_user[foto]</td>
- <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> |
- <a href=home.php?module=inputbarang&act=delete&id=$data_user[id_barang]><img src='../gambar/close.png' width=16 height=16/> Hapus</td>
- </tr>";
- $no++;
- }
- $s.= '</table>';
- $qrypaging = mysql_query("select * from tbl_barang");
- $jmlpaging = mysql_num_rows($qrypaging);
- if($jmlpaging > $batas)
- {
- $linkpaging = $jmlpaging - $batas;
- if($linkpaging < $jmlpaging) $linkpaging -= 1;
- for($i=1; $i<=$linkpaging;$i++)
- {
- if($hal != $i)
- {
- $s.= " <a href='home.php?module=inputbarang&hal=$i'>$i</a>";
- }
- else
- {
- $s.= " $i";
- }
- }
- }
- }
- else
- {
- $s.= '<p>Data Tidak ditemukan</p>';
- }
- }
- ?>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- <title></title>
- </head>
- <script language="JavaScript">
- function konfirmasi(id_barang)
- {
- tanya = confirm('Anda yakin ingin menghapus barang '+ id_barang + '?');
- if (tanya == true) return true;
- else return false;
- }
- </script>
- <script type="text/javascript" src="jquery.min.js"></script>
- <script type="text/javascript" src="jquery.ui.min.js"></script>
- <script language=javascript>
- $(document).ready(function(){
- $("#tanggal").click(function(){
- $(this).datepicker();
- })
- });
- <body>
- <?=$s;?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement