请问怎么通过是否配置角色来控制 sql查询条件, 请问我的语句该怎么调

-- 有配置角色 看对应团队数据

${if(len(fine_role) == 0,"  

and exists (select 1 

from dw_crm.dws_crm_finereport_role t1 

join (select distinct t.vc_fundcode, t.vc_cust_mngrid, t.vc_objeno,  

t.vc_effectivedate as vc_bgndate, t.vc_enddate, 

t1.vc_ori_dept_crm as c_nodecode

from dw.dw_empl_cust_brok_rela t 

    join dw.dw_empl_main_dept_crm t1

on (t.vc_cust_mngrid = t1.vc_emplno_crm and t.vc_effectivedate <= t1.vc_enddate and t.vc_enddate >= t1.vc_bgndate)

where t.vc_audit_status = '0' -- 审核通过

and t.vc_obje_type = '1' -- 客户

-- and t.vc_cust_mngrid = (select distinct vc_emplid_crm from dw.dw_empl_base_info_crm where vc_email = '${p_email}') 

) t2

on (t1.fr_role_name in ('${REPLACE(fine_role,",","','")}')  

and t2.c_nodecode like t1.c_nodevalue||'%'

)

where t2.vc_fundcode = a1.vc_fundcode

and t2.vc_objeno = a1.vc_custno

and a1.vc_cdate >= t2.vc_bgndate

and a1.vc_cdate <= t2.vc_enddate  

)

"," 

-- 无配置角色-看自己的数据 

and exists (

select 1 

from (select distinct t.vc_fundcode, t.vc_cust_mngrid, t.vc_objeno,  

t.vc_effectivedate as vc_bgndate, t.vc_enddate, 

t1.vc_ori_dept_crm as c_nodecode

from dw.dw_empl_cust_brok_rela t 

    join dw.dw_empl_main_dept_crm t1

on (t.vc_cust_mngrid = t1.vc_emplno_crm and t.vc_effectivedate <= t1.vc_enddate and t.vc_enddate >= t1.vc_bgndate)

where t.vc_audit_status = '0' -- 审核通过

and t.vc_obje_type = '1' -- 客户

and t.vc_cust_mngrid = (select distinct vc_emplid_crm from dw.dw_empl_base_info_crm where vc_email = '${p_email}') 

) t2

where t2.vc_fundcode = a1.vc_fundcode

and t2.vc_objeno = a1.vc_custno

and a1.vc_cdate >= t2.vc_bgndate

and a1.vc_cdate <= t2.vc_enddate  

)

" )}