1 files changed, 75 insertions, 0 deletions
diff --git a/ecomp-sdk/epsdk-analytics/src/main/java/org/openecomp/portalsdk/analytics/view/CrossTabColumnValues.java b/ecomp-sdk/epsdk-analytics/src/main/java/org/openecomp/portalsdk/analytics/view/CrossTabColumnValues.java
new file mode 100644
index 00000000..8970d1a8
--- /dev/null
+++ b/ecomp-sdk/epsdk-analytics/src/main/java/org/openecomp/portalsdk/analytics/view/CrossTabColumnValues.java
@@ -0,0 +1,75 @@
+/*-
+ * ================================================================================
+ * eCOMP Portal SDK
+ * ================================================================================
+ * Copyright (C) 2017 AT&T Intellectual Property
+ * ================================================================================
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ * 
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ * 
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ * ================================================================================
+ */
+package org.openecomp.portalsdk.analytics.view;
+
+import java.util.*;
+
+import org.openecomp.portalsdk.analytics.error.*;
+import org.openecomp.portalsdk.analytics.system.*;
+import org.openecomp.portalsdk.analytics.util.*;
+
+public class CrossTabColumnValues extends org.openecomp.portalsdk.analytics.RaptorObject {
+	private String colId = null;
+
+	private Vector columnValues = null;
+
+	public CrossTabColumnValues(String colId, String loadValuesSQL, String dbInfo)
+			throws RaptorException {
+		this.colId = colId;
+		DataSet ds = ConnectionUtils.getDataSet(loadValuesSQL, dbInfo);
+		// DataSet ds = DbUtils.executeQuery(loadValuesSQL);
+		columnValues = new Vector(ds.getRowCount());
+		for (int i = 0; i < ds.getRowCount(); i++)
+			columnValues.add(ds.getString(i, 0));
+	} // CrossTabColumnValues
+
+	public String getColId() {
+		return colId;
+	}
+
+	public Vector getColumnValues() {
+		return columnValues;
+	}
+
+	public int getValuesCount() {
+		return columnValues.size();
+	}
+
+	public String getValueAt(int idx) {
+		return (String) columnValues.get(idx);
+	}
+
+	public int getIndexOf(String value) {
+		for (int i = 0; i < getValuesCount(); i++)
+			if (value.equals(getValueAt(i)))
+				return i;
+
+		return -1;
+	} // getIndexOf
+
+	public int getIndexOf(int value) {
+		for (int i = 0; i < getValuesCount(); i++)
+			if (value == new Integer(getValueAt(i)).intValue())
+				return i;
+
+		return -1;
+	} // getIndexOf
+
+} // CrossTabColumnValues