package com.mes.damage.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.github.yulichang.base.MPJBaseServiceImpl;
|
import com.github.yulichang.query.MPJQueryWrapper;
|
import com.mes.damage.entity.Damage;
|
import com.mes.damage.entity.DamagePrint;
|
import com.mes.damage.mapper.DamageMapper;
|
import com.mes.damage.service.DamageService;
|
import com.mes.glassinfo.entity.GlassInfo;
|
import com.mes.glassinfo.mapper.GlassInfoMapper;
|
import com.mes.work_assignment.entity.WorkAssignment;
|
import com.mes.work_assignment.mapper.WorkAssignmentMapper;
|
import org.springframework.beans.BeanUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import javax.annotation.Resource;
|
import java.sql.Timestamp;
|
import java.time.LocalDateTime;
|
import java.util.Collections;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
import java.util.stream.Collectors;
|
|
/**
|
* <p>
|
* 服务实现类
|
* </p>
|
*
|
* @author wu
|
* @since 2024-06-13
|
*/
|
@Service
|
public class DamageServiceImpl extends MPJBaseServiceImpl<DamageMapper, Damage> implements DamageService {
|
|
@Resource
|
GlassInfoMapper glassInfoMapper;
|
@Resource
|
WorkAssignmentMapper workAssignmentMapper;
|
@Autowired
|
private DamageMapper damageMapper;
|
|
/**
|
* 查询报工信息
|
*/
|
@Override
|
public List<Damage> selectDamage(String startTime, String endTime, int type, int status, String workingProcedure) {
|
LambdaQueryWrapper<Damage> damageSelectWrapper = new LambdaQueryWrapper<>();
|
damageSelectWrapper.between(Damage::getDamageTime, startTime, endTime);
|
if (type != 0) {
|
damageSelectWrapper.eq(Damage::getType, type);
|
}
|
if (status != 0) {
|
damageSelectWrapper.eq(Damage::getStatus, status);
|
}
|
if (!"0".equals(workingProcedure)) {
|
damageSelectWrapper.eq(Damage::getWorkingProcedure, workingProcedure);
|
}
|
List<Damage> damageList = baseMapper.selectList(damageSelectWrapper);
|
|
for (Damage damage : damageList) {
|
damage.setStatus(2);
|
}
|
return baseMapper.selectList(damageSelectWrapper);
|
}
|
|
/**
|
* 提交报工
|
*/
|
@Override
|
public void submitDamage(List<Damage> damageList) {
|
Map<String, List<Damage>> firstMap = damageList.stream().collect(Collectors.groupingBy(e -> e.getProcessId() + ":"
|
+ e.getWorkingProcedure() + ":" + e.getDeviceName() + ":" + e.getTeamsGroupsName()));
|
|
for (Map.Entry<String, List<Damage>> entry : firstMap.entrySet()) {
|
String key = entry.getKey();
|
List<Damage> damages = entry.getValue();
|
|
System.out.println("Key: " + key);
|
|
Map<String, List<Damage>> secondMap = damageList.stream().collect(Collectors.groupingBy(e -> e.getProcessId() + ":"
|
+ e.getWorkingProcedure() + ":" + e.getDeviceName() + ":" + e.getTeamsGroupsName()));
|
|
for (Map.Entry<String, List<Damage>> entrys : secondMap.entrySet()) {
|
|
}
|
}
|
|
|
}
|
|
/**
|
* 添加报工信息
|
*/
|
@Override
|
public void insertDamage(Damage damage) {
|
LambdaQueryWrapper<GlassInfo> glassInfoSelectWrapper = new LambdaQueryWrapper<>();
|
glassInfoSelectWrapper.eq(GlassInfo::getGlassId, damage.getGlassId());
|
GlassInfo glassInfo = glassInfoMapper.selectOne(glassInfoSelectWrapper);
|
BeanUtils.copyProperties(glassInfo, damage);
|
|
LambdaQueryWrapper<WorkAssignment> workAssignmentSelectWrapper = new LambdaQueryWrapper<>();
|
workAssignmentSelectWrapper
|
.eq(WorkAssignment::getLine, damage.getLine())
|
.eq(WorkAssignment::getWorkProcesses, damage.getWorkingProcedure());
|
WorkAssignment workAssignment = workAssignmentMapper.selectOne(workAssignmentSelectWrapper);
|
if (workAssignment != null) {
|
damage.setTeamsGroupsName(workAssignment.getTeamsGroupsName());
|
damage.setDeviceName(workAssignment.getDeviceName());
|
}
|
damage.setProcessId(glassInfo.getFlowCardId());
|
damage.setOrderNumber(glassInfo.getGlassType());
|
damage.setTechnologyNumber(glassInfo.getLayer());
|
damage.setDamageTime(Timestamp.valueOf(LocalDateTime.now()));
|
baseMapper.insert(damage);
|
}
|
|
/**
|
* 添加报工信息
|
*/
|
@Override
|
public void batchInsertDamage(List<Damage> damageList) {
|
WorkAssignment workAssignment = workAssignmentMapper.selectOne(new LambdaQueryWrapper<WorkAssignment>()
|
.eq(WorkAssignment::getLine, damageList.get(0).getLine())
|
.eq(WorkAssignment::getWorkProcesses, damageList.get(0).getWorkingProcedure()));
|
|
List<String> glassList = damageList.stream().map(Damage::getGlassId).collect(Collectors.toList());
|
List<GlassInfo> glassInfoList = glassInfoMapper.selectList(new LambdaQueryWrapper<GlassInfo>().in(GlassInfo::getGlassId, glassList));
|
Map<String, List<GlassInfo>> listMap = glassInfoList.stream().collect(Collectors.groupingBy(GlassInfo::getGlassId));
|
for (Damage damage : damageList) {
|
GlassInfo glassInfo = listMap.get(damage.getGlassId()).get(0);
|
BeanUtils.copyProperties(glassInfo, damage);
|
if (workAssignment != null) {
|
damage.setTeamsGroupsName(workAssignment.getTeamsGroupsName());
|
damage.setDeviceName(workAssignment.getDeviceName());
|
}
|
damage.setProcessId(glassInfo.getFlowCardId());
|
damage.setOrderNumber(glassInfo.getGlassType());
|
damage.setTechnologyNumber(glassInfo.getLayer());
|
damage.setDamageTime(Timestamp.valueOf(LocalDateTime.now()));
|
}
|
this.saveBatch(damageList);
|
}
|
|
@Override
|
public List<Damage> selectDamagePrint(Damage damage) {
|
QueryWrapper<Damage> wrapper = new QueryWrapper<>();
|
wrapper.select("working_procedure,engineer_id,teams_groups_name,device_name,count(glass_id)as glass_id")
|
.eq("type",damage.getType())
|
.eq("working_procedure",damage.getWorkingProcedure())
|
.groupBy("working_procedure,engineer_id,teams_groups_name,device_name");
|
if (damage.getEngineerId() != null) {
|
wrapper.eq("engineer_id", damage.getEngineerId());
|
}
|
return this.list(wrapper);
|
}
|
|
@Override
|
public List<DamagePrint> selectDamagePrintDetails(Damage damage) {
|
List<DamagePrint> listDamage=damageMapper.selectJoinList(DamagePrint.class,new MPJQueryWrapper<Damage>()
|
.select("b.flow_card_id,b.layer,t.engineer_id,b.tempering_layout_id,b.tempering_feed_sequence,t.glass_id,b.width,b.height,b.thickness")
|
.leftJoin("glass_info as b on t.glass_id=b.glass_id")
|
.eq("t.working_procedure",damage.getWorkingProcedure())
|
.eq("t.type",damage.getType())
|
.eq("t.engineer_id",damage.getEngineerId())
|
);
|
return listDamage;
|
}
|
}
|
