Friday, April 14, 2017

Query clause with two whereIn

I try to run this query , all is good till :

->whereIn('statut_licence_id', ['1' , '4'])

this second whereIn seems to not work , it's display me only statut_licence_id = 1 and not also 4 , someone now how to resolve the problem ?

        $licencies = Licencies::whereIn('structure_id', $structures->pluck('id'))->whereIn('type_licence_id', ['1', '2', '3', '4', '5'])
            ->whereIn('statut_licence_id', ['1' , '4'])
            ->where('valid_licence_id', '1')
            ->where('lb_assurance_etat' ,'=' , 'Assurée')
            ->orderBy('created_at', 'DESC')
            ->paginate(10);



via Mathieu Mourareau

Advertisement