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; }
private function xtestMorph() { //http://stackoverflow.com/questions/33189347/get-data-from-polymorphic-relations-with-namespaces //$medium->translations[$key]->{$medium_type.'s'}->update //STORE //https://laracasts.com/discuss/channels/eloquent/multiple-polymorphic-relationships-with-the-same-controller $u = collect(['provider' => 'updateproviderNEW1234']); $this->testUpdate(121, $u); //image $u = collect(['application' => 'updateApplicationNEW1234']); $this->testUpdate(122, $u); //file dc(Media\Image::class); dc(Media\File::class); dc(Media\Video::class); return "views"; $mt = Mediatranslation::find(121); //image $u = collect(['provider' => 'updateproviderNEW']); dc($mt->mediable()->update($u->all())); $this->testUpdate(121, $u); //image $u = collect(['application' => 'updateApplicationNEW']); $this->testUpdate(122, $u); //file $mt1 = MediaTranslation::find(122); //file //dc($mt1); $u = collect(['application' => 'updateApplicationNEW']); dc($mt1->mediable()->update($u->all())); //$mt = Mediatranslation::with(['mediable'])->where('id',121)->first(); //dc($mt->mediable); $mt1 = Mediatranslation::with(['mediable'])->where('id', 122)->first(); dc($mt1->mediable); $mt1 = Mediatranslation::with(['mediable'])->where('id', 121)->first(); dc($mt1->mediable); return "view"; $test = Mediatranslation::with(['image'])->where('id', 121)->get()->all(); //dc($test); $img = Image::with(['media'])->get(); //dc($img); foreach ($img as $image) { // dc($image->media); } return 'view'; return "view"; //$mt = Mediatranslation::with('mediable')->get(); $mt = Mediatranslation::with('mediable')->whereIn('id', ['121', '122'])->get(); foreach ($mt as $t) { //dc($t->mediable->orientation); dc(class_basename($t->mediable)); } //dc($mt->first()->mediable); return "view"; $mt = Mediatranslation::with('mediable')->whereIn('id', ['121', '122']); dc($mt->get()); return "view"; $media = Media::find(31); $media = $media->translation->mediable(); dc($media->getResults()); dc('-----'); $mediaTranslation = MediaTranslation::find(122); //dc($mediaTranslation); $mediable = $mediaTranslation->mediable(); dc($mediable->getResults()); $image = Image::find(62); dc($image->media()->getResults()); //foreach ($staff->photos as $photo) { // //} return "view"; }