SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | if (isset($_POST['simpanpen'])) {
| |
| 3 | $karinput= $conn->query("SELECT * FROM tb_karyawan WHERE uname = '$_SESSION[kd_role]'");
| |
| 4 | $rowkarinput = $karinput->fetch_assoc(); | |
| 5 | $kd_kar_input = $rowkarinput['kd_kar']; //id karyawan | |
| 6 | ||
| 7 | // tabel penjualan | |
| 8 | $id_pen = $_POST['id_pen']; // id penjualan / id transaksi | |
| 9 | $no_pen = $_POST['no_pen']; // nomer penjualan | |
| 10 | $id_kus = $_POST['id_kus']; // id kustomer | |
| 11 | $tgl_pen = $_POST['tgl_pen']; // tgl penjualan | |
| 12 | $po_pen = $_POST['po_pen']; // no PO | |
| 13 | $almt_pen = $_POST['almt_pen']; // alamat pengiriman | |
| 14 | $fak_pen = $_POST['fak_pen']; // no faktur | |
| 15 | ||
| 16 | // tabel data penjualan | |
| 17 | $id_pendata = $_POST['id_pen']; // id data penjualan ini ambil data dari tb_penjualan | |
| 18 | $no_pendata = $_POST['no_pen']; // no penjualan ini ambil data dari tb_penjualan | |
| 19 | // ini form input dinamis | |
| 20 | $kd_pen = $_POST['kd_pen']; // manual | |
| 21 | $id_bw = $_POST['id_bw']; // id warna barang | |
| 22 | $id_brg = $_POST['id_brg']; // id barang | |
| 23 | $qty_pen = $_POST['qty_pen']; // Qty | |
| 24 | $harga = str_replace(".", "", $_POST['harga']); // harga
| |
| 25 | $jumlah = $_POST['jumlah']; // jumlah barang | |
| 26 | ||
| 27 | //TB PENJUALAN | |
| 28 | - | $res = $conn->query("INSERT INTO tb_penjualan (id_pen,kd_kar,id_kus,no_pen,tgl_pen,po_pen,almt_pen,fak_pen) VALUES ('$id_pen','$kd_kar_input','$id_kus','$no_pen', '$tgl_pen', '$po_pen', '$almt_pen', '$fak_pen')");
|
| 28 | + | foreach($kd_pen as $i=>$val){
|
| 29 | $sql="INSERT INTO tb_penjualan (id_pen,kd_kar,id_kus,no_pen,tgl_pen,po_pen,almt_pen,fak_pen) VALUES | |
| 30 | ('$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]')";
| |
| 31 | } | |
| 32 | $res = $conn->query($sql); | |
| 33 | } | |
| 34 | if ($res == true) {
| |
| 35 | //TB PENJUALAN DATA | |
| 36 | $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')");
| |
| 37 | ||
| 38 | echo "<script>alert('Data berhasil disimpan!'); window.location='../../page/penjualan';</script>";
| |
| 39 | } else {
| |
| 40 | echo 'Error ' . mysqli_error($conn); | |
| 41 | } | |
| 42 | } | |
| 43 | ?> |
