String formatScriptResultHTML(
String script, Object result, Exception error, StringBuffer scriptOutput) throws IOException {
SimpleTemplate tmplt;
if (error != null) {
tmplt = new SimpleTemplate(getClass().getResource("error.template"));
String errString;
if (error instanceof bsh.EvalError) {
int lineNo = ((EvalError) error).getErrorLineNumber();
String msg = error.getMessage();
int contextLines = 4;
errString = escape(msg);
if (lineNo > -1) errString += "<hr>" + showScriptContextHTML(script, lineNo, contextLines);
} else errString = escape(error.toString());
tmplt.replace("error", errString);
} else {
tmplt = new SimpleTemplate(getClass().getResource("result.template"));
tmplt.replace("value", escape(String.valueOf(result)));
tmplt.replace("output", escape(scriptOutput.toString()));
}
return tmplt.toString();
}
public ActionForward execute(
ActionMapping mapping, ActionForm form, HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
try {
GpsImportForm gpsForm = (GpsImportForm) form;
User user = (User) req.getSession().getAttribute("user");
int entryId = gpsForm.getEntryId();
String fileName = gpsForm.getFileName();
String title = gpsForm.getTitle();
String activityId = gpsForm.getActivityId();
String xml = gpsForm.getXml();
log.debug(xml);
List<GpsTrack> tracks = new TcxParser().parse(xml.getBytes());
GpsTrack track = tracks.get(0); // Horrible hack.
createAttachment(user, entryId, fileName, title, activityId, track);
createGeotag(fileName, track);
req.setAttribute("status", "success");
req.setAttribute("message", "");
log.debug("Returning status: success.");
return mapping.findForward("results");
} catch (Exception e) {
log.fatal("Error processing incoming Garmin XML", e);
req.setAttribute("status", "failure");
req.setAttribute("message", e.toString());
return mapping.findForward("results");
}
}
/**
* Sets an application attribute.
*
* @param name the name of the attribute
* @param value the value of the attribute
*/
public void setAttribute(String name, Object value) {
Object oldValue;
synchronized (_attributes) {
if (value != null) oldValue = _attributes.put(name, value);
else oldValue = _attributes.remove(name);
}
// Call any listeners
if (_applicationAttributeListeners != null) {
ServletContextAttributeEvent event;
if (oldValue != null) event = new ServletContextAttributeEvent(this, name, oldValue);
else event = new ServletContextAttributeEvent(this, name, value);
for (int i = 0; i < _applicationAttributeListeners.size(); i++) {
ServletContextAttributeListener listener;
Object objListener = _applicationAttributeListeners.get(i);
listener = (ServletContextAttributeListener) objListener;
try {
if (oldValue != null) listener.attributeReplaced(event);
else listener.attributeAdded(event);
} catch (Exception e) {
log.log(Level.FINE, e.toString(), e);
}
}
}
}
private void forceV3Poll() {
ArchivalUnit au = getAu();
if (au == null) return;
try {
callV3ContentPoll(au);
} catch (Exception e) {
log.error("Can't start poll", e);
errMsg = "Error: " + e.toString();
}
}
public static String loadDriver() {
String sErr = "";
try {
java.sql.DriverManager.registerDriver(
(java.sql.Driver) (Class.forName(DBDriver).newInstance()));
} catch (Exception e) {
sErr = e.toString();
}
return (sErr);
}
/**
* this is the main method of the servlet that will service all get requests.
*
* @param request HttpServletRequest
* @param responce HttpServletResponce
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
HttpSession session = null;
try {
try {
session = request.getSession(true);
} catch (Exception e) {
Log.error(e, "PingSession2.doGet(...): error getting session");
// rethrow the exception for handling in one place.
throw e;
}
// Get the session data value
Integer ival = (Integer) session.getAttribute("sessiontest.counter");
// if there is not a counter then create one.
if (ival == null) {
ival = new Integer(1);
} else {
ival = new Integer(ival.intValue() + 1);
}
session.setAttribute("sessiontest.counter", ival);
// if the session count is equal to five invalidate the session
if (ival.intValue() == 5) {
session.invalidate();
}
try {
// Output the page
response.setContentType("text/html");
response.setHeader("SessionTrackingTest-counter", ival.toString());
PrintWriter out = response.getWriter();
out.println(
"<html><head><title>Session Tracking Test 2</title></head><body><HR><BR><FONT size=\"+2\" color=\"#000066\">HTTP Session Test 2: Session create/invalidate <BR></FONT><FONT size=\"+1\" color=\"#000066\">Init time: "
+ initTime
+ "</FONT><BR><BR>");
hitCount++;
out.println(
"<B>Hit Count: " + hitCount + "<BR>Session hits: " + ival + "</B></body></html>");
} catch (Exception e) {
Log.error(e, "PingSession2.doGet(...): error getting session information");
// rethrow the exception for handling in one place.
throw e;
}
} catch (Exception e) {
// log the excecption
Log.error(e, "PingSession2.doGet(...): error.");
// set the server responce to 500 and forward to the web app defined error page
response.sendError(500, "PingSession2.doGet(...): error. " + e.toString());
}
} // end of the method
private void doV3Poll() {
ArchivalUnit au = getAu();
if (au == null) return;
try {
callV3ContentPoll(au);
} catch (PollManager.NotEligibleException e) {
errMsg = "AU is not eligible for poll: " + e.getMessage();
// errMsg = "Ineligible: " + e.getMessage() +
// "<br>Click again to force new poll.";
// showForcePoll = true;
return;
} catch (Exception e) {
log.error("Can't start poll", e);
errMsg = "Error: " + e.toString();
}
}
public void init(ServletConfig config) throws ServletException {
try {
String ps = config.getServletContext().getRealPath("/WEB-INF/jiql.properties");
if (!new File(ps).exists()) {
return;
}
NameValuePairs p = new NameValuePairs(ps);
theUser = (String) p.get("user");
thePassword = (String) p.get("password");
if (p.getInt("maxUpload") > 0) mU = p.getInt("maxUpload");
} catch (Exception e) {
tools.util.LogMgr.err("JiqlServlet.init " + e.toString());
e.printStackTrace(System.out);
}
super.init(config);
}
public Object process(ResultSet rs) {
String users = "";
try {
while (rs.next()) {
users =
users
+ "<li>"
+ "<a href=/user1/user/"
+ rs.getString(1)
+ ">"
+ rs.getString(2)
+ "</a>"
+ "</li>";
}
} catch (Exception e) {
users = e.toString();
}
return (Object) users;
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
Integer etat = (Integer) request.getSession().getAttribute("etat");
if (etat == null) {
RequestDispatcher dispatcher = request.getRequestDispatcher("/login.jsp");
dispatcher.forward(request, response);
} else {
try {
String titre = request.getParameter("titre");
String dateSortie = request.getParameter("dateSortie");
String nom = request.getParameter("nom");
String role = request.getParameter("role");
// conversion du parametre dateSortie en SQLDate
Date date;
try {
date = new Date(FormatDate.convertirDate(dateSortie).getTime());
} catch (ParseException e) {
throw new Tp6Exception(
"Format de la date " + dateSortie + " incorrect. AAAA-MM-JJ attendue.");
}
// executer la transaction
GestionTp6 tp6Update = (GestionTp6) request.getSession().getAttribute("tp6Update");
synchronized (tp6Update) {
tp6Update.gestionFilm.ajoutActeurFilm(titre, date, nom, role);
}
RequestDispatcher dispatcher = request.getRequestDispatcher("/WEB-INF/menu.jsp");
dispatcher.forward(request, response);
} catch (Tp6Exception e) {
List<String> listeMessageErreur = new LinkedList<String>();
listeMessageErreur.add(e.toString());
request.setAttribute("listeMessageErreur", listeMessageErreur);
RequestDispatcher dispatcher = request.getRequestDispatcher("/WEB-INF/menu.jsp");
dispatcher.forward(request, response);
} catch (Exception e) {
e.printStackTrace();
response.sendError(HttpServletResponse.SC_INTERNAL_SERVER_ERROR, e.toString());
}
}
}
/**
* this is the main method of the servlet that will service all get requests.
*
* @param request HttpServletRequest
* @param responce HttpServletResponce
*/
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
try {
res.setContentType("text/html");
// The following 2 lines are the difference between PingServlet and PingServletWriter
// the latter uses a PrintWriter for output versus a binary output stream.
ServletOutputStream out = res.getOutputStream();
// java.io.PrintWriter out = res.getWriter();
hitCount++;
out.println(
"<html><head><title>Ping Servlet</title></head>"
+ "<body><HR><BR><FONT size=\"+2\" color=\"#000066\">Ping Servlet<BR></FONT><FONT size=\"+1\" color=\"#000066\">Init time : "
+ initTime
+ "<BR><BR></FONT> <B>Hit Count: "
+ hitCount
+ "</B></body></html>");
} catch (Exception e) {
Log.error(e, "PingServlet.doGet(...): general exception caught");
res.sendError(500, e.toString());
}
}
public void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
resp.setContentType("text/html");
PrintWriter out = resp.getWriter();
Connection con = null; // init DB objects
PreparedStatement pstmt = null;
Statement stmt = null;
ResultSet rs = null;
try {
con = dbConn.Connect("demopaul");
} catch (Exception ignore) {
}
String stype_id = req.getParameter("type_id");
int type_id = 0;
String sgroup_id = req.getParameter("group_id");
int group_id = 0;
String sitem_id = req.getParameter("item_id");
int item_id = 0;
try {
type_id = Integer.parseInt(stype_id);
} catch (NumberFormatException ignore) {
}
try {
group_id = Integer.parseInt(sgroup_id);
} catch (NumberFormatException ignore) {
}
try {
item_id = Integer.parseInt(sitem_id);
} catch (NumberFormatException ignore) {
}
out.println(
"<!-- type_id=" + type_id + ", group_id=" + group_id + ", item_id=" + item_id + " -->");
out.println("<script>");
out.println("function load_types() {");
out.println(" try {document.forms['frmSelect'].item_id.selectedIndex = -1; } catch (err) {}");
out.println(" document.forms['frmSelect'].group_id.selectedIndex = -1;");
out.println(" document.forms['frmSelect'].submit();");
out.println("}");
out.println("function load_groups() {");
out.println(" document.forms['frmSelect'].submit();");
out.println("}");
out.println("</script>");
out.println("<form name=frmSelect>");
// LOAD ACTIVITY TYPES
out.println("<select name=type_id onchange=\"load_types()\">");
if (type_id == 0) {
out.println("<option>CHOOSE TYPE</option>");
}
try {
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT * FROM activity_types");
while (rs.next()) {
Common_Config.buildOption(rs.getInt("type_id"), rs.getString("type_name"), type_id, out);
}
stmt.close();
} catch (Exception exc) {
out.println("<p>ERROR:" + exc.toString() + "</p>");
}
out.println("");
out.println("</select>");
// LOAD ACTIVITIES BY GROUP TYPE
out.println("<select name=group_id onchange=\"load_groups()\">");
if (type_id == 0) {
out.println("<option>CHOOSE TYPE</option>");
} else {
try {
stmt = con.createStatement();
rs =
stmt.executeQuery(
"SELECT group_id, group_name FROM activity_groups WHERE type_id = " + type_id);
rs.last();
if (rs.getRow() == 1) {
group_id = rs.getInt("group_id");
out.println("<!-- ONLY FOUND 1 GROUP -->");
} else {
out.println("<option value=\"0\">CHOOSE...</option>");
}
rs.beforeFirst();
while (rs.next()) {
Common_Config.buildOption(
rs.getInt("group_id"), rs.getString("group_name"), group_id, out);
}
stmt.close();
} catch (Exception exc) {
out.println("<p>ERROR:" + exc.toString() + "</p>");
}
}
out.println("");
out.println("</select>");
if (group_id > 0) { // || sitem_id != null
// LOAD ACTIVITIES BY ITEM TYPE
out.println("<select name=item_id onchange=\"load_times()\">");
if (group_id == 0) {
out.println("<option value=\"0\">CHOOSE GROUP</option>");
} else {
try {
stmt = con.createStatement();
rs =
stmt.executeQuery(
"SELECT item_id, item_name FROM activity_items WHERE group_id = " + group_id);
rs.last();
if (rs.getRow() == 1) {
item_id = rs.getInt("item_id");
out.println("<!-- ONLY FOUND 1 ITEM -->");
} else {
out.println("<option value=\"0\">CHOOSE...</option>");
}
rs.beforeFirst();
while (rs.next()) {
Common_Config.buildOption(
rs.getInt("item_id"), rs.getString("item_name"), item_id, out);
}
stmt.close();
} catch (Exception exc) {
out.println("<p>ERROR:" + exc.toString() + "</p>");
}
}
out.println("");
out.println("</select>");
}
out.println("</form>");
out.println("<p><a href=\"Member_genrez\">Reset</a></p>");
try {
con.close();
} catch (Exception ignore) {
}
out.close();
}
public void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
resp.setContentType("text/html");
PrintWriter out = resp.getWriter();
PreparedStatement pstmt = null;
Statement stmt = null;
ResultSet rs = null;
HttpSession session = SystemUtils.verifyMem(req, out); // check for intruder
if (session == null) return;
Connection con = Connect.getCon(req); // get DB connection
if (con == null) {
resp.setContentType("text/html");
out.println(SystemUtils.HeadTitle("DB Connection Error"));
out.println("<BODY><CENTER><BR>");
out.println("<BR><BR><H3>Database Connection Error</H3>");
out.println("<BR><BR>Unable to connect to the Database.");
out.println("<BR>Please try again later.");
out.println("<BR><BR>If problem persists, contact customer support.");
out.println("<BR><BR>");
out.println("<a href=\"javascript:history.back(1)\">Return</a>");
out.println("</CENTER></BODY></HTML>");
out.close();
return;
}
//
// Get needed vars out of session obj
//
String club = (String) session.getAttribute("club");
String user = (String) session.getAttribute("user");
String caller = (String) session.getAttribute("caller");
int activity_id = (Integer) session.getAttribute("activity_id");
int foretees_mode = 0;
String stype_id = req.getParameter("type_id");
int type_id = 0;
String sgroup_id = req.getParameter("group_id");
int group_id = 0;
String sitem_id = req.getParameter("item_id");
int item_id = 0;
try {
type_id = Integer.parseInt(stype_id);
} catch (NumberFormatException ignore) {
}
try {
group_id = Integer.parseInt(sgroup_id);
} catch (NumberFormatException ignore) {
}
try {
item_id = Integer.parseInt(sitem_id);
} catch (NumberFormatException ignore) {
}
out.println(
"<!-- type_id=" + type_id + ", group_id=" + group_id + ", item_id=" + item_id + " -->");
//
// START PAGE OUTPUT
//
out.println(SystemUtils.HeadTitle("Member Acivities"));
out.println("<style>");
out.println(".actLink { color: black }");
out.println(".actLink:hover { color: #336633 }");
// out.println(".playerTD {width:125px}");
out.println("</style>");
out.println(
"<body bgcolor=\"#CCCCAA\" text=\"#000000\" link=\"#336633\" vlink=\"#8B8970\" alink=\"#8B8970\">");
SystemUtils.getMemberSubMenu(req, out, caller); // required to allow submenus on this page
//
// DISPLAY A LIST OF AVAILABLE ACTIVITIES
//
out.println(
"<p align=center><b><font size=5 color=#336633><BR><BR>Available Activities</font></b></p>");
out.println(
"<p align=center><b><font size=3 color=#000000>Select your desired activity from the list below.<br>NOTE: You can set your default activity under <a href=\"Member_services\" class=actLink>Settings</a>.</font></b></p>");
out.println("<table align=center>");
try {
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT foretees_mode FROM club5 WHERE clubName <> '';");
if (rs.next()) {
foretees_mode = rs.getInt(1);
}
// if they have foretees then give a link in to the golf system
if (foretees_mode != 0) {
out.println(
"<tr><td align=center><b><a href=\"Member_jump?switch&activity_id=0\" class=linkA style=\"color:#336633\" target=_top>Golf</a></b></td></tr>"); // ForeTees
}
// build a link to any activities they have access to
rs =
stmt.executeQuery(
"SELECT * FROM activities " + "WHERE parent_id = 0 " + "ORDER BY activity_name");
while (rs.next()) {
out.println(
"<tr><td align=center><b><a href=\"Member_jump?switch&activity_id="
+ rs.getInt("activity_id")
+ "\" class=linkA style=\"color:#336633\" target=_top>"
+ rs.getString("activity_name")
+ "</a></b></td></tr>");
}
stmt.close();
} catch (Exception exc) {
out.println("<p>ERROR:" + exc.toString() + "</p>");
} finally {
try {
rs.close();
} catch (Exception ignore) {
}
try {
stmt.close();
} catch (Exception ignore) {
}
}
out.println("</table>");
out.println("</body></html>");
/*
out.println("<script>");
out.println("function load_types() {");
out.println(" try {document.forms['frmSelect'].item_id.selectedIndex = -1; } catch (err) {}");
out.println(" document.forms['frmSelect'].group_id.selectedIndex = -1;");
out.println(" document.forms['frmSelect'].submit();");
out.println("}");
out.println("function load_groups() {");
out.println(" document.forms['frmSelect'].submit();");
out.println("}");
out.println("function load_times(id) {");
out.println(" top.bot.location.href='Member_gensheets?id=' + id;");
out.println("}");
out.println("</script>");
out.println("<form name=frmSelect>");
// LOAD ACTIVITY TYPES
out.println("<select name=type_id onchange=\"load_types()\">");
if (type_id == 0) {
out.println("<option>CHOOSE TYPE</option>");
}
try {
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT * FROM activities WHERE parent_id = 0");
while (rs.next()) {
Common_Config.buildOption(rs.getInt("activity_id"), rs.getString("activity_name"), type_id, out);
}
stmt.close();
} catch (Exception exc) {
out.println("<p>ERROR:" + exc.toString() + "</p>");
}
out.println("");
out.println("</select>");
// LOAD ACTIVITIES BY GROUP TYPE
out.println("<select name=group_id onchange=\"load_groups()\">");
if (type_id == 0) {
out.println("<option>CHOOSE TYPE</option>");
} else {
try {
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT activity_id, activity_name FROM activities WHERE parent_id = " + type_id);
rs.last();
if (rs.getRow() == 1) {
group_id = rs.getInt("activity_id");
out.println("<!-- ONLY FOUND 1 GROUP -->");
} else {
out.println("<option value=\"0\">CHOOSE...</option>");
}
rs.beforeFirst();
while (rs.next()) {
Common_Config.buildOption(rs.getInt("activity_id"), rs.getString("activity_name"), group_id, out);
}
stmt.close();
} catch (Exception exc) {
out.println("<p>ERROR:" + exc.toString() + "</p>");
}
}
out.println("");
out.println("</select>");
boolean do_load = false;
if (group_id > 0 ) { //|| sitem_id != null
// LOAD ACTIVITIES BY ITEM TYPE
try {
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT activity_id, activity_name FROM activities WHERE parent_id = " + group_id);
rs.last();
if (rs.getRow() == 0) {
// no sub groups found
do_load = true;
item_id = group_id;
} else if (rs.getRow() == 1) {
// single sub group found (pre select it)
item_id = rs.getInt("activity_id");
out.println("<!-- ONLY FOUND 1 ITEM -->");
} else {
out.println("<select name=item_id onchange=\"load_times(this.options[this.selectedIndex].value)\">");
out.println("<option value=\"0\">CHOOSE...</option>");
}
if (!do_load) {
rs.beforeFirst();
while (rs.next()) {
Common_Config.buildOption(rs.getInt("activity_id"), rs.getString("activity_name"), item_id, out);
}
}
stmt.close();
out.println("");
out.println("</select>");
} catch (Exception exc) {
out.println("<p>ERROR:" + exc.toString() + "</p>");
}
}
out.println("</form>");
out.println("<p><a href=\"Member_genrez\">Reset</a></p>");
try {
con.close();
} catch (Exception ignore) {}
if (do_load) out.println("<script>load_times(" + item_id + ")</script>");
//out.println("<iframe name=ifSheet src=\"\" style=\"width:640px height:480px\"></iframe>");
*/
out.close();
}
/**
* Processes the request coming to the servlet and grabs the attributes set by the servlet and
* uses them to fire off pre-determined methods set in the setupActionMethods function of the
* servlet.
*
* @param request the http request coming from the browser.
* @param response the http response going to the browser.
* @throws javax.servlet.ServletException
* @throws java.io.IOException
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
if (!actionInitialized) {
LogController.write(this, "This dispatcher servlet is not initialized properly!");
return;
}
if (actionTag == null) {
LogController.write(this, "There is no action attribute tag name!");
return;
}
HttpSession httpSession = request.getSession();
UserSession userSession = (UserSession) httpSession.getAttribute("user_session");
if (userSession == null) {
LogController.write(this, "User session is no longer available in this http session.");
userSession = new UserSession();
// We always want a user session though...
httpSession.setAttribute("user_session", userSession);
}
String action = (String) request.getAttribute(actionTag);
try {
if (action == null) {
// There is no action attribute specified, check parameters.
String external_action = (String) request.getParameter(actionTag);
if (external_action != null) {
Method method = externalActions.get(external_action);
if (method != null) {
LogController.write(this, "Performing external action: " + external_action);
method.invoke(this, new Object[] {userSession, request, response});
} else {
if (defaultExternalMethod != null) {
LogController.write(this, "Performing default external action.");
defaultExternalMethod.invoke(this, new Object[] {userSession, request, response});
} else {
LogController.write(this, "Unable to perform default external action.");
}
}
} else {
if (defaultExternalMethod != null) {
LogController.write(this, "Performing default external action.");
defaultExternalMethod.invoke(this, new Object[] {userSession, request, response});
} else {
LogController.write(this, "Unable to perform default external action.");
}
}
} else {
Method method = internalActions.get(action);
if (method != null) {
LogController.write(this, "Performing internal action: " + action);
method.invoke(this, new Object[] {userSession, request, response});
} else {
if (defaultInternalMethod != null) {
LogController.write(this, "Performing default internal action.");
defaultInternalMethod.invoke(this, new Object[] {userSession, request, response});
} else {
LogController.write(this, "Unable to perform default internal action.");
}
}
request.removeAttribute("application_action");
}
} catch (IllegalAccessException accessEx) {
LogController.write(this, "Exception while processing request: " + accessEx.getMessage());
} catch (InvocationTargetException invokeEx) {
LogController.write(this, "Exception while processing request: " + invokeEx.toString());
invokeEx.printStackTrace();
} catch (Exception ex) {
LogController.write(this, "Unknown exception: " + ex.toString());
}
}
@Override
public void serveResource(ResourceRequest portletReq, ResourceResponse portletResp)
throws PortletException, IOException {
LOGGER.entering(LOG_CLASS, "main portlet serveResource entry");
long tid = Thread.currentThread().getId();
portletReq.setAttribute(THREADID_ATTR, tid);
PrintWriter writer = portletResp.getWriter();
JSR286SignatureTestCaseDetails tcd = new JSR286SignatureTestCaseDetails();
// Create result objects for the tests
PortletURL url = portletResp.createActionURL();
ClassChecker cc = new ClassChecker(url.getClass());
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasAddProperty */
/* Details: "Action URL has a addProperty(String, String) method " */
TestResult tr0 =
tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASADDPROPERTY);
try {
String name = "addProperty";
Class<?>[] exceptions = null;
Class<?>[] parms = {String.class, String.class};
tr0.setTcSuccess(cc.hasMethod(name, parms, exceptions));
} catch (Exception e) {
tr0.appendTcDetail(e.toString());
}
tr0.writeTo(writer);
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasAddPropertyReturns */
/* Details: "Action URL method addProperty(String, String) returns */
/* void " */
TestResult tr1 =
tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASADDPROPERTYRETURNS);
try {
String name = "addProperty";
Class<?> retType = void.class;
Class<?>[] parms = {String.class, String.class};
tr1.setTcSuccess(cc.methodHasReturnType(name, retType, parms));
} catch (Exception e) {
tr1.appendTcDetail(e.toString());
}
tr1.writeTo(writer);
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasGetParameterMap */
/* Details: "Action URL has a getParameterMap() method " */
TestResult tr2 =
tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASGETPARAMETERMAP);
try {
String name = "getParameterMap";
Class<?>[] exceptions = null;
Class<?>[] parms = null;
tr2.setTcSuccess(cc.hasMethod(name, parms, exceptions));
} catch (Exception e) {
tr2.appendTcDetail(e.toString());
}
tr2.writeTo(writer);
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasGetParameterMapReturns */
/* Details: "Action URL method getParameterMap() returns */
/* java.util.Map " */
TestResult tr3 =
tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASGETPARAMETERMAPRETURNS);
try {
String name = "getParameterMap";
Class<?> retType = java.util.Map.class;
Class<?>[] parms = null;
tr3.setTcSuccess(cc.methodHasReturnType(name, retType, parms));
} catch (Exception e) {
tr3.appendTcDetail(e.toString());
}
tr3.writeTo(writer);
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasSetParameter */
/* Details: "Action URL has a setParameter(String, String) method " */
TestResult tr4 =
tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASSETPARAMETER);
try {
String name = "setParameter";
Class<?>[] exceptions = null;
Class<?>[] parms = {String.class, String.class};
tr4.setTcSuccess(cc.hasMethod(name, parms, exceptions));
} catch (Exception e) {
tr4.appendTcDetail(e.toString());
}
tr4.writeTo(writer);
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasSetParameterA */
/* Details: "Action URL has a setParameter(String, String[]) method */
/* " */
TestResult tr5 =
tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASSETPARAMETERA);
try {
String name = "setParameter";
Class<?>[] exceptions = null;
Class<?>[] parms = {String.class, String[].class};
tr5.setTcSuccess(cc.hasMethod(name, parms, exceptions));
} catch (Exception e) {
tr5.appendTcDetail(e.toString());
}
tr5.writeTo(writer);
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasSetParameterReturns */
/* Details: "Action URL method setParameter(String, String) returns */
/* void " */
TestResult tr6 =
tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASSETPARAMETERRETURNS);
try {
String name = "setParameter";
Class<?> retType = void.class;
Class<?>[] parms = {String.class, String.class};
tr6.setTcSuccess(cc.methodHasReturnType(name, retType, parms));
} catch (Exception e) {
tr6.appendTcDetail(e.toString());
}
tr6.writeTo(writer);
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasSetParameterReturnsA */
/* Details: "Action URL method setParameter(String, String[]) returns */
/* void " */
TestResult tr7 =
tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASSETPARAMETERRETURNSA);
try {
String name = "setParameter";
Class<?> retType = void.class;
Class<?>[] parms = {String.class, String[].class};
tr7.setTcSuccess(cc.methodHasReturnType(name, retType, parms));
} catch (Exception e) {
tr7.appendTcDetail(e.toString());
}
tr7.writeTo(writer);
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasSetParameters */
/* Details: "Action URL has a setParameters(java.util.Map) method " */
TestResult tr8 =
tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASSETPARAMETERS);
try {
String name = "setParameters";
Class<?>[] exceptions = null;
Class<?>[] parms = {java.util.Map.class};
tr8.setTcSuccess(cc.hasMethod(name, parms, exceptions));
} catch (Exception e) {
tr8.appendTcDetail(e.toString());
}
tr8.writeTo(writer);
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasSetParametersReturns */
/* Details: "Action URL method setParameters(java.util.Map) returns */
/* void " */
TestResult tr9 =
tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASSETPARAMETERSRETURNS);
try {
String name = "setParameters";
Class<?> retType = void.class;
Class<?>[] parms = {java.util.Map.class};
tr9.setTcSuccess(cc.methodHasReturnType(name, retType, parms));
} catch (Exception e) {
tr9.appendTcDetail(e.toString());
}
tr9.writeTo(writer);
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasSetProperty */
/* Details: "Action URL has a setProperty(String, String) method " */
TestResult tr10 =
tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASSETPROPERTY);
try {
String name = "setProperty";
Class<?>[] exceptions = null;
Class<?>[] parms = {String.class, String.class};
tr10.setTcSuccess(cc.hasMethod(name, parms, exceptions));
} catch (Exception e) {
tr10.appendTcDetail(e.toString());
}
tr10.writeTo(writer);
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasSetPropertyReturns */
/* Details: "Action URL method setProperty(String, String) returns */
/* void " */
TestResult tr11 =
tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASSETPROPERTYRETURNS);
try {
String name = "setProperty";
Class<?> retType = void.class;
Class<?>[] parms = {String.class, String.class};
tr11.setTcSuccess(cc.methodHasReturnType(name, retType, parms));
} catch (Exception e) {
tr11.appendTcDetail(e.toString());
}
tr11.writeTo(writer);
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasSetSecure */
/* Details: "Action URL has a setSecure(boolean) throws */
/* PortletSecurityException method " */
TestResult tr12 = tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASSETSECURE);
try {
String name = "setSecure";
Class<?>[] exceptions = {PortletSecurityException.class};
Class<?>[] parms = {boolean.class};
tr12.setTcSuccess(cc.hasMethod(name, parms, exceptions));
} catch (Exception e) {
tr12.appendTcDetail(e.toString());
}
tr12.writeTo(writer);
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasSetSecureReturns */
/* Details: "Action URL method setSecure(boolean) returns void " */
TestResult tr13 =
tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASSETSECURERETURNS);
try {
String name = "setSecure";
Class<?> retType = void.class;
Class<?>[] parms = {boolean.class};
tr13.setTcSuccess(cc.methodHasReturnType(name, retType, parms));
} catch (Exception e) {
tr13.appendTcDetail(e.toString());
}
tr13.writeTo(writer);
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasToString */
/* Details: "Action URL has a toString() method " */
TestResult tr14 = tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASTOSTRING);
try {
String name = "toString";
Class<?>[] exceptions = null;
Class<?>[] parms = null;
tr14.setTcSuccess(cc.hasMethod(name, parms, exceptions));
} catch (Exception e) {
tr14.appendTcDetail(e.toString());
}
tr14.writeTo(writer);
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasToStringReturns */
/* Details: "Action URL method toString() returns String " */
TestResult tr15 =
tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASTOSTRINGRETURNS);
try {
String name = "toString";
Class<?> retType = String.class;
Class<?>[] parms = null;
tr15.setTcSuccess(cc.methodHasReturnType(name, retType, parms));
} catch (Exception e) {
tr15.appendTcDetail(e.toString());
}
tr15.writeTo(writer);
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasWrite */
/* Details: "Action URL has a write(java.io.Writer) throws */
/* java.io.IOException method " */
TestResult tr16 = tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASWRITE);
try {
String name = "write";
Class<?>[] exceptions = {java.io.IOException.class};
Class<?>[] parms = {java.io.Writer.class};
tr16.setTcSuccess(cc.hasMethod(name, parms, exceptions));
} catch (Exception e) {
tr16.appendTcDetail(e.toString());
}
tr16.writeTo(writer);
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasWriteA */
/* Details: "Action URL has a write(java.io.Writer, boolean) throws */
/* java.io.IOException method " */
TestResult tr17 = tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASWRITEA);
try {
String name = "write";
Class<?>[] exceptions = {java.io.IOException.class};
Class<?>[] parms = {java.io.Writer.class, boolean.class};
tr17.setTcSuccess(cc.hasMethod(name, parms, exceptions));
} catch (Exception e) {
tr17.appendTcDetail(e.toString());
}
tr17.writeTo(writer);
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasWriteReturns */
/* Details: "Action URL method write(java.io.Writer) returns void " */
TestResult tr18 =
tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASWRITERETURNS);
try {
String name = "write";
Class<?> retType = void.class;
Class<?>[] parms = {java.io.Writer.class};
tr18.setTcSuccess(cc.methodHasReturnType(name, retType, parms));
} catch (Exception e) {
tr18.appendTcDetail(e.toString());
}
tr18.writeTo(writer);
/* TestCase: V2SigTestsURL_BaseURL_SIGResourceActurl_hasWriteReturnsA */
/* Details: "Action URL method write(java.io.Writer, boolean) returns */
/* void " */
TestResult tr19 =
tcd.getTestResultFailed(V2SIGTESTSURL_BASEURL_SIGRESOURCEACTURL_HASWRITERETURNSA);
try {
String name = "write";
Class<?> retType = void.class;
Class<?>[] parms = {java.io.Writer.class, boolean.class};
tr19.setTcSuccess(cc.methodHasReturnType(name, retType, parms));
} catch (Exception e) {
tr19.appendTcDetail(e.toString());
}
tr19.writeTo(writer);
}
String proceedError(javax.servlet.http.HttpServletResponse response, Exception e) {
return e.toString();
}
// *****************************************************
// Process the request from Member_sheet
// *****************************************************
//
public void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
resp.setContentType("text/html");
PrintWriter out = resp.getWriter();
PreparedStatement pstmt3 = null;
Statement stmt = null;
ResultSet rs = null;
HttpSession session = SystemUtils.verifyMem(req, out); // check for intruder
if (session == null) {
return;
}
Connection con = SystemUtils.getCon(session); // get DB connection
if (con == null) {
out.println(SystemUtils.HeadTitle("DB Connection Error"));
out.println(
"<BODY bgcolor=\"#ccccaa\"><CENTER><img src=\"/" + rev + "/images/foretees.gif\"><BR>");
out.println("<hr width=\"40%\">");
out.println("<BR><BR><H3>Database Connection Error</H3>");
out.println("<BR><BR>Unable to connect to the Database.");
out.println("<BR>Please try again later.");
out.println("<BR><BR>If problem persists, please contact customer support.");
out.println("<BR><BR>");
out.println("<font size=\"2\">");
out.println("<form method=\"get\" action=\"javascript:history.back(1)\">");
out.println("<input type=\"submit\" value=\"Return\" style=\"text-decoration:underline;\">");
out.println("</form></font>");
out.println("</CENTER></BODY></HTML>");
out.close();
return;
}
// Create Json response for later use
Gson gson_obj = new Gson();
// HashMap for later use by gson
Map<String, Object> hashMap = new HashMap<String, Object>();
// Check if we will only be return json data
boolean json_mode = (req.getParameter("jsonMode")) != null;
//
// See if we are here to VIEW a wait list
//
if (req.getParameter("view") != null && req.getParameter("waitListId") != null) {
if (json_mode) {
out.print(gson_obj.toJson(viewSignups(req, out, con, true)));
} else {
viewSignups(req, out, con);
}
return;
}
String jump = "0"; // jump index - default to zero (for _sheet)
if (req.getParameter("jump") != null) { // if jump index provided
jump = req.getParameter("jump");
}
//
// Get this session's username
//
String club = (String) session.getAttribute("club");
String user = (String) session.getAttribute("user");
String name = (String) session.getAttribute("name"); // get users full name
String sindex =
req.getParameter("index"); // index value of day (needed by Member_sheet when returning)
String course = req.getParameter("course"); // Name of Course
String id = req.getParameter("waitListId"); // uid of the wait list we are working with
String returnCourse = "";
if (req.getParameter("returnCourse") != null) { // if returnCourse provided
returnCourse = req.getParameter("returnCourse");
}
String sdate = req.getParameter("date"); // date of the request (yyyymmdd)
String day_name = req.getParameter("day"); // name of the day
String p5 = req.getParameter("p5"); // 5-somes supported
int index = 0;
int wait_list_id = 0;
int count = 0;
int mm = 0;
int dd = 0;
int yy = 0;
int date = 0;
int time = SystemUtils.getTime(con);
//
// Convert the values from string to int
//
try {
wait_list_id = Integer.parseInt(id);
index = Integer.parseInt(sindex);
date = Integer.parseInt(sdate);
} catch (NumberFormatException e) {
}
// get our date parts
yy = date / 10000;
mm = date - (yy * 10000);
dd = mm - (mm / 100) * 100;
mm = mm / 100;
//
// parm block to hold the wait list parameters
//
parmWaitList parmWL = new parmWaitList(); // allocate a parm block
parmWL.wait_list_id = wait_list_id;
try {
getWaitList.getParms(con, parmWL); // get the wait list config
// if members can see the wait list then get the count
if (parmWL.member_view == 1) {
count = getWaitList.getListCount(wait_list_id, date, index, time, true, con);
}
} catch (Exception exp) {
out.println(exp.getMessage());
}
int onlist = 0;
try {
onlist = getWaitList.onList(user, wait_list_id, date, con);
} catch (Exception exp) {
out.println(exp.toString());
}
String waitlist_notice = "";
if (onlist == 0) {
// not on the list
try {
// out.println("<pre>");
waitlist_notice = getWaitList.getNotice(wait_list_id, con);
// out.println("</pre>");
} catch (Exception exp) {
}
}
if (json_mode) {
// If in json mode, add data to hashmap
// New skin uses Member_waitlist in json mode exclusively.
// Group the data we want to send to javascript in a hash map
hashMap.put("wait_list_id", wait_list_id);
hashMap.put("waitlist_notice", waitlist_notice);
hashMap.put("date", "" + mm + "/" + dd + "/" + yy);
hashMap.put("start_time", SystemUtils.getSimpleTime(parmWL.start_time));
hashMap.put("end_time", SystemUtils.getSimpleTime(parmWL.end_time));
hashMap.put("member_access", parmWL.member_access);
hashMap.put("member_view", parmWL.member_view);
hashMap.put("onlist", onlist);
hashMap.put("index", index);
hashMap.put("course", course);
hashMap.put("count", count);
hashMap.put("name", parmWL.name);
out.print(gson_obj.toJson(hashMap));
return;
} else {
// If not in json mode, output data directly to user
out.println(
"<!-- wait_list_id=" + wait_list_id + ", date=" + date + ", count=" + count + " -->");
//
// ********************************************************************
// Build a page to display Wait List details to member
// ********************************************************************
//
out.println("<html>");
out.println("<head>");
out.println(
"<link rel=\"stylesheet\" href=\"/"
+ rev
+ "/web utilities/foretees2.css\" type=\"text/css\">");
out.println("<title>Member Wait List Registration Page</title>");
out.println("</head>");
out.println(
"<body bgcolor=\"#ccccaa\" text=\"#000000\" link=\"#FFFFFF\" vlink=\"#FFFFFF\" alink=\"#FF0000\" topmargin=\"0\">");
out.println("<font face=\"Arial, Helvetica, Sans-serif\"><center>");
out.println(
"<table border=\"0\" width=\"100%\" align=\"center\" valign=\"top\">"); // large table for
// whole page
out.println("<tr><td valign=\"top\" align=\"center\">");
out.println(
"<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#336633\" align=\"center\" valign=\"top\">");
out.println("<tr><td align=\"left\" width=\"300\"> ");
out.println("<img src=\"/" + rev + "/images/foretees.gif\" border=0>");
out.println("</td>");
out.println("<td align=\"center\">");
out.println("<font color=\"ffffff\" size=\"5\">Member Wait List Registration</font>");
out.println("</font></td>");
out.println("<td align=\"center\" width=\"300\">");
out.println("<font size=\"1\" color=\"#ffffff\">Copyright </font>");
out.println("<font size=\"2\" color=\"#ffffff\">© </font>");
out.println(
"<font size=\"1\" color=\"#ffffff\">ForeTees, LLC <br> 2009 All rights reserved.");
out.println("</font><font size=\"3\">");
out.println(
"<br><br><a href=\"/" + rev + "/member_help.htm\" target=\"_blank\"><b>Help</b></a>");
out.println("</font></td>");
out.println("</tr></table>");
out.println("<br>");
out.println("<table border=\"1\" cols=\"1\" bgcolor=\"#f5f5dc\" cellpadding=\"3\">");
out.println("<tr>");
out.println("<td width=\"620\" align=\"center\">");
out.println("<font size=\"3\">");
out.println("<b>Wait List Registration</b><br></font>");
out.println("<font size=\"2\">");
out.println(
"The golf shop is running a wait list "
+ ((index == 0) ? "today" : "on this day")
+ ". ");
out.println(
"The wait list you've selected is running from <nobr>"
+ SystemUtils.getSimpleTime(parmWL.start_time)
+ "</nobr> till <nobr>"
+ SystemUtils.getSimpleTime(parmWL.end_time)
+ ".</nobr> ");
out.println("Review the information below and click on 'Continue With Request' to continue.");
out.println(
"<br>OR click on 'Cancel Request' to delete the request. To return without changes click on 'Go Back'.");
// out.println("<br><br><b>NOTE:</b> Only the person that originates the request will be
// allowed to cancel it or change these values.");
out.println("</font></td></tr>");
out.println("</table>");
out.println("<br><br>");
out.println("<table border=0>");
out.println("<tr><td><font size=\"2\">");
out.println(
"Date: <b>"
+ day_name
+ " "
+ mm
+ "/"
+ dd
+ "/"
+ yy
+ "</b></td>");
out.println("<td> </td><td>");
if (!course.equals("")) {
out.println("<font size=\"2\">Course: <b>" + course + "</b></font>");
}
out.println("</td></tr>");
out.println(
"<tr><td><font size=\"2\">Wait List: <b>"
+ SystemUtils.getSimpleTime(parmWL.start_time)
+ " to "
+ SystemUtils.getSimpleTime(parmWL.end_time)
+ "</b></font></td>");
out.println("<td></td>");
out.println("<td><font size=\"2\">Signups:<b>");
out.print(((parmWL.member_view == 1) ? count : "N/A"));
out.println("</b></font></td>");
out.println("</table>");
out.println("<br>");
out.println("<table border=\"0\" align=\"center\">"); // table to contain 2 tables below
out.println("<tr>");
out.println("<td align=\"center\" valign=\"top\">");
out.println(
"<table border=\"1\" bgcolor=\"#f5f5dc\" align=\"center\" width=\"500\" cellpadding=\"5\" cellspacing=\"5\">"); // table for request details
out.println("<tr bgcolor=\"#336633\"><td align=\"center\">");
out.println("<font color=\"ffffff\" size=\"3\">");
out.println(
"<b>" + ((!parmWL.name.equals("")) ? parmWL.name : "Wait List Information") + "</b>");
out.println("</font></td></tr>");
out.println("<tr>");
out.println("<form action=\"Member_waitlist_slot\" method=\"post\">");
out.println("<input type=\"hidden\" name=\"waitListId\" value=\"" + wait_list_id + "\">");
out.println("<input type=\"hidden\" name=\"sdate\" value=\"" + date + "\">");
out.println("<input type=\"hidden\" name=\"day\" value=\"" + day_name + "\">");
out.println("<input type=\"hidden\" name=\"index\" value=\"" + sindex + "\">");
out.println("<input type=\"hidden\" name=\"course\" value=\"" + course + "\">");
out.println("<input type=\"hidden\" name=\"returnCourse\" value=\"" + returnCourse + "\">");
out.println("<input type=\"hidden\" name=\"jump\" value=\"" + jump + "\">");
out.println("<td><font size=\"2\"><br>");
// see if they are already on the wait list
out.println("<input type=\"hidden\" name=\"signupId\" value=\"" + onlist + "\">");
if (onlist == 0) {
// not on the list
// out.println("The golf shop is running a wait list " + ((index == 0) ? "today": "on this
// day") + ". ");
// out.println("The wait list you've selected is running from " +
// SystemUtils.getSimpleTime(parmWL.start_time) + " till " +
// SystemUtils.getSimpleTime(parmWL.end_time) + ". ");
// try {
// out.println("<pre>");
// out.print(getWaitList.getNotice(wait_list_id, con));
// out.println("</pre>");
out.print(waitlist_notice);
// } catch (Exception exp) { }
if (parmWL.member_access == 1) {
out.println(
"<br><p align=center><input type=submit value=\"Continue With Sign-up\" name=\"continue\"></p>");
} else {
out.println("<p align=center><b>Contact the golf shop to get on the wait list.</b></p>");
}
} else {
// already on this list
out.println(
"<p align=center><b><i>You are already signed up for this wait list.</b></i></p>");
if (parmWL.member_access == 1) {
out.println(
"<br><p align=center><input type=submit value=\"Modify Your Sign-up\" name=\"continue\"></p>");
} else {
out.println(
"<p align=center><b>Contact the golf shop to make changes or cancel your entry.</b></p>");
}
}
if (parmWL.member_view == 1 && count > 0) {
out.println(
"<p align=center><input type=button value=\"View Wait List\" name=\"view\" onclick=\"document.forms['frmView'].submit();\"></p>");
}
out.println("<br></font></td>");
out.println("</table>");
out.println("</form>");
out.println("<br>");
if (index == 999) {
// out.println("<form action=\"Member_teelist\" method=\"GET\">");
out.println("<form action=\"/" + rev + "/member_teemain.htm\" method=\"GET\">");
} else if (index == 995) {
// out.println("<form action=\"Member_teelist_list\" method=\"GET\">");
out.println("<form action=\"/" + rev + "/member_teemain2.htm\" method=\"GET\">");
} else {
out.println("<form action=\"Member_jump\" method=\"POST\">");
out.println("<input type=\"hidden\" name=\"jump\" value=" + jump + ">");
out.println("<input type=\"hidden\" name=\"index\" value=" + index + ">");
out.println(
"<input type=\"hidden\" name=\"course\" value=\""
+ ((!returnCourse.equals("")) ? returnCourse : course)
+ "\">");
}
out.println("<font size=2>Return w/o Changes:</font><br>");
out.println("<input type=\"submit\" value=\"Go Back\" name=\"cancel\"></form>");
out.println("<form action=\"Member_waitlist\" method=\"GET\" name=frmView>");
out.println("<input type=\"hidden\" name=\"view\" value=\"current\">");
out.println("<input type=\"hidden\" name=\"waitListId\" value=\"" + wait_list_id + "\">");
out.println("<input type=\"hidden\" name=\"sdate\" value=\"" + date + "\">");
out.println("<input type=\"hidden\" name=\"name\" value=\"" + parmWL.name + "\">");
// out.println("<input type=\"hidden\" name=\"day\" value=\"" + day_name + "\">");
out.println("<input type=\"hidden\" name=\"index\" value=\"" + sindex + "\">");
out.println("<input type=\"hidden\" name=\"course\" value=\"" + parmWL.course + "\">");
out.println("<input type=\"hidden\" name=\"returnCourse\" value=\"" + returnCourse + "\">");
out.println("<input type=\"hidden\" name=\"jump\" value=\"" + jump + "\">");
;
out.println(
"<input type=\"hidden\" name=\"start_time\" value=\"" + parmWL.start_time + "\">");
out.println("<input type=\"hidden\" name=\"end_time\" value=\"" + parmWL.end_time + "\">");
out.println("<input type=\"hidden\" name=\"day_name\" value=\"" + day_name + "\">");
// out.println("<input type=submit value=\"View Sign-ups\" name=\"view\">");
out.println("</form>");
} // end json check
} // end doPost
public void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
resp.setContentType("text/html");
PrintWriter out = resp.getWriter();
String support = "support"; // valid username
HttpSession session = null;
session = req.getSession(false); // Get user's session object (no new one)
if (session == null) {
invalidUser(out); // Intruder - reject
return;
}
String userName = (String) session.getAttribute("user"); // get username
if (!userName.equals(support)) {
invalidUser(out); // Intruder - reject
return;
}
Connection con1 = null; // init DB objects
Connection con2 = null;
Statement stmt1 = null;
Statement stmt2 = null;
ResultSet rs1 = null;
ResultSet rs2 = null;
out.println("<HTML><HEAD><TITLE>Database Query</TITLE></HEAD>");
out.println("<BODY><H3>List Each Club With a Custom Style Sheet</H3>");
out.println(
"<table border=1><tr><td><b>Site</b></td><td><b>Club Name</b></td><td><b>Style Sheet</b></td></tr>");
out.flush();
String club = "";
String fullname = "";
String styles = "";
try {
con1 = Connect.getCon(rev); // connect to v5
} catch (Exception exc) {
// Error connecting to db....
out.println("<BR><BR>Unable to connect to the DB.");
out.println("<BR>Exception: " + exc.getMessage());
out.println("<BR><BR> <A HREF=\"/v5/servlet/Support_main\">Return</A>.");
out.println("</BODY></HTML>");
return;
}
//
// Get the club names from the 'clubs' table
//
// Process each club in the table
//
try {
stmt1 = con1.createStatement();
rs1 =
stmt1.executeQuery(
"SELECT clubname, fullname FROM v5.clubs WHERE inactive=0 ORDER BY clubname");
while (rs1.next()) {
club = rs1.getString(1); // get a club name
fullname = rs1.getString(2); // get club's full name
if (!club.startsWith("demo")) { // if NOT a demo site
con2 = Connect.getCon(club); // get a connection to this club's db
stmt2 = con2.createStatement(); // create a statement
try {
rs2 = stmt2.executeQuery("SELECT custom_styles FROM club5");
if (rs2.next()) {
styles = rs2.getString("custom_styles"); // get the custom styles name, if any
if (!styles.equals("")) {
out.println(
"<tr><td>"
+ club
+ "</td><td>"
+ fullname
+ "</td><td>"
+ styles
+ "</td></tr>");
}
}
} catch (Exception exc) {
out.println(club + " failed!!!!!!!!!!!!!!!!!!!! " + exc.toString());
}
stmt2.close();
con2.close();
}
} // end if WHILE clubs
out.println("</table>");
} catch (Exception exc) {
// Error connecting to db....
out.println("<BR><BR>Unable to connect to the DB.");
out.println("<BR>Exception: " + exc.getMessage());
out.println("<BR><BR> <A HREF=\"/v5/servlet/Support_main\">Return</A>.");
out.println("</BODY></HTML>");
return;
}
try {
stmt1.close();
con1.close();
} catch (Exception ignore) {
}
out.println("<BR><BR> <A HREF=\"/v5/servlet/Support_main\">Return</A>.");
out.println("</BODY></HTML>");
out.close();
}
/**
* this is the main method of the servlet that will service all get requests.
*
* @param request HttpServletRequest
* @param responce HttpServletResponce
*/
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
try {
res.setContentType("text/html");
ServletOutputStream out = res.getOutputStream();
hitCount++;
long totalMemory = Runtime.getRuntime().totalMemory();
long maxMemoryBeforeGC = Runtime.getRuntime().maxMemory();
long freeMemoryBeforeGC = Runtime.getRuntime().freeMemory();
long startTime = System.currentTimeMillis();
System.gc(); // Invoke the GC.
long endTime = System.currentTimeMillis();
long maxMemoryAfterGC = Runtime.getRuntime().maxMemory();
long freeMemoryAfterGC = Runtime.getRuntime().freeMemory();
out.println(
"<html><head><title>ExplicitGC</title></head>"
+ "<body><HR><BR><FONT size=\"+2\" color=\"#000066\">Explicit Garbage Collection<BR></FONT><FONT size=\"+1\" color=\"#000066\">Init time : "
+ initTime
+ "<BR><BR></FONT> <B>Hit Count: "
+ hitCount
+ "<br>"
+ "<table border=\"0\"><tr>"
+ "<td align=\"right\">Total Memory</td><td align=\"right\">"
+ totalMemory
+ "</td>"
+ "</tr></table>"
+ "<table width=\"350\"><tr><td colspan=\"2\" align=\"left\">"
+ "Statistics before GC</td></tr>"
+ "<tr><td align=\"right\">"
+ "Max Memory</td><td align=\"right\">"
+ maxMemoryBeforeGC
+ "</td></tr>"
+ "<tr><td align=\"right\">"
+ "Free Memory</td><td align=\"right\">"
+ freeMemoryBeforeGC
+ "</td></tr>"
+ "<tr><td align=\"right\">"
+ "Used Memory</td><td align=\"right\">"
+ (totalMemory - freeMemoryBeforeGC)
+ "</td></tr>"
+ "<tr><td colspan=\"2\" align=\"left\">Statistics after GC</td></tr>"
+ "<tr><td align=\"right\">"
+ "Max Memory</td><td align=\"right\">"
+ maxMemoryAfterGC
+ "</td></tr>"
+ "<tr><td align=\"right\">"
+ "Free Memory</td><td align=\"right\">"
+ freeMemoryAfterGC
+ "</td></tr>"
+ "<tr><td align=\"right\">"
+ "Used Memory</td><td align=\"right\">"
+ (totalMemory - freeMemoryAfterGC)
+ "</td></tr>"
+ "<tr><td align=\"right\">"
+ "Total Time in GC</td><td align=\"right\">"
+ Float.toString((endTime - startTime) / 1000)
+ "s</td></tr>"
+ "</table>"
+ "</body></html>");
} catch (Exception e) {
Log.error(e, "ExplicitGC.doGet(...): general exception caught");
res.sendError(500, e.toString());
}
}
void editorials_Show(
javax.servlet.http.HttpServletRequest request,
javax.servlet.http.HttpServletResponse response,
javax.servlet.http.HttpSession session,
javax.servlet.jsp.JspWriter out,
String seditorialsErr,
String sForm,
String sAction,
java.sql.Connection conn,
java.sql.Statement stat)
throws java.io.IOException {
String sWhere = "";
int iCounter = 0;
int iPage = 0;
boolean bIsScroll = true;
boolean hasParam = false;
String sOrder = "";
String sSQL = "";
String transitParams = "";
String sQueryString = "";
String sPage = "";
int RecordsPerPage = 20;
String sSortParams = "";
String formParams = "";
// Build WHERE statement
// Build ORDER statement
sOrder = " order by e.article_title Asc";
String sSort = getParam(request, "Formeditorials_Sorting");
String sSorted = getParam(request, "Formeditorials_Sorted");
String sDirection = "";
String sForm_Sorting = "";
int iSort = 0;
try {
iSort = SymString.parseInt(sSort);
} catch (NumberFormatException e) {
sSort = "";
}
if (iSort == 0) {
sForm_Sorting = "";
} else {
if (sSort.equals(sSorted)) {
sSorted = "0";
sForm_Sorting = "";
sDirection = " DESC";
sSortParams = "Formeditorials_Sorting=" + sSort + "&Formeditorials_Sorted=" + sSort + "&";
} else {
sSorted = sSort;
sForm_Sorting = sSort;
sDirection = " ASC";
sSortParams = "Formeditorials_Sorting=" + sSort + "&Formeditorials_Sorted=" + "&";
}
if (iSort == 1) {
sOrder = " order by e.article_title" + sDirection;
}
if (iSort == 2) {
sOrder = " order by e1.editorial_cat_name" + sDirection;
}
if (iSort == 3) {
sOrder = " order by i.name" + sDirection;
}
}
// Build full SQL statement
sSQL =
"select e.article_id as e_article_id, "
+ "e.article_title as e_article_title, "
+ "e.editorial_cat_id as e_editorial_cat_id, "
+ "e.item_id as e_item_id, "
+ "e1.editorial_cat_id as e1_editorial_cat_id, "
+ "e1.editorial_cat_name as e1_editorial_cat_name, "
+ "i.item_id as i_item_id, "
+ "i.name as i_name "
+ " from editorials e, editorial_categories e1, items i"
+ " where e1.editorial_cat_id=e.editorial_cat_id and i.item_id=e.item_id ";
sSQL = sSQL + sWhere + sOrder;
String sNoRecords =
" <tr>\n <td colspan=\"3\" style=\"background-color: #FFFFFF; border-width: 1\"><font style=\"font-size: 10pt; color: #000000\">No records</font></td>\n </tr>";
String tableHeader = "";
tableHeader =
" <tr>\n <td style=\"background-color: #FFFFFF; border-style: inset; border-width: 0\"><a href=\""
+ sFileName
+ "?"
+ formParams
+ "Formeditorials_Sorting=1&Formeditorials_Sorted="
+ sSorted
+ "&\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">Title</font></a></td>\n <td style=\"background-color: #FFFFFF; border-style: inset; border-width: 0\"><a href=\""
+ sFileName
+ "?"
+ formParams
+ "Formeditorials_Sorting=2&Formeditorials_Sorted="
+ sSorted
+ "&\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">Editorial Category</font></a></td>\n <td style=\"background-color: #FFFFFF; border-style: inset; border-width: 0\"><a href=\""
+ sFileName
+ "?"
+ formParams
+ "Formeditorials_Sorting=3&Formeditorials_Sorted="
+ sSorted
+ "&\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">Item</font></a></td>\n </tr>";
try {
out.println(" <table style=\"\">");
out.println(
" <tr>\n <td style=\"background-color: #336699; text-align: Center; border-style: outset; border-width: 1\" colspan=\"3\"><a name=\"editorials\"><font style=\"font-size: 12pt; color: #FFFFFF; font-weight: bold\">Editorials</font></a></td>\n </tr>");
out.println(tableHeader);
} catch (Exception e) {
}
try {
// Select current page
iPage = SymString.parseInt(getParam(request, "Formeditorials_Page"));
} catch (NumberFormatException e) {
iPage = 0;
}
if (iPage == 0) {
iPage = 1;
}
RecordsPerPage = 20;
try {
java.sql.ResultSet rs = null;
// Open recordset
rs = openrs(stat, sSQL);
iCounter = 0;
absolute(rs, (iPage - 1) * RecordsPerPage + 1);
java.util.Hashtable rsHash = new java.util.Hashtable();
String[] aFields = getFieldsName(rs);
// Show main table based on recordset
while ((iCounter < RecordsPerPage) && rs.next()) {
getRecordToHash(rs, rsHash, aFields);
String fldarticle_id = (String) rsHash.get("e_article_id");
String fldarticle_title = (String) rsHash.get("e_article_title");
String fldeditorial_cat_id = (String) rsHash.get("e1_editorial_cat_name");
String flditem_id = (String) rsHash.get("i_name");
out.println(" <tr>");
out.print(" <td style=\"background-color: #FFFFFF; border-width: 1\">");
out.print(
"<a href=\"EditorialsRecord.jsp?"
+ transitParams
+ "article_id="
+ toURL((String) rsHash.get("e_article_id"))
+ "&\"><font style=\"font-size: 10pt; color: #000000\">"
+ toHTML(fldarticle_title)
+ "</font></a>");
out.println("</td>");
out.print(" <td style=\"background-color: #FFFFFF; border-width: 1\">");
out.print(
"<font style=\"font-size: 10pt; color: #000000\">"
+ toHTML(fldeditorial_cat_id)
+ " </font>");
out.println("</td>");
out.print(" <td style=\"background-color: #FFFFFF; border-width: 1\">");
out.print(
"<font style=\"font-size: 10pt; color: #000000\">"
+ toHTML(flditem_id)
+ " </font>");
out.println("</td>");
out.println(" </tr>");
iCounter++;
}
if (iCounter == 0) {
// Recordset is empty
out.println(sNoRecords);
out.print(
" <tr>\n <td colspan=\"3\" style=\"background-color: #FFFFFF; border-style: inset; border-width: 0\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">");
out.print(
"<a href=\"EditorialsRecord.jsp?"
+ formParams
+ "\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">Insert</font></a> ");
out.println("</td>\n </tr>");
iCounter = RecordsPerPage + 1;
bIsScroll = false;
} else {
// Parse scroller
boolean bInsert = false;
boolean bNext = rs.next();
if (!bNext && iPage == 1) {
out.print(
" <tr>\n <td colspan=\"3\" style=\"background-color: #FFFFFF; border-style: inset; border-width: 0\">\n <font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">");
out.print(
"\n <a href=\"EditorialsRecord.jsp?"
+ formParams
+ "\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">Insert</font></a> ");
out.println("\n </td>\n </tr>");
} else {
out.print(
" <tr>\n <td colspan=\"3\" style=\"background-color: #FFFFFF; border-style: inset; border-width: 0\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">");
out.print(
"\n <a href=\"EditorialsRecord.jsp?"
+ formParams
+ "\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">Insert</font></a> ");
bInsert = true;
if (iPage == 1) {
out.print(
"\n <a href_=\"#\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">Previous</font></a>");
} else {
out.print(
"\n <a href=\""
+ sFileName
+ "?"
+ formParams
+ sSortParams
+ "Formeditorials_Page="
+ (iPage - 1)
+ "#Form\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">Previous</font></a>");
}
out.print("\n [ " + iPage + " ]");
if (!bNext) {
out.print(
"\n <a href_=\"#\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">Next</font></a><br>");
} else {
out.print(
"\n <a href=\""
+ sFileName
+ "?"
+ formParams
+ sSortParams
+ "Formeditorials_Page="
+ (iPage + 1)
+ "#Form\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">Next</font></a><br>");
}
if (!bInsert) {
out.print(
" <tr>\n <td colspan=\"3\" style=\"background-color: #FFFFFF; border-style: inset; border-width: 0\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">");
out.print(
"\n <a href=\"EditorialsRecord.jsp?"
+ formParams
+ "\"><font style=\"font-size: 10pt; color: #CE7E00; font-weight: bold\">Insert</font></a> ");
}
out.println("</td>\n </tr>");
}
}
if (rs != null) rs.close();
out.println(" </table>");
} catch (Exception e) {
out.println(e.toString());
}
}
private void doUpdate(PrintWriter out) {
Connection con1 = null; // init DB objects
Connection con2 = null;
PreparedStatement pstmt = null;
Statement stmt1 = null;
Statement stmt1a = null;
Statement stmt2 = null;
Statement stmt3 = null;
ResultSet rs1 = null;
ResultSet rs2 = null;
ResultSet rs3 = null;
out.println("<HTML><HEAD><TITLE>Database Query</TITLE></HEAD>");
out.println("<BODY><H3>Starting Job to Check for Clubster Users</H3>");
out.flush();
String club = "";
String name = "";
try {
con1 = dbConn.Connect(rev);
} catch (Exception exc) {
// Error connecting to db....
out.println("<BR><BR>Unable to connect to the DB.");
out.println("<BR>Exception: " + exc.getMessage());
out.println("<BR><BR> <A HREF=\"/v5/servlet/Support_main\">Return</A>.");
out.println("</BODY></HTML>");
return;
}
//
// Get the club names from the 'clubs' table
//
// Process each club in the table
//
int x1 = 0;
int x2 = 0;
int i = 0;
boolean skip = true;
try {
stmt1 = con1.createStatement();
rs1 = stmt1.executeQuery("SELECT clubname, fullname FROM clubs ORDER BY clubname");
while (rs1.next()) {
x1++;
club = rs1.getString(1); // get a club name
name = rs1.getString(2); // get full club name
con2 = dbConn.Connect(club); // get a connection to this club's db
stmt2 = con2.createStatement();
rs2 = stmt2.executeQuery("SELECT date FROM sessionlog WHERE msg LIKE '%clubster'");
if (rs2.next()) {
out.println("<br><br>");
out.print("Club found: " + club + ", " + name);
}
stmt2.close();
con2.close();
}
stmt1.close();
con1.close();
} catch (Exception e) {
// Error connecting to db....
out.println("<BR><BR><H3>Fatal Error!</H3>");
out.println("Error performing update to club '" + club + "'.");
out.println("<BR>Exception: " + e.getMessage());
out.println("<BR>Message: " + e.toString());
out.println("<BR><BR> <A HREF=\"/v5/servlet/Support_main\">Return</A>.");
out.println("</BODY></HTML>");
out.close();
Connect.close(stmt2, con2);
Connect.close(stmt1, con1);
return;
}
Connect.close(stmt2, con2);
Connect.close(stmt1, con1);
out.print("<BR><BR>Done, " + x1 + "clubs checked.");
out.println("<BR><BR> <A HREF=\"/v5/servlet/Support_main\">Return</A>");
out.println("</CENTER></BODY></HTML>");
// out.flush();
// out.close();
}
public void doProcess(HttpServletRequest req, HttpServletResponse res, boolean isPost) {
StringBuffer bodyContent = null;
OutputStream out = null;
PrintWriter writer = null;
String serviceKey = null;
try {
BufferedReader in = req.getReader();
String line = null;
while ((line = in.readLine()) != null) {
if (bodyContent == null) bodyContent = new StringBuffer();
bodyContent.append(line);
}
} catch (Exception e) {
}
try {
if (requireSession) {
// check to see if there was a session created for this request
// if not assume it was from another domain and blow up
// Wrap this to prevent Portlet exeptions
HttpSession session = req.getSession(false);
if (session == null) {
res.setStatus(HttpServletResponse.SC_FORBIDDEN);
return;
}
}
serviceKey = req.getParameter("id");
// only to preven regressions - Remove before 1.0
if (serviceKey == null) serviceKey = req.getParameter("key");
// check if the services have been loaded or if they need to be reloaded
if (services == null || configUpdated()) {
getServices(res);
}
String urlString = null;
String xslURLString = null;
String userName = null;
String password = null;
String format = "json";
String callback = req.getParameter("callback");
String urlParams = req.getParameter("urlparams");
String countString = req.getParameter("count");
// encode the url to prevent spaces from being passed along
if (urlParams != null) {
urlParams = urlParams.replace(' ', '+');
}
try {
if (services.has(serviceKey)) {
JSONObject service = services.getJSONObject(serviceKey);
// default to the service default if no url parameters are specified
if (urlParams == null && service.has("defaultURLParams")) {
urlParams = service.getString("defaultURLParams");
}
String serviceURL = service.getString("url");
// build the URL
if (urlParams != null && serviceURL.indexOf("?") == -1) {
serviceURL += "?";
} else if (urlParams != null) {
serviceURL += "&";
}
String apikey = "";
if (service.has("username")) userName = service.getString("username");
if (service.has("password")) password = service.getString("password");
if (service.has("apikey")) apikey = service.getString("apikey");
urlString = serviceURL + apikey;
if (urlParams != null) urlString += "&" + urlParams;
if (service.has("xslStyleSheet")) {
xslURLString = service.getString("xslStyleSheet");
}
}
// code for passing the url directly through instead of using configuration file
else if (req.getParameter("url") != null) {
String serviceURL = req.getParameter("url");
// build the URL
if (urlParams != null && serviceURL.indexOf("?") == -1) {
serviceURL += "?";
} else if (urlParams != null) {
serviceURL += "&";
}
urlString = serviceURL;
if (urlParams != null) urlString += urlParams;
} else {
writer = res.getWriter();
if (serviceKey == null)
writer.write("XmlHttpProxyServlet Error: id parameter specifying serivce required.");
else
writer.write(
"XmlHttpProxyServlet Error : service for id '" + serviceKey + "' not found.");
writer.flush();
return;
}
} catch (Exception ex) {
getLogger().severe("XmlHttpProxyServlet Error loading service: " + ex);
}
Map paramsMap = new HashMap();
paramsMap.put("format", format);
// do not allow for xdomain unless the context level setting is enabled.
if (callback != null && allowXDomain) {
paramsMap.put("callback", callback);
}
if (countString != null) {
paramsMap.put("count", countString);
}
InputStream xslInputStream = null;
if (urlString == null) {
writer = res.getWriter();
writer.write(
"XmlHttpProxyServlet parameters: id[Required] urlparams[Optional] format[Optional] callback[Optional]");
writer.flush();
return;
}
// default to JSON
res.setContentType(responseContentType);
out = res.getOutputStream();
// get the stream for the xsl stylesheet
if (xslURLString != null) {
// check the web root for the resource
URL xslURL = null;
xslURL = ctx.getResource(resourcesDir + "xsl/" + xslURLString);
// if not in the web root check the classpath
if (xslURL == null) {
xslURL =
XmlHttpProxyServlet.class.getResource(classpathResourcesDir + "xsl/" + xslURLString);
}
if (xslURL != null) {
xslInputStream = xslURL.openStream();
} else {
String message =
"Could not locate the XSL stylesheet provided for service id "
+ serviceKey
+ ". Please check the XMLHttpProxy configuration.";
getLogger().severe(message);
try {
out.write(message.getBytes());
out.flush();
return;
} catch (java.io.IOException iox) {
}
}
}
if (!isPost) {
xhp.doGet(urlString, out, xslInputStream, paramsMap, userName, password);
} else {
if (bodyContent == null)
getLogger()
.info(
"XmlHttpProxyServlet attempting to post to url "
+ urlString
+ " with no body content");
xhp.doPost(
urlString,
out,
xslInputStream,
paramsMap,
bodyContent.toString(),
req.getContentType(),
userName,
password);
}
} catch (Exception iox) {
iox.printStackTrace();
getLogger().severe("XmlHttpProxyServlet: caught " + iox);
try {
writer = res.getWriter();
writer.write(iox.toString());
writer.flush();
} catch (java.io.IOException ix) {
ix.printStackTrace();
}
return;
} finally {
try {
if (out != null) out.close();
if (writer != null) writer.close();
} catch (java.io.IOException iox) {
}
}
}
// New -- returns data in HashMap
private static Map viewSignups(
HttpServletRequest req, PrintWriter out, Connection con, boolean json_mode) {
int wait_list_id = 0;
int wait_list_signup_id = 0;
int sum_players = 0;
int date = 0;
int pos = 1;
int time = SystemUtils.getTime(con);
int today_date = (int) SystemUtils.getDate(con);
int start_time = 0;
int end_time = 0;
int count = 0;
int index = 0;
int player_index = 0;
Map waitlist_map = new HashMap();
waitlist_map.put("options", new HashMap());
waitlist_map.put("signups", new LinkedHashMap());
String sindex =
req.getParameter(
"index"); // index value of day (needed by Proshop_waitlist_slot when returning)
String id = req.getParameter("waitListId"); // uid of the wait list we are working with
String course = (req.getParameter("course") == null) ? "" : req.getParameter("course");
String returnCourse =
(req.getParameter("returnCourse") == null) ? "" : req.getParameter("returnCourse");
String sdate = (req.getParameter("sdate") == null) ? "" : req.getParameter("sdate");
String name = (req.getParameter("name") == null) ? "" : req.getParameter("name");
String day_name = (req.getParameter("day_name") == null) ? "" : req.getParameter("day_name");
String sstart_time =
(req.getParameter("start_time") == null) ? "" : req.getParameter("start_time");
String send_time = (req.getParameter("end_time") == null) ? "" : req.getParameter("end_time");
// String count = (req.getParameter("count") == null) ? "" : req.getParameter("count");
String jump = req.getParameter("jump");
String fullName = "";
String cw = "";
String notes = "";
String nineHole = "";
PreparedStatement pstmt = null;
PreparedStatement pstmt2 = null;
boolean tmp_found = false;
boolean tmp_found2 = false;
boolean master =
(req.getParameter("view") != null && req.getParameter("view").equals("master"));
boolean show_notes =
(req.getParameter("show_notes") != null && req.getParameter("show_notes").equals("yes"));
boolean alt_row = false;
boolean tmp_converted = false;
try {
date = Integer.parseInt(sdate);
index = Integer.parseInt(sindex);
wait_list_id = Integer.parseInt(id);
start_time = Integer.parseInt(sstart_time);
end_time = Integer.parseInt(send_time);
} catch (NumberFormatException e) {
}
try {
count = getWaitList.getListCount(wait_list_id, date, index, time, !master, con);
} catch (Exception exp) {
out.println(exp.getMessage());
}
//
// isolate yy, mm, dd
//
int yy = date / 10000;
int temp = yy * 10000;
int mm = date - temp;
temp = mm / 100;
temp = temp * 100;
int dd = mm - temp;
mm = mm / 100;
String report_date = SystemUtils.getLongDateTime(today_date, time, " at ", con);
if (!json_mode) {
out.println("<br>");
out.println(
"<h3 align=center>"
+ ((master) ? "Master Wait List Sign-up Sheet" : "Current Wait List Sign-ups")
+ "</h3>");
out.println("<p align=center><font size=3><b><i>\"" + name + "\"</i></b></font></p>");
out.println("<table border=0 align=center>");
out.println("<tr><td><font size=\"2\">");
out.println(
"Date: <b>"
+ day_name
+ " "
+ mm
+ "/"
+ dd
+ "/"
+ yy
+ "</b></td>");
out.println("<td> </td><td>");
if (!course.equals("")) {
out.println("<font size=\"2\">Course: <b>" + course + "</b></font>");
}
out.println("</td></tr>");
out.println(
"<tr><td><font size=\"2\">Time: <b>"
+ SystemUtils.getSimpleTime(start_time)
+ " to "
+ SystemUtils.getSimpleTime(end_time)
+ "</b></font></td>");
out.println("<td></td>");
out.println("<td><font size=\"2\">Signups: <b>" + count + "</b></font></td>");
out.println("</table>");
out.println(
"<p align=center><font size=2><b><i>List Generated on "
+ report_date
+ "</i></b></font></p>");
out.println("<table align=center border=1 bgcolor=\"#F5F5DC\">");
if (master) {
out.println(
"<tr bgcolor=\"#8B8970\" align=center style=\"color: black; font-weight: bold\">"
+ "<td height=35> Pos </td>"
+ "<td>Sign-up Time</td>"
+ "<td>Members</td>"
+ "<td>Desired Time</td>"
+ "<td> Players </td>"
+ "<td> On Sheet </td>"
+ "<td>Converted At</td>"
+ "<td> Converted By </td>"
+ ((show_notes) ? "<td> Notes </td>" : "")
+ "</tr>");
} else {
out.println(
"<tr bgcolor=\"#8B8970\" align=center style=\"color: black; font-weight: bold\">"
+ "<td height=35> Pos </td>"
+ "<td>Members</td>"
+ "<td>Desired Time</td>"
+ "<td> Players </td>"
+ ((show_notes) ? "<td> Notes </td>" : "")
+ "</tr>"); // +
// "<td> On Sheet </td>" +
// "</tr>");
// ((multi == 0) ? "" : "<td>Course</td>") +
}
out.println(
"<!-- wait_list_id=" + wait_list_id + ", date=" + date + ", time=" + time + " -->");
}
try {
pstmt =
con.prepareStatement(
""
+ "SELECT *, "
+ "DATE_FORMAT(created_datetime, '%c/%e/%y %r') AS created_time, "
+ "DATE_FORMAT(converted_at, '%c/%e/%y %r') AS converted_time "
+ // %l:%i %p
"FROM wait_list_signups "
+ "WHERE wait_list_id = ? AND date = ? "
+ ((master) ? "" : "AND converted = 0 ")
+ ((!master && sindex.equals("0")) ? "AND ok_etime > ? " : "")
+ "ORDER BY created_datetime");
pstmt.clearParameters();
pstmt.setInt(1, wait_list_id);
pstmt.setInt(2, date);
if (!master && sindex.equals("0")) {
pstmt.setInt(3, time);
}
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
wait_list_signup_id = rs.getInt("wait_list_signup_id");
if (json_mode) {
((Map) waitlist_map.get("signups"))
.put("signup_id_" + wait_list_signup_id, new LinkedHashMap());
((Map) ((Map) waitlist_map.get("signups")).get("signup_id_" + wait_list_signup_id))
.put("players", new LinkedHashMap());
((Map) ((Map) waitlist_map.get("signups")).get("signup_id_" + wait_list_signup_id))
.put("options", new HashMap());
} else {
out.print(
"<tr align=center"
+ ((alt_row) ? " style=\"background-color:white\"" : "")
+ "><td>"
+ pos
+ "</td>");
if (master) {
out.println("<td> " + rs.getString("created_time") + " </td>");
}
out.print("<td align=left>");
}
// if (multi == 1) out.println("<td>" + rs.getString("course") + "</td>");
//
// Display players in this signup
//
pstmt2 =
con.prepareStatement(
""
+ "SELECT * "
+ "FROM wait_list_signups_players "
+ "WHERE wait_list_signup_id = ? "
+ "ORDER BY pos");
pstmt2.clearParameters();
pstmt2.setInt(1, wait_list_signup_id);
ResultSet rs2 = pstmt2.executeQuery();
tmp_found2 = false;
player_index = 0;
while (rs2.next()) {
if (json_mode) {
player_index++;
((Map)
((Map)
((Map) waitlist_map.get("signups"))
.get("signup_id_" + wait_list_signup_id))
.get("players"))
.put("player_" + player_index, new HashMap());
((Map)
((Map)
((Map)
((Map) waitlist_map.get("signups"))
.get("signup_id_" + wait_list_signup_id))
.get("players"))
.get("player_" + player_index))
.put("player_name", rs2.getString("player_name"));
((Map)
((Map)
((Map)
((Map) waitlist_map.get("signups"))
.get("signup_id_" + wait_list_signup_id))
.get("players"))
.get("player_" + player_index))
.put("player_name", rs2.getString("player_name"));
((Map)
((Map)
((Map)
((Map) waitlist_map.get("signups"))
.get("signup_id_" + wait_list_signup_id))
.get("players"))
.get("player_" + player_index))
.put("cw", rs2.getString("cw"));
((Map)
((Map)
((Map)
((Map) waitlist_map.get("signups"))
.get("signup_id_" + wait_list_signup_id))
.get("players"))
.get("player_" + player_index))
.put("9hole", rs2.getInt("9hole"));
} else {
fullName = rs2.getString("player_name");
cw = rs2.getString("cw");
if (rs2.getInt("9hole") == 1) {
cw = cw + "9";
}
if (tmp_found2) {
out.print(", ");
} else {
out.print(" ");
}
out.print(fullName + " <font style=\"font-size:9px\">(" + cw + ")</font>");
tmp_found2 = true;
}
sum_players++;
nineHole = ""; // reset
}
pstmt2.close();
if (json_mode) {
((Map)
((Map)
((Map) waitlist_map.get("signups"))
.get("signup_id_" + wait_list_signup_id))
.get("options"))
.put("notes", notes);
((Map)
((Map)
((Map) waitlist_map.get("signups"))
.get("signup_id_" + wait_list_signup_id))
.get("options"))
.put("created_time", rs.getInt("created_time"));
((Map)
((Map)
((Map) waitlist_map.get("signups"))
.get("signup_id_" + wait_list_signup_id))
.get("options"))
.put("converted", rs.getInt("converted"));
((Map)
((Map)
((Map) waitlist_map.get("signups"))
.get("signup_id_" + wait_list_signup_id))
.get("options"))
.put("converted_time", rs.getString("converted_time"));
((Map)
((Map)
((Map) waitlist_map.get("signups"))
.get("signup_id_" + wait_list_signup_id))
.get("options"))
.put("converted_by", rs.getString("converted_by"));
((Map)
((Map)
((Map) waitlist_map.get("signups"))
.get("signup_id_" + wait_list_signup_id))
.get("options"))
.put("start_time", SystemUtils.getSimpleTime(rs.getInt("ok_stime")));
((Map)
((Map)
((Map) waitlist_map.get("signups"))
.get("signup_id_" + wait_list_signup_id))
.get("options"))
.put("end_time", SystemUtils.getSimpleTime(rs.getInt("ok_etime")));
((Map)
((Map)
((Map) waitlist_map.get("signups"))
.get("signup_id_" + wait_list_signup_id))
.get("options"))
.put("wait_list_signup_id", wait_list_signup_id);
((Map)
((Map)
((Map) waitlist_map.get("signups"))
.get("signup_id_" + wait_list_signup_id))
.get("options"))
.put("player_count", sum_players);
} else {
out.print("</td>");
out.println(
"<td> "
+ SystemUtils.getSimpleTime(rs.getInt("ok_stime"))
+ " - "
+ SystemUtils.getSimpleTime(rs.getInt("ok_etime"))
+ " </td>");
out.println("<td>" + sum_players + "</td>");
if (master) {
tmp_converted = rs.getInt("converted") == 1;
out.println("<td>" + ((tmp_converted) ? "Yes" : "No") + "</td>");
out.println(
"<td>" + ((tmp_converted) ? rs.getString("converted_time") : " ") + "</td>");
out.println(
"<td>" + ((tmp_converted) ? rs.getString("converted_by") : " ") + "</td>");
}
if (show_notes) {
notes = rs.getString("notes").trim();
if (notes.equals("")) {
notes = " ";
}
out.println("<td>" + notes + "</td>");
}
out.print("</tr>");
}
pos++;
sum_players = 0;
alt_row = alt_row == false;
}
pstmt.close();
} catch (Exception exc) {
SystemUtils.buildDatabaseErrMsg(
"Error loading wait list signups.", exc.toString(), out, false);
}
if (json_mode) {
((Map) waitlist_map.get("options")).put("index", sindex);
((Map) waitlist_map.get("options")).put("wait_list_id", wait_list_id);
((Map) waitlist_map.get("options")).put("date", "" + mm + "/" + dd + "/" + yy);
((Map) waitlist_map.get("options")).put("name", name);
((Map) waitlist_map.get("options")).put("time", time);
((Map) waitlist_map.get("options")).put("jump", jump);
((Map) waitlist_map.get("options")).put("returnCourse", returnCourse);
((Map) waitlist_map.get("options")).put("course", course);
((Map) waitlist_map.get("options")).put("master", master);
((Map) waitlist_map.get("options")).put("report_date", report_date);
((Map) waitlist_map.get("options")).put("show_notes", show_notes);
} else {
out.println("</table><br>");
out.println("<table align=center><tr>");
out.println("<form action=\"Member_jump\" method=\"POST\" target=\"_top\">");
out.println("<input type=\"hidden\" name=\"jump\" value=\"0\">");
out.println("<input type=\"hidden\" name=\"index\" value=" + sindex + ">");
out.println(
"<input type=\"hidden\" name=\"course\" value=\""
+ ((!returnCourse.equals("")) ? returnCourse : course)
+ "\">");
out.println("<td><input type=\"submit\" value=\"Tee Sheet\"></td></form>");
out.println("<td> </td>");
out.println("<form action=\"Member_waitlist\" method=\"POST\">");
out.println("<input type=\"hidden\" name=\"waitListId\" value=\"" + wait_list_id + "\">");
out.println("<input type=\"hidden\" name=\"date\" value=\"" + date + "\">");
out.println("<input type=\"hidden\" name=\"day\" value=\"" + day_name + "\">");
out.println("<input type=\"hidden\" name=\"index\" value=\"" + sindex + "\">");
out.println("<input type=\"hidden\" name=\"course\" value=\"" + course + "\">");
out.println("<input type=\"hidden\" name=\"returnCourse\" value=\"" + returnCourse + "\">");
out.println("<input type=\"hidden\" name=\"jump\" value=\"" + jump + "\">");
out.println("<td><input type=\"submit\" value=\"Return\"></td></form>");
out.println("</tr></table></form>");
out.println("<br>");
}
return waitlist_map;
} // end viewSignups
// The tck uses only get & post requests
protected void processTCKReq(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
LOGGER.entering(LOG_CLASS, "servlet entry");
PortletRequest portletReq = (PortletRequest) request.getAttribute("javax.portlet.request");
PortletResponse portletResp = (PortletResponse) request.getAttribute("javax.portlet.response");
PortletConfig portletConfig = (PortletConfig) request.getAttribute("javax.portlet.config");
long svtTid = Thread.currentThread().getId();
long reqTid = (Long) portletReq.getAttribute(THREADID_ATTR);
PrintWriter writer = ((MimeResponse) portletResp).getWriter();
JSR286DispatcherReqRespTestCaseDetails tcd = new JSR286DispatcherReqRespTestCaseDetails();
// Create result objects for the tests
/* TestCase: V2DispatcherReqRespTests4_SPEC2_19_IncludeServletResourceResponse_containsHeader */
/* Details: "In a target servlet of a include in the Resource phase, */
/* the method HttpServletResponse.containsHeader must return false" */
TestResult tr0 =
tcd.getTestResultFailed(
V2DISPATCHERREQRESPTESTS4_SPEC2_19_INCLUDESERVLETRESOURCERESPONSE_CONTAINSHEADER);
try {
boolean ok = response.containsHeader("Accept");
tr0.setTcSuccess(ok == false);
} catch (Exception e) {
tr0.appendTcDetail(e.toString());
}
tr0.writeTo(writer);
/* TestCase: V2DispatcherReqRespTests4_SPEC2_19_IncludeServletResourceResponse_encodeRedirectURL1 */
/* Details: "In a target servlet of a include in the Resource phase, */
/* the method HttpServletResponse.encodeRedirectURL must return null" */
TestResult tr1 =
tcd.getTestResultFailed(
V2DISPATCHERREQRESPTESTS4_SPEC2_19_INCLUDESERVLETRESOURCERESPONSE_ENCODEREDIRECTURL1);
try {
String isval = response.encodeRedirectURL("http://www.cnn.com/");
CompareUtils.stringsEqual(isval, null, tr1);
} catch (Exception e) {
tr1.appendTcDetail(e.toString());
}
tr1.writeTo(writer);
/* TestCase: V2DispatcherReqRespTests4_SPEC2_19_IncludeServletResourceResponse_encodeRedirectUrl */
/* Details: "In a target servlet of a include in the Resource phase, */
/* the method HttpServletResponse.encodeRedirectUrl must return null" */
TestResult tr2 =
tcd.getTestResultFailed(
V2DISPATCHERREQRESPTESTS4_SPEC2_19_INCLUDESERVLETRESOURCERESPONSE_ENCODEREDIRECTURL);
try {
String isval = response.encodeRedirectUrl("http://www.cnn.com/");
CompareUtils.stringsEqual(isval, null, tr2);
} catch (Exception e) {
tr2.appendTcDetail(e.toString());
}
tr2.writeTo(writer);
/* TestCase: V2DispatcherReqRespTests4_SPEC2_19_IncludeServletResourceResponse_encodeURL1 */
/* Details: "In a target servlet of a include in the Resource phase, */
/* the method HttpServletResponse.encodeURL must provide the same */
/* functionality as ResourceResponse.encodeURL" */
TestResult tr3 =
tcd.getTestResultFailed(
V2DISPATCHERREQRESPTESTS4_SPEC2_19_INCLUDESERVLETRESOURCERESPONSE_ENCODEURL1);
try {
String turl = "http://www.apache.org/";
String hval = (String) response.encodeURL(turl);
String pval = (String) portletResp.encodeURL(turl);
CompareUtils.stringsEqual("HttpServletResponse", hval, "ResourceResponse", pval, tr3);
} catch (Exception e) {
tr3.appendTcDetail(e.toString());
}
tr3.writeTo(writer);
/* TestCase: V2DispatcherReqRespTests4_SPEC2_19_IncludeServletResourceResponse_encodeUrl */
/* Details: "In a target servlet of a include in the Resource phase, */
/* the method HttpServletResponse.encodeUrl must provide the same */
/* functionality as ResourceResponse.encodeURL" */
TestResult tr4 =
tcd.getTestResultFailed(
V2DISPATCHERREQRESPTESTS4_SPEC2_19_INCLUDESERVLETRESOURCERESPONSE_ENCODEURL);
try {
String turl = "http://www.apache.org/";
String hval = (String) response.encodeUrl(turl);
String pval = (String) portletResp.encodeURL(turl);
CompareUtils.stringsEqual("HttpServletResponse", hval, "ResourceResponse", pval, tr4);
} catch (Exception e) {
tr4.appendTcDetail(e.toString());
}
tr4.writeTo(writer);
/* TestCase: V2DispatcherReqRespTests4_SPEC2_19_IncludeServletResourceResponse_getBufferSize */
/* Details: "In a target servlet of a include in the Resource phase, */
/* the method HttpServletResponse.getBufferSize must provide the same */
/* functionality as ResourceResponse.getBufferSize" */
TestResult tr5 =
tcd.getTestResultFailed(
V2DISPATCHERREQRESPTESTS4_SPEC2_19_INCLUDESERVLETRESOURCERESPONSE_GETBUFFERSIZE);
try {
int hval = response.getBufferSize();
int pval = ((ResourceResponse) portletResp).getBufferSize();
String str =
"Value "
+ hval
+ " from "
+ "HttpServletResponse"
+ " does not equal value "
+ pval
+ " + ResourceResponse";
if (hval != pval) {
tr5.appendTcDetail(str);
}
tr5.setTcSuccess(hval == pval);
} catch (Exception e) {
tr5.appendTcDetail(e.toString());
}
tr5.writeTo(writer);
/* TestCase: V2DispatcherReqRespTests4_SPEC2_19_IncludeServletResourceResponse_getCharacterEncoding */
/* Details: "In a target servlet of a include in the Resource phase, */
/* the method HttpServletResponse.getCharacterEncoding must provide */
/* the same functionality as ResourceResponse.getCharacterEncoding" */
TestResult tr6 =
tcd.getTestResultFailed(
V2DISPATCHERREQRESPTESTS4_SPEC2_19_INCLUDESERVLETRESOURCERESPONSE_GETCHARACTERENCODING);
try {
String hval = response.getCharacterEncoding();
String pval = ((ResourceResponse) portletResp).getCharacterEncoding();
CompareUtils.stringsEqual("HttpServletResponse", hval, "ResourceResponse", pval, tr6);
} catch (Exception e) {
tr6.appendTcDetail(e.toString());
}
tr6.writeTo(writer);
/* TestCase: V2DispatcherReqRespTests4_SPEC2_19_IncludeServletResourceResponse_getContentType */
/* Details: "In a target servlet of a include in the Resource phase, */
/* the method HttpServletResponse.getContentType must provide the */
/* same functionality as ResourceResponse.getContentType" */
TestResult tr7 =
tcd.getTestResultFailed(
V2DISPATCHERREQRESPTESTS4_SPEC2_19_INCLUDESERVLETRESOURCERESPONSE_GETCONTENTTYPE);
try {
String hval = response.getContentType();
String pval = ((ResourceResponse) portletResp).getContentType();
CompareUtils.stringsEqual("HttpServletResponse", hval, "ResourceResponse", pval, tr7);
} catch (Exception e) {
tr7.appendTcDetail(e.toString());
}
tr7.writeTo(writer);
/* TestCase: V2DispatcherReqRespTests4_SPEC2_19_IncludeServletResourceResponse_getLocale */
/* Details: "In a target servlet of a include in the Resource phase, */
/* the method HttpServletResponse.getLocale must provide the same */
/* functionality as ResourceResponse.getLocale" */
TestResult tr8 =
tcd.getTestResultFailed(
V2DISPATCHERREQRESPTESTS4_SPEC2_19_INCLUDESERVLETRESOURCERESPONSE_GETLOCALE);
try {
Locale hl = response.getLocale();
Locale pl = ((MimeResponse) portletResp).getLocale();
String hval = hl.getDisplayName();
String pval = pl.getDisplayName();
CompareUtils.stringsEqual("HttpServletResponse", hval, "ResourceResponse", pval, tr8);
} catch (Exception e) {
tr8.appendTcDetail(e.toString());
}
tr8.writeTo(writer);
/* TestCase: V2DispatcherReqRespTests4_SPEC2_19_IncludeServletResourceResponse_isCommitted */
/* Details: "In a target servlet of a include in the Resource phase, */
/* the method HttpServletResponse.isCommitted must provide the same */
/* functionality as ResourceResponse.isCommitted" */
TestResult tr9 =
tcd.getTestResultFailed(
V2DISPATCHERREQRESPTESTS4_SPEC2_19_INCLUDESERVLETRESOURCERESPONSE_ISCOMMITTED);
try {
boolean hval = response.isCommitted();
boolean pval = ((ResourceResponse) portletResp).isCommitted();
String str =
"Value "
+ hval
+ " from "
+ "HttpServletResponse"
+ " does not equal value "
+ pval
+ " + ResourceResponse";
if (hval != pval) {
tr9.appendTcDetail(str);
}
tr9.setTcSuccess(hval == pval);
} catch (Exception e) {
tr9.appendTcDetail(e.toString());
}
tr9.writeTo(writer);
}
public void doGet(HttpServletRequest req, HttpServletResponse resp)
throws IOException, ServletException {
boolean isMultipart = FileUpload.isMultipartContent(req);
Hashtable dv = new Hashtable();
String user = null;
String password = null;
String sql = null;
String dfo = null;
String enc = null;
if (isMultipart) {
ServletFileUpload upload = new ServletFileUpload();
upload.setSizeMax(mU);
try {
FileItemIterator iter = upload.getItemIterator(req);
// List<FileItem> items = upload.parseRequest(req);
while (iter.hasNext()) {
FileItemStream item = iter.next();
// for (int ct = 0;ct < items.size();ct++){
// FileItem item = (FileItem)items.get(ct);
String name = item.getName();
// (name + " jiql UREEAD 1aay " + item.isFormField() + ":" + name.equals("directValues"));
InputStream stream = item.openStream();
// InputStream stream = item.getInputStream();
//// (name + " jiql UREEAD 1 " + stream.available());
// byte[] b = StreamUtil.readBytes(stream);
if (name.equals("directValues")) {
// (stream.available() + " jiql UREEAD " );
// ByteArrayInputStream bout = new ByteArrayInputStream(b);
ObjectInputStream dout = new ObjectInputStream(stream);
// ObjectInputStream dout = new ObjectInputStream(bout);
dv = (Hashtable) dout.readObject();
}
}
} catch (Exception e) {
tools.util.LogMgr.err("JS.readDV " + e.toString());
e.printStackTrace();
}
// ("$$$ DV " + dv);
Hashtable pars = (Hashtable) dv.get("parameters");
if (pars != null) {
Enumeration en = pars.keys();
while (en.hasMoreElements()) {
String n = en.nextElement().toString();
// ("PARSMS " + n);
if (n.equals("query")) sql = pars.get(n).toString();
else if (n.equals("password")) password = pars.get(n).toString();
else if (n.equals("user")) user = pars.get(n).toString();
else if (n.equals("date.format")) dfo = pars.get(n).toString();
else if (n.equals("encoding")) enc = pars.get(n).toString();
}
}
}
if (user == null) user = req.getParameter("user");
if (password == null) password = req.getParameter("password");
if (!StringUtil.isRealString(user) || !StringUtil.isRealString(password)) {
resp.sendError(403, "Invalid User or Password");
return;
}
if (!StringUtil.isRealString(theUser) || !StringUtil.isRealString(thePassword)) {
resp.sendError(403, "Invalid User OR Password");
return;
}
Connection Conn = null;
Hashtable h = new Hashtable();
h.put("remote", "true");
try {
// NameValuePairs p = new NameValuePairs(ps);
if (!user.equals(theUser) || !password.equals(thePassword)) {
resp.sendError(403, "Invalid User OR Invalid Password");
return;
}
// throw new ServletException("Invalid User OR Password");
if (sql == null) sql = req.getParameter("query");
// ( "THE SQL " + sql);
NameValuePairs nvp = new NameValuePairs();
if (dfo == null) dfo = req.getParameter("date.format");
if (dfo != null) nvp.put("date.format", dfo);
if (enc == null) enc = req.getParameter("encoding");
if (enc != null) nvp.put("encoding", enc);
Conn = get(nvp);
org.jiql.jdbc.Statement Stmt = (org.jiql.jdbc.Statement) Conn.createStatement();
Stmt.setDirectValues(dv);
Stmt.execute(sql);
org.jiql.jdbc.ResultSet res = (org.jiql.jdbc.ResultSet) Stmt.getResultSet();
if (res != null) {
if (res.getResults() != null) h.put("results", res.getResults());
if (res.getSQLParser() != null) h.put("sqlparser", res.getSQLParser());
} else h.put("sqlparser", Stmt.getSQLParser());
// h.put("remote","true");
resp.setContentType("binary/object");
// if (enc != null)
// resp.setCharacterEncoding(enc);
OutputStream fos = resp.getOutputStream();
ObjectOutputStream oos = new ObjectOutputStream(fos);
oos.writeObject(h);
// resp.getWriter(). ("result" + h);
} catch (Exception ex) {
org.jiql.util.JGUtil.olog(ex);
ex.printStackTrace();
tools.util.LogMgr.err("JIQLServlet " + ex.toString());
JGException je = null;
if (ex instanceof JGException) je = (JGException) ex;
else je = new JGException(ex.toString());
h.put("error", je);
resp.setContentType("binary/object");
OutputStream fos = resp.getOutputStream();
ObjectOutputStream oos = new ObjectOutputStream(fos);
oos.writeObject(h);
// throw new ServletException(ex.toString());
} finally {
if (Conn != null)
try {
Conn.close();
} catch (Exception ex) {
ex.printStackTrace();
}
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try {
address = PAConfiguration.getAddress();
port = PAConfiguration.getPort(instantiation);
poslAddress = PAConfiguration.getPOSL(instantiation, topic);
rdfAddress = PAConfiguration.getRDFTaxonomy(instantiation);
messageEndpoint = PAConfiguration.getEndpointName(instantiation, topic);
} catch (BadConfigurationException e) {
System.out.println(e.getMessage());
e.printStackTrace();
System.exit(0);
}
response.setContentType("text/html; charset=UTF-8");
PrintWriter out = response.getWriter();
try {
System.out.println("5 Publicty Chair Servlet");
System.out.println(response.toString());
BufferedReader brd = request.getReader();
String input = "";
String message = "";
while (!input.equals("</RuleML>")) {
input = brd.readLine();
message = message + input;
}
String[] varOrder = getVariableOrder(message);
System.out.println("Received Message: " + message);
// BackwardReasoner br = new BackwardReasoner();
// Iterator solit =null;
// DefiniteClause dc = null;
// SymbolTable.reset();
POSLParser pp = new POSLParser();
// String contents = "c(a).\nc(b).\nc(c).";
Date t1 = new GregorianCalendar().getTime();
System.out.println(t1.getHours() + ":" + t1.getMinutes());
// append time to contents
System.out.println("day: " + t1.getDay());
System.out.println("day: " + t1.getYear());
System.out.println("day: " + t1.getMonth());
// time
String time = "time(" + t1.getHours() + ":integer).";
System.out.println(time);
String url = poslAddress;
// String url = "http://www.jdrew.org/oojdrew/test.posl";
String contents = "";
// day of the week
int day = t1.getDay();
boolean weekday = true;
if (day == 0 || day == 6) {
weekday = false;
}
String dayOfWeek;
if (weekday) {
dayOfWeek = "day(weekday).";
} else {
dayOfWeek = "day(weekend).";
}
// full date
Calendar cal = new GregorianCalendar();
int year = cal.get(Calendar.YEAR);
int month = cal.get(Calendar.MONTH) + 1;
int day2 = cal.get(Calendar.DAY_OF_MONTH);
String date;
String day3 = "" + day2;
if (day2 == 1 || day2 == 2 || day2 == 3 || day2 == 4 || day2 == 5 || day2 == 6 || day2 == 7
|| day2 == 8 || day2 == 9) {
day3 = "0" + day2;
}
if (month == 10 || month == 11 || month == 12) date = "" + year + month + day3;
else date = "" + year + "0" + month + day3;
date = "date(" + date + ":integer).";
System.out.println(date);
String url2 = rdfAddress;
HttpClient client2 = new HttpClient();
GetMethod method2 = new GetMethod(url2);
method2.setFollowRedirects(true);
String typestr = "";
// Execute the GET method
int statusCode2 = client2.executeMethod(method2);
if (statusCode2 != -1) {
typestr = method2.getResponseBodyAsString();
}
System.out.println("Types: " + typestr);
Types.reset();
RDFSParser.parseRDFSString(typestr);
try {
HttpClient client = new HttpClient();
GetMethod method = new GetMethod(url);
method.setFollowRedirects(true);
// Execute the GET method
int statusCode = client.executeMethod(method);
if (statusCode != -1) {
contents = method.getResponseBodyAsString();
}
} catch (Exception e) {
e.printStackTrace();
}
contents = contents + "\n" + time;
contents = contents + "\n" + dayOfWeek;
contents = contents + "\n" + date;
BackwardReasoner br = new BackwardReasoner();
Iterator solit = null;
DefiniteClause dc = null;
SymbolTable.reset();
pp.parseDefiniteClauses(contents);
br.loadClauses(pp.iterator());
System.out.println("TEST");
Iterator it = pp.iterator();
while (it.hasNext()) {
DefiniteClause d = (DefiniteClause) it.next();
System.out.println("Loaded clause: " + d.toPOSLString());
}
br = new BackwardReasoner(br.clauses, br.oids);
MessageParser m = new MessageParser(message);
Element atom = null;
try {
atom = m.parseForContent();
} catch (Exception e) {
System.out.println("Invalid Message");
// out.flush();
}
QueryBuilder q = new QueryBuilder(atom);
String query = q.generateDoc();
System.out.println("ABOUT TO INPUT THIS QUERY:" + query);
RuleMLParser qp = new RuleMLParser();
try {
dc = qp.parseRuleMLQuery(query);
} catch (Exception e) {
System.out.println("Invalid Query");
// out.flush();
}
// solit = br.iterativeDepthFirstSolutionIterator(dc);
solit = br.iterativeDepthFirstSolutionIterator(dc);
int varSize = 0;
while (solit.hasNext()) {
Vector data = new Vector();
BackwardReasoner.GoalList gl = (BackwardReasoner.GoalList) solit.next();
Hashtable varbind = gl.varBindings;
javax.swing.tree.DefaultMutableTreeNode root = br.toTree();
root.setAllowsChildren(true);
javax.swing.tree.DefaultTreeModel dtm = new DefaultTreeModel(root);
int i = 0;
Object[][] rowdata = new Object[varbind.size()][2];
varSize = varbind.size();
Enumeration e = varbind.keys();
while (e.hasMoreElements()) {
Object k = e.nextElement();
Object val = varbind.get(k);
String ks = (String) k;
rowdata[i][0] = ks;
rowdata[i][1] = val;
i++;
}
data.addElement(rowdata);
String[] messages = new String[data.size()];
MessageGenerator g =
new MessageGenerator(
data, varSize, messageEndpoint, m.getId(), m.getProtocol(), m.getRel(), varOrder);
messages = g.Messages2();
String appender = "";
URL sender = new URL(address + ":" + port);
HttpMessage msg = new HttpMessage(sender);
Properties props = new Properties();
for (int i1 = 0; i1 < data.size(); i1++) {
System.out.println(i1 + ")" + messages[i1].toString());
props.put("text", messages[i1].toString());
InputStream in = msg.sendGetMessage(props);
}
System.out.println("NEXT MESSAGE");
}
MessageGenerator g =
new MessageGenerator(
null, varSize, messageEndpoint, m.getId(), m.getProtocol(), m.getRel());
URL sender = new URL(address + ":" + port);
HttpMessage msg = new HttpMessage(sender);
Properties props = new Properties();
String finalMessage = g.finalMessage(query);
System.out.println(finalMessage);
props.put("text", finalMessage);
InputStream in = msg.sendGetMessage(props);
System.out.println("Stop_Communication");
} catch (Exception e) {
System.out.println("ERROR has occured : " + e.toString());
}
out.close();
}
