{% extends "base.html" %}

{% block content %}

<div class="page-hero">
    <div>
        <h2><i class="bi bi-calendar3"></i> {{ t('monthly_report') }}</h2>
        <p class="page-subtitle">{{ l("A summary of sales, profit and expenses for the selected month", 'নির্বাচিত মাসের বিক্রয়, লাভ ও খরচের সারসংক্ষেপ') }}</p>
    </div>
    <div class="page-hero-actions">
        <a href="/export/monthly-report/csv?month={{ '%04d-%02d'|format(selected_year, selected_month) }}" class="btn btn-outline-success btn-sm"><i class="bi bi-filetype-csv"></i> CSV</a>
        <a href="/export/monthly-report/excel?month={{ '%04d-%02d'|format(selected_year, selected_month) }}" class="btn btn-outline-success btn-sm"><i class="bi bi-file-earmark-excel"></i> Excel</a>
        <a href="/export/monthly-report/pdf?month={{ '%04d-%02d'|format(selected_year, selected_month) }}" class="btn btn-outline-success btn-sm"><i class="bi bi-file-earmark-pdf"></i> PDF</a>
    </div>
</div>

<div class="panel py-3">
    <form method="GET" action="{{ url_for('monthly_report') }}" class="d-flex align-items-end gap-2 flex-wrap">
        <div>
            <label class="form-label-sm">{{ l('Select Month', 'মাস নির্বাচন করুন') }}</label>
            <input type="month" name="month" class="form-control" value="{{ '%04d-%02d'|format(selected_year, selected_month) }}">
        </div>
        <button class="btn btn-primary"><i class="bi bi-search"></i> {{ l('View', 'দেখুন') }}</button>
        <a href="{{ url_for('monthly_report') }}" class="btn btn-outline-secondary"><i class="bi bi-arrow-counterclockwise"></i> {{ l('This Month', 'এই মাস') }}</a>
    </form>
</div>

<div class="stat-grid">
    <div class="stat-card">
        <div class="stat-icon" style="background:#dcfce7;color:#166534;"><i class="bi bi-cash-stack"></i></div>
        <div class="stat-label">{{ l('Sales', 'বিক্রয়') }}</div>
        <div class="stat-value">৳ {{ "%.2f"|format(total_sales_amount) }}</div>
    </div>
    <div class="stat-card">
        <div class="stat-icon" style="background:#d1fae5;color:#065f46;"><i class="bi bi-graph-up-arrow"></i></div>
        <div class="stat-label">{{ l('Gross Profit', 'মোট লাভ') }}</div>
        <div class="stat-value">৳ {{ "%.2f"|format(total_profit) }}</div>
    </div>
    <div class="stat-card">
        <div class="stat-icon" style="background:#fee2e2;color:#991b1b;"><i class="bi bi-wallet2"></i></div>
        <div class="stat-label">{{ l('Expense', 'খরচ') }}</div>
        <div class="stat-value">৳ {{ "%.2f"|format(monthly_expense_total) }}</div>
    </div>
    <div class="stat-card">
        <div class="stat-icon" style="background:#eef2ff;color:#4f46e5;"><i class="bi bi-gem"></i></div>
        <div class="stat-label">{{ l('Net Profit', 'নিট লাভ') }}</div>
        <div class="stat-value">৳ {{ "%.2f"|format(monthly_net_profit) }}</div>
    </div>
</div>

<div class="panel">
    <div class="panel-title">
        <i class="bi bi-receipt"></i> {{ l('Sales Details', 'বিক্রয় বিবরণ') }}
        <span class="badge bg-light text-dark border ms-1">{{ '%04d-%02d'|format(selected_year, selected_month) }}</span>
    </div>
    <div class="table-responsive">
    <table class="table table-modern align-middle">
        <thead>
        <tr>
            <th>{{ l('Invoice No', 'চালান নং') }}</th>
            <th>{{ l('Product', 'পণ্য') }}</th>
            <th>{{ l('Qty', 'পরিমাণ') }}</th>
            <th>{{ l('Price', 'মূল্য') }}</th>
            <th>{{ l('Total', 'মোট') }}</th>
            <th>{{ l('Date', 'তারিখ') }}</th>
        </tr>
        </thead>
        <tbody>
        {% for invoice in sales %}
            {% for item in invoice.items %}
            <tr>
                <td class="text-muted">{{ invoice.invoice_no }}</td>
                <td class="fw-semibold">
                    {% if item.product %}{{ item.product.name }}{% else %}{{ l('Deleted Product', 'মুছে ফেলা পণ্য') }}{% endif %}
                </td>
                <td>{{ "%.2f"|format(item.quantity) }}</td>
                <td>৳ {{ "%.2f"|format(item.price) }}</td>
                <td class="fw-semibold">৳ {{ "%.2f"|format(item.total) }}</td>
                <td>{{ invoice.created_at.strftime('%d-%m-%Y %H:%M') }}</td>
            </tr>
            {% endfor %}
        {% else %}
        <tr><td colspan="6">
            <div class="empty-state"><i class="bi bi-inbox"></i>{{ l('No sales found for this month', 'এই মাসে কোনো বিক্রয় পাওয়া যায়নি') }}</div>
        </td></tr>
        {% endfor %}
        </tbody>
    </table>
    </div>
</div>

{% endblock %}