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.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) { QueryWrapperqueryWrapper=new QueryWrapper<>(); queryWrapper.eq("this_process",reportingdamage.getThisProcess()) .eq("device_name",reportingdamage.getDeviceName()) .le("reporting_work_time", LocalDateTime.now()); return reportingDamageMapper.selectList(queryWrapper); // rw.reporting_work_time BETWEEN '2024/05/12'and'2024/06/20' and rw.this_process = '磨边' and rw.device_name = '快速磨' } }