@extends('hr.hr-master')

@section('title', 'Generate Salary Sheet')

@section('content')
<div class="container mt-5">
    <h1 class="text-center mb-4" style="color: #5bc0de;">Generate Salary Sheet</h1>

    @if(session('success'))
    <div class="alert alert-success">{{ session('success') }}</div>
    @endif


    <!-- Salary Sheet Form -->
    <div class="card p-4 shadow-sm">
        <form action="{{ route('hr.saveSalarySheet') }}" method="POST">
            @csrf

            <!-- Month and Year Selection -->
            <div class="row">
                <div class="col-md-6 mb-3">
                    <label for="month">Month:</label>
                    <select name="month" id="month" class="form-control" required>
                        <option value="">Select Month</option>
                        @foreach(range(1, 12) as $month)
                        <option value="{{ $month }}" {{ old('month') == $month ? 'selected' : '' }}>
                            {{ \Carbon\Carbon::create()->month($month)->format('F') }}
                        </option>
                        @endforeach
                    </select>
                </div>

                <div class="col-md-6 mb-3">
                    <label for="year">Year:</label>
                    <input type="number" name="year" value="{{ old('year') }}" class="form-control" required>
                </div>
            </div>

            <!-- Employee Details Section -->
            <h3 class="mt-4 mb-3">Employee Details</h3>

            <!-- Employee and Payscale Selection -->
            <table class="table table-striped table-bordered">
                <thead>
                    <tr>
                        <th>Employee Name</th>
                        <th>Present Days</th>
                        <th>Payscale</th>
                    </tr>
                </thead>
                <tbody>
                    <tr>
                        <td>
                            <select name="employee_id" class="form-control" required>
                                <option value="">Select Employee</option>
                                @foreach($employees as $employee)
                                <option value="{{ $employee->id }}"
                                    {{ old('employee_id') == $employee->id ? 'selected' : '' }}>
                                    {{ $employee->name }}
                                </option>
                                @endforeach
                            </select>
                        </td>
                        <td><input type="number" name="present_days" class="form-control" required></td>

                        <td>
                            <select name="payscale_id" class="form-control" required>
                                <option value="">Select Payscale</option>
                                @foreach($payscales as $payscale)
                                <option value="{{ $payscale->id }}"
                                    {{ old('payscale_id') == $payscale->id ? 'selected' : '' }}>
                                    {{ $payscale->component_name }}
                                </option>
                                @endforeach
                            </select>
                        </td>
                    </tr>
                </tbody>
            </table>

            <!-- Save Button -->
            <div class="text-center mt-4">
                <button type="submit" class="btn btn-primary btn-lg">Save Salary Sheet</button>
            </div>
        </form>
    </div>
    <!-- Filters Form -->
    <div class="card p-4 shadow-sm mb-4">
        <form method="GET" action="{{ route('hr.salary_sheet') }}">
            @csrf
            <div class="row mb-3">
                <div class="col-md-4">
                    <label for="employee_id">Employee:</label>
                    <select name="employee_id" id="employee_id" class="form-control">
                        <option value="">Select Employee</option>
                        @foreach($employees as $employee)
                        <option value="{{ $employee->id }}"
                            {{ request('employee_id') == $employee->id ? 'selected' : '' }}>
                            {{ $employee->name }}
                        </option>
                        @endforeach
                    </select>
                </div>

                <div class="col-md-4">
                    <label for="month">Month:</label>
                    <select name="month" id="month" class="form-control">
                        <option value="">Select Month</option>
                        @foreach(range(1, 12) as $month)
                        <option value="{{ $month }}" {{ request('month') == $month ? 'selected' : '' }}>
                            {{ \Carbon\Carbon::create()->month($month)->format('F') }}
                        </option>
                        @endforeach
                    </select>
                </div>

                <div class="col-md-4">
                    <label for="year">Year:</label>
                    <input type="number" name="year" id="year" class="form-control" value="{{ request('year') }}"
                        placeholder="Year">
                </div>
            </div>

            <button type="submit" class="btn btn-primary mb-3">Apply Filters</button>
        </form>
    </div>

    <!-- Display Filtered Salary Sheets -->
    <div class="card p-4 mt-4">
        <h3 class="mb-4">Salary Sheets</h3>

        <table class="table table-striped">
            <thead>
                <tr>
                    <th>Employee Name</th>
                    <th>Payscale</th>
                    <th>Present Days</th>
                    <th>component (fixed)</th>
                    <th>component (%)</th>
                    <th>Total Salary</th>
                    <th>Month</th>
                    <th>Year</th>
                </tr>
            </thead>
            <tbody>
                @forelse($salarySheets as $salarySheet)
                <tr>
                    <td>{{ $salarySheet->employee->name }}</td>
                    <td>{{ $salarySheet->payscale->component_name }}</td>
                    <td>{{ $salarySheet->present_days }}</td>
                    <td>{{ $salarySheet->component_fixed_value }}</td>
                    <td>{{ $salarySheet->component_percentage_value }}</td>
                    <td>{{ $salarySheet->total_salary }}</td>
                    <td>{{ \Carbon\Carbon::create()->month($salarySheet->month)->format('F') }}</td>
                    <td>{{ $salarySheet->year }}</td>
                </tr>
                @empty
                <tr>
                    <td colspan="5" class="text-center">No Salary Sheets Found</td>
                </tr>
                @endforelse
            </tbody>
        </table>
    </div>

</div>
@endsection