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]);
}
