public List findByRoleNameLike(String roleName) {
Session session = HibernateTrain.getSession();
Criteria criteria =
session.createCriteria(StaffRole.class).add(Restrictions.like("roleName", roleName));
return criteria.list();
}
public Integer getCountUserValidate(String staffPiority) {
Criteria criteria = getSession().createCriteria(User.class);
criteria.add(Restrictions.eq("validateStu", 0));
criteria.add(Restrictions.like("piority", "%" + staffPiority + "%"));
ProjectionList projectionList = Projections.projectionList();
projectionList.add(Projections.count("validateStu"));
criteria.setProjection(projectionList);
Integer count = (Integer) criteria.uniqueResult();
closeSession();
return count;
}
public List<User> getUserValidate(String piority, Integer page) {
Criteria criteria = getSession().createCriteria(User.class);
criteria.add(Restrictions.eq("validateStu", 0));
criteria.add(Restrictions.like("piority", "%" + piority + "%"));
criteria.addOrder(Order.asc("dateCreate"));
page = (page - 1) * 10;
criteria.setFirstResult(page);
criteria.setMaxResults(10);
List<User> list = (List<User>) criteria.list();
closeSession();
return list;
}
public List<User> getStaffData(
String fName, String lName, String nickName, String company, String employeeId) {
Criteria criteria = getSession().createCriteria(User.class);
if (BeanUtils.isNotEmpty(fName) && BeanUtils.isNotEmpty(lName)) {
if (BeanUtils.isNotEmpty(fName)) {
criteria.add(Restrictions.like("thFname", "%" + fName + "%"));
}
if (BeanUtils.isNotEmpty(lName)) {
criteria.add(Restrictions.like("thLname", "%" + lName + "%"));
}
} else if (BeanUtils.isEmpty(lName) && BeanUtils.isNotEmpty(fName)) {
criteria.add(
Restrictions.or(
Restrictions.like("thFname", "%" + fName + "%"),
Restrictions.like("thLname", "%" + fName + "%")));
}
if (BeanUtils.isNotEmpty(nickName)) {
criteria.add(Restrictions.like("nickName", "%" + nickName + "%"));
}
if (BeanUtils.isNotEmpty(employeeId)) {
criteria.add(Restrictions.like("empId", "%" + employeeId + "%"));
}
if (BeanUtils.isNotEmpty(company)) {
criteria.add(Restrictions.eq("compId", Integer.parseInt(company)));
}
criteria.add(Restrictions.eq("status", 2));
List<User> list = (List<User>) criteria.list();
closeSession();
return list;
}
public List<User> getStudentData(
String fName,
String lName,
String nickName,
String staff,
String position,
String piority,
Integer status) {
Criteria criteria = getSession().createCriteria(User.class);
if (BeanUtils.isNotEmpty(fName) && BeanUtils.isNotEmpty(lName)) {
if (BeanUtils.isNotEmpty(fName)) {
criteria.add(Restrictions.like("thFname", "%" + fName + "%"));
}
if (BeanUtils.isNotEmpty(lName)) {
criteria.add(Restrictions.like("thLname", "%" + lName + "%"));
}
} else if (BeanUtils.isEmpty(lName) && BeanUtils.isNotEmpty(fName)) {
criteria.add(
Restrictions.or(
Restrictions.like("thFname", "%" + fName + "%"),
Restrictions.like("thLname", "%" + fName + "%")));
}
if (BeanUtils.isNotEmpty(nickName)) {
criteria.add(Restrictions.like("nickName", "%" + nickName + "%"));
}
if (BeanUtils.isNotEmpty(staff)) {
criteria.add(Restrictions.eq("staffId", Integer.parseInt(staff))); // Edit by PEEM
}
if (BeanUtils.isNotEmpty(position)) {
criteria.add(Restrictions.eq("posiId", Integer.parseInt(position)));
}
criteria.add(Restrictions.eq("status", 3));
criteria.add(Restrictions.eq("validateStu", 1));
if (status == 2) {
criteria.add(Restrictions.like("piority", "%" + piority + "%"));
criteria.add(Restrictions.ne("piority", piority));
}
// page = (page-1)*10;
// criteria.setFirstResult(page);
// criteria.setMaxResults(10);
List<User> list = (List<User>) criteria.list();
closeSession();
return list;
}
public static Integer findPiority(String pior, Integer status) {
Integer sizePioruty = 0;
StringBuffer piorityBuffer = new StringBuffer();
Criteria criteria = getSession().createCriteria(User.class);
criteria.add(Restrictions.like("piority", pior + "%"));
criteria.add(Restrictions.eq("status", status));
criteria.add(new LengthExpression("piority", pior.length() + 3));
criteria.addOrder(Order.asc("piority"));
List<User> list = (List<User>) criteria.list();
sizePioruty = list.size();
if ((list.size() > 0 && status == 3) || (status == 2 && list.size() > 0)) {
piorityBuffer.append(
list.get(list.size() - 1)
.getPiority()
.charAt(list.get(list.size() - 1).getPiority().length() - 3)
+ "");
piorityBuffer.append(
list.get(list.size() - 1)
.getPiority()
.charAt(list.get(list.size() - 1).getPiority().length() - 2)
+ "");
piorityBuffer.append(
list.get(list.size() - 1)
.getPiority()
.charAt(list.get(list.size() - 1).getPiority().length() - 1)
+ "");
sizePioruty = Integer.parseInt(piorityBuffer.toString()) + 1;
}
if (list.size() <= 0 && status == 2) {
sizePioruty++;
}
if (list.size() <= 0 && status == 3) {
sizePioruty++;
}
return sizePioruty;
}
/**
* Restricts the results by the given properties value
*
* @param property The name of the property
* @param expr The expression to restrict by
* @return This query instance
*/
public Query like(String property, String expr) {
criteria.add(Restrictions.like(property, expr));
return this;
}
public List findByCountryNameLike(String countryName) {
Criteria criteria =
session.createCriteria(Countries.class).add(Restrictions.like("countryName", countryName));
return criteria.list();
}