| Line 3628... |
Line 3628... |
| 3628 |
tra = session.query(func.sum(RechargeOrder.totalAmount)).filter(RechargeOrder.status == RechargeOrderStatus.RECHARGE_SUCCESSFUL).one()
|
3628 |
tra = session.query(func.sum(RechargeOrder.totalAmount)).filter(RechargeOrder.status == RechargeOrderStatus.RECHARGE_SUCCESSFUL).one()
|
| 3629 |
gwa = session.query(func.sum(UserWalletHistory.amount)).filter(UserWalletHistory.orderId > 100000).one()
|
3629 |
gwa = session.query(func.sum(UserWalletHistory.amount)).filter(UserWalletHistory.orderId > 100000).one()
|
| 3630 |
#tpa = session.query(func.sum(UserWalletHistory.amount)).filter(UserWalletHistory.orderId < 100000).one()
|
3630 |
#tpa = session.query(func.sum(UserWalletHistory.amount)).filter(UserWalletHistory.orderId < 100000).one()
|
| 3631 |
tpa = session.query(func.sum(RechargeOrder.totalAmount-RechargeOrder.walletAmount)).filter(RechargeOrder.status.in_((RechargeOrderStatus.RECHARGE_SUCCESSFUL, RechargeOrderStatus.RECHARGE_FAILED, RechargeOrderStatus.PAYMENT_SUCCESSFUL, RechargeOrderStatus.RECHARGE_FAILED_REFUNDED))).one()
|
3631 |
tpa = session.query(func.sum(RechargeOrder.totalAmount-RechargeOrder.walletAmount)).filter(RechargeOrder.status.in_((RechargeOrderStatus.RECHARGE_SUCCESSFUL, RechargeOrderStatus.RECHARGE_FAILED, RechargeOrderStatus.PAYMENT_SUCCESSFUL, RechargeOrderStatus.RECHARGE_FAILED_REFUNDED))).one()
|
| 3632 |
|
3632 |
|
| 3633 |
balance = Decimal(RechargeService.getBalance())
|
3633 |
balance = RechargeService.getBalance()
|
| 3634 |
amounts['(a) Total Payment Amount'] = tpa[0]
|
3634 |
amounts['(a) Total Payment Amount'] = tpa[0]
|
| 3635 |
amounts['(b) Gift Wallet Amount'] = gwa[0]
|
3635 |
amounts['(b) Gift Wallet Amount'] = gwa[0]
|
| 3636 |
amounts['(c) Total Wallet Amount'] = twa[0]
|
3636 |
amounts['(c) Total Wallet Amount'] = twa[0]
|
| 3637 |
amounts['(d) Total Recharge Amount'] = tra[0]
|
3637 |
amounts['(d) Total Recharge Amount'] = tra[0]
|
| 3638 |
amounts['(e) Account Balance'] = balance
|
3638 |
amounts['(e) Account Balance'] = balance
|