/**
* Closes a task
* @param integer $task_id
* @param integer $reason
* @param string $comment
* @param bool $mark100
* @access public
* @return bool
* @version 1.0
*/
function close_task($task_id, $reason, $comment, $mark100 = true)
{
global $db, $user, $fs;
$task = Flyspray::GetTaskDetails($task_id);
if (!$user->can_close_task($task)) {
return false;
}
if ($task['is_closed']) {
return false;
}
$db->x->autoExecute('{tasks}', array('date_closed' => time(), 'closed_by' => $user->id, 'closure_comment' => $comment, 'is_closed' => 1, 'resolution_reason' => $reason, 'last_edited_time' => time(), 'last_edited_by' => $user->id, 'percent_complete' => (bool) $mark100 * 100), MDB2_AUTOQUERY_UPDATE, sprintf('task_id = %d', $task_id));
if ($mark100) {
Flyspray::logEvent($task_id, 3, 100, $task['percent_complete'], 'percent_complete');
}
// [RED] Update last changed date
$db->x->execParam('UPDATE {redundant} SET last_changed_time = ?,
last_changed_by_real_name = ?, last_changed_by_user_name = ?,
closed_by_real_name = ?, closed_by_user_name = ?
WHERE task_id = ?', array(time(), $user->infos['real_name'], $user->infos['user_name'], $user->infos['real_name'], $user->infos['user_name'], $task_id));
Notifications::send($task_id, ADDRESS_TASK, NOTIFY_TASK_CLOSED);
Flyspray::logEvent($task_id, 2, $reason, $comment);
// If there's an admin request related to this, close it
$db->x->autoExecute('{admin_requests}', array('resolved_by' => $user->id, 'time_resolved' => time()), MDB2_AUTOQUERY_UPDATE, sprintf('task_id = %d AND request_type = 1', $task_id));
// duplicate
if ($reason == $fs->prefs['resolution_dupe']) {
$look = array('FS#', 'bug ');
foreach ($fs->projects as $project) {
$look[] = preg_quote($project['project_prefix'] . '#', '/');
}
preg_match("/\\b(" . implode('|', $look) . ")(\\d+)\\b/", $comment, $dupe_of);
if (count($dupe_of) >= 2) {
$existing = $db->x->getOne('SELECT count(*) FROM {related} WHERE this_task = ? AND related_task = ? AND related_type = 1', null, array($task_id, $dupe_of[1]));
if (!$existing) {
$db->x->autoExecute('{related}', array('this_task' => $task_id, 'related_task' => $dupe_of[1], 'related_type' => 1));
}
Backend::add_vote($task['opened_by'], $dupe_of[1]);
}
}
return true;
}
/**
* Closes a task
* @param integer $task_id
* @param integer $reason
* @param string $comment
* @param bool $mark100
* @access public
* @return bool
* @version 1.0
*/
public static function close_task($task_id, $reason, $comment, $mark100 = true)
{
global $db, $notify, $user, $proj;
$task = Flyspray::GetTaskDetails($task_id);
if (!$user->can_close_task($task)) {
return false;
}
if ($task['is_closed']) {
return false;
}
$db->Query('UPDATE {tasks}
SET date_closed = ?, closed_by = ?, closure_comment = ?,
is_closed = 1, resolution_reason = ?, last_edited_time = ?,
last_edited_by = ?
WHERE task_id = ?', array(time(), $user->id, $comment, $reason, time(), $user->id, $task_id));
if ($mark100) {
$db->Query('UPDATE {tasks} SET percent_complete = 100 WHERE task_id = ?', array($task_id));
Flyspray::logEvent($task_id, 3, 100, $task['percent_complete'], 'percent_complete');
}
$notify->Create(NOTIFY_TASK_CLOSED, $task_id, null, null, NOTIFY_BOTH, $proj->prefs['lang_code']);
Flyspray::logEvent($task_id, 2, $reason, $comment);
// If there's an admin request related to this, close it
$db->Query('UPDATE {admin_requests}
SET resolved_by = ?, time_resolved = ?
WHERE task_id = ? AND request_type = ?', array($user->id, time(), $task_id, 1));
// duplicate
if ($reason == 6) {
preg_match("/\\b(?:FS#|bug )(\\d+)\\b/", $comment, $dupe_of);
if (count($dupe_of) >= 2) {
$existing = $db->Query('SELECT * FROM {related} WHERE this_task = ? AND related_task = ? AND is_duplicate = 1', array($task_id, $dupe_of[1]));
if ($existing && $db->CountRows($existing) == 0) {
$db->Query('INSERT INTO {related} (this_task, related_task, is_duplicate) VALUES(?, ?, 1)', array($task_id, $dupe_of[1]));
}
Backend::add_vote($task['opened_by'], $dupe_of[1]);
}
}
return true;
}
if ($task['project_id'] != $parent['project_id']) {
Flyspray::show_error(L('musthavesameproject'));
break;
}
//finally looks like all the checks are valid so update the supertask_id for the current task
$db->Query('UPDATE {tasks}
SET supertask_id = ?
WHERE task_id = ?', array(Post::val('supertask_id'), Post::val('task_id')));
// If task already had a different parent, the log removal too
if ($task['supertask_id']) {
Flyspray::logEvent($task['supertask_id'], 33, Post::val('task_id'));
Flyspray::logEvent(Post::val('task_id'), 35, $task['supertask_id']);
}
// Log the events in the task history
Flyspray::logEvent(Post::val('supertask_id'), 32, Post::val('task_id'));
Flyspray::logEvent(Post::val('task_id'), 34, Post::val('supertask_id'));
// set success message
$_SESSION['SUCCESS'] = L('supertaskmodified');
break;
case 'notifications.remove':
if (!isset($_POST['message_id'])) {
// Flyspray::show_error(L('summaryanddetails'));
break;
}
if (!is_array($_POST['message_id'])) {
// Flyspray::show_error(L('summaryanddetails'));
break;
}
if (!count($_POST['message_id'])) {
// Nothing to do.
break;
$_SESSION['SUCCESS'] = L('taskmadeprivatemsg');
break;
// ##################
// making a task public
// ##################
// ##################
// making a task public
// ##################
case 'makepublic':
if (!$user->perms('manage_project')) {
break;
}
$db->Query('UPDATE {tasks}
SET mark_private = 0
WHERE task_id = ?', array($task['task_id']));
Flyspray::logEvent($task['task_id'], 3, 0, 1, 'mark_private');
$_SESSION['SUCCESS'] = L('taskmadepublicmsg');
break;
// ##################
// Adding a vote for a task
// ##################
// ##################
// Adding a vote for a task
// ##################
case 'details.addvote':
if (Backend::add_vote($user->id, $task['task_id'])) {
$_SESSION['SUCCESS'] = L('voterecorded');
} else {
Flyspray::show_error(L('votefailed'));
break;
}
break;
}
//Check that the supertask_id is a numeric value
if (!is_integer((int) Post::val('supertask_id'))) {
Flyspray::show_error(L('invalidsupertaskid'));
break;
}
// check that supertask_id is a valid task id
$sql = $db->Query('SELECT COUNT(*) FROM {tasks}
WHERE task_id = ' . Post::val("supertask_id") . ';');
if (!$db->fetchOne($sql)) {
Flyspray::show_error(L('invalidsupertaskid'));
break;
}
// Log the event in the task history
Flyspray::logEvent(Get::val('task_id'), 34, Get::val('subtaskid'));
//finally looks like all the checks are valid so update the supertask_id for the current task
$db->Query('UPDATE {tasks}
SET supertask_id = ?
WHERE task_id = ?', array(Post::val('supertask_id'), Post::val('task_id')));
// set success message
$_SESSION['SUCCESS'] = L('supertaskmodified');
break;
case 'task.bulkupdate':
if (Post::val('updateselectedtasks') == "true") {
//process quick actions
switch (Post::val('bulk_quick_action')) {
case 'bulk_take_ownership':
Backend::assign_to_me(Post::val('user_id'), Post::val('ids'));
break;
case 'bulk_start_watching':
if ($db->countRows($res) < 1) {
header(':', true, 403);
die(L('invalidvalue'));
}
break;
case 'closedby_version':
$res = $db->Query('SELECT * FROM {list_version} WHERE (project_id=0 OR project_id=?) AND show_in_list=1 AND version_id=? AND version_tense=3', array($task['project_id'], $value));
if ($db->countRows($res) < 1) {
header(':', true, 403);
die(L('invalidvalue'));
}
break;
default:
header(':', true, 403);
die(L('invalidField'));
break;
}
$oldvalue = $task[Post::val('name')];
$time = time();
$sql = $db->Query("UPDATE {tasks} SET " . Post::val('name') . " = ?,last_edited_time = ? WHERE task_id = ?", array($value, $time, Post::val('task_id')));
# load $proj again of task with correct project_id for getting active notification types in notification class
$proj = new Project($task['project_id']);
// Log the changed field in task history
Flyspray::logEvent($task['task_id'], 3, $value, $oldvalue, Post::val('name'), $time);
// Get the details of the task we just updated to generate the changed-task message
$new_details_full = Flyspray::GetTaskDetails($task['task_id']);
$changes = Flyspray::compare_tasks($task, $new_details_full);
if (count($changes) > 0) {
$notify = new Notifications();
$notify->Create(NOTIFY_TASK_CHANGED, $task['task_id'], $changes, null, NOTIFY_BOTH, $proj->prefs['lang_code']);
}
function action_requestclose($task)
{
global $proj, $user, $db;
if (Post::val('action') == 'requestclose') {
Flyspray::AdminRequest(1, $proj->id, $task['task_id'], $user->id, Post::val('reason_given'));
Flyspray::logEvent($task['task_id'], 20, Post::val('reason_given'));
} else {
Flyspray::AdminRequest(2, $proj->id, $task['task_id'], $user->id, Post::val('reason_given'));
Flyspray::logEvent($task['task_id'], 21, Post::val('reason_given'));
Backend::add_notification($user->id, $task['task_id']);
}
// Now, get the project managers' details for this project
$pms = $db->x->GetCol('SELECT u.user_id
FROM {users} u
LEFT JOIN {users_in_groups} uig ON u.user_id = uig.user_id
LEFT JOIN {groups} g ON uig.group_id = g.group_id
WHERE g.project_id = ? AND g.manage_project = 1', null, $proj->id);
if (count($pms)) {
Notifications::send($pms, ADDRESS_USER, NOTIFY_PM_REQUEST, array('task_id' => $task['task_id']));
}
return array(SUBMIT_OK, L('adminrequestmade'));
}
