gerrit.onap Code Review - portal/sdk.git/blob

   1 appDS2.controller("reportRunController", ['$scope','$rootScope','$routeParams','$http','dateFilter', '$window', '$timeout', 'rowSorter',
   2                                        function ($scope,$rootScope,$routeParams,$http,dateFilter,$window,$timeout,rowSorter) {
   3         $scope.dateformat = "MM/dd/yyyy";
   4         $scope.datetimeformat = "MM/dd/yyyy hh:mm a";
   5         $scope.showFormFields =  false;
   6         $scope.showGrid =  false;
   7         $scope.showChart =  false;
   8         $scope.showBackButton = false;
   9         $scope.reportData = {};
  10         $scope.reportData.allowEdit = false;
  11         $scope.formFieldSelectedValues = {};
  12         $scope.showFormFieldIds = false;
  13     $scope.showFormFieldId = {
  14             value: false
  15         };
  16         $scope.isInProgress = true;
  17
  18         if($routeParams.reportUrlParams.indexOf("parent___params===")>-1) {
  19                 $scope.showBackButton = true;
  20                 $scope.parentReportUrlParams = $routeParams.reportUrlParams.substring($routeParams.reportUrlParams.indexOf("parent___params===")+18);
  21                 $scope.currentReportUrlParams = $routeParams.reportUrlParams.substring(0,$routeParams.reportUrlParams.indexOf("parent___params==="));
  22         } else {
  23                 $scope.currentReportUrlParams = $routeParams.reportUrlParams;
  24         }
  25         // console.log($routeParams.reportUrlParams);
  26         var parseQueryString = function( queryString ) {
  27             var params = {}, queries, temp, i, l;
  28             // Split into key/value pairs
  29             queries = queryString.split("&");
  30             // Convert the array of strings into an object
  31             for ( i = 0, l = queries.length; i < l; i++ ) {
  32                 temp = queries[i].split('=');
  33                 //console.log(temp[0]);
  34                 //console.log(temp[0] != "refresh");
  35                 if(temp[0] && temp[0] != "refresh")
  36                         params[temp[0]] = temp[1];
  37             }
  38             return params;
  39         };
  40
  41         var convertQueryString = function(queryString) {
  42                 var keys = ""; var str = "";
  43                 keys = Object.keys(queryString);
  44                 //console.log(keys);
  45                 for ( i = 0, l = keys.length; i < l; i++ ) {
  46                         str += keys[i]+"="+queryString[keys[i]] + "&";
  47
  48                 }
  49                 return str;
  50                 //queryString =
  51         }
  52
  53
  54
  55
  56         $scope.urlParams = parseQueryString($scope.currentReportUrlParams);
  57
  58         $scope.reportChartURL = 'report#/report_chart_wizard/'+$scope.urlParams.c_master;
  59
  60         $scope.reportEditURL = 'report_wizard.htm?action=report.edit&c_master='+$scope.urlParams.c_master;
  61
  62
  63         $http.get('raptor.htm?action=report.run.container&'+$scope.currentReportUrlParams).then(
  64                 function(response){
  65                         // console.log(response);
  66                         $scope.isInProgress = false;
  67                         $scope.reportData = response.data;
  68                         // console.log('reportData report run container response',$scope.reportData);
  69                         if ($scope.reportData.reportTitle) {
  70                                 $scope.reportData.reportHeading = $scope.reportData.reportTitle;
  71                                 if ($scope.reportData.reportSubTitle) {
  72                                         $scope.reportData.reportSubTitle = $scope.reportData.reportSubTitle;
  73                                 }
  74                         }
  75                         else
  76                                 $scope.reportData.reportHeading = $scope.reportData.reportName;
  77                         if(!$scope.urlParams.hideChart && $scope.reportData.chartAvailable && $scope.reportData.totalRows>1){
  78                         // console.log('raptor.htm?action=chart.run&'+convertQueryString($scope.urlParams));
  79                         $http.get('raptor.htm?action=chart.run&'+convertQueryString($scope.urlParams)).then(
  80                                         function(response){
  81                                           $scope.showChart =  true;
  82                                           document.getElementById('chartiframe').contentWindow.document.write(response.data);
  83                                           document.getElementById('chartiframe').contentWindow.document.close();
  84                                         });
  85                 }
  86
  87                 if($scope.reportData.displayForm && $scope.reportData.formFieldList && $scope.reportData.formFieldList.length>0 && !$scope.urlParams.hideFormFields){
  88                           $scope.showFormFields = true;
  89                     }
  90                 });
  91     $scope.getFormFieldSelectedValuesAsURL = function(){
  92         var formFieldsUrl = '';
  93         $scope.reportData.formFieldList.forEach(function(formField) {
  94                         if(formField.fieldType==='LIST_BOX') {
  95                                 if($scope.formFieldSelectedValues && $scope.formFieldSelectedValues[formField.fieldId] && $scope.formFieldSelectedValues[formField.fieldId].value != '') {
  96                                         formFieldsUrl = formFieldsUrl+formField.fieldId+'='+$scope.formFieldSelectedValues[formField.fieldId].value+'&';
  97                                 }
  98                         } else if(formField.fieldType==='LIST_MULTI_SELECT') {
  99                                 if($scope.formFieldSelectedValues[formField.fieldId].length >0) {
 100                                         for (var i = 0; i < $scope.formFieldSelectedValues[formField.fieldId].length; i++) {
 101                                                 if($scope.formFieldSelectedValues[formField.fieldId][i].defaultValue){
 102                                                   formFieldsUrl = formFieldsUrl+formField.fieldId+'='+$scope.formFieldSelectedValues[formField.fieldId][i].value+'&';
 103                                                 }
 104                                     }
 105                                 }
 106                         } else if((formField.fieldType === 'text' || formField.fieldType === 'TEXT') && formField.validationType === 'DATE'){
 107                                 formFieldsUrl = formFieldsUrl+formField.fieldId+'='+dateFilter($scope.formFieldSelectedValues[formField.fieldId],$scope.dateformat)+'&';
 108                         } else if((formField.fieldType === 'text' || formField.fieldType === 'TEXT') && formField.validationType === 'TIMESTAMP_MIN'){
 109                                 formFieldsUrl = formFieldsUrl+formField.fieldId+'='+dateFilter($scope.formFieldSelectedValues[formField.fieldId],$scope.datetimeformat)+'&';
 110                         } else if((formField.fieldType === 'text' || formField.fieldType === 'TEXT') && $scope.formFieldSelectedValues[formField.fieldId] && $scope.formFieldSelectedValues[formField.fieldId] != ''){
 111                                 formFieldsUrl = formFieldsUrl+formField.fieldId+'='+$scope.formFieldSelectedValues[formField.fieldId]+'&';
 112                         }
 113         });
 114         return formFieldsUrl;
 115
 116     }
 117
 118     $scope.runReport = function(pagination){
 119         var formFieldsUrl = $scope.getFormFieldSelectedValuesAsURL();
 120                 /*if ($scope.reportData.reportTitle)
 121                         $scope.reportData.reportHeading = $scope.reportData.reportTitle;
 122                 else
 123                         $scope.reportData.reportHeading = $scope.reportData.reportName;*/
 124
 125         // console.log("pagination");
 126         if(!pagination) {
 127                 //console.log("refreshed ...");
 128                 $scope.gridOptions.pageNumber = 1;
 129                 paginationOptions.pageNumber = 1;
 130                 paginationOptions.pageSize = $scope.reportData.pageSize;
 131                 //console.log($scope.gridOptions);
 132                 $scope.gridOptions.paginationCurrentPage = 1;
 133                   $scope.gridOptions.paginationPageSizes= [$scope.reportData.pageSize];
 134                   $scope.gridOptions.paginationPageSize= $scope.reportData.pageSize;
 135                   if($scope.reportData.totalRows<14){
 136                           $scope.gridHeight = ($scope.reportData.totalRows+7)*30+'px';
 137                   } else{
 138                           $scope.gridHeight = '400px';
 139                   }
 140                   $scope.gridOptions.totalItems = $scope.reportData.totalRows;
 141                   $scope.gridOptions.data= $scope.reportData.reportDataRows;
 142                   $scope.gridOptions.exporterPdfHeader.text= $scope.reportData.reportName;
 143
 144         }
 145         $scope.currentReportUrlParams = 'c_master='+$scope.urlParams.c_master+'&'+formFieldsUrl+'&display_content=Y&r_page='+(paginationOptions.pageNumber-1);
 146         // console.log('raptor.htm?action=report.run.container&c_master='+$scope.urlParams.c_master+'&'+formFieldsUrl+'refresh=Y&display_content=Y&r_page='+(paginationOptions.pageNumber-1));
 147           $http.get('raptor.htm?action=report.run.container&c_master='+$scope.urlParams.c_master+'&'+formFieldsUrl+'refresh=Y&display_content=Y&r_page='+(paginationOptions.pageNumber-1)).then(
 148                 function(response){
 149                         $scope.reportData = response.data;
 150                         if ($scope.reportData.reportTitle) {
 151                                         $scope.reportData.reportHeading = $scope.reportData.reportTitle;
 152                                         if ($scope.reportData.reportSubTitle) {
 153                                                 $scope.reportData.reportSubTitle = $scope.reportData.reportSubTitle;
 154                                         }
 155                                 }
 156                                 else
 157                                         $scope.reportData.reportHeading = $scope.reportData.reportName;
 158
 159                         if($scope.reportData.errormessage) {
 160                                 //console.log($scope.reportData);
 161                                 var stacktraceFP = $scope.reportData.stacktrace.substring(0, $scope.reportData.stacktrace.indexOf(":")+1);
 162                                 document.getElementById('errorDiv').innerHTML = stacktraceFP + " " + $scope.reportData.errormessage;
 163                                 //console.log(document.getElementById('errorDiv').innerHtml);
 164                                 //console.log(stacktraceFP + " " + $scope.reportData.errormessage);
 165                         }
 166                     if(!pagination) {
 167                       if(!$scope.urlParams.hideChart && $scope.reportData.chartAvailable && $scope.reportData.totalRows>1){
 168                                 // console.log('raptor.htm?action=chart.run&c_master='+$scope.urlParams.c_master+'&'+formFieldsUrl+'display_content=Y&r_page='+(paginationOptions.pageNumber-1));
 169                                 $http.get('raptor.htm?action=chart.run&c_master='+$scope.urlParams.c_master+'&'+formFieldsUrl+'display_content=Y&r_page='+(paginationOptions.pageNumber-1)).then(
 170                                                 function(response) {
 171                                                         // console.log(response.data);
 172                                                         $scope.showChart =  true;
 173                                                         // console.log('response.data',response.data);
 174                                                         document.getElementById('chartiframe').contentWindow.document.write(response.data);
 175                                                         document.getElementById('chartiframe').contentWindow.document.close();
 176                                                 });
 177                         } else {
 178                                                         $scope.showChart =  false;
 179                         }
 180                     }
 181                         if($scope.reportData.displayForm && $scope.reportData.formFieldList && $scope.reportData.formFieldList.length>0 && !$scope.urlParams.hideFormFields && !$scope.reportData.hideFormFieldsAfterRun){
 182                                 $scope.showFormFields = true;
 183                                 } else {
 184                                         $scope.showFormFields = false;
 185                                 }
 186                 });
 187     };
 188
 189           var paginationOptions = {
 190                             pageNumber: 1,
 191                             pageSize: 5,
 192                             sort: null
 193           };
 194
 195                 var correctTotalPaginationTemplate =
 196                           //same as normal template, but fixed totals:  {{(((grid.options.paginationCurrentPage-1)*grid.options.paginationPageSize)+1)}}   {{(grid.options.paginationCurrentPage*grid.options.paginationPageSize>grid.options.totalItems?grid.options.totalItems:grid.options.paginationCurrentPage*grid.options.paginationPageSize)}}
 197                           "<div role=\"contentinfo\" class=\"ui-grid-pager-panel\" ui-grid-pager ng-show=\"grid.options.enablePaginationControls\"><div role=\"navigation\" class=\"ui-grid-pager-container\"><div role=\"menubar\" class=\"ui-grid-pager-control\"><button type=\"button\" role=\"menuitem\" class=\"ui-grid-pager-first\" ui-grid-one-bind-title=\"aria.pageToFirst\" ui-grid-one-bind-aria-label=\"aria.pageToFirst\" ng-click=\"pageFirstPageClick()\" ng-disabled=\"cantPageBackward()\"><div class=\"first-triangle\"><div class=\"first-bar\"></div></div></button> <button type=\"button\" role=\"menuitem\" class=\"ui-grid-pager-previous\" ui-grid-one-bind-title=\"aria.pageBack\" ui-grid-one-bind-aria-label=\"aria.pageBack\" ng-click=\"pagePreviousPageClick()\" ng-disabled=\"cantPageBackward()\"><div class=\"first-triangle prev-triangle\"></div></button> <input type=\"number\" ui-grid-one-bind-title=\"aria.pageSelected\" ui-grid-one-bind-aria-label=\"aria.pageSelected\" class=\"ui-grid-pager-control-input\" ng-model=\"grid.options.paginationCurrentPage\" min=\"1\" max=\"{{ paginationApi.getTotalPages() }}\" required> <span class=\"ui-grid-pager-max-pages-number\" ng-show=\"paginationApi.getTotalPages() > 0\"><abbr ui-grid-one-bind-title=\"paginationOf\">/</abbr> {{ paginationApi.getTotalPages() }}</span> <button type=\"button\" role=\"menuitem\" class=\"ui-grid-pager-next\" ui-grid-one-bind-title=\"aria.pageForward\" ui-grid-one-bind-aria-label=\"aria.pageForward\" ng-click=\"pageNextPageClick()\" ng-disabled=\"cantPageForward()\"><div class=\"last-triangle next-triangle\"></div></button> <button type=\"button\" role=\"menuitem\" class=\"ui-grid-pager-last\" ui-grid-one-bind-title=\"aria.pageToLast\" ui-grid-one-bind-aria-label=\"aria.pageToLast\" ng-click=\"pageLastPageClick()\" ng-disabled=\"cantPageToLast()\"><div class=\"last-triangle\"><div class=\"last-bar\"></div></div></button></div><div class=\"ui-grid-pager-row-count-picker\" ng-if=\"grid.options.paginationPageSizes.length > 1\"><select ui-grid-one-bind-aria-labelledby-grid=\"'items-per-page-label'\" ng-model=\"grid.options.paginationPageSize\" ng-options=\"o as o for o in grid.options.paginationPageSizes\"></select><span ui-grid-one-bind-id-grid=\"'items-per-page-label'\" class=\"ui-grid-pager-row-count-label\">&nbsp;{{sizesLabel}}</span></div><span ng-if=\"grid.options.paginationPageSizes.length <= 1\" class=\"ui-grid-pager-row-count-label\">{{grid.options.paginationPageSize}}&nbsp;{{sizesLabel}}</span></div><div class=\"ui-grid-pager-count-container\"><div class=\"ui-grid-pager-count\"><span ng-show=\"grid.options.totalItems > 0\">{{(((grid.options.paginationCurrentPage-1)*grid.options.paginationPageSize)+1)}} <abbr ui-grid-one-bind-title=\"paginationThrough\">-</abbr> {{(grid.options.paginationCurrentPage*grid.options.paginationPageSize>grid.options.totalItems?grid.options.totalItems:grid.options.paginationCurrentPage*grid.options.paginationPageSize)}} {{paginationOf}} {{grid.options.totalItems}} {{totalItemsLabel}}</span></div></div></div>";
 198
 199           $scope.gridOptions = {
 200                                 pageNumber: 1,
 201                                 sort : null,
 202                             paginationPageSizes: [5],
 203                             paginationPageSize: 5,
 204                                 paginationTemplate: correctTotalPaginationTemplate,
 205                                 columnDefs: [],
 206                                 data: [],
 207                             enableGridMenu: true,
 208                             enableSelectAll: true,
 209                                 gridMenuCustomItems : [
 210                                         {       title : 'All Reports',
 211                                                 action : function($event) {
 212                                                         $window.open('report.htm','_self');
 213                                                         },      order : 210     },
 214                                         {       title : 'Edit Report',
 215                                                 action : function($event) {
 216                                                         $window.open($scope.reportEditURL,'_self');
 217                                                         },      order : 211     },
 218                                         {       title : 'Export All data as Excel 2007',
 219                                                 action : function($event) {
 220                                                         $window.open('raptor.htm?c_master='+$scope.reportData.reportID+'&r_action=report.download.excel2007.session','_self');
 221                                                         },      order : 212     },
 222                                         {       title : 'Export All data as Excel',
 223                                                 action : function($event) {
 224                                                         $window.open('raptor.htm?c_master='+$scope.reportData.reportID+'&r_action=report.download.excel.session','_self');
 225                                                         },      order : 213 },
 226                                         {       title : 'Export All data as CSV',
 227                                                 action : function($event) {
 228                                                         $window.open('raptor.htm?c_master='+$scope.reportData.reportID+'&r_action=report.download.csv.session','_self');
 229                                                         },      order : 214     },
 230                                         {       title : 'Export All data as PDF',
 231                                                 action : function($event) {
 232                                                         $window.open('raptor.htm?c_master='+$scope.reportData.reportID+'&r_action=report.download.pdf.session','_self');
 233                                                         },      order : 215     } ],
 234                             exporterMenuPdf: false,
 235                         exporterMenuCsv: false,
 236                             exporterCsvFilename: 'myFile.csv',
 237                             exporterPdfDefaultStyle: {fontSize: 9},
 238                             exporterPdfTableStyle: {margin: [30, 30, 30, 30]},
 239                             exporterPdfTableHeaderStyle: {fontSize: 10, bold: true, italics: true, color: 'red'},
 240                             exporterPdfHeader: { text: "My Header", style: 'headerStyle' },
 241                             exporterPdfFooter: function ( currentPage, pageCount ) {
 242                               return { text: currentPage.toString() + ' of ' + pageCount.toString(), style: 'footerStyle' };
 243                             },
 244                             exporterPdfCustomFormatter: function ( docDefinition ) {
 245                               docDefinition.styles.headerStyle = { fontSize: 22, bold: true };
 246                               docDefinition.styles.footerStyle = { fontSize: 10, bold: true };
 247                               return docDefinition;
 248                             },
 249                             exporterPdfOrientation: 'portrait',
 250                             exporterPdfPageSize: 'LETTER',
 251                             exporterPdfMaxGridWidth: 500,
 252                             exporterCsvLinkElement: angular.element(document.querySelectorAll(".custom-csv-link-location")),
 253                             onRegisterApi: function(gridApi) {
 254                                 $scope.gridApi = gridApi;
 255                                 gridApi.pagination.on.paginationChanged($scope, function (newPage, pageSize) {
 256                                   paginationOptions.pageNumber = newPage;
 257                                   paginationOptions.pageSize = pageSize;
 258                                   $scope.runReport(true);
 259                                 });
 260                               }
 261                           };
 262
 263           $scope.uiGridRefresh = function(){
 264                   var columnDefsArray = [];
 265                   var columnFreezeEndColumn = $scope.reportData.colIdxTobeFreezed;
 266                   var doColumnNeedToFreeze = false;
 267                   if(columnFreezeEndColumn && columnFreezeEndColumn.length>0) {
 268                           doColumnNeedToFreeze = true;
 269                   }
 270                   $scope.reportData.reportDataColumns.forEach(function(entry) {
 271                           var tempColumnDef = { displayName: entry.columnTitle, field: entry.colId, enableSorting: entry.sortable,
 272                                           sortingAlgorithm: function(a, b) {
 273                                          return rowSorter.sortAlpha(a.displayValue, b.displayValue);
 274                                           },
 275                                           cellTemplate: '<div  class="ui-grid-cell-contents"  style="text-align:{{COL_FIELD.alignment}};" title="TOOLTIP">   '+
 276                                                  '  <div ng-if="!COL_FIELD.drillDownURL || COL_FIELD.drillDownURL==\'\'">{{COL_FIELD.displayValue}}</div>' +
 277                                  '  <a ng-if="COL_FIELD.drillDownURL && COL_FIELD.drillDownURL!=\'\'" ng-href="{{COL_FIELD.drillDownURL}}&parent___params==={{grid.appScope.currentReportUrlParams}}" >{{COL_FIELD.displayValue}}</a>' +
 278                                                   '</div>'};
 279                           if(entry.columnWidth && entry.columnWidth!='null' && entry.columnWidth!='pxpx' && entry.columnWidth!='nullpx' && entry.columnWidth!='nullpxpx'){
 280                                   tempColumnDef['minWidth'] = entry.columnWidth.substring(0, entry.columnWidth.length - 2);
 281                           } else {
 282                                   tempColumnDef['minWidth'] = '100';
 283                           }
 284                           if(doColumnNeedToFreeze) {
 285                                   tempColumnDef['pinnedLeft']= true;
 286                                   if(columnFreezeEndColumn === entry.colId){
 287                                           doColumnNeedToFreeze = false;
 288                                   }
 289                           }
 290                           columnDefsArray.push(tempColumnDef);
 291                   });
 292
 293                   $scope.gridOptions.paginationPageSizes= [$scope.reportData.pageSize];
 294                   $scope.gridOptions.paginationPageSize= $scope.reportData.pageSize;
 295                   if($scope.reportData.totalRows<14){
 296                           $scope.gridHeight = ($scope.reportData.totalRows+5)*30+'px';
 297                   }else{
 298                           $scope.gridHeight = '400px';
 299                   }
 300                   $scope.gridOptions.totalItems = $scope.reportData.totalRows;
 301                   $scope.gridOptions.columnDefs= columnDefsArray;
 302                   $scope.gridOptions.data= $scope.reportData.reportDataRows;
 303                   $scope.gridOptions.exporterPdfHeader.text= $scope.reportData.reportName;
 304           };
 305
 306                 $scope.$watch("reportData",function(newValue,oldValue) {
 307                  if(!$scope.urlParams.hideGrid){
 308                   if($scope.reportData){
 309                 if($scope.reportData.displayData && $scope.reportData.reportDataColumns){
 310                                 $scope.showGrid =  true;
 311                         $scope.uiGridRefresh();
 312                         }
 313               }
 314                  }
 315                 });
 316
 317                 $scope.triggerOtherFormFields = function(){
 318                         // console.log("report_run");
 319                 var formFieldsUrl = $scope.getFormFieldSelectedValuesAsURL();
 320                 $http.get('raptor.htm?action=report.formfields.run.container&c_master='+$scope.reportData.reportID+'&'+formFieldsUrl).then(
 321                                 function(response){
 322                                 $scope.reportData = response.data;
 323                                 });
 324                 };
 325                 $timeout(function() {
 326                         $rootScope.isViewRendering = false;
 327                         });
 328 }]);