{% extends "inventory/base.html" %}
{% load crispy_forms_tags %}

{% block title %}利润报表{% endblock %}

{% block extra_head %}
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
{% endblock %}

{% block content %}
<div class="container">
    <div class="row mb-4">
        <div class="col-md-8">
            <h1 class="h2">利润报表</h1>
            <p class="text-muted">
                日期范围: {{ start_date|date:"Y-m-d" }} 至 {{ end_date|date:"Y-m-d" }}
                ({{ period|default:"按日" }})
            </p>
        </div>
        <div class="col-md-4 text-md-end">
            <a href="{% url 'reports_index' %}" class="btn btn-outline-secondary">
                <i class="bi bi-arrow-left"></i> 返回报表中心
            </a>
        </div>
    </div>

    <!-- 搜索表单 -->
    <div class="row mb-4">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header">
                    <h3 class="h5 mb-0">设置报表参数</h3>
                </div>
                <div class="card-body">
                    <form method="post">
                        {% csrf_token %}
                        <div class="row">
                            <div class="col-md-4">
                                {{ form.start_date|as_crispy_field }}
                            </div>
                            <div class="col-md-4">
                                {{ form.end_date|as_crispy_field }}
                            </div>
                            <div class="col-md-2">
                                {{ form.period|as_crispy_field }}
                            </div>
                            <div class="col-md-2 d-flex align-items-end">
                                <button type="submit" class="btn btn-primary w-100">查询</button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    <!-- 统计卡片 -->
    <div class="row mb-4">
        <div class="col-md-3">
            <div class="card text-white bg-primary">
                <div class="card-body">
                    <h5 class="card-title">总销售额</h5>
                    <h3 class="mb-0">¥{{ summary.total_sales|floatformat:2 }}</h3>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card text-white bg-info">
                <div class="card-body">
                    <h5 class="card-title">总成本</h5>
                    <h3 class="mb-0">¥{{ summary.total_cost|floatformat:2 }}</h3>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card text-white bg-success">
                <div class="card-body">
                    <h5 class="card-title">总利润</h5>
                    <h3 class="mb-0">¥{{ summary.total_profit|floatformat:2 }}</h3>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card text-white bg-warning">
                <div class="card-body">
                    <h5 class="card-title">平均毛利率</h5>
                    <h3 class="mb-0">{{ summary.avg_profit_margin|floatformat:2 }}%</h3>
                </div>
            </div>
        </div>
    </div>

    <!-- 图表 -->
    <div class="row mb-4">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header">
                    <h3 class="h5 mb-0">利润趋势图表</h3>
                </div>
                <div class="card-body">
                    <canvas id="profitChart" height="300"></canvas>
                </div>
            </div>
        </div>
    </div>

    <!-- 数据表格 -->
    <div class="row">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header">
                    <h3 class="h5 mb-0">利润数据明细</h3>
                </div>
                <div class="card-body p-0">
                    <div class="table-responsive">
                        <table class="table table-hover mb-0">
                            <thead class="table-light">
                                <tr>
                                    <th>日期</th>
                                    <th class="text-end">销售额</th>
                                    <th class="text-end">成本</th>
                                    <th class="text-end">利润</th>
                                    <th class="text-end">毛利率</th>
                                    <th class="text-end">订单数</th>
                                </tr>
                            </thead>
                            <tbody>
                                {% for data in profit_data %}
                                <tr>
                                    <td>{{ data.period|date:"Y-m-d" }}</td>
                                    <td class="text-end">¥{{ data.sales|floatformat:2 }}</td>
                                    <td class="text-end">¥{{ data.cost|floatformat:2 }}</td>
                                    <td class="text-end">¥{{ data.profit|floatformat:2 }}</td>
                                    <td class="text-end">
                                        <span class="{% if data.profit_margin < 15 %}text-danger{% elif data.profit_margin < 25 %}text-warning{% else %}text-success{% endif %}">
                                            {{ data.profit_margin|floatformat:2 }}%
                                        </span>
                                    </td>
                                    <td class="text-end">{{ data.order_count }}</td>
                                </tr>
                                {% empty %}
                                <tr>
                                    <td colspan="6" class="text-center py-4">没有销售数据</td>
                                </tr>
                                {% endfor %}
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

{% if profit_data %}
<script>
    document.addEventListener('DOMContentLoaded', function() {
        const ctx = document.getElementById('profitChart').getContext('2d');
        
        // 准备数据
        const labels = [
            {% for data in profit_data %}
                '{{ data.period|date:"Y-m-d" }}',
            {% endfor %}
        ];
        
        const salesData = [
            {% for data in profit_data %}
                {{ data.sales|default:0 }},
            {% endfor %}
        ];
        
        const costData = [
            {% for data in profit_data %}
                {{ data.cost|default:0 }},
            {% endfor %}
        ];
        
        const profitData = [
            {% for data in profit_data %}
                {{ data.profit|default:0 }},
            {% endfor %}
        ];
        
        const profitMarginData = [
            {% for data in profit_data %}
                {{ data.profit_margin|default:0 }},
            {% endfor %}
        ];
        
        // 创建图表
        const myChart = new Chart(ctx, {
            type: 'bar',
            data: {
                labels: labels,
                datasets: [
                    {
                        label: '销售额',
                        data: salesData,
                        backgroundColor: 'rgba(54, 162, 235, 0.5)',
                        borderColor: 'rgba(54, 162, 235, 1)',
                        borderWidth: 1,
                        yAxisID: 'y',
                        order: 3
                    },
                    {
                        label: '成本',
                        data: costData,
                        backgroundColor: 'rgba(153, 102, 255, 0.5)',
                        borderColor: 'rgba(153, 102, 255, 1)',
                        borderWidth: 1,
                        yAxisID: 'y',
                        order: 2
                    },
                    {
                        label: '利润',
                        data: profitData,
                        backgroundColor: 'rgba(75, 192, 192, 0.5)',
                        borderColor: 'rgba(75, 192, 192, 1)',
                        borderWidth: 1,
                        yAxisID: 'y',
                        order: 1
                    },
                    {
                        label: '毛利率',
                        data: profitMarginData,
                        type: 'line',
                        fill: false,
                        backgroundColor: 'rgba(255, 99, 132, 0.5)',
                        borderColor: 'rgba(255, 99, 132, 1)',
                        borderWidth: 2,
                        tension: 0.1,
                        yAxisID: 'y1',
                        order: 0
                    }
                ]
            },
            options: {
                responsive: true,
                interaction: {
                    mode: 'index',
                    intersect: false
                },
                scales: {
                    y: {
                        type: 'linear',
                        display: true,
                        position: 'left',
                        title: {
                            display: true,
                            text: '金额 (¥)'
                        }
                    },
                    y1: {
                        type: 'linear',
                        display: true,
                        position: 'right',
                        title: {
                            display: true,
                            text: '毛利率 (%)'
                        },
                        grid: {
                            drawOnChartArea: false
                        },
                        min: 0,
                        max: 100
                    }
                }
            }
        });
    });
</script>
{% endif %}
{% endblock %}