public static function discussion($discussionID = null)
{
$discussion = Discussion::load($discussionID);
$title = $discussion->getTitle();
$projectID = $discussion->getProjectID();
return array_merge(self::discussions($projectID), self::oneCrumb($title, Url::discussion($discussionID)));
}
function formatEvent($event, $showProject = false)
{
switch ($event->getEventTypeID()) {
case 'create_user':
$formatted = sprintf("%s registered for %s.", formatUserLink($event->getUser1ID()), '<a href="' . Url::base() . '">' . PIPELINE_NAME . '</a>');
break;
case 'send_message':
$formatted = sprintf("%s sent a message to %s.", formatUserLink($event->getUser1ID()), formatUserLink($event->getUser2ID()));
break;
case 'accept_member_invitation':
$predicate = $showProject ? 'the project ' . formatProjectLink($event->getProjectID()) : "this project";
$formatted = sprintf("%s accepted %s's invitation to join %s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), formatUserLink($event->getUser2ID(), $event->getProjectID()), $predicate);
break;
case 'trust_member':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$formatted = sprintf("%s trusted %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), formatUserLink($event->getUser2ID(), $event->getProjectID()), $predicate);
break;
case 'untrust_member':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$formatted = sprintf("%s untrusted %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), formatUserLink($event->getUser2ID(), $event->getProjectID()), $predicate);
break;
case 'join_project':
$predicate = $showProject ? ' ' . formatProjectLink($event->getProjectID()) : '';
$formatted = sprintf("%s joined the project%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), $predicate);
break;
case 'leave_project':
$predicate = $showProject ? ' ' . formatProjectLink($event->getProjectID()) : '';
$formatted = sprintf("%s left the project%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), $predicate);
break;
case 'follow_project':
$predicate = $showProject ? ' ' . formatProjectLink($event->getProjectID()) : '';
$formatted = sprintf("%s followed the project%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), $predicate);
break;
case 'unfollow_project':
$predicate = $showProject ? ' ' . formatProjectLink($event->getProjectID()) : '';
$formatted = sprintf("%s unfollowed the project%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), $predicate);
break;
case 'ban_user':
$predicate = $showProject ? ' from the project ' . formatProjectLink($event->getProjectID()) : '';
$formatted = sprintf("%s banned %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), formatUserLink($event->getUser2ID(), $event->getProjectID()), $predicate);
break;
case 'unban_user':
$predicate = $showProject ? ' from the project ' . formatProjectLink($event->getProjectID()) : '';
$formatted = sprintf("%s unbanned %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), formatUserLink($event->getUser2ID(), $event->getProjectID()), $predicate);
break;
case 'create_project':
$predicate = $showProject ? 'the project ' . formatProjectLink($event->getProjectID()) : 'this project';
$formatted = sprintf("%s created %s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), formatProjectLink($event->getProjectID()));
break;
case 'edit_pitch':
$predicate = $showProject ? ' for the project ' . formatProjectLink($event->getProjectID()) : '';
$formatted = sprintf("%s edited the %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . Url::pitch($event->getProjectID()) . '">pitch</a>', $predicate);
break;
case 'edit_specs':
$predicate = $showProject ? ' for the project ' . formatProjectLink($event->getProjectID()) : '';
$formatted = sprintf("%s edited the %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . Url::specs($event->getProjectID()) . '">specs</a>', $predicate);
break;
case 'edit_rules':
$predicate = $showProject ? ' for the project ' . formatProjectLink($event->getProjectID()) : '';
$formatted = sprintf("%s edited the %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . Url::rules($event->getProjectID()) . '">rules</a>', $predicate);
break;
case 'edit_project_status':
$predicate = $showProject ? 'the project ' . formatProjectLink($event->getProjectID()) : 'this project';
$status = $event->getData2();
$formatted = sprintf("%s changed the %s of %s to “%s.”", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . Url::status($event->getProjectID()) . '">status</a>', $predicate, formatProjectStatus($status));
break;
case 'edit_project_deadline':
$deadline = $event->getData2();
if ($deadline != null) {
$predicate = $showProject ? 'the project ' . formatProjectLink($event->getProjectID()) : 'this project';
$formatted = sprintf("%s changed the %s of %s to %s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . Url::deadline($event->getProjectID()) . '">deadline</a>', $predicate, strftime("%a, %b %d, %Y", strtotime($deadline)));
} else {
$predicate = $showProject ? 'the project ' . formatProjectLink($event->getProjectID()) : 'this project';
$formatted = sprintf("%s removed the %s for %s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . Url::deadline($event->getProjectID()) . '">deadline</a>', $predicate);
}
break;
case 'create_discussion':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$discussion = Discussion::load($event->getItem1ID());
$title = $discussion->getTitle();
$url = Url::discussion($discussion->getID());
$formatted = sprintf("%s posted the discussion %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $url . '">' . $title . '</a>', $predicate);
break;
case 'lock_discussion':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$discussion = Discussion::load($event->getItem1ID());
$title = $discussion->getTitle();
$url = Url::discussion($discussion->getID());
$formatted = sprintf("%s locked the discussion %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $url . '">' . $title . '</a>', $predicate);
break;
case 'unlock_discussion':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$discussion = Discussion::load($event->getItem1ID());
$title = $discussion->getTitle();
$url = Url::discussion($discussion->getID());
$formatted = sprintf("%s unlocked the discussion %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $url . '">' . $title . '</a>', $predicate);
break;
case 'create_discussion_reply':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$discussion = Discussion::load($event->getItem2ID());
$title = $discussion->getTitle();
$url = Url::discussion($discussion->getID());
$formatted = sprintf("%s replied to the discussion %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $url . '">' . $title . '</a>', $predicate);
break;
case 'create_task':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$task = Task::load($event->getItem1ID());
$title = $task->getTitle();
$url = Url::task($task->getID());
$formatted = sprintf("%s created the task %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $url . '">' . $title . '</a>', $predicate);
break;
case 'edit_task_title':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$task = Task::load($event->getItem1ID());
$title = $task->getTitle();
$url = Url::task($task->getID());
$formatted = sprintf("%s edited the name of the task %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $url . '">' . $title . '</a>', $predicate);
break;
case 'edit_task_status':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$task = Task::load($event->getItem1ID());
$title = $task->getTitle();
$url = Url::task($task->getID());
$status = $event->getData2();
if ($status == Task::STATUS_CLOSED) {
$formatted = sprintf("%s closed the task %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $url . '">' . $title . '</a>', $predicate);
} else {
$formatted = sprintf("%s opened the task %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $url . '">' . $title . '</a>', $predicate);
}
break;
case 'edit_task_num_needed':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$task = Task::load($event->getItem1ID());
$title = $task->getTitle();
$url = Url::task($task->getID());
$numNeeded = $event->getData2();
if ($numNeeded != '') {
$formatted = sprintf("%s changed the # people needed for the task %s%s to %s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $url . '">' . $title . '</a>', $predicate, $numNeeded);
} else {
$formatted = sprintf("%s changed the # people needed for the task %s%s to ∞.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $url . '">' . $title . '</a>', $predicate, $numNeeded);
}
break;
case 'edit_task_leader':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$task = Task::load($event->getItem1ID());
$title = $task->getTitle();
$url = Url::task($task->getID());
$formatted = sprintf("%s changed the leader of the task %s%s to %s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $url . '">' . $title . '</a>', $predicate, formatUserLink($event->getUser2ID(), $event->getProjectID()));
break;
case 'edit_task_description':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$task = Task::load($event->getItem1ID());
$title = $task->getTitle();
$url = Url::task($task->getID());
$formatted = sprintf("%s edited the instructions for the task %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $url . '">' . $title . '</a>', $predicate);
break;
case 'edit_task_uploads':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$task = Task::load($event->getItem1ID());
$title = $task->getTitle();
$url = Url::task($task->getID());
$formatted = sprintf("%s edited the attached files for the task %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $url . '">' . $title . '</a>', $predicate);
break;
case 'edit_task_deadline':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$task = Task::load($event->getItem1ID());
$title = $task->getTitle();
$url = Url::task($task->getID());
$deadline = $event->getData2();
if ($deadline != '') {
$formatted = sprintf("%s changed the deadline for the task %s%s to %s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $url . '">' . $title . '</a>', $predicate, strftime("%a, %b %d, %Y", strtotime($deadline)));
} else {
$formatted = sprintf("%s removed the deadline for the task %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $url . '">' . $title . '</a>', $predicate);
}
break;
case 'accept_task':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$accepted = Accepted::load($event->getItem1ID());
//$acceptedUrl = Url::updates($accepted->getID());
$task = Task::load($event->getItem2ID());
$taskTitle = $task->getTitle();
$taskUrl = Url::task($task->getID());
$formatted = sprintf("%s joined the task %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $taskUrl . '">' . $taskTitle . '</a>', $predicate);
break;
case 'release_task':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$accepted = Accepted::load($event->getItem1ID());
//$acceptedUrl = Url::updates($accepted->getID());
$task = Task::load($event->getItem2ID());
$taskTitle = $task->getTitle();
$taskUrl = Url::task($task->getID());
$formatted = sprintf("%s left the task %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $taskUrl . '">' . $taskTitle . '</a>', $predicate);
break;
case 'edit_accepted_status':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$update = Update::load($event->getItem1ID());
$updateTitle = $update->getTitle();
$updateUrl = Url::update($update->getID());
$accepted = Accepted::load($event->getItem2ID());
$task = Task::load($event->getItem3ID());
$taskTitle = $task->getTitle();
$taskUrl = Url::task($task->getID());
$status = $event->getData2();
if ($status == Accepted::STATUS_FEEDBACK) {
$formatted = sprintf("%s is seeking feedback on his/her work on the task %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $taskUrl . '">' . $taskTitle . '</a>', $predicate);
} elseif ($status == Accepted::STATUS_COMPLETED) {
$formatted = sprintf("%s is finished working on the task %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $taskUrl . '">' . $taskTitle . '</a>', $predicate);
} elseif ($status == Accepted::STATUS_PROGRESS) {
$formatted = sprintf("%s is working on the task %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $taskUrl . '">' . $taskTitle . '</a>', $predicate);
}
break;
case 'create_task_comment':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$task = Task::load($event->getItem2ID());
$title = $task->getTitle();
$url = Url::task($task->getID());
$formatted = sprintf("%s commented on the task %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $url . '">' . $title . '</a>', $predicate);
break;
case 'create_task_comment_reply':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$task = Task::load($event->getItem3ID());
$title = $task->getTitle();
$url = Url::task($task->getID());
$formatted = sprintf("%s replied to a comment on the task %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $url . '">' . $title . '</a>', $predicate);
break;
case 'create_update_comment':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$update = Update::load($event->getItem2ID());
$title = $update->getTitle();
$url = Url::update($update->getID());
$formatted = sprintf("%s commented on the contribution %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $url . '">' . $title . '</a>', $predicate);
break;
case 'create_update_comment_reply':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$update = Update::load($event->getItem3ID());
$title = $update->getTitle();
$url = Url::update($update->getID());
$formatted = sprintf("%s replied to a comment on the contribution %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $url . '">' . $title . '</a>', $predicate);
break;
case 'create_update':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$update = Update::load($event->getItem1ID());
$updateTitle = $update->getTitle();
$updateUrl = Url::update($update->getID());
$formatted = sprintf("%s created the contribution %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $updateUrl . '">' . $updateTitle . '</a>', $predicate);
break;
case 'edit_update_title':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$update = Update::load($event->getItem1ID());
$updateTitle = $update->getTitle();
$updateUrl = Url::update($update->getID());
$formatted = sprintf("%s edited the title of the contribution %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $updateUrl . '">' . $updateTitle . '</a>', $predicate);
break;
case 'edit_update_message':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$update = Update::load($event->getItem1ID());
$updateTitle = $update->getTitle();
$updateUrl = Url::update($update->getID());
$formatted = sprintf("%s edited the contents of the contribution %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $updateUrl . '">' . $updateTitle . '</a>', $predicate);
break;
case 'edit_update_uploads':
$predicate = $showProject ? ' in the project ' . formatProjectLink($event->getProjectID()) : '';
$update = Update::load($event->getItem1ID());
$updateTitle = $update->getTitle();
$updateUrl = Url::update($update->getID());
$formatted = sprintf("%s edited the attached files for the contribution %s%s.", formatUserLink($event->getUser1ID(), $event->getProjectID()), '<a href="' . $updateUrl . '">' . $updateTitle . '</a>', $predicate);
break;
default:
$formatted = 'Event type "' . $event->getEventTypeID() . '" not found.';
}
return $formatted;
}
public static function getDiscussionEvents($discussionID = null, $limit = null)
{
if ($discussionID == null) {
return null;
}
$discussion = Discussion::load($discussionID);
$projectID = $discussion->getProjectID();
$query = "SELECT e.id AS id FROM " . self::DB_TABLE . " e";
$query .= " INNER JOIN " . EventType::DB_TABLE . " et ON ";
$query .= " e.event_type_id = et.id";
$query .= " WHERE e.project_id = " . $projectID;
$query .= " AND ( e.item_1_id = " . $discussionID . " AND e.event_type_id = 'create_discussion' )";
$query .= " OR ( e.item_1_id = " . $discussionID . " AND e.event_type_id = 'lock_discussion' )";
$query .= " OR ( e.item_1_id = " . $discussionID . " AND e.event_type_id = 'unlock_discussion' )";
$query .= " OR ( e.item_2_id = " . $discussionID . " AND e.event_type_id = 'create_discussion_reply' )";
$query .= " AND et.hidden = 0";
$query .= " ORDER BY e.date_created DESC";
if ($limit != null) {
$query .= " LIMIT " . $limit;
}
//echo $query;
$db = Db::instance();
$result = $db->lookup($query);
if (!mysql_num_rows($result)) {
return array();
}
$events = array();
while ($row = mysql_fetch_assoc($result)) {
$events[$row['id']] = self::load($row['id']);
}
return $events;
}
if ($project->getPrivate()) {
if (!Session::isAdmin() && !$project->isCreator(Session::getUserID())) {
if (!$project->isInvited(Session::getUserID()) && !$project->isMember(Session::getUserID()) && !$project->isTrusted(Session::getUserID()) || ProjectUser::isBanned(Session::getUserID(), $project->getID())) {
header('Location: ' . Url::error());
exit;
}
}
}
// page number, if any
if (empty($_GET['page'])) {
$page = 1;
} else {
$page = Filter::numeric($_GET['page']);
}
$discussionID = Filter::numeric($_GET['d']);
$discussion = Discussion::load($discussionID);
define('REPLIES_PER_PAGE', 10);
// how many replies per page
$totalNumReplies = count($discussion->getReplies());
// total # replies
$numPages = ceil($totalNumReplies / REPLIES_PER_PAGE);
// get # pages
if ($numPages != 0 && $page > $numPages) {
// invalid page number
header('Location: ' . Url::error());
exit;
}
$limit = ($page - 1) * REPLIES_PER_PAGE . ', ' . REPLIES_PER_PAGE;
$replies = $discussion->getReplies("ASC", $limit);
// get replies
$events = Event::getDiscussionEvents($discussionID, 10);
public static function discussion($discussionID = null)
{
if ($discussionID == null) {
return null;
}
$discussion = Discussion::load($discussionID);
return self::discussions($discussion->getProjectID()) . '/' . $discussionID;
}
