";
echo "
stock_no: {$_POST['stock_no']}";
echo "
stock_type: {$_POST['stock_type']}";
echo "
supplier_id: {$_POST['supplier_id']}";
echo "
status: {$_POST['status']}";
echo "
";
echo "INSERT INTO `stock_control`(`stock_no`, `stock_type`, `supplier_id`, `status`) VALUES ('{$_POST['stock_no']}','{$_POST['stock_type']}','{$_POST['supplier_id']}','{$_POST['status']}')";
$stock_record_id = $db->query("stock_control", "INSERT INTO `stock_control`(`stock_no`, `stock_type`, `supplier_id`, `status`) VALUES ('{$_POST['stock_no']}','{$_POST['stock_type']}','{$_POST['supplier_id']}','{$_POST['status']}')");
if ($_POST['stock_type'] == "OILS") {
echo "
";
echo "INSERT INTO `oil_stock`(`stock_record_id`, `item_name`, `vehicle_type`, `unit_of_measure` ,`quantity`, `weight`, `open_balance`, `close_balance`, `team_assigned_id`) VALUES ('{$stock_record_id}','{$_POST['item_name']}','{$_POST['vehicle_type']}', '{$_POST['unit_of_measure']}', '{$_POST['quantity']}', '{$_POST['weight']}','{$_POST['open_balance']}','{$_POST['close_balance']}','{$_POST['team_assigned_id']}')";
echo "
stock_record_id: {$stock_record_id}";
echo "
item_name: {$_POST['item_name']}";
echo "
vehicle_type: {$_POST['vehicle_type']}";
echo "
unit_of_measure: {$_POST['unit_of_measure']}";
echo "
quantity: {$_POST['quantity']}";
echo "
weight: {$_POST['weight']}";
echo "
open_balance: {$_POST['open_balance']}";
echo "
close_balance: {$_POST['close_balance']}";
echo "
team_assigned_id: {$_POST['team_assigned_id']}";
echo "
";
$oil_stock = $db->query("oil_stock", "INSERT INTO `oil_stock`(`stock_record_id`, `item_name`, `vehicle_type`, `unit_of_measure` ,`quantity`, `weight`, `open_balance`, `close_balance`, `team_assigned_id`) VALUES ('{$stock_record_id}','{$_POST['item_name']}','{$_POST['vehicle_type']}', '{$_POST['unit_of_measure']}', '{$_POST['quantity']}', '{$_POST['weight']}','{$_POST['open_balance']}','{$_POST['close_balance']}','{$_POST['team_assigned_id']}')");
} else if ($_POST['stock_type'] == "HYDRAULICS") {
echo "
";
echo "INSERT INTO `hydrolics_stock`(`stock_record_id`, `item_name`, `unit_of_measure`, `weight`, `quantity`, `open_balance`, `close_balance`, `team_assigned_id`) VALUES ('{$stock_record_id}','{$_POST['item_name']}','{$_POST['unit_of_measure']}','{$_POST['weight']}','{$_POST['quantity']}','{$_POST['open_balance']}','{$_POST['close_balance']}','{$_POST['team_assigned_id']}')";
echo "
stock_record_id: {$stock_record_id}";
echo "
item_name: {$_POST['item_name']}";
echo "
unit_of_measure: {$_POST['unit_of_measure']}";
echo "
quantity: {$_POST['quantity']}";
echo "
weight: {$_POST['weight']}";
echo "
open_balance: {$_POST['open_balance']}";
echo "
close_balance: {$_POST['close_balance']}";
echo "
team_assigned_id: {$_POST['team_assigned_id']}";
echo "
";
$hydrolics_stock = $db->query("hydrolics_stock", "INSERT INTO `hydrolics_stock`(`stock_record_id`, `item_name`, `unit_of_measure`, `weight`, `quantity`, `open_balance`, `close_balance`, `team_assigned_id`) VALUES ('{$stock_record_id}','{$_POST['item_name']}','{$_POST['unit_of_measure']}','{$_POST['weight']}','{$_POST['quantity']}','{$_POST['open_balance']}','{$_POST['close_balance']}','{$_POST['team_assigned_id']}')");
} else if ($_POST['stock_type'] == "PUMPS") {
echo "
";
echo "INSERT INTO `pump_stock`(`record_id`, `stock_record_id`, `product_name`, `unit_of_measure`, `weight`, `quantity`, `open_balance`, `close_balance`, `team_assigned_id`) VALUES ('{$stock_record_id}','{$_POST['item_name']}','{$_POST['unit_of_measure']}', '{$_POST['quantity']}', '{$_POST['weight']}','{$_POST['open_balance']}','{$_POST['close_balance']}','{$_POST['team_assigned_id']}')";
echo "
stock_record_id: {$stock_record_id}";
echo "
item_name: {$_POST['item_name']}";
echo "
unit_of_measure: {$_POST['unit_of_measure']}";
echo "
quantity: {$_POST['quantity']}";
echo "
weight: {$_POST['weight']}";
echo "
open_balance: {$_POST['open_balance']}";
echo "
close_balance: {$_POST['close_balance']}";
echo "
team_assigned_id: {$_POST['team_assigned_id']}";
echo "
";
$pump_stock = $db->query("pump_stock", "INSERT INTO `pump_stock`(`record_id`, `stock_record_id`, `product_name`, `unit_of_measure`, `weight`, `quantity`, `open_balance`, `close_balance`, `team_assigned_id`) VALUES ('{$stock_record_id}','{$_POST['item_name']}', '{$_POST['unit_of_measure']}', '{$_POST['quantity']}', '{$_POST['weight']}','{$_POST['open_balance']}','{$_POST['close_balance']}','{$_POST['team_assigned_id']}')");
} else if ($_POST['stock_type'] == "HAMMERS") {
echo "
";
echo "INSERT INTO `hammer_stock`(`record_id`, `stock_record_id`, `item_name`,`serial_number_in`,`serial_number_out` ,`unit_of_measure`, `quantity`, `weight`, `team_assigned_id`) VALUES ('{$stock_record_id}','{$_POST['item_name']}', '{$_POST['unit_of_measure']}', '{$_POST['quantity']}', '{$_POST['weight']}','{$_POST['open_balance']}','{$_POST['close_balance']}','{$_POST['team_assigned_id']}')";
echo "
stock_record_id: {$stock_record_id}";
echo "
item_name: {$_POST['item_name']}";
echo "
serial_number_in: {$_POST['serial_number_in']}";
echo "
serial_number_out: {$_POST['serial_number_out']}";
echo "
unit_of_measure: {$_POST['unit_of_measure']}";
echo "
quantity: {$_POST['quantity']}";
echo "
weight: {$_POST['weight']}";
echo "
open_balance: {$_POST['open_balance']}";
echo "
close_balance: {$_POST['close_balance']}";
echo "
team_assigned_id: {$_POST['team_assigned_id']}";
echo "
";
$hammer_stock = $db->query("hammer_stock", "INSERT INTO `hammer_stock`(`record_id`, `stock_record_id`, `item_name`, `unit_of_measure`, `quantity`, `weight`, `team_assigned_id`) VALUES ('{$stock_record_id}','{$_POST['item_name']}','{$_POST['unit_of_measure']}', '{$_POST['quantity']}', '{$_POST['weight']}','{$_POST['open_balance']}','{$_POST['close_balance']}','{$_POST['team_assigned_id']}')");
} else if ($_POST['stock_type'] == "BOLTS AND NUTS") {
echo "
";
echo "INSERT INTO `bolts_nuts_stock`(`record_id`, `stock_record_id`, `item_name`, `unit_of_measure`, `weight`, `quantity`, `open_balance`, `close_balance`, `team_assigned_id`) VALUES ('{$stock_record_id}','{$_POST['item_name']}', '{$_POST['unit_of_measure']}', '{$_POST['quantity']}', '{$_POST['weight']}','{$_POST['open_balance']}','{$_POST['close_balance']}','{$_POST['team_assigned_id']}')";
echo "
stock_record_id: {$stock_record_id}";
echo "
item_name: {$_POST['item_name']}";
echo "
unit_of_measure: {$_POST['unit_of_measure']}";
echo "
quantity: {$_POST['quantity']}";
echo "
weight: {$_POST['weight']}";
echo "
open_balance: {$_POST['open_balance']}";
echo "
close_balance: {$_POST['close_balance']}";
echo "
team_assigned_id: {$_POST['team_assigned_id']}";
echo "
";
$bolts_nuts = $db->query("bolts_nuts_stock", "INSERT INTO `bolts_nuts_stock`(`record_id`, `stock_record_id`, `item_name`, `unit_of_measure`, `weight`, `quantity`, `open_balance`, `close_balance`, `team_assigned_id`) VALUES ('{$stock_record_id}','{$_POST['item_name']}', '{$_POST['unit_of_measure']}', '{$_POST['quantity']}', '{$_POST['weight']}','{$_POST['open_balance']}','{$_POST['close_balance']}','{$_POST['team_assigned_id']}')");
} else if ($_POST['stock_type'] == "CONSUMABLES") {
echo "
";
echo "INSERT INTO `consumables_stock`(`record_id`, `stock_record_id`, `item_name`, `unit_of_measure`, `weight`, `quantity`, `team_assigned_id`, `open_balance`, `close_balance`) VALUES ('{$stock_record_id}','{$_POST['item_name']}', '{$_POST['unit_of_measure']}', '{$_POST['quantity']}', '{$_POST['weight']}','{$_POST['open_balance']}','{$_POST['close_balance']}','{$_POST['team_assigned_id']}')";
echo "
stock_record_id: {$stock_record_id}";
echo "
item_name: {$_POST['item_name']}";
echo "
unit_of_measure: {$_POST['unit_of_measure']}";
echo "
quantity: {$_POST['quantity']}";
echo "
weight: {$_POST['weight']}";
echo "
open_balance: {$_POST['open_balance']}";
echo "
close_balance: {$_POST['close_balance']}";
echo "
team_assigned_id: {$_POST['team_assigned_id']}";
echo "
";
$consumables_stock = $db->query("consumables_stock", "INSERT INTO `consumables_stock`(`record_id`, `stock_record_id`, `item_name`, `unit_of_measure`, `weight`, `quantity`, `team_assigned_id`, `open_balance`, `close_balance`) VALUES ('{$stock_record_id}','{$_POST['item_name']}','{$_POST['unit_of_measure']}', '{$_POST['quantity']}', '{$_POST['weight']}','{$_POST['open_balance']}','{$_POST['close_balance']}','{$_POST['team_assigned_id']}')");
}
echo "
";
// echo "";