Subversion Repositories SmartDukaan

Rev

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

Rev 14440 Rev 14451
Line 2... Line 2...
2 
Created on Mar 11, 2015
 2 
Created on Mar 11, 2015
3 
 
 3 
 
4 
@author: amit
 4 
@author: amit
5 
'''
 5 
'''
6 
 
 6 
 
7 
from datetime import date
 7 
from datetime import date, datetime, timedelta
8 
from email import encoders
 8 
from email import encoders
9 
from email.mime.base import MIMEBase
 9 
from email.mime.base import MIMEBase
10 
from email.mime.multipart import MIMEMultipart
 10 
from email.mime.multipart import MIMEMultipart
11 
from email.mime.text import MIMEText
 11 
from email.mime.text import MIMEText
12 
import MySQLdb
 12 
import MySQLdb
13 
import datetime
 - 
 
14 
import smtplib
 13 
import smtplib
15 
import traceback
 14 
import traceback
16 
import xlwt
 15 
import xlwt
17 
 
 16 
 
18 
 
 17 
 
Line 28... Line 27...
28 
 
 27 
 
29 
 
 28 
 
30 
ORDERS_QUERY='''
 29 
ORDERS_QUERY='''
31 
select * from order_view order by id desc limit %s offset %s
 30 
select * from order_view order by id desc limit %s offset %s
32 
'''
 31 
'''
- 
 
 32 
ORDERS_DATE_QUERY = '''
- 
 
 33 
select * from order_view where created > %s and store_id = %s
- 
 
 34 
'''
33 
 
 35 
 
34 
ORDERS_COUNT_QUERY='''
 36 
ORDERS_COUNT_QUERY='''
35 
select count(*) from order_view
 37 
select count(*) from order_view
36 
'''
 38 
'''
37 
 
 39 
 
Line 84... Line 86...
84 
    except:
 86 
    except:
85 
        traceback.print_exc()
 87 
        traceback.print_exc()
86 
    finally:
 88 
    finally:
87 
        conn.close()
 89 
        conn.close()
88 
 
 90 
 
- 
 
 91 
def getOrdersAfterDate(afterDate, storeId):
- 
 
 92 
    conn = getDbConnection()
- 
 
 93 
    cursor = conn.cursor()
- 
 
 94 
    afterDate = datetime.strftime(afterDate,"\'%Y-%m-%d\'")
- 
 
 95 
    cursor.execute(ORDERS_DATE_QUERY%(afterDate, storeId))
- 
 
 96 
    result = cursor.fetchall()
- 
 
 97 
    return result
- 
 
 98 
 
89 
def main():
 99 
def main():
90 
    print getOrders()
 100 
    getOrdersAfterDate(datetime.now() - timedelta(days=10), 3)
91 
 
 101 
 
92 
 
 102 
 
93 
if __name__ == '__main__':
 103 
if __name__ == '__main__':
94 
    main()
 104 
    main()
95 

            105