Example usage for com.liferay.portal.kernel.dao.orm Type STRING

Introduction

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

Prototype

Type STRING

To view the source code for com.liferay.portal.kernel.dao.orm Type STRING.

Click Source Link

Usage

From source file:com.beorn.onlinepayment.service.persistence.TransactionParameterFinderImpl.java

License:Open Source License

public List<String> findParameterKeysForSellerId(long sellerId) throws SystemException {

    Session session = null;/*from   w w w  .jav a 2  s.c  o m*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(FIND_PARAMETER_KEYS_FOR_SELLER_ID);

        SQLQuery q = session.createSQLQuery(sql);

        q.addScalar("Payment_TransactionParameter.key_", Type.STRING);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(sellerId);

        return (List<String>) QueryUtil.list(q, getDialect(), QueryUtil.ALL_POS, QueryUtil.ALL_POS);

    } catch (Exception e) {
        throw new SystemException(e);

    } finally {
        closeSession(session);
    }
}

---

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

License:Open Source License

@SuppressWarnings("unchecked")
public List<Object[]> obtenerSolicitud(Integer filas, Integer pagina, String fechaInicio, String fechaFinal)
        throws BusinessException {
    _log.info(//www  .  j  a  v a 2s. c o  m
            "com.ext.portlet.halcon.service.SolicitudContactoLocalService - obtenerSolicitudCount : fechainicio "
                    + fechaInicio + " - fechafinal " + fechaFinal + " - filas " + filas.toString()
                    + " - pagina " + pagina.toString());
    Session session = null;
    try {
        session = solicitudContactoPersistence.openSession();
        String sql = CustomSQLUtil.get(FINDER_SOLICITUDES);
        SQLQuery q = session.createSQLQuery(sql);
        if (filas > 0 && pagina > 0) {
            q.setFirstResult(filas * pagina - filas);
            q.setMaxResults(filas);
        }

        q.addScalar("slct_IdSolicitudContacto", Type.STRING);
        q.addScalar("slct_EsCliente", Type.STRING);
        q.addScalar("slct_Nombres", Type.STRING);
        q.addScalar("slct_Apellidos", Type.STRING);
        q.addScalar("slct_Email", Type.STRING);
        q.addScalar("slct_TipoDocumento", Type.STRING);
        q.addScalar("slct_Ndocumento", Type.STRING);
        q.addScalar("slct_Direccion", Type.STRING);
        q.addScalar("slct_Departamento", Type.STRING);
        q.addScalar("slct_Provincia", Type.STRING);
        q.addScalar("slct_Distrito", Type.STRING);
        q.addScalar("slct_Telefono", Type.STRING);
        q.addScalar("slct_Fecha", Type.DATE);
        q.addScalar("slct_Mensaje", Type.STRING);
        q.addScalar("slct_Moneda", Type.STRING);
        q.addScalar("slct_Importe", Type.STRING);
        q.addScalar("slct_TipoMensaje", Type.STRING);
        q.addScalar("slct_TipoTema", Type.STRING);

        QueryPos qPos = QueryPos.getInstance(q);
        qPos.add(fechaInicio + " 0:00:00");
        qPos.add(fechaFinal + " 23:59:59");
        List<Object[]> out = new ArrayList<Object[]>();
        out = q.list();
        return out;
    } catch (Exception e) {
        e.printStackTrace();
        _log.error("Error en com.ext.portlet.halcon.service.SolicitudContactoLocalService" + e.toString());
        throw new BusinessException(
                "Error en com.ext.portlet.halcon.service.SolicitudContactoLocalService.obtenerSolicitud - Clase: com.ext.portlet.halcon.service.SolicitudContactoLocalService",
                e.toString());
    } finally {
        solicitudContactoPersistence.closeSession(session);
    }
}

---

From source file:com.inkwell.internet.slogan.service.persistence.SloganFinderImpl.java

License:Open Source License

public List<Slogan> findByRatingsStats(long groupId, int status, int start, int end) throws SystemException {

    long classNameId = PortalUtil.getClassNameId("com.inkwell.internet.slogan.model.Slogan");

    Session session = null;//  www.java 2  s  .c om

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(FIND_BY_RATINGSSTATS);

        SQLQuery q = session.createSQLQuery(sql);

        q.addScalar("averageScore", Type.DOUBLE);
        q.addScalar("sloganId", Type.LONG);
        q.addScalar("sloganText", Type.STRING);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);
        qPos.add(status);
        qPos.add(classNameId);

        List<Object[]> ratedSlogans = (List<Object[]>) QueryUtil.list(q, getDialect(), start, end);

        List<Slogan> slogans = assembleSlogans(ratedSlogans);

        return slogans;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:com.liferay.asset.category.property.service.persistence.impl.AssetCategoryPropertyFinderImpl.java

License:Open Source License

@Override
public List<AssetCategoryProperty> findByG_K(long groupId, String key, int start, int end) {

    Session session = null;//from w  w  w  .  jav  a2s.  c o m

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(getClass(), FIND_BY_G_K);

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar("categoryPropertyValue", Type.STRING);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);
        qPos.add(key);

        List<AssetCategoryProperty> categoryProperties = new ArrayList<>();

        Iterator<String> itr = (Iterator<String>) QueryUtil.iterate(q, getDialect(), start, end);

        while (itr.hasNext()) {
            String value = itr.next();

            AssetCategoryProperty categoryProperty = new AssetCategoryPropertyImpl();

            categoryProperty.setKey(key);
            categoryProperty.setValue(value);

            categoryProperties.add(categoryProperty);
        }

        return categoryProperties;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:com.liferay.bookmarks.service.persistence.impl.BookmarksFolderFinderImpl.java

License:Open Source License

protected List<Object> doFindF_E_ByG_F(long groupId, long folderId, QueryDefinition<?> queryDefinition,
        boolean inlineSQLHelper) {

    Session session = null;//from w w  w .  ja  v  a2 s  . c  o m

    try {
        session = openSession();

        StringBundler sb = new StringBundler(5);

        sb.append("SELECT * FROM (");

        String sql = null;

        if (queryDefinition.getStatus() == WorkflowConstants.STATUS_ANY) {
            sql = CustomSQLUtil.get(getClass(), FIND_F_BY_G_P);
        } else {
            sql = CustomSQLUtil.get(getClass(), FIND_F_BY_G_P_S);

            sql = replaceExcludeStatus(sql, queryDefinition);
        }

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql, BookmarksFolder.class.getName(),
                    "BookmarksFolder.folderId", groupId);
        }

        sb.append(sql);
        sb.append(" UNION ALL ");

        if (queryDefinition.getStatus() == WorkflowConstants.STATUS_ANY) {
            sql = CustomSQLUtil.get(getClass(), FIND_E_BY_G_F);
        } else {
            sql = CustomSQLUtil.get(getClass(), FIND_E_BY_G_F_S);

            sql = replaceExcludeStatus(sql, queryDefinition);
        }

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql, BookmarksEntry.class.getName(),
                    "BookmarksEntry.fileEntryId", groupId);
        }

        sb.append(sql);
        sb.append(") TEMP_TABLE ORDER BY modelName ASC");

        sql = sb.toString();

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar("modelId", Type.LONG);
        q.addScalar("modelName", Type.STRING);
        q.addScalar("modelFolder", Type.LONG);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);
        qPos.add(folderId);

        if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) {
            qPos.add(queryDefinition.getStatus());
        }

        qPos.add(groupId);
        qPos.add(folderId);

        if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) {
            qPos.add(queryDefinition.getStatus());
        }

        List<Object> models = new ArrayList<>();

        Iterator<Object[]> itr = (Iterator<Object[]>) QueryUtil.iterate(q, getDialect(),
                queryDefinition.getStart(), queryDefinition.getEnd());

        while (itr.hasNext()) {
            Object[] array = itr.next();

            long modelId = (Long) array[0];
            //String name = (String)array[1];
            long modelFolder = (Long) array[2];

            Object obj = null;

            if (modelFolder == 0) {
                obj = BookmarksFolderUtil.findByPrimaryKey(modelId);
            } else {
                obj = BookmarksEntryUtil.findByPrimaryKey(modelId);
            }

            models.add(obj);
        }

        return models;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:com.liferay.chat.service.persistence.impl.StatusFinderImpl.java

License:Open Source License

protected void addScalars(SQLQuery sqlQuery) {
    sqlQuery.addScalar("awake", Type.BOOLEAN);
    sqlQuery.addScalar("firstName", Type.STRING);
    sqlQuery.addScalar("groupId", Type.LONG);
    sqlQuery.addScalar("lastName", Type.STRING);
    //sqlQuery.addScalar("male", Type.BOOLEAN);
    sqlQuery.addScalar("middleName", Type.STRING);
    sqlQuery.addScalar("portraitId", Type.LONG);
    sqlQuery.addScalar("screenName", Type.STRING);
    sqlQuery.addScalar("userId", Type.LONG);
    sqlQuery.addScalar("userUuid", Type.STRING);
}

---

From source file:com.liferay.chat.service.persistence.StatusFinderImpl.java

License:Open Source License

public List<Object[]> findByModifiedDate(long companyId, long userId, long modifiedDate, int start, int end)
        throws SystemException {

    Session session = null;/*ww w  . j  a  v  a  2 s  .com*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(FIND_BY_MODIFIED_DATE);

        SQLQuery q = session.createSQLQuery(sql);

        q.addScalar("userId", Type.LONG);
        q.addScalar("screenName", Type.STRING);
        q.addScalar("firstName", Type.STRING);
        q.addScalar("middleName", Type.STRING);
        q.addScalar("lastName", Type.STRING);
        q.addScalar("portraitId", Type.LONG);
        q.addScalar("awake", Type.BOOLEAN);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(companyId);
        qPos.add(userId);
        qPos.add(modifiedDate);

        return (List<Object[]>) QueryUtil.list(q, getDialect(), start, end);
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:com.liferay.chat.service.persistence.StatusFinderImpl.java

License:Open Source License

public List<Object[]> findBySocialRelationType(long userId, int type, long modifiedDate, int start, int end)
        throws SystemException {

    Session session = null;/* ww  w. j  a v  a  2  s.  c  om*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(FIND_BY_SOCIAL_RELATION_TYPE);

        SQLQuery q = session.createSQLQuery(sql);

        q.addScalar("userId", Type.LONG);
        q.addScalar("screenName", Type.STRING);
        q.addScalar("firstName", Type.STRING);
        q.addScalar("middleName", Type.STRING);
        q.addScalar("lastName", Type.STRING);
        q.addScalar("portraitId", Type.LONG);
        q.addScalar("awake", Type.BOOLEAN);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(userId);
        qPos.add(type);
        qPos.add(modifiedDate);

        return (List<Object[]>) QueryUtil.list(q, getDialect(), start, end);
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:com.liferay.chat.service.persistence.StatusFinderImpl.java

License:Open Source License

public List<Object[]> findByUsersGroups(long userId, long modifiedDate, int start, int end)
        throws SystemException {

    Session session = null;/*from ww  w.ja v a2 s  .c o m*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(FIND_BY_USERS_GROUPS);

        SQLQuery q = session.createSQLQuery(sql);

        q.addScalar("userId", Type.LONG);
        q.addScalar("screenName", Type.STRING);
        q.addScalar("firstName", Type.STRING);
        q.addScalar("middleName", Type.STRING);
        q.addScalar("lastName", Type.STRING);
        q.addScalar("portraitId", Type.LONG);
        q.addScalar("awake", Type.BOOLEAN);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(userId);
        qPos.add(modifiedDate);

        return (List<Object[]>) QueryUtil.list(q, getDialect(), start, end);
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

From source file:com.liferay.contacts.service.persistence.EntryFinderImpl.java

License:Open Source License

public List<BaseModel<?>> findByC_U_FN_EA(long companyId, long userId, String[] fullNames,
        String[] emailAddresses, boolean andOperator, int start, int end) throws SystemException {

    fullNames = CustomSQLUtil.keywords(fullNames, true);
    emailAddresses = CustomSQLUtil.keywords(emailAddresses, true);

    Session session = null;/*from  w ww  .j a v a 2s. c  o  m*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(FIND_BY_C_U_FN_EA);

        sql = CustomSQLUtil.replaceKeywords(sql, "lower(User_.firstName)", StringPool.LIKE, false, fullNames);
        sql = CustomSQLUtil.replaceKeywords(sql, "lower(User_.middleName)", StringPool.LIKE, false, fullNames);
        sql = CustomSQLUtil.replaceKeywords(sql, "lower(User_.lastName)", StringPool.LIKE, false, fullNames);
        sql = CustomSQLUtil.replaceKeywords(sql, "lower(User_.screenName)", StringPool.LIKE, false, fullNames);
        sql = CustomSQLUtil.replaceKeywords(sql, "lower(User_.emailAddress)", StringPool.LIKE, true,
                emailAddresses);
        sql = CustomSQLUtil.replaceKeywords(sql, "lower(Contacts_Entry.fullName)", StringPool.LIKE, false,
                fullNames);
        sql = CustomSQLUtil.replaceKeywords(sql, "lower(Contacts_Entry.emailAddress)", StringPool.LIKE, true,
                emailAddresses);
        sql = CustomSQLUtil.replaceAndOperator(sql, andOperator);

        SQLQuery q = session.createSQLQuery(sql);

        q.addScalar("id", Type.LONG);
        q.addScalar("name", Type.STRING);
        q.addScalar("portalUser", Type.INTEGER);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(companyId);
        qPos.add(fullNames, 8);
        qPos.add(emailAddresses, 2);
        qPos.add(userId);
        qPos.add(fullNames, 2);
        qPos.add(emailAddresses, 2);

        List<BaseModel<?>> models = new ArrayList<BaseModel<?>>();

        Iterator<Object[]> itr = (Iterator<Object[]>) QueryUtil.iterate(q, getDialect(), start, end);

        while (itr.hasNext()) {
            Object[] array = itr.next();

            long id = (Long) array[0];
            //String name = (String)array[1];
            int portalUser = (Integer) array[2];

            BaseModel<?> model = null;

            if (portalUser == 1) {
                model = UserLocalServiceUtil.getUser(id);
            } else {
                model = EntryLocalServiceUtil.getEntry(id);
            }

            models.add(model);
        }

        return models;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

---

• «
• 1
• 2
• 3
• 4
• 5
• »