${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+"'","")}选择单个值报错,多选正常