mardi 17 avril 2018

Laravel wherebetween with orwherebetween

I have written laravel query.in this query i am using wherebetween and orwherebetween.also one where statement column named 'shareable' which should return the rows equal to one.but this query does not takes where condition into consideration.it tooks only wherebetween and orwherebetweens.what can be the reason.

my query

$childs = Program::whereIn('id', $programs_by_date)
                ->where('shareable', '=','1')
                ->wherebetween('starting_date', [$new_start_date,$new_end_date])
                ->orwherebetween('ending_date', [$new_start_date,$new_end_date])
                ->orderBy('starting_date')
                ->get(); 

->where('shareable', '=','1') this returns 0 value rows also.what can be the reason.'shareable' type is enum



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire