From 99132a43bf344f2aafdd9894b0762d2eedd9767b Mon Sep 17 00:00:00 2001
From: “djh” <“3298565835@qq.com”>
Date: 星期二, 01 七月 2025 17:15:25 +0800
Subject: [PATCH] 修改
---
multi-system/src/main/resources/mapper/system/QualityMapper.xml | 2 +-
multi-system/src/main/resources/mapper/system/QualityTargetMapper.xml | 2 +-
multi-system/src/main/resources/mapper/system/CatalogueMapper.xml | 12 ++++++++----
multi-system/src/main/resources/mapper/system/QualityDecomposeMapper.xml | 2 +-
4 files changed, 11 insertions(+), 7 deletions(-)
diff --git a/multi-system/src/main/resources/mapper/system/CatalogueMapper.xml b/multi-system/src/main/resources/mapper/system/CatalogueMapper.xml
index e03a1a3..170cccb 100644
--- a/multi-system/src/main/resources/mapper/system/CatalogueMapper.xml
+++ b/multi-system/src/main/resources/mapper/system/CatalogueMapper.xml
@@ -16,7 +16,7 @@
</insert>
<update id="updateCatalogueData">
- UPDATE `train_exam`.`catalogue_data`
+ UPDATE `catalogue_data`
SET
<if test="companyId!=null">
`company_id` = #{companyId},
@@ -43,7 +43,8 @@
`id` = #{id}
</update>
<update id="updateCatalogueDataFile">
- UPDATE `train_exam`.`catalogue_data_file`
+ UPDATE `catalogue_data_file`
+ set
<if test="catalogueId!=null">
`catalogue_id` = #{catalogueId},
</if>
@@ -63,7 +64,7 @@
`type` = #{type},
</if>
<if test="delFlag != null and delFlag != ''" >
- del_flag = #{item.delFlag},
+ del_flag = #{delFlag},
</if>
<if test="updateBy != null" >
update_by = #{updateBy},
@@ -123,15 +124,18 @@
SELECT
id,
`catalogue_data_id`,
+ company_id,
+ catalogue_id,
`name`,
`file_path`,
+ file_name,
`type`,
`create_by`,
`create_time`
FROM
catalogue_data_file
WHERE
- company_id = #{companyId} and catalogue_id = #{catalogueId}
+ company_id = #{companyId} and catalogue_id = #{catalogueId} and del_flag =1
</select>
<select id="selectByCompanyId" resultType="com.gkhy.exam.system.domain.CatalogueData">
SELECT
diff --git a/multi-system/src/main/resources/mapper/system/QualityDecomposeMapper.xml b/multi-system/src/main/resources/mapper/system/QualityDecomposeMapper.xml
index a788e6e..2f13d41 100644
--- a/multi-system/src/main/resources/mapper/system/QualityDecomposeMapper.xml
+++ b/multi-system/src/main/resources/mapper/system/QualityDecomposeMapper.xml
@@ -3,7 +3,7 @@
<mapper namespace="com.gkhy.exam.system.mapper.QualityDecomposeMapper">
<insert id="insertDecompose" useGeneratedKeys="true" keyProperty="id">
INSERT INTO
- `train_exam`.`quality_decompose`
+ `quality_decompose`
( `company_id`, `quality_id`, `number`, `serial`, `fiction_id`, `fiction_name`, `fiction_time`, `check_id`,`check_name`,
`check_time`, `ratify_id`, `ratify_name`, `ratify_time`, `create_by`, `create_time`)
VALUES
diff --git a/multi-system/src/main/resources/mapper/system/QualityMapper.xml b/multi-system/src/main/resources/mapper/system/QualityMapper.xml
index b4e7ff7..cb0db08 100644
--- a/multi-system/src/main/resources/mapper/system/QualityMapper.xml
+++ b/multi-system/src/main/resources/mapper/system/QualityMapper.xml
@@ -3,7 +3,7 @@
<mapper namespace="com.gkhy.exam.system.mapper.QualityMapper">
<insert id="insertQuality" useGeneratedKeys="true" keyProperty="id">
- INSERT INTO `train_exam`.`quality` (
+ INSERT INTO `quality` (
`company_id`,`company_name`,`year`,`num`,`type`, `depart_id`,`depart_name`,`method`,`compilation_id`, `compilation_name`,`compilation_time`,`quality_id`,`quality_name`,
`quality_time`,`lead_id`,`lead_name`,`lead_time`,`create_by`,`create_time`
)
diff --git a/multi-system/src/main/resources/mapper/system/QualityTargetMapper.xml b/multi-system/src/main/resources/mapper/system/QualityTargetMapper.xml
index b6719b4..9eb68cf 100644
--- a/multi-system/src/main/resources/mapper/system/QualityTargetMapper.xml
+++ b/multi-system/src/main/resources/mapper/system/QualityTargetMapper.xml
@@ -3,7 +3,7 @@
<mapper namespace="com.gkhy.exam.system.mapper.QualityTargetMapper">
<insert id="insertQualityTargets">
- INSERT INTO `train_exam`.`quality_target` (
+ INSERT INTO `quality_target` (
`company_id`,`quality_id`,`message`,`num`,`method`,`calculate`,`data_source`,`depart_name`,
`frequency`,`duty_name`,`remark`,`create_by`,`create_time`
)
--
Gitblit v1.9.2