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();
|
|
|
|
}
|
