/** * 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; }