student-admission/resources/views/teacher/load_application.blade.php

@if(count($students) >0)
    <div class="col-md-12 bg-white" style="padding:10px; height:500px;">
        <h4 class="text-info"></h4>
        <div class="table-responsive">
            <table class="table table-bordered list_table">
                <thead>
                    <tr>
                        <th>Sl</th>
                        <th>Student Information</th>
                        <th>Education</th>
                        <th class="text-center">English Test</th>
                        <th class="text-center">Others</th>
                        <th>Proposal Summary</th>
                        <th class="text-center">Status</th>
                    </tr>
                </thead>
                <tbody>
                @foreach($students as $key=>$row)
                    <tr>
                        <td style="font-size: 11px;">{{$key+1}}</td>
                        <td>
                            <div style="font-size: 12px; font-weight: 600; color: black; text-transform: capitalize;">
                                <span>{{cn($row,'student_details.first_name','')}} {{cn($row,'student_details.last_name','')}}</span>
                            </div>
                            <div style="font-size: 11.5px;">
                                <a href="" class="" style="color: #868e96;"><span>Ref : {{$row->student_apply_ref ?? "N/A"}} </span></a>
                            </div>
                            <div style="font-size: 11.5px;">
                                <span style="color: #868e96;">Applied : {{utc_to_ltz($row->submitted_date, 'd M Y g:i A', local_tz($user))}}</span>
                            </div>
                        </td>
                        <td style="font-size: 11.5px;">
                            <div style="font-size: 11.5px; font-weight: 600; display:block;">
                                <span style="color: black;">{{cn($row,'institutes.institution','')}}</span>
                            </div>
                            <div style="font-size: 11.5px;">
                                <span style="color: black;">Passing Year :  {{cn($row,'institutes.passing_year','N/A')}} </span>
                            </div>
                            <div class="mt-1" style="font-size: 11.5px;">
                                <span class="label_badge_gpa">{{cn($row,'institutes.result','')}} (GPA)</span>
                            </div>
                        </td>
                        <td style="font-size: 11.5px; text-align:center; color: black;">{{cn($row,'scores.test_name','N/A')}} - {{cn($row,'scores.overall_score','')}}
                            <div style="font-size: 11.5px;">
                                <span style="color: black;">
                                @php
                                        $work_history_first =$row->work_experience_date()->whereNotNull('start_date')->oldest()->first();

                                        $work_history_last =$row->work_experience_date()->latest()->first();
                                        if($work_history_first && $work_history_last && $work_history_last->end_date){

                                        $diff_in_days =diff_in_days($work_history_first->start_date,$work_history_last->end_date);

                                        }elseif($work_history_first){
                                        $diff_in_days =diff_in_days($work_history_first->start_date, now());
                                        }else{
                                        $diff_in_days =0;
                                        }

                                        $years = ($diff_in_days / 365) ;
                                        $years = floor($years);
                                        $month = ($diff_in_days % 365) / 30.5;
                                        $month = floor($month);
                                        $days = ($diff_in_days % 365) % 30.5;
                                        @endphp

                                        <div class="mt-1" style="font-size: 11px; display:block;">
                                            <span class="label_badge_work"><i class="fa fa-briefcase" style="color: rgb(152, 152, 152); margin-right: 5px;"></i>{{$years}} years</span>
                                        </div>
                                </span>
                            </div>
                        </td>
                        <td style="font-size: 11px; text-align:center;">
                            <div style="font-size: 11px; display:block;">
                                <div style="font-size: 11px; color: black;"> Pu :
                                    @if($row->student_details->is_publication==1)
                                        <span class="label_badge_work"> yes</span>
                                    @else
                                        <span class="label_badge_no"> No</span>
                                    @endif
                                </div>
                                <div class="mt-1" style="font-size: 11px; color: black;"> Con :
                                    @if($row->student_details->is_attended_conference==1)
                                        <span class="label_badge_work"> yes</span>
                                    @else
                                        <span class="label_badge_no"> No</span>
                                    @endif
                                </div>
                            </div>
                        </td>
                        <td style="font-size: 11px;">
                            @php
                                $hashids = new \Hashids\Hashids('application', 25);
                            @endphp
                            <div class="inner_right">
                                <a href="{{ url('supervisor/application/'.$hashids->encode($row->id)) }}"><strong style="font-size:11px; color:black;">{{cn($row,'proposal.title','')}}</strong></a></br>
                                <span style="color:black;">{{cn($row,'proposal.methology','')}}</span>
                                @php
                                    $proposal =\DB::table('proposal')->where(
                                        'student_id',$row->student_id
                                        )->first();

                                    if(isset($proposal)){
                                        $department =\DB::table('departments')->where(
                                            'id',$proposal->department
                                        )->first();
                                    }
                                @endphp
                                @if(isset($department))
                                <span>.</span>
                                <span style="color:black;">
                                    {{ $department->name }}
                                </span>
                                @endif
                                <span>.</span>
                                <span style="color:black;">{{cn($row,'proposal.status','')}}</span>
                            </div>
                        </td>
                        <td style="font-size: 11px; text-align:center;">

                            <div class="top_part_status">
                                @if($row->accepted_status==1 && $row->proposal_status ==1)
                                        <button class="btn btn2" style="padding: 1px 10px !important; font-size: 11px;">Reviewing</button>
                                @elseif($row->accepted_status==1 && $row->proposal_status ==2)
                                    <button class="btn btn2" style="padding: 1px 10px !important; font-size: 11px;">Reviewing</button>
                                @elseif($row->accepted_status==1 && $row->proposal_status ==3)
                                    <button class="btn btn2" style="padding: 1px 10px !important; font-size: 11px;">Push</button>
                                @elseif($row->accepted_status==1 && $row->proposal_status ==4)
                                    <button class="btn btn2" style="padding: 1px 10px !important; font-size: 11px;">Hold</button>
                                @elseif($row->accepted_status==1 && $row->proposal_status ==5)
                                    <button class="btn btn2" style="padding: 1px 10px !important; font-size: 11px;">Interested</button>
                                @elseif($row->accepted_status==1 && $row->proposal_status ==6)
                                    <button class="btn btn2" style="padding: 1px 10px !important; font-size: 11px;">Rejected</button>
                                @else
                                    <button class="btn btn2 accept_status_update" data-id="{{$row->id}}" style="padding: 1px 10px !important; font-size: 11px;">Accept</button>
                                @endif

                                @if($row->proposal_status_date)
                                    <br>
                                    <span style="font-size:11px; font-weight: bold;">
                                    {{utc_to_ltz($row->proposal_status_date, 'd M Y g:i A', local_tz($user))}}
                                </span>

                                @endif
                            </div>
                        </td>
                    </tr>
                @endforeach
                </tbody>
            </table>
        </div>
    </div><!--end col-->
    @else
    <div class="col-md-12 bg-white" style="padding:10px;">
        <div class="alert  mt-1 mb-3" style="border-color: #e9f0f3; font-size: 12px !important; color: #dc3545; border-radius: 30px; padding: 8px 15px; text-align: center;">
            <span>No data available.</span>
        </div>
    </div>
@endif