Subversion Repositories SmartDukaan

Rev

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

Rev 17052 Rev 17084
Line 35... Line 35...
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 = '''
 39 
ORDERS_DATE_QUERY_ONE = '''
40 
select * from order_view where o.created between '%s' and '%s' and store_id = %s
 40 
select * from order_view where created between '%s' and '%s' and store_id = %s
41 
'''
 41 
'''
42 
 
 42 
 
43 
ORDERS_DATE_QUERY1 = '''
 43 
ORDERS_DATE_QUERY1 = '''
44 
select * from orders where created > %s and store_id = %s
44 
select * from orders where created > %s and store_id = %s
45 
'''
 45 
'''