public BonusTO[] searchPageRecord(String txtMbrCode, String txtDateFrom, String txtDateTo) {
String searchQuery = ConstantValue.EMPTY_STRING;
ArrayList<String> arrParameter = new ArrayList<String>();
if (txtMbrCode != null && txtMbrCode.length() > 0) {
searchQuery += " where b.code = ?";
arrParameter.add(txtMbrCode);
}
if ((txtDateFrom != null && txtDateTo != null)
&& (txtDateFrom.length() > 0 && txtDateTo.length() > 0)) {
if (searchQuery.length() > 0) {
searchQuery += " and a.trx_date between ? and ?";
} else {
searchQuery += " where a.trx_date between ? and ?";
}
arrParameter.add(txtDateFrom);
arrParameter.add(txtDateTo);
}
BonusDAO bonusDAO = new BonusDAO();
String[] parameterList = (String[]) arrParameter.toArray(new String[0]);
return bonusDAO.searchBonus(searchQuery, parameterList);
}
