def fallback_support_file_not_found(self, batch, topic): name = self.get_cookie("name") email= self.get_cookie("email") email_sender = EmailSender() email_sender.sendEmailToSupportForFileNotFound(name, email, batch, topic) response = "Email sent to support team! You will be contacted soon" return response
def processRequest(req): log = logger.Log() sessionID = req.get("responseId") user_says = req.get("queryText") result = reg.get("queryResult") log.writeLog(sessionID, "User Says : " + user_says) parameters = req.get("parameters") name = parameters.get("name") pin = parameters.get("pin") mailid = parameters.get("mailid") phone = parameters.get("phone") option_name = paramerers.get("option_name") intent = result.get("intent").get('displayName') if intent == "covid_intent": email_sender = EmailSender() template = template_reader.TemplateReader() email_message = template.select_info(option_name) email_sender.send_email_to_student(mailid, email_message) email_file_support = open("email_templates/preventive_Template.html", "r") email_message_support = email_file_support.read() email_sender.send_email_to_support(name=name, phone=phone, mailid=mailid, option_name=option_name, body=email_message_support) fulfillmentText = "We have sent the details to you via email. An email has been sent to the Support Team with your contact information, you'll be contacted soon. Do you have further queries?" log.write_log(sessionID, "Bot Says: " + fulfillmentText) return {"fulfillmentText": fulfillmentText} else: log.write_log(sessionID, "Bot Says: " + result.fulfillmentText)
def fallback_support(self, user_query): name = self.get_cookie("name") email= self.get_cookie("email") email_sender = EmailSender() email_sender.sendEmailToSupport(name, email, user_query) response = "Email sent to support team! You will be contacted soon" return response
def fallback_support_recording(self, batch, day): name = self.get_cookie("name") email= self.get_cookie("email") email_sender = EmailSender() email_sender.sendEmailToSupportForRecording(name, email, batch, day) response = "Email sent to support team! You will be contacted soon" return response
def fallback_support_dashboard_access(self, batch): name = self.get_cookie("name") email= self.get_cookie("email") email_sender = EmailSender() email_sender.sendEmailToSupportForDashboardAccess(name, email, batch) response = "Email sent to support team! You will be contacted soon" return response
def processRequest(req): log = logger.Log() sessionID = req.get('responseId') result = req.get("queryResult") user_says = result.get("queryText") log.write_log(sessionID, "User Says: " + user_says) # log.write_mongodb(sessionID, "User Says: " + user_says) parameters = result.get("parameters") cust_name = parameters.get("user_name") #print(cust_name) cust_contact = parameters.get("user_phone") cust_email = parameters.get("user_email") cust_pincode = parameters.get("user_pincode") cust_pincode = re.sub(' ', '', str(cust_pincode)) intent = result.get("intent").get('displayName') if (intent == 'ZipcodeSelection'): # covid19 = CoronaDataScrap() # data = covid19.scrap_data() #data = pd.read_csv('/DataScrap/Corona_reports.csv') email_sender = EmailSender() template = template_reader.TemplateReader() email_message = template.read_course_template('covid_19_template.html') email_sender.send_email_to_student(cust_email, email_message) # email_file_support = open("email_templates/support_team_Template.html", "r") # #email_message_support = email_file_support.read() #email_sender.send_email_to_support(cust_name=cust_name,cust_contact=cust_contact,cust_email=cust_email,course_name=course_name,body=email_message_support) fulfillmentText = "We have sent the Precautionary Measures and India's covid details to you via email. Stay safe and take care." log.write_log(sessionID, "Bot Says: " + fulfillmentText) #log.write_mongodb(sessionID, "Bot Says: " + fulfillmentText) return {"fulfillmentText": fulfillmentText} else: log.write_log(sessionID, "Bot Says: " + result.fulfillmentText)
def processRequest(req): log = logger.Log() sessionID=req.get('responseId') result = req.get("queryResult") user_says=result.get("queryText") log.write_log(sessionID, "User Says: "+user_says) parameters = result.get("parameters") cust_name=parameters.get("cust_name") #print(cust_name) cust_contact = parameters.get("cust_contact") cust_email=parameters.get("cust_email") person_name= parameters.get("person_name") intent = result.get("intent").get('displayName') if (intent=='Person_info'): email_sender=EmailSender() #template= template_reader.TemplateReader() #email_message=template.read_person_name(person_name) email_sender.send_email_to_student(cust_email,email_message) # email_file_support = open("email_templates/support_team_Template.html", "r") #email_message_support = email_file_support.read() email_sender.send_email_to_support(cust_name=cust_name,cust_contact=cust_contact,cust_email=cust_email,person_name=person_name,body=email_message_support) fulfillmentText="Happy botting" log.write_log(sessionID, "Bot Says: "+fulfillmentText) return { "fulfillmentText": fulfillmentText } else: log.write_log(sessionID, "Bot Says: " + result.fulfillmentText)
def processRequest(req): log = logger.Log() sessionID = req.get('responseId') result = req.get("queryResult") user_says = result.get("queryText") log.write_log(sessionID, "User is: " + user_says) parameters = result.get("parameters") cust_name = parameters.get("usr_name") #print(cust_name) cust_email = parameters.get("usr_email") intent = result.get("intent").get('displayName') if (intent == 'Send_Resume'): email_sender = EmailSender() #template= template_reader.TemplateReader() email_message = "Hello. PFA Shivam Chauhan Resume" email_sender.send_email_to_student(cust_email, email_message) #email_file_support = open("email_templates/support_team_Template.html", "r") #email_message_support = email_file_support.read() #email_sender.send_email_to_support(cust_name=cust_name,cust_contact=cust_contact,cust_email=cust_email,course_name=course_name,body=email_message_support) fulfillmentText = "We have sent the Resume and other details to your email. Thanks you. Do you have further queries?" log.write_log(sessionID, "Bot Says: " + fulfillmentText) return {"fulfillmentText": fulfillmentText} else: log.write_log(sessionID, "Bot Says: " + result.fulfillmentText)
def processRequest(req): log = logger.Log() sessionID = req.get('responseId') result = req.get("queryResult") user_says = result.get("queryText") bot_says = result.get("fulfillmentText") log.write_log(sessionID, "User Says: " + user_says) parameters = result.get("parameters") cust_name = parameters.get("cust_name") #print(cust_name) cust_contact = parameters.get("cust_contact") cust_email = parameters.get("cust_email") course_name = parameters.get("course_name") intent = result.get("intent").get('displayName') if (intent == 'course_selection'): dbConn = pymongo.MongoClient("mongodb://localhost:27017/") db = dbConn['Chatbot'] collection = db['GD_INeuron_Course_Details'] if collection['SessionID'] == sessionID: collection.update_one( {"SessionId": sessionID}, {"$push": { "Event": { "$each": [user_says, bot_says] } }}, True) else: collection.insert_one({ "SessionId": sessionID, "Name": cust_name, "Contact": cust_contact, "EmailId": cust_email, "Course": course_name, "Events": [user_says, bot_says] }) email_sender = EmailSender() template = template_reader.TemplateReader() email_message = template.read_course_template(course_name) email_sender.send_email_to_student(cust_email, email_message) email_file_support = open("email_templates/support_team_Template.html", "r") email_message_support = email_file_support.read() email_sender.send_email_to_support(cust_name=cust_name, cust_contact=cust_contact, cust_email=cust_email, course_name=course_name, body=email_message_support) fulfillmentText = "We have sent the course syllabus and other relevant details to you via email. An email has been sent to the Support Team with your contact information, you'll be contacted soon. Do you have further queries?" log.write_log(sessionID, "Bot Says: " + fulfillmentText) return {"fulfillmentText": fulfillmentText} else: log.write_log(sessionID, "Bot Says: " + result.fulfillmentText)
def processRequest(req): log = logger.Log() sessionID=req.get('responseId') result = req.get("queryResult") user_says=result.get("queryText") log.write_log(sessionID, "User Says: "+user_says) parameters = result.get("parameters") cust_name=parameters.get("Name") cust_contact = parameters.get("PhoneNumber") cust_email=parameters.get("Email") course_name= parameters.get("Disease") intent = result.get("intent").get('displayName') if (intent=='appoint_yes_confirm'): email_sender=EmailSender() template= template_reader.TemplateReader() email_message=template.read_course_template(course_name) email_sender.send_email_to_student(cust_email,email_message) email_file_support = open("email_templates/support_team_Template.html", "r") email_message_support = email_file_support.read() email_sender.send_email_to_support(cust_name=cust_name,cust_contact=cust_contact,cust_email=cust_email,course_name=course_name,body=email_message_support) fulfillmentText="An email has been sent to the Support Team with your contact information, you'll be contacted soon with appointment details. " log.write_log(sessionID, "Bot Says: "+fulfillmentText) return { "fulfillmentText": fulfillmentText } if (intent == 'Welcome_Intent'): return { "fulfillmentMessages": [ { "card": { "title": "Hello. Good day. Please choose any of the below.", "buttons": [ { "text": "Need advise.", "postback": "Advise" }, { "text": "Consultation", "postback": "Consultation" }, { "text": "Book Appointment ?", "postback": "Appointment" } ] } } ] } else: log.write_log(sessionID, "Bot Says: " + result.fulfillmentText)
def predict(): ''' For rendering results on HTML GUI ''' #int_features = [22582, 2, 170, 90.0, 120, 80, 1, 1, 1, 1, 1, 31] i = 0 myList = [] for x in request.form.values(): if i == 0: name = x elif i == 1: email = x else: myList.append(x) i = i + 1 int_features = [int(x) for x in myList] int_features[0] = int_features[0] * 365 data = int_features[3] / (int_features[2] / 100)**2 int_features.append(data) final_features = pd.DataFrame([int_features]) prediction = model.predict(final_features) email_sender = EmailSender() email_file = open("email-templates/email-template-district.html", "r") email_message = email_file.read() if prediction[0] == 0: email_pred = "Hey! you are healthy. keep going on..Check your email for more information" else: email_pred = "Hey! you are more likely to have a cardio vascular outbreak. Take care. Check your email or the below link for more information" email_sender.sendEmailDistrict(name, email, email_message, email_pred) if prediction[0] == 0: return render_template( 'index.html', prediction_text= 'Hey! you seem not to have any cardio issues. you are healthy!. keep going on..' ) return render_template( 'index.html', prediction_text= 'Hey! you are more likely to have a cardio vascular outbreak. Take care of your health. For more details about the disease check the below link or your email' )
def processRequest(req): log = logger.Log() sessionID = req.get('responseId') result = req.get("queryResult") user_says = result.get("queryText") log.write_log(sessionID, "User Says: " + user_says) parameters = result.get("parameters") user_name = parameters.get("user_name") option_name = parameters.get("option_name") option_name_2 = parameters.get("option_name_2") user_location = parameters.get("user_location") user_location = user_location.upper() user_mobile = parameters.get("user_mobile") user_email = parameters.get("user_email") #intent = result.get("intent").get('displayName') cases = CovidCases() email_sender = EmailSender() content_email = email_content.EmailContent() if (option_name == 'Covid-19 in India'): cases_india = cases.covid_india(user_location) content_india = content_email.email_india(cases_india) email_sender.send_email_to_user(user_email, content_india) fulfillmentText = "The total confirmed cases in {} state is {}.For more details please check your Email and for visualization please check below link. https://www.covid19india.org/".format( cases_india.get("response").get('name'), cases_india.get("response").get('confirmed')) log.write_log(sessionID, "Bot Says: " + fulfillmentText) return {"fulfillmentText": fulfillmentText} elif (option_name_2 == 'Covid-19 in World'): cases_world = cases.covid_world(user_location) content_world = content_email.email_world(cases_world) email_sender.send_email_to_user(user_email, content_world) fulfillmentText = "The total confirmed cases in {} is {}.For more details please check your Email and for visualization please check below link. https://www.covidvisualizer.com/".format( cases_world.get('country'), cases_world.get('confirmed')) log.write_log(sessionID, "Bot Says: " + fulfillmentText) return {"fulfillmentText": fulfillmentText} else: log.write_log(sessionID, "Bot Says: " + result.fulfillmentText)
def processRequest(req): #log = logger.Log() sessionID = req.get('responseId') result = req.get("queryResult") user_says = result.get("queryText") #log.write_log(sessionID, "User Says: "+user_says) parameters = result.get("parameters") cust_contact = parameters.get("phn_no") course_no = parameters.get("number") cust_name = parameters.get("name") cust_email = parameters.get("email") print(cust_name) print(cust_contact) print(cust_email) print(course_no) if (course_no == 1): course_name = 'DataScienceMasters' elif (course_no == 2): course_name = 'MachineLearningMasters' elif (course_no == 3): course_name = 'DeepLearningMasters' else: course_name = 'NLPMasters' intent = result.get("intent").get('displayName') print(course_name) if (intent == 'course_selection'): email_sender = EmailSender() template = template_reader.TemplateReader() email_message = template.read_course_template(course_name) email_sender.send_email_to_student(cust_email, email_message) fulfillmentText = "We have sent course syllabus and other relevant details to your given email address. An email has sent to support team having your contact information, you will be contacted soon. Do you have further queries?" return {"fulfillmentText": fulfillmentText} else: return "nothing found"
def processRequest(req): log = logger.Log() sessionID = req.get('responseId') result = req.get("queryResult") user_says = result.get("queryText") log.write_log(sessionID, "User Says: "+user_says) parameters = result.get("parameters") #cust_name = parameters.get("name") #cust_contact = parameters.get("mobile") cust_email = parameters.get("mail") cust_city = parameters.get("state") custdistrict = parameters.get('district') intent = result.get("intent").get('displayName') message = 'No Data Found' api_data = get_api_data(custdistrict,cust_city) if api_data.get('status',False): message = api_data['message'] log.write_log('cust', "Cust Details%r"%[cust_city, cust_email, custdistrict]) if (intent== 'zip'): email_sender = EmailSender() email_file = open("email_templates/bot.html", "r") email_message = email_file.read() email_sender.send_email_to_student(cust_email, email_message, message) fulfillmentText = "We have sent the course syllabus " log.write_log('fulfillmentText', "Bot Says: " + fulfillmentText) return { "fulfillmentText": fulfillmentText } else: pass
def processRequest(req): global webhookresponse, webhookresponse1, fulfillmentText log = logger.Log() sessionID = req.get('responseId') result = req.get("queryResult") user_says = result.get("queryText") ##log.write_log(sessionID, "User Says: "+user_says,webhookresponse,intent) parameters = result.get("parameters") cust_name = parameters.get("cust_name") #print(cust_name) cust_contact = parameters.get("cust_contact") cust_email = parameters.get("cust_email") course_name = parameters.get("course_name") intent = result.get("intent").get('displayName') if (intent == 'country_selection'): cust_country = parameters.get("cust-country") if (cust_country == "United States"): cust_country = "USA" if (cust_country == "United Arab Emirates"): cust_country = "UAE" if (cust_country == "United Kingdom"): cust_country = "UK" fulfillmentText, deaths_data, testsdone_data = makeApiRequest( cust_country) webhookresponse = "***Covid Report*** \n\n" +\ " New cases :" + str( fulfillmentText.get( 'new' ) ) + \ "\n" + " Active cases : " + str( fulfillmentText.get( 'active' ) ) + "\n" + " Critical cases : " + str( fulfillmentText.get( 'critical' ) ) + \ "\n" + " Recovered cases : " + str( fulfillmentText.get( 'recovered' ) ) + "\n" + " Total cases : " + str( fulfillmentText.get( 'total' ) ) + \ "\n" + " New Deaths : " + str( deaths_data.get( 'new' ) ) + "\n" + " Total Deaths : " + str( deaths_data.get( 'total' ) ) + \ "\n" + " Total Test Done : " + str( testsdone_data.get( 'total' ) ) + "\n\n*******END********* \n " print("Country Name :", cust_country) print(webhookresponse) fulfillmentText = cust_country + "\n" + webhookresponse + "\n\n" + "Do you want me to share COVID-19 related information on your email id? Please chose from the below \n 1. Sure! \n 2. No. Thanks!" log.write_log(sessionID, "Current Cases", webhookresponse, intent) return { "fulfillmentText": fulfillmentText # "fulfillmentTextMessages" : [ # { # "text":{ # "text":[ # cust_country # ] # } # }, # { # "text":{ # "text":[ # webhookresponse # ] # } # }, # { # "text":{ # "text":[ # "Do you want me to share COVID-19 related information on your email id? Please chose from the below \n 1. Sure! \n 2. No. Thanks!" # ] # } # } # ] } elif intent == "Welcome" or intent == "continue_conversation" or intent == "not_send_email" or intent == "endConversation" \ or intent == "Fallback" or intent == "FAQ" : fulfillmentText = result.get("fulfillmentText") log.write_log(sessionID, user_says, fulfillmentText, intent) elif intent == "Send_Email": # print("Please enter your name", cust_name) # while True: # if not cust_name.isalpha(): # print( "Please Enter valid name" ) # else: # break # print("Please enter your email id", cust_email) # print("Please enter your contact number", cust_contact) fulfillmentText = result.get("fulfillmentText") log.write_log(sessionID, "Sure send email", fulfillmentText, intent) email_sender = EmailSender() template = templatereader.TemplateReader() email_message = template.read_course_template() email_sender.sendEmail(cust_email, email_message) #fulfillmentText = "We have sent the Covid19 related information on your email address.Please chose from the below \n 1. Main Menu \n 2. Exit" log.write_log(sessionID, "Sure send email", fulfillmentText, intent) return {"fulfillmentText": fulfillmentText} elif intent == "worldwide_data": fulfillmentText = makeApiRequest("world") webhookresponse = "***Worldwide Cases Report*** \n\n" + " Recovered :" + str( fulfillmentText.__getitem__( 'recovered' ) ) + \ "\n" + " Deaths : " + str(fulfillmentText.__getitem__( 'deaths' ) ) + "\n" + " Confirmed cases : " + str( fulfillmentText.__getitem__( 'confirmed' ) ) + \ "\n" + "Last Checked :" + str(fulfillmentText.__getitem__('lastChecked') ) + "\n" + "Last Reported :" + str( fulfillmentText.__getitem__( 'lastReported' ) ) + \ "\n\n*******END********* \n " print(webhookresponse) fulfillmentText = webhookresponse + "\n\n" + "Do you want me to share COVID-19 related information on your email id? Please chose from the below \n 1. Sure! \n 2. No. Thanks!" log.write_log(sessionID, "Worldwide Cases", webhookresponse, intent) return {"fulfillmentText": fulfillmentText} elif intent == "COVID_Headlines": fulfillmentText = makeApiRequest("headlines") webhookresponse = "***COVID Headlines*** \n\n" + str(fulfillmentText[0:-1]) +\ "\n\n*******END*******\n" print(webhookresponse) fulfillmentText = webhookresponse + "\n\n" + "Do you want me to share COVID19 related information on your email id? Please chose from the below \n 1. Sure! \n 2. No. Thanks!" log.write_log(sessionID, "COVID Headlines", webhookresponse, intent) return {"fulfillmentText": fulfillmentText} elif intent == "indian_states": fulfillmentText = makeApiRequest("state") print(len(fulfillmentText)) webhookresponse1 = '' webhookresponse2 = '' webhookresponse3 = '' for i in range(0, 11): webhookresponse = fulfillmentText[i] webhookresponse1 += "*********\n" + " State :" + str( webhookresponse[ 'state' ] ) + \ "\n" + " Confirmed cases : " + str(webhookresponse[ 'confirmed' ] ) + "\n" + " Recovered cases : " + str( webhookresponse[ 'recovered' ] ) + \ "\n"+ "Death cases : " + str( webhookresponse[ 'deaths' ] ) + \ "\n***********" for i in range(11, 21): webhookresponse = fulfillmentText[i] webhookresponse2 += "*********\n" + " State :" + str( webhookresponse[ 'state' ] ) + \ "\n" + " Confirmed cases : " + str(webhookresponse[ 'confirmed' ] ) + "\n" + " Recovered cases : " + str( webhookresponse[ 'recovered' ] ) + \ "\n"+ "Death cases : " + str( webhookresponse[ 'deaths' ] ) + \ "\n***********" for i in range(21, 38): webhookresponse = fulfillmentText[i] webhookresponse3 += "*********\n" + " State :" + str( webhookresponse[ 'state' ] ) + \ "\n" + " Confirmed cases : " + str(webhookresponse[ 'confirmed' ] ) + "\n" + " Recovered cases : " + str( webhookresponse[ 'recovered' ] ) + \ "\n"+ "Death cases : " + str( webhookresponse[ 'deaths' ] ) + \ "\n***********" print("***Statewise Cases*** \n\n" + webhookresponse1 + "\n\n") print("***Statewise Cases*** \n\n" + webhookresponse2 + "\n\n") print("***Statewise Cases*** \n\n" + webhookresponse3 + "\n\n*******END********* \n") #fulfillmentText = webhookresponse1 + "\n" + webhookresponse2 + "\n" + webhookresponse3 + "\n\n" + "Do you want me to share COVID-19 related information on your email id? Please chose from the below \n 1. Sure! \n 2. No. Thanks!" log.write_log(sessionID, "Indian State Cases", webhookresponse1, intent) return { "fulfillmentText": "***Statewise Cases*** \n\n" + webhookresponse1 + "\n" + webhookresponse2 + "\n" + webhookresponse3 + "\n\n" + "Do you want me to share COVID-19 related information on your email id? Please chose from the below \n 1. Sure! \n 2. No. Thanks!" }
def worldData(req): sessionID = req.get('responseId') result = req.get("queryResult") user_says = result.get("queryText") parameters = result.get("parameters") cur = mysql.connection.cursor() cur.execute( "INSERT INTO user_chat_history(sessionId,message, updated_time) VALUES (%s, %s, %s)", (sessionID, "User says: " + user_says + "With parameters:- " + str(parameters), datetime.datetime.utcnow())) mysql.connection.commit() cur.close() name = parameters.get("name") email = parameters.get("email") url = " https://corona-api.com/countries" headers = {} response = requests.request("GET", url, headers=headers) data = json.loads(response.text) country = [] country_code = [] latitude = [] longitude = [] population = [] confirmed = [] recoverd = [] deaths = [] for items in data["data"]: latitude.append(items["coordinates"]["latitude"]) longitude.append(items["coordinates"]["longitude"]) population.append(items["population"]) country.append(items["name"]) country_code.append(items["code"]) confirmed.append(items["latest_data"]["confirmed"]) recoverd.append(items["latest_data"]["recovered"]) deaths.append(items["latest_data"]["deaths"]) dict1 = { 'country': country, 'county_code': country_code, 'latitude': latitude, 'longitude': longitude, 'population': population, 'confirmed': confirmed, 'recoverd': recoverd, 'deaths': deaths } df = pd.DataFrame(dict1) # saving the dataframe df.to_csv('world_stats.csv') a = createMap() email_sender = EmailSender() template = template_reader.TemplateReader() email_message = template.read_course_template("Worldwide_Template") email_message = email_message.replace('User', name) email_message = email_message.replace( 'corona-url', os.path.join(BASE_DIR, 'covid-19\email_templates\world_map.html')) email_sender.send_email_to_student(email, email_message) fulfillmentText = "We have sent the visulization of corona effects world wide and other relevant details to you via email.Do you have further queries?" cur = mysql.connection.cursor() cur.execute( "INSERT INTO user_chat_history(sessionId,message, updated_time) VALUES (%s, %s, %s)", (sessionID, "Bot says: " + fulfillmentText, datetime.datetime.utcnow())) mysql.connection.commit() cur.close() return {"fulfillmentText": fulfillmentText}
def getUserDetails(req, db): sessionID = req.get("session") session = re.compile("sessions/(.*)") sessionID = session.findall(sessionID)[0] result = req.get("queryResult") user_says = result.get("queryText") name = result.get("parameters").get("name") email = result.get("parameters").get("email") mobile = result.get("parameters").get("mobile") pincode = result.get("parameters").get("pincode") regex_email = "^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+\.[a-zA-Z0-9-.]+$" regex_mobile = "[0-9]{10}" regex_pincode = "[0-9]{6}" if re.search(regex_email, email) is None: fulfillmentText = "Not a valid email. Please start again and enter valid email." bot_says = fulfillmentText if db.conversations.find({"sessionID": sessionID}).count() > 0: db.conversations.update_one( {"sessionID": sessionID}, {"$push": { "events": { "$each": [user_says, bot_says] } }}) else: db.conversations.insert_one({ "sessionID": sessionID, "events": [user_says, bot_says] }) return {"fulfillmentText": fulfillmentText} if re.search(regex_mobile, mobile) is None: fulfillmentText = "Not a valid mobile number. Please start again and enter valid mobile number." bot_says = fulfillmentText if db.conversations.find({"sessionID": sessionID}).count() > 0: db.conversations.update_one( {"sessionID": sessionID}, {"$push": { "events": { "$each": [user_says, bot_says] } }}) else: db.conversations.insert_one({ "sessionID": sessionID, "events": [user_says, bot_says] }) return {"fulfillmentText": fulfillmentText} if re.search(regex_pincode, pincode) is None: fulfillmentText = "Not a valid pincode. Please start again and enter valid pincode." bot_says = fulfillmentText if db.conversations.find({"sessionID": sessionID}).count() > 0: db.conversations.update_one( {"sessionID": sessionID}, {"$push": { "events": { "$each": [user_says, bot_says] } }}) else: db.conversations.insert_one({ "sessionID": sessionID, "events": [user_says, bot_says] }) return {"fulfillmentText": fulfillmentText} try: url = "https://api.postalpincode.in/pincode/" + pincode res = requests.get(url) jsonRes = res.json() postOffice = jsonRes[0]["PostOffice"] state = str(postOffice[0]["State"]) if "&" in state: state = state.replace("&", "and") district = str(postOffice[0]["District"]) if "&" in district: district = district.replace("&", "and") if district == "Ahmedabad": district = "Ahmadabad" elif district == "Bangalore": district = "Bengaluru" elif district == "Central Delhi": district = "New Delhi" print(state, end=',') print(district) try: url1 = "https://api.covid19india.org/v2/state_district_wise.json" res1 = requests.get(url1) jsonRes1 = res1.json() stateDistrictData = jsonRes1 for i in range(len(stateDistrictData)): stateDistrictData1 = stateDistrictData[i] if stateDistrictData1["state"] == state: districtData = stateDistrictData1["districtData"] for j in range(len(districtData)): email_sender = EmailSender() if districtData[j]["district"] == district: confirmed = str(districtData[j]["confirmed"]) print(f"\n Confirmed Cases are: {confirmed}") email_file = open( "email-templates/email-template-district.html", "r") email_message = email_file.read() email_sender.sendEmailDistrict( name, email, district, confirmed, email_message) fulfillmentText = "A mail has been sent to you with current COVID-19 cases in your area." bot_says = fulfillmentText if db.conversations.find({ "sessionID": sessionID }).count() > 0: db.conversations.update_one( {"sessionID": sessionID}, { "$push": { "events": { "$each": [user_says, bot_says] } } }) else: db.conversations.insert_one({ "sessionID": sessionID, "events": [user_says, bot_says] }) return {"fulfillmentText": fulfillmentText} else: fulfillmentText = "Sorry we did not found any data of COVID-19 in " + district + ". It might be a misspelling or we don't have record of the district." bot_says = fulfillmentText if db.conversations.find({ "sessionID": sessionID }).count() > 0: db.conversations.update_one( {"sessionID": sessionID}, { "$push": { "events": { "$each": [user_says, bot_says] } } }) else: db.conversations.insert_one({ "sessionID": sessionID, "events": [user_says, bot_says] }) return {"fulfillmentText": fulfillmentText} except HTTPError as http_err: print(f"HTTP error occurred: {http_err}") except Exception as err: print(f"Other error occurred: {err}") except HTTPError as http_err: print(f"HTTP error occurred: {http_err}") except Exception as err: print(f"Other error occurred: {err}")
def processRequest(req): log = logger.Log() sessionID = req.get('responseId') result = req.get("queryResult") user_says = result.get("queryText") log.write_log(sessionID, "User Says: " + user_says) parameters = result.get("parameters") cust_name = parameters.get("cust_name") cust_contact = parameters.get("cust_contact") cust_email = parameters.get("cust_email") pin_code = parameters.get("pin_code") intent = result.get("intent").get('displayName') if (intent == 'CORONA_BY_PINCODE'): results = getFrmPincode(pin_code) district_name = results[0]["PostOffice"][0]["District"] state_name = results[0]["PostOffice"][0]["State"] country_name = results[0]["PostOffice"][0]["Country"] print(district_name) # delete fulfillmentText = " " state_data = getStateCovidCases(state_name) print(state_data) print(len(state_data['districtData'])) try: district_data = getDistrictCovidCases(state_data, district_name) if district_data['active'] > 0: messageTxt = getCovidDist(district_data) fulfillmentText = district_name + '(' + pin_code + ')' + ' -- ' + messageTxt print(fulfillmentText) #delete # Store the details to database dbConn = pymongo.MongoClient("mongodb://localhost:27017/" ) # opening a connection to Mongo db = dbConn[ 'covidReqDB'] # connect to the database called covidReqDB dateTimeObj = datetime.now() mydict = { "Name": cust_name, "Email": cust_email, "Pincode": pin_code, "Contact": cust_contact, "Time_Stamp": dateTimeObj } # saving that detail to a dictionary collection = db[cust_email] collection.insert_one(mydict) # inserting the dictionary except Exception as e: messageTxt = getCovidState(state_data) fulfillmentText = messageTxt template = template_reader.TemplateReader() email_message = template.read_covid_template() email_sender = EmailSender() email_sender.send_email(cust_name, cust_email, email_message, fulfillmentText) fulfillmentText += "We have sent the preventive measures of Carona(Covid-19) disease to you via email. Do you have any queries?" log.write_log(sessionID, "Bot Says: " + fulfillmentText) return {"fulfillmentText": fulfillmentText} else: log.write_log(sessionID, "Bot Says: " + result.fulfillmentText) if (intent == 'CORONA_MAP_INDIA'): webbrowser.open('https://www.covid19india.org/') if (intent == 'CORONA_BY_WORLD'): webbrowser.open( 'https://news.google.com/covid19/map?hl=en-IN&gl=IN&ceid=IN:en')
def processRequest(req): sessionID = req.get('responseId') result = req.get("queryResult") user_says = result.get("queryText") parameters = result.get("parameters") cur = mysql.connection.cursor() cur.execute( "INSERT INTO user_chat_history(sessionId,message, updated_time) VALUES (%s, %s, %s)", (sessionID, "User says: " + user_says + "With parameters:- " + str(parameters), datetime.datetime.utcnow())) mysql.connection.commit() cur.close() name = parameters.get("name") mobile_number = parameters.get("mobile_number") email = parameters.get("email") pin_code = parameters.get("pin_code") geolocator = Nominatim(user_agent="geoapiExercises") location = geolocator.geocode(pin_code) address_info = location.raw["display_name"] print(address_info) data_from_address = geolocator.geocode(address_info, addressdetails=True) address = data_from_address.raw["address"] print(address) country = address["country"] country_code = address["country_code"] if ("state" in address.keys()): state = address["state"] elif ("state_district" in address.keys()): state = address["state_district"] else: state = country if ("city" in address.keys()): city = address["city"] elif ("state_district" in address.keys()): city = address["state_district"] elif ("city_district" in address.keys()): city = address["city_district"] else: city = country if city == "Ahmedabad District": city = "Ahmadabad" if (country == "India"): url = "https://api.covid19india.org/v2/state_district_wise.json" headers = {} response = requests.request("GET", url, headers=headers) res = next( (sub for sub in json.loads(response.text) if sub['state'] == state), None) state_data = res city_data = next( (sub for sub in state_data['districtData'] if sub['district'] in city), None) if city_data != None: total_confimred_cases_in_district = city_data["confirmed"] total_confimred_cases_in_state = sum( d['confirmed'] for d in state_data['districtData'] if d) else: total_confimred_cases_in_district = 0 total_confimred_cases_in_state = 0 print(total_confimred_cases_in_district, total_confimred_cases_in_state) email_sender = EmailSender() template = template_reader.TemplateReader() email_message = template.read_course_template("India_template") email_message = email_message.replace('User', name) email_message = email_message.replace('pin_code', pin_code) email_message = email_message.replace('state', state) email_message = email_message.replace('city', city) email_message = email_message.replace( 'total_No_cases_c', str(total_confimred_cases_in_district)) email_message = email_message.replace( 'total_No_cases_s', str(total_confimred_cases_in_state)) email_sender.send_email_to_student(email, email_message) fulfillmentText = "We have sent the number of corona virus cases in your area and other relevant details to you via email.Do you have further queries?" cur = mysql.connection.cursor() cur.execute( "INSERT INTO user_chat_history(sessionId,message, updated_time) VALUES (%s, %s, %s)", (sessionID, "Bot says: " + fulfillmentText, datetime.datetime.utcnow())) mysql.connection.commit() cur.close() return {"fulfillmentText": fulfillmentText} else: url = "https://covid-19-data.p.rapidapi.com/country/code" querystring = {"format": "json", "code": country_code} headers = { 'x-rapidapi-host': "covid-19-data.p.rapidapi.com", 'x-rapidapi-key': "API-KEY" } response = requests.request("GET", url, headers=headers, params=querystring) counntry_info = json.loads(response.text) confirmed = counntry_info[0]["confirmed"] recovered = counntry_info[0]["recovered"] critical = counntry_info[0]["critical"] deaths = counntry_info[0]["deaths"] email_sender = EmailSender() template = template_reader.TemplateReader() email_message = template.read_course_template("NotIndia_template") email_message = email_message.replace('User', name) email_message = email_message.replace('pin_code', pin_code) email_message = email_message.replace('Country', country) email_message = email_message.replace('total_No_cases_c', str(confirmed)) email_message = email_message.replace('total_No_cases_r', str(recovered)) email_message = email_message.replace('total_No_cases_t', str(critical)) email_message = email_message.replace('total_No_cases_d', str(deaths)) email_sender.send_email_to_student(email, email_message) fulfillmentText = "We have sent the number of corona virus cases in your area and other relevant details to you via email.Do you have further queries?" cur = mysql.connection.cursor() cur.execute( "INSERT INTO user_chat_history(sessionId,message, updated_time) VALUES (%s, %s, %s)", (sessionID, "Bot says: " + fulfillmentText, datetime.datetime.utcnow())) mysql.connection.commit() cur.close() return {"fulfillmentText": fulfillmentText}
def getUserDetails(req): result = req.get("queryResult") user_says = result.get("queryText") name = result.get("parameters").get("user_name") email = result.get("parameters").get("user_mail") mobile = result.get("parameters").get("user_phone") pincode = result.get("parameters").get("user_pin") try: url = "https://api.postalpincode.in/pincode/" + pincode res = requests.get(url) jsonRes = res.json() postOffice = jsonRes[0]["PostOffice"] state = str(postOffice[0]["State"]) if "&" in state: state = state.replace("&", "and") district = str(postOffice[0]["District"]) if "&" in district: district = district.replace("&", "and") if district == "Ahmedabad": district = "Ahmadabad" elif district == "Bangalore": district = "Bengaluru" elif district == "Central Delhi": district = "New Delhi" print(state, end=',') print(district) try: url1 = "https://api.covid19india.org/v2/state_district_wise.json" res1 = requests.get(url1) jsonRes1 = res1.json() stateDistrictData = jsonRes1 for i in range(len(stateDistrictData)): stateDistrictData1 = stateDistrictData[i] if stateDistrictData1["state"] == state: districtData = stateDistrictData1["districtData"] for j in range(len(districtData)): email_sender = EmailSender() if districtData[j]["district"] == district: confirmed = str(districtData[j]["confirmed"]) print(f"\n Confirmed Cases are: {confirmed}") email_file = open( "email-templates/email-template-district.html", "r") email_message = email_file.read() email_sender.sendEmailDistrict( name, email, district, confirmed, email_message) fulfillmentText = "A mail has been sent to you with current COVID-19 cases in your area." bot_says = fulfillmentText return {"fulfillmentText": fulfillmentText} else: fulfillmentText = "Sorry we did not found any data of COVID-19 in " + district + ". It might be a misspelling or we don't have record of the district." bot_says = fulfillmentText return {"fulfillmentText": fulfillmentText} except HTTPError as http_err: print(f"HTTP error occurred: {http_err}") except Exception as err: print(f"Other error occurred: {err}") except HTTPError as http_err: print(f"HTTP error occurred: {http_err}") except Exception as err: print(f"Other error occurred: {err}")