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.openmeetings.app.data.user.dao.PrivateMessagesDaoImpl.java

public Long countPrivateMessagesByUser(Long toUserId, String search, Long privateMessageFolderId) {
    try {/*from  w  w w  .  jav  a2  s  .co m*/

        String hql = "select count(c.privateMessageId) from PrivateMessages c "
                + "where c.to.user_id = :toUserId " + "AND 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("[countPrivateMessagesByUser]", e);
    }
    return null;
}

---

From source file:org.openmeetings.app.data.user.dao.PrivateMessagesDaoImpl.java

public List<PrivateMessages> getPrivateMessagesByUser(Long toUserId, String search, String orderBy, int start,
        Boolean asc, Long privateMessageFolderId, int max) {
    try {/*from   w ww .  ja v a  2s .  c om*/

        String hql = "select c from PrivateMessages c " + "where c.to.user_id = :toUserId "
                + "AND 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";
        }

        TypedQuery<PrivateMessages> query = em.createQuery(hql, PrivateMessages.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<PrivateMessages> ll = query.getResultList();

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

---

From source file:org.openmeetings.app.data.user.dao.PrivateMessagesDaoImpl.java

public Long countSendPrivateMessagesByUser(Long toUserId, String search, Long privateMessageFolderId) {
    try {//from  ww w .ja va2s. c  om

        String hql = "select count(c.privateMessageId) from PrivateMessages c "
                + "where c.from.user_id = :toUserId " + "AND 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 += " ) ";
        }

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

        return ll.get(0);

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

---

From source file:org.openmeetings.app.data.user.dao.PrivateMessagesDaoImpl.java

public List<PrivateMessages> getTrashPrivateMessagesByUser(Long user_id, String search, String orderBy,
        int start, Boolean asc, int max) {
    try {/*from  w w w  .  j a v  a  2  s  . c  o  m*/

        String hql = "select c from PrivateMessages c " + "where c.isTrash = true "
                + "AND c.owner.user_id = :user_id ";

        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";
        }

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

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

---

From source file:org.openmeetings.app.data.user.dao.PrivateMessagesDaoImpl.java

public Long countTrashPrivateMessagesByUser(Long user_id, String search) {
    try {/*from   ww  w  .j  av  a2 s.co m*/

        String hql = "select count(c.privateMessageId) from PrivateMessages c " + "where c.isTrash = true  "
                + "AND c.owner.user_id = :user_id ";

        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("user_id", user_id);
        if (search.length() != 0) {
            query.setParameter("search", StringUtils.lowerCase("%" + search + "%"));
        }
        List<Long> ll = query.getResultList();

        return ll.get(0);

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

---

From source file:org.openmeetings.app.data.user.dao.PrivateMessagesDaoImpl.java

public List<PrivateMessages> getSendPrivateMessagesByUser(Long toUserId, String search, String orderBy,
        int start, Boolean asc, Long privateMessageFolderId, int max) {
    try {//from   w  ww.  j  a  v a  2 s  . c  om

        String hql = "select c from PrivateMessages c " + "where c.from.user_id = :toUserId "
                + "AND 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 += " ) ";
        }

        hql += "ORDER BY " + orderBy;

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

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

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

---

From source file:org.openmeetings.app.data.user.dao.PrivateMessagesDaoImpl.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 PrivateMessages 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.openmeetings.app.data.user.dao.PrivateMessagesDaoImpl.java

public List<PrivateMessages> getFolderPrivateMessagesByUser(Long toUserId, String search, String orderBy,
        int start, Boolean asc, Long privateMessageFolderId, int max) {
    try {/*from  w ww.jav  a  2s  .c  om*/

        String hql = "select c from PrivateMessages 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<PrivateMessages> query = em.createQuery(hql, PrivateMessages.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<PrivateMessages> ll = query.getResultList();

        return ll;

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

---

From source file:org.openmeetings.app.data.user.dao.UsersDaoImpl.java

public Long getAllUserMax(String search) {
    try {//from w w  w .  ja va 2 s .c  om

        String[] searchItems = search.split(" ");

        log.debug("getUserContactsBySearch: " + search);
        // log.debug("getUserContactsBySearch: "+ userId);

        String hql = "select count(u.user_id) from  Users u " + "WHERE u.deleted = 'false' ";

        hql += "AND ( ";
        for (int i = 0; i < searchItems.length; i++) {
            if (i != 0) {
                hql += " OR ";
            }
            hql += "( " + "lower(u.lastname) LIKE '" + StringUtils.lowerCase("%" + searchItems[i] + "%") + "' "
                    + "OR lower(u.firstname) LIKE '" + StringUtils.lowerCase("%" + searchItems[i] + "%") + "' "
                    + "OR lower(u.login) LIKE '" + StringUtils.lowerCase("%" + searchItems[i] + "%") + "' "
                    + "OR lower(u.adresses.email) LIKE '" + StringUtils.lowerCase("%" + searchItems[i] + "%")
                    + "' " + ") ";

        }
        hql += " )";

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

        TypedQuery<Long> query = em.createQuery(hql, Long.class);

        // log.debug("id: "+folderId);
        List<Long> ll = query.getResultList();

        // log.error((Long)ll.get(0));
        Long i = ll.get(0);

        return i;
    } catch (Exception ex2) {
        log.error("[getAllUserMax]: ", ex2);
    }
    return null;
}

---

From source file:org.openmeetings.app.data.user.dao.UsersDaoImpl.java

/**
 * @param search/*  w  w w  .  j  a v a2s  .  co m*/
 * @return
 */
public Long selectMaxFromUsersWithSearch(String search) {
    try {

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

        // get all users
        TypedQuery<Long> query = em.createQuery(hql, 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;
}

---

• «
• 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
• »