/*
|
* Copyright [2020-2030] [https://www.stylefeng.cn]
|
*
|
* Licensed under the Apache License, Version 2.0 (the "License");
|
* you may not use this file except in compliance with the License.
|
* You may obtain a copy of the License at
|
*
|
* http://www.apache.org/licenses/LICENSE-2.0
|
*
|
* Unless required by applicable law or agreed to in writing, software
|
* distributed under the License is distributed on an "AS IS" BASIS,
|
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
|
* See the License for the specific language governing permissions and
|
* limitations under the License.
|
*
|
* Guns采用APACHE LICENSE 2.0开源协议，您在使用过程中，需要注意以下几点：
|
*
|
* 1.请不要删除和修改根目录下的LICENSE文件。
|
* 2.请不要删除和修改Guns源码头部的版权声明。
|
* 3.请保留源码和相关描述文件的项目出处，作者声明等。
|
* 4.分发源码时候，请注明软件出处 https://gitee.com/stylefeng/guns
|
* 5.在修改包名，模块名称，项目代码等时，请注明软件出处 https://gitee.com/stylefeng/guns
|
* 6.若您的项目无法满足以上几点，可申请商业授权
|
*/
|
package cn.stylefeng.roses.kernel.validator.api.validators.unique;
|
|
import cn.hutool.core.lang.Dict;
|
import cn.hutool.core.util.ObjectUtil;
|
import cn.hutool.core.util.StrUtil;
|
import cn.stylefeng.roses.kernel.rule.pojo.request.BaseRequest;
|
import cn.stylefeng.roses.kernel.validator.api.context.RequestGroupContext;
|
import cn.stylefeng.roses.kernel.validator.api.context.RequestParamContext;
|
import cn.stylefeng.roses.kernel.validator.api.pojo.UniqueValidateParam;
|
import cn.stylefeng.roses.kernel.validator.api.validators.unique.service.TableUniqueValueService;
|
|
import javax.validation.ConstraintValidator;
|
import javax.validation.ConstraintValidatorContext;
|
|
/**
|
* 验证表的的某个字段值是否在是唯一值
|
*
|
* @author fengshuonan
|
* @date 2020/11/4 14:39
|
*/
|
public class TableUniqueValueValidator implements ConstraintValidator<TableUniqueValue, Object> {
|
|
/**
|
* 表名称，例如 sys_user
|
*/
|
private String tableName;
|
|
/**
|
* 列名称，例如 user_code
|
*/
|
private String columnName;
|
|
/**
|
* id字段的名称
|
*/
|
private String idFieldName;
|
|
/**
|
* 是否开启逻辑删除校验，默认是关闭的
|
* <p>
|
* 关于为何开启逻辑删除校验：
|
* <p>
|
* 若项目中某个表包含控制逻辑删除的字段，我们在进行唯一值校验的时候要排除这种状态的记录，所以需要用到这个功能
|
*/
|
private boolean excludeLogicDeleteItems;
|
|
/**
|
* 逻辑删除的字段名称
|
*/
|
private String logicDeleteFieldName;
|
|
/**
|
* 默认逻辑删除的值（Y是已删除）
|
*/
|
private String logicDeleteValue;
|
|
@Override
|
public void initialize(TableUniqueValue constraintAnnotation) {
|
this.tableName = constraintAnnotation.tableName();
|
this.columnName = constraintAnnotation.columnName();
|
this.excludeLogicDeleteItems = constraintAnnotation.excludeLogicDeleteItems();
|
this.logicDeleteFieldName = constraintAnnotation.logicDeleteFieldName();
|
this.logicDeleteValue = constraintAnnotation.logicDeleteValue();
|
this.idFieldName = constraintAnnotation.idFieldName();
|
}
|
|
@Override
|
public boolean isValid(Object fieldValue, ConstraintValidatorContext context) {
|
|
if (ObjectUtil.isNull(fieldValue)) {
|
return true;
|
}
|
|
Class<?> validateGroupClass = RequestGroupContext.get();
|
|
// 如果属于edit group，校验时需要排除当前修改的这条记录
|
if (BaseRequest.edit.class.equals(validateGroupClass)) {
|
UniqueValidateParam editParam = createEditParam(fieldValue);
|
return TableUniqueValueService.getFiledUniqueFlag(editParam);
|
}
|
|
// 如果属于add group，则校验库中所有行
|
if (BaseRequest.add.class.equals(validateGroupClass)) {
|
UniqueValidateParam addParam = createAddParam(fieldValue);
|
return TableUniqueValueService.getFiledUniqueFlag(addParam);
|
}
|
|
// 默认校验所有的行
|
UniqueValidateParam addParam = createAddParam(fieldValue);
|
return TableUniqueValueService.getFiledUniqueFlag(addParam);
|
}
|
|
/**
|
* 创建校验新增的参数
|
*
|
* @author fengshuonan
|
* @date 2020/8/17 21:55
|
*/
|
private UniqueValidateParam createAddParam(Object fieldValue) {
|
return UniqueValidateParam.builder()
|
.tableName(tableName)
|
.columnName(columnName)
|
.value(fieldValue)
|
.excludeCurrentRecord(Boolean.FALSE)
|
.excludeLogicDeleteItems(excludeLogicDeleteItems)
|
.logicDeleteFieldName(logicDeleteFieldName)
|
.logicDeleteValue(logicDeleteValue).build();
|
}
|
|
/**
|
* 创建修改的参数校验
|
*
|
* @author fengshuonan
|
* @date 2020/8/17 21:56
|
*/
|
private UniqueValidateParam createEditParam(Object fieldValue) {
|
|
// 获取请求字段中id的值
|
Dict requestParam = RequestParamContext.get();
|
|
// 获取id字段的驼峰命名法
|
String camelCaseIdFieldName = StrUtil.toCamelCase(idFieldName);
|
|
return UniqueValidateParam.builder()
|
.tableName(tableName)
|
.columnName(columnName)
|
.value(fieldValue)
|
.idFieldName(idFieldName)
|
.excludeCurrentRecord(Boolean.TRUE)
|
.id(requestParam.getLong(camelCaseIdFieldName))
|
.excludeLogicDeleteItems(excludeLogicDeleteItems)
|
.logicDeleteFieldName(logicDeleteFieldName)
|
.logicDeleteValue(logicDeleteValue).build();
|
}
|
|
}
|
