$mdb2 = getConnection();
$result = array();
- $sql = "select c.id, c.cron_spec, c.email, fr.name from tt_cron c
+ $sql = "select c.id, c.cron_spec, c.email, c.report_condition, fr.name from tt_cron c
left join tt_fav_reports fr on (fr.id = c.report_id)
- where c.team_id = $team_id and c.status is not null";
+ where c.team_id = $team_id and c.status = 1 and fr.status = 1";
$res = $mdb2->query($sql);
$result = array();
if (!is_a($res, 'PEAR_Error')) {
$time_format_part = '';
$week_start_part = '';
$tracking_mode_part = '';
- $task_required_part = ' , task_required = '.$mdb2->quote($fields['task_required']);
+ $task_required_part = ' , task_required = '.intval($fields['task_required']);
$record_type_part = '';
$uncompleted_indicators_part = '';
+ $bcc_email_part = '';
$plugins_part = '';
$lock_spec_part = '';
$workday_hours_part = '';
if (isset($fields['tracking_mode'])) $tracking_mode_part = ', tracking_mode = '.intval($fields['tracking_mode']);
if (isset($fields['record_type'])) $record_type_part = ', record_type = '.intval($fields['record_type']);
if (isset($fields['uncompleted_indicators'])) $uncompleted_indicators_part = ', uncompleted_indicators = '.intval($fields['uncompleted_indicators']);
+ if (!empty($fields['bcc_email'])) $bcc_email_part = ', bcc_email = '.$mdb2->quote($fields['bcc_email']);
if (isset($fields['plugins'])) $plugins_part = ', plugins = '.$mdb2->quote($fields['plugins']);
if (isset($fields['lock_spec'])) $lock_spec_part = ', lock_spec = '.$mdb2->quote($fields['lock_spec']);
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 $task_required_part $record_type_part
- $uncompleted_indicators_part $plugins_part $lock_spec_part $workday_hours_part where id = $team_id";
+ $uncompleted_indicators_part $bcc_email_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;
return true;
}
- // The getInactiveTeams is a maintenance function that returns an array of inactive team ids (max 25).
+ // The getInactiveTeams is a maintenance function that returns an array of inactive team ids (max 50).
static function getInactiveTeams() {
$inactive_teams = array();
$mdb2 = getConnection();
// Get all team ids for teams created or modified more than 1 year ago.
- $ts = date('Y-m-d', strtotime('-1 year'));
+ // $ts = date('Y-m-d', strtotime('-1 year'));
+ $ts = date('Y-m-d', strtotime('-4 month'));
$sql = "select id from tt_teams where timestamp < '$ts' order by id";
$res = $mdb2->query($sql);
$count++;
$inactive_teams[] = $team_id;
// Limit the array size for perfomance by allowing this operation on small chunks only.
- if ($count >= 100) break;
+ if ($count >= 50) break;
}
}
return $inactive_teams;