@Override
public Object[] search(MaintenancehistoryBean bean) {
Map<String, Object> properties = new HashMap<String, Object>();
StringBuffer whereClause = new StringBuffer(" 1 = 1");
if (bean.getPojo().getMachine() != null && bean.getPojo().getMachine().getMachineID() > 0) {
properties.put("machine.machineID", bean.getPojo().getMachine().getMachineID());
}
if (bean.getPojo().getMachinecomponent() != null
&& bean.getPojo().getMachinecomponent().getMachineComponentID() > 0) {
properties.put(
"machinecomponent.machineComponentID",
bean.getPojo().getMachinecomponent().getMachineComponentID());
}
if (bean.getFromDate() != null) {
whereClause.append(" AND maintenanceDate >= '").append(bean.getFromDate()).append("'");
}
if (bean.getToDate() != null) {
whereClause.append(" AND maintenanceDate <= '").append(bean.getToDate()).append("'");
}
return this.maintenancehistoryDAO.searchByProperties(
properties,
bean.getFirstItem(),
bean.getMaxPageItems(),
bean.getSortExpression(),
bean.getSortDirection(),
true,
whereClause.toString());
}
