{% extends 'base.html' %}
{% load static %}
{% load custom_tags %}

{% block title %}Dashboard - Business Analytics{% endblock %}

{% block content %}
<div class="container-fluid px-3">
    <!-- Header Section -->
    <div class="row mb-4">
        <div class="col-12">
            <div class="d-flex flex-column flex-md-row justify-content-between align-items-start align-items-md-center">
                <div class="mb-3 mb-md-0">
                    <h1 class="h3 mb-2 text-primary">
                        <i class="fas fa-chart-line mr-2"></i>Business Dashboard
                    </h1>
                    <p class="text-muted mb-0">Real-time business insights and analytics</p>
                </div>
                <div class="d-flex align-items-center">
                    <small class="text-muted mr-3">
                        <i class="fas fa-clock mr-1"></i>
                        Last updated: <span id="lastUpdated"></span>
                    </small>
                    <button class="btn btn-outline-primary btn-sm" onclick="refreshDashboard()">
                        <i class="fas fa-sync-alt mr-1"></i>Refresh
                    </button>
                </div>
            </div>
        </div>
    </div>

    <!-- Quick Stats Row -->
    <div class="row mb-4">
        <div class="col-xl-3 col-lg-6 col-md-6 mb-4">
            <div class="card border-0 shadow-sm h-100">
                <div class="card-body">
                    <div class="d-flex align-items-center">
                        <div class="flex-grow-1">
                            <div class="text-xs font-weight-bold text-success text-uppercase mb-1">
                                Total Sales
                            </div>
                            <div class="h4 mb-0 font-weight-bold" style="color: var(--card-fg);">
                                KSh {{ total_sales|floatformat:2|default:"0.00" }}
                            </div>
                        </div>
                        <div class="icon-circle bg-success">
                            <i class="fas fa-dollar-sign text-white"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-lg-6 col-md-6 mb-4">
            <div class="card border-0 shadow-sm h-100">
                <div class="card-body">
                    <div class="d-flex align-items-center">
                        <div class="flex-grow-1">
                            <div class="text-xs font-weight-bold {% if profit_loss >= 0 %}text-success{% else %}text-danger{% endif %} text-uppercase mb-1">
                                Profit/Loss
                            </div>
                            <div class="h4 mb-0 font-weight-bold {% if profit_loss >= 0 %}text-success{% else %}text-danger{% endif %}">
                                KSh {{ profit_loss|floatformat:2|default:"0.00" }}
                            </div>
                        </div>
                        <div class="icon-circle {% if profit_loss >= 0 %}bg-success{% else %}bg-danger{% endif %}">
                            <i class="fas {% if profit_loss >= 0 %}fa-arrow-up{% else %}fa-arrow-down{% endif %} text-white"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-lg-6 col-md-6 mb-4">
            <div class="card border-0 shadow-sm h-100">
                <div class="card-body">
                    <div class="d-flex align-items-center">
                        <div class="flex-grow-1">
                            <div class="text-xs font-weight-bold text-info text-uppercase mb-1">
                                Inventory Value
                            </div>
                            <div class="h4 mb-0 font-weight-bold" style="color: var(--card-fg);">
                                KSh {{ inventory_value|floatformat:2|default:"0.00" }}
                            </div>
                        </div>
                        <div class="icon-circle bg-info">
                            <i class="fas fa-boxes text-white"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Business Insights Row -->
    <div class="row mb-4">
        <!-- Sales Analytics -->
        <div class="col-lg-8 mb-4">
            <div class="card border-0 shadow-sm h-100">
                <div class="card-header border-0 pb-0" style="background: var(--card-bg);">
                    <div class="d-flex justify-content-between align-items-center">
                        <h6 class="m-0 font-weight-bold text-primary">
                            <i class="fas fa-chart-area mr-2"></i>Sales Performance
                        </h6>
                        <div class="dropdown">
                            <button class="btn btn-sm btn-outline-secondary dropdown-toggle" type="button" data-toggle="dropdown">
                                <i class="fas fa-calendar mr-1"></i>Period
                            </button>
                            <div class="dropdown-menu dropdown-menu-right">
                                <a class="dropdown-item" href="#">Today</a>
                                <a class="dropdown-item" href="#">This Week</a>
                                <a class="dropdown-item" href="#">This Month</a>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="card-body">
                    <div class="row">
                        <div class="col-md-4 mb-3">
                            <div class="rounded p-3 text-center" style="background: var(--input-bg);">
                                <div class="text-xs text-muted mb-1">Today's Sales</div>
                                <div class="h5 mb-0 text-success">KSh {{ daily_sales|floatformat:2|default:"0.00" }}</div>
                            </div>
                        </div>
                        <div class="col-md-4 mb-3">
                            <div class="rounded p-3 text-center" style="background: var(--input-bg);">
                                <div class="text-xs text-muted mb-1">This Week</div>
                                <div class="h5 mb-0 text-primary">KSh {{ weekly_sales|floatformat:2|default:"0.00" }}</div>
                            </div>
                        </div>
                        <div class="col-md-4 mb-3">
                            <div class="rounded p-3 text-center" style="background: var(--input-bg);">
                                <div class="text-xs text-muted mb-1">This Month</div>
                                <div class="h5 mb-0 text-info">KSh {{ monthly_sales|floatformat:2|default:"0.00" }}</div>
                            </div>
                        </div>
                    </div>

                    <div class="mt-4">
                        <h6 class="text-muted mb-3">Payment Methods Breakdown</h6>
                        <div class="row">
                            {% if sales_by_payment_method %}
                            {% for method in sales_by_payment_method %}
                            <div class="col-6 col-md-3 mb-2">
                                <div class="d-flex align-items-center">
                                    <div class="payment-method-icon mr-2">
                                        {% if method.payment_method == 'cash' %}
                                            <i class="fas fa-money-bill-wave text-success"></i>
                                        {% elif method.payment_method == 'mpesa' %}
                                            <i class="fas fa-mobile-alt text-primary"></i>
                                        {% elif method.payment_method == 'credit' %}
                                            <i class="fas fa-credit-card text-warning"></i>
                                        {% elif method.payment_method == 'cheque' %}
                                            <i class="fas fa-file-invoice text-info"></i>
                                        {% else %}
                                            <i class="fas fa-circle text-secondary"></i>
                                        {% endif %}
                                    </div>
                                    <div>
                                        <div class="text-xs text-muted">{{ method.payment_method|title|default:"Unknown" }}</div>
                                        <div class="font-weight-bold">KSh {{ method.total|floatformat:2|default:"0.00" }}</div>
                                    </div>
                                </div>
                            </div>
                            {% endfor %}
                        {% else %}
                            <div class="col-12">
                                <div class="alert alert-info text-center">
                                    <i class="fas fa-info-circle mr-2"></i>
                                    No sales data available yet. 
                                    <a href="/sales/make_sale/" class="alert-link">Make your first sale</a>
                                </div>
                            </div>
                        {% endif %}
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <!-- Quick Actions & Alerts -->
        <div class="col-lg-4 mb-4">
            <div class="card border-0 shadow-sm h-100">
                <div class="card-header border-0 pb-0" style="background: var(--card-bg);">
                    <h6 class="m-0 font-weight-bold text-primary">
                        <i class="fas fa-bell mr-2"></i>Alerts & Quick Actions
                    </h6>
                </div>
                <div class="card-body">
                    <!-- Inventory Alerts -->
                    {% if low_stock_count > 0 %}
                    <div class="alert alert-warning py-2 px-3 mb-3" role="alert">
                        <div class="d-flex align-items-center">
                            <i class="fas fa-exclamation-triangle mr-2"></i>
                            <div class="flex-grow-1">
                                <strong>{{ low_stock_count }}</strong> product{{ low_stock_count|pluralize }} running low
                            </div>
                            <a href="{{ inventory_report_url }}" class="btn btn-sm btn-outline-warning">View</a>
                        </div>
                    </div>
                    {% endif %}

                    {% if near_expiry_count > 0 %}
                    <div class="alert alert-info py-2 px-3 mb-3" role="alert">
                        <div class="d-flex align-items-center">
                            <i class="fas fa-calendar-exclamation mr-2"></i>
                            <div class="flex-grow-1">
                                <strong>{{ near_expiry_count }}</strong> product{{ near_expiry_count|pluralize }} expiring soon
                            </div>
                            <a href="{{ inventory_report_url }}" class="btn btn-sm btn-outline-info">View</a>
                        </div>
                    </div>
                    {% endif %}

                    {% if pending_orders > 0 %}
                    <div class="alert alert-secondary py-2 px-3 mb-3" role="alert">
                        <div class="d-flex align-items-center">
                            <i class="fas fa-clock mr-2"></i>
                            <div class="flex-grow-1">
                                <strong>{{ pending_orders }}</strong> pending order{{ pending_orders|pluralize }}
                            </div>
                            <a href="/orders/" class="btn btn-sm btn-outline-secondary">View</a>
                        </div>
                    </div>
                    {% endif %}

                    <!-- Quick Actions -->
                    <div class="mt-4">
                        <h6 class="text-muted mb-3">Quick Actions</h6>
                        <div class="d-grid gap-2">
                            <a href="/sales/make_sale/" class="btn btn-success btn-sm">
                                <i class="fas fa-plus mr-1"></i>New Sale
                            </a>
                            <a href="/inventory/products/add/" class="btn btn-primary btn-sm">
                                <i class="fas fa-box mr-1"></i>Add Product
                            </a>
                            <a href="/customers/add/" class="btn btn-info btn-sm">
                                <i class="fas fa-user-plus mr-1"></i>Add Customer
                            </a>
                            <a href="/orders/create/" class="btn btn-warning btn-sm">
                                <i class="fas fa-shopping-cart mr-1"></i>Create Order
                            </a>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Bottom Row - Customers & HR -->
    <div class="row mb-4">
        <!-- Customer Insights -->
        <div class="col-lg-6 mb-4">
            <div class="card border-0 shadow-sm h-100">
                <div class="card-header border-0 pb-0" style="background: var(--card-bg);">
                    <div class="d-flex justify-content-between align-items-center">
                        <h6 class="m-0 font-weight-bold text-primary">
                            <i class="fas fa-users mr-2"></i>Customer Insights
                        </h6>
                        <a href="/customers/" class="btn btn-sm btn-outline-primary">View All</a>
                    </div>
                </div>
                <div class="card-body">
                    <div class="row mb-3">
                        <div class="col-6">
                            <div class="text-center">
                                <div class="h4 mb-1 text-success">{{ customer_growth }}</div>
                                <div class="text-xs text-muted">New This Month</div>
                            </div>
                        </div>
                        <div class="col-6">
                            <div class="text-center">
                                <div class="h4 mb-1 text-primary">{{ top_customers|length }}</div>
                                <div class="text-xs text-muted">Top Customers</div>
                            </div>
                        </div>
                    </div>

                    <div>
                        <h6 class="text-muted mb-3">Top Customers</h6>
                        {% for customer in top_customers %}
                        <div class="d-flex align-items-center mb-2">
                            <div class="avatar-sm bg-primary text-white rounded-circle d-flex align-items-center justify-content-center mr-3">
                                {{ customer.first_name|first }}{{ customer.last_name|first }}
                            </div>
                            <div class="flex-grow-1">
                                <div class="font-weight-medium">{{ customer.first_name }} {{ customer.last_name }}</div>
                                <small class="text-muted">KSh {{ customer.total_spent|floatformat:2|default:"0.00" }}</small>
                            </div>
                        </div>
                        {% empty %}
                        <p class="text-muted text-center">No customer data available</p>
                        {% endfor %}
                    </div>
                </div>
            </div>
        </div>

        <!-- HR Overview -->
        <div class="col-lg-6 mb-4">
            <div class="card border-0 shadow-sm h-100">
                <div class="card-header border-0 pb-0" style="background: var(--card-bg);">
                    <div class="d-flex justify-content-between align-items-center">
                        <h6 class="m-0 font-weight-bold text-primary">
                            <i class="fas fa-user-tie mr-2"></i>HR Overview
                        </h6>
                        <a href="/hr/" class="btn btn-sm btn-outline-primary">View All</a>
                    </div>
                </div>
                <div class="card-body">
                    <div class="row">
                        <div class="col-6 mb-3">
                            <div class="text-center">
                                <div class="h4 mb-1 text-primary">{{ employee_count }}</div>
                                <div class="text-xs text-muted">Active Employees</div>
                            </div>
                        </div>
                        <div class="col-6 mb-3">
                            <div class="text-center">
                                <div class="h4 mb-1 text-success">{{ employee_attendance.count }}</div>
                                <div class="text-xs text-muted">Present Today</div>
                            </div>
                        </div>
                    </div>

                    <div class="mt-4">
                        <div class="d-grid gap-2">
                            <a href="/hr/attendance/" class="btn btn-outline-primary btn-sm">
                                <i class="fas fa-calendar-check mr-1"></i>Mark Attendance
                            </a>
                            <a href="/hr/employees/add/" class="btn btn-outline-success btn-sm">
                                <i class="fas fa-user-plus mr-1"></i>Add Employee
                            </a>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<style>
.icon-circle {
    width: 50px;
    height: 50px;
    border-radius: 50%;
    display: flex;
    align-items: center;
    justify-content: center;
    font-size: 20px;
}

.avatar-sm {
    width: 32px;
    height: 32px;
    font-size: 12px;
}

.payment-method-icon i {
    font-size: 16px;
}

.font-weight-medium {
    font-weight: 500;
}

.text-xs {
    font-size: 0.75rem;
}

.bg-light {
    background-color: var(--input-bg) !important;
}

.card {
    transition: transform 0.2s;
}

.card:hover {
    transform: translateY(-2px);
}

.alert {
    border-radius: 10px;
}

.btn-sm {
    font-size: 0.875rem;
}

@media (max-width: 576px) {
    .container-fluid {
        padding-left: 10px;
        padding-right: 10px;
    }

    .icon-circle {
        width: 40px;
        height: 40px;
        font-size: 16px;
    }

    .h4 {
        font-size: 1.25rem;
    }

    .d-grid .btn {
        margin-bottom: 0.5rem;
    }
}

@media (max-width: 768px) {
    .d-flex.flex-column.flex-md-row {
        align-items: stretch !important;
    }
}
</style>

{% block extra_js %}
{# Add jQuery CDN here if not already included in base.html #}
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
// Wait for both jQuery and DOM to be ready
$(document).ready(function() {
    console.log('Dashboard JavaScript loaded');

    // Update last updated time
    function updateLastUpdatedTime() {
        const now = new Date();
        const timeString = now.toLocaleTimeString();
        const element = document.getElementById('lastUpdated');
        if (element) {
            element.textContent = timeString;
        }
    }

    // Refresh dashboard function
    window.refreshDashboard = function() {
        location.reload();
    };

    // Initialize
    updateLastUpdatedTime();

    // Update time every minute
    setInterval(updateLastUpdatedTime, 60000);

    // Fix dropdown functionality for Bootstrap 4
    if (typeof $.fn.dropdown !== 'undefined') {
        $('.dropdown-toggle').dropdown();
    }

    // Log dashboard data for debugging
    console.log('Dashboard data:', {
        dailySales: '{{ daily_sales|default:"0" }}',
        weeklySales: '{{ weekly_sales|default:"0" }}',
        monthlySales: '{{ monthly_sales|default:"0" }}',
        paymentMethods: '{{ sales_by_payment_method|length|default:"0" }}'
    });
});
</script>
{% endblock %}

{% endblock %}