input_html_from_db("orders", "jc_number", "record_id = {$_GET['record_id']}", "jc_number", "jc_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", "", "", "disabled"); ?>
select_from_db_add_current_selected_column("orders", 'supplier_id', "record_id = {$_GET['record_id']}", 'supplier_id'); ?>
Items
query("order_items", "SELECT * FROM order_items WHERE order_id = '{$_GET['record_id']}' AND stock_id != 0");
echo "
";
echo $html->input_html("", "ITEM", "", "", 'inputs', 'width:18vw;');
echo $html->input_html("", "ORDERED", "", "");
echo $html->input_html("", "RECEIVED TO DATE", "", "");
echo $html->input_html("", "REMAINING", "", "");
echo "
";
while ($items = $items_res->fetch_assoc()) {
echo "
";
echo $html->input_html("", $items['stock_id'], "stock_id_$index", "stock_id_$index", "hidden");
$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;
}
echo "";
echo $html->input_html("", $items['quantity'], "quantity_$index", "quantity_$index", "inputs", "", "", "text", "readonly");
echo $html->input_html("", $total, "actual_amount_$index", "actual_amount_$index", "inputs", "", "onchange = check($index)", "", "readonly");
echo $html->input_html("", $items['quantity'] - $total, "amount_remaining_$index", "amount_remaining_$index", "inputs", "", "readonly");
if ($items['quantity'] == $total) {
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
} else {
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
}
echo "
";
$index++;
}
?>