add_styles_page(); $html->prevent_enter_script(); $call = new call_functions; // $html->check_user_type("ADMIN"); $db = new db_safeguard(); $results = $db->query("stock", "SELECT * FROM stock WHERE 1"); $orders_res = $db->query("orders", "SELECT * FROM orders WHERE record_id = {$_GET['record_id']}"); $orders = $orders_res->fetch_assoc(); if ($orders['jc_number'] != "") { $jobcard_res_1 = $db->query("job_cards", "SELECT * FROM job_cards WHERE jc_number = '{$orders['jc_number']}'"); if ($jobcard_res_1->num_rows == 0) { $jobcard_res_2 = $db->query("job_cards_tech", "SELECT * FROM job_cards_tech WHERE jc_number = '{$orders['jc_number']}'"); if ($jobcard_res_2->num_rows == 0) { $jobcard_res_2 = $db->query("job_card_accounts", "SELECT * FROM job_card_accounts WHERE `name` = '{$orders['jc_number']}'"); $accounts = $jobcard_res_2->fetch_assoc(); $job_card_name = $accounts['name']; } else { $tech = $jobcard_res_2->fetch_assoc(); $job_card_name = $tech['company_name']; } } else { $project = $jobcard_res_1->fetch_assoc(); $job_card_name = $project['project_name']; } } else { $job_card_name = $project['N/A']; } $record_id = new input(); $record_id->name("record_id"); $record_id->id("record_id"); $record_id->type("hidden"); $record_id->readonly(); $record_id->required(); $record_id->value($_GET['record_id']); $jobcard_numbers_res = $db->query("job_cards", "SELECT * FROM job_cards WHERE 1"); echo ""; while ($jobcard = $jobcard_numbers_res->fetch_assoc()) { echo ""; } $jobcard_numbers_res = $db->query("job_cards_tech", "SELECT * FROM job_cards_tech WHERE 1"); while ($jobcard = $jobcard_numbers_res->fetch_assoc()) { echo ""; } echo ""; $jobcard_account = new select(); $jobcard_account->name("job_card_account_id"); $jobcard_account->id("job_card_account_id"); $jobcard_account->class("search_inputs"); $jobcard_account->add_option("", "JOB CARD ACCOUNT"); $job_card_account_res = $db->query("job_card_accounts", "SELECT * FROM job_card_accounts WHERE `status` = 1"); while ($job_card_account = $job_card_account_res->fetch_assoc()) { $jobcard_account->add_option($job_card_account['record_id'], $job_card_account['name'] . " : " . $job_card_account['description']); } $jobcard_account->style("width: 80%;"); $jobcard_account->value_from_db("orders", "job_card_account_id", "record_id = {$_GET['record_id']}"); $po_number = new input(); $po_number->name("po_number"); $po_number->id("po_number"); $po_number->class("search_inputs"); $po_number->placeholder("PO Number"); $po_number->type("text"); $po_number->style("width: 80%;"); $po_number->value_from_db("orders", "po_number", "record_id = {$_GET['record_id']}"); $jc_number = new input(); $jc_number->name("jc_number"); $jc_number->id("jc_number"); $jc_number->class("search_inputs"); $jc_number->placeholder("JC Number"); $jc_number->type("text"); $jc_number->datalist("job_cards_list"); $jc_number->onchange("split_jc_and_name(this)"); $jc_number->value_from_db("orders", "jc_number", "record_id = {$_GET['record_id']}"); $jc_number->style("width: 80%;"); $jc_name = new input(); $jc_name->name(""); $jc_name->id(""); $jc_name->class("search_inputs job_card_name"); $jc_name->placeholder(""); $jc_name->type("text"); $jc_name->value($job_card_name); $jc_name->style("width: 80%;"); $jc_name->readonly(); $supplier = new select(); $supplier->name("supplier_id"); $supplier->id("supplier_id"); $supplier->class("search_inputs"); $supplier->add_option("", "Supplier"); $supplier->fill_from_db("suppliers", "record_id", "name"); $supplier->style("width: 80%;"); $supplier->value_from_db("orders", "supplier_id", "record_id = {$_GET['record_id']}"); $order_date = new input(); $order_date->name("order_date"); $order_date->id("order_date"); $order_date->class("search_inputs"); $order_date->type("datetime-local"); $order_date->value(date("Y-m-d H:i", strtotime("+2 hours"))); $order_date->style("width: 80%;"); $order_date->value_from_db("orders", "date_time_created", "record_id = {$_GET['record_id']}"); $ordered_for = new select(); $ordered_for->name("user_id"); $ordered_for->id("user_id"); $ordered_for->class("search_inputs"); $ordered_for->required(); $ordered_for->add_option("", "Order For"); $ordered_for->fill_from_db("users", "record_id", "username"); $ordered_for->style("width: 80%;"); $ordered_for->value_from_db("orders", "user_id", "record_id = {$_GET['record_id']}"); $ordered_by = new select(); $ordered_by->name("user_created"); $ordered_by->id("user_created"); $ordered_by->class("search_inputs"); $ordered_by->required(); $ordered_by->add_option("", "Order By"); // $ordered_by->fill_from_db("users", "record_id", "username"); $ordered_by->add_option("3", "Kaylynn"); $ordered_by->add_option("12", "Chanay"); $ordered_by->add_option("19", "Claurika"); $ordered_by->style("width: 80%;"); $ordered_by->value_from_db("orders", "user_created", "record_id = {$_GET['record_id']}"); $datalist = ""; while ($result = $results->fetch_assoc()) { $datalist .= ""; } $results = $db->query("stock", "SELECT * FROM stock WHERE stock_type = 1"); $datalist_non_stock = ""; while ($result = $results->fetch_assoc()) { $datalist_non_stock .= ""; } $results = $db->query("stock", "SELECT * FROM stock WHERE stock_type = 2"); $datalist_units = ""; while ($result = $results->fetch_assoc()) { $datalist_units .= ""; } $warrenty = new select(); $warrenty->id('warrenty'); $warrenty->name('warrenty'); $warrenty->required(); $warrenty->class(); $warrenty->add_option('0', 'No Warrenty'); $warrenty->add_option('1', 'Has Warrenty'); $warrenty->value_from_db("orders", "warrenty", "record_id = {$_GET['record_id']}"); ?>

EDIT ORDER

select_from_db_add_current_selected_column('orders', "status", "record_id = {$_GET['record_id']}", 'status'); ?>
add(); $po_number->add(); $jobcard_account->add(); $jc_number->add(); $jc_name->add(); $supplier->add(); ?>
add(); $ordered_for->add(); $ordered_by->add(); $warrenty->add(); ?>
query("order_items", "SELECT * FROM order_items WHERE order_id = {$_GET['record_id']} ORDER BY record_id ASC"); while ($order_item = $order_items_res->fetch_assoc()) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $index++; } ?>
Not Stock Item Description (double click to clear) Quantity Cost Price Ex. Action
INCLUDE VAT CALCULATIONS
Total Ex Vat:
Total Inc Vat:
query("order_trans", "SELECT * FROM `order_trans` WHERE order_id = {$_GET['record_id']} AND stock_id != 0 ORDER BY record_id DESC"); ?>

STOCK RECEIVED

fetch_assoc()) { $stock_res = $db->query("stock", "SELECT * FROM stock WHERE record_id = {$stock_received_log['stock_id']}"); $stock = $stock_res->fetch_assoc(); if ($stock['stock_type'] == 2) { $unit_stock_res = $db->query("units_stock", "SELECT * FROM units_stock WHERE record_id = {$stock_received_log['units_stock_id']}"); $unit_stock = $unit_stock_res->fetch_assoc(); $barcode = $unit_stock['barcode']; $serail_number = $unit_stock['serial_number']; $type = $stock['stock_type']; $id = $unit_stock['record_id']; } else if ($stock['stock_type'] == 1) { $non_stock_res = $db->query("non_stock", "SELECT * FROM non_stock WHERE record_id = {$stock_received_log['non_stock_id']}"); $non_stock = $non_stock_res->fetch_assoc(); $barcode = $non_stock['barcode']; $serail_number = ''; $type = $stock['stock_type']; $id = $non_stock['record_id']; } else { $barcode = ''; $serail_number = ''; $type = $stock['stock_type']; $id = $stock['record_id']; } ?>
DESCRIPTION AMOUNT DATE BARCODE SERAIL NUMBER USER
get_username($stock_received_log['user_id']); ?>