while ($val = $res->fetchRow()) {
// Localize top manager role name, as it is not localized in db.
if ($val['rank'] == 512)
- $val['role_name'] = $i18n->getKey('role.top_manager.label');
+ $val['role_name'] = $i18n->get('role.top_manager.label');
$user_list[] = $val;
}
return false;
}
- // The getTeams function returns an array of all active teams on the server.
- static function getTeams() {
- $result = array();
- $mdb2 = getConnection();
-
- $sql = "select id, name, created, lang 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['created'], 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) {
// Get all team ids for teams created or modified more than 8 months ago.
// $ts = date('Y-m-d', strtotime('-1 year'));
- $ts = date('Y-m-d', strtotime('-8 month'));
- $sql = "select id from tt_teams where timestamp < '$ts' order by id";
+ $ts = $mdb2->quote(date('Y-m-d', strtotime('-8 month')));
+ $sql = "select id from tt_teams where created < $ts and (modified is null or modified < $ts) order by id";
$res = $mdb2->query($sql);
$count = 0;
$count = 0;
$ts = date('Y-m-d', strtotime('-2 years'));
- $sql = "select count(*) as cnt from tt_log where user_id in ($user_list) and timestamp > '$ts'";
+ $sql = "select count(*) as cnt from tt_log where user_id in ($user_list) and created > '$ts'";
$res = $mdb2->query($sql);
if (!is_a($res, 'PEAR_Error')) {
if ($val = $res->fetchRow()) {
// We will consider a team inactive if it has 5 or less time entries made more than 1 year ago.
$count_last_year = 0;
$ts = date('Y-m-d', strtotime('-1 year'));
- $sql = "select count(*) as cnt from tt_log where user_id in ($user_list) and timestamp > '$ts'";
+ $sql = "select count(*) as cnt from tt_log where user_id in ($user_list) and created > '$ts'";
$res = $mdb2->query($sql);
if (!is_a($res, 'PEAR_Error')) {
if ($val = $res->fetchRow()) {