Subversion Repositories SmartDukaan

Rev

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

Rev 17171 Rev 17209
Line 14... Line 14...
14 
from email.mime.multipart import MIMEMultipart
 14 
from email.mime.multipart import MIMEMultipart
15 
from email.mime.text import MIMEText
 15 
from email.mime.text import MIMEText
16 
from operator import or_
 16 
from operator import or_
17 
from pymongo.mongo_client import MongoClient
 17 
from pymongo.mongo_client import MongoClient
18 
from shop2020.utils.Utils import to_py_date, to_java_date
 18 
from shop2020.utils.Utils import to_py_date, to_java_date
19 
from sqlalchemy.sql.expression import func
 19 
from sqlalchemy.sql.expression import func, and_
20 
from time import strftime
 20 
from time import strftime
21 
from xlrd import open_workbook
 21 
from xlrd import open_workbook
22 
from xlutils.copy import copy
 22 
from xlutils.copy import copy
23 
from xlwt.Workbook import Workbook
 23 
from xlwt.Workbook import Workbook
24 
import MySQLdb
 24 
import MySQLdb
Line 42... Line 42...
42 
dateWiseSaholicOrderMap = {}
 42 
dateWiseSaholicOrderMap = {}
43 
weekWiseSaholicOrderMap = {}
 43 
weekWiseSaholicOrderMap = {}
44 
monthWiseSaholicOrderMap = {}
 44 
monthWiseSaholicOrderMap = {}
45 
 
 45 
 
46 
orderIds = []
 46 
orderIds = []
- 
 
 47 
 
- 
 
 48 
curDate = date.today()
- 
 
 49 
cutOffMonth = (datetime.now().month + 10)%12
- 
 
 50 
cutOffYear = curDate.year - (0 if curDate.month-2 > 0 else 1)
47 
cutOff = utils.toTimeStamp(date.today()-timedelta(days=90))
 51 
cutOff = datetime(cutOffYear, cutOffMonth, 1)
48 
#cutOff = 1425234600
 52 
#cutOff = 1425234600
49 
oneDay = 86400
 53 
oneDay = 86400
50 
monthCutOff = 1425148200
 54 
monthCutOff = 1425148200
51 
weekCutOff = 1425839400
 55 
weekCutOff = 1425839400
52 
newWeekCutOff = 1425839400
 56 
newWeekCutOff = 1425839400
Line 1004... Line 1008...
1004 
                break
1008 
                break
1005 
 
 1009 
 
1006
1010
1007 
def populateValidOrders():
 1011 
def populateValidOrders():
1008 
    global order_ids
 1012 
    global order_ids
1009 
    allOrders = session.query(Orders.id).join((Users,Orders.user_id==Users.id)).filter(or_(~(func.lower(Users.referrer)).like('emp%'),Users.utm_campaign != None)).all()
 1013 
    allOrders = session.query(Orders.id).join((Users,Orders.user_id==Users.id)).filter(or_(~(func.lower(Users.referrer)).like('emp%'),Users.utm_campaign != None)).filter(and_(Orders.created>=cutOff)).all()
1010 
    order_ids = list(zip(*allOrders)[0])
 1014 
    order_ids = list(zip(*allOrders)[0])
1011
1015
1012 
def main():
 1016 
def main():
1013 
    populateYesterdayActiveUsers(24)
 1017 
    #populateYesterdayActiveUsers(24)
1014 
    populateValidOrders()
 1018 
    populateValidOrders()
1015 
    populateOrderMap()
 1019 
    populateOrderMap()
1016 
    populateWeekWiseMap1()
 1020 
    populateWeekWiseMap1()
1017 
    populateMonthWiseMap1()
 1021 
    populateMonthWiseMap1()
1018 
    populateSaholicOrderMap()
 1022 
    populateSaholicOrderMap()