select_from_db_add_current_selected_column("stock", 'stock_type', "record_id = {$_GET['record_id']}", 'stock_type');
echo $html->input_html("record_id", $_GET['record_id'], 'record_id', 'record_id', 'hidden');
echo "
";
$item_code->add();
echo "
";
// echo $html->select_html_from_db('stock_categories', 'record_id', 'name', "1", 'category_id', 'category_id');
// echo $html->select_from_db_add_current_selected_column("stock", 'category_id', "record_id = {$_GET['record_id']}", 'category_id');
$category_id->add();
echo "
";
echo $html->select_html_from_db('suppliers', 'record_id', 'name', "1", 'supplier_id', 'supplier_id');
echo $html->select_from_db_add_current_selected_column("stock", 'supplier_id', "record_id = {$_GET['record_id']}", 'supplier_id');
echo "
";
$db = new db_safeguard();
$res = $db->query("stock", "SELECT * FROM `stock` WHERE record_id = {$_GET['record_id']}");
$data = $res->fetch_assoc();
echo "
";
// echo $html->text_formator_from_db("description", "stock", 'description', "record_id = {$_GET['record_id']}");
echo "
";
echo $html->input_html_from_db('stock', 'packaging_size', "record_id = {$_GET['record_id']}", 'packaging_size', 'packaging_size', 'packaging_size');
echo "
";
echo $html->input_html_from_db('stock', 'cost_price', "record_id = {$_GET['record_id']}", 'cost price', 'cost_price', 'cost_price');
echo "
";
echo "
";
echo $html->input_html_from_db('stock', 'adjustment_type', "record_id = {$_GET['record_id']}", 'Adjustment Type', 'adjustment_type', 'adjustment_type');
echo "
";
echo $html->input_html_from_db('stock', 'amount', "record_id = {$_GET['record_id']}", 'Amount', 'amount', 'amount');
echo "
";
echo $html->input_html_from_db('stock', 'max', "record_id = {$_GET['record_id']}", 'Max Amount', 'max', 'max');
echo "
";
echo $html->input_html_from_db('stock', 'min', "record_id = {$_GET['record_id']}", 'Min Amount', 'min', 'min');
?>
IN STOCK:
fetch_assoc()['in_stock']; ?>'
class="inputs" />
BARCODE";
echo $html->input_html_from_db('stock', 'barcode', "record_id = {$_GET['record_id']}", 'QR/Bar-code', 'barcode', 'barcode');
// echo $barcode->add_button("barcode");
// echo $html->QRCodeScanner("barcode");
// echo $html->qr_code_generator($_GET['record_id'], $_GET['record_id']);
// echo "
";
// echo "
Download QR Code";
echo $html->submit_btn("submit", 'SAVE', 'stock()', 'select_button'); ?>
html_form_ajax("stock", "UPDATE", "stock", '', false, [], '', [], 'barcode-zoom-control-0,');
$stock_res = $db->query("order_trans", "SELECT * FROM `order_trans` WHERE units_stock_id != 0 AND amount = 1 AND stock_id = {$_GET['record_id']}");
if ($stock_res->num_rows > 0) {
?>