Subversion Repositories SmartDukaan

Rev

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

Rev 14526 Rev 14578
Line 94... Line 94...
94 
def getOrdersAfterDate(afterDate, storeId):
 94 
def getOrdersAfterDate(afterDate, storeId):
95 
    try:
 95 
    try:
96 
        conn = getDbConnection()
 96 
        conn = getDbConnection()
97 
        cursor = conn.cursor()
 97 
        cursor = conn.cursor()
98 
        afterDate = datetime.strftime(afterDate,"\'%Y-%m-%d\'")
 98 
        afterDate = datetime.strftime(afterDate,"\'%Y-%m-%d\'")
99 
        beforeDate = datetime.strftime(datetime.now(),"\'%Y-%m-%d\'")
 99 
        beforeDate = datetime.strftime(datetime.now(),"\'%Y-%m-%d %H\'")
100 
        cursor.execute(ORDERS_DATE_QUERY%(afterDate, beforeDate, storeId))
 100 
        cursor.execute(ORDERS_DATE_QUERY%(afterDate, beforeDate, storeId))
101 
        result = cursor.fetchall()
 101 
        result = cursor.fetchall()
102 
        return result
 102 
        return result
103 
    finally:
 103 
    finally:
104 
        conn.close()
104 
        conn.close()