| Server IP : 167.235.224.122 / Your IP : 216.73.216.110 Web Server : Apache/2.4.58 (Ubuntu) System : Linux newplayground 6.8.0-136-generic #136-Ubuntu SMP PREEMPT_DYNAMIC Wed Jul 1 21:33:11 UTC 2026 aarch64 User : deploy ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/www/html/reef_analytics/app/Services/ |
Upload File : |
<?php
namespace App\Services;
use App\Models\MetricSnapshot;
use Illuminate\Support\Collection;
/**
* Derives KPI stat-tile data from stored metric snapshots.
*
* Tile contract: label · value (+unit) · delta vs a named period · sparkline.
* Trend series ending "today" drop the final, partial point first.
*/
class KpiBuilder
{
protected Collection $snapshots;
public function __construct()
{
$this->snapshots = MetricSnapshot::all()->keyBy('key');
}
public function build(array $keys): array
{
return array_values(array_filter(array_map(
fn (string $key) => $this->one($key),
$keys,
)));
}
protected function one(string $key): ?array
{
return match ($key) {
'dau' => $this->fromTrend('dau', 'Daily active users', 'yesterday', dropPartial: true),
'wau' => $this->fromTrend('wau', 'Weekly active users', 'last full week', dropPartial: true),
'mau' => $this->fromTrend('mau', 'Monthly active users', 'last full month', dropPartial: true),
'registrations_total' => $this->registrationsTotal(),
'funnel_conversion' => $this->funnelConversion(),
'top_screen' => $this->topScreen(),
default => null,
};
}
protected function series(string $key): ?array
{
$payload = $this->snapshots->get($key)?->payload;
if (! $payload || $payload['type'] !== 'series' || empty($payload['series'])) {
return null;
}
return $payload;
}
protected function fromTrend(string $key, string $label, string $periodNote, bool $dropPartial = false): ?array
{
$payload = $this->series($key);
if (! $payload) {
return null;
}
$data = $payload['series'][0]['data'];
if ($dropPartial && count($data) > 1) {
array_pop($data);
}
if ($data === []) {
return null;
}
$current = end($data);
$previous = count($data) > 1 ? $data[count($data) - 2] : null;
return [
'key' => $key,
'label' => $label,
'value' => $current,
'delta' => $this->delta($current, $previous),
'note' => $periodNote,
'spark' => array_slice($data, -14),
];
}
protected function registrationsTotal(): ?array
{
$payload = $this->series('registrations');
if (! $payload) {
return null;
}
$data = $payload['series'][0]['data'];
$current = end($data);
$weekAgo = $data[max(count($data) - 8, 0)] ?? null;
return [
'key' => 'registrations_total',
'label' => 'Registered users',
'value' => $current,
'delta' => $this->delta($current, $weekAgo),
'note' => 'vs. 7 days ago',
'spark' => array_slice($data, -14),
];
}
protected function funnelConversion(): ?array
{
$payload = $this->snapshots->get('funnel_main')?->payload;
if (! $payload || $payload['type'] !== 'funnel' || empty($payload['steps'])) {
return null;
}
$steps = $payload['steps'];
$last = end($steps);
return [
'key' => 'funnel_conversion',
'label' => 'Install → data source',
'value' => $last['rate'],
'unit' => '%',
'delta' => null,
'note' => 'activation conversion',
'spark' => null,
];
}
protected function topScreen(): ?array
{
$payload = $this->snapshots->get('top_screens')?->payload;
if (! $payload || $payload['type'] !== 'ranking' || empty($payload['items'])) {
return null;
}
$top = $payload['items'][0];
return [
'key' => 'top_screen',
'label' => 'Most visited screen',
'value' => $top['name'],
'text' => true,
'delta' => null,
'note' => number_format($top['value']).' views',
'spark' => null,
];
}
protected function delta(mixed $current, mixed $previous): ?array
{
if (! is_numeric($current) || ! is_numeric($previous) || $previous == 0) {
return null;
}
$pct = round(($current - $previous) / abs($previous) * 100, 1);
return [
'pct' => $pct,
'direction' => $pct <=> 0,
];
}
}