<?php

namespace App\Models;

use Carbon\Carbon;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\Storage;

class Course extends Model
{
    use HasFactory;

    protected $fillable = [
        'id', 'name', 'description', 'imagen', 'data', 'url', 'certification', 'cycle_id', 'start_date', 'end_date', 'data->objectives', 'data->content', 'duration', 'social_service'
    ];

    protected $casts = [
        'data'          => 'array',
    ];

    public function saveImage($file)
    {
        $fechaActual = Carbon::now()->format('Y-m-d_H:i:s');
        /** Elimina archivo */
        Storage::disk('files_base64')->delete(str_replace('/storage/', '', $this->imagen));

        $file = $file[0] ?? $file;
        $file_base64 = base64_decode(substr($file['content'], strpos($file['content'], ",") + 1));
        $url = 'img/course/C' . $this->id .'-'.$fechaActual.  '.jpg';
        Storage::disk('files_base64')->put($url, $file_base64);
        
        /** Actualiza url */
        $this->imagen = '/storage/'.$url;
        $this->save();
    }

    public function alliances(){
        return AssignedAlliance::where('model', 'courses')->where('model_id', $this->id)->pluck('alliance_id');
    }

    public function nameAlliances()
    {
        $alliances = Alliance::whereIn('id', $this->alliances())->get();
        if ($alliances->count() >= 1) {
            $names = $alliances->pluck('name')->implode(', ');
        }
        return $names ?? '';
    }

    public function saveAlliances (array $alliances = []){
        $valoresActuales = $this->alliances()->toArray();
        $valoresParaEliminar = array_diff($valoresActuales, $alliances);
        $valoresParaAgregar = array_diff($alliances, $valoresActuales);
        //Eliminar valores
        AssignedAlliance::where('model', 'courses')->where('model_id', $this->id)->whereIn('alliance_id', $valoresParaEliminar)->delete();
        //Añadir valores
        foreach ($valoresParaAgregar as $value) {
            AssignedAlliance::create([
                'model'         => 'courses',
                'model_id'      => $this->id,
                'alliance_id'   => $value
            ]);
        }
    }

    /**
     * Obtiene la imagen de banner en base 64
     * 
     * *@return array $path retorna el array con el archivo en base64 o '' en caso de no existir
     */
    public function getFile()
    {
            try {
                $path = [
                    'name' => 'B'.$this->id,
                    'type' => 'jpg',
                    'content' => getHeader('jpg') . base64_encode(Storage::get('public/' . str_replace('/storage/', '', $this->imagen))),
                ];
            } catch (\Throwable $th) {
                $path = '';
            }
        return $path;
    }

    public function updateFullData( $request ){
        $this->update($request);
        $this->update(['certification' => 'Certificado en Procesos de Formación']);
        $this->saveImage($request['image']); //Almecena imagen
        $this->saveAlliances($request['alliances'] ?? []); //Almecena alianzas
    }

    public function getFullData(){
        return [
            'name'                  => $this->name,
            'description'           => $this->description,
            'url'                   => $this->url,
            'certification'         => $this->certification,
            'cycle_id'              => $this->cycle_id,
            'start_date'            => $this->start_date,
            'end_date'              => $this->end_date,
            'duration'              => $this->duration,
            'social_service'        => $this->social_service,
            'data->objectives'      => $this->data['objectives'] ?? '',
            'data->content'         => $this->data['content'] ?? '',
            'image'                 => $this->getFile(),
            'alliances'             => $this->alliances(),
        ];

    }
}