fix

Helius

2022-05-27 05a82deffa89a22fa35abaa9196053f43cbc1103

fix

 zq-erp/src/main/java/com/matrix/system/hive/dao/MoneyCardUseFlowDao.java

@@ -35,5 +35,7 @@
    public MoneyCardUseFlow  selectById(Long id);

    int updateVipCardId(@Param("vipId") Long vipId, @Param("cardId") Long cardId);

    double selectCardUseAmount(Long cardId);
    
}

 zq-erp/src/main/resources/mybatis/mapper/hive/MoneyCardUseFlowDao.xml

@@ -366,6 +366,12 @@
            set car_use_id=#{cardId}
        where vip_id=#{vipId} and type='会员充值'
    </update>

    <select id="selectCardUseAmount" resultType="java.lang.Double">
        select IFNULL(ABS(sum(IFNULL(total, 0))), 0)
        from money_card_use_flow
        where car_use_id=#{cardId} and type='消费扣款'
    </select>
</mapper>