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

     OrderInventory, Alert, PaymentSettlement, EBSSettlementSummary, \
     CodVerificationAgent, Attribute, RechargeVoucherTracker, EmiScheme, MiscCharges, \
     BlockedIpRange, DeniedIpAddress, InsuranceDetailForOrder, DocumentStore, \
     RechargeTransaction, HotspotStore, WalletForCompany, WalletHistoryForCompany, \
     FRC, OperatorSeries, SourceDetail, Company, \
-    AmazonOrder
+    AmazonOrder, StoreOrderDetail, EdcBank
 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 \
                 transaction_requiring_extra_processing = TransactionRequiringExtraProcessing()
                 transaction_requiring_extra_processing.category = 'PAYMENT_FLAGGED'
                 transaction_requiring_extra_processing.transaction_id = transaction_id
                 session.commit()
         elif order.source == OrderSource.STORE:
-                attribute = Attribute()
-                attribute.orderId = order.id
-                attribute.name = "PAYMENT_MODE"
-                attribute.value = "Cash"
-                session.commit()
                 catalog_client = CatalogClient().get_client()
                 sourcePricing = catalog_client.getStorePricing(order.lineitems[0].item_id)
                 if order.total_amount >= sourcePricing.minPrice:
                     order.status = OrderStatus.SUBMITTED_FOR_PROCESSING
+                    order.statusDescription = "Order Accepted"
                     session.commit()
-                    __push_store_collection_to_hotspot(order, "advance")
+                    __push_store_collection_to_hotspot(order, "advance", order.advanceAmount)
                 else:
                     order.status = OrderStatus.COD_VERIFICATION_PENDING
+                    order.statusDescription = "Approval Pending"
                     content = "<html><body>"
                     content += "<h4>Order Id:  " + str(order.id) + "</h4>"
                     content += "<h4>Product:  " + str(order.lineitems[0]) + "</h4>"
                     content += "<h4>Min Price: " +  str(sourcePricing.minPrice) + "</h4>"
                     content += "<h4>Recommended Price: " +  str(sourcePricing.recommendedPrice) + "</h4>"
                      OrderStatus.BILLED : OrderStatus.CANCELLED_DUE_TO_LOW_INVENTORY,
                      OrderStatus.CANCEL_REQUEST_CONFIRMED : OrderStatus.CANCELLED_ON_CUSTOMER_REQUEST
+                     }
         if order.status not in status_transition.keys():
             raise TransactionServiceException(114, "This order can't be refunded")
         if order.status in [OrderStatus.COD_VERIFICATION_PENDING, OrderStatus.SUBMITTED_FOR_PROCESSING, OrderStatus.INVENTORY_LOW, OrderStatus.LOW_INV_PO_RAISED, OrderStatus.LOW_INV_REVERSAL_IN_PROCESS, OrderStatus.LOW_INV_NOT_AVAILABLE_AT_HOTSPOT, OrderStatus.ACCEPTED]:
             __update_inventory_reservation(order)
             order.statusDescription = "Order Cancelled"
         elif order.status == OrderStatus.BILLED:
             __create_return_order(order)
                 else:
                     warehouseClient.scanForOrder(None, ScanType.SALE_RET, lineitem.quantity, order.id, order.fulfilmentWarehouseId, order.warehouse_id)
             if warehouse.billingType == BillingType.OURS_EXTERNAL:
                 warehouseClient.scanForOursExternalSaleReturn(order.id, lineitem.transfer_price)
+    if order.source == 2 and order.status in (OrderStatus.SUBMITTED_FOR_PROCESSING, OrderStatus.ACCEPTED, OrderStatus.INVENTORY_LOW):
+        __push_store_collection_to_hotspot(order, "advanceRefund", -order.advanceAmount)
     order.status = status_transition[order.status]
     order.refund_timestamp = datetime.datetime.now()
     order.refunded_by = refunded_by
     order.refund_reason = reason
     session.commit()
     return True
 def __update_inventory_reservation(order):
     '''
     pdf.drawText(order_text)
     pdf.showPage()
     pdf.save()
     return filename
-def __push_store_collection_to_hotspot(order, type):
+def __push_store_collection_to_hotspot(order, ctype, amount):
     try:
         ts = order.created_timestamp
         store =  get_hotspot_store(order.storeId, "")
         storeName = store.hotspotId
         store_string = "<Store>" + storeName + "</Store>"
         order_string = "<OrderID>" + str(order.id) + "</OrderID>"
         product_string = "<Product>" + str(order.lineitems[0]) + "</Product>"
-        collection_type = "<CollectionType>" + type + "</CollectionType>"
+        collection_type = "<CollectionType>" + ctype + "</CollectionType>"
-        if type == 'advance':
-            amount_string = "<AdvanceAmount>" + order.advanceAmount + "</AdvanceAmount>"
+        amount_string = "<AdvanceAmount>" + amount + "</AdvanceAmount>"
         date_string = "<TimeStamp>" + ts.strftime("%Y%m%d%H%M%S") + "</TimeStamp>"
         cash_string = "<CashAmount>" + order.advanceAmount + "</CashAmount>"
         card_string = "<CardAmount>" + "0" + "</CardAmount>"
         #advance, saleClosure, advanceRefund, saleRefund
             query = query.filter(Order.status.in_(statuses))
     orders = query.filter(Order.storeId == storeId).all()
     return orders
-def get_store_order_advance_invoice(orderId):
+def get_store_order_advance_invoice(orderId, storeId):
     order = Order.get_by(id = orderId)
+    storeOrderDetail = StoreOrderDetail.query.filter(StoreOrderDetail.orderId == orderId).filter(StoreOrderDetail.storeId == storeId).first()
     filename = "/tmp/recharge" + str(order.id) + ".pdf"
     modelName = "&nbsp;"
     modelNumber = "&nbsp;"
     color = "&nbsp;"
     if order.lineitems[0].model_name:
         modelNumber = modelNumber + order.lineitems[0].model_number
     if order.lineitems[0].color:
         color = color + order.lineitems[0].color
     product = order.lineitems[0].brand +  modelName + modelNumber + color
-    amount = order.advanceAmount
+    advanceAmount = order.advanceAmount
     totalAmount = order.total_amount
     delivery = order.expected_delivery_time
     customerName = order.customer_name
+    customerAdd1 = order.customer_address1
+    customerAdd2 = order.customer_address2
+    customerCity = order.customer_city
+    customerState = order.customer_state
+    customerMobile = order.customer_mobilenumber
+    customerPin = order.customer_pincode
+    mode = ""
+    if storeOrderDetail.cashAmount > 0 and storeOrderDetail.cardAmount > 0:
+        mode = "CASH + CARD"
+    elif storeOrderDetail.cashAmount > 0:
+        mode = "CASH"
+    elif storeOrderDetail.cardAmount > 0:
+        mode = "CARD"
     #payMethod = recharge.payMethod
+#    if order.status == 15 or order.status == 34:
+#        return __printStoreOrderAdvanceInvoice(filename, product, advanceAmount, totalAmount, customerName, delivery, mode, customerAdd1, customerAdd2, customerCity, customerState, customerMobile, customerPin)
-    return __printStoreOrderAdvanceInvoice(filename, product, amount, totalAmount, customerName, delivery)
+    return __printStoreOrderAdvanceInvoice(filename, product, advanceAmount, totalAmount, customerName, delivery, mode, customerAdd1, customerAdd2, customerCity, customerState, customerMobile, customerPin)
-def __printStoreOrderAdvanceInvoice(filename, product, amount, totalAmount, customerName, delivery):
+def __printStoreOrderAdvanceInvoice(filename, product, advanceAmount, totalAmount, customerName, delivery, mode, customerAdd1, customerAdd2, customerCity, customerState, customerMobile, customerPin):
     PAGE_HEIGHT=defaultPageSize[1];
     styles = getSampleStyleSheet()
     styles.add(ParagraphStyle(name='prologue', alignment=TA_CENTER, fontName="Courier", rightIndent = 5, fontSize=10), alias='sH')
     styles.add(ParagraphStyle(name='text', alignment=TA_JUSTIFY, fontName="Courier", fontSize=10), alias='text')
     styles.add(ParagraphStyle(name='line', alignment=TA_CENTER, fontName="Courier", fontSize=10), alias='line')
     #Two Columns
     frame1 = Frame(58, doc.bottomMargin, doc.width/2 + 25, doc.height + 7, id='col1')
+    ############### TODO ###############################################################
     Story.append(Paragraph("""Spice Retail Limited<br></br>
         C/O,PIBCO LIMITED,Basement,Punjsons<br></br>
 ,Kalkaji Industrial Area,New Delhi<br></br>
           .<br></br>
         TIN NO. 07430284979<br></br>
         Service Tax No:AAACM0294PST001<br></br><br></br><br></br>""", prologueStyle))
+    ############### ADDRESS TO BE DYNAMIC ##############################################
     drawLine(Story, lineStyle)
+    Story.append(Paragraph("{0:^39s}".format("DELIVERY ADDRESS").replace(" ", "&nbsp;"), textStyle))
+    drawLine(Story, lineStyle)
+    Story.append(Paragraph(customerAdd1, textStyle))
+    if len(customerAdd2) > 0:
+        Story.append(Paragraph(customerAdd2, textStyle))
+    Story.append(Paragraph(customerCity, textStyle))
+    Story.append(Paragraph(customerState + " - " + customerPin, textStyle))
+    drawLine(Story, lineStyle)
     Story.append(Paragraph("{0:<6s}{1:<34s}".format("NAME:", customerName).replace(" ", "&nbsp;"), textStyle))
+    Story.append(Paragraph("{0:<10s}{1:<29s}".format("MOBILE:", customerMobile).replace(" ", "&nbsp;"), textStyle))
     Story.append(Paragraph("{0:<15s}{1:  %d/%m/%Y}".format("EXP DELIVERY:", delivery).replace(" ", "&nbsp;"), textStyle))
-    Story.append(Paragraph("{0:<15s}{1:<25s}".format("PAYMENT MODE:", "CARD").replace(" ", "&nbsp;"), textStyle))
+    Story.append(Paragraph("{0:<15s}{1:<25s}".format("PAYMENT MODE:", mode).replace(" ", "&nbsp;"), textStyle))
     drawLine(Story, lineStyle)
     Story.append(Paragraph("{0:^39s}".format("PRODUCT NAME").replace(" ", "&nbsp;"), textStyle))
     drawLine(Story, lineStyle)
     Story.append(Paragraph("{0:<39s}".format(product).replace(" ", "&nbsp;"), textStyle))
     drawLine(Story, lineStyle)
     Story.append(Paragraph(('{0:<20s}{1:>19.2f}').format("TOTAL PRICE: ", totalAmount).replace(' ', '&nbsp;'),textStyle))
-    Story.append(Paragraph(('{0:<20s}{1:>19.2f}').format("ADVANCE PAID: ", amount).replace(' ', '&nbsp;'),textStyle))
+    Story.append(Paragraph(('{0:<20s}{1:>19.2f}').format("ADVANCE AMOUNT: ", advanceAmount).replace(' ', '&nbsp;'),textStyle))
+    Story.append(Paragraph(('{0:<20s}{1:>19.2f}').format("BALANCE TO BE PAID: ", (totalAmount - advanceAmount)).replace(' ', '&nbsp;'),textStyle))
     drawLine(Story, lineStyle)
-    drawLine(Story, lineStyle)
     Story.append(Paragraph(('{0:<20s}{1:>19s}').format("Customer care : ", "0120-6744700").replace(' ', '&nbsp;'),textStyle))
+    drawLine(Story, lineStyle)
+    drawLine(Story, lineStyle)
+    Story.append(Paragraph("Note:", textStyle))
+    Story.append(Paragraph("* In case of cancellation of order on customer request, 10% of product amount subject to minimum Rs 500/- shall be deducted by Spice Retail Limited as cancellation charges. Customer shall provide original copy of 'Advance Receipt' to get the balance amount as refund",textStyle))
+    Story.append(Paragraph("* In case of cancellation of order other than customer request, original copy of 'Advance Receipt' shall be provided by customer to get the refund",textStyle))
+    Story.append(Paragraph("* Balance amount as mentioned above to be paid at the time of delivery of product to courier agency. Refusal to accept the product delivered through courier shall be deemed as cancellation of order and cancellation charges shall become applicable.",textStyle))
+    Story.append(Paragraph("* The product as mentioned above shall be made available to the customer, subject to its availability from the manufacturer",textStyle))
     doc.addPageTemplates([PageTemplate(id='TwoCol',frames=[frame1]), ])
     #start the construction of the pdf
     doc.build(Story)
         operatorSeriesObject.series = series
         operatorSeriesObject.circleId = circle
         operatorSeriesObject.operatorId = operatorId
         session.commit()
         return "Successfully saved"
+def save_store_order_detail(thrift_storeOrderDetail):
+    txnId = thrift_storeOrderDetail.orderId
+    txn = Transaction.get_by(id=txnId)
+    oid = txn.orders[0].id
+    ds_storeOrderDetail = StoreOrderDetail()
+    ds_storeOrderDetail.orderId = oid
+    ds_storeOrderDetail.advanceAmount = thrift_storeOrderDetail.advanceAmount
+    ds_storeOrderDetail.cardAmount = thrift_storeOrderDetail.cardAmount
+    ds_storeOrderDetail.cashAmount = thrift_storeOrderDetail.cashAmount
+    ds_storeOrderDetail.storeId = thrift_storeOrderDetail.storeId
+    ds_storeOrderDetail.payStatus = thrift_storeOrderDetail.payStatus
+    session.commit()
+    return True
+def get_store_order_detail(orderId, storeId):
+    storeOrderDetail = StoreOrderDetail.query.filter(StoreOrderDetail.orderId == orderId).filter(StoreOrderDetail.storeId == storeId).first()
+    if storeOrderDetail:
+        return storeOrderDetail
+    else:
+        return StoreOrderDetail()
+def get_all_edc_banks():
+    allBankNames = []
+    edcBanks = EdcBank.query.all();
+    for bank in edcBanks:
+        allBankNames.append(bank.name)
+    return allBankNames
 if __name__ == '__main__':
     print 'helllo'

Subversion Repositories SmartDukaan

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