| Line 201... |
Line 201... |
| 201 |
|
201 |
|
| 202 |
endDate = datetime.strftime(endDate, "%Y-%m-%d")
|
202 |
endDate = datetime.strftime(endDate, "%Y-%m-%d")
|
| 203 |
startDate = datetime.strftime(startDate, "%Y-%m-%d")
|
203 |
startDate = datetime.strftime(startDate, "%Y-%m-%d")
|
| 204 |
url = "https://affiliate-api.flipkart.net/affiliate/report/orders/detail/json?startDate=%s&endDate=%s&status=%s&offset=%s"
|
204 |
url = "https://affiliate-api.flipkart.net/affiliate/report/orders/detail/json?startDate=%s&endDate=%s&status=%s&offset=%s"
|
| 205 |
|
205 |
|
| 206 |
sum = 0
|
- |
|
| 207 |
for status in statuses:
|
206 |
for status in statuses:
|
| 208 |
offset=-1
|
207 |
offset=-1
|
| 209 |
while True:
|
208 |
while True:
|
| 210 |
offset += 1
|
209 |
offset += 1
|
| 211 |
reqUlrl = url%(startDate, endDate, status, offset)
|
210 |
reqUlrl = url%(startDate, endDate, status, offset)
|
| Line 215... |
Line 214... |
| 215 |
resp = urllib2.urlopen(req)
|
214 |
resp = urllib2.urlopen(req)
|
| 216 |
resString = json.loads(resp.read())
|
215 |
resString = json.loads(resp.read())
|
| 217 |
orderList = resString["orderList"]
|
216 |
orderList = resString["orderList"]
|
| 218 |
if orderList:
|
217 |
if orderList:
|
| 219 |
for order in orderList:
|
218 |
for order in orderList:
|
| 220 |
print order
|
- |
|
| 221 |
order['sales'] = int(order['sales']['amount'])
|
219 |
order['sales'] = int(order['sales']['amount'])
|
| 222 |
order['tentativeCommission'] = int(order['tentativeCommission']['amount'])
|
220 |
order['tentativeCommission'] = int(order['tentativeCommission']['amount'])
|
| 223 |
if order['status']!='failed':
|
- |
|
| 224 |
sum += order['tentativeCommission']
|
- |
|
| 225 |
self.db.flipkartOrderAffiliateInfo1.save(order)
|
- |
|
| 226 |
skuData = getSkuData(2, order.get("productCode"))
|
- |
|
| 227 |
if skuData is not None:
|
- |
|
| 228 |
order['catalogId'] = skuData.get("skuBundleId")
|
- |
|
| 229 |
order['brand'] = skuData.get("brand")
|
- |
|
| 230 |
order['model'] = skuData.get("model_name")
|
- |
|
| 231 |
order['category'] = categoryMap.get(skuData.get("category_id"))
|
- |
|
| 232 |
|
- |
|
| 233 |
|
- |
|
| 234 |
subTagId = order.get("affExtParam1")
|
221 |
subTagId = order.get("affExtParam1")
|
| 235 |
userId = None
|
222 |
userId = None
|
| 236 |
email = None
|
223 |
email = None
|
| 237 |
if subTagId:
|
224 |
if subTagId:
|
| 238 |
click = session.query(Clicks).filter_by(tag = subTagId).first()
|
225 |
click = session.query(Clicks).filter_by(tag = subTagId).first()
|
| Line 245... |
Line 232... |
| 245 |
flipkartOrder = FlipkartOrders()
|
232 |
flipkartOrder = FlipkartOrders()
|
| 246 |
flipkartOrder.subtagId = subTagId
|
233 |
flipkartOrder.subtagId = subTagId
|
| 247 |
flipkartOrder.user_id = userId
|
234 |
flipkartOrder.user_id = userId
|
| 248 |
flipkartOrder.identifier = order.get("identifier")
|
235 |
flipkartOrder.identifier = order.get("identifier")
|
| 249 |
flipkartOrder.email = email
|
236 |
flipkartOrder.email = email
|
| 250 |
flipkartOrder.created = datetime.strptime(order.get("orderDate"), "%m-%d-%Y")
|
237 |
flipkartOrder.created = datetime.strptime(order.get("orderDate"), "%d-%m-%Y")
|
| 251 |
flipkartOrder.status = order.get("status")
|
238 |
flipkartOrder.status = order.get("status")
|
| 252 |
flipkartOrder.title = order.get("title")
|
239 |
flipkartOrder.title = order.get("title")
|
| 253 |
flipkartOrder.price = order.get("price")
|
240 |
flipkartOrder.price = order.get("price")
|
| 254 |
flipkartOrder.quantity = order.get("quantity")
|
241 |
flipkartOrder.quantity = order.get("quantity")
|
| 255 |
flipkartOrder.productCode = order.get("productId")
|
242 |
flipkartOrder.productCode = order.get("productId")
|