This forum has moved to a new location and is in read-only mode. Please visit talk.octobercms.com to access the new location.

Akhil
Akhil

I have written a script to get theses rows but i am unable to put where condition for its attachment 'image'.

       $modelMusicCurrent = modelMusicCurrent::select('id','name','alias','created_at')
                        ->where('published', '=', 1)
                        ->where('is_trending', '=', 1)
                        ->where('is_deleted', '=', 0);

Last updated

daftspunky
daftspunky

Use

->has('images')
Akhil
Akhil

How can i use orderBy for both Tables in has and master and where condition for "Has" too. Basically i want to use Where, OrderBy, and Limit with "Has" Realstionship output.

$modelTvShowHomeList = modelTvShow::where('published', '=', 1)
                                ->where('is_deleted', '=', 0)
                                ->orderBy('published_on', 'desc')
                                ->has('tvseasons')
                                ->skip(0)
                                ->take(4);

Last updated

Akhil
Akhil

NOt working "Has" Limit anf Order BY ........

    $modelTvShowHomeList = modelTvShow::where('published', '=', 1) 
     ->where('is_deleted', '=', 0) 
     ->orderBy('published_on', 'desc') 
     ->orWhereHas('tvseasons', function($q){ 
      $q->where('published', '=', 1)->orderBy('id', 'DESC')->skip(0)->take(1); 
     }) 
     ->skip(0) 
     ->take(4) 
     ->get();
Akhil
Akhil

So finally some how ....taken the help from Laravel ............to find the solution.

                modelTvShow::where('published', '=', 1)
                                ->where('is_deleted', '=', 0)
                                ->orderBy('published_on', 'desc')
                                ->with(array('tvseasons' => function($s){
                                    $s->where('published', '=', 1)
                                    ->where('is_deleted', '=', 0)
                                    ->orderBy('published_on', 'desc')
                                    ->with(array('tvepisodes' => function($e){
                                        $e->where('published', '=', 1)
                                        ->where('is_deleted', '=', 0)
                                        ->orderBy('published_on', 'desc')
                                        ->skip(0)->take(3);
                                    }))->skip(0)->take(1);
                                }))->skip(0)->take(4)->get();

Last updated

1-5 of 5

You cannot edit posts or make replies: the forum has moved to talk.octobercms.com.