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.!']);
}
}