From 33becf92e0dc84504adefa9f579f3c8ab3da0c5a Mon Sep 17 00:00:00 2001
From: mitao <2763622819@qq.com>
Date: 星期六, 15 六月 2024 18:15:35 +0800
Subject: [PATCH] 提交【管理后台】订单管理-开票申请相关接口
---
ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderReturnRequestMapper.xml | 65 ++++++++++++++++++++++++++++++++
1 files changed, 65 insertions(+), 0 deletions(-)
diff --git a/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderReturnRequestMapper.xml b/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderReturnRequestMapper.xml
index a542c34..110ea99 100644
--- a/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderReturnRequestMapper.xml
+++ b/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderReturnRequestMapper.xml
@@ -2,4 +2,69 @@
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ruoyi.order.mapper.OrderReturnRequestMapper">
+ <select id="getOrderReturnRequestPage"
+ resultType="com.ruoyi.order.controller.management.vo.MgtOrderReturnRequestVO">
+ SELECT
+ torr.*,
+ o.order_no,
+ o.member_id,
+ CASE
+ WHEN o.order_from = 4 THEN 2 -- 当order_from为拍卖订单时，orderType赋值为2
+ ELSE 1 -- 其他情况下，orderType赋值为1
+ END AS orderType,
+ o.order_from
+ FROM
+ t_order_return_request torr
+ LEFT JOIN t_order o ON torr.order_id = o.id
+ <where>
+ <if test="query.orderNo != null and query.orderNo != ''">
+ AND o.order_no LIKE concat('%', #{query.orderNo}, '%')
+ </if>
+ <if test="query.requestType != null">
+ AND torr.request_type = #{query.requestType}
+ </if>
+ <if test="query.memberIdSet!=null">
+ <foreach collection="query.memberIdSet" item="memberId" separator=","
+ open="AND o.member_id in (" close=")">
+ #{memberId}
+ </foreach>
+ </if>
+ <if test="query.auditStatus != null">
+ AND torr.audit_status = #{query.auditStatus}
+ </if>
+ <if test="query.status != null">
+ AND torr.status = #{query.status}
+ </if>
+ <if test="query.orderType != null and query.orderType== 1">
+ AND o.order_from in (1,2,3)
+ </if>
+ <if test="query.orderType != null and query.orderType== 2">
+ AND o.order_from = 4
+ </if>
+ </where>
+ ORDER BY torr.create_time DESC
+ </select>
+ <select id="getOrderReturnRequestDetail"
+ resultType="com.ruoyi.order.controller.management.vo.MgtOrderReturnRequestVO"
+ parameterType="java.lang.Long">
+ SELECT torr.*,
+ o.order_no,
+ o.member_id,
+ o.order_time,
+ o.pay_time,
+ o.paymemt_method,
+ o.price,
+ o.points,
+ o.total_amount,
+ o.discount_money,
+ CASE
+ WHEN o.order_from = 4 THEN 2 -- 当order_from为拍卖订单时，orderType赋值为2
+ ELSE 1 -- 其他情况下，orderType赋值为1
+ END AS orderType,
+ o.order_from
+ FROM t_order_return_request torr
+ LEFT JOIN t_order o
+ ON torr.order_id = o.id
+ WHERE torr.id = #{id}
+ </select>
</mapper>
--
Gitblit v1.7.1