提交【管理后台】订单管理-开票申请相关接口

mitao

2024-06-15 33becf92e0dc84504adefa9f579f3c8ab3da0c5a

提交【管理后台】订单管理-开票申请相关接口

 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>