| | |
| | | |
| | | /** |
| | | * 添加积分 |
| | | * @param memberId |
| | | * @param shopId |
| | | * @param integral |
| | | */ |
| | | @Select(" update shop set INTEGRAL = ifNull( INTEGRAL,0) + #{integral} , TOTAL_INTEGRAL = ifNull(TOTAL_INTEGRAL,0) + #{titleIntegral} , EDIT_DATE = now() where id = #{shopId} ") |
| | |
| | | |
| | | /** |
| | | * 减少积分 |
| | | * @param memberId |
| | | * @param shopId |
| | | * @param integral |
| | | */ |
| | | @Select(" update shop set INTEGRAL = ifNull( INTEGRAL,0) - #{integral} , EDIT_DATE = now() where id = #{shopId} ") |
| | | void subtractIntegral(@Param("shopId") Integer shopId , @Param("integral")BigDecimal integral); |
| | | |
| | | |
| | | /** |
| | | * 添加余额 |
| | | * @param shopId |
| | | * @param amount |
| | | */ |
| | | @Select(" update shop set AMOUNT = ifNull(AMOUNT,0) + #{amount} , TOTAL_AMOUNT = ifNull(TOTAL_AMOUNT,0) + #{titleAmount} , EDIT_DATE = now() where id = #{shopId} ") |
| | | void addAmount(@Param("shopId") Integer shopId , @Param("amount") BigDecimal amount , @Param("titleAmount")BigDecimal titleAmount); |
| | | |
| | | /** |
| | | * 减少余额 |
| | | * @param shopId |
| | | * @param amount |
| | | */ |
| | | @Select(" update shop set AMOUNT = ifNull( AMOUNT,0) - #{amount} , EDIT_DATE = now() where id = #{shopId} ") |
| | | void subtractAmount(@Param("shopId") Integer shopId , @Param("amount")BigDecimal amount); |
| | | |
| | | } |