general_rk_home.html

{% extends "base.html" %}
{% load static %}
{% load humanize %}
{% load currency_filters %}
{% block extra_css %}
<style>
    /* General Styling */
    main {
       
        min-height: 100vh;
        padding: 2.5rem 1rem;
        
    }
    .container-fluid {
        max-width: 1600px;
        padding-left: 0.75rem;
        padding-right: 0.75rem;
    }

    
    /* Stat Card Styling */
    .stat-card {
        transition: transform 0.3s ease, box-shadow 0.3s ease;
        border: none;
        border-radius: 14px;
        overflow: hidden;
    }
    .stat-card:hover {
        transform: translateY(-10px);
        box-shadow: 0 12px 24px rgba(0, 0, 0, 0.15);
    }
    .card-body {
        padding: 1.2rem;
        color: #fff;
        position: relative;
    }
    .card-body-1 {
        padding: 0.6rem;
        color: #fff;
        position: relative;
    }
    .gradient-total {
        background: linear-gradient(135deg, rgba(12, 56, 50, 0.637) 0%, rgba(0, 14, 15, 0.527) 100%);
    }
    .gradient-corporate {
        background: linear-gradient(135deg, rgba(94, 77, 33, 0.9) 0%, rgba(75, 85, 99, 0.9) 100%);
    }
    .gradient-medium {
        background: linear-gradient(135deg, rgba(30, 54, 85, 0.75) 0%, rgba(6, 45, 107, 0.75) 100%);
    }
    .gradient-small {
        background: linear-gradient(135deg, rgba(23, 77, 57, 0.75) 0%, rgba(1, 75, 50, 0.75) 100%);
    }
    .card-icon {
        font-size: 1.6rem;
        opacity: 0.85;
        position: absolute;
        right: 1.2rem;
        top: 1.2rem;
    }
    .stat-value {
  font-size: 1.5rem;
  font-weight: 700;
  margin-bottom: 0.5rem;
  text-shadow: 0 1px 2px rgba(0, 0, 0, 0.2);
}
.stat-label {
  font-size: 0.75rem;
  font-weight: bold;
  text-transform: uppercase;
  opacity: 1;
  margin-bottom: 0.5rem;
  color: #e6e6e6;
}
    .stat-label-1 {
        font-size: 1rem;
        font-weight: bold;
        text-transform: uppercase;
        opacity: 1;
        margin-bottom: 0.5rem;
        color: #ffffff;
    }
    .overdue-info {
        font-size: 1rem;
        display: flex;
        align-items: center;
        gap: 0.5rem;
        background: rgba(0, 0, 0, 0.25);
        padding: 0.5rem;
        border-radius: 8px;
    }
    .overdue-info-1 {
        font-size: 0.7rem;
        display: flex;
        align-items: center;
        gap: 0.3rem;
        background: rgba(0, 0, 0, 0.25);
        padding: 0.3rem;
        border-radius: 4px;
    }

    /* Chart Card Styling */
    .chart-card {
        border-radius: 14px;
        box-shadow: 0 6px 18px rgba(0, 0, 0, 0.1);
        border: none;
        overflow: hidden;
        min-height: 500px;
    }
    .chart-card .card-header {
        background: #fff;
        padding: 1.2rem;
        font-weight: 600;
        color: #2c3e50;
        display: flex;
        align-items: center;
        gap: 0.6rem;
        font-size: 1.1rem;
    }
    .chart-container {
        max-height: 450px;
        overflow-y: auto;
        padding: 1.5rem;
    }
    .chart-container::-webkit-scrollbar {
        width: 10px;
    }
    .chart-container::-webkit-scrollbar-thumb {
        background: #4e73df;
        border-radius: 5px;
    }
    .js-plotly-plot .plotly .cursor-crosshair {
  cursor: pointer;
}
    .chart-container::-webkit-scrollbar-track {
        background: #f1f1f1;
    }

    /* Table Styling */
    .table {
        background: #fff;
        border-radius: 14px;
        overflow: hidden;
        box-shadow: 0 6px 18px rgba(0, 0, 0, 0.1);
    }
    .table thead th {
        background: #4e73df;
        color: #fff;
        font-weight: 600;
    }
    .table tbody tr:hover {
        background: #f8f9fc;
    }
    .card-link {
        text-decoration: none;
        color: inherit;
        display: block;
    }
    .card-link:hover .card {
        box-shadow: 0 6px 12px rgba(0, 0, 0, 0.2);
    }
    .btn-success {
    background-color: #ff0000 !important; /* Signal red for active state */
    border-color: #ff0000 !important;
    color: #ffffff !important;
    font-weight: bold;
    transform: scale(1.1); /* Slightly larger for emphasis */
    transition: transform 0.2s ease-in-out;
}
.btn-outline-secondary {
    background-color: #e0e0e0; /* Light gray for inactive state */
    border-color: #6c757d;
    color: #6c757d;
}
.btn-outline-secondary:hover {
    background-color: #d0d0d0; /* Slightly darker gray on hover */
}
    /* Responsive Adjustments */
    @media (max-width: 768px) {
        .stat-value {
            font-size: 1.5rem;
        }
        .card-icon {
            font-size: 1.4rem;
        }
        .chart-container {
            max-height: 350px;
        }
        .container-fluid {
            padding-left: 0.5rem;
            padding-right: 0.5rem;
        }
        .page-header {
            font-size: 1.8rem;
        }
        .chart-card {
            min-height: 400px;
        }
    }
    .btn-alfa {
width: 100%; /* Full width of the container */
padding: 0.4rem 0.8rem; /* Smaller padding for a compact look */
font-size: 0.9rem; /* Smaller font size */
line-height: 1.4; /* Adjust line height for better text alignment */
border-radius: 8px; /* Slightly rounded corners */
transition: background-color 0.3s ease, transform 0.2s ease; /* Smooth transitions */
}

.btn-alfa:hover {
background-color: #afada8; /* Slightly darker yellow on hover */
transform: translateY(-2px); /* Subtle lift effect */
}
.d-flex.flex-row {
flex-wrap: nowrap; /* Prevent wrapping to keep buttons in one line */
width: 100%; /* Ensure the container takes full width */
}
</style>
{% endblock extra_css %}
{% block content %}

{% if user.is_authenticated %}
<main class="px-2 py-3">
    <div class="container-fluid">
        <!-- Header Section -->
        <div class="row g-4 mb-4">
            
            <div class="d-flex flex-row gap-2">
                <a href="{% url 'home' %}" class="btn btn-outline-warning"><i class="fa-solid fa-house-chimney"></i></a>      
                <a href="{% url 'home-all' %}" class="btn btn-outline-secondary btn-alfa">Все</a>
                <a href="{% url 'home-kk' %}" class="btn btn-outline-secondary btn-alfa">Корпоративный</a>
                <a href="{% url 'home-rk' %}" class="btn btn-success btn-alfa">Розничный</a>
                <a href="{% url 'home-mk' %}" class="btn btn-outline-secondary btn-alfa">Малый</a>
            </div>
            <h1 class="page-header">Розничный Кредитный портфель за {{ df_name }}</h1>
        </div>
           

        <div class="row g-4 mb-4">
            <div class="col-xl-2 col-md-6">
                <a href="#" class="text-decoration-none d-block">
                <div class="card stat-card h-100 shadow-sm">
                    <div class="card-body-1 gradient-medium position-relative">
                        <div class="stat-label fw-bold text-uppercase">КП ⇛ Женщина</div>
                        <div class="stat-value mt-2 fw-bold">
                            {{ female_lp|format_currency }}
                        </div>
                        <div class="overdue-info-1 mt-3 d-flex align-items-center flex-wrap" style="max-width: 92%;">
                            <i class="fas fa-exclamation-triangle text-danger me-2"></i>
                            <span class="fw-medium">NPL: </span>
                            <span class="fw-bold text-danger ms-1" style="font-size: 1.3em;">
                                {{female_npl|format_currency}}➜{{ female_percent|floatformat:1 }}%
                            </span>
                        </div>
                        <div class="card-icon position-absolute end-0 top-0 p-3 opacity-90">
                            <i class="fas fa-person-dress fa text-warning"></i>
                        </div>
                    </div>
                </div>
                </a>
            </div>
            <div class="col-xl-2 col-md-6">
                <a href="#" class="text-decoration-none d-block">
                <div class="card stat-card h-100 shadow-sm">
                    <div class="card-body-1 gradient-medium position-relative">
                        <div class="stat-label fw-bold text-uppercase">КП ⇛ Мужчина</div>
                        <div class="stat-value mt-2 fw-bold">
                            {{ male_lp|format_currency }}
                        </div>
                        <div class="overdue-info-1 mt-3 d-flex align-items-center flex-wrap" style="max-width: 92%;">
                            <i class="fas fa-exclamation-triangle text-danger me-2"></i>
                            <span class="fw-medium">NPL: </span>
                            <span class="fw-bold text-danger ms-1" style="font-size: 1.3em;">
                                {{male_npl|format_currency}}➜{{ male_percent|floatformat:1 }}%
                            </span>
                        </div>
                        <div class="card-icon position-absolute end-0 top-0 p-3 opacity-90">
                            <i class="fas fa-person fa text-warning"></i>
                        </div>
                    </div>
                </div>
                </a>
            </div>
            <div class="col-xl-4 col-md-6">
                <div class="card stat-card h-100 shadow-sm">
                    <div class="card-body-1 gradient-medium position-relative">
                        <div class="stat-label-1 fw-bold text-uppercase">Розничный Кредитный Портфель</div>
                        <div class="stat-value mt-2 fw-bold">
                            Портфель: {{ lp|format_currency }}
                        </div>
                        <div class="overdue-info mt-3 d-flex align-items-center flex-wrap" style="max-width: 92%;">
                            <i class="fas fa-exclamation-triangle text-danger me-2"></i>
                            <span class="fw-medium">NPL: </span>
                            <span class="fw-bold text-danger ms-1" style="font-size: 1.3em;">
                                {{npl|format_currency}}➜{{ npl_percent|floatformat:1 }}%
                            </span>
                        </div>
                        <div class="card-icon position-absolute end-0 top-0 p-3 opacity-90">
                            <i class="fas fa-credit-card fa-2x text-warning"></i>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-xl-2 col-md-6">
                <a href="{% url 'currency_home' currency='local' dept='rk' %}" class="text-decoration-none d-block">
                <div class="card stat-card h-100 shadow-sm">
                    <div class="card-body-1 gradient-medium position-relative">
                        <div class="stat-label fw-bold text-uppercase">КР ⇛ Нац. Валюта</div>
                        <div class="stat-value mt-2 fw-bold">
                            {{ national_lp|format_currency }}
                            <span class="value-percentage fw-bold" style="font-size: 0.6em; color: #f8d7a1; margin-left: 5px;"
                      data-bs-toggle="tooltip" 
                      data-bs-placement="top" 
                      title="Средняя процентная ставка по кредитам, выданным в узбекских сумах.">
                    {{ local_interest_rate|floatformat:1 }}%
                </span>
                        </div>
                        <div class="overdue-info-1 mt-3 d-flex align-items-center flex-wrap" style="max-width: 92%;">
                            <i class="fas fa-exclamation-triangle text-danger me-2"></i>
                            <span class="fw-medium">NPL: </span>
                            <span class="fw-bold text-danger ms-1" style="font-size: 1.3em;">
                                {{national_npl|format_currency}}➜{{ national_percent|floatformat:1 }}%
                            </span>
                        </div>
                        <div class="card-icon position-absolute end-0 top-0 p-3 opacity-90">
                            <i class="fas fa-coins fa text-warning"></i>
                        </div>
                    </div>
                </div>
            </a>
            </div>
            <div class="col-xl-2 col-md-6">
                <a href="{% url 'currency_home' currency='global' dept='rk' %}" class="text-decoration-none d-block">
                <div class="card stat-card h-100 shadow-sm">
                    <div class="card-body-1 gradient-medium position-relative">
                        <div class="stat-label fw-bold text-uppercase">КР ⇛ Иноц. Валюта</div>
                        <div class="stat-value mt-2 fw-bold">
                            
                            {{ foreign_lp|format_currency }}
                            <span class="value-percentage fw-bold" style="font-size: 0.6em; color: #f8d7a1; margin-left: 5px;"
                      data-bs-toggle="tooltip" 
                      data-bs-placement="top" 
                      title="Средняя процентная ставка по кредитам, выданным в иностранной валюте.">
                    {{ global_interest_rate|floatformat:1 }}%
                </span>
                        </div>
                        <div class="overdue-info-1 mt-3 d-flex align-items-center flex-wrap" style="max-width: 92%;">
                            <i class="fas fa-exclamation-triangle text-danger me-2"></i>
                            <span class="fw-medium">NPL: </span>
                            <span class="fw-bold text-danger ms-1" style="font-size: 1.3em;">
                                {{foreign_npl|format_currency}}➜{{ foreign_percent|floatformat:1 }}%
                            </span>
                        </div>
                        <div class="card-icon position-absolute end-0 top-0 p-3 opacity-90">
                            <i class="fas fa-dollar-sign fa text-warning"></i>
                        </div>
                    </div>
                </div>
            </a>
            </div>
        </div>
<hr>
        <div class="row g-4 mb-4">
            <!-- KK Chart -->
            <div class="col-xl-4">
                <div class="card chart-card h-100">
                    <div class="card-header">
                        <i class="fas fa-chart-bar me-2 text-primary"></i>
                        Розничные кредиты по Филиалом
                    </div>
                    <div class="chart-container">
                        {{ fig_branch|safe }}
                    </div>
                </div>
            </div>

            <!-- RK Chart -->
            <div class="col-xl-4">
                <div class="card chart-card h-100">
                    <div class="card-header">
                        <i class="fas fa-chart-pie me-2 text-primary"></i>
                        Розничные кредиты по Категория Качества
                    </div>
                    <div class="chart-container">
                        {{ fig_cat|safe }}
                    </div>
                </div>
            </div>

            <!-- MK Chart -->
            <div class="col-xl-4">
                <div class="card chart-card h-100">
                    <div class="card-header">
                        <i class="fas fa-chart-bar me-2 text-primary"></i>
                        Розничные кредиты по Кредитный паспорт
                    </div>
                    <div class="chart-container">
                        {{ fig_loan_type|safe }}
                    </div>
                </div>
            </div>
        </div>
    </div>
</main>
{% else %}
<main class="bg-light d-flex align-items-center justify-content-center vh-100">
    <div class="card text-center shadow-lg p-4 border-0" style="max-width: 400px;">
        <div class="card-body">
            <i class="fas fa-lock fa-4x text-danger mb-3"></i>
            <h3 class="card-title">Доступ ограничен</h3>
            <p class="card-text text-muted">Чтобы выполнить это действие, необходимо войти в систему.</p>
            <a href="{% url 'login' %}" class="btn btn-warning">
                <i class="fas fa-sign-in-alt"></i> Войти
            </a>
        </div>
    </div>
</main>
{% endif %}
<script>
    // Initialize all tooltips on the page
document.addEventListener('DOMContentLoaded', function () {
    var tooltipTriggerList = [].slice.call(document.querySelectorAll('[data-bs-toggle="tooltip"]'));
    tooltipTriggerList.forEach(function (tooltipTriggerEl) {
        new bootstrap.Tooltip(tooltipTriggerEl);
    });
});
</script>
{% endblock content %}