How to query Sql in eloquent laravel?

Question

How to query Sql in eloquent laravel?

Navigation

#1 by (1 votes)

0

I have a query on MySQl:

SELECT E.EXPE_varHR,E.EXPE_varDescripcion, 
T.TIPO_varDenominacion,T.TIPO_booSAP, (SELECT SUM(EXPE_intDiasTramite) 
FROM gen_expedientes EX INNER join gen_tipos TT on 
EX.TIPO_intId=TT.TIPO_intId WHERE EX.EXPE_varRaizHR=E.EXPE_varRaizHR and 
TT.TIPO_booSAP=1) as 'Sumado'
from gen_expedientes E INNER JOIN gen_tipos T ON 
E.TIPO_intId=T.TIPO_intId

and I would like to know how to pass it to eloquent, basically how to make that subquery

((SELECT SUM (EXPE_intDiasTramite) FROM gen_expedientes EX INNER join gen_types TT on EX.TIPO_intId = TT.TIPO_intId WHERE EX.EXPE_varRaizHR = E.EXPE_varRaizHR and TT.TIPO_booSAP = 1) as 'Added')

in eloquent

mysql laravel eloquent

asked by hans 26.06.2018 в 15:20

source

1 answer

show new items through ajax if the login is correct Pass the value of a Label to another aspx page with c #

score 1 · Answer 1

If someone has a similar question, I'll let you know how to solve it: Use the DB :: RAW

$ListaIngresos=\DB::table('gen_expedientes as E')
                      ->join('gen_tipos as T','E.TIPO_intId','=','T.TIPO_intId')
                      ->select('E.*','T.TIPO_varSiglas','T.TIPO_booSAP',
                        \DB::raw('(SELECT SUM(EXPE_intDiasTramite) FROM gen_expedientes EX INNER join gen_tipos TT on EX.TIPO_intId=TT.TIPO_intId WHERE EX.EXPE_varRaizHR=E.EXPE_varRaizHR and TT.TIPO_booSAP=1) as Sumado'))
                      ->get();
      return $ListaIngresos;

it was just adding.

DB :: raw ('(SELECT SUM (EXPE_intDiasTramite) FROM gen_expedientes EX INNER join gen_types TT on EX.TIPO_intId = TT.TIPO_intId WHERE EX.EXPE_varRaizHR = E.EXPE_varRaizHR and TT.TIPO_booSAP = 1) as added ')