<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\Route;

class Section extends Model
{
    use HasFactory;

    protected $fillable = [
        'id', 'name', 'component', 'data'
    ];

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

    public function getData()
    {
        $data = null;
        switch ($this->data['getData']) {
            case 'alliances':
                $data = $this->getAlliances();
                break;

            case 'sliderCourse':
                $data = $this->getSliderCourses();
                break;

            case 'sliderCycle':
                $data = $this->getSliderCycles();
                break;
            case 'sliderConference':
                $data = $this->getConferences();
                break;
            case 'courses':
                $data = $this->getCourses();
                break;
            case 'cycles':
                $data = $this->getCycles();
                break;
            case 'courseForCycle':
                $data = $this->courseForCycle();
                break;
            case 'herramientas-pedagogicas':
                $data = $this->getLibrary('Herramientas Pedagogicas');
                break;
            case 'datos-abiertos':
                $data = $this->getLibrary('Datos Abiertos');
                break;
            case 'socialService':
                $data = $this->getCoursesSocialService();
                break;
            default:
                $data = $this->getOptions($this->data['getData']);
                break;
        }
        return $data;
    }

    public function getAlliances()
    {
        return Alliance::orderBy('order')->get();
    }

    public function getSliderCourses()
    {
        $today = now();
        return Course::where('start_date', '<=', $today)
        ->where('end_date', '>=', $today)
        ->take(8)
        ->get();
    }

    public function getSliderCycles()
    {
        return Cycle::orderBy('name')->take(8)->get();
    }

    public function getConferences()
    {
        return Conference::select('id', 'name', 'slug', 'start_date', 'icon')->get();
    }

    public function getOptions($type)
    {
        return Option::where('type', $type)->get();
    }

    public function getLibrary($type)
    {
        return Library::where('type', $type)->get();
    }

    public function getCourses()
    {
        $today = now();
        return Course::where('start_date', '<=', $today)->where('end_date', '>=', $today)->get();
    }

    public function getCoursesSocialService(){
        return Course::where('social_service', true)->get();
    }

    public function getCycles()
    {
        return Cycle::get();
    }

    public function courseForCycle()
    {
        $slug = Route::current()->parameter('slug');
        return Cycle::where('slug', $slug)->first()->courses;
    }
}