Eloquent Count + Group By + Inner join

Question

Eloquent Count + Group By + Inner join

Navigation

#1 by (1 votes)

0

I am having some problems with the queries in the ORM-Eloquent, I have integrated eloquent in codeigniter, I am trying to make the following query:

SELECT tp.*, COUNT(*) as cuenta
FROM tipo_llamadas tp
INNER JOIN encuestas e ON tp.id = e.id_tipo_llamada
WHERE e.id_oleada = 1
GROUP BY tp.id

The result is the following:

id  | nombre       | cuenta
---------------------------
1   | Información  | 3
2   | Recogida     | 1

But I can not get it out, I have taken the following query, but I need to get the INNER JOIN with tipo_llamadas to get their names:

Encuesta::selectRaw('*, count(*) as cuenta')
           ->groupBy('id_tipo_llamada')
           ->get()
           ->toArray();

mysql php orm laravel-5

asked by PriNcee 15.12.2016 в 16:52

source

1 answer

C ++ POO The variable is not displayed correctly Hide ListView items in android and refresh onClick event

score 1 · Answer 1

In eloquent you have join () to do inner join

Modelo_tipo_llamadas::selectRaw('tipo_llamadas.*, count(*) as cuenta')
            ->join('encuestas e', 'tipo_llamadas.id', '=', 'e.id_tipo_llamada')
            ->where('e.id_oleada', '=', 1)
            ->groupBy('tipo_llamadas.id')
            ->get();

You can also build the query without the model:

$var = DB::table('tipo_llamadas tp')
        ->selectRaw('tp.*, count(*) as cuenta')
        ->join('encuestas e', 'tp.id', '=', 'e.id_tipo_llamada')
        ->where('e.id_oleada', '=', 1)
        ->groupBy('tp.id')
        ->get();