/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.support.struts.action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.hibernate.Query;

import com.support.hibernate.table.SDepartmentDAO;
import com.support.hibernate.table.SRole;
import com.support.hibernate.table.SRoleDAO;
import com.support.hibernate.table.SUserDAO;
import com.support.hibernate.table.SUserRoleDAO;
import com.support.struts.form.RoleForm;
import com.support.util.page.PageListData;
import com.support.util.page.PageQuery;

/** 
 * MyEclipse Struts
 * Creation date: 08-08-2007
 * 
 * XDoclet definition:
 * @struts.action path="/role" name="roleForm" input="/admin/role/index.jsp" scope="request" validate="true"
 * @struts.action-forward name="success" path="/admin/role/index.jsp"
 */
public class RoleAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		RoleForm roleForm = (RoleForm) form;// TODO Auto-generated method stub
		int flag = roleForm.getFlag();
		System.out.println(flag);
		switch (flag) {
		case 0:
			init(request);
			break;
		case 1:
			search(roleForm,request);
//			init(request);
			break;
		case 2:
			editPreview(roleForm);
			init(request);
			break;
		case 3:
			update(roleForm,request);
			search(roleForm,request);
//			init(request);
			break;
		case 4:
			delete(roleForm,request);
			search(roleForm,request);
//			init(request);
			break;
		case 5:
			save(roleForm,request);
			search(roleForm,request);
//			init(request);
			break;
		default:
			break;
		}
		return mapping.findForward("success");
	}
	/**
	 * 初始化頁面返回部門信息列表
	 * @param request
	 */
	public void init(HttpServletRequest request) {
		SDepartmentDAO dao = new SDepartmentDAO();
		dao.getSession().clear();
		request.setAttribute("departmentList", dao.findAll());
	}
	/**
	 * 根據(jù)輸入條件查詢角色數(shù)據(jù)
	 * @param roleForm
	 * @param request
	 */
	public void search(RoleForm roleForm,HttpServletRequest request) {
		SRoleDAO dao = new SRoleDAO();
		dao.getSession().clear();
		StringBuffer sql = new StringBuffer("from SRole role where 1 = 1");
		if (!roleForm.getName().trim().equals("")) {
			sql.append(" and role.name='").append(roleForm.getName().trim()).append("'");
		}
		if (!roleForm.getDescription().trim().equals("")) {
			sql.append(" and role.description = '").append(roleForm.getDescription().trim()).append("'");
		}
		if (!roleForm.getDepartmentId().trim().equals("")) {
			sql.append(" and role.departmentId = '").append(roleForm.getDepartmentId().trim()).append("'");
		}
		StringBuffer sqlCount = new StringBuffer("select count(*) ").append(sql.toString());
		Query query = dao.getSession().createQuery(sql.toString());
		Query countQuery = dao.getSession().createQuery(sqlCount.toString());
		PageQuery pq = new PageQuery(query,countQuery,10);
		if (roleForm.getPageNum() == 0) roleForm.setPageNum(1);
		PageListData data = pq.pageQuery(roleForm.getPageNum());
		data.setFormName("roleForm");
		data.setJsFun("getPageData");		
		request.setAttribute("pageData", data);
	}
	/**
	 * 修改御覽
	 * @param roleForm
	 */
	public void editPreview(RoleForm roleForm) {
		String id = roleForm.getId();
		SRoleDAO dao = new SRoleDAO();
		dao.getSession().clear();
		SRole role = dao.findById(id);
		roleForm.setId(role.getId());
		roleForm.setName(role.getName());
		roleForm.setDescription(role.getDescription());
		roleForm.setDepartmentId(role.getDepartmentId());
	}
	/**
	 * 根據(jù)用戶輸入修改角色信息
	 * @param roleForm
	 * @param request
	 */
	public void update(RoleForm roleForm,HttpServletRequest request) {
		String id = roleForm.getId();
		SRoleDAO dao = new SRoleDAO();
		SRole role = dao.findById(id);
		role.setName(roleForm.getName().trim());
		role.setDescription(roleForm.getDescription().trim());
		role.setDepartmentId(roleForm.getDepartmentId());
		dao.getSession().flush();
		dao.getSession().clear();
		request.setAttribute("message", "修改成功");
	}
	/**
	 * 刪除角色
	 * @param roleForm
	 * @param request
	 */
	public void delete(RoleForm roleForm,HttpServletRequest request) {
		String id = roleForm.getId();
		SRoleDAO dao = new SRoleDAO();
		SUserRoleDAO userRoleDao = new SUserRoleDAO();
		if (userRoleDao.findByRoleId(id).size() > 1) {
			request.setAttribute("message", "該角色下尚有用戶信息不允許刪除");
			return;
		}
		SRole role = dao.findById(id);
		dao.delete(role);
		dao.getSession().flush();
		dao.getSession().clear();
		request.setAttribute("message", "角色已刪除");
	}
	/**
	 * 增加角色
	 * @param roleForm
	 */
	public void save(RoleForm roleForm,HttpServletRequest request) {
		SRoleDAO dao = new SRoleDAO();
		SRole role = new SRole(roleForm.getName().trim(),roleForm.getDescription().trim(),roleForm.getDepartmentId().trim());
		dao.save(role);
		dao.getSession().flush();
		dao.getSession().clear();
		request.setAttribute("message", "添加成功");
	}
}