| | |
| | | igtOnHookPlanOrderItem.setState(1); |
| | | igtOnHookPlanOrderItemDao.updateById(igtOnHookPlanOrderItem); |
| | | if(BigDecimal.ZERO.compareTo(igtOnHookPlanOrderItem.getProfit()) < 0){ |
| | | //增加挂机主表的挂机总收益和增加挂机剩余金额 |
| | | Integer updateCount = igtOnHookPlanOrderDao.addAvaAmountAddProfitById(igtOnHookPlanOrder.getId() |
| | | ,igtOnHookPlanOrderItem.getProfit() |
| | | ,igtOnHookPlanOrderItem.getAmount()); |
| | | }else{ |
| | | //增加挂机主表的挂机总收益和减少挂机剩余金额 |
| | | Integer updateCount = igtOnHookPlanOrderDao.updateAvaAmountById(igtOnHookPlanOrder.getId() |
| | | ,igtOnHookPlanOrderItem.getProfit() |
| | |
| | | <update id="addAvaAmountAddProfitById"> |
| | | update igt_on_hook_plan_order |
| | | set |
| | | ava_amount = ava_amount + #{amount}, |
| | | ava_amount = ava_amount - #{amount}, |
| | | profit = profit + #{profit} |
| | | where |
| | | id = #{id} |
| | | and ava_amount - #{amount} <![CDATA[ >= ]]> 0 |
| | | </update> |
| | | |
| | | <select id="selectSumProfitByMemberId" resultType="java.math.BigDecimal"> |