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

 import datetime
 import time
 from elixir import *
 from shop2020.utils.Utils import to_py_date, to_java_date
 from sqlalchemy.sql.expression import and_, or_
+from sqlalchemy.sql import func
 from shop2020.model.v1 import order
 from shop2020.clients.LogisticsClient import LogisticsClient
 from shop2020.clients.InventoryClient import InventoryClient
 from shop2020.clients.UserClient import UserClient
 from shop2020.clients.HelperClient import HelperClient
     session.commit()
 def get_valid_order_count():
     return Order.query.filter(Order.status >= OrderStatus.SUBMITTED_FOR_PROCESSING).count()
+def get_cust_count_with_successful_txn():
+    return session.query(Order.customer_id).filter(Order.status >= OrderStatus.SUBMITTED_FOR_PROCESSING).distinct().count()
+def get_max_valid_order_amount():
+    orders = Order.query.filter(Order.status >= OrderStatus.SUBMITTED_FOR_PROCESSING).all()
+    order_amounts = [o.total_amount for o in orders]
+    return max(order_amounts)
+def get_min_valid_order_amount():
+    orders = Order.query.filter(Order.status >= OrderStatus.SUBMITTED_FOR_PROCESSING).all()
+    order_amounts = [o.total_amount for o in orders]
+    return min(order_amounts)
 def close_session():
     if session.is_active:
         print "session is active. closing it."
         session.close()

Subversion Repositories SmartDukaan