SELECT

d.LOTID 批次编码,

sum(d.FORMERQTY) 批次原数量,

sum(d.LASTQTY) 批次现数量,

d.ISRECIPE 型号编码,

d.FGCODE 型号规格,

d.FGKIND 材质,

d.FGCODEVERSION 成品型号,

d.EVENTUSER 操作人,

d.WORKORDER 生产订单,

d.WORKSHOPNAME 车间名称,

d.LINE 产线编号,

d.LINENAME 产线名称,

d.MACHINECODE 设备编号,

d.MACHINENAME 设备名称,

d.FIXCODE 治具编号,

d.FIXNAME 治具名称,

d.BACKUP1 模号,

u.USERNAME 操作人名字,

d.EVENTTIME 操作时间

FROM DGB_PLOT d

JOIN USERINFO u on d.EVENTUSER=u.USERID

where 1=1

${IF(LEN(开始时间) = 0,"","AND TO_CHAR(d.EVENTTIME,'YYYY-MM-DD hh24')>= ('" + 开始时间 + "')")}

${IF(LEN(结束时间) = 0,"","AND TO_CHAR(d.EVENTTIME,'YYYY-MM-DD hh24')<= ('" + 结束时间 + "')")}

group by

d.LOTID,d.FORMERQTY,d.LASTQTY,d.ISRECIPE,d.FGCODE,d.FGKIND,d.FGCODEVERSION,d.EVENTUSER,d.WORKORDER,d.WORKSHOPNAME,d.LINE,d.LINENAME,d.MACHINECODE,d.MACHINENAME,d.FIXCODE,d.FIXNAME,d.BACKUP1,u.USERNAME,d.EVENTTIME

order by d.MACHINECODE ASC

这是现在的sql

数据如图