| Line 28... |
Line 28... |
| 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 where %s order by id desc limit %s offset %s
|
| 31 |
'''
|
31 |
'''
|
| 32 |
ORDERS_DATE_QUERY = '''
|
32 |
ORDERS_DATE_QUERY = '''
|
| 33 |
select o.*, max(d.versioncode), u.username from order_view o join users u on u.id=o.user_id left
|
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)
|
| - |
|
35 |
group by ov.id, d.id having ov.created-d.created>=0 order by ov.created-d.created) dev group by dev.oid
|
| 34 |
join devices d on (d.user_id=o.user_id and o.created >= d.created) 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
|
| 35 |
'''
|
37 |
'''
|
| 36 |
ORDERS_DATE_QUERY1 = '''
|
38 |
ORDERS_DATE_QUERY1 = '''
|
| 37 |
select * from orders where created > %s and store_id = %s
|
39 |
select * from orders where created > %s and store_id = %s
|
| 38 |
'''
|
40 |
'''
|
| 39 |
|
41 |
|