{% extends "base.html" %}
{% import 'components/macros.html' as ui %}

{% block title %}AI CSV Agent{% endblock %}
{% block head_extra %}
<link rel="stylesheet" href="/static/style.css">
    <link rel="stylesheet" href="/static/ai-csv-agent.css">
{% endblock %}
{% block content %}
<div class="ai-csv-page">

    <div class="sidebar hil-inline-060732a4b2">

        <a href="/ai-csv-agent">AI CSV Agent</a>
        <a href="/ai-csv-agent/download" class="download-link">Download CSV to Local Machine</a>
        <hr>
        <div class="sidebar-group-title">CSV Modes</div>
        <form method="POST" class="hil-inline-cccfa4560d">
            <input type="hidden" name="action" value="set_mode">
            <input type="hidden" name="mode" value="auto">
            <button type="submit" class="sidebar-button">Use Auto AI Mode</button>
        </form>
        <form method="POST" class="hil-inline-cccfa4560d">
            <input type="hidden" name="action" value="set_mode">
            <input type="hidden" name="mode" value="manual">
            <button type="submit" class="sidebar-button">Use Manual Mode</button>
        </form>
        <form method="POST" class="hil-inline-cccfa4560d">
            <input type="hidden" name="action" value="regenerate_auto">
            <button type="submit" class="sidebar-button">Regenerate Auto CSV</button>
        </form>
    </div>
    <div class="main">

    <h1 class="brand">Gvelo Enterprise Platform</h1>


    <div class="card">

        <h2>AI CSV Agent</h2>

        <p>The default mode is AI auto CSV generation. You can switch to manual editor mode if needed.</p>

        <div class="hil-inline-33eee0d33f">
            Personal backup: after adding or importing many products, regenerate this CSV and download it to your local machine. If data is missing after an app update, use Bulk Import with your last downloaded CSV to recover products.
        </div>

        {% with messages = get_flashed_messages(with_categories=true) %}
            {% if messages %}
                {% for category, message in messages %}
                    <p><strong>{{ category|upper }}:</strong> {{ message }}</p>
                {% endfor %}
            {% endif %}
        {% endwith %}

        <p><strong>Current mode:</strong> {{ mode|upper }}</p>

        <hr>


        <h3>AI Analysis</h3>
        <p><strong>Total Items:</strong> {{ summary.total_items }}</p>
        <p><strong>Total Stock Value:</strong> {{ summary.total_stock_value }}</p>
        <p><strong>Total Buying Value:</strong> {{ summary.total_buying_value }}</p>
        <p><strong>Total Expected Profit:</strong> {{ summary.total_expected_profit }}</p>

        <h3>Expected Profit per Product</h3>
        <table class="hil-inline-89e1a43581">
            <thead>
                <tr><th>Name</th><th>Type</th><th>Stock</th><th>Sell</th><th>Buy</th><th>Expected Profit</th></tr>
            </thead>
            <tbody>
                {% for row in rows %}
                <tr>
                    <td>{{ row.name }}</td>
                    <td>{{ row.item_type }}</td>
                    <td>{{ row.stock }}</td>
                    <td>{{ row.selling_price }}</td>
                    <td>{{ row.buying_price }}</td>
                    <td>{{ row.expected_total_profit }}</td>
                </tr>
                {% endfor %}
            </tbody>
        </table>

        <hr>
        <h3>Manual CSV Code Editor</h3>
        <p>Use this only when mode is manual.</p>
        <form method="POST">
            <input type="hidden" name="action" value="save_manual">
            <textarea name="csv_content" rows="20" class="hil-inline-ff5d714a4b">{{ csv_text }}</textarea>
            <br><br>
            <button type="submit">Save Manual CSV</button>
        </form>

        <p><strong>CSV path:</strong> {{ csv_path }}</p>
        <p><a href="/bulk-import-products">Recover Products with Bulk Import</a> | <a href="/ai-csv-agent/download">Download Current CSV</a></p>
        <a href="/admin">Back to Admin</a>
    </div>
</div>
{% endblock %}