${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(

SELECT

qq.sales_manager

FROM(

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 ALL

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 ALL

SELECT

 sales_manager

 FROM daily_salesperson_relationship_maintenance2

 WHERE

  grade in('第二级') 

AND sales_superior ='"+fine_username+"'

UNION ALL

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 leader_name in(SELECT sales_manager FROM daily_salesperson_relationship_maintenance2 WHERE leader_superior='"+fine_username+"')

UNION ALL

SELECT

 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+"')

)qq

WHERE

qq.sales_manager = a.user_name

)" )}