$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':