/**
* Show the application dashboard to the user.
*
* @return Response
*/
public function Home()
{
$lc = app()->getlocale();
$channel = \Model\Channel\ModelName::general();
if ($lc == 'kg') {
$generalPosts = \Model\Post\ModelName::general($channel)->published()->languagekg()->take(6)->skip(0)->orderBy('id', 'desc')->get();
$projects = \Model\Project\ModelName::having('name', '<>', '')->get();
} elseif ($lc == 'ru') {
$generalPosts = \Model\Post\ModelName::general($channel)->published()->languageru()->take(6)->skip(0)->orderBy('id', 'desc')->get();
$projects = \Model\Project\ModelName::where('nameRu', '<>', '')->get();
}
$rDayVideo = \Model\Media\ModelName::having('dayVideo', '=', '1')->take(1)->skip(0)->orderBy('created_at', 'desc')->first();
if ($rDayVideo != null) {
$dayVideo = $rDayVideo;
} elseif ($rDayVideo == null) {
$dayVideoResult = \Model\Media\ModelName::take(1)->skip(0)->orderBy('id', 'desc')->first();
if ($dayVideoResult != null) {
$dayVideo = $dayVideoResult;
} else {
$dayVideo = 'KhJUlC4aJZM';
}
}
$backgroundMain = \Model\Background\ModelName::where('published', '=', true)->first();
$peopleReporters = \Model\PeopleReporter\ModelName::where('published', '=', true)->get();
// FotoParent - photo gallery
$photoParent = \Model\PhotoParent\ModelName::where('published', '=', true)->first();
if ($photoParent != null) {
$images = json_decode($photoParent->images);
// array of images
} else {
$images = 1;
}
$MediaCategories = \Model\MediaCategory\ModelName::get();
$mediaPosts = \Model\Media\ModelName::orderBy('id', 'desc')->get();
$categoriesVideos = array();
foreach ($MediaCategories as $MediaCategory) {
$CategoryVideos = \Model\Media\ModelName::where('videoType', '=', $MediaCategory->videoType)->orderBy('id', 'desc')->take(9)->get();
$categoriesVideos = array_add($categoriesVideos, $MediaCategory->videoType, $CategoryVideos);
}
$mediaLastVideos = \Model\Media\ModelName::orderBy('id', 'desc')->take(9)->get();
return view('Front::home', ['images' => $images, 'generalPosts' => $generalPosts, 'dayVideo' => $dayVideo, 'positionTop' => $this->positionTop, 'positionRight' => $this->positionRight, 'positionCenter' => $this->positionCenter, 'positionBottom' => $this->positionBottom, 'peopleReporters' => $peopleReporters, 'backgroundMain' => $backgroundMain, 'MediaCategories' => $MediaCategories, 'categoriesVideos' => $categoriesVideos, 'mediaLastVideos' => $mediaLastVideos, 'projects' => $projects]);
}
