{% extends "base.html" %}
{% block content %}
<div class="container mt-4">
    <h4>Consolidated Salary Sheet – {{ month }}</h4>

    <form method="get" action="{{ url_for('payroll.consolidated_salary_view') }}" class="form-inline mb-3">
        <input type="month" name="month" class="form-control mr-2" value="{{ month }}">
        <button type="submit" class="btn btn-primary">Filter</button>
        <a href="{{ url_for('payroll.download_consolidated_salary_excel', month=month) }}" class="btn btn-success ml-2">Download Consolidated Salary</a>
        <a href="{{ url_for('payroll.download_disbursement_sheet', month=month) }}" class="btn btn-outline-success ml-2">Download Disbursement Sheet</a>
    </form>

    <div class="table-responsive">
        <table class="table table-bordered table-sm text-center">
            <thead>
                <!-- Group Headers -->
                <tr>
                    <th rowspan="2">SN</th>
                    <th rowspan="2">Employee</th>
                    <th rowspan="2">UAN</th>
                    <th colspan="8" style="background-color: #007bff; color: white;">Master Salary [Earning]</th>
                    <th colspan="11" style="background-color: #00bcd4; color: white;">Monthly Salary [Earning]</th>
                    <th colspan="7" style="background-color: #f39c12; color: white;">Monthly Salary [Deduction]</th>
                    <th colspan="2" style="background-color: #28a745; color: white;">Summary</th>
                </tr>

                <!-- Field Headers -->
                <tr>
                    <th>Basic</th><th>HRA</th><th>TA</th><th>MA</th><th>Inc.</th><th>KPI Inc.</th><th>Other</th><th>Gross</th>
                    <th>Days</th><th>Basic</th><th>HRA</th><th>TA</th><th>MA</th><th>Inc.</th><th>Other</th><th>Laptop</th><th>KPI Incentive</th><th>Arears</th><th>Gross</th>
                    <th>PF</th><th>ESI</th><th>TDS</th><th>PT</th><th>Advance</th><th>Target</th><th>Mobile</th>
                    <th>Net Salary</th><th>Department</th>
                </tr>
            </thead>
            <tbody>
                {% for row in df.to_dict(orient='records') %}
                <tr>
                    <td>{{ row['SN'] }}</td>
                    <td>{{ row['Employee'] }}</td>
                    <td>{{ row['UAN'] }}</td>
                    <td>{{ row['Basic'] }}</td>
                    <td>{{ row['HRA'] }}</td>
                    <td>{{ row['TA'] }}</td>
                    <td>{{ row['MA'] }}</td>
                    <td>{{ row['Inc.'] }}</td>
                    <td>{{ row['KPI Inc.'] }}</td>
                    <td>{{ row['Other'] }}</td>
                    <td>{{ row['Gross'] }}</td>
                    <td>{{ row['Days'] }}</td>
                    <td>{{ row['Basic M'] }}</td>
                    <td>{{ row['HRA M'] }}</td>
                    <td>{{ row['TA M'] }}</td>
                    <td>{{ row['MA M'] }}</td>
                    <td>{{ row['Inc. M'] }}</td>
                    <td>{{ row['Other M'] }}</td>
                    <td>{{ row['Laptop'] }}</td>
                    <td>{{ row['KPI Incentive'] }}</td>
                    <td>{{ row['Arears'] }}</td>
                    <td>{{ row['Gross M'] }}</td>
                    <td>{{ row['PF'] }}</td>
                    <td>{{ row['ESI'] }}</td>
                    <td>{{ row['TDS'] }}</td>
                    <td>{{ row['PT'] }}</td>
                    <td>{{ row['Advance'] }}</td>
                    <td>{{ row['Target'] }}</td>
                    <td>{{ row['Mobile'] }}</td>
                    <td>{{ row['Net Salary'] }}</td>
                    <td>{{ row['Department Name'] }}</td>
                </tr>
                {% endfor %}
            </tbody>
        </table>
    </div>
</div>
{% endblock %}