/**
* Show the application dashboard to the user.
*
* @return Response
*/
public function Home()
{
$lc = app()->getlocale();
$channel = \Model\Channel\ModelName::general();
$channels = \Model\Channel\ModelName::take(8)->skip(1)->get();
if ($lc == 'kg') {
$generalPosts = \Model\Post\ModelName::general($channel)->published()->where('general', '=', '1')->languagekg()->take(6)->skip(0)->orderBy('number', 'asc')->get();
$projects = \Model\Project\ModelName::having('name', '<>', '')->get();
$directorPosts = \Model\Post\ModelName::where('director', '=', '1')->orderBy('id', 'desc')->take(3)->languagekg()->get();
$reporterPosts = \Model\Post\ModelName::where('reporter', '=', '1')->orderBy('id', 'desc')->take(15)->languagekg()->get();
} elseif ($lc == 'ru') {
$generalPosts = \Model\Post\ModelName::general($channel)->published()->where('general', '=', '1')->languageru()->take(6)->skip(0)->orderBy('number', 'asc')->get();
$projects = \Model\Project\ModelName::where('nameRu', '<>', '')->get();
$directorPosts = \Model\Post\ModelName::where('director', '=', '1')->orderBy('id', 'desc')->take(3)->languageru()->get();
$reporterPosts = \Model\Post\ModelName::where('reporter', '=', '1')->orderBy('id', 'desc')->take(15)->languageru()->get();
}
if ($lc == 'kg') {
$latestPosts = \Model\Post\ModelName::general($channel)->published()->where('general', '=', '1')->languagekg()->take(6)->skip(0)->orderBy('id', 'desc')->get();
} elseif ($lc == 'ru') {
$latestPosts = \Model\Post\ModelName::general($channel)->published()->where('general', '=', '1')->languageru()->take(6)->skip(0)->orderBy('id', 'desc')->get();
}
$dayVideo1 = \Model\Media\ModelName::where('dayVideo', '=', '1')->first();
$dayVideo2 = \Model\Media\ModelName::where('dayVideo', '=', '2')->first();
$dayVideo3 = \Model\Media\ModelName::where('dayVideo', '=', '3')->first();
$dayVideo4 = \Model\Media\ModelName::where('dayVideo', '=', '4')->first();
$dayVideo5 = \Model\Media\ModelName::where('dayVideo', '=', '5')->first();
if ($dayVideo1) {
$dayVideo1 = $dayVideo1;
} else {
$dayVideo1 = '';
}
if ($dayVideo2) {
$dayVideo2 = $dayVideo2;
} else {
$dayVideo2 = '';
}
if ($dayVideo3) {
$dayVideo3 = $dayVideo3;
} else {
$dayVideo3 = '';
}
if ($dayVideo4) {
$dayVideo4 = $dayVideo4;
} else {
$dayVideo4 = '';
}
$backgroundMain = \Model\Background\ModelName::where('published', '=', true)->first();
$peopleReporters = \Model\PeopleReporter\ModelName::where('published', '=', true)->get();
// Photo Gallery
$photoGalleries = \Model\PhotoParent\ModelName::where('extracolumn', '=', '1')->where('published', '=', true)->take('10')->orderBy('id', 'desc')->get();
$MediaCategories = \Model\MediaCategory\ModelName::orderBy('id', 'asc')->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();
$defaultVideo = 'rjXSurFi8uQ';
return view('Front::home', ['generalPosts' => $generalPosts, 'dayVideo1' => $dayVideo1, 'dayVideo2' => $dayVideo2, 'dayVideo3' => $dayVideo3, 'dayVideo4' => $dayVideo4, 'defaultVideo' => $defaultVideo, 'positionTop' => $this->positionTop, 'positionRight' => $this->positionRight, 'positionLeft' => $this->positionLeft, 'positionCenter' => $this->positionCenter, 'positionBottom' => $this->positionBottom, 'peopleReporters' => $peopleReporters, 'photoGalleries' => $photoGalleries, 'backgroundMain' => $backgroundMain, 'MediaCategories' => $MediaCategories, 'categoriesVideos' => $categoriesVideos, 'mediaLastVideos' => $mediaLastVideos, 'projects' => $projects, 'directorPosts' => $directorPosts, 'reporterPosts' => $reporterPosts, 'latestPosts' => $latestPosts, 'channels' => $channels]);
}
public function ChannelTeleprogram($channel)
{
$lc = app()->getlocale();
$backgroundMain = \Model\Background\ModelName::where('published', '=', true)->first();
$channels = \Model\Channel\ModelName::take(8)->skip(1)->get();
date_default_timezone_set('Asia/Bishkek');
$now = date("d-m-Y H:i");
$currentDate = date('d-m-Y');
$currentTime = date('H:i');
$weekDay = date('N', strtotime($now));
$channel = \Model\Channel\ModelName::where('id', '=', $channel->id)->first();
if ($channel) {
$schedules = \Model\Schedule\ModelName::where('channel_id', '=', $channel->id)->orderBy('date', 'desc')->get();
for ($i = 1; $i <= 7; $i++) {
if ($i < $weekDay) {
$weekDayNew = date('d-m-Y', strtotime('-' . ($weekDay - $i) . ' day'));
$week[] = $weekDayNew;
} elseif ($i > $weekDay) {
$weekDayNew = date('d-m-Y', strtotime('+' . ($i - $weekDay) . ' day'));
$week[] = $weekDayNew;
} else {
$weekDayNew = date('d-m-Y', strtotime($now));
$week[] = $weekDayNew;
}
}
if (!empty($schedules)) {
$programs = array();
for ($j = 0; $j < count($week); $j++) {
foreach ($schedules as $schedule) {
if (strtotime($week[$j]) == strtotime($schedule->date)) {
$program = json_decode($schedule->program);
$programNew = array_add($program, 'date', $schedule->date);
$programs[] = $programNew;
}
}
}
// dd($programs);
// $programs = array_reverse($programs);
}
}
// dd($programs);
return view('Front::pages.teleprogram', ['lc' => $lc, 'currentDate' => $currentDate, 'currentTime' => $currentTime, 'backgroundMain' => $backgroundMain, 'schedules' => $schedules, 'programs' => $programs, 'week' => $week, 'channels' => $channels, 'channel' => $channel, 'positionTop' => $this->positionTop, 'positionRight' => $this->positionRight, 'positionCenter' => $this->positionCenter, 'positionBottom' => $this->positionBottom, 'positionLeft' => $this->positionLeft]);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit(Schedule $schedule)
{
$channels = \Model\Channel\ModelName::take(8)->skip(1)->lists('display', 'id')->toArray();
$date = $schedule->date;
// $program = json_decode($schedule->program);
$extra = $schedule->extra;
return view('Admin::schedule.edit', ['date' => $date, 'extra' => $extra, 'schedule' => $schedule, 'channels' => $channels]);
}
