${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 T1

LEFT JOIN DIM_SHOP T2 ON T1.BUSNO=T2.SHOPCODE

GROUP 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','','*/')}