{% extends "admin/base_site.html" %}
{% load static %}

{% block title %}Import Registered Members CSV{% endblock %}

{% block breadcrumbs %}
<div class="breadcrumbs">
    <a href="{% url 'admin:index' %}">Home</a>
    &rsaquo; <a href="{% url 'admin:attendance_registeredmember_changelist' %}">Registered Members</a>
    &rsaquo; Import CSV
</div>
{% endblock %}

{% block content %}
<div id="content-main">
    <h1>Import Registered Members from CSV</h1>
    
    <div class="module" style="margin-bottom: 20px; padding: 15px; background: #f9f9f9; border: 1px solid #ddd;">
        <h2>CSV Format Requirements</h2>
        <p>Your CSV file must have the following columns (header row required):</p>
        <ul>
            <li><strong>Registration Code</strong> (required, unique identifier/barcode)</li>
            <li><strong>Full Name</strong> (required)</li>
            <li><strong>Email</strong> (optional)</li>
            <li><strong>Status</strong> (optional, default: approved)</li>
            <li><strong>Payment Status</strong> (optional, default: paid)</li>
            <li><strong>Package Name</strong> (required for access control — e.g. "Training &amp; Conference", "Training only", "All Access")</li>
            <li><strong>Package Description</strong> (optional)</li>
            <li><strong>Activity Price</strong> (optional, numeric)</li>
        </ul>
        <p><strong>Package validation:</strong> When scanning at a specific sub-event (e.g. Conference), the system checks that the member's Package Name contains the event type keyword (e.g. "CONFERENCE"). Mismatched packages are rejected at the scanner.</p>
        <p><em>Note: If a member with the same Registration Code already exists, their record will be updated.</em></p>
    </div>

    <form method="post" enctype="multipart/form-data">
        {% csrf_token %}
        
        <div class="form-row">
            <div>
                <label for="event_category_id">Event Category (optional):</label>
                <select name="event_category_id" id="event_category_id" style="width: 300px; padding: 5px;">
                    <option value="">-- No specific category --</option>
                    {% for cat in categories %}
                        <option value="{{ cat.id }}">{{ cat.name }}</option>
                    {% endfor %}
                </select>
                <p class="help">If selected, all imported members will be linked to this event category (umbrella). The member's Package Name determines which specific sub-events they may attend.</p>
            </div>
        </div>

        <div class="form-row" style="margin-top: 15px;">
            <div>
                <label for="csv_file">CSV File:</label>
                <input type="file" name="csv_file" id="csv_file" accept=".csv" required>
            </div>
        </div>

        <div class="submit-row" style="margin-top: 20px;">
            <input type="submit" value="Import CSV" class="default">
            <a href="{% url 'admin:attendance_registeredmember_changelist' %}" class="button cancel-link">Cancel</a>
        </div>
    </form>
</div>
{% endblock %}