def ht_reports_by_open_id():
open_id = request.args.get("open_id")
re_data_json = {'ok': '0', 'info': ''}
if session['username']:
try:
result = User.query.filter(User.open_id == open_id).first()
reports = Reporter.query.order_by(Reporter.updatetime.desc()).filter_by(user_id=int(result.id))
report_json =[]
for report in reports:
eq = EqInfo.query.filter_by(cata_id=report.cata_id).first()
report_dict = serialize.serialize_model(report)
eq_info = serialize.serialize_model(eq)
report_dict['eq'] = eq_info
report_json.append(report_dict)
db.close_all_sessions()
re_data_json['info'] = report_json
re_data_json["ok"] = 1
lines = json.dumps(re_data_json, cls=serialize.DateEnconding)
return jsonify(lines) # 返回数据
except Exception as e1:
re_data_json['info'] = e1
re_data_json["ok"] = 0
return jsonify(re_data_json) # 返回数据
else:
return ''
def ht_user_infos():
page_index = request.args.get("page_index")
page_size = request.args.get("page_size")
is_wx = request.args.get("is_wx")
if session['username']:
re_data_json = {'ok': '0', 'info': ''}
try:
page_count = db.session.query(func.count(User.id)).scalar()
users = User.query.order_by(User.id.desc()) \
.filter(User.is_wx == 2).offset((int(page_index) - 1) * int(page_size)) \
.limit(int(page_size)).all() # 对数据做某些处理
data_json = []
for data in users:
user_json = serialize.serialize_model(data)
data_json.append(user_json)
db.close_all_sessions()
re_data_json['info'] = data_json
re_data_json['page_total'] = page_count
re_data_json["ok"] = 1
return jsonify(re_data_json) # 返回数据
except Exception as e1:
re_data_json['info'] = e1
re_data_json["ok"] = 0
return jsonify(re_data_json) # 返回数据
else:
return ''
def eq_reports():
data_json = []
re_data_json = {'ok': '0', 'info': ''}
if session['username']:
cata_id = request.args.get("cata_id")
datas = Reporter.query.order_by(Reporter.updatetime.desc())\
.filter_by(cata_id=cata_id).limit(100)
for data in datas:
report_dict = serialize.serialize_model(data)
user = User.query.filter_by(id=data.user_id).first()
user_dict = serialize.serialize_model(user)
user_dict.pop("password")
report_dict['user'] = user_dict
data_json.append(report_dict)
re_data_json['info'] = data_json
re_data_json["ok"] = 1
else:
re_data_json['ok'] = 0
re_data_json['info'] = '登录超时或者未登陆，请重新登陆'
return jsonify(re_data_json) # 返回数据
def ht_eq_infos():
# recv_data = request.get_data() # 得到前端传送的数据
page_index = request.args.get("page_index")
page_size = request.args.get("page_size")
is_wx = request.args.get("is_wx")
if session['username']:
re_data_json = {'ok': '0', 'info': ''}
try:
page_total = db.session.query(func.count(EqInfo.cata_id)).scalar()
datas = EqInfo.query.order_by(EqInfo.O_time.desc()).offset((int(page_index)-1)*int(page_size))\
.limit(int(page_size)).all() # 对数据做某些处理
data_json = []
for data in datas:
eq_dict = serialize.serialize_model(data)
reports = Reporter.query.order_by(Reporter.updatetime.desc()).filter_by(cata_id=data.cata_id).limit(page_size)
report_json = []
for report in reports:
if report.is_wx > int(is_wx):
report_dict = serialize.serialize_model(report)
report_dict['user'] = serialize.serialize_model(report.user)
report_json.append(report_dict)
# report_user_json = []
# user = User.query.filter_by(id=report.user_id).first()
# report_user_json.append(serialize.serialize_model(user))
eq_dict['reports'] = report_json
data_json.append(eq_dict)
db.close_all_sessions()
re_data_json['info'] = data_json
re_data_json['page_total'] = page_total
re_data_json["ok"] = 1
return jsonify(re_data_json) # 返回数据
except Exception as e1:
re_data_json['info'] = e1
re_data_json["ok"] = 0
return jsonify(re_data_json) # 返回数据
else:
return ''
def ht_reports_by_id():
r_id = request.args.get("id")
re_data_json = {'ok': '0', 'info': ''}
if session['username']:
try:
report = Reporter.query.filter_by(id=int(r_id)).first()
db.close_all_sessions()
re_data_json['info'] = serialize.serialize_model(report)
re_data_json["ok"] = 1
lines = json.dumps(re_data_json, cls=serialize.DateEnconding)
return jsonify(lines) # 返回数据
except Exception as e1:
re_data_json['info'] = e1
re_data_json["ok"] = 0
return jsonify(re_data_json) # 返回数据
else:
return ''
def eq_infos():
# recv_data = request.get_data() # 得到前端传送的数据
page_index = request.args.get("page_index")
page_size = request.args.get("page_size")
if session['username']:
datas = EqInfo.query.order_by(EqInfo.O_time.desc()).offset((int(page_index)-1)*int(page_size))\
.limit(int(page_size)).all() # 对数据做某些处理
db.close_all_sessions()
data_json = []
re_data_json = {'ok': '0', 'info': ''}
for data in datas:
data_json.append(serialize.serialize_model(data))
re_data_json['info'] = data_json
re_data_json["ok"] = 1
lines = json.dumps(re_data_json, cls=serialize.DateEnconding)
return jsonify(lines) # 返回数据
else:
return ''
def ht_reports_by_cata_id():
cata_id = request.args.get("cata_id")
is_wx = request.args.get("is_wx")
re_data_json = {'ok': '0', 'info': ''}
if session['username']:
try:
reports = Reporter.query.order_by(Reporter.updatetime.desc())\
.filter(Reporter.cata_id == cata_id, Reporter.is_wx > int(is_wx)).limit(100)
db.close_all_sessions()
report_json = []
for report in reports:
report_json.append(serialize.serialize_model(report))
re_data_json["ok"] = 1
re_data_json['info'] = report_json
return jsonify(re_data_json) # 返回数据
except Exception as e1:
re_data_json['info'] = e1
re_data_json["ok"] = 0
return jsonify(re_data_json) # 返回数据
else:
return ''