return false;
}
- // The getActiveUsers obtains all active users in a given group.
+ // The getActiveUsers obtains all active users excluding clients in a given group.
static function getActiveUsers($options = null) {
global $user;
global $i18n;
$group_id = $user->getGroup();
$org_id = $user->org_id;
+ $client_part = " and u.client_id is null";
+
if (isset($options['getAllFields']))
- $sql = "select u.*, r.name as role_name, r.rank from tt_users u left join tt_roles r on (u.role_id = r.id) where u.group_id = $group_id and u.org_id = $org_id and u.status = 1 order by upper(u.name)";
+ $sql = "select u.*, r.name as role_name, r.rank from tt_users u left join tt_roles r on (u.role_id = r.id) where u.group_id = $group_id and u.org_id = $org_id and u.status = 1 $client_part order by upper(u.name)";
else
- $sql = "select id, name from tt_users where group_id = $group_id and org_id = $org_id and status = 1 order by upper(name)";
+ $sql = "select u.id, u.name from tt_users u where u.group_id = $group_id and u.org_id = $org_id and u.status = 1 $client_part order by upper(u.name)";
$res = $mdb2->query($sql);
$user_list = array();
if (is_a($res, 'PEAR_Error'))
$user_list[] = $val;
}
- if (isset($options['putSelfFirst'])) {
- // Put own entry at the front.
- $cnt = count($user_list);
- for($i = 0; $i < $cnt; $i++) {
- if ($user_list[$i]['id'] == $user->id) {
- $self = $user_list[$i]; // Found self.
- array_unshift($user_list, $self); // Put own entry at the front.
- array_splice($user_list, $i+1, 1); // Remove duplicate.
- }
+ return $user_list;
+ }
+
+ // getActiveTasks - returns an array of active tasks for a group.
+ static function getActiveTasks()
+ {
+ global $user;
+ $mdb2 = getConnection();
+
+ $group_id = $user->getGroup();
+ $org_id = $user->org_id;
+
+ $sql = "select id, name, description from tt_tasks".
+ " where group_id = $group_id and org_id = $org_id and status = 1 order by upper(name)";
+ $res = $mdb2->query($sql);
+ $result = array();
+ if (!is_a($res, 'PEAR_Error')) {
+ while ($val = $res->fetchRow()) {
+ $result[] = $val;
}
}
+ return $result;
+ }
+
+ // getInactiveTasks - returns an array of inactive tasks for a group.
+ static function getInactiveTasks()
+ {
+ global $user;
+ $mdb2 = getConnection();
+
+ $group_id = $user->getGroup();
+ $org_id = $user->org_id;
+
+ $sql = "select id, name, description from tt_tasks".
+ " where group_id = $group_id and org_id = $org_id and status = 0 order by upper(name)";
+ $res = $mdb2->query($sql);
+ $result = array();
+ if (!is_a($res, 'PEAR_Error')) {
+ while ($val = $res->fetchRow()) {
+ $result[] = $val;
+ }
+ }
+ return $result;
+ }
+
+ // validateCheckboxGroupInput - validates user input in a group of checkboxes
+ // in context of a specific database table.
+ //
+ // We need to make sure that input is a set of unique positive integers, and is
+ // "relevant" to the current group (entities exists in table).
+ //
+ // It is a safeguard against manipulation of data in posts.
+ static function validateCheckboxGroupInput($input, $table) {
+ // Empty input is valid.
+ if (!$input) return true;
+
+ // Input containing duplicates is invalid.
+ if (count($input) !== count(array_unique($input))) return false;
+
+ // Input containing anything but positive integers is invalid.
+ foreach ($input as $single_selection) {
+ if (!is_numeric($single_selection) || $single_selection <= 0) return false;
+ }
+
+ global $user;
+ $mdb2 = getConnection();
+
+ $group_id = $user->getGroup();
+ $org_id = $user->org_id;
+
+ // Now check the table. It must contain all entities associated with current group and org.
+ $comma_separated = implode(',', $input);
+ $sql = "select count(*) as item_count from $table".
+ " where id in ($comma_separated) and group_id = $group_id and org_id = $org_id and status = 1";
+ $res = $mdb2->query($sql);
+ if (is_a($res, 'PEAR_Error')) return false;
+ $val = $res->fetchRow();
+ if (count($input) != $val['item_count'])
+ return false; // Number of entities in table is different.
+
+ return true; // All is good.
+ }
+
+ // The getUsers obtains all active and inactive (but not deleted) users in a group.
+ static function getUsers() {
+ global $user;
+ $mdb2 = getConnection();
+
+ $group_id = $user->getGroup();
+ $org_id = $user->org_id;
+
+ $sql = "select id, name from tt_users where group_id = $group_id and org_id = $org_id and (status = 1 or status = 0) order by upper(name)";
+ $res = $mdb2->query($sql);
+ $user_list = array();
+ if (is_a($res, 'PEAR_Error'))
+ return false;
+ while ($val = $res->fetchRow()) {
+ $user_list[] = $val;
+ }
+ return $user_list;
+ }
+
+ // The getUsersForClient obtains all active and inactive users in a group that are relevant to a client.
+ static function getUsersForClient() {
+ global $user;
+ $mdb2 = getConnection();
+
+ $group_id = $user->getGroup();
+ $org_id = $user->org_id;
+
+ $sql = "select u.id, u.name from tt_user_project_binds upb".
+ " inner join tt_client_project_binds cpb on (upb.project_id = cpb.project_id and cpb.client_id = $user->client_id)".
+ " inner join tt_users u on (u.id = upb.user_id and u.group_id = $group_id and u.org_id = $org_id)".
+ " where (u.status = 1 or u.status = 0)".
+ " group by u.id".
+ " order by upper(u.name)";
+ $res = $mdb2->query($sql);
+ $user_list = array();
+ if (is_a($res, 'PEAR_Error'))
+ return false;
+ while ($val = $res->fetchRow()) {
+ $user_list[] = $val;
+ }
return $user_list;
}
+
+ // The getRecentInvoices returns an array of recent invoices (max 3) for a client.
+ static function getRecentInvoices($client_id) {
+ global $user;
+ $mdb2 = getConnection();
+
+ $group_id = $user->getGroup();
+ $org_id = $user->org_id;
+
+ $sql = "select i.id, i.name from tt_invoices i".
+ " left join tt_clients c on (c.id = i.client_id)".
+ " where i.group_id = $group_id and i.org_id = $org_id and i.status = 1 and c.id = $client_id".
+ " order by i.id desc limit 3";
+ $res = $mdb2->query($sql);
+ $result = array();
+ if (!is_a($res, 'PEAR_Error')) {
+ $dt = new DateAndTime(DB_DATEFORMAT);
+ while ($val = $res->fetchRow()) {
+ $result[] = $val;
+ }
+ }
+ return $result;
+ }
}