public StringBuffer getFilterFields(Object obj) {
ReportViewBean objReportViewBean = new ReportViewBean();
objReportViewBean = (ReportViewBean) obj;
String cardNo = objReportViewBean.getCardNo();
String cardProduct = objReportViewBean.getCardProduct();
String recon = objReportViewBean.getRecon();
StringBuffer sbfStr = new StringBuffer();
sbfStr.append("FROM TRANXLOG TL, CURRENCIES CU, CARDS CA, CARD_PRODUCTS CP ");
sbfStr.append("WHERE TL.CURRCODE = CU.CURR_CODE ");
sbfStr.append("AND TL.CARDNUMBER = CA.CARDNUMBER ");
sbfStr.append("AND CA.CARD_PRODUCT_ID = CP.CARD_PRODUCT_ID ");
if ((cardNo != null) && (!cardNo.trim().equals(""))) {
sbfStr.append("AND TL.CARDNUMBER = '" + cardNo + "' ");
}
if ((cardProduct != null) && (!cardProduct.trim().equals(""))) {
sbfStr.append("AND CA.CARD_PRODUCT_ID = '" + cardProduct + "' ");
}
if ((recon != null) && (!recon.trim().equals(""))) {
sbfStr.append("AND TL.RECON = '" + recon + "' ");
sbfStr.append("AND CP.CARD_PRODUCT_TYPE_ID <> 3 ");
}
sbfStr.append("ORDER BY TL.TRANXLOGID DESC ");
return sbfStr;
}
public Object setRequest(HttpServletRequest objRequest, HttpSession objSession)
throws ReportException {
ReportViewBean objReportViewBean = new ReportViewBean();
try {
String mode = objRequest.getParameter("mode");
objReportViewBean.setMode(mode);
objReportViewBean.setOpCode(objRequest.getParameter("hdOpCode"));
DBUtil emvdbutil = new DBUtil();
String strUserIssuerId = (String) objSession.getAttribute("ISSUER");
ArrayList arlProductList = emvdbutil.getCardProductList(strUserIssuerId);
objReportViewBean.setArlCardProductList(arlProductList);
this.userName = (String) objSession.getAttribute("USERID");
if (mode.trim().equals("Search")
|| mode.trim().equals("Next")
|| mode.trim().equals("View")
|| mode.trim().equals("Prev")
|| mode.trim().equals("Down")) {
if (objRequest.getParameter("CARD_PRODUCT") != null) {
objReportViewBean.setCardProduct(objRequest.getParameter("CARD_PRODUCT"));
}
if (objRequest.getParameter("CARD_NO") != null) {
objReportViewBean.setCardNo(objRequest.getParameter("CARD_NO"));
}
if (objRequest.getParameter("RECON") != null) {
objReportViewBean.setRecon(objRequest.getParameter("RECON"));
}
}
} catch (Exception e) {
throw new ReportException(
"" + ErrorCodes.REQUEST_FAIL, "Exception in getting the input parameters");
}
return objReportViewBean;
}