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]);

user_9077347 · Answer

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();

Laravel create Query SQL

1 Answers