HEX
Server: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/8.0.30
System: Linux multiplicar 3.10.0-1160.102.1.el7.x86_64 #1 SMP Tue Oct 17 15:42:21 UTC 2023 x86_64
User: root (0)
PHP: 8.0.30
Disabled: NONE
Upload Files
File: /var/www/html/performance.sumar.com.py/app/Http/Livewire/Tableroasignaciones.php
<?php

namespace App\Http\Livewire;

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

class Tableroasignaciones extends Component{
    use WithPagination;

	protected $queryString = ['buscar' => ['except' => '']];

    protected $paginationTheme = 'bootstrap';

	public $buscar='';

	public $empresa_id,$updatefecha;

    public function render(){

    	$asignaciones=DB::table('usuariotableros as a')
	    	->join('users as u','a.evaluador_id','u.id')
	    	->join('users as us','a.evaluado_id','us.id')
	    	->join('empresas as em','a.empresa_id','em.id')
	    	->select('a.id','a.asi_estado as estado','u.name as evaluador','us.name as evaluado')
	    	->where('a.empresa_id',$this->empresa_id)
	    	->where('u.name','LIKE',"%{$this->buscar}%")->paginate(50);
        return view('livewire.tableroasignaciones',["asignaciones" => $asignaciones]);
    }

    public function delete($id){
        $asignacion = Usuariotablero::find($id);
        $asignacion->delete();
        $this->emit('alert', ['type' => 'error', 'message' => '¡La asignación se elimino correctamente.!']);
    }
}