@extends('dashboard.layouts.app')

@section('content')
    <div class="container mt-5">
        <!-- Success/Error Messages -->
        @if (session('success'))
            <div class="alert alert-success alert-dismissible fade show" role="alert">
                {{ session('success') }}
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
            </div>
        @endif

        @if ($errors->any())
            <div class="alert alert-danger alert-dismissible fade show" role="alert">
                <ul>
                    @foreach ($errors->all() as $error)
                        <li>{{ $error }}</li>
                    @endforeach
                </ul>
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
            </div>
        @endif

        <!-- Search Form -->
        <div class="card">
            <div class="card-body">
                <form action="{{ route('payrolls.index') }}" method="GET">
                    <div class="row">
                        <div class="col-md-4">
                            <div class="form-group">
                                <label for="role_id">Select Role</label>
                                <select name="role_id" id="role_id" class="form-control">
                                    <option value="">All Roles</option>
                                    @foreach ($roles as $role)
                                        <option value="{{ $role->id }}"
                                            {{ request('role_id') == $role->id ? 'selected' : '' }}>
                                            {{ $role->name }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="form-group">
                                <label for="month">Select Month</label>
                                <select name="month" id="month" class="form-control">
                                    <option value="">All Months</option>
                                    @foreach ($months as $month)
                                        <option value="{{ $month }}"
                                            {{ request('month') == $month ? 'selected' : '' }}>
                                            {{ $month }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="form-group">
                                <label for="year">Select Year</label>
                                <select name="year" id="year" class="form-control">
                                    <option value="">All Years</option>
                                    @foreach ($years as $year)
                                        <option value="{{ $year }}"
                                            {{ request('year') == $year ? 'selected' : '' }}>
                                            {{ $year }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                    </div>
                    <div class="form-group mt-3">
                        <button type="submit" class="btn btn-primary">Search</button>
                        <a href="{{ route('payrolls.index') }}" class="btn btn-secondary">Clear</a>
                    </div>
                </form>
            </div>
            <!-- Users Table -->
            @if ($users->isNotEmpty())
                <div class="card mt-4">
                    <div class="card-body">

                        @php
                        $month = request('month');
                        $year = request('year');
                        $invoiceExists = $month && $year ? \App\Models\PayrollInvoice::where('month', $month)->where('year', $year)->first() : null;
                    @endphp

                        @if (!$invoiceExists)
                            <button class="btn btn-primary btn-sm mb-3" data-bs-toggle="modal"
                                data-bs-target="#generateAll">Make Invoice For All</button>
                        @else
                            <button class="btn btn-primary btn-sm mb-3" data-bs-toggle="modal"
                                data-bs-target="#viewInvoice">View Invoice No {{ $invoiceExists->invoice_no }}</button>

                            <div class="modal fade" id="viewInvoice" tabindex="-1" aria-hidden="true">
                                <div class="modal-dialog">
                                    <div class="modal-content">
                                     
                                            <div class="modal-header">
                                                <div class="modal-title">View Invoice No {{ $invoiceExists->invoice_no }}</div>
                                                <button type="button" class="btn-close" data-bs-dismiss="modal"
                                                    aria-label="Close"></button>
                                            </div>
                                            <div class="modal-body">
                                                <p>invoice for month: <strong>{{ $invoiceExists->month }}</strong></p>
                                                <p>invoice for year: <strong>{{ $invoiceExists->year }}</strong></p>
                                                <p>total amount: <strong>{{ number_format($invoiceExists->total, 2) }}</strong></p>
                                                <p>Created By: <strong>{{ $invoiceExists->createdBy->full_name }}</strong></p>
                                                <p>Created At: <strong>{{ $invoiceExists->created_at->format('Y-m-d h:i A') }}</strong></p>
    
                                            </div>
                                            <div class="modal-footer">
                                                <button type="button" class="btn btn-secondary"
                                                    data-bs-dismiss="modal">Close</button>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        @endif

                        <div class="modal fade" id="generateAll" tabindex="-1" aria-hidden="true">
                            <div class="modal-dialog">
                                <div class="modal-content">
                                    <form action="{{ route('payrolls.generateAll') }}" method="POST">
                                        @csrf
                                        <input type="hidden" name="role_id" value="{{ request('role_id') }}">
                                        <input type="hidden" name="payroll_month" value="{{ request('month') }}">
                                        <input type="hidden" name="payroll_year" value="{{ request('year') }}">

                                        <div class="modal-header">
                                            <h6 class="modal-title">Generate All</h6>
                                            <button type="button" class="btn-close" data-bs-dismiss="modal"
                                                aria-label="Close"></button>
                                        </div>
                                        <div class="modal-body">
                                            @php
                                                $month = request('month');
                                                $year = request('year');
                                                $selectedUsers = request('role_id')
                                                    ? \App\Models\User::with(['staff'])
                                                        ->where('role_id', request('role_id'))
                                                        ->get()
                                                    : collect([]);
                                                $totalAmount = $selectedUsers->sum(function ($user) use (
                                                    $month,
                                                    $year,
                                                ) {
                                                    if (!$user->staff) {
                                                        return 0;
                                                    }
                                                    $payroll = \App\Models\PayrollGenerate::where(
                                                        'staff_id',
                                                        $user->staff->id,
                                                    )
                                                        ->where('payroll_month', $month)
                                                        ->where('payroll_year', $year)
                                                        ->first();
                                                    return $payroll ? $payroll->net_salary : $user->staff->basic_salary;
                                                });
                                            @endphp

                                            <p>invoice for month: <strong>{{ request('month') ?: '' }}</strong></p>
                                            <p>invoice for year: <strong>{{ request('year') ?: '' }}</strong></p>
                                            <p>total amount: <strong>{{ number_format($totalAmount, 2) }}</strong></p>
                                            <p>number of selected users: <strong>{{ $selectedUsers->count() }}</strong></p>

                                        </div>
                                        <div class="modal-footer">
                                            <button type="button" class="btn btn-secondary"
                                                data-bs-dismiss="modal">Close</button>
                                            <button type="submit" class="btn btn-primary">Generate</button>
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>

                    <table class="table table-bordered table-sm table sm-table mb-0">
                        <thead>
                            <tr>
                                <th>Name</th>
                                <th>Role</th>
                                <th>Department</th>
                                <th>Designation</th>
                                <th>Mobile</th>
                                <th>Paid</th>
                                <th>Month</th>
                                <th>Year</th>
                                <th>Status</th>
                                <th>Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse ($users as $user)
                                <tr>
                                    <td>{{ $user['full_name'] }}</td>
                                    <td>{{ $user['role'] }}</td>
                                    <td>{{ $user['department'] }}</td>
                                    <td>{{ $user['designation'] }}</td>
                                    <td>{{ $user['mobile'] }}</td>
                                    <td>{{ $user['paid'] }}</td>
                                    <td>{{ $user['month'] }}</td>
                                    <td>{{ $user['year'] }}</td>
                                    <td>{{ $user['status'] }}</td>
                                    <td>
                                        @if (!$user['payroll_status'])
                                            <a href="{{ route('payrolls.edit', ['user' => $user['user_id'], 'month' => $user['month'], 'year' => $user['year']]) }}"
                                                class="btn btn-primary btn-sm">Make Earnings Or Deductions</a>
                                        @elseif ($user['payroll_status'] == 'Progress')
                                            <a href="{{ route('payrolls.edit', ['user' => $user['user_id'], 'month' => $user['month'], 'year' => $user['year']]) }}"
                                                class="btn btn-primary btn-sm">Update</a>
                                        @elseif ($user['payroll_status'] == 'Generated' && $user['paid'] == null)
                                           
                                            <a href="{{ route('payrolls.show', $user['payroll_id']) }}"
                                                class="btn btn-secondary btn-sm">View</a>

                                            <button class="btn btn-success btn-sm" data-bs-toggle="modal"
                                                data-bs-target="#paymentModal-{{ $user['payroll_id'] }}">Pay</button>

                                            <!-- Create Modal -->
                                            <div class="modal fade" id="paymentModal-{{ $user['payroll_id'] }}"
                                                tabindex="-1" aria-hidden="true">
                                                <div class="modal-dialog">
                                                    <div class="modal-content">
                                                        <form action="{{ route('payrolls.storePayment') }}" method="POST">
                                                            @csrf
                                                            <input type="hidden" name="sm_hr_payroll_generate_id"
                                                                value="{{ $user['payroll_id'] }}">
                                                            <div class="modal-header">
                                                                <h6 class="modal-title">Record Payment for
                                                                    {{ $user['full_name'] }}</h6>
                                                                <button type="button" class="btn-close"
                                                                    data-bs-dismiss="modal" aria-label="Close"></button>
                                                            </div>
                                                            <div class="modal-body">

                                                                <div class="mb-3">
                                                                    <label for="payment_mode-{{ $user['payroll_id'] }}"
                                                                        class="form-label">Payment Mode</label>
                                                                    <select class="form-control"
                                                                        id="payment_mode-{{ $user['payroll_id'] }}"
                                                                        name="payment_mode" required>
                                                                        <option value="Cash"
                                                                            {{ old('payment_mode') == 'Cash' ? 'selected' : '' }}>
                                                                            Cash</option>
                                                                        <option value="Bank Transfer"
                                                                            {{ old('payment_mode') == 'Bank Transfer' ? 'selected' : '' }}>
                                                                            Bank Transfer</option>
                                                                        <option value="Cheque"
                                                                            {{ old('payment_mode') == 'Cheque' ? 'selected' : '' }}>
                                                                            Cheque</option>
                                                                    </select>
                                                                    @error('payment_mode')
                                                                        <div class="text-danger">{{ $message }}</div>
                                                                    @enderror
                                                                </div>

                                                                <div class="mb-3">
                                                                    <label for="payment_date-{{ $user['payroll_id'] }}"
                                                                        class="form-label">Payment Date</label>
                                                                    <input type="date" class="form-control"
                                                                        id="payment_date-{{ $user['payroll_id'] }}"
                                                                        name="payment_date"
                                                                        value="{{ old('payment_date', now()->toDateString()) }}"
                                                                        required>
                                                                    @error('payment_date')
                                                                        <div class="text-danger">{{ $message }}</div>
                                                                    @enderror
                                                                </div>
                                                                <div class="mb-3">
                                                                    <label for="note-{{ $user['payroll_id'] }}"
                                                                        class="form-label">Note</label>
                                                                    <textarea class="form-control" id="note-{{ $user['payroll_id'] }}" name="note">{{ old('note') }}</textarea>
                                                                    @error('note')
                                                                        <div class="text-danger">{{ $message }}</div>
                                                                    @enderror
                                                                </div>
                                                            </div>
                                                            <div class="modal-footer">
                                                                <button type="button" class="btn btn-secondary"
                                                                    data-bs-dismiss="modal">Close</button>
                                                                <button type="submit" class="btn btn-primary">Record
                                                                    Payment</button>
                                                            </div>
                                                        </form>
                                                    </div>
                                                </div>
                                            </div>
                                        
                                            @elseif ($user['payroll_status'] == 'Generated' && $user['paid'] != null)
                                            <a href="{{ route('payrolls.show', $user['payroll_id']) }}"
                                            class="btn btn-secondary btn-sm">View</a>
                                            @elseif ($user['payroll_status'] == 'Paid')
                                            <a href="{{ route('payrolls.show', $user['payroll_id']) }}"
                                                class="btn btn-secondary btn-sm">View</a>
                                        @endif
                                    </td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="10" class="text-center">No records found.</td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
        </div>
    @else
        <div class="card mt-4">
            <div class="card-body text-center">
                <p>Please select a role, month, or year to view user records.</p>
            </div>
        </div>
        @endif
    </div>
    </div>
@endsection