${if(len(p_comp)!=0 and p_zq='1' and p_pq='1' and p_shop = '1','','/*')}--公司td_qhs as (SELECT T2.SUBCOMPID,T1.WAREID,COUNT(BUSNO), sum(t1.ts) as ts FROM td_kc T1LEFT JOIN DIM_SHOP T2 ON T1.BUSNO=T2.SHOPCODEGROUP BY T2.SUBCOMPID,T1.WAREID),TD_Z AS( SELECT SUBCOMPID, COUNT(DISTINCT SHOPCODE ) SHOPCODE FROM DIM_SHOP GROUP BY SUBCOMPID),TOTAL AS ( SELECT T1.WAREID,T1.TS FROM TD_qhs T1 INNER JOIN TD_Z T2 ON T1.SUBCOMPID =T2.SUBCOMPID WHERE T1.SHOPCODE = T2.SHOPCODE ${if(len(p_comp)=0,"","and T2.subcompid = '"+ p_comp +"'")})${if(len(p_comp)!=0 and p_zq='1' and p_pq='1' and p_shop = '1','','*/')}
