add_styles_page(); $db = new db_safeguard(); $stock_data_res = $db->query("stock_control", "SELECT * FROM stock_control WHERE record_id = {$_GET['record_id']}"); // echo "SELECT * FROM stock_control WHERE record_id = {$_GET['record_id']}"; $stock_data = $stock_data_res->fetch_assoc(); $record_id = new input(); $record_id->type("hidden"); $record_id->name("record_id"); $record_id->id("record_id"); $record_id->value($_GET['record_id']); $stock_id_label = new label(); $stock_id_label->for("stock_no"); $stock_id_label->value("STOCK NO : "); $stock_id_label->addAttribute("style", "font-size: 1.5em; width: 30%;"); $stock_id = new input(); $stock_id->type("text"); $stock_id->name("stock_no"); $stock_id->id("stock_no"); $stock_id->value_from_db('stock', 'stock_no', "stock_no = '{$stock_data['stock_no']}'"); $stock_id->readonly(); $stock_id->addAttribute("style", "font-size: 1.5em; width: 80%; margin: 0.5vw auto;"); $item_name_label = new label(); $item_name_label->for("item_name"); $item_name_label->value("ITEM NAME"); $item_name_label->addAttribute("style", "font-size: 1.5em; width: 30%;"); $item_name = new input(); $item_name->type("text"); $item_name->name("item_name"); $item_name->id("item_name"); $item_name->value_from_db('stock', 'item_name', "stock_no = '{$stock_data['stock_no']}'"); $item_name->addAttribute("style", "font-size: 1.5em; width: 80%; margin: 0.5vw auto;"); // $description_label = new label(); // $description_label->for("description"); // $description_label->value("DESCRIPTION"); // $description = new input(); // $description->type("text"); // $description->name("description"); // $description->id("description"); // $description->style("width:30vw;"); // $description->value_from_db('stock', 'description', "stock_no = '{$stock_data['stock_no']}'"); // $description->style("width:40vw;"); // $quantity_label = new label(); // $quantity_label->for("quantity"); // $quantity_label->value("QUANTITY"); // $quantity = new input(); // $quantity->type("number"); // $quantity->name("quantity"); // $quantity->id("quantity"); // $quantity->style("width:30vw;"); // $quantity->value_from_db('stock', 'quantity', "stock_no = '{$stock_data['stock_no']}'"); $status_label = new label(); $status_label->for("status"); $status_label->value("STATUS"); $status_label->addAttribute("style", "font-size: 1.5em; width: 30%;"); $status = new select(); $status->name("status"); $status->id("status"); $status->add_option("0", "AVAILABLE"); $status->add_option("1", "BOOKED"); $status->add_option("2", "UNAVAILABLE"); $status->addAttribute("style", "font-size: 1.5em; width: 80%; margin: 0.5vw auto;"); $submit_btn = new button(); $submit_btn->value("UPDATE"); $submit_btn->onclick("update_stock()"); ?>

UPDATE STOCK

add(); ?>
add(); $stock_id->add(); ?>
query("stock_type", "SELECT * FROM stock_type WHERE record_id = '{$stock_data['stock_type']}'"); // echo "SELECT * FROM stock_type WHERE record_id = '{$stock_data['stock_type']}'"; $stock_type = $stock_type_res->fetch_assoc(); ?>
add(); $item_name->add(); ?>
query("suppliers", "SELECT * FROM suppliers WHERE record_id = '{$stock_data['supplier_id']}'"); // echo "SELECT * FROM suppliers WHERE record_id = '{$stock_data['supplier_id']}'"; $supplier_id = $supplier_id_res->fetch_assoc(); ?>
add(); $status->add(); ?>
add(); ?>
function_name("update_stock"); $ajax->update("stock_control"); $ajax->on_success("STOCK UPDATED"); $ajax->redirect("../stock_control/home.php");