App\Models\AccountStats

Complexity

Total Complexity

4

Size/Duplication

Total Lines	83
Duplicated Lines	0 %

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	getLastUsers()	0	4	1
A	getMostWanted()	0	9	1
A	incrementRequestStats()	0	6	1
A	incrementSearchStats()	0	6	1

<?php

declare(strict_types=1);

namespace App\Models;

use Illuminate\Database\Eloquent\Model as Model;
use Illuminate\Support\Facades\DB;

/**
 * Class AccountsStats.
 *
 * @property string $uuid
 * @property int    $count_request
 * @property int    $count_search
 * @property int    $time_request
 * @property int    $time_search
 */
class AccountStats extends Model
{
    /**
     * Table name.
     *
     * @var string
     */
    protected $table = 'accounts_stats';

    /**
     * Primary key.
     *
     * @var string
     */
    protected $primaryKey = 'uuid';

    /**
     * No primary key.
     *
     * @var bool
     */
    public $incrementing = false;

    /**
     * @var bool
     */
    public $timestamps = false;

    /**
     * Increment request counter.
     */
    public function incrementRequestStats(string $uuid = '')
    {
        $this->where('uuid', $uuid)
            ->update([
                'count_request' => app('db')->raw('count_request + 1'),
                'time_request' => \time(),
            ]);
    }

    /**
     * Increment search counter.
     */
    public function incrementSearchStats(string $uuid = '')
    {
        $this->where('uuid', $uuid)
            ->update([
                'count_search' => app('db')->raw('count_search + 1'),
                'time_search' => \time(),
            ]);
    }

    /**
     * Get most wanted users.
     *
     * @return mixed
     */
    public static function getMostWanted()
    {
        $default_uuid = env('DEFAULT_UUID');

        return DB::select(
            "SELECT a.`uuid`, a.`username`, s.`count_request`
             FROM (
              SELECT `uuid`, `count_request` FROM `accounts_stats`
              WHERE `uuid` != '{$default_uuid}'
              ORDER BY `count_request` DESC
              LIMIT 14
            ) s
            INNER JOIN `accounts` AS a USING(`uuid`)
            ORDER BY s.`count_request` DESC"
        );
    }

    /**
     * Get last users.
     *
     * @return mixed
     */
    public static function getLastUsers()
    {
        return DB::select(
            'SELECT a.`uuid`, a.`username`, s.`count_request`
              FROM (
                SELECT `uuid`, `count_request` FROM `accounts_stats`
                ORDER BY `time_request` DESC
                LIMIT 9
              ) s
            INNER JOIN `accounts` a USING(`uuid`)
            ORDER BY s.`count_request` DESC'
        );
    }
}