?>
</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;
}
