TavernerPOS - Source Code
Clone:
git clone http://www.librarysmith.co.uk/tavernerPOS
package com.floreantpos.model.dao;
import java.util.List;
import org.apache.commons.lang.StringUtils;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Disjunction;
import org.hibernate.criterion.MatchMode;
import org.hibernate.criterion.Restrictions;
import com.floreantpos.model.Customer;
public class CustomerDAO extends BaseCustomerDAO {
/**
* Default constructor. Can be used in place of getInstance()
*/
public CustomerDAO() {
}
public List<Customer> findBy(String phone, String loyalty, String name) {
Session session = null;
try {
session = getSession();
Criteria criteria = session.createCriteria(getReferenceClass());
Disjunction disjunction = Restrictions.disjunction();
if (StringUtils.isNotEmpty(phone))
disjunction.add(Restrictions.like(Customer.PROP_TELEPHONE_NO, "%" + phone + "%")); //$NON-NLS-1$ //$NON-NLS-2$
if (StringUtils.isNotEmpty(loyalty))
disjunction.add(Restrictions.like(Customer.PROP_LOYALTY_NO, "%" + loyalty + "%")); //$NON-NLS-1$ //$NON-NLS-2$
if (StringUtils.isNotEmpty(name))
disjunction.add(Restrictions.like(Customer.PROP_NAME, "%" + name + "%")); //$NON-NLS-1$ //$NON-NLS-2$
criteria.add(disjunction);
return criteria.list();
} finally {
if (session != null) {
closeSession(session);
}
}
}
public List<Customer> findByName(String name) {
Session session = null;
try {
session = getSession();
Criteria criteria = session.createCriteria(getReferenceClass());
if (StringUtils.isNotEmpty(name))
criteria.add(Restrictions.ilike(Customer.PROP_NAME, name+"%".trim(),MatchMode.ANYWHERE)); //$NON-NLS-1$ //$NON-NLS-2$
return criteria.list();
} finally {
if (session != null) {
closeSession(session);
}
}
}
}
- Details
- Last Updated: Monday, 04 April 2016 02:04
- Hits: 37355451