<?php

namespace App\Http\Livewire;

use Livewire\Component;
use App\Models\Emoticon;
use DB;

class Reaccionescursocontador extends Component{

    public $capsula_id;

    public function render(){

        $megusta = Emoticon::where('emocion','me-gusta')->where('capsula_id',$this->capsula_id)->count();
        $meencanta = Emoticon::where('emocion','me-encanta')->where('capsula_id',$this->capsula_id)->count();
        $medivierta = Emoticon::where('emocion','me-divierta')->where('capsula_id',$this->capsula_id)->count();
        $measombra = Emoticon::where('emocion','me-asombra')->where('capsula_id',$this->capsula_id)->count();
        $meentristece = Emoticon::where('emocion','me-entristece')->where('capsula_id',$this->capsula_id)->count();
        $meenoja = Emoticon::where('emocion','me-enoja')->where('capsula_id',$this->capsula_id)->count();

        $usuariosmegusta = DB::table('emoticons as e')
            ->join('users as u','e.usuario_id','u.id')
            ->select('u.name')
            ->where('emocion','me-gusta')
            ->where('capsula_id',$this->capsula_id)->get();
        $usuariosmeencanta = DB::table('emoticons as e')
            ->join('users as u','e.usuario_id','u.id')
            ->select('u.name')
            ->where('emocion','me-encanta')
            ->where('capsula_id',$this->capsula_id)->get();
        $usuariosmedivierta = DB::table('emoticons as e')
            ->join('users as u','e.usuario_id','u.id')
            ->select('u.name')
            ->where('emocion','me-divierta')
            ->where('capsula_id',$this->capsula_id)->get();
        $usuariosmeasombra = DB::table('emoticons as e')
            ->join('users as u','e.usuario_id','u.id')
            ->select('u.name')
            ->where('emocion','me-asombra')
            ->where('capsula_id',$this->capsula_id)->get();
        $usuariosmeentristece = DB::table('emoticons as e')
            ->join('users as u','e.usuario_id','u.id')
            ->select('u.name')
            ->where('emocion','me-entristece')
            ->where('capsula_id',$this->capsula_id)->get();
        $usuariosmeenoja = DB::table('emoticons as e')
            ->join('users as u','e.usuario_id','u.id')
            ->select('u.name')
            ->where('emocion','me-enoja')
            ->where('capsula_id',$this->capsula_id)->get();

        return view('livewire.reaccionescursocontador',['megusta'=>$megusta,'meencanta'=>$meencanta,'medivierta'=>$medivierta,'measombra'=>$measombra,'meentristece'=>$meentristece,'meenoja'=>$meenoja,'usuariosmegusta'=>$usuariosmegusta,'usuariosmeencanta'=>$usuariosmeencanta,'usuariosmedivierta'=>$usuariosmedivierta,'usuariosmeasombra'=>$usuariosmeasombra,'usuariosmeentristece'=>$usuariosmeentristece,'usuariosmeenoja'=>$usuariosmeenoja]);
    }
}