@php
$fill_data = function() {
$out = [];
for($i = 0; $i <= 23; $i++) {
if (\Carbon\Carbon::now()->timestamp < \Carbon\Carbon::today()->addHours($i)->timestamp) continue;
array_push($out, \Illuminate\Support\Facades\DB::table('users')->where('created_at', '>=', \Carbon\Carbon::today()->addHours($i))->where('bot', '!=', true)
->where('created_at', '<=', \Carbon\Carbon::today()->addHours($i+1))->count());
}
return $out;
};
$fill_labels = function() {
$out = [];
for($i = 0; $i <= 23; $i++) {
if (\Carbon\Carbon::now()->timestamp < \Carbon\Carbon::today()->addHours($i)->timestamp) continue;
array_push($out, $i.':00 - '.$i.':59');
}
return $out;
};
$chart = new \ArielMejiaDev\LarapexCharts\LarapexChart();
$chart->setTitle('Today')->setType('area')->setHeight(600)->setXAxis($fill_labels())->setDataset([[
'name' => 'Total',
'data' => $fill_data()
]]);
@endphp
{{ $chart->script() }}
@php
$fill_data = function($days) {
$out = [];
for($i = 0; $i < $days; $i++)
array_push($out, \Illuminate\Support\Facades\DB::table('users')->where('created_at', '>=', \Carbon\Carbon::today()->subDays($i + 1))
->where('created_at', '<=', \Carbon\Carbon::today()->subDays($i))->count());
return array_reverse($out);
};
$fill_labels = function($days) {
$out = [];
for($i = 0; $i < $days; $i++)
array_push($out, $i > 0 ? $i .' days ago' : 'Today');
return array_reverse($out);
};
$chart = new \ArielMejiaDev\LarapexCharts\LarapexChart();
$chart->setTitle('7 days')->setType('area')->setHeight(600)->setXAxis($fill_labels(7))->setDataset([[
'name' => 'Total',
'data' => $fill_data(7)
]]);
@endphp
{{ $chart->script() }}
@php
$chart = new \ArielMejiaDev\LarapexCharts\LarapexChart();
$chart->setTitle('15 days')->setType('area')->setHeight(600)->setXAxis($fill_labels(15))->setDataset([[
'name' => 'Total',
'data' => $fill_data(15)
]]);
@endphp
{{ $chart->script() }}
@php
$chart = new \ArielMejiaDev\LarapexCharts\LarapexChart();
$chart->setTitle('30 days')->setType('area')->setHeight(600)->setXAxis($fill_labels(30))->setDataset([[
'name' => 'Total',
'data' => $fill_data(30)
]]);
@endphp
{{ $chart->script() }}
@php
$chart = new \ArielMejiaDev\LarapexCharts\LarapexChart();
$chart->setTitle('3 months')->setType('area')->setHeight(600)->setXAxis($fill_labels(90))->setDataset([[
'name' => 'Total',
'data' => $fill_data(90)
]]);
@endphp
{{ $chart->script() }}
@php
$chart = new \ArielMejiaDev\LarapexCharts\LarapexChart();
$chart->setTitle('6 months')->setType('area')->setHeight(600)->setXAxis($fill_labels(180))->setDataset([[
'name' => 'Total',
'data' => $fill_data(180)
]]);
@endphp
{{ $chart->script() }}
@php
$chart = new \ArielMejiaDev\LarapexCharts\LarapexChart();
$chart->setTitle('1 year')->setType('area')->setHeight(600)->setXAxis($fill_labels(365))->setDataset([[
'name' => 'Total',
'data' => $fill_data(365)
]]);
@endphp
{{ $chart->script() }}