Subversion Repositories SmartDukaan

Rev

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

Rev 14771 Rev 15731
Line 25... Line 25...
25 
def getDbConnection():
 25 
def getDbConnection():
26 
    return MySQLdb.connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
 26 
    return MySQLdb.connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
27 
 
 27 
 
28 
 
 28 
 
29 
ORDERS_QUERY='''
 29 
ORDERS_QUERY='''
30 
select o.*, u.username from order_view o join users u on u.id=o.user_id where %s order by id desc limit %s offset %s
 30 
select o.*, u.username from order_view o join users u on u.id=o.user_id %s order by id desc limit %s offset %s
31 
'''
 31 
'''
32 
ORDERS_DATE_QUERY = '''
 32 
ORDERS_DATE_QUERY = '''
33 
select o.*, dev.imeinumber, dev.versioncode, u.username from order_view o left join (
 33 
select o.*, dev.imeinumber, dev.versioncode, u.username from order_view o left join (
34 
select * from (select ov.id as oid, ov.created ocreated, d.* from order_view ov left join devices d on (ov.user_id= d.user_id)
34 
select * from (select ov.id as oid, ov.created ocreated, d.* from order_view ov left join devices d on (ov.user_id= d.user_id)
35 
group by ov.id, d.id having ov.created-d.created>=0 order by ov.created-d.created) dev group by dev.oid
 35 
group by ov.id, d.id having ov.created-d.created>=0 order by ov.created-d.created) dev group by dev.oid
Line 38... Line 38...
38 
ORDERS_DATE_QUERY1 = '''
 38 
ORDERS_DATE_QUERY1 = '''
39 
select * from orders where created > %s and store_id = %s
39 
select * from orders where created > %s and store_id = %s
40 
'''
 40 
'''
41 
 
 41 
 
42 
ORDERS_COUNT_QUERY='''
 42 
ORDERS_COUNT_QUERY='''
43 
select count(*) from order_view o join users u on u.id=o.user_id where %s
43 
select count(*) from order_view o join users u on u.id=o.user_id %s
44 
'''
 44 
'''
45 
 
 45 
 
46 
ORDER_HTML_QUERY = '''
 46 
ORDER_HTML_QUERY = '''
47 
select rawhtml from orders where id = %s
 47 
select rawhtml from orders where id = %s
48 
'''
 48 
'''
49 
 
 49 
 
50 
 
 50 
 
51 
 
 51 
 
52 
 
 52 
 
53 
def getOrders(page=1, window=50, status=None, user=None):
 53 
def getOrders(page=1, window=50, status=None, user=None, source=None):
54 
    try:
 54 
    try:
55 
        search = "1=1"
 55 
        search = []
56 
        if status is not None:
 56 
        if status is not None:
57 
            search="o.status='%s'"%(status)
 57 
            search.append("o.status='%s'"%(status))
58 
        if user is not  None:
 58 
        if user is not  None:
59 
            search = "o.user_id=%s"%(user)
 59 
            search.append("o.user_id=%s"%(user))
- 
 
 60 
        if source is not  None:
- 
 
 61 
            search.append("o.store_id=%s"%(source))
- 
 
 62 
        if len(search) > 0:
- 
 
 63 
            search = " where " +  " and ".join(search)
- 
 
 64 
        else:
- 
 
 65 
            search = " "
60 
        conn = getDbConnection()
 66 
        conn = getDbConnection()
61 
        if page==None:
 67 
        if page==None:
62 
            page = 1
 68 
            page = 1
63 
        if window==None:
 69 
        if window==None:
64 
            window = 50
 70 
            window = 50