页面历史

package smartbi.freequery.expression.function;
import smartbi.SmartbiException;
import smartbi.freequery.metadata.SQLPart;
import smartbi.freequery.metadata.SQLPartList;
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;
	}
	protected void prepareParams() {
		try {
			super.prepareParams();
		} catch (SmartbiException e) {
			result = new SQLPartList();
		}
	}
	@Override
	public void execute() {
		try {
			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()));
		} catch (Exception e) {
			result.add(new SQLPart(SQLPartType.SQLUnknown," 1=1 "));
		}
	}
	
	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 "";
	}
}