<?php

namespace App\Models;

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

class FormulariosBfRequests extends Model
{
    protected $table = 'formularios_bf_requests_view';

    public $timestamps = false;

    protected $fillable = [
        'id',
        'type_request_id',
        'type_request',
        'date_request',
        'date_entry_student',
        'date_retirement',
        'parent_id',
        'parent_rut',
        'parent_name',
        'parent_relationship',
        'status_request_id',
        'status_request',
        'academic_parent_id',
        'academic_parent_rut',
        'academic_parent_first_name',
        'academic_parent_second_name',
        'academic_parent_last_name',
        'academic_parent_second_last_name',
        'academic_parent_email',
        'academic_parent_mobile',
        'reason_request',
        'refund',
        'refund_month',
        'reason_text',
        'reason_cancellation',
        'user_cancelled',
        'cancelled_at',
        'user_finished',
        'finished_at',
        'create_date',
        'request_details'
    ];

     // Método para obtener detalles de líneas de la orden de compra
    protected function details()
    {
        // Decode JSON from purchase_order_lines to an array
        return collect(json_decode($this->request_details, true))->map(function ($line) {
            return [
                'detail_id' => $line['id'],
                'type_movement' => $line['type_movement']['type_movement'],
                'student_rut' => $line['student']['rut'],
                'student_name' => 
                    (!empty($line['student']['first_name']) ? $line['student']['first_name'] . ' ' : '') .
                    (!empty($line['student']['second_name']) ? $line['student']['second_name'] . ' ' : '') .
                    (!empty($line['student']['last_name']) ? $line['student']['last_name'] . ' ' : '') .
                    (!empty($line['student']['second_last_name']) ? $line['student']['second_last_name'] : ''),
                'description' => $line['description'],
                'quantity' => $line['quantity'],
                'price' => $line['price'],
                'subtotal' => $line['subtotal']
            ];
        });
    }
 
    // Sobrescribir el método toArray
    public function toArray()
    {
        $array = parent::toArray();
        $array['request_details'] = $this->details(); // Añadir las líneas formateadas
        return $array;
    }
}