sfp_api_laravel_ginastica_cerebro/app/Models/SupportTicket.php

<?php

namespace App\Models;

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

/**
 * @property int $id
 * @property int $unit_id
 * @property int $applicant_user_id
 * @property int $responsable_user_id
 * @property int $student_id
 * @property string $title
 * @property string|null $description
 * @property int $support_status_id
 * @property string $severity
 * @property \Illuminate\Support\Carbon|null $created_at
 * @property \Illuminate\Support\Carbon|null $updated_at
 * @property string|null $deleted_at
 * @method static \Illuminate\Database\Eloquent\Builder<static>|SupportTicket newModelQuery()
 * @method static \Illuminate\Database\Eloquent\Builder<static>|SupportTicket newQuery()
 * @method static \Illuminate\Database\Eloquent\Builder<static>|SupportTicket query()
 * @method static \Illuminate\Database\Eloquent\Builder<static>|SupportTicket whereApplicantUserId($value)
 * @method static \Illuminate\Database\Eloquent\Builder<static>|SupportTicket whereCreatedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder<static>|SupportTicket whereDeletedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder<static>|SupportTicket whereDescription($value)
 * @method static \Illuminate\Database\Eloquent\Builder<static>|SupportTicket whereId($value)
 * @method static \Illuminate\Database\Eloquent\Builder<static>|SupportTicket whereResponsableUserId($value)
 * @method static \Illuminate\Database\Eloquent\Builder<static>|SupportTicket whereSeverity($value)
 * @method static \Illuminate\Database\Eloquent\Builder<static>|SupportTicket whereStudentId($value)
 * @method static \Illuminate\Database\Eloquent\Builder<static>|SupportTicket whereSupportStatusId($value)
 * @method static \Illuminate\Database\Eloquent\Builder<static>|SupportTicket whereTitle($value)
 * @method static \Illuminate\Database\Eloquent\Builder<static>|SupportTicket whereUnitId($value)
 * @method static \Illuminate\Database\Eloquent\Builder<static>|SupportTicket whereUpdatedAt($value)
 * @mixin \Eloquent
 */
class SupportTicket extends Model
{
    use HasFactory;

    protected $table = 'support_tickets';

    protected $guarded = [
        'id', // Add more fields that shouldn't be edited here
    ];

    protected $casts = [
        'created_at' => 'datetime',
        'updated_at' => 'datetime',
        // Add your casts here (e.g., 'is_active' => 'boolean')
    ];

    // Relationships

    public function applicantUnit()
    {
        return $this->belongsTo(\App\Models\Unit::class, 'applicant_unit_id');
    }

    public function targetUnit()
    {
        return $this->belongsTo(\App\Models\Unit::class, 'target_unit_id');
    }

    public function applicantUser()
    {
        return $this->belongsTo(\App\Models\User::class, 'applicant_user_id');
    }

    public function responsableUser()
    {
        return $this->belongsTo(\App\Models\User::class, 'responsable_user_id');
    }

    // Query Scopes

    public function scopeVisibleToUnit($query, int $unitId)
    {
        return $query->where(function ($q) use ($unitId) {
            $q->where('target_unit_id', $unitId)
              ->orWhere('applicant_unit_id', $unitId);
        });
    }

}