Subversion Repositories SmartDukaan

Rev

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

Rev 14726 Rev 14727
Line 22... Line 22...
22 
        self.amount = amount
 22 
        self.amount = amount
23 
 
 23 
 
24 
def getHighVolumeTransactions():
 24 
def getHighVolumeTransactions():
25 
    global user_list
 25 
    global user_list
26 
    d = datetime.now()
 26 
    d = datetime.now()
27 
    d = d + timedelta(days = -2)
 27 
    d = d + timedelta(days = -1)
28 
    todate = datetime(d.year, d.month, d.day)
 28 
    todate = datetime(d.year, d.month, d.day)
29 
    tomorrow = todate + timedelta(days=1)
 29 
    tomorrow = todate + timedelta(days=1)
30
30
31 
    all_users= session.query(func.sum(RechargeOrder.totalAmount),RechargeOrder.userId, RechargeOrder.userEmailId).filter(RechargeOrder.creationTimestamp.between(todate, tomorrow)).filter(RechargeOrder.status == RechargeOrderStatus.RECHARGE_SUCCESSFUL).group_by(RechargeOrder.userId)
 31 
    all_users= session.query(func.sum(RechargeOrder.totalAmount),RechargeOrder.userId, RechargeOrder.userEmailId).filter(RechargeOrder.creationTimestamp.between(todate, tomorrow)).filter(RechargeOrder.status == RechargeOrderStatus.RECHARGE_SUCCESSFUL).group_by(RechargeOrder.userId)
32 
    for all_user in all_users:
 32 
    for all_user in all_users: