Shows Last Swiss / Last rehab from a PublicView CSV on the Employees page.
// ==UserScript==
// @name Torn – Last Rehab & Last Swiss (PublicView CSV • row under header)
// @namespace http://tampermonkey.net/
// @version 1.6
// @description Shows Last Swiss / Last rehab from a PublicView CSV on the Employees page.
// @match https://www.torn.com/companies.php*
// @run-at document-idle
// @license MIT
// @grant none
// ==/UserScript==
(function () {
'use strict';
const LS_URL = 'tm_torn_public_csv_url_v1';
const LS_CACHE = 'tm_torn_public_cache_v1';
const CACHE_TTL_MS = 30 * 60 * 1000;
let cache = loadCache();
let fetchInFlight = null;
const EMP_LIST_SEL = '#employees form .employee-list-wrap ul.employee-list.t-blue-cont.h';
const isEmployeesRoute = () =>
location.pathname === '/companies.php' &&
/(^|#|&|\?)option=employees\b/i.test(location.href);
mountCsvAndRefreshButtons();
startOnce();
window.addEventListener('load', () => {
if (isEmployeesRoute()) renderAllEmployees(true);
});
window.addEventListener('hashchange', () => {
if (isEmployeesRoute()) startOnce();
});
async function startOnce() {
if (!isEmployeesRoute()) return;
await waitFor(() => document.querySelector(EMP_LIST_SEL), 10000, 250);
renderAllEmployees(true).catch(() => {});
}
async function renderAllEmployees(force = false) {
const url = getCsvUrl();
if (!url) return;
await ensureData(url, force);
document
.querySelectorAll(`${EMP_LIST_SEL} > li[data-user]`)
.forEach(injectLeftMeta);
}
function injectLeftMeta(liEl) {
const leftCell = liEl.querySelector(':scope > .acc-header .employee');
if (!leftCell) return;
leftCell.style.overflow = 'visible';
leftCell.style.height = 'auto';
leftCell.style.maxHeight = 'none';
leftCell.style.minHeight = '40px';
const header = liEl.querySelector(':scope > .acc-header');
if (header) { header.style.height = 'auto'; header.style.minHeight = '40px'; }
const id = liEl.getAttribute('data-user');
const name = leftCell.querySelector('.honor-text')?.textContent?.trim() || '';
const rec = lookup(id ? { id } : { id: null, name });
let meta = leftCell.querySelector(':scope > .tm-left-meta');
if (!meta) {
meta = document.createElement('div');
meta.className = 'tm-left-meta';
const anchor = leftCell.querySelector('a.user.name') || leftCell.lastElementChild;
anchor?.insertAdjacentElement('afterend', meta);
Object.assign(meta.style, {
marginTop: '3px',
fontSize: '12px',
fontFamily: 'Arial, sans-serif',
fontWeight: '400',
lineHeight: '16px',
color: 'rgb(221, 221, 221)',
whiteSpace: 'normal',
wordBreak: 'break-word',
pointerEvents: 'none',
});
}
const isUnknown = v => !v || /unknown/i.test(v);
const swissTxt = (rec && !isUnknown(rec.last_swiss)) ? tornRelative(rec.last_swiss) : 'Unknown';
const rehabTxt = (rec && !isUnknown(rec.last_rehab)) ? tornRelative(rec.last_rehab) : 'Unknown';
meta.innerHTML = `Swiss: ${swissTxt}<br>Rehab: ${rehabTxt}`;
}
async function ensureData(url, force = false) {
const now = Date.now();
if (!force && (now - cache.lastFetch < CACHE_TTL_MS)) return;
if (fetchInFlight) return fetchInFlight;
fetchInFlight = (async () => {
let reqUrl = url;
if (force) {
try { const u = new URL(url); u.searchParams.set('tmcb', String(Date.now())); reqUrl = u.toString(); }
catch { reqUrl = url + (url.includes('?') ? '&' : '?') + 'tmcb=' + Date.now(); }
}
const res = await fetch(reqUrl, { method: 'GET', cache: 'no-store', credentials: 'omit', redirect: 'follow' });
if (!res.ok) throw new Error('CSV fetch failed ' + res.status);
const csv = await res.text();
const rows = parseCsv(csv);
if (!rows.length) return;
const header = rows.shift().map(s => (s || '').trim().toLowerCase());
const ci = { id: header.indexOf('id'), name: header.indexOf('name'), swiss: header.indexOf('last_swiss'), rehab: header.indexOf('last_rehab') };
['id','name','swiss','rehab'].forEach(k => { if (ci[k] < 0) throw new Error('Missing column: ' + k); });
const byId = Object.create(null), byName = Object.create(null), byNameNorm = Object.create(null);
for (const r of rows) {
const id = ((r[ci.id] ?? '') + '').trim();
const name = ((r[ci.name] ?? '') + '').trim();
const last_swiss = ((r[ci.swiss] ?? '') + '').trim();
const last_rehab = ((r[ci.rehab] ?? '') + '').trim();
const obj = { id, name, last_swiss, last_rehab };
if (id) byId[id] = obj;
if (name) { byName[name.toLowerCase()] = obj; byNameNorm[normalizeName(name)] = obj; }
}
cache = { byId, byName, byNameNorm, lastFetch: now };
saveCache();
})().finally(() => { fetchInFlight = null; });
return fetchInFlight;
}
function lookup(ref) {
if (ref.id && cache.byId?.[ref.id]) return cache.byId[ref.id];
if (ref.name) {
const n = ref.name.toLowerCase();
if (cache.byName?.[n]) return cache.byName[n];
const nn = normalizeName(ref.name);
if (cache.byNameNorm?.[nn]) return cache.byNameNorm[nn];
}
return null;
}
function mountCsvAndRefreshButtons() {
const attach = () => {
const heading = document.querySelector('.title-black.top-round.m-top10[role="heading"][aria-level="5"]');
if (!heading) return;
let chip = heading.querySelector('.tm-csv-chip');
if (!chip) {
chip = document.createElement('button');
chip.className = 'tm-csv-chip';
chip.title = 'Paste your PublicView → CSV link';
Object.assign(chip.style, {
marginLeft: '8px', padding: '2px 8px', font: '12px/1 system-ui, Arial, sans-serif',
border: '0', borderRadius: '999px', cursor: 'pointer', verticalAlign: 'middle', color: '#fff',
});
heading.appendChild(chip);
chip.addEventListener('click', async () => {
await promptForUrl();
const ok = !!getCsvUrl();
chip.textContent = ok ? 'CSV: Set' : 'CSV: Missing';
chip.style.background = ok ? '#2e7d32' : '#c62828';
if (isEmployeesRoute()) renderAllEmployees(true);
document.dispatchEvent(new CustomEvent('tm:csv-updated'));
});
}
const ok = !!getCsvUrl();
chip.textContent = ok ? 'CSV: Set' : 'CSV: Missing';
chip.style.background = ok ? '#2e7d32' : '#c62828';
let refresh = heading.querySelector('.tm-csv-refresh');
if (!refresh) {
refresh = document.createElement('button');
refresh.className = 'tm-csv-refresh';
refresh.textContent = '↻ Refresh';
Object.assign(refresh.style, {
marginLeft: '6px', padding: '2px 8px', font: '12px/1 system-ui, Arial, sans-serif',
border: '0', borderRadius: '999px', cursor: 'pointer', verticalAlign: 'middle',
background: '#424a57', color: '#fff',
});
refresh.addEventListener('click', async () => {
const old = refresh.textContent; refresh.textContent = 'Refreshing…'; refresh.disabled = true;
try { await renderAllEmployees(true); } finally { refresh.textContent = old; refresh.disabled = false; }
});
heading.appendChild(refresh);
}
};
attach();
waitFor(() => document.querySelector('.title-black.top-round.m-top10[role="heading"][aria-level="5"]'), 8000, 250)
.then(attach).catch(() => {});
}
async function promptForUrl() {
const wrap = document.createElement('div');
wrap.style.cssText = 'position:fixed;inset:0;z-index:100000;background:rgba(0,0,0,.55);display:flex;align-items:center;justify-content:center;padding:16px;';
wrap.innerHTML = `
<div style="background:#fff;border-radius:10px;max-width:520px;width:100%;padding:14px;font:14px/1.4 system-ui, Arial">
<div style="font-weight:700;margin-bottom:8px">Paste your <i>PublicView → CSV</i> link</div>
<div style="color:#555;margin-bottom:8px">From your sheet: <b>File → Share → Publish to web → Sheet: PublicView → Format: CSV</b></div>
<input id="tm_csv_inp" placeholder="https://docs.google.com/.../pub?gid=...&single=true&output=csv" inputmode="url"
style="width:100%;padding:10px 12px;border:1px solid #ccc;border-radius:8px;font:14px/1.4 system-ui, Arial;" />
<div style="margin-top:10px;display:flex;gap:8px;justify-content:flex-end">
<button id="tm_csv_cancel" style="padding:8px 10px;border:0;border-radius:8px;background:#eee;cursor:pointer">Cancel</button>
<button id="tm_csv_save" style="padding:8px 12px;border:0;border-radius:8px;background:#1976d2;color:#fff;cursor:pointer">Save</button>
</div>
</div>`;
document.body.appendChild(wrap);
const inp = wrap.querySelector('#tm_csv_inp');
inp.value = getCsvUrl() || '';
const close = () => wrap.remove();
wrap.querySelector('#tm_csv_cancel').addEventListener('click', close);
wrap.querySelector('#tm_csv_save').addEventListener('click', async () => {
const raw = (inp.value || '').trim();
if (!raw) return;
const url = canonCsvUrl(raw);
if (!url) return;
try { const head = await fetch(url, { method:'GET', cache:'no-store', credentials:'omit' }); if (!head.ok) throw 0; }
catch { return; }
localStorage.setItem(LS_URL, url);
close();
});
setTimeout(() => inp.focus(), 50);
}
// Helpers
function waitFor(pred, timeoutMs=5000, intervalMs=200){
return new Promise((resolve, reject)=>{
const t0 = Date.now();
(function tick(){
try { const v = pred(); if (v) return resolve(v); } catch {}
if (Date.now() - t0 >= timeoutMs) return reject(new Error('timeout'));
setTimeout(tick, intervalMs);
})();
});
}
function getCsvUrl(){ return localStorage.getItem(LS_URL) || ''; }
function canonCsvUrl(u){
try{
const url = new URL(u);
if (/docs\.google\.com\/spreadsheets\/d\/.+\/pub/.test(url.href) && url.searchParams.get('output')==='csv') return url.href;
if (/docs\.google\.com\/spreadsheets\/d\/.+\/gviz\/tq/.test(url.href)) { const tqx = url.searchParams.get('tqx') || ''; if (/out:csv/i.test(tqx)) return url.href; }
if (url.protocol==='https:' && /csv\b/i.test(url.search)) return url.href;
return '';
} catch { return ''; }
}
function loadCache(){ try{ return JSON.parse(localStorage.getItem(LS_CACHE)) || {byId:{},byName:{},byNameNorm:{},lastFetch:0}; } catch { return {byId:{},byName:{},byNameNorm:{},lastFetch:0}; } }
function saveCache(){ try{ localStorage.setItem(LS_CACHE, JSON.stringify(cache)); } catch {} }
function normalizeName(s){ if(!s)return''; let t=s.normalize('NFKC'); t=t.replace(/[\u{1F3FB}-\u{1F3FF}]/gu,''); t=t.replace(/\[[^\]]*\]|\([^\)]*\)/g,''); t=t.replace(/\s+/g,' ').trim(); return t.toLowerCase(); }
function parseCsv(text){ const rows=[]; let row=[],cur='',inQ=false; for(let i=0;i<text.length;i++){ const c=text[i]; if(inQ){ if(c==='"'){ if(text[i+1]==='"'){cur+='"'; i++;} else inQ=false; } else cur+=c; } else { if(c==='"') inQ=true; else if(c===','){ row.push(cur); cur=''; } else if(c==='\n'){ row.push(cur); rows.push(row); row=[]; cur=''; } else if(c!=='\r') cur+=c; } } if(cur.length||row.length){ row.push(cur); rows.push(row); } return rows; }
// Torn date helpers
function parseTornDate(str){
const m = String(str).match(/(\d{2}):(\d{2}):(\d{2})\s*-\s*(\d{2})\/(\d{2})\/(\d{2})/);
if (!m) return null;
const [, hh, mm, ss, dd, MM, yy] = m;
const year = 2000 + (+yy);
return new Date(year, (+MM)-1, (+dd), (+hh), (+mm), (+ss));
}
function tornRelative(str){
const d = parseTornDate(str);
if (!d) return String(str);
const diff = Date.now() - d.getTime();
if (diff < 0) return String(str);
const mins = Math.floor(diff/60000);
if (mins < 60) return `${str} (${mins}m ago)`;
const hours = Math.floor(mins/60);
if (hours < 48) return `${str} (${hours}h ago)`;
const days = Math.floor(hours/24);
return `${str} (${days}d ago)`;
}
})();