From b1a41509684c3823d41ec1c184f6a5f7ba49dfb7 Mon Sep 17 00:00:00 2001
From: fuliqi <fuliqi@qq.com>
Date: 星期日, 07 四月 2024 18:01:10 +0800
Subject: [PATCH] 考核规则
---
ycl-server/src/main/java/com/ycl/system/controller/SysDeptController.java | 6
ycl-pojo/src/main/java/com/ycl/platform/domain/query/CheckRuleQuery.java | 39 +++
ycl-server/src/main/resources/mapper/zgyw/CheckTemplateMapper.xml | 3
ycl-server/src/main/java/com/ycl/platform/mapper/CheckRuleMapper.java | 8
ycl-server/src/main/resources/application-prod.yml | 2
ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckRule.java | 25 -
ycl-server/src/main/java/com/ycl/platform/controller/CheckRuleController.java | 14
ycl-server/src/main/java/com/ycl/system/service/ISysDeptService.java | 6
ycl-pojo/src/main/java/com/ycl/system/entity/SysDept.java | 41 ++-
ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CalculateRecord.java | 79 -------
ycl-server/src/main/resources/mapper/system/SysDeptMapper.xml | 6
ycl-pojo/src/main/java/com/ycl/platform/domain/query/CheckTemplateQuery.java | 79 +++++++
ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckRuleVO.java | 55 +++++
ycl-server/src/main/resources/application-dev.yml | 2
ycl-server/src/main/java/com/ycl/platform/service/ICheckTemplateService.java | 15 +
ycl-server/src/main/java/com/ycl/system/service/impl/SysDeptServiceImpl.java | 19 +
ycl-server/src/main/java/com/ycl/platform/service/impl/CheckRuleServiceImpl.java | 10
/dev/null | 0
ycl-server/src/main/resources/mapper/zgyw/CalculateRecordMapper.xml | 12
ycl-server/src/main/java/com/ycl/platform/mapper/CheckTemplateMapper.java | 5
ycl-server/src/main/java/com/ycl/platform/service/ICheckRuleService.java | 8
ycl-server/src/main/java/com/ycl/platform/controller/CheckTemplateController.java | 21 +
document/需求确认书.docx | 0
ycl-server/src/main/java/com/ycl/platform/service/impl/CheckTemplateServiceImpl.java | 98 +++++++--
ycl-server/src/main/resources/mapper/zgyw/CheckRuleMapper.xml | 40 ++--
25 files changed, 394 insertions(+), 199 deletions(-)
diff --git "a/document/\350\207\252\350\264\241\351\241\271\347\233\256\344\273\273\345\212\241\345\210\206\351\205\215.xlsx" "b/document/\350\207\252\350\264\241\351\241\271\347\233\256\344\273\273\345\212\241\345\210\206\351\205\215.xlsx"
deleted file mode 100644
index e69de29..0000000
--- "a/document/\350\207\252\350\264\241\351\241\271\347\233\256\344\273\273\345\212\241\345\210\206\351\205\215.xlsx"
+++ /dev/null
diff --git "a/document/\351\234\200\346\261\202\347\241\256\350\256\244\344\271\2463.27.docx" "b/document/\351\234\200\346\261\202\347\241\256\350\256\244\344\271\246.docx"
similarity index 70%
rename from "document/\351\234\200\346\261\202\347\241\256\350\256\244\344\271\2463.27.docx"
rename to "document/\351\234\200\346\261\202\347\241\256\350\256\244\344\271\246.docx"
index 2b4b5aa..643e3e7 100644
--- "a/document/\351\234\200\346\261\202\347\241\256\350\256\244\344\271\2463.27.docx"
+++ "b/document/\351\234\200\346\261\202\347\241\256\350\256\244\344\271\246.docx"
Binary files differ
diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CalculateRecord.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CalculateRecord.java
index 0431c81..d5af7c1 100644
--- a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CalculateRecord.java
+++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CalculateRecord.java
@@ -3,6 +3,7 @@
import annotation.Excel;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.ycl.system.entity.BaseEntity;
+import lombok.Data;
import org.apache.commons.lang.builder.ToStringBuilder;
import org.apache.commons.lang.builder.ToStringStyle;
@@ -15,6 +16,7 @@
* @author ruoyi
* @date 2024-04-03
*/
+@Data
public class CalculateRecord extends BaseEntity
{
private static final long serialVersionUID = 1L;
@@ -37,7 +39,7 @@
/** 鎬绘湇鍔¤垂 */
@Excel(name = "鎬绘湇鍔¤垂")
- private BigDecimal totalMount;
+ private BigDecimal totalAmount;
/** 鎵ｅ噺鏈嶅姟璐� */
@Excel(name = "鎵ｅ噺鏈嶅姟璐�")
@@ -47,80 +49,5 @@
@Excel(name = "鑰冩牳鍒嗘暟")
private BigDecimal score;
- public void setId(Long id)
- {
- this.id = id;
- }
- public Long getId()
- {
- return id;
- }
- public void setDate(Date date)
- {
- this.date = date;
- }
-
- public Date getDate()
- {
- return date;
- }
- public void setRuleId(Long ruleId)
- {
- this.ruleId = ruleId;
- }
-
- public Long getRuleId()
- {
- return ruleId;
- }
- public void setUnitId(Long unitId)
- {
- this.unitId = unitId;
- }
-
- public Long getUnitId()
- {
- return unitId;
- }
- public void setTotalMount(BigDecimal totalMount)
- {
- this.totalMount = totalMount;
- }
-
- public BigDecimal getTotalMount()
- {
- return totalMount;
- }
- public void setDeductAmount(BigDecimal deductAmount)
- {
- this.deductAmount = deductAmount;
- }
-
- public BigDecimal getDeductAmount()
- {
- return deductAmount;
- }
- public void setScore(BigDecimal score)
- {
- this.score = score;
- }
-
- public BigDecimal getScore()
- {
- return score;
- }
-
- @Override
- public String toString() {
- return new ToStringBuilder(this, ToStringStyle.MULTI_LINE_STYLE)
- .append("id", getId())
- .append("date", getDate())
- .append("ruleId", getRuleId())
- .append("unitId", getUnitId())
- .append("totalMount", getTotalMount())
- .append("deductAmount", getDeductAmount())
- .append("score", getScore())
- .toString();
- }
}
diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckRule.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckRule.java
index 4c7442f..f2bb4b8 100644
--- a/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckRule.java
+++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/entity/CheckRule.java
@@ -24,7 +24,7 @@
/** 瑙勫垯缁嗗垯 */
@Excel(name = "瑙勫垯缁嗗垯")
- private String ruleDetail;
+ private String ruleIndex;
/** 瑙勫垯绫诲瀷 */
@Excel(name = "瑙勫垯绫诲瀷")
@@ -37,10 +37,6 @@
/** 瑙勫垯鎻忚堪 */
@Excel(name = "瑙勫垯鎻忚堪")
private String ruleDescription;
-
- /** 瀹℃牳鐘舵�� */
- @Excel(name = "瀹℃牳鐘舵��")
- private Long auditState;
/** 鍚敤鐘舵�� */
@Excel(name = "鍚敤鐘舵��")
@@ -67,14 +63,14 @@
{
return ruleName;
}
- public void setRuleDetail(String ruleDetail)
+ public void setRuleIndex(String ruleIndex)
{
- this.ruleDetail = ruleDetail;
+ this.ruleIndex = ruleIndex;
}
- public String getRuleDetail()
+ public String getRuleIndex()
{
- return ruleDetail;
+ return ruleIndex;
}
public void setRuleCategory(Long ruleCategory)
{
@@ -103,15 +99,7 @@
{
return ruleDescription;
}
- public void setAuditState(Long auditState)
- {
- this.auditState = auditState;
- }
- public Long getAuditState()
- {
- return auditState;
- }
public void setState(Long state)
{
this.state = state;
@@ -136,11 +124,10 @@
return new ToStringBuilder(this, ToStringStyle.MULTI_LINE_STYLE)
.append("id", getId())
.append("ruleName", getRuleName())
- .append("ruleDetail", getRuleDetail())
+ .append("ruleIndex", getRuleIndex())
.append("ruleCategory", getRuleCategory())
.append("examineCategory", getExamineCategory())
.append("ruleDescription", getRuleDescription())
- .append("auditState", getAuditState())
.append("state", getState())
.append("createTime", getCreateTime())
.append("updateTime", getUpdateTime())
diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/query/CheckRuleQuery.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/query/CheckRuleQuery.java
new file mode 100644
index 0000000..24fd731
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/query/CheckRuleQuery.java
@@ -0,0 +1,39 @@
+package com.ycl.platform.domain.query;
+
+import annotation.Excel;
+import com.ycl.platform.base.AbsQuery;
+import io.swagger.annotations.ApiModel;
+import lombok.Data;
+import lombok.experimental.Accessors;
+
+/**
+ * 涓嬪彂宸ュ崟鏌ヨ
+ *
+ */
+@Data
+@Accessors(chain = true)
+@ApiModel(value = "鑰冩牳瑙勫垯绠＄悊", description = "鑰冩牳瑙勫垯绠＄悊")
+public class CheckRuleQuery extends AbsQuery {
+ /**
+ * 妯℃澘id
+ */
+ private Integer templateId;
+ /**
+ * 瀹℃牳鐘舵��
+ */
+ private Integer auditState;
+ /**
+ * 瑙勫垯鍚嶇О
+ */
+ private String ruleName;
+ /**
+ * 瑙勫垯绫诲瀷
+ */
+ private Integer ruleCategory;
+ /**
+ * 鑰冩牳绫诲瀷
+ */
+ private Integer examineCategory;
+
+
+}
diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/query/CheckTemplateQuery.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/query/CheckTemplateQuery.java
new file mode 100644
index 0000000..388afbd
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/query/CheckTemplateQuery.java
@@ -0,0 +1,79 @@
+package com.ycl.platform.domain.query;
+
+import annotation.Excel;
+import com.baomidou.mybatisplus.annotation.FieldFill;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import com.ycl.platform.base.AbsQuery;
+import io.swagger.annotations.ApiModel;
+import lombok.Data;
+import lombok.experimental.Accessors;
+
+import java.util.Date;
+import java.util.List;
+
+@Data
+@Accessors(chain = true)
+@ApiModel(value = "瑙勫垯妯℃澘鏌ヨ", description = "瑙勫垯妯℃澘鏌ヨ")
+public class CheckTemplateQuery extends AbsQuery {
+ /** */
+ private Long id;
+
+ /** 妯℃澘鍚嶇О */
+ @Excel(name = "妯℃澘鍚嶇О")
+ private String templateName;
+
+ /** 璋冩暣绯绘暟 */
+ @Excel(name = "璋冩暣绯绘暟")
+ private Long adjustCoefficient;
+
+ /** 璋冩暣鏂瑰紡锛氫箻闄� */
+ @Excel(name = "璋冩暣鏂瑰紡锛氫箻闄�")
+ private String adjustWay;
+
+ /** 鑰冩牳绫诲瀷 */
+ @Excel(name = "鑰冩牳绫诲瀷")
+ private Long examineCategory;
+
+ /** 鍚敤/鍋滅敤 */
+ @Excel(name = "鍚敤/鍋滅敤")
+ private String status;
+
+ /** 鍖哄幙 */
+ @Excel(name = "鍖哄幙")
+ private List deptId;
+
+ /** 鍒涘缓浜篿d */
+ private Long createUser;
+
+ /** 鍒涘缓浜哄鍚� */
+ @Excel(name = "鍒涘缓浜哄鍚�")
+ private String createUserName;
+
+ /** */
+ private Long updateUser;
+
+ /** */
+ @Excel(name = "")
+ private String updateUserName;
+
+ /** 閫昏緫鍒犻櫎 */
+ private String deleted;
+
+
+ /** 鍒涘缓鑰� */
+ private String createBy;
+
+ /** 鍒涘缓鏃堕棿 */
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ private Date createTime;
+
+ /** 鏇存柊鑰� */
+ @TableField(fill = FieldFill.UPDATE)
+ private String updateBy;
+
+ /** 鏇存柊鏃堕棿 */
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+ @TableField(fill = FieldFill.UPDATE)
+ private Date updateTime;
+}
diff --git a/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckRuleVO.java b/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckRuleVO.java
new file mode 100644
index 0000000..b4ca16c
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/platform/domain/vo/CheckRuleVO.java
@@ -0,0 +1,55 @@
+package com.ycl.platform.domain.vo;
+
+import annotation.Excel;
+import com.ycl.platform.base.AbsVo;
+import lombok.Data;
+import lombok.experimental.Accessors;
+
+import java.math.BigDecimal;
+
+/**
+ * 鑰冩牳瑙勫垯灞曠ず
+ *
+ */
+@Data
+@Accessors(chain = true)
+public class CheckRuleVO extends AbsVo {
+ /**
+ * 妯℃澘id
+ */
+ private Integer templateId;
+
+ /** 妯℃澘鍚� */
+ private String templateName;
+ /**
+ * 瀹℃牳鐘舵��
+ */
+ private Integer auditState;
+ /**
+ * 瑙勫垯鍚嶇О
+ */
+ private String ruleName;
+ /**
+ * 瑙勫垯绫诲瀷
+ */
+ private String ruleCategory;
+
+ /** 瑙勫垯缁嗗垯 */
+ private String ruleIndex;
+
+ /** 鑰冩牳绫诲瀷 */
+ private Long examineCategory;
+
+ /** 瑙勫垯鎻忚堪 */
+ private String ruleDescription;
+
+ /** 瑙勫垯鏉冮噸 */
+ private BigDecimal weight;
+
+ /** 鍚敤鐘舵�� */
+ private Long state;
+
+ /** 閫昏緫鍒犻櫎 */
+ private String deleted;
+
+}
diff --git a/ycl-pojo/src/main/java/com/ycl/system/entity/SysDept.java b/ycl-pojo/src/main/java/com/ycl/system/entity/SysDept.java
index 8f75b52..ea523b4 100644
--- a/ycl-pojo/src/main/java/com/ycl/system/entity/SysDept.java
+++ b/ycl-pojo/src/main/java/com/ycl/system/entity/SysDept.java
@@ -31,6 +31,8 @@
/** 閮ㄩ棬鍚嶇О */
private String deptName;
+ /** 鍖哄煙鍚嶇О */
+ private String area;
/** 鏄剧ず椤哄簭 */
private Integer orderNum;
@@ -54,6 +56,14 @@
/** 瀛愰儴闂� */
private List<SysDept> children = new ArrayList<SysDept>();
+
+ public String getArea() {
+ return area;
+ }
+
+ public void setArea(String area) {
+ this.area = area;
+ }
public Long getDeptId()
{
@@ -183,21 +193,20 @@
@Override
public String toString() {
- return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
- .append("deptId", getDeptId())
- .append("parentId", getParentId())
- .append("ancestors", getAncestors())
- .append("deptName", getDeptName())
- .append("orderNum", getOrderNum())
- .append("leader", getLeader())
- .append("phone", getPhone())
- .append("email", getEmail())
- .append("status", getStatus())
- .append("delFlag", getDelFlag())
- .append("createBy", getCreateBy())
- .append("createTime", getCreateTime())
- .append("updateBy", getUpdateBy())
- .append("updateTime", getUpdateTime())
- .toString();
+ return "SysDept{" +
+ "deptId=" + deptId +
+ ", parentId=" + parentId +
+ ", ancestors='" + ancestors + '\'' +
+ ", deptName='" + deptName + '\'' +
+ ", area='" + area + '\'' +
+ ", orderNum=" + orderNum +
+ ", leader='" + leader + '\'' +
+ ", phone='" + phone + '\'' +
+ ", email='" + email + '\'' +
+ ", status='" + status + '\'' +
+ ", delFlag='" + delFlag + '\'' +
+ ", parentName='" + parentName + '\'' +
+ ", children=" + children +
+ '}';
}
}
diff --git a/ycl-server/src/main/java/com/ycl/platform/controller/CheckRuleController.java b/ycl-server/src/main/java/com/ycl/platform/controller/CheckRuleController.java
index bac5c34..d90e241 100644
--- a/ycl-server/src/main/java/com/ycl/platform/controller/CheckRuleController.java
+++ b/ycl-server/src/main/java/com/ycl/platform/controller/CheckRuleController.java
@@ -2,6 +2,8 @@
import annotation.Log;
import com.ycl.platform.domain.entity.CheckRule;
+import com.ycl.platform.domain.query.CheckRuleQuery;
+import com.ycl.platform.domain.vo.CheckRuleVO;
import com.ycl.platform.service.ICheckRuleService;
import com.ycl.system.AjaxResult;
import com.ycl.system.controller.BaseController;
@@ -33,11 +35,11 @@
* 鏌ヨ鑰冩牳瑙勫垯鍒楄〃
*/
@PreAuthorize("@ss.hasPermi('system:rule:list')")
- @GetMapping("/list")
- public TableDataInfo list(CheckRule checkRule)
+ @PostMapping("/list")
+ public TableDataInfo list(@RequestBody CheckRuleQuery checkRuleQuery)
{
startPage();
- List<CheckRule> list = checkRuleService.selectCheckRuleList(checkRule);
+ List<CheckRuleVO> list = checkRuleService.selectCheckRuleList(checkRuleQuery);
return getDataTable(list);
}
@@ -47,10 +49,10 @@
@PreAuthorize("@ss.hasPermi('system:rule:export')")
@Log(title = "鑰冩牳瑙勫垯", businessType = BusinessType.EXPORT)
@PostMapping("/export")
- public void export(HttpServletResponse response, CheckRule checkRule)
+ public void export(HttpServletResponse response, CheckRuleQuery checkRuleQuery)
{
- List<CheckRule> list = checkRuleService.selectCheckRuleList(checkRule);
- ExcelUtil<CheckRule> util = new ExcelUtil<CheckRule>(CheckRule.class);
+ List<CheckRuleVO> list = checkRuleService.selectCheckRuleList(checkRuleQuery);
+ ExcelUtil<CheckRuleVO> util = new ExcelUtil<CheckRuleVO>(CheckRuleVO.class);
util.exportExcel(response, list, "鑰冩牳瑙勫垯鏁版嵁");
}
diff --git a/ycl-server/src/main/java/com/ycl/platform/controller/CheckTemplateController.java b/ycl-server/src/main/java/com/ycl/platform/controller/CheckTemplateController.java
index 2ec9af4..5fcdb7e 100644
--- a/ycl-server/src/main/java/com/ycl/platform/controller/CheckTemplateController.java
+++ b/ycl-server/src/main/java/com/ycl/platform/controller/CheckTemplateController.java
@@ -2,12 +2,15 @@
import annotation.Log;
import com.ycl.platform.domain.entity.CheckTemplate;
+import com.ycl.platform.domain.query.CheckTemplateQuery;
import com.ycl.platform.service.ICheckTemplateService;
import com.ycl.system.AjaxResult;
+import com.ycl.system.Result;
import com.ycl.system.controller.BaseController;
import com.ycl.system.page.TableDataInfo;
import com.ycl.utils.poi.ExcelUtil;
import enumeration.BusinessType;
+import io.swagger.annotations.ApiOperation;
import jakarta.servlet.http.HttpServletResponse;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
@@ -33,10 +36,10 @@
*/
@PreAuthorize("@ss.hasPermi('system:template:list')")
@GetMapping("/list")
- public TableDataInfo list(CheckTemplate checkTemplate)
+ public TableDataInfo list(CheckTemplateQuery checkTemplateDTO)
{
startPage();
- List<CheckTemplate> list = checkTemplateService.selectCheckTemplateList(checkTemplate);
+ List<CheckTemplate> list = checkTemplateService.selectCheckTemplateList(checkTemplateDTO);
return getDataTable(list);
}
@@ -46,9 +49,9 @@
@PreAuthorize("@ss.hasPermi('system:template:export')")
@Log(title = "鑰冩牳妯℃澘", businessType = BusinessType.EXPORT)
@PostMapping("/export")
- public void export(HttpServletResponse response, CheckTemplate checkTemplate)
+ public void export(HttpServletResponse response, CheckTemplateQuery checkTemplateDTO)
{
- List<CheckTemplate> list = checkTemplateService.selectCheckTemplateList(checkTemplate);
+ List<CheckTemplate> list = checkTemplateService.selectCheckTemplateList(checkTemplateDTO);
ExcelUtil<CheckTemplate> util = new ExcelUtil<CheckTemplate>(CheckTemplate.class);
util.exportExcel(response, list, "鑰冩牳妯℃澘鏁版嵁");
}
@@ -69,9 +72,9 @@
@PreAuthorize("@ss.hasPermi('system:template:add')")
@Log(title = "鑰冩牳妯℃澘", businessType = BusinessType.INSERT)
@PostMapping
- public AjaxResult add(@RequestBody CheckTemplate checkTemplate)
+ public AjaxResult add(@RequestBody CheckTemplateQuery checkTemplateDTO)
{
- return toAjax(checkTemplateService.insertCheckTemplate(checkTemplate));
+ return toAjax(checkTemplateService.insertCheckTemplate(checkTemplateDTO));
}
/**
@@ -95,4 +98,10 @@
{
return toAjax(checkTemplateService.deleteCheckTemplateByIds(ids));
}
+
+ @GetMapping("/pullList")
+ @ApiOperation(value = "鍒楄〃", notes = "鍒楄〃")
+ public Result pullList() {
+ return checkTemplateService.pullList();
+ }
}
diff --git a/ycl-server/src/main/java/com/ycl/platform/mapper/CheckRuleMapper.java b/ycl-server/src/main/java/com/ycl/platform/mapper/CheckRuleMapper.java
index f3b4016..fdf0420 100644
--- a/ycl-server/src/main/java/com/ycl/platform/mapper/CheckRuleMapper.java
+++ b/ycl-server/src/main/java/com/ycl/platform/mapper/CheckRuleMapper.java
@@ -1,6 +1,8 @@
package com.ycl.platform.mapper;
import com.ycl.platform.domain.entity.CheckRule;
+import com.ycl.platform.domain.query.CheckRuleQuery;
+import com.ycl.platform.domain.vo.CheckRuleVO;
import java.util.List;
@@ -18,15 +20,15 @@
* @param id 鑰冩牳瑙勫垯涓婚敭
* @return 鑰冩牳瑙勫垯
*/
- public CheckRule selectCheckRuleById(Long id);
+ public CheckRuleVO selectCheckRuleById(Long id);
/**
* 鏌ヨ鑰冩牳瑙勫垯鍒楄〃
*
- * @param checkRule 鑰冩牳瑙勫垯
+ * @param checkRuleQuery 鑰冩牳瑙勫垯
* @return 鑰冩牳瑙勫垯闆嗗悎
*/
- public List<CheckRule> selectCheckRuleList(CheckRule checkRule);
+ public List<CheckRuleVO> selectCheckRuleList(CheckRuleQuery checkRuleQuery);
/**
* 鏂板鑰冩牳瑙勫垯
diff --git a/ycl-server/src/main/java/com/ycl/platform/mapper/CheckTemplateMapper.java b/ycl-server/src/main/java/com/ycl/platform/mapper/CheckTemplateMapper.java
index 8cbfb63..02479a1 100644
--- a/ycl-server/src/main/java/com/ycl/platform/mapper/CheckTemplateMapper.java
+++ b/ycl-server/src/main/java/com/ycl/platform/mapper/CheckTemplateMapper.java
@@ -1,6 +1,7 @@
package com.ycl.platform.mapper;
import com.ycl.platform.domain.entity.CheckTemplate;
+import com.ycl.platform.domain.query.CheckTemplateQuery;
import java.util.List;
@@ -23,10 +24,10 @@
/**
* 鏌ヨ鑰冩牳妯℃澘鍒楄〃
*
- * @param checkTemplate 鑰冩牳妯℃澘
+ * @param checkTemplateDTO 鑰冩牳妯℃澘
* @return 鑰冩牳妯℃澘闆嗗悎
*/
- public List<CheckTemplate> selectCheckTemplateList(CheckTemplate checkTemplate);
+ public List<CheckTemplate> selectCheckTemplateList(CheckTemplateQuery checkTemplateDTO);
/**
* 鏂板鑰冩牳妯℃澘
diff --git a/ycl-server/src/main/java/com/ycl/platform/service/ICheckRuleService.java b/ycl-server/src/main/java/com/ycl/platform/service/ICheckRuleService.java
index 1d599fd..6235915 100644
--- a/ycl-server/src/main/java/com/ycl/platform/service/ICheckRuleService.java
+++ b/ycl-server/src/main/java/com/ycl/platform/service/ICheckRuleService.java
@@ -1,6 +1,8 @@
package com.ycl.platform.service;
import com.ycl.platform.domain.entity.CheckRule;
+import com.ycl.platform.domain.query.CheckRuleQuery;
+import com.ycl.platform.domain.vo.CheckRuleVO;
import java.util.List;
@@ -18,15 +20,15 @@
* @param id 鑰冩牳瑙勫垯涓婚敭
* @return 鑰冩牳瑙勫垯
*/
- public CheckRule selectCheckRuleById(Long id);
+ public CheckRuleVO selectCheckRuleById(Long id);
/**
* 鏌ヨ鑰冩牳瑙勫垯鍒楄〃
*
- * @param checkRule 鑰冩牳瑙勫垯
+ * @param checkRuleQuery 鑰冩牳瑙勫垯
* @return 鑰冩牳瑙勫垯闆嗗悎
*/
- public List<CheckRule> selectCheckRuleList(CheckRule checkRule);
+ public List<CheckRuleVO> selectCheckRuleList(CheckRuleQuery checkRuleQuery);
/**
* 鏂板鑰冩牳瑙勫垯
diff --git a/ycl-server/src/main/java/com/ycl/platform/service/ICheckTemplateService.java b/ycl-server/src/main/java/com/ycl/platform/service/ICheckTemplateService.java
index 6ce7191..44eb4ea 100644
--- a/ycl-server/src/main/java/com/ycl/platform/service/ICheckTemplateService.java
+++ b/ycl-server/src/main/java/com/ycl/platform/service/ICheckTemplateService.java
@@ -1,6 +1,8 @@
package com.ycl.platform.service;
import com.ycl.platform.domain.entity.CheckTemplate;
+import com.ycl.platform.domain.query.CheckTemplateQuery;
+import com.ycl.system.Result;
import java.util.List;
@@ -18,23 +20,23 @@
* @param id 鑰冩牳妯℃澘涓婚敭
* @return 鑰冩牳妯℃澘
*/
- public CheckTemplate selectCheckTemplateById(Long id);
+ public CheckTemplateQuery selectCheckTemplateById(Long id);
/**
* 鏌ヨ鑰冩牳妯℃澘鍒楄〃
*
- * @param checkTemplate 鑰冩牳妯℃澘
+ * @param checkTemplateDTO 鑰冩牳妯℃澘
* @return 鑰冩牳妯℃澘闆嗗悎
*/
- public List<CheckTemplate> selectCheckTemplateList(CheckTemplate checkTemplate);
+ public List<CheckTemplate> selectCheckTemplateList(CheckTemplateQuery checkTemplateDTO);
/**
* 鏂板鑰冩牳妯℃澘
*
- * @param checkTemplate 鑰冩牳妯℃澘
+ * @param checkTemplateDTO 鑰冩牳妯℃澘
* @return 缁撴灉
*/
- public int insertCheckTemplate(CheckTemplate checkTemplate);
+ public int insertCheckTemplate(CheckTemplateQuery checkTemplateDTO);
/**
* 淇敼鑰冩牳妯℃澘
@@ -59,4 +61,7 @@
* @return 缁撴灉
*/
public int deleteCheckTemplateById(Long id);
+
+ Result pullList();
+
}
diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckRuleServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckRuleServiceImpl.java
index 518e882..9a2b177 100644
--- a/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckRuleServiceImpl.java
+++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckRuleServiceImpl.java
@@ -1,6 +1,8 @@
package com.ycl.platform.service.impl;
import com.ycl.platform.domain.entity.CheckRule;
+import com.ycl.platform.domain.query.CheckRuleQuery;
+import com.ycl.platform.domain.vo.CheckRuleVO;
import com.ycl.platform.mapper.CheckRuleMapper;
import com.ycl.platform.service.ICheckRuleService;
import org.springframework.beans.factory.annotation.Autowired;
@@ -28,7 +30,7 @@
* @return 鑰冩牳瑙勫垯
*/
@Override
- public CheckRule selectCheckRuleById(Long id)
+ public CheckRuleVO selectCheckRuleById(Long id)
{
return checkRuleMapper.selectCheckRuleById(id);
}
@@ -36,13 +38,13 @@
/**
* 鏌ヨ鑰冩牳瑙勫垯鍒楄〃
*
- * @param checkRule 鑰冩牳瑙勫垯
+ * @param checkRuleQuery 鑰冩牳瑙勫垯
* @return 鑰冩牳瑙勫垯
*/
@Override
- public List<CheckRule> selectCheckRuleList(CheckRule checkRule)
+ public List<CheckRuleVO> selectCheckRuleList(CheckRuleQuery checkRuleQuery)
{
- return checkRuleMapper.selectCheckRuleList(checkRule);
+ return checkRuleMapper.selectCheckRuleList(checkRuleQuery);
}
/**
diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckTemplateServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckTemplateServiceImpl.java
index db6d9a1..e05625e 100644
--- a/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckTemplateServiceImpl.java
+++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/CheckTemplateServiceImpl.java
@@ -1,97 +1,143 @@
package com.ycl.platform.service.impl;
+import com.ycl.platform.base.BaseSelect;
import com.ycl.platform.domain.entity.CheckTemplate;
+import com.ycl.platform.domain.query.CheckTemplateQuery;
import com.ycl.platform.mapper.CheckTemplateMapper;
import com.ycl.platform.service.ICheckTemplateService;
+import com.ycl.system.Result;
+import com.ycl.system.entity.SysDept;
+import com.ycl.system.service.ISysDeptService;
+import io.jsonwebtoken.lang.Collections;
+import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.context.annotation.Bean;
import org.springframework.stereotype.Service;
import utils.DateUtils;
+import utils.StringUtils;
+import java.util.ArrayList;
+import java.util.Arrays;
import java.util.List;
+import java.util.Objects;
+import java.util.stream.Collectors;
/**
* 鑰冩牳妯℃澘Service涓氬姟灞傚鐞�
- *
+ *
* @author ruoyi
* @date 2024-04-01
*/
@Service
-public class CheckTemplateServiceImpl implements ICheckTemplateService
-{
+public class CheckTemplateServiceImpl implements ICheckTemplateService {
@Autowired
private CheckTemplateMapper checkTemplateMapper;
+ @Autowired
+ private ISysDeptService deptService;
/**
* 鏌ヨ鑰冩牳妯℃澘
- *
+ *
* @param id 鑰冩牳妯℃澘涓婚敭
* @return 鑰冩牳妯℃澘
*/
@Override
- public CheckTemplate selectCheckTemplateById(Long id)
- {
- return checkTemplateMapper.selectCheckTemplateById(id);
+ public CheckTemplateQuery selectCheckTemplateById(Long id) {
+ CheckTemplate checkTemplate = checkTemplateMapper.selectCheckTemplateById(id);
+ CheckTemplateQuery checkTemplateQuery = new CheckTemplateQuery();
+ BeanUtils.copyProperties(checkTemplate,checkTemplateQuery);
+ String deptId = checkTemplate.getDeptId();
+ String deptIdStr = deptId.substring(1, deptId.length() - 1);
+ List<Integer> deptIds = Arrays.stream(deptIdStr.split(","))
+ .mapToInt(Integer::parseInt)
+ .boxed().collect(Collectors.toList());
+ checkTemplateQuery.setDeptId(deptIds);
+ return checkTemplateQuery;
}
/**
* 鏌ヨ鑰冩牳妯℃澘鍒楄〃
- *
- * @param checkTemplate 鑰冩牳妯℃澘
+ *
+ * @param checkTemplateDTO 鑰冩牳妯℃澘
* @return 鑰冩牳妯℃澘
*/
@Override
- public List<CheckTemplate> selectCheckTemplateList(CheckTemplate checkTemplate)
- {
- return checkTemplateMapper.selectCheckTemplateList(checkTemplate);
+ public List<CheckTemplate> selectCheckTemplateList(CheckTemplateQuery checkTemplateDTO) {
+ List<CheckTemplate> checkTemplates = checkTemplateMapper.selectCheckTemplateList(checkTemplateDTO);
+ //閮ㄩ棬鍖哄煙涓嬫媺鍒楄〃
+ Result all = deptService.pullList();
+ List<BaseSelect> data = (List<BaseSelect>) all.get("data");
+ //缈昏瘧閮ㄩ棬id
+ for (CheckTemplate template : checkTemplates) {
+ if(template.getDeptId() == null)continue;
+ String[] deptIds = template.getDeptId().replace("[", "").replace("]", "").split(",");
+ List<String> deptName = new ArrayList<>();
+ for (String deptId : deptIds) {
+ List<String> deptStr = data.stream()
+ .filter(baseSelect -> baseSelect.getId().equals(Integer.parseInt(deptId)))
+ .map(BaseSelect::getValue)
+ .collect(Collectors.toList());
+ deptName.addAll(deptStr);
+ }
+ template.setDeptId(StringUtils.join(deptName,","));
+ }
+
+ return checkTemplates;
}
/**
* 鏂板鑰冩牳妯℃澘
- *
- * @param checkTemplate 鑰冩牳妯℃澘
+ *
+ * @param checkTemplateDTO 鑰冩牳妯℃澘
* @return 缁撴灉
*/
@Override
- public int insertCheckTemplate(CheckTemplate checkTemplate)
- {
- checkTemplate.setCreateTime(DateUtils.getNowDate());
+ public int insertCheckTemplate(CheckTemplateQuery checkTemplateDTO) {
+ checkTemplateDTO.setCreateTime(DateUtils.getNowDate());
+ CheckTemplate checkTemplate = new CheckTemplate();
+ BeanUtils.copyProperties(checkTemplateDTO,checkTemplate);
+ checkTemplate.setDeptId(checkTemplateDTO.getDeptId().toString().replaceAll(" ",""));
return checkTemplateMapper.insertCheckTemplate(checkTemplate);
}
/**
* 淇敼鑰冩牳妯℃澘
- *
+ *
* @param checkTemplate 鑰冩牳妯℃澘
* @return 缁撴灉
*/
@Override
- public int updateCheckTemplate(CheckTemplate checkTemplate)
- {
+ public int updateCheckTemplate(CheckTemplate checkTemplate) {
checkTemplate.setUpdateTime(DateUtils.getNowDate());
return checkTemplateMapper.updateCheckTemplate(checkTemplate);
}
/**
* 鎵归噺鍒犻櫎鑰冩牳妯℃澘
- *
+ *
* @param ids 闇�瑕佸垹闄ょ殑鑰冩牳妯℃澘涓婚敭
* @return 缁撴灉
*/
@Override
- public int deleteCheckTemplateByIds(Long[] ids)
- {
+ public int deleteCheckTemplateByIds(Long[] ids) {
return checkTemplateMapper.deleteCheckTemplateByIds(ids);
}
/**
* 鍒犻櫎鑰冩牳妯℃澘淇℃伅
- *
+ *
* @param id 鑰冩牳妯℃澘涓婚敭
* @return 缁撴灉
*/
@Override
- public int deleteCheckTemplateById(Long id)
- {
+ public int deleteCheckTemplateById(Long id) {
return checkTemplateMapper.deleteCheckTemplateById(id);
}
+
+ @Override
+ public Result pullList() {
+ List<CheckTemplate> checkTemplates = checkTemplateMapper.selectCheckTemplateList(new CheckTemplateQuery());
+
+ return Result.ok().data(checkTemplates);
+ }
}
diff --git a/ycl-server/src/main/java/com/ycl/system/controller/SysDeptController.java b/ycl-server/src/main/java/com/ycl/system/controller/SysDeptController.java
index cf4ef4b..8771d99 100644
--- a/ycl-server/src/main/java/com/ycl/system/controller/SysDeptController.java
+++ b/ycl-server/src/main/java/com/ycl/system/controller/SysDeptController.java
@@ -128,4 +128,10 @@
public Result all() {
return deptService.all();
}
+
+ @GetMapping("/pullList")
+ @ApiOperation(value = "鍖哄煙涓嬫媺鍒楄〃", notes = "鍖哄煙涓嬫媺鍒楄〃")
+ public Result pullList() {
+ return deptService.pullList();
+ }
}
diff --git a/ycl-server/src/main/java/com/ycl/system/service/ISysDeptService.java b/ycl-server/src/main/java/com/ycl/system/service/ISysDeptService.java
index 93faea3..bc79014 100644
--- a/ycl-server/src/main/java/com/ycl/system/service/ISysDeptService.java
+++ b/ycl-server/src/main/java/com/ycl/system/service/ISysDeptService.java
@@ -128,4 +128,10 @@
* @return
*/
Result all();
+
+ /**
+ * 鍖哄煙鍒楄〃
+ * @return
+ */
+ Result pullList();
}
diff --git a/ycl-server/src/main/java/com/ycl/system/service/impl/SysDeptServiceImpl.java b/ycl-server/src/main/java/com/ycl/system/service/impl/SysDeptServiceImpl.java
index f7a6506..e513424 100644
--- a/ycl-server/src/main/java/com/ycl/system/service/impl/SysDeptServiceImpl.java
+++ b/ycl-server/src/main/java/com/ycl/system/service/impl/SysDeptServiceImpl.java
@@ -296,6 +296,10 @@
return deptMapper.deleteDeptById(deptId);
}
+ /**
+ * 閮ㄩ棬涓嬫媺鍒楄〃
+ * @return
+ */
@Override
public Result all() {
List<BaseSelect> vos = deptMapper.selectDeptList(new SysDept()).stream().map(sysDept -> {
@@ -307,6 +311,21 @@
).collect(Collectors.toList());
return Result.ok().data(vos);
}
+ /**
+ * 鍖哄煙涓嬫媺鍒楄〃
+ * @return
+ */
+ @Override
+ public Result pullList() {
+ List<BaseSelect> vos = deptMapper.selectDeptList(new SysDept()).stream().filter(sysDept -> sysDept.getArea()!=null).map(sysDept -> {
+ BaseSelect baseSelect = new BaseSelect();
+ baseSelect.setId(Integer.parseInt(sysDept.getDeptId() + ""));
+ baseSelect.setValue(sysDept.getArea());
+ return baseSelect;
+ }
+ ).collect(Collectors.toList());
+ return Result.ok().data(vos);
+ }
/**
* 閫掑綊鍒楄〃
diff --git a/ycl-server/src/main/resources/application-dev.yml b/ycl-server/src/main/resources/application-dev.yml
index bdaf83b..babd523 100644
--- a/ycl-server/src/main/resources/application-dev.yml
+++ b/ycl-server/src/main/resources/application-dev.yml
@@ -38,7 +38,7 @@
datasource:
url: jdbc:mysql://101.35.247.188:3306/zgyw?useUnicode=true&characterEncoding=utf8&autoReconnect=true&useSSL=false
username: root
- password: 123456
+ password: ycl@202466
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
diff --git a/ycl-server/src/main/resources/application-prod.yml b/ycl-server/src/main/resources/application-prod.yml
index 7675437..b28e93a 100644
--- a/ycl-server/src/main/resources/application-prod.yml
+++ b/ycl-server/src/main/resources/application-prod.yml
@@ -38,7 +38,7 @@
datasource:
url: jdbc:mysql://101.35.247.188:3306/zgyw?useUnicode=true&characterEncoding=utf8&autoReconnect=true&useSSL=false
username: root
- password: 123456
+ password: ycl@202466
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
diff --git a/ycl-server/src/main/resources/mapper/system/SysDeptMapper.xml b/ycl-server/src/main/resources/mapper/system/SysDeptMapper.xml
index 368609a..5c2f042 100644
--- a/ycl-server/src/main/resources/mapper/system/SysDeptMapper.xml
+++ b/ycl-server/src/main/resources/mapper/system/SysDeptMapper.xml
@@ -9,6 +9,7 @@
<result property="parentId" column="parent_id" />
<result property="ancestors" column="ancestors" />
<result property="deptName" column="dept_name" />
+ <result property="area" column="area" />
<result property="orderNum" column="order_num" />
<result property="leader" column="leader" />
<result property="phone" column="phone" />
@@ -23,7 +24,7 @@
</resultMap>
<sql id="selectDeptVo">
- select d.dept_id, d.parent_id, d.ancestors, d.dept_name, d.order_num, d.leader, d.phone, d.email, d.status, d.del_flag, d.create_by, d.create_time
+ select d.dept_id, d.parent_id, d.ancestors, d.dept_name, d.order_num, d.leader, d.phone, d.email, d.status, d.del_flag, d.create_by, d.create_time,d.area
from sys_dept d
</sql>
@@ -59,7 +60,7 @@
</select>
<select id="selectDeptById" parameterType="Long" resultMap="SysDeptResult">
- select d.dept_id, d.parent_id, d.ancestors, d.dept_name, d.order_num, d.leader, d.phone, d.email, d.status,
+ select d.dept_id, d.parent_id, d.ancestors, d.dept_name, d.order_num, d.leader, d.phone, d.email, d.status,d.area,
(select dept_name from sys_dept where dept_id = d.parent_id) parent_name
from sys_dept d
where d.dept_id = #{deptId}
@@ -120,6 +121,7 @@
<set>
<if test="parentId != null and parentId != 0">parent_id = #{parentId},</if>
<if test="deptName != null and deptName != ''">dept_name = #{deptName},</if>
+ <if test="area != null and area != ''">area = #{area},</if>
<if test="ancestors != null and ancestors != ''">ancestors = #{ancestors},</if>
<if test="orderNum != null">order_num = #{orderNum},</if>
<if test="leader != null">leader = #{leader},</if>
diff --git a/ycl-server/src/main/resources/mapper/zgyw/CalculateRecordMapper.xml b/ycl-server/src/main/resources/mapper/zgyw/CalculateRecordMapper.xml
index 57b1fa4..da7e9ee 100644
--- a/ycl-server/src/main/resources/mapper/zgyw/CalculateRecordMapper.xml
+++ b/ycl-server/src/main/resources/mapper/zgyw/CalculateRecordMapper.xml
@@ -9,13 +9,13 @@
<result property="date" column="date" />
<result property="ruleId" column="rule_id" />
<result property="unitId" column="unit_id" />
- <result property="totalMount" column="totalMount" />
+ <result property="totalAmount" column="total_amount" />
<result property="deductAmount" column="deduct_amount" />
<result property="score" column="score" />
</resultMap>
<sql id="selectCalculateRecordVo">
- select id, date, rule_id, unit_id, totalMount, deduct_amount, score from t_calculate_record
+ select id, date, rule_id, unit_id, total_amount, deduct_amount, score from t_calculate_record
</sql>
<select id="selectCalculateRecordList" resultMap="CalculateRecordResult">
@@ -24,7 +24,7 @@
<if test="date != null "> and date = #{date}</if>
<if test="ruleId != null "> and rule_id = #{ruleId}</if>
<if test="unitId != null "> and unit_id = #{unitId}</if>
- <if test="totalMount != null "> and totalMount = #{totalMount}</if>
+ <if test="totalAmount != null "> and total_amount = #{totalAmount}</if>
<if test="deductAmount != null "> and deduct_amount = #{deductAmount}</if>
<if test="score != null "> and score = #{score}</if>
</where>
@@ -42,7 +42,7 @@
<if test="date != null">date,</if>
<if test="ruleId != null">rule_id,</if>
<if test="unitId != null">unit_id,</if>
- <if test="totalMount != null">totalMount,</if>
+ <if test="totalAmount != null">total_amount,</if>
<if test="deductAmount != null">deduct_amount,</if>
<if test="score != null">score,</if>
</trim>
@@ -51,7 +51,7 @@
<if test="date != null">#{date},</if>
<if test="ruleId != null">#{ruleId},</if>
<if test="unitId != null">#{unitId},</if>
- <if test="totalMount != null">#{totalMount},</if>
+ <if test="totalAmount != null">#{totalAmount},</if>
<if test="deductAmount != null">#{deductAmount},</if>
<if test="score != null">#{score},</if>
</trim>
@@ -63,7 +63,7 @@
<if test="date != null">date = #{date},</if>
<if test="ruleId != null">rule_id = #{ruleId},</if>
<if test="unitId != null">unit_id = #{unitId},</if>
- <if test="totalMount != null">totalMount = #{totalMount},</if>
+ <if test="totalAmount != null">total_amount = #{totalAmount},</if>
<if test="deductAmount != null">deduct_amount = #{deductAmount},</if>
<if test="score != null">score = #{score},</if>
</trim>
diff --git a/ycl-server/src/main/resources/mapper/zgyw/CheckRuleMapper.xml b/ycl-server/src/main/resources/mapper/zgyw/CheckRuleMapper.xml
index b24f9a0..a940b37 100644
--- a/ycl-server/src/main/resources/mapper/zgyw/CheckRuleMapper.xml
+++ b/ycl-server/src/main/resources/mapper/zgyw/CheckRuleMapper.xml
@@ -7,11 +7,10 @@
<resultMap type="com.ycl.platform.domain.entity.CheckRule" id="CheckRuleResult">
<result property="id" column="id" />
<result property="ruleName" column="rule_name" />
- <result property="ruleDetail" column="rule_detail" />
+ <result property="ruleIndex" column="rule_index" />
<result property="ruleCategory" column="rule_category" />
<result property="examineCategory" column="examine_category" />
<result property="ruleDescription" column="rule_description" />
- <result property="auditState" column="audit_state" />
<result property="state" column="state" />
<result property="createTime" column="create_time" />
<result property="updateTime" column="update_time" />
@@ -19,24 +18,28 @@
</resultMap>
<sql id="selectCheckRuleVo">
- select id, rule_name, rule_detail, rule_category, examine_category, rule_description, audit_state, state, create_time, update_time, deleted from t_check_rule
+ select id, rule_name, rule_index, rule_category, examine_category, rule_description, state, create_time, update_time, deleted from t_check_rule
</sql>
- <select id="selectCheckRuleList" resultMap="CheckRuleResult">
- <include refid="selectCheckRuleVo"/>
- <where>
- <if test="ruleName != null and ruleName != ''"> and rule_name like concat('%', #{ruleName}, '%')</if>
- <if test="ruleCategory != null "> and rule_category = #{ruleCategory}</if>
- <if test="examineCategory != null "> and examine_category = #{examineCategory}</if>
- <if test="ruleDescription != null and ruleDescription != ''"> and rule_description = #{ruleDescription}</if>
- <if test="auditState != null "> and audit_state = #{auditState}</if>
- <if test="state != null "> and state = #{state}</if>
+ <select id="selectCheckRuleList" resultType="com.ycl.platform.domain.vo.CheckRuleVO">
+ select tcr.id, tcr.rule_name, tcr.rule_index, tcr.rule_category, tcr.examine_category, tcr.rule_description,
+ tctr.weight, tctr.audit_state,tctr.check_template_id as templateId,tct.template_name
+ from t_check_template_rule tctr inner join t_check_rule tcr on tcr.id = tctr.check_rule_id
+ inner join t_check_template tct on tctr.check_template_id = tct.id
+ <where>
+ state = 0
+ <if test="ruleName != null and ruleName != ''"> and tcr.rule_name like concat(#{ruleName}, '%')</if>
+ <if test="ruleCategory != null "> and tcr.rule_category = #{ruleCategory}</if>
+ <if test="examineCategory != null "> and tcr.examine_category = #{examineCategory}</if>
+ <if test="auditState != null "> and tctr.audit_state = #{auditState}</if>
+ <if test="templateId != null "> and tctr.check_template_id = #{templateId}</if>
</where>
</select>
- <select id="selectCheckRuleById" resultMap="CheckRuleResult">
- <include refid="selectCheckRuleVo"/>
- where id = #{id}
+ <select id="selectCheckRuleById" resultType="com.ycl.platform.domain.vo.CheckRuleVO">
+ select tcr.id, tcr.rule_name, tcr.rule_index, tcr.rule_category, tcr.examine_category, tcr.rule_description, tctr.weight, tctr.audit_state,tctr.check_template_id as templateId
+ from t_check_rule tcr inner join t_check_template_rule tctr on tcr.id = tctr.check_rule_id
+ where tcr.id = #{id} and tcr.state = 0
</select>
<insert id="insertCheckRule" useGeneratedKeys="true" keyProperty="id">
@@ -47,7 +50,6 @@
<if test="ruleCategory != null">rule_category,</if>
<if test="examineCategory != null">examine_category,</if>
<if test="ruleDescription != null">rule_description,</if>
- <if test="auditState != null">audit_state,</if>
<if test="state != null">state,</if>
<if test="createTime != null">create_time,</if>
<if test="updateTime != null">update_time,</if>
@@ -55,11 +57,10 @@
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="ruleName != null and ruleName != ''">#{ruleName},</if>
- <if test="ruleDetail != null">#{ruleDetail},</if>
+ <if test="ruleIndex != null">#{ruleIndex},</if>
<if test="ruleCategory != null">#{ruleCategory},</if>
<if test="examineCategory != null">#{examineCategory},</if>
<if test="ruleDescription != null">#{ruleDescription},</if>
- <if test="auditState != null">#{auditState},</if>
<if test="state != null">#{state},</if>
<if test="createTime != null">#{createTime},</if>
<if test="updateTime != null">#{updateTime},</if>
@@ -71,11 +72,10 @@
update t_check_rule
<trim prefix="SET" suffixOverrides=",">
<if test="ruleName != null and ruleName != ''">rule_name = #{ruleName},</if>
- <if test="ruleDetail != null">rule_detail = #{ruleDetail},</if>
+ <if test="ruleIndex != null">rule_index = #{ruleIndex},</if>
<if test="ruleCategory != null">rule_category = #{ruleCategory},</if>
<if test="examineCategory != null">examine_category = #{examineCategory},</if>
<if test="ruleDescription != null">rule_description = #{ruleDescription},</if>
- <if test="auditState != null">audit_state = #{auditState},</if>
<if test="state != null">state = #{state},</if>
<if test="createTime != null">create_time = #{createTime},</if>
<if test="updateTime != null">update_time = #{updateTime},</if>
diff --git a/ycl-server/src/main/resources/mapper/zgyw/CheckTemplateMapper.xml b/ycl-server/src/main/resources/mapper/zgyw/CheckTemplateMapper.xml
index c02a06e..d7db920 100644
--- a/ycl-server/src/main/resources/mapper/zgyw/CheckTemplateMapper.xml
+++ b/ycl-server/src/main/resources/mapper/zgyw/CheckTemplateMapper.xml
@@ -29,11 +29,8 @@
<include refid="selectCheckTemplateVo"/>
<where>
<if test="templateName != null and templateName != ''"> and template_name like concat('%', #{templateName}, '%')</if>
- <if test="adjustCoefficient != null "> and adjust_coefficient = #{adjustCoefficient}</if>
- <if test="adjustWay != null and adjustWay != ''"> and adjust_way = #{adjustWay}</if>
<if test="examineCategory != null "> and examine_category = #{examineCategory}</if>
<if test="status != null and status != ''"> and status = #{status}</if>
- <if test="deptId != null and deptId != ''"> and dept_id = #{deptId}</if>
</where>
</select>
--
Gitblit v1.8.0