agv相关接口流程修改

pang.jiabao

2025-11-20 2101fe61627cad7329376f61f7265af824c459b5

 src/main/java/com/zy/asrs/mapper/BasStationMapper.java

@@ -3,10 +3,28 @@
import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.zy.asrs.entity.BasStation;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface BasStationMapper extends BaseMapper<BasStation> {

    /**
     * 更新库位状态
     */
    @Update({
            "<script>",
            "UPDATE agv_bas_station",
            "SET loc_sts = #{sts}",
            "WHERE dev_no IN",
            "<foreach collection='siteList' item='item' open='(' separator=',' close=')'>",
            "#{item}",
            "</foreach>",
            "</script>"
    })
    void updateLocStsBatch(@Param("siteList") List<String> siteList, @Param("sts") String sts);
}