@extends('layouts.admin')


@push('styles')
<link rel="stylesheet" href="{{ asset('plugins/datatables-bs4/css/dataTables.bootstrap4.min.css') }}">
<link rel="stylesheet" href="{{ asset('plugins/datatables-responsive/css/responsive.bootstrap4.min.css') }}">
<link rel="stylesheet" href="{{ asset('plugins/datatables-buttons/css/buttons.bootstrap4.min.css') }}">
<style type="text/css">
    .btn_mt {
        margin-top: 31px;
    }
</style>
@endpush


@section('content')

<!-- Main content -->
<section class="content">
    <div class="container-fluid pt-2">
        <div class="col-md-12">
            <!-- general form elements -->
            <div class="card card-info">

                <!-- form start -->
                <form method="GET" action="{{ route('ocbonus.report') }}">
                    <div class="card-body">

                        <div class="row">


                            <div class="col-sm-2">
                                <div class="form-group">
                                    <label for="bonus_id">Oc. Bonus Type</label>

                                    <select name="bonus_id" id="bonus_id" class="form-control form-control-sm select2" value=""
                                        style="width: 100%;" required>
                                        <option value="">Select Bonus</option>

                                        <option value="1" {{ isset($bonus_id) && ($bonus_id == 1) ? 'selected' : '' }}> Eid Ul Fitr </option>

                                        <option value="2" {{ isset($bonus_id) && ($bonus_id == 2) ? 'selected' : '' }}> Eid Ul Adha </option>
                                        <option value="3" {{ isset($bonus_id) && ($bonus_id == 3) ? 'selected' : '' }}> Encourage Bonus </option>


                                    </select>
                                </div>
                            </div>

                            <div class="col-sm-2">
                                <div class="form-group">
                                    <label for="department_id">Department</label>

                                    <select name="department_id" id="department_id" class="form-control form-control-sm select2" value=""
                                        style="width: 100%;">
                                        <option value="">Select Department</option>
                                        @foreach ($departments as $v)
                                        <option value="{{ $v->id }}"
                                            {{ isset($department_id) && ($department_id == $v->id) ? 'selected' : '' }}>
                                            {{ $v->department_name }}
                                        </option>
                                        @endforeach

                                    </select>
                                </div>
                            </div>

                            <div class="col-sm-2">
                                <div class="form-group">
                                    <label for="designation_id">Designation</label>

                                    <select name="designation_id" id="designation_id" class="form-control form-control-sm select2" value=""
                                        style="width: 100%;">
                                        <option value="">Select Designation</option>
                                        @foreach ($designations as $v)
                                        <option value="{{ $v->id }}"
                                            {{ isset($designation_id) && ($designation_id == $v->id) ? 'selected' : '' }}>
                                            {{ $v->designation }}
                                        </option>
                                        @endforeach

                                    </select>
                                </div>
                            </div>

                            <div class="col-sm-2">
                                <div class="form-group">
                                    <label for="emp_id">Employee</label>

                                    <select id="emp_id" name="emp_id" class="form-control form-control-sm select2"
                                        value="" style="width: 100%;">
                                        <option value="">Select Employee</option>
                                        @foreach ($employees as $v)
                                        <option value="{{ $v->id }}"
                                            {{ isset($emp_id) && $emp_id == $v->id ? 'selected' : '' }}>
                                            {{ $v->emp_name }}
                                        </option>
                                        @endforeach

                                    </select>
                                </div>
                            </div>

                            <div class="col-sm-2">
                                <div class="form-group">
                                    <label for="emp_id">Month:</label>

                                    <select class="form-control form-control-sm" id="month" name="month" required>

                                        @php

                                        $monthNames = [
                                        ["short" => "", "full" => "Select Month"],
                                        ["short" => "01", "full" => "January"],
                                        ["short" => "02", "full" => "February"],
                                        ["short" => "03", "full" => "March"],
                                        ["short" => "04", "full" => "April"],
                                        ["short" => "05", "full" => "May"],
                                        ["short" => "06", "full" => "June"],
                                        ["short" => "07", "full" => "July"],
                                        ["short" => "08", "full" => "August"],
                                        ["short" => "09", "full" => "September"],
                                        ["short" => "10", "full" => "October"],
                                        ["short" => "11", "full" => "November"],
                                        ["short" => "12", "full" => "December"],
                                        ];

                                        @endphp

                                        @foreach ($monthNames as $mon)
                                        <option value="{{ $mon['short'] }}" {{ isset($month) && ($mon['short'] == $month) ? 'selected' : '' }}>
                                            {{ $mon['full'] }}
                                        </option>
                                        @endforeach

                                    </select>
                                </div>
                            </div>

                            <div class="col-sm-2">
                                <div class="form-group">
                                    <label for="emp_id">Year:</label>

                                    <select class="form-control form-control-sm" name="year" id="year" required>
                                        @php
                                        $startYear = 2023; // Change to your desired start year
                                        $endYear = date('Y'); // Current year
                                        @endphp

                                        @for ($yer = $endYear; $yer >= $startYear; $yer--)
                                        <option value="{{ $yer }}" {{ isset($year) && ($yer == $year ) ? 'selected' : '' }}>
                                            {{ $yer }}
                                        </option>
                                        @endfor
                                    </select>

                                </div>
                            </div>

                            <div class="col-sm-2">
                                <div class="form-group">
                                    <label for="search"></label>
                                    <button type="submit" class="btn btn-info btn-sm btn_mt">Search</button>
                                    <a href="{{ route('ocbonus.index') }}"
                                        class="btn btn-secondary btn-sm btn_mt">Refresh</a>
                                </div>
                            </div>
                        </div>
                    </div>
                </form>
            </div>
        </div>

        <!-- /.card -->

        <div class="row">
            <!-- left column -->
            <div class="col-md-12">
                <div class="card card-info">
                    <div class="card-header">
                        <h3 class="card-title">Salary Report</h3>
                    </div>
                    <!-- /.card-header -->
                    <div class="card-body">

                        <div class="row mb-2">
                            <div class="col-sm-12">
                                <button id="excelExport" type="button"
                                    class="btn btn-success btn-sm pro_excel float-right">Excel</button>
                            </div>
                        </div>

                        <div id="table2excel" class="table-responsive">
                            <table class="table table-bordered table-striped table-sm">
                                <thead>
                                    <tr>
                                        <th>SL</th>
                                        <th>Emp.ID</th>

                                        <th>Entry Date</th>
                                        <th>Month & Year</th>

                                        <th>Emp.Name</th>
                                        <th>Department</th>
                                        <th>Designation</th>
                                        <th>Mobile No</th>
                                        <th>Joining Date </th>
                                        <th>BonusType</th>
                                        <th>Gross Salary</th>
                                        <th>Bonus(%)</th>
                                        <th>Bonus Amount</th>

                                        <th>Paid Date</th>

                                    </tr>


                                </thead>
                                <tbody>
                                    @if ( count($empList) > 0 )
                                    @php
                                    $sl = 1;

                                    $payable_net_amt_total = 0;

                                    @endphp

                                    @foreach ($empList as $key => $emp)


                                    @php

                                    $dpt_id = $emp->dpt_id;
                                    $designation_id = $emp->designation_id;
                                    $entrydate = $emp->entrydate;
                                    $salary_month = $emp->salary_month;
                                    $salary_year = $emp->salary_year;
                                    $pay_date = $emp->pay_date;
                                    $note = $emp->note;
                                    $emp_id = $emp->emp_id;
                                    $gross_salary = $emp->gross_salary;
                                    $bonus_per = $emp->bonus_per;
                                    $bonus_id = $emp->bonus_id;
                                    $payable_net_amt = $emp->payable_net_amt;

                                    $paid_date = Helper::dateFormate($emp->paid_date);

                                    if($bonus_id == 1){

                                    $bonus_type = 'Eid Ul Fitr';

                                    }elseif($bonus_id == 2){
                                    $bonus_type = 'Eid Ul Adha';

                                    }


                                    $dateTime = DateTime::createFromFormat('!m', $emp->salary_month);

                                    $mont = $dateTime->format('F');

                                    $payable_net_amt_total = $payable_net_amt_total + $payable_net_amt;


                                    @endphp


                                    <tr>
                                        <td>

                                            {{ $sl++ }}

                                        </td>

                                        <td> {{ $emp->empID }} </td>

                                        <td> {{ Helper::dateFormate($emp->entrydate) }} </td>
                                        <td> {{ $mont }}, {{ $emp->salary_year }} </td>

                                        <td>{{ $emp->emp_name }}</td>
                                        <td>{{ $emp->department_name }}</td>
                                        <td>{{ $emp->designation }}</td>
                                        <td>{{ $emp->phone }}</td>
                                        <td>{{ Helper::dateFormate($emp->joining_date) }}</td>

                                        <td>{{ $bonus_type }} </td>
                                        <td>{{ $gross_salary }} </td>
                                        <td>{{ $bonus_per }} </td>
                                        <td> {{$payable_net_amt}} </td>
                                        <td>{{$paid_date}} </td>

                                    </tr>
                                    @endforeach

                                    <tr>


                                        <th style="text-align: right;" colspan="12">Total : </th>
                                        <th> {{ $payable_net_amt_total }} </th>
                                        <th></th>
                                    </tr>



                                    @endif
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>
<!-- /.content -->
@endsection

@push('scripts')
<script src="{{ asset('plugins/datatables/jquery.dataTables.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-bs4/js/dataTables.bootstrap4.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-responsive/js/dataTables.responsive.min.js') }}"></script>

<script src="{{ asset('plugins/datatables-responsive/js/responsive.bootstrap4.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-buttons/js/dataTables.buttons.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-buttons/js/buttons.bootstrap4.min.js') }}"></script>
<script src="{{ asset('plugins/jszip/jszip.min.js') }}"></script>
<script src="{{ asset('plugins/pdfmake/pdfmake.min.js') }}"></script>
<script src="{{ asset('plugins/pdfmake/vfs_fonts.js') }}"></script>
<script src="{{ asset('plugins/datatables-buttons/js/buttons.html5.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-buttons/js/buttons.print.min.js') }}"></script>
<script src="{{ asset('plugins/datatables-buttons/js/buttons.colVis.min.js') }}"></script>

<script src="{{ asset('plugins/select2/js/select2.full.min.js') }}"></script>
<script src="{{ asset('js/jquery.table2excel.js') }}"></script>

<script>
    $(function() {

        $("#department_id").change(function() {

            if ($(this).val()) {

                let department_id = $(this).val();

                let route = "{{ route('emp.deptemp') }}";

                $("#designation_id").html('');

                $.get(route, {
                        department_id: department_id
                    })
                    .done(function(data) {

                        if (data) {

                            $("#designation_id").html(data);

                        }

                    });

            }

        });


        $("#designation_id").change(function() {

            if ($(this).val()) {

                let designation_id = $(this).val();

                let route = "{{ route('emp.disemp') }}";

                $("#emp_id").html('');

                $.get(route, {
                        designation_id: designation_id
                    })
                    .done(function(data) {

                        if (data) {

                            $("#emp_id").html(data);

                        }

                    });

            }

        });


        $("#excelExport").click(function() {
            $("#table2excel").table2excel({
                exclude: ".noExl",
                name: "Salary_Sheet",
                filename: "Salary_Sheet",
                fileext: ".xls"
            });
        });

        $('#formdate').datetimepicker({
            format: 'DD-MM-YYYY'
        });

        $('#todate').datetimepicker({
            format: 'DD-MM-YYYY'
        });

        // $('.select2').select2()

        $('.select2bs4').select2({
            theme: 'bootstrap4'
        });

        $("#example1").DataTable({
            "pageLength": 1000,
            "responsive": true,
            "lengthChange": false,
            "autoWidth": false,
            buttons: [{
                    extend: 'excel',
                },
                {
                    extend: 'pdf',
                },
                {
                    extend: 'print',
                },
                'colvis'
            ]

        }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');

        $('#example2').DataTable({
            "paging": true,
            "lengthChange": false,
            "searching": false,
            "ordering": true,
            "info": true,
            "autoWidth": false,
            "responsive": true,
        });

    });
</script>
@endpush