Laravel - How to sort array objects by timestamp value of different keys?

Question

I have this array of objects from a Laravel merged collection, accessed like this, $collection->values()->all(), which returns the following:

 [
  {
    "id": "1",
    "type": "Teacher",
    "created_at": "2017-05-11 18:00:00"
  },
  {
    "id": "2",
    "type": "Student"
    "created_at": "2017-05-11 15:00:00"
  },
  {
    "id": "3",
    "type": "Course",
    "data": {
       "title: "PHP",
       "created_at": "2017-05-11 16:00:00"
    }
  }
]

I am trying to sort the order by the created_at field, so it looks like this:

 [
  {
    "id": "1",
    "type": "Teacher",
    "created_at": "2017-05-11 18:00:00"
  },
  {
    "id": "3",
    "type": "Course",
    "data": {
       "title: "PHP",
       "created_at": "2017-05-11 16:00:00"
    }
  },
  {
    "id": "2",
    "type": "Student"
    "created_at": "2017-05-11 15:00:00"
  }
]

The issue is that created_at is in two locations, sometimes it's under created_at and other times it's under data.created_at.

And what is the problem?

u_mulder
– u_mulder

2017-05-18 19:35:40 +00:00
Commented May 18, 2017 at 19:35 — u_mulder
– u_mulder, Commented May 18, 2017 at 19:35
@mimo's answer does exactly what you need

Sandeesh
– Sandeesh

2017-05-18 19:44:59 +00:00
Commented May 18, 2017 at 19:44 — Sandeesh
– Sandeesh, Commented May 18, 2017 at 19:44

cre8 · Accepted Answer · 2017-05-18 19:40:48Z

4

I think you can use the sortByDescfunction:

$sorted = $collection->sortByDesc(function ($element) {
    return $element->data ? $element->data->created_at : $element->created_at;
});

edited May 18, 2017 at 19:40

answered May 18, 2017 at 19:36

cre8

13.6k8 gold badges42 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sandeesh Over a year ago

Switch to sortByDesc since the author wants to sort the date in descending order.

Collectives™ on Stack Overflow

Laravel - How to sort array objects by timestamp value of different keys?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related