blocks|key|355073|text|我认为#1的答案是，对于一些数字列，您有空白字段，这会导致表排序程序将该列检测为“字符串”列。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|355074|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

<p>I <em>think</em> the answer to #1 is that you have blank fields for some numerical columns causing the tablesorter to detect that column as a "string" column.</p>


blocks|key|3354966|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3354967|空白字段可能有问题(例如，它们不是0)，请尝试使用自定义解析器删除任何非数字并强制将值转换为整数(例如：http://paste.pocoo.org/show/90863/+)|ordered-list-item|offset|length|3354968|将‘http://paste.pocoo.org/show/90863/’行放入标签中，紧靠表|3354969|的末尾|3354970|entityMap|0|LINK|mutability|MUTABLE|url|http://paste.pocoo.org/show/90863/|1^0|0|1G|Y|0|0|2|Y|1|0|0^^$0|@$1|2|3|-4|4|5|6|S|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|T|7|@]|8|@$D|U|E|V|1|W]]|9|$]]|$1|F|3|G|4|C|6|X|7|@]|8|@$D|Y|E|Z|1|10]]|9|$]]|$1|H|3|I|4|5|6|11|7|@]|8|@]|9|$]]|$1|J|3|-4|4|5|6|12|7|@]|8|@]|9|$]]]|K|$L|$4|M|N|O|9|$P|Q]]|R|$4|M|N|O|9|$P|Q]]]]

<ol>
<li><p>Blank fields could be a problem (e.g they are not 0), try using custom parser which removes any non-numericals and forces values to integers (example: <a href="http://paste.pocoo.org/show/90863/" rel="nofollow noreferrer">http://paste.pocoo.org/show/90863/</a> )</p></li>
<li><p>Put your 'total' row inside a &lt;tfoot&gt; &lt;/tfoot&gt; tag right before the end of the table</p></li>
</ol>


blocks|key|3354975|text|我建议使用一些Javascript从表中删除最后一行。添加页脚，然后从表中重新添加已删除的行。要解决数字单元格中的空数据问题，您可能需要添加自己的custom+parser。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3354976|+++$(function()+{
+++++++$('#communityStats').append("<tfoot></tfoot>");
+++++++$('#communityStats+>+tr:last').remove()
+++++++++++++++++++++++++++++++++++++.appendTo('#communityStats+>+tfoot');
+++++++$('#communityStats').tablesorter();
+++});|code-block|syntax|javascript|3354977|entityMap|0|LINK|mutability|MUTABLE|url|http://tablesorter.com/docs/example-parsers.html^0|21|D|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

<p>I would suggest using some Javascript to remove the last row from the table.  Add a footer and then re-add the removed row from the table.  To solve the issue with empty data in a numeric cell you may need to add your own <a href="http://tablesorter.com/docs/example-parsers.html" rel="noreferrer">custom parser</a>.</p>

<pre><code>   $(function() {
       $('#communityStats').append("&lt;tfoot&gt;&lt;/tfoot&gt;");
       $('#communityStats &gt; tr:last').remove()
                                     .appendTo('#communityStats &gt; tfoot');
       $('#communityStats').tablesorter();
   });
</code></pre>


blocks|key|355107|text|第一个问题是由于表排序器自动将列检测为“text”-列(可能是因为空单元格)。要解决此问题，请使用以下代码初始化表排序程序，并根据数据将所有字段设置为数字或货币：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|355108|<script+type="text/javascript"+>
jQuery(document).ready(function()+
{+
++++jQuery("#communityStats").tablesorter({+
++++++++headers:+{+2:+{+sorter:'digit'+}+,+
+++++++++++++++++++3:+{+sorter:'digit'+}+,
+++++++++++++++++++4:+{+sorter:'digit'+}+,
+++++++++++++++++++5:+{+sorter:'digit'+}+,
+++++++++++++++++++6:+{+sorter:'digit'+}+,
+++++++++++++++++++7:+{+sorter:'digit'+}+,
+++++++++++++++++++8:+{+sorter:'currency'+}+,
+++++++++++++++++++9:+{+sorter:'currency'+}+,
+++++++++++++++++++10:+{+sorter:'currency'+}+,
+++++++++++++++++++11:+{+sorter:'currency'+}+
+++++++++++++++++}+
++++});+
});
</script>|code-block|syntax|javascript|355109|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

<p>The first problem is due to the fact that the table sorter auto detects the column to a 'text'-column (probably because the empty cells). To solve this use this code to initialize the tablesorter and set all the field to either digit or currency depending on the data:</p>

<pre><code>&lt;script type="text/javascript" &gt;
jQuery(document).ready(function() 
{ 
    jQuery("#communityStats").tablesorter({ 
        headers: { 2: { sorter:'digit' } , 
                   3: { sorter:'digit' } ,
                   4: { sorter:'digit' } ,
                   5: { sorter:'digit' } ,
                   6: { sorter:'digit' } ,
                   7: { sorter:'digit' } ,
                   8: { sorter:'currency' } ,
                   9: { sorter:'currency' } ,
                   10: { sorter:'currency' } ,
                   11: { sorter:'currency' } 
                 } 
    }); 
});
&lt;/script&gt;
</code></pre>


blocks|key|3142029|text|我发现以下代码适用于无法识别的数字(数字)列。tablesorter的当前版本(2.0.3)似乎将0视为文本。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3142030|包括来自tvanfosson的示例，页面底部的这个脚本将从页脚移动最后一行，这将阻止它与tbody中的数据一起排序，并将强制排序程序使用数字排序，而不是您所描述的文本排序。|3142031|$(document).ready(function()+{
++$('#communityStats').append("<tfoot></tfoot>");
++$('#communityStats+>+tr:last').remove()
++++.appendTo('#communityStats+>+tfoot');

++$("#communityStats").tablesorter({
+++++debug:+true,
+++++headers:+{+
+++++++0:{sorter:+'digit'}
+++++++...
+++++++10:{sorter:+'digit'}
+++++}
++});

});+|code-block|syntax|javascript|3142032|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

<p>I found that the following will work with unrecognized numeric (digit) columns. It appears that 0 is considered text by the current version (2.0.3) of tablesorter.</p>

<p>Including the sample from tvanfosson, this script at the bottom of your page would move your last row from the footer which prevents it from being sorted with the data within tbody and would force the sorter to use a numeric sort rather than the text sort it is using as you described.</p>

<pre><code>$(document).ready(function() {
  $('#communityStats').append("&lt;tfoot&gt;&lt;/tfoot&gt;");
  $('#communityStats &gt; tr:last').remove()
    .appendTo('#communityStats &gt; tfoot');

  $("#communityStats").tablesorter({
     debug: true,
     headers: { 
       0:{sorter: 'digit'}
       ...
       10:{sorter: 'digit'}
     }
  });

}); 
</code></pre>


blocks|key|3142034|text|修复tablesorter插件的头部：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3142035|css|offset|length|style|BOLD|3142036|table.tablesorter+thead+{
position:+fixed;
top:+35px;+//+
}|code-block|syntax|javascript|3142037|JS|3142038|function+tableFixedHeader()+{
+++var+tdUnit+=+$('.tablesorter+tbody+tr:first').children('td').length;
+++for(var+i=0;i<tdUnit;+i%2B%2B)+{
+++++$('.tablesorter+thead+th').eq(i).width($('.tablesorter+tbody+td').eq(i).width());
+++}
+++$('.tablesorter').css('margin-top',$('.tablesorter+thead').height());+
}|3142039|HTML|3142040|<div+id="container">
+++<div+id="topmenu"+style="height:35px;">some+buttons</div>
+++<div+id="tablelist"+style="width:100%25;overflow:auto;">
++++++<table+class="tablesorterw">.....</table>
+++</div>
</div>|3142041|entityMap^0|0|0|3|0|0|0|2|0|0|0|4|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@$D|Y|E|Z|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|10|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|11|8|@$D|12|E|13|F|G]]|9|@]|A|$]]|$1|O|3|P|5|J|7|14|8|@]|9|@]|A|$K|L]]|$1|Q|3|R|5|6|7|15|8|@$D|16|E|17|F|G]]|9|@]|A|$]]|$1|S|3|T|5|J|7|18|8|@]|9|@]|A|$K|L]]|$1|U|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|V|$]]

<p>fixed header for tablesorter plugin :</p>

<p><strong>css</strong></p>

<pre><code>table.tablesorter thead {
position: fixed;
top: 35px; // 
}
</code></pre>

<p><strong>JS</strong></p>

<pre><code>function tableFixedHeader() {
   var tdUnit = $('.tablesorter tbody tr:first').children('td').length;
   for(var i=0;i&lt;tdUnit; i++) {
     $('.tablesorter thead th').eq(i).width($('.tablesorter tbody td').eq(i).width());
   }
   $('.tablesorter').css('margin-top',$('.tablesorter thead').height()); 
}
</code></pre>

<p><strong>HTML</strong></p>

<pre><code>&lt;div id="container"&gt;
   &lt;div id="topmenu" style="height:35px;"&gt;some buttons&lt;/div&gt;
   &lt;div id="tablelist" style="width:100%;overflow:auto;"&gt;
      &lt;table class="tablesorterw"&gt;.....&lt;/table&gt;
   &lt;/div&gt;
&lt;/div&gt;
</code></pre>


<p>I'm having a couple of problems with the JQuery <a href="http://tablesorter.com/docs/" rel="noreferrer">tablesorter</a> plugin. If you click on a column header, it should sort the data by this column, but there are a couple of problems:</p>

<ol>
<li>The rows are not properly sorted (1, 1, 2183, 236)</li>
<li>The total row is included in the sort</li>
</ol>

<p>Regarding (2), I can't easily move the total row to a table footer, because the HTML is generated by the <a href="http://displaytag.sourceforge.net/11/" rel="noreferrer">displaytag</a> tag library over which I have limited control.</p>

<p>Regarding (1), I don't understand why the sort doesn't work as I've used exactly the same JavaScript shown in the simplest example in the <a href="http://tablesorter.com/docs/#Getting-Started" rel="noreferrer">tablesorter tutorials</a>. </p>

<p>In fact, there's only a single line of JS code, which is:</p>

<pre><code>&lt;body onload="jQuery('#communityStats').tablesorter();"&gt;
</code></pre>

<p>Thanks in advance,
Don</p>


JQuery tablesorter problem

jQuery

我在JQuery 插件上遇到了一些问题。如果单击列标题，应该会按该列对数据进行排序，但有几个问题：未正确排序行(1，1,2183,236)中包含合计行关于(2)，我不能轻易地将总行移动到表脚，因为HTML是由标记库生成的，而我对它的控制是有限的。关于(1)，我不明白为什么排序不起作用，因为我使用的JavaScript与...

问JQuery表排序问题
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问JQuery表排序问题EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问JQuery表排序问题
EN