select
f_id,
f_user_id,
f_username,
f_comit_time,
f_suggestions,
f_answer,
f_type,
f_admin_user_id,
f_adminname,
f_answer_time
from
(select
f_id,
f_user_id,
(select
z_perna
from
t_person
where
z_perno = f_user_id) as f_username,
f_comit_time,
f_suggestions,
ifnull(f_answer,
''
) as f_answer,
ifnull(f_type,
''
) as f_type,
ifnull(f_admin_user_id,
''
) as f_admin_user_id,
ifnull((select
z_perna
from
t_person
where
z_perno = f_admin_user_id),
''
) as f_adminname,
ifnull(f_answer_time,
''
) as f_answer_time
from
t_suggestions) aa
where
1
=
1
<
if
test=
"radiovalue == 1"
>
and f_admin_user_id =
''
</
if
>
<
if
test=
"radiovalue == 2"
>
and f_admin_user_id !=
''
</
if
>
<
if
test=
"subpeo != null and subpeo !=''"
>
and f_username like CONCAT(
'%'
,#{subpeo,jdbcType=VARCHAR},
'%'
)
</
if
>
<
if
test=
"anspeo != null and anspeo !=''"
>
and f_adminname like CONCAT(
'%'
,#{anspeo,jdbcType=VARCHAR},
'%'
)
</
if
>
<
if
test=
"checkvalue != null and checkvalue !=''"
>
and INSTR(#{checkvalue}, f_type)!=
'0'
and f_type!=
''
</
if
>
<
if
test=
"starttime != null and starttime !='' and endtime != null and endtime !=''"
>
and f_comit_time between #{starttime,jdbcType=VARCHAR} and DATE_ADD(#{endtime,jdbcType=VARCHAR},INTERVAL
1
DAY)
</
if
>
<
if
test=
"starttime != null and starttime !='' and endtime == null"
>
and f_comit_time >= #{starttime,jdbcType=VARCHAR}
</
if
>
<
if
test=
"starttime == null and endtime != null"
>
<![CDATA[
and f_comit_time <
DATE_ADD(#{endtime,jdbcType=VARCHAR},INTERVAL
1
DAY)
]]>
</
if
>