一疮茄。
select * from fenxiao_jiekou_baiping_daioyong_statis a
where 1=1
${IF(len(data_source) == 0," "," and case when a.p_reptortype = 'OPEN_ROUD_API' then 'OPEN_ROUD_API'
when a.p_reptortype = 'OPEN_TRAVEL_API' then 'OPEN_TRAVEL_API'
else 'WHITE_SCREEN' end in ('" + data_source + "')")}
data_source對應為添加的下拉框控件名歉嗓，數(shù)據(jù)字典選中對應的數(shù)據(jù)列
二赫段。
from fenxiao_jiekou_baiping_daioyong_by_day_statis a
where 1=1
${if(len(Start)=0,""," and day>='"+start+"'")}
${if(len(End)=0,""," and day<='"+end+"'")}
${IF(len(data_source) == 0," "," and case when a.p_reptortype = 'OPEN_ROUD_API' then 'OPEN_ROUD_API'
when a.p_reptortype = 'OPEN_TRAVEL_API' then 'OPEN_TRAVEL_API'
else 'WHITE_SCREEN' end in ('" + data_source + "')")}
