huanghongfa
2021-01-15 ada9d2e3f734582a0d9ae8c00a936d8c8ed669d7
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngStructOtherBuildDAO.java
@@ -9,6 +9,8 @@
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import java.util.List;
/**
 * @program: springcloud_k8s_panzhihuazhihuishequ
 * @description: 其他建筑
@@ -48,4 +50,14 @@
            " </where>" +
            "</script>")
    IPage<ComMngStructOtherBuildVO> pageOtherBuild(Page page, @Param("comMngStructOtherBuildVO") ComMngStructOtherBuildVO comMngStructOtherBuildVO);
    @Select("SELECT\n" +
            "b.type_id \n" +
            "FROM\n" +
            "com_mng_struct_other_build b\n" +
            "WHERE\n" +
            "b.community_id = #{communityId}\n" +
            "GROUP BY\n" +
            "b.type_id")
    List<Long> selectAllBuildTypeIds(Long communityId);
}