def add_user(username, password, user_type): myCursor = myDb.cursor() myCursor.execute("select username from userstore") if username in list(map(lambda x: x[0], myCursor.fetchall())): flash("This username already exists. Try another One!", "danger") return redirect(url_for('index')) myCursor.execute( "insert into userstore(username, password, user_type) values('{}', '{}', '{}')" .format(username, generate_password_hash(password), user_type)) myDb.commit() myCursor = myDb.cursor() flash( "User {} created successfully! User can start using this id.".format( username), "success") return redirect(url_for('main.index'))
def showQuantity(): req = request.get_json(force=True) print(req) myCursor = myDb.cursor() myCursor.execute("select quantity,rate from medicinesmaster where med_name = '%s'" % (req['medicine'])) myResult = myCursor.fetchall() return jsonify(myResult)
def showRate(): req = request.get_json(force=True) print(req) myCursor = myDb.cursor() myCursor.execute( "select rate from diagnosticsmaster where test_name = '%s'" % (req['test'])) myResult = myCursor.fetchall() return jsonify(myResult)
def fetchPatientDetails(): myResult = [] req = request.get_json(force=True) patientId = req.get('patientID') if patientId != None and patientId != '': myCursor = myDb.cursor() myCursor.execute("SELECT ws_pat_name,ws_age,ws_doj,ws_rtype,ws_adrs,state,city FROM patient where ws_pat_id = %s" % (int(patientId))) myResult = myCursor.fetchall() myCursor.close() if myResult == []: return jsonify({"message": "Patient ID dosesn't exist"}) else: return jsonify({"message": "Please enter full 9 digit Patient ID"}) myCursor = myDb.cursor() myCursor.execute("select medicinesmaster.med_name, medicines.quan_issued, medicinesmaster.rate from medicines JOIN medicinesmaster on medicines.ws_med_id = medicinesmaster.med_id where medicines.ws_pat_id = %s order by medicinesmaster.med_name" % (patientId)) myResult.extend(myCursor.fetchall()) myCursor.close() return jsonify(myResult)
def search(): myresult = [] c = 0 msg = "Patient ID Does'nt Exists" if request.method == 'POST': form = request.form search_value = request.form['patient_id'] c = int(search_value) myCursor = myDb.cursor() myCursor.execute( """SELECT ws_pat_name,ws_age,ws_doj,ws_rtype,ws_adrs,state,city FROM patient where ws_pat_id = %s """ % (c)) myresult = myCursor.fetchall() return render_template('search.html', myresult=myresult, c=c)
def addTests(): req = request.get_json(force=True) print(req) patientIDDict = req.pop(0) for i in req: myCursor = myDb.cursor() myCursor.execute( "select test_id from diagnosticsmaster where test_name = '%s'" % (i['Test'].upper())) myResult = myCursor.fetchall() testId = myResult[0][0] myCursor.execute("insert into diagnosticstable values({}, {})".format( int(patientIDDict['patientID']), testId)) myCursor.close() myDb.commit() return jsonify({"message": "Tests Added Successfully"})
def issueMedicines(): req = request.get_json(force=True) print(req) patientIDDict = req.pop(0) for i in req: myCursor = myDb.cursor() myCursor.execute("select med_id from medicinesmaster where med_name = '%s'" % (i['Medicine'].upper())) myResult = myCursor.fetchall() medId = myResult[0][0] myCursor.execute("update medicinesmaster set quantity = quantity - {} where med_id = {}".format(int(i['Quantity']), medId)) myCursor.execute("select * from medicines where ws_pat_id = {} and ws_med_id = {}".format(int(patientIDDict['patientID']), medId)) myResult = myCursor.fetchall() if myResult == []: myCursor.execute("insert into medicines values({}, {}, {})".format(int(patientIDDict['patientID']), medId, int(i['Quantity']))) else: myCursor.execute("update medicines set quan_issued = quan_issued + {} where ws_pat_id = {} and ws_med_id = {}".format(int(i['Quantity']), int(patientIDDict['patientID']), medId)) myCursor.close() myDb.commit() return jsonify({"message": "Medicines Issued Successfully"})
def login(): if session.get('username'): return redirect(url_for('main.index')) if request.method == 'POST': username = request.form.get('username') password = request.form.get('password') if username != None: myCursor = myDb.cursor() myCursor.execute( "select password,user_type from userstore where username = '******'" .format(username)) myResult = myCursor.fetchall() myCursor.close() if myResult != [] and check_password_hash(myResult[0][0], password): session['username'] = username.upper() session['user_type'] = myResult[0][1] return redirect(url_for('main.index')) flash("Username doesn't exist or Password incorrect", "danger") return render_template("login.html")
def view(): mview=myDb.cursor() mview.execute("SELECT * FROM patient") view_result = mview.fetchall() return render_template("display.html",view_result=view_result)
from flask import Blueprint, request, flash, render_template, jsonify, make_response from application import myDb from random import randint from datetime import date bp = Blueprint('managePatientInformation', __name__, template_folder='templates', static_folder='static') myCursor = myDb.cursor() def function1(): flash("SSN Id should be of 9 digits!!") @bp.route('/patientnew',methods=['POST','GET']) def register(): myresult2 = [] patient_validation_ssnid=[] patient_ssn_new='' myc = 0 date1 = '' patient_doj = '' type_room = ['------','General','Semi','Single'] # updatesw_states = ['Maharashtra','MP', 'TN', 'Haryana','UP','Punjab'] myCursor.execute("select distinct(district) from city where countrycode = 'IND' order by district") updatesw_states = list(map(lambda x: x[0],myCursor.fetchall())) updatesw_cities=[] udh = type(patient_doj) #Initializing date msg = "E" p=date.today() if request.method == 'POST':
def fetchAllMedicines(): myCursor = myDb.cursor() myCursor.execute("select med_name from medicinesmaster") myResult = myCursor.fetchall() return jsonify(myResult)
def patientBilling(): myCursor = myDb.cursor() patient_info = [] myResult = [] myResult1 = [] total = [] if request.method == 'POST': ws_pat_id = int(request.form.get('ws_pat_id')) print(ws_pat_id) #patient related info myCursor.execute( """ SELECT ws_pat_id, ws_pat_name, ws_adrs, ws_age, ws_doj, ws_rtype FROM patient WHERE ws_pat_id = %s""" % (ws_pat_id)) patient_info = myCursor.fetchone() print(patient_info) date1 = patient_info[4] f_date = date(int(date1[0:4]), int(date1[5:7]), int(date1[8:])) l_date = date.today() delta = l_date - f_date total_days = delta.days + 1 total.append(total_days) if patient_info[5] == "Semi": total_amt = 4000 elif patient_info[5] == "Single": total_amt = 8000 else: total_amt = 2000 sum_patient = total_days * total_amt print(sum_patient) total.append(sum_patient) #medicine related info myCursor = myDb.cursor() myCursor.execute( "select medicinesmaster.med_name, medicines.quan_issued, medicinesmaster.rate from medicines JOIN medicinesmaster on medicines.ws_med_id = medicinesmaster.med_id where medicines.ws_pat_id = %s order by medicinesmaster.med_name" % (ws_pat_id)) myResult = myCursor.fetchall() myCursor.close() print(myResult) length = len(myResult) sum_medicine = 0 for x in range(0, length): sum1 = myResult[x][1] * myResult[x][2] sum_medicine = sum_medicine + sum1 print(sum_medicine) total.append(sum_medicine) #diagnosis related info myCursor = myDb.cursor() myCursor.execute( "select diagnosticsmaster.test_name, diagnosticsmaster.rate from diagnosticstable JOIN diagnosticsmaster on diagnosticstable.ws_test_id = diagnosticsmaster.test_id where diagnosticstable.ws_pat_id = %s order by diagnosticsmaster.test_name" % (ws_pat_id)) myResult1 = myCursor.fetchall() myCursor.close() print(myResult1) length1 = len(myResult1) sum_diagnosis = 0 for x in range(0, length1): sum_diagnosis = sum_diagnosis + myResult1[x][1] print(sum_diagnosis) total.append(sum_diagnosis) #grand related info grand_total = sum_patient + sum_medicine + sum_diagnosis total.append(grand_total) return render_template('printBill.html', patient_info=patient_info, myResult=myResult, len1=len(myResult), myResult1=myResult1, len2=len(myResult1), total=total)
def fetchAllTests(): myCursor = myDb.cursor() myCursor.execute("select test_name from diagnosticsmaster") myResult = myCursor.fetchall() return jsonify(myResult)