WebSVN – SmartDukaan – Diff – /trunk/PyDTR/src/scripts/ActivityReport.py



 
DB_HOST = "localhost"
DB_USER = "root"
DB_PASSWORD = "shop2020"
DB_NAME = "dtr"
TMP_FILE = "User_Activity_Report.xls"  
 
con = None
dateWiseOrderMap = {}
weekWiseOrderMap = {}
monthWiseOrderMap = {}

    target_day = days_of_week.index(day_name.lower())
    delta_day = target_day - (d.isoweekday()%7)
    return d + timedelta(days=delta_day)
          
def main():
    populateYesterdayActiveUsers(24)
    populateValidOrders()
    populateOrderMap()
    populateWeekWiseMap1()
    populateMonthWiseMap1()
    populateSaholicOrderMap()
    populateSaholicWeekWiseMap1()
    populateSaholicMonthWiseMap1()
    generateDailyReport()
    generateWeeklyReport()
    generateMonthlyReport()
    sendmail(["manas.kapoor@shop2020.in","rajneesh.arora@saholic.com", "amit.gupta@shop2020.in","chaitnaya.vats@shop2020.in"], "", TMP_FILE, SUBJECT)
    #sendmail(["manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)
    
    
def to_x_date(java_timestamp):
    try:

Rev 17265	Rev 17266
Line 25...	Line 25...
25		25
26	`DB_HOST = "localhost"`	26	`DB_HOST = "localhost"`
27	`DB_USER = "root"`	27	`DB_USER = "root"`
28	`DB_PASSWORD = "shop2020"`	28	`DB_PASSWORD = "shop2020"`
29	`DB_NAME = "dtr"`	29	`DB_NAME = "dtr"`
30	`TMP_FILE = "/home/manas/User_Activity_Report.xls"`	30	`TMP_FILE = "User_Activity_Report.xls"`
31		31
32	`con = None`	32	`con = None`
33	`dateWiseOrderMap = {}`	33	`dateWiseOrderMap = {}`
34	`weekWiseOrderMap = {}`	34	`weekWiseOrderMap = {}`
35	`monthWiseOrderMap = {}`	35	`monthWiseOrderMap = {}`
Line 1078...	Line 1078...
1078	`target_day = days_of_week.index(day_name.lower())`	1078	`target_day = days_of_week.index(day_name.lower())`
1079	`delta_day = target_day - (d.isoweekday()%7)`	1079	`delta_day = target_day - (d.isoweekday()%7)`
1080	`return d + timedelta(days=delta_day)`	1080	`return d + timedelta(days=delta_day)`
1081		1081
1082	`def main():`	1082	`def main():`
1083	`#populateYesterdayActiveUsers(24)`	1083	`populateYesterdayActiveUsers(24)`
1084	`populateValidOrders()`	1084	`populateValidOrders()`
1085	`populateOrderMap()`	1085	`populateOrderMap()`
1086	`populateWeekWiseMap1()`	1086	`populateWeekWiseMap1()`
1087	`populateMonthWiseMap1()`	1087	`populateMonthWiseMap1()`
1088	`populateSaholicOrderMap()`	1088	`populateSaholicOrderMap()`
1089	`populateSaholicWeekWiseMap1()`	1089	`populateSaholicWeekWiseMap1()`
1090	`populateSaholicMonthWiseMap1()`	1090	`populateSaholicMonthWiseMap1()`
1091	`generateDailyReport()`	1091	`generateDailyReport()`
1092	`generateWeeklyReport()`	1092	`generateWeeklyReport()`
1093	`generateMonthlyReport()`	1093	`generateMonthlyReport()`
1094	`#sendmail(["manas.kapoor@shop2020.in","rajneesh.arora@saholic.com", "amit.gupta@shop2020.in","chaitnaya.vats@shop2020.in"], "", TMP_FILE, SUBJECT)`	1094	`sendmail(["manas.kapoor@shop2020.in","rajneesh.arora@saholic.com", "amit.gupta@shop2020.in","chaitnaya.vats@shop2020.in"], "", TMP_FILE, SUBJECT)`
1095	`#sendmail(["manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)`	1095	`#sendmail(["manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)`
1096		1096
1097		1097
1098	`def to_x_date(java_timestamp):`	1098	`def to_x_date(java_timestamp):`
1099	`try:`	1099	`try:`

Subversion Repositories SmartDukaan

(root)/trunk/PyDTR/src/scripts/ActivityReport.py – Rev 17265 → 17266