@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('salary.report') }}">
                    <div class="card-body">

                        <div class="row">

                            <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('salary.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 rowspan="2">SL</th>
                                        <th rowspan="2">Emp.ID</th>

                                        <th rowspan="2">Entry Date</th>
                                        <th rowspan="2">Month & Year</th>

                                        <th rowspan="2">Emp.Name</th>
                                        <th rowspan="2">Department</th>
                                        <th rowspan="2">Designation</th>
                                        <th rowspan="2">Mobile No</th>
                                        <th rowspan="2">Joining Date </th>
                                        <th rowspan="2">Gross Salary</th>
                                        <th rowspan="2">Basic</th>
                                        <th rowspan="2">House Rent</th>
                                        <th rowspan="2">Medical</th>
                                        <th rowspan="2">Travel Allowance</th>
                                        <th rowspan="2">Food Allowance</th>

                                        <th colspan="3" style="text-align: center;">Work Day</th>

                                        <th colspan="3" style="text-align: center;">Overtime</th>

                                        <th rowspan="2">Absent (Deda. Amt.)</th>
                                        <th rowspan="2">Allownce</th>
                                        <th rowspan="2">Payable Net Salary</th>

                                        <th rowspan="2">Loan given</th>
                                        <th rowspan="2">Loan Adj.</th>
                                        <th rowspan="2">Stamp Deduc</th>
                                        <th rowspan="2">Payable Net Amount</th>
                                        <th rowspan="2">Signature</th>
                                        <th rowspan="2">Comments</th>
                                        <th rowspan="2">Paid Date</th>

                                    </tr>

                                    <tr>

                                        <th>Days</th>
                                        <th>Absent</th>
                                        <th>Total</th>

                                        <th>Hr</th>
                                        <th>Rt</th>
                                        <th>Total</th>

                                    </tr>

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

                                    $t_gross_salary = 0;
                                    $t_basic = 0;
                                    $t_houseRent = 0;
                                    $t_medical = 0;
                                    $t_travelAllowance = 0;
                                    $t_foodAllowance = 0;
                                    $t_days = 0;
                                    $t_absent = 0;
                                    $t_workdays = 0;
                                    $t_hr = 0;
                                    $t_rt = 0;
                                    $t_total_overtime = 0;
                                    $t_abs_deda_amt = 0;
                                    $t_allownce = 0;
                                    $t_payable_net_salary = 0;
                                    $t_loan_given = 0;
                                    $t_loan_adj = 0;
                                    $t_stamp_deduc = 0;

                                    $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;
                                    $basic = $emp->basic;
                                    $days = $emp->days;
                                    $absent = $emp->absent;
                                    $workdays = $emp->workdays;
                                    $hr = $emp->hr;
                                    $rt = $emp->rt;
                                    $total_overtime = $emp->total_overtime;
                                    $abs_deda_amt = $emp->abs_deda_amt;
                                    $allownce = $emp->allownce;
                                    $payable_net_salary = $emp->payable_net_salary;
                                    $loan_given = $emp->loan_given;
                                    $loan_adj = $emp->loan_adj;
                                    $stamp_deduc = $emp->stamp_deduc;
                                    $payable_net_amt = $emp->payable_net_amt;
                                    $signature = $emp->signature;
                                    $comments = $emp->comments;
                                    $paid_date = $emp->paid_date;

                                    $medical = $emp->medical;
                                    $travelAllowance = $emp->travelAllowance;
                                    $foodAllowance = $emp->foodAllowance;
                                    $basic = $emp->basic;
                                    $houseRent = $emp->houseRent;

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

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


                                    $t_gross_salary = $t_gross_salary + $gross_salary;
                                    $t_basic = $t_basic + $basic;
                                    $t_houseRent = $t_houseRent + $houseRent;
                                    $t_medical = $t_medical + $medical;
                                    $t_travelAllowance = $t_travelAllowance + $travelAllowance;
                                    $t_foodAllowance = $t_foodAllowance + $foodAllowance;
                                    $t_days = $t_days + $days;
                                    $t_absent = $t_absent + $absent;
                                    $t_workdays = $t_workdays + $workdays;
                                    $t_hr = $t_hr + $hr;
                                    $t_rt = $t_rt + $rt;
                                    $t_total_overtime = $t_total_overtime + $total_overtime;
                                    $t_abs_deda_amt = $t_abs_deda_amt + $abs_deda_amt;
                                    $t_allownce = $t_allownce + $allownce;
                                    $t_payable_net_salary = $t_payable_net_salary + $payable_net_salary;
                                    $t_loan_given = $t_loan_given + $loan_given;
                                    $t_loan_adj = $t_loan_adj + $loan_adj;
                                    $t_stamp_deduc = $t_stamp_deduc + $stamp_deduc;


                                    $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>{{ $gross_salary }} </td>
                                        <td> {{ $basic }} </td>

                                        <td>{{ $houseRent }} </td>
                                        <td>{{ $medical }} </td>
                                        <td>{{ $travelAllowance }} </td>
                                        <td>{{ $foodAllowance }} </td>

                                        <td> {{ $days }}</td>
                                        <td> {{ $absent }} </td>
                                        <td> {{ $workdays }} </td>

                                        <td> {{$hr}}</td>
                                        <td> {{$rt}}</td>

                                        <td> {{$total_overtime}} </td>

                                        <td> {{$abs_deda_amt}} </td>

                                        <td> {{$allownce}}</td>

                                        <td> {{$payable_net_salary}} </td>


                                        <td> {{$loan_given}} </td>

                                        <td> {{$loan_adj}} </td>

                                        <td> {{$stamp_deduc}} </td>


                                        <td> {{$payable_net_amt}} </td>


                                        <td> {{$signature}} </td>

                                        <td>{{$comments}}</td>

                                        <td>{{$paid_date}} </td>

                                    </tr>
                                    @endforeach

                                    <tr>


                                        <th style="text-align: right;" colspan="9">Total : </th>

                                        <th> {{ $t_gross_salary }} </th>
                                        <th> {{ $t_basic }} </th>
                                        <th> {{ $t_houseRent }} </th>
                                        <th> {{ $t_medical }} </th>
                                        <th> {{ $t_travelAllowance }} </th>
                                        <th> {{ $t_foodAllowance }} </th>
                                        <th> {{ $t_days }} </th>
                                        <th> {{ $t_absent }} </th>
                                        <th> {{ $t_workdays }} </th>
                                        <th> {{ $t_hr }} </th>
                                        <th> {{ $t_rt }} </th>
                                        <th> {{ $t_total_overtime }} </th>
                                        <th> {{ $t_abs_deda_amt }} </th>
                                        <th> {{ $t_allownce }} </th>
                                        <th> {{ $t_payable_net_salary }} </th>
                                        <th> {{ $t_loan_given }} </th>
                                        <th> {{ $t_loan_adj }} </th>
                                        <th> {{ $t_stamp_deduc }} </th>

                                        <th> {{ $payable_net_amt_total }} </th>
                                        <th></th>
                                        <th></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="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.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,
        });

    });


    $("#excelExport").click(function() {
        var table = document.getElementById("table2excel");
        var wb = XLSX.utils.table_to_book(table, {
            sheet: "Salary Report"
        });
        XLSX.writeFile(wb, "Salary_Sheet.xlsx");
    });
</script>
@endpush