From 184a0722e53f64f40ddb2c88f11f26941f565a8c Mon Sep 17 00:00:00 2001 From: ZY <zc857179121@qq.com> Date: 星期三, 18 十二月 2024 14:56:44 +0800 Subject: [PATCH] 上报逻辑调整 --- src/main/java/com/zy/asrs/mapper/AgvLocMastMapper.java | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/AgvLocMastMapper.java b/src/main/java/com/zy/asrs/mapper/AgvLocMastMapper.java index aadd73d..8251128 100644 --- a/src/main/java/com/zy/asrs/mapper/AgvLocMastMapper.java +++ b/src/main/java/com/zy/asrs/mapper/AgvLocMastMapper.java @@ -33,4 +33,8 @@ @Select("SELECT loc_type2 FROM agv_loc_mast WHERE loc_type1 = #{locType1} AND loc_type2 IS NOT NULL GROUP BY loc_type2") List<String> queryContainerTypeByLocType1(@Param("locType1")Short locType1); + + + @Select("SELECT distinct map_row1 as mapRow1,right_side as rightSide FROM agv_loc_mast WHERE lev1 = #{lev1} And floor = #{floor} order by map_row1") + List<AgvLocMast> selectDistinctLocByLevAndFloor(@Param("lev1")Integer lev1,@Param("floor")Integer floor); } -- Gitblit v1.9.1