{% extends "../base.html" %}
{% load crispy_forms_tags %}
{% load humanize %}

{% block page_title %}Bank Reconciliation{% endblock %}

{% block content %}
    <div class="clearfix"></div>

    <div class="row">
        <div class="col-md-12">
            <div class="x_panel">
                <div class="x_title">
                    <h2><i class="fa fa-bank"></i> Bank Reconciliation</h2>
                    <ul class="nav navbar-right panel_toolbox">
                        <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a></li>
                        <li><a href="#" data-toggle="modal" data-target="#uploadStatementModal"><i class="fa fa-upload"></i> Upload Statement</a></li>
                    </ul>
                    <div class="clearfix"></div>
                </div>
                <div class="x_content">

                    <!-- Scope Filters: Academic Year / Term / Show All -->
                    <form method="get" class="form-inline mb-3">
                        <div class="form-group mr-2">
                            <label for="academic_year"><strong>Academic Year:</strong></label>
                            <select name="academic_year" id="academic_year" class="form-control ml-2" style="min-width: 180px;">
                                <option value="">Current</option>
                                {% if academic_years %}
                                    {% for y in academic_years %}
                                        <option value="{{ y.id }}" {% if selected_academic_year and y.id == selected_academic_year %}selected{% endif %}>
                                            {{ y.academic_year }}
                                        </option>
                                    {% endfor %}
                                {% endif %}
                            </select>
                        </div>

                        <div class="form-group mr-2">
                            <label for="term"><strong>Term:</strong></label>
                            <select name="term" id="term" class="form-control ml-2" style="min-width: 140px;">
                                <option value="">Current</option>
                                {% if terms %}
                                    {% for t in terms %}
                                        <option value="{{ t.id }}" {% if selected_term and t.id == selected_term %}selected{% endif %}>
                                            {{ t.term }}
                                        </option>
                                    {% endfor %}
                                {% endif %}
                            </select>
                        </div>

                        <div class="form-group form-check mr-3 ml-2">
                            <input type="checkbox" class="form-check-input" id="show_all" name="show_all" value="1" {% if show_all %}checked{% endif %}>
                            <label class="form-check-label" for="show_all">Show all terms</label>
                        </div>

                        <button type="submit" class="btn btn-primary btn-sm mr-2">
                            <i class="fa fa-filter"></i> Apply
                        </button>
                        <a href="{% url 'bank_reconciliation' %}" class="btn btn-light btn-sm">Reset</a>
                    </form>

                    <!-- Current Scope Summary -->
                    <div class="alert alert-info py-2">
                        <strong>Scope:</strong>
                        {% if show_all %}
                            All terms
                        {% else %}
                            {% if selected_academic_year %}
                                {% for y in academic_years %}{% if y.id == selected_academic_year %}{{ y.academic_year }}{% endif %}{% endfor %}
                            {% else %}
                                Current Year
                            {% endif %}
                            —
                            {% if selected_term %}
                                {% for t in terms %}{% if t.id == selected_term %}Term {{ t.term }}{% endif %}{% endfor %}
                            {% else %}
                                Current Term
                            {% endif %}
                        {% endif %}
                    </div>

                    <!-- Bank Accounts Overview -->
                    <div class="row">
                        {% for account in bank_accounts %}
                        <div class="col-md-4">
                            <div class="card border-left-primary">
                                <div class="card-body">
                                    <h5 class="card-title">{{ account.bank_name }}</h5>
                                    <p class="card-text">{{ account.account_name }}</p>
                                    <h3 class="text-primary">UGX {{ account.balance|intcomma }}</h3>
                                    <small class="text-muted">Account: {{ account.account_number }}</small>
                                </div>
                            </div>
                        </div>
                        {% endfor %}
                    </div>

                    <!-- Unreconciled Transactions -->
                    <div class="row" style="margin-top: 30px;">
                        <div class="col-md-12">
                            <h3><i class="fa fa-exclamation-triangle"></i> Unreconciled Transactions</h3>
                            <div class="table-responsive">
                                <table class="table table-striped table-bordered">
                                    <thead class="thead-dark">
                                        <tr>
                                            <th>Date</th>
                                            <th>Description</th>
                                            <th>Amount</th>
                                            <th>Type</th>
                                            <th>Bank</th>
                                            <th>Actions</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        {% for transaction in unreconciled_transactions %}
                                        <tr>
                                            <td>{{ transaction.transaction_date|date:"M d, Y" }}</td>
                                            <td>{{ transaction.description }}</td>
                                            <td class="{% if transaction.transaction_type == 'Credit' %}text-success{% else %}text-danger{% endif %}">
                                                UGX {{ transaction.amount|floatformat:0|intcomma }}
                                            </td>
                                            <td>
                                                <span class="badge {% if transaction.transaction_type == 'Credit' %}badge-success{% else %}badge-danger{% endif %}">
                                                    {{ transaction.transaction_type }}
                                                </span>
                                            </td>
                                            <td>{{ transaction.bank_statement.bank_account.bank_name }}</td>
                                            <td>
                                                <button class="btn btn-sm btn-primary" data-transaction-id="{{ transaction.id }}" data-toggle="modal" data-target="#reconcileModal">
                                                    <i class="fa fa-link"></i> Reconcile
                                                </button>
                                            </td>
                                        </tr>
                                        {% empty %}
                                        <tr>
                                            <td colspan="6" class="text-center text-muted">
                                                <i class="fa fa-check-circle"></i> All transactions are reconciled!
                                            </td>
                                        </tr>
                                        {% endfor %}
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>

                    <!-- Unmatched Payments -->
                    <div class="row" style="margin-top: 30px;">
                        <div class="col-md-12">
                            <h3><i class="fa fa-money"></i> Unmatched Payments</h3>
                            <div class="table-responsive">
                                <table class="table table-striped table-bordered">
                                    <thead class="thead-dark">
                                        <tr>
                                            <th>Payment Date</th>
                                            <th>Student</th>
                                            <th>Amount</th>
                                            <th>Reference</th>
                                            <th>Bill</th>
                                            <th>Actions</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        {% for payment in unmatched_payments %}
                                        <tr>
                                            <td>{{ payment.payment_date|date:"M d, Y" }}</td>
                                            <td>{{ payment.bill.student.student_name }}</td>
                                            <td class="text-success">UGX {{ payment.amount|floatformat:0|intcomma }}</td>
                                            <td>{{ payment.reference_no }}</td>
                                            <td>{{ payment.bill }}</td>
                                            <td>
                                                <button class="btn btn-sm btn-info" data-payment-id="{{ payment.id }}" data-toggle="modal" data-target="#reconcileModal">
                                                    <i class="fa fa-link"></i> Match
                                                </button>
                                            </td>
                                        </tr>
                                        {% empty %}
                                        <tr>
                                            <td colspan="6" class="text-center text-muted">
                                                <i class="fa fa-check-circle"></i> All payments are matched!
                                            </td>
                                        </tr>
                                        {% endfor %}
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>

                </div>
            </div>
        </div>
    </div>

    <!-- Upload Statement Modal -->
    <div class="modal fade" id="uploadStatementModal" tabindex="-1" role="dialog">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Upload Bank Statement</h5>
                    <button type="button" class="close" data-dismiss="modal">
                        <span>&times;</span>
                    </button>
                </div>
                <form method="post" enctype="multipart/form-data">
                    {% csrf_token %}
                    <div class="modal-body">
                        <div class="form-group">
                            <label for="bank_account">Bank Account</label>
                            <select name="bank_account" class="form-control" required>
                                <option value="">Select Bank Account</option>
                                {% for account in bank_accounts %}
                                <option value="{{ account.id }}">{{ account.bank_name }} - {{ account.account_name }}</option>
                                {% endfor %}
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="statement_date">Statement Date</label>
                            <input type="date" name="statement_date" class="form-control" required>
                        </div>
                        <div class="form-group">
                            <label for="opening_balance">Opening Balance</label>
                            <input type="number" step="0.01" name="opening_balance" class="form-control" required>
                        </div>
                        <div class="form-group">
                            <label for="closing_balance">Closing Balance</label>
                            <input type="number" step="0.01" name="closing_balance" class="form-control" required>
                        </div>
                        <div class="form-group">
                            <label for="statement_file">Statement File (CSV)</label>
                            <input type="file" name="statement_file" accept=".csv" class="form-control" required>
                            <small class="form-text text-muted">Upload CSV file exported from your bank</small>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
                        <button type="submit" class="btn btn-primary">Upload Statement</button>
                    </div>
                </form>
            </div>
        </div>
    </div>

    <!-- Reconciliation Modal -->
    <div class="modal fade" id="reconcileModal" tabindex="-1" role="dialog">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Reconcile Transaction</h5>
                    <button type="button" class="close" data-dismiss="modal">
                        <span>&times;</span>
                    </button>
                </div>
                <form method="post">
                    {% csrf_token %}
                    <div class="modal-body">
                        <div class="form-group">
                            <label for="payment_id">Match with Payment</label>
                            <select name="payment_id" class="form-control" required>
                                <option value="">Select Payment</option>
                                {% for payment in unmatched_payments %}
                                <option value="{{ payment.id }}">{{ payment.bill.student.student_name }} - UGX {{ payment.amount|intcomma }} - {{ payment.payment_date|date:"M d, Y" }}</option>
                                {% endfor %}
                            </select>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
                        <button type="submit" class="btn btn-success">Reconcile</button>
                    </div>
                </form>
            </div>
        </div>
    </div>

    <script>
        function reconcileTransaction(transactionId) {
            $('#reconcileModal').modal('show');
            $('#reconcileModal form').attr('action', '/finance/reconcile/' + transactionId + '/');
        }

        function matchPayment(paymentId) {
            $('#reconcileModal').modal('show');
            $('#reconcileModal form').attr('action', '/finance/reconcile-payment/' + paymentId + '/');
        }
    </script>

{% endblock %}
<!-- Auto-attach handlers for reconciliation modal -->
<script>
document.addEventListener('DOMContentLoaded', function() {
  // When clicking a Reconcile button on a bank transaction row, set the modal form action
  document.querySelectorAll('button[data-transaction-id]').forEach(function(btn) {
    btn.addEventListener('click', function() {
      var id = btn.getAttribute('data-transaction-id');
      var form = document.querySelector('#reconcileModal form');
      if (form && id) {
        form.setAttribute('action', '/finance/reconcile/' + id + '/');
      }
    });
  });
});
</script>