cicikoko(提问者) 回复 free_zzselect case when a.duty_owner is null then u.name end,a.* from (select t.*,decode(shift_name,\'D\',\'白班\',\'N\',\'夜班\',\'其他\') shift_look from dwd_fr_mes_onduty t
where 1=1
--如果 shop2的字符串长度=0 为真就返回空，false就将控件参数传给字段shop
${IF(LEN(shop2) == 0,\"\",\"AND T.shop in (\'\" + shop2 + \"\')\") }
${IF(LEN(owner2) == 0,\"\",\"AND T.duty_owner in (\'\" + owner2 + \"\')\") }
${IF(LEN(type2) == 0,\"\",\"AND T.issue_type in (\'\" + type2 + \"\')\") }
${IF(LEN(status2) == 0,\"\",\"AND T.issue_status in (\'\" + status2 + \"\')\") }
${IF(LEN(des2) == 0,\"\",\" and T.issue_des like \'%\"+des2+\"%\'\") }
order by date_timekey desc,shift_name desc,id desc)a,
(select * from (
select \'4\' as acount,\'李\' as name from dual
union all
select \'PD005583\' as acount,\'唐小平\' as name from dual
union all
select \'P2\' as acount,\'高\' as name from dual
union all
select \'P\' as acount,\'杨\' as name from dual
union all
select \'1\' as acount,\'张\' as name from dual
union all
select \'PD\' as acount,\'赵\' as name from dual)x
where x.account=\'${fine_username}\')u
1min目标场景问卷
立即参与
