Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
Kelas Premium!
Belajar Javascript untuk website
Gunakan kupon "mulaijs" untuk diskon 75 ribu!
Giamana cara simpan ini ketika menggunakan input type submit dua kayak gini
<?php
include "inc/koneksi.php";
$username = $_SESSION['id_user'];
# HAPUS DAFTAR
if(isset($_GET['Aksi'])){
if(trim($_GET['Aksi'])=="Hapus"){
$id = $_GET['id'];
// Hapus Tmp jika datanya sudah dipindah
$mySql = "DELETE FROM peminjaman_tmp WHERE id='$id' AND id_user='$username'";
mysql_query($mySql);
}
}
// =========================================================================
# TOMBOL TAMBAH DIKLIK
if(isset($_POST['btnTambah'])){
// Baca Variabel
$kd_karyawan = $_POST['kd_karyawan'];
$kd_brg = $_POST['kd_brg'];
# SIMPAN DATA BUKU KE TMP
// Jika jumlah error pesanError tidak ada, skrip di bawah dijalankan
$tmpSql = "INSERT INTO peminjaman_tmp (kd_brg, id_user) VALUES ('$kd_brg','$username')";
mysql_query($tmpSql);
}
# ========================================================================================================
# JIKA TOMBOL SIMPAN TRANSAKSI DIKLIK
if(isset($_POST['btnSimpan'])){
// Baca variabel data form
$tgl_pinjam = $_POST['tgl_pinjam'];
$kd_karyawan = $_POST['kd_karyawan'];
$lokasi = $_POST['lokasi'];
$ket = $_POST['ket'];
// Skrip Validasi form
# SIMPAN KE DATABASE
// Jika jumlah error pesanError tidak ada, maka proses Penyimpanan akan dikalkukan
// Skrip menyimpan data ke tabel transaksi utama
$mySql = "INSERT INTO peminjaman(kd_peminjaman, kd_karyawan,tgl_pinjam, lokasi, ket, status, id_user)
VALUES ('$kd_peminjaman', '$kd_karyawan', '$tgl_pinjam', '$lokasi', '$ket', 'Pinjam', '$userLogin')";
mysql_query($mySql);
// Ambil semua data buku/buku yang dipilih (diambil dari TMP), berdasarkan user yg login
$tmpSql ="SELECT * FROM peminjaman_tmp WHERE id_user='$username' ";
$tmpQry = mysql_query($tmpSql, $koneksidb) or die ("Gagal Query baca Tmp".mysql_error());
while ($tmpData = mysql_fetch_array($tmpQry)) {
// Membaca data dari tabel TMP
$kd_brg = $tmpData['kd_brg'];
// Masukkan semua buku/buku dari TMP ke tabel peminjaman detil
$itemSql = "INSERT INTO peminjaman_detil(kd_peminjaman, kd_brg)
VALUES ('$kd_peminjaman', '$kd_brg')";
mysql_query($itemSql);
}
// Kosongkan Tmp jika datanya sudah dipindah
$hapusSql = "DELETE FROM peminjaman_tmp WHERE id_user='$username' ";
mysql_query($hapusSql);
}
# VARIABEL DATA DARI & UNTUK FORM
$kd_peminjaman = isset($_POST['kd_peminjaman']) ? $_POST['kd_peminjaman'] : '';
$kd_karyawan = isset($_POST['kd_karyawan']) ? $_POST['kd_karyawan'] : '';
$tgl_pinjam = isset($_POST['tgl_pinjam']) ? $_POST['tgl_pinjam'] : '';
$lokasi = isset($_POST['lokasi']) ? $_POST['lokasi'] : '';
$ket = isset($_POST['ket']) ? $_POST['ket'] : '';
$dataKategori = isset($_POST['id_kategori']) ? $_POST['id_kategori'] : '';
date_default_timezone_set("Asia/Bangkok");
?>
<script language="JavaScript">
function submitform() {
document.form2.submit();
}
</script>
<section id="header">
<h3><i class="fa fa-angle-right"></i> Input Data Peminjaman Barang</h3>
<tr>
<td colspan="2" align="right"><a href="index_admin.php?page=form-peminjaman-barang" ><img src="images/btn_add.png" height="30" border="0" /></a> <a href="index_admin.php?page=form-peminjaman-barang" ><img src="images/btn_view.png" height="30" border="0" /></a></td>
</tr>
</section>
<!-- BASIC FORM ELELEMNTS -->
<div class="row mt">
<div class="col-lg-12">
<div class="form-panel">
<h4 class="mb"><i class="fa fa-angle-right"></i> Data Peminjaman Barang</h4>
<form class="form-horizontal style-form" action="<?php $_SERVER['PHP_SELF']; ?>" method="post" name="form2" target="_self">
<div class="form-group">
<label class="col-sm-3 control-label">Kode Peminjaman</label>
<div class="col-sm-7">
<input type="text" class="form-control" name="kd_peminjaman" autocomplete="off" required value="<?php echo $kd_peminjaman; ?>">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label" >Nama Karyawan</label>
<div class="col-sm-7">
<select type="text" name="kd_karyawan" class="form-control chosen-select" maxlength="64" required value="<?php echo $kd_karyawan; ?>" >
<?php $sql = mysql_query("select kd_karyawan, nama_karyawan from karyawan ");
while ($data = mysql_fetch_array($sql)){
?>
<option value="<?php echo $data['kd_karyawan'];?>"><?php echo $data['kd_karyawan'] ?> -- <?php echo $data['nama_karyawan'] ?></option><?php } ?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Tanggal Peminjaman</label>
<div class="col-sm-7">
<input type="date" class="form-control" name="tgl_pinjam" autocomplete="off" required value="<?php echo $tgl_pinjam; ?>">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label" >Kategori</label>
<div class="col-sm-7">
<select class="form-control chosen-select" name="id_kategori" onchange="javascript:submitform();" >
<option value="Kosong">....</option>
<?php
// Skrip menampilkan data Kategori ke ComboBo (ListMenu)
$bacaSql = "SELECT * FROM kategori ORDER BY id_kategori";
$bacaQry = mysql_query($bacaSql);
while ($bacaData = mysql_fetch_array($bacaQry)) {
if ($bacaData['id_kategori'] == $dataKategori)
{
$cek = "selected";
} else { $cek=""; }
echo "<option value='$bacaData[id_kategori]' $cek> $bacaData[nm_kategori]</option>";
}
?> </select>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label" >Nama Barang</label>
<div class="col-sm-7">
<select class="form-control chosen-select" name="kd_brg" data-placeholder="-- Pilih Kategori--" required >
<option value=""></option>
<?php
$sql=mysql_query("select barang.kd_brg,gudang.nm_barang from barang inner join gudang on barang.id_brg_msk=gudang.id_brg_msk where id_kategori='$dataKategori' ORDER BY kd_brg");
while ($bacaData = mysql_fetch_array($sql)) {
if ($bacaData['kd_brg'] == $data)
{
$cek = " selected";
} else { $cek=""; }
echo "<option value='$bacaData[kd_brg]' $cek> $bacaData[kd_brg] - $bacaData[nm_barang] </option>"; } ?> </select>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Lokasi Proyek</label>
<div class="col-sm-7">
<input type="text" name="lokasi" class="form-control" maxlength="64" placeholder="Lokasi Proyek" required value="<?php echo $lokasi; ?>">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Keterangan</label>
<div class="col-sm-7">
<textarea name="ket" class="form-control" placeholder="Ket" required><?php echo $ket; ?>
</textarea>
<input name="btnTambah" type="submit" style="cursor:pointer;" value=" Tambah " />
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label"> Daftar Barang</label>
<div class="col-sm-7">
<table id="example2" class="display nowrap" cellspacing="0" width="100%">
<thead>
<th>Kode Barang</th>
<th>Nama Barang</th>
<th>harga</th>
<th>Kondisi</th>
<th>Action</th>
</thead>
<tbody>
<?php
$sql =mysql_query("select tmp.*, barang.kd_brg, barang.kondisi, gudang.nm_barang FROM peminjaman_tmp As tmp
JOIN barang ON tmp.kd_brg = barang.kd_brg LEFT JOIN gudang on barang.id_brg_msk=gudang.id_brg_msk
WHERE tmp.id_user='$username' ORDER BY id"
);
$nomor=0;
while($row=mysql_fetch_array($sql)) {
$nomor++;
$id = $row['id'];
?>
<tr>
<td><?php echo $nomor; ?></td>
<td><?php echo $row['kd_brg']; ?></td>
<td><?php echo $row['nm_barang']; ?></td>
<td><?php echo $row['kondisi']; ?></td>
<td><a href="?Aksi=Hapus&id=<?php echo $id; ?>" target="_self">Delete</a></td>
</tr>
<?php } ?>
</table></td>
</tr>
<div class="form-group" style="margin-bottom: 20px;">
<label class="col-sm-4 col-sm-4 control-label"></label>
<div class="col-sm-6">
<input name="btnSimpan" type="submit" style="cursor:pointer;" value=" SIMPAN TRANSAKSI " />
</div>
</div>
</tbody></table>
</form>
</div>
</div>
</div>
<script>
$(function () {
$('#example2').DataTable({
"paging": true,
"ordering": true,
"scrollX":true
});
});
</script>
0
Belum ada Jawaban. Jadi yang pertama Jawaban
Login untuk ikut Jawaban