{% extends 'base.html' %}
{% load kunj_filters %}

{% block body %}

<div id="wrapper">
    {% include 'navbar.html' %}

    <div id="page-wrapper" class="gray-bg">
        {% include 'header.html' %}
        <div class="row wrapper border-bottom white-bg page-heading">
            <div class="col-lg-10"><h2>Cash Book &amp; Bank Book</h2></div>
            <div class="col-lg-2"></div>
        </div>

        <div class="wrapper wrapper-content animated fadeInRight">

            {% if undated_count %}
            <div class="row">
                <div class="col-lg-12">
                    <div class="alert" style="background:#3a2f12; border:1px solid #6b5420; color:#f0c96b; border-radius:8px;">
                        <i class="fa fa-exclamation-triangle"></i>
                        <strong>{{undated_count}} expenditure {% if undated_count == 1 %}entry{% else %}entries{% endif %} totalling ₹ {{undated_total}}</strong>
                        have no date recorded and cannot appear here.
                    </div>
                </div>
            </div>
            {% endif %}
            <div class="row">
                <div class="col-lg-12">
                    <div class="alert" style="background:#10151f; border:1px solid #2c3446; color:#9aa4b8; border-radius:8px;">
                        Mode is derived from each entry's payment mode: Income's <strong>Mode of Payment</strong> field, and Expenditure's <strong>Online/Offline</strong> flag
                        (Online &rarr; Bank, Offline &rarr; Cash). Entries with no mode recorded show as "Unspecified" and appear under Bank Book.
                    </div>
                </div>
            </div>

            <div class="row">
                <div class="col-lg-12">
                    <div class="ibox">
                        <div class="ibox-title px-4 justify-content-between d-flex align-items-center">
                            <form action="/admin/finance-department/cash-bank-book" method="GET" style="width:100%;">
                                <div class="flex-row justify-content-between w-100 d-flex align-items-end">
                                    <div class="form-group mb-0 d-flex flex-column mr-2">
                                        <label>Project</label>
                                        <select data-placeholder="" id="project" data-value="{{project}}" name="project" class="select2 form-control" tabindex="-1">
                                            <option value="All">All</option>
                                            {% for p in projects %}
                                                <option value="{{p.id}}">{{p.project}}</option>
                                            {% endfor %}
                                        </select>
                                    </div>
                                    <div class="form-group mb-0 d-flex flex-column">
                                        <label>Financial Year</label>
                                        <select data-placeholder="" id="financial_year" data-value="{{financial_year}}" name="financial_year" class="select2 form-control" tabindex="-1">
                                            <option value="All">All</option>
                                            {% for fy in financial_years %}
                                                <option value="{{fy}}">{{fy}}</option>
                                            {% endfor %}
                                        </select>
                                    </div>
                                    <button type="submit" class="btn btn-w-s btn-primary">Apply</button>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
            </div>

            <div class="row">
                <div class="col-lg-6">
                    <div class="ibox">
                        <div class="ibox-title"><h5>Cash Book</h5></div>
                        <div class="ibox-content">
                            <div class="table-responsive">
                                <table class="footable table table-stripped table-bordered" data-page-size="15">
                                    <thead>
                                        <tr><th data-toggle="true">Date</th><th>Particulars</th><th>Type</th><th>Amount</th><th>Balance</th></tr>
                                    </thead>
                                    <tbody>
                                        {% for t in cash_transactions %}
                                            <tr>
                                                <td>{{t.date|ddmmyyyy}}</td>
                                                <td>{{t.particulars}}</td>
                                                <td>{% if t.voucher_type == 'Receipt' %}<span class="label label-success">Receipt</span>{% else %}<span class="label label-danger">Payment</span>{% endif %}</td>
                                                <td>₹ {{t.amount}}</td>
                                                <td>₹ {{t.balance}}</td>
                                            </tr>
                                        {% empty %}
                                            <tr><td colspan="5" class="text-center">No cash transactions.</td></tr>
                                        {% endfor %}
                                    </tbody>
                                    <tfoot>
                                        <tr style="font-weight:700;"><td colspan="4" class="text-right">Closing Balance</td><td>₹ {{cash_closing_balance}}</td></tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="col-lg-6">
                    <div class="ibox">
                        <div class="ibox-title"><h5>Bank Book</h5></div>
                        <div class="ibox-content">
                            <div class="table-responsive">
                                <table class="footable table table-stripped table-bordered" data-page-size="15">
                                    <thead>
                                        <tr><th data-toggle="true">Date</th><th>Particulars</th><th>Type</th><th>Amount</th><th>Balance</th></tr>
                                    </thead>
                                    <tbody>
                                        {% for t in bank_transactions %}
                                            <tr>
                                                <td>{{t.date|ddmmyyyy}}</td>
                                                <td>{{t.particulars}}</td>
                                                <td>{% if t.voucher_type == 'Receipt' %}<span class="label label-success">Receipt</span>{% else %}<span class="label label-danger">Payment</span>{% endif %}</td>
                                                <td>₹ {{t.amount}}</td>
                                                <td>₹ {{t.balance}}</td>
                                            </tr>
                                        {% empty %}
                                            <tr><td colspan="5" class="text-center">No bank transactions.</td></tr>
                                        {% endfor %}
                                    </tbody>
                                    <tfoot>
                                        <tr style="font-weight:700;"><td colspan="4" class="text-right">Closing Balance</td><td>₹ {{bank_closing_balance}}</td></tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

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

<script>
    $('.footable').footable({
        "paging": {
            "enabled": true
        }
    });

    $(document).ready(function(){
        var financial_year = $('#financial_year').attr('data-value');
        var project = $('#project').attr('data-value');
        $('#financial_year').select2({}).val(financial_year.toString()).trigger('change');
        $('#project').select2({}).val(project.toString()).trigger('change');
    });
</script>

{% endblock %}