package com.saas.biz.oppProMgr;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
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.oppProDAO.*;


public class OppProInfo{

	Dbtable tradeQuery;

	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	ArrayList queryResult = new ArrayList();

	public OppProInfo() {
		log = new Logger(this);
		tradeQuery = new Dbtable();
	}

	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 addOppProInfo(Buffers inbuffer) {
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("進入addOppProInfo方法...");
		String cust_id=inbuffer.getString("SESSION_CUST_ID");
		String proj_name=inbuffer.getString("PROJ_NAME");
		String proj_id=inbuffer.getString("PROJ_ID");
		String title=inbuffer.getString("TITLE");  
		String content=inbuffer.getString("CONTENT");
		String start_date=inbuffer.getString("START_DATE");
		String end_date=inbuffer.getString("END_DATE");
		String own_cust_id=inbuffer.getString("OWN_CUST_ID"); 
		String own_cust_name=inbuffer.getString("OWN_CUST_NAME");   
		String user_id=inbuffer.getString("USER_ID");
		String user_name=inbuffer.getString("USER_NAME");
		log.LOG_INFO("user_name======="+user_name);
		String in_date=inbuffer.getString("IN_DATE");
		String remark=inbuffer.getString("REMARK");
		String state_code=inbuffer.getString("STATE_CODE");
		int iResult = -1;
		try {
			iResult = addOppProInfo(cust_id,proj_name,proj_id,title,content,start_date,end_date,own_cust_id,own_cust_name,user_id,user_name,in_date,state_code,remark);
		}
		catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "業(yè)務處理失敗！");

		}
		else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "業(yè)務處理成功！");
		}
		log.LOG_INFO("退出addOppProInfo方法...");
	}

	public int addOppProInfo(String cust_id,String proj_name,String proj_id,String title,String content,String start_date,String end_date,String own_cust_id,String own_cust_name,String user_id,String user_name,String in_date,String state_code,String remark) throws SaasApplicationException {
		OppProExt oppProExt = new OppProExt();
		oppProExt.setParam(":VCUST_ID",cust_id);							  
		oppProExt.setParam(":VPROJ_NAME",proj_name);							
		oppProExt.setParam(":VPROJ_ID",proj_id);							
		oppProExt.setParam(":VTITLE",title);							
		oppProExt.setParam(":VCONTENT",content);							
		oppProExt.setParam(":VSTART_DATE",start_date);							
		oppProExt.setParam(":VEND_DATE",end_date);							
		oppProExt.setParam(":VOWN_CUST_ID",own_cust_id);							
		oppProExt.setParam(":VOWN_CUST_NAME",own_cust_name);							
		oppProExt.setParam(":VUSER_ID",user_id);
		oppProExt.setParam(":VUSER_NAME",user_name);
		oppProExt.setParam(":VIN_DATE",in_date);
		oppProExt.setParam(":VSTATE_CODE",state_code);
		oppProExt.setParam(":VREMARK",remark);
		tradeQuery.executeBy(oppProExt.insBy("INS_OPP_PRO"));
		return 0;
	}
	
	//修改競爭項目
	public void updateOppPro(Buffers inbuffer) {
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		log.LOG_INFO("進入updateOppPro方法...");
		String cust_id=inbuffer.getString("SESSION_CUST_ID");
		String proj_name=inbuffer.getString("PROJ_NAME");
		String proj_id=inbuffer.getString("PROJ_ID");
		String title=inbuffer.getString("TITLE");  
		String content=inbuffer.getString("CONTENT");
		String start_date=inbuffer.getString("START_DATE");
		String own_cust_id=inbuffer.getString("OWN_CUST_ID"); 
		String own_cust_name=inbuffer.getString("OWN_CUST_NAME");   
		String user_id=inbuffer.getString("USER_ID");
		String user_name=inbuffer.getString("USER_NAME");
		String in_date=inbuffer.getString("IN_DATE");
		String remark=inbuffer.getString("REMARK");
		int iResult = -1;
		try {
			iResult = updateOppPro(cust_id,proj_name,proj_id,title,content,start_date,own_cust_id,own_cust_name,user_id,user_name,in_date,remark);
		}
		catch (SaasApplicationException e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "業(yè)務處理失敗！");

		}
		else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "業(yè)務處理成功！");
		}
		log.LOG_INFO("退出updateOppPro方法...");
	}

	public int updateOppPro(String cust_id,String proj_name,String proj_id,String title,String content,String start_date,String own_cust_id,String own_cust_name,String user_id,String user_name,String in_date,String remark) throws SaasApplicationException {
		OppProExt oppProExt = new OppProExt();
		oppProExt.setParam(":VCUST_ID",cust_id);							  
		oppProExt.setParam(":VPROJ_NAME",proj_name);							
		oppProExt.setParam(":VPROJ_ID",proj_id);							
		oppProExt.setParam(":VTITLE",title);							
		oppProExt.setParam(":VCONTENT",content);							
		oppProExt.setParam(":VSTART_DATE",start_date);							
		oppProExt.setParam(":VOWN_CUST_ID",own_cust_id);							
		oppProExt.setParam(":VOWN_CUST_NAME",own_cust_name);							
		oppProExt.setParam(":VUSER_ID",user_id);
		oppProExt.setParam(":VUSER_NAME",user_name);
		oppProExt.setParam(":VIN_DATE",in_date);
		oppProExt.setParam(":VREMARK",remark);
		tradeQuery.executeBy(oppProExt.insBy("UPDATE_OPP_PRO"));
		return 0;
	}
	
	public ArrayList getOppProList(int iStart,String cust_id) throws SaasApplicationException{
		OppProExt oppProExt = new OppProExt();
		ArrayList list = new ArrayList();
		try {
		
				iStart = iStart  * 20;
			
			oppProExt.setParam(":VCUST_ID",cust_id);
			list = oppProExt.selByList("SEL_BY_OPP_PRO", iStart, 20);
		}
		catch (RuntimeException e) {
			log.LOG_INFO(e.getMessage());
		}
		return list;
	}
	
	//取出所有的競爭項目
	public int getOppProList(String cust_id) throws SaasApplicationException{
		OppProExt oppProExt = new OppProExt();
		ArrayList list = new ArrayList();
		int count = 0;
		try {
			oppProExt.setParam(":VCUST_ID",cust_id);
			list = oppProExt.selByList("SEL_BY_OPP_PRO");
		}
		catch (RuntimeException e) {
			log.LOG_INFO(e.getMessage());
		}
		if(list != null && list.size()>0){
			count = list.size();
		}
		return count;
	}
	
	
	//刪除競爭項目
	public void delOppPro(Buffers inbuffer) {

		log.LOG_INFO("進入delOppPro方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		try {
			String cust_id = inbuffer.getString("SESSION_CUST_ID");
			String proj_id = inbuffer.getString("PROJ_ID");
			iResult = delOppPro(cust_id,proj_id);
		}
		catch (Exception e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "業(yè)務處理失敗！");
		}
		else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "業(yè)務處理成功！");
		}
		log.LOG_INFO("退出delOppPro方法...");
	}
	
	
	public int delOppPro(String cust_id, String proj_id) throws SaasApplicationException {
			OppProExt oppProExt = new OppProExt();
			oppProExt.setParam(":VCUST_ID", cust_id);
			oppProExt.setParam(":VPROJ_ID", proj_id);
			tradeQuery.executeBy(oppProExt.insBy("DEL_BY_OPP_PRO"));
		return 0;
	}
	
	//通過proj_id取出對應的競爭項目
	public ArrayList getOppProList(String cust_id,String proj_id) throws SaasApplicationException{
		OppProExt oppProExt = new OppProExt();
		ArrayList list = new ArrayList();
		try {
			oppProExt.setParam(":VCUST_ID",cust_id);
			oppProExt.setParam(":VPROJ_ID",proj_id);
			list = oppProExt.selByList("SEL_OPP_BY_PROJ_ID");
		}
		catch (RuntimeException e) {
			log.LOG_INFO(e.getMessage());
		}
		return list;
	}
	
}