add_styles_page(); $db = new db_safeguard(); // $html->check_user_type("ADMIN"); $stock_take_res = $db->query("stock_takes", "SELECT * FROM stock_takes WHERE record_id = {$_GET['record_id']}"); $stock_take_data = $stock_take_res->fetch_assoc(); $total_stock_value = 0; $total_non_stock_value = 0; $total_unit_value = 0; $total_value = 0; ?>

STOCK TAKE CREATED ON :

STOCK TAKE CREATED BY : get_username($stock_take_data['user_id_created']); ?>

STOCK TAKE DONE ON :

STOCK TAKE DONE BY : get_username($stock_take_data['user_id_done']); ?>

STOCK TAKE RESULTS (STOCK)

query("stock_take_stock", "SELECT * FROM stock_take_stock WHERE stock_take_id = {$_GET['record_id']}"); $stock_index = 1; echo "
"; echo $html->input_html("ITEM", "", '', '', 'inputs', 'font-size:1.5vw;'); echo $html->input_html("PACKAGE SIZE", "", '', '', 'inputs', 'width:17vw;font-size:1.5vw;'); echo $html->input_html("SYSTEM STOCK", "", '', '', 'inputs', 'width:17vw;font-size:1.5vw;'); echo $html->input_html("COUNTED STOCK", "", '', '', 'inputs', 'width:17vw;font-size:1.5vw;'); echo $html->input_html("STOCK VALUE", "", '', '', 'inputs', 'width:17vw;font-size:1.5vw;'); echo "
"; while ($stock = $stock_res->fetch_assoc()) { $stock_id = $stock['item_id']; echo "
"; echo $html->input_html("STOCK ID", $stock_id, "stock_id_$stock_index", "stock_id_$stock_index", "hidden"); $stock_details_res = $db->query("stock", "SELECT * FROM `stock` WHERE record_id = $stock_id"); $stock_details = $stock_details_res->fetch_assoc(); echo ""; echo $html->input_html("PACKAGE SIZE", $stock_details['packaging_size'], '', '', 'inputs', 'width:15vw;'); echo $html->input_html("AMOUNT IN STOCK", $stock['amount_in_stock'], "in_stock_amount_$stock_index", "in_stock_amount_$stock_index", 'inputs', 'width:15vw;', '', 'number', 'readonly'); echo $html->input_html("AMOUNT COUNTED", $stock['amount_counted'], "stock_amount_$stock_index", "stock_amount_$stock_index", 'inputs', 'width:15vw;', 'onchange="price_adjust(\'' . $stock_index . '\')"', 'number', 'required'); ?> document.getElementById('stock_amount_$stock_index').style.backgroundColor = 'red'; document.getElementById('stock_amount_$stock_index').style.color = 'white'; "; } else { echo ""; } // get stock value $stock_value_res = $db->query("stock", "SELECT * FROM `stock` WHERE record_id = $stock_id"); $stock_value = $stock_value_res->fetch_assoc(); $stck_value = is_numeric($stock['amount_counted']) && is_numeric($stock_value['cost_price']) ? $stock['amount_counted'] * $stock_value['cost_price'] : 0; if ($stock_value['stock_type'] == 0) { $total_stock_value += $stck_value; } if ($stock_value['stock_type'] == 1) { $total_non_stock_value += $stck_value; } if ($stock_value['stock_type'] == 2) { $total_unit_value += $stck_value; } $total_value += $stck_value; echo $html->input_html("Cost", $stck_value, "total_value_$stock_index", "total_value_$stock_index", 'inputs', 'width:15vw;', '', 'text', 'required'); echo $html->input_html("Cost", $stock_value['cost_price'], "cost_price_$stock_index", "cost_price_$stock_index", 'inputs', 'width:15vw;', '', 'text', 'hidden'); echo "
"; $stock_index++; } ?>
APPROVED & ADJUSTED BY "; echo $call_functions->get_username($stock_take_data['user_id_assesed']); echo " ON {$stock_take_data['date_assesed']}"; } else { echo $html->submit_btn('save', 'SAVE', ''); echo $html->submit_btn('add_stock', 'ADD STOCK', ''); echo $html->submit_btn('submit', 'APPROVE & ADJUST', ''); } ?>