From 9bc1958825de5c9427659a8824a9e86864c2a457 Mon Sep 17 00:00:00 2001
From: “djh” <“3298565835@qq.com”>
Date: 星期四, 03 七月 2025 17:27:18 +0800
Subject: [PATCH] 修改
---
multi-system/src/main/resources/mapper/system/CompanyIndustryTemplateMapper.xml | 10 +++++++++-
1 files changed, 9 insertions(+), 1 deletions(-)
diff --git a/multi-system/src/main/resources/mapper/system/CompanyIndustryTemplateMapper.xml b/multi-system/src/main/resources/mapper/system/CompanyIndustryTemplateMapper.xml
index cf772ec..17d8961 100644
--- a/multi-system/src/main/resources/mapper/system/CompanyIndustryTemplateMapper.xml
+++ b/multi-system/src/main/resources/mapper/system/CompanyIndustryTemplateMapper.xml
@@ -90,6 +90,14 @@
and ci.type like concat('%',#{type},'%')
</if>
ORDER BY
- ci.create_time DESC
+ CAST(SUBSTRING_INDEX(ci.chapter, '.', 1) AS UNSIGNED) ASC,
+ CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(ci.chapter, '.', 2), '.', -1) AS UNSIGNED) ASC, -- 第二级
+ CAST(
+ CASE
+ WHEN LENGTH(ci.chapter) - LENGTH(REPLACE(ci.chapter, '.', '')) >= 2
+ THEN SUBSTRING_INDEX(ci.chapter, '.', -1)
+ ELSE '0'
+ END AS UNSIGNED
+ ) ASC
</select>
</mapper>
--
Gitblit v1.9.2