2 import {FileUtils} from "app/utils";
4 export interface IJsonExportExcelScope extends ng.IScope {
5 initExportExcelData:Function;
9 export class JsonExportExcelDirective implements ng.IDirective {
11 constructor(private fileUtils:FileUtils) {
15 initExportExcelData: '&'//get function that init and returns Models.ExportExcel
18 public restrict = 'E';
20 template = ():string => {
21 return require('./export-json-to-excel.html');
24 private jsonToTableText = (headers:string, dataObj:Array<Object>):string=> {
25 let tableText = headers + "\n";
26 _.each(dataObj, (rowData:any) => {
27 tableText += _.values(rowData).join() + "\n";
32 link = (scope:IJsonExportExcelScope, $elem:any) => {
33 scope.export = ():void => {
34 let exportExcelData = scope.initExportExcelData();
35 exportExcelData.fileName = !!exportExcelData.fileName ? exportExcelData.fileName : 'export-excel';
37 let headers = exportExcelData.tableHeaders.join(",");
39 if (exportExcelData.groupByField) {
40 _.each(_.groupBy(exportExcelData.dataObj, exportExcelData.groupByField), (groupData:Array<Object>) => {
41 tableData += this.jsonToTableText(headers, groupData);
45 tableData = this.jsonToTableText(headers, exportExcelData.dataObj);
48 let blob = new Blob([exportExcelData.metaData.join('\n\n') + '\n\n' + tableData], {type: "text/csv;charset=utf-8"});
50 return this.fileUtils.downloadFile(blob, exportExcelData.fileName + '.csv');
55 public static factory = (fileUtils:FileUtils)=> {
56 return new JsonExportExcelDirective( fileUtils);
61 JsonExportExcelDirective.factory.$inject = ['FileUtils'];