summaryrefslogtreecommitdiffstats
path: root/catalog-ui/src/app/directives/export-json-to-excel/export-json-to-excel.ts
blob: 25e7143e64c74c929a1459a02fe08e4375f96659 (plain)
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'];