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

 from shop2020.thriftpy.model.v1.inventory.ttypes import BillingType, \
     InventoryServiceException, WarehouseType, InventoryType
 from shop2020.thriftpy.model.v1.order.ttypes import TransactionServiceException, \
     TransactionStatus, OrderStatus, DelayReason, ExtraTransactionProcessingType, \
     HotspotAction, TimeoutSummary, OrderStatusGroups, OrderType, RechargeOrderStatus, \
-    RechargeType, RechargeStatistics, DeviceNumberInfo, EmiChargeType, PayMethod, OrderSource
+    RechargeType, RechargeStatistics, DeviceNumberInfo, EmiChargeType, PayMethod, OrderSource,\
+    StorePaymentStatus
 from shop2020.thriftpy.model.v1.user.ttypes import VoucherType
 from shop2020.thriftpy.payments.ttypes import PaymentException
 from shop2020.thriftpy.warehouse.ttypes import ScanType, \
     WarehouseServiceException
 from shop2020.utils.EmailAttachmentSender import mail, get_attachment_part
                     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):
+        storeOrderDetail = StoreOrderDetail.query.filter(StoreOrderDetail.orderId == order.id).filter(StoreOrderDetail.storeId == order.storeId).first()
+        if order.created_timestamp.date() == datetime.datetime.now().date():
+            __push_store_collection_to_hotspot(order, "advanceRefund", -(storeOrderDetail.cashRefundAmount + storeOrderDetail.cardRefundAmount))
+            storeOrderDetail.payStatus = StorePaymentStatus.ADV_REFUNDED
+        else:
-        __push_store_collection_to_hotspot(order, "advanceRefund", -order.advanceAmount)
+            __push_store_collection_to_hotspot(order, "advanceRefund", -(storeOrderDetail.cashRefundAmount))
+            if storeOrderDetail.cardRefundAmount > 0:
+                storeOrderDetail.payStatus = StorePaymentStatus.REFUND_PENDING
+            else:
+                storeOrderDetail.payStatus = StorePaymentStatus.ADV_REFUNDED
     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):
     '''
     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:
+    inCash = storeOrderDetail.cashAmount
-        mode = "CASH"
-    elif storeOrderDetail.cardAmount > 0:
+    byCard = storeOrderDetail.cardAmount
-        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, advanceAmount, totalAmount, customerName, delivery, mode, customerAdd1, customerAdd2, customerCity, customerState, customerMobile, customerPin)
+    return __printStoreOrderAdvanceInvoice(filename, product, advanceAmount, totalAmount, customerName, delivery, inCash, byCard, customerAdd1, customerAdd2, customerCity, customerState, customerMobile, customerPin)
-def __printStoreOrderAdvanceInvoice(filename, product, advanceAmount, totalAmount, customerName, delivery, mode, customerAdd1, customerAdd2, customerCity, customerState, customerMobile, customerPin):
+def __printStoreOrderAdvanceInvoice(filename, product, advanceAmount, totalAmount, customerName, delivery, inCash, byCard, 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')
     ############### 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>
+          .<br></br>""", prologueStyle))
-        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("*** ADVANCE RECEIPT ***").replace(" ", "&nbsp;"), textStyle))
+    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(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:<20s}{1:  %d/%m/%Y}".format("EXPECTED DELIVERY:", delivery).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 AMOUNT: ", advanceAmount).replace(' ', '&nbsp;'),textStyle))
+    Story.append(Paragraph(('{0:<20s}{1:>19.2f}').format("IN CASH: ", inCash).replace(' ', '&nbsp;'),textStyle))
+    Story.append(Paragraph(('{0:<20s}{1:>19.2f}').format("BY CARD: ", byCard).replace(' ', '&nbsp;'),textStyle))
     Story.append(Paragraph(('{0:<20s}{1:>19.2f}').format("BALANCE TO BE PAID: ", (totalAmount - advanceAmount)).replace(' ', '&nbsp;'),textStyle))
     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))
+    drawLine(Story, lineStyle)
+    Story.append(Paragraph(('{0:<20s}{1:>19s}').format("Customer care : ", "0120-6744700").replace(' ', '&nbsp;'),textStyle))
+    drawLine(Story, lineStyle)
     doc.addPageTemplates([PageTemplate(id='TwoCol',frames=[frame1]), ])
     #start the construction of the pdf
     doc.build(Story)
     allBankNames = []
     edcBanks = EdcBank.query.all();
     for bank in edcBanks:
         allBankNames.append(bank.name)
     return allBankNames
+def save_refund_amounts_for_store_order(orderId, storeId, cashRefundAmount, cardRefundAmount):
+    storeOrderDetail = StoreOrderDetail.query.filter(StoreOrderDetail.orderId == orderId).filter(StoreOrderDetail.storeId == storeId).first()
+    if storeOrderDetail:
+        storeOrderDetail.cashRefundAmount = cashRefundAmount
+        storeOrderDetail.cardRefundAmount = cardRefundAmount
+        session.commit()
+        return True
+    else:
+        return False
 if __name__ == '__main__':
-    print 'helllo'
     print datetime.datetime.now()
+    print datetime.datetime.now().date()
+    DataService.initialize('transaction', 'localhost')
+    order = Order.get_by(id = 308405)
+    print order.created_timestamp.date()
+    if order.created_timestamp.date() == datetime.datetime.now().date():
+        print "BOOO-YEAH"

Subversion Repositories SmartDukaan

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