public function ___getAllMediaByType() { //Media->translation->[users,images] $input = ""; $media = Media::join('mediatranslations', 'mediatranslations.media_id', '=', 'media.id')->where('mediatranslations.locale_id', auth()->user()->locale->id)->where('media_type', 'image')->with('created_by_user', 'translations.created_by_user', 'translations.updated_by_user', 'translations.images')->with(array('translations' => function ($query) use($input) { $query->where('locale_id', 4); /*$query->whereHas('locale', function ($q) { // ...1 subquery to filter the active locales $q->where('name', ''.app()->getLocale().''); });*/ }))->orderBy('mediatranslations.media_id', 'desc')->select(['media.*'])->paginate(); }
public function getQBMediaTranslation() { //return (Media::with(['translation'])); // \Illuminate\Database\Eloquent\Builder|static //return (Media::all()); // \Illuminate\Database\Eloquent\Collection|static[] //return (DB::table('media')); // \Illuminate\Database\Query\Builder //return (DB::table('media')->get()); // array|static[] //dc(DB::table('media')); // \Illuminate\Database\Query\Builder //$media = (Media::join('mediatranslations as mt','media.id','=','mt.media_id')); //return (Media::with(['translation'])); // \Illuminate\Database\Eloquent\Builder|static // \---- with: \Illuminate\Database\Query\Builder // \---- with: \App\Media // (($test = Media::with(['translation'])->find(31))); //dc($test->getRelations()); // \Illuminate\Database\Eloquent\Collection|static[] // \---- with: array|static[] // \---- ----- with: App\Media (ORM) (relations) // \---- ----- ----- with: relations //return (DB::table('media')); // \Illuminate\Database\Query\Builder //return (DB::table('media')->get()); // array|static[] //return (Media::join('mediatranslations as mt','media.id','=','mt.media_id')); // mixed: // \Illuminate\Database\Eloquent\Builder // \---- with: \Illuminate\Database\Query\Builder // \---- with: \App\Media //return (Media::join('mediatranslations as mt','media.id','=','mt.media_id')->get()); // mixed: // \Illuminate\Database\Eloquent\Collection // \---- with: array|static[] // \---- ----- with: App\Media (StdClass) return Media::join('mediatranslations as mt', 'media.id', '=', 'mt.media_id')->find(31); //return "a"; /*dc(Media::all()); dc(DB::table('media')->find(31)); dc(DB::table('media')->get()); return "view"; $media = DB::table('media')->join('mediatranslations as mt','media.id','=','mt.media_id'); dc($media->get()); $media = (Media::join('mediatranslations as mt','media.id','=','mt.media_id')); dc($media->get()); */ /* * //$media = Media::join('mediatranslations as mt','media.id','=','mt.media_id'); //dc(Media::class); return $media; */ }