package com.saas.biz.reportsMgr;

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

import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.reportsDAO.ReportsDAO;
import com.saas.biz.dao.reportsDAO.ReportsExt;
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 ReportsInfo{
	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	Dbtable tradeQuery;

	commMethodMgr commen;

	ArrayList queryResult = new ArrayList();

	public ReportsInfo() {
		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 addReportInfo(Buffers inbuffer) {
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("進入addReportInfo方法...");
		int iResult = -1;
		ReportsDAO departDao = new ReportsDAO();
		String id = inbuffer.getString("IDX");
		String content = inbuffer.getString("CONTENT");
		String part = inbuffer.getString("PART");
		String path = inbuffer.getString("PATH");
		String rpart = inbuffer.getString("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.setXchecked(0);// 0：代表上級未處理 1:已處理
		iResult = addReportInfo(departDao);
		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("退出addReportInfo方法...");
	}

	public int addReportInfo(ReportsDAO departDao) {
		ReportsExt repExt = new ReportsExt();
		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(":VXCHECKED", departDao.getXchecked());
		tradeQuery.executeBy(repExt.insBy("INS_BY_ALL"));
		return 0;
	}

	// 通過部門編號（審核上報文件）
	public ArrayList getReportInfoByDepartCode(int iStart, String departCode, String check) throws SaasApplicationException {
		ArrayList reportList = new ArrayList();
		ReportsExt repExt = new ReportsExt();
		try {
			iStart=iStart*20;
			repExt.setParam(":VRPART", departCode);
			repExt.setParam(":VXCHECKED", check);
			reportList = repExt.selByList("SEL_BY_RPART", iStart, 20);
		}
		catch (Exception e) {
			log.LOG_INFO(e.getMessage());
		}
		return reportList;
	}

	public int getReportInfoByDepartCodeCT(String departCode, String check) throws SaasApplicationException {
		ArrayList reportList = new ArrayList();
		ReportsExt repExt = new ReportsExt();
		int size = 0;
		try {

			repExt.setParam(":VRPART", departCode);
			repExt.setParam(":VXCHECKED", check);
			reportList = repExt.selByList("SEL_BY_RPART_COUNT");
			if (reportList != null && reportList.size() > 0) {
				HashMap map = (HashMap) reportList.get(0);
				if (map.get("ct") != null) {
					size = Integer.parseInt(map.get("ct").toString());
				}
			}
		}
		catch (Exception e) {
			log.LOG_INFO(e.getMessage());
		}
		return size;
	}

	// 審批查詢（自己上報的文件）
	public ArrayList getReportInfoByUser(String user, String check) throws SaasApplicationException {
		ArrayList reportList = new ArrayList();
		ReportsExt repExt = new ReportsExt();
		try {
			repExt.setParam(":VUSER", user);
			repExt.setParam(":VXCHECKED", check);
			reportList = repExt.selByList("SEL_BY_USER");
		}
		catch (Exception e) {
			log.LOG_INFO(e.getMessage());
		}
		return reportList;
	}

	// 查找單個記錄
	public ArrayList getReportInfoById(String reportId) throws SaasApplicationException {
		ReportsExt repExt = new ReportsExt();
		ArrayList reportList = new ArrayList();
		repExt.setParam(":VID", reportId);
		reportList = repExt.selByList("SEL_BY_ID");
		return reportList;
	}

	// 修改狀態(tài)
	public void updateReportInfo(Buffers inbuffer) {
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("進入updateReportInfo方法...");
		int iResult = -1;
		String report_id = inbuffer.getString("REPORTID");
		String state = "1";
		iResult = updateReportInfo(report_id, state);
		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("退出updateReportInfo方法...");
	}

	public int updateReportInfo(String report_id, String state) {
		ReportsExt repExt = new ReportsExt();
		repExt.setParam(":VID", report_id);
		repExt.setParam(":VXCHECKED", state);
		tradeQuery.executeBy(repExt.insBy("UPDATE_BY_REPORTID"));
		return 0;
	}
}