Skip to content
logo
platformaerp.com

Grupy asortymentowe

Użycie grupy asortymentowej

SQL
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
select
    isnull(t1.total,0)+ isnull(t2.total,0) + isnull(t3.total,0)+ isnull(t4.total,0)+ isnull(t5.total,0) totals,
    d.dictionaryKeyGuid ,
    d.dictionaryName ,
    d.dictionaryValue,
    d.dictionaryUrl ,
    d.accounting, --prefix indeksu
    d.status
from common.dictionary d
    left join (select itemgroupid,count(*) total from wms.item group by itemgroupid) t1
    on d.dictionaryKeyGuid  = t1.itemgroupid
    left join (select itemGroupPriceID,count(*) total from wms.item  group by itemGroupPriceID) t2
    on d.dictionaryKeyGuid  = t2.itemGroupPriceID
    left join (select itemcategoryid,count(*) total from wms.itemclass  group by itemcategoryid) t3
    on d.dictionaryKeyGuid  = t3.itemcategoryid
    left join (select itemsubcategoryid,count(*) total from wms.itemclass  group by itemsubcategoryid) t4
    on d.dictionaryKeyGuid  = t4.itemsubcategoryid
    left join (select itemgroupid,count(*) total from wms.itemclass  group by itemgroupid) t5
    on d.dictionaryKeyGuid  = t5.itemgroupid
where
dictionaryName like 'itemgroup'
and dictionaryValue  like '%produkt%'
order by 1 desc

--

select * from common.dictionary where dictionaryName like 'itemgroup'

--select * from wms.item where itemGroupID  not in ()