+ // The getUsers obtains all users in group for the purpose of export.
+ private function getUsers() {
+ global $user;
+ $mdb2 = getConnection();
+ $sql = "select u.*, r.rank from tt_users u left join tt_roles r on (u.role_id = r.id)".
+ " where u.group_id = $this->group_id and u.org_id = $user->org_id order by upper(u.name)"; // Note: deleted users are included.
+ $res = $mdb2->query($sql);
+ $result = array();
+ if (!is_a($res, 'PEAR_Error')) {
+ while ($val = $res->fetchRow()) {
+ $result[] = $val;
+ }
+ return $result;
+ }
+ return false;
+ }
+