Help Query Sum

Question

Help Query Sum

Navigation

#1 by (1 votes)
#2 by (1 votes)

0

I'm trying to retrieve a column and make a sum - using SUM - according to the time range, but without success. Can you help me with this question?

Detail: I'm not exactly using a table, but I call a function in SQL . The application works well with this function.

Function executed:

Followthesliceofthecontroller

publicfunctionabertura(Request$request,$carteira,$dia,$servico,$segmento){$servico=$servico=='NULL'?null:$servico;$segmento=$segmento=='NULL'?null:$segmento;$data=Date::createFromFormat('Y-m-d',$dia,tz());$servicos=Receptivo::makeSegmento($data->format('Ymd'),$carteira)->orderByRaw('REPLACE(REPLACE(REPLACE(REPLACE(NOME_SERVICO,\'SANTANDER_IN_VAREJO_\',\'\'),\'IN_\',\'\'),\'SERVICE_\',\'\'),\'VAREJO_\',\'\')')->get();$segmentos=Receptivo::makeSegmentoServico(ucfirst(strtolower($carteira)))->selectRaw('distinctsegmento')->get();$datas=collect(range(0,90))->map(function($incremento){returnnow_tz()->copy()->subDays($incremento);});$receb=Receptivo::makeAbertura($data->format('Ymd'),$carteira,$servico,$segmento)->orderBy('Faixa_Horario')->get();//Soma$Query=Receptivo::where('Faixa_Horario','Faixa_Horario')->sum('Atendimento_Cliente_com_Negocio');returnview('reports.hora-a-hora.receptivo.abertura.index',compact('carteira','receb','datas','data','servico','servicos','segmento','segmentos','Query'));}

Excerptfromthemodel:

publicstaticfunctionmakeAbertura($date,$carteira,$servico=null,$segmento=null){/**@varstatic$instance*/$instance=newstatic;$servico=$servico==null?'NULL':"'" . $servico . "'";

    $segmento = $segmento == null ? 'NULL' : "'" . $segmento . "'";

    $table = sprintf( 'FN_HORA_HORA_RECEPTIVO_SANTANDER_%s_ABERTURA(\'%s\', %s, %s)',
        $carteira,
        $date,
        $servico,
        $segmento
    );
    //dd($table);
    return $instance->setTable( $table );
}

query laravel-5 querybuilder

asked by anonymous 26.07.2018 / 00:57

2 answers

1

Marcelo Zapatta, it worked, I did it the following way.

 $receb = Receptivo::makeAbertura( $data->format( 'Ymd' ), $carteira, $servico, $segmento )
        ->whereIn('FAIXA_HORARIO', range(8, 20))
        ->groupBy('FAIXA_HORARIO')
        ->selectRaw('FAIXA_HORARIO, SUM(ATENDIMENTO_COM_NEGOCIO) AS SOMA')
        ->orderBy('FAIXA_HORARIO')
        ->get();

27.07.2018 / 22:01

PHP MVC - How to execute Model methods? Send form without knowing the name

score 1 · Accepted Answer

To give sum you have to have applied the function get before

$Query = Receptivo::where('Faixa_Horario', 'Faixa_Horario')->get()->sum('Atendimento_Cliente_com_Negocio');

I do not understand why in your where is: where('Faixa_Horario', 'Faixa_Horario') in the second parameter you must pass the value that you want to match in your where, eg

$Query = Receptivo::where('Faixa_Horario', 8)->get()->sum('Atendimento_Cliente_com_Negocio');