parent: 886265d9 | patch | commit | ignore whitespace
xiaoyong931011
2021-07-16 fa5dd2c847c39a52ea89b07bbb28bd5a9f75c220 
202107016
1 files modified
7 ■■■■■ changed files
gc-user/src/main/resources/mapper/user/AccountMapper.xml 7 ●●●●● patch | view | raw | blame | history 
 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