供应商查询
select b.COM_NAME ,a.IMPORTANCE_NAME,a.ct
from
(select APPLYCOM_ID,IMPORTANCE_NAME,
count(DATA_ID) as ct
from qjcx_product_structure_provider_info
group by IMPORTANCE_NAME_KEY,
APPLYCOM_ID) a
left join qjcx_org_company b
on a.APPLYCOM_ID=b.COM_ID
--------------------------------------------------------------------------------------------
select b.COM_NAME,a.IMPORTANCE_NAME,
count(a.DATA_ID) as ct
from qjcx_product_structure_provider_info a
left join qjcx_org_company b
on a.APPLYCOM_ID=b.COM_ID
group by a.IMPORTANCE_NAME_KEY,
a.APPLYCOM_ID
----------------------------------------------------------------------------------------------------
=if(ccxx.CATEGORY_KEY=11,'产品',if(ccxx.CATEGORY_KEY=12,'过程',if(ccxx.CATEGORY_KEY=13,'物资','')))
旧版：
select b.NAME,a.IMPORTANCE_NAME_KEY,a.ct from (
select PROVIDER_DATA_ID,
IMPORTANCE_NAME_KEY,
count(IMPORTANCE_NAME_KEY) as ct
from qjcx_product_permission
group by PROVIDER_DATA_ID,
IMPORTANCE_NAME_KEY
) a left join qjcx_gys_infos b on a.PROVIDER_DATA_ID=b.DATA_ID ;
select b.NAME,c.IMPORTANCE_NAME_KEY,c.ct from (
select PROVIDER_ID_CRC,
IMPORTANCE_NAME_KEY,
count(IMPORTANCE_NAME_KEY) as ct
from qjcx_product_permission
group by PROVIDER_ID_CRC,
IMPORTANCE_NAME_KEY
limit 100
) c left join qjcx_gys_infos b on c.PROVIDER_ID_CRC=b.DATA_ID ;
select b.NAME,c.IMPORTANCE_NAME_KEY,c.ct from (
select PROVIDER_ID_CRC,
IMPORTANCE_NAME_KEY,
count(IMPORTANCE_NAME_KEY) as ct
from qjcx_product_permission
group by PROVIDER_ID_CRC,
IMPORTANCE_NAME_KEY
) c left join qjcx_gys_infos b on c.PROVIDER_ID_CRC=b.DATA_ID ;
select b.NAME,c.imp,c.ct from (
select PROVIDER_ID_CRC,IMPORTANCE_NAME_KEY*1 imp,
count(IMPORTANCE_NAME_KEY) as ct
from qjcx_product_permission
where APPLYDEPTCODE in (select id
from ORGDEPARTMENT where parentdepartmentid
='${$user.org.id}')
group by PROVIDER_ID_CRC,
IMPORTANCE_NAME_KEY
) c left join
qjcx_gys_infos b
on c.PROVIDER_ID_CRC=b.DATA_ID
