int startat = startATparam.intValue();
int endat = EndAtparam.intValue();
int begainindex = Math.max(startat - 100, 1);
int endindex = endat + 100;
EventAtendeesList DL = new EventAtendeesList();
DL.setSortMember(sortmem);
CVDal cvdl = new CVDal(dataSource);
cvdl.setSql("EventAtendees.individuallistcreatetable");
cvdl.executeUpdate();
cvdl.clearParameters();
cvdl.setSql("EventAtendees.individuallistinsert");
cvdl.setInt(1, eventID);
cvdl.executeUpdate();
cvdl.clearParameters();
cvdl.setSql("EventAtendees.individuallistupdate");
cvdl.executeUpdate();
cvdl.clearParameters();
if (searchString == null)
searchString = "";
String appendStr = "";
String strSQL = "";
if (sortmem == null) {
sortmem = "individualname";
}
if (sortmem.equals("name"))
sortmem = "individualname";
if (sorttype == 'A') {
strSQL = "Select individualID individualid,concat(FirstName ,' ', LastName) individualname,Email email, accepted from individuallist order by "
+ sortmem + " LIMIT " + (begainindex - 1) + " , " + (endindex + 1) + ";";
} else {
strSQL = "Select individualID individualid,concat(FirstName ,' ', LastName) individualname,Email email, accepted from individuallist order by "
+ sortmem + " DESC LIMIT " + (begainindex - 1) + " , " + (endindex + 1) + ";";
}
if (searchString.startsWith("SIMPLE :")) {
searchString = searchString.substring(8);
appendStr = " where lr.literatureid like '%" + searchString + "%' OR lr.title like '%"
+ searchString + "%' OR ind.firstname like '%" + searchString
+ "%' OR ind.lastname like '%" + searchString + "%' OR ac.created like '%"
+ searchString + "%' OR en.name like '%" + searchString + "%' and ";
// strSQL = strSQL.replaceFirst("where ", appendStr);
}
cvdl.setSqlQuery(strSQL);
Collection v = cvdl.executeQuery();
cvdl.setSql("EventAtendees.individuallistdroptable");
cvdl.executeUpdate();
cvdl.clearParameters();
cvdl.destroy();
Iterator it = v.iterator();
TimeZone tz = TimeZone.getTimeZone("EST");
int i = 0;
while (it.hasNext()) {
i++;
HashMap hm = (HashMap)it.next();
int ID = ((Long)hm.get("individualid")).intValue();
IntMember individualid = new IntMember("individualid", ID, 10, "", 'T', false, 10);
StringMember individualname = new StringMember("individualname", (String)hm
.get("individualname"), 10, "", 'T', true);
StringMember email = new StringMember("email", (String)hm.get("email"), 10, "", 'T', true);
StringMember accepted = new StringMember("accepted", (String)hm.get("accepted"), 10, "", 'T',
false);
EventAtendeesListElement ele = new EventAtendeesListElement(ID);
ele.put("individualid", individualid);
ele.put("individualname", individualname);
ele.put("email", email);
ele.put("accepted", accepted);
// added by Sameer for generating fixed length sort key from i
StringBuffer sb = new StringBuffer("00000000000");
sb.setLength(11);
String str = (new Integer(i)).toString();
sb.replace((sb.length() - str.length()), (sb.length()), str);
String newOrd = sb.toString();
DL.put(newOrd, ele);
DL.setTotalNoOfRecords(DL.size());
DL.setListType("EventAtendees");
DL.setBeginIndex(begainindex);
DL.setEndIndex(endindex);
}
return DL;