com.scudata.ide.spl.etl.element.FXlsImport Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of esproc Show documentation
SPL(Structured Process Language) A programming language specially for structured data computing.
There is a newer version: 20240823
package com.scudata.ide.spl.etl.element;

import java.util.ArrayList;
import java.util.StringTokenizer;

import com.scudata.chart.Consts;
import com.scudata.common.StringUtils;
import com.scudata.ide.spl.etl.EtlConsts;
import com.scudata.ide.spl.etl.ObjectElement;
import com.scudata.ide.spl.etl.ParamInfo;
import com.scudata.ide.spl.etl.ParamInfoList;

/**
 * ?????????༭ f.xlsimport()
 * ??????ǰ׺F??ʾ?ļ?????
 * 
 * @author Joancy
 *
 */
public class FXlsImport extends ObjectElement {
	public ArrayList fields;
	public String sheetName;
	
	public String argb,arge;

	public String password;

	public boolean t;
	public boolean c;
	public boolean b;
	public boolean w;
	public boolean p;
	public boolean n;
	public boolean s;

	/**
	 * ??ȡ???ڽ???༭?Ĳ?????Ϣ?б?
	 */
	public ParamInfoList getParamInfoList() {
		ParamInfoList paramInfos = new ParamInfoList();
		ParamInfo.setCurrent(FXlsImport.class, this);

		paramInfos.add(new ParamInfo("fields", EtlConsts.INPUT_STRINGLIST));
		paramInfos.add(new ParamInfo("sheetName"));
		paramInfos.add(new ParamInfo("argb"));
		paramInfos.add(new ParamInfo("arge"));
		paramInfos.add(new ParamInfo("password"));
		
		String group = "options";
		paramInfos.add(group, new ParamInfo("t", Consts.INPUT_CHECKBOX));
		paramInfos.add(group, new ParamInfo("c", Consts.INPUT_CHECKBOX));
		paramInfos.add(group, new ParamInfo("b", Consts.INPUT_CHECKBOX));
		paramInfos.add(group, new ParamInfo("w", Consts.INPUT_CHECKBOX));
		paramInfos.add(group, new ParamInfo("p", Consts.INPUT_CHECKBOX));
		paramInfos.add(group, new ParamInfo("n", Consts.INPUT_CHECKBOX));
		paramInfos.add(group, new ParamInfo("s", Consts.INPUT_CHECKBOX));

		return paramInfos;
	}

	/**
	 * ??ȡ??????
	 * ???͵ĳ???????Ϊ
	 * EtlConsts.TYPE_XXX
	 * @return EtlConsts.TYPE_FILE
	 */
	public byte getParentType() {
		return EtlConsts.TYPE_FILE;
	}

	/**
	 * ??ȡ?ú????ķ???????
	 * @return ????ѡ?????Ӧ????
	 */
	public byte getReturnType() {
		if(c){
			return EtlConsts.TYPE_CURSOR;
		}
		if(s){
			return EtlConsts.TYPE_STRING;
		}
		return EtlConsts.TYPE_SEQUENCE;
	}

	/**
	 * ??ȡ????????SPL????ʽ?ĺ?????
	 */
	public String getFuncName(){
		return "xlsimport";
	}
	
	/**
	 * ??ȡ????????SPL????ʽ??ѡ?
	 */
	public String optionString(){
		StringBuffer options = new StringBuffer();
		if(t){
			options.append("t");
		}
		if(c){
			options.append("c");
		}else if(b){
			options.append("b");//@cʱ??֧??
		}
		boolean existTCB = t|c|b;
		if(!existTCB & w){
			options.append("w");//??@t@c@b????
			if(p){
				options.append("p");//wʱ??????
			}
		}
		if(n){
			options.append("n");
		}
		if(s){
			options.append("s");
		}
		
		return options.toString();
	}
	
	/**
	 * ??ȡ????????SPL????ʽ?ĺ?????
	 * ??setFuncBody???溯????Ȼ?????ʽ?ĸ?ֵҲ???ǻ????
	 */
	public String getFuncBody() {
		StringBuffer sb = new StringBuffer();
		String sfields = getStringListExp(fields,",");
		if(StringUtils.isValidString(sfields)){
			sb.append(sfields);
		}
		
		StringBuffer suffix = new StringBuffer();
		if(StringUtils.isValidString(sheetName)){
			suffix.append( getParamExp(sheetName) );
		}
		
		String be="";
		if(StringUtils.isValidString(argb)){
			be = getNumberExp(argb);
		}
		if(StringUtils.isValidString(arge)){
			be += ":";
			be += getNumberExp(arge);
		}
		
		if(StringUtils.isValidString(be)){
			suffix.append(",");
			suffix.append(be);
		}
		
		if(StringUtils.isValidString(password)){
			suffix.append(";");
			suffix.append(getParamExp(password));
		}

		if(suffix.length()>0){
			sb.append(";");
			sb.append(suffix.toString());
		}

		return sb.toString();
	}

	/**
	 * ???ú?????
	 * @param funcBody ??????
	 */
	public boolean setFuncBody( String funcBody ) {
		StringTokenizer st = new StringTokenizer(funcBody,";");
		fields = getStringList(st.nextToken(),",");
		String buf;
		if(st.hasMoreTokens()){
			buf = st.nextToken();
			if(isValidString(buf)){
				StringTokenizer st2 = new StringTokenizer(buf,",");
				sheetName = getParam(st2.nextToken());
				if(st2.hasMoreTokens()){
					buf = st2.nextToken();
					st2 = new StringTokenizer(buf,":");
					buf = st2.nextToken();
					if(isValidString(buf)){
						argb = getNumber( buf );
					}
					if(st2.hasMoreTokens()){
						arge = getNumber(st2.nextToken());
					}
				}
			}
		}
		
		if( st.hasMoreTokens()){
			buf = st.nextToken();
			password = getParam( buf );
		}
		return true;
	}

}