| Line 1194... |
Line 1194... |
| 1194 |
|
1194 |
|
| 1195 |
filename = "/tmp/snapdeal-report-"+runType+" " + str(timestamp) + ".xls"
|
1195 |
filename = "/tmp/snapdeal-report-"+runType+" " + str(timestamp) + ".xls"
|
| 1196 |
wbk.save(filename)
|
1196 |
wbk.save(filename)
|
| 1197 |
try:
|
1197 |
try:
|
| 1198 |
#EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["kshitij.sood@saholic.com"], " Snapdeal Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], [""], [])
|
1198 |
#EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["kshitij.sood@saholic.com"], " Snapdeal Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], [""], [])
|
| 1199 |
EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["chandan.kumar@saholic.com","manoj.kumar@saholic.com","yukti.jain@saholic.com","ankush.dhingra@saholic.com","manoj.pal@saholic.com"], " Snapdeal Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], ["rajneesh.arora@saholic.com","rajveer.singh@saholic.com","vikram.raghav@saholic.com","kshitij.sood@saholic.com","chaitnaya.vats@saholic.com","khushal.bhatia@saholic.com"], [])
|
1199 |
EmailAttachmentSender.mail("build@shop2020.in", "cafe@nes", ["chandan.kumar@saholic.com","manoj.kumar@saholic.com","yukti.jain@saholic.com","ankush.dhingra@saholic.com","manoj.pal@saholic.com"], " Snapdeal Auto Pricing "+runType+" " + str(timestamp), "", [get_attachment_part(filename)], ["rajneesh.arora@saholic.com","anikendra.das@saholic.com","vikram.raghav@saholic.com","kshitij.sood@saholic.com","chaitnaya.vats@saholic.com","khushal.bhatia@saholic.com"], [])
|
| 1200 |
except Exception as e:
|
1200 |
except Exception as e:
|
| 1201 |
print e
|
1201 |
print e
|
| 1202 |
print "Unable to send report.Trying with local SMTP"
|
1202 |
print "Unable to send report.Trying with local SMTP"
|
| 1203 |
smtpServer = smtplib.SMTP('localhost')
|
1203 |
smtpServer = smtplib.SMTP('localhost')
|
| 1204 |
smtpServer.set_debuglevel(1)
|
1204 |
smtpServer.set_debuglevel(1)
|
| 1205 |
sender = 'support@shop2020.in'
|
1205 |
sender = 'support@shop2020.in'
|
| 1206 |
#recipients = ['kshitij.sood@saholic.com']
|
1206 |
#recipients = ['kshitij.sood@saholic.com']
|
| 1207 |
msg = MIMEMultipart()
|
1207 |
msg = MIMEMultipart()
|
| 1208 |
msg['Subject'] = "Snapdeal Auto Pricing" + ' - ' + str(datetime.now())
|
1208 |
msg['Subject'] = "Snapdeal Auto Pricing" + ' - ' + str(datetime.now())
|
| 1209 |
msg['From'] = sender
|
1209 |
msg['From'] = sender
|
| 1210 |
recipients = ['rajneesh.arora@saholic.com','rajveer.singh@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
1210 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
| 1211 |
msg['To'] = ",".join(recipients)
|
1211 |
msg['To'] = ",".join(recipients)
|
| 1212 |
fileMsg = email.mime.base.MIMEBase('application','vnd.ms-excel')
|
1212 |
fileMsg = email.mime.base.MIMEBase('application','vnd.ms-excel')
|
| 1213 |
fileMsg.set_payload(file(filename).read())
|
1213 |
fileMsg.set_payload(file(filename).read())
|
| 1214 |
email.encoders.encode_base64(fileMsg)
|
1214 |
email.encoders.encode_base64(fileMsg)
|
| 1215 |
fileMsg.add_header('Content-Disposition','attachment;filename=snapdeal.xls')
|
1215 |
fileMsg.add_header('Content-Disposition','attachment;filename=snapdeal.xls')
|
| Line 1470... |
Line 1470... |
| 1470 |
buyBoxList.append(mpHistory)
|
1470 |
buyBoxList.append(mpHistory)
|
| 1471 |
session.commit()
|
1471 |
session.commit()
|
| 1472 |
return buyBoxList
|
1472 |
return buyBoxList
|
| 1473 |
|
1473 |
|
| 1474 |
def sendAutoPricingMail(successfulAutoDecrease,successfulAutoIncrease):
|
1474 |
def sendAutoPricingMail(successfulAutoDecrease,successfulAutoIncrease):
|
| - |
|
1475 |
if len(successfulAutoDecrease)==0 and len(successfulAutoIncrease)==0 :
|
| - |
|
1476 |
return
|
| 1475 |
xstr = lambda s: s or ""
|
1477 |
xstr = lambda s: s or ""
|
| 1476 |
catalog_client = CatalogClient().get_client()
|
1478 |
catalog_client = CatalogClient().get_client()
|
| 1477 |
inventory_client = InventoryClient().get_client()
|
1479 |
inventory_client = InventoryClient().get_client()
|
| 1478 |
message="""<html>
|
1480 |
message="""<html>
|
| 1479 |
<body>
|
1481 |
<body>
|
| Line 1538... |
Line 1540... |
| 1538 |
mailServer.ehlo()
|
1540 |
mailServer.ehlo()
|
| 1539 |
mailServer.starttls()
|
1541 |
mailServer.starttls()
|
| 1540 |
mailServer.ehlo()
|
1542 |
mailServer.ehlo()
|
| 1541 |
|
1543 |
|
| 1542 |
#recipients = ['kshitij.sood@saholic.com']
|
1544 |
#recipients = ['kshitij.sood@saholic.com']
|
| 1543 |
recipients = ['rajneesh.arora@saholic.com','rajveer.singh@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
1545 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
| 1544 |
msg = MIMEMultipart()
|
1546 |
msg = MIMEMultipart()
|
| 1545 |
msg['Subject'] = "Snapdeal Auto Pricing" + ' - ' + str(datetime.now())
|
1547 |
msg['Subject'] = "Snapdeal Auto Pricing" + ' - ' + str(datetime.now())
|
| 1546 |
msg['From'] = ""
|
1548 |
msg['From'] = ""
|
| 1547 |
msg['To'] = ",".join(recipients)
|
1549 |
msg['To'] = ",".join(recipients)
|
| 1548 |
msg.preamble = "Snapdeal Auto Pricing" + ' - ' + str(datetime.now())
|
1550 |
msg.preamble = "Snapdeal Auto Pricing" + ' - ' + str(datetime.now())
|
| Line 1734... |
Line 1736... |
| 1734 |
mailServer.ehlo()
|
1736 |
mailServer.ehlo()
|
| 1735 |
mailServer.starttls()
|
1737 |
mailServer.starttls()
|
| 1736 |
mailServer.ehlo()
|
1738 |
mailServer.ehlo()
|
| 1737 |
|
1739 |
|
| 1738 |
#recipients = ['kshitij.sood@saholic.com']
|
1740 |
#recipients = ['kshitij.sood@saholic.com']
|
| 1739 |
recipients = ['rajneesh.arora@saholic.com','rajveer.singh@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
1741 |
recipients = ['rajneesh.arora@saholic.com','anikendra.das@saholic.com','vikram.raghav@saholic.com','kshitij.sood@saholic.com','khushal.bhatia@saholic.com','chaitnaya.vats@saholic.com','chandan.kumar@saholic.com','manoj.kumar@saholic.com','yukti.jain@saholic.com','ankush.dhingra@saholic.com','manoj.pal@saholic.com']
|
| 1740 |
msg = MIMEMultipart()
|
1742 |
msg = MIMEMultipart()
|
| 1741 |
msg['Subject'] = "Snapdeal Lost Buy Box" + ' - ' + str(datetime.now())
|
1743 |
msg['Subject'] = "Snapdeal Lost Buy Box" + ' - ' + str(datetime.now())
|
| 1742 |
msg['From'] = ""
|
1744 |
msg['From'] = ""
|
| 1743 |
msg['To'] = ",".join(recipients)
|
1745 |
msg['To'] = ",".join(recipients)
|
| 1744 |
msg.preamble = "Snapdeal Lost Buy Box" + ' - ' + str(datetime.now())
|
1746 |
msg.preamble = "Snapdeal Lost Buy Box" + ' - ' + str(datetime.now())
|