Minepic\Models\AccountStats

Complexity

Total Complexity

2

Size/Duplication

Total Lines	85
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getMostWanted()	0	8	1
A	getLastUsers()	0	8	1

<?php

declare(strict_types=1);

namespace Minepic\Models;

use DB;
use Illuminate\Database\Eloquent\Model;

/**
 * Class AccountsStats.
 *
 * @property string         $uuid
 * @property int            $count_request
 * @property \Carbon\Carbon $request_at
 *
 * @method static \Illuminate\Database\Eloquent\Builder|AccountStats newModelQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|AccountStats newQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|AccountStats query()
 * @mixin \Eloquent
 */
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;

    /** @var string[] */
    public $dates = [
        'request_at',
    ];

    /** @var string[] */
    public $casts = [
        'uuid' => 'string',
        'count_request' => 'int',
        'request_at' => 'datetime',
    ];

    /**
     * @var array
     */
    protected $fillable = [
        'uuid',
        'count_request',
        'request_at',
    ];

    /**
     * Get most wanted users.
     *
     * @param int $limit
     *
     * @return mixed
     */
    public static function getMostWanted(int $limit = 14)
    {
        return DB::select(
            "SELECT a.`uuid`, a.`username`, s.`count_request`
             FROM (
              SELECT `uuid`, `count_request` FROM `accounts_stats`
              ORDER BY `count_request` DESC
              LIMIT {$limit}
            ) s
            INNER JOIN `accounts` AS a USING(`uuid`)
            ORDER BY s.`count_request` DESC"
        );
    }

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