array( 'display_title' => $lang['field'], 'title_column' => 'title', 'get_data_function' => 'get_resource_type_field', 'get_data_function_params' => array($table_reference), ), 'user' => array( 'display_title' => $lang['user'], 'title_column' => 'fullname', 'get_data_function' => 'get_user', 'get_data_function_params' => array($table_reference), ), 'resource' => array( 'display_title' => "resource", 'title_column' => 'field' . $view_title_field, 'get_data_function' => 'get_resource_data', 'get_data_function_params' => array($table_reference), ), ); // TODO: over time, these can be put under tables_data once we can use the referenced information (ie. if there is a function to do so - see examples above) $no_reference_data_tables = ps_array( ' SELECT DISTINCT remote_table AS "value" FROM activity_log WHERE remote_table IS NOT NULL AND remote_table <> "" ', array(), "" ); if (!checkperm('a') || $requesteduser == $actasuser && $requesteduser != 0) { $log_tables_where_statements = array( 'activity_log' => "`activity_log`.`user`='{$actasuser}' AND ", 'resource_log' => "`resource_log`.`user`='{$actasuser}' AND ", 'collection_log' => "`collection_log`.`user`='{$actasuser}' AND ", ); } else { // Admins see all user activity by default $log_tables_where_statements = array( 'activity_log' => "TRUE AND ", 'resource_log' => "TRUE AND ", 'collection_log' => "TRUE AND ", ); } // Add date restriction $curmonth = date('m'); $curyear = date('Y'); $logmonth = getval("logmonth", ($log_search != "" ? "" : $curmonth), true); $logyear = getval("logyear", ($log_search != "" ? "" : $curyear), true); // Add filtering if not searching if ($logmonth != 0 || $logyear != 0) { $logmonth = (int)$logmonth; $logyear = (int)$logyear; $monthstart = $logmonth == 0 ? 1 : $logmonth; $monthend = $logmonth == 0 ? 12 : $logmonth; $datevals = " BETWEEN CAST('$logyear-$monthstart-01' AS DATETIME) AND CAST( CONCAT( LAST_DAY('$logyear-$monthend-01'),' 23:59:59') AS DATETIME) "; $log_tables_where_statements['activity_log'] .= "(logged " . $datevals . ") AND "; $log_tables_where_statements['resource_log'] .= "(date " . $datevals . ") AND "; $log_tables_where_statements['collection_log'] .= "(date " . $datevals . ") AND "; } // Paging functionality $url = generateURL( "{$baseurl_short}pages/admin/admin_system_log.php", array( 'log_search' => $log_search, 'backurl' => $backurl, 'actasuser' => $requesteduser, 'table' => $table, 'table_reference' => $table_reference, 'logmonth' => $logmonth, 'logyear' => $logyear, ) ); $offset = (int) getval('offset', 0, true); $per_page = (int) getval('per_page_list', $default_perpage_list, true); $all_records = get_activity_log($log_search, null, null, $log_tables_where_statements, $table, $table_reference, true); $totalpages = ceil($all_records / $per_page); $curpage = floor($offset / $per_page) + 1; $jumpcount = 0; // End of paging functionality include "../../include/header.php"; ?>
0 && array_key_exists($table, $tables_data)) { $table_data = $tables_data[$table]; $table_reference_data = call_user_func_array($table_data['get_data_function'], $table_data['get_data_function_params']); if ($table_reference_data !== false) { $title .= " - {$table_data['display_title']}: {$table_reference_data[$table_data['title_column']]}"; } } // Breadcrumbs if (strpos($backurl, 'pages/admin/admin_resource_type_fields.php') !== false) { $links_trail = [ ['title' => $lang["systemsetup"], 'href' => "{$baseurl_short}pages/admin/admin_home.php"], ['title' => $lang["admin_resource_type_fields"], 'href' => $backurl], ]; } elseif (strpos($backurl, "pages/team/team_user.php") !== false) { // Arrived from Manage users page $links_trail = array( array( 'title' => $lang["teamcentre"], 'href' => $baseurl_short . "pages/team/team_home.php", 'menu' => true ), array( 'title' => $lang["manageusers"], 'href' => $backurl ) ); } elseif (strpos($backurl, "pages/team/team_user_edit.php") !== false) { // Arrived from edit user page. This may also have a separate backurl $back2url = $baseurl_short . "pages/team/team_user.php"; $url_parse = parse_url($backurl); if (isset($url_parse['query'])) { parse_str($url_parse['query'], $url2_qs); if (strpos($url2_qs["backurl"] ?? "", "pages/team/team_user.php") !== false) { $back2url = $url2_qs["backurl"]; } } $links_trail = array( array( 'title' => $lang["teamcentre"], 'href' => $baseurl_short . "pages/team/team_home.php", 'menu' => true ), array( 'title' => $lang["manageusers"], 'href' => $back2url, ), array( 'title' => $lang["edituser"], 'href' => $backurl ) ); } else { $links_trail = [ ['title' => $lang["systemsetup"], 'href' => "{$baseurl_short}pages/admin/admin_home.php"] ]; } $links_trail[] = array( 'title' => escape($title) ); ?>

"> ">

$log_search, 'backurl' => $backurl, 'actasuser' => $requesteduser ) ); ?>
 
$ref"; break; } } ?>
$record['access_key'],'username' => $record['user']))) ? "" : escape((string) $record['notes']); ?> " title="View resource" onclick="return ModalLoad(this,true);">