From 93c9717bb5bba8230b7d168abf446159f20e432c Mon Sep 17 00:00:00 2001
From: 陈昶聿 <chychen@nbjetron.com>
Date: 星期四, 25 六月 2026 15:13:37 +0800
Subject: [PATCH] 【省立同德】新增或修改指标选项库 增加排序功能
---
smartor/src/main/java/com/smartor/domain/IvrLibaTargetoption.java | 7 +++++++
smartor/src/main/resources/mapper/smartor/IvrLibaTargetoptionMapper.xml | 9 +++++++--
smartor/src/main/java/com/smartor/service/impl/IvrLibaTargetServiceImpl.java | 3 ++-
3 files changed, 16 insertions(+), 3 deletions(-)
diff --git a/smartor/src/main/java/com/smartor/domain/IvrLibaTargetoption.java b/smartor/src/main/java/com/smartor/domain/IvrLibaTargetoption.java
index d1099f7..699cab5 100644
--- a/smartor/src/main/java/com/smartor/domain/IvrLibaTargetoption.java
+++ b/smartor/src/main/java/com/smartor/domain/IvrLibaTargetoption.java
@@ -201,4 +201,11 @@
@ApiModelProperty(value = "鏄惁缁撴潫 0锛氫笉缁撴潫 1锛氱粨鏉�")
private Integer isEnd;
+ /**
+ * 鎺掑簭ID
+ */
+ @ApiModelProperty(value = "鎺掑簭ID")
+ @Excel(name = "鎺掑簭ID")
+ private String sortid;
+
}
diff --git a/smartor/src/main/java/com/smartor/service/impl/IvrLibaTargetServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/IvrLibaTargetServiceImpl.java
index dcd02f2..5973bd5 100644
--- a/smartor/src/main/java/com/smartor/service/impl/IvrLibaTargetServiceImpl.java
+++ b/smartor/src/main/java/com/smartor/service/impl/IvrLibaTargetServiceImpl.java
@@ -202,7 +202,8 @@
}
//鎸囨爣搴撴帓搴�
-// ivrLibaTargetoption.setGuid(ivrLibaTargetVO.getGuid());
+ ivrLibaTargetoption.setSortid(ivrLibaTargetoption.getGuid());
+ ivrLibaTargetoption.setGuid(ivrLibaTargetVO.getGuid());
ivrLibaTargetoption.setOrgid(ivrLibaTargetVO.getOrgid());
if (ivrLibaTargetoption.getIsoperation() != null && ivrLibaTargetoption.getIsoperation() == 1) {
//鏂板
diff --git a/smartor/src/main/resources/mapper/smartor/IvrLibaTargetoptionMapper.xml b/smartor/src/main/resources/mapper/smartor/IvrLibaTargetoptionMapper.xml
index 21f2362..5d92cd8 100644
--- a/smartor/src/main/resources/mapper/smartor/IvrLibaTargetoptionMapper.xml
+++ b/smartor/src/main/resources/mapper/smartor/IvrLibaTargetoptionMapper.xml
@@ -37,6 +37,7 @@
<result property="picturePath" column="picture_path"/>
<result property="prompt" column="prompt"/>
<result property="isEnd" column="is_end"/>
+ <result property="sortid" column="sortid"/>
</resultMap>
<sql id="selectIvrLibaTargetoptionVo">
@@ -54,7 +55,7 @@
nodynamiccruxs,
orderno,
dynamiccruxs,
- optiondesc, language, version, groupid, isabnormal, warnup, warndown, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, pid, guid
+ optiondesc, language, version, groupid, isabnormal, warnup, warndown, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, pid, guid, sortid
from ivr_liba_targetoption
</sql>
@@ -90,7 +91,8 @@
<if test="appenddesc != null">and appenddesc = #{appenddesc}</if>
<if test="picturePath != null">and picture_path = #{picturePath}</if>
<if test="isEnd != null ">and is_end = #{isEnd}</if>
- order by guid asc
+ <if test="sortid != null and sortid != ''">and sortid = #{sortid}</if>
+ order by guid asc, sortid asc
</select>
<select id="selectIvrLibaTargetoptionByTargetoptionid" parameterType="Long" resultMap="IvrLibaTargetoptionResult">
@@ -132,6 +134,7 @@
<if test="appenddesc != null">appenddesc,</if>
<if test="picturePath != null">picture_path,</if>
<if test="isEnd != null ">is_end,</if>
+ <if test="sortid != null and sortid != ''">sortid,</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="targetid != null">#{targetid},</if>
@@ -164,6 +167,7 @@
<if test="appenddesc != null">#{appenddesc},</if>
<if test="picturePath != null">#{picturePath},</if>
<if test="isEnd != null ">#{isEnd},</if>
+ <if test="sortid != null and sortid != ''">#{sortid},</if>
</trim>
</insert>
@@ -200,6 +204,7 @@
<if test="appenddesc != null">appenddesc = #{appenddesc},</if>
<if test="picturePath != null">picture_path = #{picturePath},</if>
<if test="isEnd != null ">is_end = #{isEnd},</if>
+ <if test="sortid != null and sortid != ''">sortid = #{sortid},</if>
</trim>
where targetoptionid = #{targetoptionid}
</update>
--
Gitblit v1.9.3