package com.tievd.cube.modules.system.controller;
|
|
import com.tievd.cube.commons.base.Result;
|
import com.tievd.cube.commons.utils.SqlInjectionUtil;
|
import com.tievd.cube.modules.system.model.api.request.DuplicateCheckRequest;
|
import com.tievd.cube.modules.system.service.ISysDictService;
|
import io.swagger.v3.oas.annotations.Operation;
|
import io.swagger.v3.oas.annotations.Parameter;
|
import io.swagger.v3.oas.annotations.Parameters;
|
import io.swagger.v3.oas.annotations.tags.Tag;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.validation.annotation.Validated;
|
import org.springframework.web.bind.annotation.GetMapping;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.RestController;
|
|
/**
|
* 重复数据校验
|
*
|
* @author 杨欣武
|
* @version 2.5.2
|
* @since 2022-08-11
|
*/
|
@Tag(name = "重复数据校验")
|
@RestController
|
@RequestMapping("/sys/duplicate")
|
public class DuplicateCheckController {
|
|
@Autowired
|
private ISysDictService sysDictService;
|
|
/**
|
* 校验数据是否已在系统
|
*/
|
@GetMapping("/check")
|
@Operation(summary = "校验数据是否已在系统")
|
@Parameters({
|
@Parameter(name = "tableName", description = "表名", required = true),
|
@Parameter(name = "fieldName", description = "字段名", required = true),
|
@Parameter(name = "fieldVal", description = "字段值", required = true),
|
@Parameter(name = "dataId", description = "要排除的数据id")
|
})
|
public Result<?> doDuplicateCheck(@Parameter(hidden = true) @Validated DuplicateCheckRequest duplicateCheckRequest) {
|
final String[] sqlInjCheck = {duplicateCheckRequest.getTableName(), duplicateCheckRequest.getFieldName()};
|
SqlInjectionUtil.filterContent(sqlInjCheck);
|
Long num = sysDictService.duplicateCheckCountSql(duplicateCheckRequest);
|
if (num != null && num > 0) {
|
return Result.error("该值已使用！");
|
}
|
return Result.ok("该值可用！");
|
}
|
}
|
