aboutsummaryrefslogtreecommitdiff
path: root/app/blueprints
diff options
context:
space:
mode:
authorrubenwardy <rw@rubenwardy.com>2020-07-15 00:21:20 +0100
committerrubenwardy <rw@rubenwardy.com>2020-07-15 00:21:20 +0100
commit15bbc35e656421d415cd6cba8accb83a77e7d84f (patch)
tree2b5f36ad23e9db1489830845359a1063bde9ff05 /app/blueprints
parentc9e4638b348a5d9004376ed90e72fe8bb9df40e3 (diff)
downloadcheatdb-15bbc35e656421d415cd6cba8accb83a77e7d84f.tar.xz
Use query builder in tag list, add link to todo page
Diffstat (limited to 'app/blueprints')
-rw-r--r--app/blueprints/todo/__init__.py13
1 files changed, 10 insertions, 3 deletions
diff --git a/app/blueprints/todo/__init__.py b/app/blueprints/todo/__init__.py
index 89e24b8..ba370a6 100644
--- a/app/blueprints/todo/__init__.py
+++ b/app/blueprints/todo/__init__.py
@@ -64,10 +64,14 @@ def view():
.filter(~ db.exists().where(Package.forums==ForumTopic.topic_id)) \
.count()
+ total_packages = Package.query.filter_by(approved=True, soft_deleted=False).count()
+ total_to_tag = Package.query.filter_by(approved=True, soft_deleted=False, tags=None).count()
+
return render_template("todo/list.html", title="Reports and Work Queue",
packages=packages, releases=releases, screenshots=screenshots,
canApproveNew=canApproveNew, canApproveRel=canApproveRel, canApproveScn=canApproveScn,
- topics_to_add=topics_to_add, total_topics=total_topics)
+ topics_to_add=topics_to_add, total_topics=total_topics, \
+ total_packages=total_packages, total_to_tag=total_to_tag)
@bp.route("/todo/topics/")
@@ -105,7 +109,10 @@ def topics():
@bp.route("/todo/tags/")
@login_required
def tags():
- packages = Package.query.filter_by(approved=True, soft_deleted=False).all()
+ qb = QueryBuilder(request.args)
+ qb.setSortIfNone("score", "desc")
+ query = qb.buildPackageQuery()
+
tags = Tag.query.order_by(db.asc(Tag.title)).all()
- return render_template("todo/tags.html", packages=packages, tags=tags)
+ return render_template("todo/tags.html", packages=query.all(), tags=tags)