package com.doumee.dao.business;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.doumee.dao.business.model.HotCity;
import com.doumee.dao.web.response.HotCityResponse;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author 江蹄蹄
 * @date 2023/03/21 15:48
 */
public interface HotCityMapper extends BaseMapper<HotCity> {




    /****************************************移动端方法开始********************************************************************/

    /**
     * 获取常用城市列表
     * @return
     */
    @Select("  select h.id , h.city_id as cityId , a.name as cityName  from hot_city h left join  areas a on h.city_id =  a.id  " +
            " order by h.SORTNUM desc   ")
    List<HotCityResponse> getHotCityResponse();



}