public function getAllMediaByActiveLocaleAndType($type) { $input = ""; $media = Media::with('translations.locale')->with(array('translations' => function ($query) use($input) { $query->whereHas('locale', function ($q) { // ...1 subquery to filter the active locales $q->where('status', '<>', 'disabled'); }); }, 'translations.' . $type . 's', 'created_by_user'))->with(array('translations' => function ($q1) { // 1 query for template of the sitemap with nested collections $q1->whereHas('locale', function ($q2) { // ...1 subquery to filter locale by active language $q2->where('identifier', '' . app()->getLocale() . ''); }); }))->where('media_type', '' . $type . '')->get(); //dc($media->first()->translations); return $media; }
/** * @return \Illuminate\Database\Eloquent\Builder|static */ public function getElqMediaTranslationAsBO() { $media = Media::with(['translation']); return $media; //\Illuminate\Database\Eloquent\Collection|static }