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"; ?>
$record['access_key'],'username' => $record['user']))) ? "" : escape((string) $record['notes']); ?> | " title="View resource" onclick="return ModalLoad(this,true);"> | $ref"; break; } } ?>