1 files changed, 183 insertions, 0 deletions
diff --git a/ecomp-sdk/epsdk-analytics/src/main/java/org/openecomp/portalsdk/analytics/system/fusion/service/RaptorServiceImpl.java b/ecomp-sdk/epsdk-analytics/src/main/java/org/openecomp/portalsdk/analytics/system/fusion/service/RaptorServiceImpl.java
new file mode 100644
index 00000000..1427a2ea
--- /dev/null
+++ b/ecomp-sdk/epsdk-analytics/src/main/java/org/openecomp/portalsdk/analytics/system/fusion/service/RaptorServiceImpl.java
@@ -0,0 +1,183 @@
+/*-
+ * ================================================================================
+ * 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.system.fusion.service;
+
+import java.io.BufferedInputStream;
+import java.io.BufferedOutputStream;
+import java.io.FileOutputStream;
+import java.io.IOException;
+import java.io.InputStream;
+import java.io.OutputStream;
+import java.math.BigDecimal;
+import java.util.Date;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
+import java.util.Set;
+
+import javax.sql.DataSource;
+
+import org.hibernate.Query;
+import org.hibernate.Session;
+import org.openecomp.portalsdk.analytics.system.fusion.domain.CR_Report;
+import org.openecomp.portalsdk.core.domain.Role;
+import org.openecomp.portalsdk.core.service.DataAccessService;
+import org.openecomp.portalsdk.core.service.support.FusionService;
+import org.openecomp.portalsdk.core.util.SystemProperties;
+import org.openecomp.portalsdk.core.web.support.UserUtils;
+import org.springframework.context.ApplicationContext;
+import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
+import org.springframework.orm.hibernate3.SessionFactoryUtils;
+import org.springframework.web.multipart.MultipartFile;
+
+public class RaptorServiceImpl extends FusionService implements RaptorService {
+
+	private DataAccessService dataAccessService;
+	
+	private int totalSize;
+
+	public DataAccessService getDataAccessService() {
+		return dataAccessService;
+	}
+
+	public void setDataAccessService(DataAccessService dataAccessService) {
+		this.dataAccessService = dataAccessService;
+	}
+	
+	private ApplicationContext applicationContext;
+
+    //raptorSearchAllReportsCount
+	
+	public int executeCountQuery(Class entity, String query, Map params, String whereClause) {
+		List l  = getDataAccessService().executeNamedCountQuery(entity, query, whereClause, params);
+		//List l  = getDataAccessService().executeNamedQuery(query, params, null);
+		int searchCount = 0;
+		if(l != null) {
+			if (!l.isEmpty()) {
+				searchCount = (((Long) l.get(0))).intValue();
+			}
+		}
+		totalSize = searchCount;
+		return totalSize;
+	}
+	
+	//raptorSearchAllReports
+	public List executeGridQuery(String query, Map params, Integer fromIndex, Integer toIndex) {
+	  return getDataAccessService().executeNamedQuery(query, params, fromIndex, toIndex, null);
+	}
+
+	public List executeGridQueryOrderByWithLimit(Class entity, String query, Map params, String _orderBy, boolean asc, Integer fromIndex, Integer toIndex) {
+		return getDataAccessService().executeNamedQueryWithOrderBy(entity, query, params, _orderBy, asc, fromIndex, toIndex, null);
+	}
+	
+    //with where clause
+	public List executeGridQuery(Class entity, String query, String whereClause, Map params, Integer fromIndex, Integer toIndex) {
+		  return getDataAccessService().executeNamedQuery(entity, query, whereClause, params, fromIndex, toIndex, null);
+	}
+
+	public List executeGridQueryOrderByWithLimit(Class entity, String query, String whereClause, Map params, String _orderBy, boolean asc, Integer fromIndex, Integer toIndex) {
+			return getDataAccessService().executeNamedQueryWithOrderBy(entity, query, whereClause, params, _orderBy, asc, fromIndex, toIndex, null);
+	}	
+	
+	/*
+	public int getUserReportsCount(Map params) {
+		List l  = getDataAccessService().executeNamedQuery("raptorSearchUserReportsCount", params, null);
+		int count = 0;
+		if(l != null) {
+			if (!l.isEmpty()) {
+				Object[] result = (Object[]) l.get(0);
+				count = ((Long)result[0]).intValue();
+			}
+		}
+		totalSize = count;
+		return totalSize;
+	}
+	
+	public List getUserReports(Map params, Integer fromIndex, Integer toIndex) {
+	  return getDataAccessService().executeNamedQuery("raptorSearchUserReports", params, fromIndex, toIndex, null);
+	}
+
+	public int getPublicReportsCount(Map params) {
+		List l  = getDataAccessService().executeNamedQuery("raptorPublicUserReportsCount", params, null);
+		int count = 0;
+		if(l != null) {
+			if (!l.isEmpty()) {
+				Object[] result = (Object[]) l.get(0);
+				count = ((Long)result[0]).intValue();
+			}
+		}
+		totalSize = count;
+		return totalSize;
+	}
+	
+	public List getPublicReports(Map params, Integer fromIndex, Integer toIndex) {
+	  return getDataAccessService().executeNamedQuery("raptorPublicUserReports", params, fromIndex, toIndex, null);
+	}
+
+	public int getFavReportsCount(Map params) {
+		List l  = getDataAccessService().executeNamedQuery("raptorSearchFavReportsCount", params, null);
+		int count = 0;
+		if(l != null) {
+			if (!l.isEmpty()) {
+				Object[] result = (Object[]) l.get(0);
+				count = ((Long)result[0]).intValue();
+			}
+		}
+		totalSize = count;
+		return totalSize;
+	}
+	
+	public List getFavReports(Map params, Integer fromIndex, Integer toIndex) {
+	  return getDataAccessService().executeNamedQuery("raptorSearchFavReports", params, fromIndex, toIndex, null);
+	}
+	*/	
+	public int getTotalSize() {
+		return totalSize;
+	}
+	
+	public void deleteReport(Long reportId) {
+		getDataAccessService().deleteDomainObject(getDataAccessService().getDomainObject(CR_Report.class, reportId, null), null);
+	}
+	
+	public List getReportInfo(Map params) {
+		return getDataAccessService().executeNamedQuery("raptorInfoQuery", params, null);
+	}
+	 
+/*	public List executeGridQueryWithOrderBy(String query, Map params, String _orderBy, boolean asc, Integer fromIndex, Integer toIndex) {
+		query = String.format(query, _orderBy, asc ? "ASC" : "DESC", fromIndex, toIndex);
+		DataSource ds = (DataSource)getApplicationContext().getBean(searchBean.getDatasourceName());
+		NamedParameterJdbcTemplate jdbcTemplate = new NamedParameterJdbcTemplate(ds);
+	}*/
+
+	/**
+	 * @return the applicationContext
+	 */
+	public ApplicationContext getApplicationContext() {
+		return applicationContext;
+	}
+
+	/**
+	 * @param applicationContext the applicationContext to set
+	 */
+	public void setApplicationContext(ApplicationContext applicationContext) {
+		this.applicationContext = applicationContext;
+	}
+
+}