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

     summary = EBSSettlementSummary.get_by(settlementId = settlement_id)
     if summary:
         summary.detailsUploaded = True
         session.commit()
+def get_settlements_by_date(settlement_date_from, settlement_date_to, is_refund):
+    query = PaymentSettlement.query
+    if settlement_date_from:
+        query = query.filter(PaymentSettlement.settlementDate >= settlement_date_from)
+    if settlement_date_to:
+        query = query.filter(PaymentSettlement.settlementDate <= settlement_date_to)
+    settlements = query.all()
+    if is_refund:
+        return [settlement for settlement in settlements if settlement.netCollection < 0.0]
+    return settlements
+def get_reshipped_order_ids(order_ids):
+    reshipped_order_ids = []
+    return [order.new_order_id for order in Order.query.filter(Order.new_order_id.in_(order_ids)).all()]
 def close_session():
     if session.is_active:
         print "session is active. closing it."
         session.close()

Subversion Repositories SmartDukaan