PHP frs_logs_extract Examples

Example #1

File: access_logs_export.php Project: pombredanne/tuleap

function export_file_logs($project, $span, $who)
{
    $eol = "\n";
    $sql_file = filedownload_logs_extract($project, $span, $who);
    $col_list_file = array('time', 'user', 'email', 'title', 'local_time');
    $file_title = array('time' => $GLOBALS['Language']->getText('project_stats_source_code_access_utils', 'file_download'), 'user' => '', 'email' => '', 'title' => '', 'local_time' => '');
    $lbl_list_file = array('time' => $GLOBALS['Language']->getText('project_export_access_logs_export', 'time'), 'user' => $GLOBALS['Language']->getText('project_export_access_logs_export', 'user'), 'email' => $GLOBALS['Language']->getText('project_export_access_logs_export', 'email'), 'title' => $GLOBALS['Language']->getText('project_export_access_logs_export', 'file'), 'local_time' => $GLOBALS['Language']->getText('project_export_access_logs_export', 'local_time'));
    $result_file = db_query($sql_file);
    $rows_file = db_numrows($result_file);
    if ($result_file && $rows_file > 0) {
        // Build csv for files access logs
        echo build_csv_header($col_list_file, $file_title) . $eol;
        echo build_csv_header($col_list_file, $lbl_list_file) . $eol;
        while ($arr_file = db_fetch_array($result_file)) {
            prepare_access_logs_record($project->getGroupId(), $arr_file);
            echo build_csv_record($col_list_file, $arr_file) . $eol;
        }
        echo build_csv_header($col_list_file, array()) . $eol;
    }
    $eol = "\n";
    $sql = frs_logs_extract($project, $span, $who);
    $col_list = array('time', 'type', 'user', 'email', 'title', 'local_time');
    $title = array('time' => $GLOBALS['Language']->getText('project_stats_source_code_access_utils', 'frs_actions'), 'type' => '', 'user' => '', 'email' => '', 'title' => '', 'local_time' => '');
    $lbl_list = array('time' => $GLOBALS['Language']->getText('project_export_access_logs_export', 'time'), 'type' => 'Action', 'user' => $GLOBALS['Language']->getText('project_export_access_logs_export', 'user'), 'email' => $GLOBALS['Language']->getText('project_export_access_logs_export', 'email'), 'title' => $GLOBALS['Language']->getText('project_stats_source_code_access_utils', 'frs_elements'), 'local_time' => $GLOBALS['Language']->getText('project_export_access_logs_export', 'local_time'));
    $result = db_query($sql);
    $rows = db_numrows($result);
    if ($result && $rows > 0) {
        // Build csv for files access logs
        echo build_csv_header($col_list, $title) . $eol;
        echo build_csv_header($col_list, $lbl_list) . $eol;
        while ($arr = db_fetch_array($result)) {
            prepare_access_logs_record($project->getGroupId(), $arr);
            echo build_csv_record($col_list, $arr) . $eol;
        }
        echo build_csv_header($col_list, array()) . $eol;
    }
}

Example #2

File: source_code_access_utils.php Project: pombredanne/tuleap

function filedownload_logs_daily($project, $span = 7, $who = "allusers")
{
    // check first if service is used by this project
    // if service not used return immediately
    if (!$project->usesFile()) {
        print '<P><B><U>' . $GLOBALS['Language']->getText('project_stats_source_code_access_utils', 'service_disabled', $GLOBALS['Language']->getText('project_stats_source_code_access_utils', 'file_download')) . '</U></B>';
        return;
    }
    $sql = filedownload_logs_extract($project, $span, $who);
    logs_display($sql, $span, $GLOBALS['Language']->getText('project_stats_source_code_access_utils', 'files'), $GLOBALS['Language']->getText('project_stats_source_code_access_utils', 'file_download'));
    $sql = frs_logs_extract($project, $span, $who);
    logs_display($sql, $span, $GLOBALS['Language']->getText('project_stats_source_code_access_utils', 'frs_elements'), $GLOBALS['Language']->getText('project_stats_source_code_access_utils', 'frs_actions'));
}