App\Models\SignupStat

Complexity

Total Complexity

3

Size/Duplication

Total Lines	31
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getUsersByMonth()	0	7	1
A	insertUsersByMonth()	0	14	2

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class SignupStat extends Model
{
    use HasFactory;

The trait Illuminate\Database\Eloquent\Factories\HasFactory requires the property $factoryClass which is not provided by App\Models\SignupStat.

    protected $guarded = [];

    public static function insertUsersByMonth(): void
    {
        $users = User::query()
            ->whereNotNull('created_at')
            ->where('created_at', '<>', '0000-00-00 00:00:00')
            ->selectRaw("DATE_FORMAT(created_at, '%Y-%m-01') as sort_date, DATE_FORMAT(created_at, '%M %Y') as mth, COUNT(id) as num")
            ->groupBy(['sort_date', 'mth'])
            ->orderByDesc('sort_date')

'sort_date' of type string is incompatible with the type Closure|Illuminate\Database\Eloquent\Builder|Illuminate\Database\Query\Builder expected by parameter $column of Illuminate\Database\Query\Builder::orderByDesc().

            ->get();

        foreach ($users as $user) {
            self::updateOrCreate(
                ['month' => $user->mth],
                ['signups' => $user->num, 'sort_date' => $user->sort_date]
            );
        }
    }

    public static function getUsersByMonth(): array
    {
        return self::query()
            ->select(['month', 'signups'])
            ->orderByDesc('sort_date')

'sort_date' of type string is incompatible with the type Closure|Illuminate\Database\Eloquent\Builder|Illuminate\Database\Query\Builder expected by parameter $column of Illuminate\Database\Query\Builder::orderByDesc().

            ->get()
            ->toArray();
    }
}