表格排序看似簡單,真正做起來卻滿是細節:欄位可能是文字、金額或日期;日期格式千變萬化;同一欄裡還可能夾著幾筆格式不統一的資料。市面上不少外掛為了解決這件事,要求每一格都補上 sort 屬性,實在算不上優雅。以下這套實作可以自動判斷欄位型別、支援多種日期寫法,也允許個別儲存格用 sort 屬性覆寫,並且不限於 table——任何「父元素 + 子元素階層」都能排序。
AddSortToTables():讓所有 class 含 sortIt 的表格,其表頭變成可點擊排序。SortTable(tbl, col):直接依指定欄位索引排序。AddSortByDate(tbl, col, dateMask):宣告某欄為日期,並給定日期格式如 'dd-mmm-yy'。AddSortByNumber(tbl, col):宣告某欄為數字,會忽略非數字字元,小數點以 . 計。另外還有 SortElements(parentEl, childTag, colTag, colIndex) 與 AddSortByDate2 / AddSortByNumber2,用來排序非表格的階層結構,例如一個 DIV 裡裝了若干 P 段落、每個段落內又有 SPAN 存價格。
var MonthNames = ["January","February","March","April","May","June",
"July","August","September","October","November","December"];
var DayNames = ["Sunday","Monday","Tueday","Wednesday","Thursday","Friday","Saturday"];
var ShortMths = ["Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"];
var ShortDays = ["Sun","Mon","Tue","Wed","Thu","Fri","Sat"];
var AddEvent = function (elem, eventType, func) {
if (elem.addEventListener) {
AddEvent = function (elem, eventType, func) { elem.addEventListener(eventType, func, false); };
} else if (elem.attachEvent) {
AddEvent = function (elem, eventType, func) { elem.attachEvent('on' + eventType, func); };
} else {
AddEvent = function (elem, eventType, func) { elem['on' + eventType] = func; };
}
AddEvent(elem, eventType, func);
};
var SortTable = function (tbl, col) {
SortElements(tbl, 'tr', 'td', col);
};
var SortElements = function (parentEl, childTag, colTag, colIndex) {
// 例:SortElements('table1','tr','td',2)
// SortElements('list1','li')
// SortElements('divName','p','span',3)
var i, j, cTags = {}, startAt = 0, childLen, aChild, elem,
sortBy, content, elems = [], sortedLen, frag;
var parent = (typeof parentEl === 'string') ? document.getElementById(parentEl) : parentEl;
// 四種比較器
var AscText = function (a, b) {
var x = a.data, y = b.data, xNum = parseFloat(x), yNum = parseFloat(y);
if (!isNaN(xNum) && !isNaN(yNum) && (xNum - yNum)) return xNum - yNum;
return ((x < y) ? -1 : ((x > y) ? 1 : 0));
};
var DescText = function (a, b) {
var x = a.data, y = b.data, xNum = parseFloat(x), yNum = parseFloat(y);
if (!isNaN(xNum) && !isNaN(yNum) && (yNum - xNum)) return yNum - xNum;
return ((x > y) ? -1 : ((x < y) ? 1 : 0));
};
var AscNum = function (a, b) { return a.data - b.data; }; // 日期也共用
var DescNum = function (a, b) { return b.data - a.data; };
// 若是 table,先推斷排序依據並跳過表頭列
if (parent.nodeName.toLowerCase() == 'table') {
if (childTag == 'tr') {
sortBy = parent.rows[0].cells[colIndex].sortBy || 'text';
}
parent = parent.tBodies[0] || parent;
if (parent.rows[0].cells[0].nodeName.toLowerCase() == 'th') startAt = 1;
}
cTags = parent.getElementsByTagName(childTag);
if (typeof colIndex == 'undefined') sortBy = 'text'; // 清單、段落當文字排
// 收集每一列要排序的內容
for (i = startAt, childLen = cTags.length; i < childLen; i++) {
aChild = cTags[i];
elem = (colTag) ? aChild.getElementsByTagName(colTag)[colIndex] : aChild;
if (elem) {
if (!sortBy) {
sortBy = (typeof elem.numberValue != 'undefined') ? 'number'
: ((typeof elem.dateValue != 'undefined') ? 'date' : 'text');
}
switch (sortBy) {
// 可用 <td sort='2011/02/12'> 覆寫單格排序依據
case 'text': content = (elem.getAttribute('sort') || elem.firstChild.nodeValue).toLowerCase(); break;
case 'number': content = elem.numberValue; break;
case 'date': content = elem.dateValue; break;
default: content = (elem.getAttribute('sort') || elem.firstChild.nodeValue).toLowerCase();
}
j = elems.length;
if (!aChild.id) aChild.id = 'tempSortID' + j;
elems[j] = { data: content, tempID: aChild.id };
}
}
// 記住上一次的排序狀態,同一欄再點一次就反轉方向
if (typeof colIndex == 'undefined') colIndex = 0;
if (parent.prevTag && parent.prevTag == ((typeof colTag == 'undefined') ? childTag : colTag)) {
if (parent.prevCol == colIndex) {
parent.prevSort = (parent.prevSort == 'asc') ? 'desc' : 'asc';
} else {
parent.prevCol = colIndex; parent.prevSort = 'asc';
}
} else {
parent.prevTag = ((typeof colTag == 'undefined') ? childTag : colTag);
parent.prevCol = colIndex; parent.prevSort = 'asc';
}
var fn = parent.prevSort === 'desc'
? { text: DescText, number: DescNum, date: DescNum }
: { text: AscText, number: AscNum, date: AscNum };
elems.sort(fn[sortBy] || fn.text);
// 用 DocumentFragment 一次搬回去,避免逐個 append 觸發多次重排
frag = document.createDocumentFragment();
for (i = 0, sortedLen = elems.length; i < sortedLen; i++) {
elem = document.getElementById(elems[i].tempID);
frag.appendChild(elem);
if ((elem.id).substr(0, 10) == 'tempSortID') elem.removeAttribute('id');
}
parent.appendChild(frag);
elems = null;
return parent.prevSort;
};
var AddSortToTables = function () {
var tables = document.getElementsByTagName('table'), i, j, tblLen, tbl, hdrs, hdrsLen;
// 用閉包把參數固定下來,避免迴圈變數共用
function PreserveSortScope(a, b, c, d) {
return function () { SortElements(a, b, c, d); };
}
for (i = 0, tblLen = tables.length; i < tblLen; i++) {
tbl = tables[i];
if (tbl.className.indexOf('sortIt') + 1) {
hdrs = tbl.getElementsByTagName('th');
if (hdrs) {
for (j = 0, hdrsLen = hdrs.length; j < hdrsLen; j++) {
AddEvent(hdrs[j], 'click', PreserveSortScope(tbl, 'tr', 'td', j));
if (!hdrs[j].title) hdrs[j].setAttribute('title', 'Click to sort');
}
}
}
}
};
/** 宣告某欄為日期,dateMask 如 'dd-mmm-yy' */
var AddSortByDate = function (tbl, col, dateMask) {
while (col.length) AddSortByDate(tbl, col.pop()); // 支援傳入陣列
if ((col instanceof Array) || isNaN(col)) return;
var tbl = (typeof tbl === 'string') ? document.getElementById(tbl) : tbl;
tbl.rows[0].cells[col].sortBy = 'date';
AddSortByDate2(tbl, 'tr', 'td', col, dateMask);
};
var AddSortByDate2 = function (parentEl, childTag, colTag, colIndex, dateMask) {
var kids, startAt = 0, i, rLen, cell;
var parent = (typeof parentEl === 'string') ? document.getElementById(parentEl) : parentEl;
if (parent.nodeName.toLowerCase() == 'table') {
parent = parent.tBodies[0] || parent;
startAt = (parent.rows[0].cells[0].nodeName.toLowerCase() == 'th') * 1;
}
kids = parent.getElementsByTagName(childTag);
for (i = startAt, rLen = kids.length; i < rLen; i++) {
cell = kids[i].getElementsByTagName(colTag)[colIndex];
if (cell) {
// 切換排序依據時先清掉舊的暫存屬性
if (typeof cell.numberValue != 'undefined') delete cell.numberValue;
if (cell.getAttribute('sort')) {
cell.dateValue = new Date(cell.getAttribute('sort'));
} else {
cell.dateValue = new Date(StringToDate(cell.firstChild.nodeValue, dateMask));
}
if (cell.dateValue.toString() == "NaN" || cell.dateValue.toString() == "Invalid Date") {
cell.dateValue = 0;
}
}
}
};
/** 宣告某欄為數字 */
var AddSortByNumber = function (tbl, col) {
while (col.length) AddSortByNumber(tbl, col.pop());
if ((col instanceof Array) || isNaN(col)) return;
tbl = (typeof tbl === 'string') ? document.getElementById(tbl) : tbl;
tbl.rows[0].cells[col].sortBy = 'number';
AddSortByNumber2(tbl, 'tr', 'td', col);
};
var AddSortByNumber2 = function (parentEl, childTag, colTag, colIndex) {
var kids, startAt = 0, i, rLen, cell, tempNum;
var parent = (typeof parentEl === 'string') ? document.getElementById(parentEl) : parentEl;
if (parent.nodeName.toLowerCase() == 'table') {
parent = parent.tBodies[0] || parent;
startAt = (parent.rows[0].cells[0].nodeName.toLowerCase() == 'th') * 1;
}
kids = parent.getElementsByTagName(childTag);
for (i = startAt, rLen = kids.length; i < rLen; i++) {
cell = kids[i].getElementsByTagName(colTag)[colIndex];
if (cell) {
if (typeof cell.dateValue != 'undefined') delete cell.dateValue;
tempNum = cell.getAttribute('sort') || cell.firstChild.nodeValue;
tempNum = tempNum.replace(/[^0-9.-]/g, ''); // 只留數字、小數點與負號
cell.numberValue = parseFloat(tempNum);
if (isNaN(cell.numberValue)) cell.numberValue = 0.0;
}
}
};
這是整套程式最複雜的一塊,負責把 'dd-mmm-yy'、'mm/dd/yyyy' 這類格式轉成 'YYYY/MM/DD'。要點是:先把英文月分(March / Mar)與星期(Tuesday / Tue)替換成數字或移除,再把單一的 D、M 補成 DD、MM,處理二位數年份的 cutoff,最後依 mask 逐段取出組裝;若 mask 出現 DMM、MDD 這類無法判定的組合就直接放棄解析。
var StringToDate = function (sDate, sFormat, cutOff) {
var sParsed, fndSingle;
sDate = sDate.toString().toUpperCase();
sFormat = sFormat.toUpperCase();
// 1. Mar / March → 03
if (sFormat.search(/MMMM|MMM/) + 1) {
sDate = sDate.replace(new RegExp('(' + ShortMths.join('|') + ')[A-Z]*', 'gi'), function (m) {
var i = ShortMths.indexOf(m.charAt(0).toUpperCase() + m.substr(1, 2).toLowerCase()) + 1;
return ((i < 10) ? "0" + i : "" + i).toString();
});
sFormat = sFormat.replace(/MMMM|MMM/g, 'MM');
}
// 2. Tue / Tuesday → 移除
if (sFormat.search(/DDDD|DDD/) + 1) {
sDate = sDate.replace(new RegExp('(' + ShortDays.join('|') + ')[A-Z]*', 'gi'), '');
sFormat = sFormat.replace(/DDDD|DDD/g, '');
}
// 3. 單數字補零、單一 D/M 補成 DD/MM
sDate = sDate.replace(/(^|\D)(\d)(?=\D|$)/g, function ($0, $1, $2) { return $1 + '0' + $2; });
sFormat = sFormat.replace(/(^|[^DMY])(D|M)(?=[^DMY]|$)/g, function ($0, $1, $2) { return $1 + $2 + $2; });
// 仍有單一 D 或 M(如 DMM)→ 不處理
fndSingle = sFormat.search(/(^|[^D])D([^D]|$)|(^|[^M])M([^M]|$)/) + 1;
if (fndSingle) return '';
// 4. 二位數年份依 cutOff 補成四位
sFormat = sFormat.replace(/(^|[^Y])(YY)(?=[^Y]|$)/g, function ($0, $1, $2, index) {
var tempDate = sDate.substr(0, index + 1);
tempDate += (cutOff)
? ((parseInt(sDate.substr(index + 1, 2), 10) > cutOff) ? '19' : '20')
: '20';
tempDate += sDate.substr(index + 1);
sDate = tempDate;
return $1 + $2 + $2;
});
// 5. 依 mask 取出 YYYY / MM / DD
sParsed = ('YYYY/MM/DD').replace(/YYYY|MM|DD/g, function (m) {
return (sFormat.indexOf(m) + 1) ? sDate.substr(sFormat.indexOf(m), m.length) : '';
});
if (sParsed.charAt(0) == '/') sParsed = (new Date().getFullYear()) + sParsed; // 無年份→今年
if (sParsed.charAt(sParsed.length - 1) == '/') sParsed += '01'; // 無日期→1 號
return (sParsed.length == 10) ? sParsed : '';
};
用暫存屬性記錄型別。把 numberValue / dateValue 直接掛在儲存格物件上,排序時就不必反覆解析字串;切換排序依據時再 delete 掉舊屬性即可。
prevSort 記在父元素上。同一欄連點兩次自動在升冪與降冪之間切換,換欄則重置為升冪,這個狀態放在 parent 上,多個表格互不干擾。
DocumentFragment 一次搬移。排序後逐個 appendChild 會觸發大量重排,先塞進 fragment 再一次掛回,只重排一次。
閉包固定迴圈變數。PreserveSortScope 這個小技巧避免了經典的「迴圈變數全部指向同一個值」問題。
現代的話,這些需求都可以交給瀏覽器原生的 Intl.Collator(處理多語言排序)與 Intl.DateTimeFormat(解析與格式化日期)來做,程式碼量能少掉一大半,也更不容易出錯。但這套實作在「任意階層元素皆可排序」與「個別儲存格覆寫」這兩點上的思路,仍然值得參考。