.ama-mt {
--ama-navy: #0f1d2e;
--ama-text: #1f2d3d;
--ama-muted: #5d6b7a;
--ama-line: #e2e7ed;
--ama-head-bg: #0f1d2e;
--ama-head-text: #ffffff;
--ama-stripe: #f6f8fa;
--ama-hover: #edf2f7;
--ama-link: #002D47;
--ama-head-font: "Montserrat", sans-serif;
--ama-body-font: "Roboto", sans-serif;
max-width: 1240px;
width: 100%;
margin: 0 auto;
color: var(--ama-text);
font-family: inherit;
font-size: 15px;
line-height: 1.5;
}
.ama-mt *, .ama-mt *::before, .ama-mt *::after { box-sizing: border-box; }
/* Search bar */
.ama-mt .ama-mt__bar {
display: flex; flex-wrap: wrap; align-items: center; justify-content: space-between;
gap: 12px; margin: 0 0 16px;
}
.ama-mt .ama-mt__search { position: relative; flex: 1 1 280px; max-width: 420px; margin: 0; }
.ama-mt .ama-mt__search svg {
position: absolute; left: 14px; top: 50%; transform: translateY(-50%);
width: 16px; height: 16px; color: var(--ama-muted); pointer-events: none;
}
.ama-mt .ama-mt__search input {
width: 100%; height: 44px; margin: 0; padding: 0 14px 0 40px;
border: 1px solid var(--ama-line); border-radius: 6px; background: #ffffff;
color: var(--ama-text); font: inherit; font-size: 15px; box-shadow: none;
}
.ama-mt .ama-mt__search input:focus {
outline: none; border-color: var(--ama-navy); box-shadow: 0 0 0 3px rgba(15, 29, 46, 0.12);
}
.ama-mt .ama-mt__count { font-size: 14px; color: var(--ama-muted); }
/* Table */
.ama-mt .ama-mt__wrap {
border: 1px solid var(--ama-line); border-radius: 8px; overflow: hidden; background: #ffffff;
}
.ama-mt .ama-mt__table {
width: 100%; margin: 0; border: 0; border-collapse: collapse; border-spacing: 0;
font-size: 14px; background: transparent;
}
.ama-mt .ama-mt__table th,
.ama-mt .ama-mt__table td {
padding: 14px 16px; border: 0; border-bottom: 1px solid var(--ama-line);
text-align: left; vertical-align: top; background: transparent;
}
.ama-mt .ama-mt__table thead th {
background: var(--ama-head-bg); color: var(--ama-head-text); border-bottom: 0;
font-family: var(--ama-head-font); font-size: 14px; font-weight: 600; white-space: nowrap;
}
.ama-mt .ama-mt__table tbody > tr > td { background: #ffffff; font-family: var(--ama-body-font); font-size: 14px; }
.ama-mt .ama-mt__table tbody > tr:nth-child(even) > td { background: var(--ama-stripe); }
.ama-mt .ama-mt__table tbody > tr:hover > td { background: var(--ama-hover); }
.ama-mt .ama-mt__table tbody > tr:last-child > td { border-bottom: 0; }
.ama-mt .ama-mt__table tbody td:first-child {
color: var(--ama-navy); font-family: var(--ama-body-font); font-weight: 600;
}
.ama-mt .ama-mt__table a {
color: var(--ama-link); text-decoration: none; overflow-wrap: anywhere;
}
.ama-mt .ama-mt__table a:hover { text-decoration: underline; }
/* Sortable headers (reset theme button styles) */
.ama-mt .ama-mt__sort,
.ama-mt .ama-mt__sort:hover,
.ama-mt .ama-mt__sort:focus {
display: inline-flex; align-items: center; gap: 6px; margin: 0; padding: 0;
border: 0; border-radius: 0; background: transparent; box-shadow: none;
color: inherit; font: inherit; letter-spacing: 0; text-transform: none; cursor: pointer;
}
.ama-mt .ama-mt__sort:focus-visible { outline: 2px solid #ffffff; outline-offset: 4px; }
.ama-mt .ama-mt__sort i { font-style: normal; font-size: 11px; opacity: 0.45; }
.ama-mt .ama-mt__sort i::after { content: "\2195"; }
.ama-mt th[aria-sort="ascending"] .ama-mt__sort i,
.ama-mt th[aria-sort="descending"] .ama-mt__sort i { opacity: 1; }
.ama-mt th[aria-sort="ascending"] .ama-mt__sort i::after { content: "\25B2"; }
.ama-mt th[aria-sort="descending"] .ama-mt__sort i::after { content: "\25BC"; }
/* States */
.ama-mt .ama-mt__table td.ama-mt__state {
padding: 32px 16px; text-align: center; color: var(--ama-muted);
font-family: inherit; font-weight: 400;
}
.ama-mt .is-hidden { display: none !important; }
/* Mobile: stacked cards */
@media (max-width: 767px) {
.ama-mt .ama-mt__search { max-width: none; }
.ama-mt .ama-mt__table thead { display: none; }
.ama-mt .ama-mt__table,
.ama-mt .ama-mt__table tbody,
.ama-mt .ama-mt__table tr { display: block; width: 100%; }
.ama-mt .ama-mt__table tbody > tr { padding: 16px; border-bottom: 1px solid var(--ama-line); }
.ama-mt .ama-mt__table tbody > tr:last-child { border-bottom: 0; }
.ama-mt .ama-mt__table tbody > tr:nth-child(even) { background: var(--ama-stripe); }
.ama-mt .ama-mt__table tbody > tr > td,
.ama-mt .ama-mt__table tbody > tr:nth-child(even) > td,
.ama-mt .ama-mt__table tbody > tr:hover > td {
display: grid; grid-template-columns: 110px minmax(0, 1fr); gap: 12px;
padding: 4px 0; border: 0; background: transparent; font-size: 14px;
}
.ama-mt .ama-mt__table tbody td::before {
content: attr(data-label); color: var(--ama-muted); font-weight: 600; font-size: 13px;
}
.ama-mt .ama-mt__table tbody td:first-child {
display: block; padding: 0 0 8px; font-size: 14px;
}
.ama-mt .ama-mt__table tbody td:first-child::before,
.ama-mt .ama-mt__table tbody td.ama-mt__state::before { content: none; }
.ama-mt .ama-mt__table tbody td.is-empty { display: none; }
.ama-mt .ama-mt__table tbody td.ama-mt__state { display: block; padding: 32px 16px; }
}
(function () {
'use strict';
/* ---------- Fetching ---------- */
function parseCSV(text) {
var rows = [], row = [], field = '', inQuotes = false;
text = text.replace(/^\uFEFF/, '');
for (var i = 0; i < text.length; i++) {
var c = text[i];
if (inQuotes) {
if (c === '"') {
if (text[i + 1] === '"') { field += '"'; i++; } else { inQuotes = false; }
} else { field += c; }
} else if (c === '"') { inQuotes = true; }
else if (c === ',') { row.push(field); field = ''; }
else if (c === '\n' || c === '\r') {
if (c === '\r' && text[i + 1] === '\n') i++;
row.push(field); rows.push(row); row = []; field = '';
} else { field += c; }
}
if (field !== '' || row.length) { row.push(field); rows.push(row); }
return rows;
}
function sheetUrl(id, path) {
return 'https://docs.google.com/spreadsheets/d/' + encodeURIComponent(id) + path;
}
// Primary: CSV export (keeps every cell exactly as typed)
function fetchCSV(id, gid) {
return fetch(sheetUrl(id, '/export?format=csv&gid=' + encodeURIComponent(gid)), { cache: 'no-store' })
.then(function (r) { if (!r.ok) throw new Error('CSV request failed (' + r.status + ')'); return r.text(); })
.then(function (t) {
if (/^\s*</.test(t)) throw new Error('CSV returned a web page, not data');
return parseCSV(t);
});
}
// Fallback: Google Visualization endpoint
function fetchGviz(id, gid) {
return fetch(sheetUrl(id, '/gviz/tq?tqx=out:json&headers=1&gid=' + encodeURIComponent(gid)), { cache: 'no-store' })
.then(function (r) { if (!r.ok) throw new Error('gviz request failed (' + r.status + ')'); return r.text(); })
.then(function (t) {
var json = JSON.parse(t.slice(t.indexOf('{'), t.lastIndexOf('}') + 1));
if (json.status === 'error' || !json.table) throw new Error('gviz returned an error');
var headers = json.table.cols.map(function (c) { return c.label || ''; });
var rows = json.table.rows.map(function (r) {
return (r.c || []).map(function (cell) {
if (!cell) return '';
if (cell.f != null) return String(cell.f);
return cell.v != null ? String(cell.v) : '';
});
});
if (!headers.some(Boolean) && rows.length) headers = rows.shift();
return [headers].concat(rows);
});
}
function clean(data, hide) {
data = data
.map(function (r) { return r.map(function (c) { return String(c == null ? '' : c).trim(); }); })
.filter(function (r) { return r.some(Boolean); });
if (!data.length) return { headers: [], rows: [] };
var headers = data[0], rows = data.slice(1);
var width = Math.max.apply(null, data.map(function (r) { return r.length; }));
var keep = [];
for (var i = 0; i < width; i++) {
var h = headers[i] || '';
if (hide.indexOf(h.toLowerCase()) !== -1) continue;
if (!h && !rows.some(function (r) { return r[i]; })) continue;
keep.push(i);
}
return {
headers: keep.map(function (i) { return headers[i] || ''; }),
rows: rows.map(function (r) { return keep.map(function (i) { return r[i] || ''; }); })
};
}
/* ---------- Cell formatting (emails, websites, phone numbers) ---------- */
var EMAIL = /^[^\s@]+@[^\s@]+\.[a-z]{2,}$/i;
var WEB = /^(https?:\/\/)?(www\.)?[a-z0-9-]+(\.[a-z0-9-]+)*\.[a-z]{2,}(:\d+)?(\/\S*)?$/i;
var PHONE = /^\+?[\d\s().-]{7,}$/;
function link(href, text, external) {
var a = document.createElement('a');
a.href = href;
a.textContent = text;
if (external) { a.target = '_blank'; a.rel = 'noopener'; }
return a;
}
function toNode(s) {
var mail = s.replace(/^mailto:/i, '');
if (EMAIL.test(mail)) return link('mailto:' + mail, mail.toLowerCase());
if (WEB.test(s) && s.indexOf('@') === -1) {
var href = /^https?:\/\//i.test(s) ? s : 'https://' + s;
// strip tracking tags such as ?utm_source=…
href = href.replace(/([?&])utm_[^=&#]*=[^&#]*&?/gi, '$1').replace(/[?&]$/, '');
// show the domain only, e.g. www.afrox.co.za
var host = s.replace(/^https?:\/\//i, '').split(/[\/?#]/)[0];
return link(href, host, true);
}
var digits = s.replace(/\D/g, '');
if (PHONE.test(s) && digits.length >= 9 && digits.length <= 15) {
var tidy = s.replace(/^\+\s+/, '+');
return link('tel:' + (tidy.charAt(0) === '+' ? '+' : '') + digits, tidy);
}
return document.createTextNode(s);
}
function fillCell(td, value) {
value.split(/\r?\n/).forEach(function (line) {
line = line.trim();
if (!line) return;
if (td.childNodes.length) td.appendChild(document.createElement('br'));
td.appendChild(toNode(line));
});
}
/* ---------- Widget ---------- */
var collator = new Intl.Collator(undefined, { numeric: true, sensitivity: 'base' });
function init(root) {
if (root.getAttribute('data-ama-ready')) return;
root.setAttribute('data-ama-ready', '1');
var id = root.getAttribute('data-sheet-id');
var gid = root.getAttribute('data-gid') || '0';
var noun = root.getAttribute('data-noun') || 'members';
var refresh = parseFloat(root.getAttribute('data-refresh')) || 0;
var hide = (root.getAttribute('data-hide') || '').split(',')
.map(function (s) { return s.trim().toLowerCase(); }).filter(Boolean);
var input = root.querySelector('.ama-mt__search input');
var count = root.querySelector('.ama-mt__count');
var thead = root.querySelector('thead');
var tbody = root.querySelector('tbody');
var state = { headers: [], rows: [], sortKey: null, sortDir: 0, noMatch: null };
function message(text) {
thead.innerHTML = '';
tbody.innerHTML = '';
var tr = document.createElement('tr');
var td = document.createElement('td');
td.className = 'ama-mt__state';
td.textContent = text;
tr.appendChild(td);
tbody.appendChild(tr);
count.textContent = '';
state.rows = [];
}
function build(data) {
state.headers = data.headers;
thead.innerHTML = '';
tbody.innerHTML = '';
var htr = document.createElement('tr');
data.headers.forEach(function (h, i) {
var th = document.createElement('th');
th.scope = 'col';
var b = document.createElement('button');
b.type = 'button';
b.className = 'ama-mt__sort';
var label = document.createElement('span');
label.textContent = h;
b.appendChild(label);
b.appendChild(document.createElement('i'));
b.addEventListener('click', function () { sortBy(h); });
th.appendChild(b);
htr.appendChild(th);
});
thead.appendChild(htr);
state.rows = data.rows.map(function (cells, index) {
var tr = document.createElement('tr');
cells.forEach(function (v, i) {
var td = document.createElement('td');
td.setAttribute('data-label', data.headers[i]);
if (v) fillCell(td, v); else td.className = 'is-empty';
tr.appendChild(td);
});
tbody.appendChild(tr);
return { cells: cells, index: index, el: tr, text: cells.join(' ').toLowerCase() };
});
var none = document.createElement('tr');
var ntd = document.createElement('td');
ntd.className = 'ama-mt__state';
ntd.colSpan = data.headers.length;
ntd.textContent = 'No ' + noun + ' match your search.';
none.appendChild(ntd);
none.className = 'is-hidden';
tbody.appendChild(none);
state.noMatch = none;
applySort();
applyFilter();
}
function sortBy(key) {
if (state.sortKey === key) {
state.sortDir = state.sortDir === 1 ? -1 : state.sortDir === -1 ? 0 : 1;
} else {
state.sortKey = key;
state.sortDir = 1;
}
applySort();
}
function applySort() {
var col = state.sortDir ? state.headers.indexOf(state.sortKey) : -1;
var ths = thead.querySelectorAll('th');
for (var i = 0; i 0 || !state.rows.length);
var total = state.rows.length;
count.textContent = terms.length ? shown + ' of ' + total + ' ' + noun : total + ' ' + noun;
}
function load(silent) {
return fetchCSV(id, gid)
.catch(function (err) {
console.warn('[AMA table] CSV feed unavailable, trying fallback.', err);
return fetchGviz(id, gid);
})
.then(function (raw) {
var data = clean(raw, hide);
if (!data.headers.length || !data.rows.length) { message('No ' + noun + ' listed yet.'); return; }
build(data);
})
.catch(function (err) {
console.error('[AMA table] Could not load the Google Sheet. Check that it is shared as "Anyone with the link – Viewer".', err);
if (!silent) message('The ' + noun + ' list could not be loaded. Please try again later.');
});
}
input.addEventListener('input', applyFilter);
load(false);
if (refresh > 0) {
setInterval(function () {
if (document.visibilityState === 'visible') load(true);
}, refresh * 60000);
}
}
function boot() {
var roots = document.querySelectorAll('.ama-mt[data-sheet-id]');
for (var i = 0; i < roots.length; i++) init(roots[i]);
}
if (document.readyState === 'loading') document.addEventListener('DOMContentLoaded', boot);
else boot();
})();