/**
* revert changes of a person
*
* Notes:
* - This function is only available of people with RIGHT_PROJECT_EDIT.
* - This will only effect changes to fields.
* - Following changes will not be reverted:
* - Creation of new items (Tasks, Topis, Efforts, Projects, etc.)
* - Task-assignments
* - Uploading of files
*
* person - id of person who did the changes
* data - date to with revert changes
* delete_history (Default off) - Reverting can't be undone! The person's modification are lost forever!
* This can be useful on massive changes to avoid sending huge
* notification mails.
*/
function personRevertChanges()
{
global $PH;
global $auth;
### check rights ###
if (!$auth->cur_user->user_rights & RIGHT_PROJECT_EDIT) {
$PH->abortWarning("You require the right to edit projects.");
}
### get person ###
$person_id = getOnePassedId('person', 'people_*');
if (!($person = Person::getVisibleById($person_id))) {
$PH->abortWarning(sprintf(__("invalid Person #%s"), $person_id));
return;
}
$page = new Page();
$page->tabs['admin'] = array('target' => "index.php?go=systemInfo", 'title' => __('Admin', 'top navigation tab'), 'bg' => "misc");
$page->cur_tab = 'admin';
$page->crumbs[] = new NaviCrumb(array('target_id' => 'systemInfo'));
$page->title = __("Reverting user changes");
$page->type = __("Admin");
#$page->title_minor=get('go');
echo new PageHeader();
echo new PageContentOpen();
$block = new PageBlock(array('title' => __('Overview'), 'id' => 'overview'));
$block->render_blockStart();
echo "<div class=text>";
echo "<ul>";
### get changes of person ###
$count_reverted_fields = 0;
$changes = ItemChange::getItemChanges(array('person' => $person_id, 'order_by' => 'id DESC'));
foreach ($changes as $c) {
if (!($project_item = DbProjectItem::getObjectById($c->item))) {
#print "unable to get item %s" % $c->item;
} else {
### Only revert changes, if item has not be editted by other person
if ($project_item->modified_by == $person_id) {
$field_name = $c->field;
echo "<li>" . "<strong>" . asHtml($project_item->name) . "." . asHtml($field_name) . "</strong>" . " '" . asHtml($project_item->{$field_name}) . "' = '" . asHtml($c->value_old) . "'" . "</li>";
$count_reverted_fields++;
if ($field_name == 'state') {
if ($project_item->state == -1 && $c->value_old == 1) {
$project_item->deleted_by = "0";
$project_item->deleted = "0000-00-00 00-00-00";
}
}
$project_item->{$field_name} = $c->value_old;
$project_item->update(array($field_name, 'deleted_by', 'deleted'), false, false);
} else {
echo "<li>" . sprintf(__("Skipped recently editted item #%s: <b>%s<b>"), $project_item->id, asHtml($project_item->name)) . "</li>";
}
$c->deleteFull();
}
}
echo "</ul>";
echo "<p>" . sprintf(__("Reverted all changes (%s) of user %s"), $count_reverted_fields, asHtml($person->nickname)) . "</p>";
echo "<p>" . __("newly created items by this user remain unaffected.") . "</p>";
echo "</div>";
$block->render_blockEnd();
### close page
echo new PageContentClose();
echo new PageHtmlEnd();
}
/**
* save field value of an item which has been edited inplace
* and return formatted html code.
*
* If only a chapter has been edited, number defined in "chapter"
*/
function itemSaveField()
{
header("Content-type: text/html; charset=utf-8");
### disable page caching ###
header("Expires: -1");
header("Cache-Control: post-check=0, pre-check=0");
header("Pragma: no-cache");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
$value = get('value');
if (is_null($value)) {
return;
}
if (!($item_id = get('item'))) {
print "Failure";
return;
}
global $g_wiki_project;
if (!($item = DbProjectItem::getEditableById($item_id))) {
print "Failure";
return;
}
if (!($object = DbProjectItem::getObjectById($item_id))) {
print "Failure";
return;
}
if ($item->type == ITEM_PROJECT) {
if (!($project = Project::getVisibleById($item->id))) {
print "Failure getting project";
return;
}
} else {
if (!($project = Project::getVisibleById($item->project))) {
print "Failure getting project";
return;
}
}
$g_wiki_project = $project;
$field_name = 'description';
if (get('field')) {
$field_name = asCleanString(get('field'));
}
if (!isset($object->fields[$field_name])) {
return NULL;
}
require_once confGet('DIR_STREBER') . 'render/render_wiki.inc.php';
$chapter = intVal(get('chapter'));
### replace complete field ###
if (is_null($chapter)) {
$object->{$field_name} = $value;
} else {
require_once confGet('DIR_STREBER') . 'render/render_wiki.inc.php';
/**
* split originial wiki block into chapters
* start with headline and belonging text
*/
$org = $object->{$field_name};
if ($object->type == ITEM_TASK) {
global $g_wiki_task;
$g_wiki_task = $object;
}
$parts = getWikiChapters($org);
### replace last line return (added by textarea) ###
if (!preg_match("/\n\$/", $value)) {
$value .= "\n";
}
#$value= str_replace("\\'", "'", $value);
#$value= str_replace('\\"', "\"", $value);
$parts[$chapter] = $value;
$new_wiki_text = implode('', $parts);
$object->{$field_name} = $new_wiki_text;
}
### update
$object->update(array($field_name));
### mark parent of comment as changes
if ($item->type == ITEM_COMMENT) {
if ($parent_task = Task::getById($object->task)) {
print "calling now changed by user";
$parent_task->nowChangedByUser();
}
}
print wiki2purehtml($object->{$field_name});
$item->nowChangedByUser();
}
private function addUntouchedMonitoredItems()
{
$unchanged_headline_html = '';
$unchanged_headline_txt = '';
$unchanged_body_html = '';
$unchanged_body_plaintext = '';
$monitored_items_unchanged = ItemPerson::getAll(array('is_bookmark' => 1, 'notify_if_unchanged_min' => NOTIFY_1DAY, 'person' => $this->recipient->id));
if (!$monitored_items_unchanged) {
return;
}
foreach ($monitored_items_unchanged as $miu) {
## reminder period ##
$period = '';
switch ($miu->notify_if_unchanged) {
case NOTIFY_1DAY:
$period = 24 * 60 * 60;
break;
case NOTIFY_2DAYS:
$period = 2 * 24 * 60 * 60;
break;
case NOTIFY_3DAYS:
$period = 3 * 24 * 60 * 60;
break;
case NOTIFY_4DAYS:
$period = 4 * 24 * 60 * 60;
break;
case NOTIFY_5DAYS:
$period = 5 * 24 * 60 * 60;
break;
case NOTIFY_1WEEK:
$period = 7 * 24 * 60 * 60;
break;
case NOTIFY_2WEEKS:
$period = 2 * 7 * 24 * 60 * 60;
break;
case NOTIFY_3WEEKS:
$period = 3 * 7 * 24 * 60 * 60;
break;
case NOTIFY_1MONTH:
$period = 4 * 7 * 24 * 60 * 60;
break;
case NOTIFY_2MONTH:
$period = 2 * 4 * 7 * 24 * 60 * 60;
break;
}
$date = $miu->notify_date;
if ($pi = DbProjectItem::getVisibleById($miu->item)) {
$mod_date = $pi->modified;
if ($date != '0000-00-00 00:00:00') {
$date = strToGMTime($date) + $period;
$date = date('Y-m-d H:i:s', $date);
if ($date >= $mod_date && strToGMTime($date) <= time()) {
$diff = strToGMTime($date) - strToGMTime($mod_date);
if ($diff >= $period) {
### diff in days ###
$information_count++;
$days = round((time() - strToGMTime($miu->notify_date)) / 60 / 60 / 24);
$object = DbProjectItem::getObjectById($pi->id);
$unchanged_body_html .= '<li>' . sprintf(__("%s (not touched since %s day(s))"), asHtml($object->name), $days) . '</li>';
$unchanged_body_plaintext .= '- ' . sprintf(__("%s (not touched since %s day(s))"), $object->name, $days) . '\\n\\r';
}
}
}
}
}
if ($unchanged_body_html) {
$this->information_count++;
$this->body_html .= "<h3>" . __('Unchanged monitored items:', 'notification') . "</h3>" . "<ul>" . $unchanged_body_html . "</ul>";
$this->body_plaintext .= "\n\r" . __('Unchanged monitored items:', 'notification') . "\n\r" . $unchanged_body_plaintext;
}
}
/**
* renders a comparision between two versions of an item @ingroup pages
*/
function itemViewDiff()
{
global $PH;
global $auth;
require_once confGet('DIR_STREBER') . 'render/render_wiki.inc.php';
### get task ####
$item_id = get('item');
if (!($item = DbProjectItem::getObjectById($item_id))) {
$PH->abortWarning("invalid item-id", ERROR_FATAL);
}
if (!($project = Project::getVisibleById($item->project))) {
$PH->abortWarning("this item has an invalid project id", ERROR_DATASTRUCTURE);
}
require_once confGet('DIR_STREBER') . "db/db_itemchange.inc.php";
$versions = ItemVersion::getFromItem($item);
$date1 = get('date1');
$date2 = get('date2');
if (!$date1) {
#if(count($versions) > 1) {
# if($auth->cur_user->last_logout < $versions[count($versions)-2]->date_to)
# {
# $date1 = $auth->cur_user->last_logout;
# }
# else {
# $date1 = $versions[count($versions)-2]->date_from;
# }
#}
#else {
foreach (array_reverse($versions) as $v) {
if ($v->author == $auth->cur_user->id) {
$date1 = $v->date_from;
break;
}
}
#}
}
if (!$date2) {
$date2 = getGMTString();
}
$page = new Page();
$page->cur_tab = 'projects';
$page->crumbs = build_project_crumbs($project);
$page->options = build_projView_options($project);
$page->title = $item->name;
$page->title_minor = __('changes');
$page->add_function(new PageFunction(array('target' => 'itemView', 'params' => array('item' => $item->id), 'icon' => 'edit', 'name' => __('View item'))));
### render title ###
echo new PageHeader();
echo new PageContentOpen();
if ($date1 > $date2) {
new FeedbackMessage(__("date1 should be smaller than date2. Swapped"));
$t = $date1;
$date1 = $date2;
$date2 = $t;
}
if (count($versions) == 1) {
echo __("item has not been edited history");
} else {
$old_version = NULL;
$version_right = NULL;
$version_left = $versions[0];
foreach ($versions as $v) {
if ($v->date_from <= $date1) {
$version_left = $v;
}
if ($v->date_from >= $date2) {
if (isset($version_right)) {
if ($version_right->date_from > $v->date_from) {
$version_right = $v;
}
} else {
$version_right = $v;
}
}
}
if (!isset($version_right)) {
$version_right = $versions[count($versions) - 1];
}
$options_left = array();
$options_right = array();
### list versions left ###
for ($i = 0; $i < count($versions) - 1; $i++) {
$v = $versions[$i];
if ($person = Person::getVisibleById($v->author)) {
$author = $person->name;
} else {
$author = __('unknown');
}
if ($v->version_number == $version_left->version_number) {
$str_link = $PH->getUrl('itemViewDiff', array('item' => $item->id, 'date1' => $versions[$i]->date_from, 'date2' => $versions[$i]->date_to));
$name = ' v.' . $v->version_number . ' -- ' . $author . " -- " . $v->date_from;
$options_left[] = "<option selected=1 value='" . $str_link . "'>" . $name . "</option>";
} else {
if ($v->version_number > $version_left->version_number) {
if ($v->version_number < $version_right->version_number) {
$str_link = $PH->getUrl('itemViewDiff', array('item' => $item->id, 'date1' => $versions[$i]->date_from, 'date2' => $versions[$i]->date_to));
$name = '> v.' . $v->version_number . ' -- ' . $author . " -- " . renderDate($v->date_from);
} else {
$str_link = $PH->getUrl('itemViewDiff', array('item' => $item->id, 'date1' => $versions[$i]->date_from, 'date2' => $version_right->date_to));
$name = '>> v.' . $v->version_number . ' -- ' . $author . " -- " . renderDate($v->date_from);
}
$options_left[] = "<option value='" . $str_link . "'>" . $name . "</option>";
} else {
$str_link = $PH->getUrl('itemViewDiff', array('item' => $item->id, 'date1' => $versions[$i]->date_from, 'date2' => $version_right->date_from));
$name = '< v.' . $v->version_number . ' -- ' . $author . " -- " . renderDate($v->date_from);
$options_left[] = "<option value='" . $str_link . "'>" . $name . "</option>";
}
}
}
### list versions right ###
for ($i = 1; $i < count($versions); $i++) {
$v = $versions[$i];
if ($person = Person::getVisibleById($v->author)) {
$author = $person->name;
} else {
$author = __('unknown');
}
if ($v->version_number == $version_right->version_number) {
$str_link = $PH->getUrl('itemViewDiff', array('item' => $item->id, 'date1' => $versions[$i]->date_from, 'date2' => $versions[$i]->date_to));
$name = ' v.' . $v->version_number . ' -- ' . $author . " -- " . $v->date_from;
$options_right[] = "<option selected=1 value='" . $str_link . "'>" . $name . "</option>";
} else {
if ($v->version_number > $version_right->version_number) {
$str_link = $PH->getUrl('itemViewDiff', array('item' => $item->id, 'date1' => $version_left->date_from, 'date2' => $versions[$i]->date_from));
$name = '> v.' . $v->version_number . ' -- ' . $author . ' -- ' . renderDate($v->date_from);
$options_right[] = "<option value='" . $str_link . "'>" . $name . "</option>";
} else {
if ($v->version_number > $version_left->version_number) {
$str_link = $PH->getUrl('itemViewDiff', array('item' => $item->id, 'date1' => $version_left->date_from, 'date2' => $versions[$i]->date_from));
$name = '< v.' . $v->version_number . ' -- ' . $author . " -- " . renderDate($v->date_from);
} else {
$str_link = $PH->getUrl('itemViewDiff', array('item' => $item->id, 'date1' => $versions[$i]->date_from, 'date2' => $versions[$i]->date_to));
$name = '<< v.' . $v->version_number . ' -- ' . $author . ' -- ' . renderDate($v->date_from);
}
$options_right[] = "<option value='" . $str_link . "'>" . $name . "</option>";
}
}
}
### prev ###
if ($version_left->version_number > 1) {
$link_prev = $PH->getLink('itemViewDiff', '<< ' . __('prev change'), array('item' => $item->id, 'date1' => $versions[$version_left->version_number - 2]->date_from, 'date2' => $versions[$version_left->version_number - 2]->date_to), NULL, true);
} else {
$link_prev = '';
}
### next ###
if ($version_right->version_number < count($versions)) {
$link_next = $PH->getLink('itemViewDiff', __('next') . '>>', array('item' => $item->id, 'date1' => $versions[$version_right->version_number - 1]->date_from, 'date2' => $versions[$version_right->version_number - 1]->date_to), NULL, true);
} else {
$link_next = '';
}
### summary ###
$link_summary = $PH->getLink('itemViewDiff', __('summary'), array('item' => $item->id, 'date1' => $auth->cur_user->last_logout, 'date2' => getGMTString()), NULL, true);
echo "<div class=diff>";
echo "<table class=nav><tr>";
echo "<td class=older>" . "<select onChange='location.href=this.options[this.selectedIndex].value'>" . join(array_reverse($options_left)) . "</select>" . '<br><b class=doclear></b>' . $link_prev . "</td>";
echo "<td class=newer>" . "<select onChange='location.href=this.options[this.selectedIndex].value'>" . join(array_reverse($options_right)) . "</select>" . '<br><b class=doclear></b>' . $link_next . $link_summary . "</td>";
echo "</table>";
#if(!$date2 || !$date1) {
# echo sprintf(__("Item did not exists at %s"), renderTime($date2));
#}
if ($old_version == $version_right) {
echo sprintf(__('no changes between %s and %s'), renderTime($date1), renderTime($date2));
}
### collect changes ###
$old_field_values = array();
$new_field_values = array();
foreach ($versions as $v) {
if ($v->version_number <= $version_left->version_number) {
foreach ($v->values as $name => $value) {
$old_field_values[$name] = $value;
}
}
if ($v->version_number >= $version_left->version_number && $v->version_number < $version_right->version_number) {
foreach ($v->values_next as $name => $value) {
$new_field_values[$name] = $value;
}
}
}
foreach ($new_field_values as $field_name => $value) {
echo "<h2>{$field_name}</h2>";
$old_value = isset($old_field_values[$field_name]) ? $old_field_values[$field_name] : "";
$new_value = isset($new_field_values[$field_name]) ? $new_field_values[$field_name] : '';
$field_type = $item->fields[$field_name]->type;
if ($field_type == 'FieldText') {
echo render_changes($old_value, $new_value);
} else {
if ($field_type == 'FieldOption') {
if ($field_name == 'status') {
global $g_status_names;
$old_value = isset($g_status_names[$old_value]) ? $g_status_names[$old_value] : __('undefined');
$new_value = isset($g_status_names[$new_value]) ? $g_status_names[$new_value] : __('undefined');
} else {
if ($field_name == 'label') {
if ($project = Project::getVisibleById($item->project)) {
$labels = explode(",", $project->labels);
$old_value = isset($labels[$old_value - 1]) ? $labels[$old_value - 1] : __('undefined');
$new_value = isset($labels[$new_value - 1]) ? $labels[$new_value - 1] : __('undefined');
}
}
}
echo render_changes($old_value, $new_value);
} else {
if ($field_type == 'FieldInternal') {
if ($field_name == 'parent_item') {
if ($task_parent_old = Task::getVisibleById($old_value)) {
$ar = array();
foreach ($task_parent_old->getFolder() as $f) {
$ar[] = $f->name;
}
$ar[] = $task_parent_old->name;
$old_value = join($ar, " > ");
}
if ($task_parent_new = Task::getVisibleById($new_value)) {
$ar = array();
foreach ($task_parent_new->getFolder() as $f) {
$ar[] = $f->name;
}
$ar[] = $task_parent_new->name;
$new_value = join($ar, " > ");
}
} else {
if ($field_name == 'state') {
$old_value = $old_value == -1 ? __('deleted') : __('ok');
$new_value = $new_value == -1 ? __('deleted') : __('ok');
} else {
if ($field_name == 'pub_level') {
global $g_pub_level_names;
$old_value = isset($g_pub_level_names[$old_value]) ? $g_pub_level_names[$old_value] : __('undefined');
$new_value = isset($g_pub_level_names[$new_value]) ? $g_pub_level_names[$new_value] : __('undefined');
}
}
}
echo render_changes($old_value, $new_value);
} else {
if ($field_type == 'FieldPercentage') {
echo render_changes($old_value, $new_value);
} else {
if ($field_type == 'FieldInt') {
echo render_changes($old_value, $new_value);
} else {
if ($field_type == 'FieldString') {
echo render_changes($old_value, $new_value);
} else {
if ($field_type == 'FieldDate') {
echo render_changes(renderDate($old_value), renderDate($new_value));
} else {
if ($field_type == 'FieldDatetime') {
echo render_changes(renderTimestamp($old_value), renderTimestamp($new_value));
}
}
}
}
}
}
}
}
}
}
echo "</div>";
echo new PageContentClose();
echo new PageHtmlEnd();
}
