Subversion Repositories bacoAlunos

package pt.estgp.estgweb.domain.dao.impl;

import jomm.dao.DaoException;

import org.hibernate.HibernateException;

import org.hibernate.Query;

import org.hibernate.Hibernate;

import org.hibernate.Criteria;

import static org.hibernate.criterion.Restrictions.*;

import org.hibernate.criterion.Criterion;

import org.hibernate.criterion.SimpleExpression;

import org.hibernate.criterion.Order;

import org.apache.log4j.Logger;

import java.util.List;

import java.util.Date;

import java.io.Serializable;

import pt.estgp.estgweb.domain.User;

import pt.estgp.estgweb.domain.Announcement;

import pt.estgp.estgweb.domain.CourseUnit;

import pt.estgp.estgweb.domain.dao.DaoUtils;

import pt.estgp.estgweb.services.common.SearchTypeEnum;

/**

 * @author Jorge Machado

 * @date 28/Fev/2008

 * @time 2:51:06

 * @see pt.estgp.estgweb.domain.dao.impl

 */

public class UserDaoImpl extends UserDao

{

    private static final 1.5.0/docs/api/java/util/logging/Logger.html">Logger logger = 1.5.0/docs/api/java/util/logging/Logger.html">Logger.getLogger(UserDaoImpl.class);

    public static UserDaoImpl getInstance()

    {

        if (myInstance == null)

            myInstance = new UserDaoImpl();

        return (UserDaoImpl) myInstance;

    }

    /**

     * Used by the base DAO classes but here for your modification Load object

     * matching the given key and return it.

     *

     * @param username to load

     * @return a user

     */

    public final User loadByUsername(1.5.0/docs/api/java/lang/String.html">String username)

    {

        try

        {

            5+0%2Fdocs%2Fapi+List">List list =

                    createCriteria()

                            .add(eq("username",username))

                            .setMaxResults(1)

                            .list();

            if(list.size() == 0)

                return null;

            return (User) list.get(0);

        }

        catch (HibernateException e)

        {

            throw new DaoException(e);

        }

    }

    /**

     * Used by the base DAO classes but here for your modification Load object

     * matching the given key and return it.

     *

     * @param email to load

     * @return a user

     */

    public final User loadByEmail(1.5.0/docs/api/java/lang/String.html">String email)

    {

        try

        {

            return (User) createCriteria()

                    .add(eq("email",email))

                    .uniqueResult();

        }

        catch (HibernateException e)

        {

            throw new DaoException(e);

        }

    }

    /**

     * Used by the base DAO classes but here for your modification Load object

     * matching the given key and return it.

     *

     * @param ID to load

     * @return a user

     */

    public final User loadByID(1.5.0/docs/api/java/lang/String.html">String ID)

    {

        try

        {

            return (User) createCriteria()

                    .add(eq("id",ID))

                    .uniqueResult();

        }

        catch (HibernateException e)

        {

            throw new DaoException(e);

        }

    }

    /**

     * Used by the base DAO classes but here for your modification Load object

     * matching the given key and return it.

     *

     * @param username to load

     * @param password to load

     * @return a user

     */

    public final User loadByUsernameAndPassword(1.5.0/docs/api/java/lang/String.html">String username, 1.5.0/docs/api/java/lang/String.html">String password)

    {

        try

        {

            return (User) createCriteria()

                    .add(eq("username",username))

                    .add(eq("password", jomm.utils.BytesUtils.getDigestMD5Hex(password)))

                    .uniqueResult();

        }

        catch (HibernateException e)

        {

            throw new DaoException(e);

        }

    }

    public List<User> loadRoleUsers (1.5.0/docs/api/java/lang/String.html">String role)

    {

        return createCriteria().add(like("roles","%" + role + "%")).addOrder(Order.asc("name")).list();

    }

    public List<User> findUsers (1.5.0/docs/api/java/lang/String.html">String textToSearch)

    {

        return findUsers(textToSearch,null);

    }

    public List<User> findUsers (1.5.0/docs/api/java/lang/String.html">String textToSearch,1.5.0/docs/api/java/lang/String.html">String typeToSearch)

    {

        Criteria criteria=null;

        if(typeToSearch!=null && typeToSearch.trim().length()!=0)

        {

            try

            {

                criteria = createCriteria(1.5.0/docs/api/java/lang/Class.html">Class.forName(typeToSearch));

            }

            catch (1.5.0/docs/api/java/lang/ClassNotFoundException.html">ClassNotFoundException e)

            {

                logger.error(e,e);

            }

        }

        else

        {

            criteria=createCriteria();

        }

        Criterion name= or(like("name","%"+textToSearch+"%"),like("name","%"+textToSearch+"%"));

        Criterion username = or(like("username", "%" + textToSearch + "%"), like("username", "%" + textToSearch + "%"));

        Criterion email = or(like("email", "%" + textToSearch + "%"), like("email", "%" + textToSearch + "%"));

        criteria.add(or(or(name,username),email))

                .addOrder(Order.desc("name"));

        return criteria.list();

    }

    public 1.5.0/docs/api/java/io/Serializable.html">Serializable save(User obj)

    {

        try {

            obj.setSaveDate(new 5+0%2Fdocs%2Fapi+Date">Date());

            return super.save(obj);

        }

        catch (HibernateException e) {

            throw new DaoException(e);

        }

    }

    public int countUsers(1.5.0/docs/api/java/lang/String.html">String query, SearchTypeEnum searchType)

    {

        Criterion c = DaoUtils.createSearchQuery(query,searchType,"name","username");

        return createCriteria()

                .add(c)

                .list().size();

    }

    public List<User> search(1.5.0/docs/api/java/lang/String.html">String query, SearchTypeEnum searchTypeEnum, int maxResults, int page)

    {

        Criterion c = DaoUtils.createSearchQuery(query, searchTypeEnum, "name", "username");

        Criteria criteria = createCriteria();

        criteria.add(c)

                .addOrder(Order.asc("name"))

                .setMaxResults(maxResults)

                .setFirstResult(page * maxResults);

        return criteria.list();

    }

}