mooxphp/moox

<?php

namespace Moox\Expiry\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\SoftDeletes;
use Illuminate\Support\Collection;
use Moox\Press\QueryBuilder\UserQueryBuilder;

class Expiry extends Model
{
    use HasFactory;
    use SoftDeletes;

    protected $fillable = [
        'title',
        'slug',
        'item_id',
        'meta_id',
        'link',
        'expiry_job',
        'category',
        'status',
        'expired_at',
        'notified_at',
        'notified_to',
        'escalated_at',
        'escalated_to',
        'handled_by',
        'done_at',
    ];

    protected $searchableFields = ['*'];

    protected $casts = [
        'expired_at' => 'datetime',
        'notified_at' => 'datetime',
        'escalated_at' => 'datetime',
        'done_at' => 'datetime',
    ];

    /**
     * Get the owning user model for notify.
     */
    public function notifyUser(): BelongsTo
    {
        return $this->belongsTo(config('expiry.user_model'), 'notified_to', 'ID');
    }

    /**
     * Get the owning user model for escalate.
     */
    public function escalateUser(): BelongsTo
    {
        return $this->belongsTo(config('expiry.user_model'), 'escalated_to', 'ID');
    }

    /**
     * Use the custom query builder for the model.
     */
    protected function newBaseQueryBuilder()
    {
        $connection = $this->getConnection();

        return new UserQueryBuilder(
            $connection, $connection->getQueryGrammar(), $connection->getPostProcessor()
        );
    }

    public static function getExpiryJobOptions(): Collection
    {
        return static::select('expiry_job')
            ->distinct()
            ->whereNotNull('expiry_job')
            ->pluck('expiry_job', 'expiry_job');
    }

    public static function getExpiryCategoryOptions(): Collection
    {
        return static::select('category')
            ->distinct()
            ->whereNotNull('category')
            ->pluck('category', 'category');
    }

    public static function getExpiryStatusOptions(): Collection
    {
        return static::select('status')
            ->distinct()
            ->whereNotNull('status')
            ->pluck('status', 'status');
    }

    public static function getUserOptions(): array
    {
        $userModel = config('expiry.user_model');

        if (! class_exists($userModel)) {
            throw new \Exception("User model class {$userModel} does not exist.");
        }

        $notifiedToUserIds = Expiry::pluck('notified_to')->unique()->filter();

        if ($notifiedToUserIds->isEmpty()) {
            return [];
        }

        $users = $userModel::whereIn('ID', $notifiedToUserIds)
            ->get(['ID', 'display_name']);

        return $users
            ->pluck('display_name', 'ID')
            ->filter(function ($displayName) {
                return ! is_null($displayName);
            })
            ->sortBy(function ($displayName, $id) {
                return strtolower($displayName);
            })
            ->toArray();
    }
}