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)