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