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         $scope.backToParentReport = function (){
  56                 $window.location.href = "report#/report_run/"+$scope.parentReportUrlParams
  57         }
  58
  59         $scope.urlParams = parseQueryString($scope.currentReportUrlParams);
  60
  61         $scope.reportChartURL = 'report#/report_chart/'+$scope.urlParams.c_master;
  62
  63         $scope.reportEditURL = 'report#/report_wizard/'+$scope.urlParams.c_master;
  64
  65
  66         $http.get('raptor.htm?action=report.run.container&'+$scope.currentReportUrlParams).then(
  67                 function(response){
  68                         // console.log(response);
  69                         $scope.isInProgress = false;
  70                         $scope.reportData = response.data;
  71                         // console.log('reportData report run container response',$scope.reportData);
  72                         if ($scope.reportData.reportTitle) {
  73                                 $scope.reportData.reportHeading = $scope.reportData.reportTitle;
  74                                 if ($scope.reportData.reportSubTitle) {
  75                                         $scope.reportData.reportSubTitle = $scope.reportData.reportSubTitle;
  76                                 }
  77                         }
  78                         else
  79                                 $scope.reportData.reportHeading = $scope.reportData.reportName;
  80                         if(!$scope.urlParams.hideChart && $scope.reportData.chartAvailable && $scope.reportData.totalRows>1){
  81                         // console.log('raptor.htm?action=chart.run&'+convertQueryString($scope.urlParams));
  82                         $http.get('raptor.htm?action=chart.run&'+convertQueryString($scope.urlParams)).then(
  83                                         function(response){
  84                                           $scope.showChart =  true;
  85                                           document.getElementById('chartiframe').contentWindow.document.write(response.data);
  86                                           document.getElementById('chartiframe').contentWindow.document.close();
  87                                         });
  88                 }
  89
  90                 if($scope.reportData.displayForm && $scope.reportData.formFieldList && $scope.reportData.formFieldList.length>0 && !$scope.urlParams.hideFormFields){
  91                           $scope.showFormFields = true;
  92                     }
  93                 });
  94     $scope.getFormFieldSelectedValuesAsURL = function(){
  95         var formFieldsUrl = '';
  96         $scope.reportData.formFieldList.forEach(function(formField) {
  97                         if(formField.fieldType==='LIST_BOX') {
  98                                 if($scope.formFieldSelectedValues && $scope.formFieldSelectedValues[formField.fieldId] && $scope.formFieldSelectedValues[formField.fieldId].value != '') {
  99                                         formFieldsUrl = formFieldsUrl+formField.fieldId+'='+$scope.formFieldSelectedValues[formField.fieldId].value+'&';
 100                                 }
 101                         } else if(formField.fieldType==='LIST_MULTI_SELECT') {
 102                                 if($scope.formFieldSelectedValues[formField.fieldId].length >0) {
 103                                         for (var i = 0; i < $scope.formFieldSelectedValues[formField.fieldId].length; i++) {
 104                                                 if($scope.formFieldSelectedValues[formField.fieldId][i].defaultValue){
 105                                                   formFieldsUrl = formFieldsUrl+formField.fieldId+'='+$scope.formFieldSelectedValues[formField.fieldId][i].value+'&';
 106                                                 }
 107                                     }
 108                                 }
 109                         } else if((formField.fieldType === 'text' || formField.fieldType === 'TEXT') && formField.validationType === 'DATE'){
 110                                 formFieldsUrl = formFieldsUrl+formField.fieldId+'='+dateFilter($scope.formFieldSelectedValues[formField.fieldId],$scope.dateformat)+'&';
 111                         } else if((formField.fieldType === 'text' || formField.fieldType === 'TEXT') && formField.validationType === 'TIMESTAMP_MIN'){
 112                                 formFieldsUrl = formFieldsUrl+formField.fieldId+'='+dateFilter($scope.formFieldSelectedValues[formField.fieldId],$scope.datetimeformat)+'&';
 113                         } else if((formField.fieldType === 'text' || formField.fieldType === 'TEXT') && $scope.formFieldSelectedValues[formField.fieldId] && $scope.formFieldSelectedValues[formField.fieldId] != ''){
 114                                 formFieldsUrl = formFieldsUrl+formField.fieldId+'='+$scope.formFieldSelectedValues[formField.fieldId]+'&';
 115                         }
 116         });
 117         return formFieldsUrl;
 118
 119     }
 120
 121     $scope.runReport = function(pagination){
 122         var formFieldsUrl = $scope.getFormFieldSelectedValuesAsURL();
 123                 /*if ($scope.reportData.reportTitle)
 124                         $scope.reportData.reportHeading = $scope.reportData.reportTitle;
 125                 else
 126                         $scope.reportData.reportHeading = $scope.reportData.reportName;*/
 127
 128         // console.log("pagination");
 129         if(!pagination) {
 130                 //console.log("refreshed ...");
 131                 $scope.gridOptions.pageNumber = 1;
 132                 paginationOptions.pageNumber = 1;
 133                 paginationOptions.pageSize = $scope.reportData.pageSize;
 134                 //console.log($scope.gridOptions);
 135                 $scope.gridOptions.paginationCurrentPage = 1;
 136                   $scope.gridOptions.paginationPageSizes= [$scope.reportData.pageSize];
 137                   $scope.gridOptions.paginationPageSize= $scope.reportData.pageSize;
 138                   if($scope.reportData.totalRows<14){
 139                           $scope.gridHeight = ($scope.reportData.totalRows+7)*30+'px';
 140                   } else{
 141                           $scope.gridHeight = '400px';
 142                   }
 143                   $scope.gridOptions.totalItems = $scope.reportData.totalRows;
 144                   $scope.gridOptions.data= $scope.reportData.reportDataRows;
 145                   $scope.gridOptions.exporterPdfHeader.text= $scope.reportData.reportName;
 146
 147         }
 148         $scope.currentReportUrlParams = 'c_master='+$scope.urlParams.c_master+'&'+formFieldsUrl+'&display_content=Y&r_page='+(paginationOptions.pageNumber-1);
 149         // 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));
 150           $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(
 151                 function(response){
 152                         $scope.reportData = response.data;
 153                         if ($scope.reportData.reportTitle) {
 154                                         $scope.reportData.reportHeading = $scope.reportData.reportTitle;
 155                                         if ($scope.reportData.reportSubTitle) {
 156                                                 $scope.reportData.reportSubTitle = $scope.reportData.reportSubTitle;
 157                                         }
 158                                 }
 159                                 else
 160                                         $scope.reportData.reportHeading = $scope.reportData.reportName;
 161
 162                         if($scope.reportData.errormessage) {
 163                                 //console.log($scope.reportData);
 164                                 var stacktraceFP = $scope.reportData.stacktrace.substring(0, $scope.reportData.stacktrace.indexOf(":")+1);
 165                                 document.getElementById('errorDiv').innerHTML = stacktraceFP + " " + $scope.reportData.errormessage;
 166                                 //console.log(document.getElementById('errorDiv').innerHtml);
 167                                 //console.log(stacktraceFP + " " + $scope.reportData.errormessage);
 168                         }
 169                     if(!pagination) {
 170                       if(!$scope.urlParams.hideChart && $scope.reportData.chartAvailable && $scope.reportData.totalRows>1){
 171                                 // console.log('raptor.htm?action=chart.run&c_master='+$scope.urlParams.c_master+'&'+formFieldsUrl+'display_content=Y&r_page='+(paginationOptions.pageNumber-1));
 172                                 $http.get('raptor.htm?action=chart.run&c_master='+$scope.urlParams.c_master+'&'+formFieldsUrl+'display_content=Y&r_page='+(paginationOptions.pageNumber-1)).then(
 173                                                 function(response) {
 174                                                         // console.log(response.data);
 175                                                         $scope.showChart =  true;
 176                                                         // console.log('response.data',response.data);
 177                                                         document.getElementById('chartiframe').contentWindow.document.write(response.data);
 178                                                         document.getElementById('chartiframe').contentWindow.document.close();
 179                                                 });
 180                         } else {
 181                                                         $scope.showChart =  false;
 182                         }
 183                     }
 184                         if($scope.reportData.displayForm && $scope.reportData.formFieldList && $scope.reportData.formFieldList.length>0 && !$scope.urlParams.hideFormFields && !$scope.reportData.hideFormFieldsAfterRun){
 185                                 $scope.showFormFields = true;
 186                                 } else {
 187                                         $scope.showFormFields = false;
 188                                 }
 189                 });
 190     };
 191
 192           var paginationOptions = {
 193                             pageNumber: 1,
 194                             pageSize: 5,
 195                             sort: null
 196           };
 197
 198                 var correctTotalPaginationTemplate =
 199                           //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)}}
 200                           "<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>";
 201
 202           $scope.gridOptions = {
 203                                 pageNumber: 1,
 204                                 sort : null,
 205                             paginationPageSizes: [5],
 206                             paginationPageSize: 5,
 207                                 paginationTemplate: correctTotalPaginationTemplate,
 208                                 columnDefs: [],
 209                                 data: [],
 210                             enableGridMenu: true,
 211                             enableSelectAll: true,
 212                                 gridMenuCustomItems : [
 213                                         {       title : 'All Reports',
 214                                                 action : function($event) {
 215                                                         $window.open('report.htm','_self');
 216                                                         },      order : 210     },
 217                                         {       title : 'Edit Report',
 218                                                 action : function($event) {
 219                                                         $window.open($scope.reportEditURL,'_self');
 220                                                         },      order : 211     },
 221                                         {       title : 'Export All data as Excel 2007',
 222                                                 action : function($event) {
 223                                                         $window.open('raptor.htm?c_master='+$scope.reportData.reportID+'&r_action=report.download.excel2007.session','_self');
 224                                                         },      order : 212     },
 225                                         {       title : 'Export All data as Excel',
 226                                                 action : function($event) {
 227                                                         $window.open('raptor.htm?c_master='+$scope.reportData.reportID+'&r_action=report.download.excel.session','_self');
 228                                                         },      order : 213 },
 229                                         {       title : 'Export All data as CSV',
 230                                                 action : function($event) {
 231                                                         $window.open('raptor.htm?c_master='+$scope.reportData.reportID+'&r_action=report.download.csv.session','_self');
 232                                                         },      order : 214     },
 233                                         {       title : 'Export All data as PDF',
 234                                                 action : function($event) {
 235                                                         $window.open('raptor.htm?c_master='+$scope.reportData.reportID+'&r_action=report.download.pdf.session','_self');
 236                                                         },      order : 215     } ],
 237                             exporterMenuPdf: false,
 238                         exporterMenuCsv: false,
 239                             exporterCsvFilename: 'myFile.csv',
 240                             exporterPdfDefaultStyle: {fontSize: 9},
 241                             exporterPdfTableStyle: {margin: [30, 30, 30, 30]},
 242                             exporterPdfTableHeaderStyle: {fontSize: 10, bold: true, italics: true, color: 'red'},
 243                             exporterPdfHeader: { text: "My Header", style: 'headerStyle' },
 244                             exporterPdfFooter: function ( currentPage, pageCount ) {
 245                               return { text: currentPage.toString() + ' of ' + pageCount.toString(), style: 'footerStyle' };
 246                             },
 247                             exporterPdfCustomFormatter: function ( docDefinition ) {
 248                               docDefinition.styles.headerStyle = { fontSize: 22, bold: true };
 249                               docDefinition.styles.footerStyle = { fontSize: 10, bold: true };
 250                               return docDefinition;
 251                             },
 252                             exporterPdfOrientation: 'portrait',
 253                             exporterPdfPageSize: 'LETTER',
 254                             exporterPdfMaxGridWidth: 500,
 255                             exporterCsvLinkElement: angular.element(document.querySelectorAll(".custom-csv-link-location")),
 256                             onRegisterApi: function(gridApi) {
 257                                 $scope.gridApi = gridApi;
 258                                 gridApi.pagination.on.paginationChanged($scope, function (newPage, pageSize) {
 259                                   paginationOptions.pageNumber = newPage;
 260                                   paginationOptions.pageSize = pageSize;
 261                                   $scope.runReport(true);
 262                                 });
 263                               }
 264                           };
 265
 266           $scope.uiGridRefresh = function(){
 267                   var columnDefsArray = [];
 268                   var columnFreezeEndColumn = $scope.reportData.colIdxTobeFreezed;
 269                   var doColumnNeedToFreeze = false;
 270                   if(columnFreezeEndColumn && columnFreezeEndColumn.length>0) {
 271                           doColumnNeedToFreeze = true;
 272                   }
 273                   $scope.reportData.reportDataColumns.forEach(function(entry) {
 274                           var tempColumnDef = { displayName: entry.columnTitle, field: entry.colId, enableSorting: entry.sortable,
 275                                           sortingAlgorithm: function(a, b) {
 276                                          return rowSorter.sortAlpha(a.displayValue, b.displayValue);
 277                                           },
 278                                           cellTemplate: '<div  class="ui-grid-cell-contents"  style="text-align:{{COL_FIELD.alignment}};" title="TOOLTIP">   '+
 279                                                  '  <div ng-if="!COL_FIELD.drillDownURL || COL_FIELD.drillDownURL==\'\'">{{COL_FIELD.displayValue}}</div>' +
 280                                  '  <a ng-if="COL_FIELD.drillDownURL && COL_FIELD.drillDownURL!=\'\'" ng-href="{{COL_FIELD.drillDownURL}}&parent___params==={{grid.appScope.currentReportUrlParams}}" >{{COL_FIELD.displayValue}}</a>' +
 281                                                   '</div>'};
 282                           if(entry.columnWidth && entry.columnWidth!='null' && entry.columnWidth!='pxpx' && entry.columnWidth!='nullpx' && entry.columnWidth!='nullpxpx'){
 283                                   tempColumnDef['minWidth'] = entry.columnWidth.substring(0, entry.columnWidth.length - 2);
 284                           } else {
 285                                   tempColumnDef['minWidth'] = '100';
 286                           }
 287                           if(doColumnNeedToFreeze) {
 288                                   tempColumnDef['pinnedLeft']= true;
 289                                   if(columnFreezeEndColumn === entry.colId){
 290                                           doColumnNeedToFreeze = false;
 291                                   }
 292                           }
 293                           columnDefsArray.push(tempColumnDef);
 294                   });
 295
 296                   $scope.gridOptions.paginationPageSizes= [$scope.reportData.pageSize];
 297                   $scope.gridOptions.paginationPageSize= $scope.reportData.pageSize;
 298                   if($scope.reportData.totalRows<14){
 299                           $scope.gridHeight = ($scope.reportData.totalRows+5)*30+'px';
 300                   }else{
 301                           $scope.gridHeight = '400px';
 302                   }
 303                   $scope.gridOptions.totalItems = $scope.reportData.totalRows;
 304                   $scope.gridOptions.columnDefs= columnDefsArray;
 305                   $scope.gridOptions.data= $scope.reportData.reportDataRows;
 306                   $scope.gridOptions.exporterPdfHeader.text= $scope.reportData.reportName;
 307           };
 308
 309                 $scope.$watch("reportData",function(newValue,oldValue) {
 310                  if(!$scope.urlParams.hideGrid){
 311                   if($scope.reportData){
 312                 if($scope.reportData.displayData && $scope.reportData.reportDataColumns){
 313                                 $scope.showGrid =  true;
 314                         $scope.uiGridRefresh();
 315                         }
 316               }
 317                  }
 318                 });
 319
 320                 $scope.triggerOtherFormFields = function(){
 321                         // console.log("report_run");
 322                 var formFieldsUrl = $scope.getFormFieldSelectedValuesAsURL();
 323                 $http.get('raptor.htm?action=report.formfields.run.container&c_master='+$scope.reportData.reportID+'&'+formFieldsUrl).then(
 324                                 function(response){
 325                                 $scope.reportData = response.data;
 326                                 });
 327                 };
 328                 $timeout(function() {
 329                         $rootScope.isViewRendering = false;
 330                         });
 331 }]);