/* * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in the * documentation and/or other materials provided with the distribution. * Neither the name of the dreamlu.net developer nor the names of its * contributors may be used to endorse or promote products derived from * this software without specific prior written permission. * Author: Chill 庄骞 (smallchill@163.com) */ package org.springblade.modules.doorplateAddress.mapper; import com.baomidou.mybatisplus.annotation.InterceptorIgnore; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.core.metadata.IPage; import org.apache.ibatis.annotations.MapKey; import org.apache.ibatis.annotations.Param; import org.springblade.common.node.TreeStringNode; import org.springblade.modules.doorplateAddress.entity.DoorplateAddressEntity; import org.springblade.modules.doorplateAddress.vo.DoorplateAddressVOTree; import org.springblade.modules.doorplateAddress.vo.DoorplateAddressVO; import org.springblade.modules.doorplateAddress.vo.FuncNode; import org.springblade.modules.house.vo.HouseParam; import java.util.List; import java.util.Map; /** * 门牌地址表（总台账数据） Mapper 接口 * * @author BladeX * @since 2023-10-28 */ public interface DoorplateAddressMapper extends BaseMapper { /** * 自定义分页 * * @param page * @param doorplateAddress * @return */ List selectDoorplateAddressPage(IPage page, @Param("doorplateAddress") DoorplateAddressVO doorplateAddress); /** * 查询街道数据 * @return */ List getRegionListByGroupTwon(@Param("houseParam") HouseParam houseParam, @Param("list") List list, @Param("communityList") List communityList); /** * 查询社区数据 * @return */ List getRegionListByGroupNei(@Param("houseParam") HouseParam houseParam, @Param("list") List list, @Param("communityList") List communityList); /** * 根据社区名称查询小区集合 * @param houseParam * @param list 网格编号 * @param communityList 社区编号 * @return */ List getDistrictList(@Param("houseParam") HouseParam houseParam, @Param("list") List list, @Param("communityList") List communityList); /** * 根据社区名称查询楼栋集合 * @param houseParam * @param list 网格编号集合 * @return */ List getBuildingList(@Param("houseParam") HouseParam houseParam, @Param("list") List list); /** * 查询户室及住户相关信息，单元中包含住户 * @param houseParam * @param list * @return */ List getUnitHouseholdList(@Param("houseParam") HouseParam houseParam, @Param("list") List list); /** * 先查询门牌信息 * @param code * @return */ DoorplateAddressVO getDoorplateAddressDetailByCode(@Param("code") String code); List getTownStreetVOTreeList(); List getNeiVOTreeList(@Param("code") String code); List getStreetRuVOTreeList(@Param("code") String code); List getDistrictVOTreeList(@Param("code") String code); List getBuildingVOTreeList(@Param("code") String code); /** * 查询街路巷 * @param houseParam * @param list * @return */ List getStreetRuList(@Param("houseParam") HouseParam houseParam, @Param("list") List list); /** * 根据街路巷编号查询街路巷门牌名称集合 * @param houseParam name/code 该处当社区编号用/ 街路巷编号 * @param list * @return */ List getDoorplateNameList(@Param("houseParam") HouseParam houseParam, @Param("list") List list); /** * 根据参数获取地址详情 * @param doorplateAddressVO * @return */ @InterceptorIgnore(tenantLine = "true") DoorplateAddressVO getDoorplateAddressDetail(@Param("vo") DoorplateAddressVO doorplateAddressVO); /** * 根据参数获取地址详情 * @param doorplateAddressVO * @return */ DoorplateAddressVO getDoorplateAddressList(@Param("vo") DoorplateAddressVO doorplateAddressVO); /** * 查询社区信息 * @param doorplateAddressEntity * @return */ List getAllDoorplateAddress(@Param("doorplateAddressEntity") DoorplateAddressEntity doorplateAddressEntity); /** * 获取房屋树 * @param houseParam * @param list * @return */ @MapKey("code") Map getHouseTree(@Param("houseParam") HouseParam houseParam, @Param("list") List list); /** * 查询所有户室数据 * @param townName * @return */ List getHouseList(@Param("townName") String townName); /** * 查询商超 * @param houseParam * @return */ List getPlaceRelList(@Param("houseParam") HouseParam houseParam); /** * 查询商超详情集合 * @param houseParam * @return */ List getPlaceRelDetailList(@Param("houseParam") HouseParam houseParam); /** * 查询小区集合 * @param list * @return */ List getAoiList(@Param("list") List list); /** * 查询所有的地址表id集合 * @return */ List getAoiCodeList(); /** * 查询所有的地址表和场所表差集集合(没有入库的) * @return */ List getNotInPlaceList(@Param("townName") String townName); /** * 查询场所标准地址数据 * @param doorplateAddressVO * @param size * @return */ List getPlaceList(@Param("doorplateAddress") DoorplateAddressVO doorplateAddressVO, @Param("size") Integer size, @Param("gridCodeList") List gridCodeList, @Param("regionChildCodesList") List regionChildCodesList, @Param("isAdministrator") Integer isAdministrator); /** * 查询详情 * @param doorplateAddress * @return */ DoorplateAddressVO getDoorplateAddressVODetail(@Param("doorplateAddress") DoorplateAddressVO doorplateAddress); /** * 查询所有的社区集合信息 * @return */ List getAllCommunityList(); /** * 通过小区id 查询楼栋编码 * @param districtId * @return */ List getHouseBuildingCode(String districtId); /** * 查询绑定房屋总数 * @param townName * @return */ Integer getNotHouseListCount(@Param("townName") String townName); /** * 查询网格范围表未绑定的地址表信息数量 * @param townName * @return */ Integer getNotBindGridRangeDoorListCount(@Param("townName") String townName, @Param("communityName") String communityName); /** * 查询所有未匹配的网格范围地址数据 * @param townName * @param communityName * @return */ List getNotBindGridRangeDoorList(@Param("townName") String townName, @Param("communityName") String communityName); /** * 根据房屋id 查询对应的地址信息 * @param houseId * @return */ DoorplateAddressVO getDoorplateAddressDetailByHouseId(@Param("houseId") Long houseId); /** * 查询未入库的场所 * @param townName * @return */ Integer getNotPlaceListCount(@Param("townName") String townName); }