add_styles_page(); $db = new db_safeguard(); $stock_data_res = $db->query("stock", "SELECT * FROM stock"); while ($stock_data = $stock_data_res->fetch_assoc()) { $stock_items = $stock_items . ""; } $stock_no_label = new label(); $stock_no_label->for("stock_no"); $stock_no_label->value("Stock No:"); $stock_no = new select(); $stock_no->class("inputs"); $stock_no->name("stock_no"); $stock_no->id("stock_no"); $stock_no->fill_from_db("stock", "stock_no", "stock_no"); $jobcard_no_label = new label(); $jobcard_no_label->for("jobcard_no_label"); $jobcard_no_label->value("Jobcard No : "); $jobcard_no = new select(); $jobcard_no->class("inputs"); $jobcard_no->name("jobcard_no"); $jobcard_no->id("jobcard_no"); $jobcard_no->fill_from_db("jobcards", "jc_no", "jc_no", "status = 0"); $stock_type_label = new label(); $stock_type_label->for("stock_type_label"); $stock_type_label->value("STOCK TYPE : "); $stock_type_label->addAttribute("style", "font-size: 1.5em; width: 30%;"); $stock_type = new select(); $stock_type->class("inputs"); $stock_type->name("stock_type"); $stock_type->id("stock_type"); $stock_type->fill_from_db("stock_types", "record_id", "name"); $stock_type->onchange("getStockTypeDetails()"); $stock_type->style("font-size: 1.5em; width: 80%; margin: 0.5vw auto;"); $stock_label = new label(); $stock_label->for("stock_label"); $stock_label->value("STOCK : "); $stock_label->addAttribute("style", "font-size: 1.5em; width: 30%;"); $date_booked_label = new label(); $date_booked_label->for("date_booked_label"); $date_booked_label->value("BOOKING DATE : "); $date_booked_label->addAttribute("style", "font-size: 1.5em; width: 30%;"); $date_booked = new input(); $date_booked->class("inputs"); $date_booked->name("date_booked"); $date_booked->id("date_booked"); $date_booked->type("datetime-local"); $date_booked->style("font-size: 1.5em; width: 80%; margin: 0.5vw auto;"); $user_id_label = new label(); $user_id_label->for("user_id_label"); $user_id_label->value("USER ID : "); $user_id_label->addAttribute("style", "font-size: 1.5em; width: 30%;"); $user_id = new input(); $user_id->type("hidden"); $user_id->id("user_id"); $user_id->name("user_id"); $user_id->value($_SESSION["user_id"]); $no_rows = new input(); $no_rows->type("hidden"); $no_rows->id("no_rows"); $no_rows->name("no_rows"); $no_rows->value(0); $submit_btn = new button(); $submit_btn->value("SUBMIT"); $submit_btn->id("submit_btn"); ?>

ASSIGN STOCK

add(); ?>
add(); $date_booked->add(); ?>

query("stock_types", "SELECT * FROM stock_types"); $stock_type_list = ""; while ($stock_type = $stock_type_list_res->fetch_assoc()) { $stock_type_list .= ""; } $users_list_res = $db->query("users", "SELECT * FROM users"); $users_list = ""; while ($user = $users_list_res->fetch_assoc()) { $users_list .= ""; } ?>
Type Item Name Quantity User Assigned Open Balance Closing Balance
TOTAL :

add(); ?>