| | |
|---|
| | | package com.mes.uppattenusage.service.impl; |
|---|
| | | package com.mes.glassinfo.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.toolkit.JoinWrappers; |
|---|
| | | import com.mes.downstorage.entity.DownStorageCage; |
|---|
| | | import com.mes.downstorage.entity.DownStorageCageDetails; |
|---|
| | | import com.mes.engineering.entity.Engineering; |
|---|
| | | import com.mes.engineering.mapper.EngineeringMapper; |
|---|
| | | import com.mes.glassinfo.entity.GlassInfo; |
|---|
| | | import com.mes.glassinfo.mapper.GlassInfoMapper; |
|---|
| | | import com.mes.glassinfo.service.GlassInfoService; |
|---|
| | |
|---|
| | | @Service |
|---|
| | | public class GlassInfoServiceImpl extends ServiceImpl<GlassInfoMapper, GlassInfo> implements GlassInfoService { |
|---|
| | | |
|---|
| | | private EngineeringMapper engineeringMapper; |
|---|
| | | private GlassInfoMapper glassInfoMapper; |
|---|
| | | |
|---|
| | | @Autowired |
|---|
| | | public GlassInfoServiceImpl(GlassInfoMapper glassInfoMapper) { |
|---|
| | | @Autowired(required=false) |
|---|
| | | public GlassInfoServiceImpl(GlassInfoMapper glassInfoMapper, EngineeringMapper engineeringMapper) { |
|---|
| | | this.glassInfoMapper = glassInfoMapper; |
|---|
| | | this.engineeringMapper = engineeringMapper; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public int getGlassInfoCountByFlowCardId(String flowCardId) { |
|---|
| | | QueryWrapper<GlassInfo> queryWrapper = new QueryWrapper<>(); |
|---|
| | | queryWrapper.eq("flow_card_id", flowCardId); |
|---|
| | | |
|---|
| | | return baseMapper.selectCount(queryWrapper); |
|---|
| | | return baseMapper.selectCount(new QueryWrapper<GlassInfo>().lambda() |
|---|
| | | .eq(GlassInfo::getFlowCardId, flowCardId)); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<Map<String, Object>> getFlowCardId() { |
|---|
| | | return baseMapper.selectMaps(new QueryWrapper<GlassInfo>().select("DISTINCT flow_card_id")); |
|---|
| | | return baseMapper.selectJoinMaps(JoinWrappers.lambda(GlassInfo.class) |
|---|
| | | .select(GlassInfo::getFlowCardId) |
|---|
| | | .leftJoin(Engineering.class, on -> on |
|---|
| | | .eq(Engineering::getEngineerId, GlassInfo::getEngineerId) |
|---|
| | | .eq(Engineering::getState, 0) |
|---|
| | | ) |
|---|
| | | .groupBy(GlassInfo::getFlowCardId) |
|---|
| | | ); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public GlassInfo selectGlassId(String id) { |
|---|
| | | QueryWrapper<GlassInfo> queryWrapper = new QueryWrapper<>(); |
|---|
| | | queryWrapper.eq("glass_id", id); |
|---|
| | | |
|---|
| | | return baseMapper.selectOne(queryWrapper); |
|---|
| | | return baseMapper.selectOne(new QueryWrapper<GlassInfo>().lambda() |
|---|
| | | .eq(GlassInfo::getGlassId, id)); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | // public void updateFlowCardIdAndCount(String flowCardId, int glassInfoCount, int workstationId) { |
|---|
| | | // int rowsAffected = glassInfoMapper.updateFlowCardIdAndCount(flowCardId, glassInfoCount, workstationId); |
|---|
| | | // if (rowsAffected > 0) { |
|---|
| | | // System.out.println("更新架子上流程卡 ID 和数量成功"); |
|---|
| | | // } else { |
|---|
| | | // System.out.println("更新架子上流程卡 ID 和数量失败"); |
|---|
| | | // } |
|---|
| | | // } |
|---|
| | | |
|---|
| | | |
|---|
| | | } |
|---|
