| | |
| | | |
| | | /** |
| | | * <p> |
| | | * 服务实现类 |
| | | * 服务实现类 |
| | | * </p> |
| | | * |
| | | * @author wu |
| | |
| | | @DS("pp") |
| | | @Slf4j |
| | | public class ReportingWorkServiceImpl extends ServiceImpl<ReportingWorkMapper, ReportingWork> implements ReportingWorkService { |
| | | @Autowired |
| | | private ReportingDamageMapper reportingDamageMapper; |
| | | @Autowired |
| | | private AwaitingRepairMapper awaitingRepairMapper; |
| | | @Autowired |
| | | 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<Reportingdamage> queryWrapper = new QueryWrapper<>(); |
| | | 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()) |
| | | .ge("reporting_work_time", reportingdamage.getReportingWorkTime()) |
| | | .groupBy("this_process"); |
| | | return reportingDamageMapper.selectList(queryWrapper); |
| | | } |
| | | |
| | | @Override |
| | | public List<AwaitingRepair> selectAwaitingRepair() { |
| | | QueryWrapper<AwaitingRepair>queryWrapper=new QueryWrapper<>(); |
| | | QueryWrapper<AwaitingRepair> queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.select("*"); |
| | | return awaitingRepairMapper.selectList(queryWrapper); |
| | | } |