From 084272c60ea97f3a835cfccbb3303227d00085e8 Mon Sep 17 00:00:00 2001
From: Frederic Guillot <fred@kanboard.net>
Date: Sun, 15 Mar 2015 17:28:46 -0400
Subject: Add cost breakdown for project budget

---
 app/Model/HourlyRate.php | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

(limited to 'app/Model/HourlyRate.php')

diff --git a/app/Model/HourlyRate.php b/app/Model/HourlyRate.php
index c2ce3eaf..1550bdae 100644
--- a/app/Model/HourlyRate.php
+++ b/app/Model/HourlyRate.php
@@ -20,6 +20,24 @@ class HourlyRate extends Base
      */
     const TABLE = 'hourly_rates';
 
+    /**
+     * Get all user rates for a given project
+     *
+     * @access public
+     * @param  integer  $project_id
+     * @return array
+     */
+    public function getAllByProject($project_id)
+    {
+        $members = $this->projectPermission->getMembers($project_id);
+
+        if (empty($members)) {
+            return array();
+        }
+
+        return $this->db->table(self::TABLE)->in('user_id', array_keys($members))->desc('date_effective')->findAll();
+    }
+
     /**
      * Get all rates for a given user
      *
-- 
cgit v1.2.3