三色任务和自查任务

linwe

2024-08-02 a1eede2f9f7c2590952ab1bdf34210020cdde7c6

 src/main/java/org/springblade/modules/place/mapper/PlaceMapper.java

@@ -19,12 +19,14 @@
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 接口
@@ -36,72 +38,87 @@


   /**
    * 九小场所档案
    *
    * @param page
    * @param place
    * @param houseCodeList
    * @param regionChildCodesList
    * @param isAdministrator
    * @return
    */
   List<PlaceVO> selectNinePlacePage(IPage page,
                          @Param("place") PlaceVO place,
                          @Param("houseCodeList") List<String> houseCodeList,
                          @Param("regionChildCodesList") List<String> regionChildCodesList,
                          @Param("isAdministrator") Integer isAdministrator);


   /**
    * 自定义分页
    *
    * @param page
    * @param place
    * @param houseCodeList
    * @param regionChildCodesList
    * @param isAdministrator
    * @return
    */
   List<PlaceVO> selectPlacePage(IPage page,
                          @Param("place") PlaceVO place,
                          @Param("houseCodeList") List<String> houseCodeList,
                          @Param("gridCodeList") List<String> gridCodeList,
                          @Param("regionChildCodesList") List<String> regionChildCodesList,
                          @Param("isAdministrator") Integer isAdministrator);

   /**
    *  自定义分页
    * @param page
    * @param place
    * @return
    */
   List<PlaceVO> getPlacePage(IPage page,  @Param("place") PlaceVO place);

   /**
    * 九小场所档案
    *
    * @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);
   List<TreeStringNode> selectPlaceNodeList(@Param("userId") String userId);

   /**
    * 插入用户标签
    *
    * @param userId
    * @param labelId
    */
   int saveUserLabel(@Param("userId") Long userId,@Param("labelId")  int 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
    */
@@ -109,6 +126,7 @@

   /**
    * 判断商超是否导入
    *
    * @param placeExcel
    * @return
    */
@@ -116,39 +134,129 @@

   /**
    * 查询出有用户id 的场所
    *
    * @return
    */
    List<PlaceEntity> getHasUserIdPlaceList();
   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,
   List<PlaceVO> getPlaceListByParam(@Param("list") List<String> stringList,
                             @Param("tableName") String tableName);

   List<NinePlaceExcel> export( @Param("place") PlaceVO place,
                         @Param("houseCodeList") List<String> houseCodeList,
   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<PlaceEntity> getPlaceNotJwGridCode();
    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);
}