public function getResult() { $types = TypeModel::select('id', 'title', 'sort_order', 'description')->get()->toArray(); $categories = CategoryModel::select('id', 'title', 'sort_order')->get()->toArray(); $courses = CourseModel::select('id', 'title')->with(['types', 'categories'])->with(['events' => function ($q) { $q->where('date_start', '>', \Carbon::now())->where('is_closed', '<>', 1); }])->get(); foreach ($types as $type_id => &$type) { // $_courses = array_filter($courses, function ($course) { // return $course->types->contains('id', $type->id); // }); $_courses = $courses->filter(function ($course) use($type) { return $course->types->contains('id', $type['id']); }); $type['courses'] = $_courses; $_cat = []; foreach ($categories as $cat_id => &$category) { // $__courses = array_filter($_courses, function ($course) { // return $course->categories->contains('id', $category->id); // }); $__courses = $_courses->filter(function ($course) use($category) { return $course->categories->contains('id', $category['id']); }); $category['courses'] = $__courses; $_cat[] = $category; } $type['categories'] = $_cat; } // $types->each(function ($type) use ($categories, $courses) { // $_courses = $courses->filter(function ($course) use ($type) { // return $course->types->contains('id', $type->id); // }); // $type['_courses'] = $_courses; // $categories->each(function ($category) use ($_courses, &$type) { // $__courses = $_courses->filter(function ($course) use ($category) { // return $course->categories->contains('id', $category->id); // }); // // $type->categories[$category->id]['__courses'] = $__courses; // $category['__courses'] = $__courses; // // CW::info(['__', $__courses]); // }); // // $type['_categories'] = $categories; // $type['_categories'] = $_cats; // }); CW::info(['Result' => $types]); return; }
/** * List Courses */ protected function listCourses() { // Assign params $params = $this->params; $type_id = $params['type']; $cat_id = $params['category']; $search = ''; $post = post(); // CW::info(['POST' => $post]); // Check POST if (count($post) > 0) { if (array_key_exists('type', $post)) { $type_id = $post['type']; } if (array_key_exists('category', $post)) { $cat_id = $post['category'] | 0; } if (array_key_exists('search', $post)) { $search = $post['search'] | ""; } } // Fetch All Types $types = TypeModel::select('id', 'title', 'sort_order', 'description', 'content'); if ($type_id != 0) { $types = $types->where('id', $type_id); } $types = $types->get()->toArray(); CW::info(['Types' => TypeModel::all()]); // Fetch All Categories $categories = CategoryModel::select('id', 'title', 'sort_order'); if ($cat_id != 0) { $categories = $categories->where('id', $cat_id); } $categories = $categories->get()->toArray(); $courses = new CourseModel(); // Search query $search = trim($search); if (strlen($search)) { $searchableFields = ['title', 'content']; $courses = $courses->searchWhere($search, $searchableFields); } // Main query $courses = $courses->select('id', 'title', 'content', 'course_type_id', 'course_category_id', 'description_long')->with(['type' => function ($q) { $q->select('id'); }, 'category' => function ($q) { $q->select('id'); }, 'events' => function ($q) { $q->where('date_start', '>', \Carbon::now())->where('is_closed', '<>', 1)->orderBy('date_start', 'asc')->select('id', 'date_start', 'date_end', 'price', 'hours', 'course_id', 'teacher'); }])->get(); // Check logged User and fetch UserCourses (UserEvents) with States if (!is_null($cmsuser = $this->user())) { $user_courses = $cmsuser->userevents()->with(['course', 'state'])->get(); // CW::info(['user_courses', $user_courses]); } else { $user_courses = null; } // Preparing Result $_types = []; foreach ($types as &$type) { // Filter Courses list by Type $_courses = $courses->filter(function ($course) use($type) { // return $course->types->contains('id', $type['id']); return $course->course_type_id == $type['id']; }); // Skip empty courses type if ($_courses->count() == 0) { continue; } $type['courses'] = $_courses; // JSON fix if (is_string($type['content'])) { $type['content'] = json_decode($type['content'], true); } $_categories = []; foreach ($categories as &$category) { // Filter Courses list by Category $__courses = $_courses->filter(function ($course) use($category) { // return $course->categories->contains('id', $category['id']); return $course->course_category_id == $category['id']; }); // Skip empty courses type if ($__courses->count() == 0) { continue; } $__courses = $__courses->each(function (&$course) { // CW::info(['Events Count' => $course->events->count()]); // Add Last Event to Course if (!$course->events->count()) { $last_event = $course->events()->orderBy('date_start', 'desc')->select('id', 'price', 'hours', 'course_id', 'teacher')->take(1)->first(); $last_event['last'] = true; $course['events'][] = $last_event; // CW::info(['Last Event' => $course]); } }); // Sorting Courses by Event dates $__courses = $__courses->sortByDesc(function ($course) { if ($course->events->first() && ($start = $course->events->first()->date_start)) { return -$start->timestamp; } else { return false; } }); // CW::info(['Courses' => $__courses]); $___courses = $__courses->toArray(); foreach ($___courses as &$course) { // Fetch UserEvents with States if (!is_null($user_courses) && !is_null($user_course = $user_courses->where('course_id', $course['id'])->where('course_type_id', $type['id'])->where('course_category_id', $category['id'])->first())) { // extract($user_course->toArray()); $course['state'] = $user_course->state->title; } // CW::info(['Event Count' => count($course['events'])]); // if ($events_count = count($course['events']) == 0) { // $last_event = CourseModel::where('id', $course['id']) // ->with([ // 'events' => function ($q) { // $q // ->orderBy('date_start', 'desc') // ->select('id', 'date_start', 'date_end', 'price', 'hours', 'course_id', 'teacher') // ->take(1) // ; // }, // ]) // ->get() // ; // CW::info(['Last Event' => $last_event]); // } // Assign fast select fields $course['prices'] = []; $course['teachers'] = []; $course['hours'] = []; foreach ($course['events'] as $event) { if (trim($event['price']) != '') { $course['prices'][] = $event['price']; } if (trim($event['teacher']) != '') { $course['teachers'][] = $event['teacher']; } if (trim($event['hours']) != '') { $course['hours'][] = $event['hours']; } } // CW::info($course); } $category['courses'] = $___courses; $_categories[$category['id']] = $category; } $type['categories'] = $_categories; $_types[$type['id']] = $type; } // CW::info(['Result' => $_types]); return $_types; }
/** * List Courses */ protected function listCourses() { $params = $this->params; $type_id = $params['type']; $cat_id = $params['category']; $types = TypeModel::select('id', 'title', 'sort_order', 'description'); if ($type_id != 0) { $types = $types->where('id', $type_id); } $types = $types->get()->toArray(); $categories = CategoryModel::select('id', 'title', 'sort_order'); if ($cat_id != 0) { $categories = $categories->where('id', $cat_id); } $categories = $categories->get()->toArray(); if (is_null($cmsuser = $this->user())) { return null; } // $user_courses = $cmsuser->userevents()->with(['course', 'course.events'])->get(); // CW::info(['user_courses', $user_courses]); // $courses = $courses->select('id', 'title', 'content', 'course_type_id', 'course_category_id') $userevents = $cmsuser->userevents()->with(['state', 'event', 'course' => function ($q) { $q->with(['events' => function ($q) { $q->where('date_start', '>', \Carbon::now())->where('is_closed', '<>', 1)->orderBy('date_start', 'asc')->select('id', 'date_start', 'date_end', 'price', 'hours', 'course_id', 'course_type_id', 'course_category_id', 'teacher'); }]); }])->get(); // CW::info(['userevents' => $userevents]); // CW::info(['events' => $cmsuser->events()->get()]); if (!$userevents) { return; } // Delete deleted UserEvents $userevents->each(function ($userevent) { if ($userevent->state_id == 9) { $userevent->delete(); } }); // Filter UserEvents from deleted UserEvents $userevents = $userevents->filter(function ($userevent) { return $userevent->state_id != 9; }); // $_types = []; foreach ($types as $type_id => &$type) { $_userevents = $userevents->filter(function ($course) use($type) { return $course->course_type_id == $type['id']; }); // CW::info(['_userevents' => $_userevents]); if ($_userevents->count() == 0) { continue; } $type['userevents'] = $_userevents; $_categories = []; foreach ($categories as $cat_id => &$category) { $__userevents = $_userevents->filter(function ($course) use($category) { return $course->course_category_id == $category['id']; }); // CW::info(['__userevents' => $_userevents]); if ($__userevents->count() == 0) { continue; } // Sorting Courses by Event dates $__userevents = $__userevents->sortByDesc(function ($userevent) { CW::info(['UserEvent' => $userevent]); if ($userevent->course->events->first() && ($start = $userevent->course->events->first()->date_start)) { return -$start->timestamp; } else { return false; } }); $___userevents = $__userevents->toArray(); foreach ($___userevents as $course_id => &$course) { // CW::info(['userevent_course' => $course]); // $events = $course['course']['events']; // CW::info(is_null($course['course'])); if (is_null($course['course'])) { continue; } // $course = array_merge($course, $course['course']); // CW::info(array_merge($course, $course['course'])); // CW::info($course); $course['title'] = $course['course']['title']; $course['description_long'] = $course['course']['description_long']; $course['events'] = collect($course['course']['events'])->filter(function ($event) use($type, $category) { return $event['course_type_id'] == $type['id'] && $event['course_category_id'] == $category['id']; }); $course['prices'] = []; $course['teachers'] = []; $course['hours'] = []; foreach ($course['events'] as $event) { if (trim($event['price']) != '') { $course['prices'][] = $event['price']; } if (trim($event['teacher']) != '') { $course['teachers'][] = $event['teacher']; } if (trim($event['hours']) != '') { $course['hours'][] = $event['hours']; } } } $category['userevents'] = $___userevents; $_categories[$category['id']] = $category; } $type['categories'] = $_categories; $_types[$type['id']] = $type; } // CW::info(['Result' => $_types]); return $_types; }