and dept_info in (

SELECT distinct  SUBSTRING(dpt_name,2)as dpt_name  

FROM dw.tbl_dw_dingtalk_user2

WHERE  dpt_id in (select dpt_id FROM dw.tbl_dw_dingtalk_user2 where 1=1

${if(fine_username)='101700075',"","and dpt_id in (select dpt_id FROM dw.tbl_dw_dingtalk_user2 where user_id = '${fine_username}')

or parent_dpt_id in (select dpt_id FROM dw.tbl_dw_dingtalk_user2 where user_jobnum = '${fine_username}')"}