parent: f54f8a92 | patch | commit | ignore whitespace
Helius
2022-02-28 25fb65540710ad0c90cbb0333cacbddef11b3f2b 
fix 40 to 50
2 files modified
4 ■■■■■ changed files
gc-core/src/main/java/com/xzx/gc/common/constant/Constants.java 2 ●●●●● patch | view | raw | blame | history
gc-user/src/main/resources/mapper/user/AccountMapper.xml 2 ●●●●● patch | view | raw | blame | history 
 gc-core/src/main/java/com/xzx/gc/common/constant/Constants.java


@@ -221,6 +221,6 @@


    public static final String ADDRESS_TYPE_SHOP = "商铺";



    public static final String ADDRESS_TYPE_HOME = "住宅";







    public static final Integer PRICE_SCORE_EXCHANGE = 40;



    public static final Integer PRICE_SCORE_EXCHANGE = 50;







}





 gc-user/src/main/resources/mapper/user/AccountMapper.xml


@@ -255,7 +255,7 @@


            c.nick_name nickname,


            c.mobile_phone phone,


            (select sum(score) from xzx_jhy_order_items where b.id = order_id) score,


            (select sum(score/ 40) from xzx_jhy_order_items where b.id = order_id) amount


            (select sum(score/ 50) from xzx_jhy_order_items where b.id = order_id) amount


        FROM


            xzx_user_head_details a


                LEFT JOIN xzx_jhy_order b ON a.order_no = b.order_no