Example usage for org.hibernate.criterion Restrictions idEq

List of usage examples for org.hibernate.criterion Restrictions idEq

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. idEq

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions idEq.

Prototype

public static Criterion idEq(Object value)

Source Link

Document

Apply an "equal" constraint to the identifier property

Usage

From source file:mx.edu.um.mateo.rh.dao.impl.EmpleadoDaoHibernate.java

License:Open Source License

/**
 * @see mx.edu.um.mateo.rh.dao.EmpleadoDao#getEmpleado(Empleado empleado)
 *///w w  w  . j  a  v  a  2  s  .  c  om
@Override
@Transactional(readOnly = true)
public Empleado getEmpleado(final Empleado empleado) {
    Empleado emp = new Empleado();

    if (empleado != null) {
        Criteria sql = getSession().createCriteria(Empleado.class);

        // Buscar por id
        if (empleado.getId() != null) {
            sql.add(Restrictions.idEq(empleado.getId()));
        } // Buscar por clave
        else if (empleado.getClave() != null && !"".equals(empleado.getClave())) {
            sql.add(Restrictions.eq("clave", empleado.getClave()));
        }
        emp = (Empleado) sql.uniqueResult();

    }
    if (emp == null) {
        log.warn("uh oh, empleado with id '" + empleado.getId() + "' not found...");
        throw new ObjectRetrievalFailureException(Empleado.class, empleado.getId());
    }
    return emp;
}

From source file:mx.edu.um.mateo.rh.dao.impl.EmpleadoPerDedDaoHibernate.java

License:Open Source License

/**
 * @see mx.edu.um.mateo.rh.dao.EmpleadoPerDedDao#lista(java.util.Map)
 */// w  ww .j a  va  2 s.  c o m
@Override
public Map<String, Object> lista(Map<String, Object> params) {
    log.debug("Buscando lista de perded con params {}", params);
    if (params == null) {
        params = new HashMap<>();
    }

    if (!params.containsKey("max")) {
        params.put("max", 10);
    } else {
        params.put("max", Math.min((Integer) params.get("max"), 100));
    }

    if (params.containsKey("pagina")) {
        Long pagina = (Long) params.get("pagina");
        Long offset = (pagina - 1) * (Integer) params.get("max");
        params.put("offset", offset.intValue());
    }

    if (!params.containsKey("offset")) {
        params.put("offset", 0);
    }
    Criteria criteria = currentSession().createCriteria(EmpleadoPerDed.class)
            .add(Restrictions.eq("status", Constantes.STATUS_ACTIVO));
    Criteria countCriteria = currentSession().createCriteria(EmpleadoPerDed.class)
            .add(Restrictions.eq("status", Constantes.STATUS_ACTIVO));

    if (params.containsKey("empresa")) {
        criteria.createCriteria("empleado").createCriteria("empresa")
                .add(Restrictions.idEq(params.get("empresa")));
        countCriteria.createCriteria("empleado").createCriteria("empresa")
                .add(Restrictions.idEq(params.get("empresa")));
    }
    if (params.containsKey("empleado")) {
        criteria.createCriteria("empleado").add(Restrictions.idEq(params.get("empleadoId")));
        countCriteria.createCriteria("empleado").add(Restrictions.idEq(params.get("empleadoId")));
    }

    if (params.containsKey("filtro")) {
        String filtro = (String) params.get("filtro");
        Disjunction propiedades = Restrictions.disjunction();
        propiedades.add(Restrictions.ilike("empleado.clave", filtro, MatchMode.ANYWHERE));
        propiedades.add(Restrictions.ilike("perded.clave", filtro, MatchMode.ANYWHERE));
        //            propiedades.add(Restrictions.ilike("status", filtro, MatchMode.ANYWHERE));
        criteria.add(propiedades);
        countCriteria.add(propiedades);
    }

    if (params.containsKey("order")) {
        String campo = (String) params.get("order");
        if (params.get("sort").equals("desc")) {
            criteria.addOrder(Order.desc(campo));
        } else {
            criteria.addOrder(Order.asc(campo));
        }
    }

    if (!params.containsKey("reporte")) {
        criteria.setFirstResult((Integer) params.get("offset"));
        criteria.setMaxResults((Integer) params.get("max"));
    }
    params.put(Constantes.EMPLEADOPERDED_LIST, criteria.list());

    countCriteria.setProjection(Projections.rowCount());
    try {
        params.put("cantidad", (Long) countCriteria.list().get(0));
    } catch (IndexOutOfBoundsException e) {
        params.put("cantidad", 0L);
    }

    return params;
}

From source file:mx.edu.um.mateo.rh.dao.impl.PuestoDaoHibernate.java

License:Open Source License

@Override
public Map<String, Object> lista(Map<String, Object> params) {
    log.debug("Buscando lista de puestos con params {}", params);
    if (params == null) {
        params = new HashMap<>();
    }/*from  www . j  ava 2 s.  c  o  m*/

    if (!params.containsKey("max")) {
        params.put("max", 10);
    } else {
        params.put("max", Math.min((Integer) params.get("max"), 100));
    }

    if (params.containsKey("pagina")) {
        Long pagina = (Long) params.get("pagina");
        Long offset = (pagina - 1) * (Integer) params.get("max");
        params.put("offset", offset.intValue());
    }

    if (!params.containsKey("offset")) {
        params.put("offset", 0);
    }
    Criteria criteria = currentSession().createCriteria(Puesto.class);
    Criteria countCriteria = currentSession().createCriteria(Puesto.class);

    if (params.containsKey("empresa")) {
        criteria.createCriteria("empresa").add(Restrictions.idEq(params.get("empresa")));
        countCriteria.createCriteria("empresa").add(Restrictions.idEq(params.get("empresa")));
    }
    //                if (params.containsKey("seccion")) {
    //         criteria.createCriteria("seccion").add(
    //               Restrictions.idEq(params.get("seccion")));
    //         countCriteria.createCriteria("seccion").add(
    //               Restrictions.idEq(params.get("seccion")));
    //      }

    if (params.containsKey("filtro")) {
        String filtro = (String) params.get("filtro");
        Disjunction propiedades = Restrictions.disjunction();
        propiedades.add(Restrictions.ilike("nombre", filtro, MatchMode.ANYWHERE));
        propiedades.add(Restrictions.ilike("nombreCompleto", filtro, MatchMode.ANYWHERE));
        propiedades.add(Restrictions.ilike("rfc", filtro, MatchMode.ANYWHERE));
        propiedades.add(Restrictions.ilike("correo", filtro, MatchMode.ANYWHERE));
        propiedades.add(Restrictions.ilike("contacto", filtro, MatchMode.ANYWHERE));
        criteria.add(propiedades);
        countCriteria.add(propiedades);
    }

    if (params.containsKey("order")) {
        String campo = (String) params.get("order");
        if (params.get("sort").equals("desc")) {
            criteria.addOrder(Order.desc(campo));
        } else {
            criteria.addOrder(Order.asc(campo));
        }
    } else {
        criteria.addOrder(Order.asc("descripcion"));
    }

    if (!params.containsKey("reporte")) {
        criteria.setFirstResult((Integer) params.get("offset"));
        criteria.setMaxResults((Integer) params.get("max"));
    }
    params.put(Constantes.PUESTO_LIST, criteria.list());

    countCriteria.setProjection(Projections.rowCount());
    params.put("cantidad", (Long) countCriteria.list().get(0));

    log.debug("params{} ", params.toString());
    return params;
}

From source file:mx.edu.um.mateo.rh.dao.impl.TipoEmpleadoDaoHibernate.java

License:Open Source License

@Override
@Transactional(readOnly = true)// www . ja  v  a2  s.c  o m
public Map<String, Object> lista(Map<String, Object> params) {
    log.debug("Buscando lista de tipoEmpleados con params {}", params);
    if (params == null) {
        params = new HashMap<>();
    }

    if (!params.containsKey("max")) {
        params.put("max", 10);
    } else {
        params.put("max", Math.min((Integer) params.get("max"), 100));
    }

    if (params.containsKey("pagina")) {
        Long pagina = (Long) params.get("pagina");
        Long offset = (pagina - 1) * (Integer) params.get("max");
        params.put("offset", offset.intValue());
    }

    if (!params.containsKey("offset")) {
        params.put("offset", 0);
    }
    Criteria criteria = currentSession().createCriteria(TipoEmpleado.class);
    Criteria countCriteria = currentSession().createCriteria(TipoEmpleado.class);

    if (params.containsKey("organizacion")) {
        criteria.createCriteria("organizacion").add(Restrictions.idEq(params.get("organizacion")));
        countCriteria.createCriteria("organizacion").add(Restrictions.idEq(params.get("organizacion")));
    }

    if (params.containsKey("filtro")) {
        String filtro = (String) params.get("filtro");
        Disjunction propiedades = Restrictions.disjunction();
        propiedades.add(Restrictions.ilike("descripcion", filtro, MatchMode.ANYWHERE));
        propiedades.add(Restrictions.ilike("prefijo", filtro, MatchMode.ANYWHERE));
        criteria.add(propiedades);
        countCriteria.add(propiedades);
    }

    if (params.containsKey("order")) {
        String campo = (String) params.get("order");
        if (params.get("sort").equals("desc")) {
            criteria.addOrder(Order.desc(campo));
        } else {
            criteria.addOrder(Order.asc(campo));
        }
    }

    if (!params.containsKey("reporte")) {
        criteria.setFirstResult((Integer) params.get("offset"));
        criteria.setMaxResults((Integer) params.get("max"));
    }
    params.put(Constantes.TIPOEMPLEADO_LIST, criteria.list());

    countCriteria.setProjection(Projections.rowCount());
    try {
        params.put("cantidad", (Long) countCriteria.list().get(0));
    } catch (IndexOutOfBoundsException e) {
        params.put("cantidad", 0L);
    }

    return params;
}

From source file:net.firejack.platform.core.store.process.CaseStore.java

License:Apache License

@Override
@Transactional/*from   w  w w . j  a va 2 s . co m*/
public CaseModel moveCaseToActivity(Long entityId, Long activityActionId, Long assigneeId, Long currentUserId,
        String comment) {
    CaseModel processCase;
    if (entityId == null || activityActionId == null || currentUserId == null) {
        processCase = null;
    } else {
        UserModel currentUser = userStore.findById(currentUserId);
        LinkedList<Criterion> restrictions = new LinkedList<Criterion>();
        restrictions.add(Restrictions.idEq(activityActionId));
        Map<String, String> aliases = new HashMap<String, String>();
        aliases.put("activityFrom", "from");
        aliases.put("activityTo", "to");
        aliases.put("status", "status");
        List<ActivityActionModel> foundActions = activityActionStore.search(restrictions, aliases, null);
        ActivityActionModel activityAction = foundActions.get(0);
        UserModel assignee = assigneeId == null ? null : userStore.findById(assigneeId);

        restrictions.clear();
        restrictions.add(Restrictions.idEq(activityAction.getActivityFrom().getId()));
        aliases.clear();
        aliases.put("parent", "parent");
        List<ProcessModel> processList = activityStore.searchWithProjection(restrictions,
                Projections.property("parent"), aliases, null);

        CaseObjectModel caseObjectModel;
        if (processList.isEmpty()) {
            processCase = null;
            caseObjectModel = null;
        } else {
            ProcessModel processModel = processList.get(0);
            EntityModel entityModel = getHibernateTemplate().get(EntityModel.class,
                    processModel.getMain().getId());
            restrictions.clear();
            restrictions.add(Restrictions.eq("entityType", entityModel.getLookup()));
            restrictions.add(Restrictions.eq("entityId", entityId));
            restrictions.add(Restrictions.eq("case.process.id", processModel.getId()));
            aliases.clear();
            aliases.put("case", "case");
            List<CaseObjectModel> caseObjects = caseObjectStore.search(restrictions, aliases, null, false);
            caseObjectModel = caseObjects.isEmpty() ? null : caseObjects.get(0);
            processCase = caseObjectModel == null ? null : caseObjectModel.getCase();
        }

        if (processCase != null) {
            restrictions.clear();
            restrictions.add(Restrictions.and(Restrictions.eq("case.id", processCase.getId()),
                    Restrictions.eq("active", Boolean.TRUE)));
            List<TaskModel> currentActiveTasks = taskStore.search(restrictions, null);
            TaskModel oldActiveTaskModel;
            if (currentActiveTasks.isEmpty()) {
                oldActiveTaskModel = null;
            } else {
                oldActiveTaskModel = currentActiveTasks.get(0);
                for (TaskModel activeTask : currentActiveTasks) {
                    activeTask.setActive(Boolean.FALSE);
                }
                taskStore.saveOrUpdateAll(currentActiveTasks);
            }

            StatusModel status = activityAction.getStatus();

            ActivityModel toActivity = activityAction.getActivityTo();

            boolean isNotFinalStep = !status.getName().equals(StatusModel.STATUS_FINISHED)
                    && toActivity.getActivityOrder() != ActivityOrder.END;

            String taskDescription = StringUtils.isBlank(toActivity.getDescription())
                    ? processCase.getDescription()
                    : toActivity.getDescription();
            Date updateDate = new Date(System.currentTimeMillis());
            TaskModel nextTaskModel = new TaskModel();
            nextTaskModel.setDescription(taskDescription);
            nextTaskModel.setActivity(toActivity);
            nextTaskModel.setCase(processCase);
            nextTaskModel.setUpdateDate(updateDate);
            nextTaskModel.setAssignee(assignee);
            nextTaskModel.setActive(isNotFinalStep);
            taskStore.saveOrUpdate(nextTaskModel);
            processCase.setStatus(status);
            processCase.setActive(isNotFinalStep);
            saveOrUpdate(processCase);

            caseObjectModel.setTask(nextTaskModel);
            caseObjectModel.setStatus(status);
            caseObjectModel.setUpdateDate(updateDate);
            caseObjectModel.setUpdatedBy(currentUser);
            caseObjectStore.saveOrUpdate(caseObjectModel);

            if (oldActiveTaskModel != null) {
                CaseActionModel caseAction = new CaseActionModel();
                caseAction.setPerformedOn(updateDate);
                caseAction.setType(CaseActionType.PERFORM_ACTIVITY);
                caseAction.setCase(processCase);
                caseAction.setUser(currentUser);
                caseAction.setTaskModel(oldActiveTaskModel);
                if (StringUtils.isNotBlank(comment)) {
                    CaseNoteModel caseNote = new CaseNoteModel();
                    caseNote.setProcessCase(processCase);
                    caseNote.setText(comment);
                    caseNote.setUser(currentUser);
                    caseNoteStore.saveOrUpdate(caseNote);
                    caseAction.setCaseNote(caseNote);
                }
                caseActionStore.saveOrUpdate(caseAction);
            }
        }
    }
    return processCase;
}

From source file:net.gasbooknet.web.app.PostWorkVPAction.java

public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest req,
        HttpServletResponse res) throws Exception {

    Work work = new WorkImpl();
    WorkForm workform = (WorkForm) form;

    String error = "";

    Integer intraUserInt = workform.getIntraUser();
    workform.setIntraUser(null);//from ww  w.  j  a  va  2 s  .com
    Integer artistInt = workform.getArtist();
    workform.setArtist(null);

    Session session = new HibernateSession().currentSession(this.getServlet().getServletContext());
    if (workform.getId() == null || workform.getId().intValue() == 0) {
        work.setId(null);
        workform.setId(null);
    } else {
        work.setId(workform.getId());
        Criteria criteria = session.createCriteria(Work.class);
        criteria.add(Restrictions.idEq(Integer.valueOf(req.getParameter("id"))));
        work = (Work) criteria.uniqueResult();

    }
    work.setName(workform.getName());
    work.setDate(workform.getDate());
    work.setYear(workform.getYear());
    work.setDescription(workform.getDescription());
    work.setPoplular(workform.isPoplular());
    work.setPoplularity(workform.getPoplularity());
    work.setClient(workform.isClient());
    work.setProjectname(workform.getProjectname());
    work.setCopywrite(workform.getCopywrite());
    work.setProductionpurpose(workform.getProductionpurpose());
    work.setExposurehistory(workform.getExposurehistory());
    work.setCredit(workform.getCredit());
    work.setClientname(workform.getClientname());
    work.setCilentrequest(workform.getCilentrequest());
    work.setTitle(workform.getTitle());
    work.setExpiredate(workform.getExpiredate());
    work.setLicensed(workform.isLicensed());
    work.setParticulars(workform.getParticulars());
    work.setComments(workform.getComments());
    work.setLicensingpossibleafterexpired(workform.isLicensingpossibleafterexpired());

    StringFullfiller.fullfil(work);
    Criteria criteria2 = session.createCriteria(IntraUser.class);
    criteria2.add(Restrictions.idEq(intraUserInt));
    IntraUser intrauser = (IntraUser) criteria2.uniqueResult();
    work.setIntraUser(intrauser);
    criteria2 = session.createCriteria(Artist.class);
    criteria2.add(Restrictions.idEq(artistInt));
    Artist artist = (Artist) criteria2.uniqueResult();
    work.setArtist(artist);

    Transaction transaction = session.beginTransaction();
    session.saveOrUpdate(work);
    transaction.commit();
    session.flush();
    if (req.getParameter("from") != null && req.getParameter("from").equals("detail")) {
        new HTTPGetRedirection(req, res, "PostWorkDetail.do", work.getId().toString());
    }
    if (StringUtils.isNotBlank(req.getParameter("ajax"))) {
        req.setAttribute("message", "success");
        return mapping.findForward("success");
    }

    new HTTPGetRedirection(req, res, "Works.do", work.getId().toString());
    return null;

}

From source file:net.hybridcore.crowley.habbo.messages.incoming.friendlist.AcceptBuddyMessageEvent.java

License:BEER-WARE LICENSE

public void run() {
    Session session = DatastoreUtil.currentSession();
    int count = this.clientMessage.readInt();

    for (int i = 0; i < count; i++) {
        int habboId = this.clientMessage.readInt();
        Habbo buddy = (Habbo) session.createCriteria(Habbo.class).add(Restrictions.idEq((long) habboId))
                .uniqueResult();//from w  w  w.j  ava 2  s. com

        // Invalid id, the fuck? We should probably delete this request at some point
        if (buddy == null) {
            break;
        }

        boolean valid = false;

        for (Habbo habbo : this.gameSession.getHabbo().getFriendRequests()) {
            if (habbo.getId().equals((long) habboId)) {
                valid = true;
            }
        }

        // Somebody is trying to add friends who didn't request it!
        if (!valid) {
            break;
        }

        if (buddy.isOnline()) {
            // fetch active session
            GameSession target = Crowley.getHabbo().getSessions().getSessionByHabboId(buddy.getId());
            buddy = target.getHabbo();

            buddy = (Habbo) session.merge(buddy);
            buddy.friendRequiresUpdate(this.gameSession.getHabbo().getId());
            session.saveOrUpdate(buddy);

            Crowley.getExecutorService().execute(new FriendListUpdateComposer(target));
        }

        this.gameSession.setHabbo((Habbo) session.merge(this.gameSession.getHabbo()));
        this.gameSession.getHabbo().addFriend(buddy);
        this.gameSession.getHabbo().friendRequiresUpdate(buddy.getId());

        session.saveOrUpdate(this.gameSession.getHabbo());

        Crowley.getExecutorService().execute(new FriendListUpdateComposer(this.gameSession));
    }
}

From source file:net.musicmug.web.app.PostCDVPAction.java

public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest req,
        HttpServletResponse res) throws Exception {

    CD cD = new CDImpl();
    CDForm cDform = (CDForm) form;// w w w .j a v a 2 s  . c  o  m

    String error = "";

    Integer intraUserInt = cDform.getIntraUser();
    cDform.setIntraUser(null);
    Integer artistInt = cDform.getArtist();
    cDform.setArtist(null);

    Session session = new HibernateSession().currentSession(this.getServlet().getServletContext());
    if (cDform.getId() == null || cDform.getId().intValue() == 0) {
        cD.setId(null);
        cDform.setId(null);
    } else {
        cD.setId(cDform.getId());
        Criteria criteria = session.createCriteria(CD.class);
        criteria.add(Restrictions.idEq(Integer.valueOf(req.getParameter("id"))));
        cD = (CD) criteria.uniqueResult();

    }
    cD.setName(cDform.getName());
    cD.setDate(cDform.getDate());
    cD.setYear(cDform.getYear());
    cD.setDescription(cDform.getDescription());
    cD.setTitle(cDform.getTitle());
    cD.setPoplular(cDform.isPoplular());
    cD.setPoplularity(cDform.getPoplularity());
    cD.setProjectname(cDform.getProjectname());
    cD.setCopywrite(cDform.getCopywrite());
    cD.setProductionpurpose(cDform.getProductionpurpose());
    cD.setExposurehistory(cDform.getExposurehistory());
    cD.setCredit(cDform.getCredit());
    cD.setClient(cDform.isClient());
    cD.setClientname(cDform.getClientname());
    cD.setCilentrequest(cDform.getCilentrequest());
    cD.setExpiredate(cDform.getExpiredate());
    cD.setLicensed(cDform.isLicensed());
    cD.setParticulars(cDform.getParticulars());
    cD.setComments(cDform.getComments());
    cD.setLicensingpossibleafterexpired(cDform.isLicensingpossibleafterexpired());

    StringFullfiller.fullfil(cD);
    Criteria criteria2 = session.createCriteria(IntraUser.class);
    criteria2.add(Restrictions.idEq(intraUserInt));
    IntraUser intrauser = (IntraUser) criteria2.uniqueResult();
    cD.setIntraUser(intrauser);
    criteria2 = session.createCriteria(Artist.class);
    criteria2.add(Restrictions.idEq(artistInt));
    Artist artist = (Artist) criteria2.uniqueResult();
    cD.setArtist(artist);

    Transaction transaction = session.beginTransaction();
    session.saveOrUpdate(cD);
    transaction.commit();
    session.flush();
    if (req.getParameter("from") != null && req.getParameter("from").equals("detail")) {
        new HTTPGetRedirection(req, res, "PostCDDetail.do", cD.getId().toString());
    }
    if (StringUtils.isNotBlank(req.getParameter("ajax"))) {
        req.setAttribute("message", "success");
        return mapping.findForward("success");
    }

    new HTTPGetRedirection(req, res, "CDs.do", cD.getId().toString());
    return null;

}

From source file:net.przemkovv.sphinx.dao.impl.DefaultGenericDAO.java

License:Open Source License

@Override
public <T extends Object> T getById(Long id, String[] collectionsToBeInitialized) {
    T entity = (T) getCurrentSession().createCriteria(type).add(Restrictions.idEq(id))
            .setFetchMode(collectionsToBeInitialized[0], FetchMode.JOIN).uniqueResult();
    int length = collectionsToBeInitialized.length;
    for (int idx = 1; idx < length; idx++) {
        String collectionName = collectionsToBeInitialized[idx];
        try {/*  ww w .j  av  a  2s .com*/
            Method m = type.getMethod(
                    "get" + collectionName.substring(0, 1).toUpperCase() + collectionName.substring(1));
            Hibernate.initialize(m.invoke(entity, (Object[]) null));
        } catch (NoSuchMethodException | InvocationTargetException | IllegalAccessException e) {
            logger.error("Could not initialize collection " + collectionName + " of class Event", e);
        }
    }
    return entity;
}

From source file:net.sf.showtracker.dao.VerificationTokenDaoImpl.java

@Override
public VerificationToken getByTokenValue(String token) {
    try {/*from   www.j av  a 2s.c o m*/
        return (VerificationToken) getCurrentSession().createCriteria(VerificationToken.class)
                .add(Restrictions.idEq(token)).uniqueResult();
    } catch (HibernateException e) {
        throw new ServiceException("Error during retrieving token.", e);
    }
}