WebSVN – SmartDukaan – Diff – /trunk/PyDTR/src/dtr/reports/affiliatereco.py

 import _mysql
 import MySQLdb
 import smtplib
 import time
 import xlwt
-from dtr.utils import utils
-from dtr.utils.utils import toTimeStamp
+from dtr.utils.utils import toTimeStamp, getSkuData
 from dtr.reports import getdata
-from scripts.ActivityReport import cutOff, cutOffMonth
 #from xlwt import
 DataService.initialize()
 client = MongoClient('mongodb://localhost:27017/')
         sh2.write(row3, inc(), order.model)
         sh2.write(row3, inc(), order.category)
     workbook.save(XLS_O_FILENAME)
-def getSkuData(storeId, identifier):
-    if storeId in (1,2,4,5,6):
-        skuData = client.Catalog.MasterData.find_one({'identifier':identifier, 'source_id':storeId})
-    elif storeId == 3:
-        skuData = client.Catalog.MasterData.find_one({'secondaryIdentifier':identifier, 'source_id':storeId})
-    return skuData
 def inc():
     global i
     i+=1
     return i
     for key,valmap in  datemap.iteritems():
         valmap['_id'] = key
         db.flSaleSnapshot.save(valmap)
 if __name__ == '__main__':
-    getdata.addToAllOrders(date.today()-timedelta(days=20))
+    getdata.addToAllOrders(date.today()-timedelta(days=45))
     main2()
     main()

Subversion Repositories SmartDukaan