package com.product.admin.util;
|
|
import java.util.regex.Matcher;
|
import java.util.regex.Pattern;
|
|
import org.springframework.stereotype.Component;
|
|
import com.alibaba.druid.util.StringUtils;
|
import com.product.admin.config.SystemCode;
|
import com.product.util.config.SystemParamSet;
|
import com.product.common.lang.DateUtils;
|
import com.product.core.entity.FieldSetEntity;
|
import com.product.core.exception.BaseException;
|
import com.product.core.service.support.AbstractBaseService;
|
import com.product.core.spring.context.SpringMVCContextHolder;
|
|
/**
|
* 系统参数替换
|
*
|
* @author Mr.Xu
|
*
|
*/
|
|
public class SystemParamReplace extends AbstractBaseService {
|
|
public static void main(String[] args) throws BaseException {
|
paramEXCELError("13", 10, 10, "12");
|
}
|
|
/**
|
* 数据导入错误提示信息
|
*
|
* @param paramText 错误通用文本
|
* @param x 错误所在行
|
* @param y 错误所在列
|
* @param dataValue 错误数据
|
* @return
|
*/
|
public static String paramError(String paramText, int x, int y, String dataValue) {
|
|
String xs = (String) excelColIndexToStr(x);
|
|
// 验证正则表达式
|
Pattern p = Pattern.compile("(\\{\\{)([\\w]+)(\\}\\})");
|
Matcher m = p.matcher(paramText);
|
StringBuffer sb = new StringBuffer();
|
while (m.find()) {
|
String group = m.group(2);
|
if ("x".equals(group)) {
|
m.appendReplacement(sb, "" + xs);
|
} else if ("y".equals(group)) {
|
m.appendReplacement(sb, "" + y);
|
} else if ("dataValue".equals(group)) {
|
m.appendReplacement(sb, dataValue);
|
}
|
}
|
m.appendTail(sb);
|
return sb.toString();
|
}
|
|
/**
|
* 错误信息替换
|
*
|
* @param paramText 原错误文本
|
* @param x 替换参数一
|
* @param y 替换参数二
|
* @param dataValue 错误数据
|
* @return
|
*/
|
public static String paramError(String paramText, String x, String y, String dataValue) {
|
// 验证正则表达式
|
Pattern p = Pattern.compile("(\\{\\{)([\\w]+)(\\}\\})");
|
Matcher m = p.matcher(paramText);
|
StringBuffer sb = new StringBuffer();
|
while (m.find()) {
|
String group = m.group(2);
|
if ("x".equals(group)) {
|
m.appendReplacement(sb, "" + x);
|
} else if ("y".equals(group)) {
|
m.appendReplacement(sb, "" + y);
|
} else if ("dataValue".equals(group)) {
|
m.appendReplacement(sb, dataValue);
|
}
|
}
|
m.appendTail(sb);
|
return sb.toString();
|
}
|
|
/**
|
* 错误信息替换(列号转为EXCEL列号)
|
*
|
* @param paramText 原错误文本
|
* @param x 替换参数一
|
* @param y 替换参数二
|
* @param dataValue 错误数据
|
* @return
|
*/
|
public static String paramEXCELError(String paramText, int x, int y, String dataValue) {
|
|
String xs = (String) excelColIndexToStr(x);
|
y=y+3;
|
|
// 验证正则表达式
|
Pattern p = Pattern.compile("(\\{\\{)([\\w]+)(\\}\\})");
|
Matcher m = p.matcher(paramText);
|
StringBuffer sb = new StringBuffer();
|
while (m.find()) {
|
String group = m.group(2);
|
if ("x".equals(group)) {
|
m.appendReplacement(sb, xs);
|
} else if ("y".equals(group)) {
|
m.appendReplacement(sb, "" + y);
|
} else if ("dataValue".equals(group)) {
|
m.appendReplacement(sb, dataValue);
|
}
|
}
|
m.appendTail(sb);
|
return sb.toString();
|
}
|
|
// 将数字转换为EXCEL列号字母
|
public static String excelColIndexToStr(int columnIndex) {
|
// 列索引从0开始
|
|
String columnStr = "";
|
do {
|
if (columnStr.length() > 0) {
|
columnIndex--;
|
}
|
columnStr = ((char) (columnIndex % 26 + (int) 'A')) + columnStr;
|
columnIndex =((columnIndex - columnIndex % 26) / 26);
|
} while (columnIndex > 0);
|
return columnStr;
|
}
|
|
/**
|
*
|
* @param args 需要替换的String字符串
|
* @param pageFieldset 表单FieldSetEntity 参数 替换规则 {表单参数} 、 [系统参数]
|
* @return
|
* @throws BaseException
|
*/
|
public static String paramReplace(String args, FieldSetEntity pageFieldset) throws BaseException {
|
Pattern p = Pattern.compile("(\\[)([\\w]+)(\\])");
|
Matcher m = p.matcher(args);
|
StringBuffer sb = new StringBuffer();
|
while (m.find()) {
|
String group = m.group(2);
|
if (SystemParamSet.SYSTEM_PARAMS.get(group) != null) {
|
m.appendReplacement(sb, replaceSystemParameter(group));
|
}
|
|
}
|
m.appendTail(sb);
|
return replacePageParameter(sb.toString(), pageFieldset);
|
}
|
|
/**
|
*
|
* @param args 需要替换的String字符串 高级参照专用
|
* @return
|
* @throws BaseException
|
*/
|
public static String paramReplacePrompt(String args) throws BaseException {
|
if (args == null || "".equals(args)) {
|
return null;
|
}
|
Pattern p = Pattern.compile("(\\{\\{)([\\w]+)(\\}\\})");
|
Matcher m = p.matcher(args);
|
StringBuffer sb = new StringBuffer();
|
while (m.find()) {
|
String group = m.group(2);
|
if (SystemParamSet.SYSTEM_PARAMS.get(group) != null) {
|
m.appendReplacement(sb, replaceSystemParameter(group));
|
}
|
|
}
|
m.appendTail(sb);
|
return sb.toString();
|
}
|
|
/**
|
* 替换业务数据
|
*
|
* @param args
|
* @param fs
|
* @return
|
* @throws BaseException
|
*/
|
private static String replacePageParameter(String args, FieldSetEntity fs) throws BaseException {
|
if (fs != null) {
|
Pattern p = Pattern.compile("(\\{)([\\w]+)(\\})");
|
Matcher m = p.matcher(args);
|
StringBuffer sb = new StringBuffer();
|
while (m.find()) {
|
String group = m.group(2);
|
if (fs.getString(group) != null) {
|
m.appendReplacement(sb, fs.getString(group));
|
}else{
|
m.appendReplacement(sb, "");
|
}
|
}
|
m.appendTail(sb);
|
return sb.toString();
|
}
|
return args;
|
}
|
|
/**
|
* 替换文本参数
|
*
|
* @param paramText 原文本
|
* @param fseData 业务数据
|
* @return 新文本
|
* @throws BaseException
|
*/
|
public static String replaceParamText(String paramText, FieldSetEntity fseData) throws BaseException {
|
String str = paramText;
|
// 人员参数{{参数值:staff}}
|
Pattern p1 = Pattern.compile("(\\{\\{)([\\w]+)(:staff\\}\\})");
|
// 邮件参数{{参数值:email}}
|
Pattern p2 = Pattern.compile("(\\{\\{)([\\w]+)(:email\\}\\})");
|
// 系统参数{{参数名:sys}}
|
Pattern p3 = Pattern.compile("(\\{\\{)([\\w]+)(:sys\\}\\})");
|
// 普通业务参数{{参数名}}
|
Pattern p4 = Pattern.compile("(\\{\\{)([\\w]+)(\\}\\})");
|
|
StringBuffer sb1 = new StringBuffer();
|
Matcher m = p1.matcher(str);
|
while (m.find()) {
|
String group = m.group(2);
|
m.appendReplacement(sb1, group);
|
}
|
m.appendTail(sb1);
|
|
StringBuffer sb2 = new StringBuffer();
|
m = p2.matcher(sb1);
|
while (m.find()) {
|
String group = m.group(2);
|
m.appendReplacement(sb2, group);
|
}
|
m.appendTail(sb2);
|
|
StringBuffer sb3 = new StringBuffer();
|
m = p3.matcher(sb2);
|
while (m.find()) {
|
String group = m.group(2);
|
String replaceValue=replaceSystemParameter(group);
|
if(StringUtils.isEmpty(replaceValue)) {
|
continue;
|
}
|
m.appendReplacement(sb3, replaceValue);
|
}
|
m.appendTail(sb3);
|
|
StringBuffer sb4 = new StringBuffer();
|
if (fseData != null) {
|
m = p4.matcher(sb3);
|
while (m.find()) {
|
String group = m.group(2);
|
String value = fseData.getString(group);
|
if (null != value) {
|
m.appendReplacement(sb4, value);
|
}
|
}
|
m.appendTail(sb4);
|
}
|
return sb4.toString();
|
|
}
|
|
/**
|
* 获取系统参数值
|
*
|
* @param key 系统参数名
|
* @return
|
*/
|
public static String replaceSystemParameter(String key) throws BaseException {
|
if (SpringMVCContextHolder.getCurrentUser() == null) {
|
return "";
|
}
|
try {
|
switch (key) {
|
case "YEAR": // 年
|
return DateUtils.getYear();
|
case "MONTH": // 月
|
return DateUtils.getMonth();
|
case "DAY": // 天
|
return DateUtils.getDay();
|
case "STAFF_NAME": // 用户名称
|
return SpringMVCContextHolder.getCurrentUser().getCurrentStaff().getString("staff_name");
|
case "STAFF_UUID": // 用户uuid
|
return SpringMVCContextHolder.getCurrentUser().getCurrentStaff().getString("uuid");
|
case "STAFF_CODE": // 用户编码
|
return SpringMVCContextHolder.getCurrentUser().getCurrentStaff().getString("tricode");
|
case "USER_UUID": // user 表uuid
|
return SpringMVCContextHolder.getCurrentUser().getUuid();
|
case "USER_ID": // user 表id
|
return String.valueOf(SpringMVCContextHolder.getCurrentUser().getUser_id());
|
case "CLIENT_UUID": // 客户uuid
|
return SpringMVCContextHolder.getCurrentUser().getClient_uuid();
|
case "CLIENT_NAME": // 客户uuid
|
return SpringMVCContextHolder.getCurrentUser().getClientName();
|
case "COMPANY_CODE": // 公司编码
|
return SpringMVCContextHolder.getCurrentUser().getOrg_level_code();
|
case "COMPANY_NAME": // 公司名称
|
return SpringMVCContextHolder.getCurrentUser().getOrg_level_name();
|
case "COMPANY_UUID": // 公司uuid
|
return SpringMVCContextHolder.getCurrentUser().getOrg_level_uuid();
|
case "DEPT_CODE": // 部门编码
|
return SpringMVCContextHolder.getCurrentUser().getCurrentDept().getString("org_level_code");
|
case "DEPT_NAME": // 部门名称
|
return SpringMVCContextHolder.getCurrentUser().getCurrentDept().getString("org_level_name");
|
case "DEPT_UUID": // 部门uuid
|
return SpringMVCContextHolder.getCurrentUser().getDept_uuid();
|
case "POST_UUID": // 岗位uuid
|
return SpringMVCContextHolder.getCurrentUser().getPost();
|
case "ROLE_UUID": // 角色UUID
|
return SpringMVCContextHolder.getCurrentUser().getRoles();
|
default:
|
return key;
|
}
|
} catch (Exception e) {
|
e.printStackTrace();
|
throw new BaseException(SystemCode.SYSTEM_SYS_PARAM_ACQUIRE_FAIL.getText(),
|
SystemCode.SYSTEM_SYS_PARAM_ACQUIRE_FAIL.getValue(), SystemParamReplace.class,
|
"replaceSystemParameter");
|
}
|
}
|
}
|
