package com.saas.biz.pleasetableMgr;

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

import com.saas.biz.commen.ParamethodMgr;
import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.pleaseresultDAO.PleaseresultExt;
import com.saas.biz.dao.pleasetableDAO.PleasetableDAO;
import com.saas.biz.dao.pleasetableDAO.PleasetableExt;
import com.saas.biz.dao.tableitemDAO.TableitemExt;
import com.saas.biz.organizeMgr.OrganizeInfo;
import com.saas.biz.pleaseItemMgr.PleaseItemInfo;
import com.saas.sys.buffer.Buffers;
import com.saas.sys.dbm.Dbtable;
import com.saas.sys.exp.SaasApplicationException;
import com.saas.sys.log.Logger;

/**
 * @author:LiuYang
 * @desc:滿意度調查[tf_b_pleasetable]
 * @2008-3-3
 */
public class PleasetableInfo {
	
	
	Dbtable tradeQuery;
	
	
	commMethodMgr comm;
	
	
	Logger log;
	
	
	Buffers inBuffer;
	
	
	Buffers outBuffer;
	
	
	ArrayList queryResult = new ArrayList();
	
	
	
	public PleasetableInfo() {

		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;
	}
	
	
	
	// 滿意度調查表[ENABLE_TAG 0 有效 1 無效]
	public void addPleaseTableInfo(Buffers inbuffer) {

		log.LOG_INFO("進入addPleaseTableInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String rsrv_str1 = inbuffer.getString("RSRV_STR1");
		String table_id = inbuffer.getString("TABLE_ID");
		String table_name = inbuffer.getString("TABLE_NAME");
		String own_project = inbuffer.getString("OWN_PROJECT");
		String p_type = inbuffer.getString("P_TYPE");
		String items_name = inbuffer.getString("ITEMS_NAME");
		String items_id = inbuffer.getString("ITEMS_ID");
		String d_value = inbuffer.getString("D_VALUE");
		String enable_tag = inbuffer.getString("ENABLE_TAG");
		String depart_code = inbuffer.getString("D_CODE");
		String start_date = inbuffer.getString("START_DATE");
		String end_date = inbuffer.getString("END_DATE");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String remark2 = inbuffer.getString("REMARK2");
		try {
			
			PleasetableDAO pleaseDao = new PleasetableDAO();
			
			pleaseDao.setCust_id(cust_id);
			pleaseDao.setRsrv_str1(rsrv_str1);
			pleaseDao.setTable_id(table_id);
			pleaseDao.setTable_name(table_name);
			pleaseDao.setOwn_project(own_project);
			pleaseDao.setP_type(p_type);
			pleaseDao.setItems_id(items_id);
			pleaseDao.setD_value(d_value);
			pleaseDao.setItems_name(items_name);
			pleaseDao.setEnable_tag(enable_tag);
			pleaseDao.setDepart_code(depart_code);
			pleaseDao.setStart_date(start_date);
			pleaseDao.setEnd_date(end_date);
			pleaseDao.setOper_user_id(oper_user_id);
			pleaseDao.setRemark2(remark2);
			
			iResult = addPleaseTableInfo(pleaseDao);
		}
		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("退出addPleaseTableInfo方法...");
	}
	
	
	public int addPleaseTableInfo(PleasetableDAO pleaseDao) throws SaasApplicationException {

		PleasetableExt pleaseExt = new PleasetableExt();
		pleaseExt.setParam(":VCUST_ID", pleaseDao.getCust_id());
		pleaseExt.setParam(":VRSRV_STR1", pleaseDao.getRsrv_str1());
		pleaseExt.setParam(":VTABLE_ID", pleaseDao.getTable_id());
		pleaseExt.setParam(":VTABLE_NAME", pleaseDao.getTable_name());
		pleaseExt.setParam(":VOWN_PROJECT", pleaseDao.getOwn_project());
		pleaseExt.setParam(":VP_TYPE", pleaseDao.getP_type());
		pleaseExt.setParam(":VITEMS_ID", pleaseDao.getItems_id());
		pleaseExt.setParam(":VD_VALUE", pleaseDao.getD_value());
		pleaseExt.setParam(":VITEMS_NAME", pleaseDao.getItems_name());
		pleaseExt.setParam(":VENABLE_TAG", pleaseDao.getEnable_tag());
		pleaseExt.setParam(":VDEPART_CODE", pleaseDao.getDepart_code());
		pleaseExt.setParam(":VSTART_DATE", pleaseDao.getStart_date());
		pleaseExt.setParam(":VEND_DATE", pleaseDao.getEnd_date());
		pleaseExt.setParam(":VOPER_USER_ID", pleaseDao.getOper_user_id());
		pleaseExt.setParam(":VREMARK2", pleaseDao.getRemark2());
		tradeQuery.executeBy(pleaseExt.insBy("INS_BY_ALL"));
		
		return 0;
	}
	
	
	
	// 級聯刪除調查表信息
	public void deleteTableInfo(Buffers inbuffer) {

		log.LOG_INFO("進入deleteTableInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("CUST_ID");
		String table_id = inbuffer.getString("TABLE_ID");
		try {
			iResult = deleteTableInfo(cust_id, table_id);
		}
		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("退出deleteTableInfo方法...");
	}
	
	
	public int deleteTableInfo(String cust_id, String table_id) throws SaasApplicationException {

		PleasetableExt tableExt = new PleasetableExt();
		tableExt.setParam(":VCUST_ID", cust_id);
		tableExt.setParam(":VTABLE_ID", table_id);
		TableitemExt itemExt = new TableitemExt();
		itemExt.setParam(":VCUST_ID", cust_id);
		itemExt.setParam(":VTABLE_ID", table_id);
		PleaseresultExt resultExt = new PleaseresultExt();
		resultExt.setParam(":VCUST_ID", cust_id);
		resultExt.setParam(":VTABLE_ID", table_id);
		tradeQuery.executeBy(tableExt.insBy("DEL_BY_TABLE"));
		tradeQuery.executeBy(itemExt.insBy("DEL_BY_TABLE"));
		tradeQuery.executeBy(resultExt.insBy("DEL_BY_TABLE"));
		return 0;
	}
	
	
	
	// 取出所有調查表
	public ArrayList getPleaseByCust_id(String cust_id, String enable) throws SaasApplicationException {

		PleasetableExt pleaseExt = new PleasetableExt();
		pleaseExt.setParam(":VCUST_ID", cust_id);
		pleaseExt.setParam(":VENABLE_TAG", enable);
		ArrayList list = pleaseExt.selByList("SEL_BY_CUST");
		return list;
	}
	
	
	
	// 取出所有調查表分頁
	public ArrayList getPleasePageByCust_id(int iStart, String cust_id) throws SaasApplicationException {

		
			iStart =iStart * 20;
	
		PleasetableExt pleaseExt = new PleasetableExt();
		pleaseExt.setParam(":VCUST_ID", cust_id);
		pleaseExt.setParam(":VENABLE_TAG", "0");
		ArrayList list = pleaseExt.selByList("SEL_BY_CUST", iStart, 20);
		return list;
	}
	
	
	
	// 調查表統計
	public int getPageSize(String cust_id) throws SaasApplicationException {

		int size = 0;
		PleasetableExt pleaseExt = new PleasetableExt();
		pleaseExt.setParam(":VCUST_ID", cust_id);
		pleaseExt.setParam(":VENABLE_TAG", "0");
		ArrayList list = pleaseExt.selByList("SEL_BY_CUST_CT");
		if (list != null && list.size() > 0) {
			HashMap map = (HashMap) list.get(0);
			size = Integer.parseInt(map.get("ct").toString());
		}
		return size;
	}
	
	
	
	// 取出所有調查表[Map<table_id,table_name>]
	public Map<String, String> getPleasesByCust_id(String cust_id, String enable) throws SaasApplicationException {

		Map<String, String> map = new HashMap<String, String>();
		PleasetableExt pleaseExt = new PleasetableExt();
		pleaseExt.setParam(":VCUST_ID", cust_id);
		pleaseExt.setParam(":VENABLE_TAG", enable);
		ArrayList list = pleaseExt.selByList("SEL_BY_CUST");
		if (list != null && list.size() > 0) {
			for (int i = 0; i < list.size(); i++) {
				HashMap pl_Map = (HashMap) list.get(0);
				String id = pl_Map.get("table_id").toString();
				String name = pl_Map.get("table_name").toString();
				map.put(id, name);
			}
		}
		return map;
	}
	
	
	public Map<String, String> getPleasesByTableId(String cust_id, String table_id, String enable) throws SaasApplicationException {

		Map<String, String> map = new HashMap<String, String>();
		ArrayList list = getPleaseByTableId(cust_id, table_id, enable);
		log.LOG_INFO("==" + list);
		if (list != null && list.size() > 0) {
			HashMap pl_Map = (HashMap) list.get(0);
			String table_idx = "";
			if (pl_Map.get("table_id") != null) {
				table_idx = pl_Map.get("table_id").toString();
				map.put("table_id", table_idx);
			}
			String table_name = "";
			if (pl_Map.get("table_name") != null) {
				table_name = pl_Map.get("table_name").toString();
				map.put("table_name", table_name);
			}
			String own_project = "";
			if (pl_Map.get("own_project") != null) {
				own_project = pl_Map.get("own_project").toString();
				map.put("own_project", own_project);
			}
			String p_type = "", type_name = "";
			if (pl_Map.get("p_type") != null) {
				p_type = pl_Map.get("p_type").toString();
				HashMap typeMap = new ParamethodMgr().getCompareInfoByCode("CRM", "p_type");
				if (typeMap != null && typeMap.size() > 0) {
					if (typeMap.get(p_type) != null) {
						type_name = typeMap.get(p_type).toString();
					}
				}
				map.put("p_type", p_type);
				map.put("type_name", type_name);
			}
			String d_value = "";
			if (pl_Map.get("d_value") != null) {
				d_value = pl_Map.get("d_value").toString();
				map.put("d_value", d_value);
			}
			String enable_tag = "";
			if (pl_Map.get("enable_tag") != null) {
				enable_tag = pl_Map.get("enable_tag").toString();
				map.put("enable_tag", enable_tag);
			}
			String depart_code = "", depart_name = "";
			if (pl_Map.get("depart_code") != null) {
				depart_code = pl_Map.get("depart_code").toString();
				Map org_map = new OrganizeInfo().getOrganizeByOrgId(depart_code);
				if (org_map != null && org_map.size() > 0) {
					if (org_map.get("org_name") != null) {
						depart_name = org_map.get("org_name").toString();
					}
				}
				map.put("depart_code", depart_code);
				map.put("depart_name", depart_name);
			}
			String start_date = "";
			if (pl_Map.get("start_date") != null) {
				start_date = pl_Map.get("start_date").toString();
				if (start_date.length() > 10) {
					start_date = start_date.substring(0, 10);
				}
				map.put("start_date", start_date);
			}
			String end_date = "";
			if (pl_Map.get("end_date") != null) {
				end_date = pl_Map.get("end_date").toString();
				if (end_date.length() > 10) {
					end_date = end_date.substring(0, 10);
				}
				map.put("end_date", end_date);
			}
		}
		log.LOG_INFO("--" + map);
		return map;
	}
	
	
	
	// 取出調查表
	public ArrayList getPleaseByTableId(String cust_id, String table_id, String enable) throws SaasApplicationException {

		PleasetableExt pleaseExt = new PleasetableExt();
		pleaseExt.setParam(":VCUST_ID", cust_id);
		pleaseExt.setParam(":VTABLE_ID", table_id);
		pleaseExt.setParam(":VENABLE_TAG", enable);
		ArrayList list = pleaseExt.selByList("SEL_BY_TABLE_ID");
		return list;
	}
	
	
	
	// 取出項目
	public Map<String, String> getImtemsByTable_id(String cust_id, String table_id, String enable) throws SaasApplicationException {

		Map<String, String> map = new HashMap<String, String>();
		try {
			PleasetableExt pleaseExt = new PleasetableExt();
			pleaseExt.setParam(":VCUST_ID", cust_id);
			pleaseExt.setParam(":VTABLE_ID", table_id);
			pleaseExt.setParam(":VENABLE_TAG", enable);
			ArrayList list = pleaseExt.selByList("SEL_BY_ITEMS");
			if (list != null && list.size() > 0) {
				for (int i = 0; i < list.size(); i++) {
					HashMap pl_Map = (HashMap) list.get(i);
					String id = pl_Map.get("items_id").toString();
					String name = pl_Map.get("items_name").toString();
					map.put(id, name);
				}
			}
		}
		catch (RuntimeException e) {
			log.LOG_INFO(e.getMessage());
		}
		return map;
	}
	
	
	
	// 取出調查表
	public ArrayList getPleaseByTableName(String cust_id, String table_name, String enable) throws SaasApplicationException {

		PleasetableExt pleaseExt = new PleasetableExt();
		pleaseExt.setParam(":VCUST_ID", cust_id);
		pleaseExt.setParam(":VTABLE_NAME", table_name);
		pleaseExt.setParam(":VENABLE_TAG", enable);
		ArrayList list = pleaseExt.selByList("SEL_BY_TABLE_NAME");
		return list;
	}
	
	
	
	// 取出單條調查表和多條條目Map<List,<Map>>
	public Map<HashMap, ArrayList> getTableAndItemsById(String cust_id, String table_id, String enable) throws SaasApplicationException {

		Map<HashMap, ArrayList> map = new HashMap<HashMap, ArrayList>();
		
		PleasetableExt pleaseExt = new PleasetableExt();
		pleaseExt.setParam(":VCUST_ID", cust_id);
		pleaseExt.setParam(":VTABLE_ID", table_id);
		pleaseExt.setParam(":VENABLE_TAG", enable);
		ArrayList list = pleaseExt.selByList("SEL_BY_ITEMS");
		if (list != null && list.size() > 0) {
			for (int i = 0; i < list.size(); i++) {
				HashMap i_Map = (HashMap) list.get(i);
				String items_id = i_Map.get("items_id").toString();
				ArrayList itemLIst = new PleaseItemInfo().getPleaseItemByItems(table_id, items_id, enable);
				map.put(i_Map, itemLIst);
			}
		}
		return map;
	}
	
	
	
	// 取出調查類型[輸入框 單選 多選]
	public String getTypeByItems(String table_id, String items_id) {

		String type = "0";
		
		PleasetableExt pleaseExt = new PleasetableExt();
		pleaseExt.setParam(":VITEMS_ID", items_id);
		pleaseExt.setParam(":VTABLE_ID", table_id);
		ArrayList list=pleaseExt.selByList("SEL_BY_TYPE");
		if(list !=null && list.size()>0){
			HashMap map=(HashMap)list.get(0);
			if(map.get("rsrv_str1")!= null){
				type=map.get("rsrv_str1").toString();
			}
		}
		return type;
	}
	
	//取出多個項目
	public HashMap getItemsName(String table_id,String cust_id)throws SaasApplicationException{
		HashMap<String,String> map=new HashMap<String,String>();
		PleasetableExt pleaseExt = new PleasetableExt();
		pleaseExt.setParam(":VCUST_ID", cust_id);
		pleaseExt.setParam(":VTABLE_ID", table_id);
		pleaseExt.setParam(":VENABLE_TAG", "0");
		ArrayList list = pleaseExt.selByList("SEL_BY_ITEMS");
		if(list !=null && list.size()>0){
			for(int i=0;i<list.size();i++){
				HashMap itMap=(HashMap)list.get(i);
				String items_id="";
				String items_name="";
				if(itMap.get("items_name")!=null){
					items_name=itMap.get("items_name").toString();
				}
				if(itMap.get("items_id")!=null){
					items_id=itMap.get("items_id").toString();
				}
				if((items_id !=null && !items_id.equals(""))&&(items_name !=null && !items_name.equals(""))){
				  map.put(items_id, items_name);
				}
			}
		}
		return map;
	}
}