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

     mailServer = smtplib.SMTP("smtp.gmail.com", 587)
     mailServer.ehlo()
     mailServer.starttls()
     mailServer.ehlo()
-    # Create the container (outer) email message.
+    #recipients = ['kshitij.sood@saholic.com']
     recipients = ['rajneesh.arora@saholic.com','rajveer.singh@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
     msg = MIMEMultipart()
     msg['Subject'] = "Snapdeal Auto Pricing" + ' - ' + str(datetime.now())
     msg['From'] = ""
     msg['To'] = ",".join(recipients)
         if (markUpdatedItem.sellingPrice!=snapdealItem.sellingPrice or markUpdatedItem.suppressPriceFeed!=snapdealItem.suppressPriceFeed or markUpdatedItem.isListedOnSource!=snapdealItem.isListedOnSnapdeal):
             markUpdatedItem.lastUpdatedOn = snapdealItem.updatedOn
         markUpdatedItem.sellingPrice = snapdealItem.sellingPrice
         markUpdatedItem.suppressPriceFeed = snapdealItem.suppressPriceFeed
         markUpdatedItem.isListedOnSource = snapdealItem.isListedOnSnapdeal
+def processLostBuyBoxItems(previousProcessingTimestamp,currentTimestamp):
+    previous_buy_box = session.query(MarketPlaceHistory.item_id).filter(MarketPlaceHistory.timestamp==previousProcessingTimestamp).filter(MarketPlaceHistory.source==OrderSource.SNAPDEAL).filter(MarketPlaceHistory.competitiveCategory==CompetitionCategory.BUY_BOX).all()
+    cant_compete = session.query(MarketPlaceHistory.item_id).filter(MarketPlaceHistory.timestamp==currentTimestamp).filter(MarketPlaceHistory.source==OrderSource.SNAPDEAL).filter(MarketPlaceHistory.competitiveCategory==CompetitionCategory.CANT_COMPETE).all()
+    lost_buy_box = list(list(zip(*previous_buy_box)[0])&list(zip(*cant_compete)[0]))
+    if len(lost_buy_box)==0:
+        return
+    xstr = lambda s: s or ""
+    message="""<html>
+            <body>
+            <h3>Lost Buy Box</h3>
+            <table border="1" style="width:100%;">
+            <thead>
+            <tr><th>Item Id</th>
+            <th>Product Name</th>
+            <th>Current Price</th>
+            <th>Current TP</th>
+            <th>Current Margin</th>
+            <th>Competition TP</th>
+            <th>Lowest Possible TP</th>
+            <th>NLC</th>
+            <th>Target NLC</th>
+            <th>Snapdeal Inventory</th>
+            <th>Total Inventory</th>
+            <th>Sales History</th>
+            </tr></thead>
+            <tbody>"""
+    items = session.query(MarketPlaceHistory).filter(MarketPlaceHistory.timestamp==currentTimestamp).filter(MarketPlaceHistory.source==OrderSource.SNAPDEAL).filter(MarketPlaceHistory.item_id.in_(lost_buy_box)).all()
+    for item in items:
+        it = Item.query.filter_by(id=item.item_id).one()
+        netInventory=''
+        if not inventoryMap.has_key(item.item_id):
+            netInventory='Info Not Available'
+        else:
+            netInventory = str(getNetAvailability(inventoryMap.get(item.item_id)))
+        message+="""<tr>
+                <td style="text-align:center">"""+str(item.item_id)+"""</td>
+                <td style="text-align:center">"""+xstr(it.brand)+" "+xstr(it.model_name)+" "+xstr(it.model_number)+" "+xstr(it.color)+"""</td>
+                <td style="text-align:center">"""+str(item.ourSellingPrice)+"""</td>
+                <td style="text-align:center">"""+str(item.ourTp)+"""</td>
+                <td style="text-align:center">"""+str(round(item.margin))+" ("+str(round((item.margin/item.ourSellingPrice)*100,1))+"%)"+"""</td>
+                <td style="text-align:center">"""+str(item.lowestTp)+"""</td>
+                <td style="text-align:center">"""+str(item.lowestPossibleTp)+"""</td>
+                <td style="text-align:center">"""+str(item.ourNlc)+"""</td>
+                <td style="text-align:center">"""+str(item.targetNlc)+"""</td>
+                <td style="text-align:center">"""+str(item.ourInventory)+"""</td>
+                <td style="text-align:center">"""+netInventory+"""</td>
+                <td style="text-align:center">"""+getOosString((itemSaleMap.get(item.item_id))[1])+"""</td>
+                </tr>"""
+    message+="""</tbody></table></body></html>"""
+    print message
+    mailServer = smtplib.SMTP("smtp.gmail.com", 587)
+    mailServer.ehlo()
+    mailServer.starttls()
+    mailServer.ehlo()
+    recipients = ['kshitij.sood@saholic.com']
+    #recipients = ['rajneesh.arora@saholic.com','rajveer.singh@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
+    msg = MIMEMultipart()
+    msg['Subject'] = "Snapdeal Lost Buy Box" + ' - ' + str(datetime.now())
+    msg['From'] = ""
+    msg['To'] = ",".join(recipients)
+    msg.preamble = "Snapdeal Lost Buy Box" + ' - ' + str(datetime.now())
+    html_msg = MIMEText(message, 'html')
+    msg.attach(html_msg)
+    mailServer.login("build@shop2020.in", "cafe@nes")
+    #mailServer.sendmail("cafe@nes", ['kshitij.sood@saholic.com'], msg.as_string())
+    mailServer.sendmail("cafe@nes", recipients, msg.as_string())
 def getOtherTp(snapdealDetails,val,spm):
     if val.parent_category==10011:
         commissionPercentage = spm.competitorCommissionAccessory
         sys.exit(1)
     itemInfo,spm= populateStuff(options.runType)
     cantCompete, buyBoxItems, competitive, \
     competitiveNoInventory, exceptionList, negativeMargin = decideCategory(itemInfo,spm)
     timestamp = datetime.now()
+    previousProcessingTimestamp = session.query(func.max(MarketPlaceHistory.timestamp)).filter(MarketPlaceHistory.source==7).one()
     exceptionItems = commitExceptionList(exceptionList,timestamp)
     cantComepeteItems = commitCantCompete(cantCompete,timestamp)
     buyBoxList = commitBuyBox(buyBoxItems,timestamp)
     competitiveItems = commitCompetitive(competitive,timestamp)
     competitiveNoInventoryItems = commitCompetitiveNoInventory(competitiveNoInventory,timestamp)
         writeReport(cantCompete, buyBoxItems, competitive, competitiveNoInventory, exceptionList, negativeMargin, previousAutoFav, nowAutoFav,timestamp, options.runType)
     else:
         writeReport(cantCompete, buyBoxItems, competitive, competitiveNoInventory, exceptionList, negativeMargin, None, None, timestamp, options.runType)
     commitPricing(successfulAutoDecrease,successfulAutoIncrease,timestamp)
     sendAutoPricingMail(successfulAutoDecrease,successfulAutoIncrease)
+    processLostBuyBoxItems(previousProcessingTimestamp[0],timestamp)
 if __name__ == '__main__':
     main()

Subversion Repositories SmartDukaan

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