@extends('admin.layouts.app')
@section('title', get_setting('site_name').' | '.__('Monthly TDS Report'))
@section('content')
    <div class="row mt-4 mb-4">
        <div class="col-12 col-xl-11 mx-auto">
            <div class="card">
                <div class="card-header d-flex justify-content-between align-items-center flex-wrap">
                    <h5 class="mb-0">{{ \App\Services\PayrollIncomeTaxService::label() }} &mdash; {{ __('Monthly deduction register') }}</h5>
                    <a href="{{ route('payroll.tax.settings') }}" class="btn btn-sm btn-outline-secondary">{{ __('TDS Settings') }}</a>
                </div>
                <div class="card-body">
                    <form method="GET" action="{{ route('tds.report.monthly') }}" class="form-row align-items-end mb-4">
                        <div class="form-group col-md-2">
                            <label class="small text-muted">{{ __('Year') }}</label>
                            <select name="year" class="form-control">
                                @for($y = 2020; $y <= (int) date('Y'); $y++)
                                    <option value="{{ $y }}" @selected((int)$year === $y)>{{ $y }}</option>
                                @endfor
                            </select>
                        </div>
                        <div class="form-group col-md-2">
                            <label class="small text-muted">{{ __('Month') }}</label>
                            <select name="month" class="form-control">
                                @for($m = 1; $m <= 12; $m++)
                                    <option value="{{ $m }}" @selected((int)$month === $m)>{{ \Carbon\Carbon::create(null, $m, 1)->format('F') }}</option>
                                @endfor
                            </select>
                        </div>
                        <div class="form-group col-md-3">
                            <label class="small text-muted">{{ __('Department') }}</label>
                            <select name="department_id" class="form-control select2">
                                <option value="">{{ __('All') }}</option>
                                @foreach($departments as $dept)
                                    <option value="{{ $dept->id }}" @selected((string)$departmentId === (string)$dept->id)>{{ $dept->name }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="form-group col-md-3">
                            <label class="small text-muted">{{ __('Branch') }}</label>
                            <select name="warehouse_id" class="form-control select2">
                                <option value="">{{ __('All') }}</option>
                                @foreach($branches as $branch)
                                    <option value="{{ $branch->id }}" @selected((string)$warehouseId === (string)$branch->id)>{{ $branch->name }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="form-group col-md-2">
                            <button type="submit" class="btn btn-primary btn-block">{{ __('Filter') }}</button>
                        </div>
                        <div class="form-group col-md-2">
                            <button type="submit" name="export" value="excel" class="btn btn-outline-success btn-block">{{ __('Export Excel') }}</button>
                        </div>
                    </form>

                    <div class="row mb-3">
                        <div class="col-md-4"><strong>{{ __('Total gross') }}:</strong> {{ number_format($totalGross, 2) }}</div>
                        <div class="col-md-4"><strong>{{ __('Total taxable') }}:</strong> {{ number_format($totalTaxable, 2) }}</div>
                        <div class="col-md-4"><strong>{{ __('Total TDS') }}:</strong> {{ number_format($totalTds, 2) }}</div>
                    </div>

                    <div class="table-responsive">
                        <table class="table table-bordered table-sm">
                            <thead class="thead-light">
                            <tr>
                                <th>{{ __('Employee') }}</th>
                                <th>{{ __('TIN') }}</th>
                                <th>{{ __('Department') }}</th>
                                <th>{{ __('Branch') }}</th>
                                <th class="text-right">{{ __('Gross') }}</th>
                                <th class="text-right">{{ __('Taxable') }}</th>
                                <th class="text-right">{{ __('TDS') }}</th>
                                <th class="text-right">{{ __('Net') }}</th>
                                <th>{{ __('Status') }}</th>
                            </tr>
                            </thead>
                            <tbody>
                            @forelse($rows as $row)
                                @php $setup = \App\Models\SalarySetup::where('staff_id', $row->staff_id)->first(); @endphp
                                <tr>
                                    <td>{{ $row->staff->user->name ?? '-' }}</td>
                                    <td>{{ $setup?->tin_number ?? '-' }}</td>
                                    <td>{{ $row->staff->department->name ?? '-' }}</td>
                                    <td>{{ $row->staff->warehouse->name ?? '-' }}</td>
                                    <td class="text-right">{{ number_format($row->gross_salary, 2) }}</td>
                                    <td class="text-right">{{ number_format($row->taxable_income ?? 0, 2) }}</td>
                                    <td class="text-right">{{ number_format($row->income_tax, 2) }}</td>
                                    <td class="text-right">{{ number_format($row->net_salary, 2) }}</td>
                                    <td>{{ $row->status }}</td>
                                </tr>
                            @empty
                                <tr><td colspan="9" class="text-center text-muted">{{ __('No TDS deductions for this period.') }}</td></tr>
                            @endforelse
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection