def aqiquery(): db = AQIDatabase() if request.method == 'POST': conds = {'region': request.form.getlist('city'), 'sdate': request.form.get('startpick'), 'edate': request.form.get('endpick')} region_query = RegionQueryAndSave(db, conds) mdata = region_query.data filename = region_query.save_temp_file() session['filename'] = filename return render_template("queryresult.html", header=mdata.get('header'), data=mdata.get('data')) return render_template('aqiquery.html', cities=db.city)
def hospitalquery(): db = HospitalDatabase() province_list = [[id,db.Province_dict[id]]for id in db.provinceid] if request.method == 'POST': conds = {'region': request.form.getlist('province'), '医院等级': request.form.getlist('hgrade'), '医院类别': request.form.getlist('htype')} print(conds) region_query = RegionQueryAndSave(db, conds) mdata = region_query.data print(mdata) filename = region_query.save_temp_file() session['filename'] = filename return render_template("queryresult.html", header=mdata.get('header'), data=mdata.get('data')) return render_template('hospitalquery.html',province=province_list,hgrade=db.grade,htype=db.type)
def provincedataquery(): # 设置数据 period = range(1978, 2014) db = ProvinceStatisticsDatabase() if request.method == 'POST': conds = {'region': re.split(',', request.form.getlist('hregion')[0]), 'year': request.form.getlist('period'), 'variable': request.form.getlist('variable')} region_query = RegionQueryAndSave(db, conds) mdata = region_query.data filename = region_query.save_temp_file() session['filename'] = filename return render_template("queryresult.html", header=mdata.get('header'), data=mdata.get('data')) return render_template("provincedataquery.html", period=period)