@extends('layouts.default') @push('title', get_phrase('Home')) @push('meta')@endpush @push('css') @endpush @section('content') @php $total_students = DB::table('users')->where('role', 'student')->get(); $total_instructors = DB::table('users')->where('role', 'instructor')->get(); $free_courses = DB::table('courses')->where('is_paid', 0)->get(); $premium_courses = DB::table('courses')->where('is_paid', 1)->get(); @endphp
@php $banner_title = get_frontend_settings('banner_title'); $arr = explode(' ', $banner_title); $phrase_two = end($arr); $phrase_one = str_replace($phrase_two, '', $banner_title); @endphp

{{ get_phrase('LEARN FROM TODAY') }}

{{ $phrase_one }} {{ $phrase_two }}

{{ get_frontend_settings('banner_sub_title') }}

@php $bannerData = json_decode(get_frontend_settings('banner_image')); $banneractive = get_frontend_settings('home_page'); if ($bannerData !== null && is_object($bannerData) && property_exists($bannerData, $banneractive)) { $banner = json_decode(get_frontend_settings('banner_image'))->$banneractive; } @endphp @if (isset($banner)) @else @endif
@php $total_students = DB::table('users')->where('role', 'student')->get(); $total_instructors = DB::table('users')->where('role', 'instructor')->get(); $free_courses = DB::table('courses')->where('is_paid', 0)->get(); $premium_courses = DB::table('courses')->where('is_paid', 1)->get(); @endphp

{{ count($premium_courses) }}+

{{ get_phrase('Premium courses') }}

{{ count($total_instructors) }}+

{{ get_phrase('Expert Mentors') }}

{{ count($total_students) }}+

{{ get_phrase('Students Globally') }}

{{ count($free_courses) }}+

{{ get_phrase('Cost Free Course') }}

{{ get_phrase('Top Courses') }}

{{ get_phrase('Awesome site. on the top advertising a business online includes assembling Having the most keep.') }}

@php $top_courses = DB::table('courses') ->leftJoin('payment_histories', 'courses.id', '=', 'payment_histories.course_id') ->select('courses.id', 'courses.slug', 'courses.thumbnail', 'courses.title', 'courses.average_rating', 'courses.discount_flag', 'courses.is_paid', 'courses.price', 'courses.discounted_price', DB::raw('COUNT(payment_histories.id) as total_sales')) ->groupBy('courses.id', 'courses.slug', 'courses.thumbnail', 'courses.title', 'courses.average_rating', 'courses.discount_flag', 'courses.is_paid', 'courses.price', 'courses.discounted_price') ->where('status', 'active') ->orderByDesc('total_sales') ->take(4) // Number of courses you want to get, e.g., top 4 ->get(); @endphp @foreach ($top_courses as $key => $row) @endforeach

{{ get_phrase('Top Categories') }}

{{ get_phrase('Awesome site. on the top advertising a business online includes assembling Having the most keep.') }}

{{ get_phrase('Featured Courses') }}

{{ get_phrase('Awesome site. on the top advertising a business online includes assembling Having the most keep.') }}

@php $featured_courses = DB::table('courses')->where('status', 'active')->latest('id')->take(4)->get(); @endphp @foreach ($featured_courses->take(4) as $key => $row) @php $ratings = DB::table('reviews') ->where('course_id', $row->id) ->pluck('rating') ->toArray(); $average_rating = count($ratings) > 0 ? array_sum($ratings) / count($ratings) : null; @endphp @endforeach
@if ($stordetails = json_decode(get_homepage_settings('kindergarden')))
@if (isset($stordetails->image)) @else @endif

{{ $stordetails->title }}

{!! $stordetails->description !!}

@endif

{{ get_phrase('Frequently Asked Questions') }}

{{ get_phrase('Awesome site. on the top advertising a business online includes assembling Having the most keep.') }}

@php $faqs = json_decode(get_frontend_settings('website_faqs'), true); $faqs = count($faqs) > 0 ? $faqs : [['question' => '', 'answer' => '']]; $odd_faqs = array_filter( $faqs, function ($v, $k) { return $k % 2 == 0; }, ARRAY_FILTER_USE_BOTH, ); $even_faqs = array_filter( $faqs, function ($v, $k) { return $k % 2 != 0; }, ARRAY_FILTER_USE_BOTH, ); @endphp
@foreach ($odd_faqs as $key => $faq)

{{ $faq['answer'] }}

@endforeach
@foreach ($even_faqs as $key => $faq)

{{ $faq['answer'] }}

@endforeach

{{ get_phrase('What they’re saying about our courses') }}

{{ get_phrase('Having enjoyed a breathlessly successful 2015, there can be no DJ dynamic set of teaching tools Billed to be deployed.') }}

@php $reviews = DB::table('user_reviews')->get(); @endphp @foreach ($reviews as $review) @php $userDetails = DB::table('users') ->where('id', $review->user_id) ->first(); $bgColor = '#fffccf'; if ($review->rating >= 4) { $bgColor = '#ffe8eb'; } elseif ($review->rating == 3) { $bgColor = '#ffedff'; } else { $bgColor = '#fffccf'; } @endphp
@for ($i = 1; $i <= 5; $i++) @if ($i <= $review->rating) @else @endif @endfor

{{ $review->review }}

{{ $userDetails->name }}

{{ $userDetails->role }}

@endforeach
@if (get_frontend_settings('blog_visibility_on_the_home_page'))

{{ get_phrase('Our Blog') }}

{{ get_phrase('Awesome site. on the top advertising a business online includes assembling Having the most keep.') }}

@endif @endsection