Example usage for com.liferay.portal.kernel.util StringPool PERCENT

Introduction

In this page you can find the example usage for com.liferay.portal.kernel.util StringPool PERCENT.

Prototype

String PERCENT

To view the source code for com.liferay.portal.kernel.util StringPool PERCENT.

Click Source Link

Usage

From source file:org.oep.cmon.portlet.admin.congchuc.utils.CongChucUtils.java

License:Apache License

/**
 * This is  function search VaiTro by TenVaiTro
 * Version: 1.0//from w ww .j a va2s . c om
 *  
 * History: 
 *   DATE        AUTHOR      DESCRIPTION 
 *  ------------------------------------------------- 
 *  3-March-2013  Nam Dinh    Create new
 * @param searchInputText
 * @param daXoa
 * @throws Exception
 * @return List<VaiTro>
 */
@SuppressWarnings("unchecked")
public static List<VaiTro> searchVaiTroByTen(String searchInputText, int daXoa) throws Exception {
    List<VaiTro> listVaiTro = new ArrayList<VaiTro>();
    DynamicQuery query = DynamicQueryFactoryUtil.forClass(VaiTroImpl.class,
            PortalClassLoaderUtil.getClassLoader());
    if (!searchInputText.equals("")) {
        Criterion creterion = RestrictionsFactoryUtil.ilike("ten",
                StringPool.PERCENT + searchInputText + StringPool.PERCENT);
        query.add(creterion);
    }
    query.add(PropertyFactoryUtil.forName(CmonFields.daXoa).eq(Constants.ACTIVATED));
    query.addOrder(OrderFactoryUtil.asc("ten"));
    listVaiTro = VaiTroLocalServiceUtil.dynamicQuery(query, QueryUtil.ALL_POS, QueryUtil.ALL_POS);
    return listVaiTro;
}

---

From source file:org.oep.cmon.portlet.doanhnghiep.quanlytaikhoan.business.CongDanBusiness.java

License:Apache License

/**
 * This is  function countByCongDan//from w  w  w.  j  ava2 s.  com
 * Version: 1.0
 *  
 * History: 
 *   DATE        AUTHOR      DESCRIPTION 
 *  ------------------------------------------------- 
 *  3-March-2013  Nam Dinh    Create new
 * @param ten
 * @return long
 */
public static long countByCongDan(String ten) {

    DynamicQuery query = DynamicQueryFactoryUtil.forClass(CongDan.class);
    Criterion criterion = null;
    ten = ten.toUpperCase();

    criterion = RestrictionsFactoryUtil.ilike("ten", StringPool.PERCENT + ten + StringPool.PERCENT);
    criterion = RestrictionsFactoryUtil.or(criterion,
            RestrictionsFactoryUtil.ilike("ho", StringPool.PERCENT + ten + StringPool.PERCENT));
    criterion = RestrictionsFactoryUtil.or(criterion,
            RestrictionsFactoryUtil.ilike("dem", StringPool.PERCENT + ten + StringPool.PERCENT));
    criterion = RestrictionsFactoryUtil.or(criterion,
            RestrictionsFactoryUtil.ilike("tenDayDu", StringPool.PERCENT + ten + StringPool.PERCENT));
    criterion = RestrictionsFactoryUtil.or(criterion,
            RestrictionsFactoryUtil.ilike("email", StringPool.PERCENT + ten + StringPool.PERCENT));
    criterion = RestrictionsFactoryUtil.or(criterion,
            RestrictionsFactoryUtil.ilike("ma", StringPool.PERCENT + ten + StringPool.PERCENT));
    criterion = RestrictionsFactoryUtil.or(criterion,
            RestrictionsFactoryUtil.ilike("soCmnd", StringPool.PERCENT + ten + StringPool.PERCENT));
    criterion = RestrictionsFactoryUtil.and(criterion,
            RestrictionsFactoryUtil.eq("tinhtrang", Constants.TINHTRANG_SONG));
    criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.eq("daXoa", Constants.ACTIVE));

    query = query.add(criterion);
    query.setProjection(ProjectionFactoryUtil.rowCount());

    long count = 0;

    try {
        Iterator<Long> resultsItr = CongDanLocalServiceUtil.dynamicQuery(query).iterator();

        if (resultsItr.hasNext()) {
            count = ((Long) resultsItr.next()).longValue();
        }
    } catch (SystemException se) {
        // _log.error(se.getMessage(), se);
    }

    return count;
}

---

From source file:org.oep.cmon.portlet.doanhnghiep.quanlytaikhoan.business.CongDanBusiness.java

License:Apache License

/**
 * This is  function find CongDan/*  w w w. ja  v  a2 s  .co m*/
 * Version: 1.0
 *  
 * History: 
 *   DATE        AUTHOR      DESCRIPTION 
 *  ------------------------------------------------- 
 *  3-March-2013  Nam Dinh    Create new
 * @param ten
 * @param start
 * @param end
 * @return list<CongDan>
 */
public static List<CongDan> findByCongDan(String ten, int start, int end) {
    List<CongDan> results = null;
    DynamicQuery query = DynamicQueryFactoryUtil.forClass(CongDan.class);
    query.addOrder(OrderFactoryUtil.asc("ten"));
    query.setLimit(start, end);
    Criterion criterion = null;

    ten = ten.toUpperCase();

    criterion = RestrictionsFactoryUtil.ilike("ten", StringPool.PERCENT + ten + StringPool.PERCENT);
    criterion = RestrictionsFactoryUtil.or(criterion,
            RestrictionsFactoryUtil.ilike("ho", StringPool.PERCENT + ten + StringPool.PERCENT));
    criterion = RestrictionsFactoryUtil.or(criterion,
            RestrictionsFactoryUtil.ilike("dem", StringPool.PERCENT + ten + StringPool.PERCENT));
    criterion = RestrictionsFactoryUtil.or(criterion,
            RestrictionsFactoryUtil.ilike("tenDayDu", StringPool.PERCENT + ten + StringPool.PERCENT));
    criterion = RestrictionsFactoryUtil.or(criterion,
            RestrictionsFactoryUtil.ilike("email", StringPool.PERCENT + ten + StringPool.PERCENT));
    criterion = RestrictionsFactoryUtil.or(criterion,
            RestrictionsFactoryUtil.ilike("ma", StringPool.PERCENT + ten + StringPool.PERCENT));
    criterion = RestrictionsFactoryUtil.or(criterion,
            RestrictionsFactoryUtil.ilike("soCmnd", StringPool.PERCENT + ten + StringPool.PERCENT));
    criterion = RestrictionsFactoryUtil.and(criterion,
            RestrictionsFactoryUtil.eq("tinhtrang", Constants.TINHTRANG_SONG));
    criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.eq("daXoa", Constants.ACTIVE));

    // Define search criteria
    query = query.add(criterion);

    try {
        results = CongDanLocalServiceUtil.dynamicQuery(query);
    } catch (SystemException e) {
    }

    if (results == null) {
        results = new ArrayList<CongDan>();
    }
    return results;

}

---

From source file:org.oep.cmon.portlet.doanhnghiep.quanlytaikhoan.business.DoanhNghiepBusiness.java

License:Apache License

/**
 * This is  function get count DoanhNghiep
 * Version: 1.0/*  ww w . j  a  va 2  s . c om*/
 *  
 * History: 
 *   DATE        AUTHOR      DESCRIPTION 
 *  ------------------------------------------------- 
 *  3-March-2013  Nam Dinh    Create new
 * @param searchInputText
 * @param idLoaiDoiTuong
 * @param daXoa
 * @throws Exception
 * @return int
 */
@SuppressWarnings("unchecked")
public static int countDoanhNghiep(String searchInputText, long idLoaiDoiTuong, int daXoa) throws Exception {
    List<DoanhNghiep> listDoanhNghiep = new ArrayList<DoanhNghiep>();
    DynamicQuery query = DynamicQueryFactoryUtil.forClass(DoanhNghiepImpl.class,
            PortalClassLoaderUtil.getClassLoader());
    if (!searchInputText.equals("")) {
        Criterion creterion = RestrictionsFactoryUtil.ilike("ten",
                StringPool.PERCENT + searchInputText + StringPool.PERCENT);
        creterion = RestrictionsFactoryUtil.or(creterion,
                RestrictionsFactoryUtil.ilike("ma", StringPool.PERCENT + searchInputText + StringPool.PERCENT));
        //         creterion = RestrictionsFactoryUtil.or(
        //               creterion,
        //               RestrictionsFactoryUtil.ilike("masothue", StringPool.PERCENT
        //                     + searchInputText + StringPool.PERCENT));
        query.add(creterion);
    }
    query.add(PropertyFactoryUtil.forName(CmonFields.daXoa).eq(daXoa));
    query.add(PropertyFactoryUtil.forName("loaiDoiTuongId").eq(idLoaiDoiTuong));
    listDoanhNghiep = CoQuanQuanLyLocalServiceUtil.dynamicQuery(query, QueryUtil.ALL_POS, QueryUtil.ALL_POS);
    return listDoanhNghiep.size();
}

---

From source file:org.oep.cmon.portlet.doanhnghiep.quanlytaikhoan.business.DoanhNghiepBusiness.java

License:Apache License

/**
 * This is  function search DoanhNghiep//  w  w w. j  av a 2s  .c o  m
 * Version: 1.0
 *  
 * History: 
 *   DATE        AUTHOR      DESCRIPTION 
 *  ------------------------------------------------- 
 *  3-March-2013  Nam Dinh    Create new
 * @param searchInputText
 * @param idLoaiDoiTuong
 * @param daXoa
 * @param start
 * @param end
 * @throws Exception
 * @return List<DoanhNghiep>
 */
@SuppressWarnings("unchecked")
public static List<DoanhNghiep> searchDoanhNghiep(String searchInputText, long idLoaiDoiTuong, int daXoa,
        int start, int end) throws Exception {
    List<DoanhNghiep> listDoanhNghiep = new ArrayList<DoanhNghiep>();
    DynamicQuery query = DynamicQueryFactoryUtil.forClass(DoanhNghiepImpl.class,
            PortalClassLoaderUtil.getClassLoader());
    if (!searchInputText.equals("")) {
        Criterion creterion = RestrictionsFactoryUtil.ilike("ten",
                StringPool.PERCENT + searchInputText + StringPool.PERCENT);
        creterion = RestrictionsFactoryUtil.or(creterion,
                RestrictionsFactoryUtil.ilike("ma", StringPool.PERCENT + searchInputText + StringPool.PERCENT));
        //         creterion = RestrictionsFactoryUtil.or(
        //               creterion,
        //               RestrictionsFactoryUtil.ilike("masothue", StringPool.PERCENT
        //                     + searchInputText + StringPool.PERCENT));
        query.add(creterion);
    }
    //query.add(PropertyFactoryUtil.forName("abc").isNull());
    query.add(PropertyFactoryUtil.forName(CmonFields.daXoa).eq(daXoa));
    query.add(PropertyFactoryUtil.forName("loaiDoiTuongId").eq(idLoaiDoiTuong));
    query.addOrder(OrderFactoryUtil.asc("ten"));
    listDoanhNghiep = CoQuanQuanLyLocalServiceUtil.dynamicQuery(query, start, end);
    return listDoanhNghiep;
}

---

From source file:org.oep.cmon.portlet.doanhnghiep.quanlytaikhoan.business.QuanLyTaiKhoan.java

License:Apache License

/**
 * This is  function get count DoanhNghiep
 * Version: 1.0//  w w  w  .  j a  v  a 2s . c o  m
 *  
 * History: 
 *   DATE        AUTHOR      DESCRIPTION 
 *  ------------------------------------------------- 
 *  3-March-2013  Nam Dinh    Create new
 * @param ten
 * @param loaiDoiTuongId
 * @throws trangThai
 * @return long
 */
public static long countByDoanhNghiep(String ten, long loaiDoiTuongId, int trangThai) {

    DynamicQuery query = DynamicQueryFactoryUtil.forClass(DoanhNghiep.class);

    if (!ten.equals("")) {
        Criterion criterion = null;
        ten = ten.toUpperCase();
        criterion = RestrictionsFactoryUtil.ilike("ten", StringPool.PERCENT + ten + StringPool.PERCENT);

        criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("tenTiengNuocNgoai",
                StringPool.PERCENT + ten + StringPool.PERCENT));
        criterion = RestrictionsFactoryUtil.or(criterion,
                RestrictionsFactoryUtil.ilike("tenVietTat", StringPool.PERCENT + ten + StringPool.PERCENT));

        criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("emailDoanhNghiep",
                StringPool.PERCENT + ten + StringPool.PERCENT));
        criterion = RestrictionsFactoryUtil.or(criterion,
                RestrictionsFactoryUtil.ilike("soGCNDKKD", StringPool.PERCENT + ten + StringPool.PERCENT));
        criterion = RestrictionsFactoryUtil.and(criterion,
                RestrictionsFactoryUtil.eq("daXoa", Constants.ACTIVE));
        query = query.add(criterion);
    }
    if (loaiDoiTuongId != 0) {
        Criterion criterion1 = RestrictionsFactoryUtil.eq("loaiDoiTuongId", loaiDoiTuongId);
        criterion1 = RestrictionsFactoryUtil.and(criterion1,
                RestrictionsFactoryUtil.eq("daXoa", Constants.ACTIVE));
        query = query.add(criterion1);
    }
    if (trangThai != 99) {
        Criterion criterion2 = null;
        if (trangThai == 2) {
            criterion2 = RestrictionsFactoryUtil.isNull("taiKhoanNguoiDungId");
        } else
            criterion2 = RestrictionsFactoryUtil.isNotNull("taiKhoanNguoiDungId");

        criterion2 = RestrictionsFactoryUtil.and(criterion2,
                RestrictionsFactoryUtil.eq("daXoa", Constants.ACTIVE));
        query = query.add(criterion2);
    }

    //query.setProjection(ProjectionFactoryUtil.max("thuTuHienThi"));
    query.setProjection(ProjectionFactoryUtil.rowCount());
    //query.setProjection(ProjectionFactoryUtil.sum("counter"));
    //DynamicQueryInitializ dqi = new DynamicQueryInitializerImpl(query);

    long count = 0;

    try {
        Iterator<Long> resultsItr = DoanhNghiepLocalServiceUtil.dynamicQuery(query).iterator();

        if (resultsItr.hasNext()) {
            count = ((Long) resultsItr.next()).longValue();
        }
    } catch (SystemException se) {
        // _log.error(se.getMessage(), se);
    }

    return count;
}

---

From source file:org.oep.cmon.portlet.doanhnghiep.quanlytaikhoan.business.QuanLyTaiKhoan.java

License:Apache License

/**
 * This is  function get list DoanhNghiep
 * Version: 1.0/*from w  w  w  .  j a  va  2s .  c  o  m*/
 *  
 * History: 
 *   DATE        AUTHOR      DESCRIPTION 
 *  ------------------------------------------------- 
 *  3-March-2013  Nam Dinh    Create new
 * @param ten
 * @param loaiDoiTuongId
 * @param trangThai
 * @param start
 * @param end
 * @throws SystemException
 */
public static List<DoanhNghiep> getListDoanhNghiep(String ten, long loaiDoiTuongId, int trangThai, int start,
        int end) throws SystemException {

    DynamicQuery query = DynamicQueryFactoryUtil.forClass(DoanhNghiep.class);
    List<DoanhNghiep> results = null;
    if (!ten.equals("")) {
        Criterion criterion = null;
        ten = ten.toUpperCase();
        criterion = RestrictionsFactoryUtil.ilike("ten", StringPool.PERCENT + ten + StringPool.PERCENT);

        criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("tenTiengNuocNgoai",
                StringPool.PERCENT + ten + StringPool.PERCENT));
        criterion = RestrictionsFactoryUtil.or(criterion,
                RestrictionsFactoryUtil.ilike("tenVietTat", StringPool.PERCENT + ten + StringPool.PERCENT));

        criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.ilike("emailDoanhNghiep",
                StringPool.PERCENT + ten + StringPool.PERCENT));
        criterion = RestrictionsFactoryUtil.or(criterion,
                RestrictionsFactoryUtil.ilike("soGCNDKKD", StringPool.PERCENT + ten + StringPool.PERCENT));
        criterion = RestrictionsFactoryUtil.and(criterion,
                RestrictionsFactoryUtil.eq("daXoa", Constants.ACTIVE));
        query = query.add(criterion);
    }
    if (loaiDoiTuongId != 0) {
        Criterion criterion1 = RestrictionsFactoryUtil.eq("loaiDoiTuongId", loaiDoiTuongId);
        criterion1 = RestrictionsFactoryUtil.and(criterion1,
                RestrictionsFactoryUtil.eq("daXoa", Constants.ACTIVE));
        query = query.add(criterion1);
    }
    if (trangThai != 99) {
        Criterion criterion2 = null;
        if (trangThai == 2) {
            criterion2 = RestrictionsFactoryUtil.isNull("taiKhoanNguoiDungId");
        } else
            criterion2 = RestrictionsFactoryUtil.isNotNull("taiKhoanNguoiDungId");

        criterion2 = RestrictionsFactoryUtil.and(criterion2,
                RestrictionsFactoryUtil.eq("daXoa", Constants.ACTIVE));
        query = query.add(criterion2);
    }
    results = DoanhNghiepLocalServiceUtil.dynamicQuery(query);
    if (results == null) {
        results = new ArrayList<DoanhNghiep>();
    }
    return results;

}

---

From source file:org.oep.cmon.portlet.doanhnghiep.xacthuc.utils.XacThucDoanhNghiepUtils.java

License:Apache License

@SuppressWarnings("unchecked")
public static List<DoanhNghiep> searchDoanhNghiep(String searchInputText, long idLoaiDoiTuong, int daXoa,
        int start, int end) throws Exception {
    List<DoanhNghiep> listDoanhNghiep = new ArrayList<DoanhNghiep>();
    DynamicQuery query = DynamicQueryFactoryUtil.forClass(DoanhNghiepImpl.class,
            PortalClassLoaderUtil.getClassLoader());
    if (!searchInputText.equals("")) {
        Criterion creterion = RestrictionsFactoryUtil.ilike("ten",
                StringPool.PERCENT + searchInputText + StringPool.PERCENT);
        creterion = RestrictionsFactoryUtil.or(creterion, RestrictionsFactoryUtil.ilike("soGCNDKKD",
                StringPool.PERCENT + searchInputText + StringPool.PERCENT));
        creterion = RestrictionsFactoryUtil.or(creterion, RestrictionsFactoryUtil.ilike("maSoThue",
                StringPool.PERCENT + searchInputText + StringPool.PERCENT));
        query.add(creterion);//from   w  ww .  ja  v  a 2 s.  c o m
    }
    query.add(PropertyFactoryUtil.forName("taiKhoanNguoiDungId").isNull());
    query.add(PropertyFactoryUtil.forName(CmonFields.daXoa).eq(daXoa));
    query.add(PropertyFactoryUtil.forName("loaiDoiTuongId").eq(idLoaiDoiTuong));
    query.addOrder(OrderFactoryUtil.asc("ten"));
    listDoanhNghiep = CoQuanQuanLyLocalServiceUtil.dynamicQuery(query, start, end);
    return listDoanhNghiep;
}

---

From source file:org.oep.cmon.portlet.doanhnghiep.xacthuc.utils.XacThucDoanhNghiepUtils.java

License:Apache License

@SuppressWarnings("unchecked")
public static int countDoanhNghiep(String searchInputText, long idLoaiDoiTuong, int daXoa) throws Exception {
    List<DoanhNghiep> listDoanhNghiep = new ArrayList<DoanhNghiep>();
    DynamicQuery query = DynamicQueryFactoryUtil.forClass(DoanhNghiepImpl.class,
            PortalClassLoaderUtil.getClassLoader());
    if (!searchInputText.equals("")) {
        Criterion creterion = RestrictionsFactoryUtil.ilike("ten",
                StringPool.PERCENT + searchInputText + StringPool.PERCENT);
        creterion = RestrictionsFactoryUtil.or(creterion, RestrictionsFactoryUtil.ilike("soGCNDKKD",
                StringPool.PERCENT + searchInputText + StringPool.PERCENT));
        creterion = RestrictionsFactoryUtil.or(creterion, RestrictionsFactoryUtil.ilike("maSoThue",
                StringPool.PERCENT + searchInputText + StringPool.PERCENT));
        query.add(creterion);/* w  ww. j  a  va  2 s .c o  m*/
    }
    query.add(PropertyFactoryUtil.forName("taiKhoanNguoiDungId").isNull());
    query.add(PropertyFactoryUtil.forName(CmonFields.daXoa).eq(daXoa));
    query.add(PropertyFactoryUtil.forName("loaiDoiTuongId").eq(idLoaiDoiTuong));
    listDoanhNghiep = CoQuanQuanLyLocalServiceUtil.dynamicQuery(query, QueryUtil.ALL_POS, QueryUtil.ALL_POS);
    return listDoanhNghiep.size();
}

---

From source file:org.oep.cmon.portlet.doanhnghiep.xacthuc.utils.XacThucDoanhNghiepUtils.java

License:Apache License

@SuppressWarnings("unchecked")
public static long countListCongDan(String ten) {
    DynamicQuery query = DynamicQueryFactoryUtil.forClass(CongDan.class);
    Criterion criterion = null;//from   w  w w.  j  av a  2s  .c om
    ten = ten.toUpperCase();

    criterion = RestrictionsFactoryUtil.ilike("ten", StringPool.PERCENT + ten + StringPool.PERCENT);
    criterion = RestrictionsFactoryUtil.or(criterion,
            RestrictionsFactoryUtil.ilike("ho", StringPool.PERCENT + ten + StringPool.PERCENT));
    criterion = RestrictionsFactoryUtil.or(criterion,
            RestrictionsFactoryUtil.ilike("dem", StringPool.PERCENT + ten + StringPool.PERCENT));
    criterion = RestrictionsFactoryUtil.or(criterion,
            RestrictionsFactoryUtil.ilike("tenDayDu", StringPool.PERCENT + ten + StringPool.PERCENT));
    criterion = RestrictionsFactoryUtil.or(criterion,
            RestrictionsFactoryUtil.ilike("email", StringPool.PERCENT + ten + StringPool.PERCENT));
    criterion = RestrictionsFactoryUtil.or(criterion,
            RestrictionsFactoryUtil.ilike("ma", StringPool.PERCENT + ten + StringPool.PERCENT));
    criterion = RestrictionsFactoryUtil.or(criterion,
            RestrictionsFactoryUtil.ilike("soCmnd", StringPool.PERCENT + ten + StringPool.PERCENT));
    criterion = RestrictionsFactoryUtil.and(criterion,
            RestrictionsFactoryUtil.eq("tinhtrang", Constants.TINHTRANG_SONG));
    criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.eq("daXoa", Constants.ACTIVE));

    query = query.add(criterion);
    query.setProjection(ProjectionFactoryUtil.rowCount());

    long count = 0;

    try {
        Iterator<Long> resultsItr = CongDanLocalServiceUtil.dynamicQuery(query).iterator();

        if (resultsItr.hasNext()) {
            count = ((Long) resultsItr.next()).longValue();
        }
    } catch (SystemException se) {
        // _log.error(se.getMessage(), se);
    }

    return count;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• »