如何格式化这个关联抓取序列化

Question

我有两个表，产品和订单的多对多关联。在数据透视表中，我保存了产品的id、数量和价格。当我获取产品时，我需要该产品的名称，但要获取名称，我需要进入产品表。我取回的响应像这样

{
"id": 111,
"name": "Matheus",
"phonenumber": "69993750103",
"reference": null,
"value_subtotal": "10.000",
"value_delivery": "5.000",
"value_total": "15.000",
"status": "pending",
"products": [
{
"name": "Açai 350ml",
"OrdersProducts": {
"quantity": 2,
"price": "0.000"
}
},
{
"name": "acai 350ml",
"OrdersProducts": {
"quantity": 3,
"price": "0.000"
}
}
]
}

但是我需要这种格式的json

{
"id": 111,
"name": "Matheus",
"street": "Rua olavo bilac",
"phonenumber": "69993750103",
"number": "3511",
"reference": null,
"note": "Retirar o morango",
"value_subtotal": "10.000",
"value_delivery": "5.000",
"value_total": "15.000",
"status": "pending",
"createdAt": "2021-10-20T18:26:25.000Z",
"updatedAt": "2021-10-20T18:26:25.000Z",
"products": [
{
"name": "Açai 350ml",
// here the difference, i want create a single object in the return, with all data i need of the product
"quantity": 2,
"price": "0.000"
}
},
{
"name": "acai 350ml",
"quantity": 3,
"price": "0.000"

}
]
}

我的控制器

async getOrder(req, res) {
const { id } = req.params;
const order = await Orders.findByPk(id, {include: [{
association: 'products',
attributes: ['name'],
through: {
attributes:['quantity', 'price'],


},
raw: true,
}]})
if (!order) return res.status(404).send({ message: 'order ${`id`}' })
return res.json(order);
},

Answer 1

var a = {
"id": 111,
"name": "Matheus",
"phonenumber": "69993750103",
"reference": null,
"value_subtotal": "10.000",
"value_delivery": "5.000",
"value_total": "15.000",
"status": "pending",
"products": [{
"name": "Açai 350ml",
"OrdersProducts": {
"quantity": 2,
"price": "0.000"
}
},
{
"name": "acai 350ml",
"OrdersProducts": {
"quantity": 3,
"price": "0.000"
}
}
]
};
var orders = [];
orders.push(a);
var updatedOrders = orders.map(function(order) {
order.products.forEach(function(product) {
product.price = product.OrdersProducts.price;
product.quantity = product.OrdersProducts.quantity;
delete product.OrdersProducts;
});
return order;
});
console.log(updatedOrders);

Answer 2

也许你可以实现查询没有关联，但使用模型。

async getOrder(req, res) {
const { id } = req.params;
const order = await Orders.findByPk(id, {include: [{
model: Product,
attributes: ['name'],
include: [{
association: "OrdersProducts",
attributes:['quantity', 'price'], 
raw: true,
}],
}]})
if (!order) return res.status(404).send({ message: 'order ${`id`}' })
return res.json(order);
},

你仍然会得到秩序。数量和订单。

价格作为产品的名称

Answer 3

如果您可以控制订单和/或产品对象，则可以添加custom toJSON方法。您可以将json输出格式化为您想要的格式。https://futurestud.io/tutorials/create-a-custom-tojson-function-in-node-js-and-javascript

如果您无法控制对象，则可以创建一个函数来格式化顺序。

const order = {
"id": 111,
"name": "Matheus",
"phonenumber": "69993750103",
"reference": null,
"value_subtotal": "10.000",
"value_delivery": "5.000",
"value_total": "15.000",
"status": "pending",
"products": [
{
"name": "Açai 350ml",
"OrdersProducts": {
"quantity": 2,
"price": "0.000"
}
},
{
"name": "acai 350ml",
"OrdersProducts": {
"quantity": 3,
"price": "0.000"
}
}
]

};

order.products = order.products.map(({OrdersProducts, ...other}) => ({...other, ...OrdersProducts})); 

我更喜欢自定义toJSON方法。当然，这取决于对对象结构的访问。