| Line 400... |
Line 400... |
| 400 |
workbook.save(XLS_FILENAME)
|
400 |
workbook.save(XLS_FILENAME)
|
| 401 |
return message
|
401 |
return message
|
| 402 |
|
402 |
|
| 403 |
def generateHomeShopReco():
|
403 |
def generateHomeShopReco():
|
| 404 |
global i
|
404 |
global i
|
| 405 |
curs = getOrdersAfterDate(datetime.now() - timedelta(days=30), 7)
|
405 |
curs = getOrdersAfterDate(datetime.now() - timedelta(days=90), 7)
|
| 406 |
db = client.Dtr
|
406 |
db = client.Dtr
|
| 407 |
notReconciled = {}
|
407 |
notReconciled = {}
|
| 408 |
matchedList = []
|
408 |
matchedList = []
|
| 409 |
workbook = xlwt.Workbook()
|
409 |
workbook = xlwt.Workbook()
|
| 410 |
worksheet = workbook.add_sheet("HomeShop18 Reconciled")
|
410 |
worksheet = workbook.add_sheet("HomeShop Reconciled")
|
| 411 |
worksheet1 = workbook.add_sheet("HomeShop18 Reconciled All")
|
411 |
worksheet1 = workbook.add_sheet("HomeShop Reconciled All")
|
| 412 |
worksheet2 = workbook.add_sheet("HomeShop18 Orders not reconciled")
|
412 |
worksheet2 = workbook.add_sheet("HomeShop Orders not reconciled")
|
| 413 |
affNotReconciledSheet = workbook.add_sheet("HomeShop18 Aff not reconciled")
|
413 |
affNotReconciledSheet = workbook.add_sheet("HomeShop Aff not reconciled")
|
| 414 |
setHeaders(worksheet, worksheet1, worksheet2, affNotReconciledSheet)
|
414 |
setHeaders(worksheet, worksheet1, worksheet2, affNotReconciledSheet)
|
| 415 |
row = 0
|
415 |
row = 0
|
| 416 |
anotherrow = 0
|
416 |
anotherrow = 0
|
| 417 |
row2 = 0
|
417 |
row2 = 0
|
| 418 |
row5=0
|
418 |
row5=0
|
| Line 1054... |
Line 1054... |
| 1054 |
generateFlipkartReco()
|
1054 |
generateFlipkartReco()
|
| 1055 |
generateShopcluesReco()
|
1055 |
generateShopcluesReco()
|
| 1056 |
generateAmazonReco(XLS_A_FILENAME)
|
1056 |
generateAmazonReco(XLS_A_FILENAME)
|
| 1057 |
message1 = getdata.summaryByBrandAndStore()
|
1057 |
message1 = getdata.summaryByBrandAndStore()
|
| 1058 |
getUserOrders()
|
1058 |
getUserOrders()
|
| - |
|
1059 |
generateHomeShopReco()
|
| 1059 |
#sendmail(["amit.gupta@shop2020.in"], message, "Affiliate Reco", XLS_FILENAME)
|
1060 |
#sendmail(["amit.gupta@shop2020.in"], message, "Affiliate Reco", XLS_FILENAME)
|
| 1060 |
#sendmail(["naman.kumar@shop2020.in"], message1, "All DTR Orders", XLS_O_FILENAME)
|
1061 |
#sendmail(["naman.kumar@shop2020.in"], message1, "All DTR Orders", XLS_O_FILENAME)
|
| 1061 |
sendmail(["amit.gupta@shop2020.in", "rajneesh.arora@saholic.com", "chaitnaya.vats@saholic.com", "manoj.kumar@saholic.com", "manish.sharma@shop2020.in"], message1, "All DTR Orders", XLS_O_FILENAME)
|
1062 |
sendmail(["amit.gupta@shop2020.in", "rajneesh.arora@saholic.com", "chaitnaya.vats@saholic.com", "manoj.kumar@saholic.com", "manish.sharma@shop2020.in"], message1, "All DTR Orders", XLS_O_FILENAME)
|
| 1062 |
sendmail(["amit.gupta@shop2020.in","rajneesh.arora@saholic.com","manish.sharma@shop2020.in"], message, "Affiliate Reco", XLS_FILENAME, XLS_F_FILENAME, XLS_A_FILENAME, XLS_SC_FILENAME)
|
1063 |
sendmail(["amit.gupta@shop2020.in","rajneesh.arora@saholic.com","manish.sharma@shop2020.in"], message, "Affiliate Reco", XLS_FILENAME, XLS_F_FILENAME, XLS_A_FILENAME, XLS_SC_FILENAME, XLS_HS_FILENAME)
|
| 1063 |
#sendmail(["amit.gupta@shop2020.in"], "", "Affiliate Reco", XLS_FILENAME, XLS_F_FILENAME, XLS_A_FILENAME, XLS_SC_FILENAME)
|
1064 |
#sendmail(["amit.gupta@shop2020.in"], "", "Affiliate Reco", XLS_FILENAME, XLS_F_FILENAME, XLS_A_FILENAME, XLS_SC_FILENAME)
|
| 1064 |
|
1065 |
|
| 1065 |
def main3():
|
1066 |
def main3():
|
| 1066 |
db = client.Dtr
|
1067 |
db = client.Dtr
|
| 1067 |
#main()
|
1068 |
#main()
|