update bwptest1.sys_item_listsetSUBSELECT_SQL = '{select case when (select * from UserHasAction(%CurrentUserID%,'23,24,146,148'))=1 then sql1||'where 1=1' when (select * from userhasaction(%CurrentUserID%,'25,28,147'))=1 then sql1||' where b.are_id = ''' || %DataAreaID% || '''' when (select * from userhasaction(%CurrentUserID%,'88,89'))=1 then sql1||' where b.districtid in(' || %DataDistrictID% || ')' when (select * from userhasaction(%CurrentUserID%,72))=1 then sql1||'where a.sho_id in (%_mul_ShopStr%)' else sql1||'where a.sho_id ='''|| %DataShopID%||'''' end bieming from (select ' select b.are_id, c.are_name, b.districtid, d.districtname, a.Sho_ID, a.bra_Id, case when b.createtime >= to_date(to_char(current_date,''YYYY'')) then ''是'' else ''否'' end ISNEWSHOP, a.WhenDate, a.DealCount, a.saleamount, a.salemoney, a.deductmoney from (select Sho_ID, WhenDate, bra_id,(DealCount) DealCount, (saleamount) saleamount, (salemoney) salemoney, (deductmoney) deductmoney from shop_day_bra_sales a where (WhenDate between @startdate@ and @enddate@ or WhenDate between @CompareStartDate@ and @CompareEndDate@ ) ) a inner join shop b on a.sho_id = b.sho_id left join area c on b.are_id = c.are_id left join districtlist d on b.districtid = d.districtid ' sql1 from dummy ) }'where ITEM_ID = '200707';能不能帮看一下
