Table Sorter

Utilizando o plugin "Table Sorter" com ordenação de data e moeda brasileiro!

HTML

<script src="http://tablesorter.com/__jquery.tablesorter.min.js"></script>
<link rel="stylesheet" href="http://twitter.github.com/bootstrap/assets/css/bootstrap.css">
<table cellspacing="1" class="tablesorter table table-striped" id="tablesorter">
    <thead>
        <tr>
            <th>N&ordm; do Pedido</th>
            <th>Cliente</th>
            <th>Valor do Pedido</th>
            <th>Observa&ccedil;&otilde;es</th>
            <th>Status</th>
            <th>&Uacute;ltima altera&ccedil;&atilde;o</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td>000057</td>
            <td>Ferrageira Distribuidora Ferragens Ltda</td>
            <td>R$ 2.020,48</td>
            <td>RETIRAMOS EM 20.12.12</td>
            <td><i class="icon icon-time"></i> Aguardando</td>
            <td>17-12-2012</td>
          </tr>
          <tr>
            <td>000056</td>
            <td>Comercial de Mat Constr Alcantara Ltda</td>
            <td>R$ 528,50</td>
            <td>&nbsp;</td>
            <td><i class="icon icon-ok"></i> Faturado</td>
            <td>17-12-2012</td>
          </tr>
          <tr>
            <td>000055</td>
            <td>Purkott e Moletta Ltda</td>
            <td>R$ 919,60</td>
            <td>&nbsp;</td>
            <td><i class="icon icon-ok"></i> Faturado</td>
            <td>17-12-2012</td>
          </tr>
          <tr>
            <td>000054</td>
            <td>Ferrageira Distribuidora Ferragens Ltda</td>
            <td>R$ 2.016,00</td>
            <td>RETIRAMOS EM 06.12.12</td>
            <td><i class="icon icon-ok"></i> Faturado</td>
            <td>07-12-2012</td>
          </tr>
          <tr>
            <td>000053</td>
            <td>Ferrageira Distribuidora Ferragens Ltda</td>
            <td>R$ 2.012,16</td>
            <td>RETIRAMOS EM 29.11.12</td>
            <td><i class="icon icon-ok"></i> Faturado</td>
            <td>29-11-2012</td>
          </tr>
          <tr>
            <td>000052</td>
           ...

JavaScript

// Moeda
$.tablesorter.addParser({
    id: 'money-br',
    is: function(s) {
        return false;
    },
    format: function(s) {
        s = '' + s;
        s = s.replace(new RegExp(/\D/g), '');
        s = $.tablesorter.formatInt(s);
        return s;
    },
    type: 'numeric'
});

// Data
$.tablesorter.addParser({
    id: 'date-br',
    is: function(s) {
        return false;
    },
    format: function(s) {
        var string = s.split('-');
        string.reverse();
        var number = string.join('');
        return number;
    },
    type: 'numeric'
});

// Zebrando tabela
$.tablesorter.defaults.widgets = ['zebra'];

// Inicalizando o plugin
$("table").tablesorter({
    headers: {
        0: {
            sorter: 'money-br'
        },
        2: {
            sorter: 'money-br'
        },
        5: {
            sorter: 'date-br'
        }
    }
});