我有一个使用Laravel雄辩的ORM从我的DB中抓取的对象集合(我不是使用Laravel,只是将雄辩的内容集成到我自己的框架中)。我使用转换方法对集合进行迭代,并对每个记录的一个列进行unserialize,然后使用塌陷将所有未序列化的对象放在一个数组中。
这里是逻辑:
$orders = Order::where('user', $user)->orderBy('id', 'desc')->get();
$orders->transform(function($order, $key) {
$order->cart = unserialize($order->cart);
$items = $order->cart->items;
return $items;
});
$collapsed = $orders->collapse();和输出:
[
{
"qty": "2",
"price": 200,
"item": {
"id": 1,
"title": "Black Hoodie",
"img": "https://s3.amazonaws.com/bucket/black-hoodie.jpg",
"description": "Plain Black Hoodie.",
"price": 100
}
},
{
"qty": "2",
"price": 200,
"item": {
"id": 2,
"title": "Green Hoodie",
"img": "https://s3.amazonaws.com/bucket/green-hoodie.jpg",
"description": "Plain Green Hoodie.",
"price": 100
}
},
{
"qty": 1,
"price": 100,
"item": {
"id": 2,
"title": "Green Hoodie",
"img": "https://s3.amazonaws.com/bucket/green-hoodie.jpg",
"description": "Plain Green Hoodie.",
"price": 100
}
},
{
"qty": 1,
"price": 100,
"item": {
"id": 1,
"title": "Black Hoodie",
"img": "https://s3.amazonaws.com/bucket/black-hoodie.jpg",
"description": "Plain Black Hoodie.",
"price": 100
}
}
]接下来,我要完成的是将数组中所有相同的对象(最好是通过它们的"item":{"id"}值)组合到一个对象中--将它们的qty和price属性相加在一起,使item属性保持不变。
我想要的输出是
[
{
"qty": "3",
"price": 300,
"item": {
"id": 1,
"title": "Black Hoodie",
"img": "https://s3.amazonaws.com/bucket/black-hoodie.jpg",
"description": "Plain Black Hoodie.",
"price": 100
}
},
{
"qty": "3",
"price": 300,
"item": {
"id": 2,
"title": "Green Hoodie",
"img": "https://s3.amazonaws.com/bucket/green-hoodie.jpg",
"description": "Plain Green Hoodie.",
"price": 100
}
}
]雄辩有吨的伟大方法可用的集合,我只是停留在正确的组合,以有效地实现我想要做的事情。
发布于 2017-08-10 06:32:37
试试这个:
use Illuminate\Support\Fluent;
use Illuminate\Support\Collection;
// Mocking data to meet your requirements.
// Wrapping attributes inside fluent object,
// so we'll have almost same object like Eloquent model
$orders = new Collection([
new Fluent([
'qty' => 2,
'price' => 200,
'item' => new Fluent([
'id' => 1,
'price' => 100,
'title' => 'Black Hoodie',
'img' => 'https://s3.amazonaws.com/bucket/black-hoodie.jpg',
'description' => 'Plain Black Hoodie.',
])
]),
new Fluent([
'qty' => 2,
'price' => 200,
'item' => new Fluent([
'id' => 2,
'price' => 100,
'title' => 'Green Hoodie',
'img' => 'https://s3.amazonaws.com/bucket/green-hoodie.jpg',
'description' => 'Plain Green Hoodie.',
])
]),
new Fluent([
'qty' => 1,
'price' => 100,
'item' => new Fluent([
'id' => 2,
'price' => 100,
'title' => 'Green Hoodie',
'img' => 'https://s3.amazonaws.com/bucket/green-hoodie.jpg',
'description' => 'Plain Green Hoodie.',
])
]),
new Fluent([
'qty' => 1,
'price' => 100,
'item' => new Fluent([
'id' => 1,
'price' => 100,
'title' => 'Black Hoodie',
'img' => 'https://s3.amazonaws.com/bucket/black-hoodie.jpg',
'description' => 'Plain Black Hoodie.',
])
])
]);
// Here's something you might interested
$result = $orders->groupBy('item.id')
->map(function ($orders, $itemId) {
return new Fluent([
'qty' => $orders->sum('qty'), // calculating quantity
'price' => $orders->sum('price'), // calculating total price
'item' => $orders->first()->item // leave the item as it is
]);
});
// You may evaluate the result here
dd($result);更新
更多的“原始”例子:
use Illuminate\Support\Collection;
$orderOne = [
'id' => 1,
'price' => 100,
'title' => 'Black Hoodie',
'img' => 'https://s3.amazonaws.com/bucket/black-hoodie.jpg',
'description' => 'Plain Black Hoodie.',
];
$orderTwo = [
'id' => 2,
'price' => 100,
'title' => 'Green Hoodie',
'img' => 'https://s3.amazonaws.com/bucket/green-hoodie.jpg',
'description' => 'Plain Green Hoodie.',
];
$orders = new Collection([
[
'qty' => 2,
'price' => 200,
'item' => $orderOne
],
[
'qty' => 2,
'price' => 200,
'item' => $orderTwo
],
[
'qty' => 1,
'price' => 100,
'item' => $orderTwo
],
[
'qty' => 1,
'price' => 100,
'item' => $orderOne
]
]);
$result = $orders->groupBy('item.id')
->map(function ($orders, $itemId) {
return [
'qty' => $orders->sum('qty'),
'price' => $orders->sum('price'),
'item' => $orders->first()['item']
];
});
dd($result);https://stackoverflow.com/questions/45584164
复制相似问题