| | |
|---|
| | | import com.baomidou.dynamic.datasource.annotation.DS; |
|---|
| | | import com.baomidou.mybatisplus.annotation.InterceptorIgnore; |
|---|
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
|---|
| | | import com.mes.downglassinfo.entity.DownGlassInfo; |
|---|
| | | import com.mes.downglassinfo.entity.DownGlassTask; |
|---|
| | | import com.mes.downworkstation.entity.DownWorkstation; |
|---|
| | | import org.apache.ibatis.annotations.*; |
|---|
| | | import org.apache.ibatis.annotations.Mapper; |
|---|
| | | import org.apache.ibatis.annotations.Select; |
|---|
| | | import org.springframework.stereotype.Repository; |
|---|
| | | |
|---|
| | | import java.util.List; |
|---|
| | | import java.util.Map; |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * <p> |
|---|
| | | * Mapper 接口 |
|---|
| | | * Mapper 接口 |
|---|
| | | * </p> |
|---|
| | | * |
|---|
| | | * @author zhoush |
|---|
| | |
|---|
| | | public interface DownWorkstationMapper extends BaseMapper<DownWorkstation> { |
|---|
| | | |
|---|
| | | |
|---|
| | | //查询工位表和任务表中状态为1的流程卡号和已落架数量 |
|---|
| | | //查询工位表和任务表中状态为1的流程卡号和已落架数量 |
|---|
| | | @Select("SELECT dwt.flow_card_id,dw.id,dw.racks_number FROM down_workstation_task dwt JOIN down_workstation dw ON dwt.flow_card_id = dw.flow_card_id WHERE dwt.state = 1 LIMIT 1") |
|---|
| | | List<DownWorkstation> selectdownWorkstationstate(); |
|---|
| | | |
|---|
| | |
|---|
| | | // void updateFlowCardId(DownWorkstation downWorkstation); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | // @Update("UPDATE down_workstation_task SET state = 0 WHERE flow_card_id = #{flowCardId}") |
|---|
| | | // void update_task_state_to_zero(@Param("flowCardId") String flowCardId); |
|---|
| | | |
|---|
| | | |
|---|
| | | // @Select("SELECT * FROM down_workstation WHERE workstation_id BETWEEN #{startId} AND #{endId}") |
|---|
| | | // List<DownWorkstation> getDownWorkstationsInRange(@Param("startId") int startId, @Param("endId") int endId); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | // @Select("SELECT DISTINCT flowcard_id from glass_info") |
|---|
