6,108
社区成员
发帖
与我相关
我的任务
分享
select zbdw 单位, ajlb 案件类别, ajxz 案件性质, count(*) val
from aj_jbxx a
where ${macro3}
and ${macro4}
and larq is not null and larq <>0 and czbs<3
group by zbdw, ajlb, ajxz
if(tjlb=='4',if(fakssj==null,"(1=1 or null =? or null =?)","fasjxx>=? and fasjxx<=?"),tjlb=='3',"fasjxx<? and (1=1 or null =?)","fasjxx>=? and fasjxx<=?")
if(tjkssj==null,"(1=1 or null =? or null =?)","larq>=? and larq<=?")