Changeset 5183 for openmrs/branches/data_synchronization_bidirectional/src/api/org/openmrs/api/db/hibernate/HibernatePersonDAO.java
- Timestamp:
- 08/06/08 17:17:55 (5 months ago)
- Files:
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
openmrs/branches/data_synchronization_bidirectional/src/api/org/openmrs/api/db/hibernate/HibernatePersonDAO.java
r4969 r5183 26 26 import org.hibernate.criterion.MatchMode; 27 27 import org.hibernate.criterion.Order; 28 import org.openmrs.Drug; 28 import org.hibernate.criterion.Projections; 29 import org.hibernate.criterion.Restrictions; 29 30 import org.hibernate.type.StringType; 31 import org.hibernate.type.Type; 30 32 import org.openmrs.Person; 31 33 import org.openmrs.PersonAddress; … … 215 217 216 218 criteria.add(Expression.eq("personVoided", false)); 217 218 219 if (dead != null) 219 criteria.add(Expression.eq("dead", dead)); 220 220 criteria.add(Expression.eq("dead", dead)); 221 221 criteria.addOrder(Order.asc("personId")); 222 222 criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY); 223 223 return criteria.list(); 224 224 } … … 377 377 public List<RelationshipType> getRelationshipTypes(String relationshipTypeName, Boolean preferred) throws DAOException { 378 378 379 Criteria criteria = sessionFactory.getCurrentSession().createCriteria(RelationshipType.class, "t"); 380 criteria.add(Expression.eq("retired", false)); 381 criteria.add(Expression.sql("CONCAT(t.aIsToB, CONCAT('/', t.bIsToA))", relationshipTypeName, new StringType())); 379 Criteria criteria = sessionFactory.getCurrentSession().createCriteria(RelationshipType.class); 380 criteria.add(Restrictions.sqlRestriction("CONCAT(a_Is_To_B, CONCAT('/', b_Is_To_A)) like (?)", relationshipTypeName, new StringType())); 382 381 383 382 if (preferred != null) … … 389 388 /** 390 389 * @see org.openmrs.api.PatientService#getRelationshipTypes() 391 * @see org.openmrs.api.db.PersonDAO#getAllRelationshipTypes( boolean)390 * @see org.openmrs.api.db.PersonDAO#getAllRelationshipTypes() 392 391 */ 393 392 @SuppressWarnings("unchecked") 394 public List<RelationshipType> getAllRelationshipTypes( boolean includeRetired) throws DAOException {393 public List<RelationshipType> getAllRelationshipTypes() throws DAOException { 395 394 396 395 Criteria criteria = sessionFactory.getCurrentSession().createCriteria(RelationshipType.class, "t"); 397 396 398 if (!includeRetired)399 criteria.add(Expression.eq("retired", false)); 397 /**if (!includeRetired) 398 criteria.add(Expression.eq("retired", false));*/ 400 399 401 400 criteria.addOrder(Order.asc("weight"));