package cn.autoform.web.client.util;
|
|
import cn.autoform.bean.form.autowhere.ScreenCondition;
|
import cn.autoform.bean.form.autowhere.ScreenCondition.Condition;
|
import cn.autoform.bean.form.autowhere.ScreenCondition.Condition.Type;
|
import cn.autoform.util.form.AutoConditionUtil;
|
import cn.autoform.util.tool.JSONTool;
|
import cn.autoform.util.tool.ObjectUtil;
|
import com.googlecode.aviator.AviatorEvaluator;
|
import com.googlecode.aviator.exception.CompileExpressionErrorException;
|
import com.googlecode.aviator.runtime.function.AbstractFunction;
|
import com.googlecode.aviator.runtime.type.AviatorBoolean;
|
import com.googlecode.aviator.runtime.type.AviatorObject;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.util.PropertyPlaceholderHelper;
|
import org.springframework.util.SystemPropertyUtils;
|
|
import java.util.ArrayList;
|
import java.util.List;
|
import java.util.Map;
|
import java.util.Objects;
|
import java.util.regex.Matcher;
|
import java.util.regex.Pattern;
|
|
@Slf4j
|
public class FormatParsingTool {
|
|
static {
|
AviatorEvaluator.addFunction(new AbstractFunction(){
|
|
@Override
|
public String getName() {
|
return "if";
|
}
|
|
@Override
|
public AviatorObject call(Map<String, Object> env, AviatorObject arg1, AviatorObject arg2, AviatorObject arg3) {
|
return arg1.booleanValue(env) ? arg2 : arg3;
|
}
|
});
|
|
AviatorEvaluator.addFunction(new AbstractFunction(){
|
|
@Override
|
public String getName() {
|
return "empty";
|
}
|
|
@Override
|
public AviatorObject call(Map<String, Object> env, AviatorObject arg1) {
|
return AviatorBoolean.valueOf(ObjectUtil.empty(arg1.stringValue(env)));
|
}
|
});
|
}
|
public static void main(String... args){
|
System.out.println(AviatorEvaluator.execute("\nif(empty(''), \"\", \"and budget_project = ''\")\n".replace("", "")));
|
}
|
public static void main1(String... args){
|
System.out.println(parsingExpression(
|
JSONTool.toObj("{\n" +
|
" \"child\":[\n" +
|
" {\n" +
|
" \"fieldKey\":\"budget_project\",\n" +
|
" \"side\":\"thi\",\n" +
|
" \"pIndex\":0,\n" +
|
" \"value\":\"\"\n" +
|
" },\n" +
|
" {\n" +
|
" \"fieldKey\":\"budget_project\",\n" +
|
" \"side\":\"ref\",\n" +
|
" \"pIndex\":1\n" +
|
" },\n" +
|
" {\n" +
|
" \"fieldKey\":\"budget_project\",\n" +
|
" \"side\":\"thi\",\n" +
|
" \"pIndex\":2,\n" +
|
" \"value\":\"\"\n" +
|
" },\n" +
|
" {\n" +
|
" \"fieldKey\":\"budgetStartDate\",\n" +
|
" \"side\":\"thi\",\n" +
|
" \"pIndex\":3,\n" +
|
" \"value\":\"2018-10-19\"\n" +
|
" },\n" +
|
" {\n" +
|
" \"fieldKey\":\"budgetStartDate\",\n" +
|
" \"side\":\"ref\",\n" +
|
" \"pIndex\":4\n" +
|
" }\n" +
|
" ],\n" +
|
" \"count\":\"processstate = 30 \n" +
|
"and stateExecution=\\\"\\\" \n" +
|
"$(\n" +
|
"if(empty({0}), \\\"\\\", \\\"and {1} = {2}\\\")\n" +
|
") \n" +
|
"and {3} > {4}\"\n" +
|
" }", ScreenCondition.class)
|
));
|
}
|
|
public static String parsingExpression(ScreenCondition screenCondition){
|
String val = parsing(screenCondition);
|
if(ObjectUtil.empty(val)){
|
return val;
|
}
|
PropertyPlaceholderHelper p = new PropertyPlaceholderHelper(
|
"$("
|
, ")"
|
, SystemPropertyUtils.VALUE_SEPARATOR
|
, true);
|
return p.replacePlaceholders(val, (expression)->{
|
try {
|
return Objects.toString(AviatorEvaluator.execute(Objects.toString(expression, "").replace("\n", "")));
|
}catch (CompileExpressionErrorException e){
|
log.error(e.getMessage(), e);
|
throw e;
|
}
|
});
|
}
|
|
public static String parsing(ScreenCondition screenCondition){
|
List<Condition> child = screenCondition.getChild();
|
String count = screenCondition.getCount();
|
List<String> li = null;
|
if(child.size()> 0){
|
li = new ArrayList<>();
|
for(Condition m : child){
|
if(m.getSide() == Type.thi){
|
li.add("'"+ getVal(m.getValue())+ "'");
|
}else{
|
li.add(m.getFieldKey());
|
}
|
}
|
count = screenCondition.getCount();
|
|
}
|
if( null == count || "".equals(count) || count.contains(" or 1=1 ")){
|
return null;
|
}else{
|
return parsingString(count, li);
|
}
|
}
|
|
public static String getVal(Object val){
|
if(val instanceof String)
|
return AutoConditionUtil.escapeSql(val);
|
else if(val instanceof List<?>){
|
if(((List<?>)val).size() == 1){
|
return AutoConditionUtil.escapeSql(((List<?>)val).get(0));
|
}else if(((List<?>)val).size() > 1){
|
final StringBuilder vals = new StringBuilder();
|
((List<?>)val).stream().filter(v->vals.append(',') != null).forEach(vals::append);
|
return AutoConditionUtil.escapeSql(vals.toString().replaceAll("^,", ""));
|
}
|
}
|
return "";
|
}
|
|
public static String parsingString(String count, List<?> li){
|
Pattern pattern = Pattern.compile("[{][^}]+[}]");
|
Matcher matcher = pattern.matcher(count);
|
String group = null;
|
Integer index = null;
|
while(matcher.find()){
|
group = matcher.group();
|
index = Integer.parseInt(group.replaceAll("[{]|[}]", ""));
|
count = count.replace(group, (CharSequence) li.get(index));
|
}
|
return count;
|
}
|
|
}
|
