expdocument.java

OBPM是一个开源

package cn.myapps.core.expimp.exp.ejb;

import java.util.ArrayList;
import java.util.Collection;
import java.util.LinkedHashMap;
import java.util.Map;

import cn.myapps.core.expimp.exp.util.SQLPackage;

public class ExpDocument extends ExpElement {
	public ExpDocument(boolean expAll) {
		super(expAll);
	}

	public final static String NAME = "T_DOCUMENT";

	public final static String ITEM_NAME = "T_ITEM";

	public final static String FOREINGKEY_COLUMN_STATE = "STATE";

	public final static String FOREINGKEY_COLUMN_AUTHOR = "AUTHOR";

	public Map exportDocSQLS(String[] formids, Collection ignoreIds)
			throws Exception {

		ArrayList newformids = new ArrayList();

		for (int i = 0; i < formids.length; i++) {
			if (ignoreIds.contains("doc_" + formids[i])) {
				continue;
			} else {
				ignoreIds.add("doc_" + formids[i]);

				newformids.add(formids[i]);
			}
		}

		Map rtn = new LinkedHashMap();

		if (newformids.size() > 0) {
			StringBuffer sqlBuffer = new StringBuffer();

			// cndtn
			StringBuffer cndtn = new StringBuffer();
			cndtn.append(" WHERE formid IN (");
			for (int i = 0; i < newformids.size(); i++) {
				cndtn.append("'" + newformids.get(i) + "'");
				if (i < newformids.size() - 1) {
					cndtn.append(",");
				}
			}
			cndtn.append(")");
			
			// 父document
			sqlBuffer.append("SELECT * FROM " + NAME);
			sqlBuffer.append(cndtn);
			sqlBuffer.append(" AND parent is null");

			SQLPackage sqlPackage = new SQLPackage(NAME, sqlBuffer.toString());

			sqlPackage.addRestColumn(FOREINGKEY_COLUMN_STATE);
			sqlPackage.addRestColumn(FOREINGKEY_COLUMN_AUTHOR);
			rtn.put("document_parent_" + newformids, sqlPackage);

			// 子document
			sqlBuffer = new StringBuffer();

			sqlBuffer.append("SELECT * FROM " + NAME);
			sqlBuffer.append(cndtn);
			sqlBuffer.append(" AND parent is not null");

			sqlPackage = new SQLPackage(NAME, sqlBuffer.toString());
			sqlPackage.addRestColumn(FOREINGKEY_COLUMN_STATE);
			sqlPackage.addRestColumn(FOREINGKEY_COLUMN_AUTHOR);
			rtn.put("document_child", sqlPackage);

			// document item
			sqlBuffer = new StringBuffer();
			sqlBuffer.append("SELECT * FROM " + ITEM_NAME);
			sqlBuffer.append(" WHERE doc_id in (");
			sqlBuffer.append("SELECT id FROM " + NAME + " ");
			sqlBuffer.append(cndtn + " )");
			
			SQLPackage sqlPackage2 = new SQLPackage(ITEM_NAME, sqlBuffer.toString());
			rtn.put("document_item" + newformids, sqlPackage2);
		}

		return rtn;
	}

	public String getName() {
		return NAME;
	}

	public Map exportSQLS(String[] ids, Collection ignoreIds) throws Exception {
		return null;
	}
}