menudao.java

很全面的hrm管理。提供通用的企业人力资源管理。

package org.self.hrm.persistence.hibernate;

import java.util.ArrayList;
import java.util.List;

import org.self.hrm.model.Menu;
import org.self.hrm.persistence.IMenuDAO;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class MenuDAO extends HibernateDaoSupport implements IMenuDAO {

	public void add(Menu menu) {

	}

	public void add(List<Menu> menus) {

	}

	public void delete(Menu menu) {

	}

	public void delete(List<Menu> menus) {

	}

	public void delete(String[] ids) {

	}

	public List<Menu> findByExample(Menu menu) {

		return null;
	}

	public Menu findById(String id) {

		return null;
	}

	public List<Menu> findByPropery(String propertyName, Object value) {

		return null;
	}

	public List<Menu> findByQL(String ql) {

		return null;
	}

	public List<Menu> list(String id) {

		return null;
	}

	public void saveOrupdate(Menu menu) {

	}

	public void saveOrupdate(List<Menu> menus) {

	}

	public void update(Menu menu) {

	}

	public void update(List<Menu> menus) {

	}

	@SuppressWarnings("unchecked")
	public List<Menu> getRoots(String userId) {
		String hql = " from Menu m where m.id in (select substr(a.menuId,0,2) from AuthView a where a.userId = '"+userId+"') ";
		return getHibernateTemplate().find(hql);
	}

	//给一个顶层菜单获取所有的子菜单
	public List<Object[]> getOffspring(String rootId, String userId) {
		List<Object[]> result = new ArrayList<Object[]>();
		List<Menu> menus = this.getSub(rootId, userId);
		if(menus != null){
			for (int i = 0; i < menus.size(); i++) {
				
				Menu menu = menus.get(i);
				Object[] node = new Object[2];
				node[0] = menu;
				node[1] = new ArrayList<Object[]>(0);
				
				List<Menu> subs = this.getSub(menu.getId(), userId);
				if(subs != null && subs.size() > 0){
					node[1] = this.getOffspring(menu.getId(), userId);
				}
				result.add(node);
			}
		}
		return result;
	}

	@SuppressWarnings("unchecked")
	public List<Menu> getSub(String menuId, String userId) {
		
		String hql = " from Menu m where m.id like '"+menuId.trim()+"__'"; 
		hql += " and m.id in ( ";
		hql += " select distinct substr(a.menuId,0,length(m.id)) from AuthView a ";
		hql += " ) ";
		return getHibernateTemplate().find(hql);
	}

}