<?php
include "../../root.class.php";
$db = new db_safeguard();

if (isset($_POST['stock_no']) && $_POST['stock_no'] !== '') {

    $stock_no = $_POST['stock_no'];

    $stock_data_res = $db->query("stock", "SELECT * FROM stock WHERE stock_no = '$stock_no'");

    if ($stock_data_res && $stock_data_res->num_rows > 0) {

        $balance_res = $db->query("stock_trans",
            "SELECT SUM(
                CASE
                    WHEN status = 'BOOKED OUT' THEN -quantity
                    WHEN status = 'USED'       THEN -quantity
                    ELSE quantity
                END
            ) as total
            FROM stock_trans
            WHERE stock_no = '$stock_no'"
        );

        $balance_row    = $balance_res->fetch_assoc();
        $total_quantity = (float) ($balance_row['total'] ?? 0);

        echo $total_quantity . "|" . $stock_no;

    } else {
        echo "0|0";
    }

} else {
    echo "0|0";
}