public String checkValidLogin(String myUserName, String myPW) {
try {
Class.forName(javaSQLDriverPath);
Connection conn =
(Connection) DriverManager.getConnection(ConnectionPath, ConnectionUser, ConnectionPW);
Statement st = conn.createStatement();
String query = "Select * from User";
ResultSet rs = st.executeQuery(query);
while (rs.next()) {
// return rs.getString("Username");
if (myUserName.equals(rs.getString("Username"))) {
if (myPW.equals(rs.getString("Password"))) {
setUserVariables(myUserName);
return "success";
} else {
return "wrongPassword";
}
}
}
rs.close();
st.close();
conn.close();
return "userNotFound";
} catch (Exception e) {
return e.getMessage();
}
}
protected collegeTable getCollege(String id, Connection con) throws SQLException {
try {
ResultSet rs = null;
Statement statement = con.createStatement();
rs =
statement.executeQuery(
"SELECT * FROM "
+ TABLECOLLEGES
+ " WHERE "
+ collegeTable.ID
+ " = "
+ id
+ " LIMIT 1");
// if found
if (rs.next()) {
collegeTable table = new collegeTable();
table.setID(id);
table.setShort(rs.getString(collegeTable.SHORTNAME));
table.setFull(rs.getString(collegeTable.FULLNAME));
return table;
} else {
return null; // not found
}
} catch (Exception e) {
log.writeException(e.getMessage());
throw new SQLException(e.getMessage());
}
} // end getCollege
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
res.setContentType("text/html");
PrintWriter toClient = res.getWriter();
toClient.println("<!DOCTYPE HTML>");
toClient.println("<html>");
toClient.println("<head><title>Books</title></head>");
toClient.println("<body>");
toClient.println("<a href=\"index.html\">Home</A>");
toClient.println("<h2>List of books</h2>");
HttpSession session = req.getSession(false);
if (session != null) {
String name = (String) session.getAttribute("name");
if (name != null) {
toClient.println("<h2>name: " + name + "</h2>");
}
}
toClient.print("<form action=\"bookOpinion\" method=GET>");
toClient.println("<table border='1'>");
String sql = "Select code, title, author FROM books";
System.out.println(sql);
try {
Statement statement = connection.createStatement();
ResultSet result = statement.executeQuery(sql);
while (result.next()) {
toClient.println("<tr>");
String codeStr = result.getString("code");
toClient.println(
"<td><input type=\"radio\" name=\"book" + "\" value=\"" + codeStr + "\"></td>");
toClient.println("<td>" + codeStr + "</td>");
toClient.println("<td>" + result.getString("title") + "</td>");
toClient.println("<td>" + result.getString("author") + "</td>");
toClient.println("</tr>");
}
} catch (SQLException e) {
e.printStackTrace();
System.out.println("Resulset: " + sql + " Exception: " + e);
}
toClient.println("</table>");
toClient.println("<textarea rows=\"8\" cols=\"60\" name=\"comment\"></textarea><BR>");
toClient.println("<input type=submit>");
toClient.println("</form>");
toClient.println("</body>");
toClient.println("</html>");
toClient.close();
}
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con =
DriverManager.getConnection(Utility.connection, Utility.username, Utility.password);
String email = request.getParameter("email_id");
String number = "";
boolean exists = false;
String user_name = "";
int user_id = -1;
String str1 = "SELECT USER_ID,NAME,PHONE_NUMBER FROM USERS WHERE EMAIL_ID=?";
PreparedStatement prep1 = con.prepareStatement(str1);
prep1.setString(1, email);
ResultSet rs1 = prep1.executeQuery();
if (rs1.next()) {
exists = true;
user_id = rs1.getInt("USER_ID");
user_name = rs1.getString("NAME");
number = rs1.getString("PHONE_NUMBER");
}
int verification = 0;
JSONObject data = new JSONObject();
if (exists) {
verification = (int) (Math.random() * 9535641 % 999999);
System.out.println("Number " + number + "\nVerification: " + verification);
SMSProvider.sendSMS(
number, "Your One Time Verification Code for PeopleConnect Is " + verification);
}
data.put("user_name", user_name);
data.put("user_id", user_id);
data.put("verification_code", "" + verification);
data.put("phone_number", number);
String toSend = data.toJSONString();
out.print(toSend);
System.out.println(toSend);
} catch (Exception e) {
e.printStackTrace();
} finally {
out.close();
}
}
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 {
Statement question;
String query;
ResultSet answer;
connect();
try {
query = "SELECT * FROM PILOT WHERE Address ='" + request.getParameter("city") + "'";
question = link.createStatement();
answer = question.executeQuery(query);
PrintWriter pen;
response.setContentType("text/html");
pen = response.getWriter();
pen.println("<HTML>");
pen.println("<HEAD> <TITLE> Answer </TITLE> </HEAD>");
pen.println("<BODY>");
while (answer.next()) {
String pN = answer.getString("PilotNumber");
String lN = answer.getString("LastName");
String fN = answer.getString("FirstName");
String ad = answer.getString("Address");
float sa = answer.getFloat("Salary");
float pr = answer.getFloat("Premium");
Date hD = answer.getDate("HiringDate");
if (answer.wasNull() == false) {
pen.println("<P><B> Pilot : </B>" + lN + " " + fN);
pen.println("<P><B> ---Reference : </B>" + pN);
pen.println("<P><B> ---Address : </B>" + ad);
pen.println("<P><B> ---Salary : </B>" + sa);
pen.println("<P><B> ---since : </B>" + hD);
if (pr > 0) pen.println("<P><B> ---Premium : </B>" + pr);
else pen.println("<P><B> ---No premium </B>");
}
}
pen.println("</BODY>");
pen.println("</HTML>");
answer.close();
question.close();
link.close();
} catch (SQLException e) {
System.out.println("Connection error: " + e.getMessage());
}
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
Connection conn = null;
PreparedStatement pstmt = null;
try {
System.out.println("Enrollno: 130050131049");
// STEP 2: Register JDBC driver
Class.forName(JDBC_DRIVER);
// STEP 3: Open a connection
System.out.println("Connecting to a selected database...");
conn = DriverManager.getConnection(DB_URL, USER, PASS);
System.out.println("Connected database successfully...");
// STEP 2: Executing query
String sql = "SELECT * FROM logindetails WHERE name = ?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "Krut");
ResultSet rs = pstmt.executeQuery();
out.print("| <b>Name</b>| ");
out.print("<b>Password</b>| ");
out.println("</br>\n-------------------------------</br>");
while (rs.next()) {
out.println();
out.print("| " + rs.getString(1));
out.print("| " + rs.getString(2) + "|");
out.println("</br>");
}
} catch (SQLException se) {
// Handle errors for JDBC
se.printStackTrace();
} catch (Exception e) {
// Handle errors for Class.forName
e.printStackTrace();
} finally {
// finally block used to close resources
try {
if (pstmt != null) conn.close();
} catch (SQLException se) {
} // do nothing
try {
if (conn != null) conn.close();
} catch (SQLException se) {
se.printStackTrace();
} // end finally try
} // end try
}
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws IOException, ServletException {
res.setContentType("text/html");
PrintWriter out = res.getWriter();
out.println("vaishali mehta-130050131524");
out.println("<html>");
out.println("<body><table border='1'>");
out.println("<th>name</th>");
out.println("<th>password</th>");
try {
rs = stmt.executeQuery("select *from records");
while (rs.next()) {
tn = rs.getString("name");
tp = rs.getString("password");
out.println("<tr>");
out.println("<td>" + tn + "</td>");
out.println("<td>" + tp + "</td>");
out.println("</tr>");
}
} catch (Exception e) {
System.out.println(e);
}
out.println("</table></body></html>");
}
public void doPost(HttpServletRequest req, HttpServletResponse res) throws IOException {
try {
res.setContentType("text/html");
pw = res.getWriter();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:com", "o7it58", "yajiv32737");
st = con.createStatement();
pw.println("<html>");
pw.println("<head><title>Welcome</title></head>");
pw.println("<body>");
s = req.getParameter("login");
if (s.equals("Submit")) {
uname = req.getParameter("firstname");
pass = req.getParameter("pwd");
PrintWriter out = new PrintWriter(new FileWriter("log.txt"), true);
out.println(uname);
rs =
st.executeQuery(
"select type from login where username='******' and password='******'");
if (rs.next()) {
type = rs.getString("type");
} else {
pw.println("<center>");
pw.println("User does not exists");
pw.println("</center>");
}
if (type.equals("admin")) {
pw.println(
"<a href=\"http://localhost:8080/servlet/AdminLogin\">Hello Admin.Please Click Here</a>");
} else if (type.equals("staff")) {
pw.println(
"<a href=\"http://localhost:8080/servlet/StaffLogin\">Hello Staff.Please Click Here</a>");
} else {
pw.println(
"<a href=\"http://localhost:8080/servlet/StudentLogin\">Hello Student.Please Click Here</a>");
}
}
pw.println("</body></html>");
} catch (Exception e) {
}
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String dbUser = "******"; // enter your username here
String dbPassword = "******"; // enter your password here
try {
OracleDataSource ods = new oracle.jdbc.pool.OracleDataSource();
ods.setURL("jdbc:oracle:thin:@//w4111b.cs.columbia.edu:1521/ADB");
ods.setUser(dbUser);
ods.setPassword(dbPassword);
Connection conn = ods.getConnection();
String query = new String();
Statement s = conn.createStatement();
query = "select * from events";
ResultSet r = s.executeQuery(query);
while (r.next()) {
out.println("Today's Date: " + r.getString(1) + " ");
}
r.close();
s.close();
conn.close();
} catch (Exception e) {
out.println("The database could not be accessed.<br>");
out.println("More information is available as follows:<br>");
e.printStackTrace(out);
}
} // end doGet method
// Needs a connection so it can fetch more stuff lazily
Copy(ResultSet rs) throws SQLException {
super();
copyId = rs.getInt("copy#");
bibId = rs.getInt("bib#");
note = rs.getString("pac_note");
location = rs.getString("location");
locationName = rs.getString("location_name");
collectionDescr = rs.getString("collection_descr");
collection = rs.getString("collection");
callNumber =
new CallNumber(
rs.getString("call_number"),
rs.getString("call_type"),
rs.getString("copy_number"),
rs.getString("call_type_hint"));
callType = rs.getString("call_type");
callTypeHint = rs.getString("call_type_hint");
callTypeName = rs.getString("call_type_name");
mediaType = rs.getString("media_type");
mediaTypeDescr = rs.getString("media_descr");
summaryOfHoldings = rs.getBoolean("summary_of_holdings");
itemType = rs.getString("itype");
itemTypeDescr = rs.getString("idescr");
}
public synchronized void service(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException {
try {
HttpSession dbSession = request.getSession();
ServletContext dbApplication = dbSession.getServletContext();
nseer_db_backup1 design_db = new nseer_db_backup1(dbApplication);
nseer_db_backup1 design_db1 = new nseer_db_backup1(dbApplication);
ValidataNumber validata = new ValidataNumber();
ValidataTag vt = new ValidataTag();
counter count = new counter(dbApplication);
if (design_db.conn((String) dbSession.getAttribute("unit_db_name"))
&& design_db1.conn((String) dbSession.getAttribute("unit_db_name"))) {
String config_id = request.getParameter("config_id");
String product_ID = request.getParameter("product_ID");
String choice = request.getParameter("choice");
String checker_ID = request.getParameter("checker_ID");
String checker = request.getParameter("checker");
String check_time = request.getParameter("check_time");
String sql6 =
"select id from design_workflow where type_id='02' and object_ID='"
+ product_ID
+ "' and ((check_tag='0' and config_id<'"
+ config_id
+ "') or (check_tag='1' and config_id='"
+ config_id
+ "'))";
ResultSet rs6 = design_db.executeQuery(sql6);
if (!rs6.next()
&& vt.validata(
(String) dbSession.getAttribute("unit_db_name"),
"design_file",
"product_ID",
product_ID,
"excel_tag")
.equals("1")) {
if (choice != null) {
if (choice.equals("")) {
String sql =
"update design_file set price_change_tag='9' where product_ID='"
+ product_ID
+ "'";
design_db.executeUpdate(sql);
sql =
"delete from design_workflow where type_id='02' and object_ID='"
+ product_ID
+ "'";
design_db.executeUpdate(sql);
} else {
sql6 =
"select id from design_workflow where type_id='02' and object_ID='"
+ product_ID
+ "' and config_id<'"
+ config_id
+ "' and config_id>='"
+ choice
+ "'";
rs6 = design_db.executeQuery(sql6);
while (rs6.next()) {
String sql =
"update design_workflow set check_tag='0' where type_id='02' and id='"
+ rs6.getString("id")
+ "'";
design_db1.executeUpdate(sql);
}
}
response.sendRedirect("design/price_change/check_delete_ok.jsp?finished_tag=0");
} else {
response.sendRedirect("design/price_change/check_delete_ok.jsp?finished_tag=1");
}
} else {
response.sendRedirect("design/price_change/check_delete_ok.jsp?finished_tag=2");
}
design_db.commit();
design_db1.commit();
design_db.close();
design_db1.close();
} else {
response.sendRedirect("error_conn.htm");
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
// 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
private List<LicenseData> getSearchByFieldResults(
String reseller, String parameter, String type) {
List<LicenseData> list = new ArrayList<LicenseData>();
Connection con = null;
try {
Statement pst = null;
con = getConnectiontoDB();
StringBuffer sql = new StringBuffer();
if (type.equalsIgnoreCase("sno")) {
sql.append(
" select distinct ib.item,o.orderkey,'1',so_header.so_number,so_header.end_user,TO_CHAR(TO_TIMESTAMP(so_header.ship_date/1000), 'YYYY-MM-DD'), ");
} else {
sql.append(
" select distinct so_item.item,so_item.entitlementkey,so_item.quantity,so_header.so_number,so_header.end_user,TO_CHAR(TO_TIMESTAMP(so_header.ship_date/1000), 'YYYY-MM-DD'), ");
}
sql.append(
"o.hmid, CASE TO_CHAR(TO_TIMESTAMP(o.substartdate/1000), 'YYYY-MM-DD') WHEN '1969-12-31' THEN '' WHEN TO_CHAR(TO_TIMESTAMP(o.subenddate/1000), 'YYYY-MM-DD') THEN '' ELSE TO_CHAR(TO_TIMESTAMP(o.substartdate/1000), 'YYYY-MM-DD') END, ");
sql.append(
"CASE TO_CHAR(TO_TIMESTAMP(o.subenddate/1000), 'YYYY-MM-DD') WHEN '1969-12-31' THEN '' WHEN TO_CHAR(TO_TIMESTAMP(o.substartdate/1000), 'YYYY-MM-DD') THEN '' ELSE TO_CHAR(TO_TIMESTAMP(o.subenddate/1000), 'YYYY-MM-DD') END, so_header.po_check_number,so_header.reseller, ");
sql.append(
" CASE WHEN so_item.producttype='Support' THEN TO_CHAR(TO_TIMESTAMP(o.startdate/1000), 'YYYY-MM-DD') ELSE '' END, ");
sql.append(
" CASE WHEN so_item.producttype='Support' THEN TO_CHAR(TO_TIMESTAMP(o.enddate/1000), 'YYYY-MM-DD') ELSE '' END ");
if (type.equalsIgnoreCase("sno")) {
sql.append(" ,ib.serialnumber");
sql.append(
" from ns.so_header so_header inner join ns.ib ib on ib.salesordernumber =so_header.so_number ");
sql.append(" inner join orderkey_information o on so_header.entitlement_key=o.orderkey");
sql.append(
" inner join ns.temp_so_item so_item on so_header.entitlement_key=so_item.entitlementkey");
} else {
sql.append(
" from ns.so_header so_header inner join ns.temp_so_item so_item on so_header.entitlement_key=so_item.entitlementkey ");
sql.append(" inner join orderkey_information o on so_header.entitlement_key=o.orderkey ");
}
if (type.equalsIgnoreCase("sno"))
sql.append(" where ib.serialnumber ILIKE '%" + parameter.trim() + "%' ");
if (type.equalsIgnoreCase("so"))
sql.append("where so_header.so_number='" + parameter.trim() + "' ");
if (type.equalsIgnoreCase("enduser"))
sql.append(
"where so_header.end_user ILIKE '%" + parameter.trim().replace("'", "''") + "%'");
if (type.equalsIgnoreCase("ek"))
sql.append("where so_header.entitlement_key ILIKE '%" + parameter.trim() + "%'");
if (type.equalsIgnoreCase("po"))
sql.append("where so_header.po_check_number ILIKE '%" + parameter.trim() + "%'");
if (type.equalsIgnoreCase("hm"))
sql.append("where o.hmid ILIKE '%" + parameter.trim() + "%'");
if (reseller != null && !reseller.isEmpty() && !reseller.equalsIgnoreCase("%admin%"))
sql.append(" and so_header.reseller ILIKE '" + reseller.trim() + "'");
if (type.equalsIgnoreCase("sno")) sql.append(" order by so_header.so_number desc ");
pst = con.createStatement();
ResultSet rs = pst.executeQuery(sql.toString());
log.info("Search Fields : SQL Query " + sql);
while (rs.next()) {
LicenseData data = new LicenseData();
data.setEntitlementKey(rs.getString(2));
data.setSku(rs.getString(1));
data.setQuantity(rs.getString(3));
data.setSoNumbber(rs.getString(4));
;
data.setEndUser(rs.getString(5));
data.setShipDate(rs.getString(6));
data.setHmId(rs.getString(7));
data.setLicenseStartDate(rs.getString(8));
data.setLicenseEndDate(rs.getString(9));
data.setPoNumber(rs.getString(10));
data.setNumber(rs.getString(4));
data.setBillingCustomer(rs.getString(11));
data.setSupportStartDate(rs.getString(12));
data.setSupportEndDate(rs.getString(13));
if (type.equalsIgnoreCase("sno")) data.setSerialNumber(rs.getString(14));
list.add(data);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return list;
}
@Override
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException {
// create the workbook, its worksheet, and its title row
Workbook workbook = new HSSFWorkbook();
Sheet sheet = workbook.createSheet("User table");
Row row = sheet.createRow(0);
row.createCell(0).setCellValue("The User table");
// create the header row
row = sheet.createRow(2);
row.createCell(0).setCellValue("UserID");
row.createCell(1).setCellValue("LastName");
row.createCell(2).setCellValue("FirstName");
row.createCell(3).setCellValue("Email");
try {
// read database rows
ConnectionPool pool = ConnectionPool.getInstance();
Connection connection = pool.getConnection();
Statement statement = connection.createStatement();
String query = "SELECT * FROM User ORDER BY UserID";
ResultSet results = statement.executeQuery(query);
// create spreadsheet rows
int i = 3;
while (results.next()) {
row = sheet.createRow(i);
row.createCell(0).setCellValue(results.getInt("UserID"));
row.createCell(1).setCellValue(results.getString("LastName"));
row.createCell(2).setCellValue(results.getString("FirstName"));
row.createCell(3).setCellValue(results.getString("Email"));
i++;
}
results.close();
statement.close();
connection.close();
} catch (SQLException e) {
this.log(e.toString());
}
// set response object headers
response.setHeader("content-disposition", "attachment; filename=users.xls");
response.setHeader("cache-control", "no-cache");
// get the output stream
String encodingString = request.getHeader("accept-encoding");
OutputStream out;
if (encodingString != null && encodingString.contains("gzip")) {
out = new GZIPOutputStream(response.getOutputStream());
response.setHeader("content-encoding", "gzip");
// System.out.println("User table encoded with gzip");
} else {
out = response.getOutputStream();
// System.out.println("User table not encoded with gzip");
}
// send the workbook to the browser
workbook.write(out);
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();
}
/** Business logic to execute. */
public final Response executeCommand(
Object inputPar,
UserSessionParameters userSessionPars,
HttpServletRequest request,
HttpServletResponse response,
HttpSession userSession,
ServletContext context) {
String serverLanguageId = ((JAIOUserSessionParameters) userSessionPars).getServerLanguageId();
Connection conn = null;
Statement stmt = null;
try {
conn = ConnectionManager.getConnection(context);
// fires the GenericEvent.CONNECTION_CREATED event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.CONNECTION_CREATED,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
null));
java.util.List list = (ArrayList) inputPar;
HierarItemDiscountVO vo = null;
ResultSet rset = null;
stmt = conn.createStatement();
for (int i = 0; i < list.size(); i++) {
vo = (HierarItemDiscountVO) list.get(i);
vo.setDiscountTypeSAL03(ApplicationConsts.DISCOUNT_CUSTOMER);
// retrieve COMPANY_CODE from progressiveHIE01...
rset =
stmt.executeQuery(
"select COMPANY_CODE_SYS01 from ITM02_ITEM_TYPES where PROGRESSIVE_HIE02 in "
+ "(select PROGRESSIVE_HIE02 from HIE01_LEVELS where PROGRESSIVE="
+ vo.getProgressiveHie01SAL05()
+ ")");
if (rset.next()) vo.setCompanyCodeSys01SAL03(rset.getString(1));
else {
rset.close();
conn.rollback();
return new ErrorResponse("Item hierarchy not found.");
}
rset.close();
DiscountBean.insertDiscount(conn, vo);
stmt.execute(
"insert into SAL05_ITEM_HIERAR_DISCOUNTS(COMPANY_CODE_SYS01,PROGRESSIVE_HIE01,DISCOUNT_CODE_SAL03) "
+ "values('"
+ vo.getCompanyCodeSys01SAL03()
+ "',"
+ vo.getProgressiveHie01SAL05()
+ ",'"
+ vo.getDiscountCodeSAL03()
+ "')");
}
Response answer = new VOListResponse(list, false, list.size());
// fires the GenericEvent.BEFORE_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.BEFORE_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
conn.commit();
// fires the GenericEvent.AFTER_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.AFTER_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
return answer;
} catch (Throwable ex) {
Logger.error(
userSessionPars.getUsername(),
this.getClass().getName(),
"executeCommand",
"Error while inserting hierarchy item discounts",
ex);
try {
conn.rollback();
} catch (Exception ex3) {
}
return new ErrorResponse(ex.getMessage());
} finally {
try {
stmt.close();
} catch (Exception ex2) {
}
try {
ConnectionManager.releaseConnection(conn, context);
} catch (Exception ex1) {
}
}
}
public synchronized void service(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException {
HttpSession dbSession = request.getSession();
JspFactory _jspxFactory = JspFactory.getDefaultFactory();
PageContext pageContext =
_jspxFactory.getPageContext(this, request, response, "", true, 8192, true);
ServletContext dbApplication = dbSession.getServletContext();
try {
HttpSession session = request.getSession();
PrintWriter out = response.getWriter();
nseer_db_backup1 fund_db = new nseer_db_backup1(dbApplication);
nseer_db_backup1 fund_db1 = new nseer_db_backup1(dbApplication);
if (fund_db.conn((String) dbSession.getAttribute("unit_db_name"))
&& fund_db1.conn((String) dbSession.getAttribute("unit_db_name"))) {
counter count = new counter(dbApplication);
ValidataRecordNumber vrn = new ValidataRecordNumber();
ValidataTag vt = new ValidataTag();
ValidataNumber validata = new ValidataNumber();
try {
String time = "";
java.util.Date now = new java.util.Date();
SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd");
time = formatter.format(now);
String apply_pay_ID = request.getParameter("apply_pay_ID");
String register_time = request.getParameter("register_time");
String register = request.getParameter("register");
String register_ID = request.getParameter("register_ID");
String bodyc = new String(request.getParameter("remark").getBytes("UTF-8"), "UTF-8");
String remark = exchange.toHtml(bodyc);
String amount = request.getParameter("amount");
String[] file_kind = request.getParameterValues("file_kind");
String[] cost_price_subtotal = request.getParameterValues("cost_price_subtotal");
int p = 0;
String file_kinda = ",";
for (int j = 1; j < file_kind.length; j++) {
file_kinda += file_kind[j] + ",";
if (cost_price_subtotal[j].equals("")) cost_price_subtotal[j] = "0";
StringTokenizer tokenTO4 = new StringTokenizer(cost_price_subtotal[j], ",");
String cost_price_subtotal1 = "";
while (tokenTO4.hasMoreTokens()) {
cost_price_subtotal1 += tokenTO4.nextToken();
}
if (!validata.validata(cost_price_subtotal1)) {
p++;
}
}
int n = 0;
for (int i = 1; i <= Integer.parseInt(amount); i++) {
String tem_file_kind = "file_kind" + i;
String file_kind2 = request.getParameter(tem_file_kind);
if (file_kinda.indexOf(file_kind2) != -1) n++;
}
if (n == 0) {
if (p == 0) {
if (vt.validata(
(String) dbSession.getAttribute("unit_db_name"),
"fund_apply_pay",
"apply_pay_ID",
apply_pay_ID,
"check_tag")
.equals("5")
|| vt.validata(
(String) dbSession.getAttribute("unit_db_name"),
"fund_apply_pay",
"apply_pay_ID",
apply_pay_ID,
"check_tag")
.equals("9")) {
String currency_name = "";
String personal_unit = "";
String chain_ID = "";
String chain_name = "";
String funder = "";
String funder_ID = "";
String sql11 =
"select * from fund_apply_pay where apply_pay_ID='" + apply_pay_ID + "'";
ResultSet rs11 = fund_db.executeQuery(sql11);
while (rs11.next()) {
chain_ID = rs11.getString("chain_ID");
chain_name = rs11.getString("chain_name");
funder = rs11.getString("human_name");
funder_ID = rs11.getString("human_ID");
currency_name = rs11.getString("currency_name");
personal_unit = rs11.getString("personal_unit");
}
int expenses_amount = 0;
String sql6 =
"select count(*) from fund_apply_pay_details where apply_pay_ID='"
+ apply_pay_ID
+ "'";
ResultSet rs6 = fund_db.executeQuery(sql6);
if (rs6.next()) {
expenses_amount = rs6.getInt("count(*)");
}
double demand_cost_price_sum = 0.0d;
for (int i = 1; i <= expenses_amount; i++) {
String tem_cost_price_subtotal = "cost_price_subtotal" + i;
String cost_price_subtotal2 = request.getParameter(tem_cost_price_subtotal);
demand_cost_price_sum += Double.parseDouble(cost_price_subtotal2);
sql6 =
"update fund_apply_pay_details set cost_price_subtotal='"
+ cost_price_subtotal2
+ "' where apply_pay_ID='"
+ apply_pay_ID
+ "' and details_number='"
+ i
+ "'";
fund_db.executeUpdate(sql6);
}
for (int i = 1; i < file_kind.length; i++) {
StringTokenizer tokenTO1 = new StringTokenizer(file_kind[i], "/");
String file_chain_ID = "";
String file_chain_name = "";
while (tokenTO1.hasMoreTokens()) {
file_chain_ID = tokenTO1.nextToken();
file_chain_name = tokenTO1.nextToken();
}
StringTokenizer tokenTO4 = new StringTokenizer(cost_price_subtotal[i], ",");
String cost_price_subtotal1 = "";
while (tokenTO4.hasMoreTokens()) {
cost_price_subtotal1 += tokenTO4.nextToken();
}
demand_cost_price_sum += Double.parseDouble(cost_price_subtotal1);
expenses_amount++;
String sql1 =
"insert into fund_apply_pay_details(apply_pay_ID,details_number,file_chain_ID,file_chain_name,cost_price_subtotal) values ('"
+ apply_pay_ID
+ "','"
+ expenses_amount
+ "','"
+ file_chain_ID
+ "','"
+ file_chain_name
+ "','"
+ cost_price_subtotal1
+ "')";
fund_db.executeUpdate(sql1);
}
String sql =
"update fund_apply_pay set demand_cost_price_sum='"
+ demand_cost_price_sum
+ "',check_tag='2',register_time='"
+ register_time
+ "',register='"
+ register
+ "',remark='"
+ remark
+ "' where apply_pay_ID='"
+ apply_pay_ID
+ "'";
fund_db.executeUpdate(sql);
response.sendRedirect("draft/fund/applyPayExpenses_ok.jsp?finished_tag=2");
} else {
response.sendRedirect("draft/fund/applyPayExpenses_ok.jsp?finished_tag=3");
}
} else {
response.sendRedirect("draft/fund/applyPayExpenses_ok.jsp?finished_tag=6");
}
} else {
response.sendRedirect("draft/fund/applyPayExpenses_ok.jsp?finished_tag=7");
}
} catch (Exception ex) {
ex.printStackTrace();
}
fund_db.commit();
fund_db1.commit();
fund_db.close();
fund_db1.close();
} else {
response.sendRedirect("error_conn.htm");
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
public synchronized void service(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException {
HttpSession dbSession = request.getSession();
JspFactory _jspxFactory = JspFactory.getDefaultFactory();
PageContext pageContext =
_jspxFactory.getPageContext(this, request, response, "", true, 8192, true);
ServletContext dbApplication = dbSession.getServletContext();
try {
// 实例化
HttpSession session = request.getSession();
ServletContext context = session.getServletContext();
String path = context.getRealPath("/");
counter count = new counter(dbApplication);
SmartUpload mySmartUpload = new SmartUpload();
mySmartUpload.setCharset("UTF-8");
nseer_db_backup1 qcs_db = new nseer_db_backup1(dbApplication);
if (qcs_db.conn((String) dbSession.getAttribute("unit_db_name"))) {
mySmartUpload.initialize(pageContext);
String file_type = getFileLength.getFileType((String) session.getAttribute("unit_db_name"));
long d = getFileLength.getFileLength((String) session.getAttribute("unit_db_name"));
mySmartUpload.setMaxFileSize(d);
mySmartUpload.setAllowedFilesList(file_type);
try {
mySmartUpload.upload();
String qcs_id = mySmartUpload.getRequest().getParameter("qcs_id");
String config_id = mySmartUpload.getRequest().getParameter("config_id");
String[] item = mySmartUpload.getRequest().getParameterValues("item");
if (item != null) {
String[] file_name = new String[mySmartUpload.getFiles().getCount()];
String[] not_change = new String[mySmartUpload.getFiles().getCount()];
java.util.Date now = new java.util.Date();
SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd");
String time = formatter.format(now);
String standard_id = mySmartUpload.getRequest().getParameter("standard_id");
String sqla =
"select attachment1 from qcs_intrmanufacture where qcs_id='"
+ qcs_id
+ "' and (check_tag='5' or check_tag='9')";
ResultSet rs = qcs_db.executeQuery(sqla);
if (!rs.next()) {
response.sendRedirect("draft/qcs/intrmanufacture_ok.jsp?finished_tag=1");
} else {
String[] attachment = mySmartUpload.getRequest().getParameterValues("attachment");
String[] delete_file_name = new String[0];
if (attachment != null) {
delete_file_name = new String[attachment.length];
for (int i = 0; i < attachment.length; i++) {
delete_file_name[i] = rs.getString(attachment[i]);
}
}
for (int i = 0; i < mySmartUpload.getFiles().getCount(); i++) {
com.jspsmart.upload.SmartFile file = mySmartUpload.getFiles().getFile(i);
if (file.isMissing()) {
file_name[i] = "";
int q = i + 1;
String field_name = "attachment" + q;
if (!rs.getString(field_name).equals("")) not_change[i] = "yes";
continue;
}
int filenum =
count.read(
(String) dbSession.getAttribute("unit_db_name"), "qcsAttachmentcount");
count.write(
(String) dbSession.getAttribute("unit_db_name"), "qcsAttachmentcount", filenum);
file_name[i] = filenum + file.getFileName();
file.saveAs(path + "qcs/file_attachments/" + filenum + file.getFileName());
}
String apply_id = mySmartUpload.getRequest().getParameter("apply_id");
String product_id = mySmartUpload.getRequest().getParameter("product_id");
String product_name = mySmartUpload.getRequest().getParameter("product_name");
String qcs_amount = mySmartUpload.getRequest().getParameter("qcs_amount");
String qcs_time = mySmartUpload.getRequest().getParameter("qcs_time");
String quality_way = mySmartUpload.getRequest().getParameter("quality_way");
String quality_solution = mySmartUpload.getRequest().getParameter("quality_solution");
String sampling_standard =
mySmartUpload.getRequest().getParameter("sampling_standard");
String sampling_amount = mySmartUpload.getRequest().getParameter("sampling_amount");
String accept = mySmartUpload.getRequest().getParameter("accept");
String reject = mySmartUpload.getRequest().getParameter("reject");
String qualified = mySmartUpload.getRequest().getParameter("qualified");
String unqualified = mySmartUpload.getRequest().getParameter("unqualified");
String qcs_result = mySmartUpload.getRequest().getParameter("qcs_result");
String checker = mySmartUpload.getRequest().getParameter("checker");
String checker_id = mySmartUpload.getRequest().getParameter("checker_id");
String check_time = mySmartUpload.getRequest().getParameter("check_time");
String changer = mySmartUpload.getRequest().getParameter("changer");
String changer_id = mySmartUpload.getRequest().getParameter("changer_id");
String change_time = mySmartUpload.getRequest().getParameter("change_time");
String bodyab =
new String(
mySmartUpload.getRequest().getParameter("remark").getBytes("UTF-8"), "UTF-8");
String remark = exchange.toHtml(bodyab);
sqla =
"update qcs_intrmanufacture set apply_id='"
+ apply_id
+ "',product_id='"
+ product_id
+ "',product_name='"
+ product_name
+ "',qcs_amount='"
+ qcs_amount
+ "',qcs_time='"
+ qcs_time
+ "',quality_way='"
+ quality_way
+ "',quality_solution='"
+ quality_solution
+ "',sampling_standard='"
+ sampling_standard
+ "',sampling_amount='"
+ sampling_amount
+ "',accept='"
+ accept
+ "',reject='"
+ reject
+ "',qualified='"
+ qualified
+ "',unqualified='"
+ unqualified
+ "',changer_id='"
+ changer_id
+ "',qcs_result='"
+ qcs_result
+ "',changer='"
+ changer
+ "',change_time='"
+ change_time
+ "',remark='"
+ remark
+ "',check_tag='5'";
String sqlb = " where qcs_id='" + qcs_id + "'";
if (attachment != null) {
for (int i = 0; i < attachment.length; i++) {
sqla = sqla + "," + attachment[i] + "=''";
java.io.File file =
new java.io.File(path + "qcs/file_attachments/" + delete_file_name[i]);
file.delete();
}
}
for (int i = 0; i < mySmartUpload.getFiles().getCount(); i++) {
if (not_change[i] != null && not_change[i].equals("yes")) continue;
int p = i + 1;
sqla = sqla + ",attachment" + p + "='" + file_name[i] + "'";
}
String sql = sqla + sqlb;
qcs_db.executeUpdate(sql);
sql = "delete from qcs_intrmanufacture_details where qcs_id='" + qcs_id + "'";
qcs_db.executeUpdate(sql);
String[] default_basis =
mySmartUpload.getRequest().getParameterValues("default_basis");
String[] ready_basis = mySmartUpload.getRequest().getParameterValues("ready_basis");
String[] quality_method =
mySmartUpload.getRequest().getParameterValues("quality_method");
String[] analyse_method =
mySmartUpload.getRequest().getParameterValues("analyse_method");
String[] standard_value =
mySmartUpload.getRequest().getParameterValues("standard_value");
String[] standard_max = mySmartUpload.getRequest().getParameterValues("standard_max");
String[] standard_min = mySmartUpload.getRequest().getParameterValues("standard_min");
String[] quality_value =
mySmartUpload.getRequest().getParameterValues("quality_value");
String[] sampling_amount_d =
mySmartUpload.getRequest().getParameterValues("sampling_amount_d");
String[] qualified_d = mySmartUpload.getRequest().getParameterValues("qualified_d");
String[] unqualified_d =
mySmartUpload.getRequest().getParameterValues("unqualified_d");
String[] quality_result =
mySmartUpload.getRequest().getParameterValues("quality_result");
String[] unqualified_reason =
mySmartUpload.getRequest().getParameterValues("unqualified_reason");
for (int i = 0; i < item.length; i++) {
if (!item[i].equals("")) {
sql =
"insert into qcs_intrmanufacture_details(qcs_id,item,default_basis,ready_basis,quality_method,analyse_method,standard_value,standard_max,standard_min,quality_value,sampling_amount_d,qualified_d,unqualified_d,quality_result,unqualified_reason,details_number) values('"
+ qcs_id
+ "','"
+ item[i]
+ "','"
+ default_basis[i]
+ "','"
+ ready_basis[i]
+ "','"
+ quality_method[i]
+ "','"
+ analyse_method[i]
+ "','"
+ standard_value[i]
+ "','"
+ standard_max[i]
+ "','"
+ standard_min[i]
+ "','"
+ quality_value[i]
+ "','"
+ sampling_amount_d[i]
+ "','"
+ qualified_d[i]
+ "','"
+ unqualified_d[i]
+ "','"
+ quality_result[i]
+ "','"
+ unqualified_reason[i]
+ "','"
+ i
+ "')";
qcs_db.executeUpdate(sql);
}
}
response.sendRedirect("draft/qcs/intrmanufacture_ok.jsp?finished_tag=0");
}
qcs_db.commit();
qcs_db.close();
} else {
response.sendRedirect("draft/qcs/intrmanufacture_ok.jsp?finished_tag=7");
}
} catch (Exception ex) {
response.sendRedirect("draft/qcs/intrmanufacture_ok.jsp?finished_tag=6");
}
} else {
response.sendRedirect("error_conn.htm");
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException {
HttpSession dbSession = request.getSession();
JspFactory _jspxFactory = JspFactory.getDefaultFactory();
PageContext pageContext =
_jspxFactory.getPageContext(this, request, response, "", true, 8192, true);
ServletContext dbApplication = dbSession.getServletContext();
try {
PrintWriter out = response.getWriter();
session = request.getSession();
counter count = new counter(dbApplication);
ValidataNumber validata = new ValidataNumber();
ValidataRecord vr = new ValidataRecord();
ValidataTag vt = new ValidataTag();
getNameFromID getNameFromID = new getNameFromID();
getRateFromID getRateFromID = new getRateFromID();
nseer_db_backup1 purchase_db = new nseer_db_backup1(dbApplication);
if (purchase_db.conn((String) dbSession.getAttribute("unit_db_name"))) {
String register_ID = (String) session.getAttribute("human_IDD");
String config_id = request.getParameter("config_id");
String discussion_ID = request.getParameter("discussion_ID");
String provider_ID = request.getParameter("provider_ID");
String provider_name = request.getParameter("provider_name");
String demand_contact_person = request.getParameter("demand_contact_person");
String demand_contact_person_tel = request.getParameter("demand_contact_person_tel");
String demand_contact_person_fax = request.getParameter("demand_contact_person_fax");
String demand_pay_time = request.getParameter("demand_pay_time");
String check_time = request.getParameter("check_time");
String checker = request.getParameter("checker");
String checker_ID = request.getParameter("checker_ID");
String bodyc = new String(request.getParameter("remark").getBytes("UTF-8"), "UTF-8");
String remark = exchange.toHtml(bodyc);
String modify_tag = request.getParameter("modify_tag");
String product_amount = request.getParameter("product_amount");
int num = Integer.parseInt(product_amount);
int n = 0;
for (int i = 1; i <= num; i++) {
String tem_amount = "amount" + i;
String tem_off_discount = "off_discount" + i;
String tem_list_price = "list_price" + i;
String amount = request.getParameter(tem_amount);
String off_discount = request.getParameter(tem_off_discount);
String list_price2 = request.getParameter(tem_list_price);
StringTokenizer tokenTO2 = new StringTokenizer(list_price2, ",");
String list_price = "";
while (tokenTO2.hasMoreTokens()) {
String list_price1 = tokenTO2.nextToken();
list_price += list_price1;
}
if (!validata.validata(amount)
|| !validata.validata(off_discount)
|| !validata.validata(list_price)) {
n++;
}
}
String sql6 =
"select id from purchase_workflow where object_ID='"
+ discussion_ID
+ "' and ((check_tag='0' and config_id<'"
+ config_id
+ "') or (check_tag='1' and config_id='"
+ config_id
+ "'))";
ResultSet rs6 = purchase_db.executeQuery(sql6);
if (!rs6.next()) {
if (vt.validata(
(String) dbSession.getAttribute("unit_db_name"),
"purchase_discussion",
"discussion_ID",
discussion_ID,
"check_tag")
.equals("0")) {
if (n == 0) {
String time = "";
java.util.Date now = new java.util.Date();
SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd");
time = formatter.format(now);
String sql =
"update purchase_discussion set discussion_ID='"
+ discussion_ID
+ "',provider_ID='"
+ provider_ID
+ "',provider_name='"
+ provider_name
+ "',demand_contact_person='"
+ demand_contact_person
+ "',demand_contact_person_tel='"
+ demand_contact_person_tel
+ "',demand_contact_person_fax='"
+ demand_contact_person_fax
+ "',check_time='"
+ check_time
+ "',checker='"
+ checker
+ "',checker_ID='"
+ checker_ID
+ "',remark='"
+ remark
+ "' where discussion_ID='"
+ discussion_ID
+ "'";
purchase_db.executeUpdate(sql);
try {
int service_count = 0;
int stock_number = 0;
int pay_amount_sum = 0;
double sale_price_sum = 0.0d;
double cost_price_sum = 0.0d;
double real_cost_price_sum = 0.0d;
for (int i = 1; i <= num; i++) {
String tem_product_name = "product_name" + i;
String tem_product_ID = "product_ID" + i;
String tem_product_describe = "product_describe" + i;
String tem_amount = "amount" + i;
String tem_off_discount = "off_discount" + i;
String tem_list_price = "list_price" + i;
String tem_cost_price = "cost_price" + i;
String tem_real_cost_price = "real_cost_price" + i;
String tem_amount_unit = "amount_unit" + i;
String product_name = request.getParameter(tem_product_name);
String product_ID = request.getParameter(tem_product_ID);
String product_describe = request.getParameter(tem_product_describe);
String amount1 = request.getParameter(tem_amount);
String off_discount = request.getParameter(tem_off_discount);
String list_price2 = request.getParameter(tem_list_price);
StringTokenizer tokenTO2 = new StringTokenizer(list_price2, ",");
String list_price = "";
while (tokenTO2.hasMoreTokens()) {
String list_price1 = tokenTO2.nextToken();
list_price += list_price1;
}
String cost_price2 = request.getParameter(tem_cost_price);
StringTokenizer tokenTO3 = new StringTokenizer(cost_price2, ",");
String cost_price = "";
while (tokenTO3.hasMoreTokens()) {
String cost_price1 = tokenTO3.nextToken();
cost_price += cost_price1;
}
String real_cost_price2 = request.getParameter(tem_real_cost_price);
StringTokenizer tokenTO4 = new StringTokenizer(real_cost_price2, ",");
String real_cost_price = "";
while (tokenTO4.hasMoreTokens()) {
String real_cost_price1 = tokenTO4.nextToken();
real_cost_price += real_cost_price1;
}
String amount_unit = request.getParameter(tem_amount_unit);
double amount = 0.0d;
double subtotal =
Double.parseDouble(list_price)
* (1 - Double.parseDouble(off_discount) / 100)
* Double.parseDouble(amount1);
double cost_price_after_discount_sum =
Double.parseDouble(cost_price) * Double.parseDouble(amount1);
double real_cost_price_after_discount_sum =
Double.parseDouble(real_cost_price) * Double.parseDouble(amount1);
sale_price_sum += subtotal;
cost_price_sum += cost_price_after_discount_sum;
real_cost_price_sum += real_cost_price_after_discount_sum;
double order_sale_bonus_subtotal =
getRateFromID.getRateFromID(
(String) dbSession.getAttribute("unit_db_name"),
"design_file",
"product_ID",
product_ID,
"order_sale_bonus_rate")
* subtotal
/ 100;
double order_profit_bonus_subtotal = 0.0d;
String sql1 =
"update purchase_discussion_details set product_ID='"
+ product_ID
+ "',product_name='"
+ product_name
+ "',product_describe='"
+ product_describe
+ "',list_price='"
+ list_price
+ "',amount='"
+ amount1
+ "',cost_price='"
+ cost_price
+ "',off_discount='"
+ off_discount
+ "',subtotal='"
+ subtotal
+ "' where discussion_ID='"
+ discussion_ID
+ "' and details_number='"
+ i
+ "'";
purchase_db.executeUpdate(sql1);
String product_type = "";
String sql16 = "select * from design_file where product_ID='" + product_ID + "'";
ResultSet rs16 = purchase_db.executeQuery(sql16);
if (rs16.next()) {
product_type = rs16.getString("type");
}
if (product_type.equals("物料") || product_type.equals("外购商品")) {
stock_number += 1;
} else if (product_type.equals("商品")
|| product_type.equals("部件")
|| product_type.equals("委外部件")) {
stock_number += 1;
} else if (product_type.equals("服务型产品")) {
service_count++;
}
}
String sql2 =
"update purchase_workflow set checker='"
+ checker
+ "',checker_ID='"
+ checker_ID
+ "',check_time='"
+ check_time
+ "',check_tag='1' where object_ID='"
+ discussion_ID
+ "' and config_id='"
+ config_id
+ "'";
purchase_db.executeUpdate(sql2);
sql2 =
"select id from purchase_workflow where object_ID='"
+ discussion_ID
+ "' and check_tag='0'";
ResultSet rset = purchase_db.executeQuery(sql2);
if (!rset.next()) {
sql2 =
"update purchase_discussion set sale_price_sum='"
+ sale_price_sum
+ "',cost_price_sum='"
+ cost_price_sum
+ "',modify_tag='0',discussion_tag='1',discussion_status='等待',check_tag='1' where discussion_ID='"
+ discussion_ID
+ "'";
purchase_db.executeUpdate(sql2);
} else {
sql2 =
"update purchase_discussion set sale_price_sum='"
+ sale_price_sum
+ "',cost_price_sum='"
+ cost_price_sum
+ "',modify_tag='0' where discussion_ID='"
+ discussion_ID
+ "'";
purchase_db.executeUpdate(sql2);
}
} catch (Exception ex) {
ex.printStackTrace();
}
response.sendRedirect(
"purchase/discussion/check_choose_attachment.jsp?discussion_ID="
+ discussion_ID
+ "");
} else {
response.sendRedirect("purchase/discussion/check_ok.jsp?finished_tag=0");
}
} else {
response.sendRedirect("purchase/discussion/check_ok.jsp?finished_tag=1");
}
} else {
response.sendRedirect("purchase/discussion/check_ok.jsp?finished_tag=2");
}
purchase_db.commit();
purchase_db.close();
} else {
response.sendRedirect("error_conn.htm");
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
public void doPost (HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
{
Connection con=null;
pw=res.getWriter();
Statement stmt=null;
ResultSet rr=null;
ResultSetMetaData rsmd;
res.setContentType("text/html");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:sri","scott","tiger");
stmt=con.createStatement();
String inm="'"+req.getParameter("txtinm")+"'";
String q="'"+req.getParameter("txtq")+"'";
String t=req.getParameter("txtr");
char type=t.charAt(0);
System.out.println((char)type);
pw.println("Item name "+inm);
pw.println("Quantity "+q);
pw.println("Item Type "+t);
pw.println((char)type);
String qry1=null;
switch(type)
{
case 'H':
case 'h':
qry1="select rate,iname from hware where iname="+inm;
pw.println(qry1);
// rr=stmt.executeQuery("select rate from hware where iname="+inm);
rr=stmt.executeQuery(qry1);
pw.println("Query is Executed...");
break;
case 'S':
case 's': qry1="select rate,iname from sware where iname="+inm;
pw.println(qry1);
break;
case 'M':
case 'm': rr=stmt.executeQuery("select rate,title from music where title="+inm);
break;
case 'B':
case 'b': rr=stmt.executeQuery("select rate,title from books where title="+inm);
break;
default:
{
pw.println("Invalid choice");
myflag='n';
}
}
pw.println("Concerned Statement Prepared and Executed...");
pw.println((char)type+" Valid item type "+myflag);
/*rsmd=rr.getMetaData();
int col=rsmd.getColumnCount();
pw.println("The Above Query has fetched "+col+ " Columns");*/
String name="";
while(rr.next())
{
String rate=rr.getString(1);
int amount=Integer.parseInt(rate);
name=rr.getString(2);
System.out.println(" "+rate+" "+name);
pw.println(" "+amount+" "+name);
pw.println("\n"+myflag);
System.out.println("Valid item name "+rr.getString(2)+" "+myflag);
}
pw.println(" "+myflag);
if(myflag=='y')
{
pw.println("\nOK");
pw.println("Valid item name "+name+" "+myflag);
if(rr==null)
{
pw.println("Not a valid item");
myflag='n';
}
pw.println("Valid item name "+name+" "+myflag);
if(myflag=='y')
{
pw.println(" "+inm+" "+q);
rr=stmt.executeQuery("select * from reges where flag='y'");
if(rr==null)
{
pw.println("\nSign in first");
//System.exit(0);
myflag='n';
}
pw.println("Signed in "+rr.getString(1)+" "+myflag);
if(myflag=='y')
{
String data="'"+rr.getString(1)+"'";
String qry="insert into cart values("+inm+","+q+","+data+")";
pw.println("Query is "+qry);
int rs=stmt.executeUpdate(qry);
pw.println("1 row inserted");
}
}
}
}
catch(ClassNotFoundException e){}
catch(SQLException e){}
}
public void _jspService(
final javax.servlet.http.HttpServletRequest request,
final javax.servlet.http.HttpServletResponse response)
throws java.io.IOException, javax.servlet.ServletException {
final javax.servlet.jsp.PageContext pageContext;
javax.servlet.http.HttpSession session = null;
final javax.servlet.ServletContext application;
final javax.servlet.ServletConfig config;
javax.servlet.jsp.JspWriter out = null;
final java.lang.Object page = this;
javax.servlet.jsp.JspWriter _jspx_out = null;
javax.servlet.jsp.PageContext _jspx_page_context = null;
try {
response.setContentType("text/html");
pageContext =
_jspxFactory.getPageContext(
this,
request,
response,
"ReportErrorPage.jsp?page=EditTargetReportForm.jsp",
true,
8192,
true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
org.apache.jasper.runtime.JspRuntimeLibrary.include(
request, response, "header.jsp", out, false);
out.write(' ');
out.write('\n');
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\t<!-- files for JqxWidget grid -->\n");
out.write(
" <link rel=\"stylesheet\" href=\"js/jqwidgets/styles/jqx.base.css\" type=\"text/css\" />\n");
out.write(
" <link rel=\"stylesheet\" href=\"js/jqwidgets/styles/jqx.darkblue.css\" type=\"text/css\" />\n");
out.write(
"\t<link rel=\"stylesheet\" href=\"js/jqwidgets/styles/jqx.ui-redmond.css\" type=\"text/css\" />\n");
out.write("\t\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/gettheme.js\"></script>\n");
out.write("\t<script type=\"text/javascript\" src=\"js/jquery-1.10.2.min.js\"></script>\n");
out.write(" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxcore.js\"></script>\n");
out.write(" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxdata.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxbuttons.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxscrollbar.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxlistbox.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxcalendar.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxdatetimeinput.js\"></script>\n");
out.write(" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.filter.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.selection.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.sort.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.pager.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxmenu.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxlistbox.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxdropdownlist.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxdata.export.js\"></script> \n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.export.js\"></script> \n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.aggregates.js\"></script> \n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.grouping.js\"></script> \n");
out.write("\n");
out.write("\n");
out.write("\t\n");
out.write("\t");
session.getAttribute("UserName").toString();
// System.out.println("session bachka maapping : "+session +" \n user
// "+session.getAttribute("UserName").toString());
out.write("\n");
out.write("\n");
out.write("\n");
out.write("<script src=\"js/editCustomer_details.js\"> </script> \n");
out.write("\n");
out.write("<script type=\"text/javascript\" src=\"js/popup.js\"></script>\n");
out.write("<style>\n");
out.write("hr {\n");
out.write("color: #f00;\n");
out.write("background-color: #f00;\n");
out.write("height: 3px;\n");
out.write("}\n");
out.write("#selected_order{\n");
out.write("width: 40%;\n");
out.write("max-height: 300px;\n");
out.write("border: 1px solid black; \n");
out.write("background-color: #ECFB99;\n");
out.write("float: right;\n");
out.write("margin-top: 30px;\n");
out.write("overflow: auto;\n");
out.write("margin-right: 2%;\n");
out.write("padding: 5px;\n");
out.write("}\n");
out.write("</style>\n");
out.write("<script>\n");
out.write("\t\n");
out.write("\tfunction checkField(){\n");
out.write("\t\tif(document.myform.chckall.checked==true){\n");
out.write("\t\t\tshowHint();\n");
out.write("\t\t}\n");
out.write("\t\telse{\t\tvar c_date1,c_date2,u_date2,u_date1;\n");
out.write("\t\t\t\tif(!($(\"#createDate2\").jqxDateTimeInput('disabled'))){\n");
out.write("\t\t\t\tc_date1 = $('#createDate1').jqxDateTimeInput('getText');\n");
out.write("\t\t\t\tc_date2 = $('#createDate2').jqxDateTimeInput('getText');\n");
out.write("\t\t\t}\n");
out.write("\t\t\t\n");
out.write("\t\t\tif(!($(\"#updateDate2\").jqxDateTimeInput('disabled'))){\n");
out.write("\t\t\t\tu_date1 = $('#updateDate1').jqxDateTimeInput('getText');\n");
out.write("\t\t\t\tu_date2 = $('#updateDate2').jqxDateTimeInput('getText');\n");
out.write("\t\t\t}\t \n");
out.write("\t\t showHint();\t\t \n");
out.write("\t }\n");
out.write("\t}\n");
out.write("\tfunction showMsg(){\n");
out.write("\t \t document.myform.action=\"HomeForm.jsp\";\n");
out.write("\t \t document.myform.submit();\n");
out.write("\t}\n");
out.write("\tfunction Clear(){\n");
out.write("\t\t\n");
out.write("\t\ttry{\n");
out.write("\t\t\tdocument.getElementById(\"order_number\").focus();\n");
out.write("\t\t} catch (exp){}\n");
out.write("\t\t\n");
out.write("\t\t\n");
out.write("\t\t\n");
out.write("\t\tdocument.myform.custCode.value=\"\";\n");
out.write("\t\tdocument.myform.phonenumber.value=\"\";\n");
out.write("\t\tdocument.myform.custName.value=\"\";\n");
out.write("\t\tdocument.myform.nameString.value=\"\";\t\t\n");
out.write("\t\tdocument.myform.Building.value=\"\";\n");
out.write("\t\tdocument.myform.Building_no.value=\"\";\n");
out.write("\t\tdocument.myform.wing.value=\"\";\n");
out.write("\t\tdocument.myform.block.value=\"\";\n");
out.write("\t\tdocument.myform.add1.value=\"\";\n");
out.write("\t\tdocument.myform.add2.value=\"\";\n");
out.write("\t\tdocument.myform.area.value=\"\";\n");
out.write("\t\tdocument.myform.station.value=\"\";\n");
out.write("\t\t\n");
out.write("\t\tdocument.myform.selmonth.value=\"\";\n");
out.write("\t\t\n");
out.write(
"\t\t$(\"#createDate1\").jqxDateTimeInput({theme:'ui-redmond',width: '250px', height: '25px',max:new Date(),formatString: \"yyyy-MM-dd\"});\n");
out.write(
"\t\t$(\"#createDate2\").jqxDateTimeInput({theme:'ui-redmond',width: '250px', height: '25px',min:new Date(),max:new Date(),formatString: \"yyyy-MM-dd\",value:new Date()});\n");
out.write("\t\t$(\"#createDate2\").jqxDateTimeInput({disabled: true});\n");
out.write("\t\t\n");
out.write("\t\t\n");
out.write(
"\t\t$(\"#updateDate1\").jqxDateTimeInput({theme:'ui-redmond',width: '250px', height: '25px',max:new Date(),formatString: \"yyyy-MM-dd\"});\n");
out.write(
"\t\t$(\"#updateDate2\").jqxDateTimeInput({theme:'ui-redmond',width: '250px', height: '25px',min:new Date(),max:new Date(),formatString: \"yyyy-MM-dd\",value:new Date()});\n");
out.write("\t\t$(\"#updateDate2\").jqxDateTimeInput({disabled: true});\n");
out.write("\t\t\n");
out.write("\t\t$('#createDate1').on('close', function (event) {\n");
out.write("\t\t // Some code here. \n");
out.write("\t\t \t$(\"#createDate2\").jqxDateTimeInput({disabled: false});\n");
out.write(
"\t\t \t$(\"#createDate2\").jqxDateTimeInput({min: $('#createDate1').jqxDateTimeInput('getDate')});\n");
out.write(" \t\t}); \t\n");
out.write(" \t\t\n");
out.write(" \t\t$('#updateDate1').on('close', function (event) {\n");
out.write("\t\t // Some code here. \n");
out.write("\t\t \t$(\"#updateDate2\").jqxDateTimeInput({disabled: false});\n");
out.write(
"\t\t \t$(\"#updateDate2\").jqxDateTimeInput({min: $('#updateDate1').jqxDateTimeInput('getDate')});\n");
out.write(" \t\t}); \t\n");
out.write("\t\t\n");
out.write("\t\tfunEnabled();\n");
out.write("\t}\n");
out.write("\t\n");
out.write("function ckeckEmpty(){\n");
out.write("\tif(document.getElementById(\"order_number\").value == \"\"){\n");
out.write("\t\talert(\"Please Enter Order Number\");\n");
out.write("\t\tdocument.getElementById(\"order_number\").focus();\n");
out.write("\t\treturn false;\n");
out.write("\t} else {\n");
out.write("\t\treturn true;\n");
out.write("\t}\n");
out.write("}\n");
out.write("\n");
out.write("\n");
out.write("</script>\n");
String call_type = request.getParameter("call_type");
if (call_type == null) {
call_type = "";
}
if (call_type.equals("search_payment")) {
String m = "<< Show List";
out.write("\n");
out.write("\t\t\t<div id=\"selected_order\">\n");
out.write("\t\t\t\t<b>Selected orders</b>\n");
out.write(
"\t\t\t\t<form action=\"PrintSelectedCustPayment.jsp\" method=\"get\" id=\"submit_form\">\n");
out.write(
"\t\t\t\t<table style=\"width: 100%;border-collapse: collapse;\" border=1 id=\"selected_order_table\">\n");
out.write("\t\t\t\t<tr>\n");
out.write("\t\t\t\t\t<th style=\"width: 20%;\">Order Number</th>\n");
out.write("\t\t\t\t\t<th style=\"width: 35%;\">Cust Name</th>\n");
out.write("\t\t\t\t\t<th style=\"width: 20%;\">Balance</th>\n");
out.write("\t\t\t\t\t<th style=\"width: 25%;\"> </th>\n");
out.write("\t\t\t\t</tr>\n");
out.write("\t\t\t\t</table>\n");
out.write("\t\t\t\t<table style=\"width: 100%;\" border=1 id=\"insert_table\">\n");
out.write("\t\t\t\t</table>\n");
out.write(
"\t\t\t\t <input type=\"text\" readonly=\"readonly\" name=\"order_count\" id=\"order_count_id\" size=\"3\" value=\"0\" style=\"background-color :#ECFB99 ;\"/> orders selected to print.\n");
out.write(
"\t\t\t\t<input type=\"submit\" onclick=\" return printSelectedInformation()\" value=\"Print\" style=\"float: right;\"/>\n");
out.write("\t\t\t\t</form>\n");
out.write("\t\t\t</div>\n");
out.write("\t\t");
}
if (!call_type.equals("search_payment") || !call_type.equals("communication")) {
out.write("\n");
out.write("<center>\n");
}
out.write("\n");
out.write("<fieldset style=\"width: 55%;\"><legend>\n");
String msg = request.getParameter("msg");
if (call_type.equals("receive_payment")) {
out.print("<h3>Search Customer To Receive Payment</h3>");
} else if (call_type.equals("search_payment")) {
out.print("<h3>Search Customer To See Pending</h3>");
} else if (call_type.equals("communication")) {
out.print("<h3>Search Customer To Communicate</h3>");
} else {
out.print("<h3>Search Customer</h3>");
}
out.write("\n");
out.write("</legend>\n");
if (call_type.equals("receive_payment")) {
out.write("\n");
out.write(
"\t\t<input type = \"radio\" name = \"radio\" onclick=\"ChangeCriteria('order')\" checked=\"checked\"/>Search By Order Number\n");
out.write(
"\t\t<input type = \"radio\" name = \"radio\" onclick=\"ChangeCriteria('cust')\"/>Search By Customer Detail\n");
out.write("\t");
}
if (call_type.equals("receive_payment")) {
out.write("\n");
out.write("\t<br/><br/>\n");
out.write("<form id=\"myform1\" action=\"SearchCustUsingOrderNo.jsp\" method=\"get\">\n");
out.write("\t");
if (msg != null) {
out.print("<i><font color=red>No Matching Record Found</font></i><br/><br/>");
}
out.write("\n");
out.write(
"\tEnter Order Number : <input type = \"text\" name = \"order_number\" value=\"\" id =\"order_number\" onkeypress=\"return isNumberKey(event)\"/>\n");
out.write(
"\t<input type = \"submit\" value=\"Search\" onclick=\"return ckeckEmpty();\"/>\n");
out.write("\n");
out.write("<br/>\n");
out.write("</form>\n");
out.write("<form name=\"myform\" method=\"post\" id=\"myform\" style=\"display: none\">\n");
} else {
out.write("\n");
out.write("<form name=\"myform\" method=\"post\" id=\"myform\" >\n");
}
out.write("\n");
out.write("\t<table style=\"width: 100%;\">\n");
out.write("\t\t<tr style=\"width: 100%;\">\n");
out.write(
"\t\t\t<td align=\"center\" colspan=3><b><font color=\"blue\"> A</font>ll Customers List       \n");
out.write(
"\t\t\t<input type=\"CheckBox\" name=\"chckall\" accesskey=\"a\" onClick=\"funEnabled();\"></td>\n");
out.write("\t\t</tr>\t\t\n");
out.write("\t\t<tr style=\"width: 100%;\">\n");
out.write("\t\t\t<td colspan=3>\n");
out.write("\t\t\t<div id=\"div4\" style=\"width: 100%;\" >\n");
out.write("\t\t\t\t<table>\t\t\t\t\n");
out.write("\t\t\t\t\t<tr>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\">\n");
out.write("\t\t\t\t\t\t\t<b><font color=\"blue\">C</font>ustomer Code</b>\n");
out.write("\t\t\t\t\t\t</td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 29%;\"><input style=\"width: 97%;\" type=\"text\" name=\"custCode\" accesskey=\"c\"></td>\n");
out.write("\t\t\t\t\t\t");
if (call_type.equals("search_payment") || call_type.equals("communication")) {
out.write("\n");
out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\">\n");
out.write("\t\t\t\t\t\t\t<b>O<font color=\"blue\">r</font>der Number</b>\n");
out.write("\t\t\t\t\t\t</td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 29%;\"><input style=\"width: 97%;\" type=\"text\" name=\"ordernumber\" accesskey=\"c\"></td>\n");
out.write("\t\t\t\t\t\t");
}
out.write("\n");
out.write("\t\t\t\t\t</tr>\n");
out.write("\t\t\t\t\t<tr>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Customer <font color=\"blue\">N</font>ame</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 29%;\"><input style=\"width: 97%;\" type=\"text\" name=\"custName\" align=\"right\" accesskey=\"n\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">P</font>hone Number</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 29%;\"><input style=\"width: 97%;\" type=\"text\" name=\"phonenumber\" size=\"22\" align=\"right\" colspan=\"2\" accesskey=\"p\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t</tr>\n");
out.write("\t\t\t\t\t<tr>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>M<font color=\"blue\">o</font>bile Number</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td><input style=\"width: 97%;\" type=\"text\" name=\"mobilenumber\" size=\"22\" align=\"right\" colspan=\"2\" accesskey=\"o\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Na<font color=\"blue\">m</font>e String</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td><input style=\"width: 97%;\" style=\"width: 100%;\" type=\"text\" name=\"nameString\" size=\"22\" align=\"right\" accesskey=\"m\" colspan=\"2\"></td>\n");
out.write("\t\t\t\t\t</tr>\n");
out.write("\t\t\t\t\t<tr>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">B</font>uilding</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td><input style=\"width: 97%;\" type=\"text\" name=\"Building\" accesskey=\"b\" align=\"right\"></b></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Building <font color=\"blue\">N</font>o.</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td><input style=\"width: 97%;\" type=\"text\" name=\"Building_no\" size=\"22\" accesskey=\"o\"></b></td>\n");
out.write("\t\t\t\t\t</tr>\n");
out.write("\t\t\t\t\t<tr>\n");
out.write(
"\t\t\t\t\t <td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">W</font>ing</b></td>\n");
out.write("\t\t\t\t\t <td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t <td><input style=\"width: 97%;\" type =\"text\" name=\"wing\" accesskey=\"w\" ></td>\n");
out.write("\t\t\t\t\t \n");
out.write("\t\t\t\t\t <td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\t\t \n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">F</font>lat No.</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td><input style=\"width: 97%;\" type =\"text\" name=\"block\" size=\"22\" accesskey=\"f\" align=\"right\">\n");
out.write("\t\t\t\t\t\t</tr>\n");
out.write("\t\t\t\t\t<tr>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Addr<font color=\"blue\">e</font>ss1</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td><input style=\"width: 97%;\" type =\"text\" accesskey=\"e\" name=\"add1\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>A<font color=\"blue\">d</font>dress2</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td><input style=\"width: 97%;\" type =\"text\" accesskey=\"d\" name=\"add2\" size=\"22\"></td>\n");
out.write("\t\t\t\t\t</tr>\n");
out.write("\t\t\t\t\t<tr >\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>A<font color=\"blue\">r</font>ea</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write("\t\t\t\t\t\t<td>\n");
out.write("\t\t\t\t\t\t");
String name;
try {
Context initContext = new InitialContext();
Context envContext = (Context) initContext.lookup("java:/comp/env");
// DataSource ds = (DataSource)envContext.lookup("jdbc/js");
DataSource ds = (DataSource) envContext.lookup("jdbc/re");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs =
stmt.executeQuery(
"select value from code_table where category='AREA' order by value asc");
out.write("\n");
out.write("\t\t\t\t\t\t\t<SELECT style=\"width: 97%;\" name=\"area\">\n");
out.write("\t\t\t\t\t\t\t\t<OPTION VALUE=\"\"> Select Area </OPTION>\n");
out.write("\t\t\t\t\t\t");
while (rs.next()) {
name = rs.getString(1);
out.write("\n");
out.write("\t\t\t\t\t\t\t\t<OPTION VALUE=\"");
out.print(name);
out.write('"');
out.write('>');
out.write(' ');
out.print(name);
out.write(" </OPTION>\n");
out.write("\t\t\t\t\t\t");
}
out.write("\n");
out.write("\t\t\t\t\t\t\t</SELECT>\n");
out.write("\t\t\t\t\t\t</td>\t\n");
out.write("\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Payment Type</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write("\t\t\t\t\t\t<td>\n");
out.write("\t\t\t\t\t\t\t<SELECT style=\"width: 97%;\" name=\"payment\" align=\"left\">\n");
out.write("\t\t\t\t\t\t\t\t<OPTION selected VALUE=\"\"> Select Type </OPTION>\n");
out.write("\t\t\t\t\t\t\t\t<OPTION VALUE=\"NoType\"> No Type </OPTION>\n");
out.write("\t\t\t\t\t\t");
ResultSet rs2 =
stmt.executeQuery("SELECT payment_type_code, payment_type_desc FROM payment_type");
while (rs2.next()) {
out.write("\t\n");
out.write("\t\t\t\t\t\t\t\t<OPTION VALUE=\"");
out.print(rs2.getString(1));
out.write('"');
out.write('>');
out.write(' ');
out.print(rs2.getString(2));
out.write(" </OPTION>\n");
out.write("\t\t\t\t\t\t");
}
rs2.close();
stmt.close();
conn.close();
} catch (Exception e) {
e.getMessage();
e.printStackTrace();
}
out.write("\n");
out.write("\t\t\t\t\t\t\t</SELECT>\n");
out.write("\t\t\t\t\t\t</td>\n");
out.write("\t\t\t\t\t</tr>\n");
out.write("\t\t\t\t\t<tr>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Create<font color=\"blue\">D</font>ate</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write("\t\t\t\t\t\t<td>\n");
out.write(
"\t\t\t\t\t\t\t<!-- <input type =\"text\" accesskey=\"d\" name=\"c_date1\" size=\"15\" style=\"width: 79%;\">\n");
out.write(
"\t\t\t\t\t\t\t<input type=\"button\" onClick=\"c1.popup('c_date1');\" value=\"...\" style=\"width: 15%;\"/> -->\n");
out.write("\t\t\t\t\t\t\t<div id='createDate1'></div>\n");
out.write("\t\t\t\t\t\t</td>\n");
out.write("\t\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>And</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write("\t\t\t\t\t\t<td> \n");
out.write(
"\t\t\t\t\t\t\t<!-- <input type =\"text\" name=\"c_date2\" size=\"15\" style=\"width: 79%;\">\n");
out.write(
"\t\t\t\t\t\t\t<input type=\"button\" onClick=\"c1.popup('c_date2');\" value=\"...\" style=\"width: 15%;\"/> -->\n");
out.write("\t\t\t\t\t\t\t<div id='createDate2'></div>\n");
out.write("\t\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t</td>\n");
out.write("\t\t\t\t\t</tr>\n");
out.write("\t\t\t\t\t<tr>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">U</font>pdate Date</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write("\t\t\t\t\t\t<td>\n");
out.write(
"\t\t\t\t\t\t\t<!-- <input type =\"text\" accesskey=\"u\" name=\"u_date1\" size=\"15\" style=\"width: 79%;\"/>\n");
out.write(
"\t\t\t\t\t\t\t<input type=\"button\" onClick=\"c1.popup('u_date1');\" value=\"...\" style=\"width: 15%;\"/> -->\n");
out.write("\t\t\t\t\t\t\t<div id=\"updateDate1\"></div>\n");
out.write("\t\t\t\t\t\t</td>\n");
out.write("\t\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>And</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write("\t\t\t\t\t\t<td> \n");
out.write(
"\t\t\t\t\t\t\t<!-- <input type =\"text\" name=\"u_date2\" size=\"15\" style=\"width: 79%;\"/>\n");
out.write(
"\t\t\t\t\t\t\t<input type=\"button\" onClick=\"c1.popup('u_date2');\" value=\"...\" style=\"width: 15%;\"/> -->\n");
out.write("\t\t\t\t\t\t\t<div id='updateDate2'></div>\n");
out.write("\t\t\t\t\t\t</td>\n");
out.write("\t\t\t\t\t</tr>\n");
out.write("\t\t\t\t\t<tr>\n");
out.write(
"\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">S</font>tation</b></td>\n");
out.write("\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t<td><input style=\"width: 97%;\" type =\"text\" size=\"22\" accesskey=\"d\" name=\"station\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Last Order Days</b></td>\n");
out.write("\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t<td><input style=\"width: 97%;\" type=\"text\" name=\"selmonth\"/></td></tr>\n");
out.write("\t\t\t\t</table></div>\n");
out.write("\t\t\t</td>\n");
out.write("\t\t</tr>\n");
out.write("\t\t\t\n");
out.write("\t\t<tr>\n");
out.write("\t\t\t<td align=\"center\" colspan=4>\n");
out.write(
"\t\t\t\t<input type=\"submit\" name=\"search\" title=\"Press <Enter>\" value=\"Search <Enter>\" accesskey=\"s\" onclick=\"checkField();return false;\"/>\n");
out.write(
"\t\t\t\t<input type=\"reset\" name=\"clear\" title=\"Press <Alt+c>\" tabindex=\"1\" value=\"Clear <Alt+c>\" accesskey=\"c\" onclick=\"document.getElementById('txtHint').innerHTML='';\"/>\n");
out.write(
"\t\t\t\t<INPUT type=BUTTON value=\"Cancel <Alt+c>\" accesskey=\"c\" onClick=\"showMsg();\"/></center>\n");
out.write("\t\t\t</td>\n");
out.write("\t\t</tr>\n");
out.write("\t</table>\n");
out.write("\t</fieldset>\n");
out.write("\t<input type=\"hidden\" name=\"hchckall\" value=\"1\">\n");
out.write("\t<input type=\"hidden\" name=\"call_type\" value=\"");
out.print(call_type);
out.write("\"/>\n");
out.write("<script>\n");
out.write("function funEnabled(){\n");
out.write("\t if (document.myform.chckall.checked==true){\n");
out.write("\t\t\tdocument.getElementById('div4').style.visibility=\"hidden\";\n");
out.write("\t\t\tdocument.myform.hchckall.value=1;\t\t\n");
out.write("\t\t\t$(\"#createDate2\").jqxDateTimeInput({disabled: true});\n");
out.write("\t\t\t$(\"#updateDate2\").jqxDateTimeInput({disabled: true});\n");
out.write("\t\t\t\n");
out.write("\t\t}\n");
out.write("\t\telse{\n");
out.write("\t\t\tdocument.getElementById('div4').style.visibility=\"visible\";\n");
out.write("\t\t\tdocument.myform.hchckall.value=0;\t\t\t\n");
out.write("\t\t}\n");
out.write("\t}\n");
out.write("window.onload =Clear;\n");
out.write("\n");
out.write("function ChangeCriteria(str){\n");
out.write("\tif(str == \"cust\"){\n");
out.write("\t\tdocument.getElementById(\"myform\").style.display='block';\n");
out.write("\t\tdocument.getElementById(\"myform1\").style.display='none';\n");
out.write("\t}else if(str == \"order\"){\n");
out.write("\t\tdocument.getElementById(\"myform\").style.display='none';\n");
out.write("\t\tdocument.getElementById(\"myform1\").style.display='block';\n");
out.write("\t\tdocument.getElementById(\"txtHint\").innerHTML=\"\";\n");
out.write("\t\tdocument.getElementById(\"order_number\").focus();\n");
out.write("\t\tdocument.getElementById(\"order_number\").value=\"\";\n");
out.write("\t}\n");
out.write("}\n");
out.write("function isNumberKey(evt) {\n");
out.write("\tvar charCode = (evt.which) ? evt.which : event.keyCode;\n");
out.write("\tif (charCode != 46 && charCode > 31 && (charCode < 48 || charCode > 57))\n");
out.write("\t\treturn false;\n");
out.write("\telse\n");
out.write("\t\treturn true;\n");
out.write("}\n");
out.write("</script>\n");
out.write(
"\t<hr><center><div id=\"txtHint\" class=\"ddm1\" style=\"background-color: white;width: 100%;max-height: 400px;overflow: auto;\"></div></center>\n");
out.write("\t<br><br>\n");
out.write(
"\t<p><h1><center><div id=\"waitMessage\" style=\"cursor: sw-resize;\"></center></div></h1></p>\n");
String fromFromName = "";
if (request.getParameter("fromForm") != null) fromFromName = request.getParameter("fromForm");
// CustPmtHstry
out.write("\n");
out.write("\t<input type=\"hidden\" name=\"fromForm\" value=\"");
out.print(fromFromName);
out.write("\">\n");
out.write("</form>\n");
out.write("\n");
out.write(
"<div id=\"dispdiv\" align=\"center\" style=\"border:1px solid black; padding:25px; text-align:center; display:none; background-color:#FFF; overflow:auto; height:300px; width=200px;\"> </div>\n");
out.write("</body>\n");
out.write("</html>\n");
} catch (java.lang.Throwable t) {
if (!(t instanceof javax.servlet.jsp.SkipPageException)) {
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
try {
out.clearBuffer();
} catch (java.io.IOException e) {
}
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
else throw new ServletException(t);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}
public void _jspService(
javax.servlet.http.HttpServletRequest request,
javax.servlet.http.HttpServletResponse response)
throws java.io.IOException, javax.servlet.ServletException {
javax.servlet.http.HttpSession session = request.getSession(true);
com.caucho.server.webapp.Application _jsp_application = _caucho_getApplication();
javax.servlet.ServletContext application = _jsp_application;
com.caucho.jsp.PageContextImpl pageContext =
com.caucho.jsp.QJspFactory.allocatePageContext(
this, _jsp_application, request, response, "/error.jsp", session, 8192, true);
javax.servlet.jsp.JspWriter out = pageContext.getOut();
javax.servlet.ServletConfig config = getServletConfig();
javax.servlet.Servlet page = this;
response.setContentType("text/html");
try {
out.write(_jsp_string0, 0, _jsp_string0.length);
out.print(((String) session.getAttribute("user")));
out.write(_jsp_string1, 0, _jsp_string1.length);
out.print(((String) session.getAttribute("db")));
out.write(_jsp_string2, 0, _jsp_string2.length);
// get all tables in the database
ConDB dbcon = (ConDB) session.getAttribute("dbcon");
Connection conn = dbcon.get();
int total_rec = 0;
int total_table = 0;
String sql = "show tables";
PreparedStatement pstm = null;
ResultSet rs = null;
try {
pstm = conn.prepareStatement(sql);
rs = pstm.executeQuery();
} catch (SQLException e) {
out.println(e);
}
// count the records of each table
while (rs.next()) {
String curr_tb = rs.getString(1);
int curr_rec = 0;
PreparedStatement pstm_rec = null;
ResultSet rs_rec = null;
sql = "select count(*) from " + curr_tb;
try {
pstm_rec = conn.prepareStatement(sql);
rs_rec = pstm_rec.executeQuery();
} catch (SQLException e) {
out.println(e);
}
try {
if (rs_rec.next()) {
curr_rec = rs_rec.getInt(1);
total_rec += curr_rec;
}
} catch (SQLException e) {
out.println(e.getErrorCode() + "---" + e.getSQLState());
}
total_table++;
out.write(_jsp_string3, 0, _jsp_string3.length);
out.print((total_table & 1));
out.write(_jsp_string4, 0, _jsp_string4.length);
out.print((curr_tb));
out.write(_jsp_string5, 0, _jsp_string5.length);
out.print((curr_tb));
out.write(_jsp_string6, 0, _jsp_string6.length);
out.print((curr_tb));
out.write(_jsp_string7, 0, _jsp_string7.length);
out.print((curr_tb));
out.write(_jsp_string8, 0, _jsp_string8.length);
out.print((curr_tb));
out.write(_jsp_string9, 0, _jsp_string9.length);
out.print((curr_rec));
out.write(_jsp_string10, 0, _jsp_string10.length);
}
out.write(_jsp_string11, 0, _jsp_string11.length);
out.print((total_table));
out.write(_jsp_string12, 0, _jsp_string12.length);
out.print((total_rec));
out.write(_jsp_string13, 0, _jsp_string13.length);
out.print((session.getAttribute("db")));
out.write(_jsp_string14, 0, _jsp_string14.length);
} catch (java.lang.Throwable _jsp_e) {
pageContext.handlePageException(_jsp_e);
} finally {
com.caucho.jsp.QJspFactory.freePageContext(pageContext);
}
}
public void _jspService(
final javax.servlet.http.HttpServletRequest request,
final javax.servlet.http.HttpServletResponse response)
throws java.io.IOException, javax.servlet.ServletException {
final java.lang.String _jspx_method = request.getMethod();
if (!"GET".equals(_jspx_method)
&& !"POST".equals(_jspx_method)
&& !"HEAD".equals(_jspx_method)
&& !javax.servlet.DispatcherType.ERROR.equals(request.getDispatcherType())) {
response.sendError(
HttpServletResponse.SC_METHOD_NOT_ALLOWED, "JSPs only permit GET POST or HEAD");
return;
}
final javax.servlet.jsp.PageContext pageContext;
javax.servlet.http.HttpSession session = null;
final javax.servlet.ServletContext application;
final javax.servlet.ServletConfig config;
javax.servlet.jsp.JspWriter out = null;
final java.lang.Object page = this;
javax.servlet.jsp.JspWriter _jspx_out = null;
javax.servlet.jsp.PageContext _jspx_page_context = null;
try {
response.setContentType("text/html");
pageContext = _jspxFactory.getPageContext(this, request, response, null, true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write('\r');
out.write('\n');
String username = "";
if (session.getAttribute("login") != null) {
username = session.getAttribute("login").toString();
} else {
out.println("Invalid session! You must log back into the system.");
return;
}
String outputMsg = "TODO";
ResultSet employeeRevRes = null;
String JDBC_DRIVER = "com.mysql.jdbc.Driver";
String DB_URL = "jdbc:mysql://localhost:3306/SilkRoad 5.0";
String USER = "******";
String PASS = "******";
Statement stmt = null;
String sql = null;
Connection conn = null;
CallableStatement cs = null;
try {
// Register JDBC driver
Class.forName(JDBC_DRIVER).newInstance();
// Open a connection
conn = java.sql.DriverManager.getConnection(DB_URL, USER, PASS);
System.out.println("HERE");
cs = conn.prepareCall("call GetEmployeeRevenues()");
cs.execute();
employeeRevRes = cs.getResultSet();
// TODO. Error handling
out.write("\r\n");
out.write(" <html lang=\"en\">\r\n");
out.write(" <head>\r\n");
out.write(" <meta charset=\"utf-8\">\r\n");
out.write(" <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\r\n");
out.write(
" <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\r\n");
out.write(
" <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->\r\n");
out.write(" <title>Silk Road 5.0</title>\r\n");
out.write(" <!-- Bootstrap -->\r\n");
out.write(" <link href=\"css/bootstrap.min.css\" rel=\"stylesheet\">\r\n");
out.write(" ");
out.write("\r\n");
out.write(
" <link href=\"css/responsive.bootstrap.min.css\" rel=\"stylesheet\" type=\"text/css\">\r\n");
out.write(
" <link href=\"https://cdnjs.cloudflare.com/ajax/libs/bootstrap3-dialog/1.34.5/css/bootstrap-dialog.min.css\" rel=\"stylesheet\" type=\"text/css\" />\r\n");
out.write(" <!-- Our own custom css -->\r\n");
out.write(
" <link href=\"css/stylesheet.css\" rel=\"stylesheet\" type=\"text/css\">\r\n");
out.write(
" <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->\r\n");
out.write(
" <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->\r\n");
out.write(" <!--[if lt IE 9]>\r\n");
out.write(
" <script src=\"https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js\"></script>\r\n");
out.write(
" <script src=\"https://oss.maxcdn.com/respond/1.4.2/respond.min.js\"></script>\r\n");
out.write(" <![endif]-->\r\n");
out.write(" <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->\r\n");
out.write(" <script src=\"js/jquery-1.11.3.min.js\"></script>\r\n");
out.write(" <script src=\"js/jquery.validate.js\"></script>\r\n");
out.write(" ");
out.write("\r\n");
out.write(
" <!-- Include all compiled plugins (below), or include individual files as needed -->\r\n");
out.write(" <script src=\"js/bootstrap.min.js\"></script>\r\n");
out.write(
" <script src=\"https://cdnjs.cloudflare.com/ajax/libs/bootstrap3-dialog/1.34.5/js/bootstrap-dialog.min.js\"></script>\r\n");
out.write(" <script src=\"js/pattern.js\"></script>\r\n");
out.write(" <script src=\"js/script.js\"></script>\r\n");
out.write(" <script src=\"js/editCustomer.js\"></script>\r\n");
out.write(" </head>\r\n");
out.write(" <nav class=\"navbar\">\r\n");
out.write(" <div class=\"container-fluid\">\r\n");
out.write(" <!-- Brand and toggle get grouped for better mobile display -->\r\n");
out.write(" <div class=\"navbar-header\">\r\n");
out.write(
" <button type=\"button\" class=\"navbar-toggle collapsed\" data-toggle=\"collapse\" data-target=\"#bs-example-navbar-collapse-1\" aria-expanded=\"false\">\r\n");
out.write(" <span class=\"sr-only\">Toggle navigation</span>\r\n");
out.write(" <span class=\"icon-bar\"></span>\r\n");
out.write(" <span class=\"icon-bar\"></span>\r\n");
out.write(" <span class=\"icon-bar\"></span>\r\n");
out.write(" </button>\r\n");
out.write(" </div>\r\n");
out.write(" <!-- navbar-header -->\r\n");
out.write(
" <!-- Collect the nav links, forms, and other content for toggling -->\r\n");
out.write(" <div class=\"myNavbar\">\r\n");
out.write(" <ul class=\"nav\">\r\n");
out.write(
" <li class=\"floatLeft\"><a href=\"ManagerInformation.jsp\">Home</a></li>\r\n");
out.write(
" <li class=\"dropdown navbar-right\" style=\"padding-left:125px;\">\r\n");
out.write(
" <a data-target=\"#collapseHelp\" data-toggle=\"collapse\">Help<span class=\"caret\"></span></a>\r\n");
out.write(" <ul>\r\n");
out.write(" <div id=\"collapseHelp\" class=\"dropdown-menu\">\r\n");
out.write(
" <li><a href=\"javascript:showEmployeeScreenHelp()\">Screens</a></li>\r\n");
out.write(" <br>\r\n");
out.write(
" <li><a href=\"javascript:showAuctionHelp()\">Auctions</a></li>\r\n");
out.write(" <br>\r\n");
out.write(" </div>\r\n");
out.write(" </ul>\r\n");
out.write(" </li>\r\n");
out.write(
" <li class=\"dropdown navbar-right\" style=\"padding-left:200px;\">\r\n");
out.write(
" <a data-target=\"#collapseMenu\" data-toggle=\"collapse\" >Menu<span class=\"caret\"></span></a>\r\n");
out.write(" <ul>\r\n");
out.write(" <div id=\"collapseMenu\" class=\"dropdown-menu\">\r\n");
out.write(" </div>\r\n");
out.write(" </ul>\r\n");
out.write(" </li>\r\n");
out.write(" </ul>\r\n");
out.write(" <!-- .nav -->\r\n");
out.write(" </div>\r\n");
out.write(" <!-- .myNavbar -->\r\n");
out.write(" </div>\r\n");
out.write(" <!-- .container-fluid -->\r\n");
out.write(" </nav>\r\n");
out.write(" <body class=\"auctionHouseBody\">\r\n");
out.write(
" <h4 class=\"auctionTableHeader\">Highest Grossing Employee</h4>\r\n");
out.write(
" <table id =\"bestSellersTable\" class=\"table table-striped table-bordered dt-responsive nowrap auctionHouseTable\">\r\n");
out.write(" <thead>\r\n");
out.write(" <tr>\r\n");
out.write(" <th>Employee ID</th>\r\n");
out.write(" <th>Username</th>\r\n");
out.write(" <th>Revenue</th>\r\n");
out.write(" </tr>\r\n");
out.write(" </thead>\r\n");
out.write(" <tbody>\r\n");
out.write(" ");
while (employeeRevRes.next()) {
out.write("\r\n");
out.write(" <tr>\r\n");
out.write(" <td>\r\n");
out.write(" ");
out.print(employeeRevRes.getString("EmployeeID"));
out.write("\r\n");
out.write(" </td>\r\n");
out.write(" <td>\r\n");
out.write(" ");
out.print(employeeRevRes.getString("Username"));
out.write("\r\n");
out.write(" </td>\r\n");
out.write(" <td>\r\n");
out.write(" ");
out.print(employeeRevRes.getDouble("Revenue"));
out.write("\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write(" ");
}
out.write("\r\n");
out.write(" </tbody>\r\n");
out.write(" </table>\r\n");
out.write(" </body>\r\n");
out.write(" </html>\r\n");
out.write("\r\n");
out.write(" ");
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (Exception ee) {
}
;
}
out.write('\r');
out.write('\n');
} catch (java.lang.Throwable t) {
if (!(t instanceof javax.servlet.jsp.SkipPageException)) {
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
try {
if (response.isCommitted()) {
out.flush();
} else {
out.clearBuffer();
}
} catch (java.io.IOException e) {
}
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
else throw new ServletException(t);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}
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();
}
/** @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html");
Connection conn = null;
System.out.println("Reached here 1");
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String user = "";
String userpass = "";
String strQuery = "";
Statement st = null;
ResultSet rs = null;
HttpSession session = request.getSession(true);
try {
Class.forName(driver);
conn = DriverManager.getConnection("jdbc:odbc:test", "", "");
if (request.getParameter("user") != null
&& request.getParameter("user") != ""
&& request.getParameter("userpass") != null
&& request.getParameter("userpass") != "") {
user = request.getParameter("user").toString();
userpass = request.getParameter("userpass").toString();
strQuery = "select * from register ";
st = conn.createStatement();
System.out.println("Reached here 2");
rs = st.executeQuery(strQuery);
System.out.println("Reached here 3");
String cpass = null;
String name = null;
while (rs.next()) {
if (rs.getString(3).equals(user)) {
name = rs.getString(1);
cpass = rs.getString("pass");
break;
}
}
session.setAttribute("sname", name);
System.out.println("Reached Here 4");
StringBuffer q = pack.calc(userpass);
String q1 = q.toString();
System.out.println("Reached Here 5");
if (cpass.equals(q1)) {
RequestDispatcher rd =
this.getServletConfig().getServletContext().getRequestDispatcher("/home.jsp");
rd.forward(request, response);
} else {
RequestDispatcher rd =
this.getServletConfig().getServletContext().getRequestDispatcher("/login5.jsp");
rd.forward(request, response);
}
}
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
response.setContentType("text/html; charset=ISO-8859-1");
pageContext = _jspxFactory.getPageContext(this, request, response, null, true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
_jspx_resourceInjector =
(org.glassfish.jsp.api.ResourceInjector)
application.getAttribute("com.sun.appserv.jsp.resource.injector");
out.write("\n");
out.write(" \n");
out.write(" \n");
out.write(" \n");
Class.forName("com.mysql.jdbc.Driver");
out.write("\n");
out.write(" \n");
out.write(" \n");
out.write(
"<!DOCTYPE html PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\" \"http://www.w3.org/TR/html4/loose.dtd\">\n");
out.write("<html>\n");
out.write("<head>\n");
out.write(" <link href=\"css/bootstrap.min.css\" rel=\"stylesheet\">\n");
out.write(" <!-- Bootstrap css online -->\n");
out.write(
" <link rel=\"stylesheet\" href=\"http://netdna.bootstrapcdn.com/bootstrap/3.0.3/css/bootstrap.min.css\">\n");
out.write(" <link href=\"css/customcss.css\" rel=\"stylesheet\">\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jquery-1.10.2.min.js\"></script>\n");
out.write(" <script src=\"js/bootstrap.min.js\"></script>\n");
out.write("\n");
out.write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=ISO-8859-1\">\n");
out.write("<title>Analysis of Algorithms : D.B.Phatak</title>\n");
out.write("</head>\n");
out.write("<body>\n");
out.write("\n");
out.write("<!--Header-->\n");
out.write("\n");
out.write(" ");
String name = (String) session.getAttribute("pass");
out.write("\n");
out.write(" <div class=\"container\">\n");
out.write(" <br>\n");
out.write(" <!--HEADER -->\n");
out.write(" <div class=\"header\">\n");
out.write(
" <a href=\"index.jsp\" style=\"color: #000;\"> <ul class=\"nav nav-pills pull-left\" >\n");
out.write(
" <li id=\"brand_icon\"> <img src=\"Images/mic_logo.png\" alt=\"\" width=\"80px\" height=\"80px\"/></li>\n");
out.write(
" <li id=\"brand_name\"> <p class=\"title\"><span style=\"font-size: 70px;\">|</span> iClass <strong>Forum</strong></p></li>\n");
out.write("\n");
out.write(" </ul></a>\n");
out.write(
" <!-- <p class=\"title1\">iClass</p> <p class=\"title2\">Forum</p> \n");
out.write(" -->\n");
out.write(" <form action=\"Login\" method=\"post\">\n");
out.write("\n");
out.write(
" <ul class=\"nav nav-pills pull-right\" style=\"margin-top: 35px\">\n");
out.write(" <li><a href=\"index.jsp\">Home</a></li>\n");
out.write(" <li><a href=\"contactus.jsp\">Contact Us</a></li>\n");
out.write("\n");
out.write(" ");
if (name != null) {
try {
out.write("\n");
out.write("\n");
out.write(" <li><a href=\"logout.jsp\">Logout</a></li>\n");
out.write(" <li style=\"margin-top: 10px\">Welcome ");
out.print(name);
out.write("</li>\n");
out.write("\n");
out.write(" ");
} catch (Exception e) {
System.out.println("Problem :" + e);
}
} else {
out.write("\n");
out.write("\n");
out.write(" <li><a href=\"signup.jsp\">Login</a></li>\n");
out.write("\n");
out.write(" ");
}
out.write("\n");
out.write("\n");
out.write(" </ul>\n");
out.write(" </form>\n");
out.write("\n");
out.write("\n");
out.write(" </div>\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write(" <br>\n");
out.write(" \n");
out.write(" \n");
out.write("\n");
out.write(" <!-- MODAL -->\n");
out.write(" <form action=\"\" name=\"batti\" method=\"post\">\n");
out.write("\n");
out.write(
" <div class=\"modal fade\" id=\"myModal\" tabindex=\"-1\" role=\"dialog\" aria-labelledby=\"myModalLabel\" aria-hidden=\"true\">\n");
out.write(" <div class=\"modal-dialog\">\n");
out.write(" <div class=\"modal-content\">\n");
out.write(" <div class=\"modal-header\">\n");
out.write(
" <button type=\"button\" class=\"close\" data-dismiss=\"modal\" aria-hidden=\"true\">×</button>\n");
out.write(" <h4 class=\"modal-title\" id=\"myModalLabel\">Answer here</h4>\n");
out.write(" </div>\n");
out.write(" <div class=\"modal-body\">\n");
out.write(" <div class=\"input-group input-group-lg\">\n");
out.write(" <span class=\"input-group-addon\">\n");
out.write(
" <span class=\"glyphicon glyphicon-pencil\"></span>\n");
out.write(" </span>\n");
out.write(
" <textarea class=\"form-control\" id=\"currentans\" name=\"mainanswer\" rows=\"10\" style=\"resize: vertical;\">\n");
out.write(" </textarea>\n");
out.write(" </div>\n");
out.write(" </div>\n");
out.write(" <div class=\"modal-footer\">\n");
out.write(
" <input type=\"text\" id=\"hidden\" name=\"maindata\" value=\"JAI HO\"/>\n");
out.write(
" <button type=\"button\" class=\"btn btn-primary\" onClick=\"saveAns()\">Save Answer</button>\n");
out.write(" </div>\n");
out.write(" </div>\n");
out.write(" </div>\n");
out.write(" </div>\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write(" </form>\n");
out.write(" <!-- MODAL ENDS HERE -->\n");
out.write("\n");
out.write("<div class=\"page1\" > \n");
out.write(" <center>\n");
out.write("\n");
out.write(
" <font face=\"myFontThin\" size=\"6\" class=\"title\">Department of </font><font face=\"myFontThick\" size=\"8\"><b>Computer Science</b></font>\n");
out.write(" <br>\n");
out.write(" <font face=\"myFontThick\" size=\"5\">Prof. sunil</font>\n");
out.write(" \n");
out.write(" </center>\n");
out.write(
" <br> <br> <font face=\"myFontThick\" size=\"6\"><b> bbbbbb </b></font>\n");
out.write("<br><br><br>\n");
out.write(" \n");
out.write("\n");
out.write("\n");
out.write(" ");
Connection connection =
DriverManager.getConnection("jdbc:mysql://localhost/aakash", "root", "lavikothari");
Statement statement = connection.createStatement();
ResultSet resultset = statement.executeQuery("select * from qa27;");
int i = 0, no, ct = 0;
String qid, bid, ansdivid, buttonid, delbuttonid, userid, answerid;
while (resultset.next()) {
ct++;
no = resultset.getInt(1);
if (i < no) {
i = no;
}
qid = "q" + no;
ansdivid = "ans" + no;
bid = "b" + no;
buttonid = "button" + no;
delbuttonid = "delbutton" + no;
userid = "user" + no;
answerid = "answer" + no;
out.write("\n");
out.write(" <!-- <form action=\"\" method=\"get\" name=\"batti\" > -->\n");
out.write("\t \n");
out.write("\t<div class=\"panel panel-default\">\n");
out.write(" <div class=\"panel-heading\">\n");
out.write(" <h3 class=\"panel-title\">\n");
out.write(" <div id=");
out.print(userid);
out.write(
" style=\"font-style:bold ;font-size:15px; padding-left:0.5px ;text-shadow: 2px 2px 8px #6E6E6E\">\n");
out.write("\t \t");
out.print(resultset.getString(4));
out.write("\n");
out.write(" </div>\n");
out.write(" </h3>\n");
out.write(" </div>\n");
out.write(" <div class=\"panel-body\">\n");
out.write(" <div id=");
out.print(qid);
out.write(" style=\"text-align:left ;font-size:20px;font-style:italic\">\n");
out.write("\t\t\t");
out.print(resultset.getString(2));
out.write("<br><br>\n");
out.write("\t\t</div>\n");
out.write("\t \t<div class=\"panel panel-default\" id=");
out.print(ansdivid);
out.write(" >\n");
out.write(" \t\t\t\t<div class=\"panel-body\" >\n");
out.write(" \t\t\t \t\t<p id=");
out.print(answerid);
out.write('>');
out.print(resultset.getString(3));
out.write("</p>\n");
out.write(" \t\t \t\t</div>\n");
out.write("\t\t</div>\n");
out.write("\t\t<div id=");
out.print(bid);
out.write(" >\n");
out.write("\t\t\t ");
String condition = (String) session.getAttribute("pass");
String prof1 = (String) session.getAttribute("Prof");
String prof2 = (String) session.getAttribute("Prof2");
// out.println("Lec="+condition);
// out.println("prof1="+prof1);
// out.println("prof2="+prof2);
// System.out.println("Lec="+condition);
if (condition != null && prof1.equals(prof2)) {
out.write(" \n");
out.write("\n");
out.write(
" <input type=\"button\" class=\"btn btn-primary btn-sm\" style=\"float:right;display:inline\" value=\"Delete\" onClick=\"delQues(this.id)\" id=");
out.print(delbuttonid);
out.write(" />\n");
out.write(
" <input type=\"button\" class=\"btn btn-primary btn-sm\" style=\"float:left;display:inline\" data-toggle=\"modal\" value=\"Answer\" data-target=\"#myModal\" onClick=\"myfunc(this.id)\" id=");
out.print(buttonid);
out.write(" />\n");
out.write(" ");
}
out.write("\n");
out.write(" \n");
out.write("\t\t</div>\n");
out.write(" </div>\n");
out.write(" </div>\n");
out.write("\t\n");
out.write("\t \n");
out.write("\t\t\n");
out.write(" ");
}
out.write("\n");
out.write("\n");
out.write(
" <form action=\"\" name=\"delform\" method=\"post\" style=\"visibility:hidden\">\n");
out.write("\n");
out.write(
" <input type=\"text\" id= \"delfieldid\" name=\"delfield\" value=\"Namastey\" />\n");
out.write(
" <input type=\"text\" id= \"futureid\" name=\"futurefield\" value=\"London\" />\n");
out.write(" </form>\n");
out.write("\n");
out.write("\n");
out.write(" <span id =\"debug\" style=\"visibility:hidden\">Hello </span>\n");
out.write("\n");
out.write(" </div>\n");
out.write("</div> \n");
out.write("\t \n");
out.write(" \n");
out.write("</div>\n");
out.write(" \n");
out.write(" </div>\n");
out.write(" \n");
out.write(" \n");
out.write(" <script type=\"text/javascript\">\n");
out.write("\t count=");
out.print(ct);
out.write(";\n");
out.write("\t debugging=document.getElementById(\"debug\");\n");
out.write("\t debugging.innerHTML=\"Count is\"+count;\n");
out.write("\t hid=document.getElementById(\"hidden\");\n");
out.write("\t hid.style.display='none';\n");
out.write("\t \n");
out.write("\t for (x=1;x<=count;x++)\n");
out.write("\t {\t\n");
out.write("\t\t y=document.getElementById(\"answer\"+x);\n");
out.write("\t\t debug.innerHTML+=y.innerHTML;\n");
out.write("\t\t z=document.getElementById(\"button\"+x);\n");
out.write("\t\t if(y!=null && y.innerHTML==\"\")\n");
out.write("\t\t {\n");
out.write("\t\t document.getElementById(\"ans\"+x).style.display='none';\n");
out.write("\t\t }\n");
out.write("\t\t \n");
out.write("\t\t else\n");
out.write("\t\t\t {\n");
out.write("\t\t\t if(z!=null){\n");
out.write("\t\t\t z.value=\"Edit Answer\";\n");
out.write("\t\t\t }\n");
out.write("\t\t\t }\n");
out.write("\t }\n");
out.write("\n");
out.write("\t function myfunc(clicked_id){\n");
out.write("\t\t \n");
out.write("\t\t hid.value=clicked_id;\n");
out.write("\t\t quesid=clicked_id.replace(\"button\",\"q\");\n");
out.write("\t\t ansid=clicked_id.replace(\"button\",\"answer\");\n");
out.write("\t\t \n");
out.write("\t\t question=document.getElementById(quesid).innerHTML;\n");
out.write("\t\t answer=document.getElementById(ansid).innerHTML;\n");
out.write("\t\t \n");
out.write("\t\t answer.replace(\" \",\"\");\n");
out.write("\t\t question.replace(\" \",\"\");\n");
out.write("\t\t \n");
out.write("\t\t document.getElementById(\"myModalLabel\").innerHTML=question;\n");
out.write("\t\t document.getElementById(\"currentans\").value=answer;\n");
out.write("\t\t \n");
out.write("\t }\n");
out.write("\t \n");
out.write("\t\n");
out.write("\t function saveAns()\n");
out.write("\t {\n");
out.write("\t\t document.batti.submit();\n");
out.write("\t\t \n");
out.write("\t\t ");
String clid = request.getParameter("maindata");
if (clid != null) {
String tobeanswered = clid.replace("button", "");
System.out.println(tobeanswered);
String answer = request.getParameter("mainanswer");
Statement stmt = connection.createStatement();
String query = "update qa27 set ans ='" + answer + "' where id='" + tobeanswered + "';";
stmt.executeUpdate(query);
response.sendRedirect("lec.jsp#user" + tobeanswered);
}
out.write("\n");
out.write("\t }\n");
out.write("\t \n");
out.write("\t \n");
out.write("\n");
out.write("\t function delQues(clicked_id)\n");
out.write("\t {\n");
out.write("\t\t \n");
out.write("\t\t document.getElementById(\"delfieldid\").value=clicked_id;\n");
out.write("\t\t \n");
out.write("\t\t \n");
out.write("\t\t\t document.getElementById(\"futureid\").value=\"yesssssssss\";\n");
out.write("\t\t v=parseInt(clicked_id.replace(\"delbutton\",\"\"))+1;\n");
out.write("\t\t while(document.getElementById(\"user\"+v)==null && v<count)\n");
out.write("\t\t\t {\n");
out.write("\t\t\t v++;\n");
out.write("\t\t\t document.getElementById(\"futureid\").value=\"user\"+v;\n");
out.write("\t\t\t }\n");
out.write("\t\t if(clicked_id==\"delbutton\"+count)\n");
out.write("\t\t\t {\n");
out.write("\t\t\t v=parseInt(clicked_id.replace(\"delbutton\",\"\"))-1;\n");
out.write("\t\t\t }\n");
out.write("\t\tdocument.getElementById(\"futureid\").value=\"user\"+v;\n");
out.write("\t\t\t \n");
out.write("\t\t document.delform.submit();\n");
out.write("\t\t \n");
out.write("\t\t ");
String delid = request.getParameter("delfield");
if (delid != null) {
String tobedel = delid.replace("delbutton", "");
System.out.println("Deleting " + tobedel);
Statement stmt1 = connection.createStatement();
String query1 = "delete from qa27 where id='" + tobedel + "';";
stmt1.executeUpdate(query1);
String futid = request.getParameter("futurefield");
response.sendRedirect("lec.jsp#" + futid);
}
out.write("\n");
out.write("\t\t \n");
out.write("\t }\n");
out.write("\t \n");
out.write("\t \n");
out.write("\t </script>\n");
out.write("\t\n");
out.write("\n");
out.write("</body>\n");
out.write("</html> \n");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)) {
out = _jspx_out;
if (out != null && out.getBufferSize() != 0) out.clearBuffer();
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
else throw new ServletException(t);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}
/** Business logic to execute. */
public final Response executeCommand(
Object inputPar,
UserSessionParameters userSessionPars,
HttpServletRequest request,
HttpServletResponse response,
HttpSession userSession,
ServletContext context) {
String serverLanguageId = ((JAIOUserSessionParameters) userSessionPars).getServerLanguageId();
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = ConnectionManager.getConnection(context);
// fires the GenericEvent.CONNECTION_CREATED event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.CONNECTION_CREATED,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
null));
// retrieve companies list...
GridParams gridParams = (GridParams) inputPar;
String companies =
(String)
gridParams
.getOtherGridParams()
.get(ApplicationConsts.COMPANY_CODE_SYS01); // used in lookup grid...
if (companies == null) {
ArrayList companiesList =
((JAIOUserSessionParameters) userSessionPars).getCompanyBa().getCompaniesList("SAL06");
companies = "";
for (int i = 0; i < companiesList.size(); i++)
companies += "'" + companiesList.get(i).toString() + "',";
companies = companies.substring(0, companies.length() - 1);
} else companies = "'" + companies + "'";
String sql =
"select SAL06_CHARGES.COMPANY_CODE_SYS01,SAL06_CHARGES.CHARGE_CODE,SAL06_CHARGES.PROGRESSIVE_SYS10,"
+ "SYS10_TRANSLATIONS.DESCRIPTION,SAL06_CHARGES.VALUE,SAL06_CHARGES.PERC,SAL06_CHARGES.VAT_CODE_REG01,"
+ "SAL06_CHARGES.CURRENCY_CODE_REG03,SAL06_CHARGES.ENABLED"
+ " from SAL06_CHARGES,SYS10_TRANSLATIONS where "
+ "SAL06_CHARGES.PROGRESSIVE_SYS10=SYS10_TRANSLATIONS.PROGRESSIVE and "
+ "SYS10_TRANSLATIONS.LANGUAGE_CODE=? and "
+ "SAL06_CHARGES.ENABLED='Y' and "
+ "SAL06_CHARGES.COMPANY_CODE_SYS01 in ("
+ companies
+ ")";
Map attribute2dbField = new HashMap();
attribute2dbField.put("companyCodeSys01SAL06", "SAL06_CHARGES.COMPANY_CODE_SYS01");
attribute2dbField.put("chargeCodeSAL06", "SAL06_CHARGES.CHARGE_CODE");
attribute2dbField.put("descriptionSYS10", "SYS10_TRANSLATIONS.DESCRIPTION");
attribute2dbField.put("progressiveSys10SAL06", "SAL06_CHARGES.PROGRESSIVE_SYS10");
attribute2dbField.put("valueSAL06", "SAL06_CHARGES.VALUE");
attribute2dbField.put("percSAL06", "SAL06_CHARGES.PERC");
attribute2dbField.put("vatCodeReg01SAL06", "SAL06_CHARGES.VAT_CODE_REG01");
attribute2dbField.put("currencyCodeReg03SAL06", "SAL06_CHARGES.CURRENCY_CODE_REG03");
attribute2dbField.put("enabledSAL06", "SAL06_CHARGES.ENABLED");
ArrayList values = new ArrayList();
values.add(serverLanguageId);
// read from SAL06 table...
Response res =
CustomizeQueryUtil.getQuery(
conn,
userSessionPars,
sql,
values,
attribute2dbField,
ChargeVO.class,
"Y",
"N",
context,
gridParams,
50,
true,
new BigDecimal(292) // window identifier...
);
if (res.isError()) return res;
ArrayList list = ((VOListResponse) res).getRows();
ChargeVO vo = null;
sql =
"select SYS10_TRANSLATIONS.DESCRIPTION,REG01_VATS.VALUE,REG01_VATS.DEDUCTIBLE "
+ "from SYS10_TRANSLATIONS,REG01_VATS where "
+ "REG01_VATS.PROGRESSIVE_SYS10=SYS10_TRANSLATIONS.PROGRESSIVE and "
+ "SYS10_TRANSLATIONS.LANGUAGE_CODE=? and "
+ "REG01_VATS.VAT_CODE=?";
pstmt = conn.prepareStatement(sql);
ResultSet rset = null;
for (int i = 0; i < list.size(); i++) {
vo = (ChargeVO) list.get(i);
if (vo.getVatCodeReg01SAL06() != null) {
// retrieve vat data from REG01...
pstmt.setString(1, serverLanguageId);
pstmt.setString(2, vo.getVatCodeReg01SAL06());
rset = pstmt.executeQuery();
if (rset.next()) {
vo.setVatDescriptionSYS10(rset.getString(1));
vo.setVatValueREG01(rset.getBigDecimal(2));
vo.setVatDeductibleREG01(rset.getBigDecimal(3));
}
rset.close();
}
}
Response answer = res;
// fires the GenericEvent.BEFORE_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.BEFORE_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
return answer;
} catch (Throwable ex) {
Logger.error(
userSessionPars.getUsername(),
this.getClass().getName(),
"executeCommand",
"Error while fetching charges list",
ex);
return new ErrorResponse(ex.getMessage());
} finally {
try {
pstmt.close();
} catch (Exception ex2) {
}
try {
ConnectionManager.releaseConnection(conn, context);
} catch (Exception ex1) {
}
}
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
HttpSession session = request.getSession(true);
try {
Object accountObject = session.getValue(ACCOUNT);
// If no account object was put in the session, or
// if one exists but it is not a hashtable, then
// redirect the user to the original login page
if (accountObject == null)
throw new RuntimeException("You need to log in to use this service!");
if (!(accountObject instanceof Hashtable))
throw new RuntimeException("You need to log in to use this service!");
Hashtable account = (Hashtable) accountObject;
String userName = (String) account.get("name");
//////////////////////////////////////////////
// Display Messages for the user who logged in
//////////////////////////////////////////////
out.println("<HTML>");
out.println("<HEAD>");
out.println("<TITLE>Contacts for " + userName + "</TITLE>");
out.println("</HEAD>");
out.println("<BODY BGCOLOR='#EFEFEF'>");
out.println("<H3>Welcome " + userName + "</H3>");
out.println("<CENTER>");
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
con =
DriverManager.getConnection(
"jdbc:mysql://localhost/contacts?user=kareena&password=kapoor");
stmt = con.createStatement();
rs =
stmt.executeQuery(
"SELECT * FROM contacts WHERE userName='******' ORDER BY contactID");
out.println("<form name='deleteContactsForm' method='post' action='deleteContact'>");
out.println("<TABLE BGCOLOR='#EFEFFF' CELLPADDING='2' CELLSPACING='4' BORDER='1'>");
out.println("<TR BGCOLOR='#D6DFFF'>");
out.println("<TD ALIGN='center'><B>Contact ID</B></TD>");
out.println("<TD ALIGN='center'><B>Contact Name</B></TD>");
out.println("<TD ALIGN='center'><B>Comment</B></TD>");
out.println("<TD ALIGN='center'><B>Date</B></TD>");
out.println("<TD ALIGN='center'><B>Delete Contacts</B></TD>");
out.println("</TR>");
int nRows = 0;
while (rs.next()) {
nRows++;
String messageID = rs.getString("contactID");
String fromUser = rs.getString("contactName");
String message = rs.getString("comments");
String messageDate = rs.getString("dateAdded");
out.println("<TR>");
out.println("<TD>" + messageID + "</TD>");
out.println("<TD>" + fromUser + "</TD>");
out.println("<TD>" + message + "</TD>");
out.println("<TD>" + messageDate + "</TD>");
out.println(
"<TD><input type='checkbox' name='msgList' value='" + messageID + "'> Delete</TD>");
out.println("</TR>");
}
out.println("<TR>");
out.println(
"<TD COLSPAN='6' ALIGN='center'><input type='submit' value='Delete Selected Contacts'></TD>");
out.println("</TR>");
out.println("</TABLE>");
out.println("</FORM>");
} catch (Exception e) {
out.println("Could not connect to the users database.<P>");
out.println("The error message was");
out.println("<PRE>");
out.println(e.getMessage());
out.println("</PRE>");
} finally {
if (rs != null) {
try {
rs.close();
} catch (SQLException ignore) {
}
}
if (stmt != null) {
try {
stmt.close();
} catch (SQLException ignore) {
}
}
if (con != null) {
try {
con.close();
} catch (SQLException ignore) {
}
}
}
out.println("</CENTER>");
out.println("</BODY>");
out.println("</HTML>");
} catch (RuntimeException e) {
out.println("<script language=\"javascript\">");
out.println("alert(\"You need to log in to use this service!\");");
out.println("</script>");
out.println("<a href='index.html'>Click Here</a> to go to the main page.<br><br>");
out.println(
"Or Click on the button to exit<FORM><INPUT onClick=\"javascipt:window.close()\" TYPE=\"BUTTON\" VALUE=\"Close Browser\" TITLE=\"Click here to close window\" NAME=\"CloseWindow\" STYLE=\"font-family:Verdana, Arial, Helvetica; font-size:smaller; font-weight:bold\"></FORM>");
log(e.getMessage());
return;
}
}
/** Business logic to execute. */
public VOListResponse loadItemVariants(GridParams pars, String serverLanguageId, String username)
throws Throwable {
PreparedStatement pstmt = null;
Connection conn = null;
try {
if (this.conn == null) conn = getConn();
else conn = this.conn;
String tableName = (String) pars.getOtherGridParams().get(ApplicationConsts.TABLE_NAME);
ItemPK pk = (ItemPK) pars.getOtherGridParams().get(ApplicationConsts.ITEM_PK);
String productVariant = (String) productVariants.get(tableName);
String variantType = (String) variantTypes.get(tableName);
String variantTypeJoin = (String) variantTypeJoins.get(tableName);
String variantCodeJoin = (String) variantCodeJoins.get(tableName);
String sql =
"select "
+ tableName
+ "."
+ variantTypeJoin
+ ","
+ tableName
+ ".VARIANT_CODE,A.DESCRIPTION,B.DESCRIPTION, "
+ tableName
+ ".PROGRESSIVE_SYS10,"
+ variantType
+ ".PROGRESSIVE_SYS10 "
+ "from "
+ tableName
+ ","
+ variantType
+ ",SYS10_COMPANY_TRANSLATIONS A,SYS10_COMPANY_TRANSLATIONS B "
+ "where "
+ tableName
+ ".COMPANY_CODE_SYS01=? and "
+ tableName
+ ".COMPANY_CODE_SYS01="
+ variantType
+ ".COMPANY_CODE_SYS01 and "
+ tableName
+ "."
+ variantTypeJoin
+ "="
+ variantType
+ ".VARIANT_TYPE and "
+ tableName
+ ".COMPANY_CODE_SYS01=A.COMPANY_CODE_SYS01 and "
+ tableName
+ ".PROGRESSIVE_SYS10=A.PROGRESSIVE and A.LANGUAGE_CODE=? and "
+ variantType
+ ".COMPANY_CODE_SYS01=B.COMPANY_CODE_SYS01 and "
+ variantType
+ ".PROGRESSIVE_SYS10=B.PROGRESSIVE and B.LANGUAGE_CODE=? and "
+ tableName
+ ".ENABLED='Y' and "
+ variantType
+ ".ENABLED='Y' and "
+ // and not "+tableName+"."+variantTypeJoin+"=? and "+
"not "
+ tableName
+ ".VARIANT_CODE=? "
+ "order by "
+ tableName
+ "."
+ variantTypeJoin
+ ","
+ tableName
+ ".CODE_ORDER";
Map attribute2dbField = new HashMap();
attribute2dbField.put("variantType", tableName + "." + variantTypeJoin);
attribute2dbField.put("variantCode", tableName + ".VARIANT_CODE");
attribute2dbField.put("variantDesc", "A.DESCRIPTION");
attribute2dbField.put("variantTypeDesc", "B.DESCRIPTION");
attribute2dbField.put("variantProgressiveSys10", tableName + ".PROGRESSIVE_SYS10");
attribute2dbField.put("variantTypeProgressiveSys10", variantType + ".PROGRESSIVE_SYS10");
ArrayList values = new ArrayList();
values.add(pk.getCompanyCodeSys01ITM01());
values.add(serverLanguageId);
values.add(serverLanguageId);
// values.add(ApplicationConsts.JOLLY);
values.add(ApplicationConsts.JOLLY);
// read from ITMxxx table...
Response answer =
QueryUtil.getQuery(
conn,
new UserSessionParameters(username),
sql,
values,
attribute2dbField,
ItemVariantVO.class,
"Y",
"N",
null,
pars,
50,
true);
if (!answer.isError()) {
java.util.List vos = ((VOListResponse) answer).getRows();
HashMap map = new HashMap();
ItemVariantVO vo = null;
for (int i = 0; i < vos.size(); i++) {
vo = (ItemVariantVO) vos.get(i);
vo.setCompanyCodeSys01(pk.getCompanyCodeSys01ITM01());
vo.setItemCodeItm01(pk.getItemCodeITM01());
vo.setTableName(tableName);
map.put(vo.getVariantType() + "." + vo.getVariantCode(), vo);
}
pstmt =
conn.prepareStatement(
"select "
+ productVariant
+ "."
+ variantTypeJoin
+ ","
+ productVariant
+ "."
+ variantCodeJoin
+ " "
+ "from "
+ productVariant
+ " "
+ "where "
+ productVariant
+ ".COMPANY_CODE_SYS01=? and "
+ productVariant
+ ".ITEM_CODE_ITM01=? and "
+ productVariant
+ ".ENABLED='Y' ");
pstmt.setString(1, pk.getCompanyCodeSys01ITM01());
pstmt.setString(2, pk.getItemCodeITM01());
ResultSet rset = pstmt.executeQuery();
while (rset.next()) {
vo = (ItemVariantVO) map.get(rset.getString(1) + "." + rset.getString(2));
if (vo != null) vo.setSelected(Boolean.TRUE);
}
rset.close();
pstmt.close();
}
if (answer.isError()) throw new Exception(answer.getErrorMessage());
else return (VOListResponse) answer;
} catch (Throwable ex) {
Logger.error(
username,
this.getClass().getName(),
"getItemVariants",
"Error while fetching item variants list",
ex);
throw new Exception(ex.getMessage());
} finally {
try {
pstmt.close();
} catch (Exception ex2) {
}
try {
if (this.conn == null && conn != null) {
// close only local connection
conn.commit();
conn.close();
}
} catch (Exception exx) {
}
}
}