var ModalInstanceCtrl = function ($scope, $modalInstance, msg,$rootScope) {
	$scope.msg=msg;
}

var testRunSqlController = function ($scope, $modalInstance, $http, $log, raptorReportFactory, queriedData) {
	var init = function() {
		$scope.isError = false;
		if (queriedData.errormessage) {
			$scope.isError = true;
			$scope.errormessage = queriedData.errormessage;
			$scope.stacktrace = queriedData.stacktrace;
		} else {
			$scope.queryData = queriedData;
		}
	}
	init();	 		
	$scope.close = function() {
		$modalInstance.dismiss();
	};
}

var openColumnPopupController = function ($scope, $modalInstance, $http, $log, raptorReportFactory, colData, $routeParams) {
	$scope.processingData=true;
	$scope.colInfo={};
	$scope.drilldownReports={};
	$scope.isEditCol = true;
	var init = function() {		
		$scope.displayAlignmentOptions = [
			{value:"null", text:""},							 
			{value:"Left", text:"Left"},
			{value:"Center", text:"Center"},
			{value:"Right", text:"Right"}
		];
		$scope.dataTypeOptions = [
			{value:"Number", text:"Number"},							 
			{value:"Date", text:"Date"},
			{value:"VARCHAR2", text:"Character"},
			{value:"Hyperlink", text:"Hyperlink"}
		];
		
		$scope.multiGroupColLevel = [
			{value:"1", text:"1"},
			{value:"2", text:"2"},
			{value:"3", text:"3"},
			{value:"4", text:"4"}
		];
		$scope.indentValues = [
			{value:"1", text:"1"},
			{value:"2", text:"2"},
			{value:"3", text:"3"},
		];
	}
	
	$scope.totalForTheColList= [];
	raptorReportFactory.getTotalForTheColList().then(function(data){
		$scope.totalForTheColList = data;
	},function(error){
		$scope.errorPopUp(error);
		$log.error("raptorReportFactory: retrieveTotalForTheColList failed.");
	}); 	
	
	raptorReportFactory.getDrillDownReportList().then(function(data2){
		$scope.drilldownReports = data2;
		raptorReportFactory.getColumnEditInfoById(colData.id).then(function(data){
			$scope.colInfo = data;
			if($scope.colInfo.noWrap!=null && ($scope.colInfo.noWrap=='Y' || $scope.colInfo.noWrap==true))
				$scope.colInfo.noWrap=true;
			else
				$scope.colInfo.noWrap=false;
			$scope.processingData=false;
			init();
		},function(error){
			$scope.errorPopUp(error);
			$log.error("raptorReportFactory: getColumnEditInfoById failed.");
		}); 	
	},function(error){
		$scope.errorPopUp(error);
		$log.error("raptorReportFactory: getDrillDownReportList failed.");
	});
	
	$scope.massageData = function(){
		if(!Number.isInteger($scope.colInfo.level))
			$scope.colInfo.level = null;
		if(!Number.isInteger($scope.colInfo.indentation))
			$scope.colInfo.indentation = null;
	}
						 
	$scope.save = function() {
		$scope.processingData=true;
		$scope.colInfo.noWrap=($scope.colInfo.noWrap==true)?'Y':'N';	
		if($scope.colInfo.level && $scope.colInfo.level.startsWith("Select"))
			$scope.colInfo.level = null;
		if($scope.colInfo.displayTotal && $scope.colInfo.displayTotal.startsWith("Select"))
			$scope.colInfo.displayTotal = null;
			
		if($scope.colInfo.indentation && $scope.colInfo.indentation.startsWith("Select"))
			$scope.colInfo.indentation = null;
		raptorReportFactory.saveColumnEditInfo($scope.colInfo).then(function(data){
			$scope.successPopUp('');
			$scope.processingData=false;
			$modalInstance.close();																	
		},function(error){
			$scope.errorPopUp(error);
			$log.error("raptorReportFactory: save failed.");
			$scope.processingData=false;
		}); 						 
	};					

	$scope.cancel = function() {
		$modalInstance.dismiss();
	};
	
	
	/****Drill***/
	$scope.drilDownValues=[];			
	$scope.childReportFF =[];
	$scope.childReportCol = [];
	$scope.complete = function() {		
		var drillDownParams='';
		var ampStr = "&";
		var count =0;
		for(var i in $scope.selectedDrillReportFormField){	
			var selectedRadio = $scope.selectedDrillReportFormField[i];
			if( selectedRadio != (i+'-0')){// if it's not 'No Value' 
				if (typeof($scope.drillDownParams[i].fieldName) == "undefined"){	
					if(i>=($scope.drilDownFormField.length-1)){
						var id = $scope.drilDownFormField[i].id;
						drillDownParams+= id+"=";
					}		
				}else
					drillDownParams+=$scope.drillDownParams[i].fieldName+"=";
				if( selectedRadio == (i+'-1')){//'Fixed Value'	
					drillDownParams+= $scope.drillDownParams[i].valValue+ampStr;
				}else if( selectedRadio == (i+'-2')){//'Value of Column'
					drillDownParams+= ('['+$scope.drillDownParams[i].valColId+']'+ampStr);
				}else if( selectedRadio == (i+'-3')){//'Value of form field'
					drillDownParams+= ('[!'+$scope.drillDownParams[i].valFieldId+']'+ampStr);
				}else if( selectedRadio == (i+'-4')){//'Value set'
					if($scope.drillDownParams[i].valColId!='' && $scope.drillDownParams[i].valFieldId!='' && $scope.drillDownParams[i].valColId!='Select' && $scope.drillDownParams[i].valFieldId!='Select')	
						drillDownParams+= ('['+$scope.drillDownParams[i].valColId+'!'+$scope.drillDownParams[i].valFieldId+']'+ampStr);						
				}
			}
		}
		drillDownParams = drillDownParams.substring(0, drillDownParams.length - 1);
		$scope.colInfo.drilldownParams = drillDownParams;
		$scope.isEditCol=true;
	};
	$scope.selectedDrillReportFormField = [];
	$scope.drillDownParams = {};
	$scope.getDrillReportFormField = function(ddReportId,param){
		$scope.isEditCol = false;
		$scope.processingData = true;
		
		raptorReportFactory.getChildReportFormField(ddReportId).then(function(data){				    		
			$scope.drilDownFormField = data;
			for(var i in data){
				var array = [
					{selection: 'No Value', value:'Accept Default', radioGroup :i+'-'+'0'},
					{selection: 'Fixed Value', value:'Accept Default' , radioGroup :i+'-'+'1'},
					{selection: 'Value of Column', value:'Accept Default', radioGroup :i+'-'+'2'},
					{selection: 'Value of form field', value:'Accept Default', radioGroup :i+'-'+'3'},
					{selection: 'Value set', value:'Pass the value of the selected column if not empty, otherwise pass the value of the selected form field', radioGroup :i+'-'+'4'}
				]
				$scope.drilDownValues.push(array);
			}
			
			if(param!=''){
				raptorReportFactory.getDrillDownParamDef(param).then(function(dataDD){				
					var temp = $scope.drilDownFormField;
					$scope.drillDownParams = [];
					for(var i in $scope.drilDownFormField){
						$scope.selectedDrillReportFormField[i] = i+'-0';
						var tmp = {
								fieldName: $scope.drilDownFormField[i].id,
								valColId:'',
								ValFieldId:'',
								valType:'',
								valValue:''
						};
						$scope.drillDownParams.push(tmp);
					}
					for(var i in $scope.drilDownFormField){
						for(var j in dataDD){
							if($scope.drilDownFormField[i].id == dataDD[j].fieldName){
								$scope.selectedDrillReportFormField[i] = i+'-'+dataDD[j].valType;	
								$scope.drillDownParams[i] = dataDD[j];
							}		
						}
					}
				},function(error){
					$scope.errorPopUp(error);
					$log.error("raptorReportFactory: getChildReportFormField failed.");  
				}).finally(function() {
					$scope.processingData=false;
				});	
			}else{
				$scope.processingData = false;
			}
		},function(error){
			$scope.errorPopUp(error);
			$log.error("raptorReportFactory: getChildReportFormField failed.");  
		});

		raptorReportFactory.getChildReportFormField($scope.colInfo.drilldownURL).then(function(data){
			$scope.childReportFF =data;
		},function(error){
			$scope.errorPopUp(error);
			$log.error("raptorReportFactory: getChildReportFormField failed.");  
		});	
		
		raptorReportFactory.getChildReportColumn($routeParams.reportId).then(function(data){
			$scope.childReportCol =data;
		},function(error){
			$scope.errorPopUp(error);
			$log.error("raptorReportFactory: getChildReportFormField failed.");  
		});
	}			    	
}


var openFormFieldPopupController = function ($scope, $modalInstance, $http, $log, raptorReportFactory, fieldData) {
	$scope.formFieldEditData = {};
	$scope.sqlAsDefaultValue ={
			value:false
	};
	$scope.predefinedValues ={
			value:''
	};
	var init = function() {
		if($scope.type=='edit'){
			$scope.dataProcessing = true;
			raptorReportFactory.getFormFieldEditInfoById(fieldData.id).then(function(data){
				$scope.dataProcessing = false;
				$scope.formFieldEditData = data;
				if($scope.formFieldEditData.fieldDefaultSQL)
					$scope.sqlAsDefaultValue.value = true;
			},function(error){
				$scope.errorPopUp(error);
				$log.error("raptorReportFactory: getColumnEditInfoById failed.");
			}).finally(function() {
				$scope.dataProcessing=false; 
			});			
		}else{
			$scope.formFieldEditData ={
				groupFormField: false,
				visible:"true"
			};
		}		 						
		$scope.ynOptions = [
			{value:"true", text:"Yes"},
			{value:"false", text:"No"}							 
			];
		$scope.verifyFieldValueOptions = [
			{value:null, text:"--- Do Not Perform Validation ---"},
			{value:"DATE", text:"Date"},
			{value:"TIMESTAMP_HR", text:"TimeStamp (Hour)"},
			{value:"TIMESTAMP_MIN", text:"TimeStamp (Hour,Min)"},
			{value:"TIMESTAMP_SEC", text:"TimeStamp (Hour,Min,Sec)"},
			{value:"INTEGER", text:"Integer"},
			{value:"POSITIVE_INTEGER", text:"Positive Integer"},
			{value:"NON_NEGATIVE_INTEGER", text:"Positive Integer. Cannot Be Zero"},
			{value:"FLOAT", text:"Any Number"},
			{value:"NON_NEGATIVE_FLOAT", text:"Positive Number"},
			{value:"POSITIVE_FLOAT", text:"Positive Number. Cannot Be Zero"}
			]
		$scope.fieldTypeOptions = [
			{value:"TEXT", text:"Text Box"},
			{value:"LIST_BOX", text:"List Box"},
			{value:"LIST_MULTI_SELECT", text:"Multi-select List Box"},
			{value:"HIDDEN", text:"Hidden"}						 							 						 
			];
	}
	init();
	$scope.save = function() {
		if($scope.sqlAsDefaultValue.value && ($scope.formFieldEditData.fieldDefaultSQL==null || $scope.formFieldEditData.fieldDefaultSQL=='')){
			$scope.errorPopUp("if SQL as Default Value is checked, 'Default SQL' and 'SQL Generating Custom List of Values' fields cannot be empty");
			return;
		}else if(!$scope.sqlAsDefaultValue.value){
			$scope.formFieldEditData.fieldDefaultSQL=null;
		}
		$scope.dataProcessing = true;
		console.log($scope.formFieldEditData.validationType);
		if($scope.formFieldEditData.validationType=='Select')
			$scope.formFieldEditData.validationType = '';
		raptorReportFactory.saveFormFieldEditInfo($scope.formFieldEditData).then(function(data){
			$scope.dataProcessing = false;
			$scope.successPopUp('');
			$modalInstance.close();	
		},function(error){
			$scope.errorPopUp(error);
			$log.error("raptorReportFactory: saveFormFieldEditInfo failed.");
		}).finally(function() {
			$scope.dataProcessing=false; 
		});		      	  
	};
	
	$scope.add = function() {
		$scope.dataProcessing = true;
		$scope.formFieldEditData.visible==
		raptorReportFactory.addFormFieldEditInfo($scope.formFieldEditData).then(function(data){
			$scope.dataProcessing = false;
			$modalInstance.close();	
		},function(error){
			$scope.errorPopUp(error);
			$log.error("raptorReportFactory: add FormFieldEditInfo failed.");
		}).finally(function() {
			$scope.dataProcessing=false; 
		});
	};
	
	$scope.addPredefinedValueList = function() {
		if($scope.formFieldEditData.predefinedValueList==null)
			$scope.formFieldEditData.predefinedValueList=[];
		var item ={
				id:$scope.predefinedValues.value,
				name:$scope.predefinedValues.value,
				selected:false
		};
		if($scope.predefinedValues.value!=null && $scope.predefinedValues.value!='')
			$scope.formFieldEditData.predefinedValueList.push(item);
	};
	
	$scope.removePredefinedValueList = function(removeVal) {
		var removeIndex = null;
		for(i in $scope.formFieldEditData.predefinedValueList){
			if($scope.formFieldEditData.predefinedValueList[i].id == removeVal){
				removeIndex= i;
				break;
			}
		}
		$scope.formFieldEditData.predefinedValueList.splice(removeIndex, 1)
	};

	$scope.cancel = function() {
		$modalInstance.dismiss();
	};
}


var deleteFormFieldController = function ($scope, $modalInstance, $http, $log, raptorReportFactory, rowData) {
	$scope.tempFieldId = rowData.id;
	$scope.ok = function() {
		raptorReportFactory.deleteFormFieldById(rowData.id).then(function(data){
			$modalInstance.close();																									
		},function(error){
			$scope.errorPopUp(error);
			$log.error("raptorReportFactory: deleteFormFieldById failed.");
		});										 
	}					 
	$scope.cancel = function() {
		$modalInstance.dismiss();
	};
}

var removeReportSecurityUserController = function ($scope, $modalInstance, $http, $log, raptorReportFactory,securityUser) {					 
	$scope.securityUserName = securityUser.name;
	$scope.ok = function() {
		raptorReportFactory.removeReportSecurityUser(securityUser.id).then(function(data){
			$modalInstance.close();		
		},function(error){
			$scope.errorPopUp(error);
			$log.error("raptorReportFactory: removeReportSecurityUser failed.");
		});							 
	}					 
	$scope.cancel = function() {
		$modalInstance.dismiss();
	};
}

var removeReportSecurityRoleController = function ($scope, $modalInstance, $http, $log, raptorReportFactory,securityRole) {					 
	$scope.securityRoleName = securityRole.name;
	$scope.ok = function() {
		raptorReportFactory.removeReportSecurityRole(securityRole.id).then(function(data){
			$modalInstance.close();		
		},function(error){
			$scope.errorPopUp(error);
			$log.error("raptorReportFactory: removeReportSecurityRole failed.");
		});	
	}					 
	$scope.cancel = function() {
		$modalInstance.dismiss();
	};
}

var formFieldVerifySQLController = function ($scope, $modalInstance, $http, $log, raptorReportFactory, queriedData) {
	var init = function() {
		$scope.isError = false;
		if (queriedData.errormessage) {
			$scope.isError = true;
			$scope.errormessage = queriedData.errormessage;
			$scope.stacktrace = queriedData.stacktrace;
		} else {
			$scope.queryData = queriedData;
		}
	}
	init();	 		
	$scope.close = function() {
		$modalInstance.dismiss();
	};
}
var toggleUserEditAccessActiveController = function ($scope, $modalInstance, $http, $log, raptorReportFactory, rowData) {
	$scope.rowData = rowData;
	$scope.toggleEditAccessStatus = function(rowData) {
		raptorReportFactory.toggleUserEditAccess(rowData);
		$modalInstance.close();
	};

	$scope.cancelEditAccessToggle = function(rowData) {
		rowData.accessAllowed = ! rowData.accessAllowed;
		$modalInstance.dismiss('cancel');}
}

var toggleRoleEditAccessActiveController = function ($scope, $modalInstance, $http, $log, raptorReportFactory, rowData) {
	$scope.rowData = rowData;
	$scope.toggleEditAccessStatus = function(rowData) {
		raptorReportFactory.toggleRoleEditAccess(rowData); 
		$modalInstance.close();
	};

	$scope.cancelEditAccessToggle = function(rowData) {
		rowData.accessAllowed = ! rowData.accessAllowed;
		$modalInstance.dismiss('cancel');}
}