WebSVN – SmartDukaan – Diff – /trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py

             helperClient.saveUserEmailForSending(order.customer_email, None, emailSubject, emailBody, '', 'ShippingConfirmation')
         except Exception as e:
             print e
 def get_order_distribution_by_status(start_date, end_date):
-    distribution = session.query(Order.status, func.count(Order.id)).group_by(Order.status).all()
+    query = session.query(Order.status, func.count(Order.id)).group_by(Order.status)
+    query = query.filter(Order.created_timestamp >= start_date)
+    query = query.filter(Order.created_timestamp <= end_date)
-    print distribution
+    return query.all()
+def get_order_ids_for_status(status, start_datetime, end_datetime):
+    query = Order.query.filter(Order.status == status)
+    query = query.filter(Order.created_timestamp >= start_datetime)
+    query = query.filter(Order.created_timestamp <= end_datetime)
-    return {}
+    return query.all()
 def close_session():
     if session.is_active:
         print "session is active. closing it."
         session.close()

Subversion Repositories SmartDukaan