add exportContent

Issue-ID: USECASEUI-837
Signed-off-by: zhen1234 <liz779@chinatelecom.cn>
Change-Id: I8d374024e5592e039182c82c573480c6d264d625

3 files changed, 26 insertions, 0 deletions

diff --git a/server/src/main/java/org/onap/usecaseui/server/controller/IntentController.java b/server/src/main/java/org/onap/usecaseui/server/controller/IntentController.java
index df6530ce..6c64d6c7 100644
--- a/server/src/main/java/org/onap/usecaseui/server/controller/IntentController.java
+++ b/server/src/main/java/org/onap/usecaseui/server/controller/IntentController.java
@@ -24,6 +24,7 @@ import java.util.regex.Pattern;
 import jakarta.annotation.Resource;
 
 import com.alibaba.fastjson.JSONArray;
+import jakarta.servlet.http.HttpServletResponse;
 import org.apache.commons.collections.MapUtils;
 import org.onap.usecaseui.server.bean.HttpResponseResult;
 import org.onap.usecaseui.server.bean.intent.CCVPNInstance;
@@ -591,4 +592,8 @@ public class IntentController {
         return intentInstanceService.getIntentInstanceList(currentPage, pageSize);
     }
 
+    @PostMapping("/exportIntentContent")
+    public void exportIntentContent(HttpServletResponse response) {
+        intentInstanceService.exportIntentContent(response);
+    }
 }
diff --git a/server/src/main/java/org/onap/usecaseui/server/service/intent/IntentInstanceService.java b/server/src/main/java/org/onap/usecaseui/server/service/intent/IntentInstanceService.java
index e25fa761..b0776844 100644
--- a/server/src/main/java/org/onap/usecaseui/server/service/intent/IntentInstanceService.java
+++ b/server/src/main/java/org/onap/usecaseui/server/service/intent/IntentInstanceService.java
@@ -17,6 +17,7 @@ package org.onap.usecaseui.server.service.intent;
 
 import com.alibaba.fastjson.JSONArray;
 import com.alibaba.fastjson.JSONObject;
+import jakarta.servlet.http.HttpServletResponse;
 import org.onap.usecaseui.server.bean.csmf.SlicingOrder;
 import org.onap.usecaseui.server.bean.intent.CCVPNInstance;
 import org.onap.usecaseui.server.bean.intent.IntentInstance;
@@ -68,4 +69,6 @@ public interface IntentInstanceService {
     int updateCCVPNInstance(CCVPNInstance instance);
 
     void saveSlicingServiceToAAI(String serviceId,String operationId, SlicingOrder slicingOrder) throws IOException;
+
+    void exportIntentContent(HttpServletResponse response);
 }
diff --git a/server/src/main/java/org/onap/usecaseui/server/service/intent/impl/IntentInstanceServiceImpl.java b/server/src/main/java/org/onap/usecaseui/server/service/intent/impl/IntentInstanceServiceImpl.java
index bebc8121..bc0d05a9 100644
--- a/server/src/main/java/org/onap/usecaseui/server/service/intent/impl/IntentInstanceServiceImpl.java
+++ b/server/src/main/java/org/onap/usecaseui/server/service/intent/impl/IntentInstanceServiceImpl.java
@@ -18,6 +18,7 @@ package org.onap.usecaseui.server.service.intent.impl;
 import com.alibaba.fastjson.JSON;
 import com.alibaba.fastjson.JSONArray;
 import com.alibaba.fastjson.JSONObject;
+import jakarta.servlet.http.HttpServletResponse;
 import org.hibernate.query.Query;
 import org.hibernate.Session;
 import org.hibernate.SessionFactory;
@@ -35,6 +36,7 @@ import org.onap.usecaseui.server.service.intent.IntentApiService;
 import org.onap.usecaseui.server.service.intent.IntentInstanceService;
 import org.onap.usecaseui.server.service.lcm.domain.so.SOService;
 import org.onap.usecaseui.server.service.nsmf.ResourceMgtService;
+import org.onap.usecaseui.server.util.ExportUtil;
 import org.onap.usecaseui.server.util.Page;
 import org.onap.usecaseui.server.util.RestfulServices;
 import org.onap.usecaseui.server.util.UuiCommonUtil;
@@ -1026,4 +1028,20 @@ public class IntentInstanceServiceImpl implements IntentInstanceService {
         intentApiService.saveServiceInstance(globalCustomerId,serviceType,serviceId,requestBody).execute();
     }
 
+    @Override
+    public void exportIntentContent(HttpServletResponse response) {
+        Session session = getSession();
+        try{
+            String hql = "select i.intentContent from IntentInstance i order by id";
+            Query<String> query = session.createQuery(hql, String.class);
+            query.setMaxResults(1000);
+            List<String> intentContents = query.getResultList();
+            ExportUtil.exportExcel(response,"intentContent",intentContents);
+        } catch (Exception e) {
+            logger.error("An exception occurred with exportIntentContent. Details:" + e.getMessage());
+        } finally {
+            session.close();
+        }
+    }
+
 }