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];
}
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;
}
