{% extends 'bom/bom-base.html' %}

{% load static %}

{% block head-title %}Upload Parts — CSV Reference{% endblock %}

{% block bom-menu %}
    <li><a href="{% url 'bom:home' %}">Home</a></li>
{% endblock %}

{% block content %}
    <div class="container" style="max-width: 900px;">

        <h1>Uploading Parts via CSV</h1>
        <p>Upload a CSV file to create multiple parts at once. Each row becomes one part. The first row must contain
            column headers — unrecognized headers are rejected. Rows with errors are skipped; valid rows in the same
            file are still imported.</p>

        {% if organization.number_scheme == 'S' %}
            <div class="card-panel blue-grey lighten-5">
                <strong>Before uploading:</strong> make sure you have defined your part classes in
                <a href="{% url 'bom:settings' 'indabom' %}">Settings → IndaBOM</a>. Every part must belong to a valid
                part class.
            </div>

            <a href="{% static 'bom/doc/test_new_parts.csv' %}">Download a sample CSV</a>
        {% else %}
            <a href="{% static 'bom/doc/test_new_parts_5_intelligent.csv' %}">Download a sample CSV</a>
        {% endif %}

        {# ------------------------------------------------------------------ #}
        <h2 class="section">Required Columns</h2>

        <div class="responsive-table-wrapper">
            <table class="striped">
                <thead>
                <tr>
                    <th style="width:22%">Column</th>
                    <th style="width:18%">Accepted names</th>
                    <th>Notes</th>
                </tr>
                </thead>
                <tbody>
                {% if organization.number_scheme == 'S' %}
                    <tr>
                        <td><code>part_class</code> <em>or</em> <code>part_number</code></td>
                        <td><code>class</code>, <code>part_category</code></td>
                        <td>
                            Provide <strong>one or both</strong>.<br>
                            <code>part_class</code> — the class code (e.g. <code>500</code>); the system auto-assigns an
                            item number.<br>
                            <code>part_number</code> — a full part number in <code>CCC-NNNN-VV</code> format; must not
                            already exist.
                            If both are given, <code>part_number</code> takes precedence.
                        </td>
                    </tr>
                {% else %}
                    <tr>
                        <td><code>part_number</code></td>
                        <td><code>part number</code>, <code>part no</code></td>
                        <td>Required. Must be unique — parts with a duplicate number are skipped.</td>
                    </tr>
                {% endif %}
                <tr>
                    <td><code>revision</code></td>
                    <td><code>rev</code>, <code>part_revision</code></td>
                    <td>Up to 4 characters. Cannot be a negative integer.</td>
                </tr>
                <tr>
                    <td><code>description</code></td>
                    <td><code>desc</code></td>
                    <td>Free-form text up to 255 characters describing the part.</td>
                </tr>
                </tbody>
            </table>
        </div>

        {# ------------------------------------------------------------------ #}
        <h2 class="section">Optional: Manufacturer</h2>
        <p>Include <strong>both</strong> columns to attach a manufacturer part number. Either alone is ignored.</p>

        <div class="responsive-table-wrapper">
            <table class="striped">
                <thead>
                <tr>
                    <th style="width:22%">Column</th>
                    <th style="width:18%">Accepted names</th>
                    <th>Notes</th>
                </tr>
                </thead>
                <tbody>
                <tr>
                    <td><code>manufacturer_name</code></td>
                    <td><code>manufacturer</code>, <code>mfg</code>, <code>mfg_name</code></td>
                    <td>Created automatically if it does not already exist.</td>
                </tr>
                <tr>
                    <td><code>manufacturer_part_number</code></td>
                    <td><code>mpn</code>, <code>mfg_part_number</code></td>
                    <td>Skipped if a matching manufacturer + MPN pair already exists.</td>
                </tr>
                </tbody>
            </table>
        </div>

        {# ------------------------------------------------------------------ #}
        <h2 class="section">Optional: Seller / Sourcing</h2>
        <p>Seller data requires the manufacturer columns above. <code>seller</code>, <code>unit_cost</code>, and <code>nre_cost</code>
            must all be present to create a seller record.</p>

        <div class="responsive-table-wrapper">
            <table class="striped">
                <thead>
                <tr>
                    <th style="width:22%">Column</th>
                    <th style="width:18%">Accepted names</th>
                    <th>Notes</th>
                </tr>
                </thead>
                <tbody>
                <tr>
                    <td><code>seller</code></td>
                    <td><code>part_seller</code></td>
                    <td>Seller / distributor name. Created automatically if it does not already exist.</td>
                </tr>
                <tr>
                    <td><code>unit_cost</code></td>
                    <td><code>part_cost</code></td>
                    <td>Cost per unit. Use a plain decimal number (e.g. <code>0.42</code>).</td>
                </tr>
                <tr>
                    <td><code>nre_cost</code></td>
                    <td><code>part_nre_cost</code>, <code>part_nre</code>, <code>nre</code></td>
                    <td>Non-recurring engineering cost. Use <code>0</code> if none.</td>
                </tr>
                <tr>
                    <td><code>seller_part_number</code></td>
                    <td><code>seller_pn</code>, <code>spn</code></td>
                    <td>Optional. The seller's own catalog number.</td>
                </tr>
                <tr>
                    <td><code>minimum_order_quantity</code></td>
                    <td><code>moq</code></td>
                    <td>Optional. Minimum quantity that must be ordered.</td>
                </tr>
                <tr>
                    <td><code>minimum_pack_quantity</code></td>
                    <td><code>mpq</code></td>
                    <td>Optional. Pack / reel size.</td>
                </tr>
                <tr>
                    <td><code>lead_time_days</code></td>
                    <td><code>lead_time</code>, <code>lt</code></td>
                    <td>Optional. Lead time in days.</td>
                </tr>
                </tbody>
            </table>
        </div>

        {# ------------------------------------------------------------------ #}
        <h2 class="section">Optional: Custom Properties</h2>
        <p>
            Your organization can define custom part properties in
            <a href="{% url 'bom:settings' 'indabom' %}">Settings → IndaBOM</a>.
            Each property can be included as a column using its <strong>property code</strong>
            (shown in settings) or the property's display name.
        </p>

        <div class="responsive-table-wrapper">
            <table class="striped">
                <thead>
                <tr>
                    <th style="width:22%">Column pattern</th>
                    <th>Notes</th>
                </tr>
                </thead>
                <tbody>
                <tr>
                    <td><code>property_&lt;code&gt;</code></td>
                    <td>Value for the property whose code is <code>&lt;code&gt;</code>. The property display name is
                        also accepted.
                    </td>
                </tr>
                <tr>
                    <td><code>property_&lt;code&gt;_units</code></td>
                    <td>Unit for a numeric property. Only required when the property has a quantity of measure defined.
                        Use the unit symbol (e.g. <code>mV</code>, <code>pF</code>).
                    </td>
                </tr>
                </tbody>
            </table>
        </div>

        <div class="card-panel" style="margin-top: 24px;">
            <strong>Tip:</strong> Export your existing parts list from the Home page and open it in a spreadsheet. The
            exported file uses exactly the right column names and is a ready-made template for adding new parts.
        </div>

        <br>
    </div>
{% endblock %}