package com.dao;

import java.sql.SQLException;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.jbpm.graph.exe.ProcessInstance;
import org.jbpm.graph.exe.Token;
import org.jbpm.taskmgmt.exe.TaskInstance;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class MyJbpmDao extends HibernateDaoSupport {

	public ProcessInstance getUrl(TaskInstance ti)
	{
		Token token=ti.getToken();	
		return token.getProcessInstance();
	}
	public List findAllTaskInstanceByUserId(String userid)
	{
		TaskInstance ti=new TaskInstance();
		ti.getActorId();
		String hql="from TaskInstance ti where ti.actorId='"+userid+"'";
		List list=this.getHibernateTemplate().find(hql);
		return list;
	}
	
	public List findAll(final int offset,final int pagesize)
	{
		List list=getHibernateTemplate().executeFind(new HibernateCallback(){

			public Object doInHibernate(Session arg0) throws HibernateException, SQLException {
				List list=arg0.createQuery("").setFirstResult(offset).setMaxResults(pagesize).list();
				return list;
			}
			
		});
		return list;
	}
	
}