student-admission/resources/views/supervisor/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 style="width: 20%;">
                            <div style="display:flex;">
                                @if($row->student_details->nationality)
                                    <img class="img-responsive listFlag mt-2" style="border-radius: 2px; padding: 0px;height: 35px; width: 35px;" src="{{ asset('/assets/img/flags/4x3').'/'.strtolower(cn($row,'student_details.country_name.iso_3166_2','')).'.svg' }}" alt="Flag" data-toggle="tooltip" title="" data-placement="top">
                                @endif
                                <div class="alert" style="background-color:white; padding: 3px 7px; margin-bottom: 0px;">
                                    <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>
                                </div>
                            </div>
                        </td>
                        <td style="font-size: 11.5px; width: 17%;">
                            <div style="display:flex;">
                                <div class="alert" style="background-color:white; padding: 3px 7px; margin-bottom: 0px;">
                                    <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>
                                </div>
                            </div>
                        </td>
                        <td class="mb-1" style="font-size: 11.5px; text-align:center; color: black;"><span class="label_badge_gpa" style="background-color: #f5f4fd; color: black;">{{cn($row,'scores.test_name','N/A')}} • {{cn($row,'scores.overall_score','')}}</span>
                            <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: #2466dc; 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;"> Pub :
                                    @if($row->student_details->is_publication==1)
                                        <span class="label_badge_work" style="font-weight: 400 !important; background-color: #f5f2cd; color: #6f6b3e;"> Yes</span>
                                    @else
                                        <span class="label_badge_work" style="font-weight: 400 !important; background-color: #f5f2cd; color: #6f6b3e;"> 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" style="font-weight: 400 !important; background-color: #e5ebf7; color: #2466dc;"> Yes</span>
                                    @else
                                        <span class="label_badge_work" style="font-weight: 400 !important; background-color: #e5ebf7; color: #2466dc;"> No</span>
                                    @endif
                                </div>
                            </div>
                        </td>
                        <td style="font-size: 11px; width: 30%;">
                            @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-->
    {{-- {{ $students->appends(request()->query())->links('paginator') }} --}}
    @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

<script>
    $(function(){
        $('.accept_status_update').on('click', function(){

            var self =$(this);
            var id =self.data('id');

            var form_data={
                _token :"{{csrf_token()}}",
                'id':id,
            }

            swal({
                title: "Are you sure you want to change status?",
                text: "Please check before submitting!",
                type: "warning",
                showCancelButton: true,
                confirmButtonClass: "btn-danger",
                cancelButtonClass: "btn-info",
                confirmButtonText: "Yes",
                cancelButtonText: "No",
                closeOnConfirm: true,
                closeOnCancel: true
            }, function(isConfirm){

                if(isConfirm){
                    $.post("{{ route('ajax-post', ['name'=>'accept_status_update']) }}", form_data, function(res){
                        pop_up_msg(res.msg);
                        window.location.reload();

                    }).fail(function(err){

                        pop_up_msg(err_msg(err), 'error');

                    });
                }
            });
        });

        $('.page-link').on('click',function() {
            $('#load_data').load($(this).attr('href'));
        });

    });
</script>