{% extends 'auth/dashboard.html' %}
{% load static %}

{% block content %}
<div class="space-y-4 sm:space-y-6 px-2 sm:px-4 lg:px-8 max-w-7xl mx-auto overflow-x-hidden">
    <!-- Welcome Banner -->
    <div class="bg-gradient-to-r from-tea-green-500 to-tea-green-700 rounded-xl p-2 sm:p-4 md:p-6 text-white shadow-xl animate-fade-in-up">
        <div class="flex flex-col sm:flex-row items-center justify-between">
            <div class="mb-2 sm:mb-0">
                <h1 class="text-lg sm:text-xl md:text-2xl font-bold mb-1 sm:mb-2">
                    Welcome back, {{ request.user.get_full_name }}! 👋
                </h1>
                <p class="text-tea-green-100 text-xs sm:text-sm md:text-base">
                    {% if request.user.type == 'FARMER' %}
                        Here's your farming dashboard overview
                    {% elif request.user.is_superuser %}
                        Here's your complete system overview
                    {% else %}
                        Here's your dashboard overview
                    {% endif %}
                </p>
            </div>
            <div class="flex flex-wrap gap-2">
                {% if request.user.type == 'FARMER' %}
                     <a href="{% url 'contract_market_place:contract_create' %}" class="bg-white text-tea-green-600 px-2 py-1 sm:px-3 sm:py-2 rounded-lg hover:bg-tea-green-50 transition-all duration-300 font-semibold text-xs sm:text-sm shadow-md hover:shadow-lg transform hover:-translate-y-1">
                        <i class="fas fa-file-contract mr-1"></i>New Contract Request
                    </a>
                {% endif %}
                {% if request.user.is_superuser %}
                    <a href="{% url 'contract_market_place:contract_create' %}" class="bg-white text-tea-green-600 px-2 py-1 sm:px-3 sm:py-2 rounded-lg hover:bg-tea-green-50 transition-all duration-300 font-semibold text-xs sm:text-sm shadow-md hover:shadow-lg transform hover:-translate-y-1">
                        <i class="fas fa-file-contract mr-1"></i>New Contract
                    </a>
                {% endif %}
            </div>
        </div>
    </div>

    <!-- Group Quick Action Card (Farmers Only) -->
    {% if request.user.type == 'FARMER' %}
    <div class="bg-gradient-to-br from-blue-50 to-indigo-50 rounded-xl shadow-md p-4 sm:p-6 border-2 border-blue-200 animate-fade-in-up">
        <div class="flex items-start justify-between flex-wrap gap-4">
            <div class="flex items-center flex-1 min-w-0">
                <div class="w-12 h-12 sm:w-14 sm:h-14 bg-blue-600 rounded-full flex items-center justify-center mr-3 sm:mr-4 flex-shrink-0">
                    <i class="fas fa-users text-white text-xl sm:text-2xl"></i>
                </div>
                <div class="min-w-0">
                    <h3 class="text-lg sm:text-xl font-bold text-gray-800">Group Farming</h3>
                    {% if user_groups_count > 0 %}
                        <p class="text-sm sm:text-base text-gray-700 mt-1">
                            You are a member of <span class="font-bold text-blue-600">{{ user_groups_count }}</span> group{{ user_groups_count|pluralize }}
                            {% if is_group_signatory %}
                            <span class="ml-2 px-2 sm:px-3 py-1 bg-green-100 text-green-800 rounded-full text-xs sm:text-sm font-semibold inline-flex items-center">
                                <i class="fas fa-pen-fancy mr-1"></i>Signatory
                            </span>
                            {% endif %}
                        </p>
                        {% if pending_group_signatures > 0 %}
                        <p class="text-sm sm:text-base text-orange-600 font-medium mt-2 flex items-center">
                            <i class="fas fa-exclamation-circle mr-1"></i>
                            {{ pending_group_signatures }} contract{{ pending_group_signatures|pluralize }} awaiting your signature
                        </p>
                        {% endif %}
                    {% else %}
                        <p class="text-sm sm:text-base text-gray-600 mt-1">
                            You are not a member of any farmer group yet.
                        </p>
                        <p class="text-xs sm:text-sm text-gray-500 mt-1">
                            Contact your field officer or administrator to join a group.
                        </p>
                    {% endif %}
                </div>
            </div>
            
            <div class="flex flex-col gap-2">
                {% if user_groups_count > 0 %}
                    <a href="{% url 'contract_market_place:my_groups' %}" 
                       class="px-4 sm:px-6 py-2 bg-blue-600 text-white rounded-lg hover:bg-blue-700 transition flex items-center whitespace-nowrap text-sm sm:text-base shadow-md hover:shadow-lg transform hover:-translate-y-1">
                        <i class="fas fa-users mr-2"></i>
                        View My Groups
                    </a>
                    {% if is_group_signatory %}
                    <a href="{% url 'contract_market_place:group_contract_list' %}" 
                       class="px-4 sm:px-6 py-2 bg-indigo-600 text-white rounded-lg hover:bg-indigo-700 transition flex items-center whitespace-nowrap text-sm sm:text-base shadow-md hover:shadow-lg transform hover:-translate-y-1">
                        <i class="fas fa-file-contract mr-2"></i>
                        Group Contracts
                    </a>
                    {% endif %}
                {% else %}
                    <button disabled 
                            class="px-4 sm:px-6 py-2 bg-gray-400 text-white rounded-lg cursor-not-allowed flex items-center whitespace-nowrap text-sm sm:text-base"
                            title="You must be a group member to access this feature">
                        <i class="fas fa-lock mr-2"></i>
                        No Groups Yet
                    </button>
                {% endif %}
            </div>
        </div>
        
        <!-- Show group list if user has groups (max 3) -->
        {% if user_groups_count > 0 and user_groups_count <= 3 %}
        <div class="mt-4 pt-4 border-t border-blue-200">
            <p class="text-xs sm:text-sm font-semibold text-gray-700 mb-2">Your Groups:</p>
            <div class="grid grid-cols-1 md:grid-cols-{{ user_groups_count }} gap-2 sm:gap-3">
                {% for group in user_groups %}
                <a href="{% url 'contract_market_place:group_detail' group.id %}" 
                   class="p-2 sm:p-3 bg-white rounded-lg border border-blue-200 hover:border-blue-400 hover:shadow-md transition">
                    <p class="font-medium text-gray-800 truncate text-sm sm:text-base">{{ group.name }}</p>
                    <p class="text-xs sm:text-sm text-gray-600 mt-1 flex items-center">
                        <i class="fas fa-map-marker-alt text-blue-600 mr-1"></i>
                        {{ group.location }}
                    </p>
                </a>
                {% endfor %}
            </div>
        </div>
        {% endif %}
    </div>
    {% endif %}

    <!-- Key Metrics Cards -->
    <div class="grid grid-cols-1 sm:grid-cols-2 md:grid-cols-3 lg:grid-cols-4 gap-2 sm:gap-4">
        <!-- Total Contracts -->
        <div class="bg-white rounded-xl shadow-md p-2 sm:p-4 hover:shadow-lg transition-all duration-300 transform hover:-translate-y-1 animate-fade-in-up border-l-4 border-tea-green-500">
            <div class="flex items-center justify-between">
                <div>
                    <p class="text-gray-500 text-xs sm:text-sm font-medium mb-1">Total Contracts</p>
                    <h3 class="text-lg sm:text-xl md:text-2xl font-bold text-gray-800">{{ total_contracts|default:0 }}</h3>
                    {% if request.user.is_superuser %}
                        <p class="text-xs text-tea-green-600 mt-1">
                            <i class="fas fa-arrow-up mr-1"></i>System-wide
                        </p>
                    {% endif %}
                </div>
                <div class="bg-tea-green-100 rounded-full p-1 sm:p-2">
                    <i class="fas fa-file-contract text-tea-green-600 text-base sm:text-lg"></i>
                </div>
            </div>
        </div>

        <!-- Financial Metric -->
        {% if request.user.type == 'FARMER' %}
            <div class="bg-white rounded-xl shadow-md p-2 sm:p-4 hover:shadow-lg transition-all duration-300 transform hover:-translate-y-1 animate-fade-in-up border-l-4 border-blue-500">
                <div class="flex items-center justify-between">
                    <div>
                        <p class="text-gray-500 text-xs sm:text-sm font-medium mb-1">Total Paid</p>
                        <h3 class="text-lg sm:text-xl md:text-2xl font-bold text-gray-800">KES {{ total_paid|default:0|floatformat:0 }}</h3>
                        <p class="text-xs text-blue-600 mt-1">
                            <i class="fas fa-check-circle mr-1"></i>{{ payment_completion_rate|default:0 }}% Complete
                        </p>
                    </div>
                    <div class="bg-blue-100 rounded-full p-1 sm:p-2">
                        <i class="fas fa-money-bill-wave text-blue-600 text-base sm:text-lg"></i>
                    </div>
                </div>
            </div>

            <div class="bg-white rounded-xl shadow-md p-2 sm:p-4 hover:shadow-lg transition-all duration-300 transform hover:-translate-y-1 animate-fade-in-up border-l-4 border-yellow-500">
                <div class="flex items-center justify-between">
                    <div>
                        <p class="text-gray-500 text-xs sm:text-sm font-medium mb-1">Pending Payments</p>
                        <h3 class="text-lg sm:text-xl md:text-2xl font-bold text-gray-800">KES {{ total_pending|default:0|floatformat:0 }}</h3>
                        <p class="text-xs text-yellow-600 mt-1">
                            <i class="fas fa-clock mr-1"></i>Due Soon
                        </p>
                    </div>
                    <div class="bg-yellow-100 rounded-full p-1 sm:p-2">
                        <i class="fas fa-hourglass-half text-yellow-600 text-base sm:text-lg"></i>
                    </div>
                </div>
            </div>
        {% elif request.user.is_superuser %}
            <div class="bg-white rounded-xl shadow-md p-2 sm:p-4 hover:shadow-lg transition-all duration-300 transform hover:-translate-y-1 animate-fade-in-up border-l-4 border-blue-500">
                <div class="flex items-center justify-between">
                    <div>
                        <p class="text-gray-500 text-xs sm:text-sm font-medium mb-1">Total Revenue</p>
                        <h3 class="text-lg sm:text-xl md:text-2xl font-bold text-gray-800">KES {{ total_payments_completed|default:0|floatformat:0 }}</h3>
                        <p class="text-xs text-blue-600 mt-1">
                            <i class="fas fa-chart-line mr-1"></i>{{ collection_rate|default:0 }}% Collection
                        </p>
                    </div>
                    <div class="bg-blue-100 rounded-full p-1 sm:p-2">
                        <i class="fas fa-dollar-sign text-blue-600 text-base sm:text-lg"></i>
                    </div>
                </div>
            </div>

            <div class="bg-white rounded-xl shadow-md p-2 sm:p-4 hover:shadow-lg transition-all duration-300 transform hover:-translate-y-1 animate-fade-in-up border-l-4 border-purple-500">
                <div class="flex items-center justify-between">
                    <div>
                        <p class="text-gray-500 text-xs sm:text-sm font-medium mb-1">Active Farmers</p>
                        <h3 class="text-lg sm:text-xl md:text-2xl font-bold text-gray-800">{{ total_farmers|default:0 }}</h3>
                        <p class="text-xs text-purple-600 mt-1">
                            <i class="fas fa-users mr-1"></i>Registered
                        </p>
                    </div>
                    <div class="bg-purple-100 rounded-full p-1 sm:p-2">
                        <i class="fas fa-tractor text-purple-600 text-base sm:text-lg"></i>
                    </div>
                </div>
            </div>
        {% endif %}

        <!-- Alerts/Notifications -->
        <div class="bg-white rounded-xl shadow-md p-2 sm:p-4 hover:shadow-lg transition-all duration-300 transform hover:-translate-y-1 animate-fade-in-up border-l-4 border-red-500">
            <div class="flex items-center justify-between">
                <div>
                    <p class="text-gray-500 text-xs sm:text-sm font-medium mb-1">Overdue Payments</p>
                    <h3 class="text-lg sm:text-xl md:text-2xl font-bold text-gray-800">{{ overdue_count|default:0 }}</h3>
                    <p class="text-xs text-red-600 mt-1">
                        <i class="fas fa-exclamation-triangle mr-1"></i>Needs Attention
                    </p>
                </div>
                <div class="bg-red-100 rounded-full p-1 sm:p-2">
                    <i class="fas fa-bell text-red-600 text-base sm:text-lg"></i>
                </div>
            </div>
        </div>
    </div>

    <!-- Charts Row -->
    <div class="grid grid-cols-1 lg:grid-cols-2 gap-2 sm:gap-4">
        <!-- Contract Status Chart -->
        {% if contract_status_labels %}
        <div class="bg-white rounded-xl shadow-md p-2 sm:p-4 animate-fade-in-up">
            <h3 class="text-base sm:text-lg font-semibold text-gray-800 mb-2 sm:mb-3 flex items-center">
                <i class="fas fa-chart-pie text-tea-green-600 mr-2"></i>
                Contract Status Distribution
            </h3>
            <div class="relative w-full h-48 sm:h-64 md:h-80">
                <canvas id="contractStatusChart" class="w-full h-full"></canvas>
            </div>
        </div>
        {% endif %}

        <!-- Monthly Trend Chart -->
        {% if request.user.is_superuser and monthly_contract_labels or request.user.type == 'FARMER' and monthly_payment_labels %}
        <div class="bg-white rounded-xl shadow-md p-2 sm:p-4 animate-fade-in-up">
            <h3 class="text-base sm:text-lg font-semibold text-gray-800 mb-2 sm:mb-3 flex items-center">
                <i class="fas fa-chart-line text-tea-green-600 mr-2"></i>
                {% if request.user.type == 'FARMER' %}Payment History{% else %}Monthly Contracts{% endif %}
            </h3>
            <div class="relative w-full h-48 sm:h-64 md:h-80">
                <canvas id="monthlyTrendChart" class="w-full h-full"></canvas>
            </div>
        </div>
        {% endif %}
    </div>

    <!-- Additional Charts for Admin -->
    {% if request.user.is_superuser %}
    <div class="grid grid-cols-1 lg:grid-cols-2 gap-2 sm:gap-4">
        <!-- Payment Status -->
        {% if payment_status_labels %}
        <div class="bg-white rounded-xl shadow-md p-2 sm:p-4 animate-fade-in-up">
            <h3 class="text-base sm:text-lg font-semibold text-gray-800 mb-2 sm:mb-3 flex items-center">
                <i class="fas fa-money-check text-tea-green-600 mr-2"></i>
                Payment Status Overview
            </h3>
            <div class="relative w-full h-48 sm:h-64 md:h-80">
                <canvas id="paymentStatusChart" class="w-full h-full"></canvas>
            </div>
        </div>
        {% endif %}

        <!-- Top Inputs -->
        {% if top_input_labels %}
        <div class="bg-white rounded-xl shadow-md p-2 sm:p-4 animate-fade-in-up">
            <h3 class="text-base sm:text-lg font-semibold text-gray-800 mb-2 sm:mb-3 flex items-center">
                <i class="fas fa-box text-tea-green-600 mr-2"></i>
                Top Inputs by Demand
            </h3>
            <div class="relative w-full h-48 sm:h-64 md:h-80">
                <canvas id="topInputsChart" class="w-full h-full"></canvas>
            </div>
        </div>
        {% endif %}
    </div>
    {% endif %}

    <!-- Quick Actions & Recent Activity -->
    <div class="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-3 gap-2 sm:gap-4">
        <!-- Quick Actions -->
        <div class="bg-white rounded-xl shadow-md p-2 sm:p-4 animate-fade-in-up">
            <h3 class="text-base sm:text-lg font-semibold text-gray-800 mb-2 sm:mb-3 flex items-center">
                <i class="fas fa-bolt text-tea-green-600 mr-2"></i>
                Quick Actions
            </h3>
            <div class="space-y-1 sm:space-y-2">
                {% if request.user.type == 'FARMER' %}
                    <a href="{% url 'contract_market_place:contract_list' %}" class="block p-1 sm:p-2 bg-tea-green-50 hover:bg-tea-green-100 rounded-lg transition-colors duration-200 text-xs sm:text-sm w-full">
                        <i class="fas fa-file-contract text-tea-green-600 mr-2"></i>
                        <span class="text-gray-700 font-medium">View My Contracts</span>
                    </a>
                    <a href="{% url 'payments:farmer_payment_list' %}" class="block p-1 sm:p-2 bg-blue-50 hover:bg-blue-100 rounded-lg transition-colors duration-200 text-xs sm:text-sm w-full">
                        <i class="fas fa-money-bill text-blue-600 mr-2"></i>
                        <span class="text-gray-700 font-medium">Payment History</span>
                    </a>
                    <a href="{% url 'contract_market_place:input_list' %}" class="block p-1 sm:p-2 bg-purple-50 hover:bg-purple-100 rounded-lg transition-colors duration-200 text-xs sm:text-sm w-full">
                        <i class="fas fa-box text-purple-600 mr-2"></i>
                        <span class="text-gray-700 font-medium">Browse Inputs</span>
                    </a>
                {% elif request.user.is_superuser %}
                    <a href="{% url 'contract_market_place:contract_create' %}" class="block p-1 sm:p-2 bg-tea-green-50 hover:bg-tea-green-100 rounded-lg transition-colors duration-200 text-xs sm:text-sm w-full">
                        <i class="fas fa-plus text-tea-green-600 mr-2"></i>
                        <span class="text-gray-700 font-medium">Create Contract</span>
                    </a>
                    <a href="{% url 'contract_market_place:user_list' %}" class="block p-1 sm:p-2 bg-blue-50 hover:bg-blue-100 rounded-lg transition-colors duration-200 text-xs sm:text-sm w-full">
                        <i class="fas fa-users text-blue-600 mr-2"></i>
                        <span class="text-gray-700 font-medium">Manage Users</span>
                    </a>
                    <a href="{% url 'contract_market_place:input_list' %}" class="block p-1 sm:p-2 bg-purple-50 hover:bg-purple-100 rounded-lg transition-colors duration-200 text-xs sm:text-sm w-full">
                        <i class="fas fa-box text-purple-600 mr-2"></i>
                        <span class="text-gray-700 font-medium">Manage Inputs</span>
                    </a>
                    <a href="{% url 'contract_market_place:interest_rate_list' %}" class="block p-1 sm:p-2 bg-yellow-50 hover:bg-yellow-100 rounded-lg transition-colors duration-200 text-xs sm:text-sm w-full">
                        <i class="fas fa-percentage text-yellow-600 mr-2"></i>
                        <span class="text-gray-700 font-medium">Rates and Market Fees</span>
                    </a>
                {% elif contract_can_manage_market_commission %}
                    <a href="{% url 'contract_market_place:interest_rate_list' %}" class="block p-1 sm:p-2 bg-yellow-50 hover:bg-yellow-100 rounded-lg transition-colors duration-200 text-xs sm:text-sm w-full">
                        <i class="fas fa-percentage text-yellow-600 mr-2"></i>
                        <span class="text-gray-700 font-medium">Market Fees</span>
                    </a>
                {% endif %}
            </div>
        </div>

        <!-- Upcoming/Overdue Payments -->
        <div class="lg:col-span-2 bg-white rounded-xl shadow-md p-2 sm:p-4 animate-fade-in-up">
            <h3 class="text-base sm:text-lg font-semibold text-gray-800 mb-2 sm:mb-3 flex items-center">
                <i class="fas fa-calendar-alt text-tea-green-600 mr-2"></i>
                {% if request.user.type == 'FARMER' %}
                    {% if upcoming_payments %}Upcoming Payments{% else %}Payment Schedule{% endif %}
                {% else %}
                    Overdue Payments Alert
                {% endif %}
            </h3>
            <div class="overflow-x-auto w-full">
                <table class="min-w-full text-xs sm:text-sm">
                    <thead class="bg-tea-green-50">
                        <tr>
                            <th class="px-1 sm:px-2 py-1 sm:py-2 text-left font-medium text-gray-600">Contract</th>
                            <th class="px-1 sm:px-2 py-1 sm:py-2 text-left font-medium text-gray-600">Amount</th>
                            <th class="px-1 sm:px-2 py-1 sm:py-2 text-left font-medium text-gray-600">Due Date</th>
                            <th class="px-1 sm:px-2 py-1 sm:py-2 text-left font-medium text-gray-600">Status</th>
                            {% if request.user.type == 'FARMER' %}
                            <th class="px-1 sm:px-2 py-1 sm:py-2 text-left font-medium text-gray-600">Action</th>
                            {% endif %}
                        </tr>
                    </thead>
                    <tbody class="divide-y divide-gray-200">
                        {% if request.user.type == 'FARMER' %}
                            {% for payment in upcoming_payments %}
                            <tr class="hover:bg-tea-green-50 transition-colors">
                                <td class="px-1 sm:px-2 py-1 sm:py-2 text-gray-700">#{{ payment.contract.id }}</td>
                                <td class="px-1 sm:px-2 py-1 sm:py-2 font-semibold text-gray-800">KES {{ payment.balance|floatformat:0 }}</td>
                                <td class="px-1 sm:px-2 py-1 sm:py-2 text-gray-700">{{ payment.due_date|date:"M d, Y" }}</td>
                                <td class="px-1 sm:px-2 py-1 sm:py-2">
                                    <span class="px-1 sm:px-2 py-0.5 sm:py-1 font-semibold rounded-full {% if payment.status == 'OVERDUE' %}bg-red-100 text-red-800{% elif payment.status == 'PARTIAL' %}bg-yellow-100 text-yellow-800{% else %}bg-blue-100 text-blue-800{% endif %}">
                                        {{ payment.get_status_display }}
                                    </span>
                                </td>
                                <td class="px-1 sm:px-2 py-1 sm:py-2">
                                    <a href="{% url 'payments:payment_schedule_pay' payment.id %}" class="text-tea-green-600 hover:text-tea-green-800 font-medium">
                                        <i class="fas fa-credit-card mr-1"></i>Pay Now
                                    </a>
                                </td>
                            </tr>
                            {% empty %}
                            <tr>
                                <td colspan="5" class="px-1 sm:px-2 py-4 sm:py-6 text-center text-gray-500">
                                    <i class="fas fa-check-circle text-tea-green-500 text-base sm:text-xl mb-1"></i>
                                    <p>No upcoming payments</p>
                                </td>
                            </tr>
                            {% endfor %}
                        {% else %}
                            {% for payment in overdue_payments %}
                            <tr class="hover:bg-red-50 transition-colors">
                                <td class="px-1 sm:px-2 py-1 sm:py-2 text-gray-700">
                                    #{{ payment.contract.id }}
                                    <br><span class="text-xs text-gray-500">{{ payment.contract.farmer.get_full_name }}</span>
                                </td>
                                <td class="px-1 sm:px-2 py-1 sm:py-2 font-semibold text-gray-800">KES {{ payment.balance|floatformat:0 }}</td>
                                <td class="px-1 sm:px-2 py-1 sm:py-2 text-red-600">{{ payment.due_date|date:"M d, Y" }}</td>
                                <td class="px-1 sm:px-2 py-1 sm:py-2">
                                    <span class="px-1 sm:px-2 py-0.5 sm:py-1 font-semibold rounded-full bg-red-100 text-red-800">
                                        OVERDUE
                                    </span>
                                </td>
                            </tr>
                            {% empty %}
                            <tr>
                                <td colspan="4" class="px-1 sm:px-2 py-4 sm:py-6 text-center text-gray-500">
                                    <i class="fas fa-check-circle text-tea-green-500 text-base sm:text-xl mb-1"></i>
                                    <p>No overdue payments</p>
                                </td>
                            </tr>
                            {% endfor %}
                        {% endif %}
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <!-- Recent Contracts -->
    <div class="bg-white rounded-xl shadow-md p-2 sm:p-4 animate-fade-in-up">
        <div class="flex items-center justify-between mb-2 sm:mb-3">
            <h3 class="text-base sm:text-lg font-semibold text-gray-800 flex items-center">
                <i class="fas fa-history text-tea-green-600 mr-2"></i>
                Recent Contracts
            </h3>
            <a href="{% url 'contract_market_place:contract_list' %}" class="text-tea-green-600 hover:text-tea-green-800 text-xs sm:text-sm font-medium">
                View All <i class="fas fa-arrow-right ml-1"></i>
            </a>
        </div>
        <div class="overflow-x-auto w-full">
            <table class="min-w-full text-xs sm:text-sm">
                <thead class="bg-tea-green-50">
                    <tr>
                        <th class="px-1 sm:px-2 py-1 sm:py-2 text-left font-medium text-gray-600">ID</th>
                        {% if request.user.is_superuser %}
                        <th class="px-1 sm:px-2 py-1 sm:py-2 text-left font-medium text-gray-600">Farmer</th>
                        {% endif %}
                        <th class="px-1 sm:px-2 py-1 sm:py-2 text-left font-medium text-gray-600">Type</th>
                        <th class="px-1 sm:px-2 py-1 sm:py-2 text-left font-medium text-gray-600">Amount</th>
                        <th class="px-1 sm:px-2 py-1 sm:py-2 text-left font-medium text-gray-600">Status</th>
                        <th class="px-1 sm:px-2 py-1 sm:py-2 text-left font-medium text-gray-600">Created</th>
                        <th class="px-1 sm:px-2 py-1 sm:py-2 text-left font-medium text-gray-600">Actions</th>
                    </tr>
                </thead>
                <tbody class="divide-y divide-gray-200">
                    {% for contract in recent_contracts %}
                    <tr class="hover:bg-tea-green-50 transition-colors">
                        <td class="px-1 sm:px-2 py-1 sm:py-2 font-medium text-gray-800">#{{ contract.id }}</td>
                        {% if request.user.is_superuser %}
                        <td class="px-1 sm:px-2 py-1 sm:py-2 text-gray-700">{{ contract.farmer.get_full_name }}</td>
                        {% endif %}
                        <td class="px-1 sm:px-2 py-1 sm:py-2 text-gray-700">{{ contract.get_type_display }}</td>
                        <td class="px-1 sm:px-2 py-1 sm:py-2 font-semibold text-gray-800">KES {{ contract.total_amount|floatformat:0 }}</td>
                        <td class="px-1 sm:px-2 py-1 sm:py-2">
                            <span class="px-1 sm:px-2 py-0.5 sm:py-1 font-semibold rounded-full 
                                {% if contract.status == 'ACTIVE' %}bg-green-100 text-green-800
                                {% elif contract.status == 'COMPLETED' %}bg-blue-100 text-blue-800
                                {% elif contract.status == 'SIGNED' or contract.status == 'DEPOSIT_PAID' %}bg-yellow-100 text-yellow-800
                                {% elif contract.status == 'PENDING_SIGN' %}bg-orange-100 text-orange-800
                                {% else %}bg-gray-100 text-gray-800{% endif %}">
                                {{ contract.get_status_display }}
                            </span>
                        </td>
                        <td class="px-1 sm:px-2 py-1 sm:py-2 text-gray-700">{{ contract.created_at|date:"M d, Y" }}</td>
                        <td class="px-1 sm:px-2 py-1 sm:py-2">
                            <a href="{% url 'contract_market_place:contract_detail' contract.id %}" class="text-tea-green-600 hover:text-tea-green-800 font-medium">
                                <i class="fas fa-eye mr-1"></i>View
                            </a>
                        </td>
                    </tr>
                    {% empty %}
                    <tr>
                        <td colspan="{% if request.user.is_superuser %}7{% else %}6{% endif %}" class="px-1 sm:px-2 py-4 sm:py-6 text-center text-gray-500">
                            No contracts found
                        </td>
                    </tr>
                    {% endfor %}
                </tbody>
            </table>
        </div>
    </div>

    <!-- Recent Payments (Admin Only) -->
    {% if request.user.is_superuser and recent_payments %}
    <div class="bg-white rounded-xl shadow-md p-2 sm:p-4 animate-fade-in-up">
        <div class="flex items-center justify-between mb-2 sm:mb-3">
            <h3 class="text-base sm:text-lg font-semibold text-gray-800 flex items-center">
                <i class="fas fa-receipt text-tea-green-600 mr-2"></i>
                Recent Payments
            </h3>
            <a href="{% url 'payments:farmer_payment_list' %}" class="text-tea-green-600 hover:text-tea-green-800 text-xs sm:text-sm font-medium">
                View All <i class="fas fa-arrow-right ml-1"></i>
            </a>
        </div>
        <div class="overflow-x-auto w-full">
            <table class="min-w-full text-xs sm:text-sm">
                <thead class="bg-tea-green-50">
                    <tr>
                        <th class="px-1 sm:px-2 py-1 sm:py-2 text-left font-medium text-gray-600">Receipt #</th>
                        <th class="px-1 sm:px-2 py-1 sm:py-2 text-left font-medium text-gray-600">Farmer</th>
                        <th class="px-1 sm:px-2 py-1 sm:py-2 text-left font-medium text-gray-600">Contract</th>
                        <th class="px-1 sm:px-2 py-1 sm:py-2 text-left font-medium text-gray-600">Type</th>
                        <th class="px-1 sm:px-2 py-1 sm:py-2 text-left font-medium text-gray-600">Amount</th>
                        <th class="px-1 sm:px-2 py-1 sm:py-2 text-left font-medium text-gray-600">Date</th>
                    </tr>
                </thead>
                <tbody class="divide-y divide-gray-200">
                    {% for payment in recent_payments %}
                    <tr class="hover:bg-tea-green-50 transition-colors">
                        <td class="px-1 sm:px-2 py-1 sm:py-2 font-medium text-gray-800">{{ payment.mpesa_receipt_number|default:"N/A" }}</td>
                        <td class="px-1 sm:px-2 py-1 sm:py-2 text-gray-700">{{ payment.farmer.get_full_name }}</td>
                        <td class="px-1 sm:px-2 py-1 sm:py-2 text-gray-700">#{{ payment.contract.id }}</td>
                        <td class="px-1 sm:px-2 py-1 sm:py-2 text-gray-700">{{ payment.get_payment_type_display }}</td>
                        <td class="px-1 sm:px-2 py-1 sm:py-2 font-semibold text-green-600">KES {{ payment.amount|floatformat:0 }}</td>
                        <td class="px-1 sm:px-2 py-1 sm:py-2 text-gray-700">{{ payment.created_at|date:"M d, Y H:i" }}</td>
                    </tr>
                    {% endfor %}
                </tbody>
            </table>
        </div>
    </div>
    {% endif %}

    <!-- Low Stock Alerts (Admin Only) -->
    {% if request.user.is_superuser and low_stock_packages %}
    <div class="bg-white rounded-xl shadow-md p-2 sm:p-4 animate-fade-in-up border-l-4 border-yellow-500">
        <h3 class="text-base sm:text-lg font-semibold text-gray-800 mb-2 sm:mb-3 flex items-center">
            <i class="fas fa-exclamation-triangle text-yellow-600 mr-2"></i>
            Low Stock Alerts
        </h3>
        <div class="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-3 gap-2 sm:gap-4">
            {% for package in low_stock_packages %}
            <div class="bg-yellow-50 rounded-lg p-1 sm:p-2 border border-yellow-200">
                <div class="flex items-center justify-between mb-1 sm:mb-2">
                    <h4 class="font-semibold text-gray-800 text-xs sm:text-sm truncate">{{ package.variety.name }}</h4>
                    <span class="px-1 sm:px-2 py-0.5 sm:py-1 bg-yellow-200 text-yellow-800 text-xs font-bold rounded-full">
                        {{ package.stock }} left
                    </span>
                </div>
                <p class="text-xs text-gray-600 truncate">{{ package.input.name }} - {{ package.unit_quantity }} {{ package.unit_type }}</p>
                <a href="{% url 'contract_market_place:input_package_update_single' package.input.id package.id %}" class="text-tea-green-600 hover:text-tea-green-800 text-xs font-medium mt-1 sm:mt-2 inline-block">
                    <i class="fas fa-edit mr-1"></i>Update Stock
                </a>
            </div>
            {% endfor %}
        </div>
    </div>
    {% endif %}
</div>

<!-- Chart.js Script -->
<script src="https://cdn.jsdelivr.net/npm/chart.js@3.9.1/dist/chart.min.js"></script>
<script>
document.addEventListener('DOMContentLoaded', function() {
    // Common chart options
    const commonOptions = {
        responsive: true,
        maintainAspectRatio: false,
        plugins: {
            legend: {
                position: 'bottom',
                labels: {
                    padding: 10,
                    font: {
                        size: 11
                    }
                }
            }
        }
    };

    const colors = {
        primary: ['#22c55e', '#16a34a', '#15803d', '#166534', '#14532d'],
        status: ['#3b82f6', '#22c55e', '#eab308', '#ef4444', '#8b5cf6'],
        gradient: ['#22c55e', '#16a34a', '#15803d', '#166534', '#14532d', '#86efac']
    };

    // Contract Status Chart
    {% if contract_status_labels %}
    const contractStatusCtx = document.getElementById('contractStatusChart');
    if (contractStatusCtx) {
        new Chart(contractStatusCtx, {
            type: 'doughnut',
            data: {
                labels: {{ contract_status_labels|safe }},
                datasets: [{
                    data: {{ contract_status_counts|safe }},
                    backgroundColor: colors.status,
                    borderWidth: 1,
                    borderColor: '#ffffff'
                }]
            },
            options: {
                ...commonOptions,
                cutout: '65%',
                plugins: {
                    ...commonOptions.plugins,
                    tooltip: {
                        callbacks: {
                            label: function(context) {
                                return context.label + ': ' + context.parsed + ' contracts';
                            }
                        }
                    }
                }
            }
        });
    }
    {% endif %}

    // Monthly Trend Chart
    {% if request.user.is_superuser and monthly_contract_labels %}
    const monthlyTrendCtx = document.getElementById('monthlyTrendChart');
    if (monthlyTrendCtx) {
        new Chart(monthlyTrendCtx, {
            type: 'line',
            data: {
                labels: {{ monthly_contract_labels|safe }},
                datasets: [{
                    label: 'Contracts',
                    data: {{ monthly_contract_counts|safe }},
                    borderColor: '#22c55e',
                    backgroundColor: 'rgba(34, 197, 94, 0.1)',
                    borderWidth: 2,
                    fill: true,
                    tension: 0.4,
                    pointRadius: 4,
                    pointBackgroundColor: '#22c55e',
                    pointBorderColor: '#ffffff',
                    pointBorderWidth: 1
                }]
            },
            options: {
                ...commonOptions,
                scales: {
                    y: {
                        beginAtZero: true,
                        grid: {
                            color: 'rgba(0, 0, 0, 0.05)'
                        },
                        ticks: {
                            font: {
                                size: 10
                            }
                        }
                    },
                    x: {
                        grid: {
                            display: false
                        },
                        ticks: {
                            font: {
                                size: 10
                            }
                        }
                    }
                }
            }
        });
    }
    {% elif request.user.type == 'FARMER' and monthly_payment_labels %}
    const monthlyTrendCtx = document.getElementById('monthlyTrendChart');
    if (monthlyTrendCtx) {
        new Chart(monthlyTrendCtx, {
            type: 'line',
            data: {
                labels: {{ monthly_payment_labels|safe }},
                datasets: [{
                    label: 'Payments (KES)',
                    data: {{ monthly_payment_amounts|safe }},
                    borderColor: '#22c55e',
                    backgroundColor: 'rgba(34, 197, 94, 0.1)',
                    borderWidth: 2,
                    fill: true,
                    tension: 0.4,
                    pointRadius: 4,
                    pointBackgroundColor: '#22c55e',
                    pointBorderColor: '#ffffff',
                    pointBorderWidth: 1
                }]
            },
            options: {
                ...commonOptions,
                scales: {
                    y: {
                        beginAtZero: true,
                        grid: {
                            color: 'rgba(0, 0, 0, 0.05)'
                        },
                        ticks: {
                            font: {
                                size: 10
                            }
                        }
                    },
                    x: {
                        grid: {
                            display: false
                        },
                        ticks: {
                            font: {
                                size: 10
                            }
                        }
                    }
                }
            }
        });
    }
    {% endif %}

    // Payment Status Chart (Admin)
    {% if request.user.is_superuser and payment_status_labels %}
    const paymentStatusCtx = document.getElementById('paymentStatusChart');
    if (paymentStatusCtx) {
        new Chart(paymentStatusCtx, {
            type: 'bar',
            data: {
                labels: {{ payment_status_labels|safe }},
                datasets: [{
                    label: 'Payment Count',
                    data: {{ payment_status_counts|safe }},
                    backgroundColor: colors.status,
                    borderWidth: 0,
                    borderRadius: 6
                }]
            },
            options: {
                ...commonOptions,
                scales: {
                    y: {
                        beginAtZero: true,
                        grid: {
                            color: 'rgba(0, 0, 0, 0.05)'
                        },
                        ticks: {
                            font: {
                                size: 10
                            }
                        }
                    },
                    x: {
                        grid: {
                            display: false
                        },
                        ticks: {
                            font: {
                                size: 10
                            }
                        }
                    }
                }
            }
        });
    }
    {% endif %}

    // Top Inputs Chart (Admin)
    {% if request.user.is_superuser and top_input_labels %}
    const topInputsCtx = document.getElementById('topInputsChart');
    if (topInputsCtx) {
        new Chart(topInputsCtx, {
            type: 'bar',
            data: {
                labels: {{ top_input_labels|safe }},
                datasets: [{
                    label: 'Contracts',
                    data: {{ top_input_counts|default:0|safe }},
                    backgroundColor: colors.gradient,
                    borderWidth: 0,
                    borderRadius: 6
                }]
            },
            options: {
                ...commonOptions,
                indexAxis: 'y',
                scales: {
                    x: {
                        beginAtZero: true,
                        grid: {
                            color: 'rgba(0, 0, 0, 0.05)'
                        },
                        ticks: {
                            font: {
                                size: 10
                            }
                        }
                    },
                    y: {
                        grid: {
                            display: false
                        },
                        ticks: {
                            font: {
                                size: 10
                            }
                        }
                    }
                }
            }
        });
    }
    {% endif %}
});
</script>

<style>
@keyframes fadeInUp {
    from {
        opacity: 0;
        transform: translateY(20px);
    }
    to {
        opacity: 1;
        transform: translateY(0);
    }
}

.animate-fade-in-up {
    animation: fadeInUp 0.6s ease-out forwards;
}

.animate-fade-in-up:nth-child(1) { animation-delay: 0.1s; }
.animate-fade-in-up:nth-child(2) { animation-delay: 0.2s; }
.animate-fade-in-up:nth-child(3) { animation-delay: 0.3s; }
.animate-fade-in-up:nth-child(4) { animation-delay: 0.4s; }
</style>
{% endblock %}