package com.mes.pp.service.impl; 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; import com.mes.pp.mapper.request.ReportingDamageMapper; import com.mes.pp.service.ReportingWorkService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.time.LocalDateTime; import java.util.Collections; import java.util.List; /** *

* 服务实现类 *

* * @author wu * @since 2024-06-26 */ @Service @DS("pp") @Slf4j public class ReportingWorkServiceImpl extends ServiceImpl implements ReportingWorkService { @Autowired private ReportingDamageMapper reportingDamageMapper; @Autowired private AwaitingRepairMapper awaitingRepairMapper; @Override public List selectDamage(Reportingdamage reportingdamage) { QueryWrapper 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); } @Override public List selectAwaitingRepair() { QueryWrapper queryWrapper = new QueryWrapper<>(); queryWrapper.select("*"); return awaitingRepairMapper.selectList(queryWrapper); } }