|
var clear = true //通过判断clear来清除定时器
|
var step = 0 //每一帧
|
var step2 = 0 //每一帧
|
var arr_arr = []
|
var arr_arr2 = [] //从开始到结束所获取的数据，用于回放或保存文件
|
var timer
|
var sum_99 = 0
|
var sum_99_2 = 0 //99个点的数值总和
|
var sum_region1 = 0,
|
sum_region2 = 0,
|
sum_region3 = 0,
|
sum_region4 = 0,
|
sum_region5 = 0,
|
sum_region6 = 0,
|
sum_region7 = 0,
|
sum_region8 = 0,
|
sum_region9 = 0,
|
sum_region1_2 = 0,
|
sum_region2_2 = 0,
|
sum_region3_2 = 0,
|
sum_region4_2 = 0,
|
sum_region5_2 = 0,
|
sum_region6_2 = 0,
|
sum_region7_2 = 0,
|
sum_region8_2 = 0,
|
sum_region9_2 = 0 //每个区域的总值
|
var region_length = []
|
var region_length2 = [] //鞋垫分区的个数
|
var left_port = "/dev/tty.usbserial-14110"
|
var right_port = "/dev/tty.usbserial-14130"//左右脚对应的串口号
|
var heatmapInstance = h337.create({
|
container: document.querySelector('.left_map')
|
});
|
var heatmapInstance2 = h337.create({
|
container: document.querySelector('.right_map')
|
});
|
|
|
|
|
//页面初始化时进行分区
|
$(document).ready(function(){
|
for(let i=0;i<region_data_right.length;i++){
|
let data_left = region_data_right[i][`region${i+1}`]
|
region_length.push(data_left.length)
|
for(let a=0;a<data_left.length;a++){
|
let demo = $(`${data_left[a]}`)
|
demo.addClass(`region${i+1}`)
|
}
|
}
|
for(let i=0;i<region_data_left.length;i++){
|
let data_left = region_data_left[i][`region${i+1}`]
|
region_length2.push(data_left.length)
|
for(let a=0;a<data_left.length;a++){
|
let demo = $(`${data_left[a]}`)
|
demo.addClass(`region${i+1}`)
|
}
|
}
|
})
|
|
// 精准到毫秒
|
function getNowTime () {
|
const date = new Date()
|
const year = date.getFullYear()
|
const month = date.getMonth() + 1
|
const day = date.getDate()
|
const hour = date.getHours() < 10 ? '0' + date.getHours() : date.getHours()
|
const minute = date.getMinutes() < 10 ? '0' + date.getMinutes() : date.getMinutes()
|
const second = date.getSeconds() < 10 ? '0' + date.getSeconds() : date.getSeconds()
|
const milliSeconds = date.getMilliseconds() //毫秒
|
const currentTime = year + '-' + month + '-' + day + ' ' + hour + ':' + minute + ':' + second + '.' + milliSeconds
|
return currentTime
|
}
|
|
//根据数值返回颜色
|
function opcity_end(num){
|
if(num<50){
|
return 0.1
|
}else if(num<100){
|
return 0.2
|
}else if(num<150){
|
return 0.3
|
}else if(num<200){
|
return 0.4
|
}else if(num<250){
|
return 0.5
|
}else if(num<300){
|
return 0.6
|
}else if(num<350){
|
return 0.7
|
}else if(num<400){
|
return 0.8
|
}else if(num<500){
|
return 0.9
|
}else{
|
return 1
|
}
|
}
|
|
//根据序号返回ABCD包
|
function trueID(num){
|
if(num==0){
|
return 'A'
|
}else if(num==1){
|
return 'B'
|
}else if(num==2){
|
return 'C'
|
}else if(num==3){
|
return 'D'
|
}
|
}
|
function trueID2(num){
|
if(num==0){
|
return 'A2'
|
}else if(num==1){
|
return 'B2'
|
}else if(num==2){
|
return 'C2'
|
}else if(num==3){
|
return 'D2'
|
}
|
}
|
|
|
//小数转化百分比
|
function toPercent(point){
|
let percent = Number(point*100).toFixed(3)
|
percent += "%"
|
return percent
|
}
|
|
//导出CSV方法
|
function tableToExcel(data,filename){
|
//列标题，逗号隔开，每一个逗号就是隔开一个单元格
|
let str = ``;
|
//增加\t为了不让表格显示科学计数法或者其他格式
|
for(let i = 0 ; i < data.length ; i++ ){
|
str+=`${data[i].data.join(',') + '\t'},`;
|
str+='\n';
|
}
|
//encodeURIComponent解决中文乱码
|
let uri = 'data:text/csv;charset=utf-8,\ufeff' + encodeURIComponent(str);
|
//通过创建a标签实现
|
let link = document.createElement("a");
|
link.href = uri;
|
//对下载的文件命名
|
link.download = filename;
|
document.body.appendChild(link);
|
link.click();
|
document.body.removeChild(link);
|
}
|
|
|
//创建连接服务端的socket
|
|
var socket = io('http://127.0.0.1:3001');
|
|
//更改图表数据方法
|
function addData(chart, num, label, data) {
|
chart.data.labels.push(label)
|
chart.data.labels.shift()
|
chart.data.datasets[num].data.push(data)
|
chart.data.datasets[num].data.shift()
|
chart.update()
|
}
|
|
//echarts图表
|
var ctx = document.getElementById('chart').getContext('2d');
|
var lineChart = new Chart(ctx, {
|
type: 'line',
|
data: {
|
labels: ['Red', 'Blue', 'Yellow', 'Green', 'Purple', 'Orange'],
|
datasets: [{
|
label: 'region1',
|
data: [0, 0, 0, 0, 0, 0],
|
borderColor: [
|
'#1D38C3',
|
],
|
borderWidth: 3,
|
fill: false
|
},
|
{
|
label: 'region2',
|
data: [0, 0, 0, 0, 0, 0],
|
borderColor: [
|
'#FF4C4F',
|
],
|
borderWidth: 3,
|
fill: false
|
},
|
{
|
label: 'region3',
|
data: [0, 0, 0, 0, 0, 0],
|
borderColor: [
|
'#fdec3d',
|
],
|
borderWidth: 3,
|
fill: false
|
},
|
{
|
label: 'region4',
|
data: [0, 0, 0, 0, 0, 0],
|
borderColor: [
|
'#73d13d',
|
],
|
borderWidth: 3,
|
fill: false
|
},
|
{
|
label: 'region5',
|
data: [0, 0, 0, 0, 0, 0],
|
borderColor: [
|
'#41a8ff',
|
],
|
borderWidth: 3,
|
fill: false
|
},
|
{
|
label: 'region6',
|
data: [0, 0, 0, 0, 0, 0],
|
borderColor: [
|
'#37cfca',
|
],
|
borderWidth: 3,
|
fill: false
|
},
|
{
|
label: 'region7',
|
data: [0, 0, 0, 0, 0, 0],
|
borderColor: [
|
'#ffa940',
|
],
|
borderWidth: 3,
|
fill: false
|
},
|
{
|
label: 'region8',
|
data: [0, 0, 0, 0, 0, 0],
|
borderColor: [
|
'#f75baa',
|
],
|
borderWidth: 3,
|
fill: false
|
},
|
{
|
label: 'region9',
|
data: [0, 0, 0, 0, 0, 0],
|
borderColor: [
|
'#9153de',
|
],
|
borderWidth: 3,
|
fill: false
|
}
|
]
|
},
|
options: {
|
scales: {
|
yAxes: [{
|
ticks: {
|
beginAtZero: true,
|
steps: 100,
|
stepValue: 10,
|
max: 1500
|
}
|
}]
|
},
|
animation: true,
|
animationEasing: 'easeInOutQuart',
|
animationSteps: 80
|
|
}
|
});
|
|
var ctx2 = document.getElementById('chart2').getContext('2d');
|
var lineChart2 = new Chart(ctx2, {
|
type: 'line',
|
data: {
|
labels: ['Red', 'Blue', 'Yellow', 'Green', 'Purple', 'Orange'],
|
datasets: [{
|
label: 'region1',
|
data: [0, 0, 0, 0, 0, 0],
|
borderColor: [
|
'#1D38C3',
|
],
|
borderWidth: 3,
|
fill: false
|
},
|
{
|
label: 'region2',
|
data: [0, 0, 0, 0, 0, 0],
|
borderColor: [
|
'#FF4C4F',
|
],
|
borderWidth: 3,
|
fill: false
|
},
|
{
|
label: 'region3',
|
data: [0, 0, 0, 0, 0, 0],
|
borderColor: [
|
'#fdec3d',
|
],
|
borderWidth: 3,
|
fill: false
|
},
|
{
|
label: 'region4',
|
data: [0, 0, 0, 0, 0, 0],
|
borderColor: [
|
'#73d13d',
|
],
|
borderWidth: 3,
|
fill: false
|
},
|
{
|
label: 'region5',
|
data: [0, 0, 0, 0, 0, 0],
|
borderColor: [
|
'#41a8ff',
|
],
|
borderWidth: 3,
|
fill: false
|
},
|
{
|
label: 'region6',
|
data: [0, 0, 0, 0, 0, 0],
|
borderColor: [
|
'#37cfca',
|
],
|
borderWidth: 3,
|
fill: false
|
},
|
{
|
label: 'region7',
|
data: [0, 0, 0, 0, 0, 0],
|
borderColor: [
|
'#ffa940',
|
],
|
borderWidth: 3,
|
fill: false
|
},
|
{
|
label: 'region8',
|
data: [0, 0, 0, 0, 0, 0],
|
borderColor: [
|
'#f75baa',
|
],
|
borderWidth: 3,
|
fill: false
|
},
|
{
|
label: 'region9',
|
data: [0, 0, 0, 0, 0, 0],
|
borderColor: [
|
'#9153de',
|
],
|
borderWidth: 3,
|
fill: false
|
}
|
]
|
},
|
options: {
|
scales: {
|
yAxes: [{
|
ticks: {
|
beginAtZero: true,
|
steps: 100,
|
stepValue: 10,
|
max: 1500
|
}
|
}]
|
},
|
animation: true,
|
animationEasing: 'easeInOutQuart',
|
animationSteps: 80
|
}
|
});
|
|
|
// 开始按钮
|
$('.start').click(function(){
|
socket = io('http://127.0.0.1:3001')
|
$('.start').attr('disabled',true)
|
$('.last').attr('disabled',true)
|
$('.next').attr('disabled',true)
|
$('.back').attr('disabled',true) //关闭回放功能
|
$('.download').attr('disabled',true)
|
if(!clear){
|
console.log("清空了")
|
arr_arr = []
|
arr_arr2 = [] //清除上一次数据
|
}
|
clear = true
|
clearInterval(timer)
|
socket.open() //打开socket
|
socket.on('output',(data1)=>{
|
|
|
|
if(data1.serialport == right_port){
|
let data = data1.data
|
let data_end = data1.data.flat()
|
for(let i=0;i<data_map.data.length;i++){
|
data_map.data[i].value = data_end[i]
|
data_map.data[i].radius = data_end[i]<10?0:30
|
}
|
|
heatmapInstance2.setData(data_map);
|
arr_arr.push(data1)
|
for(let i=0;i<data.length;i++){
|
for(let x=0;x<data[i].length;x++){
|
let id_end = trueID(i)
|
// let clor = clor_end(data[i][x])
|
// $(`#${id_end} .data${x}`).css({'background':clor})
|
$(`#${id_end} .data${x}`).attr('value',`${data[i][x]}`)
|
// sum_99 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region1'){
|
sum_region1 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region2'){
|
sum_region2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region3'){
|
sum_region3 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region4'){
|
sum_region4 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region5'){
|
sum_region5 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region6'){
|
sum_region6 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region7'){
|
sum_region7 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region8'){
|
sum_region8 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region9'){
|
sum_region9 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}
|
if(i==data.length-1&&x==data[i].length-1){
|
sum_99 = sum_region1+sum_region2+sum_region3+sum_region4+sum_region5+sum_region6+sum_region7+sum_region8+sum_region9
|
$('.dataRight .region1 .ave').text((sum_region1/region_length[0]).toFixed(5));
|
$('.dataRight .region1 .pr').text(toPercent((sum_region1/sum_99).toFixed(5)));
|
$('.dataRight .region2 .ave').text((sum_region2/region_length[1]).toFixed(5));
|
$('.dataRight .region2 .pr').text(toPercent((sum_region2/sum_99).toFixed(5)));
|
$('.dataRight .region3 .ave').text((sum_region3/region_length[2]).toFixed(5));
|
$('.dataRight .region3 .pr').text(toPercent((sum_region3/sum_99).toFixed(5)));
|
$('.dataRight .region4 .ave').text((sum_region4/region_length[3]).toFixed(5));
|
$('.dataRight .region4 .pr').text(toPercent((sum_region4/sum_99).toFixed(5)));
|
$('.dataRight .region5 .ave').text((sum_region5/region_length[4]).toFixed(5));
|
$('.dataRight .region5 .pr').text(toPercent((sum_region5/sum_99).toFixed(5)));
|
$('.dataRight .region6 .ave').text((sum_region6/region_length[5]).toFixed(5));
|
$('.dataRight .region6 .pr').text(toPercent((sum_region6/sum_99).toFixed(5)));
|
$('.dataRight .region7 .ave').text((sum_region7/region_length[6]).toFixed(5));
|
$('.dataRight .region7 .pr').text(toPercent((sum_region7/sum_99).toFixed(5)));
|
$('.dataRight .region8 .ave').text((sum_region8/region_length[7]).toFixed(5));
|
$('.dataRight .region8 .pr').text(toPercent((sum_region8/sum_99).toFixed(5)));
|
$('.dataRight .region9 .ave').text((sum_region9/region_length[8]).toFixed(5));
|
$('.dataRight .region9 .pr').text(toPercent((sum_region9/sum_99).toFixed(5)));
|
$('.fbox2 .region_1').css({opacity: opcity_end(sum_region1/region_length[0])})
|
$('.fbox2 .region_2').css({opacity: opcity_end(sum_region2/region_length[1])})
|
$('.fbox2 .region_3').css({opacity: opcity_end(sum_region3/region_length[2])})
|
$('.fbox2 .region_4').css({opacity: opcity_end(sum_region4/region_length[3])})
|
$('.fbox2 .region_5').css({opacity: opcity_end(sum_region5/region_length[4])})
|
$('.fbox2 .region_6').css({opacity: opcity_end(sum_region6/region_length[5])})
|
$('.fbox2 .region_7').css({opacity: opcity_end(sum_region7/region_length[6])})
|
$('.fbox2 .region_8').css({opacity: opcity_end(sum_region8/region_length[7])})
|
$('.fbox2 .region_9').css({opacity: opcity_end(sum_region9/region_length[8])})
|
|
addData(lineChart, 0, 'time3',(sum_region1/region_length[0]).toFixed(5))
|
addData(lineChart, 1, 'time3',(sum_region2/region_length[1]).toFixed(5))
|
addData(lineChart, 2, 'time3',(sum_region3/region_length[2]).toFixed(5))
|
addData(lineChart, 3, 'time3',(sum_region4/region_length[3]).toFixed(5))
|
addData(lineChart, 4, 'time3',(sum_region5/region_length[4]).toFixed(5))
|
addData(lineChart, 5, 'time3',(sum_region6/region_length[5]).toFixed(5))
|
addData(lineChart, 6, 'time3',(sum_region7/region_length[6]).toFixed(5))
|
addData(lineChart, 7, 'time3',(sum_region8/region_length[7]).toFixed(5))
|
addData(lineChart, 8, 'time3',(sum_region9/region_length[8]).toFixed(5))
|
|
|
}
|
}
|
}
|
sum_99 = 0;sum_region1 = 0;sum_region2 = 0;sum_region3 = 0;sum_region4 = 0;sum_region5 = 0;sum_region6 = 0;sum_region7 = 0;sum_region8 = 0;sum_region9 = 0
|
}else if(data1.serialport == left_port){
|
let data = data1.data
|
let data_end = data1.data.flat()
|
for(let i=0;i<data_map.data.length;i++){
|
data_map.data[i].value = data_end[i]
|
data_map.data[i].radius = data_end[i]<10?0:50
|
}
|
|
heatmapInstance.setData(data_map);
|
arr_arr2.push(data1)
|
for(let i=0;i<data.length;i++){
|
for(let x=0;x<data[i].length;x++){
|
let id_end = trueID2(i)
|
// let clor = clor_end(data[i][x])
|
// $(`#${id_end} .data${x}`).css({'background':clor})
|
$(`#${id_end} .data${x}`).attr('value',`${data[i][x]}`)
|
// sum_99 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region1'){
|
sum_region1_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region2'){
|
sum_region2_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region3'){
|
sum_region3_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region4'){
|
sum_region4_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region5'){
|
sum_region5_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region6'){
|
sum_region6_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region7'){
|
sum_region7_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region8'){
|
sum_region8_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region9'){
|
sum_region9_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}
|
if(i==data.length-1&&x==data[i].length-1){
|
sum_99_2 = sum_region1_2+sum_region2_2+sum_region3_2+sum_region4_2+sum_region5_2+sum_region6_2+sum_region7_2+sum_region8_2+sum_region9_2
|
$('.dataLeft .region1 .ave').text((sum_region1_2/region_length2[0]).toFixed(5));
|
$('.dataLeft .region1 .pr').text(toPercent((sum_region1_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region2 .ave').text((sum_region2_2/region_length2[1]).toFixed(5));
|
$('.dataLeft .region2 .pr').text(toPercent((sum_region2_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region3 .ave').text((sum_region3_2/region_length2[2]).toFixed(5));
|
$('.dataLeft .region3 .pr').text(toPercent((sum_region3/sum_99_2).toFixed(5)));
|
$('.dataLeft .region4 .ave').text((sum_region4_2/region_length2[3]).toFixed(5));
|
$('.dataLeft .region4 .pr').text(toPercent((sum_region4_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region5 .ave').text((sum_region5_2/region_length2[4]).toFixed(5));
|
$('.dataLeft .region5 .pr').text(toPercent((sum_region5_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region6 .ave').text((sum_region6_2/region_length2[5]).toFixed(5));
|
$('.dataLeft .region6 .pr').text(toPercent((sum_region6_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region7 .ave').text((sum_region7_2/region_length2[6]).toFixed(5));
|
$('.dataLeft .region7 .pr').text(toPercent((sum_region7_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region8 .ave').text((sum_region8_2/region_length2[7]).toFixed(5));
|
$('.dataLeft .region8 .pr').text(toPercent((sum_region8_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region9 .ave').text((sum_region9_2/region_length2[8]).toFixed(5));
|
$('.dataLeft .region9 .pr').text(toPercent((sum_region9_2/sum_99_2).toFixed(5)));
|
$('.fbox .region_1').css({opacity: opcity_end(sum_region1_2/region_length2[0])})
|
$('.fbox .region_2').css({opacity: opcity_end(sum_region2_2/region_length2[1])})
|
$('.fbox .region_3').css({opacity: opcity_end(sum_region3_2/region_length2[2])})
|
$('.fbox .region_4').css({opacity: opcity_end(sum_region4_2/region_length2[3])})
|
$('.fbox .region_5').css({opacity: opcity_end(sum_region5_2/region_length2[4])})
|
$('.fbox .region_6').css({opacity: opcity_end(sum_region6_2/region_length2[5])})
|
$('.fbox .region_7').css({opacity: opcity_end(sum_region7_2/region_length2[6])})
|
$('.fbox .region_8').css({opacity: opcity_end(sum_region8_2/region_length2[7])})
|
$('.fbox .region_9').css({opacity: opcity_end(sum_region9_2/region_length2[8])})
|
addData(lineChart2, 0, 'time3',(sum_region1_2/region_length2[0]).toFixed(5))
|
addData(lineChart2, 1, 'time3',(sum_region2_2/region_length2[1]).toFixed(5))
|
addData(lineChart2, 2, 'time3',(sum_region3_2/region_length2[2]).toFixed(5))
|
addData(lineChart2, 3, 'time3',(sum_region4_2/region_length2[3]).toFixed(5))
|
addData(lineChart2, 4, 'time3',(sum_region5_2/region_length2[4]).toFixed(5))
|
addData(lineChart2, 5, 'time3',(sum_region6_2/region_length2[5]).toFixed(5))
|
addData(lineChart2, 6, 'time3',(sum_region7_2/region_length2[6]).toFixed(5))
|
addData(lineChart2, 7, 'time3',(sum_region8_2/region_length2[7]).toFixed(5))
|
addData(lineChart2, 8, 'time3',(sum_region9_2/region_length2[8]).toFixed(5))
|
}
|
}
|
}
|
sum_99_2 = 0;sum_region1_2 = 0;sum_region2_2 = 0;sum_region3_2 = 0;sum_region4_2 = 0;sum_region5_2 = 0;sum_region6_2 = 0;sum_region7_2 = 0;sum_region8_2 = 0;sum_region9_2 = 0
|
}
|
})
|
})
|
|
|
//结束按钮
|
$('.end').click(function(){
|
// var socket = io('http://127.0.0.1:3001');
|
console.log(arr_arr,arr_arr2)
|
clear = false
|
socket.destroy();
|
// socket.disconnect(true)
|
// socket.close(false) //关闭socket不再接收传回的数据
|
clearInterval(timer)
|
$('.start').attr('disabled',false)
|
$('.last').attr('disabled',false)
|
$('.next').attr('disabled',false)
|
$('.back').attr('disabled',false) //开启回放功能
|
$('.download').attr('disabled',false)
|
})
|
|
//回放功能
|
$('.back').click(function(){
|
if(arr_arr.length == 0&&arr_arr2.length == 0){
|
alert('暂无数据')
|
}else{
|
clear = false
|
timer = setInterval(function(){
|
if(arr_arr.length!=0&&arr_arr2.length!=0){
|
step == arr_arr.length-1?arr_arr.length-1:step++
|
step2 == arr_arr2.length-1?arr_arr2.length-1:step2++
|
}else if(arr_arr.length == 0&&arr_arr2.length!=0){
|
step = 0
|
step2 == arr_arr2.length-1?arr_arr2.length-1:step2++
|
}else if(arr_arr2.length == 0&&arr_arr.length!=0){
|
step2 = 0
|
step == arr_arr.length-1?arr_arr.length-1:step++
|
}
|
|
|
for(let i=0;i<arr_arr[step]?.data.length;i++){
|
for(let x=0;x<arr_arr[step].data[i].length;x++){
|
let id_end = trueID(i)
|
// let clor = clor_end(arr_arr[step][i][x])
|
// $(`#${id_end} .data${x}`).css({'background':clor})
|
$(`#${id_end} .data${x}`).attr('value',`${arr_arr[step].data[i][x]}`)
|
if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region1'){
|
sum_region1 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region2'){
|
sum_region2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region3'){
|
sum_region3 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region4'){
|
sum_region4 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region5'){
|
sum_region5 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region6'){
|
sum_region6 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region7'){
|
sum_region7 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region8'){
|
sum_region8 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region9'){
|
sum_region9 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}
|
if(i==arr_arr[step].data.length-1&&x==arr_arr[step].data[i].length-1){
|
sum_99 = sum_region1+sum_region2+sum_region3+sum_region4+sum_region5+sum_region6+sum_region7+sum_region8+sum_region9
|
$('.dataRight .region1 .ave').text((sum_region1/region_length[0]).toFixed(5));
|
$('.dataRight .region1 .pr').text(toPercent((sum_region1/sum_99).toFixed(5)));
|
$('.dataRight .region2 .ave').text((sum_region2/region_length[1]).toFixed(5));
|
$('.dataRight .region2 .pr').text(toPercent((sum_region2/sum_99).toFixed(5)));
|
$('.dataRight .region3 .ave').text((sum_region3/region_length[2]).toFixed(5));
|
$('.dataRight .region3 .pr').text(toPercent((sum_region3/sum_99).toFixed(5)));
|
$('.dataRight .region4 .ave').text((sum_region4/region_length[3]).toFixed(5));
|
$('.dataRight .region4 .pr').text(toPercent((sum_region4/sum_99).toFixed(5)));
|
$('.dataRight .region5 .ave').text((sum_region5/region_length[4]).toFixed(5));
|
$('.dataRight .region5 .pr').text(toPercent((sum_region5/sum_99).toFixed(5)));
|
$('.dataRight .region6 .ave').text((sum_region6/region_length[5]).toFixed(5));
|
$('.dataRight .region6 .pr').text(toPercent((sum_region6/sum_99).toFixed(5)));
|
$('.dataRight .region7 .ave').text((sum_region7/region_length[6]).toFixed(5));
|
$('.dataRight .region7 .pr').text(toPercent((sum_region7/sum_99).toFixed(5)));
|
$('.dataRight .region8 .ave').text((sum_region8/region_length[7]).toFixed(5));
|
$('.dataRight .region8 .pr').text(toPercent((sum_region8/sum_99).toFixed(5)));
|
$('.dataRight .region9 .ave').text((sum_region9/region_length[8]).toFixed(5));
|
$('.dataRight .region9 .pr').text(toPercent((sum_region9/sum_99).toFixed(5)));
|
$('.fbox2 .region_1').css({opacity: opcity_end(sum_region1/region_length[0])})
|
$('.fbox2 .region_2').css({opacity: opcity_end(sum_region2/region_length[1])})
|
$('.fbox2 .region_3').css({opacity: opcity_end(sum_region3/region_length[2])})
|
$('.fbox2 .region_4').css({opacity: opcity_end(sum_region4/region_length[3])})
|
$('.fbox2 .region_5').css({opacity: opcity_end(sum_region5/region_length[4])})
|
$('.fbox2 .region_6').css({opacity: opcity_end(sum_region6/region_length[5])})
|
$('.fbox2 .region_7').css({opacity: opcity_end(sum_region7/region_length[6])})
|
$('.fbox2 .region_8').css({opacity: opcity_end(sum_region8/region_length[7])})
|
$('.fbox2 .region_9').css({opacity: opcity_end(sum_region9/region_length[8])})
|
addData(lineChart, 0, 'time',(sum_region1/region_length[0]).toFixed(5))
|
addData(lineChart, 1, 'time',(sum_region2/region_length[1]).toFixed(5))
|
addData(lineChart, 2, 'time',(sum_region3/region_length[2]).toFixed(5))
|
addData(lineChart, 3, 'time',(sum_region4/region_length[3]).toFixed(5))
|
addData(lineChart, 4, 'time',(sum_region5/region_length[4]).toFixed(5))
|
addData(lineChart, 5, 'time',(sum_region6/region_length[5]).toFixed(5))
|
addData(lineChart, 6, 'time',(sum_region7/region_length[6]).toFixed(5))
|
addData(lineChart, 7, 'time',(sum_region8/region_length[7]).toFixed(5))
|
addData(lineChart, 8, 'time',(sum_region9/region_length[8]).toFixed(5))
|
|
}
|
}
|
}
|
for(let i=0;i<arr_arr2[step2]?.data.length;i++){
|
for(let x=0;x<arr_arr2[step2].data[i].length;x++){
|
let id_end = trueID2(i)
|
// let clor = clor_end(arr_arr2[step2][i][x])
|
// $(`#${id_end} .data${x}`).css({'background':clor})
|
$(`#${id_end} .data${x}`).attr('value',`${arr_arr2[step2].data[i][x]}`)
|
if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region1'){
|
sum_region1_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region2'){
|
sum_region2_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region3'){
|
sum_region3_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region4'){
|
sum_region4_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region5'){
|
sum_region5_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region6'){
|
sum_region6_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region7'){
|
sum_region7_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region8'){
|
sum_region8_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region9'){
|
sum_region9_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}
|
if(i==arr_arr2[step2]?.data.length-1&&x==arr_arr2[step2]?.data[i].length-1){
|
sum_99_2 = sum_region1_2+sum_region2_2+sum_region3_2+sum_region4_2+sum_region5_2+sum_region6_2+sum_region7_2+sum_region8_2+sum_region9_2
|
$('.dataLeft .region1 .ave').text((sum_region1_2/region_length2[0]).toFixed(5));
|
$('.dataLeft .region1 .pr').text(toPercent((sum_region1_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region2 .ave').text((sum_region2_2/region_length2[1]).toFixed(5));
|
$('.dataLeft .region2 .pr').text(toPercent((sum_region2_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region3 .ave').text((sum_region3_2/region_length2[2]).toFixed(5));
|
$('.dataLeft .region3 .pr').text(toPercent((sum_region3/sum_99_2).toFixed(5)));
|
$('.dataLeft .region4 .ave').text((sum_region4_2/region_length2[3]).toFixed(5));
|
$('.dataLeft .region4 .pr').text(toPercent((sum_region4_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region5 .ave').text((sum_region5_2/region_length2[4]).toFixed(5));
|
$('.dataLeft .region5 .pr').text(toPercent((sum_region5_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region6 .ave').text((sum_region6_2/region_length2[5]).toFixed(5));
|
$('.dataLeft .region6 .pr').text(toPercent((sum_region6_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region7 .ave').text((sum_region7_2/region_length2[6]).toFixed(5));
|
$('.dataLeft .region7 .pr').text(toPercent((sum_region7_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region8 .ave').text((sum_region8_2/region_length2[7]).toFixed(5));
|
$('.dataLeft .region8 .pr').text(toPercent((sum_region8_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region9 .ave').text((sum_region9_2/region_length2[8]).toFixed(5));
|
$('.dataLeft .region9 .pr').text(toPercent((sum_region9_2/sum_99_2).toFixed(5)));
|
$('.fbox .region_1').css({opacity: opcity_end(sum_region1_2/region_length2[0])})
|
$('.fbox .region_2').css({opacity: opcity_end(sum_region2_2/region_length2[1])})
|
$('.fbox .region_3').css({opacity: opcity_end(sum_region3_2/region_length2[2])})
|
$('.fbox .region_4').css({opacity: opcity_end(sum_region4_2/region_length2[3])})
|
$('.fbox .region_5').css({opacity: opcity_end(sum_region5_2/region_length2[4])})
|
$('.fbox .region_6').css({opacity: opcity_end(sum_region6_2/region_length2[5])})
|
$('.fbox .region_7').css({opacity: opcity_end(sum_region7_2/region_length2[6])})
|
$('.fbox .region_8').css({opacity: opcity_end(sum_region8_2/region_length2[7])})
|
$('.fbox .region_9').css({opacity: opcity_end(sum_region9_2/region_length2[8])})
|
addData(lineChart2, 0, 'time2',(sum_region1_2/region_length2[0]).toFixed(5))
|
addData(lineChart2, 1, 'time2',(sum_region2_2/region_length2[1]).toFixed(5))
|
addData(lineChart2, 2, 'time2',(sum_region3_2/region_length2[2]).toFixed(5))
|
addData(lineChart2, 3, 'time2',(sum_region4_2/region_length2[3]).toFixed(5))
|
addData(lineChart2, 4, 'time2',(sum_region5_2/region_length2[4]).toFixed(5))
|
addData(lineChart2, 5, 'time2',(sum_region6_2/region_length2[5]).toFixed(5))
|
addData(lineChart2, 6, 'time2',(sum_region7_2/region_length2[6]).toFixed(5))
|
addData(lineChart2, 7, 'time2',(sum_region8_2/region_length2[7]).toFixed(5))
|
addData(lineChart2, 8, 'time2',(sum_region9_2/region_length2[8]).toFixed(5))
|
}
|
}
|
}
|
console.log(step,step2,arr_arr.length-1,arr_arr2.length-1)
|
if(arr_arr.length!=0&&arr_arr2.length!=0){
|
if(step == arr_arr.length-1&&step2 == arr_arr2.length-1){
|
clearInterval(timer)
|
step = 0
|
step2 = 0
|
}
|
}else if(arr_arr.length == 0){
|
if(step2 == arr_arr2.length-1){
|
clearInterval(timer)
|
step = 0
|
step2 = 0
|
}
|
}else if(arr_arr2.length == 0){
|
if(step == arr_arr.length-1){
|
clearInterval(timer)
|
step = 0
|
step2 = 0
|
}
|
}
|
|
|
sum_99 = 0;sum_region1 = 0;sum_region2 = 0;sum_region3 = 0;sum_region4 = 0;sum_region5 = 0;sum_region6 = 0;sum_region7 = 0;sum_region8 = 0;sum_region9 = 0
|
sum_99_2 = 0;sum_region1_2 = 0;sum_region2_2 = 0;sum_region3_2 = 0;sum_region4_2 = 0;sum_region5_2 = 0;sum_region6_2 = 0;sum_region7_2 = 0;sum_region8_2 = 0;sum_region9_2 = 0
|
|
},40)
|
}
|
|
|
|
})
|
|
// 上一帧
|
$('.last').click(function(){
|
clearInterval(timer)
|
clear = false
|
step ==0?0:step--
|
step2 ==0?0:step2--
|
for(let i=0;i<arr_arr[step]?.data.length;i++){
|
for(let x=0;x<arr_arr[step].data[i].length;x++){
|
let id_end = trueID(i)
|
// let clor = clor_end(arr_arr[step][i][x])
|
// $(`#${id_end} .data${x}`).css({'background':clor})
|
$(`#${id_end} .data${x}`).attr('value',`${arr_arr[step].data[i][x]}`)
|
if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region1'){
|
sum_region1 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region2'){
|
sum_region2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region3'){
|
sum_region3 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region4'){
|
sum_region4 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region5'){
|
sum_region5 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region6'){
|
sum_region6 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region7'){
|
sum_region7 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region8'){
|
sum_region8 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region9'){
|
sum_region9 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}
|
if(i==arr_arr[step]?.data.length-1&&x==arr_arr[step].data[i].length-1){
|
sum_99 = sum_region1+sum_region2+sum_region3+sum_region4+sum_region5+sum_region6+sum_region7+sum_region8+sum_region9
|
$('.dataRight .region1 .ave').text((sum_region1/region_length[0]).toFixed(5));
|
$('.dataRight .region1 .pr').text(toPercent((sum_region1/sum_99).toFixed(5)));
|
$('.dataRight .region2 .ave').text((sum_region2/region_length[1]).toFixed(5));
|
$('.dataRight .region2 .pr').text(toPercent((sum_region2/sum_99).toFixed(5)));
|
$('.dataRight .region3 .ave').text((sum_region3/region_length[2]).toFixed(5));
|
$('.dataRight .region3 .pr').text(toPercent((sum_region3/sum_99).toFixed(5)));
|
$('.dataRight .region4 .ave').text((sum_region4/region_length[3]).toFixed(5));
|
$('.dataRight .region4 .pr').text(toPercent((sum_region4/sum_99).toFixed(5)));
|
$('.dataRight .region5 .ave').text((sum_region5/region_length[4]).toFixed(5));
|
$('.dataRight .region5 .pr').text(toPercent((sum_region5/sum_99).toFixed(5)));
|
$('.dataRight .region6 .ave').text((sum_region6/region_length[5]).toFixed(5));
|
$('.dataRight .region6 .pr').text(toPercent((sum_region6/sum_99).toFixed(5)));
|
$('.dataRight .region7 .ave').text((sum_region7/region_length[6]).toFixed(5));
|
$('.dataRight .region7 .pr').text(toPercent((sum_region7/sum_99).toFixed(5)));
|
$('.dataRight .region8 .ave').text((sum_region8/region_length[7]).toFixed(5));
|
$('.dataRight .region8 .pr').text(toPercent((sum_region8/sum_99).toFixed(5)));
|
$('.dataRight .region9 .ave').text((sum_region9/region_length[8]).toFixed(5));
|
$('.dataRight .region9 .pr').text(toPercent((sum_region9/sum_99).toFixed(5)));
|
$('.fbox2 .region_1').css({opacity: opcity_end(sum_region1/region_length[0])})
|
$('.fbox2 .region_2').css({opacity: opcity_end(sum_region2/region_length[1])})
|
$('.fbox2 .region_3').css({opacity: opcity_end(sum_region3/region_length[2])})
|
$('.fbox2 .region_4').css({opacity: opcity_end(sum_region4/region_length[3])})
|
$('.fbox2 .region_5').css({opacity: opcity_end(sum_region5/region_length[4])})
|
$('.fbox2 .region_6').css({opacity: opcity_end(sum_region6/region_length[5])})
|
$('.fbox2 .region_7').css({opacity: opcity_end(sum_region7/region_length[6])})
|
$('.fbox2 .region_8').css({opacity: opcity_end(sum_region8/region_length[7])})
|
$('.fbox2 .region_9').css({opacity: opcity_end(sum_region9/region_length[8])})
|
addData(lineChart, 0, 'time',(sum_region1/region_length[0]).toFixed(5))
|
addData(lineChart, 1, 'time',(sum_region2/region_length[1]).toFixed(5))
|
addData(lineChart, 2, 'time',(sum_region3/region_length[2]).toFixed(5))
|
addData(lineChart, 3, 'time',(sum_region4/region_length[3]).toFixed(5))
|
addData(lineChart, 4, 'time',(sum_region5/region_length[4]).toFixed(5))
|
addData(lineChart, 5, 'time',(sum_region6/region_length[5]).toFixed(5))
|
addData(lineChart, 6, 'time',(sum_region7/region_length[6]).toFixed(5))
|
addData(lineChart, 7, 'time',(sum_region8/region_length[7]).toFixed(5))
|
addData(lineChart, 8, 'time',(sum_region9/region_length[8]).toFixed(5))
|
|
|
}
|
}
|
}
|
for(let i=0;i<arr_arr2[step2]?.data.length;i++){
|
for(let x=0;x<arr_arr2[step2].data[i].length;x++){
|
let id_end = trueID2(i)
|
// let clor = clor_end(arr_arr2[step2][i][x])
|
// $(`#${id_end} .data${x}`).css({'background':clor})
|
$(`#${id_end} .data${x}`).attr('value',`${arr_arr2[step2].data[i][x]}`)
|
if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region1'){
|
sum_region1_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region2'){
|
sum_region2_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region3'){
|
sum_region3_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region4'){
|
sum_region4_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region5'){
|
sum_region5_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region6'){
|
sum_region6_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region7'){
|
sum_region7_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region8'){
|
sum_region8_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region9'){
|
sum_region9_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}
|
if(i==arr_arr2[step2].data.length-1&&x==arr_arr2[step2].data[i].length-1){
|
sum_99_2 = sum_region1_2+sum_region2_2+sum_region3_2+sum_region4_2+sum_region5_2+sum_region6_2+sum_region7_2+sum_region8_2+sum_region9_2
|
$('.dataLeft .region1 .ave').text((sum_region1_2/region_length2[0]).toFixed(5));
|
$('.dataLeft .region1 .pr').text(toPercent((sum_region1_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region2 .ave').text((sum_region2_2/region_length2[1]).toFixed(5));
|
$('.dataLeft .region2 .pr').text(toPercent((sum_region2_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region3 .ave').text((sum_region3_2/region_length2[2]).toFixed(5));
|
$('.dataLeft .region3 .pr').text(toPercent((sum_region3/sum_99_2).toFixed(5)));
|
$('.dataLeft .region4 .ave').text((sum_region4_2/region_length2[3]).toFixed(5));
|
$('.dataLeft .region4 .pr').text(toPercent((sum_region4_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region5 .ave').text((sum_region5_2/region_length2[4]).toFixed(5));
|
$('.dataLeft .region5 .pr').text(toPercent((sum_region5_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region6 .ave').text((sum_region6_2/region_length2[5]).toFixed(5));
|
$('.dataLeft .region6 .pr').text(toPercent((sum_region6_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region7 .ave').text((sum_region7_2/region_length2[6]).toFixed(5));
|
$('.dataLeft .region7 .pr').text(toPercent((sum_region7_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region8 .ave').text((sum_region8_2/region_length2[7]).toFixed(5));
|
$('.dataLeft .region8 .pr').text(toPercent((sum_region8_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region9 .ave').text((sum_region9_2/region_length2[8]).toFixed(5));
|
$('.dataLeft .region9 .pr').text(toPercent((sum_region9_2/sum_99_2).toFixed(5)));
|
$('.fbox .region_1').css({opacity: opcity_end(sum_region1_2/region_length2[0])})
|
$('.fbox .region_2').css({opacity: opcity_end(sum_region2_2/region_length2[1])})
|
$('.fbox .region_3').css({opacity: opcity_end(sum_region3_2/region_length2[2])})
|
$('.fbox .region_4').css({opacity: opcity_end(sum_region4_2/region_length2[3])})
|
$('.fbox .region_5').css({opacity: opcity_end(sum_region5_2/region_length2[4])})
|
$('.fbox .region_6').css({opacity: opcity_end(sum_region6_2/region_length2[5])})
|
$('.fbox .region_7').css({opacity: opcity_end(sum_region7_2/region_length2[6])})
|
$('.fbox .region_8').css({opacity: opcity_end(sum_region8_2/region_length2[7])})
|
$('.fbox .region_9').css({opacity: opcity_end(sum_region9_2/region_length2[8])})
|
addData(lineChart2, 0, 'time2',(sum_region1_2/region_length2[0]).toFixed(5))
|
addData(lineChart2, 1, 'time2',(sum_region2_2/region_length2[1]).toFixed(5))
|
addData(lineChart2, 2, 'time2',(sum_region3_2/region_length2[2]).toFixed(5))
|
addData(lineChart2, 3, 'time2',(sum_region4_2/region_length2[3]).toFixed(5))
|
addData(lineChart2, 4, 'time2',(sum_region5_2/region_length2[4]).toFixed(5))
|
addData(lineChart2, 5, 'time2',(sum_region6_2/region_length2[5]).toFixed(5))
|
addData(lineChart2, 6, 'time2',(sum_region7_2/region_length2[6]).toFixed(5))
|
addData(lineChart2, 7, 'time2',(sum_region8_2/region_length2[7]).toFixed(5))
|
addData(lineChart2, 8, 'time2',(sum_region9_2/region_length2[8]).toFixed(5))
|
|
}
|
}
|
}
|
console.log(step,step2,arr_arr.length-1,arr_arr2.length-1)
|
sum_99 = 0;sum_region1 = 0;sum_region2 = 0;sum_region3 = 0;sum_region4 = 0;sum_region5 = 0;sum_region6 = 0;sum_region7 = 0;sum_region8 = 0;sum_region9 = 0
|
sum_99_2 = 0;sum_region1_2 = 0;sum_region2_2 = 0;sum_region3_2 = 0;sum_region4_2 = 0;sum_region5_2 = 0;sum_region6_2 = 0;sum_region7_2 = 0;sum_region8_2 = 0;sum_region9_2 = 0
|
|
})
|
|
|
|
//下一帧
|
$('.next').click(function(){
|
clearInterval(timer)
|
clear = false
|
if(arr_arr.length!=0&&arr_arr2.length!=0){
|
step == arr_arr.length-1?arr_arr.length-1:step++
|
step2 == arr_arr2.length-1?arr_arr2.length-1:step2++
|
}else if(arr_arr.length == 0&&arr_arr2.length!=0){
|
step = 0
|
step2 == arr_arr2.length-1?arr_arr2.length-1:step2++
|
}else if(arr_arr2.length == 0&&arr_arr.length!=0){
|
step2 = 0
|
step == arr_arr.length-1?arr_arr.length-1:step++
|
}
|
for(let i=0;i<arr_arr[step]?.data.length;i++){
|
for(let x=0;x<arr_arr[step].data[i].length;x++){
|
let id_end = trueID(i)
|
// let clor = clor_end(arr_arr[step][i][x])
|
// $(`#${id_end} .data${x}`).css({'background':clor})
|
$(`#${id_end} .data${x}`).attr('value',`${arr_arr[step].data[i][x]}`)
|
if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region1'){
|
sum_region1 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region2'){
|
sum_region2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region3'){
|
sum_region3 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region4'){
|
sum_region4 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region5'){
|
sum_region5 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region6'){
|
sum_region6 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region7'){
|
sum_region7 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region8'){
|
sum_region8 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region9'){
|
sum_region9 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}
|
if(i==arr_arr[step].data.length-1&&x==arr_arr[step].data[i].length-1){
|
sum_99 = sum_region1+sum_region2+sum_region3+sum_region4+sum_region5+sum_region6+sum_region7+sum_region8+sum_region9
|
$('.dataRight .region1 .ave').text((sum_region1/region_length[0]).toFixed(5));
|
$('.dataRight .region1 .pr').text(toPercent((sum_region1/sum_99).toFixed(5)));
|
$('.dataRight .region2 .ave').text((sum_region2/region_length[1]).toFixed(5));
|
$('.dataRight .region2 .pr').text(toPercent((sum_region2/sum_99).toFixed(5)));
|
$('.dataRight .region3 .ave').text((sum_region3/region_length[2]).toFixed(5));
|
$('.dataRight .region3 .pr').text(toPercent((sum_region3/sum_99).toFixed(5)));
|
$('.dataRight .region4 .ave').text((sum_region4/region_length[3]).toFixed(5));
|
$('.dataRight .region4 .pr').text(toPercent((sum_region4/sum_99).toFixed(5)));
|
$('.dataRight .region5 .ave').text((sum_region5/region_length[4]).toFixed(5));
|
$('.dataRight .region5 .pr').text(toPercent((sum_region5/sum_99).toFixed(5)));
|
$('.dataRight .region6 .ave').text((sum_region6/region_length[5]).toFixed(5));
|
$('.dataRight .region6 .pr').text(toPercent((sum_region6/sum_99).toFixed(5)));
|
$('.dataRight .region7 .ave').text((sum_region7/region_length[6]).toFixed(5));
|
$('.dataRight .region7 .pr').text(toPercent((sum_region7/sum_99).toFixed(5)));
|
$('.dataRight .region8 .ave').text((sum_region8/region_length[7]).toFixed(5));
|
$('.dataRight .region8 .pr').text(toPercent((sum_region8/sum_99).toFixed(5)));
|
$('.dataRight .region9 .ave').text((sum_region9/region_length[8]).toFixed(5));
|
$('.dataRight .region9 .pr').text(toPercent((sum_region9/sum_99).toFixed(5)));
|
$('.fbox2 .region_1').css({opacity: opcity_end(sum_region1/region_length[0])})
|
$('.fbox2 .region_2').css({opacity: opcity_end(sum_region2/region_length[1])})
|
$('.fbox2 .region_3').css({opacity: opcity_end(sum_region3/region_length[2])})
|
$('.fbox2 .region_4').css({opacity: opcity_end(sum_region4/region_length[3])})
|
$('.fbox2 .region_5').css({opacity: opcity_end(sum_region5/region_length[4])})
|
$('.fbox2 .region_6').css({opacity: opcity_end(sum_region6/region_length[5])})
|
$('.fbox2 .region_7').css({opacity: opcity_end(sum_region7/region_length[6])})
|
$('.fbox2 .region_8').css({opacity: opcity_end(sum_region8/region_length[7])})
|
$('.fbox2 .region_9').css({opacity: opcity_end(sum_region9/region_length[8])})
|
addData(lineChart, 0, 'time',(sum_region1/region_length[0]).toFixed(5))
|
addData(lineChart, 1, 'time',(sum_region2/region_length[1]).toFixed(5))
|
addData(lineChart, 2, 'time',(sum_region3/region_length[2]).toFixed(5))
|
addData(lineChart, 3, 'time',(sum_region4/region_length[3]).toFixed(5))
|
addData(lineChart, 4, 'time',(sum_region5/region_length[4]).toFixed(5))
|
addData(lineChart, 5, 'time',(sum_region6/region_length[5]).toFixed(5))
|
addData(lineChart, 6, 'time',(sum_region7/region_length[6]).toFixed(5))
|
addData(lineChart, 7, 'time',(sum_region8/region_length[7]).toFixed(5))
|
addData(lineChart, 8, 'time',(sum_region9/region_length[8]).toFixed(5))
|
|
}
|
}
|
}
|
for(let i=0;i<arr_arr2[step2]?.data.length;i++){
|
for(let x=0;x<arr_arr2[step2].data[i].length;x++){
|
let id_end = trueID2(i)
|
// let clor = clor_end(arr_arr[step2].data[i][x])
|
// $(`#${id_end} .data${x}`).css({'background':clor})
|
$(`#${id_end} .data${x}`).attr('value',`${arr_arr2[step2].data[i][x]}`)
|
if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region1'){
|
sum_region1_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region2'){
|
sum_region2_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region3'){
|
sum_region3_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region4'){
|
sum_region4_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region5'){
|
sum_region5_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region6'){
|
sum_region6_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region7'){
|
sum_region7_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region8'){
|
sum_region8_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}else if($(`#${id_end} .data${x}`)[0]?.classList[2] == 'region9'){
|
sum_region9_2 += Number($(`#${id_end} .data${x}`)[0]?.attributes[1].value == undefined?0:$(`#${id_end} .data${x}`)[0]?.attributes[1].value)
|
}
|
if(i==arr_arr2[step2].data.length-1&&x==arr_arr2[step2].data[i].length-1){
|
sum_99_2 = sum_region1_2+sum_region2_2+sum_region3_2+sum_region4_2+sum_region5_2+sum_region6_2+sum_region7_2+sum_region8_2+sum_region9_2
|
$('.dataLeft .region1 .ave').text((sum_region1_2/region_length2[0]).toFixed(5));
|
$('.dataLeft .region1 .pr').text(toPercent((sum_region1_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region2 .ave').text((sum_region2_2/region_length2[1]).toFixed(5));
|
$('.dataLeft .region2 .pr').text(toPercent((sum_region2_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region3 .ave').text((sum_region3_2/region_length2[2]).toFixed(5));
|
$('.dataLeft .region3 .pr').text(toPercent((sum_region3/sum_99_2).toFixed(5)));
|
$('.dataLeft .region4 .ave').text((sum_region4_2/region_length2[3]).toFixed(5));
|
$('.dataLeft .region4 .pr').text(toPercent((sum_region4_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region5 .ave').text((sum_region5_2/region_length2[4]).toFixed(5));
|
$('.dataLeft .region5 .pr').text(toPercent((sum_region5_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region6 .ave').text((sum_region6_2/region_length2[5]).toFixed(5));
|
$('.dataLeft .region6 .pr').text(toPercent((sum_region6_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region7 .ave').text((sum_region7_2/region_length2[6]).toFixed(5));
|
$('.dataLeft .region7 .pr').text(toPercent((sum_region7_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region8 .ave').text((sum_region8_2/region_length2[7]).toFixed(5));
|
$('.dataLeft .region8 .pr').text(toPercent((sum_region8_2/sum_99_2).toFixed(5)));
|
$('.dataLeft .region9 .ave').text((sum_region9_2/region_length2[8]).toFixed(5));
|
$('.dataLeft .region9 .pr').text(toPercent((sum_region9_2/sum_99_2).toFixed(5)));
|
$('.fbox .region_1').css({opacity: opcity_end(sum_region1_2/region_length2[0])})
|
$('.fbox .region_2').css({opacity: opcity_end(sum_region2_2/region_length2[1])})
|
$('.fbox .region_3').css({opacity: opcity_end(sum_region3_2/region_length2[2])})
|
$('.fbox .region_4').css({opacity: opcity_end(sum_region4_2/region_length2[3])})
|
$('.fbox .region_5').css({opacity: opcity_end(sum_region5_2/region_length2[4])})
|
$('.fbox .region_6').css({opacity: opcity_end(sum_region6_2/region_length2[5])})
|
$('.fbox .region_7').css({opacity: opcity_end(sum_region7_2/region_length2[6])})
|
$('.fbox .region_8').css({opacity: opcity_end(sum_region8_2/region_length2[7])})
|
$('.fbox .region_9').css({opacity: opcity_end(sum_region9_2/region_length2[8])})
|
addData(lineChart2, 0, 'time2',(sum_region1_2/region_length2[0]).toFixed(5))
|
addData(lineChart2, 1, 'time2',(sum_region2_2/region_length2[1]).toFixed(5))
|
addData(lineChart2, 2, 'time2',(sum_region3_2/region_length2[2]).toFixed(5))
|
addData(lineChart2, 3, 'time2',(sum_region4_2/region_length2[3]).toFixed(5))
|
addData(lineChart2, 4, 'time2',(sum_region5_2/region_length2[4]).toFixed(5))
|
addData(lineChart2, 5, 'time2',(sum_region6_2/region_length2[5]).toFixed(5))
|
addData(lineChart2, 6, 'time2',(sum_region7_2/region_length2[6]).toFixed(5))
|
addData(lineChart2, 7, 'time2',(sum_region8_2/region_length2[7]).toFixed(5))
|
addData(lineChart2, 8, 'time2',(sum_region9_2/region_length2[8]).toFixed(5))
|
|
}
|
}
|
}
|
console.log(step,step2,arr_arr.length-1,arr_arr2.length-1)
|
sum_99 = 0;sum_region1 = 0;sum_region2 = 0;sum_region3 = 0;sum_region4 = 0;sum_region5 = 0;sum_region6 = 0;sum_region7 = 0;sum_region8 = 0;sum_region9 = 0
|
sum_99_2 = 0;sum_region1_2 = 0;sum_region2_2 = 0;sum_region3_2 = 0;sum_region4_2 = 0;sum_region5_2 = 0;sum_region6_2 = 0;sum_region7_2 = 0;sum_region8_2 = 0;sum_region9_2 = 0
|
|
})
|
|
|
//下载文件
|
$('.download').click(function(){
|
console.log(arr_arr,arr_arr2)
|
let time = getNowTime()
|
if(arr_arr.length == 0&&arr_arr2.length>0){
|
tableToExcel(arr_arr2,`左脚${time}.csv`)
|
}else if(arr_arr2.length == 0&&arr_arr.length>0){
|
tableToExcel(arr_arr,`右脚${time}.csv`)
|
}else if(arr_arr.length>0&&arr_arr2.length>0){
|
tableToExcel(arr_arr,`右脚${time}.csv`)
|
tableToExcel(arr_arr2,`左脚${time}.csv`)
|
}else{
|
alert('缺少数据')
|
}
|
})
|
|
|
//给input标签绑定change事件，一上传选中的.xls文件就会触发该函数
|
$('#excel-file').change(function(e) {
|
var files = e.target.files;
|
var fileReader = new FileReader();
|
fileReader.onload = function(ev) {
|
try {
|
var data = ev.target.result
|
var workbook = XLSX.read(data, {
|
type: 'binary'
|
}) // 以二进制流方式读取得到整份excel表格对象
|
var persons = []; // 存储获取到的数据
|
} catch (e) {
|
console.log('文件类型不正确');
|
return;
|
}
|
|
// 表格的表格范围，可用于判断表头是否数量是否正确
|
var fromTo = '';
|
// 遍历每张表读取
|
for (var sheet in workbook.Sheets) {
|
if (workbook.Sheets.hasOwnProperty(sheet)) {
|
fromTo = workbook.Sheets[sheet]['!ref'];//读取的全部数据 A1:AN203
|
console.log(fromTo);
|
persons = persons.concat(XLSX.utils.sheet_to_json(workbook.Sheets[sheet], {header:1,defval:''}));//合并数据
|
break; // 如果只取第一张表，就取消注释这行
|
}
|
}
|
//在控制台打印出来表格中的数据
|
console.log(persons);
|
text=persons;//训练数据集text
|
// console.log(persons)
|
};
|
// 以二进制方式打开文件
|
fileReader.readAsBinaryString(files[0]);
|
});
|
