使用jquery的alpha数字排序
使用jquery的alpha数字排序
提问于 2016-12-12 20:48:45
我有一个混合数组，我需要按字母排序，然后按数字排序。
[Ab-1,Ab-5,Ab-11,ab-101,ab-100,ab-10,ab-12,ab-3,ab-21]根据代码，im获得以下输出
ab-1 ab-5 ab-11 ab-101 ab-100 ab-10 ab-12 ab-3 ab-21根据代码，默认情况下，第三列分别显示为活动列和非活动列。但我希望第一列(ID)也将其排序为：
ab-1
ab-2
ab-3
ab-5
ab-10
ab-11
ab-12
ab-100
ab-101....有什么帮助吗？
<!DOCTYPE HTML>
<html lang="en-US">
<head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<script>
// Fetch the values from json
$(document).ready(function() {
$.getJSON("dynamic_content_values1.json",
/* sort starts for Active and Inactive */
function(result_1) {
function sortJSON(data, key) {
return data.sort(function (a, b) {
var x = a[key];
var y = b[key];
return ((x < y) ? -1 : ((x > y) ? 1 : 0));
});
}
sorting_active_and_inactive = sortJSON(result_1, 'flag');
/* sort End for Active and Inactive*/
$.each(sorting_active_and_inactive,function(i, field) {
var status = field.flag;
if (status == 'N') {
status = 'Active';
} else {
status = 'Inactive';
}
var data = '<tr><td><a href="#">' + field.first_column + '</a></td><td>' + field.summary + '</td><td>' + status + '</td></tr>';
$("#resultBody").append(data);
});
});
//******************************************* Starting CODE for Sorting the Active/In-Active Columns *******************************************
function sortTable(table, col, reverse) {
var tb = table.tBodies[0], // use `<tbody>` to ignore `<thead>` and `<tfoot>` rows
tr = Array.prototype.slice.call(tb.rows, 0), // put rows into array
i;
reverse = -((+reverse) || -1);
tr = tr.sort(function (a, b) { // sort rows
return reverse // `-1 *` if want opposite order
* (a.cells[col].textContent.trim() // using `.textContent.trim()` for test
.localeCompare(b.cells[col].textContent.trim())
);
});
for(i = 0; i < tr.length; ++i) tb.appendChild(tr[i]); // append each row in order
}
function makeSortable(table) {
var th = table.tHead, i;
th && (th = th.rows[0]) && (th = th.cells);
if (th) i = th.length;
else return; // if no `<thead>` then do nothing
while (--i >= 0) (function (i) {
var dir = 1;
th[i].addEventListener('click', function () {sortTable(table, i, (dir = 1 - dir))});
}(i));
}
function makeAllSortable(parent) {
parent = parent || document.body;
var t = parent.getElementsByTagName('table'), i = t.length;
while (--i >= 0) makeSortable(t[i]);
}
window.onload = function () {makeAllSortable();};
//************************************************** Ending CODE for Sorting the Active/In-Active Columns *********************************
});
function showabc() {
document.getElementById('container1').style.display = "block";
}
</script>
</head>
<body>
<div class="" id="container1">
<table>
<thead>
<tr>
<th><b>ID</b></th>
<th><b>Summary</b></th>
<th>Status</th>
</tr>
</thead>
<tbody id="resultBody" style="cursor: move">
</tbody>
</table>
</div>
<div class="containerPopup1"><div id="abc1" style="height: 1400px;"></div></div>
<div class="containerPopup"><div id="abc2" style="height: 2700px;"></div></div>
</body>
</html>Json结构: dynamic_content_values1.json
[ {
"first_column": "AB-1",
"summary": "AB-1 Summary",
"flag": "N"
}, {
"first_column": "AB-11",
"summary": "AB-11 Summary",
"flag": "N"
},{
"first_column": "AB-12",
"summary": "AB-12 Summary",
"flag": "Y"
},{
"first_column": "AB-10",
"summary": "AB-10 Summary",
"flag": "Y"
},{
"first_column": "AB-100",
"summary": "AB-100 Summary",
"flag": "Y"
},{
"first_column": "AB-101",
"summary": "AB-101 Summary",
"flag": "N"
},{
"first_column": "AB-2",
"summary": "AB-2 Summary",
"flag": "Y"
},{
"first_column": "AB-3",
"summary": "AB-3 Summary",
"flag": "Y"
},{
"first_column": "AB-21",
"summary": "AB-21 Summary",
"flag": "Y"
},{
"first_column": "AB-210",
"summary": "AB-210 Summary",
"flag": "Y"
},{
"first_column": "AB-211",
"summary": "AB-211 Summary",
"flag": "Y"
},{
"first_column": "AB-5",
"summary": "AB-5 Summary",
"flag": "N"
}]回答 2
Stack Overflow用户
回答已采纳
发布于 2016-12-12 21:06:59
稍微改变一下您的逻辑，看看它是否最适合您，在-中拆分值，然后以不同的方式比较数字和字符串。您可以添加NaN条件，为了简单起见，我跳过了它。
工作片段：
function naturalSorter(as, bs) {
var splittedA = as.split("-");
var splittedB = bs.split("-");
if (splittedA[0].toLowerCase() > splittedB[0].toLowerCase()) {
return 1
} else if (splittedA[0].toLowerCase() < splittedB[0].toLowerCase()) {
return -1;
} else {
return Number(splittedA[1]) === Number(splittedB[1]) ? 0 : Number(splittedA[1]) > Number(splittedB[1]) ? 1 : -1;
}
}
$(document).ready(function() {
var selectModel = [];
$('table.table_sorting td').each(function() {
var $this = $(this);
selectModel.push({
value: $this.val(),
text: $this.text()
});
});
selectModel.sort(function(a, b) {
return naturalSorter(a.text, b.text);
});
var tempHtml = '';
for (var i = 0, ii = selectModel.length; i < ii; i++) {
//tempHtml += '<option value="' + selectModel[i].value + '">' + selectModel[i].text + '</option>';
tempHtml += '<tr><td>' + selectModel[i].text + '</td></tr>';
}
$('table.table_sorting').html(tempHtml);
});<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<table style="border: 1px solid red;" class="table_sorting">
<tr>
<td>ab-1</td>
</tr>
<tr>
<td>ab-11</td>
</tr>
<tr>
<td>ab-12</td>
</tr>
<tr>
<td>ab-13</td>
</tr>
<tr>
<td>ab-100</td>
</tr>
<tr>
<td>ab-101</td>
</tr>
<tr>
<td>ab-102</td>
</tr>
<tr>
<td>ab-111</td>
</tr>
<tr>
<td>ab-222</td>
</tr>
<tr>
<td>ab-333</td>
</tr>
<tr>
<td>ab-3</td>
</tr>
<tr>
<td>ab-2</td>
</tr>
<tr>
<td>ab-4</td>
</tr>
<tr>
<td>ab-44</td>
</tr>
<tr>
<td>ab-5</td>
</tr>
<tr>
<td>ab-55</td>
</tr>
</table>
Stack Overflow用户
发布于 2016-12-12 21:54:00
对于排序，您可以使用一种简化的链式方法，如果前一次重reuslt为零，则使用comnparisond进行排序。
var data = ['Ab-1', 'Ab-11', 'Ab-12', 'ab-10', 'ab-100', 'ab-101', 'ab-2', 'ab-3', 'ab-105'];
data.sort(function (a, b) {
var aa = a.split('-'),
bb = b.split('-');
return aa[0].toLowerCase().localeCompare(bb[0].toLowerCase()) || aa[1] - bb[1];
});
console.log(data);
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/41109294
复制相关文章
相似问题
腾讯云开发者
Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 
粤公网安备44030502008569号
腾讯云计算（北京）有限责任公司 京ICP证150476号 | 京ICP备11018762号