当前位置： 文江博客话题详情

卖方的一系列销售组，从每个卖方那里获取总数，按总销售额订购

发布于 2025-01-21 07:14:45 字数 1768 浏览 5 评论 0原文

我有这样的数组：

[
    {
        "orderId": 1,
        "orderDate": "2021-04-28T08:20:58Z",
        "status": "Confirmed",
        "sellerName": "Chris Gilmour",
        "revenue": 2316.49
    },
    {
        "orderId": 2,
        "orderDate": "2020-12-19T12:30:18Z",
        "status": "Confirmed",
        "sellerName": "Alanna Sumner",
        "revenue": 2928.88
    },
    {
        "orderId": 4,
        "orderDate": "2020-12-24T08:00:09Z",
        "status": "Confirmed",
        "sellerName": "Beth North",
        "revenue": 1550.19
    },
    {
        "orderId": 5,
        "orderDate": "2021-06-06T04:40:48Z",
        "status": "Confirmed",
        "sellerName": "Laura Ponce",
        "revenue": 35.5
    },
    {
        "orderId": 8,
        "orderDate": "2021-08-27T05:13:40Z",
        "status": "Canceled",
        "sellerName": "Blade Newman",
        "revenue": 2957.29
    },
    {
        "orderId": 9,
        "orderDate": "2020-12-26T08:07:57Z",
        "status": "Confirmed",
        "sellerName": "Alanna Sumner",
        "revenue": 2164.75
    },
    {
        "orderId": 10,
        "orderDate": "2021-04-23T18:44:19Z",
        "status": "Confirmed",
        "sellerName": "Blade Newman",
        "revenue": 2287.55
    }
]

我希望新阵列成为：

[ 
    {
        "sellerName": "Blade Newman",
        "totalRevenue": 5244.84
    },
    {
        "sellerName": "Alanna Sumner",
        "totalRevenue": 5093.63
    },
    { 
        "sellerName": "Chris Gilmour",
        "totalRevenue" : 2316.49
    },
    {
        "sellerName": "Beth North",
        "totalRevenue": 1550.19
    }

]

所以我希望该数组由Sellername分组，售出的金额总结并由销售总数最多的卖家订购。

我试图通过使用foreach和降低来解决这个问题，但是如果有人能帮助我，那我就会很棒。

提前致谢。

原文

I have an array like this :

[
    {
        "orderId": 1,
        "orderDate": "2021-04-28T08:20:58Z",
        "status": "Confirmed",
        "sellerName": "Chris Gilmour",
        "revenue": 2316.49
    },
    {
        "orderId": 2,
        "orderDate": "2020-12-19T12:30:18Z",
        "status": "Confirmed",
        "sellerName": "Alanna Sumner",
        "revenue": 2928.88
    },
    {
        "orderId": 4,
        "orderDate": "2020-12-24T08:00:09Z",
        "status": "Confirmed",
        "sellerName": "Beth North",
        "revenue": 1550.19
    },
    {
        "orderId": 5,
        "orderDate": "2021-06-06T04:40:48Z",
        "status": "Confirmed",
        "sellerName": "Laura Ponce",
        "revenue": 35.5
    },
    {
        "orderId": 8,
        "orderDate": "2021-08-27T05:13:40Z",
        "status": "Canceled",
        "sellerName": "Blade Newman",
        "revenue": 2957.29
    },
    {
        "orderId": 9,
        "orderDate": "2020-12-26T08:07:57Z",
        "status": "Confirmed",
        "sellerName": "Alanna Sumner",
        "revenue": 2164.75
    },
    {
        "orderId": 10,
        "orderDate": "2021-04-23T18:44:19Z",
        "status": "Confirmed",
        "sellerName": "Blade Newman",
        "revenue": 2287.55
    }
]

I want the new Array to be :

[ 
    {
        "sellerName": "Blade Newman",
        "totalRevenue": 5244.84
    },
    {
        "sellerName": "Alanna Sumner",
        "totalRevenue": 5093.63
    },
    { 
        "sellerName": "Chris Gilmour",
        "totalRevenue" : 2316.49
    },
    {
        "sellerName": "Beth North",
        "totalRevenue": 1550.19
    }

]

So I want the array to be grouped by sellerName, the amount sold summed up and ordered By sellers with the most total sales.

I tried to solve this by using forEachs and reduces but I failed, if anyone can help me that would be great.

Thanks in advance.

如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论， 你可以免费 注册 一个本站的账号。

评论（7）

像你 2025-01-28 07:14:45

如@CarySwoveland在评论中所述，您可以在对象中为每个卖方积累收入，将对象条目转换为数组进行排序，然后根据排序值生成一个新对象：

const sales = [{
    "orderId": 1,
    "orderDate": "2021-04-28T08:20:58Z",
    "status": "Confirmed",
    "sellerName": "Chris Gilmour",
    "revenue": 2316.49
  },
  {
    "orderId": 2,
    "orderDate": "2020-12-19T12:30:18Z",
    "status": "Confirmed",
    "sellerName": "Alanna Sumner",
    "revenue": 2928.88
  },
  {
    "orderId": 4,
    "orderDate": "2020-12-24T08:00:09Z",
    "status": "Confirmed",
    "sellerName": "Beth North",
    "revenue": 1550.19
  },
  {
    "orderId": 5,
    "orderDate": "2021-06-06T04:40:48Z",
    "status": "Confirmed",
    "sellerName": "Laura Ponce",
    "revenue": 35.5
  },
  {
    "orderId": 8,
    "orderDate": "2021-08-27T05:13:40Z",
    "status": "Canceled",
    "sellerName": "Blade Newman",
    "revenue": 2957.29
  },
  {
    "orderId": 9,
    "orderDate": "2020-12-26T08:07:57Z",
    "status": "Confirmed",
    "sellerName": "Alanna Sumner",
    "revenue": 2164.75
  },
  {
    "orderId": 10,
    "orderDate": "2021-04-23T18:44:19Z",
    "status": "Confirmed",
    "sellerName": "Blade Newman",
    "revenue": 2287.55
  }
];

let totalsales = sales.reduce((acc, {
  sellerName,
  revenue
}) => {
  acc[sellerName] = (acc[sellerName] || 0) + revenue;
  return acc;
}, {});

totalsales = Object.entries(totalsales)
.sort((a, b) => b[1] - a[1])
.map((v) => ({ sellerName: v[0], totalRevenue: v[1] }))

console.log(totalsales)

As described by @CarySwoveland in the comments, you can accumulate revenue for each seller in an object, convert the object entries to an array to sort, and then generate a new object based on the sorted values:

const sales = [{
    "orderId": 1,
    "orderDate": "2021-04-28T08:20:58Z",
    "status": "Confirmed",
    "sellerName": "Chris Gilmour",
    "revenue": 2316.49
  },
  {
    "orderId": 2,
    "orderDate": "2020-12-19T12:30:18Z",
    "status": "Confirmed",
    "sellerName": "Alanna Sumner",
    "revenue": 2928.88
  },
  {
    "orderId": 4,
    "orderDate": "2020-12-24T08:00:09Z",
    "status": "Confirmed",
    "sellerName": "Beth North",
    "revenue": 1550.19
  },
  {
    "orderId": 5,
    "orderDate": "2021-06-06T04:40:48Z",
    "status": "Confirmed",
    "sellerName": "Laura Ponce",
    "revenue": 35.5
  },
  {
    "orderId": 8,
    "orderDate": "2021-08-27T05:13:40Z",
    "status": "Canceled",
    "sellerName": "Blade Newman",
    "revenue": 2957.29
  },
  {
    "orderId": 9,
    "orderDate": "2020-12-26T08:07:57Z",
    "status": "Confirmed",
    "sellerName": "Alanna Sumner",
    "revenue": 2164.75
  },
  {
    "orderId": 10,
    "orderDate": "2021-04-23T18:44:19Z",
    "status": "Confirmed",
    "sellerName": "Blade Newman",
    "revenue": 2287.55
  }
];

let totalsales = sales.reduce((acc, {
  sellerName,
  revenue
}) => {
  acc[sellerName] = (acc[sellerName] || 0) + revenue;
  return acc;
}, {});

totalsales = Object.entries(totalsales)
.sort((a, b) => b[1] - a[1])
.map((v) => ({ sellerName: v[0], totalRevenue: v[1] }))

console.log(totalsales)

回复 原文
酒几许 2025-01-28 07:14:45

您可以尝试一下：

    const newArray=[];
    for (var order of orders) {
        var index = newArray.findIndex((a)=>a.sellerName==order.sellerName);
        if (index>-1){
            newArray[index].totalRevenue+=order.revenue;
        } else {
            newArray.push({
                sellerName: order.sellerName,
                totalRevenue: order.revenue
           }) 
       }
   } 
   newArray.sort((a,b)=>b.totalRevenue-a.totalRevenue);

You can try this:

    const newArray=[];
    for (var order of orders) {
        var index = newArray.findIndex((a)=>a.sellerName==order.sellerName);
        if (index>-1){
            newArray[index].totalRevenue+=order.revenue;
        } else {
            newArray.push({
                sellerName: order.sellerName,
                totalRevenue: order.revenue
           }) 
       }
   } 
   newArray.sort((a,b)=>b.totalRevenue-a.totalRevenue);
回复 原文
暮年慕年 2025-01-28 07:14:45

使用一个简单的循环循环以卖方名称获得收入（这比redy更可读）。

const revenueByName = {};
for (const {sellerName, revenue} of data) {
    revenueByName[sellerName] = (revenueByName[sellerName] ?? 0) + revenue;
}
const result = Object.entries(revenueByName)
    .map(([sellerName, totalRevenue]) => ({sellerName, totalRevenue}))
    .sort((a, b) => b.totalRevenue - a.totalRevenue);

Use a simple for loop to make a hash of revenue by seller name (this is more readable than reduce).

const revenueByName = {};
for (const {sellerName, revenue} of data) {
    revenueByName[sellerName] = (revenueByName[sellerName] ?? 0) + revenue;
}
const result = Object.entries(revenueByName)
    .map(([sellerName, totalRevenue]) => ({sellerName, totalRevenue}))
    .sort((a, b) => b.totalRevenue - a.totalRevenue);
回复 原文
话少情深 2025-01-28 07:14:45

与其他答案相同的技术，但折叠成一个功能：

const total = (sales) => 
  Object .entries (sales .reduce (
    (a, {sellerName: n, revenue}) => ({...a, [n] : (a[n] ?? 0) + revenue}), 
    {}
  )) .map (([sellerName, totalRevenue]) => ({sellerName, totalRevenue}))

const sales = [{orderId: 1, orderDate: "2021-04-28T08: 20: 58Z", status: "Confirmed", sellerName: "Chris Gilmour", revenue: 2316.49}, {orderId: 2, orderDate: "2020-12-19T12: 30: 18Z", status: "Confirmed", sellerName: "Alanna Sumner", revenue: 2928.88}, {orderId: 4, orderDate: "2020-12-24T08: 00: 09Z", status: "Confirmed", sellerName: "Beth North", revenue: 1550.19}, {orderId: 5, orderDate: "2021-06-06T04: 40: 48Z", status: "Confirmed", sellerName: "Laura Ponce", revenue: 35.5}, {orderId: 8, orderDate: "2021-08-27T05: 13: 40Z", status: "Canceled", sellerName: "Blade Newman", revenue: 2957.29}, {orderId: 9, orderDate: "2020-12-26T08: 07: 57Z", status: "Confirmed", sellerName: "Alanna Sumner", revenue: 2164.75}, {orderId: 10, orderDate: "2021-04-23T18: 44: 19Z", status: "Confirmed", sellerName: "Blade Newman", revenue: 2287.55}]

console .log (total (sales))
.as-console-wrapper {max-height: 100% !important; top: 0}

使用降低，我们获得此中间格式：

{
  "Chris Gilmour": 2316.49,
  "Alanna Sumner": 5093.63,
  "Beth North": 1550.19,
  "Laura Ponce": 35.5,
  "Blade Newman": 5244.84
}

然后对象.entries将其变成

[
  ["Chris Gilmour", 2316.49],
  ["Alanna Sumner", 5093.63],
  ["Beth North", 1550.19],
  ["Laura Ponce", 35.5],
  ["Blade Newman", 5244.84]
]

map调用将其变成其最终形式。

Same technique as in other answers, but folded into a single function:

const total = (sales) => 
  Object .entries (sales .reduce (
    (a, {sellerName: n, revenue}) => ({...a, [n] : (a[n] ?? 0) + revenue}), 
    {}
  )) .map (([sellerName, totalRevenue]) => ({sellerName, totalRevenue}))

const sales = [{orderId: 1, orderDate: "2021-04-28T08: 20: 58Z", status: "Confirmed", sellerName: "Chris Gilmour", revenue: 2316.49}, {orderId: 2, orderDate: "2020-12-19T12: 30: 18Z", status: "Confirmed", sellerName: "Alanna Sumner", revenue: 2928.88}, {orderId: 4, orderDate: "2020-12-24T08: 00: 09Z", status: "Confirmed", sellerName: "Beth North", revenue: 1550.19}, {orderId: 5, orderDate: "2021-06-06T04: 40: 48Z", status: "Confirmed", sellerName: "Laura Ponce", revenue: 35.5}, {orderId: 8, orderDate: "2021-08-27T05: 13: 40Z", status: "Canceled", sellerName: "Blade Newman", revenue: 2957.29}, {orderId: 9, orderDate: "2020-12-26T08: 07: 57Z", status: "Confirmed", sellerName: "Alanna Sumner", revenue: 2164.75}, {orderId: 10, orderDate: "2021-04-23T18: 44: 19Z", status: "Confirmed", sellerName: "Blade Newman", revenue: 2287.55}]

console .log (total (sales))
.as-console-wrapper {max-height: 100% !important; top: 0}

Using reduce, we get this intermediate format:

{
  "Chris Gilmour": 2316.49,
  "Alanna Sumner": 5093.63,
  "Beth North": 1550.19,
  "Laura Ponce": 35.5,
  "Blade Newman": 5244.84
}

Then Object .entries turns it into

[
  ["Chris Gilmour", 2316.49],
  ["Alanna Sumner", 5093.63],
  ["Beth North", 1550.19],
  ["Laura Ponce", 35.5],
  ["Blade Newman", 5244.84]
]

and the map call turns it into its final form.

回复 原文
心房的律动 2025-01-28 07:14:45
//temp = given array
let result = temp.reduce((acc, curr) => {
    if (acc[curr.sellerName]) {
        acc[curr.sellerName] += curr.revenue;
    } else {
        acc[curr.sellerName] = curr.revenue;
    }
    return acc;
}, {});
// console.log(result, (a, b) => {
//     console.log
// });
result = Object.entries(result).map((value) => {
    return {
        sellerName: value[0],
        revenue: value[1],
    };
});

result = result.sort((a, b) => a["revenue"] - b["revenue"]);
console.log(result);

//temp = given array
let result = temp.reduce((acc, curr) => {
    if (acc[curr.sellerName]) {
        acc[curr.sellerName] += curr.revenue;
    } else {
        acc[curr.sellerName] = curr.revenue;
    }
    return acc;
}, {});
// console.log(result, (a, b) => {
//     console.log
// });
result = Object.entries(result).map((value) => {
    return {
        sellerName: value[0],
        revenue: value[1],
    };
});

result = result.sort((a, b) => a["revenue"] - b["revenue"]);
console.log(result);

回复 原文
痴情 2025-01-28 07:14:45

您可以将MAP与分组步骤组合在一起，然后只有sort数组

const orders=[{orderId:1,orderDate:"2021-04-28T08:20:58Z",status:"Confirmed",sellerName:"Chris Gilmour",revenue:2316.49},{orderId:2,orderDate:"2020-12-19T12:30:18Z",status:"Confirmed",sellerName:"Alanna Sumner",revenue:2928.88},{orderId:4,orderDate:"2020-12-24T08:00:09Z",status:"Confirmed",sellerName:"Beth North",revenue:1550.19},{orderId:5,orderDate:"2021-06-06T04:40:48Z",status:"Confirmed",sellerName:"Laura Ponce",revenue:35.5},{orderId:8,orderDate:"2021-08-27T05:13:40Z",status:"Canceled",sellerName:"Blade Newman",revenue:2957.29},{orderId:9,orderDate:"2020-12-26T08:07:57Z",status:"Confirmed",sellerName:"Alanna Sumner",revenue:2164.75},{orderId:10,orderDate:"2021-04-23T18:44:19Z",status:"Confirmed",sellerName:"Blade Newman",revenue:2287.55}];

const result = Object.values(orders.reduce((acc, { sellerName, revenue }) => {
    acc[sellerName] ??= { sellerName, totalRevenue: 0 };
    acc[sellerName].totalRevenue += revenue;
    return acc;
}, {}))
.sort(({ totalRevenue: a }, { totalRevenue: b }) => b - a);

console.log(result);
.as-console-wrapper { max-height: 100% !important; top: 0; }

You can combine map with grouping step together, and then just sort array

const orders=[{orderId:1,orderDate:"2021-04-28T08:20:58Z",status:"Confirmed",sellerName:"Chris Gilmour",revenue:2316.49},{orderId:2,orderDate:"2020-12-19T12:30:18Z",status:"Confirmed",sellerName:"Alanna Sumner",revenue:2928.88},{orderId:4,orderDate:"2020-12-24T08:00:09Z",status:"Confirmed",sellerName:"Beth North",revenue:1550.19},{orderId:5,orderDate:"2021-06-06T04:40:48Z",status:"Confirmed",sellerName:"Laura Ponce",revenue:35.5},{orderId:8,orderDate:"2021-08-27T05:13:40Z",status:"Canceled",sellerName:"Blade Newman",revenue:2957.29},{orderId:9,orderDate:"2020-12-26T08:07:57Z",status:"Confirmed",sellerName:"Alanna Sumner",revenue:2164.75},{orderId:10,orderDate:"2021-04-23T18:44:19Z",status:"Confirmed",sellerName:"Blade Newman",revenue:2287.55}];

const result = Object.values(orders.reduce((acc, { sellerName, revenue }) => {
    acc[sellerName] ??= { sellerName, totalRevenue: 0 };
    acc[sellerName].totalRevenue += revenue;
    return acc;
}, {}))
.sort(({ totalRevenue: a }, { totalRevenue: b }) => b - a);

console.log(result);
.as-console-wrapper { max-height: 100% !important; top: 0; }

回复 原文
时光礼记 2025-01-28 07:14:45

lodash 如果您不介意

const orders=[{orderId:1,orderDate:"2021-04-28T08:20:58Z",status:"Confirmed",sellerName:"Chris Gilmour",revenue:2316.49},{orderId:2,orderDate:"2020-12-19T12:30:18Z",status:"Confirmed",sellerName:"Alanna Sumner",revenue:2928.88},{orderId:4,orderDate:"2020-12-24T08:00:09Z",status:"Confirmed",sellerName:"Beth North",revenue:1550.19},{orderId:5,orderDate:"2021-06-06T04:40:48Z",status:"Confirmed",sellerName:"Laura Ponce",revenue:35.5},{orderId:8,orderDate:"2021-08-27T05:13:40Z",status:"Canceled",sellerName:"Blade Newman",revenue:2957.29},{orderId:9,orderDate:"2020-12-26T08:07:57Z",status:"Confirmed",sellerName:"Alanna Sumner",revenue:2164.75},{orderId:10,orderDate:"2021-04-23T18:44:19Z",status:"Confirmed",sellerName:"Blade Newman",revenue:2287.55}];

const result = _.chain(orders)
  .groupBy('sellerName')
  .map((values, key) => ({ sellerName: key, totalRevenue: _.sumBy(values, 'revenue') }))
  .sortBy('sellerName')
  .value();

console.log(result);
.as-console-wrapper {max-height: 100% !important; top: 0}
<script src="https://cdnjs.cloudflare.com/ajax/libs/lodash.js/4.17.21/lodash.min.js" integrity="sha512-WFN04846sdKMIP5LKNphMaWzU7YpMyCU245etK3g/2ARYbPK9Ub18eG+ljU96qKRCWh+quCY7yefSmlkQw1ANQ==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>

Lodash if you don't mind

const orders=[{orderId:1,orderDate:"2021-04-28T08:20:58Z",status:"Confirmed",sellerName:"Chris Gilmour",revenue:2316.49},{orderId:2,orderDate:"2020-12-19T12:30:18Z",status:"Confirmed",sellerName:"Alanna Sumner",revenue:2928.88},{orderId:4,orderDate:"2020-12-24T08:00:09Z",status:"Confirmed",sellerName:"Beth North",revenue:1550.19},{orderId:5,orderDate:"2021-06-06T04:40:48Z",status:"Confirmed",sellerName:"Laura Ponce",revenue:35.5},{orderId:8,orderDate:"2021-08-27T05:13:40Z",status:"Canceled",sellerName:"Blade Newman",revenue:2957.29},{orderId:9,orderDate:"2020-12-26T08:07:57Z",status:"Confirmed",sellerName:"Alanna Sumner",revenue:2164.75},{orderId:10,orderDate:"2021-04-23T18:44:19Z",status:"Confirmed",sellerName:"Blade Newman",revenue:2287.55}];

const result = _.chain(orders)
  .groupBy('sellerName')
  .map((values, key) => ({ sellerName: key, totalRevenue: _.sumBy(values, 'revenue') }))
  .sortBy('sellerName')
  .value();

console.log(result);
.as-console-wrapper {max-height: 100% !important; top: 0}
<script src="https://cdnjs.cloudflare.com/ajax/libs/lodash.js/4.17.21/lodash.min.js" integrity="sha512-WFN04846sdKMIP5LKNphMaWzU7YpMyCU245etK3g/2ARYbPK9Ub18eG+ljU96qKRCWh+quCY7yefSmlkQw1ANQ==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>

回复 原文
~没有更多了~

关于作者

浮生面具三千个

暂无简介

文章
评论
27 人气
发私信

相关话题

更多

热门标签

操作系统 程序设计 IT运维 Linux系统管理 JavaScript 服务器应用 solaris C/C++ PHP Shell BSD Vue.js aix Oracle Python HTML 系统管理 HTML5 CSS 前端
更多

推荐作者

櫻之舞

文章 0 评论 0

弥枳

文章 0 评论 0

m2429

文章 0 评论 0

寻找一个思念的角度

文章 0 评论 0

野却迷人

文章 0 评论 0

我怀念的。

文章 0 评论 0

更多

友情链接

文江博客
    我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站，即表示您同意使用 Cookies 和您的相关数据。
    原文