<?php
include "../../root.class.php";
$db = new db_safeguard();

if (isset($_POST['item_name']) && $_POST['item_name'] !== '') {

    $item_name = $_POST['item_name'];

    $stock_data_res = $db->query("stock", "SELECT * FROM stock WHERE item_name = '$item_name'");
    // echo "SELECT * FROM stock WHERE item_name = '$item_name'";

    if ($stock_data_res && $stock_data_res->num_rows > 0) {
        $stock_data = $stock_data_res->fetch_assoc();

        $stock_trans_res = $db->query("stock_trans", "SELECT * FROM stock_trans WHERE stock_no = '{$stock_data['stock_no']}'");
        // echo "SELECT * FROM stock_trans WHERE stock_no = '{$stock_data['stock_no']}'";
        // $stock_trans = $stock_trans_res->fetch_assoc();

        $total_quantity = 0;

        while ($stock = $stock_trans_res->fetch_assoc()) {
            $total_quantity = $total_quantity + $stock["quantity"];
        }
        // quantity|cost
        echo $total_quantity . "|" . $stock_data['stock_no'];
    } else {
        echo "0|0";
    }

} else {
    echo "0|0";
}