投票人员查询优化

linwei

2024-02-22 7bcd0d2d7510cb2ba67099cd768e1b2b6d047dc2

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

@@ -19,6 +19,7 @@
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.NinePlaceExcel;
import org.springblade.modules.place.excel.PlaceAndRelExcel;
import org.springblade.modules.place.vo.PlaceVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
@@ -33,17 +34,41 @@
 */
public interface PlaceMapper extends BaseMapper<PlaceEntity> {


   /**
    * 九小场所档案
    *
    * @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 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("houseCodeList") List<String> houseCodeList,
                          @Param("regionChildCodesList") List<String> regionChildCodesList,
                          @Param("isAdministrator") Integer isAdministrator);

   /**
    * 查询场所集合信息
@@ -110,10 +135,37 @@
   List<PlaceEntity> placeAndRelHandle();

   /**
    * 根据标签编号集合查询对应的场所
    * 根据编号集合查询对应的场所（按颜色区分近多少天没有发过任务的场所）4部分数据（三种颜色对应的+从来没有发过的）
    * @param stringList
    * @param tableName
    * @return
    */
    List<PlaceVO> getPlaceListByParam(@Param("list") List<String> stringList,
                             @Param("color") String color);
                             @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);
}