Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if( empty( $_SESSION['id_user'] ) ){
- $_SESSION['err'] = '<strong>ERROR!</strong> Anda harus login terlebih dahulu.';
- header('Location: ./');
- die();
- } else {
- if( isset( $_REQUEST['submit'] )){
- switch($aksi){
- case 'edit':
- include 'semi_edit.php';
- break;
- case 'hapus':
- include 'semi_hapus.php';
- break;
- }
- $id_barang = $_REQUEST['id_barang'];
- $nama_barang = $_REQUEST['nama_barang'];
- $id_semi = $_REQUEST['id_semi'];
- $trx = $_REQUEST['trx'];
- $tanggal = date('Y-m-H');
- $jenis_barang = $_REQUEST['jenis_barang'];
- $satuan = $_REQUEST['satuan'];
- $permintaan = $_REQUEST['permintaan'];
- $nama = $_SESSION['nama'];
- $koordinator = $_SESSION['koordinator'];
- $id_user = $_SESSION['id_user'];
- $sql = mysqli_query($koneksi, "INSERT INTO semi (trx,id_barang,nama_barang,tanggal,jenis_barang,satuan,permintaan,nama,koordinator,id_user) VALUES ('$trx','$id_barang','$nama_barang','$tanggal','$jenis_barang','$satuan','$permintaan','$nama','$koordinator','$id_user')");
- if($sql == true){
- header('Location: ./admin.php?hlm=transaksi&aksi=baru');
- die();
- } else {
- echo 'ERROR! Periksa penulisan querynya';
- }
- }
- if( isset( $_REQUEST['submit2'] )){
- switch($aksi){
- case 'edit':
- include 'semi_edit.php';
- break;
- case 'hapus':
- include 'semi_hapus.php';
- break;
- }
- $id_transaksi = ['id_transaksi'];
- $tanggal1 = date ("M-Y");
- $id_user = $_SESSION['id_user'];
- $nama = $_SESSION['nama'];
- $koordinator = $_SESSION['koordinator'];
- $nota = $_SESSION['nama']."-".$_SESSION['koordinator']."-". date("d")."-".date("M");
- $sql2 = mysqli_query($koneksi, "INSERT INTO transaksi (id_transaksi,nota,nama,koordinator,tanggal,id_user) VALUES ('$id_transaksi','$nota','$nama','$koordinator','$tanggal1','$id_user')");
- $id = $_REQUEST['trx'];
- $data = mysqli_query($koneksi,"SELECT trx,nama_barang,satuan,permintaan,tanggal,id_user,jenis_barang,id_barang,koordinator,nama,id_sub
- FROM semi WHERE trx='$id'");
- $d = mysqli_fetch_array($data);
- $id_sub = $d['id_sub'];
- $trx = $d['trx'];
- $nama_barang = $d['nama_barang'];
- $permintaan = $d['permintaan'];
- $tanggal = $d['tanggal'];
- $id_user = $d['id_user'];
- $koordinator = $d['koordinator'];
- $nama = $d['nama'];
- $jenis_barang = $d['jenis_barang'];
- $id_barang = $d['id_barang'];
- $satuan = $d['satuan'];
- foreach ($data as $value) {
- $sql = mysqli_query($koneksi, "INSERT INTO sub (nota, permintaan, nama_barang, tanggal, id_user, koordinator, nama, jenis_barang , id_barang,satuan)
- VALUES('$trx', '$permintaan', '$nama_barang', '$tanggal', '$id_user', '$koordinator', '$nama', '$jenis_barang', '$id_barang','$satuan' )");
- }
- $query = mysqli_query($koneksi, "DELETE FROM semi WHERE trx='$id'");
- if($query == true){
- header('Location: ./admin.php?hlm=transaksi');
- die();
- } else {
- echo'onclick="return konfirmasi()"';
- }
- }else {
- ?>
- <form method="post" action="" class="form-inline" role="form">
- <div ><br></div>
- <div class="form-group">
- <label for="nota" class="col-sm-2 control-label">No. Nota</label>
- <div class="col-sm-2"><div class="col-sm-2">
- <input type="text" name="trx" class="form-control" value="<?php echo $_SESSION['nama']."-".$_SESSION['koordinator']."-". date("d")."-".date("M") ?>" readonly>
- </div>
- </div>
- <div class="pull-right">
- <label for="koordinator" class="col-sm-4 control-label">Koordinator</label>
- <div class="col-sm-4">
- <h3>
- <?php echo $_SESSION['koordinator']; ?>
- </h3>
- </div>
- </div>
- </div>
- <div class="pull-right">
- <button type="submit" name="submit2" class="btn btn-primary">Simpan</button>
- <form action="" method="post" role="form" class="form-inline">
- <a href="./admin.php?hlm=transaksi" class="btn btn-danger btn-s "><span class=" pull-right"> Batal </span></a>
- </div>
- <br/><hr/>
- <form method="post" action="" class="form-inline" role="form">
- <div class="form-group">
- <label for="id_barang" class="col-sm-3 control-label">Kode Barang</label>
- <div class="col-sm-4">
- <input type="text" name="id_barang" class="form-control" id="id_barang" placeholder="Masukkan Kode Barang" onkeyup="autofill()" >
- </div>
- </div>
- <div class="form-group">
- <label for="nama_barang" class="col-sm-4 control-label">Nama Barang</label>
- <div class="col-sm-4">
- <input type="text" class="form-control" id="nama_barang" name="nama_barang" placeholder="Masukkan Nama Barang" onkeyup="autofill2()" >
- </div>
- </div>
- <div class="form-group">
- <label for="permintaan" class="col-sm-4 control-label">Permintaan </label>
- <div class="col-sm-4">
- <input type="text" name="permintaan" class="form-control" id="permintaan" placeholder="Masukkan Jumlah" value="" >
- </div>
- </div>
- <hr>
- <div class="form-group">
- <label for="jenis_barang" class="col-sm-3 control-label">Jenis Barang</label>
- <div class="col-sm-4">
- <input type="text" name="jenis_barang" class="form-control" id="jenis_barang" value="" placeholder="" readonly required>
- </div>
- </div>
- <div class="form-group">
- <label for="jumlah" class="col-sm-4 control-label">Jumlah Yang Tersedia</label>
- <div class="col-sm-4">
- <input type="text" class="form-control" id="jumlah" name="jumlah" placeholder="-" value="" readonly required>
- </div>
- </div>
- <div class="form-group">
- <label for="satuan" class="col-sm-2 control-label">Satuan</label>
- <div class="col-sm-4">
- <input type="text" name="satuan" class="form-control" id="satuan" placeholder="-" value="" readonly required>
- </div>
- </div>
- <button type="submit" name="submit" class="btn btn-success">Tambah</button>
- <hr>
- <div ><input type="text" class="hidden" name="id_sub" id="id_sub"></div>
- </form>
- <div >
- <table class="table table-bordered">
- <thead>
- <tr class="info">
- <th width="5%">No</th>
- <th width="10%">Nota</th>
- <th width="10%">Kode Barang</th>
- <th width="22%">Nama Barang</th>
- <th width="10%">Jenis</th>
- <th width="10%">satuan</th>
- <th width="10%">permintaan</th>
- <th width="20%">Tindakan</th>
- </tr>
- </thead>
- <tbody>
- <?php
- $id_user = $_SESSION['id_user'];
- $sql = mysqli_query($koneksi, "SELECT * FROM semi where id_user='$id_user' ORDER BY id_user DESC");
- if(mysqli_num_rows($sql) > 0){
- $no = 0;
- while($row = mysqli_fetch_array($sql)){
- $no++;
- echo '
- <tr>
- <td>'.$no.'</td>
- <td>'.$row['trx'].'</td>
- <td>'.$row['id_barang'].'</td>
- <td>'.$row['nama_barang'].'</td>
- <td>'.$row['jenis_barang'].'</td>
- <td>'.$row['satuan'].'</td>
- <td>'.$row['permintaan'].'</td>
- <td>';
- echo'
- <script type="text/javascript" language="JavaScript">
- function konfirmasi(){
- tanya = confirm("Anda yakin akan menghapus data ini?");
- if (tanya == true) return true;
- else return false;
- }
- </script>
- <a href="?hlm=transaksi&aksi=edit&id_semi='.$row['id_sub'].'" class="btn btn-warning btn-s">Edit</a>
- <a href="?hlm=transaksi&aksi=hapus&submit=yes&id_semi='.$row['id_sub'].'" onclick="return konfirmasi()" class="btn btn-danger btn-s">Hapus</a>
- </td>';
- }
- }
- ?>
- </tr>
- </tbody>
- </div>
- </div>
- </form>
- <?php
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement