def extractNewTicketData_cust(self, cust_id):
logging.info ('extractTrainingData : Started : ' + str(cust_id))
trainlog = get_model()
traindata = getTrainingModel()
next_page_token = 0
token = None
while next_page_token != None:
ticket_logs, next_page_token = trainlog.list(log_type='tickets', cursor=token, cust_id=cust_id, done=True)
token = next_page_token
for ticket_log in ticket_logs:
tickets_data = ticket_log["json_data"]
tickets_data_json = json.loads(tickets_data)
for ticket_data in tickets_data_json['upload_ticket_data']:
comments = ''
for comment_data in tickets_data_json['upload_comment_data']:
print (comment_data)
#print (ticket_data['id'])
try:
if (comment_data['id'] == ticket_data['id']):
try:
comments = comment_data['comments'][1]['plain_body']
except IndexError as err:
logging.debug(err)
except KeyError as err:
logging.debug(err)
comments = cleanhtml (comments)
description = ticket_data['description']
subject = ticket_data['subject']
id = ticket_data['id']
tags = ', '.join(ticket_data['tags'])
traindata.create(tags, str(str(subject) + ' . ' + str(description)), comments, done=False, id=id, cust_id=cust_id)
trainlog.delete(ticket_log['id'], cust_id=cust_id)
print('Creating for Tickets : ' , id, cust_id)
logging.info ('extractTrainingData : Completed :' + cust_id)
def extractFeedbackData_default(self, src_cust_id='default'):
logging.info ('extractFeedbackData_default : Started : ' + str(src_cust_id))
trainlog = get_model()
traindata = getTrainingModel()
next_page_token = 0
token = None
cust_list, next_page_token2 = getCustomerModel().list(done=True)
while next_page_token != None:
intent_logs, next_page_token = trainlog.list(log_type='feedback', cursor=token, cust_id=src_cust_id, done=True)
token = next_page_token
for intent_log in intent_logs:
intents_data = intent_log["json_data"]
intents_data_json = json.loads(intents_data)
selected_response_id = intents_data_json["selected_response_id"]
cust_id = intents_data_json["ticket_data"]['currentAccount']['subdomain']
id = intents_data_json["ticket_data"]['id']
for cust_id_x in cust_list:
if cust_id_x['cust_name'] == cust_id:
train_data = traindata.read(id, cust_id=cust_id)
response_data = getResponseModel().read(selected_response_id, cust_id=cust_id)
if train_data != None and response_data != None:
traindata.update(train_data["tags"], train_data["query"], train_data["response"], query_category=train_data['query_category'], resp_category=response_data['res_category'], feedback_flag=True, done=True, id=train_data['id'], cust_id=cust_id)
trainlog.delete(intent_log['id'], cust_id=src_cust_id)
print('Updating Feedback : ' , id, cust_id)
logging.info ('extractFeedbackData_default : Completed : ' + str(src_cust_id))
def extractIntentData_default(self, src_cust_id='default'):
logging.info ('extractIntentData_default : Started : ' + str(src_cust_id))
trainlog = get_model()
traindata = getTrainingModel()
next_page_token = 0
token = None
cust_list, next_page_token2 = getCustomerModel().list(done=True)
while next_page_token != None:
intent_logs, next_page_token = trainlog.list(log_type='intent', cursor=token, cust_id=src_cust_id, done=True)
token = next_page_token
for intent_log in intent_logs:
intents_data = intent_log["json_data"]
intents_data_json = json.loads(intents_data)
description = intents_data_json['description']
subject = intents_data_json['subject']
tags = ', '.join(intents_data_json['requester']['tags'])
cust_id = intents_data_json['currentAccount']['subdomain']
id = intents_data_json['id']
response = ''
if len(intents_data_json['comments']) > 0:
response = intents_data_json['comments'][0]['value']
response = cleanhtml (response)
for cust_id_x in cust_list:
if cust_id_x['cust_name'] == cust_id:
traindata.create(tags, str(subject + ' . ' + description), response, id=id, done=False, cust_id=cust_id)
trainlog.delete(intent_log['id'], cust_id=src_cust_id)
print('Creating for Intent : ' , intents_data_json['id'], cust_id)
logging.info ('extractIntentData_default : Completed : ' + str(src_cust_id))
def extractTicketData_default(self, src_cust_id='default'):
logging.info ('extractTicketData_default : Started :' + str(src_cust_id))
trainlog = get_model()
traindata = getTrainingModel()
next_page_token = 0
token = None
cust_list, next_page_token2 = getCustomerModel().list(done=True)
while next_page_token != None:
ticket_logs, next_page_token = trainlog.list(log_type='tickets', cursor=token, cust_id=src_cust_id, done=True)
token = next_page_token
for ticket_log in ticket_logs:
tickets_data = ticket_log["json_data"]
tickets_data_json = json.loads(tickets_data)
for ticket_data in tickets_data_json['tickets']:
description = ticket_data['description']
subject = ticket_data['subject']
tags = ', '.join(ticket_data['tags'])
url = ticket_data['url']
id = ticket_data['id']
for cust_id_x in cust_list:
if cust_id_x['cust_name'] in url:
traindata.create(tags, str(subject + ' . ' + description), '', done=False, id=id, cust_id=cust_id_x['cust_name'])
trainlog.delete(ticket_log['id'], cust_id=src_cust_id)
print('Creating for Ticket Id : ' , ticket_data['id'], cust_id_x['cust_name'])
logging.info ('extractTicketData_default : Completed : ' + str(src_cust_id))
def extractIntentData_cust(self, cust_id):
logging.info ('extractIntentData_cust : Started : ' + str(cust_id))
trainlog = get_model()
traindata = getTrainingModel()
tickets_learn = tickets_learner()
ticket_struct = []
trainlog_struct = []
intent_data = tickets_learn.getTrainingLog(cust_id=cust_id, log_type = 'intent', done=True)
len_traindata = 0
for intent_logs in intent_data:
len_traindata += len (intent_logs)
for intent_log in intent_logs:
intents_data = intent_log["json_data"]
intents_data_json = json.loads(intents_data)
try:
description = intents_data_json['description']
except KeyError as err:
print (err)
continue
description = intents_data_json['description']
subject = intents_data_json['subject']
tags = ', '.join(intents_data_json['requester']['tags'])
response = ''
id = intents_data_json['id']
comment_len = len(intents_data_json['comments'])
if comment_len > 1:
for i in range(comment_len-1, -1, -1):
requester_email = ''
commentor_email = ''
try:
requester_email = intents_data_json['requester']['email']
commentor_email = intents_data_json['comments'][i]['author']['email']
except KeyError as err:
logging.error(err)
break
if requester_email != commentor_email:
response = intents_data_json['comments'][i]['value']
response = cleanhtml (response)
break
ticket_struct.append({'id' : id, 'query' : str(subject + ' . ' + description), 'query_category' : '',
'feedback_flag' : False, 'feedback_prob' : 0, 'done' : False, 'response': response, 'resp_category': '', 'tags' : tags})
trainlog_struct.append({'id' : intent_log['id'], 'type': intent_log['type'], 'created': intent_log['created'], 'json_data': intent_log['json_data'], 'done': False})
logging.info ('No of Training Data Processing : ' + str(len_traindata))
if (len (ticket_struct) > 1):
ticket_pd = pd.DataFrame(ticket_struct)
trainlog_pd = pd.DataFrame(trainlog_struct)
ticket_pd = ticket_pd.drop_duplicates(subset=['id'], keep='last')
trainlog_pd = trainlog_pd.drop_duplicates(subset=['id'], keep='last')
traindata.batchUpdate(ticket_pd, cust_id)
trainlog.batchUpdate(trainlog_pd, cust_id)
logging.info ('extractIntentData_cust : Completed : ' + str(cust_id))
def uploadFeedback():
logging.info('uploadFeedback : ')
received_data = request.json
cust_id = ''
try:
cust_id = received_data['ticket_data']['currentAccount']['subdomain']
except KeyError as err:
logging.info(err)
cust_id = 'default'
cust = getCustomerModel().authenticate(cust_id.strip().lower(), newflag=False)
if cust == None:
cust_id = 'default'
else:
cust_id = cust['cust_name']
logging.info('Customer Id : ' + str(cust_id))
get_model().create('feedback', json.dumps(request.json), done=True, cust_id=cust_id)
return '200'
def copyOldTrainingLog(self):
logging.info ('copyOldTrainingLog : Starting')
trainlog = get_model()
next_page_token = 0
token = None
while next_page_token != None:
ticket_logs, next_page_token = trainlog.list(cursor=token, cust_id='', done=True)
token = next_page_token
for ticket_log in ticket_logs:
trainlog.create(ticket_log['type'], ticket_log['json_data'], created=ticket_log['created'], done=True, cust_id='default')
trainlog.delete(id=ticket_log['id'], cust_id='')
print ('Copying Old data: ' , ticket_log['id'])
print ('copyOldTrainingLog: Completed ')
def predictIntent():
logging.info('predictIntent : ')
intent_input = ''
cust_id = ''
intenteng = IntentExtractor()
ticketLearner = tickets_learner()
utilclass = UtilityClass()
received_data = request.json
try:
cust_id = received_data['currentAccount']['subdomain']
except KeyError as err:
logging.error(err)
cust_id = 'default'
cust = getCustomerModel().authenticate(cust_id.strip().lower(), newflag=False)
if cust == None:
cust_id = 'default'
else:
cust_id = cust['cust_name']
logging.info('Customer Id : ' + str(cust_id))
get_model().create('intent', json.dumps(request.json), done=True, cust_id=cust_id)
len_comment = len(received_data['comments'])
if ((len_comment > 0) and (received_data['requester']['email'] == received_data['comments'][0]['author']['email'])):
intent_input = utilclass.cleanhtml(received_data['comments'][0]['value'])
else:
intent_input = utilclass.cleanhtml(received_data['description'] + '. ' + received_data['subject'])
predicted_intent = intenteng.getIntentForText(intent_input, cust_id)
formatted_resp = ticketLearner.formatOutput(predicted_intent, cust_id)
logging.info('\'' + str(intent_input) + '\' >> ' + str(formatted_resp))
json_resp = json.dumps(formatted_resp)
#get_model().create('response', json_resp, done=True, cust_id=cust_id)
return json_resp
def extractFeedbackData_cust(self, cust_id):
logging.info ('extractFeedbackData_cust : Started : ' + str(cust_id))
trainlog = get_model()
traindata = getTrainingModel()
respdata = getResponseModel()
tickets_learn = tickets_learner()
ticket_struct = []
trainlog_struct = []
intent_data = tickets_learn.getTrainingLog(cust_id=cust_id, log_type = 'feedback', done=None)
len_traindata = 0
for intent_logs in intent_data:
len_traindata += len (intent_logs)
for intent_log in intent_logs:
intents_data = intent_log["json_data"]
intents_data_json = json.loads(intents_data)
selected_response_id = intents_data_json["selected_response_id"]
selected_response_prob = (intents_data_json["selected_response_prob"]/100) if 'selected_response_prob' in intents_data_json else 0
cust_id = intents_data_json["ticket_data"]['currentAccount']['subdomain']
id = intents_data_json["ticket_data"]['id']
train_data = traindata.read(id, cust_id=cust_id)
response_data = respdata.read(selected_response_id, cust_id=cust_id)
if train_data != None and response_data != None:
'''
traindata.update(train_data["tags"], train_data['query'], response_data["response_text"], query_category=train_data['query_category'],
resp_category=train_data['resp_category'], feedback_resp=response_data['res_category'],
feedback_flag=True, feedback_prob=selected_response_prob, predict_prob = train_data['predict_prob'],
done=True, id=train_data['id'], cust_id=cust_id)
'''
ticket_struct.append({'id' : train_data['id'], 'query' : train_data['query'], 'query_category' : train_data['query_category'],
'response': response_data["response_text"], 'resp_category': train_data['resp_category'],
'feedback_resp' : response_data['res_category'], 'feedback_flag' : True, 'feedback_prob' : selected_response_prob,
'predict_prob': train_data['predict_prob'] if 'predict_prob' in train_data else 0,
'done' : train_data['done'], 'tags' : train_data['tags']})
trainlog_struct.append({'id' : intent_log['id'], 'type': intent_log['type'], 'created': intent_log['created'],
'json_data': intent_log['json_data'], 'done': False})
print('Updating Feedback : ' , id, cust_id)
logging.info ('No of Training Data Processing : ' + str(len_traindata))
if (len (ticket_struct) > 1):
ticket_pd = pd.DataFrame(ticket_struct)
trainlog_pd = pd.DataFrame(trainlog_struct)
ticket_pd = ticket_pd.drop_duplicates(subset=['id'], keep='last')
trainlog_pd = trainlog_pd.drop_duplicates(subset=['id'], keep='last')
traindata.batchUpdate(ticket_pd, cust_id)
trainlog.batchUpdate(trainlog_pd, cust_id)
logging.info ('extractFeedbackData_cust : Completed : ' + str(cust_id))
def copyDefaultTrainingLog(self):
logging.info ('copyDefaultTrainingLog : Started :' )
trainlog = get_model()
traindata = getTrainingModel()
next_page_token = 0
token = None
cust_list, next_page_token2 = getCustomerModel().list(done=True)
while next_page_token != None:
ticket_logs, next_page_token = trainlog.list(cursor=token, cust_id='default', done=True)
token = next_page_token
for ticket_log in ticket_logs:
tickets_data = ticket_log["json_data"]
if (ticket_log['type'] == 'response'):
continue
tickets_data_json = json.loads(tickets_data)
tik_data1 = None
try :
tik_data1 = tickets_data_json['ticket_data']
except KeyError as err:
tik_data1 = None
if tik_data1 == None: # Intent / Old TIcket
tik_data2 = None
try :
tik_data2 = tickets_data_json['currentAccount']['subdomain']
except KeyError as err:
tik_data2 = None
if tik_data2 != None: # Intent
cust_id = tickets_data_json['currentAccount']['subdomain']
for cust_id_x in cust_list:
if cust_id_x['cust_name'] == cust_id:
trainlog.create(ticket_log['type'], ticket_log['json_data'], created=ticket_log['created'], done=True, cust_id=cust_id)
trainlog.delete(id=ticket_log['id'], cust_id='default')
print ('Copying Intent data: ' , ticket_log['id'], cust_id)
continue
tik_data3 = None
try :
tik_data3 = tickets_data_json['tickets'][0]['url']
except KeyError as err:
tik_data3 = None
if tik_data3 != None : # Old Ticket
url = tickets_data_json['tickets'][0]['url']
for cust_id_x in cust_list:
if cust_id_x['cust_name'] in url:
cust_id = cust_id_x['cust_name']
trainlog.create(ticket_log['type'], ticket_log['json_data'], created=ticket_log['created'], done=True, cust_id=cust_id)
trainlog.delete(id=ticket_log['id'], cust_id='default')
print ('Copying Old Ticket data: ' , ticket_log['id'], cust_id)
continue
else: # New Ticket and Feedback
tik_data4 = None
try :
tik_data4 = tickets_data_json['ticket_data']['currentAccount']['subdomain']
except KeyError as err:
tik_data4 = None
if tik_data4 != None:
cust_id = tickets_data_json["ticket_data"]['currentAccount']['subdomain']
for cust_id_x in cust_list:
if cust_id_x['cust_name'] == cust_id:
trainlog.create(ticket_log['type'], ticket_log['json_data'], created=ticket_log['created'], done=True, cust_id=cust_id)
trainlog.delete(id=ticket_log['id'], cust_id='default')
print ('Copying New Ticket/Feedback data: ' , ticket_log['id'], cust_id)
continue
logging.info ('copyDefaultTrainingLog : Completed : ')
def create_app(config, debug=False, testing=False, config_overrides=None):
app = Flask(__name__)
app.config.from_object(config)
storage = StorageOps()
app.debug = debug
app.testing = testing
if config_overrides:
app.config.update(config_overrides)
# Configure logging
if not app.testing:
logging.basicConfig(level=logging.INFO)
logging.getLogger().setLevel(logging.INFO)
# Setup the data model.
with app.app_context():
model = get_model()
model.init_app(app)
storage.create_bucket()
# Register the Bookshelf CRUD blueprint.
from .crud import crud
app.register_blueprint(crud, url_prefix='/smartreply')
# Add a default root route.
@app.route("/")
def index():
return redirect(url_for('crud.login'))
@app.route('/intent', methods=['POST'])
def predictIntent():
logging.info('predictIntent : ')
intent_input = ''
cust_id = ''
intenteng = IntentExtractor()
ticketLearner = tickets_learner()
utilclass = UtilityClass()
received_data = request.json
try:
cust_id = received_data['currentAccount']['subdomain']
except KeyError as err:
logging.error(err)
cust_id = 'default'
cust = getCustomerModel().authenticate(cust_id.strip().lower(), newflag=False)
if cust == None:
cust_id = 'default'
else:
cust_id = cust['cust_name']
logging.info('Customer Id : ' + str(cust_id))
get_model().create('intent', json.dumps(request.json), done=True, cust_id=cust_id)
len_comment = len(received_data['comments'])
if ((len_comment > 0) and (received_data['requester']['email'] == received_data['comments'][0]['author']['email'])):
intent_input = utilclass.cleanhtml(received_data['comments'][0]['value'])
else:
intent_input = utilclass.cleanhtml(received_data['description'] + '. ' + received_data['subject'])
predicted_intent = intenteng.getIntentForText(intent_input, cust_id)
formatted_resp = ticketLearner.formatOutput(predicted_intent, cust_id)
logging.info('\'' + str(intent_input) + '\' >> ' + str(formatted_resp))
json_resp = json.dumps(formatted_resp)
#get_model().create('response', json_resp, done=True, cust_id=cust_id)
return json_resp
@app.route('/entity', methods=['POST'])
def extractEntity():
Received = request.json
Email_Content = ""
if 'query' in Received:
Email_Content = Received['query']
predicted_entity = entityeng.POS_Tagging(Email_Content)
resp = {}
resp["Entity_values"] = predicted_entity
json_resp = json.dumps(resp)
return json_resp
@app.route('/uploadtickets', methods=['POST'])
def uploadTickets():
logging.info('uploadTickets : ')
cust_id = ''
received_data = request.json
#print (received_data)
try:
cust_id = received_data['ticket_data']['currentAccount']['subdomain']
except KeyError as err:
logging.error(err)
return '200'
cust = getCustomerModel().authenticate(cust_id.strip().lower(), newflag=False)
if cust == None:
cust_id = 'default'
else:
cust_id = cust['cust_name']
logging.info('Customer Id : ' + str(cust_id))
get_model().create('tickets', json.dumps(request.json), done=True, cust_id=cust_id)
return '200'
@app.route('/uploadarticles', methods=['POST'])
def uploadArticles():
logging.info('uploadArticles : ')
cust_id = ''
received_data = request.json
#print (received_data)
try:
cust_id = received_data['ticket_data']['currentAccount']['subdomain']
except KeyError as err:
logging.error(err)
return '200'
cust = getCustomerModel().authenticate(cust_id.strip().lower(), newflag=False)
if cust == None:
cust_id = 'default'
else:
cust_id = cust['cust_name']
logging.info('Customer Id : ' + str(cust_id))
response_struct = []
article_data = received_data['article_data']
respdata = getResponseModel()
for items in article_data:
response_text = str(items['body'])
resp_name = items['title'].split()[:5]
resp_name = ' '.join(resp_name).title().replace(" ", "_")
utils_class = UtilityClass()
response_text = utils_class.cleanhtml(response_text)
if len(response_text) > 600:
response_text = str ('Please find response for your query at following link. \n ' + items['html_url'])
response_struct.append({'id' : items['id'], 'resp_name': resp_name, 'res_category': str(cust_id + '_Article_' + str(items['id'])),
'response_text' : response_text, 'tags' : items['title'],
'modifiedflag': False, 'defaultflag' : False, 'resp_tags' : '', 'created': datetime.datetime.utcnow(),
'done': True})
if (len (response_struct) > 1):
response_pd = pd.DataFrame(response_struct)
respdata.batchUpdate(response_pd, cust_id)
return '200'
@app.route('/uploadfeedback', methods=['POST'])
def uploadFeedback():
logging.info('uploadFeedback : ')
received_data = request.json
cust_id = ''
try:
cust_id = received_data['ticket_data']['currentAccount']['subdomain']
except KeyError as err:
logging.info(err)
cust_id = 'default'
cust = getCustomerModel().authenticate(cust_id.strip().lower(), newflag=False)
if cust == None:
cust_id = 'default'
else:
cust_id = cust['cust_name']
logging.info('Customer Id : ' + str(cust_id))
get_model().create('feedback', json.dumps(request.json), done=True, cust_id=cust_id)
return '200'
@app.route('/getticketflag', methods=['POST'])
def getTicketFlag():
logging.info('getTicketFlag : ')
cust_id = ''
received_data = request.json
try:
cust_id = received_data['currentAccount']['subdomain']
except KeyError as err:
logging.error(err)
cust_id = 'default'
cust = getCustomerModel().authenticate(cust_id.strip().lower(), newflag=False)
if cust == None:
cust_id = 'default'
else:
cust_id = cust['cust_name']
logging.info('Customer Id : ' + str(cust_id))
if cust_id == 'default':
status_flag = False
else:
status_flag = getCustomerModel().getTicketFlag(cust_id)
resp = {}
resp["Ticket_Flag"] = status_flag
json_resp = json.dumps(resp)
return json_resp
@app.errorhandler(404)
def not_found(error):
return make_response(jsonify({'error': 'Not found'}), 404)
@app.errorhandler(500)
def server_error(e):
return """
An internal error occurred: <pre>{}</pre>
See logs for full stacktrace.
""".format(e), 500
return app
