Subversion Repositories SmartDukaan

Rev

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

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: