Add last updated section to homepage

2 files changed, 13 insertions, 2 deletions

diff --git a/app/blueprints/homepage/__init__.py b/app/blueprints/homepage/__init__.py
index 37c1800..063aa92 100644
--- a/app/blueprints/homepage/__init__.py
+++ b/app/blueprints/homepage/__init__.py
@@ -17,12 +17,22 @@ def home():
 
 	query   = Package.query.filter_by(approved=True, soft_deleted=False)
 	count   = query.count()
+
 	new     = join(query.order_by(db.desc(Package.created_at))).limit(8).all()
 	pop_mod = join(query.filter_by(type=PackageType.MOD).order_by(db.desc(Package.score))).limit(8).all()
 	pop_gam = join(query.filter_by(type=PackageType.GAME).order_by(db.desc(Package.score))).limit(4).all()
 	pop_txp = join(query.filter_by(type=PackageType.TXP).order_by(db.desc(Package.score))).limit(4).all()
+
+	updated = db.session.query(Package).select_from(PackageRelease).join(Package) \
+			.filter_by(soft_deleted=False, approved=True) \
+			.order_by(db.desc(PackageRelease.releaseDate)) \
+			.limit(8).all()
+	updated = updated[:4]
+
 	reviews = PackageReview.query.filter_by(recommends=True).order_by(db.desc(PackageReview.created_at)).limit(5).all()
+
 	downloads_result = db.session.query(func.sum(Package.downloads)).one_or_none()
 	downloads = 0 if not downloads_result or not downloads_result[0] else downloads_result[0]
+
 	return render_template("index.html", count=count, downloads=downloads, \
-			new=new, pop_mod=pop_mod, pop_txp=pop_txp, pop_gam=pop_gam, reviews=reviews)
+			new=new, updated=updated, pop_mod=pop_mod, pop_txp=pop_txp, pop_gam=pop_gam, reviews=reviews)
diff --git a/app/blueprints/packages/packages.py b/app/blueprints/packages/packages.py
index 3b9ca4a..6ff6623 100644
--- a/app/blueprints/packages/packages.py
+++ b/app/blueprints/packages/packages.py
@@ -301,7 +301,7 @@ def create_edit(author=None, name=None):
 
 		form.populate_obj(package) # copy to row
 
-		if package.type== PackageType.TXP:
+		if package.type == PackageType.TXP:
 			package.license = package.media_license
 
 		mpackage_cache = {}
@@ -367,6 +367,7 @@ def approve(package):
 
 	else:
 		package.approved = True
+		package.approved_at = datetime.datetime.now()
 
 		screenshots = PackageScreenshot.query.filter_by(package=package, approved=False).all()
 		for s in screenshots: