<?php

namespace App\Http\Livewire;

use Livewire\Component;
use Livewire\WithPagination;
use Illuminate\Support\Facades\DB;

class Control extends Component{
    
    use WithPagination;

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

    protected $paginationTheme = 'bootstrap';

	public $buscar='';
    
    public function render(){

        $control = DB::table('monedaparticipantes as m')
            ->join('users as u','m.usuario_id','u.id')
            ->select(DB::raw('sum(m.monedas) as totalmonedas,count(m.desafio_id) as totaldesafios,u.name'))
            ->where('u.name','LIKE',"%{$this->buscar}%")
            ->groupBy('u.name')
            ->orderByRaw('SUM(m.monedas) DESC')->paginate(20);

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