aboutsummaryrefslogtreecommitdiffstats
path: root/catalog-ui/src/app/directives/export-json-to-excel/export-json-to-excel.ts
blob: deb1c9493686597a4ed18cca8357bf4f9596b9e3 (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
'use strict';
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'];