diff options
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(); + } + } + } |