List of usage examples for com.liferay.portal.kernel.dao.orm RestrictionsFactoryUtil isNull
public static Criterion isNull(String propertyName)
From source file:at.graz.hmmc.liferay.portlet.puch.service.impl.TransaktionLocalServiceImpl.java
License:Open Source License
/** * /*from w w w . j a va 2s . c om*/ */ 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.service.service.impl.InvitationOrganisationLocalServiceImpl.java
License:Open Source License
/** * @throws SystemException /*from www . j a va 2s. c o m*/ */ 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.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 = ""; }/* w w w . 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:org.oep.cmon.portlet.doanhnghiep.quanlytaikhoan.business.QuanLyTaiKhoan.java
License:Apache License
/** * This is function get count DoanhNghiep * Version: 1.0/* www . j av 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. jav a 2s. c om * * 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.taocongdan.business.TaoCongDanBusiness.java
License:Apache License
/** * This is fucntion findByCongDan/*w w w. j a v a 2 s .co m*/ * Version: 1.0 * * History: * DATE AUTHOR DESCRIPTION * ------------------------------------------------- * 3-March-2013 Nam Dinh Create new * @param String ten, String taiKhoanNguoiDungId, int start, int end * @return List<CongDan> */ @SuppressWarnings("unchecked") public static List<CongDan> findByCongDan(String ten, String taiKhoanNguoiDungId, int start, int end) { List<CongDan> results = null; DynamicQuery query = DynamicQueryFactoryUtil.forClass(CongDan.class); query.addOrder(OrderFactoryUtil.asc("ten")); query.setLimit(start, end); // This is a test line for display all request if there's no search criteria 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)); if (taiKhoanNguoiDungId != "") { if (taiKhoanNguoiDungId.equals(String.valueOf(Constants.TaoCongDan.CO_TAI_KHOAN))) { criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.isNotNull("taiKhoanNguoiDungId")); } else { criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.isNull("taiKhoanNguoiDungId")); } } 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.taocongdan.business.TaoCongDanBusiness.java
License:Apache License
/** * This is fucntion countByCongDan/*from w w w . j av a2 s . co m*/ * Version: 1.0 * * History: * DATE AUTHOR DESCRIPTION * ------------------------------------------------- * 3-March-2013 Nam Dinh Create new * @param String ten, String taiKhoanNguoiDungId * @return long */ @SuppressWarnings("unchecked") public static long countByCongDan(String ten, String taiKhoanNguoiDungId) { 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)); if (taiKhoanNguoiDungId != "") { if (taiKhoanNguoiDungId.equals(String.valueOf(Constants.TaoCongDan.CO_TAI_KHOAN))) { criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.isNotNull("taiKhoanNguoiDungId")); } else { criterion = RestrictionsFactoryUtil.and(criterion, RestrictionsFactoryUtil.isNull("taiKhoanNguoiDungId")); } } 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.thamso.action.ThamSoPortlet.java
License:Apache License
/** * This is fucntion findByTenThamSo/*from w ww .ja va2 s. c o m*/ * Version: 1.0 * * History: * DATE AUTHOR DESCRIPTION * ------------------------------------------------- * 3-March-2013 Nam Dinh Create new * @param String keyWord, Long ungDungId, Long heThongId, int start, int end * @return List<ThamSo> */ @SuppressWarnings("unchecked") public List<ThamSo> findByTenThamSo(String keyWord, Long ungDungId, Long heThongId, int start, int end) { List<ThamSo> results = null; if (keyWord.trim().length() > 0 | ungDungId != null | heThongId != null) { // Query code request using keyword DynamicQuery query = DynamicQueryFactoryUtil.forClass(ThamSo.class); query.addOrder(OrderFactoryUtil.asc("Ten")); query.setLimit(start, end); // This is a test line for display all request if there's no search criteria Criterion criteriaTen = RestrictionsFactoryUtil.ilike("Ten", StringPool.PERCENT + keyWord + StringPool.PERCENT); Criterion criteriaUngDung = null; Criterion criteriaHeThong = null; if (ungDungId != null) { criteriaUngDung = RestrictionsFactoryUtil.eq("UngDungId", ungDungId); } else { criteriaUngDung = RestrictionsFactoryUtil.isNull("UngDungId"); } if (heThongId != null) { criteriaHeThong = RestrictionsFactoryUtil.eq("HeThongId", heThongId); } else { criteriaHeThong = RestrictionsFactoryUtil.isNull("HeThongId"); } Criterion criteria = RestrictionsFactoryUtil.and(criteriaUngDung, criteriaHeThong); query = query.add(RestrictionsFactoryUtil.and(criteriaTen, criteria)); try { results = ThamSoLocalServiceUtil.dynamicQuery(query); } catch (SystemException e) { } } else { try { DynamicQuery query = DynamicQueryFactoryUtil.forClass(ThamSo.class); query.addOrder(OrderFactoryUtil.asc("Ten")); query.setLimit(start, end); results = ThamSoLocalServiceUtil.dynamicQuery(query); } catch (SystemException e) { } } if (results == null) { results = new ArrayList<ThamSo>(); } return results; }