(SELECT

customer_name,

sum(fbaseqty_a) as fbaseqty_a,

sum(famountlocal)/10000 as famountlocal

FROM easdb.ads_saleorder_saleissue_fenlei_wms_newrule a

WHERE

 fbizdate_a>='${start}'

AND fbizdate_a<='${END}'

and fbaseunit ='吨'

and cfcounttype not in(3,4)

AND fbasestatus_i in(4)

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

)" )}

GROUP BY customer_name

ORDER BY sum(fbaseqty_a) desc

LIMIT ${aa}

)