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