${if(len(saler)==0,"","AND Ta.username in ('"+ treelayer(saler, true, "\',\'") +"')")}


${IF(FIND("总监",GETUSERJOBTITLES())!=0,IF(FIND("北办",GETUSERDEPARTMENTS())!=0 || FIND("北京",GETUSERDEPARTMENTS())!=0,"AND (Ta.GROUP_NAME LIKE '%北办%' OR Ta.GROUP_NAME LIKE '%北京%')",""),"")}

${IF(FIND("总监",GETUSERJOBTITLES())!=0,IF(FIND("B端营销",GETUSERDEPARTMENTS())!=0,"AND Ta.GROUP_NAME LIKE '%B端营销%'",""),"")}

${IF(FIND("总监",GETUSERJOBTITLES())!=0,IF(FIND("武办",GETUSERDEPARTMENTS())!=0 || FIND("武汉",GETUSERDEPARTMENTS())!=0,"AND (Ta.GROUP_NAME LIKE '%武办%' OR Ta.GROUP_NAME LIKE '%武汉%')",""),"")}

${IF(FIND("总监",GETUSERJOBTITLES())!=0,IF(FIND("银行创新",GETUSERDEPARTMENTS())!=0,"AND Ta.GROUP_NAME LIKE '%银行创新%'",""),"")}

${IF(FIND("总监",GETUSERJOBTITLES())!=0,IF(FIND("A",GETUSERDEPARTMENTS())!=0,"AND Ta.GROUP_NAME LIKE '%A%'",""),"")}

${IF(FIND("总监",GETUSERJOBTITLES())!=0,IF(FIND("B",GETUSERDEPARTMENTS())!=0 && FIND("B端营销管理",GETUSERDEPARTMENTS())=0,"AND Ta.GROUP_NAME LIKE '%B%' AND Ta.GROUP_NAME NOT LIKE '%B端营销管理%'",""),"")}

${IF(FIND("总监",GETUSERJOBTITLES())!=0,IF(FIND("营销服务顾问",GETUSERDEPARTMENTS())!=0,"AND 1=1",""),"")}

${IF(FIND("总监",GETUSERJOBTITLES())!=0,IF(FIND("市场规划",GETUSERDEPARTMENTS())!=0,"AND Ta.GROUP_NAME LIKE '%市场规划%'",""),"")}

${IF(FIND("总监",GETUSERJOBTITLES())!=0,IF(FIND("深办",GETUSERDEPARTMENTS())!=0 || FIND("深圳",GETUSERDEPARTMENTS())!=0,"AND (Ta.GROUP_NAME LIKE '%深办%' OR Ta.GROUP_NAME LIKE '%深圳%')",""),"")}

${IF(FIND("区域经理",GETUSERJOBTITLES())!=0,"AND Ta.GROUP_NAME='"+position+"'","")}

${IF(FIND("销售员",GETUSERJOBTITLES())!=0,"AND Ta.username='"+fine_username+"'","")}

选择单个值报错，多选正常