| | |
| | | BigDecimal selectTotalAmountByCreateTimeAndOrderId(@Param("startTime")Date startTime, @Param("endTime")Date endTime, @Param("orderId")Long id); |
| | | |
| | | Long selectByIsgoalAndOrderId(@Param("isGoal")int i, @Param("orderId")Long orderId); |
| | | |
| | | IgtOnHookPlanOrderItem selectByCreateTimeAndIsgoaAndOrderId(@Param("endTime")Date endTime, @Param("isGoal")int i, @Param("orderId")Long orderId); |
| | | } |
| | |
| | | @Override |
| | | public Integer isGoal(String num) { |
| | | Set set = new HashSet(); |
| | | num = StrUtil.subSuf(num,1); |
| | | char[] chars = num.toCharArray(); |
| | | for(char c:chars) { |
| | | set.add(c); |
| | |
| | | } |
| | | } |
| | | |
| | | public static void main(String[] args) { |
| | | |
| | | String num = StrUtil.subSuf("01234",1); |
| | | System.out.print(num); |
| | | } |
| | | |
| | | private String isIdentity(List<String> refererIds,String levelCode){ |
| | | String flag = levelCode; |
| | | for(String str : refererIds){ |
| | |
| | | igtOnHookPlanOrderItemDao.insert(igtOnHookPlanOrderItem); |
| | | |
| | | if(2 == igtOnHookPlanOrderItem.getIsGoal()){ |
| | | |
| | | //返还两次中奖之间的本金 |
| | | Date startTime = igtOnHookPlanOrderItemsOld.get(0).getCreateTime(); |
| | | Date endTime = igtOnHookPlanOrderItem.getCreateTime(); |
| | | Date startTime = null; |
| | | //返回上次中奖的记录 |
| | | IgtOnHookPlanOrderItem igtOld = igtOnHookPlanOrderItemDao.selectByCreateTimeAndIsgoaAndOrderId(endTime,1,igtOnHookPlanOrder.getId()); |
| | | if(ObjectUtil.isNotEmpty(igtOld)){ |
| | | startTime = igtOld.getCreateTime(); |
| | | } |
| | | BigDecimal totalAmount = igtOnHookPlanOrderItemDao.selectTotalAmountByCreateTimeAndOrderId(startTime,endTime,igtOnHookPlanOrder.getId()); |
| | | //如果中奖,增加挂机主表的挂机总收益,返还两次中奖之间的本金 |
| | | igtOnHookPlanOrderDao.AddProfitById(igtOnHookPlanOrder.getId() |
| | | ,igtOnHookPlanOrderItem.getProfit()); |
| | | igtOnHookPlanOrderDao.addAvaAmountById(igtOnHookPlanOrder.getId() |
| | | ,totalAmount); |
| | | }else{ |
| | |
| | | SELECT |
| | | ifnull(sum(a.amount),0) |
| | | FROM igt_on_hook_plan_order_item a |
| | | where a.order_id = #{orderId} |
| | | and a.create_time > #{startTime} |
| | | and a.create_time < #{endTime} |
| | | <where> |
| | | a.order_id = #{orderId} |
| | | and a.create_time < #{endTime} |
| | | <if test="startTime != null"> |
| | | and a.create_time > #{startTime} |
| | | </if> |
| | | </where> |
| | | order by create_time desc |
| | | </select> |
| | | |
| | |
| | | order by create_time desc |
| | | </select> |
| | | |
| | | <select id="selectByCreateTimeAndIsgoaAndOrderId" resultType="cc.mrbird.febs.dapp.entity.IgtOnHookPlanOrderItem"> |
| | | SELECT |
| | | a.* |
| | | FROM igt_on_hook_plan_order_item a |
| | | where a.order_id = #{orderId} |
| | | and a.is_goal = #{isGoal} |
| | | and a.create_time < #{endTime} |
| | | order by create_time desc |
| | | limit 1 |
| | | </select> |
| | | |
| | | |
| | | </mapper> |
| | |
| | | igtOnHookPlanOrderItemDao.insert(igtOnHookPlanOrderItem); |
| | | |
| | | if(2 == igtOnHookPlanOrderItem.getIsGoal()){ |
| | | |
| | | //返还两次中奖之间的本金 |
| | | Date startTime = igtOnHookPlanOrderItemsOld.get(0).getCreateTime(); |
| | | Date endTime = igtOnHookPlanOrderItem.getCreateTime(); |
| | | Date startTime = null; |
| | | //返回上次中奖的记录 |
| | | IgtOnHookPlanOrderItem igtOld = igtOnHookPlanOrderItemDao.selectByCreateTimeAndIsgoaAndOrderId(endTime,1,igtOnHookPlanOrder.getId()); |
| | | if(ObjectUtil.isNotEmpty(igtOld)){ |
| | | startTime = igtOld.getCreateTime(); |
| | | } |
| | | BigDecimal totalAmount = igtOnHookPlanOrderItemDao.selectTotalAmountByCreateTimeAndOrderId(startTime,endTime,igtOnHookPlanOrder.getId()); |
| | | //如果中奖,增加挂机主表的挂机总收益,返还两次中奖之间的本金 |
| | | igtOnHookPlanOrderDao.AddProfitById(igtOnHookPlanOrder.getId() |