springboot-vue3/src/main/java/com/example/springboot/mapper/HomeMapper.java
@@ -262,7 +262,7 @@ StorageCage SelectStorageByCell(String cell); // 手动完成任务 @Select("update storage_task set task_state=1 where id=1429") @Select("update storage_task set task_state=1 where id=#{id}") void FinishTask(Integer id); @Select("select gi.* from glassinfo gi inner join flowcard fc on gi.flowcard=fc.flowcard where fc.state!=2 and position(#{width} in gi.width) and position(#{height} in gi.height) and position(#{thickness} in gi.thickness) and position(#{films} in gi.films) group by gi.id")