Subversion Repositories SmartDukaan

Rev

Rev 15576 | Rev 15578 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 15576 Rev 15577
Line 238... Line 238...
238 
    affNotReconciledSheet = workbook.add_sheet("Snapdeal Aff not reconciled")
 238 
    affNotReconciledSheet = workbook.add_sheet("Snapdeal Aff not reconciled")
239 
    setHeaders(worksheet, worksheet1, worksheet2, affNotReconciledSheet)
 239 
    setHeaders(worksheet, worksheet1, worksheet2, affNotReconciledSheet)
240 
    row = 0
 240 
    row = 0
241 
    anotherrow = 0
 241 
    anotherrow = 0
242 
    row2 = 0
 242 
    row2 = 0
- 
 
 243 
    row5=0
243 
    for row1 in curs:
 244 
    for row1 in curs:
244 
        orderId = row1[0]
 245 
        orderId = row1[0]
245 
        order = db.merchantOrder.find_one({"orderId":orderId})
 246 
        order = db.merchantOrder.find_one({"orderId":orderId})
246 
        if order is None:
 247 
        if order is None:
247 
            continue
 248 
            continue
Line 337... Line 338...
337 
                worksheet1.write(anotherrow, inc(), subOrder['amountPaid'])
 338 
                worksheet1.write(anotherrow, inc(), subOrder['amountPaid'])
338 
                worksheet1.write(anotherrow, inc(), subOrder['quantity'])
 339 
                worksheet1.write(anotherrow, inc(), subOrder['quantity'])
339 
                worksheet1.write(anotherrow, inc(), subOrder['status'])
 340 
                worksheet1.write(anotherrow, inc(), subOrder['status'])
340 
                worksheet1.write(anotherrow, inc(), subOrder['cashBackStatus'])
 341 
                worksheet1.write(anotherrow, inc(), subOrder['cashBackStatus'])
341 
                worksheet1.write(anotherrow, inc(), subOrder['cashBackAmount'])
 342 
                worksheet1.write(anotherrow, inc(), subOrder['cashBackAmount'])
- 
 
 343 
            row5 += 1
- 
 
 344 
            i=-1
- 
 
 345 
            worksheet2.write(row5, inc(), order["orderId"])
- 
 
 346 
            worksheet2.write(row5, inc(), row1[1])
- 
 
 347 
            worksheet2.write(row5, inc(), row1[-1])
- 
 
 348 
            worksheet2.write(row5, inc(), row1[-2])
- 
 
 349 
            worksheet2.write(row5, inc(), row1[-3])
- 
 
 350 
            worksheet2.write(row5, inc(), order['merchantOrderId'])
- 
 
 351 
            worksheet2.write(row5, inc(), order['subTagId'])
- 
 
 352 
            worksheet2.write(row5, inc(), order['placedOn'])
- 
 
 353 
            worksheet2.write(row5, inc(), formattedTimestamp)
- 
 
 354 
            worksheet2.write(row5, inc(), int(order['paidAmount']))
- 
 
 355 
            row5 -=1
342 
 
 356 
            k=i
- 
 
 357 
            for subOrder in order['subOrders']:
- 
 
 358 
                i = k
- 
 
 359 
                row2 += 1
- 
 
 360 
                worksheet2.write(row5, inc(), subOrder['productTitle'])
- 
 
 361 
                worksheet2.write(row5, inc(), subOrder['amountPaid'])
- 
 
 362 
                worksheet2.write(row5, inc(), subOrder['quantity'])
- 
 
 363 
                worksheet2.write(row5, inc(), subOrder['status'])
- 
 
 364 
                worksheet2.write(row5, inc(), subOrder['cashBackStatus'])
- 
 
 365 
                worksheet2.write(row2, inc(), subOrder['cashBackAmount'])
343
366
344 
    last30Days =  date.today() - timedelta(days=30)
 367 
    last30Days =  date.today() - timedelta(days=30)
345 
    int(time.mktime(last30Days.timetuple()))
 368 
    int(time.mktime(last30Days.timetuple()))
346 
    row = 0
 369 
    row = 0
347 
    for offer in db.snapdealOrderAffiliateInfo.find({"reconciled":{"$exists":False},
370 
    for offer in db.snapdealOrderAffiliateInfo.find({"reconciled":{"$exists":False},
Line 363... Line 386...
363 
                    db.snapdealOrderAffiliateInfo.update({"adId":offer.get("adId")}, {"$set":{"reconciled":True, "orderId":order[0]}}, multi=True)
 386 
                    db.snapdealOrderAffiliateInfo.update({"adId":offer.get("adId")}, {"$set":{"reconciled":True, "orderId":order[0]}}, multi=True)
364 
                    db.merchantOrder.update({"orderId":order[0]}, {"$set":{"reconciled":True, "adId":offer.get("adId")}}, multi=True)
 387 
                    db.merchantOrder.update({"orderId":order[0]}, {"$set":{"reconciled":True, "adId":offer.get("adId")}}, multi=True)
365 
                    break
 388 
                    break
366 
 
 389 
 
367 
    unreconciledOrders = notReconciled.keys()
 390 
    unreconciledOrders = notReconciled.keys()
368 
    row2=0
 391 
 
369 
    for row1 in curs:
 - 
 
370 
        if row1[0] in unreconciledOrders:
 - 
 
371 
            for order in db.merchantOrder.find({"orderId":row1[0]}):
 - 
 
372 
                row2 += 1
 - 
 
373 
                i=-1
 - 
 
374 
                worksheet2.write(row2, inc(), order["orderId"])
 - 
 
375 
                worksheet2.write(row2, inc(), row1[1])
 - 
 
376 
                worksheet2.write(row2, inc(), row1[-1])
 - 
 
377 
                worksheet2.write(row2, inc(), row1[-2])
 - 
 
378 
                worksheet2.write(row2, inc(), row1[-3])
 - 
 
379 
                worksheet2.write(row2, inc(), order['merchantOrderId'])
 - 
 
380 
                worksheet2.write(row2, inc(), order['subTagId'])
 - 
 
381 
                worksheet2.write(row2, inc(), order['placedOn'])
 - 
 
382 
                worksheet2.write(row2, inc(), formattedTimestamp)
 - 
 
383 
                worksheet2.write(row2, inc(), int(order['paidAmount']))
 - 
 
384 
                row2 -=1
 - 
 
385 
                k=i
 - 
 
386 
                for subOrder in order['subOrders']:
 - 
 
387 
                    i = k
 - 
 
388 
                    row2 += 1
 - 
 
389 
                    worksheet2.write(row2, inc(), subOrder['productTitle'])
 - 
 
390 
                    worksheet2.write(row2, inc(), subOrder['amountPaid'])
 - 
 
391 
                    worksheet2.write(row2, inc(), subOrder['quantity'])
 - 
 
392 
                    worksheet2.write(row2, inc(), subOrder['status'])
 - 
 
393 
                    worksheet2.write(row2, inc(), subOrder['cashBackStatus'])
 - 
 
394 
                    worksheet2.write(row2, inc(), subOrder['cashBackAmount'])
 - 
 
395
392
396
393
397 
    for offer in db.snapdealOrderAffiliateInfo.find({"reconciled":{"$exists":False},
394 
    for offer in db.snapdealOrderAffiliateInfo.find({"reconciled":{"$exists":False},
398 
                                                     "saleTime":{"$gt":int(time.mktime(last30Days.timetuple())),
 395 
                                                     "saleTime":{"$gt":int(time.mktime(last30Days.timetuple())),
399 
                                                                 "$lt":int(time.mktime(date.today().timetuple()))}} ):
 396 
                                                                 "$lt":int(time.mktime(date.today().timetuple()))}} ):