0
ORDER BY p.name ASC
";
} else {
// ==========================
// PRODUCT WISE STOCK
// ==========================
$sql = "
SELECT
p.id AS product_id,
p.name AS product_name,
p.brand,
p.category,
p.hsn_code,
p.unit,
SUM(pi.available_qty) AS total_stock,
MAX(pi.mrp) AS mrp,
MAX(pi.purchase_price) AS purchase_price,
MAX(pi.gst_percent) AS gst_percent,
pi.selling_price AS selling_price
FROM purchase_items pi
JOIN products p ON p.id = pi.product_id
WHERE pi.available_qty > 0
GROUP BY p.id
ORDER BY p.name ASC
";
}
$result = $conn->query($sql);
?>