WebSVN – SmartDukaan – Diff – /trunk/PyProj/src/shop2020/purchase/main/handler/PurchaseServiceHandler.py

         try:
             return [i.to_thrift_object() for i in Invoice.query.filter(Invoice.date > to_py_date(date)).all()]
         finally:
             self.close_session()
+    def getInvoicesForWarehouse(self, warehouseId, supplierId, date):
+        """
+        Fetches all invoices for a given date for specified physical warehouse
+        Parameters:
+         - date
+        """
+        try:
+            return [i.to_thrift_object() for i in Invoice.query.filter(Invoice.date > to_py_date(date)).filter(Invoice.warehouseId == warehouseId).filter(Invoice.supplierId == supplierId).all()]
+        finally:
+            self.close_session()
     def getInvoice(self, invoiceNumber, supplierId):
         """
         Fetches all invoices for  given invoiceNumber and supplierId
         Parameters:
             invoiceObj.invoiceNumber = invoice.invoiceNumber
             invoiceObj.date = to_py_date(invoice.date)
             invoiceObj.receivedFrom = invoice.receivedFrom
             invoiceObj.numItems = invoice.numItems
             invoiceObj.supplierId = invoice.supplierId
+            invoiceObj.warehouseId = invoice.warehouseId
             session.commit()
         finally:
             self.close_session()
     def addSupplier(self, supplier):
         lineItem = LineItem.get_by(purchaseOrder_id=poId, itemId=itemId)
         lineItem.unfulfilledQuantity = lineItem.unfulfilledQuantity - 1
         if not lineItem.unfulfilledQuantity:
             lineItem.fulfilled = 1
         session.commit()
+    def closePO(self, poId):
+        purchaseOrder = PurchaseOrder.get_by(id=poId)
+        if not purchaseOrder:
+                raise PurchaseServiceException(101, "No purchase order can be found with id:" + str(id))
+        purchaseOrder.status = 4
+        session.commit()
+    def isInvoiceReceived(self, invoiceNumber, supplierId):
+        """
+        Returns whether invoice is already received for given invoiceNumber and supplierId
+        Parameters:
+         - invoiceNumber, supplierId
+        """
+        try:
+            invoice = Invoice.query.filter_by(invoiceNumber=invoiceNumber, supplierId=supplierId).first()
+            if invoice is None:
+                return False
+            else:
+                return True
+        finally:
+            self.close_session()
     def isAlive(self,):
         """
         For checking weather service is active alive or not. It also checks connectivity with database
         """
         try:

Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/purchase/main/handler/PurchaseServiceHandler.py – Rev 7106 → 7410