<?php

namespace App\Models;

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

class JobRequest extends Model
{
    use HasFactory;

    protected $fillable = [
        'job_id',
        'user_id',
        'status',
        'note',
    ];

    protected $hidden = [
        'updated_at',
    ];

    public function user()
    {
        return $this->hasOne(User::class, 'id', 'user_id');
    }

    public function job()
    {
        return $this->hasOne(PostJobs::class, 'job_id', 'id');
    }

    public const PerPageRecord = "10";

    public static function GetInterestedUsers($request, $jobId)
    {
        $keyword   = getValue($request->input('keyword'));
        $offset    = (int) getValue($request->input('offset'), 0);
        $sort_by   = getValue($request->input('sort_by'), 'created_at');
        $order_by  = getValue($request->input('order_by'), 'DESC');

        $query = self::with(['user', 'user.operatorInfo'])
            ->where('job_id', $jobId)
            ->orderBy($sort_by, $order_by);

        $totalRequests = $query->count();

        $requests = $query->offset($offset * self::PerPageRecord)
            ->limit(self::PerPageRecord)
            ->get();

        return [
            'count'        => $totalRequests,
            'list'         => $requests,
            'next_offset'  => (count($requests) === self::PerPageRecord) ? $offset + 1 : -1,
        ];
    }
}