blame | 历史 | 补丁 | 提交 | 提交对比 | show whitespace
严智鑫
2024-07-05 c7093edbf1fb3c91107c457ea13935305e1a9458 
 hangzhoumesParent/common/servicebase/src/main/java/com/mes/pp/service/impl/ReportingWorkServiceImpl.java


New file


@@ -0,0 +1,54 @@


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,device_name ")


                .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);


    }


}