/**
* Method used to get all open issues and group them by assignee or reporter.
*
* @param integer $prj_id The project ID
* @param integer $cutoff_days The number of days to use as a cutoff period
* @param bool $group_by_reporter
* @return array The list of issues
*/
public static function getOpenIssuesByUser($prj_id, $cutoff_days, $group_by_reporter = false)
{
$prj_id = (int) $prj_id;
$cutoff_days = (int) $cutoff_days;
$ts = time();
$ts_diff = $cutoff_days * Date_Helper::DAY;
$stmt = "SELECT\n assignee.usr_full_name as assignee_name,\n reporter.usr_full_name as reporter_name,\n iss_id,\n iss_summary,\n sta_title,\n iss_sta_id,\n iss_created_date,\n iss_updated_date,\n iss_last_response_date,\n sta_color\n FROM\n (\n {{%issue}},\n {{%issue_user}},\n {{%user}} as assignee,\n {{%user}} as reporter\n )\n LEFT JOIN\n {{%status}}\n ON\n iss_sta_id=sta_id\n WHERE\n sta_is_closed=0 AND\n iss_prj_id=? AND\n iss_id=isu_iss_id AND\n isu_usr_id=assignee.usr_id AND\n iss_usr_id=reporter.usr_id AND\n UNIX_TIMESTAMP(iss_created_date) < (UNIX_TIMESTAMP() - ?)\n ORDER BY\n";
if ($group_by_reporter) {
$stmt .= 'reporter.usr_full_name';
} else {
$stmt .= 'assignee.usr_full_name';
}
try {
$res = DB_Helper::getInstance()->getAll($stmt, array($prj_id, $ts_diff));
} catch (DbException $e) {
return '';
}
Time_Tracking::fillTimeSpentByIssues($res);
$issues = array();
foreach ($res as &$row) {
if (empty($row['iss_updated_date'])) {
$row['iss_updated_date'] = $row['iss_created_date'];
}
if (empty($row['iss_last_response_date'])) {
$row['iss_last_response_date'] = $row['iss_created_date'];
}
if ($group_by_reporter) {
$name = $row['reporter_name'];
} else {
$name = $row['assignee_name'];
}
$update_date_ts = Date_Helper::getUnixTimestamp($row['iss_updated_date'], Date_Helper::getDefaultTimezone());
$last_response_ts = Date_Helper::getUnixTimestamp($row['iss_last_response_date'], Date_Helper::getDefaultTimezone());
$issues[$name][$row['iss_id']] = array('iss_summary' => $row['iss_summary'], 'sta_title' => $row['sta_title'], 'iss_created_date' => Date_Helper::getFormattedDate($row['iss_created_date']), 'time_spent' => Misc::getFormattedTime($row['time_spent']), 'status_color' => $row['sta_color'], 'last_update' => Date_Helper::getFormattedDateDiff($ts, $update_date_ts), 'last_email_response' => Date_Helper::getFormattedDateDiff($ts, $last_response_ts));
}
return $issues;
}
/**
* Returns the status of a quarantine.
*
* @param integer $issue_id The issue ID
* @return integer Indicates what the current state of quarantine is.
*/
public static function getQuarantineInfo($issue_id)
{
$stmt = 'SELECT
iqu_status,
iqu_expiration
FROM
{{%issue_quarantine}}
WHERE
iqu_iss_id = ? AND
(iqu_expiration > ? OR
iqu_expiration IS NULL)';
try {
$res = DB_Helper::getInstance()->getRow($stmt, array($issue_id, Date_Helper::getCurrentDateGMT()));
} catch (DbException $e) {
return array();
}
if (!empty($res['iqu_expiration'])) {
$expiration_ts = Date_Helper::getUnixTimestamp($res['iqu_expiration'], Date_Helper::getDefaultTimezone());
$res['time_till_expiration'] = Date_Helper::getFormattedDateDiff($expiration_ts, time());
}
return $res;
}
