| Line 323... |
Line 323... |
| 323 |
shipmentDivs = orderDetailsContainer.find('div', class_='shipment').findAll('div', recursive = False)
|
323 |
shipmentDivs = orderDetailsContainer.find('div', class_='shipment').findAll('div', recursive = False)
|
| 324 |
subOrders = []
|
324 |
subOrders = []
|
| 325 |
merchantOrder.subOrders = subOrders
|
325 |
merchantOrder.subOrders = subOrders
|
| 326 |
closedStatus = True
|
326 |
closedStatus = True
|
| 327 |
for shipmentDiv in shipmentDivs:
|
327 |
for shipmentDiv in shipmentDivs:
|
| - |
|
328 |
try:
|
| - |
|
329 |
trackingUrl = 'http://www.amazon.in/' + shipmentDiv.find('span', class_='track-package-button').span.a.get('href')
|
| - |
|
330 |
except:
|
| - |
|
331 |
trackingUrl= None
|
| - |
|
332 |
|
| 328 |
deliverySpanTop = None
|
333 |
deliverySpanTop = None
|
| 329 |
innerBoxes = shipmentDiv.findAll('div', recursive = False)
|
334 |
innerBoxes = shipmentDiv.findAll('div', recursive = False)
|
| 330 |
statusDiv = innerBoxes[0]
|
335 |
statusDiv = innerBoxes[0]
|
| 331 |
subOrderStatus = statusDiv.div.span.text.strip()
|
336 |
subOrderStatus = statusDiv.div.span.text.strip()
|
| 332 |
try:
|
337 |
try:
|
| Line 374... |
Line 379... |
| 374 |
|
379 |
|
| 375 |
createdOn = datetime.fromtimestamp(merchantOrder.createdOnInt)
|
380 |
createdOn = datetime.fromtimestamp(merchantOrder.createdOnInt)
|
| 376 |
subOrder.trackAfter = int(time.mktime(max(estDlvyTime-timedelta(days=4),createdOn + timedelta(days=3)).timetuple()))
|
381 |
subOrder.trackAfter = int(time.mktime(max(estDlvyTime-timedelta(days=4),createdOn + timedelta(days=3)).timetuple()))
|
| 377 |
subOrder.detailedStatus = subOrderStatus
|
382 |
subOrder.detailedStatus = subOrderStatus
|
| 378 |
subOrder.deliveryCharges = shippingPrice
|
383 |
subOrder.deliveryCharges = shippingPrice
|
| - |
|
384 |
if trackingUrl:
|
| - |
|
385 |
subOrder.tracingkUrl = trackingUrl
|
| 379 |
subOrder.imgUrl = imgDiv.img["src"]
|
386 |
subOrder.imgUrl = imgDiv.img["src"]
|
| 380 |
(cashbackAmount, percentage) = self.getCashbackAmount(subOrder.productCode, amountPaid)
|
387 |
(cashbackAmount, percentage) = self.getCashbackAmount(subOrder.productCode, amountPaid)
|
| 381 |
dealRank = getDealRank(subOrder.productCode, self.store_id, merchantOrder.userId)
|
388 |
dealRank = getDealRank(subOrder.productCode, self.store_id, merchantOrder.userId)
|
| 382 |
subOrder.dealRank = dealRank.get('rank')
|
389 |
subOrder.dealRank = dealRank.get('rank')
|
| 383 |
subOrder.rankDesc = dealRank.get('description')
|
390 |
subOrder.rankDesc = dealRank.get('description')
|
| Line 736... |
Line 743... |
| 736 |
#process_rejects("/home/amit/Downloads/RejectCashbackTemplate.xlsx")
|
743 |
#process_rejects("/home/amit/Downloads/RejectCashbackTemplate.xlsx")
|
| 737 |
#str1 = readSSh("/AmazonTrack/User2466/orderSummary28-06:13:25:08")
|
744 |
#str1 = readSSh("/AmazonTrack/User2466/orderSummary28-06:13:25:08")
|
| 738 |
#readSSh("/tmp/User2/404-2225153-7073122")
|
745 |
#readSSh("/tmp/User2/404-2225153-7073122")
|
| 739 |
#for orderId, trackingUrl in all.iteritems():
|
746 |
#for orderId, trackingUrl in all.iteritems():
|
| 740 |
store = getStore(1)
|
747 |
store = getStore(1)
|
| 741 |
#store.parseOrderRawHtml(46328, '3442342424334346', 9722, readSSh("/home/amit/46328"), "https://www.amazon.in/gp/css/summary/edit.html?orderID=403-4276089-1251522")
|
748 |
store.parseOrderRawHtml(46328, '3442342424334346', 9722, readSSh("/home/amit/46328"), "https://www.amazon.in/gp/css/summary/edit.html?orderID=403-4276089-1251522")
|
| 742 |
# print store.parseTrackingUrl(trackingUrl, orderId)
|
749 |
# print store.parseTrackingUrl(trackingUrl, orderId)
|
| 743 |
#store.scrapeStoreOrders()
|
750 |
#store.scrapeStoreOrders()
|
| 744 |
# store.scrapeStoreOrders()
|
751 |
# store.scrapeStoreOrders()
|
| 745 |
#store.parseInfo()
|
752 |
#store.parseInfo()
|
| 746 |
#store.trackOrdersForUser(4355, "", readSSh("~/4355"))
|
753 |
#store.trackOrdersForUser(4355, "", readSSh("~/4355"))
|
| Line 756... |
Line 763... |
| 756 |
# print "No summary for", userId
|
763 |
# print "No summary for", userId
|
| 757 |
# else:
|
764 |
# else:
|
| 758 |
# print userId, directory+summaryFile
|
765 |
# print userId, directory+summaryFile
|
| 759 |
# store.trackOrdersForUser(userId, 'https://www.amazon.in/gp/css/order-history', readSSh(directory + summaryFile))
|
766 |
# store.trackOrdersForUser(userId, 'https://www.amazon.in/gp/css/order-history', readSSh(directory + summaryFile))
|
| 760 |
#"storeId":1, "status":"parse_failed", "subOrders":{"$exists":False}
|
767 |
#"storeId":1, "status":"parse_failed", "subOrders":{"$exists":False}
|
| 761 |
for order in store.db.merchantOrder.find({}):
|
768 |
for order in store.db.merchantOrder.find({"subOrders":{"$exists":True}, "subOrders.trackingUrl":{"$exists":False}}):
|
| 762 |
try:
|
769 |
try:
|
| 763 |
orderId=order.get("orderId")
|
770 |
orderId=order.get("orderId")
|
| 764 |
o = session.query(OrdersRaw).filter_by(id = orderId).one()
|
771 |
o = session.query(OrdersRaw).filter_by(id = orderId).one()
|
| 765 |
print orderId
|
- |
|
| 766 |
if order.get("status")=="success" and o.status!='DETAIL_CREATED':
|
- |
|
| 767 |
o.status='DETAIL_CREATED'
|
- |
|
| 768 |
o.order_url = order.get("orderTrackingUrl")
|
- |
|
| 769 |
print o.status
|
- |
|
| 770 |
session.commit()
|
- |
|
| 771 |
if order.get('status')=="html_required" and (o.status != 'ORDER_CREATED'):
|
- |
|
| 772 |
o.status='ORDER_CREATED'
|
- |
|
| 773 |
print o.status
|
- |
|
| 774 |
session.commit()
|
- |
|
| 775 |
if order.get('status')=="parse_failed" and (o.status != 'DETAIL_NOT_CREATED_UNKNOWN'):
|
- |
|
| 776 |
o.status='DETAIL_NOT_CREATED_UNKNOWN'
|
- |
|
| 777 |
print o.status
|
- |
|
| 778 |
session.commit()
|
- |
|
| 779 |
if order.get('status')=="cancelled" and (o.status != 'ORDER_CANCELLED'):
|
- |
|
| 780 |
o.status='ORDER_CANCELLED'
|
- |
|
| 781 |
print o.status
|
- |
|
| 782 |
session.commit()
|
- |
|
| 783 |
#store.parseOrderRawHtml(o.id, o.sub_tag, o.user_id, o.rawhtml, order['orderTrackingUrl'])
|
772 |
store.parseOrderRawHtml(o.id, o.sub_tag, o.user_id, o.rawhtml, order['orderTrackingUrl'])
|
| 784 |
except:
|
773 |
except:
|
| 785 |
print "Could not parse", orderId
|
774 |
print "Could not parse", orderId
|
| 786 |
finally:
|
775 |
finally:
|
| 787 |
session.close()
|
776 |
session.close()
|
| 788 |
#store.trackOrdersForUser(8703, 'https://www.amazon.in/gp/css/order-history', readSSh('/home/amit/Downloads/orderSummary06-10_12_15_54'))
|
777 |
#store.trackOrdersForUser(8703, 'https://www.amazon.in/gp/css/order-history', readSSh('/home/amit/Downloads/orderSummary06-10_12_15_54'))
|