{% extends 'base.html' %}

{% load static %}
{% load humanize %}




{% block content %}

<main class="content">
    <div class="container-fluid p-0">

        <div class="mb-3">
            <h1 class="h3 d-inline align-middle">User Dashboard - {{logged_user_profile.user.first_name|upper}}
                {{logged_user_profile.middle_name|upper}} ({{logged_user_profile.user.username}}) {{today}}</h1>
        </div>


        <div class="row">

            <div class="col-12">

                <div class="row">

                    

                    <div class="col-md-3">
                        <div class="card bg-secondary">
                            <div class="card-body">
                                <div class="row">
                                    <div class="col mt-0">
                                        <h5 class="card-title text-white">B/F</h5>
                                    </div>

                                    <div class="col-auto">
                                        <div class="stat text-primary">
                                            <i class="align-middle" data-feather="pocket"></i>
                                        </div>
                                    </div>
                                </div>
                                <h1 class="mt-1 mb-3 text-white">{{currency}} {{previous_balance|floatformat:2|intcomma}}</h1>
                                <div class="mb-0">
                                    
                                    <span class="text-white">Opening Balance</span>
                                </div>
                            </div>
                        </div>

                    </div>

                    <div class="col-md-3">
                        <div class="card bg-info">
                            <div class="card-body">
                                <div class="row">
                                    <div class="col mt-0">
                                        <h5 class="card-title text-white">Cash In</h5>
                                    </div>

                                    <div class="col-auto">
                                        <div class="stat text-primary">
                                            <i class="align-middle" data-feather="plus-circle"></i>
                                        </div>
                                    </div>
                                </div>
                                <h1 class="mt-1 mb-3 text-white">{{currency}} {{transaction_summary.debit_total|floatformat:2|intcomma}}</h1>
                                <div class="mb-0">
                                    
                                    <span class="text-white">Today</span>
                                </div>
                            </div>
                        </div>

                    </div>

                    <div class="col-md-3">
                        <div class="card bg-danger">
                            <div class="card-body">
                                <div class="row">
                                    <div class="col mt-0">
                                        <h5 class="card-title text-white">Cash Out</h5>
                                    </div>

                                    <div class="col-auto">
                                        <div class="stat text-primary">
                                            <i class="align-middle" data-feather="minus-circle"></i>
                                        </div>
                                    </div>
                                </div>
                                <h1 class="mt-1 mb-3 text-white">{{currency}} {{transaction_summary.credit_total|floatformat:2|intcomma}}</h1>
                                <div class="mb-0">
                                    
                                    <span class="text-white">Today</span>
                                </div>
                            </div>
                        </div>

                    </div>

                    <div class="col-md-3">
                        <a href="{% url 'transaction-details' %}" class="text-decoration-none">
                        <div class="card bg-primary">
                            <div class="card-body">
                                <div class="row">
                                    <div class="col mt-0">
                                        <h5 class="card-title text-white">Cash Drawer</h5>
                                    </div>

                                    <div class="col-auto">
                                        <div class="stat text-primary">
                                            <i class="align-middle" data-feather="inbox"></i>
                                        </div>
                                    </div>
                                </div>
                                <h1 class="mt-1 mb-3 text-white">{{currency}} {{current_balance|floatformat:2|intcomma}}</h1>
                                <div class="mb-0">
                                    <span class="text-white">Today</span>
                                </div>
                            </div>
                        </div>
                        </a>

                    </div>


                </div>

            </div>




        </div>


        <div class="row">

            <div class="col-12">

                <div class="row">

                    <div class="col-md-2">
                        <div class="card bg-primary">
                            <div class="card-body">
                                <div class="row">
                                    <div class="col mt-0">
                                        <h5 class="card-title text-white">Cash</h5>
                                    </div>

                                    <div class="col-auto">
                                        <div class="stat text-primary">
                                            <i class="align-middle" data-feather="pocket"></i>
                                        </div>
                                    </div>
                                </div>
                                <h1 class="mt-1 mb-3 text-white">{{currency}} {{cash_total|floatformat:2}}</h1>
                                <div class="mb-0">
                                    <span class="text-white">Cash Payments</span>
                                </div>
                            </div>
                        </div>

                    </div>

                    <div class="col-md-2">
                        <div class="card bg-primary">
                            <div class="card-body">
                                <div class="row">
                                    <div class="col mt-0">
                                        <h5 class="card-title text-white">PDQ</h5>
                                    </div>

                                    <div class="col-auto">
                                        <div class="stat text-primary">
                                            <i class="align-middle" data-feather="pocket"></i>
                                        </div>
                                    </div>
                                </div>
                                <h1 class="mt-1 mb-3 text-white">{{currency}} {{pdq_total|floatformat:2}}</h1>
                                <div class="mb-0">
                                    <span class="text-white">PDQ Payments</span>
                                </div>
                            </div>
                        </div>

                    </div>


                    <div class="col-md-2">
                        <div class="card bg-primary">
                            <div class="card-body">
                                <div class="row">
                                    <div class="col mt-0">
                                        <h5 class="card-title text-white">Bank</h5>
                                    </div>

                                    <div class="col-auto">
                                        <div class="stat text-primary">
                                            <i class="align-middle" data-feather="pocket"></i>
                                        </div>
                                    </div>
                                </div>
                                <h1 class="mt-1 mb-3 text-white">{{currency}} {{bank_total|floatformat:2}}</h1>
                                <div class="mb-0">
                                    <span class="text-white">Bank Payments</span>
                                </div>
                            </div>
                        </div>

                    </div>

                    
                     
                    <div class="col-md-2">
                        <a href="{% url 'expense-details' %}" class="text-decoration-none">
                        <div class="card bg-danger">
                            <div class="card-body">
                                <div class="row">
                                    <div class="col mt-0">
                                        <h5 class="card-title text-white">Expense</h5>
                                    </div>

                                    <div class="col-auto">
                                        <div class="stat text-primary">
                                            <i class="align-middle" data-feather="minus-circle"></i>
                                        </div>
                                    </div>
                                </div>
                                <h1 class="mt-1 mb-3 text-white">{{currency}} {{expense_summary.today_balance|floatformat:2|intcomma}}</h1>
                                <div class="mb-0">
                                    <span class="text-white">Today's Expenses</span>
                                </div>
                            </div>
                        </div>
                        </a>
                    </div>
                    

                    
                    <div class="col-md-4">
                        <div class="card bg-success">
                            <div class="card-body">
                                <div class="row">
                                    <div class="col mt-0">
                                        <h5 class="card-title text-white">Total</h5>
                                    </div>

                                    <div class="col-auto">
                                        <div class="stat text-primary">
                                            <i class="align-middle" data-feather="pocket"></i>
                                        </div>
                                    </div>
                                </div>
                                <h1 class="mt-1 mb-3 text-white">{{currency}} {{net_total|floatformat:2|intcomma}}</h1>
                                <div class="mb-0">
                                    <span class="text-white">Total Payments</span>
                                </div>
                            </div>
                        </div>

                    </div>


                    


                </div>

            </div>

        </div>

        <div class="row">

            <div class="col-md-12 col-lg-12 col-xl-6">

                <div class="card">
                    <div class="card-header">
                        <h5 class="card-title">Cash Payments (Invoice)</h5>
                    </div>
                    <div class="card-body">
                        <table class="table table-responsive table-striped" style="width:100%">
                            <thead>
                                <tr>
                                    
                                    
                                    <th>Invoice</th>
                                    <th>Date</th>
                                    <th>Time</th>
                                    <th>Status</th>
                                    <th class="text-sm-end">Amount</th>
                                    
                                    
                                </tr>
                            </thead>
                            <tbody>

                                {% for invoice_payment in invoice_cash_list %}
                                <tr>
                                    
                                    
                                    <td>{{invoice_payment.invoice.id}}</td>
                                    <td>{{invoice_payment.invoice.invoice_date}}</td>
                                    <td>{{invoice_payment.invoice.invoice_time}}</td>

                                    {% if invoice_payment.invoice.invoice_status|lower == "paid" %}
                                        <td><span class="badge bg-success">Paid</span></td>
                                        {% elif invoice_payment.invoice.invoice_status|lower == "unpaid" %}
                                        <td><span class="badge bg-warning">Unpaid</span></td>
                                        {% elif invoice_payment.invoice.invoice_status|lower == "cancelled" %}
                                        <td><span class="badge bg-danger">Cancelled</span></td>
                                        {% else %}
                                        <td><span class="badge bg-danger">Error# {{invoice_payment.invoice.invoice_status}}</span></td>
                                        {% endif %}

                                    <td class="text-sm-end">{{currency}} {{invoice_payment.amount|floatformat:2|intcomma}}</td>
                                    

                                </tr>
                                {% endfor %}
                               
                            </tbody>
                        </table>
                    </div>
                </div>

            </div>

            <div class="col-md-12 col-lg-12 col-xl-6">

                <div class="card">
                    <div class="card-header">
                        <h5 class="card-title">Cash Payments (Customer Payments)</h5>
                    </div>
                    <div class="card-body">
                        <table class="table table-responsive table-striped" style="width:100%">
                            <thead>
                                <tr>
                                    
                                    <th>Receipt</th>
                                    <th>Date</th>
                                    <th>Time</th>
                                    <th>Status</th>
                                    <th class="text-sm-end">Amount ({{currency}})</th>
                                    
                                    
                                </tr>
                            </thead>
                            <tbody>

                                {% for customer_payment_item in customer_payment_cash_list %}
                                <tr>
                                    
                                    <td>{{customer_payment_item.customer_payment.id}}</td>
                                    <td>{{customer_payment_item.customer_payment.payment_date}}</td>
                                    <td>{{customer_payment_item.customer_payment.payment_time}}</td>

                                    {% if customer_payment_item.customer_payment.payment_status|lower == "paid" %}
                                        <td><span class="badge bg-success">Paid</span></td>
                                        {% elif customer_payment_item.customer_payment.payment_status|lower == "unpaid" %}
                                        <td><span class="badge bg-warning">Unpaid</span></td>
                                        {% elif customer_payment_item.customer_payment.payment_status|lower == "cancelled" %}
                                        <td><span class="badge bg-danger">Cancelled</span></td>
                                        {% else %}
                                        <td><span class="badge bg-danger">Error# {{customer_payment_item.customer_payment.payment_status}}</span></td>
                                        {% endif %}

                                    <td class="text-sm-end">{{currency}} {{customer_payment_item.amount|floatformat:2|intcomma}}</td>
                                    

                                </tr>
                                {% endfor %}
                               
                            </tbody>
                        </table>
                    </div>
                </div>

            </div>

        </div>     


        <div class="row">

            <div class="col-md-12 col-lg-12 col-xl-6">

                <div class="card">
                    <div class="card-header">
                        <h5 class="card-title">PDQ Payments (Invoice)</h5>
                    </div>
                    <div class="card-body">
                        <table class="table table-responsive table-striped" style="width:100%">
                            <thead>
                                <tr>
                                    
                                    <th>Invoice</th>
                                    <th>Date</th>
                                    <th>Time</th>
                                    <th>Status</th>
                                    <th class="text-sm-end">Amount ({{currency}})</th>
                                    
                                    
                                </tr>
                            </thead>
                            <tbody>

                                {% for invoice_payment in invoice_pdq_list %}
                                <tr>
                                    
                                    <td>{{invoice_payment.invoice.id}}</td>
                                    <td>{{invoice_payment.invoice.invoice_date}}</td>
                                    <td>{{invoice_payment.invoice.invoice_time}}</td>

                                    {% if invoice_payment.invoice.invoice_status|lower == "paid" %}
                                        <td><span class="badge bg-success">Paid</span></td>
                                        {% elif invoice_payment.invoice.invoice_status|lower == "unpaid" %}
                                        <td><span class="badge bg-warning">Unpaid</span></td>
                                        {% elif invoice_payment.invoice.invoice_status|lower == "cancelled" %}
                                        <td><span class="badge bg-danger">Cancelled</span></td>
                                        {% else %}
                                        <td><span class="badge bg-danger">Error# {{invoice_payment.invoice.invoice_status}}</span></td>
                                        {% endif %}

                                    <td class="text-sm-end">{{currency}} {{invoice_payment.amount|floatformat:2|intcomma}}</td>
                                    

                                </tr>
                                {% endfor %}
                               
                            </tbody>
                        </table>
                    </div>
                </div>

            </div>

            <div class="col-md-12 col-lg-12 col-xl-6">

                <div class="card">
                    <div class="card-header">
                        <h5 class="card-title">PDQ Payments (Customer Payments)</h5>
                    </div>
                    <div class="card-body">
                        <table class="table table-responsive table-striped" style="width:100%">
                            <thead>
                                <tr>
                                    
                                    <th>Receipt</th>
                                    <th>Date</th>
                                    <th>Time</th>
                                    <th>Status</th>
                                    <th class="text-sm-end">Amount ({{currency}})</th>
                                    
                                    
                                </tr>
                            </thead>
                            <tbody>

                                {% for customer_payment_item in customer_payment_pdq_list %}
                                <tr>
                                    
                                    <td>{{customer_payment_item.customer_payment.id}}</td>
                                    <td>{{customer_payment_item.customer_payment.payment_date}}</td>
                                    <td>{{customer_payment_item.customer_payment.payment_time}}</td>

                                    {% if customer_payment_item.customer_payment.payment_status|lower == "paid" %}
                                        <td><span class="badge bg-success">Paid</span></td>
                                        {% elif customer_payment_item.customer_payment.payment_status|lower == "unpaid" %}
                                        <td><span class="badge bg-warning">Unpaid</span></td>
                                        {% elif customer_payment_item.customer_payment.payment_status|lower == "cancelled" %}
                                        <td><span class="badge bg-danger">Cancelled</span></td>
                                        {% else %}
                                        <td><span class="badge bg-danger">Error# {{customer_payment_item.customer_payment.payment_status}}</span></td>
                                        {% endif %}

                                    <td class="text-sm-end">{{currency}} {{customer_payment_item.amount|floatformat:2|intcomma}}</td>
                                    

                                </tr>
                                {% endfor %}
                               
                            </tbody>
                        </table>
                    </div>
                </div>

            </div>

        </div>     


        <div class="row">

            <div class="col-md-12 col-lg-12 col-xl-6">

                <div class="card">
                    <div class="card-header">
                        <h5 class="card-title">Bank Payments (Invoice)</h5>
                    </div>
                    <div class="card-body">
                        <table class="table table-responsive table-striped" style="width:100%">
                            <thead>
                                <tr>
                                    
                                    <th>Invoice</th>
                                    <th>Date</th>
                                    <th>Time</th>
                                    <th>Status</th>
                                    <th class="text-sm-end">Amount ({{currency}})</th>
                                    
                                    
                                </tr>
                            </thead>
                            <tbody>

                                {% for invoice_payment in invoice_bank_list %}
                                <tr>
                                    
                                    <td>{{invoice_payment.invoice.id}}</td>
                                    <td>{{invoice_payment.invoice.invoice_date}}</td>
                                    <td>{{invoice_payment.invoice.invoice_time}}</td>

                                    {% if invoice_payment.invoice.invoice_status|lower == "paid" %}
                                        <td><span class="badge bg-success">Paid</span></td>
                                        {% elif invoice_payment.invoice.invoice_status|lower == "unpaid" %}
                                        <td><span class="badge bg-warning">Unpaid</span></td>
                                        {% elif invoice_payment.invoice.invoice_status|lower == "cancelled" %}
                                        <td><span class="badge bg-danger">Cancelled</span></td>
                                        {% else %}
                                        <td><span class="badge bg-danger">Error# {{invoice_payment.invoice.invoice_status}}</span></td>
                                        {% endif %}

                                    <td class="text-sm-end">{{currency}} {{invoice_payment.amount|floatformat:2|intcomma}}</td>
                                    

                                </tr>
                                {% endfor %}
                               
                            </tbody>
                        </table>
                    </div>
                </div>

            </div>

            <div class="col-md-12 col-lg-12 col-xl-6">

                <div class="card">
                    <div class="card-header">
                        <h5 class="card-title">Bank Payments (Customer Payments)</h5>
                    </div>
                    <div class="card-body">
                        <table class="table table-responsive table-striped" style="width:100%">
                            <thead>
                                <tr>
                                    
                                    <th>Receipt</th>
                                    <th>Date</th>
                                    <th>Time</th>
                                    <th>Status</th>
                                    <th class="text-sm-end">Amount ({{currency}})</th>
                                    
                                    
                                </tr>
                            </thead>
                            <tbody>

                                {% for customer_payment_item in customer_payment_bank_list %}
                                <tr>
                                    
                                    <td>{{customer_payment_item.customer_payment.id}}</td>
                                    <td>{{customer_payment_item.customer_payment.payment_date}}</td>
                                    <td>{{customer_payment_item.customer_payment.payment_time}}</td>

                                    {% if customer_payment_item.customer_payment.payment_status|lower == "paid" %}
                                        <td><span class="badge bg-success">Paid</span></td>
                                        {% elif customer_payment_item.customer_payment.payment_status|lower == "unpaid" %}
                                        <td><span class="badge bg-warning">Unpaid</span></td>
                                        {% elif customer_payment_item.customer_payment.payment_status|lower == "cancelled" %}
                                        <td><span class="badge bg-danger">Cancelled</span></td>
                                        {% else %}
                                        <td><span class="badge bg-danger">Error# {{customer_payment_item.customer_payment.payment_status}}</span></td>
                                        {% endif %}

                                    <td class="text-sm-end">{{currency}} {{customer_payment_item.amount|floatformat:2|intcomma}}</td>
                                    

                                </tr>
                                {% endfor %}
                               
                            </tbody>
                        </table>
                    </div>
                </div>

            </div>


            <div class="col-md-12 col-lg-12 col-xl-6">

                <div class="card">
                    <div class="card-header">
                        <h5 class="card-title">Expenses</h5>
                    </div>
                    <div class="card-body">
                        <table class="table table-responsive table-striped" style="width:100%">
                            <thead>
                                <tr>
                                    
                                    <th>Voucher</th>
                                    <th>Date</th>
                                    <th>Time</th>

                                    <th>Type</th>
                                    
                                    <th class="text-sm-end">Amount ({{currency}})</th>
                                    
                                    
                                </tr>
                            </thead>
                            <tbody>

                                {% for cash_voucher in cash_voucher_list %}
                                <tr>
                                    
                                    <td>{{cash_voucher.id}}</td>
                                    <td>{{cash_voucher.transaction_date}}</td>
                                    <td>{{cash_voucher.transaction_time}}</td>

                                    <td>{{cash_voucher.transaction_type}}</td>

                                    <td class="text-sm-end">{{currency}} {{cash_voucher.transaction_amount|floatformat:2|intcomma}}</td>
                                    

                                </tr>
                                {% endfor %}
                               
                            </tbody>
                        </table>
                    </div>
                </div>

            </div>

        </div>     



    </div>
</main>


<script>
    const ctx = document.getElementById('counsellors-reg-count-performance-chart');

    new Chart(ctx, {
        type: 'bar',
        data: {
            labels: {{counsellor_reg_count_performance_chart_label|safe}},
            datasets: [{
                label: '# Number of Registered Students',
                data: {{counsellor_reg_count_performance_chart_data|safe}},
                backgroundColor: [
                    'rgba(29, 37, 99, 1)'
                ],
                borderWidth: 1
            }]
        },
        options: {

            scales: {
                x: {
                    stacked: true
                },
                y: {
                    stacked: true,
                    ticks: {
                        stepSize: 1
                    },
                },
            },
            responsive: true,
            maintainAspectRatio: false,

            //scales: {
            //    y: {
            //        beginAtZero: true
            //    }
            //}
        }
    });
</script>

<script>
    const ctx2 = document.getElementById('counsellors-revenue-performance-chart');

    new Chart(ctx2, {
        type: 'bar',
        data: {
            labels: {{counsellor_revenue_performance_chart_label|safe}},
            datasets: [{
                label: 'Revenue',
                data: {{counsellor_revenue_performance_chart_data|safe}},
                backgroundColor: [
                'rgba(29, 37, 99, 1)'
                ],
                borderWidth: 1
            }]
        },
        options: {

            scales: {
                x: {
                    stacked: true
                },
                y: {
                    stacked: true
                },
            },
            responsive: true,
            maintainAspectRatio: false,

            //scales: {
            //    y: {
            //        beginAtZero: true
            //    }
            //}
        }
    });
</script>


{% endblock %}