{% extends "base.html" %}

{% block content %}

<div class="page-hero">
    <div>
        <h2><i class="bi bi-calendar-day"></i> {{ t('daily_report') }}</h2>
        <p class="page-subtitle">{{ l("A summary of sales, profit and expenses for the selected day", 'নির্বাচিত দিনের বিক্রয়, লাভ ও খরচের সারসংক্ষেপ') }}</p>
    </div>
    <div class="page-hero-actions">
        <a href="/export/daily-report/csv?date={{ selected_date }}" class="btn btn-outline-success btn-sm"><i class="bi bi-filetype-csv"></i> CSV</a>
        <a href="/export/daily-report/excel?date={{ selected_date }}" class="btn btn-outline-success btn-sm"><i class="bi bi-file-earmark-excel"></i> Excel</a>
        <a href="/export/daily-report/pdf?date={{ selected_date }}" 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('daily_report') }}" class="d-flex align-items-end gap-2 flex-wrap">
        <div>
            <label class="form-label-sm">{{ l('Select Date', 'তারিখ নির্বাচন করুন') }}</label>
            <input type="date" name="date" class="form-control" value="{{ selected_date }}" max="{{ today }}">
        </div>
        <button class="btn btn-primary"><i class="bi bi-search"></i> {{ l('View', 'দেখুন') }}</button>
        {% if selected_date != today %}
        <a href="{{ url_for('daily_report') }}" class="btn btn-outline-secondary"><i class="bi bi-arrow-counterclockwise"></i> {{ l('Today', 'আজ') }}</a>
        {% endif %}
    </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(today_expense) }}</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(net_profit) }}</div>
    </div>
</div>

<!-- Cash Register Closing & Payment Settlement Panel -->
<div class="panel mb-3">
    <div class="panel-title text-primary"><i class="bi bi-safe2-fill me-2"></i> {{ l('Shift Cash Register Settlement', 'ক্যাশ রেজিস্টার সমাপনী হিসাব') }}</div>
    <div class="row g-3">
        <div class="col-md-3 col-6">
            <div class="p-3 border rounded bg-light">
                <small class="text-muted d-block fw-semibold">{{ l('Cash Collected', 'ক্যাশে আদায়') }}</small>
                <h5 class="mb-1 text-success fw-bold">৳ {{ "%.2f"|format(cash_sales|default(0)) }}</h5>
                {% if cash_expense|default(0) > 0 %}
                <small class="text-danger d-block" style="font-size:11px;">-৳{{ "%.2f"|format(cash_expense) }} {{ l('Expense', 'খরচ') }}</small>
                {% endif %}
            </div>
        </div>
        <div class="col-md-3 col-6">
            <div class="p-3 border rounded bg-light">
                <small class="text-muted d-block fw-semibold">{{ l('bKash Collected', 'বিকাশে আদায়') }}</small>
                <h5 class="mb-1 text-danger fw-bold">৳ {{ "%.2f"|format(bkash_sales|default(0)) }}</h5>
                {% if bkash_expense|default(0) > 0 %}
                <small class="text-danger d-block" style="font-size:11px;">-৳{{ "%.2f"|format(bkash_expense) }} {{ l('Expense', 'খরচ') }} (Net: ৳{{ "%.2f"|format(net_bkash_in_hand|default(0)) }})</small>
                {% endif %}
            </div>
        </div>
        <div class="col-md-2 col-6">
            <div class="p-3 border rounded bg-light">
                <small class="text-muted d-block fw-semibold">{{ l('Nagad Collected', 'নগদে আদায়') }}</small>
                <h5 class="mb-1 text-warning fw-bold">৳ {{ "%.2f"|format(nagad_sales|default(0)) }}</h5>
                {% if nagad_expense|default(0) > 0 %}
                <small class="text-danger d-block" style="font-size:11px;">-৳{{ "%.2f"|format(nagad_expense) }} {{ l('Expense', 'খরচ') }}</small>
                {% endif %}
            </div>
        </div>
        <div class="col-md-2 col-6">
            <div class="p-3 border rounded bg-light">
                <small class="text-muted d-block fw-semibold">{{ l('Card/Bank', 'কার্ড/ব্যাংক') }}</small>
                <h5 class="mb-1 text-primary fw-bold">৳ {{ "%.2f"|format(card_sales|default(0)) }}</h5>
                {% if card_expense|default(0) > 0 %}
                <small class="text-danger d-block" style="font-size:11px;">-৳{{ "%.2f"|format(card_expense) }} {{ l('Expense', 'খরচ') }}</small>
                {% endif %}
            </div>
        </div>
        <div class="col-md-2 col-12">
            <div class="p-3 border rounded bg-light">
                <small class="text-muted d-block fw-semibold">{{ l('Dues Given', 'বাকি বিক্রয়') }}</small>
                <h5 class="mb-0 text-secondary fw-bold">৳ {{ "%.2f"|format(due_sales|default(0)) }}</h5>
            </div>
        </div>
    </div>
    <div class="mt-3 p-3 rounded" style="background:#dcfce7; border:1px solid #86efac;">
        <div class="d-flex justify-content-between align-items-center">
            <span class="fw-bold text-success fs-6"><i class="bi bi-wallet-fill me-1"></i> {{ l('Net Cash in Hand', 'ক্যাশ বাক্সে মোট নগদ জমা') }}</span>
            <span class="fs-4 fw-bolder text-success">৳ {{ "%.2f"|format(net_cash_in_hand|default(0)) }}</span>
        </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">{{ selected_date }}</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>
        {% if sales %}
            {% 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 %}
            {% endfor %}
        {% else %}
        <tr><td colspan="6">
            <div class="empty-state"><i class="bi bi-inbox"></i>{{ l('No sales found for this date', 'এই তারিখে কোনো বিক্রয় পাওয়া যায়নি') }}</div>
        </td></tr>
        {% endif %}
        </tbody>
    </table>
    </div>
</div>

{% endblock %}