Customizing Array

Question

I had a Response coming like a JSON array like below and I need to sort out the JSON containing the same roleId and TenantId and send them with all the features in the same array.

[
    {
        "roleId": 1,
        "role": "admin",
        "featureId": 1,
        "feature": "Dashboard",
        "tenantId": 1,
        "tenant": "Admin"
    },
    {
        "roleId": 1,
        "role": "admin",
        "featureId": 2,
        "feature": "Overview",
        "tenantId": 1,
        "tenant": "Admin"
    },
    {
        "roleId": 1,
        "role": "admin",
        "featureId": 3,
        "feature": "Devices",
        "tenantId": 1,
        "tenant": "Admin"
    },
    {
        "roleId": 1,
        "role": "admin",
        "featureId": 4,
        "feature": "Map View",
        "tenantId": 1,
        "tenant": "Admin"
    }
]

I need to customize it and return as a response like below grouping by tenantid and role in a sub json

{
    "roleId": 1,
    "role": "admin",
    "features": [
        {
            "featureId": 1,
            "feature": "Dashboard"
        },
        {
            "featureId": 2,
            "feature": "Overview",
        },
        {
            "featureId": 4,
            "feature": "Map View",
        },
        {
            "featureId": 3,
            "feature": "Devices",
        }
    ],
    "tenantId": 1,
    "tenant": "Admin"
},
{
    "roleId": 2,
    "role": "monitor",
    "features": [
        {
            "featureId": 1,
            "feature": "Dashboard"
        },
        {
            "featureId": 2,
            "feature": "Overview",
        },
        {
            "featureId": 4,
            "feature": "Map View",
        },
        {
            "featureId": 3,
            "feature": "Devices",
        }
    ],
    "tenantId": 1,
    "tenant": "Admin"
}

Expected UI should be something like below after integration

UI Image

Please help me out in this

Thanks in advance

You can not have same index in your desired output array. they will get overWritten [feature,featureId ... etc]. See here:- 3v4l.org/Ze2SY — Death-is-the-real-truth
– Death-is-the-real-truth, Commented May 8, 2019 at 7:03
That can't be parsed back to an array later, you know that? An array can only have one key with the same name in the same subarray — Andreas
– Andreas, Commented May 8, 2019 at 7:04
I have changed the required response, can you please look @AlivetoDie — kishan
– kishan, Commented May 8, 2019 at 9:53

Death-is-the-real-truth · Accepted Answer · 2019-05-09 04:07:31Z

1

1.You need to decode your json data using json_decode()

2.Then you need to use foreach() to loop this data

3.Now create a new array and assign values to this array inside loop by making roleId as array keys[so that same roleId values will goes to same child-array automatically]

4.Now do array_values() to re-index the final array

5.Encode this using json_encode() to get desired format.

Code:-

$array = json_decode( $json , true);

$final_array = array();

foreach($array as $arr){
    $final_array[$arr['roleId']]['roleId'] = $arr['roleId'];
    $final_array[$arr['roleId']]['role'] = $arr['role'];
    $final_array[$arr['roleId']]['feature'][] = array('featureId'=>$arr['featureId'],'feature'=>$arr['feature']);
}

$final_array = array_values($final_array);
echo json_encode($final_array);

Output:-https://3v4l.org/CuCI2

edited May 9, 2019 at 4:07

answered May 8, 2019 at 10:21

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

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

Collectives™ on Stack Overflow

Customizing Array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related