"; // echo "
booking_date : " . $_POST['date_booked']; // echo "
jc_no : " . $_POST['jobcard_no']; // echo "
pump_code : " . $_POST['pump_code']; echo "
clean booking date : " . $clean_date = str_replace("T", " ", $_POST['date_booked']); // echo "
no_rows : " . $_POST['no_rows'] . "
"; // echo "

"; $index = 1; while ($index <= $_POST['no_rows']) { // echo "
INDEX : " . $index; // echo "
stock_no : " . $_POST["stock_no_" . $index]; // echo "
stock_type : " . $_POST["type_defualt_" . $index]; // echo "
item_name : " . $_POST["item_defualt_" . $index]; // echo "
quantity : " . $_POST["quantity_defualt_" . $index]; // echo "
team_id : " . $_POST["team_defualt_" . $index]; // echo "
stock_no : " . $_POST["stock_no_defualt_" . $index]; // echo "
open_balance : " . $_POST['open_defualt_' . $index]; // echo "
close_balance : " . $_POST['close_defualt_' . $index]; // echo "

"; $stock_res = $db->query("stock_trans", "SELECT * FROM stock_trans WHERE stock_no = '{$_POST["stock_no_defualt_" . $index]}'"); while ($stock = $stock_res->fetch_assoc()) { $new_quantity = $stock['quantity'] - $_POST['quantity_defualt_' . $index]; // echo "
CURRENT QUANTITY : " . $stock['quantity'] // . "
QUANTITY TO SUBTRACT : " . $_POST['quantity_defualt_' . $index]; // echo "
NEW QUANTITY : " . $new_quantity; if ($new_quantity < 0) { ?>
"; // echo "INSERT INTO `book_stock`(`booking_date`, `pump_code`, `jc_no`, `stock_type_id`, `stock_no`, `item_name`, `quantity`, `team_assigned_id`, `open_balance`, `close_balance`) VALUES ('{$clean_date}','{$_POST['pump_code']}','{$_POST['jobcard_no']}','{$_POST["type_defualt_" . $index]}','{$_POST["stock_no_defualt_" . $index]}','{$_POST["item_defualt_" . $index]}','{$_POST["quantity_defualt_" . $index]}','{$_POST["team_defualt_" . $index]}','{$_POST['open_defualt_' . $index]}','{$_POST['close_defualt_' . $index]}')"; $booked_stock = $db->query("book_stock", "INSERT INTO `book_stock`(`booking_date`, `pump_code`, `jc_no`, `stock_type_id`, `stock_no`, `item_name`, `quantity`, `team_assigned_id`, `open_balance`, `close_balance`) VALUES ('{$clean_date}','{$_POST['pump_code']}','{$_POST['jobcard_no']}','{$_POST["type_defualt_" . $index]}','{$_POST["stock_no_defualt_" . $index]}','{$_POST["item_defualt_" . $index]}','{$_POST["quantity_defualt_" . $index]}','{$_POST["team_defualt_" . $index]}','{$_POST['open_defualt_' . $index]}','{$_POST['close_defualt_' . $index]}')"); // echo "

"; // echo "
INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('{$stock['stock_no']}', '{$_POST["item_defualt_" . $index]}', '{$_POST['quantity_defualt_' . $index]}')"; $stock_transaction = $db->query("stock_trans","INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('{$stock['stock_no']}', '{$_POST["item_defualt_" . $index]}', '{$_POST['quantity_defualt_' . $index]}')"); } // echo "

"; } $index++; } echo "";