WebSVN – SmartDukaan – Diff – //trunk/PyDTR/src/dtr/reports/crmoutbound.py

     worksheet.write(23,1,len(list(set(agentLoginList))),center_alignment)
     conn.close()
     datesql=FRESH_QUERY_LINKS_CONVERTED
     conn = getDbConnection()
+    global Converted
+    global AgentsLoggedIn
+    AgentsLoggedIn=len(list(set(agentLoginList)))
     cursor = conn.cursor()
     cursor.execute(datesql)
     result = cursor.fetchall()
     loginTime=0
     for r in result:
-        converted=r[0]
+        Converted=r[0]
         worksheet.write(24,1,r[0],center_alignment)
-    worksheet.write(25,1,totalVerifiedLinkSent-converted,center_alignment)
+    worksheet.write(25,1,totalVerifiedLinkSent-Converted,center_alignment)
     conn.close()
     datesql=TOTAL_ACTIVATIONS
     conn = getDbConnection()
+    global TotalActivations
     cursor = conn.cursor()
     cursor.execute(datesql)
     result = cursor.fetchall()
     loginTime=0
     for r in result:
+        TotalActivations=r[0]
         worksheet.write(26,1,r[0],center_alignment)
     workbook.save(TMP_FILE)
     #sendmail(["manas.kapoor@shop2020.in"], "", TMP_FILE, SUBJECT)
     # Create the container (outer) email message.
     msg = MIMEMultipart()
     msg['Subject'] = title
     msg.preamble = title
+    message="Total Activations :" + str(TotalActivations)
+    message1="Links Converted :" + str(Converted)
+    message2="Total Agents Logged In :" + str(AgentsLoggedIn)
-    html_msg = MIMEText(message, 'html')
+    html_msg = MIMEText(message+"<br><br>"+message1+"<br><br>"+message2, 'html')
     msg.attach(html_msg)
     fileMsg = MIMEBase('application', 'vnd.ms-excel')
     fileMsg.set_payload(file(TMP_FILE).read())
     encoders.encode_base64(fileMsg)

Subversion Repositories SmartDukaan

(root)//trunk/PyDTR/src/dtr/reports/crmoutbound.py – Rev 15438 → 15441