| | |
|---|
| | | |
|---|
| | | 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; |
|---|
| | |
|---|
| | | @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") |
|---|
| | | .orderByDesc("id"); |
|---|
| | | return temperingMapper.selectList(wrapper); |
|---|
| | | } |
|---|
| | | |
|---|
