Example usage for com.liferay.portal.kernel.dao.orm OrderFactoryUtil desc

List of usage examples for com.liferay.portal.kernel.dao.orm OrderFactoryUtil desc

  1. HOME
  2. Java
  3. com.liferay.portal
  4. com.liferay.portal.kernel.dao.orm.*
  5. OrderFactoryUtil
  6. desc

Introduction

In this page you can find the example usage for com.liferay.portal.kernel.dao.orm OrderFactoryUtil desc.

Prototype

public static Order desc(String propertyName)

Source Link

Usage

From source file:at.graz.hmmc.liferay.portlet.puch.service.impl.TransaktionLocalServiceImpl.java

License:Open Source License

/**
 * //from  w  ww.  j  av a  2s .c o m
 */
public Transaktion getLastTransactionOfType(long puchmuseumsobjectId, String transactiontype) {
    try {
        DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(Transaktion.class);
        Criterion criterion = RestrictionsFactoryUtil.eq("puchmuseumsobjectId", puchmuseumsobjectId);
        criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.eq("typ", transactiontype));
        criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.isNull("endDate"));
        dynamicQuery.add(criterion);
        Order order = OrderFactoryUtil.desc("startDate");
        dynamicQuery.addOrder(order);
        List<Transaktion> transactions = TransaktionLocalServiceUtil.dynamicQuery(dynamicQuery);
        if (transactions != null) {
            if (transactions.size() != 0) {
                return transactions.get(0);
            }
        }
    } catch (Exception ex) {
        System.err.println("[" + date_format_apache_error.format(new Date())
                + "] [error] [PuchMuseum-portlet::at.graz.hmmc.liferay.portlet.puch.service.impl.TransaktionLocalServiceImpl::getLastTransactionOfType] Error getting Transaktion.");
        ex.printStackTrace();
    }
    return null;
}

From source file:at.graz.meduni.liferay.portlet.bibbox.kdssmp.service.model.impl.KdssmpPatientImpl.java

License:Open Source License

public Event getLastEventOfType(String eventtype) {
    DynamicQuery dynamicQuery = EventLocalServiceUtil.dynamicQuery();
    Criterion criterion = RestrictionsFactoryUtil.ilike("eventtype", eventtype);
    dynamicQuery.add(criterion);//from   w  ww. ja v a2  s  .  com
    dynamicQuery.addOrder(OrderFactoryUtil.desc("eventdate"));
    try {
        List<Event> events = EventLocalServiceUtil.dynamicQuery(dynamicQuery);
        if (events.size() > 1) {
            return events.get(0);
        }
    } catch (SystemException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    return null;
}

From source file:at.graz.meduni.liferay.portlet.bibbox.service.service.impl.InvitationOrganisationLocalServiceImpl.java

License:Open Source License

/**
 * @throws SystemException //from w  w w . j a  v  a 2  s  .  com
 */
public List<InvitationOrganisation> getInvitationOrganisationByStatus(boolean rejacted) throws SystemException {
    /*DynamicQuery subQuery = DynamicQueryFactoryUtil.forClass(Invitation.class, "subQuery", PortalClassLoaderUtil.getClassLoader())
    .setProjection(ProjectionFactoryUtil.property("subQuery.invitationId"))
    .add(PropertyFactoryUtil.forName("subQuery.invitationId").eqProperty("answerdQuery.invitationId"))
    .add(PropertyFactoryUtil.forName("subQuery.invitationsend").isNotNull());
            
    DynamicQuery answerdQuery = DynamicQueryFactoryUtil.forClass(InvitationOrganisation.class, "answerdQuery", PortalClassLoaderUtil.getClassLoader())
    .add(PropertyFactoryUtil.forName("subQuery.invitationId").eq(subQuery));*/

    DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(InvitationOrganisation.class);
    Criterion criterion = null;
    if (rejacted) {
        criterion = RestrictionsFactoryUtil.isNotNull("reactdate");
        dynamicQuery.addOrder(OrderFactoryUtil.desc("reactdate"));
    } else {
        criterion = RestrictionsFactoryUtil.isNull("reactdate");
    }
    dynamicQuery.addOrder(OrderFactoryUtil.desc("invitationOrganisationId"));

    //dynamicQuery.setProjection(ProjectionFactoryUtil.groupProperty("organisationId"));

    dynamicQuery.add(criterion);

    List<InvitationOrganisation> invitationorganisation = InvitationOrganisationLocalServiceUtil
            .dynamicQuery(dynamicQuery);
    return invitationorganisation;
}

From source file:at.meduni.liferay.portlet.bbmrieric.service.impl.SearchIndexLocalServiceImpl.java

License:Open Source License

public String[] getCountry() {
    try {// w w w  . j a  v a2s .co m
        DynamicQuery dynamicQuery = SearchIndexLocalServiceUtil.dynamicQuery();
        Criterion criterion = RestrictionsFactoryUtil.like("searchindexkey", "biobankCountry");
        dynamicQuery.add(criterion);
        ProjectionList projectionList = ProjectionFactoryUtil.projectionList();
        projectionList.add(ProjectionFactoryUtil.groupProperty("searchindexvalue"));
        //projectionList.add(ProjectionFactoryUtil.rowCount());
        dynamicQuery.setProjection(projectionList);
        Order defaultOrder = OrderFactoryUtil.desc("searchindexvalue");
        dynamicQuery.addOrder(defaultOrder);
        List<Object> results = SearchIndexLocalServiceUtil.dynamicQuery(dynamicQuery);
        /*for(Object result : results) {
           System.out.println(result);   
        }*/
        return results.toArray(new String[results.size()]);
    } catch (Exception ex) {
        ex.printStackTrace();
    }
    return new String[] {};
}

From source file:at.meduni.liferay.portlet.rdconnect.service.impl.CandidateLocalServiceImpl.java

License:Open Source License

public List<Candidate> getFilterdCandidates(String name, String country, String type, String source,
        String state) throws SystemException {
    if (country.equals("all")) {
        country = "";
    }//from w ww  . j a v  a  2 s . c om
    if (type.equals("all")) {
        type = "";
    } else {
        if (type.equals("Registry"))
            type = "Registr";
    }
    if (source.equals("all")) {
        source = "";
    }
    if (state.equals("all")) {
        state = "";
    }

    // Dynamic Query for search
    DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(Candidate.class);

    Criterion criterion = null;

    Criterion criterion_subunit = RestrictionsFactoryUtil.isNull("subunitof");
    criterion_subunit = RestrictionsFactoryUtil.or(criterion_subunit,
            RestrictionsFactoryUtil.eq("subunitof", ""));

    Criterion criterion_diseases = RestrictionsFactoryUtil.ilike("diseasesfreetext",
            StringPool.PERCENT + name + StringPool.PERCENT);
    criterion_diseases = RestrictionsFactoryUtil.or(criterion_diseases,
            RestrictionsFactoryUtil.ilike("diseasescodes", StringPool.PERCENT + name + StringPool.PERCENT));
    criterion_diseases = RestrictionsFactoryUtil.or(criterion_diseases,
            RestrictionsFactoryUtil.ilike("name", StringPool.PERCENT + name + StringPool.PERCENT));
    criterion_diseases = RestrictionsFactoryUtil.or(criterion_diseases,
            RestrictionsFactoryUtil.ilike("candidatesubtype", StringPool.PERCENT + name + StringPool.PERCENT));

    try {
        long searchlong = Long.valueOf(name);
        criterion_diseases = RestrictionsFactoryUtil.or(criterion_diseases,
                RestrictionsFactoryUtil.eq("candidateId", searchlong));
    } catch (Exception e) {

    }

    criterion = RestrictionsFactoryUtil.ilike("source", StringPool.PERCENT + source + StringPool.PERCENT);
    criterion = RestrictionsFactoryUtil.and(criterion,
            RestrictionsFactoryUtil.ilike("country", StringPool.PERCENT + country + StringPool.PERCENT));
    criterion = RestrictionsFactoryUtil.and(criterion,
            RestrictionsFactoryUtil.ilike("candidatetype", StringPool.PERCENT + type + StringPool.PERCENT));
    if (state.equalsIgnoreCase("")) {
        criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil
                .not(RestrictionsFactoryUtil.ilike("state", StringPool.PERCENT + "X" + StringPool.PERCENT)));
    } else {
        criterion = RestrictionsFactoryUtil.and(criterion,
                RestrictionsFactoryUtil.ilike("state", StringPool.PERCENT + state + StringPool.PERCENT));
    }
    criterion = RestrictionsFactoryUtil.and(criterion, criterion_diseases);
    criterion = RestrictionsFactoryUtil.and(criterion, criterion_subunit);

    dynamicQuery.add(criterion);

    Order countryOrder = OrderFactoryUtil.desc("country");
    Order nameOrder = OrderFactoryUtil.desc("name");
    //Order candidateidOrder = OrderFactoryUtil.asc("candidateId");
    //Order masteridOrder = OrderFactoryUtil.desc("masterId");

    dynamicQuery.addOrder(countryOrder);
    dynamicQuery.addOrder(nameOrder);

    List<Candidate> candidates = CandidateLocalServiceUtil.dynamicQuery(dynamicQuery);

    //List<Candidate> candidates = candidatePersistence.findByCNSTDD(country, name, source, type, diseases_freetext, diseases_code, "");
    return candidates;
}

From source file:at.meduni.liferay.portlet.rdconnect.service.impl.RDCRecommenderLocalServiceImpl.java

License:Open Source License

/**
 * Returns a number of Recommandations for a user
 * /*from  ww  w  . j  ava2 s .c  o  m*/
 * @param userId
 * @return
 */
public List<RDCRecommender> getReconnandationsForUser(long userId) {
    try {
        List<Organization> organizations = OrganizationLocalServiceUtil.getUserOrganizations(userId);
        //System.out.println("Number of Organizations for user: " + organizations.size());
        DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(RDCRecommender.class);
        Criterion criterion = null;
        for (Organization organization : organizations) {
            if (criterion == null) {
                criterion = RestrictionsFactoryUtil.eq("organisationId", organization.getOrganizationId());
                //criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.eq("recommendedorganisationId", organization.getOrganizationId()));
            } else {
                criterion = RestrictionsFactoryUtil.or(criterion,
                        RestrictionsFactoryUtil.eq("organisationId", organization.getOrganizationId()));
                //criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.eq("recommendedorganisationId", organization.getOrganizationId()));
            }
        }
        if (criterion == null) {
            return null;
        }
        //System.out.println("Criterion" + criterion.toString());
        dynamicQuery.add(criterion);
        Order recommendervalueOrder = OrderFactoryUtil.desc("recommendervalue");
        dynamicQuery.addOrder(recommendervalueOrder);
        List<RDCRecommender> rdcrecommenders = RDCRecommenderLocalServiceUtil.dynamicQuery(dynamicQuery);
        return rdcrecommenders;
    } catch (Exception ex) {
        System.out.println("ERROR: RDCRecommenderLocalServiceImpl::getReconnandationsForUser");
        ex.printStackTrace();
    }
    return null;
}

From source file:com.commsen.liferay.multidevice.rules.service.impl.RuleLocalServiceImpl.java

License:Open Source License

/**
 * Returns list of rules matching the company, group, layout and user's device.
 * //from ww w  .  j  av a  2s  . c o m
 * @param companyId company (instance) id
 * @param groupId group (community/organization) id
 * @param layoutId layout (page) id
 * @param device user's device
 * @action the rule action type (change theme, redirect)
 * @return list of rules matching the company, group, layout and user's device.
 */
public List<Rule> getMatchingRules(long companyId, long groupId, long layoutId, Device device) {
    List<Rule> result = Collections.emptyList();

    // Brand and model query part
    Junction modelMatchesOrNull = RestrictionsFactoryUtil.disjunction();
    modelMatchesOrNull.add(PropertyFactoryUtil.forName("model").eq(device.getModel()));
    modelMatchesOrNull.add(PropertyFactoryUtil.forName("model").isNull());

    Junction brandMatchesAndModelMatchesOrNull = RestrictionsFactoryUtil.conjunction();
    brandMatchesAndModelMatchesOrNull.add(PropertyFactoryUtil.forName("brand").eq(device.getBrand()));
    brandMatchesAndModelMatchesOrNull.add(modelMatchesOrNull);

    Junction brandNullOrMatchesWithModelMatchesOrNull = RestrictionsFactoryUtil.disjunction();
    brandNullOrMatchesWithModelMatchesOrNull.add(PropertyFactoryUtil.forName("brand").isNull());
    brandNullOrMatchesWithModelMatchesOrNull.add(brandMatchesAndModelMatchesOrNull);

    // Operating system query part
    Junction osVersionMatchesOrNull = RestrictionsFactoryUtil.disjunction();
    osVersionMatchesOrNull.add(PropertyFactoryUtil.forName("osVersion").eq(device.getOSVersion()));
    osVersionMatchesOrNull.add(PropertyFactoryUtil.forName("osVersion").isNull());

    Junction osNameMatchesAndOsVersionMathcesOrNull = RestrictionsFactoryUtil.conjunction();
    osNameMatchesAndOsVersionMathcesOrNull.add(PropertyFactoryUtil.forName("os").eq(device.getOS()));
    osNameMatchesAndOsVersionMathcesOrNull.add(osVersionMatchesOrNull);

    Junction osNameNullOrMatchesWithOsVersionMathcesOrNull = RestrictionsFactoryUtil.disjunction();
    osNameNullOrMatchesWithOsVersionMathcesOrNull.add(PropertyFactoryUtil.forName("os").isNull());
    osNameNullOrMatchesWithOsVersionMathcesOrNull.add(osNameMatchesAndOsVersionMathcesOrNull);

    // Browser query part
    Junction browserVersionMatchesOrNull = RestrictionsFactoryUtil.disjunction();
    browserVersionMatchesOrNull
            .add(PropertyFactoryUtil.forName("browserVersion").eq(device.getBrowserVersion()));
    browserVersionMatchesOrNull.add(PropertyFactoryUtil.forName("browserVersion").isNull());

    Junction browserNameMatchesAndBrowserVersionMathcesOrNull = RestrictionsFactoryUtil.conjunction();
    browserNameMatchesAndBrowserVersionMathcesOrNull
            .add(PropertyFactoryUtil.forName("browser").eq(device.getBrowser()));
    browserNameMatchesAndBrowserVersionMathcesOrNull.add(browserVersionMatchesOrNull);

    Junction browserNameNullOrMatchesWithBrowserVersionMatchesOrNull = RestrictionsFactoryUtil.disjunction();
    browserNameNullOrMatchesWithBrowserVersionMatchesOrNull
            .add(PropertyFactoryUtil.forName("browser").isNull());
    browserNameNullOrMatchesWithBrowserVersionMatchesOrNull
            .add(browserNameMatchesAndBrowserVersionMathcesOrNull);

    // Pointing device query part
    Junction pointingMethodMatchesOrNull = RestrictionsFactoryUtil.disjunction();
    pointingMethodMatchesOrNull
            .add(PropertyFactoryUtil.forName("pointingMethod").eq(device.getPointingMethod()));
    pointingMethodMatchesOrNull.add(PropertyFactoryUtil.forName("pointingMethod").isNull());

    // Is tablet query part
    Junction tabletMatchesOrNull = RestrictionsFactoryUtil.disjunction();
    tabletMatchesOrNull.add(PropertyFactoryUtil.forName("tablet").eq(Boolean.toString(device.isTablet())));
    tabletMatchesOrNull.add(PropertyFactoryUtil.forName("tablet").isNull());

    // Has qwerty keyboard query part
    Junction qwertyKeyboardMatchesOrNull = RestrictionsFactoryUtil.disjunction();
    qwertyKeyboardMatchesOrNull
            .add(PropertyFactoryUtil.forName("qwertyKeyboad").eq(Boolean.toString(device.hasQwertyKeyboard())));
    qwertyKeyboardMatchesOrNull.add(PropertyFactoryUtil.forName("qwertyKeyboad").isNull());

    // Page query part
    Junction pageMatchesOrNull = RestrictionsFactoryUtil.disjunction();
    pageMatchesOrNull.add(PropertyFactoryUtil.forName("layoutId").eq(0l));
    pageMatchesOrNull.add(PropertyFactoryUtil.forName("layoutId").eq(layoutId));

    DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(Rule.class);
    dynamicQuery.add(PropertyFactoryUtil.forName("companyId").eq(companyId));
    dynamicQuery.add(PropertyFactoryUtil.forName("groupId").eq(groupId));
    dynamicQuery.add(pageMatchesOrNull);
    dynamicQuery.add(brandNullOrMatchesWithModelMatchesOrNull);
    dynamicQuery.add(osNameNullOrMatchesWithOsVersionMathcesOrNull);
    dynamicQuery.add(browserNameNullOrMatchesWithBrowserVersionMatchesOrNull);
    dynamicQuery.add(pointingMethodMatchesOrNull);
    dynamicQuery.add(tabletMatchesOrNull);
    dynamicQuery.add(qwertyKeyboardMatchesOrNull);
    dynamicQuery.addOrder(OrderFactoryUtil.desc("layoutId"));
    dynamicQuery.addOrder(OrderFactoryUtil.asc("priority"));

    try {
        result = RuleUtil.findWithDynamicQuery(dynamicQuery);
    } catch (SystemException e) {
        _log.error("Failed to find theme rules matching " + device, e);
    }
    return result;
}

From source file:com.ext.portlet.halcon.service.impl.AuditoriaCajaSorpresaLocalServiceImpl.java

License:Open Source License

/**
 * Se obtiene los registros del reporte de caja sorpresa.
 * @throws BusinessException /*from ww w . ja  v  a2  s  . c  o  m*/
 */
@SuppressWarnings("unchecked")
public List<AuditoriaCajaSorpresa> obtenerListaAuditoriaCajaSorpresa(Integer filas, Integer pagina,
        Integer cboTipoDocumento, String producto, String txtFechaInicio, String txtFechaFin)
        throws BusinessException {
    _log.info(
            " obtenerListaAuditoriaCajaSorpresa datos cboTipoDocumento : " + cboTipoDocumento + "  producto : "
                    + producto + "  txtFechaInicio : " + txtFechaInicio + "  txtFechaFin : " + txtFechaFin);
    try {

        ClassLoader classLoader = (ClassLoader) PortletBeanLocatorUtil
                .locate(ClpSerializer.getServletContextName(), "portletClassLoader");
        DynamicQuery consultaAuditoriaCajaSorpresa = DynamicQueryFactoryUtil
                .forClass(AuditoriaCajaSorpresa.class, classLoader);
        if (cboTipoDocumento != null && cboTipoDocumento > 0) {
            consultaAuditoriaCajaSorpresa
                    .add(PropertyFactoryUtil.forName("tipoDocumento").eq(String.valueOf(cboTipoDocumento)))
                    .add(PropertyFactoryUtil.forName("tipoDocumento").isNotNull())
                    .add(RestrictionsFactoryUtil.not(PropertyFactoryUtil.forName("tipoDocumento").eq("")));
        }

        if (producto != null && !producto.equals("0")) {
            Disjunction funcionOr = RestrictionsFactoryUtil.disjunction();
            funcionOr.add(PropertyFactoryUtil.forName("codProducto1").eq(producto));
            funcionOr.add(PropertyFactoryUtil.forName("codProducto2").eq(producto));
            funcionOr.add(PropertyFactoryUtil.forName("codProducto3").eq(producto));
            consultaAuditoriaCajaSorpresa.add(funcionOr);
        }

        try {
            if ((txtFechaInicio != null && (!txtFechaInicio.equals("")) && txtFechaInicio.length() > 0)
                    && (txtFechaFin != null && (!txtFechaFin.equals("")) && txtFechaFin.length() > 0)) {
                SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                consultaAuditoriaCajaSorpresa
                        .add(PropertyFactoryUtil.forName("fechaHora")
                                .gt(sdf.parse(txtFechaInicio + " 00:00:00")))
                        .add(PropertyFactoryUtil.forName("fechaHora").lt(sdf.parse(txtFechaFin + " 23:59:59")));
            }
        } catch (Exception e) {
            System.out.println(e);
        }
        consultaAuditoriaCajaSorpresa.addOrder(OrderFactoryUtil.desc("fechaHora"));

        if (filas > 0 && pagina > 0) {
            int init = (filas * pagina - filas);
            int fin = init + filas;

            List<AuditoriaCajaSorpresa> lst = AuditoriaPerfiladorLocalServiceUtil
                    .dynamicQuery(consultaAuditoriaCajaSorpresa, init, fin);
            _log.info(" select  obtenerListaAuditoriaCajaSorpresa lst.size() :" + lst.size());

            return lst;
        } else {
            List<AuditoriaCajaSorpresa> lst = AuditoriaPerfiladorLocalServiceUtil
                    .dynamicQuery(consultaAuditoriaCajaSorpresa);
            _log.info(" select  -1 -1 obtenerListaAuditoriaCajaSorpresa lst.size() :" + lst.size());
            return lst;
        }

    } catch (Exception e) {
        //throw new BusinessException(nameClase+" - obtenerListaAuditoriaCajaSorpresa",e.toString());
        _log.error(Propiedades.getResourceBundleMetodo(
                "capa.halcon.auditoria.cajasorpresa.obtenerlistaauditoriacajasorpresa") + e.toString());
        throw new BusinessException(Propiedades.getResourceBundle("capa.halcon.auditoria.cajasorpresa",
                "capa.halcon.auditoria.cajasorpresa.obtenerlistaauditoriacajasorpresa"), e.toString());
    }
}

From source file:com.ext.portlet.halcon.service.impl.AuditoriaPerfiladorLocalServiceImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<AuditoriaPerfilador> obtenerListaAuditoriaPerfilador(Integer filas, Integer pagina,
        Integer cboTipoDocumento, Integer cboPerfilador, String txtFechaInicio, String txtFechaFin)
        throws BusinessException {
    _log.info(" obtenerListaAuditoriaSimulador datos cboTipoDocumento : " + cboTipoDocumento
            + "  cboPerfilador : " + cboPerfilador + "  txtFechaInicio : " + txtFechaInicio + "  txtFechaFin : "
            + txtFechaFin);//from  w  w  w .  ja va  2s . c o m
    try {

        ClassLoader classLoader = (ClassLoader) PortletBeanLocatorUtil
                .locate(ClpSerializer.getServletContextName(), "portletClassLoader");
        DynamicQuery consultaAuditoriaPerfilador = DynamicQueryFactoryUtil.forClass(AuditoriaPerfilador.class,
                classLoader);
        if (cboTipoDocumento != null && cboTipoDocumento > 0) {
            consultaAuditoriaPerfilador
                    .add(PropertyFactoryUtil.forName("tipoDocumento").eq(String.valueOf(cboTipoDocumento)))
                    .add(PropertyFactoryUtil.forName("tipoDocumento").isNotNull())
                    .add(RestrictionsFactoryUtil.not(PropertyFactoryUtil.forName("tipoDocumento").eq("")));
        }
        if (cboPerfilador != null && cboPerfilador > 0) {
            consultaAuditoriaPerfilador
                    .add(PropertyFactoryUtil.forName("perfilador").eq(String.valueOf(cboPerfilador)))
                    .add(PropertyFactoryUtil.forName("perfilador").isNotNull())
                    .add(RestrictionsFactoryUtil.not(PropertyFactoryUtil.forName("perfilador").eq("")));
        }
        try {
            if ((txtFechaInicio != null && (!txtFechaInicio.equals("")) && txtFechaInicio.length() > 0)
                    && (txtFechaFin != null && (!txtFechaFin.equals("")) && txtFechaFin.length() > 0)) {
                SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                consultaAuditoriaPerfilador
                        .add(PropertyFactoryUtil.forName("fechaHora")
                                .gt(sdf.parse(txtFechaInicio + " 00:00:00")))
                        .add(PropertyFactoryUtil.forName("fechaHora").lt(sdf.parse(txtFechaFin + " 23:59:59")));
            }
        } catch (Exception e) {
            System.out.println(e);
            e.printStackTrace();
        }

        consultaAuditoriaPerfilador.addOrder(OrderFactoryUtil.desc("fechaHora"));
        if (filas > 0 && pagina > 0) {
            int init = (filas * pagina - filas);
            int fin = init + filas;

            List<AuditoriaPerfilador> lst = AuditoriaPerfiladorLocalServiceUtil
                    .dynamicQuery(consultaAuditoriaPerfilador, init, fin);
            _log.info(" select  obtenerListaAuditoriaPerfilador lst.size() :" + lst.size());

            return lst;
        } else {
            List<AuditoriaPerfilador> lst = AuditoriaPerfiladorLocalServiceUtil
                    .dynamicQuery(consultaAuditoriaPerfilador);
            _log.info(" select  obtenerListaAuditoriaPerfilador lst.size() :" + lst.size());
            return lst;
        }

    } catch (Exception e) {
        // throw new
        // BusinessException(nameClase+" - obtenerListaAuditoriaPerfilador",e.toString());
        _log.error(Propiedades.getResourceBundleMetodo(
                "capa.halcon.auditoria.perfilador.obtenerlistaauditoriaperfilador") + e.toString());
        throw new BusinessException(Propiedades.getResourceBundle("capa.halcon.auditoria.perfilador",
                "capa.halcon.auditoria.perfilador.obtenerlistaauditoriaperfilador"), e.toString());
    }
}

From source file:com.ext.portlet.halcon.service.impl.AuditoriaSimuladorLocalServiceImpl.java

License:Open Source License

public List<AuditoriaSimulador> obtenerListaSimuladores(Integer filas, Integer pagina, Integer cboTipoDocumento,
        Integer simulador, String txtFechaInicio, String txtFechaFin) throws BusinessException {
    _log.info(" obtenerListaSimuladores datos cboTipoDocumento : " + cboTipoDocumento + "  simulador : "
            + simulador + "  txtFechaInicio : " + txtFechaInicio + "  txtFechaFin : " + txtFechaFin);
    try {/* www.  j a v  a 2  s .  c  o  m*/

        ClassLoader classLoader = (ClassLoader) PortletBeanLocatorUtil
                .locate(ClpSerializer.getServletContextName(), "portletClassLoader");
        DynamicQuery consultaAuditoriaSimulador = DynamicQueryFactoryUtil.forClass(AuditoriaSimulador.class,
                classLoader);

        if (cboTipoDocumento != null && cboTipoDocumento > 0) {
            consultaAuditoriaSimulador
                    .add(PropertyFactoryUtil.forName("tipoDocumento").eq(String.valueOf(cboTipoDocumento)))
                    .add(PropertyFactoryUtil.forName("tipoDocumento").isNotNull())
                    .add(RestrictionsFactoryUtil.not(PropertyFactoryUtil.forName("tipoDocumento").eq("")));
        }

        if (simulador != null && simulador > 0) {
            consultaAuditoriaSimulador
                    .add(PropertyFactoryUtil.forName("tipoSimulador").eq(String.valueOf(simulador)))
                    .add(PropertyFactoryUtil.forName("tipoSimulador").isNotNull())
                    .add(RestrictionsFactoryUtil.not(PropertyFactoryUtil.forName("tipoSimulador").eq("")));
        }

        try {
            if ((txtFechaInicio != null && (!txtFechaInicio.equals("")) && txtFechaInicio.length() > 0)
                    && (txtFechaFin != null && (!txtFechaFin.equals("")) && txtFechaFin.length() > 0)) {
                SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
                consultaAuditoriaSimulador
                        .add(PropertyFactoryUtil.forName("fechaHora")
                                .gt(sdf.parse(txtFechaInicio + " 00:00:00")))
                        .add(PropertyFactoryUtil.forName("fechaHora").lt(sdf.parse(txtFechaFin + " 23:59:59")));
            }
        } catch (Exception e) {
            System.out.println(e);
        }
        consultaAuditoriaSimulador.addOrder(OrderFactoryUtil.desc("fechaHora"));
        if (filas > 0 && pagina > 0) {
            int init = (filas * pagina - filas);
            int fin = init + filas;

            @SuppressWarnings("unchecked")
            List<AuditoriaSimulador> lst = AuditoriaSimuladorLocalServiceUtil
                    .dynamicQuery(consultaAuditoriaSimulador, init, fin);
            _log.info(" select  obtenerListaAuditoriaCajaSorpresa lst.size() :" + lst.size());

            return lst;
        } else {
            @SuppressWarnings("unchecked")
            List<AuditoriaSimulador> lst = AuditoriaSimuladorLocalServiceUtil
                    .dynamicQuery(consultaAuditoriaSimulador);
            _log.info(" select  -1 -1 obtenerListaAuditoriaCajaSorpresa lst.size() :" + lst.size());
            return lst;
        }

    } catch (Exception e) {
        //throw new BusinessException(nameClase+" - obtenerListaSimuladores",e.toString());
        _log.error(Propiedades.getResourceBundleMetodo(
                "capa.halcon.auditoria.simulador.auditoriasimuladorlocalserviceutil") + e.toString());
        throw new BusinessException(Propiedades.getResourceBundle("capa.halcon.auditoria.simulador",
                "capa.halcon.auditoria.simulador.auditoriasimuladorlocalserviceutil"), e.toString());
    }
}