restrictAccess(Auth::isManager()) ->setPageTitle(WT_I18N::translate('Changes')); require WT_ROOT . 'includes/functions/functions_edit.php'; $earliest = WT_DB::prepare("SELECT DATE(MIN(change_time)) FROM `##change`")->execute(array())->fetchOne(); $latest = WT_DB::prepare("SELECT DATE(MAX(change_time)) FROM `##change`")->execute(array())->fetchOne(); // Filtering $action = WT_Filter::get('action'); $from = WT_Filter::get('from', '\d\d\d\d-\d\d-\d\d', $earliest); $to = WT_Filter::get('to', '\d\d\d\d-\d\d-\d\d', $latest); $type = WT_Filter::get('type', 'accepted|rejected|pending'); $oldged = WT_Filter::get('oldged'); $newged = WT_Filter::get('newged'); $xref = WT_Filter::get('xref', WT_REGEX_XREF); $user = WT_Filter::get('user'); $search = WT_Filter::get('search'); $search = isset($search['value']) ? $search['value'] : null; $statuses = array( '' => '', 'accepted' => /* I18N: the status of an edit accepted/rejected/pending */ WT_I18N::translate('accepted'), 'rejected' => /* I18N: the status of an edit accepted/rejected/pending */ WT_I18N::translate('rejected'), 'pending' => /* I18N: the status of an edit accepted/rejected/pending */ WT_I18N::translate('pending'), ); if (Auth::isAdmin()) { // Administrators can see all logs $gedc = WT_Filter::get('gedc'); } else { // Managers can only see logs relating to this gedcom $gedc = WT_GEDCOM; } $query = array(); $args = array(); if ($search) { $query[] = "(old_gedcom LIKE CONCAT('%', ?, '%') OR new_gedcom LIKE CONCAT('%', ?, '%'))"; $args [] = $search; $args [] = $search; } if ($from) { $query[] = 'change_time>=?'; $args [] = $from; } if ($to) { $query[] = 'change_timeexecute($args); break; case 'export': Zend_Session::writeClose(); header('Content-Type: text/csv'); header('Content-Disposition: attachment; filename="webtrees-changes.csv"'); $rows = WT_DB::prepare($SELECT1 . $WHERE . ' ORDER BY change_id')->execute($args)->fetchAll(); foreach ($rows as $row) { $row->old_gedcom = str_replace('"', '""', $row->old_gedcom); $row->old_gedcom = str_replace("\n", '""', $row->old_gedcom); $row->new_gedcom = str_replace('"', '""', $row->new_gedcom); $row->new_gedcom = str_replace("\n", '""', $row->new_gedcom); echo '"', $row->change_time, '",', '"', $row->status, '",', '"', $row->xref, '",', '', $row->old_gedcom, '",', '', $row->new_gedcom, '",', '"', str_replace('"', '""', $row->user_name), '",', '"', str_replace('"', '""', $row->gedcom_name), '"', "\n"; } return; case 'load_json': Zend_Session::writeClose(); $start = WT_Filter::getInteger('start'); $length = WT_Filter::getInteger('length'); $search = WT_Filter::get('search'); $search = $search['value']; Auth::user()->setPreference('admin_site_change_page_size', $length); if ($length > 0) { $LIMIT = " LIMIT " . $start . ',' . $length; } else { $LIMIT = ""; } $order = WT_Filter::getArray('order'); if ($order) { $ORDER_BY = ' ORDER BY '; foreach ($order as $key => $value) { if ($key > 0) { $ORDER_BY .= ','; } // Datatables numbers columns 0, 1, 2, ... // MySQL numbers columns 1, 2, 3, ... switch ($value['dir']) { case 'asc': if (WT_Filter::getInteger('iSortCol_' . $key) == 0) { $ORDER_BY .= 'change_id ASC '; // column 0 is "timestamp", using change_id gives the correct order for events in the same second } else { $ORDER_BY .= (1 + $value['column']) . ' ASC '; } break; case 'desc': if (WT_Filter::getInteger('iSortCol_' . $key) == 0) { $ORDER_BY .= 'change_id DESC '; } else { $ORDER_BY .= (1 + $value['column']) . ' DESC '; } break; } } } else { $ORDER_BY = 'ORDER BY 1 DESC'; } // This becomes a JSON list, not array, so need to fetch with numeric keys. $data = WT_DB::prepare($SELECT1 . $WHERE . $ORDER_BY . $LIMIT)->execute($args)->fetchAll(PDO::FETCH_NUM); foreach ($data as &$datum) { $datum[1] = WT_I18N::translate($datum[1]); $datum[2] = '' . $datum[2] . ''; $datum[3] = '

' . WT_Filter::escapeHtml($datum[3]) . '

'; $datum[4] = '

' . WT_Filter::escapeHtml($datum[4]) . '

'; $datum[5] = WT_Filter::escapeHtml($datum[5]); $datum[6] = WT_Filter::escapeHtml($datum[6]); } // Total filtered/unfiltered rows $recordsFiltered = WT_DB::prepare("SELECT FOUND_ROWS()")->fetchOne(); $recordsTotal = WT_DB::prepare($SELECT2 . $WHERE)->execute($args)->fetchOne(); header('Content-type: application/json'); // See http://www.datatables.net/usage/server-side echo json_encode(array( 'draw' => WT_Filter::getInteger('draw'), // Always an integer 'recordsTotal' => $recordsTotal, 'recordsFiltered' => $recordsFiltered, 'data' => $data )); return; } $controller ->pageHeader() ->addExternalJavascript(WT_JQUERY_DATATABLES_JS_URL) ->addExternalJavascript(WT_DATATABLES_BOOTSTRAP_JS_URL) ->addExternalJavascript(WT_MOMENT_JS_URL) ->addExternalJavascript(WT_BOOTSTRAP_DATETIMEPICKER_JS_URL) ->addInlineJavascript(' jQuery(".table-site-changes").dataTable( { processing: true, serverSide: true, ajax: "'.WT_SERVER_NAME . WT_SCRIPT_PATH . WT_SCRIPT_NAME . '?action=load_json&from=' . $from . '&to=' . $to . '&type=' . $type . '&oldged=' . rawurlencode($oldged) . '&newged=' . rawurlencode($newged) . '&xref=' . rawurlencode($xref) . '&user=' . rawurlencode($user) . '&gedc=' . rawurlencode($gedc) . '", ' . WT_I18N::datatablesI18N(array(10, 20, 50, 100, 500, 1000, -1)) . ', sorting: [[ 0, "desc" ]], pageLength: ' . Auth::user()->getPreference('admin_site_change_page_size', 10) . ', columns: [ /* Timestamp */ { }, /* Status */ { }, /* Record */ { }, /* Old data */ { sortable: false }, /* New data */ { sortable: false }, /* User */ { }, /* Family tree */ { } ] }); jQuery("#from,#to").parent("div").datetimepicker({ format: "YYYY-MM-DD", minDate: "' . $earliest . '", maxDate: "' . $latest . '", locale: "' . WT_LOCALE . '", icons: { time: "fa fa-clock-o", date: "fa fa-calendar", up: "fa fa-arrow-up", down: "fa fa-arrow-down", previous: "fa fa-arrow-left", next: "fa fa-arrow-right", today: "fa fa-trash-o", clear: "fa fa-trash-o" } }); '); $url = WT_SCRIPT_NAME . '?from=' . rawurlencode($from) . '&to=' . rawurlencode($to) . '&type=' . rawurlencode($type) . '&oldged=' . rawurlencode($oldged) . '&newged=' . rawurlencode($newged) . '&xref=' . rawurlencode($xref) . '&user=' . rawurlencode($user) . '&gedc=' . rawurlencode($gedc); $users_array = array(); foreach (User::all() as $tmp_user) { $users_array[$tmp_user->getUserName()] = $tmp_user->getUserName(); } ?>

getPageTitle(); ?>