Subversion Repositories SmartDukaan

Rev

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

Rev 16027 Rev 16637
Line 2... Line 2...
2 
import xlwt
 2 
import xlwt
3 
from datetime import datetime
 3 
from datetime import datetime
4 
from email.mime.multipart import MIMEMultipart
 4 
from email.mime.multipart import MIMEMultipart
5 
import email.encoders
 5 
import email.encoders
6 
import smtplib
 6 
import smtplib
- 
 
 7 
import traceback
7 
 
 8 
 
8 
con = None
 9 
con = None
9 
 
 10 
 
10 
statusMap = {1:'Active',2:'EOL',3:'In Process',4:'Exclusive'}
 11 
statusMap = {1:'Active',2:'EOL',3:'In Process',4:'Exclusive'}
11 
 
 12 
 
Line 52... Line 53...
52 
    data = get_mongo_connection().Catalog.Deals.find().sort([('totalPoints',pymongo.DESCENDING)])
 53 
    data = get_mongo_connection().Catalog.Deals.find().sort([('totalPoints',pymongo.DESCENDING)])
53 
    print data.count()
 54 
    print data.count()
54 
    for x in data:
 55 
    for x in data:
55 
        if x['source_id'] == 5 and x['rank'] ==0:
 56 
        if x['source_id'] == 5 and x['rank'] ==0:
56 
            continue
 57 
            continue
- 
 
 58 
        try:
57 
        s_info = __SkuInfo(x['_id'], x['skuBundleId'], x['category_id'],x['mrp'],x['available_price'],x['source_id'],x['rank'],x['maxNlc'], \
 59 
            s_info = __SkuInfo(x['_id'], x['skuBundleId'], x['category_id'],x['mrp'],x['available_price'],x['source_id'],x['rank'],x['maxNlc'], \
58 
                           x['minNlc'], x['schemeAmount'],x['minDiscount'],x['maxDiscount'],x['discountType'],x['dp'],x['nlcPoints'],x['bestSellerPoints'], \
 60 
                               x['minNlc'], x['schemeAmount'],x['minDiscount'],x['maxDiscount'],x['discountType'],x['dp'],x['nlcPoints'],x['bestSellerPoints'], \
59 
                           x['totalPoints'],x['in_stock'],x['maxprice'],x['showDeal'],x['catalogBestSellerPoints'],x['prepaidDeal'])
 61 
                               x['totalPoints'],x['in_stock'],x['maxprice'],x['showDeal'],x['catalogBestSellerPoints'],x['prepaidDeal'])
- 
 
 62 
        except:
- 
 
 63 
            print 'Error Comes for Sku Id :- ', x['_id']
- 
 
 64 
            print traceback.print_exc()
60 
        p.append(s_info)
 65 
        p.append(s_info)
61
66
62 
    wbk = xlwt.Workbook()
 67 
    wbk = xlwt.Workbook()
63 
    sheet = wbk.add_sheet('Deals')
 68 
    sheet = wbk.add_sheet('Deals')
64 
    xstr = lambda s: s or ""
 69 
    xstr = lambda s: s or ""