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
