Subversion Repositories SmartDukaan

Rev

Rev 6289 | Rev 6305 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6289 Rev 6295
Line 3608... Line 3608...
3608
    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()
3608
    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()
3609
    amounts['Total Wallet Amount'] = twa[0]
3609
    amounts['Total Wallet Amount'] = twa[0]
3610
    amounts['Total Recharge Amount'] = tra[0]
3610
    amounts['Total Recharge Amount'] = tra[0]
3611
    amounts['Gift Wallet Amount'] = gwa[0]
3611
    amounts['Gift Wallet Amount'] = gwa[0]
3612
    #amounts['Total Payment Amount'] = tra[0] + twa[0] - gwa[0]
3612
    #amounts['Total Payment Amount'] = tra[0] + twa[0] - gwa[0]
3613
    amounts['Total Payment Amount'] = tpa
3613
    amounts['Total Payment Amount'] = tpa[0]
-
 
3614
    amounts['Mismatch'] = tpa[0] + gwa[0] - tra[0] - twa[0] 
3614
    
3615
    
3615
    rs.statusCounts = statusCounts
3616
    rs.statusCounts = statusCounts
3616
    rs.operatorCounts = operatorCounts    
3617
    rs.operatorCounts = operatorCounts    
3617
    rs.currentOrders = currentOrders
3618
    rs.currentOrders = currentOrders
3618
    rs.amounts = amounts
3619
    rs.amounts = amounts