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

     else:
         filename = "/tmp/order-" + str(order.id) + ".pdf"
     #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(store, order.id, filename, product, advanceAmount, totalAmount, customerName, delivery, inCash, byCard, customerAdd1, customerAdd2, customerCity, customerState, customerMobile, customerPin)
+    return __printStoreOrderAdvanceInvoice(store, order.id, filename, product, advanceAmount, totalAmount, customerName, delivery, inCash, byCard, customerAdd1, customerAdd2, customerCity, customerState, customerMobile, customerPin, order.created_timestamp.date())
 def __printStoreOrderCancellationReceipt(store, orderId, filename, customerName, customerAdd1, customerAdd2, customerCity, customerState, customerMobile, customerPin, product, advanceAmount,inCash, byCard, createdDate, cancelDate):
     PAGE_HEIGHT=defaultPageSize[1];
     styles = getSampleStyleSheet()
     styles.add(ParagraphStyle(name='prologue', alignment=TA_CENTER, fontName="Courier", rightIndent = 5, fontSize=10), alias='sH')
     Story.append(Paragraph(store.line2 + ', ' + store.city, prologueStyle))
     Story.append(Paragraph(store.state + ' - ' + store.pin, prologueStyle))
     drawLine(Story, lineStyle)
-    Story.append(Paragraph("{0:^39s}".format("*** ADVANCE CANCELLATION RECEIPT ***").replace(" ", "&nbsp;"), textStyle))
+    Story.append(Paragraph("{0:^39s}".format("*** ADVANCE REFUND RECEIPT ***").replace(" ", "&nbsp;"), 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:<20s}{1:>19.2f}').format("ADVANCE AMOUNT: ", advanceAmount).replace(' ', '&nbsp;'),textStyle))
     Story.append(Paragraph(('{0:<30s}{1:>9.2f}').format("LESS-CANCELLATION CHARGES: ", advanceAmount-inCash-byCard).replace(' ', '&nbsp;'),textStyle))
     Story.append(Paragraph(('{0:<30s}{1:>9.2f}').format("AMOUNT TO BE REFUNDED: ", inCash+byCard).replace(' ', '&nbsp;'),textStyle))
     if inCash > 0:
-        Story.append(Paragraph(('{0:<20s}{1:>19.2f}').format("REFUND IN CASH: ", inCash).replace(' ', '&nbsp;'),textStyle))
+        Story.append(Paragraph(('{0:>20s}{1:>19.2f}').format("REFUND IN CASH: ", inCash).replace(' ', '&nbsp;'),textStyle))
     if byCard > 0:
-        Story.append(Paragraph(('{0:<20s}{1:>19.2f}').format("REFUND BY CARD: ", byCard).replace(' ', '&nbsp;'),textStyle))
+        Story.append(Paragraph(('{0:>20s}{1:>19.2f}').format("REFUND BY CARD: ", byCard).replace(' ', '&nbsp;'),textStyle))
     drawLine(Story, lineStyle)
     Story.append(Paragraph("CUSTOMER SIGNATURE :", textStyle))
     Story.append(Paragraph("&nbsp;", textStyle))
     drawLine(Story, lineStyle)
     drawLine(Story, lineStyle)
     Story.append(Paragraph("Note:", textStyle))
     Story.append(Paragraph("* Original copy of 'Advance Receipt' Shall be provided  by Customer to get the refund",textStyle))
+    Story.append(Paragraph("* All disputes subject to Delhi jusrisdiction",textStyle))
     drawLine(Story, lineStyle)
     Story.append(Paragraph(('{0:<20s}{1:>19s}').format("Customer care : ", "0120-6744700").replace(' ', '&nbsp;'),textStyle))
     return pdfFile
-def __printStoreOrderAdvanceInvoice(store, orderId, filename, product, advanceAmount, totalAmount, customerName, delivery, inCash, byCard, customerAdd1, customerAdd2, customerCity, customerState, customerMobile, customerPin):
+def __printStoreOrderAdvanceInvoice(store, orderId, filename, product, advanceAmount, totalAmount, customerName, delivery, inCash, byCard, customerAdd1, customerAdd2, customerCity, customerState, customerMobile, customerPin, createdDate):
     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')
     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:<10s}{1:<29s}".format("ORDER ID:", str(orderId)).replace(" ", "&nbsp;"), textStyle))
+    Story.append(Paragraph("{0:<10s}{1:<12s}{2:7s}{3:  %d/%m/%Y}".format("ORDER ID:", str(orderId), "DATE:", createdDate).replace(" ", "&nbsp;"), textStyle))
     Story.append(Paragraph("{0:<20s}{1:  %d/%m/%Y}".format("EXPECTED DELIVERY:", delivery).replace(" ", "&nbsp;"), textStyle))
+    Story.append(Paragraph("{0:<20s}{1:  %d/%m/%Y}".format("CURRENT DATE:", datetime.datetime.now().date()).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))
     if inCash > 0:
-        Story.append(Paragraph(('{0:<20s}{1:>19.2f}').format("IN CASH: ", inCash).replace(' ', '&nbsp;'),textStyle))
+        Story.append(Paragraph(('{0:>13s}{1:>26.2f}').format("IN CASH: ", inCash).replace(' ', '&nbsp;'),textStyle))
     if byCard > 0:
-        Story.append(Paragraph(('{0:<20s}{1:>19.2f}').format("BY CARD: ", byCard).replace(' ', '&nbsp;'),textStyle))
+        Story.append(Paragraph(('{0:>13s}{1:>26.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("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 on customer request, 10% of product amount subject to minimum Rs 500/- shall be deducted 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))
+    Story.append(Paragraph("* All disputes subject to Delhi Jurisdiction",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]), ])
         storeOrderDetail.cardRefundAmount = cardRefundAmount
         session.commit()
         return True
     else:
         return False
+def get_collections_for_store(storeId, startdate, enddate):
+    if startdate == -1:
+        startdate = None
+    if enddate == -1:
+        enddate = None
+    if storeId== 0:
+        storeId = None
+    if storeId:
+        store = HotspotStore.get_by(id = storeId)
+    hotspotId = store.hotspotId
+    query = StoreOrderCollection.query
+    if storeId is not None:
+        query = query.filter(StoreOrderCollection.hotspotId == hotspotId)
+    else:
+        return []
+    if startdate is not None and enddate is not None:
+        startdate = to_py_date(startdate).date()
+        enddate = to_py_date(enddate).date()
+        if startdate == enddate:
+            query = query.filter(cast(StoreOrderCollection.pushedAt, DATE) == enddate)
+        elif enddate < startdate:
+            query = query.filter(between(cast(StoreOrderCollection.pushedAt, DATE), enddate, startdate))
+        else:
+            query = query.filter(between(cast(StoreOrderCollection.pushedAt, DATE), startdate, enddate))
+    elif startdate is not None:
+        startdate = to_py_date(startdate).date()
+        query = query.filter(cast(StoreOrderCollection.pushedAt, DATE) >= startdate)
+    elif enddate is not None:
+        enddate = to_py_date(enddate).date()
+        query = query.filter(cast(StoreOrderCollection.pushedAt, DATE) <= enddate)
+    return query.filter(StoreOrderCollection.pushedToOcr == 1).all()
 if __name__ == '__main__':
     print datetime.datetime.now()
     print datetime.datetime.now().date()

Subversion Repositories SmartDukaan

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