package com.saas.biz.conTractMgr;

import java.text.SimpleDateFormat;
import java.util.*;
import java.util.Calendar;
import java.util.StringTokenizer;
import com.saas.biz.dao.contractDAO.ContractDAO;
import com.saas.biz.dao.contractDAO.ContractExt;
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 ConTractInfo {
	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	Dbtable tradeQuery;

	ArrayList queryResult = new ArrayList();

	public ConTractInfo() {
		log = new Logger(this);
		tradeQuery = new Dbtable();
		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 static String getConNo(String co_class, String con_num) {
		Calendar cal = Calendar.getInstance();
		String date = new SimpleDateFormat("yyyyMMdd").format(cal.getTime());
		String str = "";
		for (int i = 1; i <= Integer.parseInt(con_num); i++) {
			str += co_class + "-" + date + "-" + i + "|";
		}
		return str;
	}

	public void addConTractInfo(Buffers inbuffer) {
		log.LOG_INFO("進入addConTractInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String con_id = inbuffer.getString("CON_ID");
		String con_name = inbuffer.getString("CON_NAME");
		String obj_cust_name = inbuffer.getString("OBJ_CUST_NAME");
		String proj_name = inbuffer.getString("PROJ_NAME");
		String state_code = inbuffer.getString("STATE_CODE");
		String con_class = inbuffer.getString("CON_CLASS");
		String co_class = inbuffer.getString("CO_CLASS");
		String state_code_date = inbuffer.getString("STATE_CODE_DATE");
		String con_type = inbuffer.getString("CON_TYPE");
		String con_excut_way = inbuffer.getString("CON_EXCUT_WAY");
		String fare_way = inbuffer.getString("FARE_WAY");
		String pay_type = inbuffer.getString("PAY_TYPE");
		String currency = inbuffer.getString("CURRENCY");
		String con_sign_fare = inbuffer.getString("CON_SIGN_FARE");
		String con_fare = inbuffer.getString("CON_FARE");
		String sign_date = inbuffer.getString("SIGN_DATE");
		String con_object = inbuffer.getString("CON_OBJECT");
		String start_date = inbuffer.getString("START_DATE");
		String end_date = inbuffer.getString("END_DATE");
		String con_desc = inbuffer.getString("CON_DESC");
		String publish_date = inbuffer.getString("PUBLISH_DATE");
		String user_id = inbuffer.getString("SESSION_USER_ID");
		String remark = inbuffer.getString("REMARK");
		String con_no1 = "", con_no = "";
		con_no1 = getConNo(co_class, "1");
		try {
			ContractDAO condao = new ContractDAO();
			condao.setCust_id(cust_id);
			condao.setCon_id(con_id);

			condao.setCon_name(con_name);
			condao.setObj_cust_name(obj_cust_name);
			condao.setProj_name(proj_name);
			condao.setState_code(state_code);
			condao.setCon_class(con_class);
			condao.setState_code_date(state_code_date);
			condao.setCon_type(con_type);
			condao.setCon_excut_way(con_excut_way);
			condao.setFare_way(fare_way);
			condao.setPay_type(pay_type);
			condao.setCurrency(currency);
			condao.setCon_sign_fare(con_sign_fare);
			condao.setCon_fare(con_fare);
			condao.setSign_date(sign_date);
			condao.setCon_object(con_object);
			condao.setStart_date(start_date);
			condao.setEnd_date(end_date);
			condao.setCon_desc(con_desc);
			condao.setPublish_date(publish_date);
			condao.setUser_id(user_id);
			condao.setRemark(remark);

			StringTokenizer con_no2 = new StringTokenizer(con_no1, "|");
			while (con_no2.hasMoreTokens()) {
				con_no = con_no2.nextToken();
				condao.setCon_no(con_no);
				iResult = addConTractInfo(condao);
			}
		} catch (Exception 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("退出addConTractInfo方法...");
	}

	public int addConTractInfo(ContractDAO condao)
			throws SaasApplicationException {

		ContractExt conExt = new ContractExt();
		// log.LOG_INFO("開始執行SQL:===:");
		conExt.setParam(":VCUST_ID", condao.getCust_id());
		conExt.setParam(":VCON_ID", condao.getCon_id());
		conExt.setParam(":VCON_NO", condao.getCon_no());
		conExt.setParam(":VCON_NAME", condao.getCon_name());
		conExt.setParam(":VOBJ_CUST_NAME", condao.getObj_cust_name());
		conExt.setParam(":VPROJ_NAME", condao.getProj_name());
		conExt.setParam(":VSTATE_CODE", condao.getState_code());
		conExt.setParam(":VCON_CLASS", condao.getCon_class());
		conExt.setParam(":VSTATE_CODE_DATE", condao.getState_code_date());
		conExt.setParam(":VCON_TYPE", condao.getCon_type());
		conExt.setParam(":VCON_EXCUT_WAY", condao.getCon_excut_way());
		conExt.setParam(":VFARE_WAY", condao.getFare_way());
		conExt.setParam(":VPAY_TYPE", condao.getPay_type());
		conExt.setParam(":VCURRENCY", condao.getCurrency());
		conExt.setParam(":VCON_SIGN_FARE", condao.getCon_sign_fare());
		conExt.setParam(":VCON_FARE", condao.getCon_fare());
		conExt.setParam(":VSIGN_DATE", condao.getSign_date());
		conExt.setParam(":VCON_OBJECT", condao.getCon_object());
		conExt.setParam(":VSTART_DATE", condao.getStart_date());
		conExt.setParam(":VEND_DATE", condao.getEnd_date());
		conExt.setParam(":VCON_DESC", condao.getCon_desc());
		conExt.setParam(":VPUBLISH_DATE", condao.getPublish_date());
		conExt.setParam(":VUSER_ID", condao.getUser_id());
		conExt.setParam(":VREMARK", condao.getRemark());

		// log.LOG_INFO("開始執行SQL:===:" + conExt.insBy("INS_BY_CON_TRACT"));
		tradeQuery.executeBy(conExt.insBy("INS_BY_CON_TRACT"));
		return 0;
	}

	//通過狀態取出合同信息
	public ArrayList getConTractList(int iStart, String cust_id,
			String state_code) throws SaasApplicationException {

		iStart=iStart*20;
		ContractExt coniExt = new ContractExt();
		coniExt.setParam(":VCUST_ID", cust_id);
		coniExt.setParam(":VSTATE_CODE", state_code);
		ArrayList list = coniExt.selByList("SEL_BY_CONT", iStart, 20);
		return list;
	}
	
	public ArrayList getWarnConTractList(String cust_id,
			String state_code) throws SaasApplicationException {
		ContractExt coniExt = new ContractExt();
		coniExt.setParam(":VCUST_ID", cust_id);
		coniExt.setParam(":VSTATE_CODE", state_code);
		ArrayList list = coniExt.selByList("SEL_WARE_BY_CONT");
		return list;
	}

	public int getConTractList(String cust_id, String state_code)
			throws SaasApplicationException {
		int count = 0;
		ContractExt coniExt = new ContractExt();
		coniExt.setParam(":VCUST_ID", cust_id);
		coniExt.setParam(":VSTATE_CODE", state_code);
		ArrayList list = coniExt.selByList("SEL_BY_CONT");
		if (list != null && list.size() > 0) {
			count = list.size();
		}
		return count;
	}

	public void modifyConTractList(Buffers inbuffer) {

		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("進入modifyConTractList方法...");
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String con_id = inbuffer.getString("CON_ID");
		String con_name = inbuffer.getString("CON_NAME");
		String obj_cust_name = inbuffer.getString("OBJ_CUST_NAME");
		String proj_name = inbuffer.getString("PROJ_NAME");
		String state_code = inbuffer.getString("STATE_CODE");
		String con_class = inbuffer.getString("CON_CLASS");
		String state_code_date = inbuffer.getString("STATE_CODE_DATE");
		String con_type = inbuffer.getString("CON_TYPE");
		String con_excut_way = inbuffer.getString("CON_EXCUT_WAY");
		String fare_way = inbuffer.getString("FARE_WAY");
		String pay_type = inbuffer.getString("PAY_TYPE");
		String currency = inbuffer.getString("CURRENCY");
		String con_sign_fare = inbuffer.getString("CON_SIGN_FARE");
		String con_fare = inbuffer.getString("CON_FARE");
		String sign_date = inbuffer.getString("SIGN_DATE");
		String con_object = inbuffer.getString("CON_OBJECT");
		String start_date = inbuffer.getString("START_DATE");
		String end_date = inbuffer.getString("END_DATE");
		String con_desc = inbuffer.getString("CON_DESC");
		String publish_date = inbuffer.getString("PUBLISH_DATE");
		String user_id = inbuffer.getString("SESSION_USER_ID");
		String remark = inbuffer.getString("REMARK");

		try {
			ContractDAO condao = new ContractDAO();
			condao.setCust_id(cust_id);
			condao.setCon_id(con_id);
			condao.setCon_name(con_name);
			condao.setObj_cust_name(obj_cust_name);
			condao.setProj_name(proj_name);
			condao.setState_code(state_code);
			condao.setCon_class(con_class);
			condao.setState_code_date(state_code_date);
			condao.setCon_type(con_type);
			condao.setCon_excut_way(con_excut_way);
			condao.setFare_way(fare_way);
			condao.setPay_type(pay_type);
			condao.setCurrency(currency);
			condao.setCon_sign_fare(con_sign_fare);
			condao.setCon_fare(con_fare);
			condao.setSign_date(sign_date);
			condao.setCon_object(con_object);