From ce33567aee14fb59e590852309264f1bf0140a20 Mon Sep 17 00:00:00 2001 From: rentaiming <806181062@qq.com> Date: 星期一, 15 七月 2024 18:19:19 +0800 Subject: [PATCH] 修改bug --- ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml | 19 +++++++++++++++++++ 1 files changed, 19 insertions(+), 0 deletions(-) diff --git a/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml b/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml index c7af134..54a8be8 100644 --- a/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml +++ b/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml @@ -106,6 +106,25 @@ </select> + + + <select id="getOrderByGroupPurchaseMemberId1" resultType="com.ruoyi.system.api.domain.Order"> + SELECT + o.* + FROM + t_order o + <where> + o.goods_sku_id = #{goodsSkuId} + AND o.del_flag=0 + AND o.member_id=#{memberId} + AND o.order_from = 3 + AND o.order_status in (2,3) + </where> + + + </select> + + <select id="getStaticsOrderList" resultType="com.ruoyi.system.api.domain.Order"> SELECT * -- Gitblit v1.7.1