@include('partials.reportHead.index')

<style>
    table tbody tr td{
        color: black;
    }
</style>

<table class="table table-bordered table-condensed table-striped">
    <thead>
        <tr>
            <th rowspan="3">SL#</th>
            <th rowspan="3">Name of Staff</th>
            <th rowspan="3">Designation</th>
            <th rowspan="3">ID</th>
            <th colspan="{{ $particulars->count() }}">Taxable Amount Calculation</th>
            <th rowspan="3">Total Yearly Income</th>
            <th rowspan="3">Exemption</th>
            <th rowspan="3">Net Taxable Income</th>
            <th colspan="{{ $slabs->max('sort_order') * 2 + 2 }}">Tax Calculation</th>
            <th rowspan="3">Rebate On Maximum Investment</th>
            <th rowspan="3">Net Tax Payable</th>
            <th rowspan="3">Total Tax Pays For Curent Year</th>
            <th rowspan="3">Total Tax Due For Curent Year</th>
        </tr>

        <tr>
            <th colspan="{{ $particulars->where('salary_type', 'main_salary')->count() }}">Year Total Salary & Allowance
                Income</th>
            <th colspan="{{ $particulars->where('salary_type', 'bonus_or_others')->count() }}">Year Oter Benifit Income
            </th>
            <th colspan="{{ $particulars->where('salary_type', 'org_contribution')->count() }}">Org. Contribution
            </th>

            @php
                $lastOrder = $slabs->max('sort_order');
            @endphp

            @foreach ($slabsOrders as $slabsOrder)
                @php
                    $thisOrderSlabs = $slabs->where('sort_order', $slabsOrder);
                    $text = $thisOrderSlabs->max('taxable_percentage') . '% Upto M. ' . ($thisOrderSlabs->where('gender', 'Male')->max('taxable_amount') / 100000) . ' L., F. ' . ($thisOrderSlabs->where('gender', 'Female')->max('taxable_amount') / 100000). ' L.';
                    if ($thisOrderSlabs->max('sort_order') == $lastOrder) {
                        $text = $thisOrderSlabs->max('taxable_percentage') . '% Tax for Next Rest of Amount';
                    }
                @endphp
                <th colspan="2">{{ $text }}</th>
            @endforeach
            <th colspan="2">Total Taxable Amount & TAX</th>
        </tr>


        <tr>


            @foreach ($particulars as $particular)
                <th>{{ $particular->short_name }}</th>
            @endforeach

            {{-- <th>Basic</th> --}}
            {{-- <th>H. Rent</th>
            <th>Con.</th>
            <th>DA. Allow.</th>
            <th>Medical Allow.</th>
            <th>Gross Salary</th>
            <th>PFC Org.</th>
            <th>Gratuity Org.</th>
            <th>Con. WF Org.</th>
            <th>Total Salary</th>
            <th>Bonus</th>
            <th>Others</th>
            <th>Sub. Total</th> --}}

            @foreach ($slabsOrders as $slabsOrder)
                <th>Amount</th>
                <th>Tax</th>
            @endforeach

            <th>Amount</th>
            <th>Tax</th>
        </tr>
    </thead>

    <tbody>
        @php
            $slNo = 1;
        @endphp
        @foreach ($employees as $employee)
            {{-- @php
            dd($employee);
        @endphp --}}
            <tr>
                <td style="width: 40px; text-align: center;">{{ $slNo++ }}</td>
                <td>{{ $employee->emp_name_english }}</td>
                <td>{{ $employee->position_name }}</td>
                <td>{{ $employee->emp_id }}</td>
                @foreach ($particulars as $particular)
                    <td class="amount">{{ number_format(@$employee->particular[$particular->id]) }}</td>
                @endforeach
                <td class="amount">{{ number_format(array_sum($employee->particular)) }}</td>
                <td class="amount">{{ number_format($employee->exemptionAmount) }}</td>
                <td class="amount">{{ number_format($employee->taxableIncome) }}</td>

                @foreach ($slabsOrders as $slabsOrder)
                    <td class="amount">{{ number_format(@$employee->slabAmounts[$slabsOrder]['slabAmount']) }}</td>
                    <td class="amount">{{ number_format(@$employee->slabAmounts[$slabsOrder]['incomeTaxAmount']) }}</td>
                @endforeach

                <td class="amount">{{ number_format($employee->taxableIncome) }}</td>
                <td class="amount">{{ number_format(@$employee->incomeTaxAmount) }}</td>
                <td class="amount">{{ number_format(@$employee->rebateAmount) }}</td>
                <td class="amount">{{ number_format(@$employee->netTaxPayable) }}</td>
                <td class="amount">{{ number_format(@$employee->paidTaxAmount) }}</td>
                <td class="amount">{{ number_format(@$employee->dueTaxAmount) }}</td>
            </tr>
        @endforeach

        <tfoot>
            <tr>
                <td colspan="4" style="text-align: center; vertical-align: middle;">Total</td>
                @foreach ($particulars as $particular)
                @php
                    $totalParticularAmount = $employees->sum(function ($employee) use ($particular) {
                        return $employee->particular[$particular->id];
                    });
                @endphp
                    <td class="amount">{{ number_format($totalParticularAmount) }}</td>
                @endforeach

                @php
                $totalIncome = $employees->sum(function ($employee) {
                        return array_sum($employee->particular);
                    });
                @endphp
                <td class="amount">{{ number_format($totalIncome) }}</td>
                <td class="amount">{{ number_format($employees->sum('exemptionAmount')) }}</td>
                <td class="amount">{{ number_format($employees->sum('taxableIncome')) }}</td>
                
                @foreach ($slabsOrders as $slabsOrder)
                @php
                    $totalSlabIncomeTaxAmount = $employees->sum(function ($employee) use($slabsOrder) {
                        return (int) @$employee->slabAmounts[$slabsOrder]['incomeTaxAmount'];
                    });
                    @endphp
                    <td></td>
                    <td class="amount">{{ number_format($totalSlabIncomeTaxAmount) }}</td>
                @endforeach

                <td class="amount">{{ number_format($employees->sum('taxableIncome')) }}</td>
                <td class="amount">{{ number_format($employees->sum('incomeTaxAmount')) }}</td>
                <td class="amount">{{ number_format($employees->sum('rebateAmount')) }}</td>
                <td class="amount">{{ number_format($employees->sum('netTaxPayable')) }}</td>
                <td class="amount">{{ number_format($employees->sum('paidTaxAmount')) }}</td>
                <td class="amount">{{ number_format($employees->sum('dueTaxAmount')) }}</td>
            </tr>
        </tfoot>
    </tbody>
</table>

<style>
    td.amount{
        text-align: right;
        padding-right: 5px;
    }
    tfoot tr td{
        font-weight: bold;
    }
</style>