def check_vitals():
error = None
# nurseID = request.form['nurseID']
patID = request.form['patID']
temp = request.form['temp']
pulse_arg = request.form['pulse_arg']
bp = request.form['bp']
resp = request.form['resp']
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['USR']) as con:
usr = con.login()
nurseID = usr[1]
if request.method == 'POST':
if app.config['SQL_CRED']['USR'] == '' or app.config['SQL_CRED'][
'PWD'] == '':
error = 'Invalid Credentials. Please try again.'
else:
with dataconnector.Connection(
app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['USR']) as con:
print(nurseID, patID, temp, pulse_arg, bp, resp)
con.check_vitals(nurseID, patID, temp, pulse_arg, bp, resp)
return render_template('home.html',
usr=app.config['SQL_CRED']['USR'])
return render_template('home.html', usr=app.config['SQL_CRED']['USR'])
def make_diagnosis():
error = None
# docID = request.form['docID']
patID = request.form['patID']
icdID = request.form['icdID']
# icdDesc = request.form['desc']
icdname = request.form['desc'] # icdname
specifics = request.form['specs']
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['USR']) as con:
usr = con.login()
docID = usr[1]
icdDesc = icdservice.get_entity_description(icdID)
if request.method == 'POST':
if app.config['SQL_CRED']['USR'] == '' or app.config['SQL_CRED'][
'PWD'] == '':
error = 'Invalid Credentials. Please try again.'
else:
with dataconnector.Connection(
app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['USR']) as con:
print(docID, patID, icdID, icdDesc, icdname, specifics)
con.make_diagnosis(docID, patID, icdID, icdDesc, icdname,
specifics)
return render_template('home.html',
usr=app.config['SQL_CRED']['USR'])
return render_template('home.html', usr=app.config['SQL_CRED']['USR'])
def GetInternPerformanceData():
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['PWD']) as con:
data = con.GetInternPerformanceData()
data_top = con.GetInternsByMostPatient()
id_most = [(str(d[0]) + ' ' + str(d[1])) for d in data_top]
for_legend = list(set([(str(d[1]) + ' ' + str(d[2])) for d in data]))
temp = []
for d in for_legend:
if d in id_most:
temp += [d + '*']
else:
temp += [d]
for_legend = temp
for_label = list(set([(str(d[4])) for d in data]))
for_label.sort()
for_series = []
for name in for_legend:
series = []
for date in for_label:
for d in data:
if (str(d[4]) == date) and (str(d[1]) + ' ' + str(d[2])
== name.replace('*', '')):
series.append(d[3])
for_series += [series]
return {
'legendNames': for_legend,
'labels': for_label,
'series': for_series
}
def GetNursesByPatientAndDate():
if (request.args.get('patID') == ''):
patID = 0
else:
patID = request.args.get('patID')
# if (request.args.get('startDate') == ''):
# startDate = 0
# else:
# startDate = request.args.get('startDate')
# if (request.args.get('endDate') == ''):
# endDate = 0
# else:
# endDate = request.args.get('endDate')
print('patID:', patID)
startDate = datetime.date(datetime.now()) - timedelta(days=7)
endDate = datetime.date(datetime.now())
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['USR']) as con:
nurses = con.GetNursesByPatientAndDate(startDate, endDate, patID)
if nurses and len(nurses) > 0:
print("YEP! Good to go!")
else:
nurses = [(' ', ' ', ' ', ' ', ' ', ' ')]
columns = [
'nurse_ID', 'fname', 'lname', 'gen_name', 'dosage', 'date_time'
]
nurses = jsonify([{k: str(val)
for val, k in zip(row, columns)} for row in nurses])
print(nurses)
return nurses
def GetMedicineAllergyByMostPatients_forchart():
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['PWD']) as con:
medz = con.GetMedicineAllergyByMostPatients()
return {
'labels': [('MED-' + str(med[0])) for med in medz],
'series': [med[2] for med in medz]
}
def GetPatientByDiagnosisAndDate(q=""):
startDate = datetime.date(datetime.now()) - timedelta(days=7)
endDate = datetime.date(datetime.now())
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['PWD']) as con:
pats = con.GetPatientByDiagnosisAndDate(startDate, endDate, q)
pats = [[str(val) for val in row] for row in pats]
return pats
def home(usr):
try:
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['PWD']) as con:
usr = con.login()
except Exception as e:
return render_template('home.html', error_msg=e)
finally:
return render_template('home.html', usr=usr + 'lol')
def get_patients():
search = request.args.get('search')
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['PWD']) as con:
pats = con.get_patients(search)
columns = ['pat_ID', 'fname', 'lname', 'dob', 'address', 'phone']
pats = jsonify([{k: str(val)
for val, k in zip(row, columns)} for row in pats])
print(pats)
return pats
def get_nurses_by_patient_and_date():
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['USR']) as con:
nurses = con.get_nurses_by_patient_and_date(request.form['start_date'],
request.form['end_date'],
request.form['patID'])
columns = ['nurse_id', 'fname', 'lname']
nurses = jsonify([{k: str(val)
for val, k in zip(row, columns)} for row in nurses])
print(nurses)
return nurses
def get_medicine_allergy_by_most_patients():
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['USR']) as con:
# DO WE NEED THIS?
med_allergies = con.get_medicine_allergy_by_most_patients(
request.form['patID'])
columns = ['med_ID', 'gen_name']
med_allergies = jsonify([{k: str(val)
for val, k in zip(row, columns)}
for row in med_allergies])
print(med_allergies)
return med_allergies
def GetPatientByDiagnosisAndDate():
search = request.args.get('search')
# print(search)
startDate = datetime.date(datetime.now()) - timedelta(days=7)
endDate = datetime.date(datetime.now())
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['USR']) as con:
pats = con.GetPatientByDiagnosisAndDate(startDate, endDate, search)
columns = ['pat_ID', 'fname', 'lname', 'dob', 'address', 'phone']
pats = jsonify([{k: str(val)
for val, k in zip(row, columns)} for row in pats])
print(pats)
return pats
def get_interns_by_most_patients():
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['USR']) as con:
# DO WE NEED THIS?
interns = con.get_interns_by_most_patients(request.form['start_date'],
request.form['end_date'],
request.form['patID'])
columns = ['fname', 'lname']
interns = jsonify([{k: str(val)
for val, k in zip(row, columns)}
for row in interns])
print(interns)
return interns
def login():
error = None
if request.method == 'POST':
app.config.update(SQL_CRED=dict(USR=request.form['username'],
PWD=request.form['password']))
if app.config['SQL_CRED']['USR'] == '' or app.config['SQL_CRED'][
'PWD'] == '':
error = 'Invalid Credentials. Please try again.'
else:
with dataconnector.Connection(
app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['USR']) as con:
usr = con.login()
return render_template('home.html', usr=usr[0])
return render_template('login.html', error=error)
def reg_patient():
error = None
if request.method == 'POST':
if app.config['SQL_CRED']['USR'] == '' or app.config['SQL_CRED'][
'PWD'] == '':
error = 'Invalid Credentials. Please try again.'
else:
with dataconnector.Connection(
app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['USR']) as con:
con.add_patient(request.form['fname'], request.form['lname'],
request.form['dob'], request.form['address'],
request.form['phone'])
return render_template('home.html',
usr=app.config['SQL_CRED']['USR'])
return render_template('home.html', usr=app.config['SQL_CRED']['USR'])
def get_allergens_of_patient():
if (request.args.get('patID') == ''):
patID = 0
else:
patID = request.args.get('patID')
print('patID:', patID)
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['USR']) as con:
allergens = con.get_allergens_of_patient(patID)
if allergens and len(allergens) > 0:
print("YEP! Good to go!")
else:
allergens = [(' ', ' ', ' ', ' ', ' ')]
columns = [
'AllergenID', 'AllergenType', 'Allergen', 'FirstName', 'LastName'
]
allergens = jsonify([{k: str(val)
for val, k in zip(row, columns)}
for row in allergens])
print(allergens)
return allergens
def GetResultsByPatient():
if (request.args.get('patID') == ''):
patID = 0
else:
patID = request.args.get('patID')
print('patID:', patID)
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['USR']) as con:
pat_results = con.GetResultsByPatient(patID)
if pat_results and len(pat_results) > 0:
print("YEP! Good to go!")
else:
pat_results = [(' ', ' ', ' ', ' ', ' ')]
columns = [
'TestType', 'TestName', 'TestResult', 'Attachment', 'TestDate'
]
pat_results = jsonify([{k: str(val)
for val, k in zip(row, columns)}
for row in pat_results])
print(pat_results)
return pat_results
def get_patients(q=""):
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['PWD']) as con:
pats = con.get_patients(q)
pats = [[str(val) for val in row] for row in pats]
return pats
def GetInternPerformanceData_perm():
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['PWD']) as con:
data = con.GetInternPerformanceData()
if (data):
return 1
def GetMedicineAllergyByMostPatients_perm():
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['PWD']) as con:
medz = con.GetMedicineAllergyByMostPatients()
if (medz):
return 1
def get_nurses():
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['PWD']) as con:
nurses = con.get_nurses()
return nurses
def get_doctors():
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['PWD']) as con:
doctors = con.get_doctors()
return doctors
def get_role():
with dataconnector.Connection(app.config['SQL_CRED']['USR'],
app.config['SQL_CRED']['PWD']) as con:
tuple = con.get_role()
return tuple