Example usage for org.hibernate.criterion DetachedCriteria forClass

List of usage examples for org.hibernate.criterion DetachedCriteria forClass

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. DetachedCriteria
  6. forClass

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria forClass.

Prototype

public static DetachedCriteria forClass(Class clazz)

Source Link

Document

Static builder to create a DetachedCriteria for the given entity, by its Class.

Usage

From source file:com.isdemu.dao.impl.TB_DescargoDaoImp.java

@Override
public List getTop() {
    DetachedCriteria dc = DetachedCriteria.forClass(TbDescargo.class);
    Date fecha_finalHoy = new Date();
    Date fecha_inicial = new Date();

    //restar dias a la fecha
    Calendar calendar = Calendar.getInstance();
    calendar.setTime(fecha_finalHoy);//from  w ww.  j  ava2  s .c o m
    calendar.add(Calendar.DAY_OF_YEAR, -7); // numero de das a aadir, o restar en caso de das<0
    fecha_inicial = calendar.getTime();

    dc.add(Restrictions.between("fecha", fecha_inicial, fecha_finalHoy));
    System.out.println("fecha inicial:" + fecha_inicial + "fecha final:" + fecha_finalHoy);

    return dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list();
}

From source file:com.isdemu.dao.impl.TB_InventarioDaoImpl.java

@Override
public List<TbInventario> getAll() {
    // TODO Auto-generated method stub
    DetachedCriteria dc = DetachedCriteria.forClass(TbInventario.class);

    List<TbInventario> inventario = dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list();
    return inventario;
}

From source file:com.isdemu.dao.impl.TB_InventarioDaoImpl.java

@Override
public List getTop() {
    // TODO Auto-generated method stub
    DetachedCriteria dc = DetachedCriteria.forClass(TbInventario.class);
    dc.addOrder(Order.asc("idInventario"));

    Date fecha_finalHoy = new Date();
    Date fecha_inicial = new Date();

    //restar dias a la fecha
    Calendar calendar = Calendar.getInstance();
    calendar.setTime(fecha_finalHoy);/*  ww w .j  a v a2s  .c  o m*/
    calendar.add(Calendar.DAY_OF_YEAR, -7); // numero de das a aadir, o restar en caso de das<0
    fecha_inicial = calendar.getTime();

    dc.add(Restrictions.between("fechaInsert", fecha_inicial, fecha_finalHoy));
    System.out.println("fecha inicial:" + fecha_inicial + "fecha final:" + fecha_finalHoy);

    return dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list();
}

From source file:com.isdemu.dao.impl.TB_MovimientoDaoImp.java

@Override
public List getAll() {
    // TODO Auto-generated method stub
    DetachedCriteria dc = DetachedCriteria.forClass(TbMovimiento.class);
    // System.out.println("criteria="+dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list().get(0));
    // dc.addOrder(Order.asc("codigo_inventario"));
    return dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list();
}

From source file:com.isdemu.dao.impl.TB_PrestamoDaoImpl.java

@Override
public List getAll() {
    // TODO Auto-generated method stub
    DetachedCriteria dc = DetachedCriteria.forClass(TbPrestamoEquipo.class);
    // System.out.println("criteria="+dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list().get(0));
    // dc.addOrder(Order.asc("codigo_inventario"));
    return dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list();
}

From source file:com.jaspersoft.jasperserver.api.engine.common.service.impl.HibernateLoggingService.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRED)
public List getUserEvents(ExecutionContext context) {
    List<RepoLogEvent> events;
    RepoUser user = userHandler.getPersistentUserFromContext();
    if (user != null) {
        DetachedCriteria criteria = DetachedCriteria.forClass(RepoLogEvent.class);
        criteria.add(Restrictions.eq("user", user));
        criteria.addOrder(Order.desc("occurrenceDate"));

        //noinspection unchecked
        events = getHibernateTemplate().findByCriteria(criteria);
    } else {//from  w  w  w .j a  v a2 s .  co m
        events = Collections.emptyList();
    }

    return getClientEvents(events);
}

From source file:com.jaspersoft.jasperserver.api.engine.common.service.impl.HibernateLoggingService.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRED)
public List<LogEvent> getUnreadEvents(ExecutionContext context) {
    List<RepoLogEvent> events;
    RepoUser user = userHandler.getPersistentUserFromContext();
    if (user != null) {
        DetachedCriteria criteria = DetachedCriteria.forClass(RepoLogEvent.class);
        criteria.add(Restrictions.eq("state", LogEvent.STATE_UNREAD));
        criteria.add(Restrictions.eq("user", user));
        criteria.addOrder(Order.desc("occurrenceDate"));

        //noinspection unchecked
        events = getHibernateTemplate().findByCriteria(criteria);
    } else {//ww w .ja v  a  2s .  c  om
        events = Collections.emptyList();
    }

    return getClientEvents(events);
}

From source file:com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.HibernateReportJobsPersistenceService.java

License:Open Source License

protected List getReportUnitJobs(final String reportUnitURI) {
    HibernateTemplate hibernateTemplate = getHibernateTemplate();
    DetachedCriteria crit = DetachedCriteria.forClass(PersistentReportJob.class);
    crit.add(Restrictions.eq("source.reportUnitURI", reportUnitURI));
    return hibernateTemplate.findByCriteria(crit);
}

From source file:com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.HibernateReportJobsPersistenceService.java

License:Open Source License

protected List getReportUnitJobs(final ReportJobModel criteriaReportJob, ExecutionContext context) {
    if (criteriaReportJob == null)
        return getAllJobs();
    boolean requireDetailSearch = false;
    HibernateTemplate hibernateTemplate = getHibernateTemplate();
    DetachedCriteria crit = DetachedCriteria.forClass(PersistentReportJob.class);
    // REPORT JOB (MAIN CLASS)
    if (criteriaReportJob.isBaseOutputFileNameModified())
        addLikeRestriction(crit, "baseOutputFilename", criteriaReportJob.getBaseOutputFilename());
    if (criteriaReportJob.isCreationDateModified() && criteriaReportJob.getCreationDate() != null)
        requireDetailSearch = true;//from   ww w .j  av  a 2  s .  co  m
    if (criteriaReportJob.isLabelModified())
        addLikeRestriction(crit, "label", criteriaReportJob.getLabel());
    if (criteriaReportJob.isDescriptionModified())
        addLikeRestriction(crit, "description", criteriaReportJob.getDescription());
    if (criteriaReportJob.isOutputLocaleModified())
        addEqualRestriction(crit, "outputLocale", criteriaReportJob.getOutputLocale());
    // USER REPO
    final String username = criteriaReportJob.getUsername();
    if (criteriaReportJob.isUsernameModified() && username != null) {
        String[] nameTenant = username.split("\\|");
        crit.createAlias("owner", "owner");
        addEqualRestriction(crit, "owner.username", nameTenant[0]);
        crit.createAlias("owner.tenant", "tenant");
        addEqualRestriction(crit, "tenant.tenantId",
                nameTenant.length > 1 ? nameTenant[1] : TenantService.ORGANIZATIONS);
    }
    if (criteriaReportJob.isOutputFormatsModified() && criteriaReportJob.getOutputFormatsSet() != null)
        requireDetailSearch = true;
    // REPORT TRIGGER
    if (criteriaReportJob.isTriggerModified() && criteriaReportJob.getTriggerModel() != null)
        requireDetailSearch = true;
    // REPORT JOB SOURCE
    if (criteriaReportJob.isSourceModified() && criteriaReportJob.getSourceModel() != null) {
        ReportJobSourceModel des = criteriaReportJob.getSourceModel();
        if (des.isParametersMapModified())
            addEqualRestriction(crit, "source.parametersMap", des.getParametersMap());
        if (des.isReportUnitURIModified())
            addLikeRestriction(crit, "source.reportUnitURI", des.getReportUnitURI());
    }
    // REPORTJOBREPOSITORYDESTINATION
    if (criteriaReportJob.isContentRespositoryDestinationModified()
            && criteriaReportJob.getContentRepositoryDestinationModel() != null) {
        crit.createAlias("contentRepositoryDestination", "contentRepositoryDestination");
        ReportJobRepositoryDestinationModel des = criteriaReportJob.getContentRepositoryDestinationModel();
        if (des.isFolderURIModified())
            addLikeRestriction(crit, "contentRepositoryDestination.folderURI", des.getFolderURI());
        if (des.isOutputDescriptionsModified())
            addLikeRestriction(crit, "contentRepositoryDestination.outputDescription",
                    des.getOutputDescription());
        if (des.isTimestampPatternModified())
            addEqualRestriction(crit, "contentRepositoryDestination.timestampPattern",
                    des.getTimestampPattern());
        if (des.isOverwriteFilesModified())
            addEqualRestriction(crit, "contentRepositoryDestination.overwriteFiles", des.isOverwriteFiles());
        if (des.isSaveToRepositoryModified())
            addEqualRestriction(crit, "contentRepositoryDestination.saveToRepository",
                    des.isSaveToRepository());
        if (des.isSequentialFilenamesModified())
            addEqualRestriction(crit, "contentRepositoryDestination.sequentialFilenames",
                    des.isSequentialFilenames());
        if (des.isDefaultReportOutputFolderURIModified())
            requireDetailSearch = true;
        if (des.isUsingDefaultReportOutputFolderURIModified()) {
            addEqualRestriction(crit, "contentRepositoryDestination.usingDefaultReportOutputFolderURI",
                    des.isUsingDefaultReportOutputFolderURI());
        }
        if (des.isOutputLocalFolderModified())
            addEqualRestriction(crit, "contentRepositoryDestination.outputLocalFolder",
                    des.getOutputLocalFolder());

        // FTP INFO
        if (des.isOutputFTPInfoModified() && des.getOutputFTPInfoModel() != null) {
            FTPInfoModel ftpInfoModel = des.getOutputFTPInfoModel();
            if (ftpInfoModel.isUserNameModified())
                addLikeRestriction(crit, "contentRepositoryDestination.outputFTPInfo.userName",
                        ftpInfoModel.getUserName());
            if (ftpInfoModel.isPasswordModified())
                addEqualRestriction(crit, "contentRepositoryDestination.outputFTPInfo.password",
                        ftpInfoModel.getPassword());
            if (ftpInfoModel.isServerNameModified())
                addLikeRestriction(crit, "contentRepositoryDestination.outputFTPInfo.server_name",
                        ftpInfoModel.getUserName());
            if (ftpInfoModel.isFolderPathModified())
                addLikeRestriction(crit, "contentRepositoryDestination.outputFTPInfo.folder_path",
                        ftpInfoModel.getPassword());
            if (ftpInfoModel.isPropertiesMapModified())
                addEqualRestriction(crit, "contentRepositoryDestination.outputFTPInfo.propertiesMap",
                        ftpInfoModel.getPropertiesMap());
        }
    }
    // MAILNOTIFICATION
    if (criteriaReportJob.isMailNotificationModified()
            && criteriaReportJob.getMailNotificationModel() != null) {
        crit.createAlias("mailNotification", "mailNotification");
        ReportJobMailNotificationModel des = criteriaReportJob.getMailNotificationModel();
        if (des.isSubjectModified())
            addLikeRestriction(crit, "mailNotification.subject", des.getSubject());
        if (des.isMessageTextModified())
            addLikeRestriction(crit, "mailNotification.messageText", des.getMessageText());
        if (des.isMessageTextWhenJobFailsModified())
            addLikeRestriction(crit, "mailNotification.messageTextWhenJobFails",
                    des.getMessageTextWhenJobFails());
        if (des.isIncludingStackTraceWhenJobFailsModified())
            addEqualRestriction(crit, "mailNotification.includingStackTraceWhenJobFails",
                    des.isIncludingStackTraceWhenJobFails());
        if (des.isSkipNotificationWhenJobFailsModified())
            addEqualRestriction(crit, "mailNotification.skipNotificationWhenJobFails",
                    des.isSkipNotificationWhenJobFails());
        if (des.isResultSendTypeModified())
            addEqualRestriction(crit, "mailNotification.resultSendType", des.getResultSendTypeCode());
        if (des.isSkipEmptyReportsModified())
            addEqualRestriction(crit, "mailNotification.skipEmptyReports", des.isSkipEmptyReports());
        if (((des.isToAddressesModified()) && (des.getToAddresses() != null)
                && (des.getToAddresses().size() > 0))
                || ((des.isCcAddressesModified()) && (des.getCcAddresses() != null)
                        && (des.getCcAddresses().size() > 0))
                || ((des.isBccAddressesModified()) && (des.getBccAddresses() != null)
                        && (des.getBccAddresses().size() > 0)))
            requireDetailSearch = true;
    }
    // ALERT
    if (criteriaReportJob.isAlertModified() && criteriaReportJob.getAlertModel() != null) {
        crit.createAlias("alert", "alert");
        ReportJobAlertModel des = criteriaReportJob.getAlertModel();
        if (des.isMessageTextModified())
            addLikeRestriction(crit, "alert.messageText", des.getMessageText());
        if (des.isMessageTextWhenJobFailsModified())
            addLikeRestriction(crit, "alert.messageTextWhenJobFails", des.getMessageTextWhenJobFails());
        if (des.isSubjectModified())
            addLikeRestriction(crit, "alert.subject", des.getSubject());
        if (des.isIncludingStackTraceModified())
            addEqualRestriction(crit, "alert.includingStackTrace", des.isIncludingStackTrace());
        if (des.isIncludingReportJobInfoModified())
            addEqualRestriction(crit, "alert.includingReportJobInfo", des.isIncludingReportJobInfo());
        if (des.isJobStateModified())
            addEqualRestriction(crit, "alert.jobState", des.getJobState());
        if (des.isRecipientModified())
            addEqualRestriction(crit, "alert.recipient", des.getRecipient());
        if (des.isToAddressesModified())
            requireDetailSearch = true;
    }
    List persistentJobs = hibernateTemplate.findByCriteria(crit);
    if (requireDetailSearch && (persistentJobs != null)) {
        for (int i = persistentJobs.size() - 1; i >= 0; i--) {
            if (!detailCriteriaMatch((PersistentReportJob) persistentJobs.get(i), criteriaReportJob, context)) {
                persistentJobs.remove(i);
            }
        }
    }
    return persistentJobs;
}

From source file:com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.HibernateReportJobsPersistenceService.java

License:Open Source License

protected List getJobsByID(List<ReportJobIdHolder> jobIDList) {
    HibernateTemplate hibernateTemplate = getHibernateTemplate();
    DetachedCriteria crit = DetachedCriteria.forClass(PersistentReportJob.class);
    Disjunction criterion = Restrictions.disjunction();
    for (ReportJobIdHolder idHolder : jobIDList)
        criterion.add(Restrictions.eq("id", idHolder.getId()));
    crit.add(criterion);/*from   w  w  w  .  j av  a2 s .  com*/
    List persistentJobs = hibernateTemplate.findByCriteria(crit);
    return persistentJobs;
}