def patient_dash(): #usr=session['userno'] #Recieving the userid for db manipulation from the initilised session #sql="SELECT * FROM PROJECTS WHERE USERID = %s"%(usr) #projects=dbquery.fetchall(sql) if request.method=='POST': title = request.form['title'] remark = request.form['remark'] app.config['UPLOAD_FOLDER']="/Users/pranoy/Desktop/medi-fi/static/uploads/%s"%(session['email']) if not os.path.exists(app.config['UPLOAD_FOLDER']): os.makedirs(app.config['UPLOAD_FOLDER']) try: f = request.files['file'] f.save(os.path.join(app.config['UPLOAD_FOLDER'],f.filename)) print(f.filename) sql="INSERT INTO posts(email,title,remark,image,post_by) VALUES('%s','%s' ,'%s','%s','%s')"%(email,title,remark,f.filename,session['id']) dbquery.inserttodb(sql) except: sql="INSERT INTO posts(email,title,remark,post_by) VALUES('%s','%s' ,'%s','%s')"%(email,title,remark,session['id']) dbquery.inserttodb(sql) sql="SELECT * FROM patient WHERE email = '%s'"%(session['email']) datas = dbquery.fetchall(sql) sql="SELECT * FROM posts where email = '%s'"%(session['email']) posts = dbquery.fetchall(sql) return render_template('patient_dash.html',datas=datas,posts=posts)
def profile(email): #usr=session['userno'] #Recieving the userid for db manipulation from the initilised session #sql="SELECT * FROM PROJECTS WHERE USERID = %s"%(usr) #projects=dbquery.fetchall(sql) if request.method=='POST': title = request.form['title'] remark = request.form['remark'] app.config['UPLOAD_FOLDER']="/Users/pranoy/Desktop/medi-fi/static/uploads/%s"%(email) if not os.path.exists(app.config['UPLOAD_FOLDER']): os.makedirs(app.config['UPLOAD_FOLDER']) try: f = request.files['file'] f.save(os.path.join(app.config['UPLOAD_FOLDER'],f.filename)) sql="INSERT INTO posts(email,title,remark,image,post_by) VALUES('%s','%s' ,'%s','%s','%s')"%(email,title,remark,f.filename,session['id']) dbquery.inserttodb(sql) path = app.config['UPLOAD_FOLDER']+'/'+f.filename bashCommand = "python3 /Users/pranoy/Desktop/medi-fi/ml/predict.py %s"%(path) print(bashCommand) import subprocess process = subprocess.Popen(bashCommand.split(), stdout=subprocess.PIPE) except: sql="INSERT INTO posts(email,title,remark,post_by) VALUES('%s','%s' ,'%s','%s')"%(email,title,remark,session['id']) dbquery.inserttodb(sql) sql="SELECT * FROM patient WHERE email = '%s'"%(email) datas = dbquery.fetchall(sql) sql="SELECT * FROM posts where email = '%s'"%(email) posts = dbquery.fetchall(sql) return render_template('profile.html',datas=datas,posts=posts)
def projects(id): if id == session['userid']: return redirect(url_for('dashboard')) if request.method=='POST': message=request.form['message'] name =str(session['name']) message=name+": "+message sql="INSERT INTO CHATS(SENDER,RECIEVER,MESSAGE) VALUES('%d','%d','%s')"%(session['userid'],id,message) dbquery.inserttodb(sql) sql="SELECT MESSAGE FROM CHATS WHERE (SENDER = %d AND RECIEVER = %d) OR (SENDER= %d AND RECIEVER = %d) "%(session['userid'],id,id,session['userid']) chats=dbquery.fetchall(sql) return render_template("chat.html",chats=chats) try: sql="SELECT MESSAGE FROM CHATS WHERE (SENDER = %d AND RECIEVER = %d) OR (SENDER= %d AND RECIEVER = %d) "%(session['userid'],id,id,session['userid']) chats=dbquery.fetchall(sql) return render_template("chat.html",chats=chats) except: sql="INSERT INTO CHATS(SENDER,RECIEVER,MESSAGE) VALUES('%d','%d','%s')"%(session['userid'],id,"Say hello") dbquery.inserttodb(sql) sql="SELECT MESSAGE FROM CHATS WHERE (SENDER = %d AND RECIEVER = %d) OR (SENDER= %d AND RECIEVER = %d) "%(session['userid'],id,id,session['userid']) chats=dbquery.fetchall(sql) return render_template("chat.html",chats=chats)
def medibot(): if request.method == 'POST': try: slot = request.form['slot'] print(slot) medicine = request.form['medicine'] sql="INSERT INTO medibot(medicine,slot) VALUES('%s','%s' )"%(medicine,slot) dbquery.inserttodb(sql) #connecting to db model bashCommand = "curl -v -F slot=%s 192.168.43.112:80"%(slot) import subprocess process = subprocess.Popen(bashCommand.split(), stdout=subprocess.PIPE) except: dispense = request.form['dispense'] print(dispense) sql = "select * from medibot where medicine ='%s'"%(dispense) slotinfo = dbquery.fetchall(sql) slot = slotinfo[0][1] bashCommand = "curl -v -F slot=%s 192.168.43.112:80"%(slot) import subprocess process = subprocess.Popen(bashCommand.split(), stdout=subprocess.PIPE) sql ="delete from medibot where slot ='%s'"%(slot) dbquery.inserttodb(sql) sql = "select * from medicine" medicines = dbquery.fetchall(sql) sql = "select * from medibot" medicinebots = dbquery.fetchall(sql) return render_template('medibot.html',medicines = medicines, medicinebots = medicinebots)
def doctor_dash(): email=session['email'] #Recieving the userid for db manipulation from the initilised session sql = "Select * from appointment where doctoremail = '%s'"%(email) appointments=dbquery.fetchall(sql) return render_template('doctor_dash.html',appointments = appointments)
def search(): if request.method=='POST': location=request.form['location'] sql="SELECT COST,CONTACTNO,ADDRESS,TIMING,LOCATION FROM TOILETS WHERE LOCATION='%s';"%(location) info=dbquery.fetchall(sql) return render_template('search.html',info=info) return render_template('search.html')
def auth(): if request.method == 'POST': nurse = request.form['nurse'] patient = request.form['patient'] print(nurse,patient) sql = "INSERT INTO rfid(nurse,patient) VALUES('%s','%s')"%(nurse,patient) dbquery.inserttodb(sql) return "200" #usr=session['userno'] #Recieving the userid for db manipulation from the initilised session sql="SELECT * FROM rfid " info=dbquery.fetchall(sql) return render_template('nurse_dash.html',info=info)
def home(): sql = "SELECT TIME_STAMP FROM DATA WHERE USERID =1 AND DATA_DATE = CURDATE();" data = dbquery.fetchall(sql) List = list() #converting from tuple to string for t in data: List.append(int(t[0])) List.sort() data = {x: List.count(x) for x in List} print(data) return render_template("index.html", data=data) #display the html template
def appointment(): if request.method== 'POST': patient = request.form['patient'] doctor = request.form['doctor'] date = request.form['date'] sql = "SELECT * from patient where name = '%s'"%(patient) data = dbquery.fetchall(sql) patientEmail = data[0][5] sql = "SELECT * from users where name = '%s' and type = 'Doctor'"%(doctor) data = dbquery.fetchall(sql) doctorEmail = data[0][2] sql = "SELECT * from users where userno = '%s' and type = 'Nurse'"%(session['id']) data = dbquery.fetchall(sql) nurse = data[0][1] sql="INSERT INTO appointment(userid,patient,doctor,date,patientEmail,doctorEmail,nurseemail,nurse) VALUES('%s','%s' ,'%s','%s','%s','%s','%s','%s')"%(session['id'],patient,doctor,date,patientEmail,doctorEmail,session['email'],nurse) dbquery.inserttodb(sql) #connecting to db model message="Appointment Created" return render_template('appointment.html',message=message) sql = "select name from patient where nurseid ='%s'"%(session['id']) patients=dbquery.fetchall(sql) sql = "select name from users where type ='Doctor'" doctors = dbquery.fetchall(sql) return render_template('appointment.html',patients=patients,doctors=doctors)
def nurse_dash(): #usr=session['userno'] #Recieving the userid for db manipulation from the initilised session sql="SELECT * FROM patient WHERE nurseid = '%s'"%(session['id']) info=dbquery.fetchall(sql) return render_template('nurse_dash.html',info=info)
def dashboard(): sql="SELECT * FROM TOILETS WHERE USERID = '%s'"%(session['userid']) people=dbquery.fetchall(sql) return render_template('dashboard.html',people=people)
def dashboard(): city=session['city'] #Recieving the userid for db manipulation from the initilised session sql="SELECT * FROM USERS WHERE CITY = '%s' AND USERID <> %d"%(city,session['userid']) people=dbquery.fetchall(sql) return render_template('dashboard.html',people=people,city=city)