activity_user_report.inc

Go to the documentation of this file.

<?php
Fakoli::using("activity_tracker");
Fakoli::usingFeature("data_view", "filter_form");
 
$user_id = checkNumeric($_GET["user_id"]);
 
if (!$user_id) redirect("activity_report");
 
$menu_item = "Activity Report";
 
$constraint = "WHERE user_id={$user_id}";
 
$sessions = IteratedQuery::create(UserActivitySession, "$constraint ORDER BY session_start DESC")->execute();
 
$table = new DataListView($sessions, "session");
$table->column("User", "<a href='/admin/session_details?session_id={session_id}'>{User.first_name} {User.last_name}</a>", true, "width: 25%")
       ->column("Session #", "<a href='/admin/session_details?session_id={session_id}'>{session_id}</a>", true, "text-align: right; width: 5%")
       ->column("Start", "{session_start}", true)
       ->column("End", "{session_end}", true)
       ->column("Page Views", "{page_views}", true, "text-align: right")
       ->column("Feedback", "{feedback_count}", true, "text-align: right")
       ->column("Browser", "{ActivityTracker::getBrowser}", true, "width: 20%");
       
$table->sortable = true;
$table->pageSize = 20;
$table->filter = true;
$table->excelFile = "activity_report.xls";
 
$script .= $table->writeScript();
 
$table->drawView();
 
$count = Query::create(UserActivity, "")->executeValue("COUNT(1)");
 
if ($count > 0)
{
?>
<br/>
<a class='button' href='#' onclick='new BackgroundProcess("Migrating User Activity", "/action/activity_tracker/migrate_data"); return false;'>Migrate User Activity Logs</a>
<?
}
?>