- 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();
-
- $lock_spec = $fields['lock_spec'];
- if ($lock_spec !== null) {
- $lockspec_f = ', lock_spec';
- $lockspec_v = ', ' . $mdb2->quote($lock_spec);
- } else {
- $lockspec_f = '';
- $lockspec_v = '';
- }
-
- if ($fields['lock_interval'] !== null) {
- $locktime_f = ', locktime';
- $locktime_v = ", " . (int)$fields['lock_interval'];
- } else {
- $locktime_f = '';
- $locktime_v = '';
- }
-
- $lang = $fields['lang'];
- if (!$lang) {
- global $i18n;
- $lang = $i18n->lang;
- }
-
- $decimal_mark = $fields['decimal_mark'];
- if ($decimal_mark !== null) {
- $decimal_mark_f = ', decimal_mark';
- $decimal_mark_v = ', ' . $mdb2->quote($decimal_mark);
- } else {
- $decimal_mark_f = '';
- $decimal_mark_v = '';
- }
-
- $date_format = $fields['date_format'];
- if ($date_format !== null) {
- $date_format_f = ', date_format';
- $date_format_v = ', ' . $mdb2->quote($date_format);
- } elseif (defined('DATE_FORMAT_DEFAULT')) {
- $date_format_f = ', date_format';
- $date_format_v = ', ' . $mdb2->quote(DATE_FORMAT_DEFAULT);
- } else {
- $date_format_f = '';
- $date_format_v = '';
- }
-
- $time_format = $fields['time_format'];
- if ($time_format !== null) {
- $time_format_f = ', time_format';
- $time_format_v = ', ' . $mdb2->quote($time_format);
- } elseif (defined('TIME_FORMAT_DEFAULT')) {
- $time_format_f = ', time_format';
- $time_format_v = ', ' . $mdb2->quote(TIME_FORMAT_DEFAULT);
- } else {
- $time_format_f = '';
- $time_format_v = '';
- }
-
- $week_start = $fields['week_start'];
- if ($week_start !== null) {
- $week_start_f = ', week_start';
- $week_start_v = ', ' . (int)$week_start;
- } elseif (defined('WEEK_START_DEFAULT')) {
- $week_start_f = ', week_start';
- $week_start_v = ', ' . (int)WEEK_START_DEFAULT;
- } else {
- $week_start_f = '';
- $week_start_v = '';
- }
-
- $plugins = $fields['plugins'];
- if ($plugins !== null) {
- $plugins_f = ', plugins';
- $plugins_v = ', ' . $mdb2->quote($plugins);
- } else {
- $plugins_f = '';
- $plugins_v = '';
- }