def get(self): submit = request.args resp = excel.make_response_from_records(Purchase.export(submit), "xlsx") resp.headers[ "Content-Disposition"] = "attachment; filename=purchase.xlsx" return resp
def downloadSurvey(): if not session.get("companyId") and session.get("level")==2: db_result = db_session.query(User, Answer)\ .join(Answer, Answer.userId==User.userId)\ .all() elif session.get("companyId"): db_result = db_session.query(User, Answer)\ .join(Answer, Answer.userId==User.userId)\ .filter(User.companyId==session["companyId"])\ .all() # query_sets = Answer.query.join.limit(5).all() # column_names = ['answerId'] # return excel.make_response_from_query_sets(query_sets, column_names, "xls") else: abort(401) records = list() userKeys = User.__table__.columns.keys() answerKeys = Answer.__table__.columns.keys() for row1, row2 in db_result: od = OrderedDict() rowJSON1 = row1.tojson() for k in userKeys: od[k] = rowJSON1[k] rowJSON2 = row2.tojson() for k in answerKeys: od[k] = rowJSON2[k] records.append(od) return excel.make_response_from_records(records, "xls") #여기서 컬럼순서가 망가진다...
def get(self, field=""): result = [] field_default = { "cn": "名", "businessCategory": "部门", "title": "职务", "mail": "电子邮件地址", } field_ext = { "mobile": "手机" } fields = dict(field_default.items() + field_ext.items()) if field in fields.keys(): fields = {field: fields[field], "uid": "用户名"} else: fields = field_default ldap = Ldap() for u in ldap.export(fields.keys()): _dict = {} for key in u.keys(): _dict[fields[key]] = u[key] result.append(_dict) resp = excel.make_response_from_records(result, "xlsx") resp.headers["Content-Disposition"] = "attachment; filename=user.xlsx" return resp
def get(self, field=""): result = [] field_default = { "cn": "名", "businessCategory": "部门", "title": "职务", "mail": "电子邮件地址", } field_ext = {"mobile": "手机"} fields = dict(field_default.items() + field_ext.items()) if field in fields.keys(): fields = {field: fields[field], "uid": "用户名"} else: fields = field_default ldap = Ldap() for u in ldap.export(fields.keys()): _dict = {} for key in u.keys(): _dict[fields[key]] = u[key] result.append(_dict) resp = excel.make_response_from_records(result, "xlsx") resp.headers["Content-Disposition"] = "attachment; filename=user.xlsx" return resp
def signup(): observations = 'observations.html' blat = 18.30 blong = -69.59 if request.method == 'POST': print request.form #if request.form['Fields'] == 'Fields': if 'Create_Fields' in request.form: key = request.form['bkey'] secret = request.form['bsecret'] lat = request.form['blat'] long = request.form['blong'] field_id = request.form['field_id'] farm_id = request.form['farm_id'] y = AWhereCall(key, secret) fields = y.create_field(lat, long, field_id, farm_id) return render_template(observations, fields=fields) if 'BFields' in request.form: key = request.form['bkey'] secret = request.form['bsecret'] y = AWhereCall(key, secret) fields = y.get_fields() return render_template(observations, fields=fields) if 'Fields' in request.form: key = request.form['key'] secret = request.form['secret'] y = AWhereCall(key, secret) fields = y.get_fields() return render_template(observations, fields=fields) if 'Observations' in request.form: key = request.form['bkey'] secret = request.form['bsecret'] field = request.form['field_id'] y = AWhereCall(key, secret) out = y.get_observations(field) blat = out['observations'][0]['location']['latitude'] blong = out['observations'][0]['location']['longitude'] blong = -blong flat = y.flatten_observations(out) df = pd.DataFrame(flat) return render_template(observations, flat=df.to_html(), blat=blat, blong=blong) if 'Download' in request.form: key = request.form['bkey'] secret = request.form['bsecret'] field = request.form['field_id'] y = AWhereCall(key, secret) out = y.get_observations(field) flat = y.flatten_observations(out) return excel.make_response_from_records(flat, "csv") return render_template(observations, blat=blat, blong=blong)
def signup(): observations = 'observations.html' blat=18.30 blong=-69.59 if request.method == 'POST': print request.form #if request.form['Fields'] == 'Fields': if 'Create_Fields' in request.form: key = request.form['bkey'] secret = request.form['bsecret'] lat = request.form['blat'] long = request.form['blong'] field_id = request.form['field_id'] farm_id = request.form['farm_id'] y = AWhereCall(key, secret) fields = y.create_field(lat, long, field_id, farm_id) return render_template(observations, fields=fields) if 'BFields' in request.form: key = request.form['bkey'] secret = request.form['bsecret'] y = AWhereCall(key, secret) fields = y.get_fields() return render_template(observations, fields=fields) if 'Fields' in request.form: key = request.form['key'] secret = request.form['secret'] y = AWhereCall(key, secret) fields = y.get_fields() return render_template(observations, fields=fields) if 'Observations' in request.form: key = request.form['bkey'] secret = request.form['bsecret'] field = request.form['field_id'] y = AWhereCall(key, secret) out = y.get_observations(field) blat = out['observations'][0]['location']['latitude'] blong = out['observations'][0]['location']['longitude'] blong = -blong flat = y.flatten_observations(out) df = pd.DataFrame(flat) return render_template(observations, flat=df.to_html(), blat=blat, blong=blong) if 'Download' in request.form: key = request.form['bkey'] secret = request.form['bsecret'] field = request.form['field_id'] y = AWhereCall(key, secret) out = y.get_observations(field) flat = y.flatten_observations(out) return excel.make_response_from_records(flat, "csv") return render_template(observations, blat=blat, blong=blong)
def upload_array(struct_type): if struct_type == "array": array = request.get_array(field_name='file') return excel.make_response_from_array(array, 'xls') elif struct_type == "dict": adict = request.get_dict(field_name='file') return excel.make_response_from_dict(adict, 'xls') elif struct_type == "records": records = request.get_records(field_name='file') return excel.make_response_from_records(records, 'xls') elif struct_type == "book": book = request.get_book(field_name='file') return excel.make_response(book, 'xls') elif struct_type == "book_dict": book_dict = request.get_book_dict(field_name='file') return excel.make_response_from_book_dict(book_dict, 'xls')
def get(self): submit = request.args resp = excel.make_response_from_records(Stock.export(submit), "xlsx") resp.headers["Content-Disposition"] = "attachment; filename=stock.xlsx" return resp
def download(): sql_data = cache.get('sql_data') response = excel.make_response_from_records(sql_data, 'xls') return response