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

   1 appDS2.controller('reportStepController', function($scope,$http,$location, $routeParams, $q, $modal,$log,$window, raptorReportFactory, stepFormFactory) {
   2         /*****************Init values*********************/
   3         $scope.reportIdURL = $routeParams.reportId;
   4         $scope.isEdit = ($scope.reportIdURL==null||$scope.reportIdURL=='')?false:true;
   5         $scope.isDefReady = $scope.isEdit;
   6         $scope.activeTabsId = 'definition';
   7         $scope.pageMsg =''
   8         $scope.stepNum = 0;
   9         $scope.stepTabs=[
  10                  {
  11              title: 'Definition',
  12              id: 'definition',
  13              uniqueId: 'uniqueStep1',
  14              tabPanelId: 'definitionTab',
  15              disabled: false
  16
  17          }, {
  18              title: 'SQL',
  19              id: 'sql',
  20              uniqueId: 'uniqueStep2',
  21              tabPanelId: 'sqlTab',
  22              disabled: (!$scope.isDefReady)
  23          }, {
  24              title: 'Columns',
  25              id: 'columns',
  26              uniqueId: 'uniqueTab3x',
  27              tabPanelId: 'columnsTab',
  28              disabled: (!$scope.isDefReady)
  29          }, {
  30              title: 'Form Fields',
  31              id: 'formFields',
  32              uniqueId: 'uniqueTab4x',
  33              tabPanelId: 'formFieldsTab',
  34              disabled: (!$scope.isDefReady)
  35          }, {
  36              title: 'Security',
  37              id: 'security',
  38              uniqueId: 'uniqueTab5x',
  39              tabPanelId: 'securityTab',
  40              disabled: (!$scope.isDefReady)
  41          }, {
  42              title: 'Log',
  43              id: 'log',
  44              uniqueId: 'uniqueTab6x',
  45              tabPanelId: 'logTab',
  46              disabled: (!$scope.isDefReady)
  47          }, {
  48              title: 'Run',
  49              id: 'run',
  50              uniqueId: 'uniqueTab7x',
  51              tabPanelId: 'runTab',
  52              disabled: (!$scope.isDefReady)
  53          }
  54
  55         ];
  56         $scope.$watch('activeTabsId', function (newVal, oldVal) {
  57                 if(newVal !== oldVal) {
  58                         $scope.init();
  59                 }
  60         });
  61
  62         $scope.renderStep = function(stepNum){
  63         var containerElement = angular.element(document.getElementById("stepView"));
  64         containerElement.empty();
  65         $scope.stepNum = stepNum;
  66         var jsonSrcName = getJsonSrcName(stepNum);
  67         stepFormFactory.renderForm(jsonSrcName, containerElement, $scope);
  68     }
  69          $scope.next = function(){
  70                 $scope.stepNum = $scope.stepNum +1;
  71         $scope.activeTabsId = $scope.stepTabs[$scope.stepNum].id;
  72     };
  73
  74
  75     $scope.previous = function(){
  76                 $scope.stepNum = $scope.stepNum -1;
  77         $scope.activeTabsId = $scope.stepTabs[$scope.stepNum].id;
  78         }
  79
  80         /*******************Step 1 Definitions****************/
  81         $scope.displayOptions={
  82                         hideFormFields:false,
  83                         hideChart:false,
  84                         hideReportData:false,
  85                         hideExcel:false,
  86                         hidePdf:false
  87         }
  88         $scope.reportIdURL = $routeParams.reportId;
  89         $scope.definitionData={};
  90         $scope.definitionData.displayOptions=[
  91                 {name:'HideFormFields', selected:false},
  92                 {name:'HideChart', selected:false},
  93                 {name:'HideReportData', selected:false},
  94                 {name:'HideExcel', selected:false},
  95                 {name:'HidePdf', selected:false}
  96         ]
  97
  98 /*      $scope.definitionData.dbSrcOptions=[
  99                 {text:'local', value:'local', selected:true},
 100                 {text:'e911dev_leto07', value:'e911dev_leto07', selected:false},
 101         ]*/
 102
 103         $scope.pageSizeValues=['10','25','50','100','500'];
 104         $scope.pageSizeOptions =[];
 105         $scope.dbSrcOptions =[];
 106         $scope.maxRowValues = ['500','1000','2000','3000','4000','5000','10000','15000','20000','25000','30000','35000','40000','45000','50000','65000']
 107         $scope.maxRowOptions =[];
 108         $scope.frozenColValues = ['0','1','2','3','4'];
 109         $scope.frozenColOptions =[];
 110         $scope.dataGridAlignValues = ['Left','Right','Center'];
 111         $scope.dataGridAlignOptions =[];
 112         $scope.dataContainerValues = ['10','20','30','40','50','60','70','80','90','100','110','120','130','140','150','160','170','180','190','200'];
 113         $scope.dataContainerOptions =[];
 114         $scope.runTimeFormNumValues = ['1','2','3','4'];
 115         $scope.runTimeFormNumOptions =[];
 116         /******create*****/
 117         if(!$scope.isEdit){
 118                 $scope.definitionData.reportType = 'Linear';
 119                 //$scope.definitionData.dbInfo = 'Local';
 120                 //$scope.definitionData.dbSrcOptions = ['Local'];
 121         }
 122         /****end create***/
 123
 124         /*functions*/
 125         $scope.getDefinitionById = function(id) {
 126                 $scope.showLoader=true;
 127                 raptorReportFactory.getDefinitionByReportId(id).then(function(data){
 128                         $scope.showLoader=false;
 129                         $scope.definitionData = data;
 130                         $scope.definitionData.dbSrc=data.dbInfo;
 131                         $scope.definitionData.dbSrcOptions = data.dbInfoList;
 132                         console.log($scope.definitionData.dbSrcOptions[0].name);
 133
 134                         $scope.showLoader = false;
 135                         for(x in data.displayOptions){
 136                                 if(data.displayOptions[x].name=='HideFormFields')
 137                                         $scope.displayOptions.hideFormFields = data.displayOptions[x].selected;
 138                                 else if(data.displayOptions[x].name=='HideChart')
 139                                         $scope.displayOptions.hideChart = data.displayOptions[x].selected;
 140                                 else if(data.displayOptions[x].name=='HideReportData')
 141                                         $scope.displayOptions.hideReportData = data.displayOptions[x].selected;
 142                                 else if(data.displayOptions[x].name=='HideExcel')
 143                                         $scope.displayOptions.hideExcel = data.displayOptions[x].selected;
 144                                 else if(data.displayOptions[x].name=='HidePdf')
 145                                         $scope.displayOptions.hidePdf = data.displayOptions[x].selected;
 146                         }
 147
 148                         $scope.definitionData.frozenColumns = $scope.definitionData.frozenColumns+'';
 149                         $scope.definitionData.numFormCols = $scope.definitionData.numFormCols+'';
 150                         $scope.definitionData.allowScheduler = data.allowScheduler=='Y'?true:false;
 151                         $scope.definitionData.sizedByContent = data.sizedByContent=='Y'?true:false;
 152
 153                         $scope.definitionData.oneTimeRec = data.oneTimeRec=='Y'?true:false;
 154                         $scope.definitionData.hourlyRec = data.hourlyRec=='Y'?true:false;
 155                         $scope.definitionData.dailyRec = data.dailyRec=='Y'?true:false;
 156                         $scope.definitionData.dailyMFRec = data.dailyMFRec=='Y'?true:false;
 157                         $scope.definitionData.weeklyRec = data.weeklyRec=='Y'?true:false;
 158                         $scope.definitionData.monthlyRec = data.monthlyRec=='Y'?true:false;
 159
 160                         if($scope.definitionData.reportTitle==null || $scope.definitionData.reportTitle=='')
 161                                 $scope.definitionData.reportTitle = $scope.definitionData.reportName;
 162                 },function(error){
 163                         $scope.errorPopUp(error);
 164                         $log.error("raptorReportFactory: getDefinitionById failed.");
 165                         $scope.showLoader = false;
 166                 });
 167         }
 168
 169         $scope.constructureDefDropDown = function(){
 170
 171                 for(i in $scope.pageSizeValues){
 172                         var v = {
 173                                 value :$scope.pageSizeValues[i],
 174                                 text :$scope.pageSizeValues[i]
 175                         }
 176                         $scope.pageSizeOptions.push(v);
 177                 }
 178                 for(i in $scope.maxRowValues){
 179                         var v = {
 180                                 value :$scope.maxRowValues[i],
 181                                 text :$scope.maxRowValues[i]
 182                         }
 183                         $scope.maxRowOptions.push(v);
 184                 }
 185                 for(i in $scope.frozenColValues){
 186                         var v = {
 187                                 value :$scope.frozenColValues[i]+'',
 188                                 text :$scope.frozenColValues[i]
 189                         }
 190                         $scope.frozenColOptions.push(v);
 191                 }
 192                 for(i in $scope.dataGridAlignValues){
 193                         var v = {
 194                                 value :$scope.dataGridAlignValues[i].toLowerCase(),
 195                                 text :$scope.dataGridAlignValues[i]
 196                         }
 197                         $scope.dataGridAlignOptions.push(v);
 198                 }
 199                 for(i in $scope.dataContainerValues){
 200                         var v = {
 201                                 value :$scope.dataContainerValues[i],
 202                                 text :$scope.dataContainerValues[i]
 203                         }
 204                         $scope.dataContainerOptions.push(v);
 205                 }
 206                 for(i in $scope.runTimeFormNumValues){
 207                         var v = {
 208                                 value :$scope.runTimeFormNumValues[i],
 209                                 text :$scope.runTimeFormNumValues[i]
 210                         }
 211                         $scope.runTimeFormNumOptions.push(v);
 212                 }
 213         }
 214
 215         $scope.constructDef = function(){
 216                 var data =Object.assign({}, $scope.definitionData);
 217                 if($scope.definitionData.dbSrc){
 218                         console.log("Hello World ", $scope.definitionData.dbSrc);
 219                         data.dbInfo = $scope.definitionData.dbSrc;
 220                 }
 221                 for(x in $scope.definitionData.displayOptions){
 222                         if($scope.definitionData.displayOptions[x].name=='HideFormFields')
 223                                 data.displayOptions[x].selected = $scope.displayOptions.hideFormFields
 224                         else if($scope.definitionData.displayOptions[x].name=='HideChart')
 225                                 data.displayOptions[x].selected = $scope.displayOptions.hideChart
 226                         else if($scope.definitionData.displayOptions[x].name=='HideReportData')
 227                                 data.displayOptions[x].selected = $scope.displayOptions.hideReportData
 228                         else if($scope.definitionData.displayOptions[x].name=='HideExcel')
 229                                 data.displayOptions[x].selected = $scope.displayOptions.hideExcel
 230                         else if($scope.definitionData.displayOptions[x].name=='HidePdf')
 231                                 data.displayOptions[x].selected = $scope.displayOptions.hidePdf
 232                 }
 233                 if(data.pageSize==null || data.pageSize.startsWith("Select"))
 234                         data.pageSize = null;
 235                 if(data.maxRowsInExcelCSVDownload==null || data.maxRowsInExcelCSVDownload.startsWith("Select"))
 236                         data.maxRowsInExcelCSVDownload = null;
 237                 if(data.frozenColumns==null || data.frozenColumns.startsWith("Select"))
 238                         data.frozenColumns = null;
 239                 if(data.dataGridAlign==null || data.dataGridAlign.startsWith("Select"))
 240                         data.dataGridAlign = null;
 241                 if(data.dataContainerHeight==null || data.dataContainerHeight.startsWith("Select"))
 242                         data.dataContainerHeight = null;
 243                 if(data.dataContainerWidth ==null || data.dataContainerWidth.startsWith("Select"))
 244                         data.dataContainerWidth = null;
 245                 if(data.numFormCols ==null || data.numFormCols.startsWith("Select"))
 246                         data.numFormCols = null;
 247
 248                 if(!$scope.isEdit)
 249                         data.reportId=-1;
 250                 if(data.reportTitle==null || data.reportTitle=='')
 251                         data.reportTitle = data.reportName;
 252                 return data;
 253         }
 254         $scope.updateDef = function(){
 255                 $scope.showLoader=true;
 256                 var dataToSave = $scope.constructDef();
 257                 raptorReportFactory.updateDefinition(dataToSave,$scope.isEdit).then(function(data){
 258                         $scope.successPopUp('Definition is updated');
 259                         for(x in $scope.stepTabs){
 260                                 $scope.stepTabs[x].disabled=false;
 261                         }
 262                         $scope.showLoader=false;
 263                 },function(error){
 264                         $scope.errorPopUp(error);
 265                         $log.error("report-step-controller: updateDefinition by Id failed.");
 266                 });
 267         }
 268         /*******************Step1 Ends****************/
 269         /*******************Step2 SQL****************/
 270         $scope.pageisCreating = false;
 271         $scope.sqlScript={
 272                         value:''
 273         };
 274         $scope.sqlTestTableData='';
 275         /*function*/
 276         $scope.getSql = function(){
 277                 $scope.showLoader = true;
 278                 raptorReportFactory.getSqlInSession().then(function(data){
 279                         $scope.sqlInSessionJSON = data;
 280                         $scope.sqlScript.value = data.query;
 281                         $scope.showLoader = false;
 282                 },function(error){
 283                         $scope.errorPopUp(error);
 284                         $log.error("raptorReportFactory: getSearchData failed.");
 285                 });
 286         }
 287         $scope.testRunSql = function(){
 288                 $scope.showLoader=true;
 289                 var queryJSON = {query: $scope.sqlScript.value};
 290                 queryJSON = JSON.stringify(queryJSON);
 291                 raptorReportFactory.testRunSQL(queryJSON).then(function(data){
 292                         $scope.showLoader=false;
 293                         var modalInstance = $modal.open({
 294                                 scope: $scope,
 295                                 animation: $scope.animationsEnabled,
 296                                 templateUrl: 'app/fusion/scripts/DS2-view-models/ds2-reports/modal/report-wizard-test-run-sql.html',
 297                                 windowClass:'modal-docked',
 298                                 sizeClass: 'modal-large',
 299                                 controller: testRunSqlController,
 300                                 resolve:{
 301                                         queriedData: function(){
 302                                                 return data;
 303                                         }
 304                                 }
 305                         });
 306
 307                         modalInstance.result.finally(function () {
 308                                 if(!$scope.isEdit){
 309                                         $scope.showLoader=true;
 310                                         $scope.pageisCreating = true;
 311                                         $scope.pageMsg = 'Please wait while we are creating the report. Page will be reloaded after the creation is done.'
 312                                         raptorReportFactory.getDefinitionInSession().then(function(data){
 313                                                 var newReportId = data.reportId;
 314                                                 if(newReportId!=null && newReportId!='' && newReportId!=-1)
 315                                                         $window.location.href = "#/report_wizard/"+newReportId;
 316
 317                                                 $scope.showLoader = false;
 318                                                 $scope.pageisCreating = false;
 319                                         },function(error){
 320                                                 $scope.errorPopUp(error);
 321                                                 $log.error("raptorReportFactory: get Definition In Session failed.");
 322                                                 $scope.showLoader = false;
 323                                         });
 324                                 }
 325                         });
 326
 327                 },function(error){
 328                         $scope.errorPopUp(error);
 329                         $log.error("raptorReportFactory: test run SQL failed.");
 330                 });
 331         }
 332
 333         /*******************Step2 End****************/
 334         /*******************Step3 Column****************/
 335         $scope.colTableRowData='';
 336         $scope.isEditCol= true;
 337
 338         $scope.getColumn = function(){
 339                 $scope.showLoader = true;
 340                 raptorReportFactory.getColumnList().then(function(data){
 341                         $scope.colTableRowData = data;
 342                         $scope.showLoader = false;
 343                 },function(error){
 344                         $scope.errorPopUp(error);
 345                         $log.error("raptorReportFactory: get column list failed.");
 346                 });
 347         }
 348
 349         $scope.openColumnPopup = function (rowData) {
 350                 var modalInstance = $modal.open({
 351                         scope: $scope,
 352                         animation: $scope.animationsEnabled,
 353                         templateUrl: 'app/fusion/scripts/DS2-view-models/ds2-reports/modal/report-wizard-col-edit.html',
 354                         windowClass:'modal-docked',
 355                         sizeClass: 'modal-jumbo',
 356                         controller: openColumnPopupController,
 357                         resolve:{
 358                                 colData: function(){
 359                                         return rowData;
 360                                 }
 361                         }
 362                 });
 363                 modalInstance.result.finally(function () {
 364                         $scope.getColumn();
 365                 });
 366         };
 367
 368         /*******************Step3 End****************/
 369         /*******************Step4 Starts Form Fields****************/
 370
 371         $scope.dataProcessing = false;
 372         $scope.formFieldData = [];
 373         $scope.getFormFieldList = function(){
 374                 $scope.showLoader= true;
 375                 $scope.formFieldData = [];
 376                 raptorReportFactory.getFormFieldList().then(function(data){
 377                         $scope.showLoader= false;
 378                         $scope.formFieldData = data;
 379                         $scope.formFieldData.sort(function(obj1, obj2) {
 380                                 // Ascending: first age less than the previous
 381                                 return obj1.orderSeq - obj2.orderSeq;
 382                         });
 383
 384                         $scope.showLoader = false;
 385                 },function(error){
 386                         $scope.errorPopUp(error);
 387                         $log.error("raptorReportFactory: get formfields failed.");
 388                         $scope.showLoader = false;
 389                 });
 390         }
 391
 392         $scope.formFieldReOrder = function(upID, downID){
 393
 394                 $scope.moveUpFF={};
 395                 $scope.moveDownFF={};
 396                 $scope.showLoader=true;
 397                 raptorReportFactory.getFormFieldEditInfoById(upID).then(function(data){
 398                         $scope.moveUpFF = data;
 399                         raptorReportFactory.getFormFieldEditInfoById(downID).then(function(data){
 400                                 $scope.moveDownFF = data;
 401                                 var downOrder = $scope.moveDownFF.orderSeq;
 402                                 $scope.moveDownFF.orderSeq = $scope.moveUpFF.orderSeq;
 403                                 $scope.moveUpFF.orderSeq = downOrder;
 404                                 raptorReportFactory.saveFormFieldEditInfo($scope.moveDownFF).then(function(data){
 405                                         raptorReportFactory.saveFormFieldEditInfo($scope.moveUpFF).then(function(data){
 406                                                 $scope.successPopUp('');
 407                                         },function(error){
 408                                                 $scope.errorPopUp(error);
 409                                                 $log.error("raptorReportFactory: saveFormFieldEditInfo failed.");
 410                                         }).finally(function() {
 411                                                 $scope.showLoader=false;
 412                                                 $scope.getFormFieldList();
 413                                         })
 414                                 },function(error){
 415                                         $scope.errorPopUp(error);
 416                                         $log.error("raptorReportFactory: saveFormFieldEditInfo failed.");
 417                                 });
 418
 419                         },function(error){
 420                                 $scope.errorPopUp(error);
 421                                 $log.error("raptorReportFactory: getColumnEditInfoById failed.");
 422                         });
 423                 },function(error){
 424                         $scope.errorPopUp(error);
 425                         $log.error("raptorReportFactory: getColumnEditInfoById failed.");
 426                 })
 427
 428
 429         }
 430
 431         $scope.formFieldVerifySQL= function(sqlScript){
 432                 var queryJSON = {query: sqlScript};
 433                 queryJSON = JSON.stringify(queryJSON);
 434                 raptorReportFactory.formFieldVerifySQL(queryJSON).then(function(data){
 435                         var modalInstance = $modal.open({
 436                                 scope: $scope,
 437                                 animation: $scope.animationsEnabled,
 438                                 templateUrl: 'app/fusion/scripts/DS2-view-models/ds2-reports/modal/report-wizard-test-run-sql.html',
 439                                 sizeClass: 'modal-large',
 440                                 controller: formFieldVerifySQLController,
 441                                 resolve:{
 442                                         queriedData: function(){
 443                                                 return data;
 444                                         }
 445                                 }
 446                         })
 447
 448                 },function(error){
 449                         $scope.errorPopUp(error);
 450                         $log.error("raptorReportFactory: test run SQL failed.");
 451                 });
 452         }
 453
 454
 455         $scope.openFormFieldPopup = function (rowData,type) {
 456                 $scope.type= type;
 457                 var modalInstance = $modal.open({
 458                         scope: $scope,
 459                         animation: true,
 460                         templateUrl: 'app/fusion/scripts/DS2-view-models/ds2-reports/modal/report-wizard-formfield-edit.html',
 461                         sizeClass: 'modal-large',
 462                         controller: openFormFieldPopupController,
 463                         resolve:{
 464                                 fieldData: function(){
 465                                         return rowData;
 466                                 }
 467                         }
 468                 });
 469
 470                 modalInstance.result.finally(function () {
 471                         $scope.getFormFieldList();
 472                 });
 473         };
 474         $scope.addFormField = function(){
 475                 $scope.openFormFieldPopup('','add');
 476         }
 477
 478
 479         $scope.deleteFormField = function(rowData) {
 480                 var modalInstance = $modal.open({
 481                         scope: $scope,
 482                         animation: $scope.animationsEnabled,
 483                         templateUrl: 'app/fusion/scripts/DS2-view-models/ds2-reports/modal/report-formfield-del-confirm.html',
 484                         sizeClass: 'modal-small',
 485                         controller: deleteFormFieldController,
 486                         resolve:{
 487                                 rowData: function(){
 488                                         return rowData;
 489                                 }
 490                         }
 491                 });
 492                 modalInstance.result.then(function () {
 493                         $scope.getFormFieldList();
 494                 }, function () {
 495                 });
 496         }
 497
 498         /*******************Step4 End****************/
 499         /*******************Step5 Starts Security****************/
 500         $scope.ynOptions = [
 501                 {value:"true", text:"Yes"},
 502                 {value:"false", text:"No"}
 503         ];
 504         $scope.addReportUserId={
 505                         id:''
 506         };
 507         $scope.addReportRoleId={
 508                         id:''
 509         };
 510         $scope.loadSecurityPage = function() {
 511                 $scope.showLoader = true;
 512                 raptorReportFactory.resetSecurityLoadingCounter();
 513
 514                 //API call 1:
 515                 raptorReportFactory.getSecurityReportOwnerList().then(function(data){
 516                         $scope.reportOwnerList = data;
 517                         raptorReportFactory.icrementSecurityLoadingCounter();
 518                         if(raptorReportFactory.checkSecurityLoadingCounter()){$scope.showLoader = false;};
 519                 },function(error){
 520                         $scope.errorPopUp(error);
 521                         $log.error("raptorReportFactory: getSecurityReportOwnerList failed.");
 522                 });
 523
 524                 //API call 2: get report role list
 525                 raptorReportFactory.getReportRoleList().then(function(data){
 526                         $scope.reportRoleList = data;
 527                         raptorReportFactory.icrementSecurityLoadingCounter();
 528                         if(raptorReportFactory.checkSecurityLoadingCounter()){$scope.showLoader = false;};
 529                 },function(error){
 530                         $scope.errorPopUp(error);
 531                         $log.error("raptorReportFactory: getReportRoleList failed.");
 532                 });
 533
 534                 //API call 3: get security page basic info
 535                 raptorReportFactory.getReportSecurityInfo().then(function(data){
 536                         $scope.reportSecurityInfo = data;
 537                         $scope.reportOwnerId ={id: $scope.reportSecurityInfo.ownerId};
 538                         raptorReportFactory.icrementSecurityLoadingCounter();
 539                         if(raptorReportFactory.checkSecurityLoadingCounter()){$scope.showLoader = false;};
 540                 },function(error){
 541                         $scope.errorPopUp(error);
 542                         $log.error("raptorReportFactory: getReportSecurityInfo failed.");
 543                         $scope.showLoader = false;});
 544
 545                 //API call 4: retrieve security users
 546                 raptorReportFactory.getReportSecurityUsers().then(function(data){
 547
 548                         $scope.reportSecurityUsers = data;
 549                         for (var i=0; i<$scope.reportSecurityUsers.length;i++) {
 550                                 $scope.reportSecurityUsers[i]["accessAllowed"] = !$scope.reportSecurityUsers[i]["readOnly"];
 551                                 $scope.reportSecurityUsers[i].runAccess = true; // need to check why 1702 version is making it true always
 552                         }
 553                         raptorReportFactory.icrementSecurityLoadingCounter();
 554                         if(raptorReportFactory.checkSecurityLoadingCounter()){$scope.showLoader = false;};
 555                 },function(error){
 556                         $scope.errorPopUp(error);
 557                         $log.error("raptorReportFactory: reportSecurityUsers failed.");
 558                 });
 559
 560                 //API call 5: retrieve security roles
 561                 raptorReportFactory.getReportSecurityRoles().then(function(data){
 562                         $scope.reportSecurityRoles = data;
 563                         for (var i=0; i<$scope.reportSecurityRoles.length;i++) {
 564                                 $scope.reportSecurityRoles[i]["accessAllowed"] = !$scope.reportSecurityRoles[i]["readOnly"];
 565                                 $scope.reportSecurityRoles[i].runAccess = true; // need to check why 1702 version is making it true always
 566                         }
 567
 568                         raptorReportFactory.icrementSecurityLoadingCounter();
 569                         if(raptorReportFactory.checkSecurityLoadingCounter()){$scope.showLoader = false;};
 570                 },function(error){
 571                         $scope.errorPopUp(error);
 572                         $log.error("raptorReportFactory: reportSecurityRoles failed.");
 573                 });
 574         }
 575         $scope.addReportSecurityUser = function(userId) {
 576                 $scope.showLoader=true;
 577                 raptorReportFactory.addReportSecurityUser(userId).then(function(data){
 578                         $scope.loadSecurityPage();
 579                 },function(error){
 580                         $scope.errorPopUp(error);
 581                         $log.error("raptorReportFactory: addReportSecurityUser failed.");
 582                 }).finally(function() {
 583                         $scope.showLoader=false;
 584                 });
 585         }
 586
 587         $scope.removeReportSecurityUser = function(securityUser) {
 588                 var modalInstance = $modal.open({
 589                         scope: $scope,
 590                         animation: $scope.animationsEnabled,
 591                         templateUrl: 'app/fusion/scripts/DS2-view-models/ds2-reports/modal/report-security-user-del-confirm.html',
 592                         sizeClass: 'modal-small',
 593                         controller: removeReportSecurityUserController,
 594                         resolve:{
 595                                 securityUser: function(){
 596                                         return securityUser;
 597                                 }
 598                         }
 599                 });
 600                 modalInstance.result.then(function () {
 601                         $scope.loadSecurityPage();
 602                 }, function () {
 603                 });
 604         };
 605         $scope.addReportSecurityRole = function(roleId) {
 606                 raptorReportFactory.addReportSecurityRole(roleId).then(function(data){
 607                         $scope.loadSecurityPage();
 608                 },function(error){
 609                         $scope.errorPopUp(error);
 610                         $log.error("raptorReportFactory: addReportSecurityRole failed.");
 611                 });
 612         }
 613
 614
 615         $scope.removeReportSecurityRole = function(securityRole) {
 616                 var modalInstance = $modal.open({
 617                         scope: $scope,
 618                         animation: $scope.animationsEnabled,
 619                         templateUrl: 'app/fusion/scripts/DS2-view-models/ds2-reports/modal/report-security-role-del-confirm.html',
 620                         sizeClass: 'modal-small',
 621                         controller: removeReportSecurityRoleController,
 622                         resolve:{
 623                                 securityRole: function(){
 624                                         return securityRole;
 625                                 }
 626                         }
 627                 });
 628                 modalInstance.result.then(function () {
 629                         $scope.loadSecurityPage();
 630                 }, function () {
 631                 });
 632         }
 633
 634         $scope.saveReportSecurityInfo = function() {
 635                 $scope.showLoader = true;
 636                 var securityInfo = {'userId':$scope.reportSecurityInfo.ownerId+"",'isPublic':$scope.reportSecurityInfo.isPublic};
 637                 raptorReportFactory.updateReportSecurityInfo(securityInfo).then(function(data){
 638                         $scope.successPopUp('');
 639                         $scope.loadSecurityPage();
 640                 },function(error){
 641                         $scope.errorPopUp(error);
 642                         $log.error("raptorReportFactory: updateReportSecurityInfo failed.");
 643                 });
 644         };
 645
 646         $scope.toggleUserEditAccessActive = function(rowData) {
 647                 var modalInstance = $modal.open({
 648                         scope: $scope,
 649                         animation: $scope.animationsEnabled,
 650                         templateUrl: 'app/fusion/scripts/DS2-view-models/ds2-reports/modal/report-user-role-confirm-toggle.html',
 651                         sizeClass: 'modal-small',
 652                         controller: toggleUserEditAccessActiveController,
 653                         resolve:{
 654                                 rowData: function(){
 655                                         return rowData;
 656                                 }
 657                         }
 658                 });
 659         }
 660
 661         $scope.toggleRoleEditAccessActive = function(rowData) {
 662                 var modalInstance = $modal.open({
 663                         scope: $scope,
 664                         animation: $scope.animationsEnabled,
 665                         templateUrl: 'app/fusion/scripts/DS2-view-models/ds2-reports/modal/report-user-role-confirm-toggle.html',
 666                         sizeClass: 'modal-small',
 667                         controller: toggleRoleEditAccessActiveController,
 668                         resolve:{
 669                                 rowData: function(){
 670                                         return rowData;
 671                                 }
 672                         }
 673                 });
 674         }
 675
 676         /*******************Step5 End****************/
 677         /*******************Step6 Starts****************/
 678         $scope.logs = [];
 679         $scope.getReportID = function(){
 680                 $scope.showLoader = true;
 681                 raptorReportFactory.getReportLogs($routeParams.reportId).then(function(data){
 682                         $scope.logs = data;
 683                         $scope.showLoader = false;
 684
 685                 },function(error){
 686                         $scope.errorPopUp(error);
 687                         $log.error("raptorReportFactory: getReportID failed."+ error);
 688                 });
 689         }
 690
 691
 692         /*******************Step6 End****************/
 693         /*******************Step7 Starts Run****************/
 694         $scope.loadDefinitionInSession = function(){
 695                 $scope.showLoader = true;
 696                 raptorReportFactory.getDefinitionInSession().then(function(data){
 697                         $scope.reportId = data.reportId;
 698                         $scope.showLoader = false;
 699                 },function(error){
 700                         $scope.errorPopUp(error);
 701                         $log.error("raptorReportFactory: getDefinitionInSession failed.");
 702                         $scope.showLoader = false;
 703                 });
 704         }
 705         $scope.runReport = function(){
 706                 $window.location.href = "#/report_run/c_master="+$scope.reportId+"&refresh=Y";
 707         }
 708         /*******************Step7 End****************/
 709
 710         /********************Init*************/
 711         $scope.init = function(){
 712                 if ($routeParams.reportMode=="copy") {
 713                         raptorReportFactory.copyReportById($routeParams.reportId).then(function(data){
 714                                 $scope.isEdit = true;
 715                                 $scope.reportId = -1;
 716                                 $scope.getDefinitionById(-1);
 717                         },function(error){
 718                                 $log.error("raptorReportFactory: deleteFormFieldById failed.");
 719                         });
 720                 } /*else if ($routeParams.reportMode=="import") {
 721                         $scope.$emit('RefreshInsession');
 722                 }*/
 723
 724
 725                 if($scope.activeTabsId=='definition'){ /*Step 1*/
 726                         $scope.constructureDefDropDown();
 727                         if($scope.isEdit)
 728                                 $scope.getDefinitionById($scope.reportIdURL); //edit
 729                         else
 730                                 $scope.getDefinitionById(-1); //create
 731                 }else if($scope.activeTabsId=='sql'){ /*Step 2*/
 732                         $scope.getSql();
 733                 }else if($scope.activeTabsId=='columns'){
 734                         $scope.getColumn();
 735                 }else if($scope.activeTabsId=='formFields'){
 736                         $scope.getFormFieldList();
 737                 }else if($scope.activeTabsId=='security'){
 738                         $scope.loadSecurityPage();
 739                 }else if($scope.activeTabsId=='log'){
 740                         $scope.getReportID();
 741                 }else if($scope.activeTabsId=='run'){
 742                         $scope.reportId = $scope.reportIdURL;
 743                         if($scope.reportId==null || $scope.reportId=='')
 744                                 $scope.loadDefinitionInSession();
 745                 }
 746         }
 747
 748         $scope.successPopUp = function (msg) {
 749         var modalInstance = $modal.open({
 750                         templateUrl: 'app/fusion/scripts/DS2-modal/success_modal.html',
 751                         controller: ModalInstanceCtrl,
 752                         sizeClass: 'modal-small',
 753                         resolve: {
 754                                 msg: function () {
 755                                         var message = {
 756                                                 title:    '',
 757                                 text:     msg
 758                         };
 759                                         return message;
 760                 }
 761                 }
 762                 });
 763     };
 764
 765     $scope.errorPopUp = function (msg) {
 766         var modalInstance = $modal.open({
 767                         templateUrl: 'app/fusion/scripts/DS2-modal/error_modal.html',
 768                         controller: ModalInstanceCtrl,
 769                         sizeClass: 'modal-small',
 770                         resolve: {
 771                                 msg: function () {
 772                                         return msg;
 773                 }
 774                 }
 775                 });
 776     };
 777
 778         $scope.init();
 779 });