<?php include "../../root.class.php";
$db = new db_safeguard();

// var_dump($_POST);

// echo "<br><br>";

// echo "<br>stock_no: {$_POST['stock_no']}";
// echo "<br>stock_type: {$_POST['stock_type']}";
// echo "<br>status: {$_POST['status']}";

if ($_POST['stock_type'] == "3") {
    $supplier_id = 0;
    // echo "<br>supplier_id: {$supplier_id}";

} else {
    $supplier_id = $_POST['supplier_id'];
    // echo "<br>supplier_id: {$_POST['supplier_id']}";
}

// echo "<br><br>";

// echo "INSERT INTO `stock_control`(`stock_no`, `stock_type`, `supplier_id`, `status`) VALUES ('{$_POST['stock_no']}','{$_POST['stock_type']}','{$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']}','{$supplier_id}','{$_POST['status']}')");

if ($_POST['stock_type'] == "1") {

    // echo "<br><br>";

    // echo "<br><br>stock_record_id: {$stock_record_id}";
    // echo "<br>item_name: {$_POST['item_name']}";
    // echo "<br>stock_type: {$_POST['stock_type']}";
    // echo "<br>supplier_id: {$supplier_id}";
    // echo "<br>item_price: {$_POST['item_price']}";
    // echo "<br>unit_of_measure: {$_POST['unit_of_measure']}";
    // echo "<br>status: {$_POST['status']}";
    // echo "<br>quantity: {$_POST['quantity']}";
    // echo "<br>vehicle_type: {$_POST['vehicle_type']}";

    // echo "<br><br>";

    // echo "INSERT INTO `oil_stock`(`stock_record_id`, `item_name`, `vehicle_type`, `unit_of_measure` ,`quantity`, `weight`) VALUES ('{$stock_record_id}','{$_POST['item_name']}','{$_POST['vehicle_type']}', '{$_POST['unit_of_measure']}', '{$_POST['quantity']}', '{$_POST['weight']}')";

    // echo "<br><br>";

    // echo "INSERT INTO `stock`(`stock_no`, `item_name`, `stock_type_id`, `supplier_id`, `item_price`, `unit_of_measure`,`vehicle_type`, `status`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['vehicle_type']}','{$_POST['status']}')";

    $stock_details = $db->query("stock", "INSERT INTO `stock`(`stock_no`, `item_name`, `stock_type_id`, `supplier_id`, `item_price`, `unit_of_measure`,`vehicle_type`, `status`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['vehicle_type']}','{$_POST['status']}')");

    // echo "<br><br>";

    // echo "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['quantity']}')";

    $stock_transactions = $db->query("stock_trans", "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['quantity']}')");

    // echo "<br><br>";

    // $oil_stock = $db->query("oil_stock", "INSERT INTO `oil_stock`(`stock_record_id`, `item_name`, `vehicle_type`, `unit_of_measure` ,`quantity`, `weight`) VALUES ('{$stock_record_id}','{$_POST['item_name']}','{$_POST['vehicle_type']}', '{$_POST['unit_of_measure']}', '{$_POST['quantity']}', '{$_POST['weight']}')");

} else if ($_POST['stock_type'] == "2") {

    // echo "<br><br>";

    // echo "<br><br>stock_record_id: {$stock_record_id}";
    // echo "<br>item_name: {$_POST['item_name']}";
    // echo "<br>stock_type: {$_POST['stock_type']}";
    // echo "<br>supplier_id: {$supplier_id}";
    // echo "<br>item_price: {$_POST['item_price']}";
    // echo "<br>unit_of_measure: {$_POST['unit_of_measure']}";
    // echo "<br>status: {$_POST['status']}";
    // echo "<br>quantity: {$_POST['quantity']}";

    // echo "<br><br>";

    // echo "INSERT INTO `stock`(`stock_no`, `item_name`, `stock_type_id`, `supplier_id`, `item_price`, `unit_of_measure`, `status`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['status']}')";

    $stock_details = $db->query("stock", "INSERT INTO `stock`(`stock_no`, `item_name`, `stock_type_id`, `supplier_id`, `item_price`, `unit_of_measure`, `status`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['status']}')");

    // echo "INSERT INTO `hydrolics_stock`(`stock_record_id`, `item_name`, `unit_of_measure`, `weight`, `quantity`) VALUES ('{$stock_record_id}','{$_POST['item_name']}','{$_POST['unit_of_measure']}','{$_POST['weight']}','{$_POST['quantity']}')";

    // echo "<br><br>";

    // echo "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['quantity']}')";

    $stock_transactions = $db->query("stock_trans", "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['quantity']}')");

    // $hydrolics_stock = $db->query("hydrolics_stock", "INSERT INTO `hydrolics_stock`(`stock_record_id`, `item_name`, `unit_of_measure`, `weight`, `quantity`) VALUES ('{$stock_record_id}','{$_POST['item_name']}','{$_POST['unit_of_measure']}','{$_POST['weight']}','{$_POST['quantity']}')");

} else if ($_POST['stock_type'] == "3") {

    // echo "<br><br>stock_record_id: {$stock_record_id}";
    // echo "<br>item_name: {$_POST['item_name']}";
    // echo "<br>stock_type: {$_POST['stock_type']}";
    // echo "<br>supplier_id: {$supplier_id}";
    // echo "<br>status: {$_POST['status']}";

    $quantity = 1;

    // echo "<br><br>";

    // echo "INSERT INTO `stock`(`stock_no`, `item_name`, `stock_type_id`, `supplier_id`, `status`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['status']}')";

    $stock_details = $db->query("stock", "INSERT INTO `stock`(`stock_no`, `item_name`, `stock_type_id`, `supplier_id`, `status`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['status']}')");

    // echo "INSERT INTO `pump_stock`(`stock_record_id`, `product_name`, `unit_of_measure`, `weight`, `quantity`) VALUES ('{$stock_record_id}','{$_POST['item_name']}','{$_POST['unit_of_measure']}', '{$_POST['quantity']}', '{$_POST['weight']}')";

    // echo "<br><br>";

    // echo "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$quantity}')";

    $stock_transactions = $db->query("stock_trans", "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$quantity}')");

    // $pump_stock = $db->query("pump_stock", "INSERT INTO `pump_stock`(`stock_record_id`, `product_name`, `unit_of_measure`, `weight`, `quantity`, `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']}')");

} else if ($_POST['stock_type'] == "4") {

    // echo "<br><br>";

    // echo "<br><br>stock_record_id: {$stock_record_id}";
    // echo "<br>item_name: {$_POST['item_name']}";
    // echo "<br>stock_type: {$_POST['stock_type']}";
    // echo "<br>supplier_id: {$supplier_id}";
    // echo "<br>item_price: {$_POST['item_price']}";
    // echo "<br>unit_of_measure: {$_POST['unit_of_measure']}";
    // echo "<br>status: {$_POST['status']}";
    // echo "<br>quantity: {$_POST['quantity']}";
    // echo "<br>serial_number: {$_POST['serial_number']}";

    // echo "<br><br>";

    // echo "INSERT INTO `stock`(`stock_no`, `item_name`, `serial_number`,`stock_type_id`, `supplier_id`, `item_price`, `unit_of_measure`, `status`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['serial_number']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['status']}')";

    $stock_details = $db->query("stock", "INSERT INTO `stock`(`stock_no`, `item_name`, `serial_number`,`stock_type_id`, `supplier_id`, `item_price`, `unit_of_measure`, `status`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['serial_number']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['status']}')");

    // echo "INSERT INTO `hammer_stock`(`record_id`, `stock_record_id`, `item_name`,`serial_number_in`,`serial_number_out` ,`unit_of_measure`, `quantity`, `weight`) VALUES ('{$stock_record_id}','{$_POST['item_name']}', '{$_POST['unit_of_measure']}', '{$_POST['quantity']}', '{$_POST['weight']}','{$_POST['open_balance']}','{$_POST['close_balance']}')";

    // echo "<br><br>";

    // echo "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['quantity']}')";

    $stock_transactions = $db->query("stock_trans", "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['quantity']}')");

    // $hammer_stock = $db->query("hammer_stock", "INSERT INTO `hammer_stock`(`record_id`, `stock_record_id`, `item_name`, `unit_of_measure`, `quantity`, `weight`) VALUES ('{$stock_record_id}','{$_POST['item_name']}','{$_POST['unit_of_measure']}', '{$_POST['quantity']}', '{$_POST['weight']}','{$_POST['open_balance']}','{$_POST['close_balance']}')");

} else if ($_POST['stock_type'] == "5") {

    // echo "<br><br>";

    // echo "<br><br>stock_record_id: {$stock_record_id}";
    // echo "<br>item_name: {$_POST['item_name']}";
    // echo "<br>stock_type: {$_POST['stock_type']}";
    // echo "<br>supplier_id: {$supplier_id}";
    // echo "<br>item_price: {$_POST['item_price']}";
    // echo "<br>unit_of_measure: {$_POST['unit_of_measure']}";
    // echo "<br>status: {$_POST['status']}";
    // echo "<br>quantity: {$_POST['quantity']}";

    // echo "<br><br>";

    // echo "INSERT INTO `stock`(`stock_no`, `item_name`, `stock_type_id`, `supplier_id`, `item_price`, `unit_of_measure`, `status`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['status']}')";

    $stock_details = $db->query("stock", "INSERT INTO `stock`(`stock_no`, `item_name`, `stock_type_id`, `supplier_id`, `item_price`, `unit_of_measure`, `status`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['status']}')");

    // echo "INSERT INTO `bolts_nuts_stock`(`record_id`, `stock_record_id`, `item_name`, `unit_of_measure`, `weight`, `quantity`, `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']}')";

    // echo "<br><br>";

    // echo "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['quantity']}')";

    $stock_transactions = $db->query("stock_trans", "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['quantity']}')");

    // $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`) VALUES ('{$stock_record_id}','{$_POST['item_name']}', '{$_POST['unit_of_measure']}', '{$_POST['quantity']}', '{$_POST['weight']}','{$_POST['open_balance']}','{$_POST['close_balance']}')");

} else if ($_POST['stock_type'] == "6") {

    // echo "<br><br>";

    // echo "<br><br>stock_record_id: {$stock_record_id}";
    // echo "<br>item_name: {$_POST['item_name']}";
    // echo "<br>stock_type: {$_POST['stock_type']}";
    // echo "<br>supplier_id: {$supplier_id}";
    // echo "<br>item_price: {$_POST['item_price']}";
    // echo "<br>unit_of_measure: {$_POST['unit_of_measure']}";
    // echo "<br>status: {$_POST['status']}";
    // echo "<br>quantity: {$_POST['quantity']}";

    // echo "<br><br>";

    // echo "INSERT INTO `stock`(`stock_no`, `item_name`, `stock_type_id`, `supplier_id`, `item_price`, `unit_of_measure`, `status`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['status']}')";

    $stock_details = $db->query("stock", "INSERT INTO `stock`(`stock_no`, `item_name`, `stock_type_id`, `supplier_id`, `item_price`, `unit_of_measure`, `status`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['stock_type']}','{$supplier_id}','{$_POST['item_price']}','{$_POST['unit_of_measure']}','{$_POST['status']}')");

    // echo "INSERT INTO `consumables_stock`(`record_id`, `stock_record_id`, `item_name`, `unit_of_measure`, `weight`, `quantity`, `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']}')";

    // echo "<br><br>";

    // echo "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['quantity']}')";

    $stock_transactions = $db->query("stock_trans", "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`) VALUES ('{$_POST['stock_no']}','{$_POST['item_name']}','{$_POST['quantity']}')");

    // $consumables_stock = $db->query("consumables_stock", "INSERT INTO `consumables_stock`(`record_id`, `stock_record_id`, `item_name`, `unit_of_measure`, `weight`, `quantity`, `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']}'");

}

?>
<script>
    alert("Stock Added Successfully!");
</script>
<?php

// echo "<br><br>";

echo "<script>window.location.href = '../stock_control/home.php';</script>";