@extends('backEnd.master')
@section('title') 
@lang('lang.lesson') @lang('lang.plan') @lang('lang.overview')
@endsection
@section('mainContent')


<section class="sms-breadcrumb mb-40 white-box">
    <div class="container-fluid">
        <div class="row justify-content-between">
            <h1>@lang('lang.lesson') @lang('lang.plan') @lang('lang.overview')</h1>
            <div class="bc-pages">
                <a href="{{route('dashboard')}}">@lang('lang.dashboard')</a>
                <a href="#">@lang('lang.lesson') @lang('lang.plan')</a>
                <a href="#">@lang('lang.lesson') @lang('lang.plan') @lang('lang.overview')</a>
            </div>
        </div>
    </div>
</section>
<section class="admin-visitor-area">
    <div class="container-fluid p-0">
  
    </div>

          
            <div class="row mt-40">
                <div class="col-lg-12">
                    <div class="row">
                        <div class="col-lg-4 no-gutters">
                            <div class="main-title">
                 
                            </h3>
                            </div>
                        </div>
                    </div>
                <div class="col-lg-12">
                    <table id="table_id" class="display school-table" cellspacing="0" width="100%"> 
                        <thead>
                          
                            <tr>
                            <th>@lang('lang.lesson')</th>
                            <th>@lang('lang.topic')</th>
                            <th>@lang('lang.sup_topic')</th>
                            <th>@lang('lang.completed') @lang('lang.date') </th>
                            <th>@lang('lang.upcoming') @lang('lang.date') </th>
                            <th>@lang('lang.status')</th>
                           
                        </tr>
                    </thead>

                    <tbody>
                        @foreach ($lessonPlanner as $data)
                            
                       
                        <tr>
                            <td>{{@$data->lessonName !=""?@$data->lessonName->lesson_title:""}}</td>

                            <td> 
                                @php 
                                $alllessonPlannerTopic=DB::table('lesson_planners') 
                                                     ->join('sm_lessons','sm_lessons.id','=','lesson_planners.lesson_detail_id')
                                                    ->join('sm_lesson_topic_details','sm_lesson_topic_details.id','=','lesson_planners.topic_detail_id')                                                
                                                    ->where('lesson_detail_id',$data->lesson_detail_id) 
                                                    ->where('lesson_planners.active_status', 1)
                                                    ->select('lesson_planners.*','sm_lessons.lesson_title','sm_lesson_topic_details.topic_title')
                                                    ->get();                               
                                @endphp
                                @foreach($alllessonPlannerTopic as $allData)                             
                                {{@$allData->topic_title !=""?@$allData->topic_title :""}}<br>
                                @endforeach

                            </td>
                            <td>
                               @foreach($alllessonPlannerTopic as $allData)
                                @php
                                    $topicdate=DB::table('lesson_planners')->where('id',$allData->id)->first();                                  
                                @endphp 
                                {{@$topicdate->sub_topic !=""?@$topicdate->sub_topic:""}}<br> 
                                @endforeach
                            </td>
                                
                            
                            <td>
       
                                @foreach($alllessonPlannerTopic as $allData)
                                @php
                                    $topicdate=DB::table('lesson_planners')->where('id',$allData->id)->first();                                  
                                @endphp 
                                {{@$topicdate->competed_date !=""?@$topicdate->competed_date:""}}<br> 
                                @endforeach
                           
                                </td>
                                                                <td>
                                    @foreach($alllessonPlannerTopic as $allData)
                                    @php
                                    $topicdate=DB::table('lesson_planners')->where('id',$allData->id)->first();                                  
                                    @endphp 
                                
                                      
                                           
                                           @if(date('Y-m-d')< $topicdate->lesson_date && $topicdate->competed_date=="")
                                            Upcoming     ({{$topicdate->lesson_date}})<br>                                          
                                           @elseif($topicdate->competed_date=="")
                                            Assigned Date({{$topicdate->lesson_date}})  
                                           <br>
                                           @else
                                          
                                           @endif
                                       
                                 
                                     @endforeach
                                </td>
                                <td>
                                     @foreach($alllessonPlannerTopic as $allData)
                                     @php
                                     $topicdate=DB::table('lesson_planners')->where('id',$allData->id)->first();                                  
                                     @endphp 
                                      @if(date('Y-m-d')< $topicdate->lesson_date && $topicdate->competed_date=="")
                                                Upcoming <br>                                          
                                               @elseif($topicdate->competed_date=="")
                                                Incompete <br>
                                               <br>
                                               @else
                                              <strong>completed</strong> <br>
                                               @endif
                                      @endforeach
                                </td>

                        
                        </tr>
                        @endforeach
                       
                    </tbody>
                </table>
            </div>
      
        </div>
    </div>
</div>
</div>
</section>
@endsection