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();
ServletContext application;
HttpSession session = request.getSession();
nseer_db_backup1 finance_db = new nseer_db_backup1(dbApplication);
try {
if (finance_db.conn((String) dbSession.getAttribute("unit_db_name"))) {
String finance_cheque_id = request.getParameter("finance_cheque_id");
String sql = "delete from finance_bill where id='" + finance_cheque_id + "'";
finance_db.executeUpdate(sql);
finance_db.commit();
finance_db.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();
nseer_db_backup1 stock_db = new nseer_db_backup1(dbApplication);
try {
if (stock_db.conn((String) dbSession.getAttribute("unit_db_name"))) {
int i;
int intRowCount;
String sqll =
"select * from stock_config_public_char where describe1='\u51fa\u5165\u5e93\u7406\u7531'";
ResultSet rs = stock_db.executeQuery(sqll);
rs.next();
rs.last();
intRowCount = rs.getRow();
String[] del = new String[intRowCount];
del = (String[]) dbSession.getAttribute("del");
if (del != null) {
for (i = 1; i <= intRowCount; i++) {
String sql = "delete from stock_config_public_char where id='" + del[i - 1] + "'";
stock_db.executeUpdate(sql);
}
}
stock_db.commit();
stock_db.close();
response.sendRedirect("stock/config/apply_gather_pay/reason.jsp");
} 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();
PrintWriter out = response.getWriter();
MakePdf mm = new MakePdf();
excel query = new excel();
getKeyColumn column = new getKeyColumn();
mm.setConfigFile("xml/stock/pdf_export.xml");
String sql = "";
String tablename = request.getParameter("tablename");
String condition = "";
String queue = "";
if (tablename.equals("stock_balance")) {
queue = "order by chain_ID";
condition = "where address_group!=''";
}
sql = "select * from " + tablename + " " + condition + " " + queue;
int a = sql.indexOf("*");
String sqla = sql.substring(0, a) + "count(*) as A" + sql.substring(a + 1, sql.length());
mm.make(
(String) dbSession.getAttribute("unit_db_name"),
tablename,
sqla,
sql,
"pdf_files/stock_data",
1500,
session);
int fileAmount = mm.fileAmount();
response.sendRedirect("stock/export/pdf_ok_a.jsp?file_amount=" + fileAmount + "");
} catch (Exception ex) {
ex.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");
response.setHeader("X-Powered-By", "JSP/2.2");
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");
response.sendRedirect(request.getContextPath() + "/main");
} 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);
}
}
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 void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
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 {
_jspxFactory = JspFactory.getDefaultFactory();
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("\n\n\n\n\n\n\n\n\n\n\n");
org.jivesoftware.util.WebManager webManager = null;
synchronized (_jspx_page_context) {
webManager =
(org.jivesoftware.util.WebManager)
_jspx_page_context.getAttribute("webManager", PageContext.PAGE_SCOPE);
if (webManager == null) {
webManager = new org.jivesoftware.util.WebManager();
_jspx_page_context.setAttribute("webManager", webManager, PageContext.PAGE_SCOPE);
}
}
out.write('\n');
webManager.init(request, response, session, application, out);
DBManager dbManager = DBManager.getInstance();
Iterator<User> users = webManager.getUserManager().getUsers().iterator();
Msn msn = null;
// Get Action
boolean create = request.getParameter("create") != null;
boolean cancel = request.getParameter("cancel") != null;
// Get data
Map<String, String> errors = new HashMap<String, String>();
if (cancel) {
String user = request.getParameter("user");
if (user != null & !"".equals(user)) {
response.sendRedirect("pf-main.jsp?user="******"pf-main.jsp");
}
return;
}
if (create) {
String input_jid = null;
try {
input_jid = request.getParameter("jid");
String input_msn = request.getParameter("msn");
String input_enable = request.getParameter("enable");
if (input_jid == null || "".equals(input_jid)) {
errors.put("add_msn_error", "jid can not be null");
}
if (input_msn == null || "".equals(input_msn)) {
errors.put("add_msn_error", "msn can not be null");
}
int enable = 0;
if (input_enable == null) {
enable = 0;
} else {
enable = 1;
}
dbManager.addMsn(input_jid, input_msn, enable);
} catch (Exception e) {
Log.error(e);
errors.put("add_msn_error", e.getLocalizedMessage());
}
if (errors.isEmpty()) {
response.sendRedirect("pf-main.jsp?user="******"\n<html>\n<head>\n <title>\n ");
if (_jspx_meth_fmt_message_0(_jspx_page_context)) return;
out.write(
"\n\n </title>\n <meta name=\"pageID\" content=\"addMsn\"/>\n <script language=\"JavaScript\" type=\"text/javascript\" src=\"scripts/packetfilter.js\"></script>\n</head>\n<body>\n\n");
if (!errors.isEmpty()) {
out.write(
"\n\n<div class=\"jive-error\">\n <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n <tbody>\n <tr>\n <td class=\"jive-icon\"><img src=\"/images/error-16x16.gif\" width=\"16\" height=\"16\" border=\"0\"/></td>\n <td class=\"jive-icon-label\">\n\n ");
if (errors.get("add_msn_error") != null) {
out.write("\n ");
out.print(errors.get("add_msn_error"));
out.write("\n ");
}
out.write(
"\n </td>\n </tr>\n </tbody>\n </table>\n</div>\n<br>\n\n");
}
out.write(
"\n\n<form action=\"msn-form.jsp\" method=\"get\">\n <div class=\"jive-table\">\n <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n <tbody>\n <tr class=\"jive-even\">\n <td>JID</td>\n <td>\n <select name=\"jid\" id=\"jid\">\n ");
if (users != null) {
while (users.hasNext()) {
User user = users.next();
out.write("\n <option value=\"");
out.print(user.getUsername());
out.write('"');
out.write('>');
out.print(user.getUsername());
out.write("</option>\n ");
}
}
out.write("\n </select>\n\n\n ");
// <input type="text" name="jid" value="" size="40"/>
out.write(
"\n </td>\n </tr>\n <tr class=\"jive-odd\">\n <td>Msn</td>\n <td>\n <input type=\"text\" name=\"msn\" value=\"\" size=\"40\"/>\n </td>\n\n </tr>\n <tr class=\"jive-even\">\n <td>Enable</td>\n <td>\n <input type=\"checkbox\" name=\"enable\" value=\"true\" checked>\n </td>\n\n </tr>\n\n\n <tr>\n <td>\n <input type=\"submit\" name=\"create\" value=\"");
if (_jspx_meth_fmt_message_1(_jspx_page_context)) return;
out.write("\">\n <input type=\"submit\" name=\"cancel\" value=\"");
if (_jspx_meth_fmt_message_2(_jspx_page_context)) return;
out.write(
"\">\n </td>\n <td> </td>\n </tr>\n </tbody>\n </table>\n\n </div>\n</form>\n\n</body>\n</html>\n\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);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
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 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 oa_db = new nseer_db_backup1(dbApplication);
if (oa_db.conn((String) dbSession.getAttribute("unit_db_name"))) {
getAttachmentLength getAttachmentLength = new getAttachmentLength();
getAttachmentType getAttachmentType = new getAttachmentType();
double d =
getAttachmentLength.getAttachmentLength(
(String) dbSession.getAttribute("unit_db_name"), "document_config_public_char");
String ee =
getAttachmentType.getAttachmentType(
(String) dbSession.getAttribute("unit_db_name"), "document_config_public_char");
mySmartUpload.initialize(pageContext);
mySmartUpload.upload();
String[] file_name = new String[mySmartUpload.getFiles().getCount()];
int j = 0;
int filenum1 =
count.read((String) dbSession.getAttribute("unit_db_name"), "oaMessagecount");
String message_ID = filenum1 + "";
count.write((String) dbSession.getAttribute("unit_db_name"), "oaMessagecount", filenum1);
String sql1 = "select * from oa_message where message_ID='" + message_ID + "'";
ResultSet rs = oa_db.executeQuery(sql1);
if (j != 0 || rs.next()) {
response.sendRedirect("oa/message/register_ok_a.jsp");
} else {
String subject = mySmartUpload.getRequest().getParameter("subject");
String message_type = mySmartUpload.getRequest().getParameter("message_type");
String register = mySmartUpload.getRequest().getParameter("register");
String register_ID = mySmartUpload.getRequest().getParameter("register_ID");
String register_time = mySmartUpload.getRequest().getParameter("register_time");
String bulletin = mySmartUpload.getRequest().getParameter("bulletin");
String content = exchange.toHtmlFCK(mySmartUpload.getRequest().getParameter("content"));
String bodyab =
new String(
mySmartUpload.getRequest().getParameter("remark").getBytes("UTF-8"), "UTF-8");
String remark = exchange.toHtml(bodyab);
if (j != 0) {
response.sendRedirect("oa/message/register_ok_c.jsp");
} else {
String sqla = "";
String sqlb = "";
if (bulletin == null) {
sqla =
"insert into oa_message(register,register_ID,register_time,message_ID,subject,type,content,remark";
sqlb =
") values ('"
+ register
+ "','"
+ register_ID
+ "','"
+ register_time
+ "','"
+ message_ID
+ "','"
+ subject
+ "','"
+ message_type
+ "','"
+ content
+ "','"
+ remark
+ "'";
} else {
sqla =
"insert into oa_message(register,register_ID,register_time,message_ID,subject,type,content,remark,check_tag";
sqlb =
") values ('"
+ register
+ "','"
+ register_ID
+ "','"
+ register_time
+ "','"
+ message_ID
+ "','"
+ subject
+ "','"
+ message_type
+ "','"
+ content
+ "','"
+ remark
+ "','2'";
}
String sql = sqla + sqlb + ")";
oa_db.executeUpdate(sql);
response.sendRedirect("oa/message/register_ok_b.jsp");
}
}
oa_db.commit();
oa_db.close();
} else {
response.sendRedirect("error_conn.htm");
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
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 {
_jspxFactory = JspFactory.getDefaultFactory();
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\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n");
org.jivesoftware.util.WebManager webManager = null;
synchronized (_jspx_page_context) {
webManager =
(org.jivesoftware.util.WebManager)
_jspx_page_context.getAttribute("webManager", PageContext.PAGE_SCOPE);
if (webManager == null) {
webManager = new org.jivesoftware.util.WebManager();
_jspx_page_context.setAttribute("webManager", webManager, PageContext.PAGE_SCOPE);
}
}
out.write('\r');
out.write('\n');
webManager.init(request, response, session, application, out);
boolean save = request.getParameter("save") != null;
boolean success = request.getParameter("success") != null;
String persistentRosterParam = request.getParameter("persistentEnabled");
boolean persistentRoster =
persistentRosterParam == null ? false : persistentRosterParam.equals("true");
String ignoreSubdomainsParam = request.getParameter("ignoreSubdomains");
boolean ignnoreSubdomains =
ignoreSubdomainsParam == null ? false : ignoreSubdomainsParam.equals("true");
String blockPresencesParam = request.getParameter("blockPresences");
boolean blockPresences =
blockPresencesParam == null ? false : blockPresencesParam.equals("true");
String sparkdiscoParam = request.getParameter("sparkDiscoInfo");
boolean sparkDiscoInfo = sparkdiscoParam == null ? false : sparkdiscoParam.equals("true");
String iqLastFilterPram = request.getParameter("iqLastFilter");
boolean iqLastFilter = iqLastFilterPram == null ? false : iqLastFilterPram.equals("true");
String mucFilterParam = request.getParameter("mucFilter");
boolean mucFilter = mucFilterParam == null ? false : mucFilterParam.equals("true");
String gajimBroadcastParam = request.getParameter("gajimBroadcast");
boolean gajimBroadcast =
gajimBroadcastParam == null ? false : gajimBroadcastParam.equals("true");
String[] componentsEnabled = request.getParameterValues("enabledComponents[]");
PermissionManager _pmanager = new PermissionManager();
DatabaseManager _db;
Map<String, String> errors = new HashMap<String, String>();
if (save) {
for (String property : JiveGlobals.getPropertyNames("plugin.remoteroster.jids")) {
JiveGlobals.deleteProperty(property);
}
if (componentsEnabled != null) {
for (int i = 0; i < componentsEnabled.length; i++) {
JiveGlobals.setProperty("plugin.remoteroster.jids." + componentsEnabled[i], "true");
String group = request.getParameter("input_group." + componentsEnabled[i]);
if (group != null) {
_pmanager.setGroupForGateway(componentsEnabled[i], group);
}
}
}
JiveGlobals.setProperty(
"plugin.remoteroster.persistent", (persistentRoster ? "true" : "false"));
JiveGlobals.setProperty(
"plugin.remoteroster.blockPresences", (blockPresences ? "true" : "false"));
JiveGlobals.setProperty(
"plugin.remoteroster.sparkDiscoInfo", (sparkDiscoInfo ? "true" : "false"));
JiveGlobals.setProperty(
"plugin.remoteroster.iqLastFilter", (iqLastFilter ? "true" : "false"));
JiveGlobals.setProperty("plugin.remoteroster.mucFilter", (mucFilter ? "true" : "false"));
JiveGlobals.setProperty(
"plugin.remoteroster.gajimBroadcast", (gajimBroadcast ? "true" : "false"));
JiveGlobals.setProperty(
"plugin.remoteroster.ignoreSubdomains", (ignnoreSubdomains ? "true" : "false"));
response.sendRedirect("rr-main.jsp?success=true");
return;
}
// Get the session manager
SessionManager sessionManager = webManager.getSessionManager();
Collection<ComponentSession> sessions = sessionManager.getComponentSessions();
_db = DatabaseManager.getInstance();
out.write(
"\r\n\r\n<html>\r\n<head>\r\n<title>Gojara Settings</title>\r\n<link href=\"./css/rr.css\" rel=\"stylesheet\" type=\"text/css\">\r\n<script src=\"./js/http.js\" type=\"text/javascript\"></script>\r\n<script src=\"./js/jquery.js\" type=\"text/javascript\"></script>\r\n<script src=\"./js/rr.js\" type=\"text/javascript\"></script>\r\n<script src=\"./js/jquery.sparkline.js\" type=\"text/javascript\"></script>\r\n<script src=\"./js/jquery.horiz-bar-graph.js\" type=\"text/javascript\"></script>\r\n<!--[if lte IE 8]><script language=\"javascript\" type=\"text/javascript\" src=\"./js/excanvas.min.js\"></script><![endif]-->\r\n<script language=\"javascript\" type=\"text/javascript\" src=\"./js/jquery.flot.js\"></script>\r\n<script language=\"javascript\" type=\"text/javascript\" src=\"./js/jquery.flot.pie.js\"></script>\r\n\r\n<meta name=\"pageID\" content=\"remoteRoster\" />\r\n<meta name=\"helpPage\" content=\"\" />\r\n\r\n</head>\r\n<body>\r\n\r\n\t<p>Any components configured here will allow the external component associated with them full control over their\r\n\t\tdomain within any user's roster. Before enabling Remote Roster Management support for an external component, first\r\n");
out.write(
"\t\tconnect it like you would any external component. Once it has connected and registered with Openfire, it's JID should\r\n\t\tshow up below and you can enable Remote Roster support.</p>\r\n\r\n\t");
if (success) {
out.write(
"\r\n\r\n\t<div class=\"jive-success\">\r\n\t\t<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\r\n\t\t\t<tbody>\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td class=\"jive-icon\"><img src=\"images/success-16x16.gif\" width=\"16\" height=\"16\" border=\"0\" alt=\"\"></td>\r\n\t\t\t\t\t<td class=\"jive-icon-label\">Settings saved!</td>\r\n\t\t\t\t</tr>\r\n\t\t\t</tbody>\r\n\t\t</table>\r\n\t</div>\r\n\t<br>\r\n\r\n\t");
} else if (errors.size() > 0) {
out.write(
"\r\n\r\n\t<div class=\"jive-error\">\r\n\t\t<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\r\n\t\t\t<tbody>\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td class=\"jive-icon\"><img src=\"images/error-16x16.gif\" width=\"16\" height=\"16\" border=\"0\" alt=\"\"></td>\r\n\t\t\t\t\t<td class=\"jive-icon-label\">Error saving settings!</td>\r\n\t\t\t\t</tr>\r\n\t\t\t</tbody>\r\n\t\t</table>\r\n\t</div>\r\n\t<br>\r\n\r\n\t");
}
out.write(
"\r\n\r\n\t<form action=\"rr-main.jsp?save\" method=\"post\">\r\n\r\n\t\t<div class=\"jive-contentBoxHeader\">Connected Gateway Components</div>\r\n\t\t<div class=\"jive-contentBox\">\r\n\r\n\t\t\t<p>Select which components you want to enable remote roster on:</p>\r\n\t\t\t");
boolean gatewayFound = false;
int i = 0;
for (ComponentSession componentSession : sessions) {
if (!componentSession.getExternalComponent().getCategory().equals("gateway")) {
continue;
}
gatewayFound = true;
long incoming = componentSession.getNumClientPackets();
long outgoing = componentSession.getNumServerPackets();
long both = incoming + outgoing;
int incomingPercent = (int) (incoming * 100 / both);
int outgoingPercent = (int) (outgoing * 100 / both);
out.write(
"\r\n\t\t\t<table class=\"gatewayHeader\">\r\n\t\t\t\t<tbody>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td class=\"gatewayCheckbox\"><input type=\"checkbox\" name=\"enabledComponents[]\"\r\n\t\t\t\t\t\t\tvalue=\"");
out.print(componentSession.getExternalComponent().getInitialSubdomain());
out.write("\"\r\n\t\t\t\t\t\t\t");
out.print(
JiveGlobals.getBooleanProperty(
"plugin.remoteroster.jids."
+ componentSession.getExternalComponent().getInitialSubdomain(),
false)
? "checked=\"checked\""
: "");
out.write(" />\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td class=\"gatewayName\">");
out.print(componentSession.getExternalComponent().getName());
out.write(
"</td>\r\n\t\t\t\t\t\t<td class=\"gatewayIcons\"><img src=\"images/log-16x16.png\" onclick=\"slideToggle('#logs");
out.print(i);
out.write(
"')\"><img\r\n\t\t\t\t\t\t\tsrc=\"images/permissions-16x16.png\" id=\"showPermissions\" onclick=\"slideToggle('#permission");
out.print(i);
out.write(
"')\"><img\r\n\t\t\t\t\t\t\tsrc=\"images/info-16x16.png\" id=\"showConfig\" onclick=\"slideToggle('#config");
out.print(i);
out.write(
"')\"></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t</tbody>\r\n\t\t\t</table>\r\n\t\t\t<div id=\"config");
out.print(i);
out.write(
"\" class=\"slider\">\r\n\t\t\t\t<div class=\"sildeHeader\">Information</div>\r\n\t\t\t\t<table class=\"configTable\">\r\n\t\t\t\t\t<tbody>\r\n\t\t\t\t\t\t<tr id=\"logodd\">\r\n\t\t\t\t\t\t\t<td width=\"200px\">Domain:</td>\r\n\t\t\t\t\t\t\t<td>");
out.print(componentSession.getExternalComponent().getInitialSubdomain());
out.write(
"</td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr id=\"logeven\">\r\n\t\t\t\t\t\t\t<td>Status:</td>\r\n\t\t\t\t\t\t\t<td>Online</td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr id=\"logodd\">\r\n\t\t\t\t\t\t\t<td>Packages Send/Received:</td>\r\n\t\t\t\t\t\t\t<td><dl class=\"browser-data\" title=\"\">\r\n\t\t\t\t\t\t\t\t\t<dt>Incoming</dt>\r\n\t\t\t\t\t\t\t\t\t<dd>");
out.print(incomingPercent);
out.write("</dd>\r\n\t\t\t\t\t\t\t\t\t<dt>Outgoing</dt>\r\n\t\t\t\t\t\t\t\t\t<dd>");
out.print(outgoingPercent);
out.write(
"</dd>\r\n\t\t\t\t\t\t\t\t</dl></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t</tbody>\r\n\t\t\t\t</table>\r\n\t\t\t</div>\r\n\t\t\t<div id=\"permission");
out.print(i);
out.write(
"\" class=\"slider\">\r\n\t\t\t\t<div class=\"sildeHeader\">Access control</div>\r\n\t\t\t\t<table class=\"groupTable\">\r\n\t\t\t\t\t<tbody>\r\n\t\t\t\t\t\t<tr id=\"loghead\">\r\n\t\t\t\t\t\t\t<td colspan=\"3\">You can limit the access to the external component to an existing group</td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<td class=\"permissionTableColumn\">Groupname:</td>\r\n\t\t\t\t\t\t\t<td><input class=\"groupInput\" type=\"text\" id=\"groupSearch");
out.print(i);
out.write("\"\r\n\t\t\t\t\t\t\t\tname=\"input_group.");
out.print(componentSession.getExternalComponent().getInitialSubdomain());
out.write("\" alt=\"Find Groups\"\r\n\t\t\t\t\t\t\t\tonkeyup=\"searchSuggest('");
out.print(i);
out.write("');\" autocomplete=\"off\"\r\n\t\t\t\t\t\t\t\tvalue=\"");
out.print(
_pmanager.getGroupForGateway(
componentSession.getExternalComponent().getInitialSubdomain()));
out.write("\">\r\n\t\t\t\t\t\t\t\t<div id=\"search_suggest");
out.print(i);
out.write(
"\"></div></td>\r\n\t\t\t\t\t\t\t<td style=\"vertical-align: top;\">\r\n\t\t\t\t\t\t\t\t<div class=\"ajaxloading\" id=\"ajaxloading");
out.print(i);
out.write(
"\"></div>\r\n\t\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t</tbody>\r\n\t\t\t\t</table>\r\n\t\t\t</div>\r\n\t\t\t<div id=\"logs");
out.print(i);
out.write("\" class=\"slider\">\r\n\t\t\t\t");
int iqs =
_db.getPacketCount(
componentSession.getExternalComponent().getInitialSubdomain(),
Class.forName("org.xmpp.packet.IQ"));
int msgs =
_db.getPacketCount(
componentSession.getExternalComponent().getInitialSubdomain(),
Class.forName("org.xmpp.packet.Message"));
int rosters =
_db.getPacketCount(
componentSession.getExternalComponent().getInitialSubdomain(),
Class.forName("org.xmpp.packet.Roster"));
int presences =
_db.getPacketCount(
componentSession.getExternalComponent().getInitialSubdomain(),
Class.forName("org.xmpp.packet.Presence"));
out.write(
"\r\n\t\t\t\t<div class=\"sildeHeader\">Logs & Statistics</div>\r\n\r\n\t\t\t\t<table class=\"logtable\">\r\n\t\t\t\t\t<tfoot>\r\n\t\t\t\t\t\t<tr id=\"logfoot\">\r\n\t\t\t\t\t\t\t<td colspan=\"2\">Packages being logged for ");
out.print(JiveGlobals.getIntProperty("plugin.remoteroster.log.cleaner.minutes", 60));
out.write(
"\r\n\t\t\t\t\t\t\t\tminutes\r\n\t\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t\t<td><a style=\"float: right;\"\r\n\t\t\t\t\t\t\t\tonClick=\"window.open('liveStats.jsp?component=");
out.print(componentSession.getExternalComponent().getInitialSubdomain());
out.write(
"','mywindow','width=1200,height=700')\">Show\r\n\t\t\t\t\t\t\t\t\trealtime Log</a>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t</tfoot>\r\n\t\t\t\t\t<tbody>\r\n\t\t\t\t\t\t<tr id=\"loghead\">\r\n\t\t\t\t\t\t\t<td width=\"200px\">Paket type</td>\r\n\t\t\t\t\t\t\t<td width=\"100px\">Number</td>\r\n\t\t\t\t\t\t\t<td></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr id=\"logodd\">\r\n\t\t\t\t\t\t\t<td>IQ</td>\r\n\t\t\t\t\t\t\t<td id=\"logiq");
out.print(i);
out.write('"');
out.write('>');
out.print(iqs);
out.write("</td>\r\n\t\t\t\t\t\t\t<td rowspan=\"5\"><div id=\"pie");
out.print(i);
out.write(
"\" class=\"graph\"></div></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr id=\"logeven\">\r\n\t\t\t\t\t\t\t<td>Messages</td>\r\n\t\t\t\t\t\t\t<td id=\"logmsg");
out.print(i);
out.write('"');
out.write('>');
out.print(msgs);
out.write(
"</td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr id=\"logodd\">\r\n\t\t\t\t\t\t\t<td>Roster</td>\r\n\t\t\t\t\t\t\t<td id=\"logroster");
out.print(i);
out.write('"');
out.write('>');
out.print(rosters);
out.write(
"</td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr id=\"logeven\">\r\n\t\t\t\t\t\t\t<td>Presence</td>\r\n\t\t\t\t\t\t\t<td id=\"logpresence");
out.print(i);
out.write('"');
out.write('>');
out.print(presences);
out.write(
"</td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr id=\"logodd\">\r\n\t\t\t\t\t\t\t<td><span style=\"font-weight: bold;\">Total:</span></td>\r\n\t\t\t\t\t\t\t<td><span style=\"font-weight: bold;\">");
out.print(iqs + msgs + rosters + presences);
out.write(
"</span></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t</tbody>\r\n\t\t\t\t</table>\r\n\r\n\t\t\t</div>\r\n\r\n\r\n\t\t\t");
++i;
}
out.write("\r\n\t\t\t");
if (!gatewayFound) {
out.write(
"\r\n\t\t\t<span style=\"font-weight: bold\">No connected external gateway components found.</span>\r\n\t\t\t");
}
out.write(
"\r\n\t\t</div>\r\n\t\t\r\n\t\t\r\n<div class=\"jive-contentBoxHeader\">General Options</div>\r\n<div class=\"jive-contentBox\">\r\n <table cellpadding=\"3\" cellspacing=\"0\" border=\"0\" width=\"100%\">\r\n <tbody>\r\n <tr valign=\"top\">\r\n <td width=\"100%\">\r\n <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\r\n <tbody>\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td><input type=\"checkbox\" name=\"persistentEnabled\" id=\"GO1\" value=\"true\"\r\n\t\t\t\t\t\t");
out.print(
JiveGlobals.getBooleanProperty("plugin.remoteroster.persistent", false)
? "checked=\"checked\""
: "");
out.write(
" />\r\n\r\n\t\t\t\t\t</td>\r\n\t\t\t\t\t<td><label for=\"GO1\">Enable persistent Roster</label></td>\r\n\t\t\t\t</tr>\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td />\r\n\t\t\t\t\t<td align=\"left\" style=\"font-size: -3; color: grey\">When Persistent-Roster is enabled, contacts will be saved to database and\r\n\t\t\t\t\tno contacts will be deleted\tby GoJara automatically.<br>\t\t\t\t\t\r\n\t\t\t\t\tWhen Persistent-Roster is disabled, contacts will not be saved to database and \r\n\t\t\t\t\tGoJara will automatically delete all Legacy-RosterItems from the OF-Roster of a User upon logout.<br>Enable this if you want to store Gateway contacts in DB. </td>\r\n\t\t\t\t</tr>\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td><input type=\"checkbox\" name=\"mucFilter\" id=\"GO2\" value=\"true\"\r\n\t\t\t\t\t\t");
out.print(
JiveGlobals.getBooleanProperty("plugin.remoteroster.mucFilter", false)
? "checked=\"checked\""
: "");
out.write(
" />\r\n\t\t\t\t\t</td>\r\n\t\t\t\t\t<td><label for=\"GO2\">Only allow internal Jabber Conferences</label></td>\r\n\t\t\t\t</tr>\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td />\r\n\t\t\t\t\t<td align=\"left\" style=\"font-size: -3; color: grey\">Spectrum might add MUC(Multi User Chat) to supported features\r\n\t\t\t\t\t of some Transports. If this should not be allowed, because only internal Jabber Conferences should be used, GoJara\r\n\t\t\t\t\t can remove these.</td>\r\n\t\t\t\t</tr>\r\n\t\t\t\t\r\n\t\t\t\t\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td><input type=\"checkbox\" name=\"ignoreSubdomains\" id=\"GO3\" value=\"true\"\r\n\t\t\t\t\t\t");
out.print(
JiveGlobals.getBooleanProperty("plugin.remoteroster.ignoreSubdomains", true)
? "checked=\"checked\""
: "");
out.write(
" />\r\n\t\t\t\t\t</td>\r\n\t\t\t\t\t<td><label for=\"GO2\">Do not add Subdomains to Roster</label></td>\r\n\t\t\t\t</tr>\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td />\r\n\t\t\t\t\t<td align=\"left\" style=\"font-size: -3; color: grey\">If you do not want the gateway itself to show up as a contact on your roster,\r\n\t\t\t\t\tenable this (only happens on registration).\r\n\t\t\t\t\t</td>\r\n\t\t\t\t</tr>\r\n\r\n </tbody>\r\n </table>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n</div>\r\n\r\n\t\t<br /> <br />\r\n\t\t<div class=\"jive-contentBoxHeader\">Client specific options</div>\r\n\t\t<div class=\"jive-contentBox\">\r\n\t\t\t<table cellpadding=\"3\" cellspacing=\"0\" border=\"0\" width=\"100%\">\r\n\t\t\t\t<tbody>\r\n\t\t\t\t\t<tr valign=\"top\">\r\n\t\t\t\t\t\t<td width=\"1%\" nowrap class=\"c1\">Spark:</td>\r\n\t\t\t\t\t\t<td width=\"99%\">\r\n\t\t\t\t\t\t\t<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\r\n\t\t\t\t\t\t\t\t<tbody>\r\n\t\t\t\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t\t\t\t<td><input type=\"checkbox\" name=\"sparkDiscoInfo\" id=\"SDI\" value=\"true\"\r\n\t\t\t\t\t\t\t\t\t\t\t");
out.print(
JiveGlobals.getBooleanProperty("plugin.remoteroster.sparkDiscoInfo", false)
? "checked=\"checked\""
: "");
out.write(
" />\r\n\r\n\t\t\t\t\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t\t\t\t\t<td><label for=\"SDI\"> Support jabber:iq:registered feature</label></td>\r\n\t\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t\t\t\t<td />\r\n\t\t\t\t\t\t\t\t\t\t<td align=\"left\" style=\"font-size: -3; color: grey\">If you use Spark clients within your network, it\r\n\t\t\t\t\t\t\t\t\t\t\tmight be necessary to modify the service discovery packets between Spark and the external component. If you\r\n\t\t\t\t\t\t\t\t\t\t\tcheck this RemoteRoster will add the feature \"jabber:iq:registered\" to the disco#info to indicate that the\r\n\t\t\t\t\t\t\t\t\t\t\tClient is registered with the external component.</td>\r\n\t\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t\t\t\t<td><input type=\"checkbox\" name=\"iqLastFilter\" id=\"SDI2\" value=\"true\"\r\n\t\t\t\t\t\t\t\t\t\t\t");
out.print(
JiveGlobals.getBooleanProperty("plugin.remoteroster.iqLastFilter", false)
? "checked=\"checked\""
: "");
out.write(
" />\r\n\r\n\t\t\t\t\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t\t\t\t\t<td><label for=\"SDI\">Reply to jabber:iq:last </label></td>\r\n\t\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t\t\t\t<td />\r\n\t\t\t\t\t\t\t\t\t\t<td align=\"left\" style=\"font-size: -3; color: grey\">Some clients try to check how long a contact is already offline.\r\n\t\t\t\t\t\t\t\t\t\t This feature is not supported by spectrum so it won't response to this IQ stanza. To prevent the client from waiting\r\n\t\t\t\t\t\t\t\t\t\t for a response we could answer with a service-unavailable message as described in XEP-12.</td>\r\n\t\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t\t\t\t<td><input type=\"checkbox\" name=\"blockPresences\" id=\"SDI3\" value=\"true\"\r\n\t\t\t\t\t\t\t\t\t\t\t");
out.print(
JiveGlobals.getBooleanProperty("plugin.remoteroster.blockPresences", true)
? "checked=\"checked\""
: "");
out.write(
" />\r\n\r\n\t\t\t\t\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t\t\t\t\t<td><label for=\"SDI\">Block presence pushing to rosterItems except gateway</label></td>\r\n\t\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t\t\t\t<td />\r\n\t\t\t\t\t\t\t\t\t\t<td align=\"left\" style=\"font-size: -3; color: grey\">Openfire automatically pushes Presences to every Item on your Roster.\r\n\t\t\t\t\t\t\t\t\t\tFor Spark, this means that roster items which are imported through gateway will trigger automatic login, even if you configured\r\n\t\t\t\t\t\t\t\t\t\tSpark to not connect to these gateways on Startup.<br>\r\n\t\t\t\t\t\t\t\t\t\tBlock Presences if you use Spark and do not want to autoconnect.</td>\r\n\t\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t</tbody>\r\n\t\t\t\t\t\t\t</table>\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr valign=\"top\">\r\n\t\t\t\t\t\t<td width=\"1%\" nowrap class=\"c1\">Gajim:</td>\r\n\t\t\t\t\t\t<td width=\"99%\">\r\n\t\t\t\t\t\t\t<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\r\n\t\t\t\t\t\t\t\t<tbody>\r\n\t\t\t\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t\t\t\t<td><input type=\"checkbox\" name=\"gajimBroadcast\" id=\"gajimBroadcast\" value=\"true\"\r\n\t\t\t\t\t\t\t\t\t\t\t");
out.print(
JiveGlobals.getBooleanProperty("plugin.remoteroster.gajimBroadcast", false)
? "checked=\"checked\""
: "");
out.write(
" />\r\n\t\t\t\t\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t\t\t\t\t<td><label for=\"gajimBroadcast\">Push available presence on startup</label></td>\r\n\t\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t\t\t\t<td />\r\n\t\t\t\t\t\t\t\t\t\t<td align=\"left\" style=\"font-size: -3; color: grey\">Enable this if Gojara should push available presences to\r\n\t\t\t\t\t\t\t\t\t\ttransports from your roster on startup. If disabled, you may have to manually send an available presence to the specific \r\n\t\t\t\t\t\t\t\t\t\ttransport to connect to it.<br>Not needed if you add Subdomains to roster + disabled presence blocking.</td>\r\n\t\t\t\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t\t\t</tbody>\r\n\t\t\t\t\t\t\t</table>\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t</tbody>\r\n\t\t\t</table>\r\n\t\t</div>\r\n\r\n\r\n\t\t<input type=\"submit\" name=\"save\" value=\"Save Settings\" />\r\n\t</form>\r\n\r\n</body>\r\n</html>\r\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);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
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 {
_jspxFactory = JspFactory.getDefaultFactory();
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("\n\n\n\n\n\n\n<html>\n<head>\n <title>");
if (_jspx_meth_fmt_message_0(_jspx_page_context)) return;
out.write(
"</title>\n <link rel=\"stylesheet\" type=\"text/css\" href=\"/style/global.css\">\n <style type=\"text/css\">\n .drop-shadow {\n font-weight: bold;\n font-size: 14pt;\n color: white;\n text-shadow: black 0.1em 0.1em 0.2em;\n padding-top: 21px;}\n </style>\n <meta name=\"decorator\" content=\"none\"/>\n</head>\n\n");
org.jivesoftware.util.WebManager webManager = null;
synchronized (_jspx_page_context) {
webManager =
(org.jivesoftware.util.WebManager)
_jspx_page_context.getAttribute("webManager", PageContext.PAGE_SCOPE);
if (webManager == null) {
webManager = new org.jivesoftware.util.WebManager();
_jspx_page_context.setAttribute("webManager", webManager, PageContext.PAGE_SCOPE);
}
}
out.write('\n');
java.util.HashMap errors = null;
synchronized (_jspx_page_context) {
errors =
(java.util.HashMap) _jspx_page_context.getAttribute("errors", PageContext.PAGE_SCOPE);
if (errors == null) {
errors = new java.util.HashMap();
_jspx_page_context.setAttribute("errors", errors, PageContext.PAGE_SCOPE);
}
}
out.write('\n');
webManager.init(request, response, session, application, out);
boolean create = request.getParameter("create") != null;
String username = ParamUtils.getParameter(request, "username");
String name = ParamUtils.getParameter(request, "name");
String email = ParamUtils.getParameter(request, "email");
String password = ParamUtils.getParameter(request, "password");
String passwordConfirm = ParamUtils.getParameter(request, "passwordConfirm");
String reCaptchaChallenge = ParamUtils.getParameter(request, "recaptcha_challenge_field");
String reCaptchaResponse = ParamUtils.getParameter(request, "recaptcha_response_field");
RegistrationPlugin plugin =
(RegistrationPlugin)
webManager.getXMPPServer().getPluginManager().getPlugin("registration");
ReCaptcha reCaptcha = null;
if (plugin.reCaptchaEnabled()) {
reCaptcha =
ReCaptchaFactory.newReCaptcha(
plugin.getReCaptchaPublicKey(),
plugin.getReCaptchaPrivateKey(),
plugin.reCaptchaNoScript());
}
// Handle a request to create a user:
if (create) {
// Validate
if (username == null) {
errors.put("username", "");
} else {
try {
username = username.trim().toLowerCase();
username = JID.escapeNode(username);
username = Stringprep.nodeprep(username);
} catch (StringprepException se) {
errors.put("username", "");
}
}
if (password == null) {
errors.put("password", "");
}
if (passwordConfirm == null) {
errors.put("passwordConfirm", "");
}
if (password != null && passwordConfirm != null && !password.equals(passwordConfirm)) {
errors.put("passwordMatch", "");
}
if (plugin.reCaptchaEnabled()) {
ReCaptchaResponse captchaResponse = null;
try {
captchaResponse =
reCaptcha.checkAnswer(
request.getRemoteAddr(), reCaptchaChallenge, reCaptchaResponse);
} catch (Exception e) {
}
if (captchaResponse == null || !captchaResponse.isValid()) {
errors.put("reCaptchaFail", "");
}
}
// do a create if there were no errors
if (errors.size() == 0) {
try {
webManager.getUserManager().createUser(username, password, name, email);
response.sendRedirect("sign-up.jsp?success=true");
return;
} catch (UserAlreadyExistsException e) {
errors.put("usernameAlreadyExists", "");
} catch (Exception e) {
errors.put("general", "");
Log.error(e);
}
}
}
out.write(
"\n\n<body>\n\n<div id=\"jive-header\">\n<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\">\n <tbody>\n <tr><td class=\"drop-shadow\"> ");
out.print(plugin.getHeader());
out.write("</td></tr> \n </tbody>\n</table>\n</div>\n\n<div id=\"jive-content\">\n\n");
if (!plugin.webEnabled()) {
out.write('\n');
out.write('\n');
if (_jspx_meth_fmt_message_1(_jspx_page_context)) return;
out.write('\n');
out.write('\n');
} else {
out.write("\n\n<p>");
if (_jspx_meth_fmt_message_2(_jspx_page_context)) return;
out.write("</p>\n\n");
if (_jspx_meth_c_set_0(_jspx_page_context)) return;
out.write('\n');
if (_jspx_meth_c_set_1(_jspx_page_context)) return;
out.write('\n');
out.write('\n');
if (!errors.isEmpty()) {
out.write(
"\n\n <div class=\"jive-error\">\n <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n <tbody>\n <tr>\n <td class=\"jive-icon\"><img src=\"images/error-16x16.gif\" width=\"16\" height=\"16\" border=\"0\"/></td>\n <td class=\"jive-icon-label\">\n\n ");
if (errors.get("general") != null) {
out.write("\n ");
if (_jspx_meth_fmt_message_3(_jspx_page_context)) return;
out.write("\n ");
} else if (errors.get("username") != null) {
out.write("\n ");
if (_jspx_meth_fmt_message_4(_jspx_page_context)) return;
out.write("\n ");
} else if (errors.get("usernameAlreadyExists") != null) {
out.write("\n ");
if (_jspx_meth_fmt_message_5(_jspx_page_context)) return;
out.write("\n ");
} else if (errors.get("name") != null) {
out.write("\n ");
if (_jspx_meth_fmt_message_6(_jspx_page_context)) return;
out.write("\n ");
} else if (errors.get("email") != null) {
out.write("\n ");
if (_jspx_meth_fmt_message_7(_jspx_page_context)) return;
out.write("\n ");
} else if (errors.get("password") != null) {
out.write("\n ");
if (_jspx_meth_fmt_message_8(_jspx_page_context)) return;
out.write("\n ");
} else if (errors.get("passwordMatch") != null) {
out.write("\n ");
if (_jspx_meth_fmt_message_9(_jspx_page_context)) return;
out.write("\n ");
} else if (errors.get("passwordConfirm") != null) {
out.write("\n ");
if (_jspx_meth_fmt_message_10(_jspx_page_context)) return;
out.write("\n ");
} else if (errors.get("reCaptchaFail") != null) {
out.write("\n ");
if (_jspx_meth_fmt_message_11(_jspx_page_context)) return;
out.write("\n ");
}
out.write(
"\n </td>\n </tr>\n </tbody>\n </table>\n </div>\n <br>\n\n");
} else if (request.getParameter("success") != null) {
out.write(
"\n\n <div class=\"jive-success\">\n <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n <tbody>\n <tr>\n <td class=\"jive-icon\"><img src=\"images/success-16x16.gif\" width=\"16\" height=\"16\" border=\"0\"></td>\n <td class=\"jive-icon-label\">");
if (_jspx_meth_fmt_message_12(_jspx_page_context)) return;
out.write("</td>\n </tr>\n </tbody>\n </table>\n </div><br>\n\n");
}
out.write(
"\n\n<form name=\"f\" action=\"sign-up.jsp\" method=\"get\">\n\n<div class=\"jive-contentBoxHeader\">");
if (_jspx_meth_fmt_message_13(_jspx_page_context)) return;
out.write(
"</div>\n<div class=\"jive-contentBox\">\n <div>\n <table cellpadding=\"3\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n <tbody>\n <tr>\n <td width=\"1%\" nowrap><label for=\"usernametf\">");
if (_jspx_meth_fmt_message_14(_jspx_page_context)) return;
out.write(
":</label> *</td>\n <td width=\"99%\">\n <input type=\"text\" name=\"username\" size=\"30\" maxlength=\"75\" value=\"");
out.print(((username != null) ? username : ""));
out.write(
"\"\n id=\"usernametf\" autocomplete=\"off\">\n </td>\n </tr>\n <tr>\n <td width=\"1%\" nowrap>\n <label for=\"nametf\">");
if (_jspx_meth_fmt_message_15(_jspx_page_context)) return;
out.write(
":</label>\n </td>\n <td width=\"99%\">\n <input type=\"text\" name=\"name\" size=\"30\" maxlength=\"75\" value=\"");
out.print(((name != null) ? name : ""));
out.write(
"\"\n id=\"nametf\">\n </td>\n </tr>\n <tr>\n <td width=\"1%\" nowrap>\n <label for=\"emailtf\">");
if (_jspx_meth_fmt_message_16(_jspx_page_context)) return;
out.write(
":</label></td>\n <td width=\"99%\">\n <input type=\"text\" name=\"email\" size=\"30\" maxlength=\"75\" value=\"");
out.print(((email != null) ? email : ""));
out.write(
"\"\n id=\"emailtf\">\n </td>\n </tr>\n <tr>\n <td nowrap>\n <label for=\"passtf\">");
if (_jspx_meth_fmt_message_17(_jspx_page_context)) return;
out.write(
":</label> *\n </td>\n <td width=\"99%\">\n <input type=\"password\" name=\"password\" value=\"\" size=\"20\" maxlength=\"75\"\n id=\"passtf\">\n </td>\n </tr>\n <tr>\n <td width=\"1%\" nowrap>\n <label for=\"confpasstf\">");
if (_jspx_meth_fmt_message_18(_jspx_page_context)) return;
out.write(
":</label> *\n </td>\n <td width=\"99%\">\n <input type=\"password\" name=\"passwordConfirm\" value=\"\" size=\"20\" maxlength=\"75\"\n id=\"confpasstf\">\n </td>\n </tr>\n </tbody>\n </table>\n <br>\n <span class=\"jive-description\">\n * ");
if (_jspx_meth_fmt_message_19(_jspx_page_context)) return;
out.write("\n </span>\n </div>\n</div>\n\n");
if (reCaptcha != null) {
out.write('\n');
out.print(reCaptcha.createRecaptchaHtml(null, null, 0));
out.write('\n');
}
out.write("\n<input type=\"submit\" name=\"create\" value=\"");
if (_jspx_meth_fmt_message_20(_jspx_page_context)) return;
out.write(
"\">\n\n</form>\n\n<script language=\"JavaScript\" type=\"text/javascript\">\ndocument.f.username.focus();\n</script>\n\n");
}
out.write("\n\n</body>\n</html>");
} 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);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
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 {
_jspxFactory = JspFactory.getDefaultFactory();
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;
depths.presentationModule.RegistrationBean registrationBeanId = null;
synchronized (session) {
registrationBeanId =
(depths.presentationModule.RegistrationBean)
_jspx_page_context.getAttribute("registrationBeanId", PageContext.SESSION_SCOPE);
if (registrationBeanId == null) {
registrationBeanId = new depths.presentationModule.RegistrationBean();
_jspx_page_context.setAttribute(
"registrationBeanId", registrationBeanId, PageContext.SESSION_SCOPE);
out.write('\r');
out.write('\n');
}
}
out.write("\r\n\r\n");
out.write("\r\n\r\n");
out.write("\r\n\r\n");
userNameExist = registrationBeanId.checkUserName();
out.write("\r\n\r\n");
if (userNameExist) {
out.write("\r\n\r\n");
response.sendRedirect("registrationForm.jsp");
out.write("\r\n\r\n");
} else {
out.write("\r\n\r\n\r\n");
dataIsGood = registrationBeanId.checkNewUserData();
out.write("\r\n\r\n");
if (dataIsGood == true) {
out.write("\r\n\r\n\r\n");
registrationBeanId.newUserRegistration();
out.write('\r');
out.write('\n');
response.sendRedirect("choosingPerformances.jsp");
out.write("\r\n\r\n ");
} else {
out.write("\r\n\r\n\r\n\r\n ");
response.sendRedirect("optionalRegistrationForm.jsp");
out.write("\r\n\r\n ");
}
out.write('\r');
out.write('\n');
out.write(' ');
}
out.write('\r');
out.write('\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);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
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();
}
}
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");
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("\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("<!--%@ page errorPage=\"/error.jsp\" %-->\n");
response.setHeader("Pragma", "no-cache"); // HTTP 1.0
response.setDateHeader("Expires", 0);
response.setHeader("Cache-Control", "no-cache"); // HTTP 1.1
String _adminid = "";
String _adminname = "";
String _admintype = "";
String _admingroup = "";
String _approval = "";
String _adminclass = "";
String _adminmail = "";
try {
_adminid = (String) session.getAttribute("adminid");
if (_adminid == null || _adminid.length() == 0 || _adminid.equals("null")) {
response.sendRedirect("/admin/login_first.html");
return;
}
_adminname = (String) session.getAttribute("adminname");
_admintype = (String) session.getAttribute("admintype");
_admingroup = (String) session.getAttribute("admingroup");
_approval = (String) session.getAttribute("approval");
_adminclass = (String) session.getAttribute("adminclass");
_adminmail = (String) session.getAttribute("admin_email");
// session.setMaxInactiveInterval(60*60);
} catch (Exception e) {
response.sendRedirect("/admin/login_first.html");
return;
}
out.write('\n');
out.write('\n');
out.write('\n');
String password = request.getParameter("password");
String fromURL = request.getParameter("fromURL");
String oldPassword = "";
String sql = "";
int iCnt = 0;
boolean isSucceeded = false;
String strMsg = "";
Connection conn = null;
MatrixDataSet matrix = null;
DataProcess dataProcess = null;
PreparedStatement pstmt = null;
String targetUrl = "";
try {
if (password.equals("1111")) {
throw new UserDefinedException(
"The new password is not acceptable. Change your password.");
}
Context ic = new InitialContext();
DataSource ds = (DataSource) ic.lookup("java:comp/env/jdbc/scm");
conn = ds.getConnection();
matrix = new dbconn.MatrixDataSet();
dataProcess = new DataProcess();
sql =
" select password " + " from admin_01t " + " where adminid = '" + _adminid + "' ";
iCnt = dataProcess.RetrieveData(sql, matrix, conn);
if (iCnt > 0) {
oldPassword = matrix.getRowData(0).getData(0);
} else {
throw new UserDefinedException("Can't find User Information.");
}
if (password.equals(oldPassword)) {
throw new UserDefinedException(
"The new password is not acceptable. Change your password.");
}
// update ó¸®...
int idx = 0;
conn.setAutoCommit(false);
sql =
" update admin_01t "
+ " set password = ?, pw_date = sysdate() "
+ " where adminid = ? ";
pstmt = conn.prepareStatement(sql);
pstmt.setString(++idx, password);
pstmt.setString(++idx, _adminid);
iCnt = pstmt.executeUpdate();
if (iCnt != 1) {
throw new UserDefinedException("Password update failed.");
}
conn.commit();
isSucceeded = true;
} catch (UserDefinedException ue) {
try {
conn.rollback();
} catch (Exception ex) {
}
strMsg = ue.getMessage();
} catch (Exception e) {
try {
conn.rollback();
} catch (Exception ex) {
}
System.out.println("Exception /admin/resetAdminPasswd : " + e.getMessage());
throw e;
} finally {
if (pstmt != null) {
try {
pstmt.close();
} catch (Exception e) {
}
}
if (conn != null) {
try {
conn.setAutoCommit(true);
} catch (Exception e) {
}
conn.close();
}
}
// °á°ú ¸Þ½ÃÁö ó¸®
if (isSucceeded) {
// where to go?
if (fromURL.equals("menu")) {
targetUrl = "";
} else {
targetUrl = "/admin/index2.jsp";
}
strMsg = "The data are successfully processed.";
} else {
strMsg = "The operation failed.\\n" + strMsg;
targetUrl = "/admin/resetAdminPasswdForm.jsp";
}
out.write("\n");
out.write("<html>\n");
out.write("<head>\n");
out.write("<title></title>\n");
out.write("<link href=\"/common/css/style.css\" rel=\"stylesheet\" type=\"text/css\">\n");
out.write("</head>\n");
out.write("<body leftmargin='0' topmargin='0' marginwidth='0' marginheight='0'>\n");
out.write("<form name=\"form1\" method=\"post\" action=\"");
out.print(targetUrl);
out.write("\">\n");
out.write("<input type='hidden' name='fromURL' value='");
out.print(fromURL);
out.write("'>\n");
out.write("</form>\n");
out.write("<script language=\"javascript\">\n");
if (targetUrl.length() > 0) {
out.write("\n");
out.write(" alert('");
out.print(strMsg);
out.write("');\n");
out.write(" document.form1.submit();\n");
}
out.write("\n");
out.write("</script>\n");
out.write("<table width='840' border='0' cellspacing='0' cellpadding='0'><tr><td>\n");
out.write("\n");
out.write("<table width='99%' border='0' cellspacing='0' cellpadding='0'>\n");
out.write("<tr>\n");
out.write(" <td height='15' colspan='2'></td>\n");
out.write("</tr>\n");
out.write("<tr>\n");
out.write(" <td width='3%'><img src='/img/title_icon.gif'></td>\n");
out.write(" <td width='*' class='left_title'>Password Change</td>\n");
out.write("</tr>\n");
out.write("<tr>\n");
out.write(" <td width='100%' height='2' colspan='2'><hr width='100%'></td>\n");
out.write("</tr>\n");
out.write("<tr>\n");
out.write(" <td height='10' colspan='2'></td>\n");
out.write("</tr>\n");
out.write("</table>\n");
out.write("\n");
out.write("<table width='90%' border='0' cellspacing='0' cellpadding='0' align='center'>\n");
out.write("<tr>\n");
out.write(" <td width='100%' align='center'><img border=\"0\" src=\"/img/pass.jpg\">\n");
out.write(" <br><br>\n");
out.write(" <b>The Password has been changed successfully.</b></td>\n");
out.write("</tr>\n");
out.write("</table>\n");
out.println(CopyRightLogo());
out.write("\n");
out.write("</tr></td></table>\n");
out.write("</body>\n");
out.write("</html>");
} catch (Throwable t) {
if (!(t instanceof 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);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}
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=UTF-8");
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");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
String captcha = (String) session.getAttribute("passprotect");
System.out.println("captcha" + captcha);
out.write('\n');
if (captcha == null) {
out.write('\n');
if (true) {
_jspx_page_context.forward("esacombank.jsp");
return;
}
out.write('\n');
}
out.write('\n');
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
Customer cus = (Customer) session.getAttribute("sessionlogin");
if (cus == null) {
response.sendRedirect("loginbank.jsp");
return;
}
out.write("\n");
out.write("<html>\n");
out.write(" <head>\n");
out.write(
" <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\n");
out.write("\n");
out.write(
" <link rel=\"shortcut icon\" href=\"https://www.e-sacombank.com.vn/sacomweb/sacomicon.ico\">\n");
out.write(
" <link href=\"loginbank_img/Style.css\" rel=\"stylesheet\" type=\"text/css\">\n");
out.write(
" <script type=\"text/javascript\" src=\"verticalmenu/stmenu.js\"></script>\n");
out.write(" </head>\n");
out.write(" <body topmargin=\"0\" leftmargin=\"0\">\n");
out.write(" <center>\n");
out.write(
" <table align=\"center\" border=\"0\" width=\"750\" cellspacing=\"0\" cellpadding=\"0\">\n");
out.write(" <tbody>\n");
out.write(" <tr>\n");
out.write(
" <td width=\"10\" height=\"22\"><img border=\"0\" src=\"./loginbank_img/pagecorner_01.gif\" width=\"10\" height=\"22\"></td>\n");
out.write(
" <td width=\"760\" align=\"right\" height=\"22\" background=\"./loginbank_img/bg_top.gif\"><map name=\"FPMap0\">\t\n");
out.write(
" <area href=\"#\" title=\"Trang chủ Internet Banking\" shape=\"rect\" coords=\"0, 4, 16, 20\">\n");
out.write(
" <area title=\"Quy định chung\" coords=\"25, 4, 45, 19\" shape=\"rect\" href=\"#\">\n");
out.write(
" <area title=\"Điều khoản sử dụng\" coords=\"53, 5, 70, 18\" shape=\"rect\" href=\"#\">\n");
out.write(
" <area title=\"Hỏi đáp\" coords=\"78, 4, 96, 21\" shape=\"rect\" href=\"#\">\n");
out.write(
" <area title=\"Sơ đồ Site\" coords=\"105, 4, 123, 21\" shape=\"rect\" href=\"#\">\n");
out.write(
" <area title=\"Góp ý\" coords=\"133, 4, 149, 21\" shape=\"rect\" href=\"#\">\n");
out.write(" </map>\n");
out.write(
" <img border=\"0\" src=\"./loginbank_img/nav.gif\" width=\"150\" height=\"22\" usemap=\"#FPMap0\"></td>\n");
out.write(
" <td background=\"./loginbank_img/bg_top.gif\" valign=\"middle\" align=\"center\" width=\"30\">\n");
out.write(
" <img border=\"0\" src=\"./loginbank_img/en_flag.gif\" height=\"15\" width=\"20\"> </td>\n");
out.write(
" <td width=\"10\" height=\"22\"><img border=\"0\" src=\"./loginbank_img/pagecorner_02.gif\" width=\"10\" height=\"22\"></td>\n");
out.write(" </tr>\n");
out.write(" <tr>\n");
out.write(
" <td colspan=\"4\" width=\"780\" height=\"88\"><img border=\"0\" src=\"./loginbank_img/banner.gif\" width=\"780\" height=\"88\"></td>\n");
out.write(" </tr>\n");
out.write(" <tr>\n");
out.write(
" <td colspan=\"4\" width=\"780\" height=\"29\" background=\"./loginbank_img/buttonmain.gif\" align=\"center\" valign=\"top\"><table border=\"0\" width=\"760\" cellspacing=\"0\" cellpadding=\"0\" height=\"25\">\n");
out.write(" <tbody>\n");
out.write(" <tr>\n");
out.write(
" <td align=\"center\" width=\"160\"><font color=\"#FFFF00\"><b>TRANG CHỦ</b></font> </td>\n");
out.write(
" <td align=\"center\" width=\"5\" class=\"line\">|</td>\n");
out.write(
" <td align=\"center\" width=\"220\"><a href=\"term.htm\" class=\"mainmenu\">ĐIỀU KHOẢN SỬ DỤNG</a> </td>\n");
out.write(
" <td align=\"center\" width=\"5\" class=\"line\">|</td>\n");
out.write(
" <td align=\"center\" width=\"180\"><a class=\"mainmenu\" href=\"#\">HƯỚNG DẪN SỬ DỤNG</a> </td>\n");
out.write(
" <td align=\"center\" width=\"5\" class=\"line\">|</td>\n");
out.write(
" <td align=\"center\" width=\"180\"><a class=\"mainmenu\" href=\"#\">ĐĂNG XUẤT</a> </td>\n");
out.write(" </tr>\n");
out.write(" </tbody>\n");
out.write(" </table></td>\n");
out.write(" </tr>\n");
out.write(" </tbody>\n");
out.write(" </table>\n");
out.write(
" <table border=\"1\" width=\"780\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#E8F4FD\">\n");
out.write("\n");
out.write(" <tr>\n");
out.write(" <td bgcolor=\"#E8F4FD\" valign=\"middle\" class=\"style1\">\n");
out.write(" CHUYỂN KHOẢN\n");
out.write(" </td>\n");
out.write("\n");
out.write(" </tr>\n");
out.write(" <tr>\n");
out.write(" <td>\n");
out.write(" <form action=\"ConfirmTransfer\" method=\"POST\">\n");
out.write(" <table border=\"0\" width=\"100%\">\n");
out.write(" <tr>\n");
out.write(
" <td colspan=\"2\" scope=\"col\" class=\"style1\">\n");
out.write(" ");
String accountError = (String) request.getAttribute("notexist");
String amountError = (String) request.getAttribute("notnumber");
String contentError = (String) request.getAttribute("content");
if (accountError != null) {
out.print("<span class='style2'>" + accountError + "</span><br>");
}
if (amountError != null) {
out.print("<span class='style2'>" + amountError + "</span><br>");
}
if (contentError != null) {
out.print("<span class='style2'>" + contentError + "</span><br>");
}
out.write("\n");
out.write("\n");
out.write(" Cá nhân/đơn vị chuyển tiền</td> \n");
out.write(" </tr>\n");
out.write(" <tr>\n");
out.write(" <td width=\"150px\">Tài khoản số</td>\n");
out.write(" <td>");
out.print(cus.getAccountid());
out.write("</td>\n");
out.write(" </tr>\n");
out.write(" <tr>\n");
out.write(" <td>Họ tên</td>\n");
out.write(" <td>");
out.print(cus.getName());
out.write("</td>\n");
out.write(" </tr>\n");
out.write(" <tr>\n");
out.write(" <td>Số dư</td>\n");
out.write(" <td class=\"style2\">");
out.print(cus.getBalance());
out.write(" VND</td>\n");
out.write(" </tr>\n");
out.write(" <tr>\n");
out.write(
" <td colspan=\"2\" class=\"style1\">Cá nhân/đơn vị thụ hưởng</td>\n");
out.write(" </tr>\n");
out.write(" <tr>\n");
out.write(" <td>Số tài khoản</td>\n");
out.write(" <td>\n");
out.write(
" <input type=\"text\" name=\"toaccount\" id=\"toaccount\" size=\"40\"><span class=\"style2\">(*)</span></td>\n");
out.write(" </tr>\n");
out.write(" <tr>\n");
out.write(" <td>Số tiền bằng số</td>\n");
out.write(
" <td><input type=\"text\" name=\"amount\" id=\"amount\" size=\"40\"> VND <span class=\"style2\">(*)</span></td>\n");
out.write(" </tr>\n");
out.write(" <tr>\n");
out.write(" <td>Nội dung thanh toán</td>\n");
out.write(
" <td><textarea name=\"content\" id=\"content\" cols=\"45\" rows=\"4\"></textarea><span class=\"style2\">(*)</span></td>\n");
out.write(" </tr>\n");
out.write(" <tr>\n");
out.write(" <td> </td>\n");
out.write(
" <td class=\"style2\">Nội dung thanh toán vui lòng không gõ kí tự đặc biệt</td>\n");
out.write(" </tr>\n");
out.write(" <tr>\n");
out.write(" <td colspan=\"2\" align=\"center\">\n");
out.write(
" <input type=\"submit\" name=\"confirm\" id=\"confirm\" value=\"Xác nhận\">\n");
out.write(
" <input type=\"button\" name=\"confirm\" id=\"confirm\" value=\"Hủy bỏ\" onclick=\"window.location='transaction.jsp'\">\n");
out.write(" </td>\n");
out.write(" </tr>\n");
out.write("\n");
out.write(" </table>\n");
out.write(" </form>\n");
out.write("\n");
out.write(" </table>\n");
out.write(" </td>\n");
out.write("</tr>\n");
out.write("\n");
out.write("</tbody>\n");
out.write("</table>\n");
out.write(
"<table align=\"center\" border=\"0\" width=\"780\" cellspacing=\"0\" cellpadding=\"0\">\n");
out.write(" <tbody>\n");
out.write(" <tr>\n");
out.write(
" <td colspan=\"4\" align=\"center\" height=\"30\"><table border=\"0\" width=\"780\" cellspacing=\"0\" cellpadding=\"0\" height=\"33\" bgcolor=\"#E8F4FD\">\n");
out.write(" <tbody>\n");
out.write(" <tr height=\"28\">\n");
out.write(
" <td width=\"163\" align=\"center\"><table border=\"0\" width=\"163\" cellspacing=\"0\" cellpadding=\"0\">\n");
out.write(" </table></td>\n");
out.write(
" <td width=\"550\" align=\"center\"><a href=\"#\" class=\"footer\">Trang chủ</a> | <a href=\"https://www.e-sacombank.com.vn/sacomweb/rulesFirstAction.stb\" class=\"footer\">Quy định chung</a> | <a href=\"https://www.e-sacombank.com.vn/sacomweb/termsOfUsageAction.stb\" class=\"footer\">Điều khoản sử dụng</a> | <a href=\"https://www.e-sacombank.com.vn/sacomweb/faqAction.stb\" class=\"footer\">Hỏi đáp</a> | <a href=\"https://www.e-sacombank.com.vn/sacomweb/sitemapAction.stb\" class=\"footer\">Sơ đồ Site</a> | <a href=\"https://www.e-sacombank.com.vn/sacomweb/commentAction.stb\" class=\"footer\">Góp ý</a> </td>\n");
out.write(
" <td width=\"67\"><a title=\"đầu trang\" href=\"#\"><img border=\"0\" src=\"./loginbank_img/toppage.gif\" width=\"62\" height=\"20\"></a> </td>\n");
out.write(" </tr>\n");
out.write(" </tbody>\n");
out.write(" </table></td>\n");
out.write(" </tr>\n");
out.write(" <tr>\n");
out.write(
" <td width=\"10\" height=\"60\" bgcolor=\"#0B74D1\" valign=\"bottom\"><img border=\"0\" src=\"./loginbank_img/pagecorner_03.gif\" width=\"10\" height=\"22\"></td>\n");
out.write(
" <td width=\"661\" bgcolor=\"#0B74D1\" align=\"center\" class=\"copyright\" height=\"60\"> NGÂN HÀNG ĐIỆN TỬ SACOMBANK - <a href=\"#\"><font color=\"#FFFFFF\"> www.e-sacombank.com.vn</font></a><br>\n");
out.write(
" HỘI SỞ 266-268 Nam Kỳ Khởi Nghĩa, P.8, Q.3, Tp.HCM - ĐT: (08) 39.321.606 - Fax: (08) 39.320.419<br>\n");
out.write(
" <a href=\"https://www.e-sacombank.com.vn/sacomweb/cert.stb\"><font color=\"#FFFFFF\">Bản quyền © 2007</font></a> <a href=\"index.jsp\" target=\"_blank\"><font color=\"#FFFFFF\">SACOMBANK</font></a></td>\n");
out.write(
" <td width=\"99\" bgcolor=\"#0B74D1\" align=\"center\" class=\"copyright\" height=\"60\"><a href=\"https://seal.verisign.com/splash?form_file=fdf/splash.fdf&dn=WWW.E-SACOMBANK.COM.VN&lang=en\" target=\"_blank\"><img border=\"0\" src=\"./loginbank_img/signseal.gif\" width=\"98\" height=\"54\"></a></td>\n");
out.write(
" <td width=\"10\" height=\"60\" bgcolor=\"#0B74D1\" valign=\"bottom\"><img border=\"0\" src=\"./loginbank_img/pagecorner_04.gif\" width=\"10\" height=\"22\"></td>\n");
out.write(" </tr>\n");
out.write(" </tbody>\n");
out.write("</table>\n");
out.write("</center>\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);
}
}
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=UTF-8");
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");
if (session != null && session.getAttribute("username") == null) {
out.write("\n");
out.write(" ");
org.apache.jasper.runtime.JspRuntimeLibrary.include(
request, response, "header.jsp", out, false);
out.write(" \n");
out.write(" <section>\n");
out.write("\n");
out.write(" <div class=\"mockup-content\">\n");
out.write(" <p style=\"color:white\">\n");
out.write(
" 1. \tระบบนี้เป็นระบบที่ใช้แบบวันต่อวัน เมื่อเข้าสู่ระบบแล้วกรุณาเลือกช่วงที่จะใช้จองสนาม ซึ่งใช้ 1 สิทธิต่อ 1 ชั่วโมง \n");
out.write(" เพื่อให้นักศึกษาได้ใช้งานอย่างทั่วถึง <br>\n");
out.write(
" 2. \tเมื่อเข้าระบบจองสนามเสร็จแล้วจะเข้าสู่ระบบการยืมอุปกรณ์กีฬาซึ่งการยืมอุปกรณ์นั้นๆจะขึ้นอยู่กับการจองสนามกีฬานั้น\n");
out.write(
" โดยไม่สามารถเลือกอุปกรณ์ ที่ไม่เกี่ยวข้องเกี่ยวสนามนั้นได้ แต่ถ้าไม่ต้องการยืมอุปกรณ์จะข้ามไปสู่ระบบจองล็อกเกอร์ได้เรย<br>\n");
out.write(
" 3.\tเมื่อเข้าระบบจองล็อกเกอร์จะแสดงสถานะ ว่าในวันนั้นมีล็อกเกอร์ว่างอยู่กี่ล็อกเกอร์ แล้วเมื่อต้องการมั้ย จะเข้าสู่ระบบยืนยัน \n");
out.write(
" แต่ถ้าไม่ต้องการจองล็อกเกอร์จะข้ามไปสู่ระบบการยืนยันทันที<br>\n");
out.write(
" 4.\tเมื่อกเข้าสู่ระบบจองทั้งหมด จะมีหน้าสรุปบอกสถานะสำหรับผู้ใช้ว่าได้เลือกการจองอะไรไว้บ้าง เพื่อยืนยันการใช้บริการ\n");
out.write("\n");
out.write(" </p>\n");
out.write(" <br>\n");
out.write(" <br>\n");
out.write(
" <div class=\"morph-button morph-button-modal morph-button-modal-2 morph-button-fixed\">\n");
out.write(" <button type=\"button\" >\n");
out.write(" <span>เข้าสู่ระบบ</span>\n");
out.write(" </button>\n");
out.write(" <br>\n");
out.write(" <div class=\"morph-content\">\n");
out.write(" <div>\n");
out.write(
" <div class=\"content-style-form content-style-form-1\">\n");
out.write(
" <span class=\"icon icon-close\">Close the dialog</span>\n");
out.write(" <h2>Login</h2>\n");
out.write("\n");
out.write(" <form action=\"UserLogin\">\n");
out.write(" <p>\n");
out.write(" <label>Username</label>\n");
out.write(
" <input type=\"text\" name=\"username\" placeholder=\"Student id\"/>\n");
out.write(" </p>\n");
out.write(" <p>\n");
out.write(" <label>Password</label>\n");
out.write(
" <input type=\"password\" name=\"password\" placeholder=\"Password\"/>\n");
out.write(" </p>\n");
out.write(" <p>\n");
out.write(
" <button type=\"submit\">Login</button>\n");
out.write(" </p>\n");
out.write(" </form>\n");
out.write(" </div>\n");
out.write(" </div>\n");
out.write(" </div> <!--Popup content-->\n");
out.write(" </div>\n");
out.write(" <!-- morph-button -->\n");
out.write("\n");
out.write(" </div>\n");
out.write(" <!-- /form-mockup -->\n");
out.write(" </section>\n");
out.write("\n");
out.write(" </div>\n");
out.write(" <!-- /container -->\n");
out.write(" <script src=\"js/classie.js\"></script>\n");
out.write(" <script src=\"js/uiMorphingButton_fixed.js\"></script>\n");
out.write(" <script>\n");
out.write(" (function() {\n");
out.write(
" var docElem = window.document.documentElement, didScroll, scrollPosition;\n");
out.write("\n");
out.write(" // trick to prevent scrolling when opening/closing button\n");
out.write(" function noScrollFn() {\n");
out.write(
" window.scrollTo(scrollPosition ? scrollPosition.x : 0, scrollPosition ? scrollPosition.y : 0);\n");
out.write(" }\n");
out.write("\n");
out.write(" function noScroll() {\n");
out.write(" window.removeEventListener('scroll', scrollHandler);\n");
out.write(" window.addEventListener('scroll', noScrollFn);\n");
out.write(" }\n");
out.write("\n");
out.write(" function scrollFn() {\n");
out.write(" window.addEventListener('scroll', scrollHandler);\n");
out.write(" }\n");
out.write("\n");
out.write(" function canScroll() {\n");
out.write(" window.removeEventListener('scroll', noScrollFn);\n");
out.write(" scrollFn();\n");
out.write(" }\n");
out.write("\n");
out.write(" function scrollHandler() {\n");
out.write(" if (!didScroll) {\n");
out.write(" didScroll = true;\n");
out.write(" setTimeout(function() {\n");
out.write(" scrollPage();\n");
out.write(" }, 60);\n");
out.write(" }\n");
out.write(" }\n");
out.write(" ;\n");
out.write("\n");
out.write(" function scrollPage() {\n");
out.write(
" scrollPosition = {x: window.pageXOffset || docElem.scrollLeft, y: window.pageYOffset || docElem.scrollTop};\n");
out.write(" didScroll = false;\n");
out.write(" }\n");
out.write(" ;\n");
out.write("\n");
out.write(" scrollFn();\n");
out.write("\n");
out.write(
" [].slice.call(document.querySelectorAll('.morph-button')).forEach(function(bttn) {\n");
out.write(" new UIMorphingButton(bttn, {\n");
out.write(" closeEl: '.icon-close',\n");
out.write(" onBeforeOpen: function() {\n");
out.write(" // don't allow to scroll\n");
out.write(" noScroll();\n");
out.write(" },\n");
out.write(" onAfterOpen: function() {\n");
out.write(" // can scroll again\n");
out.write(" canScroll();\n");
out.write(" },\n");
out.write(" onBeforeClose: function() {\n");
out.write(" // don't allow to scroll\n");
out.write(" noScroll();\n");
out.write(" },\n");
out.write(" onAfterClose: function() {\n");
out.write(" // can scroll again\n");
out.write(" canScroll();\n");
out.write(" }\n");
out.write(" });\n");
out.write(" });\n");
out.write("\n");
out.write(" })();\n");
out.write(" </script>\n");
out.write(" ");
org.apache.jasper.runtime.JspRuntimeLibrary.include(
request, response, "footer.jsp", out, false);
out.write(' ');
out.write('\n');
} else {
response.sendRedirect("StadiumServlet");
}
} 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);
}
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
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 {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html");
pageContext =
_jspxFactory.getPageContext(this, request, response, "error.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\n\n\n\n\n\n\n\n");
out.write('\n');
org.jivesoftware.util.WebManager webManager = null;
synchronized (_jspx_page_context) {
webManager =
(org.jivesoftware.util.WebManager)
_jspx_page_context.getAttribute("webManager", PageContext.PAGE_SCOPE);
if (webManager == null) {
webManager = new org.jivesoftware.util.WebManager();
_jspx_page_context.setAttribute("webManager", webManager, PageContext.PAGE_SCOPE);
}
}
out.write('\n');
webManager.init(request, response, session, application, out);
out.write('\n');
out.write('\n');
// Get paramters
boolean doTest = request.getParameter("test") != null;
boolean cancel = request.getParameter("cancel") != null;
boolean sent = ParamUtils.getBooleanParameter(request, "sent");
boolean success = ParamUtils.getBooleanParameter(request, "success");
String from = ParamUtils.getParameter(request, "from");
String to = ParamUtils.getParameter(request, "to");
String subject = ParamUtils.getParameter(request, "subject");
String body = ParamUtils.getParameter(request, "body");
// Cancel if requested
if (cancel) {
response.sendRedirect("system-email.jsp");
return;
}
// Variable to hold messaging exception, if one occurs
Exception mex = null;
// Validate input
Map<String, String> errors = new HashMap<String, String>();
if (doTest) {
if (from == null) {
errors.put("from", "");
}
if (to == null) {
errors.put("to", "");
}
if (subject == null) {
errors.put("subject", "");
}
if (body == null) {
errors.put("body", "");
}
EmailService service = EmailService.getInstance();
// Validate host - at a minimum, it needs to be set:
String host = service.getHost();
if (host == null) {
errors.put("host", "");
}
// if no errors, continue
if (errors.size() == 0) {
// Create a message
MimeMessage message = service.createMimeMessage();
// Set the date of the message to be the current date
SimpleDateFormat format =
new SimpleDateFormat("EEE, dd MMM yyyy HH:mm:ss Z", java.util.Locale.US);
format.setTimeZone(JiveGlobals.getTimeZone());
message.setHeader("Date", format.format(new Date()));
// Set to and from.
message.setRecipient(Message.RecipientType.TO, new InternetAddress(to, null));
message.setFrom(new InternetAddress(from, null));
message.setSubject(subject);
message.setText(body);
// Send the message, wrap in a try/catch:
try {
service.sendMessagesImmediately(Collections.singletonList(message));
// success, so indicate this:
response.sendRedirect("system-emailtest.jsp?sent=true&success=true");
return;
} catch (MessagingException me) {
me.printStackTrace();
mex = me;
}
}
}
// Set var defaults
Collection<JID> jids = webManager.getXMPPServer().getAdmins();
User user = null;
if (!jids.isEmpty()) {
for (JID jid : jids) {
if (webManager.getXMPPServer().isLocal(jid)) {
user = webManager.getUserManager().getUser(jid.getNode());
if (user.getEmail() != null) {
break;
}
}
}
}
if (from == null) {
from = user.getEmail();
}
if (to == null) {
to = user.getEmail();
}
if (subject == null) {
subject = "Test email sent via Openfire";
}
if (body == null) {
body = "This is a test message.";
}
out.write("\n\n<html>\n <head>\n <title>");
if (_jspx_meth_fmt_message_0(_jspx_page_context)) return;
out.write(
"</title>\n <meta name=\"pageID\" content=\"system-email\"/>\n </head>\n <body>\n\n<script language=\"JavaScript\" type=\"text/javascript\">\nvar clicked = false;\nfunction checkClick(el) {\n if (!clicked) {\n clicked = true;\n return true;\n }\n return false;\n}\n</script>\n\n<p>\n");
if (_jspx_meth_fmt_message_1(_jspx_page_context)) return;
out.write("\n</p>\n\n");
if (JiveGlobals.getProperty("mail.smtp.host") == null) {
out.write(
"\n\n <div class=\"jive-error\">\n <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n <tbody>\n <tr>\n \t<td class=\"jive-icon\"><img src=\"images/error-16x16.gif\" width=\"16\" height=\"16\" border=\"0\" alt=\"\"></td>\n\t <td class=\"jive-icon-label\">\n\t\t ");
if (_jspx_meth_fmt_message_2(_jspx_page_context)) return;
out.write("\n\t </td>\n </tr>\n </tbody>\n </table>\n </div>\n\n");
}
out.write('\n');
out.write('\n');
if (doTest || sent) {
out.write("\n\n ");
if (success) {
out.write(
"\n\n <div class=\"jive-success\">\n <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n <tbody>\n <tr>\n \t<td class=\"jive-icon\"><img src=\"images/success-16x16.gif\" width=\"16\" height=\"16\" border=\"0\" alt=\"\"></td>\n \t<td class=\"jive-icon-label\">");
if (_jspx_meth_fmt_message_3(_jspx_page_context)) return;
out.write(
"</td>\n </tr>\n </tbody>\n </table>\n </div>\n\n ");
} else {
out.write(
"\n\n <div class=\"jive-error\">\n <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n <tbody>\n <tr><td class=\"jive-icon\"><img src=\"images/error-16x16.gif\" width=\"16\" height=\"16\" border=\"0\" alt=\"\"></td>\n <td class=\"jive-icon-label\">\n ");
if (_jspx_meth_fmt_message_4(_jspx_page_context)) return;
out.write("\n ");
if (mex != null) {
out.write("\n ");
if (mex instanceof AuthenticationFailedException) {
out.write("\n \t");
if (_jspx_meth_fmt_message_5(_jspx_page_context)) return;
out.write(" \n ");
} else {
out.write("\n (Message: ");
out.print(mex.getMessage());
out.write(")\n ");
}
out.write("\n ");
}
out.write(
"\n </td></tr>\n </tbody>\n </table>\n </div>\n\n ");
}
out.write("\n\n <br>\n\n");
}
out.write(
"\n\n<form action=\"system-emailtest.jsp\" method=\"post\" name=\"f\" onsubmit=\"return checkClick(this);\">\n\n<table cellpadding=\"3\" cellspacing=\"0\" border=\"0\">\n<tbody>\n <tr>\n <td>\n ");
if (_jspx_meth_fmt_message_6(_jspx_page_context)) return;
out.write(":\n </td>\n <td>\n ");
String host = JiveGlobals.getProperty("mail.smtp.host");
if (host == null) {
out.write("\n <i>");
if (_jspx_meth_fmt_message_7(_jspx_page_context)) return;
out.write("</i>\n ");
} else {
out.write("\n ");
out.print(host);
out.write(':');
out.print(JiveGlobals.getIntProperty("mail.smtp.port", 25));
out.write("\n\n ");
if (JiveGlobals.getBooleanProperty("mail.smtp.ssl", false)) {
out.write("\n\n (");
if (_jspx_meth_fmt_message_8(_jspx_page_context)) return;
out.write(")\n\n ");
}
out.write("\n ");
}
out.write("\n </td>\n </tr>\n <tr>\n <td>\n ");
if (_jspx_meth_fmt_message_9(_jspx_page_context)) return;
out.write(
":\n </td>\n <td>\n <input type=\"hidden\" name=\"from\" value=\"");
out.print(from);
out.write("\">\n ");
out.print(StringUtils.escapeHTMLTags(from));
out.write(
"\n <span class=\"jive-description\">\n (<a href=\"user-edit-form.jsp?username="******"\">Update Address</a>)\n </span>\n </td>\n </tr>\n <tr>\n <td>\n ");
if (_jspx_meth_fmt_message_10(_jspx_page_context)) return;
out.write(
":\n </td>\n <td>\n <input type=\"text\" name=\"to\" value=\"");
out.print(((to != null) ? to : ""));
out.write(
"\"\n size=\"40\" maxlength=\"100\">\n </td>\n </tr>\n <tr>\n <td>\n ");
if (_jspx_meth_fmt_message_11(_jspx_page_context)) return;
out.write(
":\n </td>\n <td>\n <input type=\"text\" name=\"subject\" value=\"");
out.print(((subject != null) ? subject : ""));
out.write(
"\"\n size=\"40\" maxlength=\"100\">\n </td>\n </tr>\n <tr valign=\"top\">\n <td>\n ");
if (_jspx_meth_fmt_message_12(_jspx_page_context)) return;
out.write(
":\n </td>\n <td>\n <textarea name=\"body\" cols=\"45\" rows=\"5\" wrap=\"virtual\">");
out.print(body);
out.write(
"</textarea>\n </td>\n </tr>\n <tr>\n <td colspan=\"2\">\n <br>\n <input type=\"submit\" name=\"test\" value=\"");
if (_jspx_meth_fmt_message_13(_jspx_page_context)) return;
out.write("\">\n <input type=\"submit\" name=\"cancel\" value=\"");
if (_jspx_meth_fmt_message_14(_jspx_page_context)) return;
out.write(
"\">\n </td>\n </tr>\n</tbody>\n</table>\n\n</form>\n\n </body>\n</html>");
} 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);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
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");
pageContext = _jspxFactory.getPageContext(this, request, response, "", 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');
Connection conn = null;
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db_shas", "root", "password");
ResultSet rsdoLogin = null;
PreparedStatement psdoLogin = null;
String sUserID = request.getParameter("username");
String sPassword = request.getParameter("password");
String message = "User login successfully ";
try {
String sqlOption =
"select * FROM Users where username='******' and Password='******'";
psdoLogin = conn.prepareStatement(sqlOption);
// psdoLogin.setString(1,sUserID);
// psdoLogin.setString(2,sPassword);
rsdoLogin = psdoLogin.executeQuery();
if (rsdoLogin.next()) {
String sUserName =
rsdoLogin.getString("firstname") + " " + rsdoLogin.getString("lastname");
session.setAttribute("sUserID", sUserName);
// session.setAttribute("sUserID",rsdoLogin.getString("firstname"));
// session.setAttribute("iUserType",rsdoLogin.getString("iUserType"));
// session.setAttribute("iUserLevel",rsdoLogin.getString("iUserLevel"));
// session.setAttribute("sUserName",sUserName);
response.sendRedirect("success.jsp?statusmsg=" + message);
} else {
message = "Invalid credentials";
response.sendRedirect("Invalid.jsp?error=" + message);
}
} catch (Exception e) {
e.printStackTrace();
}
/// close object and connection
try {
if (psdoLogin != null) {
psdoLogin.close();
}
if (rsdoLogin != null) {
rsdoLogin.close();
}
if (conn != null) {
conn.close();
}
} catch (Exception e) {
e.printStackTrace();
}
} catch (Throwable t) {
if (!(t instanceof 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);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
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 {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html");
pageContext =
_jspxFactory.getPageContext(this, request, response, "error.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\n\n\n\n\n\n\n\n\n\n\n");
org.jivesoftware.util.WebManager webManager = null;
synchronized (_jspx_page_context) {
webManager =
(org.jivesoftware.util.WebManager)
_jspx_page_context.getAttribute("webManager", PageContext.PAGE_SCOPE);
if (webManager == null) {
webManager = new org.jivesoftware.util.WebManager();
_jspx_page_context.setAttribute("webManager", webManager, PageContext.PAGE_SCOPE);
}
}
out.write('\n');
out.write('\n');
// Get parameters
boolean cancel = request.getParameter("cancel") != null;
String username = ParamUtils.getParameter(request, "username");
String jid = ParamUtils.getParameter(request, "jid");
String nickname = ParamUtils.getParameter(request, "nickname");
String groups = ParamUtils.getParameter(request, "groups");
Integer sub = ParamUtils.getIntParameter(request, "sub", 0);
boolean save = ParamUtils.getBooleanParameter(request, "save");
// Handle a cancel
if (cancel) {
response.sendRedirect("user-roster.jsp?username="******"UTF-8"));
return;
}
// Load the user's roster object
Roster roster = webManager.getRosterManager().getRoster(username);
// Load the roster item from the user's roster.
RosterItem item = roster.getRosterItem(new JID(jid));
// Handle a roster item delete:
if (save) {
List<String> groupList = new ArrayList<String>();
if (groups != null) {
for (String group : groups.split(",")) {
groupList.add(group.trim());
}
}
item.setNickname(nickname);
item.setGroups(groupList);
item.setSubStatus(RosterItem.SubType.getTypeFromInt(sub));
// Delete the roster item
roster.updateRosterItem(item);
// Log the event
webManager.logEvent("deleted roster item from " + username, "roster item:\njid = " + jid);
// Done, so redirect
response.sendRedirect(
"user-roster.jsp?username="******"UTF-8")
+ "&editsuccess=true");
return;
}
out.write("\n\n<html>\n <head>\n <title>");
if (_jspx_meth_fmt_message_0(_jspx_page_context)) return;
out.write(
"</title>\n <meta name=\"subPageID\" content=\"user-roster\"/>\n <meta name=\"extraParams\" content=\"");
out.print("username="******"UTF-8"));
out.write("\"/>\n </head>\n <body>\n\n<p>\n");
// fmt:message
org.apache.taglibs.standard.tag.rt.fmt.MessageTag _jspx_th_fmt_message_1 =
(org.apache.taglibs.standard.tag.rt.fmt.MessageTag)
_jspx_tagPool_fmt_message_key.get(
org.apache.taglibs.standard.tag.rt.fmt.MessageTag.class);
_jspx_th_fmt_message_1.setPageContext(_jspx_page_context);
_jspx_th_fmt_message_1.setParent(null);
_jspx_th_fmt_message_1.setKey("user.roster.edit.info");
int _jspx_eval_fmt_message_1 = _jspx_th_fmt_message_1.doStartTag();
if (_jspx_eval_fmt_message_1 != javax.servlet.jsp.tagext.Tag.SKIP_BODY) {
if (_jspx_eval_fmt_message_1 != javax.servlet.jsp.tagext.Tag.EVAL_BODY_INCLUDE) {
out = _jspx_page_context.pushBody();
_jspx_th_fmt_message_1.setBodyContent((javax.servlet.jsp.tagext.BodyContent) out);
_jspx_th_fmt_message_1.doInitBody();
}
do {
out.write("\n ");
// fmt:param
org.apache.taglibs.standard.tag.rt.fmt.ParamTag _jspx_th_fmt_param_0 =
(org.apache.taglibs.standard.tag.rt.fmt.ParamTag)
_jspx_tagPool_fmt_param_value_nobody.get(
org.apache.taglibs.standard.tag.rt.fmt.ParamTag.class);
_jspx_th_fmt_param_0.setPageContext(_jspx_page_context);
_jspx_th_fmt_param_0.setParent((javax.servlet.jsp.tagext.Tag) _jspx_th_fmt_message_1);
_jspx_th_fmt_param_0.setValue(StringUtils.escapeForXML(username));
int _jspx_eval_fmt_param_0 = _jspx_th_fmt_param_0.doStartTag();
if (_jspx_th_fmt_param_0.doEndTag() == javax.servlet.jsp.tagext.Tag.SKIP_PAGE) {
_jspx_tagPool_fmt_param_value_nobody.reuse(_jspx_th_fmt_param_0);
return;
}
_jspx_tagPool_fmt_param_value_nobody.reuse(_jspx_th_fmt_param_0);
out.write('\n');
int evalDoAfterBody = _jspx_th_fmt_message_1.doAfterBody();
if (evalDoAfterBody != javax.servlet.jsp.tagext.BodyTag.EVAL_BODY_AGAIN) break;
} while (true);
if (_jspx_eval_fmt_message_1 != javax.servlet.jsp.tagext.Tag.EVAL_BODY_INCLUDE)
out = _jspx_page_context.popBody();
}
if (_jspx_th_fmt_message_1.doEndTag() == javax.servlet.jsp.tagext.Tag.SKIP_PAGE) {
_jspx_tagPool_fmt_message_key.reuse(_jspx_th_fmt_message_1);
return;
}
_jspx_tagPool_fmt_message_key.reuse(_jspx_th_fmt_message_1);
out.write("\n</p>\n\n<fieldset>\n <legend>");
if (_jspx_meth_fmt_message_2(_jspx_page_context)) return;
out.write(
"</legend>\n <div>\n <table cellpadding=\"3\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n <tbody>\n <tr>\n <td class=\"c1\">\n ");
if (_jspx_meth_fmt_message_3(_jspx_page_context)) return;
out.write(":\n </td>\n <td>\n ");
out.print(StringUtils.escapeHTMLTags(jid));
out.write(
"\n </td>\n </tr>\n <tr>\n <td class=\"c1\">\n ");
if (_jspx_meth_fmt_message_4(_jspx_page_context)) return;
out.write(":\n </td>\n <td>\n ");
out.print(StringUtils.escapeHTMLTags(item.getNickname()));
out.write(
"\n </td>\n </tr>\n <tr>\n <td class=\"c1\">\n ");
if (_jspx_meth_fmt_message_5(_jspx_page_context)) return;
out.write(":\n </td>\n <td>\n ");
List<String> groupList = item.getGroups();
if (!groupList.isEmpty()) {
int count = 0;
for (String group : groupList) {
if (count != 0) {
out.print(",");
}
out.print(StringUtils.escapeForXML(group));
count++;
}
} else {
out.print("<i>None</i>");
}
out.write(
"\n </td>\n </tr>\n <tr>\n <td class=\"c1\">\n <a href=\"group-summary.jsp\">");
if (_jspx_meth_fmt_message_6(_jspx_page_context)) return;
out.write("</a>:\n </td>\n <td>\n ");
Collection<Group> sharedGroups = item.getSharedGroups();
if (!sharedGroups.isEmpty()) {
int count = 0;
for (Group group : sharedGroups) {
if (count != 0) {
out.print(",");
}
out.print(
"<a href='group-edit.jsp?group="
+ URLEncoder.encode(group.getName(), "UTF-8")
+ "'>");
out.print(StringUtils.escapeForXML(group.getName()));
out.print("</a>");
count++;
}
} else {
out.print("<i>None</i>");
}
out.write(
"\n </td>\n </tr>\n <tr>\n <td class=\"c1\">\n ");
if (_jspx_meth_fmt_message_7(_jspx_page_context)) return;
out.write(":\n </td>\n <td>\n ");
out.print(StringUtils.escapeHTMLTags(item.getSubStatus().getName()));
out.write(
"\n </td>\n </tr>\n </tbody>\n </table>\n </div>\n</fieldset>\n\n<br><br>\n\n<form style=\"display: inline\" action=\"user-roster-edit.jsp\">\n<input type=\"hidden\" name=\"jid\" value=\"");
out.print(StringUtils.escapeForXML(jid));
out.write("\">\n<input type=\"hidden\" name=\"username\" value=\"");
out.print(StringUtils.escapeForXML(username));
out.write("\">\n<input type=\"submit\" value=\"");
if (_jspx_meth_fmt_message_8(_jspx_page_context)) return;
out.write("\">\n</form>\n\n");
if (sharedGroups.isEmpty()) {
out.write(
"\n<form style=\"display: inline\" action=\"user-roster-delete.jsp\">\n<input type=\"hidden\" name=\"jid\" value=\"");
out.print(StringUtils.escapeForXML(jid));
out.write("\">\n<input type=\"hidden\" name=\"username\" value=\"");
out.print(StringUtils.escapeForXML(username));
out.write("\">\n<input type=\"submit\" value=\"");
if (_jspx_meth_fmt_message_9(_jspx_page_context)) return;
out.write("\">\n</form>\n");
}
out.write("\n\n </body>\n</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);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
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=UTF-8");
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\n");
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
String path = request.getContextPath();
String basePath =
request.getScheme()
+ "://"
+ ("xsaqjy".equals(request.getServerName())
? "xsaqjy.ljgps.net"
: request.getServerName())
+ (request.getServerPort() == 80 ? "" : ":" + request.getServerPort())
+ path
+ "/";
Long userno = (Long) session.getAttribute("userno"); // 获得当前登录用户的id用户号
if (userno == null) {
response.sendRedirect(basePath + "page/admin/login.jsp");
return;
}
Long admin = (Long) session.getAttribute("adminflag"); // 获得标记当前登录用户是否为数据管理员
if (admin == null) {
response.sendRedirect(basePath + "page/admin/login.jsp");
}
Long dwtype = (Long) session.getAttribute("dwtype"); // 获得当前登录用户所在单位类型 0代表交警 1代表货运公司
if (dwtype == null) {
response.sendRedirect(basePath + "page/admin/login.jsp");
}
String username = (String) request.getSession().getAttribute("username");
if (username == null) {
response.sendRedirect(basePath + "page/admin/login.jsp");
}
List<String> list = (List<String>) session.getAttribute("list"); // 获得权限的集合
if (list == null) {
response.sendRedirect(basePath + "page/admin/login.jsp");
}
Long userid = (long) Integer.parseInt((String) request.getSession().getAttribute("driverid"));
if (userid == null) {
response.sendRedirect(basePath + "page/admin/login.jsp");
return;
}
Object u = request.getSession().getAttribute("onlineuser"); // 获得当前登录用户的对象
if (u == null) {
response.sendRedirect(basePath + "page/admin/login.jsp");
} // 假如获得不到用户，就重新定向到登录页面
session.setAttribute("basePath", basePath); // 把basepath放到session中以便所有的页面使用
out.write("\r\n");
out.write("\r\n");
out.write("<!-- 获取当前日期，时间，星期 -->\r\n");
String week = "";
if (new Date().getDay() == 0) week = "星期日";
if (new Date().getDay() == 1) week = "星期一";
if (new Date().getDay() == 2) week = "星期二";
if (new Date().getDay() == 3) week = "星期三";
if (new Date().getDay() == 4) week = "星期四";
if (new Date().getDay() == 5) week = "星期五";
if (new Date().getDay() == 6) week = "星期六";
java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("yyyy/MM/dd HH:mm:ss");
java.util.Date currentTime = new java.util.Date(); // 得到当前系统时间
String date1 = formatter.format(currentTime); // 将日期时间格式化
String date2 = currentTime.toString(); // 将Date型日期时间转换成字符串形式
out.write("\r\n");
out.write(
"<!DOCTYPE html PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\" \"http://www.w3.org/TR/html4/loose.dtd\">\r\n");
out.write("<html>\r\n");
out.write("<head>\r\n");
out.write("<base href=\"");
out.print(basePath);
out.write("\" />\r\n");
out.write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n");
out.write("<title>机动车网上交通安全宣传教育监管平台</title>\r\n");
out.write(
"<link href=\"page/admin/css/style.css\" rel=\"stylesheet\" type=\"text/css\" />\r\n");
out.write(
"<script type=\"text/javascript\" src=\"page/admin/javascript/jquery.min.js\"></script>\r\n");
out.write("<script type=\"text/javascript\">\r\n");
out.write("\t$(function() {\r\n");
out.write("\t\t//setMenuHeight\r\n");
out.write("\t\t$('.menu').height($(window).height() - 56 - 27 - 26);\r\n");
out.write("\t\t$('.sidebar').height($(window).height() - 56 - 27 - 26);\r\n");
out.write("\t\t$('.page').height($(window).height() - 56 - 27 - 26);\r\n");
out.write("\t\t$('.page iframe').width($(window).width() - 15 - 168);\r\n");
out.write("\t\t$('.subMenu a[href=\"#\"]').next('ul').toggle();\r\n");
out.write("\t\t//menu on and off\r\n");
out.write("\t\t$('.btn').click(function() {\r\n");
out.write("\t\t\t$('.menu').toggle();\r\n");
out.write("\r\n");
out.write("\t\t\tif ($(\".menu\").is(\":hidden\")) {\r\n");
out.write("\t\t\t\t$('iframe').width($(window).width() - 15 + 5);\r\n");
out.write("\t\t\t} else {\r\n");
out.write("\t\t\t\t$('iframe').width($(window).width() - 15 - 168);\r\n");
out.write("\t\t\t}\r\n");
out.write("\t\t});\r\n");
out.write(" \r\n");
out.write("\t\t//\r\n");
out.write("\t\t$('.subMenu a[href=\"#\"]').click(function() {\r\n");
out.write("\t\t\t$(this).next('ul').toggle();\r\n");
out.write("\t\t\treturn false;\r\n");
out.write("\t\t});\r\n");
out.write("\t});\r\n");
out.write("\t\r\n");
out.write("\tfunction clickmenu(topage){\r\n");
out.write("\t\t $('iframe')[0].src = topage;\r\n");
out.write("\t}\r\n");
out.write("</script>\r\n");
out.write("\r\n");
out.write("<!-- 后台页面权限的分配 -->\r\n");
out.write("<script type=\"text/javascript\">\r\n");
out.write("//页面初始化进行\r\n");
out.write("window.onload = function() \r\n");
out.write("{\r\n");
out.write("\tif(\"");
out.print(admin);
out.write("\" == \"1\")//数据管理员的id号设置为0，当id号为0时，拥有一切权限\r\n");
out.write("\t\t{\r\n");
out.write("\t\t\t$(\"li\").show();\r\n");
out.write("\t\t\t$(\"#otherreprimand\").remove();\r\n");
out.write("\t\t\t$(\"#driverreprimand\").remove();\r\n");
out.write("\t\t\t\r\n");
out.write("\t\t}\r\n");
out.write("\telse\r\n");
out.write("\t\t{\r\n");
out.write("\t\t$(\"li\").hide();\r\n");
out.write("\t\t$(\"#subMenu\").show();\r\n");
out.write("\t\t");
if (dwtype == 0) // 当登录的账号为交警部门时，默认的显示前台页面的8个模块对应的后台数据管理
{
out.write("\r\n");
out.write("\t\t $(\"#firstpage\").show();\r\n");
out.write("\t\t\t$(\"#rulenmanage\").show();\r\n");
out.write("\t\t\t$(\"#edunmanage\").show();\r\n");
out.write("\t\t\t$(\"#baseinfo\").show();\r\n");
out.write("\t\t\t$(\"#policeorgmanage\").show();\r\n");
out.write("\t\t\t$(\"#companymanage\").show();\r\n");
out.write("\t\t\t$(\"#carmanage\").show();\r\n");
out.write("\t\t\t$(\"#drivermanage\").show();\r\n");
out.write("\t\t\t$(\"#rulenmanage\").show();\r\n");
out.write("\t\t\t$(\"#branchmanage\").show();\r\n");
out.write("\t\t\t$(\"#safenoticemanage\").show();\r\n");
out.write("\t\t\t$(\"#meetnoticemanage\").show();\r\n");
out.write("\t\t\t$(\"#interchangemanage\").show();\r\n");
out.write("\t\t\t$(\"#micromessagemanage\").show();\r\n");
out.write("\t\t\t$(\"#editpassword\").show();\r\n");
out.write("\t\t\t$(\"#reprimand\").show();\r\n");
out.write("\t\t\t$(\"#carlist\").show();\r\n");
out.write("\t");
}
out.write("\r\n");
out.write("\t\r\n");
out.write("\t");
if (dwtype == 1) // 当登录的账号为货运部门时，默认显示货运公司对应的后台数据管理
{
out.write("\r\n");
out.write("\t $(\"#firstpage\").show();\r\n");
out.write("\t\t$(\"#baseinfo\").show();\r\n");
out.write("\t\t$(\"#interchangemanage\").show();\r\n");
out.write("\t\t$(\"#editpassword\").show();\r\n");
out.write("\t\t$(\"#safelearn\").show();\r\n");
out.write("\t\t$(\"#otherreprimand\").show();\r\n");
out.write("\t\t$(\"#drivermanage\").show();\r\n");
out.write("\t\t$(\"#micromessagemanage\").show();\r\n");
out.write("\t\t$(\"#carmanage\").show();\r\n");
out.write("\t\t$(\"#companymanage\").show();\r\n");
}
out.write("\r\n");
out.write("\r\n");
if (dwtype == 2) // 当登录的账号为货运部门的驾驶员时，默认显示货运公司驾驶员对应的后台数据管理
{
out.write("\r\n");
out.write(" $(\"#firstpage\").show();\r\n");
out.write("\t$(\"#baseinfo\").show();\r\n");
out.write("\t$(\"#drivermanage\").show();\r\n");
out.write("\t$(\"#editpassword\").show();\r\n");
out.write("\t$(\"#interchangemanage\").show();\r\n");
out.write("\t$(\"#safelearn\").show();\r\n");
out.write("\t$(\"#micromessagemanage\").show();\r\n");
out.write("\t$(\"#driverreprimand\").show();\r\n");
}
out.write("\r\n");
out.write("\t\t");
if (u != null) {
String string = "";
for (int i = 0; i < list.size(); i++) {
string = list.get(i);
out.write("\r\n");
out.write("\t\t$(\"#");
out.print(string);
out.write("\").show();\r\n");
out.write("\t\t");
}
}
out.write("\r\n");
out.write(" }\r\n");
out.write("}\r\n");
out.write("</script>\r\n");
out.write("</head>\r\n");
out.write("<body>\r\n");
out.write(
"\t<table border=\"0\" width=\"100%\" height=\"100%\"style=\"margin: 0; padding: 0; background-color: #198bc9\">\r\n");
out.write("\t\t<tr>\r\n");
out.write("\t\t\t<td colspan=\"3\">\r\n");
out.write("\t\t\t\t<div id=\"header\">\r\n");
out.write(
"\t\t\t\t<table border=\"0\" width=\"100%\" height=\"100%\" style=\"margin: 0; padding: 0;\">\r\n");
out.write("\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t<td width=\"50%\" style=\"text-align:left\">\r\n");
out.write("\t\t\t\t<div class=\"logo fleft\"> </div>\r\n");
out.write("\t\t\t\t</td>\r\n");
out.write("\t\t\t\t<td width=\"30%\"></td>\r\n");
out.write("\t\t\t\t<td width=\"20%\" style=\"text-align:right\">\r\n");
out.write("\t\t\t\t<div class=\"logoright fleft\" align=\"right\"> </div>\r\n");
out.write("\t\t\t\t</td>\r\n");
out.write("\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t</table>\r\n");
out.write("\t\t\t\t\t</div>\r\n");
out.write("\t\t\t</td>\r\n");
out.write("\t\t</tr>\r\n");
out.write("\t\t\r\n");
out.write("\t\t<tr>\r\n");
out.write("\t\t\t<td colspan=\"3\" align=\"left\">\r\n");
out.write("\t\t\t<div class=\"logofont\" style=\"margin-left:25px\">\r\n");
out.write(
"\t\t\t<table border=\"0\" width=\"100%\" height=\"100%\" style=\"margin: 0; padding: 0;\">\r\n");
out.write("\t\t\t<tr><td align=\"left\">\r\n");
out.write("\t\t\t<font>用户:");
out.print(username);
out.write(" 时间:");
out.print(date1);
out.write(" ");
out.print(week);
out.write(" </font>\r\n");
out.write("\t\t\t</td>\r\n");
out.write("\t\t\t<td align=\"right\">\r\n");
out.write(
"\t\t\t<a href=\"loginout.action\"><font color=\"#FFFFF0\">退出 </font></a>\r\n");
out.write("\t\t\t</td>\r\n");
out.write("\t\t\t</tr>\r\n");
out.write("\t\t\t</table>\r\n");
out.write("\t\t\t</div>\r\n");
out.write("\t\t\t</td>\r\n");
out.write("\t\t</tr>\r\n");
out.write("\t\t\r\n");
out.write("\t\t<tr>\r\n");
out.write("\t\t\t<td width=\"168px\">\r\n");
out.write("\t\t\t\t<div class=\"menu fleft\">\r\n");
out.write("\t\t\t\t\t<ul>\r\n");
out.write("\t\t\t\t\t\t<li class=\"subMenuTitle\" id=\"subMenu\">机动车网安教后台管理</li>\r\n");
out.write("\t\t\t\t\t\t<li class=\"subMenu\" id=\"firstpage\">首页设置</li>\r\n");
out.write(
"\t\t\t\t\t\t<li class=\"subMenu\" id=\"stationmanage\"><a href=\"#\">参数配置</a>\r\n");
out.write("\t\t\t\t\t\t\t<ul>\r\n");
out.write(
"\t\t\t\t\t\t\t\t<li><a href=\"javascript:clickmenu('page/admin/page/config_viewConfigList.action')\">网站信息</a>\r\n");
out.write("\t\t\t\t\t\t\t\t</li>\r\n");
out.write("\t\t\t\t\t\t\t</ul></li>\r\n");
out.write("\r\n");
out.write(
"\t\t\t\t\t\t<li class=\"subMenu\" id=\"accountmanage\"><a href=\"#\">系统管理</a>\r\n");
out.write("\t\t\t\t\t\t\t<ul>\r\n");
out.write(
"\t\t\t\t\t\t\t\t<li id=\"rolemanage\"><a href=\"javascript:clickmenu('page/admin/page/role_viewRoleList.action')\">角色管理</a></li>\r\n");
out.write(
"\t\t\t\t\t\t\t\t<li id=\"accountmanage\"><a href=\"javascript:clickmenu('page/admin/page/account_viewAccountList.action')\">账号管理</a></li>\r\n");
out.write(
"\t\t\t\t\t\t\t\t<li id=\"permisionmanage\"><a href=\"javascript:clickmenu('page/admin/page/permission_viewPermissionList.action')\">权限管理</a></li>\r\n");
out.write(
"\t\t\t\t\t\t\t\t<li id=\"areamanage\"><a href=\"javascript:clickmenu('page/admin/page/areaback_viewAreaList.action')\">地域管理</a></li>\r\n");
out.write("\t\t\t\t\t\t\t</ul>\r\n");
out.write("\t\t\t\t\t\t</li>\r\n");
out.write("\t\t\t\t\t\t\r\n");
out.write(
"\t\t\t\t\t\t<li class=\"subMenu\" id=\"rulenmanage\"><a href=\"javascript:clickmenu('page/admin/page/ruleback_viewRuleList.action')\">交通法规</a></li>\r\n");
out.write(
"\t\t\t\t\t\t<li class=\"subMenu\" id=\"edunmanage\"><a href=\"javascript:clickmenu('page/admin/page/eduback_viewEduList.action')\">宣教中心</a></li>\r\n");
out.write("\r\n");
out.write("\t\t\t\t\t <li class=\"subMenu\" id=\"baseinfo\"><a href=\"#\">基本信息</a>\r\n");
out.write("\t\t\t\t\t\t <ul>\r\n");
out.write(
"\t\t\t\t\t\t <!-- <li id=\"policeorgmanage\"><a href=\"javascript:clickmenu('page/admin/page/orgback_viewPoliceOrgList.action')\">交警部门</a></li> -->\r\n");
out.write(
"\t\t\t\t\t\t <li id=\"orgmanage\"><a href=\"javascript:clickmenu('page/admin/page/policeorgback_viewPoliceOrgList.action')\">交警部门</a></li>\r\n");
out.write(
"\t\t\t\t\t\t <li class=\"subMenu\" id=\"carlist\"><a href=\"javascript:clickmenu('page/admin/page/policeback_viewPoliceList.action')\">交警信息</a></li>\r\n");
out.write(
"\t\t\t\t\t\t\t<li id=\"companymanage\"><a href=\"javascript:clickmenu('page/admin/page/companyback_viewCompanyList.action')\">企业安全组</a></li>\r\n");
out.write(
"\t\t\t\t\t\t\t<li id=\"carmanage\"><a href=\"javascript:clickmenu('page/admin/page/carback_viewCarList.action')\">车辆管理</a></li>\r\n");
out.write(
"\t\t\t\t\t\t\t<li id=\"drivermanage\"><a href=\"javascript:clickmenu('page/admin/page/driverback_viewDriverList.action')\">驾驶员管理</a></li>\r\n");
out.write(
"\t\t\t\t\t\t \t<li class=\"subMenu\" id=\"editpassword\"><a href=\"javascript:clickmenu('page/admin/page/account_viewPassword.action?id=");
out.print(userid);
out.write("')\">修改密码</a></li>\r\n");
out.write("\t\t\t\t\t\t </ul>\r\n");
out.write("\t\t\t\t\t </li>\r\n");
out.write(
"\t\t\t\t\t\t<li class=\"subMenu\" id=\"rulenmanage\"><a href=\"javascript:clickmenu('page/admin/page/illegalback_viewIllegalList.action')\">违法查询</a></li>\r\n");
out.write("\r\n");
out.write(
"\t\t\t\t\t\t<li class=\"subMenu\" id=\"branchmanage\"><a href=\"javascript:clickmenu('page/admin/page/branchback_viewBranchList.action')\">快速处理点</a></li>\r\n");
out.write("\r\n");
out.write(
"\t\t\t\t\t\t<li class=\"subMenu\" id=\"safenoticemanage\"><a href=\"javascript:clickmenu('page/admin/page/safenoticeback_viewSafeNoticeList.action')\">安全提醒</a></li>\r\n");
out.write("\r\n");
out.write(
"\t\t\t\t\t\t<li class=\"subMenu\" id=\"meetnoticemanage\"><a href=\"javascript:clickmenu('page/admin/page/meetnoticeback_viewMeetNoticeList.action')\">会议通知</a></li>\r\n");
out.write("\r\n");
out.write(
"\t\t\t\t\t\t<li class=\"subMenu\" id=\"safelearn\"><a href=\"javascript:clickmenu('page/admin/page/safelearnback_viewEduList.action')\">安全教育学习</a></li>\r\n");
out.write("\t\t\t\t\t\t\r\n");
out.write(
"\t\t\t\t\t\t<li class=\"subMenu\" id=\"reprimand\"><a href=\"javascript:clickmenu('page/admin/page/reprimandback_viewReprimandList.action')\">通报批评</a></li>\r\n");
out.write("\t\t\t\t\t\r\n");
out.write(
"\t\t\t\t\t <li class=\"subMenu\" id=\"otherreprimand\"><a href=\"javascript:clickmenu('page/admin/page/otherreprimandback_viewReprimandList.action')\">通报批评</a></li>\r\n");
out.write("\t\t\t\t\t \r\n");
out.write(
"\t\t\t\t\t <li class=\"subMenu\" id=\"driverreprimand\"><a href=\"javascript:clickmenu('page/admin/page/otherreprimandback_showDriverReprimand.action')\">通报批评</a></li>\r\n");
out.write("\t\t\t\t\t \r\n");
out.write(
"\t\t\t\t\t <li class=\"subMenu\" id=\"interchangemanage\"><a href=\"javascript:clickmenu('page/admin/page/interchangeback_viewInterchangeList.action')\">问题答疑</a></li>\r\n");
out.write("\r\n");
out.write(
"\t\t\t\t\t\t<li class=\"subMenu\" id=\"micromessagemanage\"><a href=\"javascript:clickmenu('page/admin/page/micromessage/micromessagelist.jsp')\">微博互动</a></li>\r\n");
out.write("\t\t\t\t\t\r\n");
out.write("\t\t\t\t\t</ul>\r\n");
out.write("\t\t\t\t\t\r\n");
out.write("\t\t\t\t</div>\r\n");
out.write("\t\t\t</td>\r\n");
out.write("\t\t\t<td width=\"5px\">\r\n");
out.write("\t\t\t\t<div class=\"sidebar fleft\">\r\n");
out.write("\t\t\t\t\t<div class=\"btn\"></div>\r\n");
out.write("\t\t\t\t</div>\r\n");
out.write("\t\t\t</td>\r\n");
out.write("\t\t\t<td class=\"page\"><iframe width=\"100%\" scrolling=\"auto\"\r\n");
out.write("\t\t\t\t\theight=\"100%\" FRAMEBORDER=0 style=\"border: medium none;\"\r\n");
out.write(
"\t\t\t\t\tsrc=\"/TrafficPolice/page/admin/page/Startpage.jsp\" id=\"rightMain\"\r\n");
out.write("\t\t\t\t\tname=\"right\"></iframe>\r\n");
out.write("\t\t\t</td>\r\n");
out.write("\t\t</tr>\r\n");
out.write("\t\t<tr>\r\n");
out.write("\t\t\t<td colspan=\"3\"><div id=\"footer\"></div></td>\r\n");
out.write("\t\t</tr>\r\n");
out.write("\t</table>\r\n");
out.write("</body>\r\n");
out.write("\r\n");
out.write("</html>");
} catch (Throwable t) {
if (!(t instanceof 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);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}
public synchronized 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();
nseer_db_backup1 stock_db = new nseer_db_backup1(dbApplication);
nseer_db_backup1 crm_db = new nseer_db_backup1(dbApplication);
if (stock_db.conn((String) dbSession.getAttribute("unit_db_name"))
&& crm_db.conn((String) dbSession.getAttribute("unit_db_name"))) {
FileKind FileKind = new FileKind();
ValidataNumber validata = new ValidataNumber();
ValidataRecord vr = new ValidataRecord();
counter count = new counter(dbApplication);
ValidataTag vt = new ValidataTag();
String register_ID = (String) dbSession.getAttribute("human_IDD");
String config_id = request.getParameter("config_id");
String pay_ID = request.getParameter("pay_ID");
String product_amount = request.getParameter("product_amount");
int num = Integer.parseInt(product_amount);
String payer_name = request.getParameter("payer_name");
String payer_ID = request.getParameter("payer_ID");
String reason = request.getParameter("reason");
String not_return_tag = request.getParameter("not_return_tag");
String register = request.getParameter("register");
String register_time = request.getParameter("register_time");
String demand_return_time = request.getParameter("demand_return_time");
String sales_name = request.getParameter("sales_name");
String sales_ID = request.getParameter("sales_ID");
String bodyc = new String(request.getParameter("remark").getBytes("UTF-8"), "UTF-8");
String remark = exchange.toHtml(bodyc);
String time = "";
java.util.Date now = new java.util.Date();
SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd");
time = formatter.format(now);
String[] product_IDn = request.getParameterValues("product_ID");
String[] amountn = request.getParameterValues("amount");
if (num == 0 && product_IDn.length == 1) {
response.sendRedirect("draft/crm/credit_ok_a.jsp?pay_ID=" + pay_ID);
} else {
int p = 0;
for (int i = 1; i <= num; i++) {
String tem_amount = "amount" + i;
String amount = request.getParameter(tem_amount);
if (amount.equals("")) amount = "0";
if (!validata.validata(amount)) {
p++;
}
}
int n = 0;
String product_ID_group = "";
for (int j = 1; j < product_IDn.length; j++) {
product_ID_group += product_IDn[j] + ",";
if (amountn[j].equals("")) amountn[j] = "0";
if (!validata.validata(amountn[j])) {
p++;
}
}
for (int i = 1; i <= num; i++) {
String tem_product_ID = "product_ID" + i;
String product_ID = request.getParameter(tem_product_ID);
if (product_ID_group.indexOf(product_ID) != -1) n++;
}
if (vt.validata(
(String) dbSession.getAttribute("unit_db_name"),
"stock_apply_pay",
"pay_ID",
pay_ID,
"check_tag")
.equals("9")
|| vt.validata(
(String) dbSession.getAttribute("unit_db_name"),
"stock_apply_pay",
"pay_ID",
pay_ID,
"check_tag")
.equals("5")) {
if (p == 0) {
try {
if (n == 0) {
boolean flag = false;
List rsList = GetWorkflow.getList(crm_db, "crm_config_workflow", "05");
String[] elem = new String[3];
if (rsList.size() == 0) {
flag = true;
}
String sqll = "";
String[] aaa1 =
FileKind.getKind(
(String) dbSession.getAttribute("unit_db_name"),
"crm_file",
"customer_ID",
payer_ID);
String stock_pay_ID =
NseerId.getId("stock/pay", (String) dbSession.getAttribute("unit_db_name"));
double demand_amount = 0.0d;
double list_price_sum = 0.0d;
double 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_available_amount = "available_amount" + i;
String tem_amount = "amount" + i;
String tem_list_price = "list_price" + i;
String tem_cost_price = "cost_price" + i;
String tem_type = "type" + 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 available_amount = request.getParameter(tem_available_amount);
String amount = request.getParameter(tem_amount);
if (amount.equals("")) amount = "0";
String list_price2 = request.getParameter(tem_list_price);
String cost_price = request.getParameter(tem_cost_price);
String type = request.getParameter(tem_type);
StringTokenizer tokenTO3 = new StringTokenizer(list_price2, ",");
String list_price = "";
while (tokenTO3.hasMoreTokens()) {
String list_price1 = tokenTO3.nextToken();
list_price += list_price1;
}
String amount_unit = request.getParameter(tem_amount_unit);
double list_price_subtotal =
Double.parseDouble(list_price) * Double.parseDouble(amount);
list_price_sum += list_price_subtotal;
double cost_price_subtotal =
Double.parseDouble(cost_price) * Double.parseDouble(amount);
cost_price_sum += cost_price_subtotal;
demand_amount += Double.parseDouble(amount);
String sql1 =
"update stock_apply_pay_details set amount='"
+ amount
+ "',list_price='"
+ list_price
+ "',list_price_subtotal='"
+ list_price_subtotal
+ "',cost_price='"
+ cost_price
+ "',subtotal='"
+ cost_price_subtotal
+ "' where pay_ID='"
+ pay_ID
+ "' and details_number='"
+ i
+ "'";
stock_db.executeUpdate(sql1);
if (flag) {
if (type.equals("物料") || type.equals("外购商品")) {
String sql2 =
"insert into stock_pay_details(pay_ID,details_number,product_ID,product_name,type,list_price,list_price_subtotal,cost_price,subtotal,amount,unpay_amount,apply_manufacture_amount,apply_purchase_amount) values('"
+ stock_pay_ID
+ "','"
+ i
+ "','"
+ product_ID
+ "','"
+ product_name
+ "','"
+ type
+ "','"
+ list_price
+ "','"
+ list_price_subtotal
+ "','"
+ cost_price
+ "','"
+ cost_price_subtotal
+ "','"
+ amount
+ "','"
+ amount
+ "','0','"
+ amount
+ "')";
stock_db.executeUpdate(sql2);
} else if (type.equals("商品") || type.equals("部件") || type.equals("委外部件")) {
String sql2 =
"insert into stock_pay_details(pay_ID,details_number,product_ID,product_name,type,list_price,list_price_subtotal,cost_price,subtotal,amount,unpay_amount,apply_manufacture_amount,apply_purchase_amount) values('"
+ stock_pay_ID
+ "','"
+ i
+ "','"
+ product_ID
+ "','"
+ product_name
+ "','"
+ type
+ "','"
+ list_price
+ "','"
+ list_price_subtotal
+ "','"
+ cost_price
+ "','"
+ cost_price_subtotal
+ "','"
+ amount
+ "','"
+ amount
+ "','"
+ amount
+ "','0')";
stock_db.executeUpdate(sql2);
}
String sql97 =
"select * from crm_salecredit_balance_details where crediter_ID='"
+ payer_ID
+ "' and product_ID='"
+ product_ID
+ "'";
ResultSet rs97 = crm_db.executeQuery(sql97);
if (rs97.next()) {
double balance_amount =
rs97.getDouble("amount") + Double.parseDouble(amount);
double balance_cost_price_subtotal =
rs97.getDouble("subtotal") + cost_price_subtotal;
double balance_list_price_subtotal =
rs97.getDouble("list_price_subtotal") + list_price_subtotal;
String sql96 =
"update crm_salecredit_balance_details set amount='"
+ balance_amount
+ "',check_tag='1',subtotal='"
+ balance_cost_price_subtotal
+ "',list_price_subtotal='"
+ balance_list_price_subtotal
+ "' where crediter_ID='"
+ payer_ID
+ "' and product_ID='"
+ product_ID
+ "'";
crm_db.executeUpdate(sql96);
} else {
String[] aaa =
FileKind.getKind(
(String) dbSession.getAttribute("unit_db_name"),
"design_file",
"product_ID",
product_ID);
String sql95 =
"insert into crm_salecredit_balance_details(chain_ID,chain_name,crediter_chain_ID,crediter_chain_name,product_ID,product_name,list_price,list_price_subtotal,cost_price,subtotal,amount,crediter_ID,crediter_name) values('"
+ aaa[0]
+ "','"
+ aaa[1]
+ "','"
+ aaa1[0]
+ "','"
+ aaa1[1]
+ "','"
+ product_ID
+ "','"
+ product_name
+ "','"
+ list_price
+ "','"
+ list_price_subtotal
+ "','"
+ cost_price
+ "','"
+ cost_price_subtotal
+ "','"
+ amount
+ "','"
+ payer_ID
+ "','"
+ payer_name
+ "')";
crm_db.executeUpdate(sql95);
}
}
}
String[] cost_pricen = request.getParameterValues("cost_price");
String[] list_pricen = request.getParameterValues("list_price");
String[] product_namen = request.getParameterValues("product_name");
String[] product_describen = request.getParameterValues("product_describe");
String[] amount_unitn = request.getParameterValues("amount_unit");
String[] typen = request.getParameterValues("type");
for (int i = 1; i < product_IDn.length; i++) {
StringTokenizer tokenTO3 = new StringTokenizer(list_pricen[i], ",");
String list_price = "";
while (tokenTO3.hasMoreTokens()) {
String list_price1 = tokenTO3.nextToken();
list_price += list_price1;
}
if (!amountn[i].equals("") && Double.parseDouble(amountn[i]) != 0) {
double list_price_subtotal =
Double.parseDouble(list_price) * Double.parseDouble(amountn[i]);
list_price_sum += list_price_subtotal;
double subtotal =
Double.parseDouble(cost_pricen[i]) * Double.parseDouble(amountn[i]);
cost_price_sum += subtotal;
demand_amount += Double.parseDouble(amountn[i]);
num++;
String sql1 =
"insert into stock_apply_pay_details(payer_chain_ID,payer_chain_name,sales_ID,sales_name,payer_ID,payer_name,payer_type,pay_ID,details_number,product_ID,product_name,product_describe,amount,amount_unit,list_price,list_price_subtotal,cost_price,subtotal,type) values ('"
+ aaa1[0]
+ "','"
+ aaa1[1]
+ "','"
+ sales_ID
+ "','"
+ sales_name
+ "','"
+ payer_ID
+ "','"
+ payer_name
+ "','销售赊货','"
+ pay_ID
+ "','"
+ num
+ "','"
+ product_IDn[i]
+ "','"
+ product_namen[i]
+ "','"
+ product_describen[i]
+ "','"
+ amountn[i]
+ "','"
+ amount_unitn[i]
+ "','"
+ list_price
+ "','"
+ list_price_subtotal
+ "','"
+ cost_pricen[i]
+ "','"
+ subtotal
+ "','"
+ typen[i]
+ "')";
stock_db.executeUpdate(sql1);
// **********************
if (rsList.size() == 0) {
if (typen[i].equals("物料") || typen[i].equals("外购商品")) {
String sql2 =
"insert into stock_pay_details(pay_ID,details_number,product_ID,product_name,type,list_price,list_price_subtotal,cost_price,subtotal,amount,unpay_amount,apply_manufacture_amount,apply_purchase_amount) values('"
+ stock_pay_ID
+ "','"
+ num
+ "','"
+ product_IDn[i]
+ "','"
+ product_namen[i]
+ "','"
+ typen[i]
+ "','"
+ list_price
+ "','"
+ list_price_subtotal
+ "','"
+ cost_pricen[i]
+ "','"
+ subtotal
+ "','"
+ amountn[i]
+ "','"
+ amountn[i]
+ "','0','"
+ amountn[i]
+ "')";
stock_db.executeUpdate(sql2);
} else if (typen[i].equals("商品")
|| typen[i].equals("部件")
|| typen[i].equals("委外部件")) {
String sql2 =
"insert into stock_pay_details(pay_ID,details_number,product_ID,product_name,type,list_price,list_price_subtotal,cost_price,subtotal,amount,unpay_amount,apply_manufacture_amount,apply_purchase_amount) values('"
+ stock_pay_ID
+ "','"
+ num
+ "','"
+ product_IDn[i]
+ "','"
+ product_namen[i]
+ "','"
+ typen[i]
+ "','"
+ list_price
+ "','"
+ list_price_subtotal
+ "','"
+ cost_pricen[i]
+ "','"
+ subtotal
+ "','"
+ amountn[i]
+ "','"
+ amountn[i]
+ "','"
+ amountn[i]
+ "','0')";
stock_db.executeUpdate(sql2);
}
String sql97 =
"select * from crm_salecredit_balance_details where crediter_ID='"
+ payer_ID
+ "' and product_ID='"
+ product_IDn[i]
+ "'";
ResultSet rs97 = crm_db.executeQuery(sql97);
if (rs97.next()) {
double balance_amount =
rs97.getDouble("amount") + Double.parseDouble(amountn[i]);
double balance_cost_price_subtotal =
rs97.getDouble("subtotal") + subtotal;
double balance_list_price_subtotal =
rs97.getDouble("list_price_subtotal") + list_price_subtotal;
String sql96 =
"update crm_salecredit_balance_details set amount='"
+ balance_amount
+ "',check_tag='1',subtotal='"
+ balance_cost_price_subtotal
+ "',list_price_subtotal='"
+ balance_list_price_subtotal
+ "' where crediter_ID='"
+ payer_ID
+ "' and product_ID='"
+ product_IDn[i]
+ "'";
crm_db.executeUpdate(sql96);
} else {
String[] aaa =
FileKind.getKind(
(String) dbSession.getAttribute("unit_db_name"),
"design_file",
"product_ID",
product_IDn[i]);
String sql95 =
"insert into crm_salecredit_balance_details(chain_ID,chain_name,crediter_chain_ID,crediter_chain_name,product_ID,product_name,list_price,list_price_subtotal,cost_price,subtotal,amount,crediter_ID,crediter_name) values('"
+ aaa[0]
+ "','"
+ aaa[1]
+ "','"
+ aaa1[0]
+ "','"
+ aaa1[1]
+ "','"
+ product_IDn[i]
+ "','"
+ product_namen[i]
+ "','"
+ list_price
+ "','"
+ list_price_subtotal
+ "','"
+ cost_pricen[i]
+ "','"
+ subtotal
+ "','"
+ amountn[i]
+ "','"
+ payer_ID
+ "','"
+ payer_name
+ "')";
crm_db.executeUpdate(sql95);
}
}
// ***************************
}
}
String sql =
"update stock_apply_pay set reason='"
+ reason
+ "',register='"
+ register
+ "',register_time='"
+ register_time
+ "',demand_return_time='"
+ demand_return_time
+ "',register_time='"
+ register_time
+ "',register='"
+ register
+ "',remark='"
+ remark
+ "',demand_amount='"
+ demand_amount
+ "',list_price_sum='"
+ list_price_sum
+ "',cost_price_sum='"
+ cost_price_sum
+ "',not_return_tag='"
+ not_return_tag
+ "' where pay_ID='"
+ pay_ID
+ "'";
stock_db.executeUpdate(sql);
if (flag) {
sql = "update stock_apply_pay set check_tag='1' where pay_ID='" + pay_ID + "'";
stock_db.executeUpdate(sql);
if (!vr.validata(
(String) dbSession.getAttribute("unit_db_name"),
"stock_pay",
"reasonexact",
pay_ID)) {
String sql4 =
"insert into stock_pay(pay_ID,reason,reasonexact,reasonexact_details,demand_amount,list_price_sum,cost_price_sum,register,register_time) values('"
+ stock_pay_ID
+ "','"
+ reason
+ "','"
+ pay_ID
+ "','"
+ payer_name
+ "','"
+ demand_amount
+ "','"
+ list_price_sum
+ "','"
+ cost_price_sum
+ "','"
+ register
+ "','"
+ register_time
+ "')";
stock_db.executeUpdate(sql4);
}
String sql98 = "select * from crm_file where customer_ID='" + payer_ID + "'";
ResultSet rs98 = crm_db.executeQuery(sql98);
if (rs98.next()) {
double salecredit_list_price_sum =
rs98.getDouble("salecredit_list_price_sum") + list_price_sum;
double salecredit_cost_price_sum =
rs98.getDouble("salecredit_cost_price_sum") + cost_price_sum;
String sql99 =
"update crm_file set credit_yes_or_not_tag='1',salecredit_list_price_sum='"
+ salecredit_list_price_sum
+ "',salecredit_cost_price_sum='"
+ salecredit_cost_price_sum
+ "' where customer_ID='"
+ payer_ID
+ "' ";
crm_db.executeUpdate(sql99);
}
} else {
sql = "update stock_apply_pay set check_tag='0' where pay_ID='" + pay_ID + "'";
stock_db.executeUpdate(sql);
Iterator ite = rsList.iterator();
while (ite.hasNext()) {
elem = (String[]) ite.next();
sql =
"insert into crm_workflow(config_id,object_ID,describe1,describe2) values ('"
+ elem[0]
+ "','"
+ pay_ID
+ "','"
+ elem[1]
+ "','"
+ elem[2]
+ "')";
crm_db.executeUpdate(sql);
}
}
response.sendRedirect("draft/crm/credit_ok.jsp?finished_tag=8");
} else {
response.sendRedirect(
"draft/crm/credit_ok.jsp?finished_tag=7&pay_ID=" + pay_ID + "");
}
} catch (Exception ex) {
ex.printStackTrace();
}
} else {
response.sendRedirect("draft/crm/credit_ok.jsp?finished_tag=6&pay_ID=" + pay_ID + "");
}
} else {
response.sendRedirect("draft/crm/credit_ok.jsp?finished_tag=9");
}
}
stock_db.commit();
crm_db.commit();
stock_db.close();
crm_db.close();
} else {
response.sendRedirect("error_conn.htm");
}
} catch (Exception ex) {
ex.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=utf-8");
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\n");
out.write("\r\n");
out.write("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">\r\n");
out.write("<html>\r\n");
out.write(" <head>\r\n");
out.write(" <style type=\"text/css\">\r\n");
out.write("<!--\r\n");
out.write("body {\r\n");
out.write("\tbackground-image: url(images/bb286.gif);\r\n");
out.write("\tbackground-repeat: repeat-y;\r\n");
out.write("\tbackground-position: center;\r\n");
out.write("}\r\n");
out.write(".STYLE3 {\r\n");
out.write("\tcolor: #000080;\r\n");
out.write("\tfont-weight: bold;\r\n");
out.write("}\r\n");
out.write("-->\r\n");
out.write(" </style>\r\n");
out.write(" <title>增加课程</title>\r\n");
out.write(" <SCRIPT LANGUAGE = \"JavaScript\"> \r\n");
out.write("function check()\r\n");
out.write("{\r\n");
out.write("var numb1= document.addcourse.name.value;\r\n");
out.write("var numb2= document.addcourse.course_id.value;\r\n");
out.write("if (numb1==\"\"&&numb2==\"\")\r\n");
out.write("{\r\n");
out.write(" alert(\"课程名和课程号不能为空！\");\r\n");
out.write("return false;\r\n");
out.write("}\r\n");
out.write("else if (numb1==\"\")\r\n");
out.write("{\r\n");
out.write(" alert(\"课程名不能为空！\");\r\n");
out.write("return false;\r\n");
out.write("}\r\n");
out.write("else if (numb2==\"\")\r\n");
out.write("{\r\n");
out.write("\t alert(\"课程号不能为空！\");\r\n");
out.write("return false;\r\n");
out.write("}\r\n");
out.write("else \r\n");
out.write("\treturn true;\r\n");
out.write("\r\n");
out.write("}\r\n");
out.write("\r\n");
out.write("</SCRIPT>\r\n");
out.write(" </head>\r\n");
out.write(" <body>\r\n");
String admin_id = (String) session.getAttribute("id");
if (admin_id == null) {
response.sendRedirect("./adm_login.jsp");
}
out.write("\r\n");
out.write(
"<form name=\"addcourse\" onSubmit=\"return check()\" method=\"post\" action=\"addcourse\">\r\n");
out.write(" <p> </p>\r\n");
out.write(" <div align=\"center\"></div>\r\n");
out.write(" <br>\r\n");
out.write(" <br>\r\n");
out.write(" <table width=\"37%\" border=\"1\" align=\"center\">\r\n");
out.write(" <tr> \r\n");
out.write(" <td width=\"37%\">课程名</td>\r\n");
out.write(" <td width=\"63%\"><input name=\"name\" type=\"text\"></td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr> \r\n");
out.write(" <td>课程号</td>\r\n");
out.write(" <td><input name=\"course_id\" type=\"text\"></td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr> \r\n");
out.write(" <td>学分</td>\r\n");
out.write(" <td><select name=\"mark\" size=\"1\" id=\"mark\">\r\n");
out.write(" <option value=\"1\">1</option>\r\n");
out.write(" <option value=\"2\">2</option>\r\n");
out.write(" <option value=\"3\">3</option>\r\n");
out.write(" <option value=\"4\">4</option>\r\n");
out.write(" </select></td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr> \r\n");
out.write(" <td>开课学院</td>\r\n");
out.write(" <td><select name=\"dep\" size=\"1\">\r\n");
out.write(" <option>软件学院</option>\r\n");
out.write(" <option>人文学院</option>\r\n");
out.write(" <option>外语学院</option>\r\n");
out.write(" <option>经贸学院</option>\r\n");
out.write(" <option>理学院</option>\r\n");
out.write(" <option>法学院</option>\r\n");
out.write(" <option>教科学院</option>\r\n");
out.write(" <option>政管学院</option>\r\n");
out.write(" <option>健行学院</option>\r\n");
out.write(" <option>生环学院</option>\r\n");
out.write(" \t <option>机械学院</option>\r\n");
out.write(" \t <option>信息学院</option>\r\n");
out.write(" \t <option>化材学院</option>\r\n");
out.write(" \t <option>国际学院</option>\r\n");
out.write(" \t <option>药学院</option>\r\n");
out.write(" \t <option>艺术学院</option>\r\n");
out.write(" \t <option>建工学院</option>\r\n");
out.write(" \t <option>之江学院</option>\r\n");
out.write(" </select></td>\r\n");
out.write(" </tr>\r\n");
out.write(" </table>\r\n");
out.write(" <p align=\"center\"> \r\n");
out.write(" <input type=\"submit\" name=\"submit\" value=\"提交\">\r\n");
out.write(" </p>\r\n");
out.write(" </form>\r\n");
out.write(" </body>\r\n");
out.write("</html>\r\n");
} catch (Throwable t) {
if (!(t instanceof 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);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}
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);
}
}
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 _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
javax.servlet.jsp.PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html;charset=ISO-8859-1");
pageContext =
_jspxFactory.getPageContext(this, request, response, "/error.jsp", true, 8192, true);
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");
/** This include page ensures that the handler exists and is ready to be accessed. */
CrawlJobHandler handler = (CrawlJobHandler) application.getAttribute("handler");
Heritrix heritrix = (Heritrix) application.getAttribute("heritrix");
// If handler is empty then this is the first time this bit of code is
// being run since the server came online. In that case get or create the
// handler.
if (handler == null) {
if (Heritrix.isSingleInstance()) {
heritrix = Heritrix.getSingleInstance();
handler = heritrix.getJobHandler();
application.setAttribute("heritrix", heritrix);
application.setAttribute("handler", handler);
} else {
// TODO:
// If we get here, then there are multiple heritrix instances
// and we have to put up a screen allowing the user choose between.
// Otherwise, there is no Heritrix instance. Thats a problem.
throw new RuntimeException(
"No heritrix instance (or multiple "
+ "to choose from and we haven't implemented this yet)");
}
}
// ensure controller's settingsHandler is always thread-installed
// in web ui threads
if (handler != null) {
CrawlJob job = handler.getCurrentJob();
if (job != null) {
CrawlController controller = job.getController();
if (controller != null) {
controller.installThreadContextSettingsHandler();
}
}
}
out.write("\n");
out.write("\n");
/** This webpage performs actions that can be performed from the console. */
String sAction = request.getParameter("action");
if (sAction != null) {
// Need to handle an action
if (sAction.equalsIgnoreCase("start")) {
// Tell handler to start crawl job
handler.startCrawler();
} else if (sAction.equalsIgnoreCase("stop")) {
// Tell handler to stop crawl job
handler.stopCrawler();
} else if (sAction.equalsIgnoreCase("terminate")) {
// Delete current job
if (handler.getCurrentJob() != null) {
handler.deleteJob(handler.getCurrentJob().getUID());
}
} else if (sAction.equalsIgnoreCase("pause")) {
// Tell handler to pause crawl job
handler.pauseJob();
} else if (sAction.equalsIgnoreCase("resume")) {
// Tell handler to resume crawl job
handler.resumeJob();
} else if (sAction.equalsIgnoreCase("checkpoint")) {
if (handler.getCurrentJob() != null) {
handler.checkpointJob();
}
}
}
response.sendRedirect(request.getContextPath() + "/index.jsp");
out.write("\n");
} catch (Throwable t) {
out = _jspx_out;
if (out != null && out.getBufferSize() != 0) out.clearBuffer();
if (pageContext != null) pageContext.handlePageException(t);
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
}
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
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 {
_jspxFactory = JspFactory.getDefaultFactory();
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("\n\n\n\n\n");
boolean exportUsers = request.getParameter("exportUsers") != null;
boolean success = request.getParameter("success") != null;
boolean exportToFile = ParamUtils.getBooleanParameter(request, "exporttofile", true);
ImportExportPlugin plugin =
(ImportExportPlugin)
XMPPServer.getInstance().getPluginManager().getPlugin("userimportexport");
String exportText = "";
Map<String, String> errors = new HashMap<String, String>();
if (exportUsers) {
if (exportToFile) {
String file = ParamUtils.getParameter(request, "exportFile");
if ((file == null) || (file.length() <= 0)) {
errors.put("missingFile", "missingFile");
} else {
response.sendRedirect("export-file.jsp?fileName=" + file);
}
} else {
try {
exportText = plugin.exportUsersToString();
} catch (IOException e) {
errors.put("IOException", "IOException");
}
}
}
out.write(
"\n\n<html>\n <head>\n <title>Export User Data</title>\n <meta name=\"pageID\" content=\"import-export-selection\"/>\n </head>\n <body>\n\n");
if (errors.size() > 0) {
out.write(
"\n\n <div class=\"jive-error\">\n <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n <tbody>\n <tr>\n <td class=\"jive-icon\"><img src=\"images/error-16x16.gif\" width=\"16\" height=\"16\" border=\"0\"></td>\n <td class=\"jive-icon-label\">\n ");
if (errors.containsKey("missingFile")) {
out.write("\n Missing or bad file name.\n ");
} else if (errors.containsKey("IOException") || errors.containsKey("fileNotCreated")) {
out.write("\n Couldn't create export file.\n ");
}
out.write(
"\n </td>\n </tr>\n </tbody>\n </table>\n </div>\n <br>\n\n");
} else if (ParamUtils.getBooleanParameter(request, "success")) {
out.write(
"\n\n <div class=\"jive-success\">\n <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n <tbody>\n <tr>\n <td class=\"jive-icon\"><img src=\"images/success-16x16.gif\" width=\"16\" height=\"16\" border=\"0\"></td>\n <td class=\"jive-icon-label\">User data successfully exported.</td>\n </tr>\n </tbody>\n </table>\n </div>\n <br>\n \n");
}
out.write(
"\n\n<form action=\"export-user-data.jsp?exportUsers\" method=\"post\">\n\n<div class=\"jive-contentBoxHeader\">Export Options</div>\n<div class=\"jive-contentBox\">\n <p>\n Select the radio button next to the desired export option and then click on the Export button.\n </p>\n \n <table cellpadding=\"3\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n <tbody>\n <tr>\n <td width=\"1%\"><input type=\"radio\" name=\"exporttofile\" value=\"true\" ");
out.print(exportToFile ? "checked" : "");
out.write(
" id=\"rb01\"></td>\n <td width=\"99%\"><label for=\"rb01\"><b>To File</b></label> - Save user data to the specified file location.</td>\n </tr>\n <tr>\n <td width=\"1%\"> </td>\n <td width=\"99%\">Export File Name: <input type=\"text\" size=\"30\" maxlength=\"150\" name=\"exportFile\"></td>\n </tr>\n <tr>\n <td width=\"1%\"><input type=\"radio\" name=\"exporttofile\" value=\"false\" ");
out.print(!exportToFile ? "checked" : "");
out.write(
" id=\"rb02\"></td>\n <td width=\"99%\"><label for=\"rb02\"><b>To Screen</b></label> - Display user data in the text area below.</td> \n </tr>\n <tr>\n <td width=\"1%\"> </td>\n <td width=\"99%\"><textarea cols=\"80\" rows=\"20\" wrap=off>");
out.print(exportText);
out.write(
"</textarea></td>\n </tr>\n </tbody>\n </table>\n</div>\n\n<input type=\"submit\" value=\"Export\">\n</form>\n\n</body>\n</html>");
} 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);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
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 security_db = new nseer_db_backup1(dbApplication);
if (security_db.conn((String) dbSession.getAttribute("unit_db_name"))) {
getRecordCount query = new getRecordCount();
String tablename = request.getParameter("tablename");
String[] cols = request.getParameterValues("col");
if (cols == null) {
response.sendRedirect("hr/config/key/key_register_ok_a.jsp");
} else {
String column_group = "";
for (int i = 0; i < cols.length; i++) {
column_group += cols[i] + ",";
}
column_group = column_group.substring(0, column_group.length() - 1);
String sql1 =
"select * from security_publicconfig_key where tablename='" + tablename + "'";
ResultSet rs = security_db.executeQuery(sql1);
if (rs.next()) {
String sql =
"update security_publicconfig_key set column_group='"
+ column_group
+ "' where tablename='"
+ tablename
+ "'";
security_db.executeUpdate(sql);
} else {
String sql =
"insert into security_publicconfig_key(tablename,column_group) values('"
+ tablename
+ "','"
+ column_group
+ "')";
security_db.executeUpdate(sql);
}
response.sendRedirect("hr/config/key/key_register_ok_b.jsp");
}
security_db.commit();
security_db.close();
} else {
response.sendRedirect("error_conn.htm");
}
} catch (Exception ex) {
}
}
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();
PrintWriter out = response.getWriter();
ServletContext application;
HttpSession session = request.getSession();
nseer_db_backup1 finance_db = new nseer_db_backup1(dbApplication);
ValidataNumber validata = new ValidataNumber();
try {
if (finance_db.conn((String) dbSession.getAttribute("unit_db_name"))) {
String file_id = request.getParameter("file_id");
String balance_sum = request.getParameter("balance_sum");
String balance_sum1 = request.getParameter("balance_sum1");
if (validata.validata(balance_sum) && validata.validata(balance_sum1)) {
String sql2 = "select id from finance_bill where tag='1' and file_id='" + file_id + "'";
ResultSet rs2 = finance_db.executeQuery(sql2);
String sql = "";
if (rs2.next()) {
sql =
"update finance_bill set debit_subtotal='"
+ balance_sum1
+ "' where tag='1' and file_id='"
+ file_id
+ "'";
} else {
sql =
"insert into finance_bill(debit_subtotal,file_id,tag) values('"
+ balance_sum1
+ "','"
+ file_id
+ "','1')";
}
finance_db.executeUpdate(sql);
sql2 =
"select id from finance_voucher where account_period='18' and chain_id='"
+ file_id
+ "'";
rs2 = finance_db.executeQuery(sql2);
if (rs2.next()) {
sql =
"update finance_voucher set debit_subtotal='"
+ balance_sum
+ "' where account_period='18' and chain_id='"
+ file_id
+ "'";
} else {
sql =
"insert into finance_voucher(debit_subtotal,chain_id,account_period) values('"
+ balance_sum
+ "','"
+ file_id
+ "','18')";
}
finance_db.executeUpdate(sql);
finance_db.commit();
finance_db.close();
} else {
out.println("1");
}
} else {
response.sendRedirect("error_conn.htm");
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
public synchronized 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 {
ValidataNumber validata = new ValidataNumber();
nseer_db_backup1 crm_db = new nseer_db_backup1(dbApplication);
if (crm_db.conn((String) dbSession.getAttribute("unit_db_name"))) {
counter count = new counter(dbApplication);
PrintWriter out = response.getWriter();
String product_amount = request.getParameter("product_amount");
String reasonexact = request.getParameter("reasonexact");
String which_time = request.getParameter("which_time");
int num = Integer.parseInt(product_amount);
String reason = request.getParameter("reason");
String customer_ID = request.getParameter("customer_ID");
String customer_name = request.getParameter("customer_name");
String real_customer_mailing_address =
request.getParameter("real_customer_mailing_address");
String real_contact_person = request.getParameter("real_contact_person");
String real_contact_person_tel = request.getParameter("real_contact_person_tel");
String real_contact_person_fax = request.getParameter("real_contact_person_fax");
String real_invoice_time = request.getParameter("real_invoice_time");
String real_invoice_type = request.getParameter("real_invoice_type");
String register = request.getParameter("register");
String register_ID = request.getParameter("register_ID");
String invoice_group = request.getParameter("invoice_group");
String register_time = request.getParameter("register_time");
double invoiced_subtotal_sum = 0.0d;
double invoiced_subtotal_sum_all = 0.0d;
int p = 0;
for (int i = 1; i <= num; i++) {
String tem_invoice_sum = "invoice_sum" + i;
String invoice_sum2 = request.getParameter(tem_invoice_sum);
if (invoice_sum2.equals("")) invoice_sum2 = "0";
StringTokenizer tokenTO2 = new StringTokenizer(invoice_sum2, ",");
String invoice_sum = "";
while (tokenTO2.hasMoreTokens()) {
String invoice_sum1 = tokenTO2.nextToken();
invoice_sum += invoice_sum1;
}
if (!validata.validata(invoice_sum)) {
p++;
}
}
if (p == 0) {
int n = 0;
if (n == 0) {
String sql8 =
"select * from crm_order where order_id='"
+ reasonexact
+ "' and (invoice_check_tag='9' or invoice_check_tag='5') and which_time='"
+ which_time
+ "'";
ResultSet rs8 = crm_db.executeQuery(sql8);
if (rs8.next()) {
for (int j = 1; j <= num; j++) {
String tem_details_number = "details_number" + j;
String tem_id = "id" + j;
String id = request.getParameter(tem_id);
String details_number = request.getParameter(tem_details_number);
}
String product_ID_control1 = request.getParameter("product_ID1");
String subtotal_control1 = request.getParameter("invoiced_subtotal1");
double subtotal_control = Double.parseDouble(subtotal_control1);
for (int j = 1; j <= num; j++) {
invoiced_subtotal_sum = 0;
String tem_details_number = "details_number" + j;
String tem_product_name = "product_name" + j;
String tem_product_ID = "product_ID" + j;
String tem_subtotal = "subtotal" + j;
String tem_invoice_sum = "invoice_sum" + j;
String tem_invoiced_subtotal = "invoiced_subtotal" + j;
String tem_remark = "remark" + j;
String tem_id = "id" + j;
String id = request.getParameter(tem_id);
String product_name = request.getParameter(tem_product_name);
String product_ID = request.getParameter(tem_product_ID);
String details_number = request.getParameter(tem_details_number);
String subtotal = request.getParameter(tem_subtotal);
String invoiced_subtotal = request.getParameter(tem_invoiced_subtotal);
String invoice_sum2 = request.getParameter(tem_invoice_sum);
if (invoice_sum2.equals("")) invoice_sum2 = "0";
StringTokenizer tokenTO1 = new StringTokenizer(invoice_sum2, ",");
String invoice_sum = "";
while (tokenTO1.hasMoreTokens()) {
String invoice_sum1 = tokenTO1.nextToken();
invoice_sum += invoice_sum1;
}
String remark = request.getParameter(tem_remark);
if (product_ID.equals(product_ID_control1)) {
if (invoice_sum != null && Double.parseDouble(invoice_sum) != 0) {
subtotal_control += Double.parseDouble(invoice_sum);
invoiced_subtotal_sum_all += Double.parseDouble(invoice_sum);
String sql1 =
"update crm_ordering set reason='"
+ reason
+ "',customer_ID='"
+ customer_ID
+ "',customer_name='"
+ customer_name
+ "',real_customer_mailing_address='"
+ real_customer_mailing_address
+ "',real_contact_person='"
+ real_contact_person
+ "',real_contact_person_tel='"
+ real_contact_person_tel
+ "',real_contact_person_fax='"
+ real_contact_person_fax
+ "',real_invoice_time='"
+ real_invoice_time
+ "',real_invoice_type='"
+ real_invoice_type
+ "',register='"
+ register
+ "',register_ID='"
+ register_ID
+ "',register_time='"
+ register_time
+ "',product_ID='"
+ product_ID
+ "',product_name='"
+ product_name
+ "',invoice_sum='"
+ invoice_sum
+ "',remark='"
+ remark
+ "',invoice_group='"
+ invoice_group
+ "' where id='"
+ id
+ "'";
crm_db.executeUpdate(sql1);
if (subtotal_control == Double.parseDouble(subtotal)) {
String sql2 =
"update crm_order_details set invoiced_subtotal='"
+ subtotal_control
+ "',invoice_tag='1' where order_ID='"
+ reasonexact
+ "' and details_number='"
+ details_number
+ "'";
crm_db.executeUpdate(sql2);
} else {
String sql3 =
"update crm_order_details set invoiced_subtotal='"
+ subtotal_control
+ "' where order_ID='"
+ reasonexact
+ "' and details_number='"
+ details_number
+ "'";
crm_db.executeUpdate(sql3);
}
} else if (Double.parseDouble(invoice_sum) == 0) {
String sql7 = "delete from crm_ordering where id='" + id + "'";
crm_db.executeUpdate(sql7);
}
} else {
if (invoice_sum != null && Double.parseDouble(invoice_sum) != 0) {
product_ID_control1 = product_ID;
subtotal_control =
Double.parseDouble(invoiced_subtotal) + Double.parseDouble(invoice_sum);
invoiced_subtotal_sum_all += Double.parseDouble(invoice_sum);
String sql1 =
"update crm_ordering set reason='"
+ reason
+ "',customer_ID='"
+ customer_ID
+ "',customer_name='"
+ customer_name
+ "',real_customer_mailing_address='"
+ real_customer_mailing_address
+ "',real_contact_person='"
+ real_contact_person
+ "',real_contact_person_tel='"
+ real_contact_person_tel
+ "',real_contact_person_fax='"
+ real_contact_person_fax
+ "',real_invoice_time='"
+ real_invoice_time
+ "',real_invoice_type='"
+ real_invoice_type
+ "',register='"
+ register
+ "',register_ID='"
+ register_ID
+ "',register_time='"
+ register_time
+ "',product_ID='"
+ product_ID
+ "',product_name='"
+ product_name
+ "',invoice_sum='"
+ invoice_sum
+ "',remark='"
+ remark
+ "',invoice_group='"
+ invoice_group
+ "' where id='"
+ id
+ "'";
crm_db.executeUpdate(sql1);
if (subtotal_control == Double.parseDouble(subtotal)) {
String sql2 =
"update crm_order_details set invoiced_subtotal='"
+ subtotal_control
+ "',invoice_tag='1' where order_ID='"
+ reasonexact
+ "' and details_number='"
+ details_number
+ "'";
crm_db.executeUpdate(sql2);
} else {
String sql3 =
"update crm_order_details set invoiced_subtotal='"
+ subtotal_control
+ "' where order_ID='"
+ reasonexact
+ "' and details_number='"
+ details_number
+ "'";
crm_db.executeUpdate(sql3);
}
} else if (Double.parseDouble(invoice_sum) == 0) {
String sql7 = "delete from crm_ordering where id='" + id + "'";
crm_db.executeUpdate(sql7);
}
}
}
String sql2 =
"update crm_order set invoice_check_tag='2' where order_ID='" + reasonexact + "'";
crm_db.executeUpdate(sql2);
response.sendRedirect("draft/crm/invoice_ok.jsp?finished_tag=2");
} else {
response.sendRedirect("draft/crm/invoice_ok.jsp?finished_tag=1");
}
} else {
response.sendRedirect("draft/crm/invoice_ok_a.jsp?order_ID=" + reasonexact + "");
}
} else {
response.sendRedirect("draft/crm/invoice_ok_b.jsp?order_ID=" + reasonexact + "");
}
crm_db.commit();
crm_db.close();
} else {
response.sendRedirect("error_conn.htm");
}
} catch (Exception ex) {
}
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
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 {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html");
pageContext =
_jspxFactory.getPageContext(this, request, response, "error.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("\r\n\r\n\r\n\r\n\r\n");
PresencePlugin plugin =
(PresencePlugin) XMPPServer.getInstance().getPluginManager().getPlugin("presence");
// Get parameters
boolean save = request.getParameter("save") != null;
boolean success = request.getParameter("success") != null;
boolean presencePublic = ParamUtils.getBooleanParameter(request, "presencePublic");
String unavailableStatus =
ParamUtils.getParameter(request, "presenceUnavailableStatus", false);
if (unavailableStatus == null) {
unavailableStatus = plugin.getUnavailableStatus();
}
// Handle a save
if (save) {
plugin.setPresencePublic(presencePublic);
plugin.setUnavailableStatus(unavailableStatus);
response.sendRedirect("presence-service.jsp?success=true");
return;
}
presencePublic = plugin.isPresencePublic();
out.write(
"\r\n\r\n<html>\r\n <head>\r\n <title>Presence Service</title>\r\n <meta name=\"pageID\" content=\"presence-service\"/>\r\n </head>\r\n <body>\r\n\r\n<div class=\"information\">\r\n ");
String serverName = XMPPServer.getInstance().getServerInfo().getXMPPDomain();
int port = JiveGlobals.getXMLProperty("adminConsole.port", -1);
int securePort = JiveGlobals.getXMLProperty("adminConsole.securePort", -1);
boolean secureOnly = (port == -1);
out.write("\r\n\r\n Presence Service URL:<br>\r\n <tt>");
out.print(secureOnly ? "https" : "http");
out.write(':');
out.write('/');
out.write('/');
out.print(serverName);
out.write(':');
out.print(secureOnly ? securePort : port);
out.write("/plugins/presence/status</tt>\r\n <br><br>\r\n Example:<br>\r\n <tt>");
out.print(secureOnly ? "https" : "http");
out.write(':');
out.write('/');
out.write('/');
out.print(serverName);
out.write(':');
out.print(secureOnly ? securePort : port);
out.write("/plugins/presence/status?jid=admin@");
out.print(serverName);
out.write(
"</tt> \r\n\r\n\r\n</div>\r\n\r\n<p>\r\nUse the form below to configure user presence visibility. By default, user\r\npresence should only be visible to those users that are authorized.<br>\r\n</p>\r\n\r\n");
if (success) {
out.write(
"\r\n\r\n <div class=\"jive-success\">\r\n <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\r\n <tbody>\r\n <tr><td class=\"jive-icon\"><img src=\"images/success-16x16.gif\" width=\"16\" height=\"16\" border=\"0\"></td>\r\n <td class=\"jive-icon-label\">\r\n Presence service properties edited successfully.\r\n </td></tr>\r\n </tbody>\r\n </table>\r\n </div><br>\r\n");
}
out.write(
"\r\n\r\n<form action=\"presence-service.jsp?save\" method=\"post\">\r\n\r\n<fieldset>\r\n <legend>Presence visibility</legend>\r\n <div>\r\n <p>\r\n For security reasons, users control which users are authorized to see their presence. However,\r\n it is posible to configure the service so that anyone has access to all presence information.\r\n Use this option with caution.\r\n </p>\r\n <table cellpadding=\"3\" cellspacing=\"0\" border=\"0\" width=\"100%\">\r\n <tbody>\r\n <tr>\r\n <td width=\"1%\">\r\n <input type=\"radio\" name=\"presencePublic\" value=\"true\" id=\"rb01\"\r\n ");
out.print(((presencePublic) ? "checked" : ""));
out.write(
">\r\n </td>\r\n <td width=\"99%\">\r\n <label for=\"rb01\"><b>Anyone</b> - Anyone may get presence information.</label>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width=\"1%\">\r\n <input type=\"radio\" name=\"presencePublic\" value=\"false\" id=\"rb02\"\r\n ");
out.print(((!presencePublic) ? "checked" : ""));
out.write(
">\r\n </td>\r\n <td width=\"99%\">\r\n <label for=\"rb02\"><b>Subscribed</b> - Presence information is only visibile to authorized users.</label>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </div>\r\n</fieldset>\r\n\r\n<br>\r\n \r\n<fieldset>\r\n <legend>Plain Text 'Unavailable' Status Message</legend>\r\n <div>\r\n <p>\r\n In "text" mode the status message for unavailable users is "Unavailable"\r\n by default. It is possible to change the unavailable status message by setting this property.\r\n </p>\r\n <p>\r\n <input type=\"text\" name=\"presenceUnavailableStatus\" value=\"");
out.print(unavailableStatus);
out.write(
"\">\r\n </p>\r\n </div>\r\n</fieldset>\r\n\r\n<br><br>\r\n\r\n<input type=\"submit\" value=\"Save Properties\">\r\n</form>\r\n\r\n</body>\r\n</html>");
} 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);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
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=UTF-8");
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("\n");
out.write("\n");
out.write("<!DOCTYPE html>\n");
out.write("<!--\n");
out.write("To change this license header, choose License Headers in Project Properties.\n");
out.write("To change this template file, choose Tools | Templates\n");
out.write("and open the template in the editor.\n");
out.write("-->\n");
out.write("<html id=\"content\" >\n");
out.write(" ");
if ((session.getAttribute("useridariprasetiyo") == null)
|| (session.getAttribute("useridariprasetiyo") == "")) {
out.write("\n");
out.write(" <head>\n");
out.write(" <title>Login</title>\n");
out.write(" <meta charset=\"UTF-8\">\n");
out.write(
" <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n");
out.write(" <link href=\"admin/css/bootstrap.css\" rel=\"stylesheet\"> \n");
out.write(" <link href=\"admin/css/main.css\" rel=\"stylesheet\">\n");
out.write(" <!--\n");
out.write(
" <link href=\"http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css\" rel=\"stylesheet\" type=\"text/css\" />\n");
out.write(" --\n");
out.write(
" <link href=\"admin/css/jquery-ui.css\" rel=\"stylesheet\" type=\"text/css\">\n");
out.write(" -->\n");
out.write(" </head>\n");
out.write(" <body >\n");
out.write(" <div id=\"login-overlay\" 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\"><span aria-hidden=\"true\">×</span><span class=\"sr-only\">Close</span></button>\n");
out.write(
" <h4 class=\"modal-title\" id=\"myModalLabel\">Login to admin</h4>\n");
out.write(" </div>\n");
out.write(" <div class=\"modal-body\">\n");
out.write(" <div class=\"well\">\n");
out.write(" <form id=\"loginForm\" novalidate=\"novalidate\">\n");
out.write(" <div class=\"form-group\">\n");
out.write(
" <label for=\"username\" class=\"control-label\">Username</label>\n");
out.write(
" <input type=\"text\" class=\"form-control\" id=\"username\" name=\"username\" value=\"\" required=\"\" placeholder=\"[email protected]\">\n");
out.write(" <span class=\"help-block\"></span>\n");
out.write(" </div>\n");
out.write(" <div class=\"form-group\">\n");
out.write(
" <label for=\"password\" class=\"control-label\">Password</label>\n");
out.write(
" <input name=\"password\" id=\"password\" class=\"form-control\" type=\"password\" placeholder=\"password\" />\n");
out.write(
" <input id=\"methods\" type=\"checkbox\" class=\"form-inline\" disabled/> <label class=\"form-inline\"> Show password</label>\n");
out.write(" <span class=\"help-block\"></span>\n");
out.write(" </div>\n");
out.write(" <div id=\"ajaxResponse\"></div>\n");
out.write(" <!--\n");
out.write(
" <div id=\"loginErrorMsg\" class=\"alert alert-error hide\">Wrong username og password</div>\n");
out.write(" <div class=\"checkbox\">\n");
out.write(" <label>\n");
out.write(
" <input type=\"checkbox\" name=\"remember\" id=\"remember\"> Remember login\n");
out.write(" </label>\n");
out.write(
" <p class=\"help-block\">(if this is a private computer)</p>\n");
out.write(" </div>\n");
out.write(" -->\n");
out.write(
" <button type=\"submit\" class=\"btn btn-success btn-block\" id=\"buttonLogin\">Login</button>\n");
out.write(
" <!-- <a href=\"/forgot/\" class=\"btn btn-default btn-block\">Help to login</a> --> \n");
out.write(" </form>\n");
out.write(" </div>\n");
out.write(" </div>\n");
out.write(" </div>\n");
out.write(" </div>\n");
out.write("<script src=\"admin/js/jquery.min.js\"></script>\n");
out.write("<script src=\"admin/js/jquery.validate.min.js\"></script>\n");
out.write("<script src=\"admin/js/bootstrap.min.js\"></script>\n");
out.write("<!--\n");
out.write(
"<script src=\"http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/jquery-ui.min.js\" type=\"text/javascript\"></script>\n");
out.write("-->\n");
out.write("<script src=\"admin/js/jquery-ui.min.js\"></script> \n");
out.write("<script src=\"admin/js/password.js\"></script> \n");
out.write("<!-- <script src=\"../BOOTSTRAP/js/ValidationFormScript.js\"></script> -->\n");
out.write("<script src=\"admin/ajax/seteru.js\"></script>\n");
out.write("<script>\n");
out.write("$(function() {\n");
out.write(" $('#password').password().on('show.bs.password', function(e) {\n");
out.write(" $('#methods').prop('checked', true);\n");
out.write(" }).on('hide.bs.password', function(e) {\n");
out.write(" $('#methods').prop('checked', false);\n");
out.write(" });\n");
out.write(" $('#methods').click(function() {\n");
out.write(" });\n");
out.write("});\n");
out.write("$(document).ready(function() {\n");
out.write(" $(\"#methods\").click(function() {\n");
out.write(
" // this function will get executed every time the #home element is clicked (or tab-spacebar changed)\n");
out.write(
" if($(this).is(\":checked\")) // \"this\" refers to the element that fired the event\n");
out.write(" {\n");
out.write(" field.attr('type', 'text');\n");
out.write(" }\n");
out.write(" else{\n");
out.write(" field.attr('type', 'password');\n");
out.write(" }\n");
out.write(" });\n");
out.write("});\n");
out.write("</script>\n");
out.write(" </body> \n");
out.write(" ");
} else {
response.sendRedirect("admin/ari.ari");
}
out.write("\n");
out.write("</html>\n");
} catch (Throwable t) {
if (!(t instanceof 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);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}