def get_lucky_num():
"""takes data from form, makes api call, returns lucky number information.
Returns JSON {'num': {fact, num} 'year': {fact, year}}
"""
data = request.get_json()
form = InfoForm(MultiDict(mapping=data['data']), csrf_enabled=False)
#essentially make a fake form that the JSON data gets assigned to and is then validated. Disable CSRF so the "form" goes through validation
print(form)
if form.validate():
num = randint(0, 100)
resp = {
"num": {
"fact":
requests.get(f"http://numbersapi.com/{num}/trivia").text,
"num": num
},
"year": {
"fact":
requests.get(
f"http://numbersapi.com/{data['data']['year']}/year").text,
"year":
data['data']['year']
}
}
return jsonify(resp)
else:
resp = {'errors': {}}
for error in form.errors:
resp['errors'][error] = eval(f'form.{error}.errors')[0]
return jsonify(resp)
def get_lucky_num():
data = request.get_json()
form = InfoForm(MultiDict(mapping=data['data']), csrf_enabled=False)
if form.validate():
print(form.data)
from random import randint
num = randint(0, 100)
resp = {
"num": {
"fact":
requests.get(f"http://numbersapi.com/{num}/trivia").text,
"num": num
},
"year": {
"fact":
requests.get(
f"http://numbersapi.com/{data['data']['year']}/year").text,
"year":
data['data']['year']
}
}
return jsonify(resp)
else:
resp = {'errors': {}}
for error in form.errors:
resp['errors'][error] = eval(f'form.{error}.errors')[0]
return jsonify(resp)
def home():
if 'email' not in session:
return redirect(url_for('login'))
email = session['email']
form = InfoForm()
key = ''
value = ''
user = db_session.query(User).filter(User.email == email).first()
if request.method == 'POST':
if form.validate() == False:
return render_template('home.html', form=form)
else:
key = form.key.data
value = form.value.data
newinfo = Info(form.key.data, form.value.data, user.uid)
db_session.add(newinfo)
db_session.commit()
return render_template('home.html',
form=form,
key=key,
value=value)
elif request.method == 'GET':
return render_template("home.html",
form=form,
key=key,
value=value,
user=user)
def user_info(): # 修改个人信息
user = query_user_by_name(session.get("user_name"))
# 打开修改信息页面，将原来信息展示出来，消息回填
form = InfoForm()
if form.validate_on_submit():
current_login_name = session.get("user_name")
old_name = user.name
new_name = request.form["user_name"]
query_user = query_user_by_name(new_name)
if query_user == None or current_login_name == query_user.name: # 如果数据库没有这个用户名或者当前登录的用户名和更改的用户名一样（本人操作），都可以更新个人信息
user.name = request.form["user_name"]
user.email = request.form["user_email"]
user.age = request.form["user_age"]
user.birthday = request.form["user_birthday"]
user.face = request.form["user_face"]
update_user_by_name(old_name, user)
flash(message="用户信息已更新！", category="ok")
session.pop("user_name", None) # 修改密码后需要重新登录，然后清除session中的数据
session["user_name"] = user.name
return redirect(url_for("user_detail"))
else:
flash(message="用户名已存在！", category="err")
return render_template("user_info.html", user=user, form=form)
def icms():
form = InfoForm()
if form.is_submitted():
formResult = request.form.to_dict()
dictToJson = formResultParser(formResult)
if formResult["hour"] == '':
print("visit now")
print(dictToJson)
res = requests.post(
'https://app-tier1-latest-collections.uc.r.appspot.com/places',
json=dictToJson)
print(str(res))
if str(res) != '<Response [200]>':
res = requests.post(
'https://app-tier1-latest-collections.uc.r.appspot.com/places',
json=dictToJson)
print(res)
else:
dictToJson["hour"] = int(formResult["hour"][:2])
dictToJson["day"] = datetime.strptime(formResult["day"],
"%Y-%m-%d").strftime('%a')
# call to analytics url
res = requests.post(
'https://app-tier2-analytics-collection.uc.r.appspot.com/analytics',
json=dictToJson)
if str(res) != '<Response [200]>':
res = requests.post(
'https://app-tier2-analytics-collection.uc.r.appspot.com/analytics',
json=dictToJson)
print(res)
response_data = res.json()
# print(response_data)
markers_list, result_list, placeid_result_dict, message = responseParser(
response_data, formResult["location"], formResult["qtype"],
formResult["hour"])
#########################################################################################
mymap = Map(
identifier="view-side",
lat=37.4419,
lng=-122.1419,
# markers=[(loc['icon'],loc['lat'], loc['lng'], loc['infobox']) for loc in markers_list]
)
sndmap = Map(identifier="sndmap",
lat=33.4166117,
lng=-111.9235453,
markers=list(loc for loc in markers_list),
fit_markers_to_bounds=True)
queryType = formResult["qtype"].capitalize()
return render_template('example.html',
mymap=mymap,
sndmap=sndmap,
recommendations=result_list,
firstResult=placeid_result_dict,
qtype=queryType,
message=message)
return render_template('display.html', form=form)
def create():
form = InfoForm()
if form.validate_on_submit():
create = Info(name=request.form["name"],
content=request.form["content"])
db.session.add(create)
db.session.commit()
return redirect(url_for('dashboard'))
return render_template('authentication/create.html', form=form)
def create_notification():
form = InfoForm()
if form.validate_on_submit():
create = Notice(name=form.name.data, content=form.content.data)
db.session.add(create)
db.session.commit()
return redirect(url_for('dashboard'))
return render_template('authentication/create_notification.html',
form=form)
def update(id):
form = InfoForm()
info = Info.query.filter_by(id=id).first()
form.name.data = info.name
form.content.data = info.content
if form.validate_on_submit():
info.name = request.form['name']
info.content = request.form['content']
db.session.commit()
return redirect(url_for('dashboard'))
return render_template('authentication/update.html', form=form, info=info)
def update_meeting_date():
form = InfoForm()
dates = MeetingDate.query.first()
form.name.data = dates.name
form.content.data = dates.content
if form.validate_on_submit():
dates.name = request.form['name']
dates.content = request.form['content']
db.session.commit()
return redirect(url_for('dashboard'))
return render_template('authentication/update_meeting_date.html',
form=form,
dates=dates)
def new_album():
"""
Add a new info
"""
form = InfoForm(request.form)
if request.method == 'POST' and form.validate():
# save the info
info = Info()
save_changes(info, form, new=True)
flash('info created successfully!')
return redirect('/')
return render_template('new_album.html', form=form)
def submit():
form = InfoForm()
if form.validate_on_submit():
appendIfNotExist(form.currency.data, form.fromDate.data,
form.tillDate.data)
session['currency'] = form.currency.data
session['fromDate'] = form.fromDate.data
session['tillDate'] = form.tillDate.data
return redirect(url_for('summary'))
return render_template('forms.html', form=form)
def user_info():
form = InfoForm()
user = query_user_by_name(session.get("user_name"))
if form.validate_on_submit():
old_name = user.name
user.name = form.data["user_name"]
user.email = form.data["user_email"]
user.age = form.data["user_edge"]
user.birthday = form.data["user_birthday"]
user.face = form.data["user_face"]
update_user_by_name(old_name, user)
session["user_name"] = user.name
return redirect(url_for("user_detail"))
return render_template("user_info.html", user=user, form=form)
def profile():
form=InfoForm()
if request.method=='POST':
username=request.form['username']
id=random.randint(100,100000)
firstname=request.form ['firstname']
lastname=request.form['lastname']
biography=request.form['biography']
age=request.form['age']
gender=request.form['gender']
file=request.files['image']
image=secure_filename(file.filename)
file.save(os.path.join('app/static/images'))
datejoined = datetime.now().strftime("%a %d %b %Y")
user = UserProfile(username, id, firstname,lastname, biography,age,gender,image,datejoined)
db.session.add(profile)
db.session.commit()
flash('User added successfully')
return redirect(url_for('profile'))
flash_errors(form)
return render_template('profile.html', form=form)
def register():
# 表单对象
form = InfoForm()
if form.validate_on_submit():
user_id = request.form.get('user_id', None)
user_name = request.form.get('username', None)
password = request.form.get('password', None)
sex = request.form.get('sex', None)
birthday = request.form.get('birthday', None)
# 实现注册，保存信息到User模型中
user = User(user_id)
user.save_password(password)
user.insert_info(user_name, sex, birthday)
login_user(user)
app.logger.info('user: '******' sign in')
return redirect(url_for('index'))
else:
return render_template('register.html', form=form)
def create(request):
if request.POST:
form = InfoForm(request.POST, request.FILES)
if form.is_valid():
a = form.save()
messages.add_message(request, messages.SUCCESS, "Your Information was added")
return HttpResponseRedirect('/logins')
else:
form = InfoForm()
args = {}
args.update(csrf(request))
args['form'] = form
return render_to_response('logins/create_info.html', args)
def add():
form = InfoForm()
if form.validate_on_submit():
data = form.getDataDict()
schoolnum = Info.query.filter_by(name=data['schoolnum']).first()
print(schoolnum)
if schoolnum:
flash(message="student id is exists")
else:
info = Info()
for i in data:
if hasattr(info, i):
setattr(info, i, data[i])
db.session.add(info)
db.session.commit()
flash("commit successed!")
return render_template("forms.html",form=form)
def edit(id):
"""
Add / edit an item in the database
"""
qry = db_session.query(Info).filter(
Info.id==id)
info = qry.first()
if info:
form = InfoForm(formdata=request.form, obj=info)
if request.method == 'POST' and form.validate():
# save edits
save_changes(info, form)
flash('info updated successfully!')
return redirect('/')
return render_template('edit_album.html', form=form)
else:
return 'Error loading #{id}'.format(id=id)
def wnew():
form = InfoForm()
if request.method == "POST":
if form.validate() == False:
flash('All fields are required')
return render_template("/whats_new.html", form=form)
else:
msg = Message("Interest in Sewing Classes",
sender=form.email.data,
recipients=['*****@*****.**'])
msg.body = """From: %s %s <%s> %s""" % (
form.first_name.data, form.last_name.data, form.email.data,
form.experience.data)
mail.send(msg)
return redirect("/signup.html")
elif request.method == "GET":
return render_template("/whats_new.html", form=form)
def delete(id):
"""
Delete the item in the database that matches the specified
id in the URL
"""
qry = db_session.query(Info).filter(Info.id==id)
info = qry.first()
if info:
form = InfoForm(formdata=request.form, obj=info)
if request.method == 'POST' and form.validate():
# delete the item from the database
db_session.delete(info)
db_session.commit()
flash('info deleted successfully!')
return redirect('/')
return render_template('delete_album.html', form=form)
else:
return 'Error deleting #{id}'.format(id=id)
def edit_info():
form = InfoForm()
if form.validate_on_submit():
current_user.name = form.name.data
current_user.phone = form.phone.data
current_user.gender = form.gender.data
current_user.age = form.age.data
current_user.about_me = form.about_me.data
if session.get('avater_temp') and request.values.get('is_update_avatar',type=bool):
x=request.values.get('select_x',type=int)
y=request.values.get('select_y',type=int)
x2=request.values.get('select_x2',type=int)
y2=request.values.get('select_y2',type=int)
path=session['avater_temp']
url=get_img_url(cut_img(path,(x,y,x2,y2)))
current_user.avatar=url
session['avater_temp']=None
db.session.add(current_user)
db.session.commit()
return redirect(url_for('auth.info'))
return render_template('auth/edit_info.html', form=form)
def edit():
form = InfoForm()
if form.validate_on_submit():
role = Role.query.filter_by(name=form.name.data).first()
user_role=g.user.role.all()
if user_role==[]:
roles= Role(position=form.position.data,name=form.name.data,tel=form.tel.data,author=g.user)
db.session.add(roles)
db.session.commit()
flash(u'信息添加成功！')
else:
if role is not None:
if g.user.role[0].name==role.name:
role.position=form.position.data
role.tel=form.tel.data
db.session.add(role)
db.session.commit()
flash(u'信息修改成功！')
else:
flash(u'真实姓名不符，无法修改！')
else:
flash(u'真实姓名不符，无法修改！')
role_list= models.Role.query.all()
position_list=[]
name_list=[]
tel_list=[]
positions=[]
names=[]
tels=[]
for role in role_list:
position_list.append(role.position)
name_list.append(role.name)
tel_list.append(role.tel)
return render_template('edit.html',
title='Home',
form=form,
position_list=position_list,name_list=name_list,tel_list=tel_list,role_list=role_list)
def submit():
form = InfoForm()
if form.validate_on_submit():
infoList =[]
for i in form:
infoList.append(i.data)
print(infoList)
eventDf = pd.DataFrame(infoList[0:-2]).transpose()
eventDf.columns = ['event_name',
'question1',
'question2',
'question3',
'answer1',
'answer2',
'answer3',
'answer4',
'answer5',
'answer6',
'answer7',
'answer8',
'answer9',
]
eventDict = eventDf.to_dict('index')[0]
print(eventDict)
config = {
"apiKey": "AIzaSyCb4oRMVM6s4eFTJ9oMU5p4Xpv_9GQvMCE",
"authDomain": "studentgo-76a0d.firebaseapp.com",
"databaseURL": "https://studentgo-76a0d.firebaseio.com/",
"storageBucket": "studentgo-76a0d.appspot.com"
}
firebase = pyrebase.initialize_app(config)
auth = firebase.auth()
db = firebase.database()
db.child("Events").push(eventDict)
return redirect(url_for('home'))
return render_template('form.html', title='Submit', form=form)
def edit_info(user_id):
form = InfoForm()
user = User.query.filter(User.id == user_id).first()
if request.method == 'GET':
return render_template('edit_info.html', form=form)
else:
email = request.form.get('email')
address = request.form.get('address')
hobby = request.form.get('hobby')
user.email = email
user.address = address
user.hobby = hobby
db.session.add(user)
db.session.commit()
return redirect(url_for('user_detail', user_id=user_id))
def index():
name=False
district=False
state=False
area=False
beds= False
form = InfoForm()
page = request.args.get('page', 1, type=int)
print('page: ', page)
if request.method == 'POST':
name = form.name.data
district = form.district.data
state = form.state.data
area = form.area.data
beds = form.beds.data
page = 1
print(name)
print(district)
if request.method == 'GET':
name = request.args.get('name')
state = request.args.get('state')
district = request.args.get('district')
area = request.args.get('area')
beds = request.args.get('beds')
# data = Hospital.query.order_by(Hospital.total_beds.desc()).paginate(per_page=5, page=page)
if form.validate_on_submit() and request.method == "POST":
print('POST request')
#print(request.form['name'])
# print(form.name.data)
data = Hospital.query.order_by(Hospital.total_beds.desc()).paginate(per_page=5, page=page)
# if request.method == "POST":
#print(request.form['name'])
# if name =='Please Select':
# name_avail = False
# if district =='Please Select':
# district_avail = False
# if state =='Please Select':
# state_avail = False
# if area =='Please Select':
# area_avail = False
if(name =='Please Select' and district =='Please Select' and state =='Please Select' and area =='Please Select'):
if beds == 'total_beds':
data = Hospital.query.order_by(Hospital.total_beds.desc()).paginate(per_page=5, page=page)
elif beds== 'available_beds':
data = Hospital.query.order_by(Hospital.available_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds':
data = Hospital.query.order_by(Hospital.available_ward_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds_with_oxygen':
data = Hospital.query.order_by(Hospital.available_ward_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds':
data = Hospital.query.order_by(Hospital.available_icu_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds_with_oxygen':
data = Hospital.query.order_by(Hospital.available_icu_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif(name != 'Please Select' and district =='Please Select' and state =='Please Select' and area =='Please Select'):
if beds == 'total_beds':
data = Hospital.query.filter_by(name=name).order_by(Hospital.total_beds.desc()).paginate(per_page=5, page=page)
elif beds== 'available_beds':
data = Hospital.query.filter_by(name=name).order_by(Hospital.available_beds).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds':
data = Hospital.query.filter_by(name=name).order_by(Hospital.available_ward_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds_with_oxygen':
data = Hospital.query.filter_by(name=name).order_by(Hospital.available_ward_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds':
data = Hospital.query.filter_by(name=name).order_by(Hospital.available_icu_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds_with_oxygen':
data = Hospital.query.filter_by(name=name).order_by(Hospital.available_icu_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif(name == 'Please Select' and district !='Please Select' and state =='Please Select' and area =='Please Select'):
if beds == 'total_beds':
data = Hospital.query.filter_by(district=district).order_by(Hospital.total_beds.desc()).paginate(per_page=5, page=page)
elif beds== 'available_beds':
data = Hospital.query.filter_by(district=district).order_by(Hospital.available_beds).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds':
data = Hospital.query.filter_by(district=district).order_by(Hospital.available_ward_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds_with_oxygen':
data = Hospital.query.filter_by(district=district).order_by(Hospital.available_ward_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds':
data = Hospital.query.filter_by(district=district).order_by(Hospital.available_icu_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds_with_oxygen':
data = Hospital.query.filter_by(district=district).order_by(Hospital.available_icu_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif(name == 'Please Select' and district =='Please Select' and state !='Please Select' and area =='Please Select'):
if beds == 'total_beds':
data = Hospital.query.filter_by(state=state).order_by(Hospital.total_beds.desc()).paginate(per_page=5, page=page)
elif beds== 'available_beds':
data = Hospital.query.filter_by(state=state).order_by(Hospital.available_beds).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds':
data = Hospital.query.filter_by(state=state).order_by(Hospital.available_ward_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds_with_oxygen':
data = Hospital.query.filter_by(state=state).order_by(Hospital.available_ward_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds':
data = Hospital.query.filter_by(state=state).order_by(Hospital.available_icu_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds_with_oxygen':
data = Hospital.query.filter_by(state=state).order_by(Hospital.available_icu_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif(name == 'Please Select' and district =='Please Select' and state =='Please Select' and area !='Please Select'):
if beds == 'total_beds':
data = Hospital.query.filter_by(area=area).order_by(Hospital.total_beds.desc()).paginate(per_page=5, page=page)
elif beds== 'available_beds':
data = Hospital.query.filter_by(area=area).order_by(Hospital.available_beds).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds':
data = Hospital.query.filter_by(area=area).order_by(Hospital.available_ward_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds_with_oxygen':
data = Hospital.query.filter_by(area=area).order_by(Hospital.available_ward_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds':
data = Hospital.query.filter_by(area=area).order_by(Hospital.available_icu_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds_with_oxygen':
data = Hospital.query.filter_by(area=area).order_by(Hospital.available_icu_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif(name != 'Please Select' and district !='Please Select' and state =='Please Select' and area =='Please Select'):
if beds == 'total_beds':
data = Hospital.query.filter_by(name=name, district=district).order_by(Hospital.total_beds.desc()).paginate(per_page=5, page=page)
elif beds== 'available_beds':
data = Hospital.query.filter_by(name=name, district=district).order_by(Hospital.available_beds).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds':
data = Hospital.query.filter_by(name=name, district=district).order_by(Hospital.available_ward_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds_with_oxygen':
data = Hospital.query.filter_by(name=name, district=district).order_by(Hospital.available_ward_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds':
data = Hospital.query.filter_by(name=name, district=district).order_by(Hospital.available_icu_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds_with_oxygen':
data = Hospital.query.filter_by(name=name, district=district).order_by(Hospital.available_icu_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif(name != 'Please Select' and district =='Please Select' and state !='Please Select' and area =='Please Select'):
if beds == 'total_beds':
data = Hospital.query.filter_by(name=name, state=state).order_by(Hospital.total_beds.desc()).paginate(per_page=5, page=page)
elif beds== 'available_beds':
data = Hospital.query.filter_by(name=name, state=state).order_by(Hospital.available_beds).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds':
data = Hospital.query.filter_by(name=name, state=state).order_by(Hospital.available_ward_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds_with_oxygen':
data = Hospital.query.filter_by(name=name, state=state).order_by(Hospital.available_ward_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds':
data = Hospital.query.filter_by(name=name, state=state).order_by(Hospital.available_icu_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds_with_oxygen':
data = Hospital.query.filter_by(name=name, state=state).order_by(Hospital.available_icu_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif(name != 'Please Select' and district =='Please Select' and state =='Please Select' and area !='Please Select'):
if beds == 'total_beds':
data = Hospital.query.filter_by(name=name, area=area).order_by(Hospital.total_beds.desc()).paginate(per_page=5, page=page)
elif beds== 'available_beds':
data = Hospital.query.filter_by(name=name, area=area).order_by(Hospital.available_beds).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds':
data = Hospital.query.filter_by(name=name, area=area).order_by(Hospital.available_ward_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds_with_oxygen':
data = Hospital.query.filter_by(name=name, area=area).order_by(Hospital.available_ward_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds':
data = Hospital.query.filter_by(name=name, area=area).order_by(Hospital.available_icu_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds_with_oxygen':
data = Hospital.query.filter_by(name=name, area=area).order_by(Hospital.available_icu_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif(name == 'Please Select' and district !='Please Select' and state !='Please Select' and area =='Please Select'):
if beds == 'total_beds':
data = Hospital.query.filter_by(district=district, state=state).order_by(Hospital.total_beds.desc()).paginate(per_page=5, page=page)
elif beds== 'available_beds':
data = Hospital.query.filter_by(district=district, state=state).order_by(Hospital.available_beds).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds':
data = Hospital.query.filter_by(district=district, state=state).order_by(Hospital.available_ward_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds_with_oxygen':
data = Hospital.query.filter_by(district=district, state=state).order_by(Hospital.available_ward_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds':
data = Hospital.query.filter_by(district=district, state=state).order_by(Hospital.available_icu_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds_with_oxygen':
data = Hospital.query.filter_by(district=district, state=state).order_by(Hospital.available_icu_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif(name == 'Please Select' and district !='Please Select' and state =='Please Select' and area !='Please Select'):
if beds == 'total_beds':
data = Hospital.query.filter_by(district=district, area=area).order_by(Hospital.total_beds.desc()).paginate(per_page=5, page=page)
elif beds== 'available_beds':
data = Hospital.query.filter_by(district=district, area=area).order_by(Hospital.available_beds).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds':
data = Hospital.query.filter_by(district=district, area=area).order_by(Hospital.available_ward_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds_with_oxygen':
data = Hospital.query.filter_by(district=district, area=area).order_by(Hospital.available_ward_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds':
data = Hospital.query.filter_by(district=district, area=area).order_by(Hospital.available_icu_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds_with_oxygen':
data = Hospital.query.filter_by(district=district, area=area).order_by(Hospital.available_icu_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif(name == 'Please Select' and district =='Please Select' and state !='Please Select' and area !='Please Select'):
if beds == 'total_beds':
data = Hospital.query.filter_by(state=state, area=area).order_by(Hospital.total_beds.desc()).paginate(per_page=5, page=page)
elif beds== 'available_beds':
data = Hospital.query.filter_by(state=state, area=area).order_by(Hospital.available_beds).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds':
data = Hospital.query.filter_by(state=state, area=area).order_by(Hospital.available_ward_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds_with_oxygen':
data = Hospital.query.filter_by(state=state, area=area).order_by(Hospital.available_ward_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds':
data = Hospital.query.filter_by(state=state, area=area).order_by(Hospital.available_icu_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds_with_oxygen':
data = Hospital.query.filter_by(state=state, area=area).order_by(Hospital.available_icu_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif(name != 'Please Select' and district !='Please Select' and state !='Please Select' and area =='Please Select'):
if beds == 'total_beds':
data = Hospital.query.filter_by(name=name, district=district, state=state).order_by(Hospital.total_beds.desc()).paginate(per_page=5, page=page)
elif beds== 'available_beds':
data = Hospital.query.filter_by(name=name, district=district, state=state).order_by(Hospital.available_beds).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds':
data = Hospital.query.filter_by(name=name, district=district, state=state).order_by(Hospital.available_ward_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds_with_oxygen':
data = Hospital.query.filter_by(name=name, district=district, state=state).order_by(Hospital.available_ward_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds':
data = Hospital.query.filter_by(name=name, district=district, state=state).order_by(Hospital.available_icu_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds_with_oxygen':
data = Hospital.query.filter_by(name=name, district=district, state=state).order_by(Hospital.available_icu_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif(name != 'Please Select' and district !='Please Select' and state =='Please Select' and area !='Please Select'):
if beds == 'total_beds':
data = Hospital.query.filter_by(name=name, district=district, area=area).order_by(Hospital.total_beds.desc()).paginate(per_page=5, page=page)
elif beds== 'available_beds':
data = Hospital.query.filter_by(name=name, district=district, area=area).order_by(Hospital.available_beds).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds':
data = Hospital.query.filter_by(name=name, district=district, area=area).order_by(Hospital.available_ward_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds_with_oxygen':
data = Hospital.query.filter_by(name=name, district=district, area=area).order_by(Hospital.available_ward_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds':
data = Hospital.query.filter_by(name=name, district=district, area=area).order_by(Hospital.available_icu_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds_with_oxygen':
data = Hospital.query.filter_by(name=name, district=district, area=area).order_by(Hospital.available_icu_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif(name != 'Please Select' and district =='Please Select' and state !='Please Select' and area !='Please Select'):
if beds == 'total_beds':
data = Hospital.query.filter_by(name=name, state=state, area=area).order_by(Hospital.total_beds.desc()).paginate(per_page=5, page=page)
elif beds== 'available_beds':
data = Hospital.query.filter_by(name=name, state=state, area=area).order_by(Hospital.available_beds).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds':
data = Hospital.query.filter_by(name=name, state=state, area=area).order_by(Hospital.available_ward_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds_with_oxygen':
data = Hospital.query.filter_by(name=name, state=state, area=area).order_by(Hospital.available_ward_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds':
data = Hospital.query.filter_by(name=name, state=state, area=area).order_by(Hospital.available_icu_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds_with_oxygen':
data = Hospital.query.filter_by(name=name, state=state, area=area).order_by(Hospital.available_icu_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif(name == 'Please Select' and district !='Please Select' and state !='Please Select' and area !='Please Select'):
if beds == 'total_beds':
data = Hospital.query.filter_by(district=district, state=state, area=area).order_by(Hospital.total_beds.desc()).paginate(per_page=5, page=page)
elif beds== 'available_beds':
data = Hospital.query.filter_by(district=district, state=state, area=area).order_by(Hospital.available_beds).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds':
data = Hospital.query.filter_by(district=district, state=state, area=area).order_by(Hospital.available_ward_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds_with_oxygen':
data = Hospital.query.filter_by(district=district, state=state, area=area).order_by(Hospital.available_ward_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds':
data = Hospital.query.filter_by(district=district, state=state, area=area).order_by(Hospital.available_icu_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds_with_oxygen':
data = Hospital.query.filter_by(district=district, state=state, area=area).order_by(Hospital.available_icu_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif(name != 'Please Select' and district !='Please Select' and state !='Please Select' and area !='Please Select'):
if beds == 'total_beds':
data = Hospital.query.filter_by(name=name, district=district, state=state, area=area).order_by(Hospital.total_beds.desc()).paginate(per_page=5, page=page)
elif beds== 'available_beds':
data = Hospital.query.filter_by(name=name, district=district, state=state, area=area).order_by(Hospital.available_beds).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds':
data = Hospital.query.filter_by(name=name, district=district, state=state, area=area).order_by(Hospital.available_ward_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_ward_beds_with_oxygen':
data = Hospital.query.filter_by(name=name, district=district, state=state, area=area).order_by(Hospital.available_ward_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds':
data = Hospital.query.filter_by(name=name, district=district, state=state, area=area).order_by(Hospital.available_icu_beds.desc()).paginate(per_page=5, page=page)
elif beds == 'available_icu_beds_with_oxygen':
data = Hospital.query.filter_by(name=name, district=district, state=state, area=area).order_by(Hospital.available_icu_beds_with_oxygen.desc()).paginate(per_page=5, page=page)
else:
data = Hospital.query.order_by(Hospital.total_beds.desc()).paginate(per_page=5, page=page)
print("Get Request")
form.name.data = name
form.district.data = district
form.state.data = state
form.area.data = area
form.beds.data = beds
return render_template('index.html', form=form, name=name, district=district, state=state, area=area, beds=beds, hospitals=data)