Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if (isset($_POST['simpanpen'])) {
- $karinput= $conn->query("SELECT * FROM tb_karyawan WHERE uname = '$_SESSION[kd_role]'");
- $rowkarinput = $karinput->fetch_assoc();
- $kd_kar_input = $rowkarinput['kd_kar']; //id karyawan
- // tabel penjualan
- $id_pen = $_POST['id_pen']; // id penjualan / id transaksi
- $no_pen = $_POST['no_pen']; // nomer penjualan
- $id_kus = $_POST['id_kus']; // id kustomer
- $tgl_pen = $_POST['tgl_pen']; // tgl penjualan
- $po_pen = $_POST['po_pen']; // no PO
- $almt_pen = $_POST['almt_pen']; // alamat pengiriman
- $fak_pen = $_POST['fak_pen']; // no faktur
- // tabel data penjualan
- $id_pendata = $_POST['id_pen']; // id data penjualan ini ambil data dari tb_penjualan
- $no_pendata = $_POST['no_pen']; // no penjualan ini ambil data dari tb_penjualan
- // ini form input dinamis
- $kd_pen = $_POST['kd_pen']; // manual
- $id_bw = $_POST['id_bw']; // id warna barang
- $id_brg = $_POST['id_brg']; // id barang
- $qty_pen = $_POST['qty_pen']; // Qty
- $harga = str_replace(".", "", $_POST['harga']); // harga
- $jumlah = $_POST['jumlah']; // jumlah barang
- //TB PENJUALAN
- foreach($kd_pen as $i=>$val){
- $sql="INSERT INTO tb_penjualan (id_pen,kd_kar,id_kus,no_pen,tgl_pen,po_pen,almt_pen,fak_pen) VALUES
- ('$id_pen[$i]','$kd_kar_input[$i]','$id_kus[$i]','$no_pen[$i]', '$tgl_pen[$i]', '$po_pen[$i]', '$almt_pen[$i]', '$fak_pen[$i]')";
- }
- $res = $conn->query($sql);
- }
- if ($res == true) {
- //TB PENJUALAN DATA
- $res_multi = $conn->multi_query("INSERT INTO tb_penjualandata(id_pen,kd_pen,no_pen,id_bw,id_brg,qty_pen,harga,jumlah) VALUES ('$id_pendata','$kd_pen','$no_pendata','$id_bw','$id_brg','$qty_pen', '$harga', '$jumlah')");
- echo "<script>alert('Data berhasil disimpan!'); window.location='../../page/penjualan';</script>";
- } else {
- echo 'Error ' . mysqli_error($conn);
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement