I am interested in organizing a three-dimensional array using JavaScript

Question

I am interested in organizing a three-dimensional array using JavaScript

Just the other day, I posted a question on PHP, but now I need similar help for JavaScript.

Here is my array :

var inboxMessages = {
    105775: { 
        0: {
            'id': 85,
            'thread_id': 105775,
            'message': "hello",
            'created_at': "May 20, 2015",
            'datetime': 1432118191,
            'sender_id': 13,
        },
        1: {
            'id': 70,
            'thread_id': 105775,
            'message': "hii",
            'created_at': "May 19, 2015",
            'datetime': 1432021227,
            'sender_id': 13,
        }
    },
    224199: { 
        0: {
            'id': 88,
            'thread_id': 224199,
            'message': "yessss...",
            'created_at': "May 20, 2015",
            'datetime': 1432306513,
            'sender_id': 14,
        },
        1: {
            'id': 75,
            'thread_id': 224199,
            'message': "hellowwww...",
            'created_at': "May 19, 2015",
            'datetime': 1432021227,
            'sender_id': 14,
        }
    },
    107917: { 
        0: {
            'id': 56,
            'thread_id': 107917,
            'message': "how r u??",
            'created_at': "May 16, 2015",
            'datetime': 1431792155,
            'sender_id': 14,
        },
        1: {
            'id': 30,
            'thread_id': 107917,
            'message': "hi.. i m fine.",
            'created_at': "May 6, 2015",
            'datetime': 1430920006,
            'sender_id': 14,
        },
        2: {
            'id': 30,
            'thread_id': 107917,
            'message': "hi!!!!..how r u??",
            'created_at': "May 6, 2015",
            'datetime': 1430920006,
            'sender_id': 14,
        }
    },
    378552: { 
        0: {
            'id': 108,
            'thread_id': 378552,
            'message': "hi",
            'created_at': "May 29, 2015",
            'datetime': 1432906923,
            'sender_id': 14,
        },
        1: {
            'id': 107,
            'thread_id': 378552,
            'message': "hi.",
            'created_at': "May 29, 2015",
            'datetime': 1432903194,
            'sender_id': 14,
        }
    }

};

Now, I need the output to be like this :

var inboxMessages = {
    378552: {
        0: {
            'id': 108,
            'thread_id': 378552,
            'message': "hi",
            'created_at': "May 29, 2015",
            'datetime': 1432906923,
            'sender_id': 14,
        },
        1: {
            'id': 107,
            'thread_id': 378552,
            'message': "hi.",
            'created_at': "May 29, 2015",
            'datetime': 1432903194,
            'sender_id': 14,
        }
    },
    224199: {
        0: {
            'id': 88,
            'thread_id': 224199,
            'message': "yessss...",
            'created_at': "May 20, 2015",
            'datetime': 1432306513,
            'sender_id': 14,
        },
        1: {
            'id': 75,
            'thread_id': 224199,
            'message': "hellowwww...",
            'created_at': "May 19, 2015",
            'datetime': 1432021227,
            'sender_id': 14,
        }
    },
    105775: {
        0: {
            'id': 85,
            'thread_id': 105775,
            'message': "hello",
            'created_at': "May 20, 2015",
            'datetime': 1432118191,
            'sender_id': 13,
        },
        1: {
            'id': 70,
            'thread_id': 105775,
            'message': "hii",
            'created_at': "May 19, 2015",
            'datetime': 1432021227,
            'sender_id': 13,
        }
    },
    107917: {
        0: {
            'id': 56,
            'thread_id': 107917,
            'message': "how r u??",
            'created_at': "May 16, 2015",
            'datetime': 1431792155,
            'sender_id': 14,
        },
        1: {
            'id': 30,
            'thread_id': 107917,
            'message': "hi.. i m fine.",
            'created_at': "May 6, 2015",
            'datetime': 1430920006,
            'sender_id': 14,
        },
        2: {
            'id': 30,
            'thread_id': 107917,
            'message': "hi!!!!..how r u??",
            'created_at': "May 6, 2015",
            'datetime': 1430920006,
            'sender_id': 14,
        }
    },
};

I'm not sure how to sort this in JS.

I want the most recent datetime for each thread to be at the top of the array.

javascript arrays sorting

Answer 1

Answer №1

Is this achieving your desired outcome?

//var inboxMessages = {... your input ...};

function convertMessages(inboxMessages) {
  var result = [];
  var threadIds = Object.keys(inboxMessages);
  var threadObj, threadArr, keys;

  for (var i=0, threadId; threadId=threadIds[i]; i++) {
      threadObj = inboxMessages[threadId];
      keys = Object.keys(threadObj);
      threadArr = [];
      result.push(threadArr);

      for (var j=0, key; key=keys[j]; j++) {
          threadArr.push(threadObj[key]);
      }

      threadArr.sort(function (a, b) {
        return (b.datetime - a.datetime);
      });
  }

  result.sort(function (a, b) {
    return (b[0].datetime - a[0].datetime);
  });

  return result;
}

function getThreadIds(threadArrays) {
  var threadIdArr = [];

  for (var i=0, threadArr; threadArr=threadArrays[i]; i++) {
    threadId = threadArr[0].threadId;
    threadIdArr.push(threadId);
  }

  return threadIdArr;
}

function findThreadById(threadId, threadIdArr, threadArrays) {
  var index = threadIdArr.indexOf(threadId);
  var threadArr;

  if (index < 0) {
    // no matching thread found
  } else {
    threadArr = threadArrays[index];
  }

  return threadArr;
}

var results = convertMessages(inboxMessages);
var threadIdArr = getThreadIds(results);
var recentThread = threadIdArr[0];
var recentMessage = results[0][0];
var specificThread = findThreadById(105775, threadIdArr, results);

console.log(results);
// sorted array of sorted arrays
console.log(threadIdArr);
// [378552, 224199, 105775, 107917]
console.log(recentThread);
// 378552
console.log(recentMessage);
/* {
  created_at: "May 29, 2015"
, datetime: 1432906923
, id: 108
, message: "hi"
, sender_id: 14
, thread_id: 378552
} */
console.log(specificThread);
// sorted array

Answer 2

Is this achieving your desired outcome?

//var inboxMessages = {... your input ...};

function convertMessages(inboxMessages) {
  var result = [];
  var threadIds = Object.keys(inboxMessages);
  var threadObj, threadArr, keys;

  for (var i=0, threadId; threadId=threadIds[i]; i++) {
      threadObj = inboxMessages[threadId];
      keys = Object.keys(threadObj);
      threadArr = [];
      result.push(threadArr);

      for (var j=0, key; key=keys[j]; j++) {
          threadArr.push(threadObj[key]);
      }

      threadArr.sort(function (a, b) {
        return (b.datetime - a.datetime);
      });
  }

  result.sort(function (a, b) {
    return (b[0].datetime - a[0].datetime);
  });

  return result;
}

function getThreadIds(threadArrays) {
  var threadIdArr = [];

  for (var i=0, threadArr; threadArr=threadArrays[i]; i++) {
    threadId = threadArr[0].threadId;
    threadIdArr.push(threadId);
  }

  return threadIdArr;
}

function findThreadById(threadId, threadIdArr, threadArrays) {
  var index = threadIdArr.indexOf(threadId);
  var threadArr;

  if (index < 0) {
    // no matching thread found
  } else {
    threadArr = threadArrays[index];
  }

  return threadArr;
}

var results = convertMessages(inboxMessages);
var threadIdArr = getThreadIds(results);
var recentThread = threadIdArr[0];
var recentMessage = results[0][0];
var specificThread = findThreadById(105775, threadIdArr, results);

console.log(results);
// sorted array of sorted arrays
console.log(threadIdArr);
// [378552, 224199, 105775, 107917]
console.log(recentThread);
// 378552
console.log(recentMessage);
/* {
  created_at: "May 29, 2015"
, datetime: 1432906923
, id: 108
, message: "hi"
, sender_id: 14
, thread_id: 378552
} */
console.log(specificThread);
// sorted array

Answer 3

Answer №2

The sorting of this array is already implemented in the server script using PHP. However, I noticed that when I retrieve the data via ajax and convert it to JSON, only the Chrome web browser sorts it in numeric order based on the thread_id in ascending order.

To address this issue, I decided to add an underscore _ before the thread_id on the server side so that it becomes _378552 and is treated as a string, preventing Chrome from automatically sorting it.

Once I have retrieved the data, I remove the underscore from the thread_id to access it properly. This workaround has successfully resolved the sorting issue, which seems to be specific to the Chrome browser.

Answer 4

The sorting of this array is already implemented in the server script using PHP. However, I noticed that when I retrieve the data via ajax and convert it to JSON, only the Chrome web browser sorts it in numeric order based on the thread_id in ascending order.

To address this issue, I decided to add an underscore _ before the thread_id on the server side so that it becomes _378552 and is treated as a string, preventing Chrome from automatically sorting it.

Once I have retrieved the data, I remove the underscore from the thread_id to access it properly. This workaround has successfully resolved the sorting issue, which seems to be specific to the Chrome browser.

I am interested in organizing a three-dimensional array using JavaScript

Answer №1

Answer №2

Similar questions

Use PHP to redirect a webpage as an alternative to utilizing JavaScript

Utilizing JavaScript to dynamically resize an element within a slide as soon as the slider transitions to the following slide

What is the best way to update my React components to switch from a dark theme to a light theme?

What is the most efficient method for executing over 1,000 queries on MongoDB using nodejs?

Retrieving data from a multidimensional array using PHP

Modify the tooltip of the selected item in an ng-repeat loop in AngularJS

Adjusting firebugx.js for compatibility with Internet Explorer Developer Tools

Grab the div, position it accurately, and initiate an ajax call

Getting data before the Router is loaded following authentication with Angular 2+ - A comprehensive guide

Uploading files with node.js and express

Having trouble with the response function not functioning properly within an AJAX autocomplete

Is it possible to create an online game using JavaScript?

Creating a line graph using chart.js and JSON dataset

Converting Emoji to PNG or JPG using Node.js - What's the Procedure?

Combine the values of identical keys from multiple objects in an array by utilizing the forEach method in JavaScript

I am continuously encountering an error message saying [$injector:modulerr] while working with AngularJS

Updating a property in an object within an Angular service and accessing it in a different controller

Update the array in state by adding a new element using setState

troubleshooting problems with AJAX calls and routing in Angular

What is the best way to populate a div with multiple other div elements?