API tools faq
paste
Advertisement
benchmark

koding kolom1.php

benchmark
Feb 26th, 2014
100
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 20.80 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. error_reporting(0);
  3. include '../config/koneksi.php';
  4. session_start();
  5. if  (empty($_SESSION[nama_user]) AND empty($_SESSION[pass_user]))
  6. {
  7.         echo "<h2>Maaf, akses langsung ke alamat ini Tidak di Ijinkan !!! </h2>";
  8.  
  9. echo "<a href='../tampil.php?page=beranda'>Silakan Kembali Ke Beranda</a>";    
  10. }
  11. else
  12. {
  13.     if  ($_GET[page]=='home')  
  14.     {
  15.         echo"<center><h2>Selamat datang di Halaman Administrator</h2>
  16.               Silahkan pilih menu di atas untuk aplikasi admin !</center>";
  17.     }
  18.    
  19.     //master barang
  20.     if  ($_GET[page]=='m_barang')  
  21.     {
  22.         echo "<center><h2>Data Master Barang</h2>";
  23.         echo "<table>
  24.                 <!--<button onclick=window.location.href='?page=tambah_m_barang'>TAMBAH BARANG</button>//-->
  25.                 <tr><th>Id Barang</th><th>Nama Barang</th><th>Merek</th><th>Tgl_Pengadaan</th><th>Spesifikasi</th><th>Id Status barang</th><th>Id Tipe</th><th>Edit</th><th>Del</th></tr>";
  26.         $qry=mysql_query("select * FROM barang") or die("Ada kesalahan tabel");
  27.         while($d=mysql_fetch_array($qry)){
  28.             echo "<tr><td>$d[id_barang]</td><td>$d[nama_barang]</td><td>$d[merek]</td><td>$d[tgl_pengadaan]</td>
  29.                   <td>$d[spesifikasi]</td><td>$d[id_status]</td><td>$d[id_tipe]</td>
  30.                   <td><a href=?page=edit_m_barang&id=$d[id_barang]>Edit</a></td>
  31.                   <td><a href=\"aksi.php?page=hapus_m_barang&id=$d[id_barang]\"
  32.                       onclick=\"return confirm ('Apakah Anda benar-benar akan menghapus $d[nama_barang]?')\">Hapus</a></td>                
  33.                     </tr>";                
  34.         }
  35.         echo "</table>
  36.         <button onclick=window.location.href='?page=tambah_m_barang'>TAMBAH BARANG</button></center>";
  37.     }
  38.     //end master barang
  39.    
  40.     //tambah master barang
  41.     $query=mysql_query("select from tipe");
  42.     if  ($_GET[page]=='tambah_m_barang')  
  43.     {
  44.         echo "<center><h2>TAMBAH Master Barang</h2>
  45.             <form action='aksi.php?page=tambah_m_barang' method=POST>
  46.                 <table>
  47.                 <tr><td>Id Barang</td><td>  <input type=text name=id_barang value='$d[id_barang]'> </td></tr>
  48.                 <tr><td>Nama Barang</td><td>    <input type=text name=nama_barang></td></tr>
  49.                 <tr><td>Merek</td><td>          <input type=text name=merek></td></tr>
  50.                 <tr><td>Tgl Pengadaan</td><td>  <input type=text name=tgl_pengadaan> thn-bln-tgl </td></tr>
  51.                 <tr><td>Spesifikasi</td><td>    <input type=text name=spesifikasi></td></tr>
  52.                 <tr><td>Id Status barang</td><td> <input type=text name=id_status_barang></td></tr>
  53.                
  54.                
  55.                 <tr><td>Id Tipe</td><td>              
  56.                                   <select name="id_tipe">
  57.                                      <option value="#">Type</option>
  58.                                      <?php while($drop=mysql_fetch_array($query)){?>
  59.                                       <option value="<?php $drop['id_type'];?>"><?php echo $drop['type'];?>
  60.                                       <?php }?>
  61.                                    </select>
  62.                                 </td></tr>
  63.                                 <tr><td></td><td><input type=submit value=SIMPAN></td></tr>    
  64.                                 </table>
  65.                         </form> </center>";
  66.     }
  67.     //end tambah master barang
  68.    
  69.     //edit master barang
  70.     if  ($_GET[page]=='edit_m_barang')  
  71.     {
  72.         $qry=mysql_query("select * FROM barang where id_barang=$_GET[id]") or die("Ada kesalahan tabel");
  73.         while($d=mysql_fetch_array($qry)){
  74.             echo "<center><h2>EDIT Master Barang</h2>      
  75.             <form action='aksi.php?page=simpan_edit_m_barang' method=POST>
  76. <table>
  77. <tr><td>Id Barang</td>          <td><input type=text name=id_barang     value='$d[id_barang]'> </td></tr>              
  78. <tr><td>Nama Barang</td>        <td><input type=text name=nama_barang   value='$d[nama_barang]'> </td></tr>
  79. <tr><td>merek</td>              <td><input type=text name=merek         value='$d[merek]'></td></tr>
  80. <tr><td>Tgl Pengadaan</td>      <td><input type=text name=tgl_pengadaan value='$d[tgl_pengadaan]'> thn-bln-tg </td></tr>
  81. <tr><td>Spesifikasi</td>        <td><input type=text name=spesifikasi   value='$d[spesifikasi]'></td></tr>
  82. <tr><td>Id Status barang</td>   <td><input type=text name=id_status     value='$d[id_status]'></td></tr>
  83. <tr><td>Id Tipe</td>            <td><input type=text name=id_tipe       value='$d[id_tipe]'></td></tr>
  84. <tr><td></td>                   <td><input type=submit                  value=SIMPAN></td></tr>
  85. </table>
  86.                                 <input type=hidden name=id_barang value=$_GET[id]>
  87.             </form> </center>";
  88.         }  
  89.     }
  90.     //end edit master barang
  91.    
  92.     //master status barang
  93.     if  ($_GET[page]=='m_status_barang')  
  94.     {
  95.         echo "<center><h2>Data Status Barang</h2>";
  96.         echo "<table>
  97.                 <!--<button onclick=window.location.href='?page=tambah_m_status_barang'>TAMBAH STATUS BARANG</button>//-->
  98.                 <tr><th>Id Status Barang</th><th>Status Barang</th><th>Edit</th><th>Del</th></tr>";
  99.         $qry=mysql_query("select * FROM status_barang") or die("Ada kesalahan tabel");
  100.         while($d=mysql_fetch_array($qry)){
  101.             echo "<tr><td>$d[id_status_barang]</td><td>$d[status_barang]</td>
  102.             <td><a href=?page=edit_m_status_barang&id=$d[id_status_barang]>Edit</a></td>
  103.                   <td><a href=\"aksi.php?page=hapus_m_status_barang&id=$d[id_status_barang]\"
  104.                       onclick=\"return confirm ('Apakah Anda benar-benar akan menghapus $d[status_barang]?')\">Hapus</a></td>                  
  105.                     </tr>";                
  106.         }
  107.         echo "</table><button onclick=window.location.href='?page=tambah_m_status_barang'>TAMBAH STATUS BARANG</button></center>";
  108.     }
  109.     //end status barang
  110.  
  111.     //tambah status barang
  112.     if  ($_GET[page]=='tambah_m_status_barang')  
  113.     {
  114.         echo "<center><h2>Tambah Master Status Barang</h2>
  115.             <form action='aksi.php?page=tambah_m_status_barang' method=POST>
  116.                 <table>
  117.                 <tr><td>Id Status Barang</td><td>           <input type=text name=id_status_barang></td></tr>
  118.                 <tr><td>Status Barang</td><td>          <input type=text name=status_barang></td></tr>
  119.                 <tr><td></td><td><input type=submit value=SIMPAN></td></tr>
  120.                 </table>
  121.             </form> </center>";
  122.     }
  123.     //end tambah status barang
  124.    
  125.     //edit status barang
  126.     if  ($_GET[page]=='edit_m_status_barang')  
  127.     {
  128.         $qry=mysql_query("select * FROM status_barang where id_status_barang=$_GET[id]") or die("Ada kesalahan tabel");
  129.         while($d=mysql_fetch_array($qry)){
  130.             echo "<center><h2>EDIT Master Status Barang</h2>       
  131.             <form action='aksi.php?page=simpan_edit_m_status_barang' method=POST>
  132.                 <table>
  133.                
  134.                 <tr><td>Status Barang</td><td>  <input type=text name=status_barang value='$d[status_barang]'> </td></tr>
  135.                 <tr><td></td><td><input type=submit value=SIMPAN></td></tr>
  136.                 </table>
  137.                 <input type=hidden name=id_status_barang value=$_GET[id]>
  138.             </form> </center>";
  139.         }  
  140.     }
  141.     //end edit status barang
  142.        
  143.     // tipe barang
  144.     if  ($_GET[page]=='m_tipe')  
  145.     {
  146.         echo "<center><h2>Data Tipe Barang</h2>";
  147.         echo "<table>
  148.                 <!--<button onclick=window.location.href='?page=tambah_m_tipe'>TAMBAH TIPE BARANG</button>//-->
  149.                 <tr><th>Id Tipe</th><th>Tipe</th><th>Edit</th><th>Del</th></tr>";
  150.         $qry=mysql_query("select * FROM tipe") or die("Ada kesalahan tabel");
  151.         while($d=mysql_fetch_array($qry)){
  152.             echo "<tr><td>$d[id_tipe]</td><td>$d[tipe]</td>
  153.             <td><a href=?page=edit_m_tipe&id=$d[id_tipe]>Edit</a></td>
  154.                               <td><a href=\"aksi.php?page=hapus_m_tipe&id=$d[id_tipe]\"
  155.                       onclick=\"return confirm ('Apakah Anda benar-benar akan menghapus $d[tipe]?')\">Hapus</a></td>                   
  156.                     </tr>";                
  157.         }
  158.         echo "</table><button onclick=window.location.href='?page=tambah_m_tipe'>TAMBAH TIPE BARANG</button></center>";
  159.     }
  160.     //end tipe barang
  161.    
  162.     //tambah tipe barang
  163.     if  ($_GET[page]=='tambah_m_tipe')  
  164.     {
  165.         echo "<center><h2>TAMBAH Tipe Barang</h2>
  166.             <form action='aksi.php?page=tambah_m_tipe' method=POST>
  167.                 <table>
  168.                 <tr><td>Id Tipe</td><td>            <input type=text name=id_tipe></td></tr>
  169.                 <tr><td>Tipe</td><td>           <input type=text name=tipe></td></tr>
  170.                 <tr><td></td><td><input type=submit value=SIMPAN></td></tr>
  171.                 </table>
  172.             </form> </center>";
  173.     }
  174.     //end tambah tipe barang
  175.    
  176.     //edit tipe barang
  177.     if  ($_GET[page]=='edit_m_tipe')  
  178.     {
  179.         $qry=mysql_query("select * FROM tipe where id_tipe=$_GET[id]") or die("Ada kesalahan tabel");
  180.         while($d=mysql_fetch_array($qry)){
  181.             echo "<center><h2>EDIT Tipe Barang</h2>    
  182.             <form action='aksi.php?page=simpan_edit_m_tipe' method=POST>
  183.                 <table>
  184.                
  185.                 <tr><td>Tipe</td><td>           <input type=text name=tipe value='$d[tipe]'></td></tr>
  186.                 <tr><td></td><td><input type=submit value=SIMPAN></td></tr>
  187.                 </table>
  188.                 <input type=hidden name=id_tipe value=$_GET[id]>
  189.             </form></center>    ";
  190.         }  
  191.     }
  192.     //end edit tipe barang
  193.    
  194.     //master pegawai
  195.     if  ($_GET[page]=='m_pegawai')  
  196.     {
  197.         echo "<center><h2>Data Master Pegawai</h2>";
  198.         echo "<table>
  199.                 <!--<button onclick=window.location.href='?page=tambah_m_pegawai'>TAMBAH PEGAWAI</button>//-->
  200. <tr><th>Id Pegawai</th><th>Nama Pegawai</th><th>Alamat</th><th>No Hp</th><th>Lokasi</th><th>Nama Jabatan</th><th>Edit</th><th>Del</th></tr>";
  201.         $qry=mysql_query("select  p.id_pegawai,p.nama_pegawai,p.alamat,p.hp,p.lokasi, j.nama_jabatan
  202.  
  203. FROM pegawai p LEFT JOIN jabatan j ON p.id_jabatan=j.id_jabatan") or die("Ada kesalahan tabel");
  204.         while($d=mysql_fetch_array($qry)){
  205.             echo "<tr><td>$d[id_pegawai]</td><td>$d[nama_pegawai]</td><td>$d[alamat]</td><td>$d[hp]</td><td>$d[lokasi]</td><td>$d[nama_jabatan]</td>
  206.                   <td><a href=?page=edit_m_pegawai&id=$d[id_pegawai]>Edit</a></td>
  207.                   <td><a href=\"aksi.php?page=hapus_m_pegawai&id=$d[id_pegawai]\"
  208.                       onclick=\"return confirm ('Apakah Anda benar-benar akan menghapus $d[nama_pegawai]?')\">Hapus</a></td>                   
  209.                     </tr>";                
  210.        
  211.         }
  212.     echo "</table>
  213.     <button onclick=window.location.href='?page=tambah_m_pegawai'>TAMBAH PEGAWAI</button></center>";
  214.     }
  215.     //end master pegawai
  216.    
  217.     //tambah master pegawai
  218.    
  219.     if  ($_GET[page]=='tambah_m_pegawai')  
  220.     {
  221.         echo "<center><h2>TAMBAH DATA PEGAWAI</h2>
  222.             <form action='aksi.php?page=tambah_m_pegawai' method=POST>
  223.                 <table>
  224.                 <tr><td>Id Pegawai</td><td>     <input type=text name=id_pegawai></td></tr>
  225.                 <tr><td>Nama Pegawai</td><td>   <input type=text name=nama_pegawai></td></tr>
  226.                 <tr><td>Alamat</td><td>         <input type=text name=alamat></td></tr>
  227.                 <tr><td>No Hp</td><td>          <input type=text name=hp></td></tr>
  228.                 <tr><td>Lokasi</td><td>         <input type=text name=lokasi></td></tr>
  229.                 <tr><td>Id Jabatan</td><td>     <input type=text name=id_jabatan></td></tr>
  230.                 <tr><td></td><td><input type=submit value=SIMPAN></td></tr>
  231.                 </table>
  232.             </form> </center>";
  233.     }
  234.     //end tambah master pegawai
  235.    
  236.     //edit master pegawai
  237.    
  238.     if  ($_GET[page]=='edit_m_pegawai')  
  239.     {
  240.         $qry=mysql_query("select * FROM pegawai where id_pegawai=$_GET[id]") or die("Ada kesalahan tabel");
  241.         while($d=mysql_fetch_array($qry)){
  242.             echo "<center><h2>EDIT DATA PEGAWAI</h2>       
  243.             <form action='aksi.php?page=simpan_edit_m_pegawai' method=POST>
  244.                 <table>
  245.                 <tr><td>Id Pegawai</td>         <td><input type=text name=id_pegawai    value='$d[id_pegawai]'></td></tr>
  246.                 <tr><td>Nama Pegawai</td>       <td><input type=text name=nama_pegawai  value='$d[nama_pegawai]'></td></tr>
  247.                 <tr><td>Alamat</td>             <td><input type=text name=alamat        value='$d[alamat]'></td></tr>
  248.                 <tr><td>No Hp</td>              <td><input type=text name=hp            value='$d[hp]'></td></tr>
  249.                 <tr><td>Lokasi</td>             <td><input type=text name=lokasi        value='$d[lokasi]'></td></tr>
  250.                 <tr><td>Id Jabatan</td>         <td><input type=text name=id_jabatan    value='$d[id_jabatan]'></td></tr>
  251.                 <tr><td></td><td><input type=submit value=SIMPAN></td></tr>
  252.                 </table>
  253.                 <input type=hidden name=id_pegawai value=$_GET[id]>
  254.             </form></center>    ";
  255.         }  
  256.     }
  257.        
  258.     //end edit master pegawai
  259.    
  260.     //MASTER JABATAN
  261.    
  262.     if  ($_GET[page]=='m_jabatan')  
  263.     {
  264.         echo "<center><h2>Data Master Jabatan</h2>";
  265.         echo "<table>
  266.                 <!--<button onclick=window.location.href='?page=tambah_m_jabatan'>TAMBAH JABATAN</button>//-->
  267.                 <tr><th>Id Jabatan</th><th>Nama Jabatan</th><th>Edit</th><th>Del</th></tr>";
  268.         $qry=mysql_query("select * FROM jabatan") or die("Ada kesalahan tabel");
  269.         while($d=mysql_fetch_array($qry)){
  270.             echo "<tr><td>$d[id_jabatan]</td><td>$d[nama_jabatan]</td>
  271.                   <td><a href=?page=edit_m_jabatan&id=$d[id_jabatan]>Edit</a></td>
  272.                   <td><a href=\"aksi.php?page=hapus_m_jabatan&id=$d[id_jabatan]\"
  273.                       onclick=\"return confirm ('Apakah Anda benar-benar akan menghapus $d[nama_jabatan]?')\">Hapus</a></td>                   
  274.                     </tr>";                
  275.         }
  276.         echo "</table>
  277.         <button onclick=window.location.href='?page=tambah_m_jabatan'>TAMBAH JABATAN</button></center>";
  278.     }
  279.     //END MASTER JABATAN
  280.    
  281.     //TAMBAH MASTER JABATAN
  282.     if  ($_GET[page]=='tambah_m_jabatan')  
  283.     {
  284.         echo "<center><h2>TAMBAH MASTER JABATAN</h2>
  285.             <form action='aksi.php?page=tambah_m_jabatan' method=POST>
  286.                 <table>
  287.                 <tr><td>Id Jabatan</td><td> <input type=text name=id_jabatan value='$d[id_jabatan]'> </td></tr>
  288.                 <tr><td>Nama Jabatan</td><td>   <input type=text name=nama_jabatan value='$d[nama_jabatan]'> </td></tr>
  289.                
  290.                 <tr><td></td><td><input type=submit value=SIMPAN></td></tr>
  291.                 </table>
  292.             </form> </center>";
  293.     }
  294.     //END MASTER JABATAN
  295.    
  296.     //EDIT MASTER JABATAN
  297.     if  ($_GET[page]=='edit_m_jabatan')  
  298.     {
  299.         $qry=mysql_query("select * FROM jabatan where id_jabatan=$_GET[id]") or die("Ada kesalahan tabel");
  300.         while($d=mysql_fetch_array($qry)){
  301.             echo "<center><h2>EDIT MASTER JABATAN</h2>     
  302.             <form action='aksi.php?page=simpan_edit_m_jabatan' method=POST>
  303.                 <table>
  304. <tr><td>Id Jabatan</td><td> <input type=text name=id_jabatan value='$d[id_jabatan]'> </td></tr>            
  305. <tr><td>Nama Jabatan</td><td>   <input type=text name=nama_jabatan value='$d[nama_jabatan]'> </td></tr>
  306. <tr><td></td><td><input type=submit value=SIMPAN></td></tr>
  307.                 </table>
  308.                 <input type=hidden name=id_jabatan value=$_GET[id]>
  309.             </form> </center>";
  310.         }  
  311.     }
  312.     //END EDIT MASTER JABATAN
  313.    
  314.     // TRANSAKSI
  315.  
  316. if  ($_GET[page]=='m_transaksi')  
  317.     {
  318.         echo "<center><u><h2>Data Transaksi</h2></u>";
  319.         echo "<table>
  320.                 <!--<button onclick=window.location.href='?page=tambah_m_transaksi'>TAMBAH TRANSAKSI</button>//-->
  321.                 <tr><th>No Trans.</th><th>Tgl Terima</th><th>Pengguna Awal</th><th>Tgl Kembali</th><th>Pengguna Akhir</th><th>Administrator</th><th>Nama Barang</th><th>Status Barang</th><th>Merk Barang</th><th>Edit</th><th>Del</th></tr>";
  322.         $qry=mysql_query("select  transaksi.no_transaksi,transaksi.tgl_terima,pegawai.nama_pegawai,transaksi.tgl_kembali,pegawai.nama_pegawai,admin.nama_admin,barang.nama_barang,status_barang.status_barang,barang.merek
  323. FROM transaksi
  324. LEFT JOIN admin ON transaksi.id_admin=admin.id_admin
  325. LEFT JOIN barang ON transaksi.id_barang=barang.id_barang
  326. LEFT JOIN status_barang ON transaksi.id_status_barang=status_barang.id_status_barang
  327. LEFT JOIN pegawai ON transaksi.id_pegawai=pegawai.id_pegawai") or die("Ada kesalahan tabel");
  328.         while($d=mysql_fetch_array($qry)){
  329.             echo "<tr><td>$d[no_transaksi]</td><td>$d[tgl_terima]</td><td>$d[nama_pegawai]</td><td>$d[tgl_kembali]</td><td>$d[nama_pegawai]</td><td>$d[nama_admin]</td><td>$d[nama_barang]</td><td>$d[status_barang]</td><td>$d[merek]</td>
  330.             <td><a href=?page=edit_m_transaksi&id=$d[no_transaksi]>Edit</a></td>
  331.                   <td><a href=\"aksi.php?page=hapus_m_transaksi&id=$d[no_transaksi]\"
  332.                       onclick=\"return confirm ('Apakah Anda benar-benar akan menghapus $d[no_transaksi]?')\">Hapus</a></td>                   
  333.                     </tr>";                
  334.         }
  335.         echo "</table><button onclick=window.location.href='?page=tambah_m_transaksi'>TAMBAH TRANSAKSI</button></center>";
  336.     }
  337.  
  338. // TAMBAH TRANSAKSI
  339.    
  340. if  ($_GET[page]=='tambah_m_transaksi')  
  341.     {
  342.         echo "<h2>TAMBAH TRANSAKSI</h2>
  343.             <form action='aksi.php?page=tambah_m_transaksi' method=POST>
  344. <table>
  345. <tr><td>Nomor Transaksi</td><td>    <input type=text name=no_transaksi></td></tr>
  346. <tr><td>Id Admin</td><td>   <input type=text name=id_admin></td></tr>
  347. <tr><td>Id Pegawai</td><td>     <input type=text name=id_pegawai></td></tr>
  348. <tr><td>Id Pengguna Awal</td><td>   <input type=text name=id_pengguna_awal></td></tr>
  349. <tr><td>Id Barang</td><td>  <input type=text name=id_barang></td></tr>
  350. <tr><td>Tanggal Terima</td><td>     <input type=text name=tgl_terima> thn-bln-tgl </td></tr>
  351. <tr><td>Tanggal Kembali</td><td>    <input type=text name=tgl_kembali> thn-bln-tgl </td></tr>
  352. <tr><td>Id Pengguna Akhir</td><td>  <input type=text name=id_pengguna_akhir></td></tr>
  353. <tr><td>Id Status Barang</td><td>   <input type=text name=id_status_barang></td></tr>
  354. <tr><td></td><td><input type=submit value=SIMPAN></td></tr>
  355.                 </table>
  356.             </form> ";
  357.     }  
  358.  
  359. // EDIT TRANSAKSI
  360.  
  361. if  ($_GET[page]=='edit_m_transaksi')  
  362.     {
  363.         $qry=mysql_query("select * FROM transaksi where no_transaksi=$_GET[id]") or die("Ada kesalahan tabel");
  364.         while($d=mysql_fetch_array($qry)){
  365.             echo "<center><h2>EDIT DATA TRANSAKSI</h2>     
  366.             <form action='aksi.php?page=simpan_edit_m_transaksi' method=POST>
  367.                 <table>
  368.                 <tr><td>No. Transaksi</td>      <td>  <input type=text name=no_transaksi value='$d[no_transaksi]'> </td></tr>
  369.                 <tr><td>Nama Pengguna Awal</td> <td>  <input type=text name=id_pengguna_awal value='$d[id_pengguna_awal]'></td></tr>
  370.                 <tr><td>Tgl Terima</td>         <td>  <input type=text name=tgl_terima value='$d[tgl_terima]'></td></tr>
  371.                 <tr><td>Tgl Kembali</td>        <td>  <input type=text name=tgl_kembali value='$d[tgl_kembali]'></td></tr>
  372.                 <tr><td>Nama Pengguna Akhir</td><td>  <input type=text name=id_pengguna_akhir value='$d[id_pengguna_akhir]'></td></tr>
  373.                 <tr><td>Nama Administrator</td> <td>  <input type=text name=id_admin value='$d[id_admin]'></td></tr>
  374.                 <tr><td>Nama Barang</td>        <td>  <input type=text name=id_barang value='$d[id_barang]'></td></tr>
  375.                 <tr><td>Status Barang</td>      <td>  <input type=text name=id_status_barang value='$d[id_status_barang]'></td></tr>
  376.                 <tr><td>Merk Barang</td>        <td>  <input type=text name=merek value='$d[merek]'></td></tr>
  377.                
  378.                 <tr><td></td><td><input type=submit value=SIMPAN></td></tr>
  379.                 </table>
  380.                 <input type=hidden name=no_transaksi value=$_GET[id]>
  381.             </form></center>    ";
  382.         }  
  383.     }
  384.    
  385. //end edit transaksi
  386.    
  387.    
  388.     //cetak master barang
  389.  
  390.     if  ($_GET[page]=='cetak_barang')
  391. {
  392.     echo "<center><h2><u>DATA MASTER BARANG</u></h2></center>";
  393.     echo "<center>
  394.         <table>
  395.             <tr><th>Id barang</th><th>Nama Barang</th><th>Merek</th><th>Tgl Pengadaan</th><th>Spesifikasi</th>
  396.             <th>Status barang</th><th>Tipe</th></tr>";
  397.     $qry=mysql_query("select  b.id_barang,b.nama_barang,b.merek,b.tgl_pengadaan,b.spesifikasi,s.status_barang,t.tipe
  398.                         FROM barang b
  399.                         LEFT JOIN tipe t ON b.id_tipe=t.id_tipe
  400.                         LEFT JOIN status_barang s ON b.id_status=s.id_status_barang") or die("Ada kesalahan tabel");
  401.     while($d=mysql_fetch_array($qry)){
  402.         echo "<tr><td>$d[id_barang]</td><td>$d[nama_barang]</td><td>$d[merek]</td><td>$d[tgl_pengadaan]</td>
  403.                 <td>$d[spesifikasi]</td><td>$d[status_barang]</td><td>$d[tipe]</td></tr>";
  404.     }
  405.     echo "</table>";
  406.     echo "<br><button onclick=window.location.href='cetak_barang.php'>Cetak Ke Printer</button></br>";
  407. }
  408.  
  409. //end cetak master barang  
  410.  
  411. //cetak master pegawai
  412.  
  413. if  ($_GET[page]=='cetak_pegawai')
  414. {
  415.     echo "<center><h2><u>DATA MASTER PEGAWAI</u></h2></center>";
  416.     echo "<center>
  417.         <table>
  418.             <tr><th>Id Pegawai</th><th>Nama Pegawai</th><th>Alamat</th><th>No Hp</th><th>Lokasi</th><th>Jabatan</th></tr>";
  419.     $qry=mysql_query("select  p.id_pegawai,p.nama_pegawai,p.alamat,p.hp,p.lokasi, j.nama_jabatan
  420.                     FROM pegawai p LEFT JOIN jabatan j ON p.id_jabatan=j.id_jabatan") or die("Ada kesalahan tabel Bro");
  421.     while($d=mysql_fetch_array($qry)){
  422.         echo "<tr><td>$d[id_pegawai]</td><td>$d[nama_pegawai]</td><td>$d[alamat]</td><td>$d[hp]</td><td>$d[lokasi]</td><td>$d[nama_jabatan]</td></tr>";
  423.     }
  424.     echo "</table>";
  425.     echo "<br><button onclick=window.location.href='cetak_pegawai.php'>Cetak Ke Printer</button></br>";
  426. }
  427.  
  428. //end cetak master pegawai
  429.  
  430. //cetak transaksi
  431.  
  432. if  ($_GET[page]=='cetak_transaksi')
  433. {
  434.     echo "<center><h2><u>DATA TRANSAKSI</u></h2></center>";
  435.     echo "<center>
  436.         <table>
  437.             <tr><th>No Trans.</th><th>Tgl Terima</th><th>Pengguna Awal</th><th>Tgl Kembali</th><th>Pengguna Akhir</th><th>Nama Admin</th><th>Nama Barang</th><th>Status Barang</th><th>Merk Barang</th></tr>";
  438.     $qry=mysql_query("select  transaksi.no_transaksi,transaksi.tgl_terima,pegawai.nama_pegawai,transaksi.tgl_kembali,pegawai.nama_pegawai,admin.nama_admin,barang.nama_barang,status_barang.status_barang,barang.merek
  439. FROM transaksi
  440. LEFT JOIN admin ON transaksi.id_admin=admin.id_admin
  441. LEFT JOIN barang ON transaksi.id_barang=barang.id_barang
  442. LEFT JOIN status_barang ON transaksi.id_status_barang=status_barang.id_status_barang
  443. LEFT JOIN pegawai ON transaksi.id_pegawai=pegawai.id_pegawai") or die("Ada kesalahan tabel");
  444.     while($d=mysql_fetch_array($qry)){
  445.         echo "<tr><td>$d[no_transaksi]</td><td>$d[tgl_terima]</td><td>$d[nama_pegawai]</td><td>$d[tgl_kembali]</td><td>$d[nama_pegawai]</td><td>$d[nama_admin]</td><td>$d[nama_barang]</td><td>$d[status_barang]</td><td>$d[merek]</td></tr>";
  446.     }
  447.     echo "</table>";
  448.     echo "<br><button onclick=window.location.href='cetak_transaksi.php'>Cetak Ke Printer</button></br>";
  449. }
  450.  
  451. //end cetak transaksi
  452.  
  453.  
  454.  
  455.  
  456.  
  457.    
  458.  
  459.  
  460.  
  461.  
  462.  
  463. if  ($_GET[page]=='logout')
  464. {  
  465.         session_start();
  466.         session_destroy();
  467.         echo "Anda berhasil logout<br>";
  468.         echo "<a href='../tampil.php?page=beranda'>Kembali Ke Halaman Utama</a>";
  469. }
  470. }
  471.  
  472. ?>
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!