| | |
|---|
| | | import com.baomidou.dynamic.datasource.annotation.DS; |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
|---|
| | | import com.mes.pp.entity.ReportingWork; |
|---|
| | | import com.mes.pp.entity.request.AwaitingRepair; |
|---|
| | | import com.mes.pp.entity.request.Reportingdamage; |
|---|
| | | import com.mes.pp.mapper.ReportingWorkMapper; |
|---|
| | | import com.mes.pp.mapper.request.AwaitingRepairMapper; |
|---|
| | |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * <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.eq("this_process",reportingdamage.getThisProcess()) |
|---|
| | | .eq("device_name",reportingdamage.getDeviceName()) |
|---|
| | | .le("reporting_work_time", LocalDateTime.now()); |
|---|
| | | 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()) |
|---|
| | | .groupBy("this_process"); |
|---|
| | | return reportingDamageMapper.selectList(queryWrapper); |
|---|
| | | // rw.reporting_work_time BETWEEN '2024/05/12'and'2024/06/20' and rw.this_process = '磨边' and rw.device_name = '快速磨' |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<AwaitingRepair> selectAwaitingRepair() { |
|---|
| | | QueryWrapper<AwaitingRepair> queryWrapper = new QueryWrapper<>(); |
|---|
| | | queryWrapper.select("*"); |
|---|
| | | return awaitingRepairMapper.selectList(queryWrapper); |
|---|
| | | } |
|---|
| | | } |
|---|
