作者热门文章
- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
我创建了一个函数,它将返回一个没有重复分支的对象以及每个分支的总销售额。
var salesPersons = [
{"name": {"first": "Aleen", "last" :"Atkins"}, "sales" : "$2314", "branch": "Austin, TX"},
{"name": {"first": "Alvaro", "last" :"Angelos"}, "sales" : "$1668", "branch": "New York City, NY"},
{"name": {"first": "Denese", "last" :"Dossett"}, "sales" : "$9248", "branch": "Austin, TX"},
{"name": {"first": "Douglas", "last" :"Denney"}, "sales" : "$5058", "branch": "New York City, NY"},
{"name": {"first": "Earline", "last" :"Erickson"}, "sales" : "$18876", "branch": "New York City, NY"},
{"name": {"first": "Herman", "last" :"Hazell"}, "sales" : "$2746", "branch": "New York City, NY"},
{"name": {"first": "Homer", "last" :"Hirth"}, "sales" : "$474", "branch": "Orlando, FL"},
{"name": {"first": "Hwa", "last" :"Heidt"}, "sales" : "$9607", "branch": "San Francisco, CA"},
{"name": {"first": "Hyon", "last" :"Hampshire"}, "sales" : "$13598", "branch": "New York City, NY"},
{"name": {"first": "Issac", "last" :"Ingerson"}, "sales" : "$5225", "branch": "Austin, TX"},
{"name": {"first": "Jeraldine", "last" :"Joplin"}, "sales" : "$2891", "branch": "New York City, NY"},
{"name": {"first": "Jin", "last" :"Jeffrey"}, "sales" : "$14402", "branch": "Austin, TX"},
{"name": {"first": "Joleen", "last" :"Jolin"}, "sales" : "$15736", "branch": "Austin, TX"},
{"name": {"first": "Jude", "last" :"Jarrett"}, "sales" : "$7557", "branch": "San Francisco, CA"},
{"name": {"first": "Magda", "last" :"Mireles"}, "sales" : "$1498", "branch": "Austin, TX"},
{"name": {"first": "Mistie", "last" :"Montealegre"}, "sales" : "$6920", "branch": "New York City, NY"},
{"name": {"first": "Nancy", "last" :"Napoli"}, "sales" : "$5255", "branch": "New York City, NY"},
{"name": {"first": "Regine", "last" :"Rohrbaugh"}, "sales" : "$7881", "branch": "Orlando, FL"},
{"name": {"first": "Rolando", "last" :"Riebel"}, "sales" : "$8573", "branch": "San Francisco, CA"},
{"name": {"first": "Scarlett", "last" :"Stagg"}, "sales" : "$7126", "branch": "Orlando, FL"},
{"name": {"first": "Sherron", "last" :"Strawn"}, "sales" : "$8848", "branch": "New York City, NY"},
{"name": {"first": "Susan", "last" :"Shilling"}, "sales" : "$8542", "branch": "Seattle, WA"},
{"name": {"first": "Tama", "last" :"Tworek"}, "sales" : "$9200", "branch": "Seattle, WA"},
{"name": {"first": "Tonisha", "last" :"Taunton"}, "sales" : "$5219", "branch": "Orlando, FL"},
{"name": {"first": "Vergie", "last" :"Villescas"}, "sales" : "$8712", "branch": "New York City, NY"}
];
function convertSalesToInt(person){
var salesInt = person.sales.slice(1);
return parseInt(salesInt, 10);
}
function salesPerBranch(salesPersons){
var myObj = {};
var uniq = [];
var total = 0;
for(var i = 0; i < salesPersons.length; i++){
var splitTeam = salesPersons[i].branch;
if(uniq.indexOf(salesPersons) < 0){
myObj[salesPersons] = total+= convertSalesToInt(salesPersons[i]);
}
}
return myObj;
}
console.log(salesPerBranch(salesPersons));
/* { 'Austin, TX': 110898,
'New York City, NY': 187174,
'Orlando, FL': 178462,
'San Francisco, CA': 139527,
'Seattle, WA': 173243 } */
答案应该是这样的:
{
'Austin, TX': 48423,
'New York City, NY': 74572,
'Orlando, FL': 20700,
'San Francisco, CA': 25737,
'Seattle, WA': 17742
}
我现在唯一遇到困难的部分是我添加每个分支机构的总销售额的部分。现在它没有拉动适当的数量。这部分负责:
if(uniq.indexOf(salesPersons) < 0){
myObj[salesPersons] = total+= convertSalesToInt(salesPersons[i]);
}
有人知道我的错误是什么以及如何解决它吗?
谢谢!
最佳答案
var salesPersons = [
{"name": {"first": "Aleen", "last" :"Atkins"}, "sales" : "$2314", "branch": "Austin, TX"},
{"name": {"first": "Alvaro", "last" :"Angelos"}, "sales" : "$1668", "branch": "New York City, NY"},
{"name": {"first": "Denese", "last" :"Dossett"}, "sales" : "$9248", "branch": "Austin, TX"},
{"name": {"first": "Douglas", "last" :"Denney"}, "sales" : "$5058", "branch": "New York City, NY"},
{"name": {"first": "Earline", "last" :"Erickson"}, "sales" : "$18876", "branch": "New York City, NY"},
{"name": {"first": "Herman", "last" :"Hazell"}, "sales" : "$2746", "branch": "New York City, NY"},
{"name": {"first": "Homer", "last" :"Hirth"}, "sales" : "$474", "branch": "Orlando, FL"},
{"name": {"first": "Hwa", "last" :"Heidt"}, "sales" : "$9607", "branch": "San Francisco, CA"},
{"name": {"first": "Hyon", "last" :"Hampshire"}, "sales" : "$13598", "branch": "New York City, NY"},
{"name": {"first": "Issac", "last" :"Ingerson"}, "sales" : "$5225", "branch": "Austin, TX"},
{"name": {"first": "Jeraldine", "last" :"Joplin"}, "sales" : "$2891", "branch": "New York City, NY"},
{"name": {"first": "Jin", "last" :"Jeffrey"}, "sales" : "$14402", "branch": "Austin, TX"},
{"name": {"first": "Joleen", "last" :"Jolin"}, "sales" : "$15736", "branch": "Austin, TX"},
{"name": {"first": "Jude", "last" :"Jarrett"}, "sales" : "$7557", "branch": "San Francisco, CA"},
{"name": {"first": "Magda", "last" :"Mireles"}, "sales" : "$1498", "branch": "Austin, TX"},
{"name": {"first": "Mistie", "last" :"Montealegre"}, "sales" : "$6920", "branch": "New York City, NY"},
{"name": {"first": "Nancy", "last" :"Napoli"}, "sales" : "$5255", "branch": "New York City, NY"},
{"name": {"first": "Regine", "last" :"Rohrbaugh"}, "sales" : "$7881", "branch": "Orlando, FL"},
{"name": {"first": "Rolando", "last" :"Riebel"}, "sales" : "$8573", "branch": "San Francisco, CA"},
{"name": {"first": "Scarlett", "last" :"Stagg"}, "sales" : "$7126", "branch": "Orlando, FL"},
{"name": {"first": "Sherron", "last" :"Strawn"}, "sales" : "$8848", "branch": "New York City, NY"},
{"name": {"first": "Susan", "last" :"Shilling"}, "sales" : "$8542", "branch": "Seattle, WA"},
{"name": {"first": "Tama", "last" :"Tworek"}, "sales" : "$9200", "branch": "Seattle, WA"},
{"name": {"first": "Tonisha", "last" :"Taunton"}, "sales" : "$5219", "branch": "Orlando, FL"},
{"name": {"first": "Vergie", "last" :"Villescas"}, "sales" : "$8712", "branch": "New York City, NY"}
];
function convertSalesToInt(person){
var salesInt = person.sales.slice(1);
return parseInt(salesInt, 10);
}
function salesPerBranch(salesPersons){
var myObj = {};
for(var i = 0; i < salesPersons.length; i++){
var splitTeam = salesPersons[i].branch;
myObj[splitTeam] = myObj[splitTeam] ? myObj[splitTeam]: 0;
myObj[splitTeam] += convertSalesToInt(salesPersons[i]);
}
return myObj;
}
console.log(salesPerBranch(salesPersons));
您需要检查是否没有销售计数数据,然后将其设置为零,如果有,则添加到它。
关于javascript - 获取总销售额,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/46241238/
我正在使用 Chart.js 创建图表。我在数据库中存储了一些日期和销售额。在这里,我使用 ajax 请求从数据库中选取记录,并通过将数据划分为两个不同的数组 date["2017-12-18","2
我正在尝试创建一个销售报告,用户可以在其中查看每天、每周和每月的销售额。 这是我的 table : CREATE TABLE IF NOT EXISTS `sales_act` ( `id`
我有一张包含 customer_number、week 和 sales 的表。我需要检查每个客户是否连续 12 周没有销售,并创建一个 0/1 的标志。 我可以检查过去 12 周或特定时间范围,但
我尝试了一些方法,到目前为止,这是唯一没有抛出错误的方法,但结果不会在我的页面上回显,所以我不太确定发生了什么。 $query = "SELECT SUM(sales.total) AS sales_
我是一名优秀的程序员,十分优秀!