$status = 1;
} else {
$status = 2;
}
$i_code = get_isset($i_code);
$tanggal = date("Y-m-d");
//$get_item_name = get_item_name($i_item_id);
$data = "'',\n\t\t\t\t\t'{$i_date}', \n\t\t\t\t\t'0', \n\t\t\t\t\t'0',\n\t\t\t\t\t'0',\n\t\t\t\t\t'0',\n\t\t\t\t\t'{$i_supplier}',\n\t\t\t\t\t'{$i_branch_id}',\n\t\t\t\t\t'{$i_payment_type}',\n\t\t\t\t\t'{$status}',\n\t\t\t\t\t'{$tanggal}',\n\t\t\t\t\t'{$i_code}'\n\t\t\t";
//echo $data;
create($data);
$data_id = mysql_insert_id();
// simpan jurnal
$harga_total = get_total($data_id);
create_journal($data_id, "purchase.php?page=form&id=", 2, $harga_total['total'], $i_code, '', $i_branch_id);
//add_stock($i_item_id, $i_branch_id, $i_qty);
update_detail($data_id, $_SESSION['user_id']);
$query_item = select_detail_tmp($data_id);
while ($row_item = mysql_fetch_array($query_item)) {
//echo $row_item['transaction_production_detail_id'];
//Minus stock
$select_stock = select_stock($row_item['branch_id'], $row_item['item_id']);
$stock_plus = $select_stock['item_stock_qty'] + $row_item['purchase_detail_qty'];
//echo $stock_plus;
update_stock($row_item['branch_id'], $row_item['item_id'], $stock_plus);
}
header("Location: purchase.php?page=list&did=1");
break;
case 'edit':
extract($_POST);
$id = get_isset($_GET['id']);
$i_date = get_isset($i_date);
$i_item = get_isset($_GET['i_item']);
//$i_item = get_resep($i_resep);
//$item_id = $i_item['item_id'];
$row_id = get_isset($_GET['row_id']);
$i_date = get_isset($_GET['i_date']);
$i_date = format_back_date($i_date);
$i_code = get_isset($_GET['i_code']);
$i_cabang = get_isset($_GET['i_cabang']);
$i_hasil = get_isset($_GET['i_hasil']);
$i_target = get_isset($_GET['i_target']);
$branch_id = $_SESSION['branch_id'];
if (!$row_id) {
$data = "'',\n\t\t\t\t\t'{$i_cabang}',\t\n\t\t\t\t\t'{$i_code}',\n\t\t\t\t\t'{$i_date}',\n\t\t\t\t\t'{$i_item}',\n\t\t\t\t\t'{$i_target}',\n\t\t\t\t\t'{$i_hasil}'\n\t\t\t\t\t\n\t\t\t\t";
create_config("transaction_productions", $data);
$transaction_production_id = mysql_insert_id();
update_detail($transaction_production_id, $_SESSION['user_id']);
$query_item = select_item($transaction_production_id);
while ($row_item = mysql_fetch_array($query_item)) {
//echo $row_item['transaction_production_detail_id'];
//Minus stock
$select_stock = select_stock($row_item['branch_id'], $row_item['item_id']);
$stock_minus = $select_stock['item_stock_qty'] - $row_item['transaction_production_detail_qty'];
update_stock($row_item['branch_id'], $row_item['item_id'], $stock_minus);
}
} else {
update_production($row_id, $i_hasil);
//plus stock
$select_stock2 = select_stock($i_cabang, $i_item);
$stock_plus = $select_stock2['item_stock_qty'] + $i_hasil;
update_stock($i_cabang, $i_item, $stock_plus);
}
case 'save':
extract($_POST);
//echo "test";
$i_id = get_isset($_GET['i_id']);
$i_name = get_isset($_GET['i_name']);
$i_item_produck = get_isset($_GET['i_item_produck']);
if (!$i_id) {
$data = "'',\n\t\t\t\t\t'{$i_name}',\t\n\t\t\t\t\t'{$i_item_produck}'\n\t\t\t\t\t\n\t\t\t\t";
create_config("reseps", $data);
$resep_id = mysql_insert_id();
} else {
$data = "resep_name = '{$i_name}',\n\t\t\t\titem_id = '{$i_item_produck}'\n\t\t\t\t\n\t\t\t\t";
update_config("reseps", $data, "resep_id", $i_id);
$resep_id = $i_id;
}
update_detail($resep_id, $_SESSION['user_id']);
header("Location: resep.php");
break;
case 'edit_price':
$id = get_isset($_GET['id']);
$qty = get_isset($_GET['qty']);
$price = get_isset($_GET['price']);
$total = $qty * $price;
$data = "transaction_internal_detail_qty = '{$qty}',\n\t\t\t\ttransaction_internal_detail_price = '{$price}',\n\t\t\t\ttransaction_internal_detail_total= '{$total}'\n\t\t\t\t\n\t\t";
update_config("transaction_internal_details", $data, "transaction_internal_detail_id", $id);
break;
case 'edit_qty':
$id = get_isset($_GET['id']);
$qty = get_isset($_GET['qty']);
$data = "resep_detail_qty = '{$qty}'\n\t\t\t\n\t\t";
update_config("resep_details", $data, "resep_detail_id", $id);
create_config("transaction_internal_details", $data);
header("Location: transaksi_internal.php?page=form");
break;
case 'save':
extract($_POST);
//echo "test";
$i_date = get_isset($_GET['i_date']);
$i_date = format_back_date($i_date);
$i_code = get_isset($_GET['i_code']);
$i_pabrik = get_isset($_GET['i_pabrik']);
$i_cabang = get_isset($_GET['i_cabang']);
$branch_id = $_SESSION['branch_id'];
$data = "'',\n\t\t\t\t\t'{$i_code}',\t\n\t\t\t\t\t'{$i_date}',\n\t\t\t\t\t'{$i_pabrik}',\n\t\t\t\t\t'{$i_cabang}',\n\t\t\t\t\t'{$branch_id}'\n\t\t\t\t\t\n\t\t\t\t";
create_config("transaction_internals", $data);
$transaction_internal_id = mysql_insert_id();
update_detail($transaction_internal_id, $_SESSION['user_id']);
$query_item = select_item($transaction_internal_id);
while ($row_item = mysql_fetch_array($query_item)) {
//echo $row_item['transaction_internal_detail_id'];
//pabrik
$select_stock_pabrik = select_stock($row_item['pabrik_branch_id'], $row_item['item_id']);
$stock_pabrik = $select_stock_pabrik['item_stock_qty'] - $row_item['transaction_internal_detail_qty'];
update_stock($row_item['pabrik_branch_id'], $row_item['item_id'], $stock_pabrik);
//cabang
$select_stock_cabang = select_stock($row_item['cabang_branch_id'], $row_item['item_id']);
$stock_cabang = $select_stock_cabang['item_stock_qty'] + $row_item['transaction_internal_detail_qty'];
update_stock($row_item['cabang_branch_id'], $row_item['item_id'], $stock_cabang);
}
header("Location: transaksi_internal.php");
break;
case 'edit_price':
