<?php include "../../root.class.php";
$db = new db_safeguard();

// echo "<br><br>";

// var_dump($_POST);

// echo "<br><br>";

if ($_POST['stock_type_id'] == "1") {

    // echo "UPDATE `stock` SET `stock_no`='{$_POST['stock_no']}',`item_name`='{$_POST['item_name']}',`stock_type_id`='{$_POST['stock_type_id']}',`supplier_id`='{$_POST['supplier_id']}',`item_price`='{$_POST['item_price']}',`unit_of_measure`='{$_POST['unit_of_measure']}',`vehicle_type`='{$_POST['vehicle_type']}',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'";

    $stock_data = $db->query("stock", "UPDATE `stock` SET `stock_no`='{$_POST['stock_no']}',`item_name`='{$_POST['item_name']}',`stock_type_id`='{$_POST['stock_type_id']}',`supplier_id`='{$_POST['supplier_id']}',`item_price`='{$_POST['item_price']}',`unit_of_measure`='{$_POST['unit_of_measure']}',`vehicle_type`='{$_POST['vehicle_type']}',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'");

    // echo "<br><br>";

    // echo "UPDATE `stock_trans` SET `item_name`='{$_POST['item_name']}',`quantity`='{$_POST['quantity']}' WHERE stock_no='{$_POST['stock_no']}'";

    $update_stock_trans = $db->query("stock_trans", "UPDATE `stock_trans` SET `item_name`='{$_POST['item_name']}',`quantity`='{$_POST['quantity']}' WHERE stock_no='{$_POST['stock_no']}'");

    // UPDATE `stock_trans` SET `record_id`='[value-1]',`jobcard_no`='[value-2]',`stock_no`='[value-3]',`item_name`='[value-4]',`date_booked`='[value-5]',`datetime_created`='[value-6]',`quantity`='[value-7]',`user_id`='[value-8]' WHERE 1

    // echo "<br><br>";
    // UPDATE `stock` SET `stock_no`='{$_POST['stock_no']}',`item_name`='{$_POST['item_name']}',`stock_type_id`='{$_POST['stock_type_id']}',`supplier_id`='{$_POST['supplier_id']}',`item_price`='{$_POST['item_price']}',`unit_of_measure`='{$_POST['unit_of_measure']}',`vehicle_type`='{$_POST['vehicle_type']}',`pump_code`='{$_POST['pump_code']}',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'

} else if ($_POST['stock_type_id'] == "2") {

    if ($_POST['type'] == "Pipe") {

        // echo "<br>pipe_size: {$_POST['pipe_size']}";

        // echo "<br><br>";

        // echo "UPDATE `stock` SET `stock_no`='{$_POST['stock_no']}',`item_name`='{$_POST['item_name']}',`type`='{$_POST['type']}',`size`='{$_POST['pipe_size']}',`stock_type_id`='{$_POST['stock_type_id']}',`supplier_id`='{$_POST['supplier_id']}',`item_price`='{$_POST['item_price']}',`unit_of_measure`='{$_POST['unit_of_measure']}',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'";

        $stock_data = $db->query("stock","UPDATE `stock` SET `stock_no`='{$_POST['stock_no']}',`item_name`='{$_POST['item_name']}',`type`='{$_POST['type']}',`size`='{$_POST['pipe_size']}',`stock_type_id`='{$_POST['stock_type_id']}',`supplier_id`='{$_POST['supplier_id']}',`item_price`='{$_POST['item_price']}',`unit_of_measure`='{$_POST['unit_of_measure']}',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'");

        // echo "<br><br>";

        // echo "UPDATE `stock_trans` SET `item_name`='{$_POST['item_name']}',`quantity`='{$_POST['quantity']}' WHERE stock_no='{$_POST['stock_no']}'";

        $stock_trans = $db->query("stock_trans", "UPDATE `stock_trans` SET `item_name`='{$_POST['item_name']}',`quantity`='{$_POST['quantity']}' WHERE stock_no='{$_POST['stock_no']}'");

    } else {
        
        // echo "<br>type_size: {$_POST['type_size']}";
        // echo "<br>collar_size: {$_POST['collar_size']}";

        // echo "<br><br>";

        // echo "UPDATE `stock` SET `stock_no`='{$_POST['stock_no']}',`item_name`='{$_POST['item_name']}',`stock_type_id`='{$_POST['stock_type_id']}',`type`='{$_POST['type_size']}', `size`='{$_POST['collar_size']}',`supplier_id`='{$_POST['supplier_id']}',`item_price`='{$_POST['item_price']}',`unit_of_measure`='{$_POST['unit_of_measure']}',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'";

        $stock_data = $db->query("stock","UPDATE `stock` SET `stock_no`='{$_POST['stock_no']}',`item_name`='{$_POST['item_name']}',`stock_type_id`='{$_POST['stock_type_id']}',`type`='{$_POST['type_size']}', `size`='{$_POST['collar_size']}',`supplier_id`='{$_POST['supplier_id']}',`item_price`='{$_POST['item_price']}',`unit_of_measure`='{$_POST['unit_of_measure']}',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'");

        // echo "<br><br>";

        // echo "UPDATE `stock_trans` SET `item_name`='{$_POST['item_name']}',`quantity`='{$_POST['quantity']}' WHERE stock_no='{$_POST['stock_no']}'";

        $stock_trans = $db->query("stock_trans", "UPDATE `stock_trans` SET `item_name`='{$_POST['item_name']}',`quantity`='{$_POST['quantity']}' WHERE stock_no='{$_POST['stock_no']}'");

    }

} else if ($_POST['stock_type_id'] == "3") {

    // echo "UPDATE `stock` SET `stock_no`='{$_POST['stock_no']}',`item_name`='{$_POST['item_name']}',`stock_type_id`='{$_POST['stock_type_id']}',`pump_code`='{$_POST['pump_code']}',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'";

    // echo "<br><br>";

    $stock_data = $db->query("stock", "UPDATE `stock` SET `stock_no`='{$_POST['stock_no']}',`item_name`='{$_POST['item_name']}',`stock_type_id`='{$_POST['stock_type_id']}',`pump_code`='{$_POST['pump_code']}',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'");

    // UPDATE `stock_trans` SET `record_id`='[value-1]',`jobcard_no`='[value-2]',`stock_no`='[value-3]',`item_name`='[value-4]',`date_booked`='[value-5]',`datetime_created`='[value-6]',`quantity`='[value-7]',`user_id`='[value-8]' WHERE 1

    // echo "<br><br>";

    // echo "UPDATE `stock_trans` SET `item_name`='{$_POST['item_name']}',`quantity`='{$_POST['quantity']}' WHERE stock_no='{$_POST['stock_no']}'";

    $update_stock_trans = $db->query("stock_trans", "UPDATE `stock_trans` SET `item_name`='{$_POST['item_name']}',`quantity`='{$_POST['quantity']}' WHERE stock_no='{$_POST['stock_no']}'");

    // UPDATE `stock` SET `stock_no`='{$_POST['stock_no']}',`item_name`='{$_POST['item_name']}',`stock_type_id`='{$_POST['stock_type_id']}',`supplier_id`='{$_POST['supplier_id']}',`item_price`='{$_POST['item_price']}',`unit_of_measure`='{$_POST['unit_of_measure']}',`vehicle_type`='{$_POST['vehicle_type']}',`pump_code`='{$_POST['pump_code']}',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'

} else if ($_POST['stock_type_id'] == "4") {

    // echo "UPDATE `stock` SET `stock_no`='{$_POST['stock_no']}',`item_name`='{$_POST['item_name']}',`stock_type_id`='{$_POST['stock_type_id']}',`supplier_id`='{$_POST['supplier_id']}',`serial_number` = '{$_POST['serial_number']}',`item_price`='{$_POST['item_price']}',`unit_of_measure`='{$_POST['unit_of_measure']}',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'";

    $stock_data = $db->query("stock", "UPDATE `stock` SET `stock_no`='{$_POST['stock_no']}',`item_name`='{$_POST['item_name']}',`stock_type_id`='{$_POST['stock_type_id']}',`supplier_id`='{$_POST['supplier_id']}',`serial_number` = '{$_POST['serial_number']}',`item_price`='{$_POST['item_price']}',`unit_of_measure`='{$_POST['unit_of_measure']}',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'");

    // echo "<br><br>";

    // UPDATE `stock_trans` SET `record_id`='[value-1]',`jobcard_no`='[value-2]',`stock_no`='[value-3]',`item_name`='[value-4]',`date_booked`='[value-5]',`datetime_created`='[value-6]',`quantity`='[value-7]',`user_id`='[value-8]' WHERE 1

    // echo "<br><br>";

    // echo "UPDATE `stock_trans` SET `item_name`='{$_POST['item_name']}',`quantity`='{$_POST['quantity']}' WHERE stock_no='{$_POST['stock_no']}'";

    $update_stock_trans = $db->query("stock_trans", "UPDATE `stock_trans` SET `item_name`='{$_POST['item_name']}',`quantity`='{$_POST['quantity']}' WHERE stock_no='{$_POST['stock_no']}'");

    // UPDATE `stock` SET `stock_no`='{$_POST['stock_no']}',`item_name`='{$_POST['item_name']}',`stock_type_id`='{$_POST['stock_type_id']}',`supplier_id`='{$_POST['supplier_id']}',`item_price`='{$_POST['item_price']}',`unit_of_measure`='{$_POST['unit_of_measure']}',`vehicle_type`='{$_POST['vehicle_type']}',`pump_code`='{$_POST['pump_code']}',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'

} else if ($_POST['stock_type_id'] == "5") {

    // echo "UPDATE `stock` SET `stock_no`='{$_POST['stock_no']}',`item_name`='{$_POST['item_name']}',`stock_type_id`='{$_POST['stock_type_id']}',`supplier_id`='{$_POST['supplier_id']}',`item_price`='{$_POST['item_price']}',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'";

    $stock_data = $db->query("stock", "UPDATE `stock` SET `stock_no`='{$_POST['stock_no']}',`item_name`='{$_POST['item_name']}',`type`='{$_POST['bn_type']}',`size`='{$_POST['bn_size']}',`stock_type_id`='{$_POST['stock_type_id']}',`supplier_id`='{$_POST['supplier_id']}',`item_price`='{$_POST['item_price']}',`unit_of_measure`='{$_POST['unit_of_measure']}',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'");

    // echo "<br><br>";

    // echo "UPDATE `stock_trans` SET `item_name`='{$_POST['item_name']}',`quantity`='{$_POST['quantity']}' WHERE stock_no='{$_POST['stock_no']}'";

    $update_stock_trans = $db->query("stock_trans", "UPDATE `stock_trans` SET `item_name`='{$_POST['item_name']}',`quantity`='{$_POST['quantity']}' WHERE stock_no='{$_POST['stock_no']}'");

    // $update_stock_trans = $db->query("stock_trans", "UPDATE `stock_trans` SET `item_name`='{$_POST['item_name']}',`quantity`='{$_POST['quantity']}' WHERE stock_no='{$_POST['stock_no']}'");

    // UPDATE `stock` SET `stock_no`='{$_POST['stock_no']}',`item_name`='{$_POST['item_name']}',`stock_type_id`='{$_POST['stock_type_id']}',`supplier_id`='{$_POST['supplier_id']}',`item_price`='{$_POST['item_price']}',`unit_of_measure`='{$_POST['unit_of_measure']}',`vehicle_type`='{$_POST['vehicle_type']}',`pump_code`='{$_POST['pump_code']}',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'

} else if ($_POST['stock_type_id'] == "6") {

    // echo "UPDATE `stock` SET `stock_no`='{$_POST['stock_no']}',`item_name`='{$_POST['item_name']}',`stock_type_id`='{$_POST['stock_type_id']}',`supplier_id`='{$_POST['supplier_id']}',`item_price`='{$_POST['item_price']}',`unit_of_measure`='{$_POST['unit_of_measure']}',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'";

    $stock_data = $db->query("stock", "UPDATE `stock` SET `stock_no`='{$_POST['stock_no']}',`item_name`='{$_POST['item_name']}',`stock_type_id`='{$_POST['stock_type_id']}',`supplier_id`='{$_POST['supplier_id']}',`item_price`='{$_POST['item_price']}',`unit_of_measure`='{$_POST['unit_of_measure']}',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'");

    // echo "<br><br>";

    // echo "UPDATE `stock_trans` SET `item_name`='{$_POST['item_name']}',`quantity`='{$_POST['quantity']}' WHERE stock_no='{$_POST['stock_no']}'";

    $update_stock_trans = $db->query("stock_trans", "UPDATE `stock_trans` SET `item_name`='{$_POST['item_name']}',`quantity`='{$_POST['quantity']}' WHERE stock_no='{$_POST['stock_no']}'");

    // $update_stock_trans = $db->query("stock_trans", "UPDATE `stock_trans` SET `item_name`='{$_POST['item_name']}',`quantity`='{$_POST['quantity']}' WHERE stock_no='{$_POST['stock_no']}'");

    // UPDATE `stock` SET `stock_no`='{$_POST['stock_no']}',`item_name`='{$_POST['item_name']}',`stock_type_id`='{$_POST['stock_type_id']}',`supplier_id`='{$_POST['supplier_id']}',`item_price`='{$_POST['item_price']}',`unit_of_measure`='{$_POST['unit_of_measure']}',`vehicle_type`='{$_POST['vehicle_type']}',`pump_code`='{$_POST['pump_code']}',`status`='{$_POST['status']}' WHERE record_id = '{$_POST['record_id']}'

}

?>
<script>
    alert("STOCK UPDATED SUCCESSFULLY");
</script>
<?php
// echo "<br><br>";

echo "<script>window.location.href = '../stock_control/current_stock.php';</script>";