| | |
|---|
| | | |
|---|
| | | <select id="pageOrderList" resultType="com.panzhihua.common.model.vos.shop.ComShopFlowerOrderPageVO"> |
|---|
| | | select id as orderId,order_no,store_id,`status`,pay_status,receiver_id,total_amount as |
|---|
| | | orderTotal,pay_amount,delivery_type,remark,create_at from com_shop_flower_order as cso |
|---|
| | | orderTotal,pay_amount,delivery_type,remark,create_at, logistics_company, logistics_no from com_shop_flower_order as cso |
|---|
| | | where cso.delete_status = 1 |
|---|
| | | <if test="comOrderListDTO.userId != null"> |
|---|
| | | and cso.user_id = #{comOrderListDTO.userId} |
|---|
