phc.py

from flask import *
from database import *
import uuid

phc=Blueprint('phc',__name__)

@phc.route('phc_home')
def phc_home():
	return render_template('phc_home.html')
@phc.route('/phc_manage_ashaworker',methods=['get','post'])
def phc_manage_ashaworker():
	data={}
	if 'add_asha' in request.form:
		
		fname=request.form['fname']
		lname=request.form['lname']
		place=request.form['place']
		phone=request.form['phone']
		email=request.form['email']
		uname=request.form['uname']
		pwd=request.form['pwd']
		qn="insert into login value(null,'%s','%s','ashaworker')"%(uname,pwd)
		res=insert(qn)
		q="insert into ashaworker values(null,'%s','%s','%s','%s','%s','%s','%s')"%(res,fname,lname,place,phone,session['phc_id'],email)
		insert(q)
		flash("Register successfully")
		return redirect(url_for('phc.phc_manage_ashaworker'))

	if 'action' in request.args:
		action=request.args['action']
		ashaworker_id=request.args['ashaworker_id']
	else:
		action=None
	if action=='update':
		q="select * from ashaworker inner join login using(login_id) where ashaworker_id='%s'"%(ashaworker_id)
		data['up']=select(q)
	if action=='delete':
		q="delete from ashaworker where ashaworker_id='%s'"%(ashaworker_id)
		delete(q)
		return redirect(url_for('phc.phc_manage_ashaworker'))
		flash("Delete successfully")

		
	if 'update' in request.form:
		
		fname=request.form['fname']
		lname=request.form['lname']
		place=request.form['place']
		phone=request.form['phone']
		email=request.form['email']
		q="update ashaworker set fname='%s',lname='%s',place='%s',a_phone='%s',email='%s' where ashaworker_id='%s'"%(fname,lname,place,phone,email,ashaworker_id)
		update(q)
		flash("Update successfully")
		return redirect(url_for('phc.phc_manage_ashaworker'))


	q="select * from phc"
	data['view']=select(q)

	qa="select ashaworker.*,phc.name from ashaworker inner join phc using(phc_id) where phc_id='%s'"%(session['phc_id'])
	data['asha_view']=select(qa)
	return render_template('phc_manage_ashaworker.html',data=data)

@phc.route('/phc_manage_doctor',methods=['get','post'])
def phc_manage_doctor():
	data={}
	if 'add_doctor' in request.form:
		name=request.form['name']
		place=request.form['place']
		phone=request.form['phone']
		email=request.form['email']
		pincode=request.form['pincode']
		uname=request.form['uname']
		pwd=request.form['pwd']
		qn="insert into login value(null,'%s','%s','Doctor')"%(uname,pwd)
		res=insert(qn)

		q="insert into health values(null,'%s','%s','%s','%s','%s','%s','%s')"%(res,name,place,phone,email,pincode,session['phc_id'])
		insert(q)
		flash("Register successfully")
		return redirect(url_for('phc.phc_manage_doctor'))

	if 'action' in request.args:
		action=request.args['action']
		health_id=request.args['health_id']
		login_id=request.args['login_id']
	else:
		action=None
	if action=='update':
		q="select * from health inner join login using(login_id) where health_id='%s'"%(health_id)
		data['up']=select(q)
	if 'update' in request.form:
		
		name=request.form['name']
		place=request.form['place']
		phone=request.form['phone']
		email=request.form['email']
		pincode=request.form['pincode']
		
		q="update health set doc_name='%s',place='%s',h_phone='%s',email='%s',h_pincode='%s' where health_id='%s'"%(name,place,phone,email,pincode,health_id)
		update(q)
		flash("Update successfully")
		return redirect(url_for('phc.phc_manage_doctor'))

	if action=='delete':
		q="delete from health where health_id='%s'"%(health_id)
		delete(q)
		flash("Delete successfully")





	q="select * from phc"
	data['view']=select(q)

	q="select health.*,phc.*,health.place,phc.name,health.email from health inner join phc using(phc_id) where phc_id='%s'"%(session['phc_id'])
	data['doc_view']=select(q)
	return render_template('phc_manage_doctor.html',data=data)
@phc.route('/phc_add_vaccination',methods=['get','post'])
def phc_add_vaccination():
	data={}
	if 'user_id' in request.args:
		user_id=request.args['user_id']
	if 'vacc_add' in request.form:
		vaccination=request.form['vaccination']
		details=request.form['details']
		q="insert into vaccination values(null,'%s','%s','%s','%s',now())"%(session['login_id'],user_id,vaccination,details)
		res=insert(q)
		qv="insert into request values(null,'%s','%s',now(),'Added')"%(res,user_id)
		insert(qv)
		flash("Insert successfully")

	if 'action' in request.args:
		action=request.args['action']
		vaccination_id=request.args['vaccination_id']
	else:
		action=None 
	if action=='update':
		q="select * from vaccination where vaccination_id='%s'"%(vaccination_id)
		data['up']=select(q)
	if action=='delete':
		q="delete from vaccination where vaccination_id='%s'"%(vaccination_id)
		res=delete(q)
	if action=='delete':
		qv="delete from request where vaccination_id='%s'"%(vaccination_id)
		delete(qv)
		flash("Delete successfully")
		return redirect(url_for('phc.phc_view_pregnant_ladies_details'))

	if 'update' in request.form:
		vaccination=request.form['vaccination']
		details=request.form['details']
		q="update vaccination set vaccination='%s',details='%s' where vaccination_id='%s'"%(vaccination,details,vaccination_id)
		update(q)
		flash("Update successfully")
		return redirect(url_for('phc.phc_view_pregnant_ladies_details'))


	q="select * from vaccination where user_id='%s'"%(user_id)
	data['view']=select(q)

	return render_template('phc_add_vaccination.html',data=data)

@phc.route('/phc_view_pregnant_ladies_details')
def phc_view_pregnant_ladies_details():
	data={}
	q="select * from pregnant_ladies inner join health using(health_id)where phc_id='%s'"%(session['phc_id'])
	data['view']=select(q)

	return render_template('phc_view_pregnant_ladies_details.html',data=data)
@phc.route('/phc_view_medical_history')
def phc_view_medical_history():
	data={}
	if 'user_id' in request.args:
		user_id=request.args['user_id']
	q="select * from medical_details where user_id='%s'"%(user_id)
	data['view']=select(q)
	return render_template('phc_view_medical_history.html',data=data)
@phc.route('/phc_view_risk assessment')
def phc_view_risk_assessment():
	data={}
	if 'user_id' in request.args:
		user_id=request.args['user_id']
	q="select * from risk_assessment where user_id='%s'"%(user_id)
	data['view']=select(q)
	return render_template('phc_view_risk assessment.html',data=data)
@phc.route('/phc_view_food')
def phc_view_food():
	data={}
	if 'user_id' in request.args:
		user_id=request.args['user_id']
	q="select * from foodedetails where user_id='%s'"%(user_id)
	data['view']=select(q)
	return render_template('phc_view_food.html',data=data)
@phc.route('/phc_view_complaint')
def phc_view_complaint():
	data={}
	q="SELECT * FROM `complaint` INNER JOIN `ashaworker` USING(login_id) where phc_id='%s' union select* from complaint INNER JOIN `health` USING (login_id) WHERE phc_id='%s'"%(session['phc_id'],session['phc_id'])
	data['view']=select(q) 
	return render_template('phc_view_complaint.html',data=data)
@phc.route('/phc_send_replay',methods=['get','post'])
def phc_send_replay():
	if 'comp_id' in request.args:
		comp_id=request.args['comp_id']
	if "replay_sub" in request.form:
		reply=request.form['comp_replay']
		q="update complaint set reply='%s' where complaint_id='%s'"%(reply,comp_id)
		update(q)
		flash("Update successfully")
		return redirect(url_for('phc.phc_view_complaint'))

	return render_template('phc_send_replay.html')
@phc.route('/phc_comm_vacc',methods=['get','post'])
def phc_comm_vacc():
	data={}
	if 'comm_vacc_add' in request.form:
		vaccination=request.form['vaccination']
		details=request.form['details']
		aval=request.form['aval']
		due_date=request.form['due_date']
		q="insert into com_vaccination values(null,'%s','%s','%s','%s','%s')"%(session['login_id'],vaccination,details,aval,due_date)
		insert(q)

	if 'action' in request.args:
		action=request.args['action']
		vaccination_id=request.args['vaccination_id']
	else:
		action=None 
	if action=='update':
		q="select * from com_vaccination where com_vacci_id='%s'"%(vaccination_id)
		data['up']=select(q)
	if action=='delete':
		qv="delete from com_vaccination where com_vacci_id='%s'"%(vaccination_id)
		delete(qv)
		flash("Delete successfully")
		return redirect(url_for('phc.phc_home'))

	if 'update' in request.form:
		vaccination=request.form['vaccination']
		details=request.form['details']
		aval=request.form['aval']
		due_date=request.form['due_date']
		q="update com_vaccination set vacc_name='%s',vacc_details='%s',vacc_ava='%s',due_date='%s' where com_vacci_id='%s'"%(vaccination,details,aval,due_date,vaccination_id)
		update(q)
		flash("Update successfully")
		return redirect(url_for('phc.phc_home'))
	q="select * from com_vaccination where login_id='%s'"%(session['login_id'])
	data['view']=select(q)
	return render_template('phc_addcomm_vac.html',data=data)
@phc.route('/phc_add_gallery',methods=['get','post'])
def phc_add_gallery():
	data={}
	if 'add_photo' in request.form:
		image=request.files['photo']	
		path="static/images"+str(uuid.uuid4())+image.filename
		image.save(path)
		q="insert into gallery values(null,'%s','%s')"%(session['login_id'],path)
		insert(q)
	if 'action' in request.args:
		action=request.args['action']
		ga_id=request.args['ga_id']
	else:
		action=None 
	if action=='update':
		q="select * from gallery where ga_id='%s'"%(ga_id)
		data['up']=select(q)
	if action=='delete':
		q="delete from gallery where ga_id='%s'"%(ga_id)
		res=delete(q)
	if action=='delete':
		qv="delete from gallery where ga_id='%s'"%(ga_id)
		delete(qv)
		flash("Delete successfully")
		return redirect(url_for('phc.phc_home'))

	if 'update' in request.form:
		image=request.files['photo']	
		path="static/images"+str(uuid.uuid4())+image.filename
		image.save(path)
		q="update gallery set images='%s' where ga_id='%s'"%(path,ga_id)
		update(q)
		flash("Update successfully")
		return redirect(url_for('phc.phc_home'))
	q="select * from gallery where login_id='%s'"%(session['login_id'])
	data['view']=select(q)
	return render_template('phc_add_gallery.html',data=data)
@phc.route('/phc_logout')
def phc_logout():
	
	return redirect(url_for('public.home'))