页面历史

package smartbi.freequery.expression.function;
import smartbi.freequery.metadata.SQLPart;
import smartbi.freequery.util.SQLPartType;
import smartbi.util.StringUtil;
public class Process1000LimitOfIn extends Function {
	@Override
	public boolean checkParams() {
		if (params.length==2) 
			return true;
		else
			return false;
	}
	@Override
	public void execute() {
		String fieldName  = params[0].getSqlStr().trim();
		fieldName = trim(fieldName,"\"");
		fieldName = trim(fieldName,"'");
		String fieldValue = params[1].getSqlStr().trim();
		String sep = ",";
		String[] fieldValueArray = fieldValue.split(sep);
		int size = 1000;
		long count = Math.round(Math.ceil(((double)fieldValueArray.length)/size));
		if(count ==1){
			result.add(new SQLPart(SQLPartType.SQLSTR, fieldName + " in (" + fieldValue +")"));
			return;
		}
		//TODO 
		StringBuilder sqlSb = new StringBuilder();
		sqlSb.append("(");
		for(int i =0; i<count; i++){
			int jLen = (i+1)*size ;
			jLen = (jLen>fieldValueArray.length)?fieldValueArray.length:jLen;
			StringBuilder sb = new StringBuilder();
			for(int j = i*size; j<jLen; j++){
				sb.append(fieldValueArray[j]).append(sep);
			}
			String sbStr = sb.toString();
			if(i>0){
				sqlSb.append(" or ");
			}
			sqlSb.append(fieldName + " in (" + sbStr.substring(0, sbStr.length()-sep.length())+")");
		}
		sqlSb.append(" ) ");
		result.add(new SQLPart(SQLPartType.SQLSTR, sqlSb.toString()));
	}
	
	private String trim(String srcStr, String toTrimStr){
		if(StringUtil.isNullOrEmpty(srcStr)){
			return srcStr;
		}
		srcStr = srcStr.trim();
		while(srcStr.startsWith(toTrimStr)){
			srcStr = srcStr.substring(toTrimStr.length());
			srcStr = srcStr.trim();
		}
		while(srcStr.endsWith(toTrimStr)){
			srcStr = srcStr.substring(0, srcStr.length()-toTrimStr.length());
			srcStr = srcStr.trim();
		}
		return srcStr;
	}
	@Override
	public String getMDXValue() {
		return "";
	}
}