package com.saas.biz.studyMgr;

import java.util.ArrayList;
import java.util.HashMap;

import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.studyDAO.StudyDAO;
import com.saas.biz.dao.studyDAO.StudyExt;
import com.saas.sys.buffer.Buffers;
import com.saas.sys.dbm.Dbtable;
import com.saas.sys.exp.SaasApplicationException;
import com.saas.sys.log.Logger;

public class StudyInfo{
	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	Dbtable tradeQuery;

	commMethodMgr commen;

	ArrayList queryResult = new ArrayList();

	public StudyInfo() {
		log = new Logger(this);
		tradeQuery = new Dbtable();
		commen = new commMethodMgr();
		outBuffer = new Buffers();
	}

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

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

	public void setTradeQuery(Dbtable tradeQuery) {
		this.tradeQuery = tradeQuery;
	}

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

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

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

	// 新增上報文件
	public void addStudyInfo(Buffers inbuffer) {
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("進入addReportInfo方法...");
		int iResult = -1;
		StudyDAO departDao = new StudyDAO();
		String id = inbuffer.getString("IDX");
		String content = inbuffer.getString("CONTENT");
		String part = inbuffer.getString("DEPART_CODE");
		String path = inbuffer.getString("PATH");
		String rpart = "";
		String title = inbuffer.getString("TITLE");
		String user_name = inbuffer.getString("SESSION_USER_NAME");
		departDao.setId(id);
		departDao.setContent(content);
		departDao.setPart(part);
		departDao.setPath(path);
		departDao.setRpart(rpart);
		departDao.setTitle(title);
		departDao.setUser(user_name);
		departDao.setChecked(0);// 0：代表上級未處理 1:已處理
		iResult = addStudyInfo(departDao);
		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("退出addReportInfo方法...");
	}

	public int addStudyInfo(StudyDAO departDao) {
		StudyExt repExt = new StudyExt();
		repExt.setParam(":VID", departDao.getId());
		repExt.setParam(":VCONTENT", departDao.getContent());
		repExt.setParam(":VPART", departDao.getPart());
		repExt.setParam(":VPATH", departDao.getPath());
		repExt.setParam(":VRPART", departDao.getRpart());
		repExt.setParam(":VTITLE", departDao.getTitle());
		repExt.setParam(":VUSER", departDao.getUser());
		repExt.setParam(":VCHECKED", departDao.getChecked());
		tradeQuery.executeBy(repExt.insBy("INS_BY_ALL"));
		return 0;
	}

	public ArrayList getStudyInfoByPartOrUser(int iStart, String user, String part) throws SaasApplicationException {
		iStart=iStart*20;
		ArrayList studyList = new ArrayList();
		StudyExt repExt = new StudyExt();
		repExt.setParam(":VUSER", user);
		repExt.setParam(":VPART", part);
		studyList = repExt.selByList("SEL_BY_USERORPART", iStart, 20);
		return studyList;
	}

	public ArrayList getStudyInfoById(String id) throws SaasApplicationException {
		ArrayList studyList = new ArrayList();
		StudyExt repExt = new StudyExt();
		repExt.setParam(":VID", id);
		studyList = repExt.selByList("SEL_BY_ID");
		return studyList;
	}

	public int getStudyInfoByPartOrUserCT(String user, String part) throws SaasApplicationException {
		int size = 0;
		ArrayList studyList = new ArrayList();
		StudyExt repExt = new StudyExt();
		repExt.setParam(":VUSER", user);
		repExt.setParam(":VPART", part);
		studyList = repExt.selByList("SEL_BY_USERORPART_COUNT");
		if (studyList != null && studyList.size() > 0) {
			HashMap map=(HashMap)studyList.get(0);
			if(map.get("ct")!=null){
				size=Integer.parseInt(map.get("ct").toString());
			}
		}
		return size;
	}
}