";
// var_dump($_POST);
// echo "
";
$team_assigned = $_POST['team_assigned'];
$pump_code = $_POST['pump_code'];
$clean_date = str_replace("T", " ", $_POST['date_booked']);
$rows = $_POST['no_rows'];
$order_no_data = $db->query("book_stock", "SELECT COUNT(*) as total FROM book_stock");
$row = $order_no_data->fetch_assoc();
$order_num = $row['total'] + 1;
$order_no = "SO_" . $order_num;
// echo "
order_no : " . $order_no;
// echo "
booking_date : " . $_POST['date_booked'];
// echo "
team_assigned : " . $team_assigned;
// echo "
pump_code : " . $pump_code;
// echo "
clean booking date : " . $clean_date;
// echo "
no_rows : " . $rows;
// echo "
";
$index = 1;
// echo "
";
// echo "INSERT INTO `book_stock`(`order_no`, `team_assigned_id`, `booking_date`) VALUES ('$order_no','$team_assigned','$clean_date')";
$db->query("book_stock", "INSERT INTO `book_stock`(`order_no`, `team_assigned_id`, `booking_date`) VALUES ('$order_no','$team_assigned','$clean_date')");
// echo "
";
while ($index <= $rows) {
$type = $_POST["type_" . $index];
$item_name = $_POST["item_name_" . $index];
$quantity = $_POST["quantity_" . $index];
$registration_no = $_POST["registration_no_" . $index];
$open_balance = $_POST['open_balance_' . $index];
$close_balance = $_POST['close_balance_' . $index];
// echo "
INDEX : " . $index;
// echo "
stock_type_$index : " . $type;
// echo "
item_name_$index : " . $item_name;
// echo "
quantity_$index : " . $quantity;
// echo "
registration_no_$index : " . $registration_no;
// echo "
open_balance_$index : " . $open_balance;
// echo "
close_balance_$index : " . $close_balance;
// echo "
";
$stock_res = $db->query("stock_trans", "SELECT * FROM stock_trans WHERE item_name = '$item_name'");
while ($stock = $stock_res->fetch_assoc()) {
// echo "
";
echo "
stock_no : " . $stock_no = $stock["stock_no"];
// echo "
";
// echo "INSERT INTO `book_stock_list`(`order_no`, `pump_code`, `registration_no`, `stock_type_id`, `stock_no`, `item_name`, `amount`, `open_balance`, `close_balance`) VALUES ('$order_no', '$pump_code','$registration_no','$type','$stock_no','$item_name','$quantity','$open_balance','$close_balance')";
$db->query("book_stock_list", "INSERT INTO `book_stock_list`(`order_no`, `pump_code`, `registration_no`, `stock_type_id`, `stock_no`, `item_name`, `amount`, `open_balance`, `close_balance`) VALUES ('$order_no','$pump_code','$registration_no','$type','$stock_no','$item_name','$quantity','$open_balance','$close_balance')");
// echo "
";
// echo "
INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`, `status`) VALUES ('$stock_no', '$item_name', '$quantity', 'BOOKED OUT')";
$db->query("stock_trans", "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`, `status`) VALUES ('$stock_no', '$item_name', '$quantity', 'BOOKED OUT')");
// echo "
";
}
$index++;
}
echo "";