/**
* @param int $issue_id
* @return array
* @access protected
*/
public function getFileList($issue_id)
{
AuthCookie::setProjectCookie(Issue::getProjectID($issue_id));
$res = Attachment::getList($issue_id);
if (empty($res)) {
throw new RemoteApiException('No files could be found');
}
return $res;
}
$show_releases = 0;
}
// get if categories should be displayed
$cats = Category::getList($prj_id);
if (count($cats) > 0) {
$show_category = 1;
} else {
$show_category = 0;
}
$cookie = Auth::getCookieInfo(APP_PROJECT_COOKIE);
if (!empty($auto_switched_from)) {
$tpl->assign(array("project_auto_switched" => 1, "old_project" => Project::getName($auto_switched_from)));
}
$setup = Setup::load();
$tpl->assign("allow_unassigned_issues", @$setup["allow_unassigned_issues"]);
$tpl->assign(array('next_issue' => @$sides['next'], 'previous_issue' => @$sides['previous'], 'subscribers' => Notification::getSubscribers($issue_id), 'custom_fields' => Custom_Field::getListByIssue($prj_id, $issue_id), 'files' => Attachment::getList($issue_id), 'emails' => Support::getEmailsByIssue($issue_id), 'zones' => Date_API::getTimezoneList(), 'users' => Project::getUserAssocList($prj_id, 'active', User::getRoleID('Customer')), 'ema_id' => Email_Account::getEmailAccount(), 'max_attachment_size' => Attachment::getMaxAttachmentSize(), 'show_releases' => $show_releases, 'show_category' => $show_category, 'categories' => Category::getAssocList($prj_id), 'quarantine' => Issue::getQuarantineInfo($issue_id)));
if ($role_id != User::getRoleID('customer')) {
if (@$_REQUEST['show_all_drafts'] == 1) {
$show_all_drafts = true;
} else {
$show_all_drafts = false;
}
if (Workflow::hasWorkflowIntegration($prj_id)) {
$statuses = Workflow::getAllowedStatuses($prj_id, $issue_id);
// if currently selected release is not on list, go ahead and add it.
} else {
$statuses = Status::getAssocStatusList($prj_id);
}
if (!empty($details['iss_sta_id']) && empty($statuses[$details['iss_sta_id']])) {
$statuses[$details['iss_sta_id']] = Status::getStatusTitle($details['iss_sta_id']);
}
function getFileList($p)
{
$email = XML_RPC_decode($p->getParam(0));
$password = XML_RPC_decode($p->getParam(1));
$auth = authenticate($email, $password);
if (is_object($auth)) {
return $auth;
}
$issue_id = XML_RPC_decode($p->getParam(2));
createFakeCookie($email, Issue::getProjectID($issue_id));
$res = Attachment::getList($issue_id);
if (empty($res)) {
return new XML_RPC_Response(0, $XML_RPC_erruser + 1, "No files could be found");
} else {
return new XML_RPC_Response(XML_RPC_Encode($res));
}
}
/**
* @param int $issue_id
* @return array
* @access protected
*/
public function getFileList($issue_id)
{
self::createFakeCookie(false, Issue::getProjectID($issue_id));
$res = Attachment::getList($issue_id);
if (empty($res)) {
throw new RemoteApiException('No files could be found');
}
return $res;
}
$columns[1][] = array('title' => ev_gettext('Associated Issues'), 'field' => 'associated_issues');
if (!isset($issue_fields_display['expected_resolution']) || $issue_fields_display['expected_resolution'] != false) {
$columns[1][] = array('title' => ev_gettext('Expected Resolution Date'), 'field' => 'expected_resolution');
}
if (!isset($issue_fields_display['estimated_dev_time']) || $issue_fields_display['estimated_dev_time'] != false) {
$columns[1][] = array('title' => ev_gettext('Estimated Dev. Time'), 'data' => empty($details['iss_dev_time']) ? '' : $details['iss_dev_time'] . ' hours', 'field' => 'estimated_dev_time');
}
if ($role_id > User::getRoleID('Customer')) {
$columns[1][] = array('title' => ev_gettext('Duplicates'), 'field' => 'duplicates', 'title_bgcolor' => APP_INTERNAL_COLOR);
$columns[1][] = array('title' => ev_gettext('Authorized Repliers'), 'field' => 'authorized_repliers', 'title_bgcolor' => APP_INTERNAL_COLOR);
}
$groups = Group::getAssocList($prj_id);
if ($role_id > User::getRoleID('Customer') && count($groups) > 0) {
$columns[1][] = array('title' => ev_gettext('Group'), 'data' => isset($details['group']) ? $details['group']['grp_name'] : '', 'title_bgcolor' => APP_INTERNAL_COLOR);
}
$tpl->assign(array('next_issue' => @$sides['next'], 'previous_issue' => @$sides['previous'], 'subscribers' => Notification::getSubscribers($issue_id), 'custom_fields' => Custom_Field::getListByIssue($prj_id, $issue_id), 'files' => Attachment::getList($issue_id), 'emails' => Support::getEmailsByIssue($issue_id), 'zones' => Date_Helper::getTimezoneList(), 'users' => Project::getUserAssocList($prj_id, 'active', User::getRoleID('Customer')), 'ema_id' => Email_Account::getEmailAccount(), 'max_attachment_size' => Attachment::getMaxAttachmentSize(), 'quarantine' => Issue::getQuarantineInfo($issue_id), 'grid' => $columns, 'can_update' => Issue::canUpdate($issue_id, $usr_id), 'enabled_partners' => Partner::getPartnersByProject($prj_id), 'partners' => Partner::getPartnersByIssue($issue_id), 'issue_access' => Access::getIssueAccessArray($issue_id, $usr_id), 'is_user_notified' => Notification::isUserNotified($issue_id, $usr_id)));
if ($role_id != User::getRoleID('customer')) {
if (@$_COOKIE['show_all_drafts'] == 1) {
$show_all_drafts = true;
} else {
$show_all_drafts = false;
}
if (Workflow::hasWorkflowIntegration($prj_id)) {
$statuses = Workflow::getAllowedStatuses($prj_id, $issue_id);
// if currently selected release is not on list, go ahead and add it.
} else {
$statuses = Status::getAssocStatusList($prj_id, false);
}
if (!empty($details['iss_sta_id']) && empty($statuses[$details['iss_sta_id']])) {
$statuses[$details['iss_sta_id']] = Status::getStatusTitle($details['iss_sta_id']);
}
/**
* Method used to send an email notification to users that want
* to be alerted when new issues are created in the system.
*
* @param integer $prj_id The project ID
* @param integer $issue_id The issue ID
* @param array $exclude_list The list of users NOT to notify.
* @return void
*/
public static function notifyNewIssue($prj_id, $issue_id, $exclude_list = array())
{
// get all users associated with this project
$stmt = "SELECT\n usr_id,\n usr_full_name,\n usr_email,\n pru_role,\n usr_customer_id,\n usr_customer_contact_id\n FROM\n {{%user}},\n {{%project_user}}\n WHERE\n pru_prj_id=? AND\n usr_id=pru_usr_id AND\n usr_status = 'active' AND\n pru_role > ?";
$params = array($prj_id, User::ROLE_CUSTOMER);
if (count($exclude_list) > 0) {
$stmt .= ' AND
usr_id NOT IN (' . DB_Helper::buildList($exclude_list) . ')';
$params = array_merge($params, $exclude_list);
}
$res = DB_Helper::getInstance()->getAll($stmt, $params);
$emails = array();
foreach ($res as $row) {
$subscriber = Mail_Helper::getFormattedName($row['usr_full_name'], $row['usr_email']);
// don't send these emails to customers
if ($row['pru_role'] == User::ROLE_CUSTOMER || !empty($row['usr_customer_id']) || !empty($row['usr_customer_contact_id'])) {
continue;
}
$prefs = Prefs::get($row['usr_id']);
if (!empty($prefs['receive_new_issue_email'][$prj_id]) && @$prefs['receive_new_issue_email'][$prj_id] && !in_array($subscriber, $emails)) {
$emails[] = $subscriber;
}
}
// get assignees
$stmt = "SELECT\n usr_id,\n usr_full_name,\n usr_email\n FROM\n {{%user}},\n {{%issue_user}}\n WHERE\n isu_iss_id=? AND\n usr_id=isu_usr_id AND\n usr_status = 'active'";
$res = DB_Helper::getInstance()->getAll($stmt, array($issue_id));
foreach ($res as $row) {
$subscriber = Mail_Helper::getFormattedName($row['usr_full_name'], $row['usr_email']);
$prefs = Prefs::get($row['usr_id']);
if (!empty($prefs['receive_assigned_email'][$prj_id]) && @$prefs['receive_assigned_email'][$prj_id] && !in_array($subscriber, $emails)) {
$emails[] = $subscriber;
}
}
// get any email addresses from products
$products = Product::getProductsByIssue($issue_id);
if (count($products) > 0) {
foreach ($products as $product) {
$emails[] = $product['pro_email'];
}
}
// get notification list members
$emails = array_merge($emails, self::getSubscribedNameEmails($issue_id));
// get any additional emails
$emails = array_merge($emails, Workflow::getAdditionalEmailAddresses($prj_id, $issue_id, 'new_issue'));
$data = Issue::getDetails($issue_id, true);
$data['attachments'] = Attachment::getList($issue_id);
// notify new issue to irc channel
$irc_notice = "New Issue #{$issue_id} (";
$quarantine = Issue::getQuarantineInfo($issue_id);
if (!empty($quarantine)) {
$irc_notice .= 'Quarantined; ';
}
$irc_notice .= 'Priority: ' . $data['pri_title'];
// also add information about the assignee, if any
$assignment = Issue::getAssignedUsers($issue_id);
if (count($assignment) > 0) {
$irc_notice .= '; Assignment: ' . implode(', ', $assignment);
}
if (!empty($data['iss_grp_id'])) {
$irc_notice .= '; Group: ' . Group::getName($data['iss_grp_id']);
}
$irc_notice .= '), ';
if (@isset($data['customer'])) {
$irc_notice .= $data['customer']['name'] . ', ';
}
$irc_notice .= $data['iss_summary'];
self::notifyIRC($prj_id, $irc_notice, $issue_id, false, false, 'new_issue');
$data['custom_fields'] = array();
// empty place holder so notifySubscribers will fill it in with appropriate data for the user
$subject = ev_gettext('New Issue');
// generate new Message-ID
$message_id = Mail_Helper::generateMessageID();
$headers = array('Message-ID' => $message_id);
self::notifySubscribers($issue_id, $emails, 'new_issue', $data, $subject, false, false, $headers);
}
/**
* Callback function to be used from template class.
*
* @param string $text The text to process
* @param integer $issue_id The ID of the issue from where attachment list is taken
* @return string the processed text.
*/
public function activateAttachmentLinks($text, $issue_id)
{
// build list of files to replace, so duplicate matches will always
// take last matching filename.
$files = array();
foreach (Attachment::getList($issue_id) as $attachment) {
foreach ($attachment['files'] as $file) {
// TRANSLATORS: %1: iaf_filename, %2: iaf_filesize
$title = ev_gettext('download file (%1$s - %2$s)', $file['iaf_filename'], $file['iaf_filesize']);
$link = sprintf('<a class="link" target="_blank" title="%s" href="download.php?cat=attachment&id=%d">%s</a>', htmlspecialchars($title), htmlspecialchars($file['iaf_id']), htmlspecialchars($file['iaf_filename']));
$files[$file['iaf_filename']] = $link;
}
}
foreach ($files as $file => $link) {
// we use attachment prefix, so we don't accidentally match already processed urls
$text = preg_replace('/attachment:?\\s*' . preg_quote($file, '/') . '\\b/', $link, $text);
}
return $text;
}
/**
* Method used to send an email notification to users that want
* to be alerted when new issues are created in the system.
*
* @access public
* @param integer $prj_id The project ID
* @param integer $issue_id The issue ID
* @param array $exclude_list The list of users NOT to notify.
* @return void
*/
function notifyNewIssue($prj_id, $issue_id, $exclude_list = array())
{
$prj_id = Misc::escapeInteger($prj_id);
$issue_id = Misc::escapeInteger($issue_id);
$exclude_list = Misc::escapeInteger($exclude_list);
// get all users associated with this project
$stmt = "SELECT\r\n usr_id,\r\n usr_full_name,\r\n usr_email,\r\n usr_preferences,\r\n pru_role,\r\n usr_customer_id,\r\n usr_customer_contact_id\r\n FROM\r\n " . ETEL_USER_TABLE . ",\r\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "project_user\r\n WHERE\r\n pru_prj_id={$prj_id} AND\r\n usr_id=pru_usr_id AND\r\n usr_status = 'active' AND\r\n pru_role > " . User::getRoleID("Customer");
if (count($exclude_list) > 0) {
$stmt .= " AND\r\n usr_id NOT IN (" . join(', ', $exclude_list) . ")";
}
$res = $GLOBALS["db_api"]->dbh->getAll($stmt, DB_FETCHMODE_ASSOC);
$emails = array();
for ($i = 0; $i < count($res); $i++) {
@($res[$i]['usr_preferences'] = unserialize($res[$i]['usr_preferences']));
$subscriber = Mail_API::getFormattedName($res[$i]['usr_full_name'], $res[$i]['usr_email']);
// don't send these emails to customers
if ($res[$i]['pru_role'] == User::getRoleID('Customer') || !empty($res[$i]['usr_customer_id']) || !empty($res[$i]['usr_customer_contact_id'])) {
continue;
}
if (!empty($res[$i]['usr_preferences']['receive_new_emails'][$prj_id]) && @$res[$i]['usr_preferences']['receive_new_emails'][$prj_id] && !in_array($subscriber, $emails)) {
$emails[] = $subscriber;
}
}
// get assignees
$stmt = "SELECT\r\n usr_id,\r\n usr_full_name,\r\n usr_email,\r\n usr_preferences\r\n FROM\r\n " . ETEL_USER_TABLE . ",\r\n " . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "issue_user\r\n WHERE\r\n isu_iss_id={$issue_id} AND\r\n usr_id=isu_usr_id AND\r\n usr_status = 'active'";
$res = $GLOBALS["db_api"]->dbh->getAll($stmt, DB_FETCHMODE_ASSOC);
for ($i = 0; $i < count($res); $i++) {
@($res[$i]['usr_preferences'] = unserialize($res[$i]['usr_preferences']));
$subscriber = Mail_API::getFormattedName($res[$i]['usr_full_name'], $res[$i]['usr_email']);
if (!empty($res[$i]['usr_preferences']['receive_assigned_emails'][$prj_id]) && @$res[$i]['usr_preferences']['receive_assigned_emails'][$prj_id] && !in_array($subscriber, $emails)) {
$emails[] = $subscriber;
}
}
// get any additional emails
$emails = array_merge($emails, Workflow::getAdditionalEmailAddresses($prj_id, $issue_id, 'new_issue'));
$data = Issue::getDetails($issue_id, true);
$data['attachments'] = Attachment::getList($issue_id);
// notify new issue to irc channel
$irc_notice = "New Issue #{$issue_id} (";
$quarantine = Issue::getQuarantineInfo($issue_id);
if (!empty($quarantine)) {
$irc_notice .= "Quarantined; ";
}
$irc_notice .= "Priority: " . $data['pri_title'];
// also add information about the assignee, if any
$assignment = Issue::getAssignedUsers($issue_id);
if (count($assignment) > 0) {
$irc_notice .= "; Assignment: " . implode(', ', $assignment);
}
if (!empty($data['iss_grp_id'])) {
$irc_notice .= "; Group: " . Group::getName($data['iss_grp_id']);
}
$irc_notice .= "), ";
if (@isset($data['customer_info'])) {
$irc_notice .= $data['customer_info']['customer_name'] . ", ";
}
$irc_notice .= $data['iss_summary'];
Notification::notifyIRC($prj_id, $irc_notice, $issue_id);
$data['custom_fields'] = array();
// empty place holder so notifySubscribers will fill it in with appropriate data for the user
$subject = 'New Issue';
$headers = array("Message-ID" => $data['iss_root_message_id']);
Notification::notifySubscribers($issue_id, $emails, 'new_issue', $data, $subject, false, false, $headers);
}
