/** @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();
}
}
}
@SuppressWarnings("unchecked")
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
SecurityContextImpl securityContextImpl =
(SecurityContextImpl) req.getSession().getAttribute("SPRING_SECURITY_CONTEXT");
String username = securityContextImpl.getAuthentication().getName();
System.out.println("Username:"******"Credentials:" + password);
UserDetails ud = (UserDetails) securityContextImpl.getAuthentication().getPrincipal();
String userid = null;
if (ud instanceof LoginUserDetailsImpl) {
LoginUserDetailsImpl lud = (LoginUserDetailsImpl) ud;
userid = lud.getUserid();
}
JQueryDataTableParamModel param = DataTablesParamUtility.getParam(req);
String sEcho = param.sEcho;
int iTotalRecords; // total number of records (unfiltered)
int iTotalDisplayRecords; // value will be set when code filters companies by keyword
JSONArray data = new JSONArray(); // data that will be shown in the table
ArrayList<Device> list = new ArrayList<Device>();
try {
ArrayList<Entity> devs =
(ArrayList<Entity>) client.get("/user/" + userid + "/devices", username, password);
for (Entity e : devs) {
Device dev = (Device) e;
list.add(dev);
}
} catch (Exception e1) {
e1.printStackTrace();
}
System.out.println("size:" + list.size());
iTotalRecords = list.size();
List<Device> devices = new LinkedList<Device>();
for (Device d : list) {
if (d.getName() == null) {
continue;
}
if (d.getName().toLowerCase().contains(param.sSearch.toLowerCase())) {
devices.add(d);
continue;
}
if (d.getCode() == null) {
continue;
}
if (d.getCode().toLowerCase().contains(param.sSearch.toLowerCase())) {
devices.add(d);
continue;
}
devices.add(d);
}
iTotalDisplayRecords =
devices.size(); // Number of companies that matches search criterion should be returned
final int sortColumnIndex = param.iSortColumnIndex;
final int sortDirection = param.sSortDirection.equals("asc") ? -1 : 1;
Collections.sort(
devices,
new Comparator<Device>() {
@Override
public int compare(Device c1, Device c2) {
switch (sortColumnIndex) {
case 1:
return c1.getName().compareTo(c2.getName()) * sortDirection;
case 3:
return c1.getCode().compareTo(c2.getCode()) * sortDirection;
}
return 0;
}
});
if (devices.size() < param.iDisplayStart + param.iDisplayLength)
devices = devices.subList(param.iDisplayStart, devices.size());
else devices = devices.subList(param.iDisplayStart, param.iDisplayStart + param.iDisplayLength);
JSONObject jsonResponse = new JSONObject();
jsonResponse.put("sEcho", sEcho);
jsonResponse.put("iTotalRecords", iTotalRecords);
jsonResponse.put("iTotalDisplayRecords", iTotalDisplayRecords);
for (Device c : devices) {
JSONArray row = new JSONArray();
row.add(
"<a href='img/demo/big.jpg' title='' class='lightbox'><img src='http://placehold.it/37x37' alt='' /></a>");
row.add(c.getId());
row.add(c.getName());
row.add(c.getCode());
row.add(
"<ul class='table-controls'>"
+ "<li><a href='queryvariable.html?id="
+ c.getId()
+ "' class='btn tip' title='View'><i class='ico-eye-open'></i></a></li>"
+ "<li><a href='#' class='btn tip' onclick='disconnect("
+ c.getId()
+ ")' title='Disconnect'><i class=' ico-minus'></i></a></li>"
+ "<li><a href='#' class='btn tip' title='Share'><i class='ico-share'></i></a></li>"
+ "</ul>");
data.add(row);
}
jsonResponse.put("aaData", data);
System.out.println(jsonResponse.toJSONString());
resp.setContentType("application/json");
resp.getWriter().print(jsonResponse.toString());
}