<?php

namespace App\Models;

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

class UploadStudentPayment extends Model
{
    use HasFactory;

    protected $table = 'upload_student_payments';

    protected $fillable = [
        'quantity',
        'quantity_success',
        'quantity_error',
        'user_created',
        'sent',
        'sent_success',
        'sent_error',
        'cancelled',
        'reason_cancelled',
        'cancelled_at',
        'integration_at',
        'integration_status_id',
        'status_upload_id',
        'user_confirmation',
        'confirmation_at',
        'user_cancelled',
        'created_at',
        'updated_at',
        'sent_error_message',
        'ref_year'
    ];

    public function integration_status()
    {
        return $this->hasOne(IntegrationStatus::class, 'id', 'integration_status_id');
    }

    public function status_upload()
    {
        return $this->hasOne(StatusUpload::class, 'id', 'status_upload_id');
    }

    public function user_confirmation_data()
    {
        return $this->hasOne(Users::class, 'id', 'user_confirmation');
    }

    public function user_cancelled_data()
    {
        return $this->hasOne(Users::class, 'id', 'user_cancelled');
    }
    
    public function user_created_data()
    {
        return $this->hasOne(Users::class, 'id', 'user_created');
    }

    public function details()
    {
        return $this->hasMany(UploadStudentPaymentDetail::class, 'upload_student_payment_id', 'id');
    }
}