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;
*/
}
