package com.saas.biz.letterMgr;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.StringTokenizer;

import com.saas.biz.commen.commMethodMgr;
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.letterDAO.*;
import com.saas.biz.dao.userDAO.UserExt;

public class LetterInfo {
	
	
	Dbtable tradeQuery;
	
	
	Logger log;
	
	
	Buffers inBuffer;
	
	
	Buffers outBuffer;
	
	
	ArrayList queryResult = new ArrayList();
	
	
	commMethodMgr comm;
	
	
	
	public LetterInfo() {

		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 addLetterInfo(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("進(jìn)入addLetterInfo方法...");
		String reuser = inbuffer.getString("REUSER");
		String title = inbuffer.getStringWeb("TITLE");
		String content = inbuffer.getStringWeb("CONTENT");
		String path = inbuffer.getString("PATH");
		;
		String user_id = inbuffer.getString("SESSION_USER_NAME");
		String depart_code = inbuffer.getString("DEPART_CODE");
		int iResult = -1;
		try {
			iResult = addLetterInfo(reuser, title, content, path, user_id, depart_code);
		}
		catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "業(yè)務(wù)處理失敗！");
			
		}
		else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "業(yè)務(wù)處理成功！");
		}
		log.LOG_INFO("退出addLetterInfo方法...");
	}
	
	
	public int addLetterInfo(String reuser, String title, String content, String path, String send, String depart_code) throws SaasApplicationException {

		StringTokenizer user = new StringTokenizer(reuser, ",");
		while (user.hasMoreElements()) {
			String accept = String.valueOf(user.nextElement());
			
			String trade_id = comm.GenTradeId();
			String rpart = getUserPartByName(accept);
			if (rpart != null && !rpart.equals("")) {
				saveInfo(trade_id, send, accept, title, content, path, depart_code);
			}
			
		}
		return 0;
	}
	
	
	
	/**
	 * @param user
	 *            :發(fā)信人
	 * @param rpart:收信人
	 * @param part
	 *            :發(fā)信人部門
	 * @return
	 */
	public int saveInfo(String trade_id, String send, String accept, String title, String content, String path, String part) {

		LetterExt letterExt = new LetterExt();
		letterExt.setParam(":VID", trade_id);
		letterExt.setParam(":VTITLE", title);
		letterExt.setParam(":VCONTENT", content);
		letterExt.setParam(":VPATH", path);
		letterExt.setParam(":VRPART", accept);
		letterExt.setParam(":VUSER", send);
		letterExt.setParam(":VPART", part);
		letterExt.setParam(":VCHECKED", "0");// 未讀 1 已讀
		tradeQuery.executeBy(letterExt.insBy("INS_BY_ALL"));
		return 0;
	}
	
	
	public void addLetterInfoMsg(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("進(jìn)入addLetterInfo方法...");
		String reuser = inbuffer.getString("REUSER");
		String title = inbuffer.getString("TITLE");
		String content = inbuffer.getString("CONTENT");
		String path = inbuffer.getString("PATH");
		String trade_id = comm.GenTradeId();
		String send = inbuffer.getString("SESSION_USER_NAME");
		String depart_code = inbuffer.getString("DEPART_CODE");
		int iResult = -1;
		try {
			iResult = saveInfo(trade_id, send, reuser, title, content, path, depart_code);
		}
		catch (Exception e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "業(yè)務(wù)處理失敗！");
			
		}
		else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "業(yè)務(wù)處理成功！");
		}
		log.LOG_INFO("退出addLetterInfo方法...");
	}
	
	
	public ArrayList getLetterList(String strUserid) throws SaasApplicationException {

		ArrayList itemsList = new ArrayList();
		LetterExt letterExt = new LetterExt();
		letterExt.setParam(":VUSER", strUserid);
		itemsList = letterExt.selByList("SEL_BY_USER");
		return itemsList;
	}
	
	
	public ArrayList getLetterById(String id) throws SaasApplicationException {

		ArrayList itemsList = new ArrayList();
		LetterExt letterExt = new LetterExt();
		letterExt.setParam(":VID", id);
		itemsList = letterExt.selByList("SEL_BY_ID");
		return itemsList;
	}
	
	
	public ArrayList getLetterByPath(String path) throws SaasApplicationException {

		ArrayList itemsList = new ArrayList();
		LetterExt letterExt = new LetterExt();
		letterExt.setParam(":VPATH", path);
		itemsList = letterExt.selByList("SEL_BY_PATH");
		return itemsList;
	}
	
	
	
	// 分頁 查詢
	public ArrayList getLetterListByUser(int iStart, String strUserid) throws SaasApplicationException {

		iStart = iStart*20;
		ArrayList itemsList = new ArrayList();
		LetterExt letterExt = new LetterExt();
		letterExt.setParam(":VRPART", strUserid);
		itemsList = letterExt.selByList("SEL_BY_RPART", iStart, 20);
		return itemsList;
	}
	
	
	
	// 分頁 統(tǒng)計
	public int getLetterSumByRpart(String rpart) throws SaasApplicationException {

		int size = 0;
		ArrayList itemsList = new ArrayList();
		LetterExt letterExt = new LetterExt();
		letterExt.setParam(":VRPART", rpart);
		itemsList = letterExt.selByList("SEL_RPART_CT");
		if (itemsList != null && itemsList.size() > 0) {
			HashMap map = (HashMap) itemsList.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
	
	
	
	// 找出用戶part
	public String getUserPartByName(String user_name) throws SaasApplicationException {

		String part = "";
		UserExt UserExt = new UserExt();
		UserExt.setParam(":VUSER_NAME", user_name);
		ArrayList list = UserExt.selByList("SEL_BY_NAME");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			if (map.get("depart_code") != null)
				part = map.get("depart_code").toString();
		}
		
		return part;
	}
}