{% extends "pos/base.html" %}

{% block content %}

<div class="container-fluid mt-3">

    <h3>Stock Adjustment Script</h3>

    <div class="alert alert-warning">
        <b>Important:</b>
        Ye script old sale, purchase, aur old stock history rows ko update/delete nahi karegi.
        Apply par ProductStock rows ka stock reset hoga, product_details stock update hoga,
        aur agar history closing product stock se match nahi karti to stock_history mein new adjustment row insert hogi.
    </div>

    {% if messages %}
        {% for message in messages %}
            <div class="alert alert-{{ message.tags }}">
                {{ message }}
            </div>
        {% endfor %}
    {% endif %}

    <div class="card mb-3">
        <div class="card-body">

            <form method="get" class="row align-items-end">

                <div class="col-md-3">
                    <label>Flow</label>
                    <select name="scope" class="form-control">
                        <option value="all" {% if scope == "all" %}selected{% endif %}>
                            1. All Products
                        </option>

                        <option value="one" {% if scope == "one" %}selected{% endif %}>
                            2. One Product
                        </option>

                        <option value="problematic" {% if scope == "problematic" %}selected{% endif %}>
                            3. Problematic Only
                        </option>
                    </select>

                    <div class="form-check mt-2">
                        <input type="checkbox" class="form-check-input" id="moveDefaultToOther"
                               name="move_default_to_other" value="1"
                               {% if move_default_to_other %}checked{% endif %}>
                        <label class="form-check-label" for="moveDefaultToOther">
                            Move default layer stock to other variants as well
                        </label>
                    </div>

                    <div class="form-check mt-2">
                        <input type="checkbox" class="form-check-input" id="consolidateVariants"
                               name="consolidate_variants" value="1"
                               {% if consolidate_variants %}checked{% endif %}>
                        <label class="form-check-label" for="consolidateVariants">
                            Last variant row receives all stock (consolidate)
                        </label>
                    </div>

                    <div class="form-check mt-1" {% if not consolidate_variants %}style="opacity:0.5;"{% endif %}>
                        <input type="checkbox" class="form-check-input" id="moveDefaultToOther"
                               name="move_default_to_other" value="1"
                               {% if move_default_to_other %}checked{% endif %}
                               {% if not consolidate_variants %}disabled{% endif %}>
                        <label class="form-check-label" for="moveDefaultToOther">
                            Move default layer stock to other variants as well
                            <small class="text-muted d-block">(only applies when consolidate is ticked)</small>
                        </label>
                    </div>


                </div>

                <div class="col-md-4">
                    <label>Product Code / Prod ID / DB ID</label>
                    <input type="text"
                           name="product_code"
                           value="{{ product_code }}"
                           class="form-control"
                           placeholder="Example: 780">
                    <small class="text-muted">
                        One Product flow mein product code/prod id/db id required hai.
                    </small>
                </div>

                <div class="col-md-2">
                    <button type="submit" class="btn btn-primary">
                        Preview
                    </button>
                </div>

                <div class="col-md-2">
                    <a href="{{ request.path }}?scope=all" class="btn btn-secondary">
                        Reset
                    </a>
                </div>

            </form>

        </div>
    </div>

    <div class="card mb-3">
        <div class="card-body">

            <p>
                <b>Flow:</b> {{ scope }}
                |
                <b>Total checked:</b> {{ total_checked }}
                |
                <b>Total planned:</b> {{ total_planned }}
                |
                <b>Need adjustment:</b> {{ total_affected }}
                |
                <b>History adjustments:</b> {{ total_history_adjustments }}
                |
                <b>Variant adjustments:</b> {{ total_variant_adjustments }}
                |
                <b>Default stock will move:</b> {{ total_default_stock_will_move }}
                |
                <b>Preview limit:</b> {{ preview_limit }}
            </p>

            {% if move_default_to_other %}
                <div class="alert alert-info mb-0 mt-2">
                    "Move default layer stock to other variants" is <b>ON</b> —
                    default variant ka stock last non-default variant mein move hoga
                    (agar koi non-default variant exist nahi karta to naya bana diya jayega).
                </div>
            {% endif %}

            {% if scope == "one" and not product_code %}
                <div class="alert alert-info mb-0">
                    One Product flow ke liye pehle product code / prod id / db id enter karo.
                </div>
            {% elif total_planned > 0 %}
                <form method="post"
                      onsubmit="return confirm('Are you sure? This will update ProductStock, product_details and insert stock_history adjustment rows where needed.');">
                    {% csrf_token %}

                    <input type="hidden" name="scope" value="{{ scope }}">
                    <input type="hidden" name="product_code" value="{{ product_code }}">
                    <input type="hidden" name="move_default_to_other" value="{% if move_default_to_other %}1{% else %}0{% endif %}">
                    <input type="hidden" name="consolidate_variants" value="{% if consolidate_variants %}1{% else %}0{% endif %}">

                    <button type="submit" class="btn btn-danger">
                        Apply Stock Adjustment
                    </button>
                </form>
            {% else %}
                <div class="alert alert-success mb-0">
                    No product found for this flow.
                </div>
            {% endif %}

        </div>
    </div>

    <div class="card">
        <div class="card-body table-responsive">

            <table class="table table-bordered table-sm">
                <thead>
                    <tr>
                        <th>DB ID</th>
                        <th>Prod ID</th>
                        <th>Code</th>
                        <th>Name</th>

                        <th>Product Stock</th>
                        <th>Target Stock</th>

                        <th>Current Variant Stock</th>
                        <th>Variant Rows</th>
                        <th>Default → Other Move</th>

                        <th>History Calculation</th>
                        <th>History Adjustment</th>

                        <th>Status / Issue</th>
                    </tr>
                </thead>

                <tbody>
                    {% for row in preview_rows %}
                        <tr {% if row.will_move_default_stock %}style="background-color:#fff8e1;"{% endif %}>
                            <td>{{ row.id }}</td>
                            <td>{{ row.prod_id }}</td>
                            <td>{{ row.product_code }}</td>
                            <td>{{ row.name }}</td>

                            <td>
                                Present: <b>{{ row.old_present_stock }}</b><br>
                                Bonus: {{ row.old_bonus_stock }}
                            </td>

                            <td>
                                <b>{{ row.target_stock }}</b><br>
                                Bonus: {{ row.target_bonus }}
                            </td>

                            <td>
                                On Hand: {{ row.variant_on_hand_total }}<br>
                                Bonus: {{ row.variant_bonus_total }}<br>
                                <b>Total: {{ row.variant_total }}</b>

                                {% if row.variant_total_mismatch %}
                                    <br>
                                    <span style="color:red;">
                                        Variant total mismatch
                                    </span>
                                {% endif %}
                            </td>

                            <td>
                                {{ row.variant_rows_count }}

                                {% if row.consolidate_variants %}
                                    {% if not row.variant_distribution_ok %}
                                        <br><span style="color:red;">Distribution will be reset</span>
                                    {% else %}
                                        <br><span style="color:green;">Distribution OK</span>
                                    {% endif %}
                                {% else %}
                                    {% if row.variant_total_mismatch %}
                                        <br><span style="color:red;">Total mismatch — last row will adjust by {{ row.variant_adjustment_delta }}</span>
                                    {% else %}
                                        <br><span style="color:green;">Total OK — distribution untouched</span>
                                    {% endif %}
                                {% endif %}
                            </td>

                            <td>
                                {% if row.will_move_default_stock %}
                                    <span style="color:#b8860b;">
                                        Default stock: <b>{{ row.default_stock_before }}</b><br>
                                        → moving to: <b>{{ row.target_variant_sku }}</b>
                                    </span>
                                {% else %}
                                    <span style="color:gray;">—</span>
                                {% endif %}
                            </td>

                            <td>
                                Opening: {{ row.history_opening }}<br>
                                Net Change: {{ row.history_net_change }}<br>
                                <b>Closing: {{ row.history_closing }}</b><br>

                                Rows: {{ row.history_rows_count }}

                                {% if row.first_history_id %}
                                    <br>
                                    <small>First ID: {{ row.first_history_id }}</small>
                                {% endif %}

                                {% if row.last_history_id %}
                                    <br>
                                    <small>Last ID: {{ row.last_history_id }}</small>
                                {% endif %}
                            </td>

                            <td>
                                {% if row.history_adjustment < 0 %}
                                    <span style="color:red;">
                                        {{ row.history_adjustment }}
                                    </span>
                                {% elif row.history_adjustment > 0 %}
                                    <span style="color:green;">
                                        +{{ row.history_adjustment }}
                                    </span>
                                {% else %}
                                    <span style="color:gray;">
                                        0
                                    </span>
                                {% endif %}

                                {% if row.history_needs_adjustment %}
                                    <br>
                                    <small style="color:red;">
                                        New history adjustment row will be inserted.
                                    </small>
                                {% else %}
                                    <br>
                                    <small style="color:green;">
                                        History already matched.
                                    </small>
                                {% endif %}
                            </td>

                            <td>
                                {% if row.issue %}
                                    <span style="color:red;">
                                        {{ row.issue }}
                                    </span>
                                {% else %}

                                    {% if row.needs_change %}
                                        <span style="color:red;">
                                            Adjustment needed
                                        </span>
                                    {% else %}
                                        <span style="color:green;">
                                            Already OK
                                        </span>
                                    {% endif %}

                                    <br>

                                    {% if row.product_needs_update %}
                                        Product details stock will be updated.<br>
                                    {% else %}
                                        Product details stock already OK.<br>
                                    {% endif %}

                                    {% if row.consolidate_variants %}
                                        {% if row.variant_total_mismatch or not row.variant_distribution_ok %}
                                            ProductStock rows will be reset.<br>
                                            Last variant row will receive target stock.<br>
                                        {% else %}
                                            ProductStock already OK.<br>
                                        {% endif %}
                                    {% else %}
                                        {% if row.variant_total_mismatch %}
                                            Only last variant row will be nudged by {{ row.variant_adjustment_delta }} — other variants untouched.<br>
                                        {% else %}
                                            ProductStock already OK — distribution untouched.<br>
                                        {% endif %}
                                    {% endif %}

                                    {% if row.history_needs_adjustment %}
                                        Stock history adjustment row will be inserted.
                                    {% else %}
                                        Stock history already matched.
                                    {% endif %}

                                {% endif %}
                            </td>
                        </tr>
                    {% empty %}
                        <tr>
                            <td colspan="12" class="text-center">
                                No products found for this flow.
                            </td>
                        </tr>
                    {% endfor %}
                </tbody>
            </table>

        </div>
    </div>

</div>

{% endblock %}