def createPatient():
if request.method == 'POST':
ssnid = request.form['ssnid']
name = request.form['name']
age = request.form['age']
admission = request.form['admission']
bed = request.form['bed']
address = request.form['address']
city = request.form['city']
state = request.form['state']
if db.isPatientSsnidExist(ssnid):
flash("Patient already exist", 'red')
return redirect(url_for("createPatient"))
response = db.createPatient(ssnid, name, age, admission, bed, address,
city, state)
if response[0]:
flash("Patient creation initiated successfully", 'green')
return redirect(url_for("index"))
else:
flash(response[1], 'red')
return redirect(url_for("createPatient"))
elif request.method == 'GET':
return render_template('createPatient.html')
def finalBilling():
if request.method == 'POST':
if 'ssnid' in request.form:
ssnid = request.form['ssnid']
if db.isPatientSsnidExist(ssnid):
responce1 = db.getPatientSsnidDetails(ssnid)
responce2 = db.getPatientMedicineDetails(ssnid)
responce3 = db.getPatientDiagnosticsDetails(ssnid)
responce4 = db.dischargePatient(ssnid)
responce5 = db.getSumOfPatientMedicineDetails(ssnid)
tot_med = responce5[0]['rate']
responce6 = db.getSumOfPatientDiagnosticsDetails(ssnid)
tot_diag = responce6[0]['amount']
for k, v in responce1.items():
if k == 'admission_date':
doj = v
if k == 'bed':
roomType = v
doj = datetime.strptime(doj, '%d-%m-%Y')
dod = datetime.today().strftime('%d-%m-%Y')
dod = datetime.strptime(dod, '%d-%m-%Y')
noOfDays = dod - doj
if noOfDays.days == 0:
noOfDays = 1
if roomType == 'Single':
billforRoom = noOfDays.days * 8000
elif roomType == 'Semi':
billforRoom = noOfDays.days * 4000
else:
billforRoom = noOfDays.days * 2000
return render_template('finalBilling.html',
data1=responce1,
data2=responce2[1],
data3=responce3[1],
days=noOfDays.days,
room_rent=billforRoom,
pharmacy_bill=tot_med,
diagnostic_bill=tot_diag,
flag=True)
else:
flash("Patient does not exist", 'red')
return redirect(url_for('index'))
elif request.method == 'GET':
return render_template('finalBilling.html', flag=False)
def searchPatient():
if request.method == 'POST':
if 'ssnid' in request.form:
ssnid = request.form['ssnid']
if db.isPatientSsnidExist(ssnid):
patient_data = db.getPatientSsnidDetails(ssnid)
return render_template('searchPatient.html',
data=patient_data,
flag=True)
else:
return redirect(url_for('searchPatient'))
elif request.method == 'GET':
return render_template('searchPatient.html', flag=False)
def preUpdatePatient():
if request.method == 'POST':
if 'ssnid' in request.form:
ssnid = request.form['ssnid']
if db.isPatientSsnidExist(ssnid):
patient_data = db.getPatientSsnidDetails(ssnid)
return render_template("updatePatient.html",
data=patient_data,
flag=True)
else:
flash("Patient does not exist", 'red')
return redirect(url_for('preUpdatePatient'))
elif request.method == 'GET':
return render_template('updatePatient.html', flag=False)
def getPatientDiagnosticsDetails():
if request.method == 'POST':
if 'ssnid' in request.form:
ssnid = request.form['ssnid']
if db.isPatientSsnidExist(ssnid):
responce1 = db.getPatientSsnidDetails(ssnid)
responce2 = db.getPatientDiagnosticsDetails(ssnid)
responce3 = db.getDiagnosticsDetails()
return render_template('getPatientDiagnosticDetails.html',
data1=responce1,
data2=responce2[1],
data3=responce3[1],
flag=True)
else:
flash("Patient doesnot exist", 'red')
return redirect(url_for('index'))
elif request.method == 'GET':
return render_template('getPatientDiagnosticDetails.html', flag=False)
def getPatientMedicineDetails():
if request.method == 'POST':
if 'ssnid' in request.form:
ssnid = request.form['ssnid']
if db.isPatientSsnidExist(ssnid):
responce1 = db.getPatientSsnidDetails(
ssnid
) #Medicine quantity decrese and Patient_Medicine add row
responce2 = db.getPatientMedicineDetails(ssnid)
responce3 = db.getMedicineDetails()
return render_template('getPatientMedicineDetails.html',
data1=responce1,
data2=responce2[1],
data3=responce3,
flag=True)
else:
flash("Patient doesnot exist", 'red')
return redirect(url_for('index'))
elif request.method == 'GET':
return render_template('getPatientMedicineDetails.html', flag=False)