还需要一个时间控件 和车货总重 textEditor0_c 名字为select bb.ENFORCEUNIT,count(bb.pid) as num ,sum(bb.totalWeightGoods) as totalWeightGoods ,sum(bb.aftertotalMass) as aftertotalMassfrom bwsn_basicinfo bbleft join s_project sp on bb.pid =sp.idleft join s_unit su on bb.enforceUnitId =su.idwhere (sp.status !='撤销' or sp.status is null) and caseType='联合治超' and su.CATALOGROUTE like '%${pid}%'GROUP BY bb.enforceUnitId,bb.ENFORCEUNIT HAVING sum(bb.totalWeightGoods)>="${textEditor0_c}"