add_styles_page(); $db = new db_safeguard(); $date_returned_label = new label(); $date_returned_label->for("date_returned_label"); $date_returned_label->value("DATE RETURNED : "); $date_returned_label->addAttribute("style", "font-size: 1.5em; width: 30%;"); $date_returned = new input(); $date_returned->class("inputs"); $date_returned->name("date_returned"); $date_returned->id("date_returned"); $date_returned->type("datetime-local"); $date_returned->style("font-size: 1.5em; width: 80%; margin: 0.5vw auto;"); $date_booked_label = new label(); $date_booked_label->for("date_booked_label"); $date_booked_label->value("DATE BOOKED : "); $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->style("font-size: 1.5em; width: 80%; margin: 0.5vw auto;"); $date_booked->value_from_db("book_stock", "booking_date", "record_id = {$_GET['record_id']}"); $date_booked->addAttribute("readonly", "readonly"); $date_booked->addAttribute("disabled", "disabled"); $user_id = new input(); $user_id->type("hidden"); $user_id->id("user_id"); $user_id->name("user_id"); $user_id->value($_SESSION["user_id"]); $submit_btn = new button(); $submit_btn->value("SUBMIT"); $submit_btn->id("submit_btn"); $booked_stock_res = $db->query("book_stock", "SELECT * FROM book_stock WHERE record_id = '{$_GET['record_id']}'"); $booked_stock = $booked_stock_res->fetch_assoc(); $booked_data_res = $db->query("book_stock_list", "SELECT * FROM book_stock_list WHERE order_no = '{$booked_stock['order_no']}'"); // echo "SELECT * FROM book_stock_list WHERE order_no = '{$booked_stock['order_no']}'"; ?>

STOCK ASSIGNED

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

add(); $teams_list_res = $db->query("teams", "SELECT * FROM teams"); $teams_list = ""; while ($teams = $teams_list_res->fetch_assoc()) { $teams_list .= ""; } ?> num_rows; if ($rows > 0) { $i = 1; while ($booked_data = $booked_data_res->fetch_assoc()) { $stock_type_data = $db->query("stock_types", "SELECT * FROM stock_types WHERE record_id = '{$booked_data['stock_type_id']}'"); $stock_type = $stock_type_data->fetch_assoc(); ?>
Type Item Name Amount Registaration No. Open Balance Closing Balance
TOTAL :

RETURN STOCK

query("book_stock_list", "SELECT * FROM book_stock_list WHERE order_no = '{$booked_stock['order_no']}'"); $index = $return_data_res->num_rows; // echo $index; if ($index > 0) { $index = 1; while ($return_data = $return_data_res->fetch_assoc()) { $stock_type_res = $db->query("stock_types", "SELECT * FROM stock_types WHERE record_id = '{$return_data['stock_type_id']}'"); $stock_type_data = $stock_type_res->fetch_assoc(); ?>
Type Item Name Amount Registaration No. Open Balance Closing Balance
TOTAL :
add(); ?>