时间戳

首页 > 解决方案 > 在 NodeJS 中解析 SQL 响应

node.js - 在 NodeJS 中解析 SQL 响应

问题描述

在我的 NodeJS 方法中，我做了一个简单的选择，返回如下响应：

    [{id: 1, project: "project A", user: "Tom", duration: 8},
{id: 2, project: "project B", user: "Mark", duration: 8},
{id: 1, project: "project A", user: "Mark", duration: 8},
{id: 3, project: "project C", user: "Tom", duration: 8},
{id: 3, project: "project C", user: "Mark", duration: 8},
{id: 3, project: "project C", user: "Helen", duration: 8}]

我如何才能编辑此数组，以便在前端发送的最终响应如下所示：

    [{project: {projectName: "project A", users: [{userName: "Tom", duration: 8},
                                                  {userName: "Mark", duration: 8}]},
    {projectName: "project B", users: [{userName: "Mark", duration: 8}]},
    {projectName: "project C", users: [{userName: "Tom", duration: 8},
                                       {userName: "Mark", duration: 8},
                                       {userName: "Helen", duration: 8}]}

不知何故，我需要用同一项目中的用户和持续时间制作一组对象。

如果它更有帮助，一般的想法是我必须创建一个月度报告，让每个用户了解每个项目的工作时间。

如果有人可以帮助我，谢谢！

标签： node.jsarraysreturn

解决方案

推荐阅读