package com.project.system.mapper;

import com.project.system.domain.SysRegion;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.project.system.domain.vo.RegionVO;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 行政区划Mapper接口
 *
 * @author manton
 * @date 2023-04-13
 */
public interface SysRegionMapper extends BaseMapper<SysRegion> {


    List<RegionVO> regionTree(@Param("parentCode") String parentCode,
                              @Param("name") String name);

    @Select("SELECT  `code` FROM sys_region where parent_code = #{parentId} ORDER BY `code` DESC LIMIT 1")
    String regionCode(@Param("parentId") String parentId);
}