| | |
|---|
| | | private ReportingDamageMapper reportingDamageMapper; |
|---|
| | | @Autowired |
|---|
| | | private AwaitingRepairMapper awaitingRepairMapper; |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<Reportingdamage> selectDamage(Reportingdamage reportingdamage) { |
|---|
| | | QueryWrapper<Reportingdamage>queryWrapper=new QueryWrapper<>(); |
|---|
| | | queryWrapper.select("this_process,sum(completed_quantity)as completedQuantity,sum(breakage_quantity)as breakageQuantity,device_name ") |
|---|
| | | .eq("this_process",reportingdamage.getThisProcess()) |
|---|
| | | queryWrapper.select("this_process,sum(completed_quantity) as completedQuantity,sum(breakage_quantity) as breakageQuantity ") |
|---|
| | | //.eq("this_process", reportingdamage.getThisProcess()) |
|---|
| | | //.eq("device_name",reportingdamage.getDeviceName()) |
|---|
| | | .ge("reporting_work_time",reportingdamage.getReportingWorkTime()) |
|---|
| | | .groupBy("this_process"); |
|---|
