Example usage for org.apache.commons.lang StringUtils lowerCase

Introduction

In this page you can find the example usage for org.apache.commons.lang StringUtils lowerCase.

Prototype

public static String lowerCase(String str) 

Source Link

Document

Converts a String to lower case as per String#toLowerCase() .

Usage

From source file:org.apache.openmeetings.data.user.dao.PrivateMessagesDao.java

public Long countFolderPrivateMessagesByUser(Long toUserId, Long privateMessageFolderId, String search) {
    try {//from w  w w. j  av a  2 s .c om

        String hql = "select count(c.privateMessageId) from PrivateMessage c " + "where c.isTrash = false "
                + "AND c.owner.user_id = :toUserId "
                + "AND c.privateMessageFolderId = :privateMessageFolderId ";

        if (search.length() != 0) {
            hql += "AND ( ";
            hql += "lower(c.subject) LIKE :search ";
            hql += "OR lower(c.message) LIKE :search ";
            hql += "OR lower(c.from.firstname) LIKE :search ";
            hql += "OR lower(c.from.lastname) LIKE :search ";
            hql += "OR lower(c.from.login) LIKE :search ";
            hql += "OR lower(c.from.adresses.email) LIKE :search ";
            hql += " ) ";
        }

        TypedQuery<Long> query = em.createQuery(hql, Long.class);
        query.setParameter("toUserId", toUserId);
        if (search.length() != 0) {
            query.setParameter("search", StringUtils.lowerCase("%" + search + "%"));
        }
        query.setParameter("privateMessageFolderId", privateMessageFolderId);
        List<Long> ll = query.getResultList();

        return ll.get(0);

    } catch (Exception e) {
        log.error("[countFolderPrivateMessagesByUser]", e);
    }
    return null;
}

---

From source file:org.apache.openmeetings.data.user.dao.PrivateMessagesDao.java

public List<PrivateMessage> getFolderPrivateMessagesByUser(Long toUserId, String search, String orderBy,
        int start, Boolean asc, Long privateMessageFolderId, int max) {
    try {/*from www  . ja v  a2 s.c o m*/

        String hql = "select c from PrivateMessage c " + "where c.isTrash = :isTrash "
                + "AND c.owner.user_id = :toUserId "
                + "AND c.privateMessageFolderId = :privateMessageFolderId ";

        if (search.length() != 0) {
            hql += "AND ( ";
            hql += "lower(c.subject) LIKE :search ";
            hql += "OR lower(c.message) LIKE :search ";
            hql += "OR lower(c.from.firstname) LIKE :search ";
            hql += "OR lower(c.from.lastname) LIKE :search ";
            hql += "OR lower(c.from.login) LIKE :search ";
            hql += "OR lower(c.from.adresses.email) LIKE :search ";
            hql += " ) ";
        }

        hql += "ORDER BY " + orderBy;

        if (asc) {
            hql += " ASC";
        } else {
            hql += " DESC";
        }

        log.debug("HQL " + hql);

        log.debug("privateMessageFolderId " + privateMessageFolderId);

        TypedQuery<PrivateMessage> query = em.createQuery(hql, PrivateMessage.class);
        query.setParameter("toUserId", toUserId);
        query.setParameter("isTrash", false);
        query.setParameter("privateMessageFolderId", privateMessageFolderId);
        if (search.length() != 0) {
            query.setParameter("search", StringUtils.lowerCase("%" + search + "%"));
        }
        query.setFirstResult(start);
        query.setMaxResults(max);
        List<PrivateMessage> ll = query.getResultList();

        return ll;

    } catch (Exception e) {
        log.error("[getFolderPrivateMessagesByUser]", e);
    }
    return null;
}

---

From source file:org.apache.openmeetings.data.user.dao.UsersDao.java

/**
 * @param search/*from www .jav a 2s  .  c  o  m*/
 * @return
 */
public Long selectMaxFromUsersWithSearch(String search) {
    try {
        // get all users
        TypedQuery<Long> query = em.createNamedQuery("selectMaxFromUsersWithSearch", Long.class);
        query.setParameter("search", StringUtils.lowerCase(search));
        List<Long> ll = query.getResultList();
        log.info("selectMaxFromUsers" + ll.get(0));
        return ll.get(0);
    } catch (Exception ex2) {
        log.error("[selectMaxFromUsers] ", ex2);
    }
    return null;
}

---

From source file:org.apache.openmeetings.data.user.UserManager.java

/**
 * @param user_level/* w w  w.j ava 2 s.c  o m*/
 * @param start
 * @param max
 * @param orderby
 * @param asc
 * @param search
 * @return
 */
public SearchResult<User> getUsersListWithSearch(Long user_level, int start, int max, String orderby,
        boolean asc, String search) {
    try {
        if (authLevelUtil.checkAdminLevel(user_level)) {

            String hql = "select c from User c " + "where c.deleted = false " + "AND ("
                    + "lower(c.login) LIKE :search " + "OR lower(c.firstname) LIKE :search "
                    + "OR lower(c.lastname) LIKE :search " + ")";

            if (orderby.startsWith("c.")) {
                hql += "ORDER BY " + orderby;
            } else {
                hql += "ORDER BY " + "c." + orderby;
            }

            if (asc) {
                hql += " ASC";
            } else {
                hql += " DESC";
            }

            if (search.length() == 0) {
                search = "%";
            } else {
                search = "%" + search + "%";
            }
            log.debug("getUsersList search: " + search);

            SearchResult<User> sresult = new SearchResult<User>();
            sresult.setObjectName(User.class.getName());
            sresult.setRecords(usersDao.selectMaxFromUsersWithSearch(search));

            // get all users
            TypedQuery<User> query = em.createQuery(hql, User.class);
            query.setParameter("search", StringUtils.lowerCase(search));
            query.setMaxResults(max);
            query.setFirstResult(start);

            sresult.setResult(query.getResultList());

            return sresult;
        }
    } catch (Exception ex2) {
        log.error("[getUsersList] " + ex2);
    }
    return null;
}

---

From source file:org.apache.openmeetings.data.user.UserManager.java

public List<User> searchUserProfile(String searchTxt, String userOffers, String userSearchs, String orderBy,
        int start, int max, boolean asc) {
    try {/* www  .j av a  2  s. co m*/

        String hql = "select c from User c " + "where c.deleted = false ";

        if (searchTxt.length() != 0 && userOffers.length() != 0 && userSearchs.length() != 0) {

            hql += "AND " + "(" + "(" + "lower(c.login) LIKE :search " + "OR lower(c.firstname) LIKE :search "
                    + "OR lower(c.lastname) LIKE :search " + "OR lower(c.adresses.email) LIKE :search "
                    + "OR lower(c.adresses.town) LIKE :search " + ")" + "AND" + "("
                    + "lower(c.userOffers) LIKE :userOffers " + ")" + "AND" + "("
                    + "lower(c.userSearchs) LIKE :userSearchs " + ")" + ")";

        } else if (searchTxt.length() != 0 && userOffers.length() != 0) {

            hql += "AND " + "(" + "(" + "lower(c.login) LIKE :search " + "OR lower(c.firstname) LIKE :search "
                    + "OR lower(c.lastname) LIKE :search " + "OR lower(c.adresses.email) LIKE :search "
                    + "OR lower(c.adresses.town) LIKE :search " + ")" + "AND" + "("
                    + "lower(c.userOffers) LIKE :userOffers " + ")" + ")";

        } else if (searchTxt.length() != 0 && userSearchs.length() != 0) {

            hql += "AND " + "(" + "(" + "lower(c.login) LIKE :search " + "OR lower(c.firstname) LIKE :search "
                    + "OR lower(c.lastname) LIKE :search " + "OR lower(c.adresses.email) LIKE :search "
                    + "OR lower(c.adresses.town) LIKE :search " + ")" + "AND" + "("
                    + "lower(c.userSearchs) LIKE :userSearchs " + ")" + ")";

        } else if (userOffers.length() != 0 && userSearchs.length() != 0) {

            hql += "AND " + "(" + "(" + "lower(c.userOffers) LIKE :userOffers " + ")" + "AND" + "("
                    + "lower(c.userSearchs) LIKE :userSearchs " + ")" + ")";

        } else if (searchTxt.length() != 0) {

            hql += "AND " + "(" + "(" + "lower(c.login) LIKE :search " + "OR lower(c.firstname) LIKE :search "
                    + "OR lower(c.lastname) LIKE :search " + "OR lower(c.adresses.email) LIKE :search "
                    + "OR lower(c.adresses.town) LIKE :search " + ")" + ")";

        } else if (userOffers.length() != 0) {

            hql += "AND " + "(" + "(" + "lower(c.userOffers) LIKE :userOffers " + ")" + ")";

        } else if (userSearchs.length() != 0) {

            hql += "AND " + "(" + "(" + "lower(c.userSearchs) LIKE :userSearchs " + ")" + ")";

        }

        hql += " ORDER BY " + orderBy;

        if (asc) {
            hql += " ASC";
        } else {
            hql += " DESC";
        }

        if (searchTxt.length() != 0) {
            searchTxt = "%" + searchTxt + "%";
        }

        if (userOffers.length() != 0) {
            userOffers = "%" + userOffers + "%";
        }

        if (userSearchs.length() != 0) {
            userSearchs = "%" + userSearchs + "%";
        }

        log.debug("hql :: " + hql);

        // get all users
        TypedQuery<User> query = em.createQuery(hql, User.class);

        if (searchTxt.length() != 0 && userOffers.length() != 0 && userSearchs.length() != 0) {

            query.setParameter("search", StringUtils.lowerCase(searchTxt));
            query.setParameter("userOffers", StringUtils.lowerCase(userOffers));
            query.setParameter("userSearchs", StringUtils.lowerCase(userSearchs));

        } else if (searchTxt.length() != 0 && userOffers.length() != 0) {

            query.setParameter("search", StringUtils.lowerCase(searchTxt));
            query.setParameter("userOffers", StringUtils.lowerCase(userOffers));

        } else if (searchTxt.length() != 0 && userSearchs.length() != 0) {

            query.setParameter("search", StringUtils.lowerCase(searchTxt));
            query.setParameter("userSearchs", StringUtils.lowerCase(userSearchs));

        } else if (userOffers.length() != 0 && userSearchs.length() != 0) {

            query.setParameter("userOffers", StringUtils.lowerCase(userOffers));
            query.setParameter("userSearchs", StringUtils.lowerCase(userSearchs));

        } else if (searchTxt.length() != 0) {

            query.setParameter("search", StringUtils.lowerCase(searchTxt));

        } else if (userOffers.length() != 0) {

            query.setParameter("userOffers", StringUtils.lowerCase(userOffers));

        } else if (userSearchs.length() != 0) {

            query.setParameter("userSearchs", StringUtils.lowerCase(userSearchs));

        }

        query.setMaxResults(max);
        query.setFirstResult(start);

        List<User> userList = query.getResultList();

        return userList;

    } catch (Exception ex2) {
        log.error("[getUsersList] ", ex2);
    }

    return null;
}

---

From source file:org.apache.openmeetings.data.user.UserManager.java

public Long searchCountUserProfile(String searchTxt, String userOffers, String userSearchs) {
    try {/* w w  w.ja  va  2s.c  o  m*/

        String hql = "select count(c.user_id) from User c " + "where c.deleted = false ";

        if (searchTxt.length() != 0 && userOffers.length() != 0 && userSearchs.length() != 0) {

            hql += "AND " + "(" + "(" + "lower(c.login) LIKE :search " + "OR lower(c.firstname) LIKE :search "
                    + "OR lower(c.lastname) LIKE :search " + "OR lower(c.adresses.email) LIKE :search "
                    + "OR lower(c.adresses.town) LIKE :search " + ")" + "AND" + "("
                    + "lower(c.userOffers) LIKE :userOffers " + ")" + "AND" + "("
                    + "lower(c.userSearchs) LIKE :userSearchs " + ")" + ")";

        } else if (searchTxt.length() != 0 && userOffers.length() != 0) {

            hql += "AND " + "(" + "(" + "lower(c.login) LIKE :search " + "OR lower(c.firstname) LIKE :search "
                    + "OR lower(c.lastname) LIKE :search) " + "OR lower(c.adresses.email) LIKE :search "
                    + "OR lower(c.adresses.town) LIKE :search " + ")" + "AND" + "("
                    + "lower(c.userOffers) LIKE :userOffers " + ")" + ")";

        } else if (searchTxt.length() != 0 && userSearchs.length() != 0) {

            hql += "AND " + "(" + "(" + "lower(c.login) LIKE :search " + "OR lower(c.firstname) LIKE :search "
                    + "OR lower(c.lastname) LIKE :search " + "OR lower(c.adresses.email) LIKE :search "
                    + "OR lower(c.adresses.town) LIKE :search " + ")" + "AND" + "("
                    + "lower(c.userSearchs) LIKE :userSearchs " + ")" + ")";

        } else if (userOffers.length() != 0 && userSearchs.length() != 0) {

            hql += "AND " + "(" + "(" + "lower(c.userOffers) LIKE :userOffers " + ")" + "AND" + "("
                    + "lower(c.userSearchs) LIKE :userSearchs " + ")" + ")";

        } else if (searchTxt.length() != 0) {

            hql += "AND " + "(" + "(" + "lower(c.login) LIKE :search " + "OR lower(c.firstname) LIKE :search "
                    + "OR lower(c.lastname) LIKE :search " + "OR lower(c.adresses.email) LIKE :search "
                    + "OR lower(c.adresses.town) LIKE :search " + ")" + ")";

        } else if (userOffers.length() != 0) {

            hql += "AND " + "(" + "(" + "lower(c.userOffers) LIKE :userOffers " + ")" + ")";

        } else if (userSearchs.length() != 0) {

            hql += "AND " + "(" + "(" + "lower(c.userSearchs) LIKE :userSearchs " + ")" + ")";

        }

        if (searchTxt.length() != 0) {
            searchTxt = "%" + searchTxt + "%";
        }

        if (userOffers.length() != 0) {
            userOffers = "%" + userOffers + "%";
        }

        if (userSearchs.length() != 0) {
            userSearchs = "%" + userSearchs + "%";
        }

        log.debug("hql :: " + hql);

        // get all users
        TypedQuery<Long> query = em.createQuery(hql, Long.class);

        if (searchTxt.length() != 0 && userOffers.length() != 0 && userSearchs.length() != 0) {

            query.setParameter("search", StringUtils.lowerCase(searchTxt));
            query.setParameter("userOffers", StringUtils.lowerCase(userOffers));
            query.setParameter("userSearchs", StringUtils.lowerCase(userSearchs));

        } else if (searchTxt.length() != 0 && userOffers.length() != 0) {

            query.setParameter("search", StringUtils.lowerCase(searchTxt));
            query.setParameter("userOffers", StringUtils.lowerCase(userOffers));

        } else if (searchTxt.length() != 0 && userSearchs.length() != 0) {

            query.setParameter("search", StringUtils.lowerCase(searchTxt));
            query.setParameter("userSearchs", StringUtils.lowerCase(userSearchs));

        } else if (userOffers.length() != 0 && userSearchs.length() != 0) {

            query.setParameter("userOffers", StringUtils.lowerCase(userOffers));
            query.setParameter("userSearchs", StringUtils.lowerCase(userSearchs));

        } else if (searchTxt.length() != 0) {

            query.setParameter("search", StringUtils.lowerCase(searchTxt));

        } else if (userOffers.length() != 0) {

            query.setParameter("userOffers", StringUtils.lowerCase(userOffers));

        } else if (userSearchs.length() != 0) {

            query.setParameter("userSearchs", StringUtils.lowerCase(userSearchs));

        }

        List<Long> userList = query.getResultList();

        return userList.get(0);

    } catch (Exception ex2) {
        log.error("[getUsersList] ", ex2);
    }

    return null;
}

---

From source file:org.apache.openmeetings.data.user.UserManager.java

public Long searchMaxUserProfile(String searchTxt, String userOffers, String userSearchs) {
    try {/*from   w  ww . j  a va 2s .c  om*/

        String hql = "select count(c.user_id) from User c " + "where c.deleted = false " + "AND " + "(" + "("
                + "lower(c.login) LIKE :search " + "OR lower(c.firstname) LIKE :search "
                + "OR lower(c.lastname) LIKE :search " + "OR lower(c.adresses.email) LIKE :search "
                + "OR lower(c.adresses.town) LIKE :search " + ")" + "OR" + "("
                + "lower(c.userOffers) LIKE :userOffers " + ")" + "OR" + "("
                + "lower(c.userSearchs) LIKE :userSearchs " + ")" + ")";

        if (searchTxt.length() == 0) {
            searchTxt = "%";
        } else {
            searchTxt = "%" + searchTxt + "%";
        }

        if (userOffers.length() == 0) {
            userOffers = "%";
        } else {
            userOffers = "%" + userOffers + "%";
        }

        if (userSearchs.length() == 0) {
            userSearchs = "%";
        } else {
            userSearchs = "%" + userSearchs + "%";
        }

        // get all users
        TypedQuery<Long> query = em.createQuery(hql, Long.class);
        query.setParameter("search", StringUtils.lowerCase(searchTxt));
        query.setParameter("userOffers", StringUtils.lowerCase(userOffers));
        query.setParameter("userSearchs", StringUtils.lowerCase(userSearchs));

        List<Long> ll = query.getResultList();

        return ll.get(0);

    } catch (Exception ex2) {
        log.error("[searchMaxUserProfile] " + ex2);
    }

    return null;
}

---

From source file:org.apache.openmeetings.utils.DaoHelper.java

public static void getWhereClause(StringBuilder sb, String search, String alias, String... fields) {
    if (search != null) {
        boolean notEmpty = false;
        String[] searchItems = search.split(" ");
        for (int i = 0; i < searchItems.length; ++i) {
            if (searchItems[i].isEmpty()) {
                continue;
            }/* ww w .j  a  va 2s  .  c om*/
            if (i == 0) {
                notEmpty = true;
                sb.append(" (");
            } else {
                sb.append(" OR ");
            }
            StringBuilder placeholder = new StringBuilder();
            placeholder.append("%").append(StringUtils.lowerCase(searchItems[i])).append("%");

            sb.append("(");
            for (int j = 0; j < fields.length; ++j) {
                if (j != 0) {
                    sb.append(" OR ");
                }
                sb.append("lower(").append(alias).append(".").append(fields[j]).append(") LIKE '")
                        .append(placeholder).append("' ");
            }
            sb.append(")");
        }
        if (notEmpty) {
            sb.append(") ");
        }
    }
}

---

From source file:org.apache.usergrid.corepersistence.CpEntityManagerFactory.java

private String buildAppName(String organizationName, String name) {
    return StringUtils.lowerCase(name.contains("/") ? name : organizationName + "/" + name);
}

---

From source file:org.apache.usergrid.persistence.cassandra.ConnectionRefImpl.java

public static UUID getId(EntityRef connectingEntity, ConnectedEntityRef connectedEntity,
        ConnectedEntityRef... pairedConnections) {
    UUID uuid = null;//from   w w  w  . j av a  2 s .  com
    try {

        if (connectionsNull(pairedConnections) && connectionsNull(connectedEntity)) {
            return connectingEntity.getUuid();
        }

        ByteArrayOutputStream byteStream = new ByteArrayOutputStream(16 + (32 * pairedConnections.length));

        byteStream.write(uuidToBytesNullOk(connectingEntity.getUuid()));

        for (ConnectedEntityRef connection : pairedConnections) {
            String connectionType = connection.getConnectionType();
            UUID connectedEntityID = connection.getUuid();

            byteStream.write(ascii(StringUtils.lowerCase(connectionType)));
            byteStream.write(uuidToBytesNullOk(connectedEntityID));
        }

        String connectionType = connectedEntity.getConnectionType();
        if (connectionType == null) {
            connectionType = NULL_ENTITY_TYPE;
        }

        UUID connectedEntityID = connectedEntity.getUuid();

        byteStream.write(ascii(StringUtils.lowerCase(connectionType)));
        byteStream.write(uuidToBytesNullOk(connectedEntityID));

        byte[] raw_id = byteStream.toByteArray();

        // logger.info("raw connection index id: " +
        // Hex.encodeHexString(raw_id));

        uuid = UUID.nameUUIDFromBytes(raw_id);

        // logger.info("connection index uuid: " + uuid);

    } catch (IOException e) {
        logger.error("Unable to create connection UUID", e);
    }
    return uuid;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• »