@extends('dashboard.admin.layouts.master')

@section('content')
    @php($statusClasses = ['draft' => 'badge-light-secondary', 'processed' => 'badge-light-info', 'approved' => 'badge-light-primary', 'posted' => 'badge-light-warning', 'paid' => 'badge-light-success'])
    @php($paymentStatusClasses = ['unpaid' => 'badge-light-danger', 'partially_paid' => 'badge-light-warning', 'paid' => 'badge-light-success'])
    <div class="d-flex flex-column flex-column-fluid">
        <div id="kt_app_toolbar" class="app-toolbar py-3 py-lg-6">
            <div id="kt_app_toolbar_container" class="app-container container-xxl d-flex flex-stack">
                <div class="page-title d-flex flex-column justify-content-center flex-wrap me-3">
                    <h1 class="page-heading d-flex text-dark fw-bold fs-3 flex-column justify-content-center my-0">{{ trans('hr.payroll_summary.title') }}</h1>
                </div>
            </div>
        </div>

        <div id="kt_app_content" class="app-content flex-column-fluid">
            <div id="kt_app_content_container" class="app-container container-xxl">
                @if($errors->any())
                    <div class="alert alert-danger mb-7">
                        <ul class="mb-0 ps-6">
                            @foreach($errors->all() as $error)
                                <li>{{ $error }}</li>
                            @endforeach
                        </ul>
                    </div>
                @endif

                <div class="card mb-7">
                    <div class="card-header border-0 pt-6">
                        <div class="card-title">
                            <h2>{{ trans('hr.payroll_summary.filter') }}</h2>
                        </div>
                    </div>
                    <div class="card-body pt-0">
                        <form id="PayrollSummaryFilterForm" method="GET" action="{{ route('admin.dashboard.hr.reports.payroll_summary.index') }}">
                            <input type="hidden" name="filter" value="1">

                            <div class="row g-5">
                                <div class="col-md-4">
                                    <label class="form-label">{{ trans('hr.payroll_summary.payroll_period') }}</label>
                                    <select name="payroll_period_id" class="form-select @error('payroll_period_id') is-invalid @enderror">
                                        <option value="">{{ trans('hr.payroll_summary.all_payroll_periods') }}</option>
                                        @foreach($periods as $period)
                                            <option value="{{ $period->id }}" @selected(($selectedFilters['payroll_period_id'] ?? '') == $period->id)>
                                                {{ $period->code }} ({{ sprintf('%04d-%02d', $period->period_year, $period->period_month) }})
                                            </option>
                                        @endforeach
                                    </select>
                                </div>

                                <div class="col-md-4">
                                    <label class="form-label">{{ trans('hr.payroll_summary.payroll_run') }}</label>
                                    <select name="payroll_run_id" class="form-select @error('payroll_run_id') is-invalid @enderror">
                                        <option value="">{{ trans('hr.payroll_summary.all_payroll_runs') }}</option>
                                        @foreach($payrollRuns as $payrollRun)
                                            <option value="{{ $payrollRun->id }}" @selected(($selectedFilters['payroll_run_id'] ?? '') == $payrollRun->id)>
                                                {{ $payrollRun->code }}{{ $payrollRun->payrollPeriod ? ' - '.$payrollRun->payrollPeriod->code : '' }}{{ $payrollRun->branch ? ' - '.$payrollRun->branch->name : '' }}
                                            </option>
                                        @endforeach
                                    </select>
                                </div>

                                <div class="col-md-4">
                                    <label class="form-label">{{ trans('hr.payroll_summary.branch') }}</label>
                                    <select name="branch_id" class="form-select @error('branch_id') is-invalid @enderror">
                                        <option value="">{{ trans('hr.payroll_summary.all_branches') }}</option>
                                        @foreach($branches as $branch)
                                            <option value="{{ $branch->id }}" @selected(($selectedFilters['branch_id'] ?? '') == $branch->id)>{{ $branch->name }}</option>
                                        @endforeach
                                    </select>
                                </div>

                                <div class="col-md-4">
                                    <label class="form-label">{{ trans('hr.payroll_summary.employee') }}</label>
                                    <select name="employee_id" class="form-select @error('employee_id') is-invalid @enderror">
                                        <option value="">{{ trans('hr.payroll_summary.all_employees') }}</option>
                                        @foreach($employees as $employee)
                                            <option value="{{ $employee->id }}" @selected(($selectedFilters['employee_id'] ?? '') == $employee->id)>{{ $employee->code }} - {{ $employee->name }}</option>
                                        @endforeach
                                    </select>
                                </div>

                                <div class="col-md-4">
                                    <label class="form-label">{{ trans('hr.payroll_summary.run_type') }}</label>
                                    <select name="run_type" class="form-select @error('run_type') is-invalid @enderror">
                                        <option value="">{{ trans('hr.payroll_summary.all_run_types') }}</option>
                                        @foreach($runTypes as $runType)
                                            <option value="{{ $runType }}" @selected(($selectedFilters['run_type'] ?? '') === $runType)>{{ trans('hr.payroll_module.statuses.'.$runType) }}</option>
                                        @endforeach
                                    </select>
                                </div>

                                <div class="col-md-4">
                                    <label class="form-label">{{ trans('hr.payroll_summary.status') }}</label>
                                    <select name="status" class="form-select @error('status') is-invalid @enderror">
                                        <option value="">{{ trans('hr.payroll_summary.all_statuses') }}</option>
                                        @foreach($statuses as $status)
                                            <option value="{{ $status }}" @selected(($selectedFilters['status'] ?? '') === $status)>{{ trans('hr.payroll_module.statuses.'.$status) }}</option>
                                        @endforeach
                                    </select>
                                </div>

                                <div class="col-md-4">
                                    <label class="form-label">{{ trans('hr.payroll_summary.payment_status') }}</label>
                                    <select name="payment_status" class="form-select @error('payment_status') is-invalid @enderror">
                                        <option value="">{{ trans('hr.payroll_summary.all_payment_statuses') }}</option>
                                        @foreach($paymentStatuses as $paymentStatus)
                                            <option value="{{ $paymentStatus }}" @selected(($selectedFilters['payment_status'] ?? '') === $paymentStatus)>{{ trans('hr.payroll_module.statuses.'.$paymentStatus) }}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="d-flex justify-content-end mt-7 gap-3">
                                <a href="{{ route('admin.dashboard.hr.reports.payroll_summary.index') }}" class="btn btn-light">{{ trans('hr.payroll_summary.reset') }}</a>
                                <button type="submit" class="btn btn-primary">{{ trans('hr.payroll_summary.filter') }}</button>
                            </div>
                        </form>
                    </div>
                </div>

                @if($hasFilters)
                    @if($employeeDetails->isEmpty())
                        <div class="alert alert-info mb-7">{{ trans('hr.payroll_summary.no_data_found') }}</div>
                    @endif

                    <div class="row g-5 mb-7">
                        <div class="col-md-2">
                            <div class="card card-flush h-100">
                                <div class="card-header">
                                    <div class="card-title">
                                        <h3>{{ trans('hr.payroll_summary.total_payroll_runs') }}</h3>
                                    </div>
                                </div>
                                <div class="card-body pt-0">
                                    <div class="fs-6 text-gray-700">{{ number_format($overview['total_payroll_runs']) }}</div>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="card card-flush h-100">
                                <div class="card-header">
                                    <div class="card-title">
                                        <h3>{{ trans('hr.payroll_summary.total_employees') }}</h3>
                                    </div>
                                </div>
                                <div class="card-body pt-0">
                                    <div class="fs-6 text-gray-700">{{ number_format($overview['total_employees']) }}</div>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="card card-flush h-100">
                                <div class="card-header">
                                    <div class="card-title">
                                        <h3>{{ trans('hr.payroll_summary.total_basic_salary') }}</h3>
                                    </div>
                                </div>
                                <div class="card-body pt-0">
                                    <div class="fs-6 text-gray-700">{{ number_format($overview['total_basic_salary'], 2) }}</div>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="card card-flush h-100">
                                <div class="card-header">
                                    <div class="card-title">
                                        <h3>{{ trans('hr.payroll_summary.total_earnings') }}</h3>
                                    </div>
                                </div>
                                <div class="card-body pt-0">
                                    <div class="fs-6 text-gray-700">{{ number_format($overview['total_earnings'], 2) }}</div>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="card card-flush h-100">
                                <div class="card-header">
                                    <div class="card-title">
                                        <h3>{{ trans('hr.payroll_summary.total_deductions') }}</h3>
                                    </div>
                                </div>
                                <div class="card-body pt-0">
                                    <div class="fs-6 text-gray-700">{{ number_format($overview['total_deductions'], 2) }}</div>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="card card-flush h-100">
                                <div class="card-header">
                                    <div class="card-title">
                                        <h3>{{ trans('hr.payroll_summary.total_net_salary') }}</h3>
                                    </div>
                                </div>
                                <div class="card-body pt-0">
                                    <div class="fs-6 text-gray-700">{{ number_format($overview['total_net_salary'], 2) }}</div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="card mb-7">
                        <div class="card-header border-0 pt-6">
                            <div class="card-title">
                                <h2>{{ trans('hr.payroll_summary.payroll_totals') }}</h2>
                            </div>
                        </div>
                        <div class="card-body py-4">
                            <div class="table-responsive">
                                <table class="table align-middle table-row-dashed fs-6 gy-5">
                                    <thead>
                                    <tr class="text-start text-muted fw-bold fs-7 text-uppercase gs-0">
                                        <th>{{ trans('hr.payroll_summary.payroll_run') }}</th>
                                        <th>{{ trans('hr.payroll_summary.payroll_period') }}</th>
                                        <th>{{ trans('hr.payroll_summary.branch') }}</th>
                                        <th>{{ trans('hr.payroll_summary.run_type') }}</th>
                                        <th>{{ trans('hr.payroll_summary.status') }}</th>
                                        <th>{{ trans('hr.payroll_summary.payment_status') }}</th>
                                        <th>{{ trans('hr.payroll_summary.total_employees') }}</th>
                                        <th>{{ trans('hr.payroll_summary.basic_salary') }}</th>
                                        <th>{{ trans('hr.payroll_summary.total_earnings') }}</th>
                                        <th>{{ trans('hr.payroll_summary.deductions') }}</th>
                                        <th>{{ trans('hr.payroll_summary.net_salary') }}</th>
                                    </tr>
                                    </thead>
                                    <tbody class="text-gray-600 fw-semibold">
                                    @forelse($payrollTotals as $row)
                                        <tr>
                                            <td>{{ $row->payroll_run_code }}</td>
                                            <td>{{ $row->period_label }}</td>
                                            <td>{{ $row->branch_name }}</td>
                                            <td>{{ trans('hr.payroll_module.statuses.'.$row->run_type) }}</td>
                                            <td><span class="badge {{ $statusClasses[$row->status] ?? 'badge-light-secondary' }}">{{ trans('hr.payroll_module.statuses.'.$row->status) }}</span></td>
                                            <td><span class="badge {{ $paymentStatusClasses[$row->payment_status] ?? 'badge-light-secondary' }}">{{ trans('hr.payroll_module.statuses.'.$row->payment_status) }}</span></td>
                                            <td>{{ number_format($row->total_employees) }}</td>
                                            <td>{{ number_format($row->total_basic_salary, 2) }}</td>
                                            <td>{{ number_format($row->total_earnings, 2) }}</td>
                                            <td>{{ number_format($row->total_deductions, 2) }}</td>
                                            <td>{{ number_format($row->total_net_salary, 2) }}</td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="11" class="text-center py-10">{{ trans('hr.payroll_summary.no_data_found') }}</td>
                                        </tr>
                                    @endforelse
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>

                    <div class="card mb-7">
                        <div class="card-header border-0 pt-6">
                            <div class="card-title">
                                <h2>{{ trans('hr.payroll_summary.employee_payroll_detail') }}</h2>
                            </div>
                        </div>
                        <div class="card-body py-4">
                            <div class="table-responsive">
                                <table class="table align-middle table-row-dashed fs-6 gy-5">
                                    <thead>
                                    <tr class="text-start text-muted fw-bold fs-7 text-uppercase gs-0">
                                        <th>{{ trans('hr.payroll_summary.payroll_run') }}</th>
                                        <th>{{ trans('hr.payroll_summary.employee') }}</th>
                                        <th>{{ trans('hr.payroll_summary.branch') }}</th>
                                        <th>{{ trans('hr.payroll_summary.payroll_period') }}</th>
                                        <th>{{ trans('hr.payroll_summary.line_items') }}</th>
                                        <th>{{ trans('hr.payroll_summary.basic_salary') }}</th>
                                        <th>{{ trans('hr.payroll_summary.total_earnings') }}</th>
                                        <th>{{ trans('hr.payroll_summary.deductions') }}</th>
                                        <th>{{ trans('hr.payroll_summary.net_salary') }}</th>
                                        <th>{{ trans('hr.payroll_summary.status') }}</th>
                                    </tr>
                                    </thead>
                                    <tbody class="text-gray-600 fw-semibold">
                                    @forelse($employeeDetails as $row)
                                        <tr>
                                            <td>{{ $row->payroll_run_code }}</td>
                                            <td>{{ $row->employee_code }}<div class="text-muted small">{{ $row->employee_name }}</div></td>
                                            <td>{{ $row->branch_name }}</td>
                                            <td>{{ $row->period_label }}</td>
                                            <td>{{ number_format($row->line_items_count) }}</td>
                                            <td>{{ number_format($row->basic_salary, 2) }}</td>
                                            <td>{{ number_format($row->total_earnings, 2) }}</td>
                                            <td>{{ number_format($row->total_deductions, 2) }}</td>
                                            <td>{{ number_format($row->net_salary, 2) }}</td>
                                            <td><span class="badge {{ $statusClasses[$row->status] ?? 'badge-light-secondary' }}">{{ trans('hr.payroll_module.statuses.'.$row->status) }}</span></td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="10" class="text-center py-10">{{ trans('hr.payroll_summary.no_data_found') }}</td>
                                        </tr>
                                    @endforelse
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>

                    <div class="row g-5">
                        <div class="col-xl-6">
                            <div class="card h-100">
                                <div class="card-header border-0 pt-6">
                                    <div class="card-title">
                                        <h2>{{ trans('hr.payroll_summary.branch_payroll_cost') }}</h2>
                                    </div>
                                </div>
                                <div class="card-body py-4">
                                    <div class="table-responsive">
                                        <table class="table align-middle table-row-dashed fs-6 gy-5">
                                            <thead>
                                            <tr class="text-start text-muted fw-bold fs-7 text-uppercase gs-0">
                                                <th>{{ trans('hr.payroll_summary.branch') }}</th>
                                                <th>{{ trans('hr.payroll_summary.total_payroll_runs') }}</th>
                                                <th>{{ trans('hr.payroll_summary.total_employees') }}</th>
                                                <th>{{ trans('hr.payroll_summary.total_basic_salary') }}</th>
                                                <th>{{ trans('hr.payroll_summary.total_earnings') }}</th>
                                                <th>{{ trans('hr.payroll_summary.total_deductions') }}</th>
                                                <th>{{ trans('hr.payroll_summary.net_salary') }}</th>
                                            </tr>
                                            </thead>
                                            <tbody class="text-gray-600 fw-semibold">
                                            @forelse($branchCosts as $branchCost)
                                                <tr>
                                                    <td>{{ $branchCost->branch_name }}</td>
                                                    <td>{{ number_format($branchCost->payroll_runs_count) }}</td>
                                                    <td>{{ number_format($branchCost->total_employees) }}</td>
                                                    <td>{{ number_format($branchCost->total_basic_salary, 2) }}</td>
                                                    <td>{{ number_format($branchCost->total_earnings, 2) }}</td>
                                                    <td>{{ number_format($branchCost->total_deductions, 2) }}</td>
                                                    <td>{{ number_format($branchCost->total_net_salary, 2) }}</td>
                                                </tr>
                                            @empty
                                                <tr>
                                                    <td colspan="7" class="text-center py-10">{{ trans('hr.payroll_summary.no_data_found') }}</td>
                                                </tr>
                                            @endforelse
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>

                        <div class="col-xl-6">
                            <div class="card h-100">
                                <div class="card-header border-0 pt-6">
                                    <div class="card-title">
                                        <h2>{{ trans('hr.payroll_summary.deductions_summary') }}</h2>
                                    </div>
                                </div>
                                <div class="card-body py-4">
                                    <div class="table-responsive">
                                        <table class="table align-middle table-row-dashed fs-6 gy-5">
                                            <thead>
                                            <tr class="text-start text-muted fw-bold fs-7 text-uppercase gs-0">
                                                <th>{{ trans('hr.payroll_summary.item_type') }}</th>
                                                <th>{{ trans('hr.payroll_summary.item_name') }}</th>
                                                <th>{{ trans('hr.payroll_summary.total_employees') }}</th>
                                                <th>{{ trans('hr.payroll_summary.total_amount') }}</th>
                                            </tr>
                                            </thead>
                                            <tbody class="text-gray-600 fw-semibold">
                                            @forelse($deductionsSummary as $item)
                                                <tr>
                                                    <td>{{ ucwords(str_replace('_', ' ', $item->item_type)) }}</td>
                                                    <td>{{ $item->item_name }}</td>
                                                    <td>{{ number_format($item->total_employees) }}</td>
                                                    <td>{{ number_format($item->total_amount, 2) }}</td>
                                                </tr>
                                            @empty
                                                <tr>
                                                    <td colspan="4" class="text-center py-10">{{ trans('hr.payroll_summary.no_data_found') }}</td>
                                                </tr>
                                            @endforelse
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="card mt-7">
                        <div class="card-header border-0 pt-6">
                            <div class="card-title">
                                <h2>{{ trans('hr.payroll_summary.earnings_summary') }}</h2>
                            </div>
                        </div>
                        <div class="card-body py-4">
                            <div class="table-responsive">
                                <table class="table align-middle table-row-dashed fs-6 gy-5">
                                    <thead>
                                    <tr class="text-start text-muted fw-bold fs-7 text-uppercase gs-0">
                                        <th>{{ trans('hr.payroll_summary.item_type') }}</th>
                                        <th>{{ trans('hr.payroll_summary.item_name') }}</th>
                                        <th>{{ trans('hr.payroll_summary.total_employees') }}</th>
                                        <th>{{ trans('hr.payroll_summary.total_quantity') }}</th>
                                        <th>{{ trans('hr.payroll_summary.total_amount') }}</th>
                                    </tr>
                                    </thead>
                                    <tbody class="text-gray-600 fw-semibold">
                                    @forelse($earningsSummary as $item)
                                        <tr>
                                            <td>{{ ucwords(str_replace('_', ' ', $item->item_type)) }}</td>
                                            <td>{{ $item->item_name }}</td>
                                            <td>{{ number_format($item->total_employees) }}</td>
                                            <td>{{ number_format($item->total_quantity, 2) }}</td>
                                            <td>{{ number_format($item->total_amount, 2) }}</td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="5" class="text-center py-10">{{ trans('hr.payroll_summary.no_data_found') }}</td>
                                        </tr>
                                    @endforelse
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                @endif
            </div>
        </div>
    </div>
@endsection

@section('js')
    <script type="text/javascript" src="{{ asset('vendor/jsvalidation/js/jsvalidation.js') }}"></script>
    {!! JsValidator::formRequest('App\Http\Requests\Admin\HR\PayrollSummaryFilterRequest', '#PayrollSummaryFilterForm') !!}
@endsection