<?php

namespace App\Models;


use Illuminate\Database\Eloquent\Model;


class Requests extends Model
{
    protected $table = 'requests';
    protected $primaryKey = 'id';
    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'date_request',
        'date_entry_student',
        'date_retirement',
        'refund',
        'refund_month',
        'status_request_id',
        'type_request_id',
        'parent_id',
        'reason_request_id',
        'reason_text',
        'observation',
        'file_data',
        'user_created',
        'created_at',
        'user_updated',
        'updated_at',
        'user_cancelled',
        'cancelled_at',
        'reason_cancellation',
        'user_finished',
        'finished_at',
        'file_finished',
        'areas_comments',        
        'parent_identical',
        'academic_parent_first_name',
        'academic_parent_second_name',
        'academic_parent_last_name',
        'academic_parent_second_last_name',
        'academic_parent_relationship',
        'academic_parent_email',
        'academic_parent_mobile',
        'academic_parent_id'
    ];

    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
     */

    public function status_request()
    {
        return $this->belongsTo('App\Models\StatusRequest', 'status_request_id');
    }

    public function type_request()
    {
        return $this->belongsTo('App\Models\TypesRequest', 'type_request_id');
    }

    public function parent()
    {
        return $this->belongsTo('App\Models\Parents', 'parent_id');
    }

    public function parent_relationship()
    {
        return $this->belongsTo('App\Models\Relationships', 'academic_parent_relationship');
    }

    public function reason_request()
    {
        return $this->belongsTo('App\Models\ReasonsRequest', 'reason_request_id');
    }

    public function details()
    {
        return $this->hasMany('App\Models\RequestsDetail', 'request_id', 'id');
    }

    public function comments()
    {
        return $this->hasMany('App\Models\RequestsComments', 'request_id', 'id');
    }

    public function students()
    {
        return $this->hasMany('App\Models\Students', 'request_id', 'id');
    }

    // Relaciones con el modelo Users
    public function createdBy()
    {
        return $this->belongsTo('App\Models\Users', 'user_created');
    }

    public function updatedBy()
    {
        return $this->belongsTo('App\Models\Users', 'user_updated');
    }

    public function cancelledBy()
    {
        return $this->belongsTo('App\Models\Users', 'user_cancelled');
    }

    public function finishedBy()
    {
        return $this->belongsTo('App\Models\Users', 'user_finished');
    }
}