1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.import
console; var
temptab={- fields={
"品名"
;"产地"
;"售价"
;"数量"
;"金额"
} - }
for
(i=1
;100000
;1
){- ..
table
.append(temptab,{ - [
1
]={"品名"
="A1"
;"产地"
="B1"
;"售价"
="3"
;"数量"
=2
;}; - [
2
]={"品名"
="A2"
;"产地"
="B2"
;"售价"
="3"
;"数量"
=2
;}; - [
3
]={"品名"
="A1"
;"产地"
="B1"
;"售价"
="3"
;"数量"
=2
;}; - [
4
]={"品名"
="A2"
;"产地"
="B2"
;"售价"
="3"
;"数量"
=2
;}; } - )
- }
var
t = time
.tick()var
tab={};for
(i=1
;-
for
(n=1
; -
if
tab[n].品名=temptab[i].品名 and
tab[n].产地=temptab[i].产地 and
tab[n].售价=temptab[i].售价 { - tab[n].数量 = tab[n].数量+temptab[i].数量
- tab[n].金额 = tab[n].金额 + temptab[i].数量*temptab[i].售价
-
continue
2
- }
- }
- ..
table
.push(tab,{ "品名"
=temptab[i].品名, -
"产地"
=temptab[i].产地; -
"售价"
=temptab[i].售价; -
"数量"
=temptab[i].数量; -
"金额"
=temptab[i].数量*temptab[i].售价}); -
- }
- console.dump(
time
.tick()-t,tab) var
t = time
.tick()var
tab={};table
.filter(temptab,function
(v,index){-
var
flag=1
; -
table
.filter(tab,function
(v1,i){ -
if
(v.品名==v1.品名 and
v.产地==v1.产地 and
v.售价==v1.售价) { - v1.数量+=v.数量;
- v1.金额=v1.数量*v1.售价;
- flag=
0
; - }
- })
-
if
flag table
.push(tab,v); - })
- console.dump(
time
.tick()-t,tab) - console.pause(
true
);