javascript - 使用自定义排序对 html 表按 HH :MM:SS format 中的时间进行排序

Question

我尝试使用 tablesorter 以 HH:MM:SS 格式对时间进行排序。但是我需要一个可自定义的排序来对时间进行分割和排序，即使时间以分钟或秒为单位变化

Answer 1

使用 Javascript 对 HTML 表格进行排序。

HTML:

<table class="table-bordered" border="1">
    <thead>
        <tr class="Headers">
            <th>Number</th>
            <th>Date start
            </th>
            <th>Date end</th>
        </tr>
    </thead>
    <tbody>
        <tr class="Entries" data-id="13">
            <td data-field-type="string">1234</td>
            <td data-field-type="date">01-04-2015</td>
            <td data-field-type="date">01-04-2015</td>
        </tr>
        <tr class="Entries" data-id="24">
            <td data-field-type="string">1352</td>
            <td data-field-type="date">04-10-2012</td>
            <td data-field-type="date">23-10-2015</td>
        </tr>
        <tr class="Entries" data-id="8">
            <td data-field-type="string">1124</td>
            <td data-field-type="date">13-05-2014</td>
            <td data-field-type="date">01-04-2015</td>
        </tr>
        <tr class="Entries" data-id="23">
            <td data-field-type="string">1652</td>
            <td data-field-type="date">07-11-2013</td>
            <td data-field-type="date">22-10-2015</td>
        </tr>
                <tr class="Entries" data-id="23">
            <td data-field-type="string">1652</td>
            <td data-field-type="date">04-12-2013</td>
            <td data-field-type="date">22-10-2015</td>
        </tr>
    </tbody>
</table>

Javascript:

$('tr.Entries').each(function() {
     var $this = $(this),
             t = this.cells[1].textContent.split('-');
     $this.data('_ts', new Date(t[2], t[1]-1, t[0]).getTime());
}).sort(function (a, b) {
    return $(a).data('_ts') > $(b).data('_ts');
}).appendTo('tbody');

Try it here