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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
|
/*-
* ============LICENSE_START=======================================================
* SDC
* ================================================================================
* Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
* ================================================================================
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
* ============LICENSE_END=========================================================
*/
'use strict';
import * as _ from "lodash";
import {FileUtils} from "app/utils";
export interface IJsonExportExcelScope extends ng.IScope {
initExportExcelData:Function;
export:()=>void;
}
export class JsonExportExcelDirective implements ng.IDirective {
constructor(private fileUtils:FileUtils) {
}
scope = {
initExportExcelData: '&'//get function that init and returns Models.ExportExcel
};
public restrict = 'E';
replace = true;
template = ():string => {
return require('./export-json-to-excel.html');
};
private jsonToTableText = (headers:string, dataObj:Array<Object>):string=> {
let tableText = headers + "\n";
_.each(dataObj, (rowData:any) => {
tableText += _.values(rowData).join() + "\n";
});
return tableText;
};
link = (scope:IJsonExportExcelScope, $elem:any) => {
scope.export = ():void => {
let exportExcelData = scope.initExportExcelData();
exportExcelData.fileName = !!exportExcelData.fileName ? exportExcelData.fileName : 'export-excel';
let headers = exportExcelData.tableHeaders.join(",");
let tableData = "";
if (exportExcelData.groupByField) {
_.each(_.groupBy(exportExcelData.dataObj, exportExcelData.groupByField), (groupData:Array<Object>) => {
tableData += this.jsonToTableText(headers, groupData);
tableData += '\n';
});
} else {
tableData = this.jsonToTableText(headers, exportExcelData.dataObj);
}
let blob = new Blob([exportExcelData.metaData.join('\n\n') + '\n\n' + tableData], {type: "text/csv;charset=utf-8"});
return this.fileUtils.downloadFile(blob, exportExcelData.fileName + '.csv');
};
};
public static factory = (fileUtils:FileUtils)=> {
return new JsonExportExcelDirective( fileUtils);
};
}
JsonExportExcelDirective.factory.$inject = ['FileUtils'];
|
