拿不到地址总表数据，不设置网格信息

linwei

2024-01-31 b3b566ebdfed4005aaa513da3d5d2fd3924903cc

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

@@ -17,8 +17,9 @@
package org.springblade.modules.place.mapper;

import org.apache.ibatis.annotations.Param;
import org.springblade.common.node.TreeNode;
import org.springblade.common.node.TreeStringNode;
import org.springblade.modules.place.entity.PlaceEntity;
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;
@@ -37,14 +38,87 @@
    *
    * @param page
    * @param place
    * @param houseCodeList
    * @param regionChildCodesList
    * @param isAdministrator
    * @return
    */
   List<PlaceVO> selectPlacePage(IPage page, PlaceVO place);
   List<PlaceVO> selectPlacePage(IPage page,
                          @Param("place") PlaceVO place,
                          @Param("houseCodeList") List<String> houseCodeList,
                          @Param("regionChildCodesList") List<String> regionChildCodesList,
                          @Param("isAdministrator") Integer isAdministrator);

   /**
    * 查询场所集合信息
    * @param userId
    * @return
    */
    List<TreeNode> 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);

   /**
    * 查询所有的场所（手机号不为空）
    * @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);
}