Laravel create Query SQL

Question

I need help to create my query. I created the following query in SQL

SELECT id_funcionario, MAX(created_at) from irs GROUP by id_funcionario

I try to switch to Larevel but I'm wrong and I can't put the groupby

    $irs = irs::join('utilizadors','utilizadors.id','=', 'irs.id_funcionario')
    ->MAX('created_at')
   
    ->get([ 'utilizadors.id', 'utilizadors.nome', 'irs.id', 'irs.id_funcionario','irs.created_at', 'irs.dependentes', 'irs.titulares_rendimento', 'irs.situacoes_especiais']);
    return view('irs-total', ['itens' => $irs]);

Why are you calling ::join() when your original SQL doesn't have any kind of JOIN ... clause? I would expect the correct syntax would be something like irs::select(['id_funcionario', DB::raw('MAX(created_at)'])->groupBy('id_funcionario')->get(). If you need to verify, replace ->get() with ->toSql() to see the generated SQL. — Tim Lewis
– Tim Lewis, Commented Apr 4, 2022 at 20:49

Ibrahim Hammed · Accepted Answer · 2022-04-04 20:56:08Z

1

Try this:

use Illuminate\Support\Facades\DB;

 $irs = DB::table('irs')
             ->join('utilizadors','utilizadors.id','=', 'irs.id_funcionario')
             ->select(DB::raw('irs.created_at'), 'utilizadors.id', 
                'utilizadors.nome', 'irs.id', 'irs.id_funcionario','irs.created_at', 
                'irs.dependentes', 'irs.titulares_rendimento', 
                'irs.situacoes_especiais')
             // add your groupBy data
             ->groupBy('')
             ->get();

answered Apr 4, 2022 at 20:56

Ibrahim Hammed

9201 gold badge10 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Tim Lewis Over a year ago

Why DB::table('irs')? They have a model irs.

Ibrahim Hammed Over a year ago

I think it's the first table he's trying to join with utilizadors

Tim Lewis Over a year ago

You're missing the point of that comment; if they have a Model irs, you should encourage using it instead of DB::table('irs'), so irs::join(...)->select(...) and so on.

Collectives™ on Stack Overflow

Laravel create Query SQL

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related