$result = array();
$mdb2 = getConnection();
- $sql = "select id, name, description from tt_roles where team_id = $team_id and status = 1 order by rank";
+ $sql = "select id, name, rank, description from tt_roles where team_id = $team_id and status = 1 order by rank";
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$result = array();
$mdb2 = getConnection();
- $sql = "select id, name, description from tt_roles
+ $sql = "select id, name, rank, description from tt_roles
where team_id = $team_id and status = 0 order by rank";
$res = $mdb2->query($sql);
$result = array();
return $result;
}
+ // getAllRoles - obtains all roles defined for team.
+ static function getAllRoles($team_id) {
+ $mdb2 = getConnection();
+
+ $result = array();
+ $sql = "select * from tt_roles where team_id = $team_id";
+ $res = $mdb2->query($sql);
+ $result = array();
+ if (!is_a($res, 'PEAR_Error')) {
+ while ($val = $res->fetchRow()) {
+ $result[] = $val;
+ }
+ return $result;
+ }
+ return false;
+ }
+
// The getActiveClients returns an array of active clients for team.
static function getActiveClients($team_id, $all_fields = false)
{
return false;
}
- // getRoles - obtains all roles defined for team.
- static function getRoles($team_id) {
- $mdb2 = getConnection();
-
- $result = array();
- $sql = "select * from tt_roles where team_id = $team_id";
- $res = $mdb2->query($sql);
- $result = array();
- if (!is_a($res, 'PEAR_Error')) {
- while ($val = $res->fetchRow()) {
- $result[] = $val;
- }
- return $result;
- }
- return false;
- }
-
// getExpenseItems - obtains all expense items for all users in team.
static function getExpenseItems($team_id) {
$mdb2 = getConnection();