Transform Array to Object In Laravel

Question

I have the following data being returned from my controller:

[
  {
    "date": "2019-12-06",
    "weekday": "Friday",
    "users": 2
  },
  {
    "date": "2019-12-07",
    "weekday": "Saturday",
    "users": 1
  },
  {
    "date": "2019-12-08",
    "weekday": "Sunday",
    "users": 1
  },
  {
    "date": "2019-12-09",
    "weekday": "Monday",
    "users": 1
  },
  {
    "date": "2019-12-10",
    "weekday": "Tuesday",
    "users": 1
  },
  {
    "date": "2019-12-11",
    "weekday": "Wednesday",
    "users": 2
  }
]

I want to return this instead:

{
    "Sunday": 1,
    "Monday": 1,
    "Tuesday": 1,
    "Wednesday": 2,
    "Thursday": 0,
    "Friday": 2,
    "Saturday": 1
}

Where the numbers in the object are the "users" in the previous array, how would I go about this please?

Davit Zeynalyan · Accepted Answer · 2019-12-12 09:26:16Z

You can use like this

$data = collect($data);
$result = $data->pluck('weekday', 'users');

Then order as you want

Full solution

$data = '[
  {
    "date": "2019-12-06",
    "weekday": "Friday",
    "users": 2
  },
  {
    "date": "2019-12-07",
    "weekday": "Saturday",
    "users": 1
  },
  {
    "date": "2019-12-08",
    "weekday": "Sunday",
    "users": 1
  },
  {
    "date": "2019-12-09",
    "weekday": "Monday",
    "users": 1
  },
  {
    "date": "2019-12-10",
    "weekday": "Tuesday",
    "users": 1
  },
  {
    "date": "2019-12-11",
    "weekday": "Wednesday",
    "users": 2
  }
]';


$data = json_decode($data);
$data = collect($data);
$orders = [
    "Sunday",
    "Monday",
    "Tuesday",
    "Wednesday",
    "Thursday",
    "Friday",
    "Saturday"
];

$result = new stdClass();
foreach ($orders as $weekday) {
    $result->{$weekday} = $data->where('weekday', $weekday)->first()->users ?? 0;
}

dd($result);

result is

need to add 'thursday' to it since it didn't exist in the records but is in the desired output

rafwell · Accepted Answer · 2019-12-11 18:54:34Z

You can use collection.

$yourArray = json_decode('[
    {
        "date": "2019-12-06",
        "weekday": "Friday",
        "users": 2
    },
    {
        "date": "2019-12-07",
        "weekday": "Saturday",
        "users": 1
    },
    {
        "date": "2019-12-08",
        "weekday": "Sunday",
        "users": 1
    },
    {
        "date": "2019-12-09",
        "weekday": "Monday",
        "users": 1
    },
    {
        "date": "2019-12-10",
        "weekday": "Tuesday",
        "users": 1
    },
    {
        "date": "2019-12-11",
        "weekday": "Wednesday",
        "users": 2
    }
    ]');

$collect = collect($yourArray);
$groupped = $collect->groupBy('weekday');

$daysOfWeek = [];

foreach($groupped as $dayName => $items){
    $daysOfWeek[$dayName] = collect($items)->sum('users');
}

dd($daysOfWeek);

need to add 'thursday' which isnt in the input but is in the desired output

Collectives™ on Stack Overflow

Transform Array to Object In Laravel

2 Answers 2

2 Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Related