| | |
| | | // taskSts.add(TaskStsType.COMPLETE_OUTBOUND.sts); |
| | | taskSts.add(TaskStsType.COMPLETE_CHARGE.sts); |
| | | taskSts.add(TaskStsType.COMPLETE_MOVE.sts); |
| | | // taskSts.add(TaskStsType.COMPLETE_MANUAL.sts); |
| | | taskSts.add(TaskStsType.COMPLETE_MANUAL.sts); |
| | | |
| | | List<Task> tasks = taskService.list(new LambdaQueryWrapper<Task>() |
| | | .eq(Task::getStatus, 1) |
| | |
| | | |
| | | <select id="selectWorkingByShuttle" resultType="com.zy.asrs.wcs.core.entity.Task"> |
| | | select * from wcs_task |
| | | where task_sts in (1,2,3,101,102,103,301,302,303,401,402,403) |
| | | where task_sts in (1,2,3,101,102,103,301,302,303,401,402,403,501,502,503) |
| | | and shuttle_no = #{shuttleNo} |
| | | <if test="taskNo!=null"> |
| | | and task_no != #{taskNo} |
| | |
| | | |
| | | <select id="selectWorkingByLift" resultType="com.zy.asrs.wcs.core.entity.Task"> |
| | | select * from wcs_task |
| | | where task_sts in (1,2,3,101,102,103,201,202,203,301,302,303,401,402,403) |
| | | where task_sts in (1,2,3,101,102,103,201,202,203,301,302,303,401,402,403,501,502,503) |
| | | and lift_no = #{liftNo} |
| | | <if test="taskNo!=null"> |
| | | and task_no != #{taskNo} |