ashaworker.py

from flask import *
from database import *
import uuid
ashaworker=Blueprint('ashaworker',__name__)
@ashaworker.route('ashaworkerhome')
def ashaworkerhome():
	return render_template('ashaworkerhome.html')
@ashaworker.route('/asha_manage_pregnantladies',methods=['get','post'])
def asha_manage_pregnantladies():
	data={}
	if 'add_details' in request.form:
		email=request.form['email']
		cm="select * from pregnant_ladies where email='%s'"%(email)
		ch=select(cm)
		if ch:
			flash("already registered")
		else:
			fname=request.form['fname']
			lname=request.form['lname']
			doc_name=request.form['doc_name']
			place=request.form['place']
			phone=request.form['phone']
			email=request.form['email']
			spouse=request.form['spouse']
			age=request.form['age']
			m_status=request.form['m_status']
			height=request.form['height']
			weight=request.form['weight']
			q="insert into pregnant_ladies values(null,'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','added')"%(session['login_id'],fname,lname,doc_name,place,phone,email,spouse,age,m_status,height,weight)
			insert(q)
			flash("Register successfully")
			return redirect(url_for('ashaworker.asha_manage_pregnantladies'))

	if 'action' in request.args:
		action=request.args['action']
		user_id=request.args['user_id']
	else:
		action=None
	if action=='update':
		q="select * from pregnant_ladies where user_id='%s'"%(user_id)
		data['up']=select(q)
	if action=='delete':
		q="delete from pregnant_ladies where user_id='%s'"%(user_id)
		delete(q)
		flash("Delete successfully")
		return redirect(url_for('ashaworker.asha_manage_pregnantladies'))

	if 'update' in request.form:
		fname=request.form['fname']
		lname=request.form['lname']
		doc_name=request.form['doc_name']
		place=request.form['place']
		phone=request.form['phone']
		email=request.form['email']
		spouse=request.form['spouse']
		age=request.form['age']
		m_status=request.form['m_status']
		height=request.form['height']
		weight=request.form['weight']
		q="update pregnant_ladies set fname='%s',lname='%s',health_id='%s',place='%s',phone='%s',email='%s',spouse='%s',age='%s',marital_status='%s',height='%s',weight='%s' where user_id='%s'"%(fname,lname,doc_name,place,phone,email,spouse,age,m_status,height,weight,user_id)
		update(q)
		flash("Update successfully")
		return redirect(url_for('ashaworker.asha_manage_pregnantladies'))

	if action=='forword':
		q="update pregnant_ladies set status='forword' where user_id='%s'"%(user_id)
		update(q)
		flash("forword successfully")
		return redirect(url_for('ashaworker.asha_manage_pregnantladies'))


	q="select * from health inner join phc using(phc_id)"
	data['doctorview']=select(q)	
	qp="select * from pregnant_ladies where login_id='%s'"%(session['login_id']) 
	data['pregnant_ladies_view']=select(qp)
	return render_template('asha_manage_pregnantladies.html',data=data)
@ashaworker.route('/asha_add_medical',methods=['get','post'])
def asha_add_medical():
	data={}
	if 'user_id' in request.args:
		user_id=request.args['user_id']

	if 'medical_add' in request.form:
		blood_sugar=request.form['blood_sugar']
		pressure=request.form['pressure']
		blood_pressure=request.form['blood_pressure']
		allergies=request.form['allergies']
		typeallergy=request.form['typeallergy']
		surgical=request.form['surgical']
		surgical_file=request.files['surgical_file']
		path1="static/images"+str(uuid.uuid4())+surgical_file.filename
		surgical_file.save(path1)
		mensuration=request.form['mensuration']
		Estimated=request.form['Estimated']
		pre_pregn=request.form['uname']
		many_preg=request.form['password']
		frequent_preg=request.form['frequent_preg']
		Medication=request.form['Medication']
		medice=request.form['medice']
		complications=request.form['complications']
		details=request.form['details']
		image=request.files['image']	
		path="static/images"+str(uuid.uuid4())+image.filename
		image.save(path)
		if pre_pregn=='yes':
			q="insert into medical_details values(null,'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','added')"%(user_id,blood_sugar,pressure,blood_pressure,allergies,typeallergy,surgical,path1,mensuration,Estimated,pre_pregn,many_preg,frequent_preg,Medication,medice,complications,details,path)
			insert(q)
			flash("Insert successfully")
			return redirect(url_for('ashaworker.asha_manage_pregnantladies'))
		else:
			q="insert into medical_details values(null,'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','added')"%(user_id,blood_sugar,pressure,blood_pressure,allergies,typeallergy,surgical,path1,mensuration,Estimated,pre_pregn,many_preg,frequent_preg,Medication,medice,complications,details,path)
			insert(q)
			flash("Insert successfully")
			return redirect(url_for('ashaworker.asha_manage_pregnantladies'))


	if 'action' in request.args:
		action=request.args['action']
		user_id=request.args['user_id']
	else:
		action=None
	if action=='update':
		q="select * from medical_details where user_id='%s'"%(user_id)
		data['up']=select(q)
	if action=='delete':
		q="delete from medical_details where user_id='%s'"%(user_id)
		delete(q)
		flash("Delete successfully")
		return redirect(url_for('ashaworker.asha_manage_pregnantladies'))

	if 'update' in request.form:
		blood_sugar=request.form['blood_sugar']
		pressure=request.form['pressure']
		blood_pressure=request.form['blood_pressure']
		allergies=request.form['allergies']
		typeallergy=request.form['typeallergy']
		surgical=request.form['surgical']
		surgical_file=request.files['surgical_file']
		path1="static/images"+str(uuid.uuid4())+surgical_file.filename
		surgical_file.save(path1)
		mensuration=request.form['mensuration']
		Estimated=request.form['Estimated']
		pre_pregn=request.form['uname']
		many_preg=request.form['password']
		frequent_preg=request.form['frequent_preg']
		Medication=request.form['Medication']
		medice=request.form['medice']
		complications=request.form['complications']
		details=request.form['details']
		image=request.files['image']	
		path="static/images"+str(uuid.uuid4())+image.filename
		image.save(path)
		q="update medical_details set blood_sugar='%s',pressure='%s',blood_pressure='%s',allergies='%s',typeallergy='%s',surgical_history='%s',surgical_file='%s',mensuration='%s',Estimated='%s',pre_pregn='%s',many_preg='%s',frequent_preg='%s',Medication='%s',medice='%s',complications='%s',details='%s',file_upload='%s' where user_id='%s'"%(blood_sugar,pressure,blood_pressure,allergies,typeallergy,surgical,path1,mensuration,Estimated,pre_pregn,many_preg,frequent_preg,Medication,medice,complications,details,path,user_id)
		update(q)
		flash("Update successfully")
		return redirect(url_for('ashaworker.asha_manage_pregnantladies'))		
	q="select*from medical_details where user_id='%s'"%(user_id)
	data['view']=select(q)

	return render_template('asha_add_medical.html',data=data)
@ashaworker.route('/asha_add_risk_assessment',methods=['post','get'])
def asha_add_risk_assessment():
	data={}
	if 'user_id' in request.args:
		user_id=request.args['user_id']
	if 'add_risk' in request.form:
		diabetic=request.form['uname']
		data['dia']=diabetic
		print(data['dia'])
		Gestational=request.form['password']
		hypertension=request.form['hypertension']
		asthma=request.form['asthma']
		Heart_diseases=request.form['Heart_diseases']
		Infection=request.form['Infection']
		Genetic_factors=request.form['Genetic']
		Specify=request.form['Specify']
		mental_health=request.form['mental_health']
		cigarettes=request.form['cigarettes']
		drug=request.form['drug']
		contraceptives=request.form['contraceptives']
		unsual_sym=request.form['unsual_sym']
		vaginal=request.form['vaginal']
		domestic=request.form['domestic']
		if diabetic=='yes':
			q="insert into risk_assessment values(null,'%s','%s','yes','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')"%(user_id,diabetic,hypertension,asthma,Heart_diseases,Infection,Genetic_factors,Specify,mental_health,cigarettes,drug,contraceptives,unsual_sym,vaginal,domestic)
			insert(q)
			flash("Insert successfully")
			return redirect(url_for('ashaworker.asha_manage_pregnantladies'))
		else:
			q="insert into risk_assessment values(null,'%s','%s','no','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')"%(user_id,diabetic,hypertension,asthma,Heart_diseases,Infection,Genetic_factors,Specify,mental_health,cigarettes,drug,contraceptives,unsual_sym,vaginal,domestic)
			insert(q)
			flash("Insert successfully")
			return redirect(url_for('ashaworker.asha_manage_pregnantladies'))

	if 'action' in request.args:
		user_id=request.args['user_id']
		action=request.args['action']
	else:
		action=None
	if action=='update':
		q="select * from risk_assessment where user_id='%s'"%(user_id)
		data['up']=select(q)
	if action=='delete':
		q="delete from risk_assessment where user_id='%s'"%(user_id)
		delete(q)
		flash("Delete successfully")
		return redirect(url_for('ashaworker.asha_manage_pregnantladies'))

	if 'update' in request.form:
		diabetic=request.form['uname']
		Gestational=request.form['password']
		hypertension=request.form['hypertension']
		asthma=request.form['asthma']
		Heart_diseases=request.form['Heart_diseases']
		Infection=request.form['Infection']
		Genetic_factors=request.form['Genetic']
		Specify=request.form['Specify']
		mental_health=request.form['mental_health']
		cigarettes=request.form['cigarettes']
		drug=request.form['drug']
		contraceptives=request.form['contraceptives']
		unsual_sym=request.form['unsual_sym']
		vaginal=request.form['vaginal']
		domestic=request.form['domestic']
		if diabetic=='yes':
			qu="update risk_assessment set diabetic='%s',gestational='yes',hypertension='%s',asthma='%s',Heart_diseases='%s',Infection='%s',Genetic_factors='%s',Specify='%s',mental_health='%s',cigarettes='%s',drug='%s',contraceptives='%s',unsual_sym='%s',vaginal='%s',domestic='%s' where user_id='%s'"%(diabetic,hypertension,asthma,Heart_diseases,Infection,Genetic_factors,Specify,mental_health,cigarettes,drug,contraceptives,unsual_sym,vaginal,domestic,user_id)
			update(qu)
			flash("Update successfully")
			return redirect(url_for('ashaworker.asha_manage_pregnantladies'))
		else:
			qu="update risk_assessment set diabetic='%s',gestational='no',hypertension='%s',asthma='%s',Heart_diseases='%s',Infection='%s',Genetic_factors='%s',Specify='%s',mental_health='%s',cigarettes='%s',drug='%s',contraceptives='%s',unsual_sym='%s',vaginal='%s',domestic='%s' where user_id='%s'"%(diabetic,hypertension,asthma,Heart_diseases,Infection,Genetic_factors,Specify,mental_health,cigarettes,drug,contraceptives,unsual_sym,vaginal,domestic,user_id)
			update(qu)
			flash("Update successfully")
			return redirect(url_for('ashaworker.asha_manage_pregnantladies'))




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

	return render_template('asha_add_risk_assessment.html',data=data)
@ashaworker.route('/asha_add_emergency_con',methods=['post','get'])
def asha_add_emergency_con():
	data={}
	if 'user_id' in request.args:
		user_id=request.args['user_id']
	
	if 'emp_add' in request.form:
		phone=request.form['phone']
		home_address=request.form['home_address']
		office_address=request.form['office_address']
		relation=request.form['relation']
		q="insert into emergency_contact values(null,'%s','%s','%s','%s','%s')"%(user_id,phone,home_address,office_address,relation)
		insert(q)
		flash("Insert successfully")
		return redirect(url_for('ashaworker.asha_manage_pregnantladies'))

	if 'action' in request.args:
		action=request.args['action']
		user_id=request.args['user_id']
	else:
		action=None
	if action=='delete':
		q="delete from emergency_contact where user_id='%s'"%(user_id)
		delete(q)
		flash("Delete successfully")
		return redirect(url_for('ashaworker.asha_manage_pregnantladies'))
	
	if action=='update':
		q="select * from emergency_contact where user_id='%s'"%(user_id)
		data['up']=select(q)
	if 'update' in request.form:
 		phone=request.form['phone']
 		home_address=request.form['home_address']
 		office_address=request.form['office_address']
 		relation=request.form['relation']
 		q="update emergency_contact set phone='%s',home_address='%s',office_address='%s',relationship='%s' where user_id='%s'"%(phone,home_address,office_address,relation,user_id)
 		update(q)
 		flash("Update successfully")
 		return redirect(url_for('ashaworker.asha_manage_pregnantladies'))
	
	q="select * from emergency_contact where user_id='%s'"%(user_id)
	data['view']=select(q)
	return render_template('asha_add_emergency_con.html',data=data)
@ashaworker.route('/asha_view_food')
def asha_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('asha_view_food.html',data=data)
@ashaworker.route('/asha_view_vaccination_request')
def asha_view_vaccination_request():
	data={}
	if 'user_id' in request.args:
		user_id=request.args['user_id']
	q="select * from vaccination inner join pregnant_ladies using(user_id) where user_id='%s'"%(user_id)
	data['view']=select(q)
	return render_template('asha_view_vaccination_request.html',data=data)
@ashaworker.route('/asha_view_comm_vacc')
def asha_view_comm_vacc():
	data={}
	q="select * from com_vaccination"
	data['view']=select(q)
	return render_template('asha_view_comm_vacc.html',data=data)

@ashaworker.route('/asha_send_complaint',methods=['get','post'])
def asha_send_complaint():
	data={}
	if 'com_sub' in request.form:
		complaint=request.form['complaint']
		q="insert into complaint values(null,'%s','%s','pending',now(),'ashaworker')"%(session['login_id'],complaint)
		insert(q)
		flash("Send successfully")
		return redirect(url_for('ashaworker.ashaworkerhome'))
	q="select * from complaint where comp_user_type='ashaworker' and login_id='%s'"%(session['login_id'])
	data['view']=select(q)
	return render_template('asha_send_complaint.html',data=data)
@ashaworker.route('/asha_viewcomm_vacci')
def doctor_viewcomm_vacci():
	data={}
	q="select * from com_vaccination"
	data['view']=select(q)
	return render_template('doctor_viewcom_vacci.html',data=data)
@ashaworker.route('/asha_view_gallery')
def asha_view_gallery():
	data={}
	q="select * from gallery"
	data['view']=select(q)
	return render_template('asha_view_gallery.html',data=data)
@ashaworker.route('/asha_logout')
def asha_logout():
	
	return redirect(url_for('public.home'))
@ashaworker.route('/asha_print')
def asha_print():
	data={}
	user_id=request.args['user_id']

	q="select * from pregnant_ladies inner join health using(health_id) inner join medical_details using(user_id) inner join risk_assessment using(user_id) where user_id='%s'"%(user_id)
	data['view']=select(q)
	qv="select * from foodedetails inner join emergency_contact using(user_id) where user_id='%s'"%(user_id)
	data['view2']=select(qv)
	qq="select * from vaccination where user_id='%s'"%(user_id)
	data['view3']=select(qq)
	qr="select * from remark where user_id='%s'"%(user_id)
	data['view4']=select(qr)


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