// *****************************************************
// 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 IOException {
int index;
DatastoreService ds;
MemcacheService ms;
BlobstoreService bs;
URLFetchService us;
FileService fs;
Map<String, List<BlobKey>> blobMap;
BlobKey blobKey;
BlobInfoFactory blobInfoFactory;
BlobInfo blobInfo;
int postCount;
int postIndex;
String postType;
String postText;
String postDelpw;
String postShowgallery;
DataObj dataObj;
String filelink;
String picUrl;
HTTPResponse picRes;
List<HTTPHeader> headerList;
String picMime;
String[] fileNamePart;
AppEngineFile picFile;
FileWriteChannel writeChannel;
PostObj postObj;
List<PostObj> postObjList;
String linkID;
resp.setCharacterEncoding("UTF-8");
resp.setContentType("text/plain");
try {
ds = DatastoreServiceFactory.getDatastoreService();
ms = MemcacheServiceFactory.getMemcacheService();
bs = BlobstoreServiceFactory.getBlobstoreService();
us = URLFetchServiceFactory.getURLFetchService();
fs = FileServiceFactory.getFileService();
blobInfoFactory = new BlobInfoFactory(ds);
blobMap = bs.getUploads(req);
postCount = Integer.valueOf(req.getParameter("input_post_count"));
postObjList = new ArrayList<PostObj>();
for (postIndex = 0; postIndex < postCount; postIndex++) {
try {
postType = req.getParameter("input_post_type_" + postIndex);
if (postType == null) {
continue;
}
postText = req.getParameter("input_post_text_" + postIndex);
postDelpw = req.getParameter("input_post_delpw_" + postIndex);
postShowgallery = req.getParameter("input_post_showgallery_" + postIndex);
if (postShowgallery == null) {
postShowgallery = "";
}
if (postType.equals("file") == true) {
blobKey = blobMap.get("input_post_file_" + postIndex).get(0);
if (blobKey == null) {
throw new Exception();
}
dataObj = new DataObj();
dataObj.fileid = createUID();
dataObj.posttime = new Date().getTime();
dataObj.delpw = postDelpw;
dataObj.blobkey = blobKey;
dataObj.putDB(ds);
blobInfo = blobInfoFactory.loadBlobInfo(dataObj.blobkey);
filelink =
"http://"
+ req.getServerName()
+ "/down/"
+ dataObj.fileid
+ "/"
+ blobInfo.getFilename();
postObj =
new PostObj(
dataObj.fileid,
filelink,
blobInfo.getSize(),
dataObj.posttime,
dataObj.delpw,
postShowgallery);
postObjList.add(postObj);
} else if (postType.equals("url") == true) {
picUrl = postText;
picRes = us.fetch(new URL(picUrl));
headerList = picRes.getHeaders();
picMime = "application/octet-stream";
for (index = 0; index < headerList.size(); index++) {
if (headerList.get(index).getName().compareToIgnoreCase("Content-Type") == 0) {
picMime = headerList.get(index).getValue();
break;
}
}
fileNamePart = picUrl.split("/");
picFile = fs.createNewBlobFile(picMime, fileNamePart[fileNamePart.length - 1]);
writeChannel = fs.openWriteChannel(picFile, true);
writeChannel.write(ByteBuffer.wrap(picRes.getContent()));
writeChannel.closeFinally();
dataObj = new DataObj();
dataObj.fileid = createUID();
dataObj.posttime = new Date().getTime();
dataObj.delpw = postDelpw;
dataObj.blobkey = fs.getBlobKey(picFile);
dataObj.putDB(ds);
blobInfo = blobInfoFactory.loadBlobInfo(dataObj.blobkey);
filelink =
"http://"
+ req.getServerName()
+ "/down/"
+ dataObj.fileid
+ "/"
+ blobInfo.getFilename();
postObj =
new PostObj(
dataObj.fileid,
filelink,
blobInfo.getSize(),
dataObj.posttime,
dataObj.delpw,
postShowgallery);
postObjList.add(postObj);
}
} catch (Exception e) {
}
}
linkID = postFile(us, postObjList);
if (req.getParameter("specflag") != null) {
resp.getWriter().print("http://tnfshmoe.appspot.com/link.jsp?linkid=" + linkID);
} else {
resp.sendRedirect("http://tnfshmoe.appspot.com/link.jsp?linkid=" + linkID);
}
} catch (Exception e) {
}
}
public void doPost(HttpServletRequest req, HttpServletResponse resp) throws IOException {
int index;
DatastoreService ds;
MemcacheService ms;
Cookie[] cookies;
boolean insideFlag;
String delpw;
String paramOffset;
String paramSize;
int offset;
int size;
Key postObjGroupKey;
Query q;
List<Entity> postObjList;
PostObj postObj;
Gson gson;
List<String> filelinkList;
resp.setCharacterEncoding("UTF-8");
resp.setContentType("text/plain");
ds = DatastoreServiceFactory.getDatastoreService();
ms = MemcacheServiceFactory.getMemcacheService();
insideFlag = false;
try {
cookies = req.getCookies();
if (cookies.length > 0) {
if (ms.contains(cookies[0].getValue()) == true) {
insideFlag = true;
}
}
} catch (Exception e) {
insideFlag = false;
}
delpw = req.getParameter("delpw");
if (delpw != null) {
if (delpw.equals("") == true) {
delpw = null;
}
}
paramOffset = req.getParameter("offset");
if (paramOffset != null) {
offset = Integer.valueOf(paramOffset);
} else {
offset = 0;
}
paramSize = req.getParameter("size");
if (paramSize != null) {
size = Integer.valueOf(paramSize);
} else {
size = 4096;
}
postObjGroupKey = KeyFactory.createKey("PostObjGroup", 1L);
q = new Query("PostObj", postObjGroupKey);
if (delpw != null) {
q.addFilter("delpw", FilterOperator.EQUAL, delpw);
q.addSort("delpw");
}
q.addSort("posttime", SortDirection.DESCENDING);
postObjList = ds.prepare(q).asList(FetchOptions.Builder.withOffset(offset).limit(size));
postObj = new PostObj();
filelinkList = new ArrayList<String>();
for (index = 0; index < postObjList.size(); index++) {
postObj.getDB(postObjList.get(index));
if ((postObj.flag.equals("showgallery") == false && insideFlag == true)
|| (postObj.flag.equals("showgallery") == true && insideFlag == false)
|| delpw != null) {
filelinkList.add(postObj.filelink);
}
}
gson = new Gson();
resp.getWriter().print(gson.toJson(filelinkList));
}