From fa5dd2c847c39a52ea89b07bbb28bd5a9f75c220 Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Fri, 16 Jul 2021 14:56:46 +0800 Subject: [PATCH] 202107016 --- gc-user/src/main/resources/mapper/user/AccountMapper.xml | 7 ++++--- 1 files changed, 4 insertions(+), 3 deletions(-) diff --git a/gc-user/src/main/resources/mapper/user/AccountMapper.xml b/gc-user/src/main/resources/mapper/user/AccountMapper.xml index 1621a96..ef1568b 100644 --- a/gc-user/src/main/resources/mapper/user/AccountMapper.xml +++ b/gc-user/src/main/resources/mapper/user/AccountMapper.xml @@ -305,11 +305,12 @@ <select id="selectOrderByHeadUserId" resultType="java.lang.String"> SELECT - IFNULL(SUM(weight),0) as kg + IFNULL(SUM(a.weight),0) as kg FROM - xzx_jhy_order_items + xzx_jhy_order_items a + left join xzx_sys_environmental_info b on a.item_type = b.id WHERE - order_id in ( + b.item_unit = 'kg' and a.order_id in ( SELECT id FROM -- Gitblit v1.9.1