CODEWITHSUNDEEP
phplithium
Ramin Firooz
Ramin Firooz

Reputation: 506

ORM: List of related items

I tried to use ORM to find list of provinces and their cities.

the result is same as this list:

"provinces": [
    {
        "name": "Prov.1",
        "Cities": {
            "name": "City.1"
        }
    },
    {
        "name": "Prov.1",
        "Cities": {
            "name": "City.2"
        }
    },
]

what is expected:

"provinces": [
    {
        "name": "Prov.1",
        "Cities": [
            {
                "name": "City.1"
            },
            {
                "name": "City.2"
            }
        ]
    },
]

used ORM:

Provinces::find('all', [
    'with' => ['Cities']
]);

Upvotes: 1

Views: 73

Answers (1)

ArtisticPhoenix
ArtisticPhoenix

Reputation: 21681

Something like

$array = [];
foreach($provinces as $province){
    $key = $province['name'];
    if(!isset($array[$key])){
       $array[$key] = [
         'name' => $province['name'], 
         'Cities' => [
              [ 'name' => $province['Cities']['name']];
          ]
       ];
    }else{
       $array[$key]['Cities'][] = ['name' => $province['Cities']['name']];
    }
}

 //strip keys
$array = array_values($array);

Because you don't have an actual PHP array posted I'm just guessing at what it should be.

Upvotes: 1

Related Questions