X-Git-Url: http://git.shiar.nl/sheet.git/blobdiff_plain/217c6fda0be7b212d58da7c9edaba58dbe6d788c..d438b00d58e237164a949c7b53972131926afd18:/searchlocal.js diff --git a/searchlocal.js b/searchlocal.js index 8741044..5d7493b 100644 --- a/searchlocal.js +++ b/searchlocal.js @@ -26,6 +26,26 @@ function filtercell(el, set, action) { } } +function filtercols(table, match, action) { + var matchloc; + for (var y = 0; y < table.rows.length; y++) { + var loc = 0; + for (var x = 0; x < table.rows[y].cells.length; x++) { + var cell = table.rows[y].cells[x]; + if (y == 0) { + if (match(cell)) { + if (!matchloc) matchloc = [loc]; + matchloc[1] = loc + cell.colSpan; + filtercell(table.children.item(x+2), true, action); // colgroup + } + } + var keep = matchloc && loc >= matchloc[0] && loc < matchloc[1]; + filtercell(cell, keep, action); + loc += cell.colSpan; + } + } +} + function filterrows(table, match, action) { var rows = table.tBodies[0].rows; for (var i = 0; i < rows.length; i++) { @@ -47,12 +67,33 @@ function filtertable(query, action) { query = match[2]; } + if (query == '' && action == 'add') { + // restore all columns if explicitly adding all ("+") + filtercols(table, function(){return true}, 'add'); + // continue to restore rows + } + if (/^[a-z_]+$/.test(query) && document.querySelector('.b-a-'+query)) { + // column if class b-a-* exists + var match = function(th) { + return new RegExp('-'+query+'\\b').test(th.className); + } + return filtercols(table, match, action || 'toggle'); + } + if (/^[A-Z0-9 ]{2,}$/.test(query)) { // category title if all uppercase var match = function(row) { return row.cells[0].title.match(query, 'i'); }; } + else if (numquery = /^([<>])(\d+)$/.exec(query)) { + // support percentage if numeric comparison + var match = function(row) { + var pct = row.cells[row.cells.length - 1].textContent; + pct -= numquery[2]; // compare to query + return numquery[1] == '<' ? pct < 0 : pct >= 0; + }; + } else if (action == 'focus' && query.length <= 1) { // prevent superfluous highlighting var match = false;