| | |
| | | import com.mes.bigstoragetask.entity.BigStorageCageFeedTask; |
| | | import com.mes.bigstoragetask.mapper.BigStorageCageFeedTaskMapper; |
| | | import com.mes.bigstoragetask.service.BigStorageCageFeedTaskService; |
| | | import com.mes.utils.Result; |
| | | import org.springframework.beans.factory.annotation.Value; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | |
| | | public List<Integer> querySitToUpGlass() { |
| | | return baseMapper.querySitToUpGlass(); |
| | | } |
| | | |
| | | @Override |
| | | public List<BigStorageCageFeedTask> selectBigStorageCageFeedTask(BigStorageCageFeedTask bigStorageCageFeedTask, String startTime, String endTime) { |
| | | if (endTime != null && !endTime.isEmpty()) { |
| | | endTime = endTime + " 23:59:59"; |
| | | } |
| | | LambdaQueryWrapper<BigStorageCageFeedTask> wrapper = new LambdaQueryWrapper<>(); |
| | | if (bigStorageCageFeedTask.getTargetSlot() != null) { |
| | | wrapper.eq(BigStorageCageFeedTask::getTargetSlot, bigStorageCageFeedTask.getTargetSlot()); |
| | | } |
| | | if (bigStorageCageFeedTask.getWidth() != null) { |
| | | wrapper.eq(BigStorageCageFeedTask::getWidth, bigStorageCageFeedTask.getWidth()); |
| | | } |
| | | if (bigStorageCageFeedTask.getHeight() != null) { |
| | | wrapper.eq(BigStorageCageFeedTask::getHeight, bigStorageCageFeedTask.getHeight()); |
| | | } |
| | | if (bigStorageCageFeedTask.getLine() != 0) { |
| | | wrapper.eq(BigStorageCageFeedTask::getLine, bigStorageCageFeedTask.getLine()); |
| | | } |
| | | if (bigStorageCageFeedTask.getTaskState() != -1) { |
| | | wrapper.eq(BigStorageCageFeedTask::getTaskState, bigStorageCageFeedTask.getTaskState()); |
| | | } |
| | | if (bigStorageCageFeedTask.getTaskType() != 0) { |
| | | wrapper.eq(BigStorageCageFeedTask::getTaskType, bigStorageCageFeedTask.getTaskType()); |
| | | } |
| | | if (startTime != null && !startTime.isEmpty()) { |
| | | wrapper.ge(BigStorageCageFeedTask::getCreateTime, startTime); |
| | | } |
| | | if (endTime != null && !endTime.isEmpty()) { |
| | | wrapper.le(BigStorageCageFeedTask::getCreateTime, endTime); |
| | | } |
| | | wrapper.orderByDesc(BigStorageCageFeedTask::getId); |
| | | wrapper.and(item -> item.eq(BigStorageCageFeedTask::getDeleted, 0) |
| | | .or() |
| | | .eq(BigStorageCageFeedTask::getDeleted, 1)); |
| | | wrapper.between(BigStorageCageFeedTask::getCreateTime, startTime, endTime); |
| | | return baseMapper.selectList(wrapper); |
| | | } |
| | | } |