{% extends "base.html" %}
{% block content %}
<div class="container mt-4">

    <h3 class="mb-3">Gratuity Calculation</h3>

    <div class="card shadow-sm">
        <div class="card-body table-responsive">

            <table class="table table-bordered table-hover">
                <thead class="table-dark">
                    <tr>
                        <th>#</th>
                        <th>Employee</th>
                        <th>DOJ</th>
                        <th>Proposed LWD</th>
                        <th>Exit Status</th>
                        <th>Service</th>
                        <th>Last Salary</th>
                        <th>Components</th>
                        <th>Eligible</th>
                        <th>Formula</th>
                        <th>Gratuity</th>
                    </tr>
                </thead>
                <tbody>
                    {% for row in results %}
                    <tr>
                        <td>{{ loop.index }}</td>
                        <td>{{ row.employee.full_name }}</td>
                        <td>{{ row.doj.strftime('%d-%m-%Y') if row.doj else '' }}</td>
                        <td>{{ row.exit_date.strftime('%d-%m-%Y') if row.exit_date else '' }}</td>
                        <td>{{ row.exit_request.status }}</td>
                        <td>
                            {{ row.eligible_service_years }}
                            <small class="text-muted">
                                ({{ row.service_years }}y {{ row.remaining_months }}m)
                            </small>
                        </td>
                        <td>₹ {{ '%.2f'|format(row.last_salary or 0) }}</td>
                        <td>{{ row.component_breakup or '-' }}</td>
                        <td>
                            {% if row.eligible %}
                                <span class="badge bg-success">Yes</span>
                            {% else %}
                                <span class="badge bg-danger">No</span>
                            {% endif %}
                        </td>
                        <td>
                            {% if row.formula_error %}
                                <span class="text-danger small">Error: {{ row.formula_error }}</span>
                            {% else %}
                                <small class="text-muted">{{ row.formula_used }}</small>
                            {% endif %}
                        </td>
                        <td class="fw-bold text-primary">
                            ₹ {{ '%.2f'|format(row.gratuity or 0) }}
                        </td>
                    </tr>
                    {% else %}
                    <tr>
                        <td colspan="11" class="text-center text-muted">No exit records found</td>
                    </tr>
                    {% endfor %}
                </tbody>
            </table>

        </div>
    </div>

</div>
{% endblock %}