<?php

namespace App\Http\Livewire;

use Livewire\Component;
use Livewire\WithPagination;
use Auth;
use DB;

class Missolicitudes extends Component{

    use WithPagination;

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

    protected $paginationTheme = 'bootstrap';

    public $buscar='';

    public function render(){

        $solicitudes=DB::table('canjeproductos as cp')
            ->join('catalogos as c','cp.producto_id','c.id')
            ->join('canjes as ca','cp.canje_id','ca.id')
            ->select('cp.*','c.nombre')
            ->where('ca.usuario_id',Auth::user()->id)
            ->where('c.nombre','LIKE',"%{$this->buscar}%")->paginate(20);

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