package com.saas.biz.rolerightMgr;

import java.util.ArrayList;

import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.rolerightDAO.RoleRightDAO;
import com.saas.biz.dao.rolerightDAO.RoleRightExt;
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 RolerightInfo{
	Dbtable tradeQuery;

	commMethodMgr comm;

	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	ArrayList queryResult = new ArrayList();

	public RolerightInfo() {
		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;
	}

	// 新增權限
	public void addRightInfo(Buffers inbuffer) {
		log.LOG_INFO("進入addRightInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String oper_user_id = inbuffer.getString("SESSION_USER_ID");
		String role_code = inbuffer.getString("ROLE_CODE");
		String menu_id = inbuffer.getString("MENU_ID");
		String start_date = inbuffer.getString("START_DATE");
		String end_date = inbuffer.getString("END_DATE");
		String remark = inbuffer.getString("REMARK");
		String rsrv_str1 = inbuffer.getString("RSRV_STR1");
		String rsrv_str2 = inbuffer.getString("RSRV_STR2");
		String rsrv_str3 = inbuffer.getString("RSRV_STR3");
		try {
			RoleRightDAO rightDao = new RoleRightDAO();
			rightDao.setCust_id(cust_id);
			rightDao.setEnd_date(end_date);
			rightDao.setMenu_id(menu_id);
			rightDao.setOper_user_id(oper_user_id);
			rightDao.setRole_code(role_code);
			rightDao.setStart_date(start_date);
			rightDao.setRemark(remark);
			iResult = addRightInfo(rightDao, rsrv_str1, rsrv_str2, rsrv_str3);
		}
		catch (Exception e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "業務處理失敗！");
		}
		else if (iResult == -2) {
			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("退出addRightInfo方法...");
	}

	public int addRightInfo(RoleRightDAO rightDao, String rsrv_str1, String rsrv_str2, String rsrv_str3) throws SaasApplicationException {
		String menu_id = rightDao.getMenu_id();
		String cust_id = rightDao.getCust_id();
		String role_code = rightDao.getRole_code();
		ArrayList list = getRoleRightByMenuId(cust_id, role_code, menu_id);
		if (list != null && list.size() > 0) {
			return -2;
		}
		else {
			if (menu_id == rsrv_str1 || rsrv_str1.equals(menu_id)) {
				addRoleRightInfo(rightDao);
			}
			else if (menu_id == rsrv_str2 || rsrv_str2.equals(menu_id)) {
				list = getRoleRightByMenuId(cust_id, role_code, rsrv_str1);
				if (list != null && list.size() > 0) {
					addRoleRightInfo(rightDao);
				}
				else {
					addRoleRightInfo(rightDao);
					RoleRightDAO rightDao1 = rightDao;
					rightDao1.setMenu_id(rsrv_str2);
					addRoleRightInfo(rightDao1);
				}
			}
			else if (menu_id == rsrv_str3 || rsrv_str3.equals(menu_id)) {
				list = getRoleRightByMenuId(cust_id, role_code, rsrv_str1);
				if (list != null && list.size() > 0) {
					ArrayList list2 = getRoleRightByMenuId(cust_id, role_code, rsrv_str2);
					if (list2 != null && list2.size() > 0) {
						addRoleRightInfo(rightDao);
					}
					else {
						RoleRightDAO rightDao2 = rightDao;
						rightDao2.setMenu_id(rsrv_str2);
						addRoleRightInfo(rightDao);
						addRoleRightInfo(rightDao2);
					}
				}
				else {
					ArrayList list2 = getRoleRightByMenuId(cust_id, role_code, rsrv_str2);
					if(list2 != null && list2.size() > 0){
						addRoleRightInfo(rightDao);
						RoleRightDAO rightDao1 = rightDao;
						rightDao1.setMenu_id(rsrv_str1);
						addRoleRightInfo(rightDao1);
					}else{
						RoleRightDAO rightDao1 = rightDao;
						rightDao1.setMenu_id(rsrv_str1);
						addRoleRightInfo(rightDao1);
						RoleRightDAO rightDao2 = rightDao;
						rightDao2.setMenu_id(rsrv_str2);
						addRoleRightInfo(rightDao2);
						rightDao.setMenu_id(rsrv_str3);
						addRoleRightInfo(rightDao);
					}
				}
			}
		}
		return 0;
	}

	public int addRoleRightInfo(RoleRightDAO rightDao) {
		RoleRightExt rightExt = new RoleRightExt();
		rightExt.setParam(":VCUST_ID", rightDao.getCust_id());
		rightExt.setParam(":VROLE_CODE", rightDao.getRole_code());
		rightExt.setParam(":VMENU_ID", rightDao.getMenu_id());
		rightExt.setParam(":VSTART_DATE", rightDao.getStart_date());
		rightExt.setParam(":VEND_DATE", rightDao.getEnd_date());
		rightExt.setParam(":VOPER_USER_ID", rightDao.getOper_user_id());
		rightExt.setParam(":VREMARK", rightDao.getRemark());
		tradeQuery.executeBy(rightExt.insBy("INS_BY_ALL"));
		return 0;
	}

	// 刪除菜單權限tradeQuery.executeBy(rightExt.insBy("DEL_BY_CODE"));
	public void deleteRightInfo(Buffers inbuffer) {
		log.LOG_INFO("進入deleteRightInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String role_code = inbuffer.getString("ROLE_CODE");
		String menu_id = inbuffer.getString("MENU_ID");
		try {
			RoleRightDAO rightDao = new RoleRightDAO();
			rightDao.setCust_id(cust_id);
			rightDao.setMenu_id(menu_id);
			rightDao.setRole_code(role_code);
			iResult = deleteRightInfo(rightDao);
		}
		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("退出deleteRightInfo方法...");
	}

	public int deleteRightInfo(RoleRightDAO rightDao) {
		RoleRightExt rightExt = new RoleRightExt();
		rightExt.setParam(":VCUST_ID", rightDao.getCust_id());
		rightExt.setParam(":VROLE_CODE", rightDao.getRole_code());
		rightExt.setParam(":VMENU_ID", rightDao.getMenu_id());
		tradeQuery.executeBy(rightExt.insBy("DEL_BY_CODE"));
		return 0;
	}

	// 通過role_code取出權限菜單
	public ArrayList getRoleRightInfoByRole(String cust_id, String role_code) throws SaasApplicationException {
		ArrayList roleList = new ArrayList();
		RoleRightExt rightExt = new RoleRightExt();
		rightExt.setParam(":VCUST_ID", cust_id);
		rightExt.setParam(":VROLE_CODE", role_code);
		roleList = rightExt.selByList("DEL_BY_ROLE");
		return roleList;
	}

	public ArrayList getRoleRightByMenuId(String cust_id, String role_code, String menu_id) throws SaasApplicationException {
		ArrayList roleList = new ArrayList();
		RoleRightExt rightExt = new RoleRightExt();
		rightExt.setParam(":VCUST_ID", cust_id);
		rightExt.setParam(":VROLE_CODE", role_code);
		rightExt.setParam(":VMENU_ID", menu_id);
		roleList = rightExt.selByList("SEL_BY_MENU");
		return roleList;
	}
}