<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
use Illuminate\Support\Carbon;

class AcademyUser extends Model
{
    use SoftDeletes;
    protected $dates = ['deleted_at'];

    protected $fillable = [
        'id',
        'student_name',
        'student_last_name',
        'student_document_type_id',
        'date',
        'age',
        'mail',
        'phone',
        'advisor_name',
        'advisor_last_name',
        'advisor_document_type_id',
        'advisor_identification',
        'advisor_ocupation',
        'advisor_relation',
        'birthdate',
        'identification',
        'student_academy_code',
        'school_name',
        'school_grade',
        'address_id',
        'blood_type',
        'academy_place',
        'last_inscription_year',
        'user_id',
        'academy_period_id',
        'academy_location_id',
        'academy_category_id',
        'academy_schedule_id',
        'active',
        'ocupation',
        'type_academy',
        'type_person',
        'advisor_nit',
        'advisor_business_name',
        'advisor_property_name',
        'advisor_isic_code',
        'advisor_name_of_contact_person_nit',
        'advisor_city',
        'advisor_address_id',
        'advisor_phone',
        'advisor_cell_phone',
        'advisor_mail',
        'observations',
        'guardian_information',
        'academy_state_id',
        'country_code',
        'dial_code',
        'advisor_country_code',
        'advisor_dial_code',
        'advisor_cell_dial_code',
        'advisor_cell_country_code',
    ];

    public function user()
    {
        return $this->belongsTo(User::class)->with('user_tags');
    }

    public function academy_state()
    {
        return $this->belongsTo(AcademyState::class);
    }

    public function student_document_type()
    {
        return $this->belongsTo(DocumentType::class);
    }

    public function advisor_document_type()
    {
        return $this->belongsTo(DocumentType::class);
    }

    public function academy_period()
    {
        return $this->belongsTo(AcademyPeriod::class);
    }

    public function academy_schedule()
    {
        return $this->belongsTo(AcademySchedule::class);
    }

    public function academy_category()
    {
        return $this->belongsTo(AcademyCategory::class);
    }

    public function address()
    {
        return $this->belongsTo(Address::class);
    }

    public function academy_location()
    {
        return $this->belongsTo(AcademyLocation::class);
    }

    public function academy_attendance_today()
    {
        return $this->hasMany(AcademyAttendance::class)->whereDate('attendance_date', Carbon::today());
    }

    public function academy_users_discounts()
    {
        return $this->hasMany(AcademyUsersDiscount::class);
    }

    public function advisor_address()
    {
        return $this->belongsTo(Address::class);
    }

    public function academy_purchases()
    {
        return $this->hasMany(AcademyPurchase::class);
    }

    public function academy_attendance()
    {
        return $this->hasMany(AcademyAttendance::class);
    }
}