springboot-vue3/src/main/java/com/example/springboot/mapper/SpianMapper.java
@@ -132,6 +132,8 @@ //寻找可以多片出片的玻璃 @Select("select cage,cell,ROUND(id/2)as prcId,width,count(glass_id)shu from storage_cage where order_id=#{orderid} and (cage!=#{cage} or cell!=#{cell}) GROUP BY cage,cell HAVING shu=1 ORDER BY cage desc,cell desc limit 1") StorageCage SelectQueout(String orderid,int cage,int cell); //获取进片队列id @Select("select glassid from queue where type=1 and state=0;") String Selectqueueid(); }