用Javascript排序JSON对象

Question

我一直在寻找排序这样的JSON对象的时间{"results": [  {    "layerId": 5,    "layerName": "Pharmaceutical Entities",    "attributes": {      "OBJECTID": "35",      "FACILITYTYPE": "Pharmacy",      "FACILITYSUBTYPE": "24 Hr Pharmacy",      "COMMERCIALNAME_E": "SADD MAARAB PHARMACY",      },    "geometryType": "esriGeometryPoint",   },  {    "layerId": 5,    "layerName": "Pharmaceutical Entities",    "attributes": {      "OBJECTID": "1",      "FACILITYTYPE": "Pharmacy",      "FACILITYSUBTYPE": "24 Hr Pharmacy",      "COMMERCIALNAME_E": "GAYATHY HOSPITAL  PHARMACY",    },    "geometryType": "esriGeometryPoint",  },     {    "layerId": 5,    "layerName": "Pharmaceutical Entities",    "attributes": {      "OBJECTID": "255",      "FACILITYTYPE": "Pharmacy",      "FACILITYSUBTYPE": "24 Hr Pharmacy",      "COMMERCIALNAME_E": "AL DEWAN PHARMACY",      },    "geometryType": "esriGeometryPoint",   }]}按“ COMMERCIALNAME_E”的字母顺序获取{"results": [   {    "layerId": 5,    "layerName": "Pharmaceutical Entities",    "attributes": {      "OBJECTID": "255",      "FACILITYTYPE": "Pharmacy",      "FACILITYSUBTYPE": "24 Hr Pharmacy",      "COMMERCIALNAME_E": "AL DEWAN PHARMACY",      },    "geometryType": "esriGeometryPoint",   },  {    "layerId": 5,    "layerName": "Pharmaceutical Entities",    "attributes": {      "OBJECTID": "1",      "FACILITYTYPE": "Pharmacy",      "FACILITYSUBTYPE": "24 Hr Pharmacy",      "COMMERCIALNAME_E": "GAYATHY HOSPITAL  PHARMACY",       },    "geometryType": "esriGeometryPoint",   },   {    "layerId": 5,    "layerName": "Pharmaceutical Entities",    "attributes": {      "OBJECTID": "35",      "FACILITYTYPE": "Pharmacy",      "FACILITYSUBTYPE": "24 Hr Pharmacy",      "COMMERCIALNAME_E": "SADD MAARAB PHARMACY",      },    "geometryType": "esriGeometryPoint",   }]}我找不到任何可以做到这一点的代码。谁能给我些帮助吗？

Answer 1

function sortJsonArrayByProperty(objArray, prop, direction){

    if (arguments.length<2) throw new Error("sortJsonArrayByProp requires 2 arguments");

    var direct = arguments.length>2 ? arguments[2] : 1; //Default to ascending

    if (objArray && objArray.constructor===Array){

        var propPath = (prop.constructor===Array) ? prop : prop.split(".");

        objArray.sort(function(a,b){

            for (var p in propPath){

                if (a[propPath[p]] && b[propPath[p]]){

                    a = a[propPath[p]];

                    b = b[propPath[p]];

                }

            }

            // convert numeric strings to integers

            a = a.match(/^\d+$/) ? +a : a;

            b = b.match(/^\d+$/) ? +b : b;

            return ( (a < b) ? -1*direct : ((a > b) ? 1*direct : 0) );

        });

    }

}

sortJsonArrayByProperty(results, 'attributes.OBJECTID');

sortJsonArrayByProperty(results, 'attributes.OBJECTID', -1);

更新：请勿更改

function sortByProperty(objArray, prop, direction){

    if (arguments.length<2) throw new Error("ARRAY, AND OBJECT PROPERTY MINIMUM ARGUMENTS, OPTIONAL DIRECTION");

    if (!Array.isArray(objArray)) throw new Error("FIRST ARGUMENT NOT AN ARRAY");

    const clone = objArray.slice(0);

    const direct = arguments.length>2 ? arguments[2] : 1; //Default to ascending

    const propPath = (prop.constructor===Array) ? prop : prop.split(".");

    clone.sort(function(a,b){

        for (let p in propPath){

                if (a[propPath[p]] && b[propPath[p]]){

                    a = a[propPath[p]];

                    b = b[propPath[p]];

                }

        }

        // convert numeric strings to integers

        a = a.match(/^\d+$/) ? +a : a;

        b = b.match(/^\d+$/) ? +b : b;

        return ( (a < b) ? -1*direct : ((a > b) ? 1*direct : 0) );

    });

    return clone;

}

const resultsByObjectId = sortByProperty(results, 'attributes.OBJECTID');

const resultsByObjectIdDescending = sortByProperty(results, 'attributes.OBJECTID', -1);

Answer 2

首先提取JSON编码的数据：

var data = eval(yourJSONString);

var results = data['results'];

然后使用自定义（用户）函数进行排序：

results.sort(function(a,b){

    //return a.attributes.OBJECTID - b.attributes.OBJECTID;

    if(a.attributes.OBJECTID == b.attributes.OBJECTID)

        return 0;

    if(a.attributes.OBJECTID < b.attributes.OBJECTID)

        return -1;

    if(a.attributes.OBJECTID > b.attributes.OBJECTID)

        return 1;

});

我假设您想按排序OBJECTID，但是您可以将其更改为按任何排序。

Answer 3

您可以通过提供自定义比较功能作为的参数，对任何东西的有序数组进行排序Array.Sort()。

var myObject = /* json object from string */ ;

myObject.results.sort(function (a, b) {

    // a and b will be two instances of your object from your list

    // possible return values

    var a1st = -1; // negative value means left item should appear first

    var b1st =  1; // positive value means right item should appear first

    var equal = 0; // zero means objects are equal

    // compare your object's property values and determine their order

    if (b.attributes.COMMERCIALNAME_E < a.attributes.COMMERCIALNAME_E) {

        return b1st;

    }

    else if (a.attributes.COMMERCIALNAME_E < b.attributes.COMMERCIALNAME_E) {

        return a1st;

    }

    else {

        return equal;

    }

});