@extends('main')

@section('css')
@endsection
<style>
    .fixTableHead {
        overflow-y: auto;
        height: 74vh;
    }
    .fixTableHead thead th {
        position: sticky;
        top: 0;
    }
    table {
        border-collapse: collapse;
        width: 100%;
    }
    th {
        background: #eee;
    }
</style>
@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>Payroll</h2>
                        <ul class="breadcrumb">
                            <li class="breadcrumb-item"><a href="#"><i class="icon-home"></i></a></li>
                            <li class="breadcrumb-item">Payroll</li>
                            <li class="breadcrumb-item active">View Monthly Salary Sheet</li>
                        </ul>
                    </div>
                </div>
            </div>
            <div class="row clearfix">
                <div class="col-lg-12">
                    <div class="card mb-0">
                        <div class="header pb-1">
                            <div class="row align-items-center">
                                <div class="col-8">
                                    <h2>View Monthly Salary Sheet</h2>
                                </div>
                                <div class="col-4 d-flex">
                                    <div class="mx-auto">
                                        <button type="button" class="btn btn-success" data-toggle="modal" data-target="#exampleModal">Total Amounts</button>
                                    </div>
                                    <div class="mx-auto">
                                        <form action="{{ route('generateEblExcel') }}" method="GET">
                                            <input type="hidden" name="month" value="{{ $month }}">
                                            <button type="submit" class="btn btn-success">Generate EBL Excel</button>
                                        </form>
                                    </div>
                                    <div class="mx-auto">
                                        <form action="{{ route('generateMonthlySalarySetup') }}" method="GET">
                                            <input type="hidden" name="month" value="{{ $month }}">
                                            <button type="submit" class="btn btn-success">Generate Excel</button>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="body pt-1">
                            <div class="fixTableHead table-responsive">
                                <table class="table table-bordered table-hover table-striped">
                                    <thead>
                                    @php
                                        $totalGrossSalary = 0;
                                        $totalBasic = 0;
                                        $totalHouseRent = 0;
                                        $totalMedicalAllowance = 0;
                                        $totalOtherAllowance = 0;
                                        $totalSalesComission = 0;
                                        $totalFestivalBonus = 0;
                                        $totalMobileBill = 0;
                                        $totalArrear = 0;
                                        $totalTotalPayableSalary = 0;
                                        $totalProvidentFund = 0;
                                        $totalMedicalFund = 0;
                                        $totalSecurityDeposit = 0;
                                        $totalAit = 0;
                                        $totalLoan = 0;
                                        $totalAdjustment = 0;
                                        $totalLateDeduction = 0;
                                        $totalLwp = 0;
                                        $totalOtherAdjustment = 0;
                                        $totalTotalDeduction = 0;
                                        $totalNetPayableSalary = 0;
                                    @endphp
                                    @foreach($monthlyAllowedDeductions as $monthlyAllowedDeduction)
                                        @php
                                            $totalPayableSalary = (float) @$monthlyAllowedDeduction->gross_salary + (float) @$monthlyAllowedDeduction->other_allowance + (float) @$monthlyAllowedDeduction->sales_comission + (float) @$monthlyAllowedDeduction->festival_bonus + (float) @$monthlyAllowedDeduction->mobile_bill + (float) @$monthlyAllowedDeduction->arrear;
                                            $totalDeduction = (float) @$monthlyAllowedDeduction->provident_fund_d + (float) @$monthlyAllowedDeduction->medical_fund_d + (float) @$monthlyAllowedDeduction->security_deposit_d + (float) @$monthlyAllowedDeduction->ait_d + (float) @$monthlyAllowedDeduction->loan_d + (float) @$monthlyAllowedDeduction->adjustment_d + (float) @$monthlyAllowedDeduction->late_deduction_d + (float) @$monthlyAllowedDeduction->lwp_d + (float) @$monthlyAllowedDeduction->other_adjustment_d;
                                            $netPayableSalary = $totalPayableSalary - $totalDeduction;

                                            $totalGrossSalary += (float) $monthlyAllowedDeduction->gross_salary;
                                            $totalBasic += (float) $monthlyAllowedDeduction->basic;
                                            $totalHouseRent += (float) $monthlyAllowedDeduction->house_rent;
                                            $totalMedicalAllowance += (float) $monthlyAllowedDeduction->medical_allowance;
                                            $totalOtherAllowance += (float) $monthlyAllowedDeduction->other_allowance;
                                            $totalSalesComission += (float) $monthlyAllowedDeduction->sales_comission;
                                            $totalFestivalBonus += (float) $monthlyAllowedDeduction->festival_bonus;
                                            $totalMobileBill += (float) $monthlyAllowedDeduction->mobile_bill;
                                            $totalArrear += (float) $monthlyAllowedDeduction->arrear;
                                            $totalTotalPayableSalary +=  $totalPayableSalary;
                                            $totalProvidentFund += (float) $monthlyAllowedDeduction->provident_fund_d;
                                            $totalMedicalFund += (float) $monthlyAllowedDeduction->medical_fund_d;
                                            $totalSecurityDeposit += (float) $monthlyAllowedDeduction->security_deposit_d;
                                            $totalAit += (float) $monthlyAllowedDeduction->ait_d;
                                            $totalLoan += (float) $monthlyAllowedDeduction->loan_d;
                                            $totalAdjustment += (float) $monthlyAllowedDeduction->adjustment_d;
                                            $totalLateDeduction += (float) $monthlyAllowedDeduction->late_deduction_d;
                                            $totalLwp += (float) $monthlyAllowedDeduction->lwp_d;
                                            $totalOtherAdjustment += (float) $monthlyAllowedDeduction->other_adjustment_d;
                                            $totalTotalDeduction += $totalDeduction;
                                            $totalNetPayableSalary += $netPayableSalary;
                                        @endphp
                                    @endforeach
                                    <tr>
                                        <th class="text-center"></th>
                                        <th class="text-center"></th>
                                        <th class="text-center"></th>
                                        <th class="text-center"></th>
                                        <th class="text-center"></th>
                                        <th class="text-center"></th>
                                        <th class="text-center"></th>
                                        <th class="text-center">{{ $totalGrossSalary }}</th>
                                        <th class="text-center">{{ $totalBasic }}</th>
                                        <th class="text-center">{{ $totalHouseRent }}</th>
                                        <th class="text-center">{{ $totalMedicalAllowance }}</th>
                                        <th class="text-center">{{ $totalOtherAllowance }}</th>
                                        <th class="text-center">{{ $totalSalesComission }}</th>
                                        <th class="text-center">{{ $totalFestivalBonus }}</th>
                                        <th class="text-center">{{ $totalMobileBill }}</th>
                                        <th class="text-center">{{ $totalArrear }}</th>
                                        <th class="text-center">{{ $totalTotalPayableSalary }}</th>
                                        <th class="text-center">{{ $totalProvidentFund }}</th>
                                        <th class="text-center">{{ $totalMedicalFund }}</th>
                                        <th class="text-center">{{ $totalSecurityDeposit }}</th>
                                        <th class="text-center">{{ $totalAit }}</th>
                                        <th class="text-center">{{ $totalLoan }}</th>
                                        <th class="text-center">{{ $totalAdjustment }}</th>
                                        <th class="text-center">{{ $totalLateDeduction }}</th>
                                        <th class="text-center">{{ $totalLwp }}</th>
                                        <th class="text-center">{{ $totalOtherAdjustment }}</th>
                                        <th class="text-center">{{ $totalTotalDeduction }}</th>
                                        <th class="text-center">{{ $totalNetPayableSalary }}</th>
                                        <th class="text-center"></th>
                                    </tr>
                                    <tr>
                                        <th class="text-center">SL.No.</th>
                                        <th class="text-center">Employee ID</th>
                                        <th class="text-center">Name of Employee</th>
                                        <th class="text-center">Designation</th>
                                        <th class="text-center">Employment Status</th>
                                        <th class="text-center">Department</th>
                                        <th class="text-center">Joining Date</th>
                                        <th class="text-center">Gross Salary</th>
                                        <th class="text-center">Basic</th>
                                        <th class="text-center">House Rent</th>
                                        <th class="text-center">Medical Allowance</th>
                                        <th class="text-center">Other Allowance</th>
                                        <th class="text-center">Sales Commission</th>
                                        <th class="text-center">Festival Bonus</th>
                                        <th class="text-center">Mobile Bill</th>
                                        <th class="text-center">Arrear</th>
                                        <th class="text-center">Total Payable Salary</th>
                                        <th class="text-center">Provident Fund</th>
                                        <th class="text-center">Medical Fund</th>
                                        <th class="text-center">Security Deposit</th>
                                        <th class="text-center">AIT</th>
                                        <th class="text-center">Loan / Advance</th>
                                        <th class="text-center">Adjustment</th>
                                        <th class="text-center">Late Deduction</th>
                                        <th class="text-center">LWP/ Absence/ Days Work</th>
                                        <th class="text-center">Other Adjustment</th>
                                        <th class="text-center">Total Deduction</th>
                                        <th class="text-center">Net Payable Salary</th>
                                        <th class="text-center">Account Number</th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    @foreach( $monthlyAllowedDeductions as $key => $monthlyAllowedDeduction )
                                        @php
                                            $totalPayableSalary = (float) @$monthlyAllowedDeduction->gross_salary + (float) @$monthlyAllowedDeduction->other_allowance + (float) @$monthlyAllowedDeduction->sales_comission + (float) @$monthlyAllowedDeduction->festival_bonus + (float) @$monthlyAllowedDeduction->mobile_bill + (float) @$monthlyAllowedDeduction->arrear;
                                            $totalDeduction = (float) @$monthlyAllowedDeduction->provident_fund_d + (float) @$monthlyAllowedDeduction->medical_fund_d + (float) @$monthlyAllowedDeduction->security_deposit_d + (float) @$monthlyAllowedDeduction->ait_d + (float) @$monthlyAllowedDeduction->loan_d + (float) @$monthlyAllowedDeduction->adjustment_d + (float) @$monthlyAllowedDeduction->late_deduction_d + (float) @$monthlyAllowedDeduction->lwp_d + (float) @$monthlyAllowedDeduction->other_adjustment_d;
                                            $netPayableSalary = $totalPayableSalary - $totalDeduction;
                                        @endphp
                                        <tr>
                                            <td class="text-center">{{ $key+1 }}</td>
                                            <td class="text-center">{{ $monthlyAllowedDeduction->userAccessPin }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->firstName.' '.@$monthlyAllowedDeduction->middleName.' '.@$monthlyAllowedDeduction->lastName }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->title }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->typeTitle }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->departmentName }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->actualJoinDate }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->gross_salary }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->basic }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->house_rent }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->medical_allowance }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->other_allowance }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->sales_comission }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->festival_bonus }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->mobile_bill }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->arrear }}</td>
                                            <td class="text-center">{{ $totalPayableSalary }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->provident_fund_d }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->medical_fund_d }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->security_deposit_d }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->ait_d }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->loan_d }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->adjustment_d }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->late_deduction_d }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->lwp_d }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->other_adjustment_d }}</td>
                                            <td class="text-center">{{ $totalDeduction }}</td>
                                            <td class="text-center">{{ $netPayableSalary }}</td>
                                            <td class="text-center">{{ @$monthlyAllowedDeduction->bankAccountNo }}</td>
                                        </tr>
                                    @endforeach
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Modal -->
    <div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="exampleModalLabel">Total Amounts</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                    <table class="table table-striped">
                        <thead>
                        <tr>
                            <th>Total Net Salary</th>
                            <th>{{ $totalNetPayableSalary }}</th>
                        </tr>
                        <tr>
                            <th>Total Deduction</th>
                            <th>{{ $totalTotalDeduction }}</th>
                        </tr>
                        <tr>
                            <th>Total Exp-Salary</th>
                            <th>{{ $totalTotalPayableSalary }}</th>
                        </tr>
                        </thead>
                    </table>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                </div>
            </div>
        </div>
    </div>

@endsection
@section('js')
    <script>
        $(document).ready( function () {

        });

        function generateExcel(month) {
            $.ajax({
                type: 'GET',
                url: "{{ route('generateMonthlySalarySetup') }}",
                data: {month: month},
                success: function (data) {
                    const blob = new Blob([data], {type: "application/octetstream"});

                    //Check the Browser type and download the File.
                    const isIE = !!document.documentMode;
                    if (isIE) {
                        window.navigator.msSaveBlob(blob, fileName);
                    } else {
                        var url = window.URL || window.webkitURL;
                        link = url.createObjectURL(blob);
                        var a = $("<a />");
                        a.attr("download", fileName);
                        a.attr("href", link);
                        $("body").append(a);
                        a[0].click();
                        $("body").remove(a);
                    }
                },
                error: function (error) {
                    console.log(error)
                }
            });
        }
    </script>
@endsection