Advertisement
bulfaitelo

SELECT grou By week

Dec 11th, 2018
180
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.15 KB | None | 0 0
  1. $rows =  AtivosExtrato::select(
  2.                 'titulo_id',
  3.                 DB::raw('SUM(valor_bruto_atual) AS valor'),
  4.                 'data_imports.data_import as created_at',
  5.                 DB::raw('WEEK(data_imports.data_import) AS weeknumber')
  6.             )
  7.             ->join('titulos','titulo_id', '=', 'titulos.id' )
  8.             ->join('representantes','representante_id', '=', 'representantes.id' )
  9.             ->join('data_imports','data_import_id', '=', 'data_imports.id' )
  10.             ->where('user_id', Auth::user()->id)
  11.             ->whereIn('ativos_extratos.data_import_id',
  12.             DataImport::Select(DB::raw('max(ID)'))
  13.                 ->whereBetween('data_import',  [$request->input('start_date'), $request->input('end_date')])
  14.                 ->groupBy(db::raw('Week(data_import)'))            )
  15.                 ->whereBetween('data_imports.data_import', [$request->input('start_date'), $request->input('end_date')])
  16.             ->groupBy('titulos.nome_titulo')
  17.             ->groupBy('weeknumber')            
  18.             ->orderBy('data_import')            
  19.             ->orderBy('titulos.nome_titulo')
  20.             ->get();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement