@extends('dashboard.layouts.app')

@section('content')
    @include('components.alert')
    <div class="container-fluid">
        <div class="row">
            <div class="col-12">
                <div class="card h-100 border-0 shadow-sm overflow-hidden p-3">
                    <div class="card-header border-bottom py-3 px-5 d-flex align-items-center justify-content-between">
                        <h5 class="mb-0">Payroll Details (Per Staff)</h5>
                        @php
                            $currentMonth = now()->month;
                            $currentYear = now()->year;
                            $monthParam = request('month');
                            $yearParam = request('year');
                            $isAllMonth = ($monthParam === 'all');
                            $isAllYear = ($yearParam === 'all');
                            $selectedMonth = $isAllMonth ? null : (int) ($monthParam ?: $currentMonth);
                            $selectedYear = $isAllYear ? null : (int) ($yearParam ?: $currentYear);
                            $selectedMonthName = $selectedMonth ? date('F', mktime(0, 0, 0, $selectedMonth, 10)) : 'All months';
                            $selectedYearLabel = $selectedYear ? (string) $selectedYear : 'All years';
                            $canCheckRun = !is_null($selectedMonth) && !is_null($selectedYear);
                            $runExistsForSelected = $canCheckRun ? DB::table("payroll_runs")->where('month', $selectedMonth)->where('year', $selectedYear)->exists() : null;
//                             \App\Models\PayrollRun::where('month', $selectedMonth)->where('year', $selectedYear)->exists() : null;
                            $isCurrentSelection = $canCheckRun && ($selectedMonth === $currentMonth && $selectedYear === $currentYear);
                            $currentMonthName = date('F', mktime(0, 0, 0, $currentMonth, 10));
                        @endphp
                        <div class="text-end">
                            @if (!$canCheckRun)
                                <span class="badge bg-info">Showing {{ $selectedMonthName }} {{ $selectedYearLabel }}</span>
                            @else
                                <span class="badge {{ $runExistsForSelected ? 'bg-success' : 'bg-secondary' }}">
                {{ $runExistsForSelected ? 'Run' : 'Not run' }} for {{ $selectedMonthName }} {{ $selectedYearLabel }}
              </span>
                            @endif
                        </div>
                    </div>

                    <div class="card-body">
                        <!-- Search by Month and Year -->
                        <form action="" method="GET" class="mb-4">
                            <div class="row g-2 align-items-end">
                                <div class="col-md-4">
                                    <label for="month" class="form-label">Select Month</label>
                                    <select disabled  name="month" id="month" class="form-control">
                                        <option value="all"  {{ $isAllMonth ? 'selected' : '' }}>All months</option>
                                        @for ($m = 1; $m <= 12; $m++)
                                            @php $mName = date('F', mktime(0, 0, 0, $m, 10)); @endphp
                                            <option value="{{ $m }}" {{ (!$isAllMonth && (int)request('month', $selectedMonth ?? 0) === $m) ? 'selected' : '' }}>
                                                {{ $mName }}
                                            </option>
                                        @endfor
                                    </select>
                                </div>
                                <div class="col-md-4">
                                    <label for="year" class="form-label">Select Year</label>
                                    <select disabled name="year" id="year" class="form-control">
                                        @php $thisYear = (int)now()->year; @endphp
                                        <option value="all" {{ $isAllYear ? 'selected' : '' }}>All years</option>
                                        @for ($y = $thisYear + 1; $y >= $thisYear - 5; $y--)
                                            <option value="{{ $y }}" {{ (!$isAllYear && (int)request('year', $selectedYear ?? 0) === (int)$y) ? 'selected' : '' }}>
                                                {{ $y }}
                                            </option>
                                        @endfor
                                    </select>
                                </div>
{{--                                <div class="col-md-4">--}}
{{--                                    <button type="submit" class="btn btn-primary">Search</button>--}}
{{--                                    <a href="{{ route('payroll.saff') }}" class="btn btn-secondary">Clear</a>--}}
{{--                                </div>--}}
                            </div>
                        </form>

                        <div class="row mb-4">
                            <div class="col-md-12 mb-2 d-flex gap-2 justify-content-end">
                                @if($canCheckRun && $runExistsForSelected)
{{--                                    <a href="{{ route('payroll.saff.export.pdf', ['month' => $selectedMonth, 'year' => $selectedYear]) }}" target="_blank" class="btn btn-outline-danger btn-sm">View PDF</a>--}}
{{--                                    <a href="{{ route('payroll.saff.export.csv', ['month' => $selectedMonth, 'year' => $selectedYear]) }}" class="btn btn-outline-success btn-sm">Export CSV</a>--}}
                                @endif
                            </div>
                            <div class="col-md-4">
                                <div class="card border-0 shadow-sm">
                                    <div class="card-body">
                                        <div class="small text-muted">Total Gross Salaries</div>
                                        <div class="fs-4 text-primary fw-semibold">{{ number_format($totalGross, 2) }}</div>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-4">
                                <div class="card border-0 shadow-sm">
                                    <div class="card-body">
                                        <div class="small text-muted">Total Net Salaries</div>
                                        <div class="fs-4 text-success fw-semibold">{{ number_format($totalNet, 2) }}</div>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-4">
                                <div class="card border-0 shadow-sm">
                                    <div class="card-body">
                                        <div class="small text-muted">Total Bonuses </div>
                                        <div class="fs-4 text-success fw-semibold">{{ $bonuses_total }}</div>
                                    </div>
                                </div>
                            </div>



                            <div class="col-md-4">
                                <div class="card border-0 shadow-sm">
                                    <div class="card-body">
                                        <div class="small text-muted">Total Benalties </div>
                                        <div class="fs-4 text-danger fw-semibold">{{ $penalties_total }}</div>
                                    </div>
                                </div>
                            </div>
                        </div>

                        <div class="table-responsive">
                            <table class="text-center table table-bordered table-sm table bordered-table sm-table mb-0">
                                <thead class="">
                                <tr>
                                    <th class="text-center">Staff</th>
                                    <th class="text-center">Pay Period</th>
                                    <th class="text-center">Pay Roll Run  Date</th>
                                    <th class="text-center">Gross Salary</th>
                                    <th class="text-center">Net Salary</th>
                                    <th class="text-center">Payment Method </th>
                                    <th class="text-center">Status</th>
                                </tr>
                                </thead>
                                <tbody>
                                @if(!empty($rows))
                                    @forelse($rows as $row)
                                        @php
                                            $staffName = $row->full_name ?: trim(($row->first_name ?? '') . ' ' . ($row->last_name ?? ''));
                                        @endphp
                                        <tr>
                                            <td>{{ $staffName ?: '—' }}</td>
                                            <td>
                                                @if(!empty($row->run_date))
                                                    {{ \Carbon\Carbon::createFromDate($row->run_date)->firstOfMonth()->format('d-m-y') }}
                                                    -
                                                    {{ \Carbon\Carbon::createFromDate($row->run_date)->endOfMonth()->format('d-m-y') }}
                                                @else
                                                    —
                                                @endif
                                            </td>
                                            <td>
                                                @if(!empty($row->run_date))
                                                    {{ \Illuminate\Support\Carbon::parse($row->run_date)->format('Y-m-d') }}
                                                @else
                                                    —
                                                @endif
                                            </td>
                                            <td>{{ number_format($row->gross_salary, 2) }}</td>
                                            <td>{{ number_format($row->net_salary, 2) }}</td>
                                            {{--                                        <td class="text-success">{{ number_format($row->bonuses, 2) }}</td>--}}
                                            {{--                                        <td class="text-danger">{{ number_format($row->penalties, 2) }}</td>--}}
                                            {{--                                        <td>{{ $row->notes }}</td>--}}
                                            @php
                                                $methods = [
                                                    'cash'         => 'Cash',
                                                    'bank_transfer'=> 'Bank Transfer',
                                                    'wallet'       => 'Wallet',
                                                    'insta_pay'    => 'Insta Pay',
                                                ];
                                            @endphp

                                            <td>

{{ $row->payment_type }}

                                                {{-- <select name="payment_method" class="form-select form-select-sm">
                                                    <option value="">Select Payment Method</option>

                                                    @foreach($methods as $value => $label)
                                                        <option value="{{ $value }}"
                                                            {{ isset($row->payment_method) && $row->payment_method === $value ? 'selected' : '' }}>
                                                            {{ $label }}
                                                        </option>
                                                    @endforeach
                                                </select> --}}

                                            </td>

                                            <td>

                                                @if(isset($row->paid_at))
                                                    <span class="badge bg-success">Paid</span>
                                                @else

                                                    <button type="button"
                                                            class="btn btn-sm btn-outline-primary radius-8 btn-pay"
                                                            data-id="{{ $row->id }}">
                                                        Pay
                                                    </button>

                                                @endif
                                            </td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="9" class="text-center text-muted">No payroll staff data found.</td>
                                        </tr>
                                    @endforelse

                                @endif

                                </tbody>
                                <tfoot class="table-light">
                                <tr>
                                    <td colspan="3" class="fw-semibold">Total</td>
                                    <td class="fw-semibold">{{ number_format($totalGross, 2) }}</td>
                                    <td class="fw-semibold">{{ number_format($totalNet, 2) }}</td>
                                    <td colspan="4"></td>
                                </tr>
                                </tfoot>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@push('scripts')


    <script>
        $(document).on('click', '.btn-pay', function (e) {
            e.preventDefault();
            let rowId = $(this).data('id');
            let button = $(this);
            let payment_method = $(this).closest('tr').find('select[name="payment_method"]').val();
            $.ajax({
               url : "{{route("payroll_invoices.update")}}"  ,
                method: "POST",
                data: {
                    _token: "{{ csrf_token() }}",
                    id   : rowId,
                    is_paid: 1,
                    payment_method : payment_method
                },
                beforeSend: function () {
                    button.prop('disabled', true).text('Processing...');
                },
                success: function (res) {
                    button.closest('td').html('<span class="badge bg-success">Paid</span>');
                },
                error: function () {

                    alert("Error: Something went wrong");
                    button.prop('disabled', false).text('Pay');
                }
            });
        });
    </script>



    <style>
        .table-bordered-table {
            border: 1px solid #dee2e6;
        }
        .table-bordered-table th,
        .table-bordered-table td {
            border: 1px solid #dee2e6;
        }
    </style>
@endpush