X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/7c7f99a838bd065066e0439bc1ea61014571b182..c51ac80bc7cbb4b2f77b75cd4120b62675aa7014:/WEB-INF/lib/ttTeamHelper.class.php diff --git a/WEB-INF/lib/ttTeamHelper.class.php b/WEB-INF/lib/ttTeamHelper.class.php index b27e04d1..2f0c7ccd 100644 --- a/WEB-INF/lib/ttTeamHelper.class.php +++ b/WEB-INF/lib/ttTeamHelper.class.php @@ -498,6 +498,23 @@ class ttTeamHelper { return false; } + // getPredefinedExpenses - obtains predefined expenses for team. + static function getPredefinedExpenses($team_id) { + $mdb2 = getConnection(); + + $result = array(); + $sql = "select id, name, cost from tt_predefined_expenses 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; + } + // getNotifications - obtains notification descriptions for team. static function getNotifications($team_id) { $mdb2 = getConnection(); @@ -517,7 +534,7 @@ class ttTeamHelper { return false; } - // getNotifications - obtains monthly quotas for team. + // getMonthlyQuotas - obtains monthly quotas for team. static function getMonthlyQuotas($team_id) { $mdb2 = getConnection(); @@ -737,9 +754,6 @@ class ttTeamHelper { // The update function updates team information. static function update($team_id, $fields) { - // We'll require team name to be always set. - if (!isset($fields['name']) || $fields['name'] == "") return false; - $mdb2 = getConnection(); $name_part = 'name = '.$mdb2->quote($fields['name']); $currency_part = ''; @@ -750,6 +764,7 @@ class ttTeamHelper { $time_format_part = ''; $week_start_part = ''; $tracking_mode_part = ''; + $task_required_part = ' , task_required = '.$mdb2->quote($fields['task_required']); $record_type_part = ''; $uncompleted_indicators_part = ''; $plugins_part = ''; @@ -771,7 +786,7 @@ class ttTeamHelper { if (isset($fields['workday_hours'])) $workday_hours_part = ', workday_hours = '.$mdb2->quote($fields['workday_hours']); $sql = "update tt_teams set $name_part $addr_part $currency_part $lang_part $decimal_mark_part - $date_format_part $time_format_part $week_start_part $tracking_mode_part $record_type_part + $date_format_part $time_format_part $week_start_part $tracking_mode_part $task_required_part $record_type_part $uncompleted_indicators_part $plugins_part $lock_spec_part $workday_hours_part where id = $team_id"; $affected = $mdb2->exec($sql); if (is_a($affected, 'PEAR_Error')) return false;