@extends('main')

@section('css')
    <link rel="stylesheet" href="{{url('public/assets/vendor/jquery-datatable/dataTables.bootstrap4.min.css')}}">
    <link rel="stylesheet" href="{{url('public/assets/vendor/bootstrap-datepicker/css/bootstrap-datepicker3.min.css')}}">
@endsection
@section('content')
    <div id="main-content">
        <div class="container-fluid">
            <div class="block-header">
                <div class="row">
                    <div class="col-lg-6 col-md-8 col-sm-12">
                        <h2><a href="javascript:void(0);" class="btn btn-xs btn-link btn-toggle-fullwidth"><i class="fa fa-arrow-left"></i></a>Employee Details</h2>
                        <ul class="breadcrumb">
                            <li class="breadcrumb-item"><a href="index.html"><i class="icon-home"></i></a></li>
                            <li class="breadcrumb-item">Employee</li>
                            <li class="breadcrumb-item active">Attendance</li>
                        </ul>
                    </div>
                </div>
            </div>

            <div class="row clearfix">
                <div class="col-lg-12">
                    <div class="card">
                        {{--                        <div class="header">--}}
                        {{--                            <h2>Employee Details</h2>--}}
                        {{--                        </div>--}}
                        <div class="row" style="margin-left: 2%;margin-top: 1%;">
                            <div class="col-lg-4 col-md-12">
                                <p> <b>Date</b> </p>
                                <div class="input-daterange input-group" data-provide="datepicker">
                                    <input type="text" class="input-sm form-control" value="{{$start}}" id="startDate">
                                    <span class="input-group-addon text-center" style="width: 40px;">to</span>
                                    <input type="text" class="input-sm form-control" value="{{$end}}" id="endDate">
{{--                                    <input type="text" value=" {{ Auth::id() }}" class="input-sm form-control" id="emiid">--}}
                                </div>
                            </div>
                            <div class="col-lg-4 col-md-12">
                                <label></label>
                                <div class="input-group mb-3" style="margin-top: 3%;">
                                    <button class="btn btn-info" onclick="onDateSearch()">Search</button>
                                </div>
                            </div>
                            <div class="col-lg-4 col-md-12">
                                <label></label>
                                <div class="input-group mb-3" style="margin-top: 3%;">
{{--                                    <button onclick="exportTableToExcel('tblData')">Generate Report</button>--}}
{{--                                    <a  onclick="return excel()"> <button class="btn btn-danger">Generate Report</button></a>--}}
                                </div>
                                @if(Auth::user()->fkUserType == "admin")
                                <div class="input-group mb-3" style="margin-top: 3%;">
                                    <button id="GetFile" class="btn btn-danger">Generate Report</button>
                                    {{--                                    <a  onclick="return excel()"> <button class="btn btn-danger">Generate Report</button></a>--}}
                                </div>
                                    @endif
                            </div>
                        </div>

                        <div class="body">
                            <div class="table-responsive">
                                <table id="attendanceSummery" class="table table-bordered center-aligned-table table-striped">
                                    <thead>
                                    <tr>
                                        <th class="text-center">Emp ID</th>
                                        <th class="text-center">Name</th>
                                        <th class="text-center">Department</th>
                                        <th class="text-center">Total Attendance</th>
                                        <th class="text-center">Total Late</th>
                                        <th class="text-center">Average Working hour</th>
                                        <th class="text-center">Total Leave</th>
                                        <th class="text-center">Weekend</th>
{{--                                        <th class="text-center">Weekend Count</th>--}}
                                        <th class="text-center">Action</th>

                                    </tr>
                                    </thead>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

@endsection

@section('js')
    <script src="{{url('public/assets/js/pages/tables/jquery-datatable.js')}}"></script>
    <script src="{{url('public/assets/bundles/datatablescripts.bundle.js')}}"></script>
    <script src="{{url('public/assets/vendor/bootstrap-datepicker/js/bootstrap-datepicker.min.js')}}"></script>

    <script>

        $(document).ready( function () {
            table = $('#attendanceSummery').DataTable({
                rowReorder: {
                    selector: 'td:nth-child(0)'
                },
                processing: true,
                serverSide: true,
                stateSave: true,
                "ordering": false,
                // type:"POST",
                "ajax":{
                    "url": "{!! route('attendance-summery') !!}",
                    "type": "POST",
                    data:function (d){
                        d._token="{{csrf_token()}}";
                        d.startDate=$('#startDate').val();
                        d.endDate=$('#endDate').val();
                        // d.emiid=$('#emiid').val();
                        // alert(d.orderstatusId);
                    }
                },
                columns: [
                    { data: 'empId' ,name:'empId'},
                    { data: 'empName' ,name:'empName'},
                    { data: 'departmentName' ,name:'departmentName'},
                    { data: 'tot_attendance' , name: 'tot_attendance' },
                    { data: 'tot_late', name: 'tot_late'},
                    { data: 'averageWorkingHour', name: 'averageWorkingHour'},
                    { data: 'totalLeave', name: 'totalLeave'},
                    { data: 'weekend', name: 'weekend'},
                    // { data: 'totalWeekend', name: 'totalWeekend'},
                    { "data": function(data){

                            return '<a class="btn btn-sm btn-outline-success" title="view" data-panel-id="' + data.employeeId + '" onclick="viewDetails(this)"><i class="fa fa-eye"></i></a>'
                                ;},
                        "orderable": false, "searchable":false, "name":"selected_rows" },


                    // { title: 'Action', data: 'action', orderable: false, searchable:false },
                ]
            });

            $('#startDate').datepicker({
                format:'yyyy-mm-dd',
                todayHighlight: true,
                autoclose: true
            });
            $('#endDate').datepicker({
                format:'yyyy-mm-dd',
                todayHighlight: true,
                autoclose: true
            });
            // $('#emiid').change(function(){
            //     table.ajax.reload();
            //     if ($('#emiid').val()!=""){
            //         $('#emiid');
            //     }else {
            //         $('#emiid');
            //     }
            // });
        });

        function onDateSearch() {

            table.ajax.reload();

        }
        function viewDetails(x) {
            btn = $(x).data('panel-id');

            // alert(btn);
            var start =$('#startDate').val();
            // alert(start);
            var end = $('#endDate').val();

            window.location.href = '{{url("attendence-details/")}}'+'/'+btn+'/'+start+'/'+end;
           // window.open("/summery.details/" +id+'/'+start+'/'+end, "_blank");

        }


    </script>
    <script>
        $('#GetFile').on('click', function () {
            var startdate = document.getElementById('startDate').value;
            var enddate = document.getElementById('endDate').value;
            $.ajax({
                url: '{{route('exceldownloadforHR')}}',
                method: 'GET',
                data:{startDate: startdate, endDate:enddate},
                responseType: 'blob',
                // xhrFields: {
                //     responseType: 'blob'
                // },
                success: function (data) {
                    var a = document.createElement('a');
                    var url = '{{ url('storage/app/public') }}'+'/'+data + '.xlsx';
                    a.href = url;
                    a.download = data + '.xlsx';
                    document.body.appendChild(a);
                    a.click();
                    a.removeChild();
                    window.URL.revokeObjectURL(url);
                }
            });


        });
    </script>
@endsection