jyy
2021-03-12 4a3777f7aca51a51755c2d8db2191f3cf174db7a
新增申请成为分销员接口8
1 files modified
2 ■■■■■ changed files
zq-erp/src/main/resources/mybatis/mapper/fenxiao/ShopSalesmanApplyDao.xml 2 ●●●●● patch | view | raw | blame | history
zq-erp/src/main/resources/mybatis/mapper/fenxiao/ShopSalesmanApplyDao.xml
@@ -46,7 +46,9 @@
                    shop_salesman_order b
                WHERE
                    b.user_id = a.open_id
                  and order_status=1
                  AND b.sales_user_id = #{openId}
            ) AS revenueAmount,
            ( SELECT count( * ) FROM shop_salesman_order c WHERE c.user_id = a.open_id AND c.sales_user_id = #{openId} ) AS orderCount
        FROM