def oldt(tid):
query = "select * from Tickets where `Incident ID` = '" + str(tid) + "';"
df = create_db.fetchquery(query)
text = 'You had ' + str(df.loc[df["Incident ID"] == str(
tid)].Description.values[0]) + ' issue and status is ' + str(
df.loc[df["Incident ID"] == str(tid)].Status.values[0])
return text
def assign(tid, macid):
outp = create_db.updatenew(tid)
# df = create_db.get_data()
query = "select * from tickets where `Incident ID` ='" + str(
tid) + "';"
print(query)
df = create_db.fetchquery(query)
print(df["Issue_Class"][0])
assignticket.Ticketassign_2(str(tid))
query = "select emailid from userdetails where MAC_ID = '" + macid + "';"
df2 = create_db.fetchquery(query)
email = df2.iloc[0]["emailid"]
generate_mail.updateticket(email, df["Issue_Class"][0], str(tid))
if outp == 'Updated':
return 'Assigned to Expert.'
else:
return 'Some Error While Resolving Issue'
return 'Assigned to Expert.'
def upt(tid, macid):
outp = create_db.updatenew(tid)
# df = create_db.get_data()
query = "select * from tickets where `Incident ID` ='" + str(
tid) + "';"
print(query)
df = create_db.fetchquery(query)
print(df["Issue_Class"][0])
updateticketstatus.updateTicket_2(
str(tid), 'Resolved', 'Issue has been successfully resolved')
query = "select emailid from userdetails where MAC_ID = '" + macid + "';"
df2 = create_db.fetchquery(query)
email = df2.iloc[0]["emailid"]
generate_mail.updateticket(email, df["Issue_Class"][0], str(tid))
if outp == 'Updated':
return 'Ticket resolved successfully'
else:
return 'Some Error While Resolving Issue'
return 'Ticket resolved successfully'
def inoutserver(macid):
print(macid)
df = create_db.fetchquery(
'select * from userdetails where MAC_ID = "' + str(macid) + '";')
print(df)
ins = df['IN_SERVER'][0]
print(ins)
outs = df['OUT_SERVER'][0]
print(outs)
data = {'inserver': str(ins), 'outserver': str(outs)}
return jsonify({'inserver': str(ins), 'outserver': str(outs)})
def newt(symptom, description, macid):
print(symptom, description)
query = "select emailid from userdetails where MAC_ID = '" + macid + "';"
df = create_db.fetchquery(query)
email = df.iloc[0]["emailid"]
t_id = createticket.loginAndCreateTickets(symptom, description)
# t_id = "456"
print(t_id)
predict(macid)
generate_mail.raiseticket(str(email), 'issue', t_id)
return str(t_id)
def updateTicket_2(ticket_id, status, solution):
config.logger.exception('In update ticket part')
# df = create_db.get_data()
query = "select * from Tickets where `Incident ID` ='" + ticket_id + "';"
df = create_db.fetchquery(query)
# print(df)
df.loc[df["Incident ID"] == ticket_id, 'Status'] = status
df.loc[df["Incident ID"] == ticket_id, 'Solution'] = solution
ret = create_db.update(df)
config.logger.exception('data updated in db')
updateTicket(df.loc[df.Status == "Resolved"])
config.logger.exception('ticket updated in itsm')
def Ticketassign_2(ticket_id):
config.logger.exception('In update ticket part')
query = "select * from tickets where `Incident ID` ='" + ticket_id + "';"
df = create_db.fetchquery(query)
# df = pd.read_csv("test.csv")
print(df)
df.loc[df["Incident ID"] == ticket_id, 'Status'] = "Fail"
df.loc[df["Incident ID"] == ticket_id, 'Solution'] = "Assigned to expert."
ret = create_db.update(df)
config.logger.exception('data updated in db')
Ticketassign(df.loc[df.Status == "Fail"])
config.logger.exception('ticket updated in itsm')
def newt(subject, description, macid):
print(subject, description, macid)
r_json = manage_engine_ticket_raising.ticket_raising(
subject, description, config["DEFAULT"]["name manage"],
config["DEFAULT"]["id manage"])
# print(r_json)
t_id = r_json['request']['id']
# t_id = "456"
print(t_id)
predict(macid)
query = "select emailid from userdetails where MAC_ID = '" + macid + "';"
df = create_db.fetchquery(query)
email = df.iloc[0]["emailid"]
mail_send.raiseticket(str(email), 'issue', t_id)
return str(t_id)
def upt(tid):
outp = create_db.updatenew(tid)
query = "select * from Tickets where `Incident ID` ='" + str(tid) + "';"
print(query)
df = create_db.fetchquery(query)
print(df["Issue_Class"][0])
updateticketstatus.updateTicket_2(str(tid), 'Resolved',
'Issue has been successfully resolved')
generate_mail.updateticket("*****@*****.**", df["Issue_Class"][0],
str(tid))
if outp == 'Updated':
return 'Ticket resolved successfully'
else:
return 'Some Error While Resolving Issue'
return 'Ticket resolved successfully'
def updatetickets(ticket_id, status, solution):
# config.logger.exception("In update ticket part")
query = "select * from tickets where `Incident ID` = '" + ticket_id + "';"
df = create_db.fetchquery(query)
df.loc[df["Incident ID"] == ticket_id, 'Status'] = status
df.loc[df["Incident ID"] == ticket_id, 'Solution'] = solution
print(df)
ret = create_db.update(df)
# config.logger.exception('data updated in db')
ticket_updation(df.loc[df.Status == "Resolved"])
# config.logger.exception('ticket updated in itsm')
# s = ticket_updation(df)
def assigntickets(ticket_id):
# config.logger.exception("In update ticket part")
query = "select * from tickets where `Incident ID` = '" + str(
ticket_id) + "';"
df = create_db.fetchquery(query)
df.loc[df["Incident ID"] == str(ticket_id), 'Status'] = "Fail"
df.loc[df["Incident ID"] == str(ticket_id),
'Solution'] = "assigned to different technician"
print(df)
ret = create_db.update(df)
# config.logger.exception('data updated in db')
assignto(df.loc[df.Status == "Fail"])
# config.logger.exception('ticket updated in itsm')
# assigntickets(10)
def getall():
query = 'select MAC_ID from userdetails'
df = create_db.fetchquery(query)
df = df.to_json()
return df
def know(macid):
query = "select * from tickets where MAC_ID = '" + macid + "';"
df = create_db.fetchquery(query)
df = df.to_json()
return df
