package com.panzhihua.service_community.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.panzhihua.common.model.dtos.property.CommonPage;
import com.panzhihua.common.model.vos.community.ProvinceCityReturnVO;
import org.apache.ibatis.annotations.Mapper;
import com.panzhihua.service_community.entity.BcRegion;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 行政区划表(BcRegion)表数据库访问层
 * projectName 成都呐喊信息技术有限公司-智慧社区项目
 * description: 行政区划表相关功能
 *
 * @author zzj
 * @since 2022-04-20 14:26:13
 */
@Mapper
public interface BcRegionDao extends BaseMapper<BcRegion> {

    /**
     * 姓名查询
     * @param province
     * @param city
     * @param country
     * @return
     */
    String selectByName(@Param("province") String province,@Param("city") String city,@Param("county")String country,@Param("town")String town);

    /**
     * 通过名称查询社区编码
     * @param city
     * @param country
     * @param town
     * @param villagetr
     * @return
     */
    String selectCommunityCodeByName(@Param("city") String city,@Param("county")String country,@Param("town")String town,@Param("villagetr") String villagetr);

    List<ProvinceCityReturnVO> selectFirst();

    List<ProvinceCityReturnVO> selectSecond(String name);

    List<ProvinceCityReturnVO> selectThird(String name);

    List<ProvinceCityReturnVO> selectFourth(String name);
}