Subquery in laravel query builder

Question

How could I do this query in laravel:

SELECT * FROM(
SELECT * FROM `tb_horario` where cod_funcionario="'.$cod.'" and deleted_at is null)
AS temp
where temp.motivo!='' or temp.validado=0

but sometimes I dont have to use cod_funcionario because is a filter in my page

so I've something like:

if ($funcionario)
        {               
            $horariosQuery->where('cod_funcionario', $funcionario);
        }

I dont know how to do this query with this subquery in laravel like I did in sql. thxx!

Yeah I'm trying to do something like, but I'm not sure where I put that filter, in whereIn before the subquery or inside the subquery — Lucas Campos
– Lucas Campos, Commented Apr 28, 2014 at 14:01
Also, I don't understand why you need a subquery here. Why can't you AND temp.motivo!='' or temp.validado=0? — Sergiu Paraschiv
– Sergiu Paraschiv, Commented Apr 28, 2014 at 14:03
because if I dont filter "cod_funcionario" I select extra data, because it can be or "validado" or "motivo!=''" and if I dont select "funcionario" before I get data from other employee because of the OR — Lucas Campos
– Lucas Campos, Commented Apr 28, 2014 at 14:16
Then what you need to read is this: stackoverflow.com/questions/16995102/… — Sergiu Paraschiv
– Sergiu Paraschiv, Commented Apr 28, 2014 at 14:19

Lucas Campos · Accepted Answer · 2014-04-28 15:02:49Z

1

 $horariosQuery = $this->horario->with(array('funcionario', 'item_contabil'))
                              ->whereNull('deleted_at')
                              ->orderby('cod', 'ASC');

        if ($funcionario)
        {               
            $horariosQuery->where('cod_funcionario', $funcionario)
                          ->where(function ($query) {
                                $query->where('validado', 0)
                                      ->orWhere('motivo', '!=', '');
                            })
                          ->orderBy('data');
        }
        else
        {
            $horariosQuery->where('validado', 0)
                          ->orWhere('motivo', '<>', '')
                          ->orderBy('cod_funcionario');
        }

answered Apr 28, 2014 at 15:02

Lucas Campos

5153 gold badges9 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

Subquery in laravel query builder

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related