{% 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" }}
            </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.category|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-12">
            <div class="card">
                <div class="card-header">
                    <h3 class="h5 mb-0">库存周转率统计图</h3>
                </div>
                <div class="card-body">
                    <canvas id="turnoverChart" 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>商品编码</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>
                                    <th>周转状态</th>
                                </tr>
                            </thead>
                            <tbody>
                                {% for item in inventory_data %}
                                <tr>
                                    <td>{{ item.product_name }}</td>
                                    <td>{{ item.product_code }}</td>
                                    <td class="text-end">{{ item.current_stock }}</td>
                                    <td class="text-end">{{ item.avg_stock|floatformat:1 }}</td>
                                    <td class="text-end">{{ item.sold_quantity }}</td>
                                    <td class="text-end">{{ item.turnover_rate|floatformat:2 }}</td>
                                    <td class="text-end">{{ item.turnover_days|floatformat:0 }}</td>
                                    <td>
                                        {% if item.turnover_days > 90 %}
                                        <span class="badge bg-danger">滞销</span>
                                        {% elif item.turnover_days > 60 %}
                                        <span class="badge bg-warning">周转慢</span>
                                        {% elif item.turnover_days > 30 %}
                                        <span class="badge bg-info">正常</span>
                                        {% else %}
                                        <span class="badge bg-success">周转快</span>
                                        {% endif %}
                                    </td>
                                </tr>
                                {% empty %}
                                <tr>
                                    <td colspan="8" class="text-center py-4">没有库存周转数据</td>
                                </tr>
                                {% endfor %}
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

{% if inventory_data %}
<script>
    document.addEventListener('DOMContentLoaded', function() {
        const ctx = document.getElementById('turnoverChart').getContext('2d');
        
        // 准备数据
        const labels = [
            {% for item in inventory_data %}
                '{{ item.product_name }}',
            {% endfor %}
        ];
        
        const turnoverRateData = [
            {% for item in inventory_data %}
                {{ item.turnover_rate|default:0 }},
            {% endfor %}
        ];
        
        const turnoverDaysData = [
            {% for item in inventory_data %}
                {{ item.turnover_days|default:0 }},
            {% endfor %}
        ];
        
        // 创建图表
        const myChart = new Chart(ctx, {
            type: 'bar',
            data: {
                labels: labels,
                datasets: [
                    {
                        label: '周转率',
                        data: turnoverRateData,
                        backgroundColor: 'rgba(54, 162, 235, 0.5)',
                        borderColor: 'rgba(54, 162, 235, 1)',
                        borderWidth: 1,
                        yAxisID: 'y'
                    },
                    {
                        label: '周转天数',
                        data: turnoverDaysData,
                        type: 'line',
                        backgroundColor: 'rgba(255, 99, 132, 0.5)',
                        borderColor: 'rgba(255, 99, 132, 1)',
                        borderWidth: 2,
                        yAxisID: 'y1'
                    }
                ]
            },
            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
                        }
                    }
                }
            }
        });
    });
</script>
{% endif %}
{% endblock %}