| | |
|---|
| | | return baseMapper.selectOne(new MPJLambdaWrapper<TaskCache>().selectAll(TaskCache.class).eq(TaskCache::getEndCell, line).eq(TaskCache::getTaskStatus, 1).orderByDesc(TaskCache::getCreateTime)); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 查询判断磨边线是否有玻璃运行 |
|---|
| | | * |
|---|
| | | * @param |
|---|
| | | * @return |
|---|
| | | */ |
|---|
| | | @Override |
|---|
| | | public List<TaskCache> selectTaskCacheIsRun() { |
|---|
| | | List<TaskCache> taskCaches = null; |
|---|
| | | taskCaches = taskCacheMapper.selectJoinList(TaskCache.class, new MPJLambdaWrapper<TaskCache>() |
|---|
| | | .select("top 4 t.end_cell,ISNULL(b.glass_id, 0)as glass_id") |
|---|
| | | .leftJoin("big_storage_cage_feed_task as b on t.glass_id=b.glass_id ") |
|---|
| | | .groupBy("t.end_cell,b.glass_id,t.create_time") |
|---|
| | | .orderByDesc("t.create_time") |
|---|
| | | ); |
|---|
| | | return taskCaches; |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | } |
|---|
