diff options
| author |   kaixiliu <liukaixi@chinamobile.com> | 2023-10-09 10:09:35 +0800 |
|---|---|---|
| committer | Kaixi LIU <liukaixi@chinamobile.com> | 2023-10-18 09:00:59 +0000 |
| commit | 0396c0a98cde457edd6eddebf1cc0bee2950a76d (patch) | |
| tree | f3b64112d48a2335479b7baeb7a90996614ae74b /intentanalysis/src/main/resources/mybatis | |
| parent | 45392ebae1ef9559951b9bf660e8aeb099bba19e (diff) | |
Add report export function
Issue-ID: USECASEUI-819
Change-Id: Ieb768aec1e12f63f33fa0e29cbb98399e92e5b01
Signed-off-by: kaixiliu <liukaixi@chinamobile.com>
Diffstat (limited to 'intentanalysis/src/main/resources/mybatis')
| -rw-r--r-- | intentanalysis/src/main/resources/mybatis/sql/IntentReportFulfillmentInfoMapper.xml | 10 | ||||
| -rw-r--r-- | intentanalysis/src/main/resources/mybatis/sql/IntentReportMapper.xml | 10 |
2 files changed, 20 insertions, 0 deletions
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 >= to_timestamp(#{startTime},'yyyy-MM-dd HH24:mi:ss') + and report_time < to_timestamp(#{endTime},'yyyy-MM-dd HH24:mi:ss') + and intent_reference = #{intentInstanceId} + </select> </mapper> |