{% extends 'base.html' %}
{% block title %}Executive Business Analytics{% endblock %}
{% block breadcrumb %}Operations / Analytics{% endblock %}
{% block content %}
<div class="v16-app">
  <header class="v16-hero">
    <div>
      <span class="v16-eyebrow">GENEZ PRINT · OPERATIONS INTELLIGENCE</span>
      <h1>{% if manager %}Executive overview{% else %}Branch performance{% endif %}</h1>
      <p>Track real orders, production progress, quality checks and delivery outcomes from the Genez database. Figures update when you refresh this page.</p>
    </div>
    <div class="v16-hero-actions">
      <a class="v16-light-btn" href="{% url 'production_intelligence' %}">Production alerts</a>
      <a class="v16-light-btn" href="{% url 'production_center' %}">Job control</a>
    </div>
  </header>
  <form class="v16-filters" method="get" action="{% url 'production_analytics' %}" aria-label="Analytics filters">
    <label>From <input type="date" name="start" value="{{ period.start|date:'Y-m-d' }}" required></label>
    <label>To <input type="date" name="end" value="{{ period.end|date:'Y-m-d' }}" required></label>
    <label>Production branch
      <select name="branch"><option value="">{% if manager %}All branches{% else %}My branches{% endif %}</option>
        {% for item in branches %}<option value="{{ item.pk }}" {% if branch.pk == item.pk %}selected{% endif %}>{{ item.name }}</option>{% endfor %}
      </select>
    </label>
    <button class="v16-primary" type="submit">Apply filters</button>
    <div class="v16-exports">
      <a href="{% url 'production_analytics_export' %}?kind=branches&amp;{{ export_query }}">Export branch CSV</a>
      {% if manager %}<a href="{% url 'production_analytics_export' %}?kind=summary&amp;{{ export_query }}">Export summary CSV</a>{% endif %}
    </div>
  </form>
  <p class="v16-daterange">Showing {{ period.start|date:'d M Y' }} – {{ period.end|date:'d M Y' }} · {% if branch %}{{ branch.name }}{% else %}All permitted branches{% endif %} · Times in Africa/Lagos when configured on the server</p>
  {% if manager %}
  <section class="v16-stat-grid" aria-label="Commercial metrics">
    <div class="v16-stat"><span>Orders received</span><strong>{{ orders_count }}</strong><small>Orders created in selected period</small></div>
    <div class="v16-stat"><span>Requested order value</span><strong>₦{{ orders_requested|floatformat:0 }}</strong><small>Includes unpaid requests; not revenue</small></div>
    <div class="v16-stat v16-blue"><span>Verified order value</span><strong>₦{{ verified_order_value|floatformat:0 }}</strong><small>{{ verified_orders }} orders with payment confirmation</small></div>
    <div class="v16-stat"><span>Gross collections</span><strong>₦{{ gross_collections|floatformat:0 }}</strong><small>Confirmed in period; refunds not deducted</small></div>
  </section>
  {% endif %}
  <section class="v16-stat-grid v16-production-metrics" aria-label="Production metrics">
    <div class="v16-stat"><span>Production jobs</span><strong>{{ jobs_count }}</strong><small>Jobs on orders created in period</small></div>
    <div class="v16-stat"><span>Completed / shipped</span><strong>{{ jobs_completed }}</strong><small>{% if completion_rate != None %}{{ completion_rate }}% of jobs in cohort{% else %}No jobs to calculate a rate{% endif %}</small></div>
    <div class="v16-stat {% if jobs_overdue %}v16-warn{% endif %}"><span>Overdue jobs</span><strong>{{ jobs_overdue }}</strong><small>Deadline passed, still open</small></div>
    <div class="v16-stat"><span>Latest QC pass rate</span><strong>{% if qc_pass_rate != None %}{{ qc_pass_rate }}%{% else %}—{% endif %}</strong><small>{{ qc_pass_count }} passing / {{ jobs_with_qc }} inspected jobs</small></div>
  </section>
  {% if manager %}
  <div class="v16-two-col">
    <section class="v16-panel" aria-label="Commercial activity chart">
      <div class="v16-panel-head"><div><h2>Commercial activity</h2><p>Order creation counts and confirmed gross payments, grouped by date.</p></div><span class="v16-pill">Live database</span></div>
      <div class="v16-legend"><span><i class="v16-dot blue"></i>Orders</span><span><i class="v16-dot green"></i>Collections</span></div>
      <div class="v16-chart" role="img" aria-label="Order counts and collections by date">
        {% for point in timeline %}<div class="v16-chart-row"><span class="v16-axis-label">{{ point.label }}</span><div class="v16-chart-bars"><div class="v16-bar blue" style="width:{{ point.order_pct }}%" title="{{ point.orders }} orders"></div><div class="v16-bar green" style="width:{{ point.collection_pct }}%" title="₦{{ point.collections }} verified"></div></div><span class="v16-axis-value">{{ point.orders }}</span></div>{% empty %}<p class="muted">No order activity in this period.</p>{% endfor %}
      </div>
      <p class="v16-footnote">Gross payment confirmations may relate to older orders; refunds and chargebacks are not subtracted.</p>
    </section>
    <section class="v16-panel" aria-label="Customer service metrics">
      <div class="v16-panel-head"><div><h2>Customer experience</h2><p>Support, ratings and dispatch signals.</p></div></div>
      <div class="v16-customer-grid">
        <div><span>Support tickets created</span><strong>{{ tickets_created }}</strong></div>
        <div><span>Open support backlog</span><strong>{{ tickets_open_global }}</strong></div>
        <div><span>Order conversations</span><strong>{{ conversations }}</strong></div>
        <div><span>Shipments delivered</span><strong>{{ shipments_delivered }} <small>/ {{ shipments_count }}</small></strong></div>
        <div><span>Product review average</span><strong>{% if average_review != None %}{{ average_review }} / 5{% else %}—{% endif %}</strong><small>{{ review_count }} submitted reviews</small></div>
        <div><span>Delivery feedback average</span><strong>{% if average_delivery != None %}{{ average_delivery }} / 5{% else %}—{% endif %}</strong><small>{{ delivery_feedback_count }} submitted ratings</small></div>
      </div>
      <p class="v16-footnote">A dash means insufficient data. These are operational indicators, not service-level guarantees.</p>
    </section>
  </div>
  {% endif %}
  <section class="v16-panel" aria-label="Branch comparison">
    <div class="v16-panel-head"><div><h2>Branch production comparison</h2><p>Workload, efficiency, deadlines and recorded production costs. Unassigned jobs are shown separately.</p></div><span class="v16-pill">{{ jobs_count }} jobs</span></div>
    <div class="v16-table-scroll"><table class="v16-table"><thead><tr><th>Branch</th><th>Jobs</th><th>Complete</th><th>Completion rate</th><th>Overdue</th><th>Unassigned</th>{% if manager %}<th>Job line value</th><th>Actual costs recorded</th>{% endif %}</tr></thead>
    <tbody>{% for row in branch_rows %}<tr><th scope="row">{{ row.name }}</th><td>{{ row.jobs }}</td><td>{{ row.completed }}</td><td><div class="v16-rate"><div class="v16-rate-track"><div style="width:{{ row.completion_rate|default_if_none:0 }}%"></div></div><span>{% if row.completion_rate != None %}{{ row.completion_rate }}%{% else %}—{% endif %}</span></div></td><td>{% if row.overdue %}<span class="v16-risk">{{ row.overdue }}</span>{% else %}0{% endif %}</td><td>{{ row.unassigned }}</td>{% if manager %}<td>₦{{ row.line_value|floatformat:0 }}</td><td>₦{{ row.cost_recorded|floatformat:0 }}<div class="v16-muted-xs">{{ row.actual_jobs }} jobs recorded</div></td>{% endif %}</tr>
    {% empty %}<tr><td colspan="{% if manager %}8{% else %}6{% endif %}" class="v16-empty">No jobs belong to the selected period and permitted branches.</td></tr>{% endfor %}</tbody></table></div>
    <p class="v16-footnote">{% if manager %}Job line value is attributed by production assignment, not by payment or seller ownership. It must not be used as branch revenue. Actual costs include only jobs with recorded values.{% else %}Financial line values and production costs are available to management only.{% endif %}</p>
  </section>
  <div class="v16-two-col">
    <section class="v16-panel"><div class="v16-panel-head"><div><h2>Production pipeline</h2><p>Current job statuses for the selected order cohort.</p></div></div><div class="v16-pipeline">{% for name,value in jobs_status %}<div class="v16-stage"><span>{{ name|title }}</span><strong>{{ value }}</strong></div>{% empty %}<p class="muted">No production jobs yet.</p>{% endfor %}</div><div class="v16-annotation"><strong>{{ jobs_unassigned }}</strong> jobs need branch or staff assignment · <strong>{{ open_risks }}</strong> active job alerts</div></section>
    {% if manager %}<section class="v16-panel"><div class="v16-panel-head"><div><h2>Top products by assigned work</h2><p>Product line value on production jobs in this cohort.</p></div></div><div class="v16-products">{% for product in products %}<div class="v16-product"><span>{{ product.name }}</span><small>{{ product.count }} units</small><strong>₦{{ product.value|floatformat:0 }}</strong></div>{% empty %}<p class="muted">No product assignments in the selected period.</p>{% endfor %}</div></section>{% else %}<section class="v16-panel"><h2>Scope and privacy</h2><p>Production employees can review only their active branch memberships. Customer details, company-wide revenue, and support records are restricted to management.</p></section>{% endif %}
  </div>
  <div class="v16-disclaimer"><strong>Understanding these numbers</strong><p>Most production measures are grouped by the order's creation date, even when work continues later. Metrics are operational snapshots, not audited financial statements. Gross collections do not account for refunds; some work may have incomplete costs or estimated delivery dates.</p></div>
</div>
{% endblock %}