(SELECTcustomer_name,sum(fbaseqty_a) as fbaseqty_a,sum(famountlocal)/10000 as famountlocalFROM easdb.ads_saleorder_saleissue_fenlei_wms_newrule aWHERE 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(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)" )} GROUP BY customer_nameORDER BY sum(fbaseqty_a) descLIMIT ${aa})
