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 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 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 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 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 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 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 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 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 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 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 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 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(): 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 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)