From 0396c0a98cde457edd6eddebf1cc0bee2950a76d Mon Sep 17 00:00:00 2001
From: kaixiliu <liukaixi@chinamobile.com>
Date: Mon, 9 Oct 2023 10:09:35 +0800
Subject: Add report export function

Issue-ID: USECASEUI-819
Change-Id: Ieb768aec1e12f63f33fa0e29cbb98399e92e5b01
Signed-off-by: kaixiliu <liukaixi@chinamobile.com>
---
 .../mybatis/sql/IntentReportFulfillmentInfoMapper.xml          | 10 ++++++++++
 .../src/main/resources/mybatis/sql/IntentReportMapper.xml      | 10 ++++++++++
 2 files changed, 20 insertions(+)

(limited to 'intentanalysis/src/main/resources/mybatis')

diff --git a/intentanalysis/src/main/resources/mybatis/sql/IntentReportFulfillmentInfoMapper.xml b/intentanalysis/src/main/resources/mybatis/sql/IntentReportFulfillmentInfoMapper.xml
index bfe413e..c090d5a 100644
--- a/intentanalysis/src/main/resources/mybatis/sql/IntentReportFulfillmentInfoMapper.xml
+++ b/intentanalysis/src/main/resources/mybatis/sql/IntentReportFulfillmentInfoMapper.xml
@@ -8,4 +8,14 @@
         insert into intent_report_fulfillment_info(parent_id,fulfillment_info_id, fulfillment_info_status, not_fulfilled_state, not_fulfilled_reason,achieve_value)
         values (#{parentId},#{fulfillmentInfo.fulfillmentId}, #{fulfillmentInfo.fulfillmentStatus}, #{fulfillmentInfo.notFulfilledState}, #{fulfillmentInfo.notFulfilledReason},#{fulfillmentInfo.achieveValue})
     </insert>
+    <select id="getFulfillmentInfosByParentId"
+            resultType="org.onap.usecaseui.intentanalysis.bean.models.FulfillmentInfo">
+        select fulfillment_info_id fulfillmentId,
+               fulfillment_info_status fulfillmentStatus,
+               not_fulfilled_state notFulfilledState,
+               not_fulfilled_reason notFulfilledReason,
+               achieve_value achieveValue
+        from intent_report_fulfillment_info
+        where parent_id = #{parentId}
+    </select>
 </mapper>
diff --git a/intentanalysis/src/main/resources/mybatis/sql/IntentReportMapper.xml b/intentanalysis/src/main/resources/mybatis/sql/IntentReportMapper.xml
index 078ea9b..901055e 100644
--- a/intentanalysis/src/main/resources/mybatis/sql/IntentReportMapper.xml
+++ b/intentanalysis/src/main/resources/mybatis/sql/IntentReportMapper.xml
@@ -14,4 +14,14 @@
         from intent_report
         where intent_reference = #{intentReference}
     </select>
+
+    <select id="getIntentReportsByTime" resultType="org.onap.usecaseui.intentanalysis.bean.models.IntentReport">
+        select intent_report_id intentReportId,
+               intent_reference intentReference,
+               to_char(report_time,'yyyy-mm-dd HH24:mi:ss') reportTime
+        from intent_report
+        where report_time &gt;= to_timestamp(#{startTime},'yyyy-MM-dd HH24:mi:ss')
+          and report_time &lt; to_timestamp(#{endTime},'yyyy-MM-dd HH24:mi:ss')
+          and intent_reference = #{intentInstanceId}
+    </select>
 </mapper>
-- 
cgit