WebSVN – SmartDukaan – Diff – //trunk/PyProj/src/shop2020/model/v1/catalog/script/SnapdealHistoryPopulator.py

         temp.append(mpItem)
         cantCompete.append(temp)
     return cantCompete, buyBoxItems, competitive, competitiveNoInventory, exceptionItems, negativeMargin
-def writeReport(cantCompete, buyBoxItems, competitive, competitiveNoInventory, exceptionList, negativeMargin, previousAutoFav, nowAutoFav,timestamp):
+def writeReport(cantCompete, buyBoxItems, competitive, competitiveNoInventory, exceptionList, negativeMargin, previousAutoFav, nowAutoFav,timestamp,runType):
     wbk = xlwt.Workbook()
     sheet = wbk.add_sheet('Can\'t Compete')
     xstr = lambda s: s or ""
     heading_xf = xlwt.easyxf('font: bold on; align: wrap off, vert centre, horiz center')
             sheet.write(sheet_iterator, 26, proposed_tp)
             sheet.write(sheet_iterator, 27, proposed_sp)
             sheet.write(sheet_iterator, 28, target_nlc)
             sheet.write(sheet_iterator, 29, getSalesPotential(snapdealDetails.lowestOfferPrice,snapdealItemInfo.nlc))
             sheet_iterator+=1
+    if (runType=='FULL'):
-    sheet = wbk.add_sheet('Auto Favorites')
+        sheet = wbk.add_sheet('Auto Favorites')
-    heading_xf = xlwt.easyxf('font: bold on; align: wrap off, vert centre, horiz center')
+        heading_xf = xlwt.easyxf('font: bold on; align: wrap off, vert centre, horiz center')
-    excel_integer_format = '0'
+        excel_integer_format = '0'
-    integer_style = xlwt.XFStyle()
+        integer_style = xlwt.XFStyle()
-    integer_style.num_format_str = excel_integer_format
+        integer_style.num_format_str = excel_integer_format
-    xstr = lambda s: s or ""
+        xstr = lambda s: s or ""
-    sheet.write(0, 0, "Item ID", heading_xf)
+        sheet.write(0, 0, "Item ID", heading_xf)
-    sheet.write(0, 1, "Brand", heading_xf)
+        sheet.write(0, 1, "Brand", heading_xf)
-    sheet.write(0, 2, "Product Name", heading_xf)
+        sheet.write(0, 2, "Product Name", heading_xf)
-    sheet.write(0, 3, "Auto Favourite", heading_xf)
+        sheet.write(0, 3, "Auto Favourite", heading_xf)
-    sheet.write(0, 4, "Reason", heading_xf)
+        sheet.write(0, 4, "Reason", heading_xf)
-    sheet_iterator=1
+        sheet_iterator=1
-    for autoFav in nowAutoFav:
+        for autoFav in nowAutoFav:
-        itemId = autoFav[0]
+            itemId = autoFav[0]
-        reason = autoFav[1]
+            reason = autoFav[1]
-        it = Item.query.filter_by(id=itemId).one()
+            it = Item.query.filter_by(id=itemId).one()
-        sheet.write(sheet_iterator, 0, itemId)
+            sheet.write(sheet_iterator, 0, itemId)
-        sheet.write(sheet_iterator, 1, it.brand)
+            sheet.write(sheet_iterator, 1, it.brand)
-        sheet.write(sheet_iterator, 2, xstr(it.brand)+" "+xstr(it.model_name)+" "+xstr(it.model_number)+" "+xstr(it.color))
+            sheet.write(sheet_iterator, 2, xstr(it.brand)+" "+xstr(it.model_name)+" "+xstr(it.model_number)+" "+xstr(it.color))
-        sheet.write(sheet_iterator, 3, "True")
+            sheet.write(sheet_iterator, 3, "True")
-        sheet.write(sheet_iterator, 4, reason)
+            sheet.write(sheet_iterator, 4, reason)
-        sheet_iterator+=1
+            sheet_iterator+=1
-    for prevFav in previousAutoFav:
+        for prevFav in previousAutoFav:
-        it = Item.query.filter_by(id=prevFav).one()
+            it = Item.query.filter_by(id=prevFav).one()
-        sheet.write(sheet_iterator, 0, prevFav)
+            sheet.write(sheet_iterator, 0, prevFav)
-        sheet.write(sheet_iterator, 1, it.brand)
+            sheet.write(sheet_iterator, 1, it.brand)
-        sheet.write(sheet_iterator, 2, xstr(it.brand)+" "+xstr(it.model_name)+" "+xstr(it.model_number)+" "+xstr(it.color))
+            sheet.write(sheet_iterator, 2, xstr(it.brand)+" "+xstr(it.model_name)+" "+xstr(it.model_number)+" "+xstr(it.color))
-        sheet.write(sheet_iterator, 3, "False")
+            sheet.write(sheet_iterator, 3, "False")
-        sheet_iterator+=1
+            sheet_iterator+=1
     autoPricingItems = session.query(MarketPlaceHistory,Item).join((Item,MarketPlaceHistory.item_id==Item.id)).filter(MarketPlaceHistory.timestamp==timestamp).filter(MarketPlaceHistory.source==OrderSource.SNAPDEAL).filter(MarketPlaceHistory.decision.in_([1,2,3,4])).all()
     sheet = wbk.add_sheet('Auto Inc and Dec')
             sheet.write(sheet_iterator, 5, math.ceil(mpHistory.proposedSellingPrice))
         if Decision._VALUES_TO_NAMES.get(mpHistory.decision) == "AUTO_INCREMENT_SUCCESS":
             sheet.write(sheet_iterator, 5, math.ceil(mpHistory.ourSellingPrice+max(10,.01*mpHistory.ourSellingPrice)))
         sheet_iterator+=1
-    filename = "/tmp/snapdeal-auto-" + str(timestamp) + ".xls"
+    filename = "/tmp/snapdeal-report-"+runType+" " + str(timestamp) + ".xls"
     wbk.save(filename)
     EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["kshitij.sood@saholic.com"], " Snapdeal Auto Pricing " + str(timestamp), "", [get_attachment_part(filename)], ["kshitij.sood@saholic.com"], [])
 def commitExceptionList(exceptionList,timestamp):
     exceptionItems=[]
     negativeMarginItems = commitNegativeMargin(negativeMargin,timestamp)
     fetchItemsForAutoDecrease(timestamp)
     fetchItemsForAutoIncrease(timestamp)
     if options.runType=='FULL':
         previousAutoFav, nowAutoFav = markAutoFavourite()
-    writeReport(cantCompete, buyBoxItems, competitive, competitiveNoInventory, exceptionList, negativeMargin, previousAutoFav, nowAutoFav,timestamp)
+    writeReport(cantCompete, buyBoxItems, competitive, competitiveNoInventory, exceptionList, negativeMargin, previousAutoFav, nowAutoFav,timestamp, options.runType)
 if __name__ == '__main__':
     main()

Subversion Repositories SmartDukaan

(root)//trunk/PyProj/src/shop2020/model/v1/catalog/script/SnapdealHistoryPopulator.py – Rev 9952 → 9953