public function Home() { $channel = \Model\Channel\ModelName::name('birinchi')->first(); $lc = app()->getlocale(); if ($lc == 'kg') { $generalPosts = \Model\Post\ModelName::where('birinchi', '=', 1)->where('general', '=', '1')->languagekg()->take(3)->orderBy('id', 'desc')->get(); } else { $generalPosts = \Model\Post\ModelName::where('birinchi', '=', 1)->where('general', '=', '1')->languageru()->take(3)->orderBy('id', 'desc')->get(); } $photoGalleries = \Model\PhotoParent\ModelName::where('birinchi', '=', '1')->where('published', '=', true)->take('6')->orderBy('id', 'desc')->get(); $categoryArray = array(); $lc = app()->getlocale(); if ($lc == 'kg') { $allPost = \Model\Post\ModelName::where('birinchi', '=', 1)->where('birinchiProgram', '<>', '1')->languagekg()->take(10)->skip(0)->published()->orderBy('id', 'desc')->get(); foreach ($allPost as $key => $value) { $category = \Model\Category\ModelName::where('id', '=', $value->category_id)->first(); $categoryArray[] = $category; } } else { $allPost = \Model\Post\ModelName::where('birinchi', '=', 1)->where('birinchiProgram', '<>', '1')->languageru()->take(10)->skip(0)->published()->orderBy('id', 'desc')->get(); foreach ($allPost as $key => $value) { $category = \Model\Category\ModelName::where('id', '=', $value->category_id)->first(); $categoryArray[] = $category; } } $lc = app()->getlocale(); if ($lc == 'kg') { $birinchiProjects = \Model\Project\ModelName::where('published', '=', true)->where('birinchi', '=', 1)->where('name', '<>', '')->get(); } else { $birinchiProjects = \Model\Project\ModelName::where('published', '=', true)->where('birinchi', '=', 1)->where('nameRu', '<>', '')->get(); } $backgroundMain = \Model\Background\ModelName::where('published', '=', true)->first(); return view('Front::channel.birinchi.index', ['channel' => $channel, 'backgroundMain' => $backgroundMain, 'generalPosts' => $generalPosts, 'allPost' => $allPost, 'birinchiProjects' => $birinchiProjects, 'categories' => $categoryArray, 'photoGalleries' => $photoGalleries]); }
public function filterResultCategory(Request $request) { $category_id = $request->category; $category = \Model\Category\ModelName::where('id', '=', $category_id)->first(); $lc = app()->getlocale(); $df = $request->dateFrom; $dt = $request->dateTo; $dateFrom = date('Y-m-d', strtotime($df)); $dateTo = date('Y-m-d', strtotime($dt)); $perPage = 10; $categories = \Model\Category\ModelName::all(); $backgroundMain = \Model\Background\ModelName::where('published', '=', true)->first(); if ($lc == 'kg' and $df != '' and $dt != '') { $postAllFromTo = \Model\Post\ModelName::published()->where('category_id', '=', $category_id)->datefromkg($df)->datetokg($dt)->orderBy('id', 'desc')->paginate($perPage); } elseif ($lc == 'kg' and $df != '') { $postAllFromTo = \Model\Post\ModelName::published()->where('category_id', '=', $category_id)->datefromkg($df)->orderBy('id', 'desc')->paginate($perPage); } elseif ($lc == 'kg' and $dt != '') { $postAllFromTo = \Model\Post\ModelName::published()->where('category_id', '=', $category_id)->datetokg($dt)->orderBy('id', 'desc')->paginate($perPage); } elseif ($lc == 'ru' and $df != '' and $dt != '') { $postAllFromTo = \Model\Post\ModelName::published()->where('category_id', '=', $category_id)->datefromru($df)->datetoru($dt)->orderBy('id', 'desc')->paginate($perPage); } elseif ($lc == 'ru' and $df != '') { $postAllFromTo = \Model\Post\ModelName::published()->where('category_id', '=', $category_id)->datefromru($df)->orderBy('id', 'desc')->paginate($perPage); } elseif ($lc == 'ru' and $dt != '') { $postAllFromTo = \Model\Post\ModelName::published()->where('category_id', '=', $category_id)->datetoru($dt)->orderBy('id', 'desc')->paginate($perPage); } else { $postAllFromTo = \Model\Post\ModelName::published()->where('category_id', '=', $category_id)->orderBy('id', 'desc')->paginate($perPage); } return view('Front::category.index', ['perPage' => $perPage, 'category' => $category, 'posts' => $postAllFromTo, 'categories' => $categories, 'backgroundMain' => $backgroundMain]); }
public function news(\Model\Post\ModelName $post) { $post->incrementViewed(); $channel = \Model\Channel\ModelName::name('birinchi')->first(); $backgroundMain = \Model\Background\ModelName::where('published', '=', true)->first(); $lc = app()->getlocale(); if ($lc == 'kg') { $birinchiProjects = \Model\Project\ModelName::where('published', '=', true)->where('birinchi', '=', 1)->where('name', '<>', '')->get(); } else { $birinchiProjects = \Model\Project\ModelName::where('published', '=', true)->where('birinchi', '=', 1)->where('nameRu', '<>', '')->get(); } if ($lc == 'kg') { $allPost = \Model\Post\ModelName::where('birinchi', '=', 1)->where('birinchiProgram', '<>', '1')->languagekg()->take(10)->skip(0)->published()->orderBy('id', 'desc')->get(); foreach ($allPost as $key => $value) { $category = \Model\Category\ModelName::where('id', '=', $value->category_id)->where('titleRu', '<>', '')->first(); $categories[] = $category; } } else { $allPost = \Model\Post\ModelName::where('birinchi', '=', 1)->where('birinchiProgram', '<>', '1')->languageru()->take(10)->skip(0)->published()->orderBy('id', 'desc')->get(); foreach ($allPost as $key => $value) { $category = \Model\Category\ModelName::where('id', '=', $value->category_id)->where('titleRu', '<>', '')->first(); $categories[] = $category; } } return view('Front::channel.birinchi.news', ['channel' => $channel, 'post' => $post, 'backgroundMain' => $backgroundMain, 'birinchiProjects' => $birinchiProjects, 'categories' => $categories]); }