| | |
| | | </select> |
| | | |
| | | <select id="pageOrderBy" resultType="com.panzhihua.common.model.vos.shop.ComShopOrderSearchVO"> |
| | | SELECT distinct sr.id, sr.store_id, sr.user_id, su.phone AS userName , sr.order_no, sr.pay_no, |
| | | SELECT sr.id, sr.store_id, sr.user_id, su.phone AS userName , sr.order_no, sr.pay_no, |
| | | sr.wx_tarde_no, sr.status, sr.pay_status, sr.receiver_id, |
| | | sr.total_amount, sr.discount_amount, sr.pay_amount, sr.pay_type, |
| | | sr.pay_time, sr.delivery_type, sr.delivery_status, sr.logistics_company, |
| | |
| | | AND ss.id = #{pageComShopOrderSearchDTO.storeId} |
| | | </if> |
| | | <if test='pageComShopOrderSearchDTO.storeUserId != null '> |
| | | AND ss.sys_user_id = #{pageComShopOrderSearchDTO.storeUserId} |
| | | AND ss.user_id = #{pageComShopOrderSearchDTO.storeUserId} |
| | | </if> |
| | | <if test='pageComShopOrderSearchDTO.deliveryType != null '> |
| | | AND sr.delivery_type = #{pageComShopOrderSearchDTO.deliveryType} |