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"); $costs_res = $db->query("costs", "SELECT * FROM costs WHERE record_id = {$_GET['record_id']}"); $costs = $costs_res->fetch_assoc(); if ($costs['jc_number'] != "") { $jobcard_res_1 = $db->query("job_cards", "SELECT * FROM job_cards WHERE jc_number = '{$costs['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 = '{$costs['jc_number']}'"); if ($jobcard_res_2->num_rows == 0) { $jobcard_res_2 = $db->query("job_card_accounts", "SELECT * FROM job_card_accounts WHERE `name` = '{$costs['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("costs", "job_card_account_id", "record_id = {$_GET['record_id']}"); $name = new input(); $name->name("name"); $name->id("name"); $name->class("search_inputs"); $name->placeholder("NAME"); $name->type("text"); $name->style("width: 80%;"); $name->value_from_db("costs", "name", "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("costs", "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(); $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("costs", "date_time_created", "record_id = {$_GET['record_id']}"); ?>

EDIT COST

add(); $name->add(); $order_date->add(); ?>
add(); $jc_number->add(); $jc_name->add(); ?>
query("cost_items", "SELECT * FROM cost_items WHERE cost_id = {$_GET['record_id']} ORDER BY record_id ASC"); while ($order_item = $order_items_res->fetch_assoc()) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $index++; } ?>
Item Description (double click to clear) Quantity Cost Price Ex. Action
INCLUDE VAT CALCULATIONS
Total Ex Vat:
Total Inc Vat: