/*
|
* 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<DoorplateAddressEntity> {
|
|
/**
|
* 自定义分页
|
*
|
* @param page
|
* @param doorplateAddress
|
* @return
|
*/
|
List<DoorplateAddressVO> selectDoorplateAddressPage(IPage page,
|
@Param("doorplateAddress") DoorplateAddressVO doorplateAddress);
|
|
|
/**
|
* 查询街道数据
|
* @return
|
*/
|
List<TreeStringNode> getRegionListByGroupTwon(@Param("houseParam") HouseParam houseParam,
|
@Param("list") List<String> list,
|
@Param("communityList") List<String> communityList);
|
|
/**
|
* 查询社区数据
|
* @return
|
*/
|
List<TreeStringNode> getRegionListByGroupNei(@Param("houseParam") HouseParam houseParam,
|
@Param("list") List<String> list,
|
@Param("communityList") List<String> communityList);
|
|
/**
|
* 根据社区名称查询小区集合
|
* @param houseParam
|
* @param list 网格编号
|
* @param communityList 社区编号
|
* @return
|
*/
|
List<TreeStringNode> getDistrictList(@Param("houseParam") HouseParam houseParam,
|
@Param("list") List<String> list,
|
@Param("communityList") List<String> communityList);
|
|
/**
|
* 根据社区名称查询楼栋集合
|
* @param houseParam
|
* @param list 网格编号集合
|
* @return
|
*/
|
List<TreeStringNode> getBuildingList(@Param("houseParam") HouseParam houseParam,
|
@Param("list") List<String> list);
|
|
/**
|
* 查询户室及住户相关信息，单元中包含住户
|
* @param houseParam
|
* @param list
|
* @return
|
*/
|
List<FuncNode> getUnitHouseholdList(@Param("houseParam") HouseParam houseParam,
|
@Param("list") List<String> list);
|
|
/**
|
* 先查询门牌信息
|
* @param code
|
* @return
|
*/
|
DoorplateAddressVO getDoorplateAddressDetailByCode(@Param("code") String code);
|
|
List<DoorplateAddressVOTree> getTownStreetVOTreeList();
|
|
List<DoorplateAddressVOTree> getNeiVOTreeList(@Param("code") String code);
|
|
List<DoorplateAddressVOTree> getStreetRuVOTreeList(@Param("code") String code);
|
|
|
List<DoorplateAddressVOTree> getDistrictVOTreeList(@Param("code") String code);
|
|
List<DoorplateAddressVOTree> getBuildingVOTreeList(@Param("code") String code);
|
|
/**
|
* 查询街路巷
|
* @param houseParam
|
* @param list
|
* @return
|
*/
|
List<TreeStringNode> getStreetRuList(@Param("houseParam") HouseParam houseParam,
|
@Param("list") List<String> list);
|
|
/**
|
* 根据街路巷编号查询街路巷门牌名称集合
|
* @param houseParam name/code 该处当社区编号用/ 街路巷编号
|
* @param list
|
* @return
|
*/
|
List<FuncNode> getDoorplateNameList(@Param("houseParam") HouseParam houseParam,
|
@Param("list") List<String> 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<DoorplateAddressEntity> getAllDoorplateAddress(@Param("doorplateAddressEntity") DoorplateAddressEntity doorplateAddressEntity);
|
|
/**
|
* 获取房屋树
|
* @param houseParam
|
* @param list
|
* @return
|
*/
|
@MapKey("code")
|
Map<String, DoorplateAddressVOTree> getHouseTree(@Param("houseParam") HouseParam houseParam,
|
@Param("list") List<String> list);
|
/**
|
* 查询所有户室数据
|
* @param townName
|
* @return
|
*/
|
List<DoorplateAddressEntity> getHouseList(@Param("townName") String townName);
|
|
/**
|
* 查询商超
|
* @param houseParam
|
* @return
|
*/
|
List<TreeStringNode> getPlaceRelList(@Param("houseParam") HouseParam houseParam);
|
|
/**
|
* 查询商超详情集合
|
* @param houseParam
|
* @return
|
*/
|
List<FuncNode> getPlaceRelDetailList(@Param("houseParam") HouseParam houseParam);
|
|
/**
|
* 查询小区集合
|
* @param list
|
* @return
|
*/
|
List<DoorplateAddressEntity> getAoiList(@Param("list") List<Long> list);
|
|
/**
|
* 查询所有的地址表id集合
|
* @return
|
*/
|
List<Long> getAoiCodeList();
|
|
/**
|
* 查询所有的地址表和场所表差集集合(没有入库的)
|
* @return
|
*/
|
List<DoorplateAddressEntity> getNotInPlaceList(@Param("townName") String townName);
|
|
/**
|
* 查询场所标准地址数据
|
* @param doorplateAddressVO
|
* @param size
|
* @return
|
*/
|
List<DoorplateAddressEntity> getPlaceList(@Param("doorplateAddress") DoorplateAddressVO doorplateAddressVO,
|
@Param("size") Integer size,
|
@Param("gridCodeList") List<String> gridCodeList,
|
@Param("regionChildCodesList") List<String> regionChildCodesList,
|
@Param("isAdministrator") Integer isAdministrator);
|
|
/**
|
* 查询详情
|
* @param doorplateAddress
|
* @return
|
*/
|
DoorplateAddressVO getDoorplateAddressVODetail(@Param("doorplateAddress") DoorplateAddressVO doorplateAddress);
|
|
/**
|
* 查询所有的社区集合信息
|
* @return
|
*/
|
List<DoorplateAddressEntity> getAllCommunityList();
|
|
/**
|
* 通过小区id 查询楼栋编码
|
* @param districtId
|
* @return
|
*/
|
List<DoorplateAddressVO> 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<DoorplateAddressEntity> 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);
|
}
|
