<?php

namespace App\Http\Livewire;

use Livewire\Component;
use Livewire\WithPagination;
use App\Models\Canje;
use App\Models\Canjeproductos;
use DB;

class Solicitudesadmin extends Component{

    use WithPagination;

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

    protected $paginationTheme = 'bootstrap';

    public $buscar='';

    public function render(){

        $canjes=DB::table('canjeproductos as cp')
            ->join('canjes as c','cp.canje_id','c.id')
            ->join('users as u','c.usuario_id','u.id')
            ->join('catalogos as ca','cp.producto_id','ca.id')
            ->select('u.name','ca.*','c.created_at as fecha','cp.monedas')
            ->where('u.name','LIKE',"%{$this->buscar}%")->paginate(20); 

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

}