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;
|
|
/**
|
* <p>
|
* 服务实现类
|
* </p>
|
*
|
* @author wu
|
* @since 2024-06-26
|
*/
|
@Service
|
@DS("pp")
|
@Slf4j
|
public class ReportingWorkServiceImpl extends ServiceImpl<ReportingWorkMapper, ReportingWork> implements ReportingWorkService {
|
@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 ")
|
//.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<AwaitingRepair> selectAwaitingRepair() {
|
QueryWrapper<AwaitingRepair> queryWrapper = new QueryWrapper<>();
|
queryWrapper.select("*");
|
return awaitingRepairMapper.selectList(queryWrapper);
|
}
|
}
|
