protected function loadData()
{
$days = $this->property('days');
if (!$days) {
throw new ApplicationException('Invalid days value: ' . $days);
}
// all accesses for last month
$items = AccessLog::where('created_at', '>=', Carbon::now()->subDays($days)->format('Y-m-d'))->get();
// parse data
$all = [];
foreach ($items as $item) {
// date
$timestamp = strtotime($item->created_at) * 1000;
$day = Carbon::createFromFormat('Y-m-d H:i:s', $item->created_at)->format('Y-m-d');
if (isset($all[$day])) {
$all[$day][1]++;
} else {
$all[$day] = [$timestamp, 1];
}
}
// count accessess for each day
$all_render = [];
foreach ($all as $a) {
$all_render[] = [$a[0], $a[1]];
}
return $all_render;
}
protected function loadData()
{
$days = $this->property('days');
if (!$days) {
throw new ApplicationException('Invalid days value: ' . $days);
}
// all accesses for last month
$items = AccessLog::where('created_at', '>=', Carbon::now()->subDays($days)->format('Y-m-d'))->get();
// parse data
$all = [];
$users = [];
$user_rows = [];
foreach ($items as $item) {
// user
$user_id = $item->user_id ? $item->user_id : 0;
$users[$user_id] = $user_id > 0 ? User::find($user_id) : $this->getDeletedFakeUser();
// date
$timestamp = strtotime($item->created_at) * 1000;
$day = Carbon::createFromFormat('Y-m-d H:i:s', $item->created_at)->format('Y-m-d');
if (isset($user_rows[$user_id][$day])) {
$user_rows[$user_id][$day][1]++;
} else {
$user_rows[$user_id][$day] = [$timestamp, 1];
}
// init empty day
if (!isset($all[$day])) {
$all[$day] = ['timestamp' => $timestamp, 'date' => $day, 'count' => 0];
}
// increase count
$all[$day]['count']++;
}
// we need at least two days, to display chart
if (sizeof($all) == 1) {
$day = reset($all);
$date = Carbon::createFromFormat('Y-m-d', $day['date'])->subDays(1);
$dateFormated = $date->format('Y-m-d');
$all[$dateFormated] = ['timestamp' => $date->timestamp * 1000, 'date' => $dateFormated, 'count' => 0];
}
// transform user line to json
foreach ($user_rows as $key => $user_row) {
$rows = [];
foreach ($user_row as $row) {
$rows[] = [$row[0], $row[1]];
}
// we need at least two days, to display chart
if (sizeof($rows) == 1) {
$first = reset($rows);
$rows[] = [$first[0] - 86400000, 0];
}
$user_rows[$key] = $rows;
}
// count all
$all_render = [];
foreach ($all as $a) {
$all_render[] = [$a['timestamp'], $a['count']];
}
return ['all' => $all_render, 'user_rows' => $user_rows, 'users' => $users];
}
public function boot()
{
/**
* Log user after login
*/
Event::listen('rainlab.user.login', function ($user) {
AccessLog::add($user);
});
}
/**
* Get data for widget
*
* @return array
*/
public function getCounts()
{
$log = AccessLog::all()->groupBy('user_id');
$counts = [];
$all = 0;
foreach ($log as $l) {
$first = $l[0];
$user = $first->user ? $first->user : $this->getDeletedFakeUser();
$size = sizeof($l);
$counts[] = ['size' => $size, 'id' => $first->user_id, 'name' => $user->username];
$all += $size;
}
return ['all' => $all, 'counts' => $counts];
}
protected function loadData()
{
$days = $this->property('days');
if (!$days) {
throw new ApplicationException('Invalid days value: ' . $days);
}
// all accesses for last month
$items = AccessLog::where('created_at', '>=', Carbon::now()->subDays($days)->format('Y-m-d'))->get();
// parse data
$all = [];
$users = [];
$user_rows = [];
foreach ($items as $item) {
// user
$user_id = $item->user_id ? $item->user_id : 0;
$users[$user_id] = $user_id > 0 ? User::find($user_id) : $this->getDeletedFakeUser();
// date
$timestamp = strtotime($item->created_at) * 1000;
$day = Carbon::createFromFormat('Y-m-d H:i:s', $item->created_at)->format('Y-m-d');
if (isset($user_rows[$user_id][$day])) {
$user_rows[$user_id][$day][1]++;
} else {
$user_rows[$user_id][$day] = [$timestamp, 1];
}
if (isset($all[$day])) {
$all[$day][1]++;
} else {
$all[$day] = [$timestamp, 1];
}
}
// transform user line to json
foreach ($user_rows as $key => $user_row) {
$rows = [];
foreach ($user_row as $row) {
$rows[] = [$row[0], $row[1]];
}
$user_rows[$key] = $rows;
}
// count all
$all_render = [];
foreach ($all as $a) {
$all_render[] = [$a[0], $a[1]];
}
return ['all' => $all_render, 'user_rows' => $user_rows, 'users' => $users];
}
protected function loadData()
{
$days = $this->property('days');
if (!$days) {
throw new ApplicationException('Invalid days value: ' . $days);
}
// all accesses for last month
$items = AccessLog::where('created_at', '>=', Carbon::now()->subDays($days)->format('Y-m-d'))->get();
// parse data
$all = $this->sortItemsToDays($items);
// we need at least two days, to display chart
if (sizeof($all) == 1) {
$day = reset($all);
$date = Carbon::createFromFormat('Y-m-d', $day['date'])->subDays(1);
$dateFormated = $date->format('Y-m-d');
$all[$dateFormated] = ['timestamp' => $date->timestamp * 1000, 'date' => $dateFormated, 'count' => 0];
}
// count accessess for each day
$all_render = [];
foreach ($all as $a) {
$all_render[] = [$a['timestamp'], $a['count']];
}
return $all_render;
}
