WebSVN – SmartDukaan – Diff – /trunk/PyDTR/src/dtr/sources/amazon.py

                 soup = BeautifulSoup(rawHtml)
                 allOrders = soup.find(id="ordersContainer").findAll('div', {'class':'a-box-group a-spacing-base order'})
                 bulk = self.db.merchantOrder.initialize_ordered_bulk_op()
                 for activeOrder in activeOrders:
                     for orderEle in allOrders:
+                        deliveredOn = None
+                        deliveryEstimate = None
                         orderdiv = orderEle.find('div', {'class':'a-box a-color-offset-background order-info'}).find('div', {'class':'a-fixed-right-grid-col actions a-col-right'})
                         merchantOrderId = orderdiv.find('span', {'class':'a-color-secondary value'}).text.strip()
                         if merchantOrderId==activeOrder['merchantOrderId']:
                             closed = True
                             shipments = orderEle.findAll('div',{'class':re.compile('.*?a-box.*?')}, recursive=False)
                             shipments.pop(0)
                             for shipment in shipments:
                                 shipdiv = shipment.find('div', {'class':'a-box-inner'})
                                 sdivs = shipment.div.div.findAll('div', recursive=False)
+                                try:
+                                    orderStatus = sdivs[0].findAll('div')[1].div.text.strip()
+                                except:
-                                orderStatus = sdivs[0].findAll('div')[1].text.strip()
+                                    orderStatus = sdivs[0].findAll('div')[1].text.strip()
+                                print orderStatus
                                 status = self._getStatusFromDetailedStatus(orderStatus)
-#                                if status == MStore.ORDER_DELIVERED:
+                                if status == MStore.ORDER_DELIVERED:
-#                                    try:
-#                                        #getDateString(sdivs[0].span.text.strip().split("Delivered ")[1].strip())
+                                    dateString = sdivs[0].span.text.strip().split("Delivered ")[1].strip()
-#                                        deliveredOn = sdivs[0].findAll('span')[-1].text.strip()
+                                    deliveredOn = datetime.strftime(getDateStringDelivered(dateString), '%d-%b-%y')
-#                                        try:
+                                if status == MStore.ORDER_SHIPPED:
-#                                            deliveredOn = deliveredOn.split(":")[1].strip()
+                                    dateString = sdivs[0].span.text.strip().split("Arriving ")[1].strip()
-#                                        except:
-#                                            deliveredOn = ""
+                                    deliveryEstimate = datetime.strftime(getDateStringArriving(dateString), '%d-%b-%y')
-#                                    except:
-#                                        pass
-                                deliveryestimatespan = sdivs[0].find('span', {'class':'a-color-success'})
+#                                deliveryestimatespan = sdivs[0].find('span', {'class':'a-color-success'})
-                                deliveryEstimate = None
+#                                deliveryEstimate = None
-                                if deliveryestimatespan is not None:
+#                                if deliveryestimatespan is not None:
-                                    deliveryEstimate = deliveryestimatespan.find('span', {'class':'a-text-bold'}).text.strip()
+#                                    deliveryEstimate = deliveryestimatespan.find('span', {'class':'a-text-bold'}).text.strip()
                                 productDivs = shipdiv.find('div', {'class':re.compile('.*?a-spacing-top-medium.*?')}).find('div', {'class':'a-row'}).findAll('div', recursive=False)
                                 trackingUrl = None
                                 for buttonDiv in shipdiv.findAll('span', {'class':'a-button-inner'}):
                                     if buttonDiv.find('a').text.strip()=='Track package':
                                         trackingUrl = buttonDiv.find('a')['href'].strip()
                                             updateMap['subOrders.$.detailedStatus'] = status
                                             cashbackStatus = subOrder.get("cashBackStatus")
                                             updateMap['subOrders.$.status'] = status
                                             if status==MStore.ORDER_DELIVERED:
-#                                                if not deliveredOn:
+                                                if not deliveredOn:
-#                                                    updateMap['subOrders.$.deliveredOn'] = deliveredOn
+                                                    updateMap['subOrders.$.deliveredOn'] = deliveredOn
                                                 closedStatus = True
                                                 updateMap['subOrders.$.closed'] = True
                                                 if cashbackStatus == Store.CB_PENDING:
                                                     updateMap['subOrders.$.cashBackStatus'] = Store.CB_APPROVED
                                             if status==MStore.ORDER_CANCELLED:
                                                 closedStatus = True
                                                 updateMap['subOrders.$.closed'] = True
                                                 if cashbackStatus == Store.CB_PENDING:
                                                     updateMap['subOrders.$.cashBackStatus'] = Store.CB_CANCELLED
                                             if status==MStore.ORDER_SHIPPED:
+                                                if deliveryEstimate:
-                                                updateMap['subOrders.$.estimatedDeliveryDate'] = deliveryEstimate
+                                                    updateMap['subOrders.$.estimatedDeliveryDate'] = deliveryEstimate
                                                 if trackingUrl is not None:
                                                     updateMap['subOrders.$.trackingUrl'] = trackingUrl
                                             if not closedStatus:
                                                 closed = False
                                             bulk.find(findMap).update({'$set' : updateMap})
     #parseDetailNotCreated()
     #parseOrderNotCreated()
     for userId in store.db.merchantOrder.find({"storeId":1, "subOrders.closed":False}).distinct("userId"):
         userId = int(userId)
         directory = "/AmazonTrack/User" + str(userId) + "/"
-        summaryFile=getSummaryFile(directory)
+        summaryFile="orderSummary13-10:14:41:55"
         if summaryFile is None:
             print "No summary for", userId
         else:
             print userId, directory+summaryFile
             store.trackOrdersForUser(userId, 'https://www.amazon.in/gp/css/order-history', readSSh(directory + summaryFile))
     finally:
         session.close()
 def getDateStringDelivered(dateString='Monday'):
-    #print datetime.strftime(dateMin,"%d-%b-%y")
+    print dateString
     if dateString.lower()=='today':
         return date.today()
     if dateString.lower()=='yesterday':
         return date.today() - timedelta(days=1)
     try:
             #get Closest Date from today
             curDate = date.today()
             curTime = datetime(curDate.year, curDate.month, curDate.day)
             curYear = curDate.year
             prevYear = curYear - 1
-            dateMax = datetime.strptime(dateString + " " + str(curYear), "%A,%d %b %Y")
+            dateMax = datetime.strptime(dateString + " " + str(curYear), "%A, %d %b %Y")
-            dateMin = datetime.strptime(dateString + " " + str(prevYear), "%A,%d %b %Y")
+            dateMin = datetime.strptime(dateString + " " + str(prevYear), "%A, %d %b %Y")
             if dateMax <= curTime:
                 return dateMax
             else:
                 return dateMin
         except:
+            try:
-            days_of_week = ['sunday','monday','tuesday','wednesday',
+                days_of_week = ['sunday','monday','tuesday','wednesday',
-                        'thursday','friday','saturday']
+                            'thursday','friday','saturday']
-            deltaDays = curDate.isoweekday() - days_of_week.index(dateString.lower())
+                deltaDays = curDate.isoweekday() - days_of_week.index(dateString.lower())
-            if deltaDays <= 0:
+                if deltaDays <= 0:
-                deltaDays= deltaDays + 7
+                    deltaDays= deltaDays + 7
-            curDate = curDate - timedelta(days=deltaDays)
+                curDate = curDate - timedelta(days=deltaDays)
-            print datetime.strftime(curDate, '%d-%b-%y')
+                print datetime.strftime(curDate, '%d-%b-%y')
+                return curDate
+            except:
+                print "could not parse"
+                return None
+def getDateStringArriving(dateString='Thursday'):
+    print dateString
+    if dateString.lower()=='today':
+        return date.today()
+    if dateString.lower()=='tomorrow':
+        return date.today() + timedelta(days=1)
+    try:
+        return datetime.strptime(dateString, '%d-%b-%y')
+    except:
+        try:
+            #get Closest Date from today
+            curDate = date.today()
+            curTime = datetime(curDate.year, curDate.month, curDate.day)
+            curYear = curDate.year
+            nextYear = curYear + 1
+            dateMin = datetime.strptime(dateString + " " + str(curYear), "%A, %d %b %Y")
+            dateMax = datetime.strptime(dateString + " " + str(nextYear), "%A, %d %b %Y")
+            if dateMin >= curTime:
+                return dateMin
+            else:
+                return dateMax
+        except:
+            try:
+                days_of_week = ['sunday','monday','tuesday','wednesday',
+                            'thursday','friday','saturday']
+                deltaDays = days_of_week.index(dateString.lower()) - curDate.isoweekday()
+                if deltaDays < 0:
+                    deltaDays= deltaDays + 7
+                curDate = curDate + timedelta(days=deltaDays)
-            return curDate
+                return curDate
+            except:
+                print "Could not parse"
+                return None
 def parseOrderNotCreated():
     try:
         store=getStore(1)
         orders = session.query(OrdersRaw).filter_by(status='ORDER_NOT_CREATED_UNKNOWN').all()
     finally:
         session.close()
 if __name__ == '__main__':
-        main()
         main()
+        #getDateStringArriving()

Subversion Repositories SmartDukaan

(root)/trunk/PyDTR/src/dtr/sources/amazon.py – Rev 17253 → 17254