| Line 33... |
Line 33... |
| 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
|
| 36 |
) dev on dev.oid = o.id join users u on u.id=o.user_id where o.created between '%s' and '%s' and store_id = %s group by o.id
|
36 |
) dev on dev.oid = o.id join users u on u.id=o.user_id where o.created between '%s' and '%s' and store_id = %s group by o.id
|
| 37 |
'''
|
37 |
'''
|
| - |
|
38 |
|
| - |
|
39 |
ORDERS_DATE_QUERY_ONE = '''
|
| - |
|
40 |
select * from order_view where o.created between '%s' and '%s' and store_id = %s
|
| - |
|
41 |
'''
|
| - |
|
42 |
|
| 38 |
ORDERS_DATE_QUERY1 = '''
|
43 |
ORDERS_DATE_QUERY1 = '''
|
| 39 |
select * from orders where created > %s and store_id = %s
|
44 |
select * from orders where created > %s and store_id = %s
|
| 40 |
'''
|
45 |
'''
|
| 41 |
|
46 |
|
| 42 |
ORDERS_COUNT_QUERY='''
|
47 |
ORDERS_COUNT_QUERY='''
|
| Line 111... |
Line 116... |
| 111 |
try:
|
116 |
try:
|
| 112 |
conn = getDbConnection()
|
117 |
conn = getDbConnection()
|
| 113 |
cursor = conn.cursor()
|
118 |
cursor = conn.cursor()
|
| 114 |
afterDate = datetime.strftime(afterDate,"%Y-%m-%d")
|
119 |
afterDate = datetime.strftime(afterDate,"%Y-%m-%d")
|
| 115 |
beforeDate = datetime.strftime(datetime.now(),"%Y-%m-%d %H")
|
120 |
beforeDate = datetime.strftime(datetime.now(),"%Y-%m-%d %H")
|
| 116 |
cursor.execute(ORDERS_DATE_QUERY%(afterDate, beforeDate, storeId))
|
121 |
cursor.execute(ORDERS_DATE_QUERY_ONE%(afterDate, beforeDate, storeId))
|
| 117 |
result = cursor.fetchall()
|
122 |
result = cursor.fetchall()
|
| 118 |
return result
|
123 |
return result
|
| 119 |
finally:
|
124 |
finally:
|
| 120 |
conn.close()
|
125 |
conn.close()
|
| 121 |
|
126 |
|