Skip to content

Instantly share code, notes, and snippets.

@lucasdzuc

lucasdzuc/query.js

Last active August 21, 2023 22:57
Show Gist options
  • Save lucasdzuc/37fac1a2e5e391cd92eb30ace8e13505 to your computer and use it in GitHub Desktop.
Save lucasdzuc/37fac1a2e5e391cd92eb30ace8e13505 to your computer and use it in GitHub Desktop.
Download ZIP
Query get products of order
Raw
query.js
const sizesQuantitiesOfColorSubquery = connection('sizes_quantities_products_order')
.join('sizes', 'sizes_quantities_products_order.size_id', '=', 'sizes.id')
.select([
'sizes_quantities_products_order.color_id',
'products_order.id AS products_order_id',
connection.raw(`
json_agg(
json_build_object(
'id', sizes_quantities_products_order.id,
'size', sizes.size,
'quantity', sizes_quantities_products_order.quantity,
'color_id', sizes_quantities_products_order.color_id,
'products_order_id', sizes_quantities_products_order.products_order_id
)
) AS sizes_quantities
`)
])
.whereRaw('sizes_quantities_products_order.products_order_id = products_order.id')
.whereRaw('sizes_quantities_products_order.size_id = sizes.id')
.groupBy('sizes_quantities_products_order.color_id', 'products_order.id');
const products_order = await connection('products_order')
.join('products', 'products.id', '=', 'products_order.product_id')
.leftJoin('imagesproduct', 'imagesproduct.product_id', '=', 'products.id')
.join('products_colors', 'products_colors.product_id', '=', 'products_order.product_id')
.select([
'products_order.id',
'products_order.id as productOrderId',
'products_order.product_id',
'products_order.order_id',
'products_order.created_at',
'products_order.updated_at',
'products.id as productsId',
'products.title',
'products.model',
'products.ref',
'products.price',
'products.wholesale_price',
'imagesproduct.image',
connection.raw(`
(SELECT json_agg(
json_build_object(
'id', colors.id,
'color', colors.color,
'rgb', colors.rgb,
'isdeleted', colors.isdeleted,
'created_at', colors.created_at,
'updated_at', colors.updated_at,
'sizes_quantities', sizes_agg.sizes_quantities
)
)
FROM colors
JOIN products_colors ON colors.id = products_colors.color_id AND products_colors.product_id = products_order.product_id
JOIN (
${sizesQuantitiesOfColorSubquery}
) AS sizes_agg ON colors.id = sizes_agg.color_id
) AS colors
`),
])
// AND products_colors.product_id = products_order.product_id
.where('products_order.order_id', order.id)
.orderBy('products_order.created_at', 'desc')
.groupBy(
'products_order.id',
'products_order.product_id',
'products_order.order_id',
'products_order.created_at',
'products_order.updated_at',
'products.id',
'products.title',
'products.model',
'products.ref',
'products.price',
'products.wholesale_price',
'imagesproduct.image',
'products_colors.color_id',
'products_colors.product_id'
);
Raw
result.json
"products_order": [
{
"id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3",
"image_url": "http://192.168.0.100:3333/uploads/products/5e373643616afe751f4169da83a944d8-345884094_785741859506888_2200325217254533404_n.jpg",
"title": "Teste",
"ref": "100",
"model": "Teste",
"price": 33,
"wholesale_price": 31,
"colors": [
{
"id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"color": "Azul",
"rgb": "#245ccc",
"isdeleted": false,
"created_at": "2023-06-10T01:21:52.465859-03:00",
"updated_at": "2023-06-10T12:55:15.652046-03:00",
"sizes_quantities": [
{
"id": "6eaba215-b289-4514-a662-cf42fc8e15d9",
"size": "P",
"quantity": 1,
"color_id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "9f1827f9-64cb-41f0-bc14-b330788c03f9",
"size": "M",
"quantity": 2,
"color_id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "b8281853-c481-42e2-af85-7f89e65a0152",
"size": "G",
"quantity": 0,
"color_id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
},
{
"id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"color": "Preto",
"rgb": "#000000",
"isdeleted": false,
"created_at": "2023-05-16T13:25:54.747359-03:00",
"updated_at": "2023-08-15T18:48:21.022358-03:00",
"sizes_quantities": [
{
"id": "dccf91e8-6711-46b5-a43d-81975f5d153d",
"size": "P",
"quantity": 2,
"color_id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "b25eaf50-f41a-4159-bd55-abc3f9e23573",
"size": "M",
"quantity": 2,
"color_id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "5a7379b1-6158-4880-bff0-701b9f41da79",
"size": "G",
"quantity": 2,
"color_id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
},
{
"id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"color": "Branco",
"rgb": "#ffffff",
"isdeleted": false,
"created_at": "2023-05-16T16:33:46.774047-03:00",
"updated_at": "2023-06-10T12:55:14.925664-03:00",
"sizes_quantities": [
{
"id": "7a87dcad-9729-478f-99e1-b7731d2d462a",
"size": "P",
"quantity": 0,
"color_id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "c0080f60-bafc-4e80-a918-ea4c3a722d2a",
"size": "M",
"quantity": 0,
"color_id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "7f806fa9-36b2-410e-906a-3c61adbacfc4",
"size": "G",
"quantity": 0,
"color_id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
},
{
"id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"color": "Rosa",
"rgb": "#fa0588",
"isdeleted": false,
"created_at": "2023-06-10T00:58:11.82061-03:00",
"updated_at": "2023-06-10T12:55:15.238133-03:00",
"sizes_quantities": [
{
"id": "0a062a53-ca42-498f-ac6b-0ef7925e5e05",
"size": "M",
"quantity": 0,
"color_id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "4ff43b38-a800-4a1f-9ff6-cbd920721bcc",
"size": "G",
"quantity": 0,
"color_id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "8ca538bd-a6cd-4df6-a16e-b9b36598a5be",
"size": "P",
"quantity": 0,
"color_id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
}
]
},
{
"id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3",
"image_url": "http://192.168.0.100:3333/uploads/products/5e373643616afe751f4169da83a944d8-345884094_785741859506888_2200325217254533404_n.jpg",
"title": "Teste",
"ref": "100",
"model": "Teste",
"price": 33,
"wholesale_price": 31,
"colors": [
{
"id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"color": "Azul",
"rgb": "#245ccc",
"isdeleted": false,
"created_at": "2023-06-10T01:21:52.465859-03:00",
"updated_at": "2023-06-10T12:55:15.652046-03:00",
"sizes_quantities": [
{
"id": "6eaba215-b289-4514-a662-cf42fc8e15d9",
"size": "P",
"quantity": 1,
"color_id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "9f1827f9-64cb-41f0-bc14-b330788c03f9",
"size": "M",
"quantity": 2,
"color_id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "b8281853-c481-42e2-af85-7f89e65a0152",
"size": "G",
"quantity": 0,
"color_id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
},
{
"id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"color": "Preto",
"rgb": "#000000",
"isdeleted": false,
"created_at": "2023-05-16T13:25:54.747359-03:00",
"updated_at": "2023-08-15T18:48:21.022358-03:00",
"sizes_quantities": [
{
"id": "dccf91e8-6711-46b5-a43d-81975f5d153d",
"size": "P",
"quantity": 2,
"color_id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "b25eaf50-f41a-4159-bd55-abc3f9e23573",
"size": "M",
"quantity": 2,
"color_id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "5a7379b1-6158-4880-bff0-701b9f41da79",
"size": "G",
"quantity": 2,
"color_id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
},
{
"id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"color": "Branco",
"rgb": "#ffffff",
"isdeleted": false,
"created_at": "2023-05-16T16:33:46.774047-03:00",
"updated_at": "2023-06-10T12:55:14.925664-03:00",
"sizes_quantities": [
{
"id": "7a87dcad-9729-478f-99e1-b7731d2d462a",
"size": "P",
"quantity": 0,
"color_id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "c0080f60-bafc-4e80-a918-ea4c3a722d2a",
"size": "M",
"quantity": 0,
"color_id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "7f806fa9-36b2-410e-906a-3c61adbacfc4",
"size": "G",
"quantity": 0,
"color_id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
},
{
"id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"color": "Rosa",
"rgb": "#fa0588",
"isdeleted": false,
"created_at": "2023-06-10T00:58:11.82061-03:00",
"updated_at": "2023-06-10T12:55:15.238133-03:00",
"sizes_quantities": [
{
"id": "0a062a53-ca42-498f-ac6b-0ef7925e5e05",
"size": "M",
"quantity": 0,
"color_id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "4ff43b38-a800-4a1f-9ff6-cbd920721bcc",
"size": "G",
"quantity": 0,
"color_id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "8ca538bd-a6cd-4df6-a16e-b9b36598a5be",
"size": "P",
"quantity": 0,
"color_id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
}
]
},
{
"id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3",
"image_url": "http://192.168.0.100:3333/uploads/products/5e373643616afe751f4169da83a944d8-345884094_785741859506888_2200325217254533404_n.jpg",
"title": "Teste",
"ref": "100",
"model": "Teste",
"price": 33,
"wholesale_price": 31,
"colors": [
{
"id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"color": "Azul",
"rgb": "#245ccc",
"isdeleted": false,
"created_at": "2023-06-10T01:21:52.465859-03:00",
"updated_at": "2023-06-10T12:55:15.652046-03:00",
"sizes_quantities": [
{
"id": "6eaba215-b289-4514-a662-cf42fc8e15d9",
"size": "P",
"quantity": 1,
"color_id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "9f1827f9-64cb-41f0-bc14-b330788c03f9",
"size": "M",
"quantity": 2,
"color_id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "b8281853-c481-42e2-af85-7f89e65a0152",
"size": "G",
"quantity": 0,
"color_id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
},
{
"id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"color": "Preto",
"rgb": "#000000",
"isdeleted": false,
"created_at": "2023-05-16T13:25:54.747359-03:00",
"updated_at": "2023-08-15T18:48:21.022358-03:00",
"sizes_quantities": [
{
"id": "dccf91e8-6711-46b5-a43d-81975f5d153d",
"size": "P",
"quantity": 2,
"color_id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "b25eaf50-f41a-4159-bd55-abc3f9e23573",
"size": "M",
"quantity": 2,
"color_id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "5a7379b1-6158-4880-bff0-701b9f41da79",
"size": "G",
"quantity": 2,
"color_id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
},
{
"id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"color": "Branco",
"rgb": "#ffffff",
"isdeleted": false,
"created_at": "2023-05-16T16:33:46.774047-03:00",
"updated_at": "2023-06-10T12:55:14.925664-03:00",
"sizes_quantities": [
{
"id": "7a87dcad-9729-478f-99e1-b7731d2d462a",
"size": "P",
"quantity": 0,
"color_id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "c0080f60-bafc-4e80-a918-ea4c3a722d2a",
"size": "M",
"quantity": 0,
"color_id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "7f806fa9-36b2-410e-906a-3c61adbacfc4",
"size": "G",
"quantity": 0,
"color_id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
},
{
"id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"color": "Rosa",
"rgb": "#fa0588",
"isdeleted": false,
"created_at": "2023-06-10T00:58:11.82061-03:00",
"updated_at": "2023-06-10T12:55:15.238133-03:00",
"sizes_quantities": [
{
"id": "0a062a53-ca42-498f-ac6b-0ef7925e5e05",
"size": "M",
"quantity": 0,
"color_id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "4ff43b38-a800-4a1f-9ff6-cbd920721bcc",
"size": "G",
"quantity": 0,
"color_id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "8ca538bd-a6cd-4df6-a16e-b9b36598a5be",
"size": "P",
"quantity": 0,
"color_id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
}
]
},
{
"id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3",
"image_url": "http://192.168.0.100:3333/uploads/products/5e373643616afe751f4169da83a944d8-345884094_785741859506888_2200325217254533404_n.jpg",
"title": "Teste",
"ref": "100",
"model": "Teste",
"price": 33,
"wholesale_price": 31,
"colors": [
{
"id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"color": "Azul",
"rgb": "#245ccc",
"isdeleted": false,
"created_at": "2023-06-10T01:21:52.465859-03:00",
"updated_at": "2023-06-10T12:55:15.652046-03:00",
"sizes_quantities": [
{
"id": "6eaba215-b289-4514-a662-cf42fc8e15d9",
"size": "P",
"quantity": 1,
"color_id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "9f1827f9-64cb-41f0-bc14-b330788c03f9",
"size": "M",
"quantity": 2,
"color_id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "b8281853-c481-42e2-af85-7f89e65a0152",
"size": "G",
"quantity": 0,
"color_id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
},
{
"id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"color": "Preto",
"rgb": "#000000",
"isdeleted": false,
"created_at": "2023-05-16T13:25:54.747359-03:00",
"updated_at": "2023-08-15T18:48:21.022358-03:00",
"sizes_quantities": [
{
"id": "dccf91e8-6711-46b5-a43d-81975f5d153d",
"size": "P",
"quantity": 2,
"color_id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "b25eaf50-f41a-4159-bd55-abc3f9e23573",
"size": "M",
"quantity": 2,
"color_id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "5a7379b1-6158-4880-bff0-701b9f41da79",
"size": "G",
"quantity": 2,
"color_id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
},
{
"id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"color": "Branco",
"rgb": "#ffffff",
"isdeleted": false,
"created_at": "2023-05-16T16:33:46.774047-03:00",
"updated_at": "2023-06-10T12:55:14.925664-03:00",
"sizes_quantities": [
{
"id": "7a87dcad-9729-478f-99e1-b7731d2d462a",
"size": "P",
"quantity": 0,
"color_id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "c0080f60-bafc-4e80-a918-ea4c3a722d2a",
"size": "M",
"quantity": 0,
"color_id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "7f806fa9-36b2-410e-906a-3c61adbacfc4",
"size": "G",
"quantity": 0,
"color_id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
},
{
"id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"color": "Rosa",
"rgb": "#fa0588",
"isdeleted": false,
"created_at": "2023-06-10T00:58:11.82061-03:00",
"updated_at": "2023-06-10T12:55:15.238133-03:00",
"sizes_quantities": [
{
"id": "0a062a53-ca42-498f-ac6b-0ef7925e5e05",
"size": "M",
"quantity": 0,
"color_id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "4ff43b38-a800-4a1f-9ff6-cbd920721bcc",
"size": "G",
"quantity": 0,
"color_id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "8ca538bd-a6cd-4df6-a16e-b9b36598a5be",
"size": "P",
"quantity": 0,
"color_id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
}
]
},
{
"id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3",
"image_url": "http://192.168.0.100:3333/uploads/products/5e373643616afe751f4169da83a944d8-345884094_785741859506888_2200325217254533404_n.jpg",
"title": "Teste",
"ref": "100",
"model": "Teste",
"price": 33,
"wholesale_price": 31,
"colors": [
{
"id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"color": "Azul",
"rgb": "#245ccc",
"isdeleted": false,
"created_at": "2023-06-10T01:21:52.465859-03:00",
"updated_at": "2023-06-10T12:55:15.652046-03:00",
"sizes_quantities": [
{
"id": "6eaba215-b289-4514-a662-cf42fc8e15d9",
"size": "P",
"quantity": 1,
"color_id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "9f1827f9-64cb-41f0-bc14-b330788c03f9",
"size": "M",
"quantity": 2,
"color_id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "b8281853-c481-42e2-af85-7f89e65a0152",
"size": "G",
"quantity": 0,
"color_id": "7c46cae8-22f3-42ef-a59c-f4c0a7daaf28",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
},
{
"id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"color": "Preto",
"rgb": "#000000",
"isdeleted": false,
"created_at": "2023-05-16T13:25:54.747359-03:00",
"updated_at": "2023-08-15T18:48:21.022358-03:00",
"sizes_quantities": [
{
"id": "dccf91e8-6711-46b5-a43d-81975f5d153d",
"size": "P",
"quantity": 2,
"color_id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "b25eaf50-f41a-4159-bd55-abc3f9e23573",
"size": "M",
"quantity": 2,
"color_id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "5a7379b1-6158-4880-bff0-701b9f41da79",
"size": "G",
"quantity": 2,
"color_id": "a813ce3a-60cb-4f46-b191-15f5acb5a608",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
},
{
"id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"color": "Branco",
"rgb": "#ffffff",
"isdeleted": false,
"created_at": "2023-05-16T16:33:46.774047-03:00",
"updated_at": "2023-06-10T12:55:14.925664-03:00",
"sizes_quantities": [
{
"id": "7a87dcad-9729-478f-99e1-b7731d2d462a",
"size": "P",
"quantity": 0,
"color_id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "c0080f60-bafc-4e80-a918-ea4c3a722d2a",
"size": "M",
"quantity": 0,
"color_id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "7f806fa9-36b2-410e-906a-3c61adbacfc4",
"size": "G",
"quantity": 0,
"color_id": "be60c6cd-40ae-4455-a0c7-c15714d1302c",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
},
{
"id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"color": "Rosa",
"rgb": "#fa0588",
"isdeleted": false,
"created_at": "2023-06-10T00:58:11.82061-03:00",
"updated_at": "2023-06-10T12:55:15.238133-03:00",
"sizes_quantities": [
{
"id": "0a062a53-ca42-498f-ac6b-0ef7925e5e05",
"size": "M",
"quantity": 0,
"color_id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "4ff43b38-a800-4a1f-9ff6-cbd920721bcc",
"size": "G",
"quantity": 0,
"color_id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
},
{
"id": "8ca538bd-a6cd-4df6-a16e-b9b36598a5be",
"size": "P",
"quantity": 0,
"color_id": "f8871775-c854-4e7b-915a-7d8299512ea2",
"products_order_id": "2414f2ee-b0a8-49a4-9ff8-52c898d823c3"
}
]
}
]
}
],
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment