def query(): # 设置数据 period = range(1978, 2014) db = ProvinceStatisticsDatabase() if request.method == 'POST': form_data = request.form print(form_data) period_chosen = form_data.getlist('period') region_chosen = re.split(',', form_data.getlist('hregion')[0]) variables_chosen = form_data.getlist('variable') print(period_chosen) print(region_chosen) print(variables_chosen) conds = {'region': region_chosen, 'year': period_chosen, 'variable': variables_chosen} mdata = db.find(conds) header = mdata['header'] data = mdata['data'] print(mdata) fdata = [header] fdata.extend(data) print(fdata) filename = str(uuid.uuid1()) + '.xlsx' session['filename'] = filename outfile = ''.join([TEMP_FILE_FOLDER, filename]) print(url_for('myapp.index')) moutexcel = Excel(outfile) moutexcel.new().append(fdata, 'mysheet') moutexcel.close() return render_template("queryresult.html", header=header, data=data) return render_template("query.html", period=period)
def ajaxtwo(): db = AQIDatabase() if request.method == 'POST': form_data = request.form cities = form_data.getlist('city') start_date = form_data.get('startpick') end_date = form_data.get('endpick') conds = {'region': cities, 'sdate': start_date, 'edate': end_date} mdata = db.find(conds) header = mdata['header'] data = mdata['data'] print(mdata) fdata = [header] fdata.extend(data) print(fdata) filename = str(uuid.uuid1()) + '.xlsx' session['filename'] = filename outfile = 'E:\\gitwork\\application\\webapp\\static\\file\\' + filename moutexcel = Excel(outfile) moutexcel.new().append(fdata, 'mysheet') moutexcel.close() return render_template("queryresult.html", header=header, data=data) return render_template('ajaxtwo.html', cities=db.city)