From 579ee657f7404ecc2d216e56a19df11006150bb0 Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Mon, 28 Jun 2021 22:43:18 +0800
Subject: [PATCH] 20210628 集物员审核

---
 gc-shop/src/main/resources/mapper/shop/JhyOrderMapper.xml |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/gc-shop/src/main/resources/mapper/shop/JhyOrderMapper.xml b/gc-shop/src/main/resources/mapper/shop/JhyOrderMapper.xml
index c29fbfb..11e51cc 100644
--- a/gc-shop/src/main/resources/mapper/shop/JhyOrderMapper.xml
+++ b/gc-shop/src/main/resources/mapper/shop/JhyOrderMapper.xml
@@ -19,7 +19,7 @@
         FROM
         xzx_jhy_order a
         left join xzx_user_info b on b.user_id = a.user_id
-        left join xzx_jhy_info d on d.id = a.jhy_id
+        left join xzx_jhy_info d on d.user_id = a.jhy_id
         WHERE 1 = 1
         <if test="record.orderNo != null and record.orderNo != ''">
             and a.order_no like concat('%',#{record.orderNo},'%')
@@ -64,7 +64,7 @@
         FROM
         xzx_jhy_order a
         left join xzx_user_info b on b.user_id = a.user_id
-        left join xzx_jhy_info d on d.id = a.jhy_id
+        left join xzx_jhy_info d on d.user_id = a.jhy_id
         WHERE a.id=#{id}
     </select>
 

--
Gitblit v1.9.1