@extends('layouts.home')

@section('content')

@php 
$course_modes=DB::table('course_modes')->select('course_id')->where('mode_id','2')->get();
foreach($course_modes as $course){
    $c_ids[] = $course->course_id;
}

$course_online_modes=DB::table('course_modes')->select('course_id')->where('mode_id','1')->get();
foreach($course_online_modes as $course){
    $c_on_ids[] = $course->course_id;
}
$online_courses=DB::table('courses')->wherein('id',$c_on_ids)->where('status','1')->where('deleted_status','0')->get();
$on_campus_courses=DB::table('courses')->wherein('id',$c_ids)->where('status','1')->where('deleted_status','0')->get();

@endphp
<!-- =======We Provide Section ======= -->
            <section class="we_provide_sec common_pd">
               <div class="container">
                  <div class="text-center section_title">
                        <h1>we provide</h1>
                        <p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. <br> Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer <br> took a galley of type and scrambled it to make a type specimen book.</p>
                  </div>

                  <div class="row mt-5">
                     <div class="col-md-3">
                        <div class="icon_box text-center">
                              <img src="assets/img/training_icon.png">
                              <p>Trainings</p>
                        </div>
                     </div>
                     <div class="col-md-3">
                        <div class="icon_box text-center">
                              <img src="assets/img/placement_icon.png">
                              <p>Placement Assistance</p>
                        </div>
                     </div>
                     <div class="col-md-3">
                        <div class="icon_box text-center">
                              <img src="assets/img/scholership_icon.png">
                              <p>Student Scholarships</p>
                        </div>
                     </div>
                     <div class="col-md-3">
                        <div class="icon_box text-center">
                              <img src="assets/img/workshop_icon.png">
                              <p>Workshops and Seminars</p>
                        </div>
                     </div>
                  </div>
                  <div class="text-center mt-4">
                     <a href="#" class="round_btn">See More</a>
                  </div>
               </div>
            </section>
         <!--We Provide end Section -->

         <!--About us section start-->
         <section class="about_us_sec common_pd">
               <div class="goup_img">
                  <img src="assets/img/about_group.png">
               </div>
               <div class="container">
                  <div class="row">
                     <div class="offset-md-6 col-md-6">
                        <div class="">
                           <div class="section_title">
                                 <h1>About Us</h1>
                                 <p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.</p>
                           </div>
                           <ul>
                              <li>24000+ Online Courses</li>
                              <li>Expert Instruction</li>
                              <li>Unlimited Access</li>
                              <li>Confortable Price</li>
                              <li>Free 2 Months trail</li>
                              <li>Review System</li>
                           </ul>
                        </div>
                     </div>
                  </div>
               </div>
         </section>      
         <!--About us section end-->

         <!--recommended course section start-->
         <section class="about_us_sec common_pd">
            <div class="container">
               <div class="section_title d-flex justify-content-between align-items-center mb-4">
                  <h1>Recommended Courses</h1>
                  <div><a href="#" class="round_btn">Browse Courses</a></div>
               </div>

               <div class="row">
                  @foreach($courseFeature as $courseFeatures)
               @php $courseD=DB::table('course_modes')->where('id',$courseFeatures->id)->first(); @endphp
                  <div class="col-md-4">
                     <div class="courses_box">
                        <div class="course_img">
                           <img src="{{asset('courses_images/'.$courseFeatures->block_image)}}" style="width:414px; height: 264px;">
                           <div class="playbtn_box d-flex justify-content-center align-items-center">
                                 <a href="{{url('course-detail/'.$courseFeatures->slug)}}" class="text-center">
                                    <div class="play_btn">
                                       <i class="bi bi-play-fill"></i>
                                    </div>
                                    <p>Preview Course</p>
                                 </a>

                             
                           </div>
                        </div>
                        <div class="p-3">
                           <div class="d-flex justify-content-between align-items-center category">
                              <a href="{{url('course-detail/'.$courseFeatures->slug)}}">{{$courseFeatures->title}}</a>
                              <div class="duration">8:17 min</div>
                           </div>
                           <p class="description">How to became Greate Developer in {{$courseD->duration}} months</p>
                           <div class="d-flex justify-content-between">
                              <div class="rating">
                                 <span><i class="bi bi-star-fill"></i></span>
                                 <span><i class="bi bi-star-fill"></i></span>
                                 <span><i class="bi bi-star-fill"></i></span>
                                 <span><i class="bi bi-star-fill"></i></span>
                                 <span><i class="bi bi-star-fill"></i></span>
                                 <span>15,220</span>
                              </div>
                              <div class="reviews">
                                 <a href="{{url('course-detail/'.$courseFeatures->slug)}}">{{$courseFeatures->view}} Views</a>
                              </div>
                           </div>
                        </div>
                     </div>
                  </div>
                 @endforeach    
                  
               </div>
            </div>
   
         </section>      
      <!--recommended course section end-->    

      <!--popular online category section start-->

      <section class="online_category common_pd">
         <div class="container">
            <div class="text-center section_title">
                  <h1>Popular Online Category</h1>
                  <p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. <br> Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer <br> took a galley of type and scrambled it to make a type specimen book.</p>
            </div>

            <div class="row mt-5 mb-4">
              @if(count($course_content_chunkCat)>0) 
              @foreach($course_content_chunkCat[0] as $course_content_chunkCat1s)
              @php $course_count=DB::table('courses')->where('category_id',$course_content_chunkCat1s['id'])->count(); @endphp
               <div class="col-md-4">
                  <div class="category_box">
                     <img src="{{asset('categories/'.$course_content_chunkCat1s['image'])}}">
                     <div class="course_details">
                        <img src="assets/img/brain.png">
                        <h3>{{$course_content_chunkCat1s['title']}}</h3>
                        <div class="hover_view">
                           <p>{{$course_count}} Courses</p>
                           <a href="{{url('courses#portfolio')}}" class="round_btn">See More</a>
                        </div>
                     </div>
                  </div>
               </div>
              @endforeach 
              @endif    
            </div>


            <div class="row">
               @if(count($course_content_chunkCat)>0) 
              @foreach($course_content_chunkCat[1] as $course_content_chunkCat1s)
              @php $course_count=DB::table('courses')->where('category_id',$course_content_chunkCat1s['id'])->count(); @endphp
               <div class="col-md-4">
                  <div class="category_box">
                     <img src="{{asset('categories/'.$course_content_chunkCat1s['image'])}}">
                     <div class="course_details">
                        <img src="assets/img/map-health.png">
                        <h3>{{$course_content_chunkCat1s['title']}}</h3>
                        <div class="hover_view">
                           <p>{{$course_count}} Courses</p>
                           <a href="{{url('courses#portfolio')}}" class="round_btn">See More</a>
                        </div>
                     </div>
                  </div>
               </div>
              @endforeach 
              @endif  
              
            </div>

            <div class="text-center mt-4">
               <a href="{{url('courses#portfolio')}}" class="round_btn">See More</a>
            </div>
         </div>
      </section>

      <!--popular online category section end-->  



      <!--Specialized Courses section-->
      <section class="online_category common_pd">
         <div class="container">
            <div class="text-center section_title">
                  <h1>Our Specialized Courses</h1>
                  <p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. <br> Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer <br> took a galley of type and scrambled it to make a type specimen book.</p>
            </div> 

            <div class="techno_list mt-5">
               <ul>
                  <li><img src="assets/img/python.png"></li>
                  <li><img src="assets/img/andriod.png"></li>
                  <li><img src="assets/img/develop.png"></li>
                  <li><img src="assets/img/java.png"></li>
               </ul>

               <ul>
                  <li><img src="assets/img/dqe.png"></li>
                  <li><img src="assets/img/sdet.png"></li>
                  <li><img src="assets/img/sqe.png"></li>
                  <li class="text-center"><a href="#">View All Program</a></li>
               </ul>
            </div>
         </div>
      </section>
      <!--Specialized Courses section end-->

      <!--Testimonail section-->
         <section class="testimonail_sec common_pd">
            <div class="container">
               <div class="section_title d-flex justify-content-between align-items-center mb-4">
                  <h1>Student'd Feedback</h1>
                  <div><a href="#" class="round_btn">View More</a></div>
               </div>


               <div class="carousel_wraper">
                  <div id="owl-carousel" class="owl-carousel owl-theme">
                     <div class="item">
                        <div class="text-center feedbeck">
                           <p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.</p>

                           <img src="assets/img/student1.jpg">

                           <h3>Amanda Jackson</h3>
                           <p class="designation">Web Design</p>
                        </div>
                     </div>
                     <div class="item">
                        <div class="text-center feedbeck">
                           <p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.</p>

                           <img src="assets/img/student1.jpg">

                           <h3>Amanda Jackson</h3>
                           <p class="designation">Web Design</p>
                        </div>
                     </div>
                     <div class="item">
                        <div class="text-center feedbeck">
                           <p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.</p>

                           <img src="assets/img/student1.jpg">

                           <h3>Amanda Jackson</h3>
                           <p class="designation">Web Design</p>
                        </div>
                     </div>

                     <div class="item">
                        <div class="text-center feedbeck">
                           <p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.</p>

                           <img src="assets/img/student1.jpg">

                           <h3>Amanda Jackson</h3>
                           <p class="designation">Web Design</p>
                        </div>
                     </div>

                     <div class="item">
                        <div class="text-center feedbeck">
                           <p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.</p>

                           <img src="assets/img/student1.jpg">

                           <h3>Amanda Jackson</h3>
                           <p class="designation">Web Design</p>
                        </div>
                     </div>
                    
                     
                  </div>
               </div>


            </div>
         </section>
         
      <!--Testimonail section end-->

@endsection