', WT_I18N::translate('Pending changes'), '
';
switch ($action) {
case 'undo':
$gedcom_id=WT_DB::prepare("SELECT gedcom_id FROM `##change` WHERE change_id=?")->execute(array($change_id))->fetchOne();
$xref =WT_DB::prepare("SELECT xref FROM `##change` WHERE change_id=?")->execute(array($change_id))->fetchOne();
// Undo a change, and subsequent changes to the same record
WT_DB::prepare(
"UPDATE `##change`".
" SET status = 'rejected'".
" WHERE status = 'pending'".
" AND gedcom_id = ?".
" AND xref = ?".
" AND change_id >= ?"
)->execute(array($gedcom_id, $xref, $change_id));
break;
case 'accept':
$gedcom_id=WT_DB::prepare("SELECT gedcom_id FROM `##change` WHERE change_id=?")->execute(array($change_id))->fetchOne();
$xref =WT_DB::prepare("SELECT xref FROM `##change` WHERE change_id=?")->execute(array($change_id))->fetchOne();
// Accept a change, and all previous changes to the same record
$changes=WT_DB::prepare(
"SELECT change_id, gedcom_id, gedcom_name, xref, old_gedcom, new_gedcom".
" FROM `##change` c".
" JOIN `##gedcom` g USING (gedcom_id)".
" WHERE c.status = 'pending'".
" AND gedcom_id = ?".
" AND xref = ?".
" AND change_id <= ?".
" ORDER BY change_id"
)->execute(array($gedcom_id, $xref, $change_id))->fetchAll();
foreach ($changes as $change) {
if (empty($change->new_gedcom)) {
// delete
update_record($change->old_gedcom, $ged_id, true);
} else {
// add/update
update_record($change->new_gedcom, $ged_id, false);
}
WT_DB::prepare("UPDATE `##change` SET status='accepted' WHERE change_id=?")->execute(array($change->change_id));
AddToLog("Accepted change {$change->change_id} for {$change->xref} / {$change->gedcom_name} into database", 'edit');
}
break;
case 'undoall':
WT_DB::prepare(
"UPDATE `##change`".
" SET status='rejected'".
" WHERE status='pending' AND gedcom_id=?"
)->execute(array(get_id_from_gedcom($ged)));
break;
case 'acceptall':
$changes=WT_DB::prepare(
"SELECT change_id, gedcom_id, gedcom_name, xref, old_gedcom, new_gedcom".
" FROM `##change` c".
" JOIN `##gedcom` g USING (gedcom_id)".
" WHERE c.status='pending' AND gedcom_id=?".
" ORDER BY change_id"
)->execute(array(get_id_from_gedcom($ged)))->fetchAll();
foreach ($changes as $change) {
if (empty($change->new_gedcom)) {
// delete
update_record($change->old_gedcom, $ged_id, true);
} else {
// add/update
update_record($change->new_gedcom, $ged_id, false);
}
WT_DB::prepare("UPDATE `##change` SET status='accepted' WHERE change_id=?")->execute(array($change->change_id));
AddToLog("Accepted change {$change->change_id} for {$change->xref} / {$change->gedcom_name} into database", 'edit');
}
break;
}
$changed_gedcoms=WT_DB::prepare(
"SELECT g.gedcom_name".
" FROM `##change` c".
" JOIN `##gedcom` g USING (gedcom_id)".
" WHERE c.status='pending'".
" GROUP BY g.gedcom_name"
)->fetchOneColumn();
if ($changed_gedcoms) {
$changes=WT_DB::prepare(
"SELECT c.*, u.user_name, u.real_name, g.gedcom_name, IF(new_gedcom='', old_gedcom, new_gedcom) AS gedcom".
" FROM `##change` c".
" JOIN `##user` u USING (user_id)".
" JOIN `##gedcom` g USING (gedcom_id)".
" WHERE c.status='pending'".
" ORDER BY gedcom_id, c.xref, c.change_id"
)->fetchAll();
$output = '
';
$prev_xref=null;
$prev_gedcom_id=null;
foreach ($changes as $change) {
if ($change->xref!=$prev_xref || $change->gedcom_id!=$prev_gedcom_id) {
if ($prev_xref) {
$output.='
';
}
$prev_xref =$change->xref;
$prev_gedcom_id=$change->gedcom_id;
$output.='
';
$GEDCOM=$change->gedcom_name;
$record=WT_GedcomRecord::getInstance($change->xref);
if (!$record) {
// When a record has been both added and deleted, then
// neither the original nor latest version will exist.
// This prevents us from displaying it...
// This generates a record of some sorts from the last-but-one
// version of the record.
$record=new WT_GedcomRecord($change->gedcom);
}
$output.=''.$record->getFullName().'
';
$output.=''.WT_I18N::translate('View the changes').' | ';
$output.="xref."');\">".WT_I18N::translate('View GEDCOM Record')." | ";
$output.="xref."');\">".WT_I18N::translate('Edit raw GEDCOM record').'
';
$output.='';
$output.=WT_I18N::translate('The following changes were made to this record:').' ';
$output.=' |
';
//-- Now for the global Action bar:
$output2 = '
';
// Row 1 column 1: title "Accept all"
$output2 .= '| '.WT_I18N::translate('Approve all changes').' | ';
// Row 1 column 2: title "Undo all"
$output2 .= ''.WT_I18N::translate('Undo all changes').' |
';
// Row 2 column 1: action "Accept all"
$output2 .= '';
$count = 0;
foreach ($changed_gedcoms as $gedcom_name) {
if ($count!=0) $output2.='
';
$output2 .= ''.$gedcom_name.' - '.WT_I18N::translate('Approve all changes').'';
$count ++;
}
$output2 .= ' | ';
// Row 2 column 2: action "Undo all"
$output2 .= '';
$count = 0;
foreach ($changed_gedcoms as $gedcom_name) {
if ($count!=0) {
$output2.='
';
}
$output2 .= '$gedcom_name - ".WT_I18N::translate('Undo all changes').'';
$count++;
}
$output2 .= ' |
';
echo
$output2, $output, $output2,
'
', WT_I18N::translate('Close Window'), '
';
} else {
// No pending changes - refresh the parent window and close this one
$controller->addInlineJavascript('closePopupAndReloadParent();');
}
echo '