def admin_replies_list():
offset = request.args.get("offset", 0)
limit = 50
# get all users EXCEPT the logged in user
flags_subq = db.session.query(Flag, func.count("*").label("flag_count")).group_by(Flag.reply_id).subquery()
replies = db.session.query(Reply, flags_subq.c.flag_count).order_by(flags_subq.c.flag_count.desc())
items = replies.limit(limit).offset(offset).all()
items = [i[0].serialize() for i in items]
for i in items:
i["body"] = strip_html(i["body"])
ret = jsonify({"activities": items})
ret.headers.add("Last-Modified", datetime.now())
ret.headers.add("Cache-Control", "no-store, no-cache, must-revalidate, post-check=0, pre-check=0")
ret.headers.add("Pragma", "no-cache")
return ret
def admin_questions_list(status=None):
offset = request.args.get("offset", 0)
limit = 50
# get all users EXCEPT the logged in user
curr_status = Status.query.filter_by(name=status).first_or_404()
query = Question.query.filter_by(status=curr_status)
items = query.limit(limit).offset(offset).all()
items = [i.serialize() for i in items]
for i in items:
i["question"] = strip_html(i["question"])
ret = jsonify({"activities": items})
ret.headers.add("Last-Modified", datetime.now())
ret.headers.add("Cache-Control", "no-store, no-cache, must-revalidate, post-check=0, pre-check=0")
ret.headers.add("Pragma", "no-cache")
return ret
