1 files changed, 5 insertions, 2 deletions
diff --git a/budget/web.py b/budget/web.py
index c2909bc..a838b09 100644
--- a/budget/web.py
+++ b/budget/web.py
@@ -106,8 +106,11 @@ def invite(project):
 @app.route("/<string:project_id>/")
 @requires_auth
 def list_bills(project):
-    # FIXME filter to only get the bills for this particular project
-    bills = Bill.query.order_by(Bill.id.asc())
+    bills = Bill.query.join(Person, Project)\
+        .filter(Bill.payer_id == Person.id)\
+        .filter(Person.project_id == Project.id)\
+        .filter(Project.id == project.id)\
+        .order_by(Bill.date.desc())
     return render_template("list_bills.html", 
             bills=bills, project=project, 
             member_form=MemberForm(project),