jQuery table sort

问题:

I have a very simple HTML table with 4 columns:

Facility Name, Phone #, City, Specialty

I want the user to be able to sort by Facility name, and City only.

How can I code this using jQuery?

回答1:

If you want to avoid all the bells and whistles then may I suggest this simple sortElements plugin. Usage:

var table = $(\'table\');

$(\'.sortable th\')
    .wrapInner(\'<span title=\"sort this column\"/>\')
    .each(function(){

        var th = $(this),
            thIndex = th.index(),
            inverse = false;

        th.click(function(){

            table.find(\'td\').filter(function(){

                return $(this).index() === thIndex;

            }).sortElements(function(a, b){

                if( $.text([a]) == $.text([b]) )
                    return 0;

                return $.text([a]) > $.text([b]) ?
                    inverse ? -1 : 1
                    : inverse ? 1 : -1;

            }, function(){

                // parentNode is the element we want to move
                return this.parentNode; 

            });

            inverse = !inverse;

        });

    });

And a demo. (click the \"city\" and \"facility\" column-headers to sort)

回答2:

I came across this, and thought I\'d throw in my 2 cents. Click on the column headers to sort ascending, and again to sort descending.

• Works in Chrome, Firefox, Opera AND IE(8)
• Only uses JQuery
• Does alpha and numeric sorting - ascending and descending

$(\'th\').click(function(){
    var table = $(this).parents(\'table\').eq(0)
    var rows = table.find(\'tr:gt(0)\').toArray().sort(comparer($(this).index()))
    this.asc = !this.asc
    if (!this.asc){rows = rows.reverse()}
    for (var i = 0; i < rows.length; i++){table.append(rows[i])}
})
function comparer(index) {
    return function(a, b) {
        var valA = getCellValue(a, index), valB = getCellValue(b, index)
        return $.isNumeric(valA) && $.isNumeric(valB) ? valA - valB : valA.toString().localeCompare(valB)
    }
}
function getCellValue(row, index){ return $(row).children(\'td\').eq(index).text() }

table, th, td {
    border: 1px solid black;
}
th {
    cursor: pointer;
}

<script src=\"https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js\"></script>
<table>
    <tr><th>Country</th><th>Date</th><th>Size</th></tr>
    <tr><td>France</td><td>2001-01-01</td><td>25</td></tr>
    <tr><td><a href=#>spain</a></td><td>2005-05-05</td><td></td></tr>
    <tr><td>Lebanon</td><td>2002-02-02</td><td>-17</td></tr>
    <tr><td>Argentina</td><td>2005-04-04</td><td>100</td></tr>
    <tr><td>USA</td><td></td><td>-6</td></tr>
</table>

** Update: 2018

• For those that are interested, I\'ve provided an ES6 Plain Javascript solution here.

回答3:

By far, the easiest one I\'ve used is: http://datatables.net/

Amazingly simple...just make sure if you go the DOM replacement route (IE, building a table and letting DataTables reformat it) then make sure to format your table with <thead> and <tbody> or it won\'t work. That\'s about the only gotcha.

There\'s also support for AJAX, etc. As with all really good pieces of code, it\'s also VERY easy to turn it all off. You\'d be suprised what you might use, though. I started with a \"bare\" DataTable that only sorted one field and then realized that some of the features were really relevant to what I\'m doing. Clients LOVE the new features.

Bonus points to DataTables for full ThemeRoller support....

I\'ve also had ok luck with tablesorter, but it\'s not nearly as easy, not quite as well documented, and has only ok features.

回答4:

We just started using this slick tool: https://plugins.jquery.com/tablesorter/

There is a video on its use at: http://www.highoncoding.com/Articles/695_Sorting_GridView_Using_JQuery_TableSorter_Plug_in.aspx

    $(\'#tableRoster\').tablesorter({
        headers: {
            0: { sorter: false },
            4: { sorter: false }
        }
    });

With a simple table

<table id=\"tableRoster\">
        <thead> 
                  <tr>
                    <th><input type=\"checkbox\" class=\"rCheckBox\" value=\"all\" id=\"rAll\" ></th>
                    <th>User</th>
                    <th>Verified</th>
                    <th>Recently Accessed</th>
                    <th>&nbsp;</th>
                  </tr>
        </thead>

回答5:

My answer would be \"be careful\". A lot of jQuery table-sorting add-ons only sort what you pass to the browser. In many cases, you have to keep in mind that tables are dynamic sets of data, and could potentially contain zillions of lines of data.

You do mention that you only have 4 columns, but much more importantly, you don\'t mention how many rows we\'re talking about here.

If you pass 5000 lines to the browser from the database, knowing that the actual database-table contains 100,000 rows, my question is: what\'s the point in making the table sortable? In order to do a proper sort, you\'d have to send the query back to the database, and let the database (a tool actually designed to sort data) do the sorting for you.

In direct answer to your question though, the best sorting add-on I\'ve come across is Ingrid. There are many reasons that I don\'t like this add-on (\"unnecessary bells and whistles...\" as you call it), but one of it\'s best features in terms of sort, is that it uses ajax, and doesn\'t assume that you\'ve already passed it all the data before it does its sort.

I recognise that this answer is probably overkill (and over 2 years late) for your requirements, but I do get annoyed when developers in my field overlook this point. So I hope someone else picks up on it.

I feel better now.

回答6:

I love this accepted answer, however, rarely do you get requirements to sort html and not have to add icons indicating the sorting direction. I took the accept answer\'s usage example and fixed that quickly by simply adding bootstrap to my project, and adding the following code:

<div></div>

inside each <th> so that you have a place to set the icon.

setIcon(this, inverse);

from the accepted answer\'s Usage, below the line:

th.click(function () {

and by adding the setIcon method:

function setIcon(element, inverse) {

        var iconSpan = $(element).find(\'div\');

        if (inverse == false) {
            $(iconSpan).removeClass();
            $(iconSpan).addClass(\'icon-white icon-arrow-up\');
        } else {
            $(iconSpan).removeClass();
            $(iconSpan).addClass(\'icon-white icon-arrow-down\');
        }
        $(element).siblings().find(\'div\').removeClass();
    }

Here is a demo. --You need to either run the demo in Firefox or IE, or disable Chrome\'s MIME-type checking for the demo to work. It depends on the sortElements Plugin, linked by the accepted answer, as an external resource. Just a heads up!

回答7:

Here\'s a chart that may be helpful deciding which to use: http://blog.sematext.com/2011/09/19/top-javascript-dynamic-table-libraries/

回答8:

You can use a jQuery plugin (breedjs) that provides sort, filter and pagination:

HTML:

<table>
  <thead>
    <tr>
      <th sort=\'name\'>Name</th>
      <th>Phone</th>
      <th sort=\'city\'>City</th>
      <th>Speciality</th>
    </tr>
  </thead>
  <tbody>
    <tr b-scope=\"people\" b-loop=\"person in people\">
      <td b-sort=\"name\">{{person.name}}</td>
      <td>{{person.phone}}</td>
      <td b-sort=\"city\">{{person.city}}</td>
      <td>{{person.speciality}}</td>
    </tr>
  </tbody>
</table>

JS:

$(function(){
  var data = {
    people: [
      {name: \'c\', phone: 123, city: \'b\', speciality: \'a\'},
      {name: \'b\', phone: 345, city: \'a\', speciality: \'c\'},
      {name: \'a\', phone: 234, city: \'c\', speciality: \'b\'},
    ]
  };
  breed.run({
    scope: \'people\',
    input: data
  });
  $(\"th[sort]\").click(function(){
    breed.sort({
      scope: \'people\',
      selector: $(this).attr(\'sort\')
    });
  });
});

Working example on fiddle

回答9:

This is a nice way of sorting a table:

$(document).ready(function () {
                $(\'th\').each(function (col) {
                    $(this).hover(
                            function () {
                                $(this).addClass(\'focus\');
                            },
                            function () {
                                $(this).removeClass(\'focus\');
                            }
                    );
                    $(this).click(function () {
                        if ($(this).is(\'.asc\')) {
                            $(this).removeClass(\'asc\');
                            $(this).addClass(\'desc selected\');
                            sortOrder = -1;
                        } else {
                            $(this).addClass(\'asc selected\');
                            $(this).removeClass(\'desc\');
                            sortOrder = 1;
                        }
                        $(this).siblings().removeClass(\'asc selected\');
                        $(this).siblings().removeClass(\'desc selected\');
                        var arrData = $(\'table\').find(\'tbody >tr:has(td)\').get();
                        arrData.sort(function (a, b) {
                            var val1 = $(a).children(\'td\').eq(col).text().toUpperCase();
                            var val2 = $(b).children(\'td\').eq(col).text().toUpperCase();
                            if ($.isNumeric(val1) && $.isNumeric(val2))
                                return sortOrder == 1 ? val1 - val2 : val2 - val1;
                            else
                                return (val1 < val2) ? -sortOrder : (val1 > val2) ? sortOrder : 0;
                        });
                        $.each(arrData, function (index, row) {
                            $(\'tbody\').append(row);
                        });
                    });
                });
            });

            table, th, td {
            border: 1px solid black;
        }
        th {
            cursor: pointer;
        }

<script src=\"https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js\"></script>
<table>
        <tr><th>id</th><th>name</th><th>age</th></tr>
        <tr><td>1</td><td>Julian</td><td>31</td></tr>
        <tr><td>2</td><td>Bert</td><td>12</td></tr>
        <tr><td>3</td><td>Xavier</td><td>25</td></tr>
        <tr><td>4</td><td>Mindy</td><td>32</td></tr>
        <tr><td>5</td><td>David</td><td>40</td></tr>
    </table>

The fiddle can be found here:
https://jsfiddle.net/e3s84Luw/

The explanation can be found here: https://www.learningjquery.com/2017/03/how-to-sort-html-table-using-jquery-code

回答10:

To the response of James I will only change the sorting function to make it more universal. This way it will sort text alphabetical and numbers like numbers.

if( $.text([a]) == $.text([b]) )
    return 0;
if(isNaN($.text([a])) && isNaN($.text([b]))){
    return $.text([a]) > $.text([b]) ? 
       inverse ? -1 : 1
       : inverse ? 1 : -1;
}
else{
    return parseInt($.text([a])) > parseInt($.text([b])) ? 
      inverse ? -1 : 1
      : inverse ? 1 : -1;
}

回答11:

@Nick Grealy\'s answer is great, but it does not take into account possible rowspan attributes of the table header cells (and probably the other answers don\'t do it either). Here is an improvement of the @Nick Grealy\'s answer which fixes that. Based on this answer too (thanks @Andrew Orlov).

I\'ve also replaced the $.isNumeric function with a custom one (thanks @zad) to make it work with older jQuery versions.

To activate it, add class=\"sortable\" to the <table> tag.

$(document).ready(function() {

    $(\'table.sortable th\').click(function(){
        var table = $(this).parents(\'table\').eq(0);
        var column_index = get_column_index(this);
        var rows = table.find(\'tbody tr\').toArray().sort(comparer(column_index));
        this.asc = !this.asc;
        if (!this.asc){rows = rows.reverse()};
        for (var i = 0; i < rows.length; i++){table.append(rows[i])};
    })

});

function comparer(index) {
    return function(a, b) {
        var valA = getCellValue(a, index), valB = getCellValue(b, index);
        return isNumber(valA) && isNumber(valB) ? valA - valB : valA.localeCompare(valB);
    }
}
function getCellValue(row, index){ return $(row).children(\'td\').eq(index).html() };

function isNumber(n) {
  return !isNaN(parseFloat(n)) && isFinite(n);
}

function get_column_index(element) {
    var clickedEl = $(element);
    var myCol = clickedEl.closest(\"th\").index();
    var myRow = clickedEl.closest(\"tr\").index();
    var rowspans = $(\"th[rowspan]\");
    rowspans.each(function () {
        var rs = $(this);
        var rsIndex = rs.closest(\"tr\").index();
        var rsQuantity = parseInt(rs.attr(\"rowspan\"));
        if (myRow > rsIndex && myRow <= rsIndex + rsQuantity - 1) {
            myCol++;
        }
    });
    // alert(\'Row: \' + myRow + \', Column: \' + myCol);
    return myCol;
};

回答12:

Another approach to sort HTML table. (based on W3.JS HTML Sort)

/* Facility Name */
$(\'#bioTable th:eq(0)\').addClass(\"control-label pointer\");
/* Phone # */
$(\'#bioTable th:eq(1)\').addClass(\"not-allowed\");
/* City */
$(\'#bioTable th:eq(2)\').addClass(\"control-label pointer\");
/* Specialty */
$(\'#bioTable th:eq(3)\').addClass(\"not-allowed\");


var collection = [{
  \"FacilityName\": \"MinION\",
  \"Phone\": \"999-8888\",
  \"City\": \"France\",
  \"Specialty\": \"Genetic Prediction\"
}, {
  \"FacilityName\": \"GridION X5\",
  \"Phone\": \"999-8812\",
  \"City\": \"Singapore\",
  \"Specialty\": \"DNA Assembly\"
}, {
  \"FacilityName\": \"PromethION\",
  \"Phone\": \"929-8888\",
  \"City\": \"San Francisco\",
  \"Specialty\": \"DNA Testing\"
}, {
  \"FacilityName\": \"iSeq 100 System\",
  \"Phone\": \"999-8008\",
  \"City\": \"Christchurch\",
  \"Specialty\": \"gDNA-mRNA sequencing\"
}]

$tbody = $(\"#bioTable\").append(\'<tbody></tbody>\');

for (var i = 0; i < collection.length; i++) {
  $tbody = $tbody.append(\'<tr class=\"item\"><td>\' + collection[i][\"FacilityName\"] + \'</td><td>\' + collection[i][\"Phone\"] + \'</td><td>\' + collection[i][\"City\"] + \'</td><td>\' + collection[i][\"Specialty\"] + \'</td></tr>\');
}

.control-label:after {
  content: \"*\";
  color: red;
}

.pointer {
  cursor: pointer;
}

.not-allowed {
  cursor: not-allowed;
}

<script src=\"https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js\"></script>
<script src=\"https://www.w3schools.com/lib/w3.js\"></script>
<link href=\"https://www.w3schools.com/w3css/4/w3.css\" rel=\"stylesheet\" />
<p>Click the <strong>table headers</strong> to sort the table accordingly:</p>

<table id=\"bioTable\" class=\"w3-table-all\">
  <thead>
    <tr>
      <th onclick=\"w3.sortHTML(\'#bioTable\', \'.item\', \'td:nth-child(1)\')\">Facility Name</th>
      <th>Phone #</th>
      <th onclick=\"w3.sortHTML(\'#bioTable\', \'.item\', \'td:nth-child(3)\')\">City</th>
      <th>Specialty</th>
    </tr>
  </thead>
</table>

回答13:

My vote! jquery.sortElements.js and simple jquery
Very simple, very easy, thanks nandhp...

            $(\'th\').live(\'click\', function(){

            var th = $(this), thIndex = th.index(), var table = $(this).parent().parent();

                switch($(this).attr(\'inverse\')){
                case \'false\': inverse = true; break;
                case \'true:\': inverse = false; break;
                default: inverse = false; break;
                }
            th.attr(\'inverse\',inverse)

            table.find(\'td\').filter(function(){
                return $(this).index() === thIndex;
            }).sortElements(function(a, b){
                return $.text([a]) > $.text([b]) ?
                    inverse ? -1 : 1
                    : inverse ? 1 : -1;
            }, function(){
                // parentNode is the element we want to move
                return this.parentNode; 
            });
            inverse = !inverse;     
            });

Dei uma melhorada do código
One cod better! Function for All tables in all Th in all time... Look it!
DEMO