@extends('admin.layout.app')
@section('title','Employee Salary Report')
@push('headerscript')
    <link href="{{asset('theme/plugins/bootstrap-datepicker/css/bootstrap-datepicker.min.css')}}" rel="stylesheet">
    <link href="{{asset('theme/plugins/datatables/responsive.bootstrap.min.css')}}" rel="stylesheet" type="text/css"/>
    <link href="{{asset('theme/plugins/datatables/dataTables.bootstrap.min.css')}}" rel="stylesheet" type="text/css"/>
    <link href="{{asset('theme/css/custom.css')}}" rel="stylesheet" type="text/css"/>
@endpush
@section('content')
    <div class="content">
        <div class="container">
            <div class="row">
                <div class="col-xs-12">
                    <div class="page-title-box">
                        <h4 class="page-title">Employee Salary Report</h4>
                        <div class="clearfix"></div>
                    </div>
                </div>
            </div>
            <div class="row">
                <div class="col-sm-12 mr-auto ml-auto">
                    <div class="card-box">
                        <div class="row">
                            <div class="col-sm-12">
                                <div class="row">
                                    <div class="form-group col-sm-4 col-12">
                                        <label for="month">By Month</label>
                                        <input type="text" name="month" id="atten_month"
                                               class="form-control datepicker1" autocomplete="off">
                                        <div class="text-danger">{{$errors->first('month')}}</div>
                                    </div>
                                    <div class="form-group col-sm-4 col-12">
                                        <label for="employee_id">Employee</label>
                                        {!! Form::select("employee_id", [''=>'Select']+$employees, old("employee_id"), ['class'=>'form-control', 'required', 'id'=>'employee_id'] ) !!}
                                        <div
                                            class="text-danger">{{$errors->first() ? 'Employee bank details already exists':''}}</div>
                                    </div>
                                    <div class="form-group col-sm-4 col-12">
                                        <button type="button" onclick="exportsExcel()"
                                                class="btn btn-success btn-sm pull-right"
                                                title="Export in Excel">
                                            <i class="fa fa-file-excel-o"></i>
                                        </button>
                                        <button type="button" onclick="exportsPdf()"
                                                class="btn btn-danger btn-sm pull-right m-r-10"
                                                title="Export in Pdf">
                                            <i class="fa fa-file-pdf-o"></i>
                                        </button>
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="col-sm-12 col-12">
                                        <div class="table-responsive">
                                            <table class="table table-bordered " id="datatables">
                                                <thead>
                                                <tr>
                                                    <th>S.No.</th>
                                                    <th>Employee Name</th>
                                                    <th>Month</th>
                                                    <th>Attendance</th>
                                                    <th>Basic Salary</th>
                                                    <th>OT Hours</th>
                                                    <th>OT Amount</th>
                                                    <th>Transportation</th>
                                                    <th>Accommodation</th>
                                                    <th>Insurance</th>
                                                    <th>Other</th>
                                                    <th>Reimbursement</th>
                                                    <th>Deductions</th>
                                                    {{--                                                    <th>Deductions Reason</th>--}}
                                                    <th>Total Salary</th>
                                                    <th>Paid From</th>
                                                    <th>Paid To</th>
                                                    <th>Action</th>
                                                </tr>
                                                </thead>
                                                <tbody>
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection
@push('footerscript')
    <script src="{{asset('theme/plugins/moment/moment.js')}}"></script>
    <script src="{{asset('theme/plugins/bootstrap-datepicker/js/bootstrap-datepicker.min.js')}}"></script>
    <script src="{{asset('theme/plugins/datatables/jquery.dataTables.min.js')}}"></script>
    <script src="{{asset('theme/plugins/datatables/dataTables.bootstrap.js')}}"></script>
    {{--    <script src="{{asset('theme/plugins/datatables/responsive.bootstrap.min.js')}}"></script>--}}

    <script>
        $(".datepicker1").datepicker({
            format: "M-yyyy",
            startView: "months",
            minViewMode: "months",
            autoclose: true,
        });
        $('#employee_id, #atten_month').on('change', function () {
            $('#datatables').DataTable().draw(false);
        })

        $(function () {
            $('#datatables').DataTable({
                processing: true,
                serverSide: true,
                stateSave: true,
                responsive: true,
                ajax: {
                    url: '{{route('employeeSalary.getData') }}',
                    data: function (d) {
                        d.id = $('#employee_id').val();
                        d.month = $('#atten_month').val();
                    },
                },
                columns: [
                    {data: 'DT_RowIndex', name: 'DT_RowIndex', searchable: false},
                    {data: 'name', name: 'name'},
                    {data: 'month', name: 'month'},
                    {data: 'total_days', name: 'total_days'},
                    {data: 'basic_salary', name: 'basic_salary'},
                    {data: 'total_ot_hours', name: 'total_ot_hours'},
                    {data: 'total_ot_amount', name: 'total_ot_amount'},
                    {data: 'transportation', name: 'transportation'},
                    {data: 'accommodation', name: 'accommodation'},
                    {data: 'insurance', name: 'insurance'},
                    {data: 'others', name: 'others'},
                    {data: 'reimbursement', name: 'reimbursement'},
                    {data: 'deductions', name: 'deductions'},
                    // {data: 'deduction_resson', name: 'deduction_resson'},
                    {data: 'total_salary', name: 'total_salary'},
                    {data: 'paid_from', name: 'paid_from'},
                    {data: 'paid_to', name: 'paid_to'},
                    {data: 'action', name: 'action', orderable: false, searchable: false},
                ]
            });
        });

        function exportsExcel() {
            var id = $('#employee_id').val();
            var month = $('#atten_month').val();
            window.location.href = "{{route('employeeSalary.exportExcel')}}?id=" + id + "&month=" + month;
        }

        function exportsPdf() {
            var id = $('#employee_id').val();
            var month = $('#atten_month').val();
            window.location.href = "{{route('employeeSalary.exportPdf')}}?id=" + id + "&month=" + month;
        }
    </script>
@endpush