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

                 orderFulfillmentWarehouse = cursor.fetchone()
             except Exception as e:
                 print "Error: unable to fetch data 2"
+            if order.productCondition != ProductCondition.BAD:
-            if orderFulfillmentWarehouse is not None:
+                if orderFulfillmentWarehouse is not None:
-                itemPricing = None
+                    itemPricing = None
-                selectSql = "select * from vendoritempricing where item_id = %d and vendor_id = %d"%(itemId,orderFulfillmentWarehouse[2])
+                    selectSql = "select * from vendoritempricing where item_id = %d and vendor_id = %d"%(itemId,orderFulfillmentWarehouse[2])
-                try:
+                    try:
-                    cursor = conn.cursor()
+                        cursor = conn.cursor()
-                    cursor.execute(selectSql)
+                        cursor.execute(selectSql)
-                    itemPricing = cursor.fetchone()
+                        itemPricing = cursor.fetchone()
-                except Exception as e:
+                    except Exception as e:
-                    print "Error: unable to fetch data 3"
+                        print "Error: unable to fetch data 3"
-                if itemPricing is None:
+                    if itemPricing is None:
-                    raise TransactionServiceException(214, "Vendor Item Pricing Missing For Item Id "+str(itemId)+ " and Fulfillment Warehouse "+ str(orderFulfillmentWarehouse[1]))
+                        raise TransactionServiceException(214, "Vendor Item Pricing Missing For Item Id "+str(itemId)+ " and Fulfillment Warehouse "+ str(orderFulfillmentWarehouse[1]))
-                else:
+                    else:
-                    order.lineitems[0].transfer_price = itemPricing[4]
+                        order.lineitems[0].transfer_price = itemPricing[4]
-                    order.lineitems[0].nlc = itemPricing[5]
+                        order.lineitems[0].nlc = itemPricing[5]
         else:
             conn.close()
             raise TransactionServiceException(216, "Order in Unacceptable Status.. "+str(order.id))
     try:
         conn.commit()

Subversion Repositories SmartDukaan

(root)//trunk/PyProj/src/shop2020/model/v1/order/impl/DataAccessors.py – Rev 19077 → 19137