| | |
|---|
| | | 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; |
|---|
| | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<Map<String, Object>> getFlowCardId() { |
|---|
| | | |
|---|
| | | return glassInfoMapper.selectJoinMaps(JoinWrappers.lambda(GlassInfo.class) |
|---|
| | | .select(GlassInfo::getFlowCardId) // 选择需要查询的字段 |
|---|
| | | .eq(GlassInfo::getEngineerId, Engineering::getEngineerId) // 设置关联条件 |
|---|
| | | return baseMapper.selectJoinMaps(JoinWrappers.lambda(GlassInfo.class) |
|---|
| | | .select(GlassInfo::getFlowCardId) |
|---|
| | | .leftJoin(Engineering.class, on -> on |
|---|
| | | .eq(Engineering::getEngineerId, GlassInfo::getEngineerId) |
|---|
| | | .eq(Engineering::getState, 0) |
|---|
| | | .distinct() |
|---|
| | | |
|---|
| | | ) |
|---|
| | | .groupBy(GlassInfo::getFlowCardId) |
|---|
| | | ); |
|---|
| | | } |
|---|
| | | |
|---|
| | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public GlassInfo selectGlassId(String id) { |
|---|
| | | return baseMapper.selectOne(new QueryWrapper<GlassInfo>().lambda() |
|---|
