${if(len(fnumber_b)=0,"","and fnumber_b_name in ('"+fnumber_b+"')")}${if(len(fenlei_num)=0,"","and fenlei_num = '"+fenlei_num+"'")}${if(len(lotatt05)=0,"","and IFNULL(factory_name,0) in ('"+lotatt05+"')")} ${if(len(category_decimal)=0,"","and category_decimal in ('"+category_decimal+"')")} ${if(len(channel_name)=0,"","and channel_name in ('"+channel_name+"')")}${if(len(province)=0,"","and province in ('"+province+"')")}${if(len(category_name)=0,"","and category_name in ('"+category_name+"')")} ${if(len(product_type_name)=0,"","and product_type_name in ('"+product_type_name+"')")} ${if(fine_username="admin" || fine_role="超级管理员" || find("EAS权限组",fine_role)>0 ||len(fine_username)=0,"","and EXISTS(SELECTqq.sales_managerFROM(SELECT sales_manager FROM daily_salesperson_relationship_maintenance2 WHERE grade in('第四级')AND leader_superior NOT IN(SELECT leader_superior FROM daily_salesperson_relationship_maintenance2 WHERE grade in('第一级'))AND (sales_superior ='"+fine_username+"' OR leader_superior ='"+fine_username+"')UNION ALLSELECT sales_manager FROM daily_salesperson_relationship_maintenance2 WHERE grade in('第三级') AND leader_superior NOT IN(SELECT leader_superior FROM daily_salesperson_relationship_maintenance2 WHERE grade in('第一级'))AND (sales_superior ='"+fine_username+"' OR leader_superior ='"+fine_username+"')UNION ALLSELECT sales_manager FROM daily_salesperson_relationship_maintenance2 WHERE grade in('第二级') AND sales_superior ='"+fine_username+"'UNION ALLSELECT sales_manager FROM daily_salesperson_relationship_maintenance2 WHERE grade in('第四级')AND leader_superior NOT IN(SELECT leader_superior FROM daily_salesperson_relationship_maintenance2 WHERE grade in('第一级'))AND leader_name in(SELECT sales_manager FROM daily_salesperson_relationship_maintenance2 WHERE leader_superior='"+fine_username+"')UNION ALLSELECT sales_manager FROM daily_salesperson_relationship_maintenance2 WHERE channel_name in(SELECT channel_name FROM daily_salesperson_relationship_maintenance2 WHERE grade in('第一级')AND leader_superior='"+fine_username+"'))qqWHEREqq.sales_manager = a.user_name)" )}