mybatis-sql-union all

<select id="selectAllReportByPage" resultMap="BaseResultMap">

<if test="params.type != null and params.type!='' and params.type==1 ">

select id,name,1 as idx,

CONCAT(LEFT(id_no,3), '****' ,RIGHT(id_no,4)) as id_no,

grant_detail as grant_detail,'授信报告' as type,CONCAT('1_',id) as typeId from granting_result

</if>

<if test="params.type != null and params.type!='' and params.type==2 ">

select id,name,2 as idx,

CONCAT(LEFT(id_no,3), '****' ,RIGHT(id_no,4)) as id_no,

lending_detail as grant_detail,'桔子分期贷款' as type,CONCAT('2_',id) as typeId from juzi_lending_info

</if>

<if test="params.type != null and params.type!='' and params.type==3 ">

select id,name,3 as idx,

CONCAT(LEFT(id_no,3), '****' ,RIGHT(id_no,4)) as id_no,

lending_detail as grant_detail,'贷款申请' as type,CONCAT('3_',id) as typeId from lending_info

</if>

<if test="params.type != null and params.type!='' and params.type==4 ">

select ra.id,rl.name,4 as idx,

CONCAT(LEFT(rl.card_no,3), '****' ,RIGHT(rl.card_no,4)) as id_no,

ra.anti_detail as grant_detail,'反欺诈流水' as type,CONCAT('4_',ra.id) as typeId

from rcs_anti_seri ra left JOIN rcs_loan_seri rl on ra.reqt_id=rl.seri_no</if>

<if test="params.type != null and params.type!='' and params.type==5 ">

select rg.id,rl.name,5 as idx,

CONCAT(LEFT(rl.card_no,3), '****' ,RIGHT(rl.card_no,4)) as id_no,

rg.crdt_rule_detl as grant_detail,'授信流水' as type,CONCAT('5_',rg.id) as typeId

from rcs_grant_seri rg left JOIN rcs_loan_seri rl on rg.reqt_id=rl.seri_no</if>

<if test="params.type == null or params.type == ''">

select id,name,1 as idx,

CONCAT(LEFT(id_no,3), '****' ,RIGHT(id_no,4)) as id_no,

grant_detail as grant_detail,'授信报告' as type,CONCAT('1_',id) as typeId from granting_result

union ALL

select id,name,2 as idx,

CONCAT(LEFT(id_no,3), '****' ,RIGHT(id_no,4)) as id_no,

lending_detail as grant_detail,'桔子分期贷款' as type,CONCAT('2_',id) as typeId from juzi_lending_info

union ALL

select id,name,3 as idx,

CONCAT(LEFT(id_no,3), '****' ,RIGHT(id_no,4)) as id_no,

lending_detail as grant_detail,'贷款申请' as type,CONCAT('3_',id) as typeId from lending_info

union ALL

select ra.id,rl.name,4 as idx,

CONCAT(LEFT(rl.card_no,3), '****' ,RIGHT(rl.card_no,4)) as id_no,

ra.anti_detail as grant_detail,'反欺诈流水' as type,CONCAT('4_',ra.id) as typeId

from rcs_anti_seri ra left JOIN rcs_loan_seri rl on ra.reqt_id=rl.seri_no

union ALL

select rg.id,rl.name,5 as idx,

CONCAT(LEFT(rl.card_no,3), '****' ,RIGHT(rl.card_no,4)) as id_no,

rg.crdt_rule_detl as grant_detail,'授信流水' as type,CONCAT('5_',rg.id) as typeId

from rcs_grant_seri rg left JOIN rcs_loan_seri rl on rg.reqt_id=rl.seri_no

</if>

ORDER BY idx,id desc

limit #{currentIndex},#{pageSize}

</select>