mirror of
https://github.com/grocy/grocy.git
synced 2025-09-16 17:56:51 +00:00
10 lines
291 B
MySQL
10 lines
291 B
MySQL
|
CREATE VIEW stock_missing_products
|
||
|
|
AS
|
||
|
|
SELECT p.id, MAX(p.name) AS name, p.min_stock_amount - IFNULL(SUM(s.amount), 0) AS amount_missing
|
||
|
|
FROM products p
|
||
|
|
LEFT JOIN stock s
|
||
|
|
ON p.id = s.product_id
|
||
|
|
WHERE p.min_stock_amount != 0
|
||
|
|
GROUP BY p.id
|
||
|
|
HAVING IFNULL(SUM(s.amount), 0) < p.min_stock_amount
|