1 files changed, 10 insertions, 0 deletions
diff --git a/ihatemoney/models.py b/ihatemoney/models.py
index 6c71a57..cd896f3 100644
--- a/ihatemoney/models.py
+++ b/ihatemoney/models.py
@@ -144,6 +144,16 @@ class Project(db.Model):
             .order_by(Bill.date.desc())\
             .order_by(Bill.id.desc())
 
+    def get_member_bills(self, member_id):
+        """Return the list of bills related to a specific member"""
+        return Bill.query.join(Person, Project)\
+            .filter(Bill.payer_id == Person.id)\
+            .filter(Person.project_id == Project.id)\
+            .filter(Person.id == member_id)\
+            .filter(Project.id == self.id)\
+            .order_by(Bill.date.desc())\
+            .order_by(Bill.id.desc())
+
     def get_pretty_bills(self, export_format="json"):
         """Return a list of project's bills with pretty formatting"""
         bills = self.get_bills()