| | |
|---|
| | | 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" + |
|---|
| | | "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_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} " + |
|---|
| | |
|---|
| | | " sr.wx_tarde_no, sr.status, sr.pay_status, sr.receiver_id, \n" + |
|---|
| | | " sr.total_amount, sr.discount_amount, sr.pay_amount, sr.pay_type, \n" + |
|---|
| | | " sr.pay_time, sr.delivery_type, sr.delivery_status, sr.logistics_company, \n" + |
|---|
| | | " sr.logistics_no, sr.create_at, uad.name as receiver_name, uad.phone as receiver_phone, group_concat(og.goods_name) as goodsName \n" + |
|---|
| | | " sr.logistics_no, sr.create_at, uad.name as receiver_name, uad.phone as receiver_phone, group_concat(og.goods_name) as goodsName, ss.name as store_name \n" + |
|---|
| | | " FROM com_shop_order sr LEFT JOIN com_shop_order_goods og ON sr.id = og.order_id \n" + |
|---|
| | | " LEFT JOIN com_shop_goods_attr ga ON og.goods_attr_id = ga.id \n" + |
|---|
| | | " LEFT JOIN sys_user su ON sr.user_id = su.user_id \n" + |
|---|
| | |
|---|
| | | "<if test='pageComShopOrderSearchDTO.storeName != null '>" + |
|---|
| | | " AND ss.name like concat('%', #{pageComShopOrderSearchDTO.storeName}, '%') " + |
|---|
| | | " </if> " + |
|---|
| | | "<if test='pageComShopOrderSearchDTO.storeId != null '>" + |
|---|
| | | " AND ss.id = #{pageComShopOrderSearchDTO.storeId} " + |
|---|
| | | " </if> " + |
|---|
| | | "<if test='pageComShopOrderSearchDTO.storeUserId != null '>" + |
|---|
| | | " AND ss.sys_user_id = #{pageComShopOrderSearchDTO.storeUserId} " + |
|---|
| | | " </if> " + |
|---|
| | | " GROUP BY sr.id " + |
|---|
| | | " ORDER BY sr.create_at "+ |
|---|
| | | "</script>") |
|---|
| | |
|---|
| | | " LEFT JOIN com_shop_store ss ON sr.store_id = ss.id \n" + |
|---|
| | | " WHERE sr.delete_status = 1" + |
|---|
| | | "<if test='comShopOrderExportDTO.userId != null'>" + |
|---|
| | | " AND ss.user_id = #{comShopOrderExportDTO.userId} " + |
|---|
| | | " AND sr.user_id = #{comShopOrderExportDTO.userId} " + |
|---|
| | | " </if> " + |
|---|
| | | "<if test='comShopOrderExportDTO.storeUserId != null '>" + |
|---|
| | | " AND ss.sys_user_id = #{comShopOrderExportDTO.storeUserId} " + |
|---|
| | | " </if> " + |
|---|
| | | "<if test='comShopOrderExportDTO.orderIds != null and comShopOrderExportDTO.orderIds.length>0 '>" + |
|---|
| | | " AND sr.id in " + |
|---|
