基于数据分组的高库存导出csv
Highstock export csv based on data grouping
如何修改此代码,使其基于数据分组生成csv
数据
(function( Highcharts ) {
'use strict';
Highcharts.Chart.prototype.downloadCSV = function( returnOutput ) {
var titles = [],
xValues = [],
line,
csv = "",
col,
options = (this.options.exporting || {}).csv || {},
totalSeries = 0,
xNeedsSorting = false,
// Options
dateFormat = options.dateFormat || '%d-%m-%Y',
itemDelimeter = options.itemDelimeter || ',',
url = options.url || '/service/Export/exportchartcsv.php',
lineDelimiter = options.lineDelimeter || ''n';
Highcharts.each(this.series, function( series, seriesNo ) {
if ( series.options.includeInCSVExport === true ) return;
if ( series.options.xAxis ) { // if option is set and not zero
alert("Downloading charts as CSV with multiple axes is no supported, sorry.");
throw false;
}
if ( titles.length === 0 ) {
var xTitle = ((series.xAxis.options || {}).title || {}).text;
if ( xTitle ) {
// series.xAxis.title.text exists and we use it
} else if ( series.xAxis.isDatetimeAxis ) {
xTitle = 'Date / Time';
xNeedsSorting = true;
} else if ( series.xAxis.categories ) {
xTitle = 'Category';
} else {
xTitle = 'X values';
}
titles.push(xTitle);
}
titles.push(series.name.replace(/[^a-z0-9's]/gi, '-'));
totalSeries++;
});
Highcharts.each(this.series, function( series, seriesNo ) {
if ( series.options.includeInCSVExport === true ) return;
//console.log(series.options.alternateData);
Highcharts.each(series.options.alternateData, function( point ) {
var l = xValues.length;
while ( l-- ) {
if ( xValues[l].x === point[0] ) {
xValues[l].y[seriesNo] = point[1];
return;
}
}
var y = new Array(totalSeries);
y[-1] = point[0]; // -1nth element holds formatted x axis value
y[seriesNo] = point[1];
if ( series.xAxis.isDatetimeAxis ) {
y[-1] = Highcharts.dateFormat(dateFormat, point[0]);
} else if ( series.xAxis.categories ) {
y[-1] = Highcharts.pick(series.xAxis.categories[point[0]], point[0]);
}
xValues.push({ x : point[0], y : y });
})
});
if ( xNeedsSorting ) {
xValues.sort(function( a, b ) {return a.x - b.x});
}
csv = titles.join(itemDelimeter) + lineDelimiter;
Highcharts.each(xValues, function( values ) {
line = [];
for ( col = -1; col < values.y.length; col++ ) {
line.push(values.y[col]);
}
csv += line.join(itemDelimeter) + lineDelimiter;
});
if ( returnOutput ) {
return csv;
} else {
var title = ((this.title || {}).text || 'chart') + '.csv',
a = document.createElement('a');
if ( "download" in a ) { // modern browser - no need to use backend script
a.href = 'data:attachment/csv,' + encodeURIComponent(csv);
a.target = '_blank';
a.download = title;
document.body.appendChild(a);
a.click();
a.remove();
} else {
Highcharts.post(url, { csv : csv, title : title });
}
}
};
Highcharts.Chart.prototype.getCSV = function() {
return this.downloadCSV(true);
};
// Now we want to add "Download CSV" to the exporting menu. We post the CSV
// to a simple PHP script that returns it with a content-type header as a
// downloadable file.
// The source code for the PHP script can be viewed at
// https://raw.github.com/highslide-software/highcharts.com/master/studies/csv-export/csv.php
if ( Highcharts.getOptions().exporting ) {
Highcharts.getOptions().exporting.buttons.contextButton.menuItems.push({
text : Highcharts.getOptions().lang.downloadCSV || "Export Data",
onclick : function() { this.downloadCSV() }
});
}
}(Highcharts));
首先,您使用的是旧版本的导出csv,js插件用于Highcharts。从gitHub下载实际的一个。
然后在第31行和第47行中,您将看到series.xData.slice()
/series.yData.slice()
。此数组包含原始x/y值。如果您想要dataGrouping之后的值(当应用近似值时),则从x/yData更改为x/yProcessedXData:
series.processedXData.slice();
series.processedYData.slice();
相关文章:
- 高库存时期时间与时区不匹配
- 无法让getjson在高库存上工作
- 单点高库存滚动条问题
- 高库存 - 时间轴滴答声不是连续的
- 高图表(高库存):从外部 CSV 获取数据,无法正确显示日期
- 高库存 - 使用日期时间轴时在列之间放置一条线
- 高库存 - 更改超出数据最大值的输入范围
- 为什么高库存范围选择器中有禁用的按钮
- 高图表高库存工具提示系列顺序
- 呈现高库存日期时出错
- 高库存不同的时间值间隔
- 高库存数据点像素间距
- 高库存 - 在日期时间轴上使用刻度线放置“之间”(无类别)
- 显示带有高库存的 json 文件
- 通过推送数组将数据添加到高库存
- 以编程方式读取散点图的值 - 高库存
- 将高库存标志更改为 xAxis 上的线条
- 使用自定义 html 打印高库存
- 具有 json 数据的高库存中的不同类型的系列
- 基于数据分组的高库存导出csv