<?php

declare(strict_types=1);

namespace Models;

use Core\DbLib\DbModel;
use Core\Models\CoreHelper;
use Traits\ModelGetQuery;

/**
 * @property int $id
 * @property string $created_at
 * @property int $count
 * @property int $company_id
 */
class OnlineStat extends DbModel
{

    use ModelGetQuery;

    static string $tableName = 'online_stat';

    public static bool $hasCompanyRelation = true;

    public static function add(int $count): void
    {
        self::create(['count' => $count, 'created_at' => date('Y-m-d H:i:00'), 'company_id' => CoreHelper::$companyId]);
    }

    public static function getData(): array
    {
        $records = self::getQuery()
            ->order('created_at', 'DESC')
            ->limit(12 * 24)
            ->fetchAll();

        $data = [];
        $categories = [];
        $byRecord = [];
        foreach ($records as $record) {
            $key = date('ymdH', strtotime($record->created_at));
            $categories[$key] = date('H', strtotime($record->created_at));

            $byRecord[] = $record->count;

            if (isset($data[$key])) {
                $data[$key] = $record->count > $data[$key] ? $record->count : $data[$key];
            } else {
                $data[$key] = $record->count;
            }
        }

        ksort($categories);
        ksort($data);
        $data = array_values($data);
        $categories = array_values($categories);

        return [
            'data' => $data,
            'categories' => $categories,
            'maxMinute' => !empty($byRecord) ? max($byRecord) : 0,
            'avgMinute' => !empty($byRecord) ? array_sum($byRecord) / count($byRecord) : 0,
        ];
    }

}