<?php

namespace App\Models;

use App\Traits\HasSortsTrait;
use Carbon\Carbon;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class EncuestaNps extends Model
{
    use HasFactory, HasSortsTrait;

    protected $table = 'encuestas_nps';

    protected $fillable = [
        'pregunta',
        'slug',
        'fecha_desde',
        'fecha_hasta',
        'retardo',
        'orden',
        'estado',
        'detractors',
        'passives',
        'promoters'
    ];


    protected $dates = [
        'created_at',
        'updated_at'
    ];

    protected $casts = [
        'created_at' => 'datetime:d-m-Y H:i:s',
        'updated_at' => 'datetime:d-m-Y H:i:s',
    ];

    public function scopeHabilitado($query)
    {
        $query->activo()
            ->where('fecha_desde', '<=', Carbon::now())
            ->where('fecha_hasta', '>=', Carbon::now()->subDay());
    }
}