package com.panzhihua.service_community.dao;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.panzhihua.common.model.vos.shop.ComShopUserAddressVO;
|
import com.panzhihua.service_community.model.dos.ComShopUserAddressDO;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
/**
|
* @auther lyq
|
* @create 2021-04-14 15:04:16
|
* @describe 用户收货地址表mapper类
|
*/
|
@Mapper
|
public interface ComShopUserAddressDAO extends BaseMapper<ComShopUserAddressDO> {
|
|
@Select("select id,`name`,phone,province_code,province_name,city_code,city_name" +
|
",district_code,district_name,detail_address,is_default " +
|
" from com_shop_user_address where user_id = #{userId} order by create_at desc")
|
List<ComShopUserAddressVO> pageUserAddressList(Page page, @Param("userId") Long userId);
|
|
}
|
