如何在多列上对数组进行排序? [英] How do you sort an array on multiple columns?
问题描述
我有一个多维数组。主数组是一个数组
I have a multidimensional array. The primary array is an array of
[publicationID][publication_name][ownderID][owner_name]
我要做的是按 owner_name
排序数组,然后按 PUBLICATION_NAME
。我知道在JavaScript中你有 Array.sort()
,你可以在其中放置一个自定义函数,在我的情况下我有:
What I am trying to do is sort the array by owner_name
and then by publication_name
. I know in JavaScript you have Array.sort()
, into which you can put a custom function, in my case i have:
function mysortfunction(a, b) {
var x = a[3].toLowerCase();
var y = b[3].toLowerCase();
return ((x < y) ? -1 : ((x > y) ? 1 : 0));
}
这对于只对一列进行排序很好,即owner_name,但是如何我修改它以对 owner_name
进行排序,然后 publication_name
?
This is fine for just sorting on the one column, namely owner_name, but how do I modify it to sort on owner_name
, then publication_name
?
推荐答案
如果所有者名称不同,请按其排序。否则,使用发布名称作为决胜局。
If owner names differ, sort by them. Otherwise, use publication name for tiebreaker.
function mysortfunction(a, b) {
var o1 = a[3].toLowerCase();
var o2 = b[3].toLowerCase();
var p1 = a[1].toLowerCase();
var p2 = b[1].toLowerCase();
if (o1 < o2) return -1;
if (o1 > o2) return 1;
if (p1 < p2) return -1;
if (p1 > p2) return 1;
return 0;
}
这篇关于如何在多列上对数组进行排序?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!