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)