/** This method used to connect to the Conection pool */
public void connect() throws ConnectException, RemoteException {
try {
conn = null;
conn = dbconn.open();
USFEnv.getLog().writeDebug("created db connection(), ref: " + conn.toString(), this, null);
} catch (Exception e) {
throw new ConnectException("Database connection failure");
}
}
/** @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
final DataTableRequestParam param = DataTablesParamUtility.getParam(request);
String sEcho = param.sEcho;
int iTotalRecords = 0; // total number of records (unfiltered)
int iTotalDisplayRecords = 0; // value will be set when code filters companies by keyword
// DBConnection dbconn = new DBConnection();
ErateProducts erateProducts = new ErateProducts();
HttpSession session = request.getSession();
Connection conn = null;
DBConn dbconn = new DBConn();
if (conn == null) {
conn = dbconn.open();
}
JSONArray data = new JSONArray(); // data that will be shown in the table
try {
iTotalRecords = erateProducts.getProductCount(conn);
} catch (Exception e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
}
// iTotalRecords = DataRepository.GetCompanies().size();
// List<ProductDataDao> companies = new LinkedList<ProductDataDao>();
List<ProductDataDao> companies = new LinkedList(Collections.nCopies(iTotalRecords, null));
ProductDataDao dao = new ProductDataDao();
System.out.println("company size" + DataRepository.GetCompanies().size());
// for (int i=0;i<iTotalRecords;i++){
// List arr ;
boolean flag = false;
String searchValue = param.sSearchKeyword.toLowerCase();
// System.out.println("testing search.."+param.sSearchKeyword.toLowerCase());
USFEnv.getLog().writeDebug("testing search.." + param.sSearchKeyword.toLowerCase(), this, null);
if (!searchValue.equals("")) {
flag = true;
} else {
}
String var = "NotInSearch";
session.setAttribute("companySize", var);
if (param.bSearchable[1] && flag) {
try {
dao = erateProducts.searchCRISProduct(param.sSearchKeyword.toLowerCase(), conn);
if (dao.getProductCode() == null) {
companies.clear();
} else {
session.removeAttribute("companySize");
companies.clear();
companies.add(dao);
if (companies.size() > 0) {
var = "inFilteredRecord";
session.setAttribute("companySize", var);
} else {
var = "outSideFilteredRecord";
session.setAttribute("companySize", var);
}
// session.setAttribute("companySize",companies.size());
}
// iTotalDisplayRecords1 =companies.size();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if (dao.getProductCode() != null) {
// boolean flag= true;
// companies.add(dao);
}
}
// boolean flag = false;
/* if( param.bSearchable[1]) {
try {
dao = dbconn.searchProduct(param.sSearchKeyword.toLowerCase());
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if(dao.getProductCode()!=null ){
boolean flag= true;
companies.add(dao);
}
}*/
// param.sSearchKeyword.toLowerCase()
// if( param.bSearchable[1] &&
// c.getName().toLowerCase().contains(param.sSearchKeyword.toLowerCase())
// || param.bSearchable[2] &&
// c.getAddress().toLowerCase().contains(param.sSearchKeyword.toLowerCase())
// || param.bSearchable[3] &&
// c.getTown().toLowerCase().contains(param.sSearchKeyword.toLowerCase()))
// }
/*for(ProductDataDao c : iTotalRecords){
//Cannot search by column 0 (id)
if( param.bSearchable[1] &&
c.getName().toLowerCase().contains(param.sSearchKeyword.toLowerCase())
||
param.bSearchable[2] &&
c.getAddress().toLowerCase().contains(param.sSearchKeyword.toLowerCase())
||
param.bSearchable[3] &&
c.getTown().toLowerCase().contains(param.sSearchKeyword.toLowerCase()))
{
// companies.add(c); // Add a company that matches search criterion
}
}*/
try {
iTotalDisplayRecords = erateProducts.getProductCount(conn);
USFEnv.getLog().writeDebug("iTotalDisplayRecords" + iTotalDisplayRecords, this, null);
// System.out.println("iTotalDisplayRecords"+iTotalDisplayRecords);
} catch (Exception e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
}
// iTotalDisplayRecords = companies.size();//Number of companies that matches search criterion
// should be returned
USFEnv.getLog()
.writeDebug(
" before param.iDisplayStart"
+ param.iDisplayStart
+ "companies.size()"
+ companies.size(),
this,
null);
// System.out.println(" before
// param.iDisplayStart"+param.iDisplayStart+"companies.size()"+companies.size());
if (companies.size() < param.iDisplayStart + param.iDisplayLength) {
companies = companies.subList(param.iDisplayStart, companies.size());
} else {
try {
// System.out.println(" after
// param.iDisplayStart"+param.iDisplayStart+"param.iDisplayLength"+param.iDisplayLength);
companies =
erateProducts.getProductInfo(
param.iDisplayStart, param.iDisplayStart + param.iDisplayLength, conn);
System.out.println("after");
try {
if (conn != null) {
conn.close();
}
} catch (Exception e) {
// TODO: handle exception
}
} catch (Exception e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
// System.out.println(" after
// param.iDisplayStart"+param.iDisplayStart+"param.iDisplayLength"+param.iDisplayLength);
USFEnv.getLog()
.writeDebug(
" after param.iDisplayStart"
+ param.iDisplayStart
+ "param.iDisplayLength"
+ param.iDisplayLength,
this,
null);
session.putValue("param.iDisplayStart", param.iDisplayStart);
session.putValue("param.length", param.iDisplayStart + param.iDisplayLength);
try {
JSONObject jsonResponse = new JSONObject();
jsonResponse.put("sEcho", sEcho);
jsonResponse.put("iTotalRecords", iTotalRecords);
jsonResponse.put("iTotalDisplayRecords", iTotalDisplayRecords);
for (ProductDataDao c : companies) {
JSONArray row = new JSONArray();
row.put(c.getSeq_id())
.put(c.getProductCode())
.put(c.getDescription())
.put(c.getModifiedBy())
.put((new SimpleDateFormat("MM/dd/yyyy")).format((java.util.Date) c.getModifiedDate()));
data.put(row);
}
jsonResponse.put("aaData", data);
response.setContentType("application/json");
response.getWriter().print(jsonResponse.toString());
} catch (JSONException e) {
e.printStackTrace();
response.setContentType("text/html");
response.getWriter().print(e.getMessage());
} finally {
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}