Subversion Repositories SmartDukaan

Rev

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

Rev 17008 Rev 17010
Line 400... Line 400...
400 
                    del notReconciled[order[0]]
 400 
                    del notReconciled[order[0]]
401 
                    print "found match for user", order[1]
 401 
                    print "found match for user", order[1]
402 
                    db.snapdealOrderAffiliateInfo.update({"adId":offer.get("adId")}, {"$set":{"reconciled":True, "orderId":order[0]}}, multi=True)
 402 
                    db.snapdealOrderAffiliateInfo.update({"adId":offer.get("adId")}, {"$set":{"reconciled":True, "orderId":order[0]}}, multi=True)
403 
                    db.merchantOrder.update({"orderId":order[0]}, {"$set":{"reconciled":True, "adId":offer.get("adId")}}, multi=True)
 403 
                    db.merchantOrder.update({"orderId":order[0]}, {"$set":{"reconciled":True, "adId":offer.get("adId")}}, multi=True)
404 
                    break
 404 
                    break
405 
 
 - 
 
406 
    unreconciledOrders = notReconciled.keys()
 405
407 
 
 - 
 
408
406
409
407
410 
    for offer in db.snapdealOrderAffiliateInfo.find({"reconciled":{"$exists":False},
408 
    for offer in db.snapdealOrderAffiliateInfo.find({"reconciled":{"$exists":False},
411 
                                                     "saleTime":{"$gt":int(time.mktime(last30Days.timetuple())),
 409 
                                                     "saleTime":{"$gt":int(time.mktime(last30Days.timetuple())),
412 
                                                                 "$lt":int(time.mktime(date.today().timetuple()))}} ):
 410 
                                                                 "$lt":int(time.mktime(date.today().timetuple()))}} ):
Line 418... Line 416...
418 
        affNotReconciledSheet.write(row, inc(), offer.get("saleAmount"))
416 
        affNotReconciledSheet.write(row, inc(), offer.get("saleAmount"))
419 
        affNotReconciledSheet.write(row, inc(), offer.get("payOut"))
417 
        affNotReconciledSheet.write(row, inc(), offer.get("payOut"))
420 
        affNotReconciledSheet.write(row, inc(), offer.get("conversionStatus"))
 418 
        affNotReconciledSheet.write(row, inc(), offer.get("conversionStatus"))
421 
        affNotReconciledSheet.write(row, inc(), offer.get("ip"))
 419 
        affNotReconciledSheet.write(row, inc(), offer.get("ip"))
422
420
423
- 
 
424 
    message=""
 - 
 
425 
#    mailBodyTemplate="""
 421 
    mailBodyTemplate="""
426 
#        <html>
 422 
        <html>
427 
#            <body>
 423 
            <body>
428 
#            <table cellspacing="0" border="1" style="text-align:right">
 424 
            <table cellspacing="0" border="1" style="text-align:right">
429 
#                <thead>
 425 
                <thead>
430 
#                    <tr>
 426 
                    <tr>
431 
#                        <th style="text-align:center">Date</th>
 427 
                        <th style="text-align:center">Date</th>
432 
#                        <th  style="text-align:center">Sale</th>
 428 
                        <th  style="text-align:center">Sale</th>
433 
#                        <th  style="text-align:center">Approved</th>
 429 
                        <th  style="text-align:center">Approved</th>
- 
 
 430 
                        <th  style="text-align:center">Approved %</th>
434 
#                        <th  style="text-align:center">Rejected</th>
 431 
                        <th  style="text-align:center">Rejected</th>
- 
 
 432 
                        <th  style="text-align:center">Rejected %</th>
435 
#                    </tr>
 433 
                    </tr>
436 
#                </thead>
 434 
                </thead>
437 
#                <tbody>
 435 
                <tbody>
438 
#                    {0}
 436 
                    {0}
439 
#                </tbody>
 437 
                </tbody>
440 
#            </table>
 438 
            </table>
441 
#            </body>
 439 
            </body>
442 
#        </html>
 440 
        </html>
443 
#    """
 441 
    """
444 
#    tbody=[]
 442 
    tbody=[]
445 
#    rowtemplate="<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td></tr>"
 443 
    rowtemplate="<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td></tr>"
446 
#    for offer in db.flSaleSnapshot.find({}):
 444 
    for offer in db.flSaleSnapshot.find().limit(61).sort("_id",-1):
- 
 
 445 
        approved = offer.get("approvedAmount")
- 
 
 446 
        rejected = offer.get("rejectedAmount")
- 
 
 447 
        total = approved + rejected
- 
 
 448 
        if total ==0:
- 
 
 449 
            continue
447 
#        tbody.append(rowtemplate.format(offer.get("_id"), offer.get("paidAmount"), offer.get("saleAmount"), offer.get("rejectedAmount")))
 450 
        tbody.append(rowtemplate.format(offer.get("_id"), offer.get("paidAmount"), approved, int((approved*100/total)), rejected, int((rejected*100/total))))
448 
#    message = mailBodyTemplate.format("".join(tbody))
 451 
    message = mailBodyTemplate.format("".join(tbody))
449 
    workbook.save(XLS_FILENAME)
 452 
    workbook.save(XLS_FILENAME)
450
- 
 
451 
    return message
 453 
    return message
452
454
- 
 
 455
453 
def generateShopcluesReco():
 456 
def generateShopcluesReco():
454 
    global i
 457 
    global i
455 
    curs = getOrdersAfterDate(datetime.now() - timedelta(days=30), 5)
 458 
    curs = getOrdersAfterDate(datetime.now() - timedelta(days=30), 5)
456 
    db = client.Dtr
 459 
    db = client.Dtr
457 
    notReconciled = {}
 460 
    notReconciled = {}
Line 1081... Line 1084...
1081 
    for key,valmap in  datemap.iteritems():
 1084 
    for key,valmap in  datemap.iteritems():
1082 
        valmap['_id'] = key
 1085 
        valmap['_id'] = key
1083 
        db.flSaleSnapshot.save(valmap)
 1086 
        db.flSaleSnapshot.save(valmap)
1084 
 
 1087 
 
1085 
if __name__ == '__main__':
 1088 
if __name__ == '__main__':
1086 
    #info = client.Dtr.flipkartOrderAffiliateInfo.find()
 - 
 
1087 
    #print info
 1089 
    main2()
1088 
    main()
 1090 
    main()
- 
 
 1091 
 
1089
1092
1090 

            1093