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

     BlockedIpRange, DeniedIpAddress, InsuranceDetailForOrder, DocumentStore, \
     RechargeTransaction, HotspotStore, WalletForCompany, WalletHistoryForCompany, \
     FRC, OperatorSeries, SourceDetail, Company, EbayOrder, AmazonFbaSalesSnapshot, \
     AmazonOrder, StoreOrderDetail, EdcBank, StoreOrderCollection, \
     HotspotServiceMatrix, SnapdealOrder, FlipkartOrder, DataInsuranceDetailForOrder, \
-    AmazonFbaOrderReturns
+    AmazonFbaOrderReturns, FlipkartAdvantageOrder, InvoiceCounterGenerator
 from shop2020.model.v1.order.impl.model.BaseOrder import BaseOrder
 from shop2020.model.v1.order.impl.model.DTHRechargeOrder import DTHRechargeOrder
 from shop2020.model.v1.order.impl.model.MobileRechargeOrder import \
     MobileRechargeOrder
 from shop2020.model.v1.order.impl.model.RechargeDenomination import \
 def __getOrderTaxType(order):
     delhiPincodePrefix = "11";
     maharashtraPincodePrefix = ["40", "41", "42", "43", "44"];
     karnatakaPincodePrefix = ["56", "57", "58", "59"];
+    telenganaPincodes = ["500001","500002","500003","500004","500005","500006","500007","500008","500009","500010","500011","500012","500013","500014","500015","500016","500017","500018","500019","500020","500021","500022","500023","500024","500025","500026","500027","500028","500029","500030","500031","500032","500033","500034","500035","500036","500037","500038","500039","500040","500041","500042","500043","500044","500045","500046","500047","500048","500049","500050","500051","500052","500053","500054","500055","500056","500057","500058","500059","500060","500061","500062","500063","500064","500065","500066","500067","500068","500069","500070","500071","500072","500073","500074","500075","500076","500077","500078","500079","500080","500081","500082","500083","500084","500085","500086","500087","500088","500089","500090","500091","500092","500093","500094","500095","500096","500097","500098","500178","500409","501218","501301","501401","501510","501511","501512","502307","502319","517501","517502","517503","517505","517507","520001","520002","520003","520004","520005","520006","520007","520008","520009","520010","520011","520012","520013","520014","520015","521108","521225","522001","522002","522003","522004","522005","522006","522007","522019","522509","530001","530002","530003","530004","530005","530007","530008","530009","530010","530010","530011","530012","530013","530014","530015","530016","530017","530018","530020","530021","530022","530023","530024","530026","530027","530028","530029","530032","530035","530040","530041","530043","530044","530045","530046","531001","533101","533103","533104","533105"]
     if order.warehouse_id == 7 or order.warehouse_id == 9:
         if order.customer_pincode.startswith(delhiPincodePrefix):
             return 0
         else:
     if order.warehouse_id == 1765 or order.warehouse_id == 1768:
         for knkPincodePrefix in karnatakaPincodePrefix:
             if order.customer_pincode.startswith(knkPincodePrefix):
                 return 0
         return 1
+    if order.warehouse_id == 3298:
+        for pincode in telenganaPincodes:
+            if order.customer_pincode == pincode:
+                return 0
+        return 1
     return 0
     #raise TransactionServiceException(110, "No Vat/CST logic defined for warehouse " + str(order.warehouse_id))
 def add_billing_details(orderId, invoice_number, serialNumbers, itemNumbers, freebieWarehouseId, billedBy, jacketNumber, billingType, fulfilmentWarehouseId, authorize):
     if billedBy is None or billedBy.strip() == "":
         order.status = OrderStatus.BILLED
         order.statusDescription = "Order Billed"
         order.billing_timestamp = datetime.datetime.now()
         order.billed_by = billedBy
+        #Manish Sharma Invoice
+        whStateId = None
         # Letting the billing process fail in cases where we are unable to
         # fill in transfer price
         try:
             inventory_client = InventoryClient().get_client()
             warehouse = inventory_client.getWarehouse(fulfilmentWarehouseId)
                 if fetchStateMaster()[warehouse.stateId].vatType==VatType.MRP:
                     lineitem.vatRate = catalog_client.getVatPercentageForItem(lineitem.item_id, warehouse.stateId, lineitem.mrp)
                 else:
                     lineitem.vatRate = catalog_client.getVatPercentageForItem(lineitem.item_id, warehouse.stateId, lineitem.unit_price)
             order.vendorId = warehouse.vendor.id
+            whStateId = warehouse.stateId
         except InventoryServiceException as e:
             print sys.exc_info()[0]
             print e.message
             raise TransactionServiceException(110, 'Transfer price missing for itemId: ' + str(item_id) + ' and vendor: ' + str(warehouse.vendor.id))
     entity_id = InvoiceIDGenerator.query.filter(InvoiceIDGenerator.orderType == orderType).with_lockmode("update").one()
     invoice_number = entity_id.id + 1
     entity_id.id = invoice_number
     return invoice_number
+def get_next_invoice_counter(orderType, stateId):
+    entity_id = InvoiceCounterGenerator.query.filter(InvoiceCounterGenerator.orderType == orderType).filter(InvoiceCounterGenerator.stateId == stateId).with_lockmode("update").one()
+    invoice_number = entity_id.id + 1
+    entity_id.id = invoice_number
+    return invoice_number, entity_id.prefix
 def toggle_doa_flag(order_id):
     order = get_order(order_id)
     if(order.doaFlag):
         order.doaFlag = False
     else:
     exists = FlipkartOrder.query.filter_by(flipkartOrderId=orderid,flipkartSubOrderId=suborderid).first()
     if exists is not None:
         return True
     else:
         return False
 def create_flipkart_order(flipkartorder):
     order = FlipkartOrder()
     order.orderId = flipkartorder.orderId
     order.flipkartSubOrderId = flipkartorder.flipkartSubOrderId
     order.flipkartOrderId = flipkartorder.flipkartOrderId
     else:
         invoiceNo = get_next_invoice_number(orders[0].orderType)
         for order in orders:
             order.invoice_number = invoiceNo
             session.commit()
+def get_fa_order_by_fk_order_id(fk_OrderId,fk_OrderItemId):
+    faOrder = FlipkartAdvantageOrder.query.filter_by(fkOrderId=fk_OrderId,fkOrderItemId=fk_OrderItemId).first()
+    if not faOrder:
+        print "Not found order for orderId " + str(fk_OrderId)
+        raise TransactionServiceException(108, "no such order")
+    return faOrder
+def flipkart_fa_order_exists(fk_OrderId,fk_OrderItemId):
+    faOrder = FlipkartAdvantageOrder.query.filter_by(fkOrderId=fk_OrderId,fkOrderItemId=fk_OrderItemId).first()
+    if not faOrder:
+        return False
+    else:
+        return True
+def get_all_fa_orders_list(status):
+    faOrders = None
+    if status == 'all':
+        faOrders = FlipkartAdvantageOrder.query.all()
+    else:
+        faOrders = FlipkartAdvantageOrder.query.filter(FlipkartAdvantageOrder.status==status).all()
+    if not faOrders:
+        faOrders = []
+    return faOrders
+def add_update_fa_orders_bulk(faOrdersList):
+    for faOrder in faOrdersList:
+        if faOrder.status == 'shipped':
+            fa_Order = FlipkartAdvantageOrder()
+            fa_Order.fkOrderId = faOrder.fkOrderId
+            fa_Order.fkOrderItemId = faOrder.fkOrderItemId
+            fa_Order.sku = faOrder.sku
+            fa_Order.creationTimestamp = to_py_date(faOrder.creationTimestamp)
+            fa_Order.customerName = faOrder.customerName
+            fa_Order.customerAddress = faOrder.customerAddress
+            fa_Order.pincode = faOrder.pincode
+            fa_Order.customerCity = faOrder.customerCity
+            fa_Order.customerState = faOrder.customerState
+            fa_Order.customerPhone = faOrder.customerPhone
+            fa_Order.status = faOrder.status
+            fa_Order.quantity = faOrder.quantity
+            fa_Order.totalPrice = faOrder.totalPrice
+            fa_Order.listPrice = faOrder.listPrice
+            fa_Order.modifiedDate = to_py_date(faOrder.modifiedDate)
+            fa_Order.listingId = faOrder.listingId
+            fa_Order.cancelReason = faOrder.cancelReason
+            fa_Order.returnReason = faOrder.returnReason
+            fa_Order.freebieItemId = faOrder.freebieItemId
+            fa_Order.productTitle = faOrder.productTitle
+        else:
+            fa_Order = FlipkartAdvantageOrder.query.filter_by(fkOrderId=faOrder.fkOrderId,fkOrderItemId=faOrder.fkOrderItemId).first()
+            if fa_Order:
+                if fa_Order.status !=faOrder.status:
+                    fa_Order.status = faOrder.status
+                    fa_Order.cancelReason = faOrder.cancelReason
+                    fa_Order.returnReason = faOrder.returnReason
+                    fa_Order.modifiedDate = to_py_date(faOrder.modifiedDate)
+    session.commit()
 if __name__ == '__main__':
     print get_orders_by_mobile_number("9650889334")

Subversion Repositories SmartDukaan

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