List of usage examples for org.hibernate.criterion Order isAscending
@SuppressWarnings("UnusedDeclaration") public boolean isAscending()
From source file:com.ephesoft.dcma.da.dao.hibernate.BatchClassModuleDaoImpl.java
License:Open Source License
/** * API to fetch all batch class modules in order. * @param order Order//w ww . jav a 2 s .co m * @return List<BatchClassModule> */ @Override public List<BatchClassModule> getAllBatchClassModulesInOrder(com.ephesoft.dcma.core.common.Order order) { DetachedCriteria criteria = criteria(); if (order != null) { if (order.isAscending()) { criteria.addOrder(Order.asc(order.getSortProperty().getProperty())); } else { criteria.addOrder(Order.desc(order.getSortProperty().getProperty())); } } return find(criteria); }
From source file:com.inkubator.hrm.dao.impl.EmpDataDaoImpl.java
@Override public List<ReportEmpPensionPreparationModel> getReportPensionPreparementByParam(List<Long> listDepartmentId, List<Long> listEmpTypeId, List<Integer> listEmpAges, int firstResult, int maxResults, Order order) { final StringBuilder query = new StringBuilder( "SELECT empData.NIK AS nik, bioData.first_name AS firstName, bioData.last_name AS lastName, " + " empData.join_date AS tglMulaiBekerja, golonganJabatan.code AS golJabatan, bioData.date_of_birth AS tglLahir, " + " umur(bioData.date_of_birth , NOW()) AS usiaKaryawan, " + " jabatan.name AS jabatan, department.department_name AS departmentName, department.id AS departmentId, " + " employeeType.id AS empTypeId , employeeType.name AS statusKaryawan FROM emp_data empData " + " INNER JOIN golongan_jabatan golonganJabatan ON empData.gol_jab_id = golonganJabatan.id " + " INNER JOIN bio_data bioData ON empData.bio_data_id = bioData.id " + " INNER JOIN jabatan jabatan ON empData.jabatan_id = jabatan.id " + " INNER JOIN department department ON jabatan.departement_id = department.id " + " INNER JOIN company company ON company.id = department.company_id " + " INNER JOIN employee_type employeeType ON empData.emp_type_id = employeeType.id "); //Flag Untuk penanda apakah ada filter atau tidak //boolean isFiltered = !listDepartmentId.isEmpty() || !listEmpTypeId.isEmpty() || !listEmpAges.isEmpty(); //Flag untuk penanda jika filter lebih dari satu //boolean multipleFilter = Boolean.FALSE; //if (isFiltered) { query.append(" WHERE company.id = " + HrmUserInfoUtil.getCompanyId() + " "); //}//from w w w. ja v a 2 s . co m if (!listDepartmentId.isEmpty()) { query.append(" jabatan.departement_id IN( "); int size = listDepartmentId.size(); //karena pakai native query, isi List harus di parsing satu per satu for (int i = 0; i < size; i++) { if (i < (size - 1)) { query.append(String.valueOf(listDepartmentId.get(i))); query.append(" , "); } else { query.append(String.valueOf(listDepartmentId.get(i))); } } query.append(") "); //multipleFilter = Boolean.TRUE; } if (!listEmpTypeId.isEmpty()) { //if (multipleFilter) { query.append("AND empData.emp_type_id IN( "); /*} else { query.append(" e.emp_type_id IN( "); multipleFilter = Boolean.TRUE; }*/ //karena pakai native query, isi List harus di parsing satu per satu int size = listEmpTypeId.size(); for (int i = 0; i < size; i++) { if (i < (size - 1)) { query.append(String.valueOf(listEmpTypeId.get(i))); query.append(" , "); } else { query.append(String.valueOf(listEmpTypeId.get(i))); } } query.append(") "); } if (!listEmpAges.isEmpty()) { //if (multipleFilter) { query.append(" AND umur(bioData.date_of_birth , NOW()) IN( "); /*} else { query.append("umur(b.date_of_birth , NOW()) IN( "); }*/ //karena pakai native query, isi List harus di parsing satu per satu int size = listEmpAges.size(); for (int i = 0; i < size; i++) { if (i < (size - 1)) { query.append(String.valueOf(listEmpAges.get(i))); query.append(" , "); } else { query.append(String.valueOf(listEmpAges.get(i))); } } query.append(") "); } query.append(" ORDER BY "); if (StringUtils.equals("nik", order.getPropertyName())) { query.append("empData.nik "); } else if (StringUtils.equals("firstName", order.getPropertyName())) { query.append("bioData.first_name "); } else if (StringUtils.equals("tglMulaiBekerja", order.getPropertyName())) { query.append("empData.join_date "); } else if (StringUtils.equals("golJabatan", order.getPropertyName())) { query.append("golonganJabatan.code "); } else if (StringUtils.equals("jabatan", order.getPropertyName())) { query.append("jabatan.name "); } else if (StringUtils.equals("usiaKaryawan", order.getPropertyName())) { query.append("umur(bioData.date_of_birth , NOW()) "); } query.append(order.isAscending() ? " ASC " : " DESC "); //Limit query based on paging parameter query.append("LIMIT ").append(firstResult).append(",").append(maxResults).append(" "); return getCurrentSession().createSQLQuery(query.toString()) .setResultTransformer(Transformers.aliasToBean(ReportEmpPensionPreparationModel.class)).list(); }
From source file:com.inkubator.hrm.dao.impl.EmpDataDaoImpl.java
public List<RecruitAgreementNoticeViewModel> getAllEmployeeForRecruitAggrementNoticeWithNativeQuery( RecruitAgreementNoticeSearchParameter searchParameter, int firstResult, int maxResults, Order orderable) { final StringBuilder query = new StringBuilder( "SELECT emp.id as employeeId, bio.id as bioDataId, bio.first_name as firstName, bio.last_name as lastName, jabatan.name as jabatanName, pangkat.pangkat_name as pangkatName, bio.date_of_birth as birthOfDate,"); query.append(" (SELECT pangkat2.pangkat_name FROM pangkat pangkat2"); query.append(" WHERE pangkat2.level < pangkat.level ORDER BY LEVEL DESC LIMIT 1) as jabatanDituju,"); query.append(" pangkat.level,"); query.append(" (SELECT el.name FROM education_level el "); query.append(" INNER JOIN bio_education_history beh ON el.id = beh.pendidikan_level_id"); query.append(" INNER JOIN bio_data bio2 ON bio2.id = beh.biodata_id"); query.append(" WHERE beh.biodata_id = bio.id ORDER by el.name DESC LIMIT 1 ) as lastEducationLevel"); query.append(" FROM bio_data bio "); query.append(" LEFT JOIN emp_data emp ON bio.id = emp.bio_data_id"); /* query.append(" INNER JOIN bio_education_history beh ON beh.biodata_id = bio.id"); query.append(" INNER JOIN education_level el ON el.id = beh.pendidikan_level_id");*/ query.append(" LEFT JOIN jabatan jabatan ON emp.jabatan_id = jabatan.id"); query.append(" LEFT JOIN golongan_jabatan goljab ON goljab.id = emp.gol_jab_id"); query.append(" LEFT JOIN pangkat pangkat ON goljab.pangkat_id = pangkat.id"); //query for action searching doSearchEmployeeForRecruitAgreementNoticeWithNativeQuery(searchParameter, query); //order query base on orderable query.append(" ORDER BY "); if (StringUtils.equals("firstName", orderable.getPropertyName())) { query.append("firstName "); } else if (StringUtils.equals("jabatanName", orderable.getPropertyName())) { query.append("jabatanName "); } else if (StringUtils.equals("jabatanDituju", orderable.getPropertyName())) { query.append("jabatanDituju "); } else if (StringUtils.equals("lastEducationLevel", orderable.getPropertyName())) { query.append("lastEducationLevel "); } else if (StringUtils.equals("birthOfDate", orderable.getPropertyName())) { query.append("birthOfDate "); }/*from ww w. j ava 2 s.c o m*/ query.append(orderable.isAscending() ? " ASC " : " DESC "); //Limit query based on paging parameter query.append(" LIMIT ").append(firstResult).append(",").append(maxResults).append(" "); return getCurrentSession().createSQLQuery(query.toString()) .setResultTransformer(Transformers.aliasToBean(RecruitAgreementNoticeViewModel.class)).list(); }
From source file:com.inkubator.sms.gateway.dao.impl.GroupPhoneDaoImpl.java
@Override public List<GroupPhone> getAllByFullTextService(String parameter, int first, int pageSize, Order order) { FullTextSession fullTextSession = Search.getFullTextSession(getCurrentSession()); Criteria criteria = fullTextSession.createCriteria(GroupPhone.class); Sort sort;// w ww .j a va2 s.c o m if (order.isAscending()) { sort = new Sort(new SortField(order.getPropertyName(), SortField.STRING_VAL)); } else { sort = new Sort(new SortField(order.getPropertyName(), SortField.STRING_VAL, true)); } FullTextQuery fullTextQuery1 = doSearchFullText(parameter, fullTextSession); fullTextQuery1.setCriteriaQuery(criteria); fullTextQuery1.setFirstResult(first); fullTextQuery1.setMaxResults(pageSize); fullTextQuery1.setSort(sort); return fullTextQuery1.list(); }
From source file:com.inkubator.sms.gateway.dao.impl.LoginHistoryDaoImpl.java
@Override public List<LoginHistory> getAllByFullTextService(String parameter, int minResult, int maxResult, Order order) { System.out.println(parameter + "muahahahhahahha"); FullTextSession fullTextSession = Search.getFullTextSession(getCurrentSession()); org.apache.lucene.search.Sort sort;//from www . ja v a2 s. c om if (order.isAscending()) { sort = new Sort(new SortField(order.getPropertyName(), SortField.STRING_VAL)); } else { sort = new Sort(new SortField(order.getPropertyName(), SortField.STRING_VAL, true)); } System.out.println("Nilai sorrt " + order.getPropertyName()); FullTextQuery fullTextQuery1 = doSearchFullText(parameter, fullTextSession); fullTextQuery1.setFirstResult(minResult); fullTextQuery1.setMaxResults(maxResult); fullTextQuery1.setSort(sort); return fullTextQuery1.list(); }
From source file:com.inkubator.sms.gateway.dao.impl.PhoneBookDaoImpl.java
@Override public List<PhoneBook> getAllByFullTextService(String parameter, int first, int pageSize, Order order) { FullTextSession fullTextSession = Search.getFullTextSession(getCurrentSession()); Criteria criteria = fullTextSession.createCriteria(getEntityClass()); Sort sort;//from w ww. j av a 2 s.co m if (order.isAscending()) { sort = new Sort(new SortField(order.getPropertyName(), SortField.STRING_VAL)); } else { sort = new Sort(new SortField(order.getPropertyName(), SortField.STRING_VAL, true)); } FullTextQuery fullTextQuery1 = doSearchFullText(parameter, fullTextSession); fullTextQuery1.setCriteriaQuery(criteria); fullTextQuery1.setFirstResult(first); fullTextQuery1.setMaxResults(pageSize); fullTextQuery1.setSort(sort); return fullTextQuery1.list(); }
From source file:com.inkubator.sms.gateway.dao.impl.RoleDaoImpl.java
@Override public List<Role> getAllByFullTextService(String parameter, int minResult, int maxResult, Order order) { FullTextSession fullTextSession = Search.getFullTextSession(getCurrentSession()); org.apache.lucene.search.Sort sort;//w ww . j a va 2 s. com if (order.isAscending()) { sort = new Sort(new SortField(order.getPropertyName(), SortField.STRING_VAL)); } else { sort = new Sort(new SortField(order.getPropertyName(), SortField.STRING_VAL, true)); } System.out.println("Nilai sort " + order.getPropertyName()); FullTextQuery fullTextQuery1 = doSearchFullText(parameter, fullTextSession); fullTextQuery1.setFirstResult(minResult); fullTextQuery1.setMaxResults(maxResult); fullTextQuery1.setSort(sort); // fullTextQuery1.setSort(sort); return fullTextQuery1.list(); }
From source file:com.inkubator.sms.gateway.dao.impl.SmsActivityDaoImpl.java
@Override public List<SmsActivity> getAllByFullTextService(String parameter, int minResult, int maxResult, Order order) { FullTextSession fullTextSession = Search.getFullTextSession(getCurrentSession()); org.apache.lucene.search.Sort sort;//from ww w .j ava2s . com if (order.isAscending()) { sort = new Sort(new SortField(order.getPropertyName(), SortField.STRING_VAL)); } else { sort = new Sort(new SortField(order.getPropertyName(), SortField.STRING_VAL, true)); } System.out.println("Nilai sorrt " + order.getPropertyName()); FullTextQuery fullTextQuery1 = doSearchFullText(parameter, fullTextSession); fullTextQuery1.setFirstResult(minResult); fullTextQuery1.setMaxResults(maxResult); fullTextQuery1.setSort(sort); return fullTextQuery1.list(); }
From source file:com.inkubator.sms.gateway.dao.impl.TaskDefinitionDaoImpl.java
@Override public List<TaskDefinition> getAllByFullTextService(String parameter, int minResult, int maxResult, Order orde) { FullTextSession fullTextSession = Search.getFullTextSession(getCurrentSession()); Criteria criteria = fullTextSession.createCriteria(TaskDefinition.class).setFetchMode("modemDefinition", FetchMode.JOIN);/*from w w w. ja va2s .c o m*/ org.apache.lucene.search.Sort sort; if (orde.isAscending()) { sort = new Sort(new SortField(orde.getPropertyName(), SortField.STRING_VAL)); } else { sort = new Sort(new SortField(orde.getPropertyName(), SortField.STRING_VAL, true)); } System.out.println("Nilai sorrt " + orde.getPropertyName()); FullTextQuery fullTextQuery1 = doSearchFullText(parameter, fullTextSession); fullTextQuery1.setCriteriaQuery(criteria); fullTextQuery1.setFirstResult(minResult); fullTextQuery1.setMaxResults(maxResult); fullTextQuery1.setSort(sort); return fullTextQuery1.list(); }
From source file:com.inkubator.sms.gateway.dao.impl.UserDaoImpl.java
@Override public List<SmsGatewayUser> getAllByFullTextService(String parameter, int minResult, int maxResult, Order order) { FullTextSession fullTextSession = Search.getFullTextSession(getCurrentSession()); org.apache.lucene.search.Sort sort;//from w ww .j a v a 2s . c o m if (order.isAscending()) { sort = new Sort(new SortField(order.getPropertyName(), SortField.STRING_VAL)); } else { sort = new Sort(new SortField(order.getPropertyName(), SortField.STRING_VAL, true)); } System.out.println("Nilai sorrt " + order.getPropertyName()); FullTextQuery fullTextQuery1 = doSearchFullText(parameter, fullTextSession); fullTextQuery1.setFirstResult(minResult); fullTextQuery1.setMaxResults(maxResult); fullTextQuery1.setSort(sort); return fullTextQuery1.list(); }