?> </td> <td align="left"><?php echo $data['nama_kategori']; ?> </td> <td align="center"> <a href="?page=edit_kategori&id=<?php echo $data['id_kategori']; ?> "><img src="images/edit.png" width="13px" height="auto" title="Edit data" style="margin-right: 5px;" /></a> <a href="?page=data_kategori&menu=hapus&id=<?php echo $data['id_kategori']; ?> " <?php hapus(); ?> ><img src="images/delete.png" width="13px" height="auto" title="Hapus data" /></a> </td> </tr> <?php } $number++; } } $x = "select * from post_kategori"; $y = mysql_query($x); $rows = mysql_num_rows($y); ?>
*/ $hasil = hitung($link, $poId, $barcode); /* * Update po detail dengan nilai hasil perhitungan */ mysqli_query($link, "update purchase_order_detail set avg_daily_sales={$hasil['avg_daily_sales']}, saran_order={$hasil['saran_order']}" . " where purchase_order_id={$poId} and barcode='{$barcode}'") or die('Gagal update po #' . $poId . ', error: ' . mysqli_error($link)); /* * Kembalikan hasil perhitungan + status sukses */ echo json_encode(array_merge(array('sukses' => true), $hasil)); break; case 'order': echo json_encode(order($link, $_POST['poId'], $_POST['barcode'], $_POST['qty'])); break; case 'hapus': echo json_encode(hapus($link, $_POST['poId'], $_POST['barcode'])); break; case 'simpan': echo json_encode(simpan($link, $_POST['poId'])); break; case 'csv': csv($link, $_GET['poId']); break; case 'hapuspo': hapusPo($link, $_GET['poid']); header('location:index.php'); break; } /** * Fungsi untuk menghapus po (header dan detail) * @param mysqli $link
$link = mysqli_connect($server, $username, $password) or die("Koneksi gagal"); mysqli_select_db($link, $database) or die("Database tidak bisa dibuka"); $act = $_GET['act']; switch ($act) { case 'tambahstokstat': $stokStatId = tambahStokStat($link, $_POST['keterangan']); header('location:input.php?id=' . $stokStatId); break; case 'cek': if (cek($link, $_POST['stokStatId'], $_POST['barcode'], $_POST['qty'])) { echo json_encode(array('sukses' => true)); } break; case 'hapus': $id = $_POST['id']; if (hapus($link, $id)) { echo json_encode(array('sukses' => true)); } break; case 'simpan': $id = $_POST['id']; echo json_encode(array('sukses' => simpan($link, $id))); break; case 'hapusss': //hapus SS $id = $_GET['id']; hapusSs($link, $id); header('location:index.php'); break; case 'ubahrak': $barcode = $_POST['barcode'];
function getContent($par) { global $s, $_submit, $menuAccess, $fFile, $dFile, $cUsername; switch ($par[mode]) { case "cek": $text = cek(); break; case "kta": $text = kota(); break; case "geo": $text = getField("select namaData from mst_data where kodeData='{$par['kodeKota']}'"); break; case "delNote": if (isset($menuAccess[$s]["delete"])) { $text = hapusNote(); } else { $text = lihat(); } break; case "editNote": if (isset($menuAccess[$s]["edit"])) { $text = empty($_submit) ? formNote() : ubahNote(); } else { $text = lihat(); } break; case "addNote": if (isset($menuAccess[$s]["add"])) { $text = empty($_submit) ? formNote() : tambahNote(); } else { $text = lihat(); } break; case "delBank": if (isset($menuAccess[$s]["delete"])) { $text = hapusBank(); } else { $text = lihat(); } break; case "editBank": if (isset($menuAccess[$s]["edit"])) { $text = empty($_submit) ? formBank() : ubahBank(); } else { $text = lihat(); } break; case "addBank": if (isset($menuAccess[$s]["add"])) { $text = empty($_submit) ? formBank() : tambahBank(); } else { $text = lihat(); } break; case "delContact": if (isset($menuAccess[$s]["delete"])) { $text = hapusContact(); } else { $text = lihat(); } break; case "editContact": if (isset($menuAccess[$s]["edit"])) { $text = empty($_submit) ? formContact() : ubahContact(); } else { $text = lihat(); } break; case "addContact": if (isset($menuAccess[$s]["add"])) { $text = empty($_submit) ? formContact() : tambahContact(); } else { $text = lihat(); } break; case "getProduk": $text = getProduk(); break; case "setProduk": $text = setProduk(); break; case "delFProduct": if (isset($menuAccess[$s]["delete"])) { $text = hapusFProduct(); } else { $text = lihat(); } break; case "delProduct": if (isset($menuAccess[$s]["delete"])) { $text = hapusProduct(); } else { $text = lihat(); } break; case "editProduct": if (isset($menuAccess[$s]["edit"])) { $text = empty($_submit) ? formProduct() : ubahProduct(); } else { $text = lihat(); } break; case "addProduct": if (isset($menuAccess[$s]["add"])) { $text = empty($_submit) ? formProduct() : tambahProduct(); } else { $text = lihat(); } break; case "getData": include 'dta_supplier_data.php'; break; case "delAddress": if (isset($menuAccess[$s]["delete"])) { $text = hapusAddress(); } else { $text = lihat(); } break; case "editAddress": if (isset($menuAccess[$s]["edit"])) { $text = empty($_submit) ? formAddress() : ubahAddress(); } else { $text = lihat(); } break; case "addAddress": if (isset($menuAccess[$s]["add"])) { $text = empty($_submit) ? formAddress() : tambahAddress(); } else { $text = lihat(); } break; case "update": if (isset($menuAccess[$s]["edit"])) { $text = ubah("update"); } break; case "delNpwp": if (isset($menuAccess[$s]["edit"])) { $text = hapusNpwp(); } else { $text = lihat(); } break; case "delId": if (isset($menuAccess[$s]["edit"])) { $text = hapusId(); } else { $text = lihat(); } break; case "delTdp": if (isset($menuAccess[$s]["edit"])) { $text = hapusTdp(); } else { $text = lihat(); } break; case "delSiup": if (isset($menuAccess[$s]["edit"])) { $text = hapusSiup(); } else { $text = lihat(); } break; case "delLogo": if (isset($menuAccess[$s]["edit"])) { $text = hapusLogo(); } else { $text = lihat(); } break; case "del": if (isset($menuAccess[$s]["delete"])) { $text = hapus(); } else { $text = lihat(); } break; case "edit": if (isset($menuAccess[$s]["add"])) { $text = empty($_submit) ? form() : ubah(); } else { $text = lihat(); } break; case "add": $text = isset($menuAccess[$s]["add"]) ? tambah() : lihat(); break; case "det": $text = detail(); break; default: $sql = "select * from dta_supplier where namaSupplier='' and createBy='{$cUsername}'"; $res = db($sql); while ($r = mysql_fetch_array($res)) { if (file_exists($fFile . $r[logoSupplier]) and $r[logoSupplier] != "") { unlink($fFile . $r[logoSupplier]); } $sql_ = "select * from dta_supplier_identity where kodeSupplier='{$r['kodeSupplier']}'"; $res_ = db($sql_); $r_ = mysql_fetch_array($res_); if (file_exists($dFile . $r_[siupIdentity_file]) and $r_[siupIdentity_file] != "") { unlink($dFile . $r_[siupIdentity_file]); } if (file_exists($dFile . $r_[tdpIdentity_file]) and $r_[tdpIdentity_file] != "") { unlink($dFile . $r_[tdpIdentity_file]); } if (file_exists($dFile . $r_[idIdentity_file]) and $r_[idIdentity_file] != "") { unlink($dFile . $r_[idIdentity_file]); } if (file_exists($dFile . $r_[npwpIdentity_file]) and $r_[npwpIdentity_file] != "") { unlink($dFile . $r_[npwpIdentity_file]); } db("delete from dta_supplier where kodeSupplier='{$r['kodeSupplier']}'"); db("delete from dta_supplier_address where kodeSupplier='{$r['kodeSupplier']}'"); db("delete from dta_supplier_produk where kodeSupplier='{$r['kodeSupplier']}'"); db("delete from dta_supplier_identity where kodeSupplier='{$r['kodeSupplier']}'"); db("delete from dta_supplier_contact where kodeSupplier='{$r['kodeSupplier']}'"); db("delete from dta_supplier_bank where kodeSupplier='{$r['kodeSupplier']}'"); } $text = lihat(); break; } return $text; }