package jnpf.base.mapper;
|
|
import cn.hutool.core.bean.BeanUtil;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import jnpf.base.entity.VisualAliasEntity;
|
import jnpf.base.model.VisualAliasForm;
|
import jnpf.constant.GenerateConstant;
|
import jnpf.constant.MsgCode;
|
import jnpf.exception.DataException;
|
import jnpf.model.visualJson.TableFields;
|
import jnpf.model.visualJson.TableModel;
|
import jnpf.util.RandomUtil;
|
import jnpf.util.StringUtil;
|
import jnpf.util.UserProvider;
|
import org.apache.commons.collections4.CollectionUtils;
|
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
/**
|
* @author JNPF开发平台组
|
* @version v5.0.0
|
* @copyright 引迈信息技术有限公司
|
* @date 2024/4/13 14:03:56
|
*/
|
public interface VisualAliasMapper extends SuperMapper<VisualAliasEntity> {
|
|
|
default List<VisualAliasEntity> getList(String visualId) {
|
QueryWrapper<VisualAliasEntity> queryWrapper = new QueryWrapper<>();
|
queryWrapper.lambda().eq(VisualAliasEntity::getVisualId, visualId);
|
return this.selectList(queryWrapper);
|
}
|
|
default void aliasSave(String id, VisualAliasForm form) {
|
List<TableModel> tableList = form.getTableList();
|
List<VisualAliasEntity> list = this.getList(id);
|
List<String> tableNameList = new ArrayList<>();
|
List<String> listKeyword = GenerateConstant.getAllKeyWord();
|
String regex = "[a-zA-Z_][a-zA-Z0-9_]*";
|
for (TableModel tableModel : tableList) {
|
VisualAliasEntity tableAlias = list.stream().filter(t -> tableModel.getTable().equals(t.getTableName()) && t.getFieldName() == null).findFirst().orElse(null);
|
if (StringUtil.isNotEmpty(tableModel.getAliasName())) {
|
if (tableNameList.contains(tableModel.getAliasName())) {
|
throw new DataException(tableModel.getAliasName() + MsgCode.VS018.get());
|
} else {
|
tableNameList.add(tableModel.getAliasName());
|
}
|
|
if (listKeyword.contains(tableModel.getAliasName().toLowerCase())) {
|
throw new DataException(MsgCode.SYS128.get(tableModel.getTable() + "-" + tableModel.getAliasName()));
|
}
|
|
if (!tableModel.getAliasName().matches(regex)) {
|
throw new DataException(MsgCode.VS021.get(tableModel.getTable()));
|
}
|
if (twoCharactesUpperCase(tableModel.getAliasName())) {
|
throw new DataException(MsgCode.VS026.get());
|
}
|
if (tableAlias != null) {
|
tableAlias.setAliasName(tableModel.getAliasName());
|
} else {
|
tableAlias = new VisualAliasEntity();
|
tableAlias.setId(RandomUtil.uuId());
|
tableAlias.setVisualId(id);
|
tableAlias.setTableName(tableModel.getTable());
|
tableAlias.setAliasName(tableModel.getAliasName());
|
}
|
this.insertOrUpdate(tableAlias);
|
} else if (tableAlias != null) {
|
this.deleteById(tableAlias);
|
}
|
List<String> fieldNameList = new ArrayList<>();
|
for (TableFields field : tableModel.getFields()) {
|
VisualAliasEntity fieldAlias = list.stream().filter(t -> tableModel.getTable().equals(t.getTableName()) && t.getFieldName() != null
|
&& field.getField().equals(t.getFieldName())).findFirst().orElse(null);
|
if (StringUtil.isNotEmpty(field.getAliasName())) {
|
if (listKeyword.contains(field.getAliasName().toLowerCase())) {
|
throw new DataException(MsgCode.SYS128.get(field.getField() + "-" + field.getAliasName()));
|
}
|
if (!field.getAliasName().matches(regex)) {
|
throw new DataException(MsgCode.VS021.get(field.getField()));
|
}
|
if (twoCharactesUpperCase(field.getAliasName())) {
|
throw new DataException(MsgCode.VS026.get());
|
}
|
if (fieldNameList.contains(field.getAliasName())) {
|
throw new DataException(field.getAliasName() + MsgCode.VS020.get());
|
} else {
|
fieldNameList.add(field.getAliasName());
|
}
|
if (fieldAlias != null) {
|
fieldAlias.setAliasName(field.getAliasName());
|
} else {
|
fieldAlias = new VisualAliasEntity();
|
fieldAlias.setId(RandomUtil.uuId());
|
fieldAlias.setVisualId(id);
|
fieldAlias.setTableName(tableModel.getTable());
|
fieldAlias.setFieldName(field.getField());
|
fieldAlias.setAliasName(field.getAliasName());
|
}
|
this.insertOrUpdate(fieldAlias);
|
} else if (fieldAlias != null) {
|
this.deleteById(fieldAlias);
|
}
|
}
|
}
|
}
|
|
default void copy(String visualId, String uuid) {
|
List<VisualAliasEntity> list = this.getList(visualId);
|
if (CollectionUtils.isNotEmpty(list)) {
|
for (VisualAliasEntity entity : list) {
|
VisualAliasEntity copy = BeanUtil.copyProperties(entity, VisualAliasEntity.class);
|
copyEntity(copy, uuid);
|
}
|
}
|
}
|
|
default void copyEntity(VisualAliasEntity copy, String visualId) {
|
copy.setId(RandomUtil.uuId());
|
copy.setVisualId(visualId);
|
copy.setCreatorTime(new Date());
|
copy.setCreatorUserId(UserProvider.getUser().getUserId());
|
copy.setLastModifyUserId(null);
|
copy.setLastModifyTime(null);
|
this.insert(copy);
|
}
|
|
default void removeByVisualId(String visualId) {
|
QueryWrapper<VisualAliasEntity> queryWrapper = new QueryWrapper<>();
|
queryWrapper.lambda().eq(VisualAliasEntity::getVisualId, visualId);
|
this.delete(queryWrapper);
|
}
|
|
/**
|
* 判断前两字母是否大写
|
*
|
* @return
|
*/
|
default boolean twoCharactesUpperCase(String name) {
|
if (StringUtil.isEmpty(name)) {
|
return false;
|
}
|
if (name.length() == 1) {
|
return Character.isUpperCase(name.charAt(0));
|
}
|
if (name.length() >= 2) {
|
return Character.isUpperCase(name.charAt(0)) || Character.isUpperCase(name.charAt(1));
|
}
|
return false;
|
}
|
}
|
