| Line 3669... |
Line 3669... |
| 3669 |
|
3669 |
|
| 3670 |
twa = session.query(func.sum(UserWallet.amount)).one()
|
3670 |
twa = session.query(func.sum(UserWallet.amount)).one()
|
| 3671 |
tra = session.query(func.sum(RechargeOrder.totalAmount)).filter(RechargeOrder.status == RechargeOrderStatus.RECHARGE_SUCCESSFUL).one()
|
3671 |
tra = session.query(func.sum(RechargeOrder.totalAmount)).filter(RechargeOrder.status == RechargeOrderStatus.RECHARGE_SUCCESSFUL).one()
|
| 3672 |
gwa = session.query(func.sum(UserWalletHistory.amount)).filter(UserWalletHistory.orderId > 100000).one()
|
3672 |
gwa = session.query(func.sum(UserWalletHistory.amount)).filter(UserWalletHistory.orderId > 100000).one()
|
| 3673 |
#tpa = session.query(func.sum(UserWalletHistory.amount)).filter(UserWalletHistory.orderId < 100000).one()
|
3673 |
#tpa = session.query(func.sum(UserWalletHistory.amount)).filter(UserWalletHistory.orderId < 100000).one()
|
| 3674 |
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()
|
3674 |
tpa = session.query(func.sum(RechargeOrder.totalAmount-RechargeOrder.walletAmount-RechargeOrder.couponAmount)).filter(RechargeOrder.status.in_((RechargeOrderStatus.RECHARGE_SUCCESSFUL, RechargeOrderStatus.RECHARGE_FAILED, RechargeOrderStatus.PAYMENT_SUCCESSFUL, RechargeOrderStatus.RECHARGE_FAILED_REFUNDED))).one()
|
| - |
|
3675 |
tda = session.query(func.sum(RechargeOrder.couponAmount)).filter(RechargeOrder.status == RechargeOrderStatus.RECHARGE_SUCCESSFUL).one()
|
| 3675 |
|
3676 |
|
| 3676 |
balance = RechargeService.getBalance()
|
3677 |
balance = RechargeService.getBalance()
|
| 3677 |
amounts['(a) Total Payment Amount'] = tpa[0]
|
3678 |
amounts['(a) Total Payment Amount'] = tpa[0]
|
| 3678 |
amounts['(b) Gift Wallet Amount'] = gwa[0]
|
3679 |
amounts['(b) Gift Wallet Amount'] = gwa[0]
|
| 3679 |
amounts['(c) Total Wallet Amount'] = twa[0]
|
3680 |
amounts['(c) Total Wallet Amount'] = twa[0]
|
| 3680 |
amounts['(d) Total Recharge Amount'] = tra[0]
|
3681 |
amounts['(d) Total Recharge Amount'] = tra[0]
|
| 3681 |
amounts['(e) Account Balance'] = balance
|
3682 |
amounts['(e) Account Balance'] = balance
|
| - |
|
3683 |
amounts['(f) Discount Balance'] = tda[0]
|
| 3682 |
#amounts['Total Payment Amount'] = tra[0] + twa[0] - gwa[0]
|
3684 |
#amounts['Total Payment Amount'] = tra[0] + twa[0] - gwa[0]
|
| 3683 |
amounts['Saholic Mismatch = (a+b-c-d)'] = tpa[0] + gwa[0] - tra[0] - twa[0]
|
3685 |
amounts['Saholic Mismatch = (a+b+f-c-d)'] = tpa[0] + gwa[0] + tda[0] - tra[0] - (twa[0] + 53775)
|
| 3684 |
amounts['SpiceDeck Mismatch = (d-e)'] = tra[0] + balance - 100000
|
3686 |
amounts['SpiceDeck Mismatch = (d-e)'] = tra[0] + balance - 550000
|
| 3685 |
|
3687 |
|
| 3686 |
'''
|
3688 |
'''
|
| 3687 |
if amounts['SpiceDeck Mismatch = (d-e)'] != -739:
|
3689 |
if amounts['SpiceDeck Mismatch = (d-e)'] != -739:
|
| 3688 |
mail(mail_user, mail_password, ['rajneesh.arora@shop2020.in', 'rajveer.singh@shop2020.in', 'anupam.singh@shop2020.in'], "SpiceDeck Account mismatch of amount " + str(amounts['SpiceDeck Mismatch = (d-e)']), "", [], [], [])
|
3690 |
mail(mail_user, mail_password, ['rajneesh.arora@shop2020.in', 'rajveer.singh@shop2020.in', 'anupam.singh@shop2020.in'], "SpiceDeck Account mismatch of amount " + str(amounts['SpiceDeck Mismatch = (d-e)']), "", [], [], [])
|
| 3689 |
if amounts['Saholic Mismatch = (a+b-c-d)'] != -1919:
|
3691 |
if amounts['Saholic Mismatch = (a+b-c-d)'] != -1919:
|