package com.zy.asrs.mapper; import com.zy.asrs.entity.TaskWrk; import com.baomidou.mybatisplus.mapper.BaseMapper; import com.zy.asrs.entity.WrkMast; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import org.springframework.stereotype.Repository; import java.util.Date; import java.util.List; @Mapper @Repository public interface TaskWrkMapper extends BaseMapper { TaskWrk selectByTaskNo(String taskNo); TaskWrk selectByStartPoint(@Param("startPoint") String startPoint); TaskWrk selectByWrkNo(Integer wrkNo); List selectReceive();//获取接收任务 TaskWrk selectPakIn(@Param("crnNo") Integer crnNo, @Param("workNo") Integer workNo, @Param("startPoint") String startPoint); List selectPakOut(@Param("crnNo") Integer crnNo, @Param("targetPoint") String targetPoint); List selectPakOut3(@Param("crnNo") Integer crnNo, @Param("targetPoint") String targetPoint); List selectPakOutIoType(@Param("crnNo") Integer crnNo); TaskWrk selectCrnWorking(@Param("crnNo") Integer crnNo); TaskWrk selectCrnStaWorking(@Param("crnNo") Integer crnNo, @Param("targetPoint") String targetPoint); TaskWrk selectCrnNoInWorking(@Param("crnNo") Integer crnNo,@Param("workNo") Integer workNo); TaskWrk selectWalkSta(@Param("crnNo") Integer crnNo,@Param("workNo") Integer workNo); List selectToBeHistoryData(); int saveToHistory(String taskNo);//将任务转历史日志 List selectWorkingTask();//获取工作中的任务 List selectTaskWrkList(@Param("wrkNo") Integer wrkNo, @Param("taskNo") Integer taskNo, @Param("status") Integer status, @Param("modiTimeStart") Date modiTimeStart, @Param("modiTimeEnd") Date modiTimeEnd, @Param("pageNumber") Integer curr, @Param("pageSize") Integer limit); Long selectTaskWrkListTotal(@Param("wrkNo") Integer wrkNo, @Param("taskNo") Integer taskNo, @Param("status") Integer status, @Param("modiTimeStart") Date modiTimeStart, @Param("modiTimeEnd") Date modiTimeEnd); int saveToHistoryD(String taskNo);//将任务转历史日志 }