{% extends 'base.html' %}
{% block title %}World Rubber Prices{% endblock %}
{% block content %}

<div class="page-header">
  <div>
    <div class="page-title">World Rubber Prices
      <small>International market — Malaysia · Indonesia · Thailand</small>
    </div>
  </div>
  <div class="d-flex gap-2 align-items-center flex-wrap">
    <span class="text-sm text-muted" id="updatedLabel" style="display:none">
      <i class="bi bi-clock me-1"></i><span id="updatedText"></span>
    </span>
    <button class="btn btn-outline-secondary btn-sm" id="refreshBtn" onclick="loadPrices(true)">
      <i class="bi bi-arrow-clockwise me-1"></i> Refresh
    </button>
    <a href="https://rubberboard.gov.in/public" target="_blank" rel="noopener" class="btn btn-outline-secondary btn-sm">
      <i class="bi bi-box-arrow-up-right me-1"></i> Rubber Board
    </a>
    <a href="https://www.anrpc.org/anrpc-daily-price" target="_blank" rel="noopener" class="btn btn-outline-secondary btn-sm">
      <i class="bi bi-box-arrow-up-right me-1"></i> ANRPC
    </a>
  </div>
</div>

<!-- Source note -->
<div class="alert alert-info d-flex gap-2 align-items-start mb-4" style="font-size:12.5px">
  <i class="bi bi-info-circle-fill flex-shrink-0 mt-1"></i>
  <span>
    Live data from <strong>ANRPC</strong> (Association of Natural Rubber Producing Countries) · Prices in <strong>US$/kg</strong><br>
    <strong>SMR 20</strong> = Standard Malaysian Rubber (Malaysia) &nbsp;|&nbsp;
    <strong>SIR 20</strong> = Standard Indonesian Rubber (Indonesia) &nbsp;|&nbsp;
    <strong>STR 20</strong> = Standard Thai Rubber (Thailand) &nbsp;|&nbsp;
    <strong>RSS3</strong> = Ribbed Smoked Sheet No.3 (Bangkok) &nbsp;|&nbsp;
    <strong>Latex</strong> = Latex-in-bulk 60% (Kuala Lumpur)
  </span>
</div>

<!-- Loading state -->
<div id="loadingState" class="card mb-4">
  <div class="card-body empty-state-full">
    <i class="bi bi-hourglass-split" style="font-size:36px;color:#94a3b8;display:block;margin-bottom:12px"></i>
    <h6>Loading prices…</h6>
    <p>Fetching live data from server</p>
  </div>
</div>

<!-- Error state -->
<div id="errorState" class="alert alert-warning d-flex gap-2 mb-4" style="display:none">
  <i class="bi bi-exclamation-triangle-fill flex-shrink-0"></i>
  <div>
    <strong>Could not load live prices.</strong> <span id="errorMsg"></span>
    <div class="text-sm mt-1">
      View prices directly at
      <a href="https://rubberboard.gov.in/public" target="_blank">rubberboard.gov.in</a> or
      <a href="https://www.anrpc.org/anrpc-daily-price" target="_blank">anrpc.org</a>.
    </div>
  </div>
</div>

<!-- Price cards -->
<div id="priceCards" class="stats-grid mb-4" style="display:none;grid-template-columns:repeat(auto-fit,minmax(165px,1fr))">
  <div class="stat-card stat-blue">
    <div class="stat-card-stripe"></div>
    <div class="stat-icon"><i class="bi bi-water"></i></div>
    <div class="stat-label">SMR 20 · Malaysia</div>
    <div class="stat-value" id="val-SMR20" style="font-size:20px">–</div>
    <div class="stat-sub" id="chg-SMR20"></div>
  </div>
  <div class="stat-card stat-amber">
    <div class="stat-card-stripe"></div>
    <div class="stat-icon"><i class="bi bi-tree"></i></div>
    <div class="stat-label">SIR 20 · Indonesia</div>
    <div class="stat-value" id="val-SIR20" style="font-size:20px">–</div>
    <div class="stat-sub" id="chg-SIR20"></div>
  </div>
  <div class="stat-card stat-green">
    <div class="stat-card-stripe"></div>
    <div class="stat-icon"><i class="bi bi-grid-3x3"></i></div>
    <div class="stat-label">STR 20 · Thailand</div>
    <div class="stat-value" id="val-STR20" style="font-size:20px">–</div>
    <div class="stat-sub" id="chg-STR20"></div>
  </div>
  <div class="stat-card stat-purple">
    <div class="stat-card-stripe"></div>
    <div class="stat-icon"><i class="bi bi-graph-up"></i></div>
    <div class="stat-label">RSS3 · Bangkok</div>
    <div class="stat-value" id="val-RSS3" style="font-size:20px">–</div>
    <div class="stat-sub" id="chg-RSS3"></div>
  </div>
  <div class="stat-card">
    <div class="stat-card-stripe" style="background:linear-gradient(90deg,#0d7377,#14a5a8)"></div>
    <div class="stat-icon" style="background:#e0f7f7;color:#0d7377"><i class="bi bi-droplet-half"></i></div>
    <div class="stat-label">Latex 60% · KL</div>
    <div class="stat-value" id="val-Latex" style="font-size:20px">–</div>
    <div class="stat-sub" id="chg-Latex"></div>
  </div>
</div>

<!-- Charts -->
<div id="chartsRow" class="row g-3 mb-4" style="display:none">
  <div class="col-lg-6">
    <div class="card h-100">
      <div class="card-header">
        <span class="card-title"><i class="bi bi-graph-up me-2"></i>Dry Rubber — SMR 20 · SIR 20 · STR 20</span>
        <span class="text-sm text-muted">US$/kg</span>
      </div>
      <div class="card-body"><canvas id="chartDry" height="140"></canvas></div>
    </div>
  </div>
  <div class="col-lg-6">
    <div class="card h-100">
      <div class="card-header">
        <span class="card-title"><i class="bi bi-droplet-half me-2"></i>RSS3 &amp; Latex 60%</span>
        <span class="text-sm text-muted">US$/kg</span>
      </div>
      <div class="card-body"><canvas id="chartLatex" height="140"></canvas></div>
    </div>
  </div>
</div>

<!-- Data table -->
<div id="dataTable" class="card" style="display:none">
  <div class="card-header d-flex align-items-center justify-content-between">
    <span class="card-title"><i class="bi bi-table me-2"></i>Daily Price History</span>
    <span class="text-sm text-muted" id="rowCount"></span>
  </div>
  <div class="table-wrap">
    <table style="font-size:12.5px">
      <thead>
        <tr>
          <th>Date</th>
          <th class="text-right">SMR 20<br><span style="font-weight:400;font-size:10px">Malaysia</span></th>
          <th class="text-right">SIR 20<br><span style="font-weight:400;font-size:10px">Indonesia</span></th>
          <th class="text-right">STR 20<br><span style="font-weight:400;font-size:10px">Thailand</span></th>
          <th class="text-right">RSS3<br><span style="font-weight:400;font-size:10px">Bangkok</span></th>
          <th class="text-right">Latex 60%<br><span style="font-weight:400;font-size:10px">KL</span></th>
        </tr>
      </thead>
      <tbody id="priceTableBody"></tbody>
    </table>
  </div>
</div>

{% endblock %}
{% block scripts %}
<script>
(function loadChartJS(cdns, idx) {
  if (idx >= cdns.length) return;
  var s = document.createElement('script');
  s.src = cdns[idx];
  s.onload  = function() { if (window._pendingChart) { renderCharts(window._pendingChart); window._pendingChart = null; } };
  s.onerror = function() { loadChartJS(cdns, idx + 1); };
  document.head.appendChild(s);
})([
  'https://cdn.jsdelivr.net/npm/chart.js@4.4.1/dist/chart.umd.min.js',
  'https://cdnjs.cloudflare.com/ajax/libs/Chart.js/4.4.1/chart.umd.min.js',
], 0);

// ── Column name mapping (ANRPC sheet header → our canonical key) ──
var COL_MAP = {
  'SMR 20': 'SMR20', 'SMR20': 'SMR20',
  'SIR 20': 'SIR20', 'SIR20': 'SIR20',
  'STR 20': 'STR20', 'STR20': 'STR20',
  'RSS3':   'RSS3',  'BKK (RSS3)': 'RSS3', 'RSS 3': 'RSS3',
  'Latex':  'Latex', 'Latex-in-bulk': 'Latex', 'Latex in Bulk': 'Latex',
  'Latex (60%)': 'Latex',
};
var KEYS = ['SMR20','SIR20','STR20','RSS3','Latex'];

function parseCSV(text) {
  return text.split(/\r?\n/).map(function(line) {
    var result = [], field = '', inQ = false;
    for (var i = 0; i < line.length; i++) {
      var c = line[i];
      if (c === '"') inQ = !inQ;
      else if (c === ',' && !inQ) { result.push(field.trim()); field = ''; }
      else field += c;
    }
    result.push(field.trim());
    return result;
  });
}

function toNum(v) {
  var n = parseFloat((v || '').replace(/[^0-9.+-]/g, ''));
  return isNaN(n) ? null : n;
}

function processCSV(rawRows) {
  // Find header row — the one containing a 'date'-like first cell
  var hi = 0;
  for (var i = 0; i < Math.min(rawRows.length, 5); i++) {
    if (rawRows[i][0] && /date/i.test(rawRows[i][0])) { hi = i; break; }
  }
  var headers = rawRows[hi];
  // Map column indices
  var colIdx = {};
  headers.forEach(function(h, i) {
    var k = COL_MAP[h.trim()];
    if (k && !(k in colIdx)) colIdx[k] = i;
  });

  var data = [];
  for (var r = hi + 1; r < rawRows.length; r++) {
    var row = rawRows[r];
    if (!row[0] || !row[0].trim()) continue;
    var entry = { date: row[0].trim() };
    KEYS.forEach(function(k) {
      entry[k] = colIdx[k] != null ? toNum(row[colIdx[k]]) : null;
    });
    data.push(entry);
  }
  return data.slice(-60);
}

function setCard(key, cur, prev) {
  var vEl = document.getElementById('val-' + key);
  var cEl = document.getElementById('chg-' + key);
  if (!vEl) return;
  vEl.textContent = cur != null ? 'US$ ' + cur.toFixed(4) : '–';
  if (cEl && cur != null && prev != null) {
    var d = cur - prev;
    cEl.style.color = d > 0 ? '#16a34a' : d < 0 ? '#dc2626' : '#94a3b8';
    cEl.textContent = (d > 0 ? '▲ ' : d < 0 ? '▼ ' : '') + Math.abs(d).toFixed(4) + ' vs prev';
  }
}

function ds(data, key, label, color) {
  return {
    label: label,
    data:  data.map(function(r) { return r[key]; }),
    borderColor: color, backgroundColor: color + '15',
    borderWidth: 2, tension: 0.3, fill: true, spanGaps: true,
    pointRadius: data.length > 30 ? 0 : 3,
  };
}

var _charts = {};
function renderCharts(data) {
  if (typeof Chart === 'undefined') { window._pendingChart = data; return; }
  var labels = data.map(function(r) { return r.date; });
  var baseOpts = {
    responsive: true,
    interaction: { mode: 'index', intersect: false },
    plugins: {
      legend: { position: 'top', labels: { font: { family: 'Plus Jakarta Sans', size: 12 }, padding: 10 } },
      tooltip: {
        backgroundColor: '#0f1923',
        callbacks: { label: function(c) { return ' ' + c.dataset.label + ': ' + (c.parsed.y != null ? 'US$' + c.parsed.y.toFixed(4) : '–'); } }
      }
    },
    scales: {
      x: { grid: { display: false }, ticks: { font: { family: 'Plus Jakarta Sans', size: 10 }, maxTicksLimit: 10, maxRotation: 0 } },
      y: { grid: { color: '#f1f5f9' }, ticks: { font: { family: 'IBM Plex Mono', size: 10 }, callback: function(v) { return '$' + v.toFixed(2); } } }
    }
  };
  ['chartDry','chartLatex'].forEach(function(id) { if (_charts[id]) { _charts[id].destroy(); } });
  var c1 = document.getElementById('chartDry');
  if (c1) _charts['chartDry'] = new Chart(c1, { type:'line', data: { labels: labels, datasets: [
    ds(data,'SMR20','SMR 20 (Malaysia)','#2563eb'),
    ds(data,'SIR20','SIR 20 (Indonesia)','#d97706'),
    ds(data,'STR20','STR 20 (Thailand)','#16a34a'),
  ]}, options: baseOpts });
  var c2 = document.getElementById('chartLatex');
  if (c2) _charts['chartLatex'] = new Chart(c2, { type:'line', data: { labels: labels, datasets: [
    ds(data,'RSS3','RSS3 Bangkok','#7c3aed'),
    ds(data,'Latex','Latex 60% KL','#0d7377'),
  ]}, options: baseOpts });
}

function buildTable(data) {
  var body = document.getElementById('priceTableBody');
  if (!body) return;
  var html = '';
  data.slice().reverse().forEach(function(r) {
    html += '<tr><td style="font-family:\'IBM Plex Mono\',monospace;font-size:12px">' + r.date + '</td>';
    KEYS.forEach(function(k) {
      var v = r[k];
      html += '<td class="text-right number">' + (v != null ? v.toFixed(4) : '–') + '</td>';
    });
    html += '</tr>';
  });
  body.innerHTML = html;
  document.getElementById('rowCount').textContent = data.length + ' trading days';
}

function show(id, vis) {
  var el = document.getElementById(id);
  if (el) el.style.display = vis ? '' : 'none';
}

function loadPrices(force) {
  var btn = document.getElementById('refreshBtn');
  if (btn) { btn.disabled = true; btn.innerHTML = '<i class="bi bi-arrow-clockwise me-1"></i> Loading…'; }
  show('loadingState', true);
  show('errorState', false);
  show('priceCards', false);
  show('chartsRow', false);
  show('dataTable', false);

  var apiUrl = {{ url_for('api_world_prices')|tojson }} + (force ? '?refresh=1' : '');

  fetch(apiUrl, { cache: force ? 'no-cache' : 'default' })
    .then(function(r) {
      if (!r.ok) throw new Error('HTTP ' + r.status + ' from server');
      return r.json();
    })
    .then(function(res) {
      if (!res.ok) throw new Error(res.error || 'Failed to load prices');
      var data = res.history || [];
      if (!data.length) throw new Error('No price rows found in the source.');

      var latest = data[data.length - 1];
      var prev   = data.length > 1 ? data[data.length - 2] : null;

      KEYS.forEach(function(k) { setCard(k, latest[k], prev ? prev[k] : null); });

      var now = new Date();
      document.getElementById('updatedText').textContent =
        'Data: ' + latest.date + '  ·  Loaded: ' + now.toLocaleTimeString();
      show('updatedLabel', true);

      renderCharts(data);
      buildTable(data);

      show('loadingState', false);
      show('priceCards', true);
      show('chartsRow', true);
      show('dataTable', true);
    })
    .catch(function(err) {
      show('loadingState', false);
      document.getElementById('errorMsg').textContent = err.message;
      show('errorState', true);
    })
    .finally(function() {
      if (btn) { btn.disabled = false; btn.innerHTML = '<i class="bi bi-arrow-clockwise me-1"></i> Refresh'; }
    });
}

document.addEventListener('DOMContentLoaded', function() { loadPrices(false); });
</script>
{% endblock %}