add_styles_page();
// $barcode = new barcodeReader();
$html->prevent_enter_script();
// $serial_barcode = new serial_scanner();
// $html->check_user_type("ADMIN");
?>
input_html_from_db("orders", "jc_number", "record_id = {$_GET['record_id']}", "jc_number", "jc_number", "", "inputs", "", "readonly"); ?>
input_html_from_db("orders", "po_number", "record_id = {$_GET['record_id']}", "po_number", "po_number", "", "inputs", "", "readonly"); ?>
select_html_from_db("users", "record_id", "username", "", "user_id", "user_id", "inputs", "", "", "disabled"); ?>
select_from_db_add_current_selected_column("orders", 'user_id', "record_id = {$_GET['record_id']}", 'user_id'); ?>
select_html_from_db("suppliers", "record_id", "name", "", "supplier_id", "supplier_id", "inputs", "width:50%;", "", "disabled"); ?>
select_from_db_add_current_selected_column("orders", 'supplier_id', "record_id = {$_GET['record_id']}", 'supplier_id'); ?>
query("order_items", "SELECT * FROM order_items WHERE order_id = '{$_GET['record_id']}' AND stock_id != 0 AND stock_type = 0 ORDER BY record_id ASC");
if ($items_res->num_rows > 0) {
?>
Stock Items
";
echo $html->input_html("", "ITEM", "", "", 'inputs', "width: 30vw;");
echo $html->input_html("", "ORDERED", "", "", 'inputs', "width: 20vw;");
echo $html->input_html("", "RECEIVED", "", "", 'inputs', "width: 20vw;");
echo "
";
while ($items = $items_res->fetch_assoc()) {
$amount_res = $db->query("order_trans", "SELECT * FROM order_trans WHERE order_id = {$_GET['record_id']} AND stock_id = {$items['stock_id']}");
if ($amount_res->num_rows > 0) {
$total = 0;
while ($amount = $amount_res->fetch_assoc()) {
$total = $total + $amount['amount'];
}
} else {
$total = 0;
}
if ($total != $items['quantity']) {
echo "";
echo $html->input_html("", $items['stock_id'], "stock_id_$index", "stock_id_$index", "hidden");
echo "";
// echo $html->input_html("", $items['name'], "name_$index", "name_$index", "inputs", "", "", "text", "readonly");
echo $html->input_html("", $items['quantity'] - $total, "quantity_$index", "quantity_$index", "inputs", "width:20vw;", "", "text", "readonly");
echo $html->input_html("", "", "actual_amount_$index", "actual_amount_$index", "inputs", "width:20vw;", "onchange = check($index)");
echo $html->input_html("", $items['purchase_price_ex'], "price_$index", "price_$index", "hidden", "", "");
echo "
";
}
$index++;
}
}
?>
query("order_items", "SELECT * FROM order_items WHERE order_id = '{$_GET['record_id']}' AND stock_id != 0 AND stock_type = 1 ORDER BY record_id ASC");
if ($items_res->num_rows > 0) {
?>
Non-Stock Items
";
echo $html->input_html("", "ITEM", "", "", 'inputs', "width: 30vw;");
echo $html->input_html("", "ORDERED", "", "", 'inputs', "width: 20vw;");
echo $html->input_html("", "RECEIVED", "", "", 'inputs', "width: 20vw;");
echo $html->input_html("", "BARCODE", "", "", 'inputs', "width: 20vw;");
echo "";
while ($items = $items_res->fetch_assoc()) {
$amount_res = $db->query("order_trans", "SELECT * FROM order_trans WHERE order_id = {$_GET['record_id']} AND stock_id = {$items['stock_id']}");
if ($amount_res->num_rows > 0) {
$total = 0;
while ($amount = $amount_res->fetch_assoc()) {
$total = $total + $amount['amount'];
}
} else {
$total = 0;
}
if ($total != $items['quantity']) {
echo "";
echo $html->input_html("", $items['stock_id'], "stock_id_$index", "stock_id_$index", "hidden");
echo "";
// echo $html->input_html("", $items['name'], "name_$index", "name_$index", "inputs", "", "", "text", "readonly");
echo $html->input_html("", $items['quantity'] - $total, "quantity_$index", "quantity_$index", "inputs", "width:20vw;", "", "text", "readonly");
echo $html->input_html("", "", "actual_amount_$index", "actual_amount_$index", "inputs", "width:20vw;", "onchange = check($index)");
echo $html->input_html("", "", "barcode_non_$index", "barcode_non_$index", "inputs", "width:20vw;", "onkeyup = check_blanks(this)");
echo $html->input_html("", $items['purchase_price_ex'], "price_$index", "price_$index", "hidden", "", "");
echo "
";
}
$index++;
}
}
?>
query("order_items", "SELECT * FROM order_items WHERE order_id = '{$_GET['record_id']}' AND stock_id != 0 AND stock_type = 2 ORDER BY record_id ASC");
if ($items_res->num_rows > 0) {
?>
UNITS
";
echo $html->input_html("", "ITEM", "", "", 'inputs', "width: 15vw;");
echo $html->input_html("", "ORDERED", "", "", 'inputs', "width: 15vw;");
echo $html->input_html("", "RECEIVED", "", "", 'inputs', "width: 15vw;");
echo $html->input_html("", "S/N", "", "", 'hidden', "width: 15vw;");
echo "";
while ($items = $items_res->fetch_assoc()) {
$amount_res = $db->query("order_trans", "SELECT * FROM order_trans WHERE order_id = {$_GET['record_id']} AND stock_id = {$items['stock_id']}");
if ($amount_res->num_rows > 0) {
$total = 0;
while ($amount = $amount_res->fetch_assoc()) {
$total = $total + $amount['amount'];
}
} else {
$total = 0;
}
if ($total != $items['quantity']) {
echo "";
echo $html->input_html("", $items['stock_id'], "stock_id_$index", "stock_id_$index", "hidden");
echo $html->input_html("", $items['record_id'], "order_item_id_$index", "order_item_id_$index", "hidden");
echo "";
// echo $html->input_html("", $items['name'], "name_$index", "name_$index", "inputs", "", "", "text", "readonly");
echo $html->input_html("", $items['quantity'] - $total, "quantity_$index", "quantity_$index", "inputs", "width: 15vw;", "", "text", "readonly");
echo $html->input_html("", "", "actual_amount_$index", "actual_amount_$index", "inputs", "width: 15vw;", "onchange = 'check($index);create_popup_for_serial_numbers(this,\"serial_numbers_$index\",$index);'");
echo $html->input_html("", $items['purchase_price_ex'], "price_$index", "price_$index", "hidden", "", "");
echo $html->input_html("", "", "serial_numbers_$index", "serial_numbers_$index", 'hidden', "width: 15vw;", '', 'text', 'readonly');
echo "
";
}
$index++;
}
}
?>