<?php

namespace App\Http\Livewire;

use Livewire\Component;
use Livewire\WithPagination;
use App\Models\Notificacion;
use DB;

class Adminnotificaciones extends Component{

    use WithPagination;

    protected $paginationTheme = 'bootstrap';

    public $leidos,$noleidos;

    public function render(){



        $notificaciones=Notificacion::select(
            DB::raw('DISTINCT(data)'))->paginate(20);

        return view('livewire.adminnotificaciones',["notificaciones"=>$notificaciones]);
    }

    public function estados($data){

        $this->leidos=DB::table('notifications as no')
            ->join('users as us','no.notifiable_id','us.id')
            ->select('no.*','us.name')
            ->where('data','LIKE','%'.$data.'%')->whereNotNull('read_at')->get();

        $this->noleidos=DB::table('notifications as no')
            ->join('users as us','no.notifiable_id','us.id')
            ->select('no.*','us.name')
            ->where('data','LIKE','%'.$data.'%')->whereNull('read_at')->get();
    }
}