Edit Report:TDUMP
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- TDUMP
--
--
-- VARIABLE: {
-- name: "mfg",
-- display: "Manufacturer",
-- type: "select",
-- database_options: { table: "manufacturer", display: "name", column: "manufacturer_id", order:{ column: "name" , order: "ASC"} },
-- multiple:true,
-- empty:true,
-- }
--
--
SELECT NAME
,
stockmaster.stockid,
mfgpart,
sum( quantity ) AS qty
FROM
stockmaster
INNER JOIN locstock ON stockmaster.stockid = locstock.stockid
INNER JOIN product_to_manufacturer ON stockmaster.stockid = product_to_manufacturer.stockid
INNER JOIN manufacturer ON product_to_manufacturer.manufacturer_id = manufacturer.manufacturer_id
WHERE 1
{% if mfg[0] != '' %}
{% if mfg|length > 0 %}
and manufacturer.manufacturer_id in (
{% for m in mfg %}
'{{ m }}'
{{ not loop.last ? ',' }}
{% endfor %})
{% endif %}
{% endif %}
GROUP BY
stockid