{{-- Extends layout --}}
@extends('layout.default')
@section('styles')
    <!--begin::Page Vendors Styles(used by this page)-->
    <link href="{{asset('plugins/custom/datatables/datatables.bundle.css')}}" rel="stylesheet" type="text/css" />
    <!--end::Page Vendors Styles-->
@endsection
{{-- Content --}}
@section('content')
    <!--begin::Card-->
    <div class="card card-custom gutter-b">
        <div class="card-header flex-wrap py-3">
            <div class="card-title">
                <h3 class="card-label">স্কেল পরিবর্তন সংক্রান্ত তথ্যাদি (Information on pay scale)  From {{$startdate}} to {{$enddate}}</h3>
            </div>
        </div>
        <div class="card-header flex-wrap py-3">
            <form action="{{route('report.service_scale')}}" method="get" class="card-title">
                From <input name="start_date" data-date-format="dd-mm-yyyy" class="form-control form-control-lg form-control-solid kt_datepicker ml-2" type="text" required>
                To <input name="end_date" data-date-format="dd-mm-yyyy"  class="form-control form-control-lg form-control-solid kt_datepicker ml-2" type="text" required>
                <button type="submit" class="btn btn-primary ml-2">Search</button>
            </form>
        </div>
        <div class="card-body">
            <table class="table table-bordered nowrap" id="kt_datatable_em">
                <thead class="thead-light">
                <tr>
                    <th>Name</th>
                    <th>Rank</th>
                    <th>Date of Order</th>
                    <th>Grade</th>
                    <th>Scale</th>
                    <th>Time Scales</th>
                    <th>Basic pay</th>
                    <th>Sanction Number</th>
                    <th>Sanction Date</th>
                    <th>Contact Number</th>
                    <th>Action</th>
                </tr>
                </thead>
                <tbody>
                @foreach($datas as $data)
                    <tr>
                        <td>{{ $data->employee->name}}</td>
                        <td>@if(isset($data->employee->rank) && (int)$data->employee->rank > 0){{ $function->rank()[(int)$data->employee->rank]['name_en']}}@endif</td>
                        <td>{{$data->date_of_getting ? \Carbon\Carbon::parse($data->date_of_getting)->format('d-m-Y'):''}}</td>
                        <td>@if(isset($data->grade) && (int)$data->grade > 0){{$function->present_position_present_grade()[(int)$data->grade][1]}}@endif</td>
                        <td>@if(isset($data->scale) && (int)$data->scale > 0 && isset($function->present_position_present_grade()[(int)$data->scale])){{$function->present_position_present_grade()[(int)$data->scale][2]}}-{{$function->present_position_present_grade()[(int)$data->scale][3]}}@endif</td>
                        <td>@if(isset($data->time_scale) && (int)$data->time_scale > 0 && isset($function->time_scales()[(int)$data->time_scale])){{$function->present_position_present_grade()[(int)$data->time_scale][0]}}@endif</td>
                        <td>{{ $data->basic_pay?$data->basic_pay:''}}</td>
                        <td>{{ $data->memo_no?$data->memo_no:''}}</td>
                        <td>{{ $data->sanction_date?\Carbon\Carbon::parse($data->sanction_date)->format('d-m-Y'):''}}</td>
                        <td>{{ $data->employee->sms_number}}</td>
                        <td><a href="{{route('employee.employinfopdf',['id'=>$data->employee->id])}}" class="text-primary" role="button" >Details</a></td>
                    </tr>
                @endforeach
                </tbody>

            </table>
            <script>
                $(document).ready(function() {
                    var title = 'LandPortAuthority All Employee Information Related to Service : Present Position  From {{$startdate}} to {{$enddate}}';
                    // +$('h3.card-label').text()
                    var table = $('#kt_datatable_em');
                    table.DataTable({
                        responsive: true,
                        dom: 'Bfrtip',
                        "lengthMenu": [[50, -1], [50, "All"]],
                        rowGroup: {
                            dataSrc: 1
                        },
                        buttons: [
                            {
                                extend: 'excelHtml5',
                                title: title,
                                exportOptions: {
                                    columns:  ':visible:not(:last-child)'
                                }
                            },
                            {
                                extend: 'pdfHtml5',
                                title: title,
                                orientation: 'landscape',
                                pageSize: 'A4',
                                exportOptions: {
                                    columns:  ':visible:not(:last-child)'
                                }
                            },
                            {
                                extend: 'print',
                                title: title,
                                exportOptions: {
                                    columns:  ':visible:not(:last-child)'
                                },
                                customize: function(win)
                                {

                                    var last = null;
                                    var current = null;
                                    var bod = [];

                                    var css = '@page { size: landscape; }',
                                        head = win.document.head || win.document.getElementsByTagName('head')[0],
                                        style = win.document.createElement('style');

                                    style.type = 'text/css';
                                    style.media = 'print';

                                    if (style.styleSheet)
                                    {
                                        style.styleSheet.cssText = css;
                                    }
                                    else
                                    {
                                        style.appendChild(win.document.createTextNode(css));
                                    }

                                    head.appendChild(style);
                                }
                            },
                            'colvis'

                        ]

                    });
                });
            </script>
        </div>
    </div>
    <!--end::Card-->
@endsection

{{-- Scripts Section --}}
@section('scripts')
    <!--begin::Page Vendors(used by this page)-->
    <script src="{{asset('plugins/custom/datatables/datatables.bundle.js')}}"></script>
    <!--end::Page Vendors-->

    <!--begin::Page Scripts(used by this page)-->
    <script src="{{asset('js/pages/crud/datatables/data-sources/html.js')}}"></script>

@endsection