Subversion Repositories SmartDukaan

Rev

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

Rev 17244 Rev 17245
Line 387... Line 387...
387 
    tbody=[]
 387 
    tbody=[]
388 
    rowtemplate="<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{6}</td><td>{7}</td></tr>"
 388 
    rowtemplate="<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{6}</td><td>{7}</td></tr>"
389 
    for offer in db.flSaleSnapshot.find().limit(61).sort("_id",-1):
 389 
    for offer in db.flSaleSnapshot.find().limit(61).sort("_id",-1):
390 
        approved = offer.get("approvedAmount")
 390 
        approved = offer.get("approvedAmount")
391 
        rejected = offer.get("rejectedAmount")
 391 
        rejected = offer.get("rejectedAmount")
392 
        sale = offer.get("paidAmount")
 392 
        sale = offer.get("subAmount")
393 
        total = approved + rejected
 393 
        total = approved + rejected
394 
        if total ==0:
 394 
        if total ==0:
395 
            continue
 395 
            continue
396 
        tbody.append(rowtemplate.format(offer.get("_id"), sale, approved, int((approved*100/total)), rejected, int((rejected*100/total)), int((sale-approved-rejected)*100/sale),int((approved)*100/sale)))
 396 
        tbody.append(rowtemplate.format(offer.get("_id"), sale, approved, int((approved*100/total)), rejected, int((rejected*100/total)), int((sale-approved-rejected)*100/sale),int((approved)*100/sale)))
397 
    message = mailBodyTemplate.format("".join(tbody))
 397 
    message = mailBodyTemplate.format("".join(tbody))
Line 862... Line 862...
862 
    global i
 862 
    global i
863 
    #worksheet1 = wb.add_sheet("Suspected Users")
 863 
    #worksheet1 = wb.add_sheet("Suspected Users")
864 
    workbook = xlwt.Workbook("ISO8859-1")
 864 
    workbook = xlwt.Workbook("ISO8859-1")
865 
    sh1 = workbook.add_sheet("All Orders")
 865 
    sh1 = workbook.add_sheet("All Orders")
866 
    sh2 = workbook.add_sheet("Flipkart Orders")
 866 
    sh2 = workbook.add_sheet("Flipkart Orders")
867 
    worksheet = workbook.add_sheet("All Users")
 867 
    #worksheet = workbook.add_sheet("All Users")
868
868
869 
    db=client.Dtr
 869 
    db=client.Dtr
870 
    prevDate = cutOff
 870 
    prevDate = cutOff
871 
    results = Mysql.fetchResult("select * from allorder where created_on > %s", prevDate)
 871 
    results = Mysql.fetchResult("select * from allorder where created_on > %s", prevDate)
872 
    row = 0
 872 
    row = 0
873 
    i=-1
 873 
    i=-1
874 
    worksheet.write(row, inc(), 'User Id', boldStyle)
 874 
#    worksheet.write(row, inc(), 'User Id', boldStyle)
875 
    worksheet.write(row, inc(), 'User name', boldStyle)
 875 
#    worksheet.write(row, inc(), 'User name', boldStyle)
876 
    worksheet.write(row, inc(), 'Order Id', boldStyle)
 876 
#    worksheet.write(row, inc(), 'Order Id', boldStyle)
877 
    worksheet.write(row, inc(), 'Created On', boldStyle)
 877 
#    worksheet.write(row, inc(), 'Created On', boldStyle)
878 
    worksheet.write(row, inc(), 'Store Id', boldStyle)
 878 
#    worksheet.write(row, inc(), 'Store Id', boldStyle)
879 
    worksheet.write(row, inc(), 'Merchant Order Id', boldStyle)
 879 
#    worksheet.write(row, inc(), 'Merchant Order Id', boldStyle)
880 
    worksheet.write(row, inc(), 'SubOrder Id', boldStyle)
 880 
#    worksheet.write(row, inc(), 'SubOrder Id', boldStyle)
881 
    worksheet.write(row, inc(), 'Product title', boldStyle)
 881 
#    worksheet.write(row, inc(), 'Product title', boldStyle)
882 
    worksheet.write(row, inc(), 'Amount Paid', boldStyle)
 882 
#    worksheet.write(row, inc(), 'Amount Paid', boldStyle)
883 
    worksheet.write(row, inc(), 'Cashback', boldStyle)
 883 
#    worksheet.write(row, inc(), 'Cashback', boldStyle)
884 
    worksheet.write(row, inc(), 'Order Status', boldStyle)
 884 
#    worksheet.write(row, inc(), 'Order Status', boldStyle)
885 
    worksheet.write(row, inc(), 'Detailed Status', boldStyle)
 885 
#    worksheet.write(row, inc(), 'Detailed Status', boldStyle)
886 
    worksheet.write(row, inc(), 'Cashback Status', boldStyle)
 886 
#    worksheet.write(row, inc(), 'Cashback Status', boldStyle)
887 
    worksheet.write(row, inc(), 'Reconciled', boldStyle)
 887 
#    worksheet.write(row, inc(), 'Reconciled', boldStyle)
888 
    worksheet.write(row, inc(), 'IP', boldStyle)
 888 
#    worksheet.write(row, inc(), 'IP', boldStyle)
889 
    worksheet.write(row, inc(), 'Aff Status', boldStyle)
 889 
#    worksheet.write(row, inc(), 'Aff Status', boldStyle)
890 
    i=-1
 890 
    i=-1
891 
    sh1.write(row, inc(), 'User Id', boldStyle)
 891 
    sh1.write(row, inc(), 'User Id', boldStyle)
892 
    sh1.write(row, inc(), 'User name', boldStyle)
 892 
    sh1.write(row, inc(), 'User name', boldStyle)
893 
    sh1.write(row, inc(), 'Order Id', boldStyle)
 893 
    sh1.write(row, inc(), 'Order Id', boldStyle)
894 
    sh1.write(row, inc(), 'Created On', boldStyle)
 894 
    sh1.write(row, inc(), 'Created On', boldStyle)
Line 948... Line 948...
948 
        column = 0
 948 
        column = 0
949 
        for data in r :
 949 
        for data in r :
950 
            sh1.write(row, column, int(data) if type(data) is float else data, datetime_format if type(data) is datetime else default_format)
 950 
            sh1.write(row, column, int(data) if type(data) is float else data, datetime_format if type(data) is datetime else default_format)
951 
            column += 1
 951 
            column += 1
952 
        i=-1
 952 
        i=-1
953 
        worksheet.write(row, inc(), r[0])
 953 
#        worksheet.write(row, inc(), r[0])
954 
        worksheet.write(row, inc(), r[1])
 954 
#        worksheet.write(row, inc(), r[1])
955 
        worksheet.write(row, inc(), r[2])
 955 
#        worksheet.write(row, inc(), r[2])
956 
        worksheet.write(row, inc(), r[3], datetime_format)
 956 
#        worksheet.write(row, inc(), r[3], datetime_format)
957 
        worksheet.write(row, inc(), r[4])
 957 
#        worksheet.write(row, inc(), r[4])
958 
        worksheet.write(row, inc(), r[5])
 958 
#        worksheet.write(row, inc(), r[5])
959 
        worksheet.write(row, inc(), r[23])
 959 
#        worksheet.write(row, inc(), r[23])
960 
        worksheet.write(row, inc(), r[8])
 960 
#        worksheet.write(row, inc(), r[8])
961 
        worksheet.write(row, inc(), r[10])
 961 
#        worksheet.write(row, inc(), r[10])
962 
        worksheet.write(row, inc(), r[25])
 962 
#        worksheet.write(row, inc(), r[25])
963 
        worksheet.write(row, inc(), r[6])
 963 
#        worksheet.write(row, inc(), r[6])
964 
        worksheet.write(row, inc(), r[7])
 964 
#        worksheet.write(row, inc(), r[7])
965 
        worksheet.write(row, inc(), r[24])
 965 
#        worksheet.write(row, inc(), r[24])
966
966
967 
    flipkartOrders = session.query(FlipkartOrders).order_by(FlipkartOrders.created.desc()).all()
 967 
    flipkartOrders = session.query(FlipkartOrders).order_by(FlipkartOrders.created.desc()).all()
968 
    flipkartOrders.reverse()
 968 
    flipkartOrders.reverse()
969 
    row3=0
 969 
    row3=0
970 
    #try:
 970 
    #try:
Line 1112... Line 1112...
1112 
            saleTime = datetime.strptime(order['placedOn'], "%a, %d %b, %Y").strftime("%Y-%m-%d")
 1112 
            saleTime = datetime.strptime(order['placedOn'], "%a, %d %b, %Y").strftime("%Y-%m-%d")
1113 
        except:
 1113 
        except:
1114 
            saleTime = datetime.strptime(order['placedOn'], "%b %d, %Y, %I:%M %p").strftime("%Y-%m-%d")
 1114 
            saleTime = datetime.strptime(order['placedOn'], "%b %d, %Y, %I:%M %p").strftime("%Y-%m-%d")
1115 
        print "%s\t%s\t%s\t%s"%(orderId, order['placedOn'], saleTime, order['paidAmount'])
 1115 
        print "%s\t%s\t%s\t%s"%(orderId, order['placedOn'], saleTime, order['paidAmount'])
1116 
        if not datemap.has_key(saleTime):
 1116 
        if not datemap.has_key(saleTime):
1117 
            datemap[saleTime] = {"totalAmount":0, "paidAmount":0, "rejectedAmount":0, "approvedAmount":0, "count":0}
 1117 
            datemap[saleTime] = {"totalAmount":0, "paidAmount":0, "rejectedAmount":0, "approvedAmount":0, "count":0, "subAmount":0}
1118
1118
1119 
        obj = datemap.get(saleTime)
 1119 
        obj = datemap.get(saleTime)
1120 
        obj['paidAmount'] += order["paidAmount"]
 1120 
        obj['paidAmount'] += order["paidAmount"]
- 
 
 1121 
        for so in order['subOrders']:
- 
 
 1122 
            obj['subAmount'] += int(so['amountPaid'])
1121 
        obj['count'] += 1
 1123 
        obj['count'] += 1
1122
1124
1123 
    for offer in db.snapdealOrderAffiliateInfo1.find({"saleDate":{"$gte":toTimeStamp(datetime.now() - timedelta(days=46))}}):
 1125 
    for offer in db.snapdealOrderAffiliateInfo1.find({"saleDate":{"$gte":toTimeStamp(datetime.now() - timedelta(days=46))}}):
1124 
        saleTime =  utils.fromTimeStamp(offer.get('saleDate')).strftime("%Y-%m-%d")
 1126 
        saleTime =  utils.fromTimeStamp(offer.get('saleDate')).strftime("%Y-%m-%d")
1125 
        obj = datemap.get(saleTime)
 1127 
        obj = datemap.get(saleTime)