- // The getTeams function returns an array of all active teams on the server.
- static function getTeams() {
- $result = array();
- $mdb2 = getConnection();
-
- $sql = "select id, name, lang, timestamp from tt_teams where status = 1 order by id desc";
- $res = $mdb2->query($sql);
- $result = array();
- if (!is_a($res, 'PEAR_Error')) {
- while ($val = $res->fetchRow()) {
- $val['date'] = substr($val['timestamp'], 0, 10); // Strip the time.
- $result[] = $val;
- }
- return $result;
- }
- return false;
- }
-
- // The markDeleted function marks the team and everything in it as deleted.
- static function markDeleted($team_id) {
-
- // Iterate through team users and mark them as deleted.
- $users = ttTeamHelper::getAllUsers($team_id);
- foreach ($users as $one_user) {
- if (!ttUserHelper::markDeleted($one_user['id'])) return false;
- }
-
- // Mark tasks deleted.
- if (!ttTeamHelper::markTasksDeleted($team_id)) return false;
-
- $mdb2 = getConnection();
-
- // Mark projects deleted.
- $sql = "update tt_projects set status = NULL where team_id = $team_id";
- $affected = $mdb2->exec($sql);
- if (is_a($affected, 'PEAR_Error')) return false;
-
- // Mark clients deleted.
- $sql = "update tt_clients set status = NULL where team_id = $team_id";
- $affected = $mdb2->exec($sql);
- if (is_a($affected, 'PEAR_Error')) return false;
-
- // Mark custom fields deleted.
- $sql = "update tt_custom_fields set status = NULL where team_id = $team_id";
- $affected = $mdb2->exec($sql);
- if (is_a($affected, 'PEAR_Error')) return false;
-
- // Mark team deleted.
- $sql = "update tt_teams set status = NULL where id = $team_id";
- $affected = $mdb2->exec($sql);
- if (is_a($affected, 'PEAR_Error')) return false;
-
- return true;
- }
-
- // The getTeamDetails function returns team details.
- static function getTeamDetails($team_id) {
- $result = array();
- $mdb2 = getConnection();
-
- $role_manager = ROLE_MANAGER;
- $sql = "select t.name as team_name, u.id as manager_id, u.name as manager_name, u.login as manager_login, u.email as manager_email
- from tt_teams t
- inner join tt_users u on (u.team_id = t.id and u.role = $role_manager)
- where t.id = $team_id";
-
- $res = $mdb2->query($sql);
- if (!is_a($res, 'PEAR_Error')) {
- $val = $res->fetchRow();
- return $val;
- }
-
- return false;
- }
-
- // The insert function creates a new team.
- static function insert($fields) {
-
- $mdb2 = getConnection();
-
- // Start with team name and currency.
- $columns = 'name, currency';
- $values = $mdb2->quote(trim($fields['name'])).', '.$mdb2->quote(trim($fields['currency']));
-
- if ($fields['decimal_mark']) {
- $columns .= ', decimal_mark';
- $values .= ', '.$mdb2->quote($fields['decimal_mark']);
- }
-
- $lang = $fields['lang'];
- if (!$lang) {
- global $i18n;
- $lang = $i18n->lang;
- }
- $columns .= ', lang';
- $values .= ', '.$mdb2->quote($lang);
-
- if ($fields['date_format'] || defined('DATE_FORMAT_DEFAULT')) {
- $date_format = $fields['date_format'] ? $fields['date_format'] : DATE_FORMAT_DEFAULT;
- $columns .= ', date_format';
- $values .= ', '.$mdb2->quote($date_format);
- }
-
- if ($fields['time_format'] || defined('TIME_FORMAT_DEFAULT')) {
- $time_format = $fields['time_format'] ? $fields['time_format'] : TIME_FORMAT_DEFAULT;
- $columns .= ', time_format';
- $values .= ', '.$mdb2->quote($time_format);
- }
-
- if ($fields['week_start'] || defined('WEEK_START_DEFAULT')) {
- $week_start = $fields['week_start'] ? $fields['week_start'] : WEEK_START_DEFAULT;
- $columns .= ', week_start';
- $values .= ', '.(int)$week_start;
- }
-
- if ($fields['tracking_mode']) {
- $columns .= ', tracking_mode';
- $values .= ', '.(int)$fields['tracking_mode'];
- }
-
- if ($fields['project_required']) {
- $columns .= ', project_required';
- $values .= ', '.(int)$fields['project_required'];
- }
-
- if ($fields['task_required']) {
- $columns .= ', task_required';
- $values .= ', '.(int)$fields['task_required'];
- }
-
- if ($fields['record_type']) {
- $columns .= ', record_type';
- $values .= ', '.(int)$fields['record_type'];
- }
-
- if ($fields['bcc_email']) {
- $columns .= ', bcc_email';
- $values .= ', '.$mdb2->quote($fields['bcc_email']);
- }
-
- if ($fields['plugins']) {
- $columns .= ', plugins';
- $values .= ', '.$mdb2->quote($fields['plugins']);
- }
-
- if ($fields['lock_spec']) {
- $columns .= ', lock_spec';
- $values .= ', '.$mdb2->quote($fields['lock_spec']);
- }
-
- if ($fields['workday_minutes']) {
- $columns .= ', workday_minutes';
- $values .= ', '.(int)$fields['workday_minutes'];
- }
-
- if ($fields['config']) {
- $columns .= ', config';
- $values .= ', '.$mdb2->quote($fields['config']);
- }
-
- $sql = "insert into tt_teams ($columns) values($values)";
- $affected = $mdb2->exec($sql);
-
- if (!is_a($affected, 'PEAR_Error')) {
- $team_id = $mdb2->lastInsertID('tt_teams', 'id');
- return $team_id;
- }
-
- return false;
- }
-
- // The update function updates team information.
- static function update($team_id, $fields)
- {