package com.panzhihua.service_community.dao;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.panzhihua.common.model.dtos.shop.PageComOrderListDTO;
|
import com.panzhihua.common.model.vos.shop.ComShopOrderPageVO;
|
import com.panzhihua.common.model.vos.shop.ComShopOrderVO;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.panzhihua.common.model.dtos.PageDTO;
|
import com.panzhihua.common.model.dtos.shop.PageComShopOrderSearchDTO;
|
import com.panzhihua.common.model.vos.shop.ComShopOrderVO;
|
import com.panzhihua.common.model.vos.shop.ComShopStoreVO;
|
import com.panzhihua.service_community.model.dos.ComShopOrderDO;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.apache.ibatis.annotations.Select;
|
|
/**
|
* @auther cedoo
|
* @create 2021-4-17 17:35:51
|
* @describe 订单表mapper类
|
*/
|
@Mapper
|
public interface ComShopOrderDAO extends BaseMapper<ComShopOrderDO> {
|
|
@Select("<script> " +
|
"select order_no,store_id,`status`,pay_status,receiver_id,total_amount as orderTotal,pay_amount,delivery_type,remark,create_at from com_shop_order as cso" +
|
" where 1=1 and cso.delete_status = 1 and cso.user_id = #{comOrderListDTO.userId}" +
|
"<if test='comOrderListDTO.status != null'>" +
|
" AND cso.status = #{comOrderListDTO.status} " +
|
" </if> " +
|
" order by create_at desc " +
|
" </script>")
|
IPage<ComShopOrderPageVO> pageOrderList(Page page,@Param("comOrderListDTO") PageComOrderListDTO comOrderListDTO);
|
|
@Select("<script> " +
|
"SELECT ordr.id, ordr.store_id, ordr. user_id, ordr.order_no, ordr.pay_no, \n" +
|
" ordr.wx_tarde_no, ordr.status, ordr.pay_status, ordr.receiver_id, \n" +
|
" ordr.total_amount, ordr.discount_amount, ordr.pay_amount, ordr.pay_type, \n" +
|
" ordr.pay_time, ordr.delivery_type, ordr.delivery_status, ordr.logistics_company, \n" +
|
" ordr.logistics_no, ordr.create_at \n" +
|
" FROM com_shop_order ordr LEFT JOIN com_shop_order_goods goods ON ordr.id = goods.order_id \n" +
|
" order by create_at desc"+
|
"</script>")
|
IPage<ComShopOrderVO> pageOrderBy(PageDTO page,@Param("pageComShopOrderSearchDTO") PageComShopOrderSearchDTO pageComShopOrderSearchDTO);
|
|
}
|
