| | |
|---|
| | | |
|---|
| | | import com.baomidou.dynamic.datasource.annotation.DS; |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; |
|---|
| | | import com.mes.temperingglass.entity.TemperingGlassInfo; |
|---|
| | | import com.mes.temperingglass.mapper.TemperingGlassInfoMapper; |
|---|
| | | import com.mes.temperingglass.service.TemperingGlassInfoService; |
|---|
| | |
|---|
| | | public List<TemperingGlassInfo> selectWaitingGlass() { |
|---|
| | | //获取等待进炉中的玻璃信息 |
|---|
| | | QueryWrapper<TemperingGlassInfo> wrapper = new QueryWrapper<>(); |
|---|
| | | wrapper.select("Top 1 *").in("state",1,0); |
|---|
| | | wrapper.select("Top 1 *").in("state",1,0,-1); |
|---|
| | | TemperingGlassInfo glass=temperingMapper.selectOne(wrapper); |
|---|
| | | if(glass!=null) { |
|---|
| | | QueryWrapper<TemperingGlassInfo> glassinfo = new QueryWrapper<>(); |
|---|
| | |
|---|
| | | @Override |
|---|
| | | public List<TemperingGlassInfo> selectLayoutId() { |
|---|
| | | QueryWrapper<TemperingGlassInfo> wrapper = new QueryWrapper<>(); |
|---|
| | | wrapper.select("distinct tempering_layout_id,engineer_id") |
|---|
| | | wrapper.select("tempering_layout_id,engineer_id,max(id) as id") |
|---|
| | | .eq("state",2) |
|---|
| | | .orderByAsc("tempering_layout_id"); |
|---|
| | | .groupBy("tempering_layout_id,engineer_id") |
|---|
| | | .orderByAsc("id"); |
|---|
| | | return temperingMapper.selectList(wrapper); |
|---|
| | | } |
|---|
| | | |
|---|
