Просмотр файла app/Classes/Metrika.php

<?php

declare(strict_types=1);

namespace App\Classes;

use App\Models\Counter;
use App\Models\Online;
use Illuminate\Database\Capsule\Manager as DB;
use Illuminate\Database\Eloquent\Builder;

class Metrika
{
    /**
     * Генерирует счетчик
     *
     * @param int $online
     *
     * @return void
     */
    public function getCounter($online): void
    {
        $counter = Counter::query()->first();

        if (! $counter) {
            $counter = (object) ['dayhosts' => 0, 'dayhits' => 0];
        }

        // ----------------------------------------------------------------------//
        $img   = imagecreatefrompng(HOME . '/assets/img/images/counter.png');
        $color = imagecolorallocate($img, 62, 62, 62);

        $pos = 66;
        if ($online >= 10 && $online < 100) {
            $pos = 54;
        }
        if ($online >= 100 && $online < 1000) {
            $pos = 42;
        }

        imagettftext($img, 6, 0, 14, 7, $color, HOME . '/assets/fonts/font.ttf', (string) formatShortNum($counter->dayhosts));
        imagettftext($img, 6, 0, 14, 13, $color, HOME . '/assets/fonts/font.ttf', (string) formatShortNum($counter->dayhits));
        imagettftext($img, 12, 0, $pos, 13, $color, HOME . '/assets/fonts/font.ttf', (string) $online);

        imagepng($img, UPLOADS . '/counters/counter_new.png');
        imagedestroy($img);

        rename(UPLOADS . '/counters/counter_new.png', UPLOADS . '/counters/counter.png');
    }

    /**
     * Сохраняет статистику
     *
     * @return void
     */
    public function saveStatistic(): void
    {
        $_SESSION['hits']++;

        if (isset($_SESSION['online']) && $_SESSION['online'] > SITETIME) {
            return;
        }

        $period = date('Y-m-d H:00:00', SITETIME);
        $day    = date('Y-m-d 00:00:00', SITETIME);

        Online::query()->where('updated_at', '<', SITETIME - setting('timeonline'))->delete();

        $newHost = false;

        $ip     = getIp();
        $brow   = getBrowser();
        $userId = getUser('id');
        $uid    = md5($ip . $brow);

        $online = Online::query()
            ->where('uid', $uid)
            ->when($userId, static function (Builder $query) use ($userId) {
                return $query->orWhere('user_id', $userId);
            })
            ->first();

        if ($online) {
            $online->update([
                'uid'        => $uid,
                'ip'         => $ip,
                'brow'       => $brow,
                'updated_at' => SITETIME,
                'user_id'    => $userId,
            ]);
        } else {
            Online::query()->insertOrIgnore([
                'uid'        => $uid,
                'ip'         => $ip,
                'brow'       => $brow,
                'updated_at' => SITETIME,
                'user_id'    => $userId,
            ]);
            $newHost = true;
        }

        // -----------------------------------------------------------//
        $counter = Counter::query()->first();

        if (! $counter) {
            return;
        }

        if (date('Y-m-d 00:00:00', strtotime($counter->period)) !== $day) {
            DB::connection()->insert('insert ignore into counters31 (period, hosts, hits) values (?, ?, ?);', [$day, $counter->dayhosts, $counter->dayhits]);
            DB::connection()->update('update counters set period=?, dayhosts=?, dayhits=?;', [$period, 0, 0]);
        }

        if ($counter->period !== $period) {
            DB::connection()->insert('insert ignore into counters24 (period, hosts, hits) values (?, ?, ?);', [$period, $counter->hosts24, $counter->hits24]);
            DB::connection()->update('update counters set period=?, hosts24=?, hits24=?;', [$period, 0, 0]);
        }

        // -----------------------------------------------------------//
        $hostsUpdate = [];
        if ($newHost) {
            $hostsUpdate = [
                'allhosts' => DB::connection()->raw('allhosts + 1'),
                'dayhosts' => DB::connection()->raw('dayhosts + 1'),
                'hosts24'  => DB::connection()->raw('hosts24 + 1'),
            ];
        }

        $hits = $_SESSION['hits'];

        $hitsUpdate = [
            'allhits' => DB::connection()->raw('allhits + ' . $hits),
            'dayhits' => DB::connection()->raw('dayhits + ' . $hits),
            'hits24'  => DB::connection()->raw('hits24 + ' . $hits),
        ];

        $counter->update(array_merge($hostsUpdate, $hitsUpdate));

        $_SESSION['hits']   = 0;
        $_SESSION['online'] = strtotime('+30 seconds', SITETIME);
    }
}