/*
|
* 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.place.mapper;
|
|
import org.apache.ibatis.annotations.Param;
|
import org.springblade.common.node.TreeStringNode;
|
import org.springblade.modules.place.entity.PlaceEntity;
|
import org.springblade.modules.place.excel.ExportPlaceExcel;
|
import org.springblade.modules.place.excel.NinePlaceExcel;
|
import org.springblade.modules.place.excel.PlaceAndRelExcel;
|
import org.springblade.modules.place.vo.PlaceVO;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* 场所表 Mapper 接口
|
*
|
* @author BladeX
|
* @since 2023-10-28
|
*/
|
public interface PlaceMapper extends BaseMapper<PlaceEntity> {
|
|
|
/**
|
* 自定义分页
|
*
|
* @param page
|
* @param place
|
* @param regionChildCodesList
|
* @param isAdministrator
|
* @return
|
*/
|
List<PlaceVO> selectPlacePage(IPage page,
|
@Param("place") PlaceVO place,
|
@Param("gridCodeList") List<String> gridCodeList,
|
@Param("regionChildCodesList") List<String> regionChildCodesList,
|
@Param("isAdministrator") Integer isAdministrator);
|
|
/**
|
* 九小场所档案
|
*
|
* @param page
|
* @param place
|
* @param gridCodeList
|
* @param regionChildCodesList
|
* @param isAdministrator
|
* @param isAdministrator
|
* @return
|
*/
|
List<PlaceVO> selectNinePlacePage(IPage page,
|
@Param("place") PlaceVO place,
|
@Param("gridCodeList") List<String> gridCodeList,
|
@Param("regionChildCodesList") List<String> regionChildCodesList,
|
@Param("isAdministrator") Integer isAdministrator,
|
@Param("nineTypeList") List<String> nineTypeList);
|
|
|
/**
|
* 查询场所集合信息
|
*
|
* @param userId
|
* @return
|
*/
|
List<TreeStringNode> selectPlaceNodeList(@Param("userId") String userId);
|
|
/**
|
* 插入用户标签
|
*
|
* @param userId
|
* @param labelId
|
*/
|
int saveUserLabel(@Param("userId") Long userId, @Param("labelId") int labelId);
|
|
/**
|
* 查询所有的场所（手机号不为空）
|
*
|
* @return
|
*/
|
List<PlaceVO> getPlaceNotNullPhone();
|
|
/**
|
* 查询所有的场所
|
*
|
* @return
|
*/
|
List<PlaceVO> getAllHistoryPlace();
|
|
/**
|
* 更新场所信息
|
*
|
* @param place
|
*/
|
int updatePlaceEntity(@Param("place") PlaceVO place);
|
|
/**
|
* 查询场所详情数据
|
*
|
* @param place
|
* @return
|
*/
|
PlaceVO getDetail(@Param("place") PlaceEntity place);
|
|
/**
|
* 判断商超是否导入
|
*
|
* @param placeExcel
|
* @return
|
*/
|
PlaceEntity getPlaceAndRelInfo(@Param("place") PlaceAndRelExcel placeExcel);
|
|
/**
|
* 查询出有用户id 的场所
|
*
|
* @return
|
*/
|
List<PlaceEntity> getHasUserIdPlaceList();
|
|
/**
|
* 查询所有的场所数据（除去详情表已有的）
|
*
|
* @return
|
*/
|
List<PlaceEntity> getPlaceListByNoExt();
|
|
/**
|
* 商超数据处理
|
*
|
* @return
|
*/
|
List<PlaceEntity> placeAndRelHandle();
|
|
/**
|
* 根据编号集合查询对应的场所（按颜色区分近多少天没有发过任务的场所）4部分数据（三种颜色对应的+从来没有发过的）
|
*
|
* @param stringList
|
* @param tableName
|
* @return
|
*/
|
List<PlaceVO> getPlaceListByParam(@Param("list") List<String> stringList,
|
@Param("tableName") String tableName);
|
|
List<NinePlaceExcel> export(@Param("place") PlaceVO place,
|
@Param("houseCodeList") List<String> houseCodeList,
|
@Param("regionChildCodesList") List<String> regionChildCodesList,
|
@Param("isAdministrator") Integer isAdministrator,
|
@Param("nineTypeList") List<String> nineTypeList);
|
|
/**
|
* 查询 警务网格为空的数据
|
*
|
* @return
|
*/
|
List<PlaceEntity> getPlaceNotJwGridCode();
|
|
/**
|
* 比对两点间的距离是否在1km 范围内(和地址总表位置对比)
|
*
|
* @param placeVO
|
* @return
|
*/
|
Integer comparisonPosition(@Param("place") PlaceVO placeVO);
|
|
/**
|
* 比对两点间的距离是否在1km 范围内 (和采集的位置对比)
|
*
|
* @param placeVO
|
* @return
|
*/
|
Boolean comparisonPositionNotHouseCode(@Param("place") PlaceVO placeVO);
|
|
/**
|
* 查询 综治网格为空的数据
|
*
|
* @return
|
*/
|
List<PlaceEntity> getPlaceNotGridCode();
|
|
/**
|
* 查询对应未的场所 house_code_binds 为空，source = 1 的
|
*
|
* @return
|
*/
|
List<PlaceEntity> selectPlaceNotDoorBindList();
|
|
/**
|
* 查询绑定的房屋
|
*
|
* @param houseCodeBinds
|
* @return
|
*/
|
List<Map<String, Object>> getHouseBindMap(@Param("houseCodeBinds") String houseCodeBinds);
|
|
/**
|
* 企业商超列表查询
|
*/
|
List<PlaceVO> selectMallPage(IPage page,
|
@Param("place") PlaceVO place,
|
@Param("gridCodeList") List<String> gridCodeList,
|
@Param("regionChildCodesList") List<String> regionChildCodesList,
|
@Param("isAdministrator") Integer isAdministrator);
|
|
/**
|
* 查询所有场所数据
|
* @return
|
*/
|
List<PlaceVO> getAllList(@Param("i") int i,@Param("size") int size);
|
|
/**
|
* 查询所有场所数据总数
|
* @return
|
*/
|
int getAllListTotal();
|
|
/**
|
* 查询对应的社区编号
|
* @param id
|
* @return
|
*/
|
String getCommunityCode(@Param("id") Long id);
|
|
/**
|
* 导出场所信息
|
* @param place
|
* @return
|
*/
|
List<ExportPlaceExcel> exportPlaceList(@Param("place") PlaceVO place,
|
@Param("gridCodeList") List<String> gridCodeList,
|
@Param("regionChildCodesList") List<String> regionChildCodesList,
|
@Param("isAdministrator") Integer isAdministrator);
|
|
/**
|
* 查询附近场所
|
* @param lat
|
* @param lng
|
* @return
|
*/
|
List<PlaceVO> getNearbyPlaceList(String lat, String lng);
|
}
|
