parent: 512a2f0f | patch | commit | ignore whitespace
li-guang
2021-04-07 e2445003ce60e60b338cbf6ce837b60c2ee9adef 
修改头像
1 files modified
1 ■■■■■ changed files
zq-erp/src/main/resources/mybatis/mapper/hive/AchieveNewDao.xml 1 ●●●●● patch | view | raw | blame | history 
 zq-erp/src/main/resources/mybatis/mapper/hive/AchieveNewDao.xml


@@ -977,6 +977,7 @@


        select


            b.su_name name,


            b.su_id id,


            b.SHOP_IMAG photo,


            sum(IFNULL(a.free_consume,0) + IFNULL(a.his_consume, 0) ) amount,


            c.shop_short_name shopName


        from achieve_new a