package com.saas.biz.repositoryMgr;

import java.util.ArrayList;
import java.util.HashMap;
import com.saas.biz.attachMgr.Attachinfo;
import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.repositoryDAO.RepositoryDAO;
import com.saas.biz.dao.repositoryDAO.RepositoryExt;
import com.saas.sys.buffer.Buffers;
import com.saas.sys.dbm.Dbtable;
import com.saas.sys.exp.SaasApplicationException;
import com.saas.sys.log.Logger;
import com.saas.biz.dao.enquirytrackDAO.EnquirytrackExt;
import com.saas.biz.dao.productclassDAO.ProductclassExt;

/**
 * @author:WangYang
 * @desc: 知識庫信息
 * @2008-7-9
 */
public class RepositoryInfo {
	
	
	Dbtable tradeQuery;
	
	
	Logger log;
	
	
	Buffers inBuffer;
	
	
	Buffers outBuffer;
	
	
	ArrayList queryResult = new ArrayList();
	
	commMethodMgr comm;
	
	public RepositoryInfo() {

		log = new Logger(this);
		tradeQuery = new Dbtable();
		comm=new commMethodMgr();
	}
	
	
	public void setTradeQuery(Dbtable tradeQuery) {

		this.tradeQuery = tradeQuery;
	}
	
	
	public Dbtable getTradeQuery() {

		return this.tradeQuery;
	}
	
	
	public void setOutBuffer(Buffers outBuffer) {

		this.outBuffer = outBuffer;
	}
	
	
	public Buffers getOutBuffer() {

		return this.outBuffer;
	}
	
	
	public ArrayList getQueryResult() {

		return this.queryResult;
	}
	
	
	public void setQueryResult(ArrayList queryResult) {

		this.queryResult = queryResult;
	}
	
	
	public void genCustRepository(Buffers inbuffer) {

		log.LOG_INFO("進入genCustRepository方法...");
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String query_param = inbuffer.getString("QUERY_PARAM");
		try {
			if (query_param.equals(""))
				this.queryResult = genCustRepository(cust_id);
			else
				this.queryResult = searchRepoitory(query_param, cust_id);
		}
		catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());
		}
		log.LOG_INFO("退出ggenCustRepository方法...");
	}
	
	
	public ArrayList genCustRepository(String cust_id) throws SaasApplicationException {

		ArrayList itemsList = new ArrayList();
		RepositoryExt repositoryExt = new RepositoryExt();
		repositoryExt.setParam(":VCUST_ID", cust_id);
		repositoryExt.setParam(":VVALIDITY", "0");
		itemsList = repositoryExt.selByList("SEL_BY_CUST");
		return itemsList;
	}
	
	
	
	// 單個
	public void genOneRepository(Buffers inbuffer) {

		log.LOG_INFO("進入genCustRepository方法...");
		String repository_id = inbuffer.getString("REPOSITORY_ID");
		try {
			this.queryResult = genOneRepository(repository_id);
		}
		catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());
		}
		log.LOG_INFO("退出ggenCustRepository方法...");
	}
	
	
	public ArrayList genOneRepository(String repository_id) throws SaasApplicationException {

		ArrayList itemsList = new ArrayList();
		RepositoryExt repositoryExt = new RepositoryExt();
		repositoryExt.setParam(":VREPOSITORY_ID", repository_id);
		itemsList = repositoryExt.selByList("SEL_BY_PK");
		return itemsList;
	}
	
	
	
	// 獲取科技論文列表
	public void genSpecRepository(Buffers inbuffer) {

		log.LOG_INFO("進入genSpecRepository方法...");
		try {
			this.queryResult = genSpecRepository();
		}
		catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());
		}
		log.LOG_INFO("退出genRepository方法...");
	}
	
	
	public ArrayList genSpecRepository() throws SaasApplicationException {

		ArrayList repositoryList = new ArrayList();
		RepositoryExt repositoryExt = new RepositoryExt();
		repositoryList = repositoryExt.selByList("SEL_BY_SPEC");
		
		return repositoryList;
	}
	
	
	
	// 新增學院信息
	public void addRepositoryInfo(Buffers inbuffer) {

		log.LOG_INFO("進入addRepositoryInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		RepositoryDAO respositorydao = new RepositoryDAO();
		respositorydao.setRepository_id(inbuffer.getString("REPOSITORY_ID"));
		respositorydao.setContent(inbuffer.getString("CONTENT"));
		respositorydao.setTitle(inbuffer.getString("TITLE"));
		respositorydao.setRepository_type(inbuffer.getString("REPOSITORY_TYPE"));
		respositorydao.setPublish_user_id(inbuffer.getString("SESSION_USER_ID"));
		respositorydao.setCust_id(inbuffer.getString("SESSION_CUST_ID"));
		respositorydao.setRepository_class(inbuffer.getString("REPOSITORY_CLASS"));
		int iResult = -1;
		try {
			iResult = addRepositoryInfo(respositorydao);
			
		}
		catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "業務處理失敗！");
		}
		else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "業務處理成功！");
		}
		log.LOG_INFO("退出addRepositoryInfo方法...");
	}
	
	
	
	// 新增知識庫信息
	public void addRepositoryInfoBySort(Buffers inbuffer) {

		log.LOG_INFO("進入addRepositoryInfoBySort方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		String sort = "";
		RepositoryDAO respositorydao = new RepositoryDAO();
		respositorydao.setRepository_id(inbuffer.getString("REPOSITORY_ID"));
		respositorydao.setContent(inbuffer.getString("CONTENT"));
		respositorydao.setTitle(inbuffer.getString("TITLE"));
		respositorydao.setCust_id(inbuffer.getString("SESSION_CUST_ID"));
		respositorydao.setRepository_type(inbuffer.getString("REPOSITORY_TYPE"));
		respositorydao.setPublish_user_id(inbuffer.getString("SESSION_USER_ID"));
		try {
			if (inbuffer.isFieldExist("SORT1") && inbuffer.getString("SORT1") != null) {
				sort = inbuffer.getString("SORT1");
			}
			if (hasChildren(sort)) {
				if (inbuffer.isFieldExist("SORT2") && inbuffer.getString("SORT2") != null) {
					sort = inbuffer.getString("SORT2");
				}
			}
			if (hasChildren(sort)) {
				if (inbuffer.isFieldExist("SORT3") && inbuffer.getString("SORT3") != null) {
					sort = inbuffer.getString("SORT3");
				}
			}
			respositorydao.setRepository_class(sort);
		}
		catch (Exception ex) {
			log.LOG_INFO("分類信息出錯......." + ex.getMessage());
		}
		int iResult = -1;
		try {
			iResult = addRepositoryInfo(respositorydao);
		}
		catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "業務處理失敗！");
		}
		else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "業務處理成功！");
		}
		log.LOG_INFO("退出addRepositoryInfoBySort方法...");
	}
	
	
	public int addRepositoryInfo(RepositoryDAO respositorydao) throws SaasApplicationException {

		RepositoryExt repositoryExt = new RepositoryExt();
		String content=respositorydao.getContent();
		comm.setTextYin(content);
		repositoryExt.setParam(":VREPOSITORY_ID", respositorydao.getRepository_id());
		repositoryExt.setParam(":VTITLE", respositorydao.getTitle());
		repositoryExt.setParam(":VCONTENT", content);
		repositoryExt.setParam(":VREPOSITORY_TYPE", respositorydao.getRepository_type());
		repositoryExt.setParam(":VPUBLISH_USER_ID", respositorydao.getPublish_user_id());
		repositoryExt.setParam(":VCUST_ID", respositorydao.getCust_id());
		repositoryExt.setParam(":VVALIDITY", "0");
		repositoryExt.setParam(":VREPOSITORY_CLASS", respositorydao.getRepository_class());
		repositoryExt.setParam(":VAUDIT_USER_ID", "");
		repositoryExt.setParam(":VREMARK", "");
		log.LOG_INFO("知識庫信息完成........");
		tradeQuery.executeBy(repositoryExt.insBy("INS_BY_ALL"));
		this.outBuffer.setString("ROOT_ID", respositorydao.getRepository_id());
		return 0;
	}
	
	
	
	// 修改
	public void modRepositoryInfo(Buffers inbuffer) {

		log.LOG_INFO("進入addRepositoryInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		RepositoryDAO respositorydao = new RepositoryDAO();
		respositorydao.setContent(inbuffer.getString("CONTENT"));
		respositorydao.setTitle(inbuffer.getString("TITLE"));
		respositorydao.setRepository_id(inbuffer.getString("REPOSITORY_ID"));
		respositorydao.setRepository_type(inbuffer.getString("REPOSITORY_TYPE"));