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 ''