我有一个结束点，当前的响应如下所示，当我们使用groupBy（）查询时，它只返回一行，但是如何获得带有隐藏分组值的嵌套json .
//controller
public function products()
{
$get_products = Product::groupBy('name')
->get();
$data = [
'data' => $get_products
];
return Response::json(
$data_with_status = array_merge($this->respondSuccess('query successfull'), $data)
);
}
//json response
{
"status_code": 200,
"status_message": "query successfull",
"data": [
{
"id": 1,
"name": "onion",
"proportion": "500 gm",
"mrp": "25",
"price": "22",
"status": "1"
}
]
}
预期的结果如下，是否有查询来实现这一目标，
{
"status_code": 200,
"status_message": "query successfull",
"data": [
{
"id": 1,
"name": "onion",
"proportion": {
"0": "500 gm",
"1": "1 kg",
}
"mrp": "25",
"price": "22",
"status": "1"
},
{
"id": 2,
"name": "tomato",
"proportion": "500 gm"
"mrp": "20",
"price": "15",
"status": "1"
}
]
}
数据库架构如下
Schema::create('products', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->string('proportion');
$table->string('mrp');
$table->string('price');
$table->enum('status', ['available','unavailable']);
$table->timestamps();
$table->softDeletes();
});
从产品表中分组的样本数据
id name proportion mrp price status
1 onion 500 gm 25 22 1
2 onion 1 kg 50 44 1
3 tomato 500 gm 20 15 1
如果产品名称相同则意味着如果产品具有多个比例我想要对产品进行分组并将比例合并到json中，如上面预期的json结果所示 .
谢谢
1 回答
使用
group_cancat()-