What is the most efficient way to organize these arrays?

Question

What is the most efficient way to organize these arrays?

I've been racking my brain trying to figure out a sorting logic for some arrays, but I'm stumped. Maybe you have an idea?

Imagine we have an array of objects structured like this:

let obj = {day:'2', month:'6', year:'1938' }

The array would look something like this:

let array = [{year:'1938, month:'6', day:'3'},{year:'1935', month:'5', day:'3'},{year:'1935, month:'', day:''}, {year:'1935', month:'5', day:''}, {year:'1934}, month:'3', day:''}, {year:'1934', month:'3', day:'15'}, {year:'1934}, month:'', day:''}];

I want the sorted array to look like this:

let sortedArray = [{year:'1934}, month:'', day:''},{year:'1934}, month:'3', day:''},{year:'1934}, month:'3', day:'15'},{year:'1935, month:'', day:''},{year:'1935', month:'5', day:''},{year:'1935', month:'5', day:'3'},{year:'1938, month:'6', day:'3'}

The year, month, and day fields are not required in my app, but I want to display them sorted chronologically starting with objects that only have the year, then those with year and month, and finally those with all three elements. This helps me build a timeline.

I tried creating 3 separate arrays - one for objects with only years, one for those with years and months, and another for objects with all fields filled.

My approach looked something like this:

 // code snippet

Unfortunately, my logic hit a roadblock when I had to compare months between different arrays. If there's a solution to sort the array as described, your help would be greatly appreciated. Thank you!

javascript arrays

Answer 1

Answer №1

You may want to experiment with filtering the groups, converting each to a date, and then sorting them within each group.

There is potential for enhancement in this code snippet.

const array = [
  {year:'1938', month:'6', day:'3'},
  {year:'1935', month:'5', day:'3'}, 
  {year:'1935', month:'', day:''}, 
  {year:'1935', month:'5', day:''}, 
  {year:'1934', month:'3', day:''}, 
  {year:'1934', month:'3', day:'15'}, 
  {year:'1934', month:'', day:''}
];

const yearSort = array => {
  return array.filter(item => item.year && !item.month && !item.day).map(item => { 
    return {
      item,
      date: new Date(parseInt(item.year),0,1)
    }
  }).sort((a,b) => a.date < b.date ? -1 : 1)
      .map(i => i.item)
}

const yearMonthSort = array => {
  return array.filter(item => item.year && item.month && !item.day).map(item => { 
    return {
      item,
      date: new Date(parseInt(item.year),item.month - 1,1)
    }
  }).sort((a,b) => a.date < b.date ? -1 : 1)
      .map(i => i.item)
}

const yearMonthDaySort = array => {
  return array.filter(item => item.year && item.month && item.day).map(item => { 
    return {
      item,
      date: new Date(parseInt(item.year),item.month - 1,parseInt(item.day))
    }
  }).sort((a,b) => a.date < b.date ? -1 : 1)
      .map(i => i.item)
}


const sortedResults = yearSort(array)
                .concat(yearMonthSort(array))
                  .concat(yearMonthDaySort(array))

console.log({ sortedResults });

Answer 2

You may want to experiment with filtering the groups, converting each to a date, and then sorting them within each group.

There is potential for enhancement in this code snippet.

const array = [
  {year:'1938', month:'6', day:'3'},
  {year:'1935', month:'5', day:'3'}, 
  {year:'1935', month:'', day:''}, 
  {year:'1935', month:'5', day:''}, 
  {year:'1934', month:'3', day:''}, 
  {year:'1934', month:'3', day:'15'}, 
  {year:'1934', month:'', day:''}
];

const yearSort = array => {
  return array.filter(item => item.year && !item.month && !item.day).map(item => { 
    return {
      item,
      date: new Date(parseInt(item.year),0,1)
    }
  }).sort((a,b) => a.date < b.date ? -1 : 1)
      .map(i => i.item)
}

const yearMonthSort = array => {
  return array.filter(item => item.year && item.month && !item.day).map(item => { 
    return {
      item,
      date: new Date(parseInt(item.year),item.month - 1,1)
    }
  }).sort((a,b) => a.date < b.date ? -1 : 1)
      .map(i => i.item)
}

const yearMonthDaySort = array => {
  return array.filter(item => item.year && item.month && item.day).map(item => { 
    return {
      item,
      date: new Date(parseInt(item.year),item.month - 1,parseInt(item.day))
    }
  }).sort((a,b) => a.date < b.date ? -1 : 1)
      .map(i => i.item)
}


const sortedResults = yearSort(array)
                .concat(yearMonthSort(array))
                  .concat(yearMonthDaySort(array))

console.log({ sortedResults });

Answer 3

Answer №2

When creating a sort compare function, start by checking the year; if they are the same, then check the month, and finally, the day.

Convert all values to numbers and then compare them.
An empty string will be converted to 0 when using the + operator.

const array = [
  { year: "1938", month: "6", day: "3" },
  { year: "1935", month: "5", day: "3" },
  { year: "1935", month: "", day: "" },
  { year: "1935", month: "5", day: "" },
  { year: "1934", month: "3", day: "" },
  { year: "1934", month: "3", day: "15" },
  { year: "1934", month: "", day: "" },
];

array.sort((a, b) => {
  if (a.year === b.year) {
    if (a.month === b.month) {
      return +a.day - +b.day;
    }
    return +a.month - +b.month;
  }
  return +a.year - +b.year;
});

console.log(array);

Answer 4

When creating a sort compare function, start by checking the year; if they are the same, then check the month, and finally, the day.

Convert all values to numbers and then compare them.
An empty string will be converted to 0 when using the + operator.

const array = [
  { year: "1938", month: "6", day: "3" },
  { year: "1935", month: "5", day: "3" },
  { year: "1935", month: "", day: "" },
  { year: "1935", month: "5", day: "" },
  { year: "1934", month: "3", day: "" },
  { year: "1934", month: "3", day: "15" },
  { year: "1934", month: "", day: "" },
];

array.sort((a, b) => {
  if (a.year === b.year) {
    if (a.month === b.month) {
      return +a.day - +b.day;
    }
    return +a.month - +b.month;
  }
  return +a.year - +b.year;
});

console.log(array);

What is the most efficient way to organize these arrays?

Answer №1

Answer №2

Similar questions

Exploring the concept of passing variables by reference in PHP with the end

When redirecting to the same component, Vue.js hooks are not triggered

"Unable to move past the initial segment due to an ongoing

Why is AJAX returning false and I'm unable to figure out the reason?

How to extract IDs from a URL in Angular

How can I notify a particular user using Node.js?

Finding the index of a row using jQuery

Instructions on creating a number increment animation resembling Twitter's post engagement counter

What is the method for altering the background color of an input field upon entering text?

A function that listens for the onmouseover event and updates the image source of an HTML img element

What is the process for including an optional ngModelGroup in Angular forms?

What is the reasoning behind the return type of void for Window.open()?

The GAS and Bootstrap web form is able to search for and display data in a table format. However, it lacks the functionality to display clickable links or hyperlinks directly from the spreadsheet

Understanding how to retrieve the value count by comparing strings in JavaScript

Building a custom Vuetify extension to enhance core features

The email validation UI dialog is failing to display any dialog

Lowest value malfunctioning

Button for searching through the Bootstrap navigation bar

Enhance multiple select functionality

Verify the string to see if it contains a Steam game key