D-Net

package eu.dnetlib.goldoa.service.dao;

import org.apache.commons.logging.LogFactory;

import org.hibernate.criterion.Projections;

import org.hibernate.transform.Transformers;

import java.util.ArrayList;

import java.util.List;

/**

 * Created by antleb on 3/13/15.

 */

     * Returns the person with the given id. Objects of different type are placeholders containing only their id.

     * Objects representing relations are fully initialized, with placeholders for other main entities.

     *

     * @param userId

     * @return

     */

    public User getUserById(String userId) {

        return (User) createEntityCriteria().add(Restrictions.eq("id", userId)).list().get(0);

    }

     * Returns the person with the given email. Objects of different type are placeholders containing only their id.

     * Objects representing relations are fully initialized, with placeholders for other main entities.

     *

     * @param email

     * @return

     */

    @SuppressWarnings("unchecked")

    public User getUserByEmail(String email) {

        List<User> users = createEntityCriteria().add(Restrictions.eq("email", email)).list();

        if (users.size() == 0)

            return null;

        return u;

    public List<Role> getUserRoles(String email) {

        Criteria cr = getSession().createCriteria(UserRole.class);

        return cr.add(Restrictions.eq("pk.user",email))

                .setResultTransformer( Transformers.aliasToBean(Role.class)).list();

    }

        AccountAction acc_action = new AccountAction();

        acc_action.setUser(getUserByEmail(email));

        acc_action.setType("activation");

        acc_action.setToken(token);

        acc_action.setDate(new Timestamp(System.currentTimeMillis()));

        acc_action.setExpires(new Timestamp(System.currentTimeMillis() + 1000L * 60L * 60L * 24L * tokenTTL));

        getSession().persist(acc_action);

    }

        		.add(Restrictions.eq("password", DigestUtils.md5Hex(password))).list();

            return true;

        return false;

    }

    public boolean verifyToken(final String email, final String token) {

        Criteria cr = getSession().createCriteria(AccountAction.class);

        List<AccountAction> ac = cr.add(Restrictions.eq("email", email))

                .add(Restrictions.eq("token", token)).list();

        if (ac.size() > 0)

            return true;

        return false;

    }

        User user = (User) createEntityCriteria().add(Restrictions.eq("email", email)).list().get(0);

        user.setActive(true);

        getSession().update(user);

    }

        Criteria cr = getSession().createCriteria(AccountAction.class);

        AccountAction ac = (AccountAction) cr.add(Restrictions.eq("email", email))

                .add(Restrictions.eq("token", token))

                .add(Restrictions.eq("type", "activation")).list().get(0);

        getSession().delete(ac);

    }

    public boolean updatePassword(final String newPassword, final String email) {

        List<User> rs = createEntityCriteria().add(Restrictions.eq("email", email)).list();

        if (rs.get(0) != null) {

            User user = rs.get(0);

            user.setPassword(DigestUtils.md5Hex(newPassword));

        }

        return false;

    public List<Role> getRoles() {

        projList.add(Projections.distinct(Projections.projectionList()

                .add(Projections.property("id"), "id")))

                .add(Projections.property("role"),"role");

        Criteria cr = getSession().createCriteria(Role.class).setProjection(projList)

                        .setResultTransformer(Transformers.aliasToBean(Role.class));

        if (u != null) {

                user.setPublisher(u.getPublisher());

            if(user.getPassword() == null)

                user.setPassword(u.getPassword());

            if (user.getPassword() != null && !user.getPassword().equals(u.getPassword()))

            User user_merged = (User) getSession().merge(user);

            persist(user);

    //TODO MOVE TO PROJECT DAO

		ProjectCoordinator pc = (ProjectCoordinator) cr.add(Restrictions.eq("email",email)).list().get(0);

		getSession().delete(pc);

		persist(user);

	/*public void saveAffiliations(final User user, final List<Affiliation> affiliations) {

		persist(user);

    public List<User> getUsersByRole(String role_id) {

        Role role = (Role) cr.add(Restrictions.eq("id", role_id)).list().get(0);

        cr = getSession().createCriteria(UserRole.class);

                .add(Restrictions.eq("pk.role", role)).list();

        for (UserRole ur : rs)

            users.add(ur.getPk().getUser());

        return users;

    }

        return getUsersByRole("moderator");

    }

        return getUsersByRole("accounting");

    }

        Criteria cr = getSession().createCriteria(Role.class);

                .setResultTransformer( new AliasToBeanResultTransformer(Role.class));

        return (Role)cr.list().get(0);

        User user = (User) createEntityCriteria().add(Restrictions.eq("email", email)).list().get(0);

        user.setActive(false);

        User user = getUserByEmail(email);

        }

        User user = getUserByEmail(email);

            if (ur.getPk().getRole().getId().equals(roleId)) {

        }

    public List<User> getUsers() {

        return createEntityCriteria().list();

    }

}