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/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]);
    }

}