File: /var/www/html/performance.sumar.com.py/app/Http/Livewire/Respuestas.php
<?php
namespace App\Http\Livewire;
use Livewire\Component;
use App\Models\Asignacion;
use Livewire\WithPagination;
use Illuminate\Support\Facades\Auth;
use DB;
class Respuestas extends Component{
use WithPagination;
protected $queryString = ['buscar' => ['except' => '']];
protected $paginationTheme = 'bootstrap';
public $buscar='';
public $contestado;
public function render(){
$asignaciones=DB::table('asignacions as a')
->join('users as u','a.evaluador_id','u.id')
->join('users as us','a.evaluado_id','us.id')
->join('evaluacions as e','a.evaluacion_id','e.id')
->select('a.id','a.updated_at as fecha','us.name as evaluado','e.eva_nom as evaluacion','a.evaluacion_id','a.asi_estado','a.asi_fecha_limite')
->where('u.id',Auth::user()->id)
->where('a.asi_estado',$this->contestado)
->where('us.name','LIKE',"%{$this->buscar}%")->paginate(50);
return view('livewire.respuestas.index',["asignaciones" => $asignaciones]);
}
}