<?php

namespace App\Http\Livewire;

use Livewire\Component;
use App\Models\Mision;
use App\Models\Matricula;
use App\Models\Equipo;
use Livewire\WithPagination;
use Auth; 
use DB; 
use Carbon\Carbon; 

class FronMisiones extends Component{

	use WithPagination;

    protected $paginationTheme = 'bootstrap';

    public $anho;
    public $mes;
    public $MisionMode = true;

    public function mount(){
        $this->anho = Carbon::now()->format('Y');
    }

    public function render(){

    	$matricula = Matricula::where('usuario_id',Auth::id())->first();

    	$equipo = Equipo::findOrFail($matricula->equipo_id);

    	$misiones = DB::table('mision_matriculas as mm')
    		->join('misions as m','mm.mision_id','m.id')
    		->join('equipos as e','mm.equipo_id','e.id')
    		->select('m.id','m.titulo','m.descripcion','m.puntos','m.puntos_extras','m.fecha_limite')
    		->where('e.id',$equipo->id)
            ->whereMonth('m.fecha_limite','=',$this->mes)
            ->whereYear('m.fecha_limite','=',$this->anho)
    		->paginate(20);

        return view('livewire.misionesfront.fron-misiones',["misiones" => $misiones]);
    }

    public function selectmes($mes){
        $this->MisionMode = false;
        $this->mes=$mes;
        
    }
    public function volver(){
        $this->mes = '';
        $this->MisionMode = true;
        
    }
}