Subversion Repositories SmartDukaan

Rev

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

Rev 17547 Rev 18432
Line 6... Line 6...
6 
from dtr.storage.DataService import brand_preferences, user_actions, price_preferences
 6 
from dtr.storage.DataService import brand_preferences, user_actions, price_preferences
7 
from email.mime.multipart import MIMEMultipart
 7 
from email.mime.multipart import MIMEMultipart
8 
import email.encoders
 8 
import email.encoders
9 
import smtplib
 9 
import smtplib
10 
from datetime import datetime
 10 
from datetime import datetime
- 
 
 11 
from dtr.utils.utils import statusMap
11 
 
 12 
 
12 
mc = MemCache()
 13 
mc = MemCache()
13 
con =None
 14 
con =None
14 
DataService.initialize(db_hostname='localhost')
 15 
DataService.initialize(db_hostname='localhost')
15 
 
 16 
 
Line 200... Line 201...
200 
        elif x.category_id == 6:
 201 
        elif x.category_id == 6:
201 
            category = 'Accessories'
 202 
            category = 'Accessories'
202 
        sheet.write(it, 2, category)
 203 
        sheet.write(it, 2, category)
203 
        sheet.write(it, 3, y[0]['brand'])
 204 
        sheet.write(it, 3, y[0]['brand'])
204 
        sheet.write(it, 4, y[0]['product_name'])
 205 
        sheet.write(it, 4, y[0]['product_name'])
205 
        if y[0]['status'] ==1:
 - 
 
206 
            sheet.write(it, 5, 'Active')
 206 
        sheet.write(it, 5, statusMap.get(y[0]['status']))
207 
        else:
 - 
 
208 
            sheet.write(it, 5, 'EOL')
 - 
 
209 
        if y[0]['in_stock'] ==1:
 207 
        if y[0]['in_stock'] ==1:
210 
            sheet.write(it, 6, 'In Stock')
 208 
            sheet.write(it, 6, 'In Stock')
211 
        else:
 209 
        else:
212 
            sheet.write(it, 6, 'Out Of Stock')
 210 
            sheet.write(it, 6, 'Out Of Stock')
213 
        sheet.write(it, 7, y[0]['source'])
 211 
        sheet.write(it, 7, y[0]['source'])
214 
        sheet.write(it, 8, y[0]['identifier'])
 212 
        sheet.write(it, 8, y[0]['identifier'])
215 
        sheet.write(it, 9, y[0]['secondaryIdentifier'])
 213 
        sheet.write(it, 9, y[0]['secondaryIdentifier'])
216 
        sheet.write(it, 10, y[0]['source_product_name'])
 214 
        sheet.write(it, 10, y[0]['source_product_name'])
217 
        sheet.write(it, 11, y[0]['url'])
 215 
        sheet.write(it, 11, y[0]['marketPlaceUrl'])
218 
        sheet.write(it, 12, y[0]['available_price'])
 216 
        sheet.write(it, 12, y[0]['available_price'])
219 
        sheet.write(it, 13, x.mrp)
 217 
        sheet.write(it, 13, x.mrp)
220 
        sheet.write(it, 14, x.dp)
 218 
        sheet.write(it, 14, x.dp)
221 
        sheet.write(it, 15, x.schemeAmount)
 219 
        sheet.write(it, 15, x.schemeAmount)
222 
        sheet.write(it, 16, x.discountType)
 220 
        sheet.write(it, 16, x.discountType)