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

{% load static %}
{% load materializecss %}

{% block head-title %}{{ title }}{% endblock %}

{% block bom-menu %}{% endblock %}

{% block content %}
    <div class="container-app">
        {% if profile.role == 'A' %}

            <p>Upload a CSV to populate or update a Bill of Materials. Parts and revisions are created if they don't
                exist, or updated if they do. Immutable revisions (Released / Obsolete) are skipped. Rows with errors
                are skipped and the rest continue to import.</p>
            <p>In addition to <a href="{% url 'bom:upload-parts' %}">uploading parts</a>, uploading a <b>bill of
                materials</b>: associates parts to create assemblies, and adds quantities to specify how many parts are
                in an assembly.</p>

            <p style="margin-top: 8px; font-size: 0.85rem;">
                {% if organization.number_scheme == 'S' %}
                    <a href="{% static 'bom/doc/test_full_bom.csv' %}">Download a Sample CSV</a>
                {% else %}
                    <a href="{% static 'bom/doc/test_bom_5_intelligent.csv' %}">Download a Sample CSV</a>
                {% endif %}
            </p>
            <div class="row" style="margin-bottom: 0;">
                <div class="col s12 m6">
                    <table class="striped" style="font-size: 0.9rem;">
                        <thead>
                        <tr>
                            <th colspan="2">Required columns</th>
                        </tr>
                        </thead>
                        <tbody>
                        <tr>
                            <td><code>part_number</code> <em>or</em><br><code>manufacturer_part_number</code></td>
                            <td>Identifies the subpart. The part must already exist when using <code>manufacturer_part_number</code>.
                            </td>
                        </tr>
                        <tr>
                            <td><code>quantity</code></td>
                            <td>Also accepted: <code>count</code>, <code>qty</code>. Defaults to 1 if empty.</td>
                        </tr>
                        <tr>
                            <td><code>level</code></td>
                            <td>Nesting depth (1 = direct child). Required unless a <strong>Parent part number</strong>
                                is given below, in which case all rows are treated as level 1.
                            </td>
                        </tr>
                        </tbody>
                        <thead>
                        <tr>
                            <th colspan="2">Optional columns</th>
                        </tr>
                        </thead>
                        <tbody>
                        <tr>
                            <td><code>reference</code></td>
                            <td>Also accepted: <code>designator</code>. Comma-separated list (e.g. <code>R1, R2</code>).
                                Count must match quantity.
                            </td>
                        </tr>
                        <tr>
                            <td><code>do_not_load</code></td>
                            <td>Also accepted: <code>dnl</code>, <code>dnp</code>. Mark as Do Not Load. Values:
                                <code>y</code>, <code>x</code>, <code>yes</code>, <code>true</code>.
                            </td>
                        </tr>
                        <tr>
                            <td><code>revision</code></td>
                            <td>Also accepted: <code>rev</code>. Target revision. Defaults to <code>1</code> if omitted.
                            </td>
                        </tr>
                        <tr>
                            <td><code>description</code></td>
                            <td>Part description. Up to 255 characters.</td>
                        </tr>
                        </tbody>
                    </table>
                </div>

                <div class="col s12 m6">
                    <div class="card-panel">
                        <form action="{% url 'bom:upload-bom' %}" method="post" enctype="multipart/form-data">
                            {% csrf_token %}
                            <div class="file-field input-field">
                            <div class="green lighten-1 btn">
                                <span>Choose file</span>
                                {{ bom_csv_form.file }}
                            </div>
                            <div class="file-path-wrapper">
                                <input class="file-path validate" type="text" placeholder="Select a CSV file…">
                                {{ bom_csv_form.file.errors }}
                            </div>
                        </div>
                            <div class="row" style="margin-bottom: 0; margin-top: 8px;">
                                {{ upload_bom_form.parent_part_number|materializecss:'s12' }}
                        </div>
                            <p style="font-size: 0.85rem; margin-top: -8px; color: #666;">
                                Optional. Attach all rows as direct children of this assembly. Omit when the CSV
                                includes a <code>level</code> column.
                            {% if parent_part %}
                                <br><a href="{% url 'bom:part-info' part_id=parent_part.id %}">Go
                                to {{ parent_part_number }}</a>
                            {% endif %}
                            </p>
                            <div style="margin-top: 8px;">
                                <input class="green lighten-1 btn" type="submit" value="Upload"/>
                                <a href="{% url 'bom:home' %}" class="btn-flat grey-text" style="margin-left: 8px;">Cancel</a>
                            </div>
                        </form>
                    </div>
                </div>
            </div>

        {% else %}
            {% include 'bom/nothing-to-see.html' with required_privilege='Admin' %}
        {% endif %}
    </div>
{% endblock %}