package com.test.dao.impl;

import java.util.List;

import org.apache.log4j.Logger;
import org.hibernate.criterion.DetachedCriteria;

import com.test.dao.ResourceDao;
import com.test.vo.Resource;
import com.test.vo.Role;

public class ResourceImpl extends BaseDaoImpl<Resource, Integer> implements ResourceDao {
	private Logger logger = Logger.getLogger(ResourceImpl.class);
	
	public List<Role> getRolesByResourceId(int resourceId) {
		String hql = "select r.id , r.name ,r.desc  from" +
				" Role r, RoleResource  rr where rr.role.id " +
				"= r.id and rr.resource.resourceId="+resourceId ;
		
		return  getHibernateTemplate().find(hql);
		
	}

	public List<Resource> getResourceByUserName(String userName) {
		List<Resource> list = null ;
		String hql = "select r.resourceId , r.resourceName , " +
				"r.resourceURL , r.parentId from User u , UserRole ur ,   " +
				"RoleResource rr , Resource r where u.id = ur.userid" +
				" and  ur.role.id = rr.role.id and rr.resource.resourceId=" +
				"r.resourceId and u.username ="+userName+" GROUP BY r.resourceId";
		
		list = getHibernateTemplate().find(hql);
		return list;
	}
	
	public List<Resource> getResourceByRoleId(int roleId){
		DetachedCriteria dc = DetachedCriteria.forClass(Resource.class);
		return null ;
	}

}