| | |
| | | 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; |
| | | import com.mes.uppattenusage.entity.UpPattenUsage; |
| | | import com.mes.uppattenusage.mapper.UpPattenUsageMapper; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | |
| | | @Service |
| | | public class GlassInfoServiceImpl extends ServiceImpl<GlassInfoMapper, GlassInfo> implements GlassInfoService { |
| | | |
| | | private EngineeringMapper engineeringMapper; |
| | | private UpPattenUsageMapper upPattenUsageMapper; |
| | | private GlassInfoMapper glassInfoMapper; |
| | | |
| | | @Autowired(required=false) |
| | | public GlassInfoServiceImpl(GlassInfoMapper glassInfoMapper, EngineeringMapper engineeringMapper) { |
| | | public GlassInfoServiceImpl(GlassInfoMapper glassInfoMapper, UpPattenUsageMapper upPattenUsageMapper) { |
| | | this.glassInfoMapper = glassInfoMapper; |
| | | this.engineeringMapper = engineeringMapper; |
| | | this.upPattenUsageMapper = upPattenUsageMapper; |
| | | } |
| | | |
| | | @Override |
| | |
| | | public List<Map<String, Object>> getFlowCardId() { |
| | | return baseMapper.selectJoinMaps(JoinWrappers.lambda(GlassInfo.class) |
| | | .select(GlassInfo::getFlowCardId) |
| | | .leftJoin(Engineering.class, on -> on |
| | | .eq(Engineering::getEngineerId, GlassInfo::getEngineerId) |
| | | .eq(Engineering::getState, 0) |
| | | .leftJoin(UpPattenUsage.class, on -> on |
| | | .eq(UpPattenUsage::getEngineeringId, GlassInfo::getEngineerId) |
| | | .ne(UpPattenUsage::getState, 300) |
| | | ) |
| | | .groupBy(GlassInfo::getFlowCardId) |
| | | ); |