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 void doInitBody() throws JspException { try { setAttribute(); } catch (Exception e) { e.printStackTrace(); } }
static { try { } catch (Exception e) { e.printStackTrace(); throw new RuntimeException(e); } }
public int doStartTag() throws JspException { try { ncrMgr = (NcrMgr) pageContext.getSession().getAttribute("ncrMgr"); List attributeCodeList = null; if (listType.equals("dmgType")) { attributeCodeList = (List) ncrMgr.getCurrentNcrMeta().getDmgTypeList(); currentAttributeCode = (SelectionOption) ncrMgr.getCurrentNcr().getDmgType(); } else if (listType.equals("solType")) { attributeCodeList = (List) ncrMgr.getCurrentNcrMeta().getSolTypeList(); currentAttributeCode = (SelectionOption) ncrMgr.getCurrentNcr().getSolType(); } else if (listType.equals("ncrType")) { attributeCodeList = (List) ncrMgr.getCurrentNcrMeta().getNcrTypeList(); currentAttributeCode = (SelectionOption) ncrMgr.getCurrentNcr().getNcrType(); } if (attributeCodeList == null || attributeCodeList.size() == 0) { return Tag.SKIP_BODY; } iterator = attributeCodeList.iterator(); } catch (Exception e) { e.printStackTrace(); } return IterationTag.EVAL_BODY_AGAIN; }
/** Holds value of propertys navigatorName. */ public int doStartTag() throws JspException { try { BomMgr bomMgr = (BomMgr) pageContext.getSession().getAttribute("bomMgr"); MfgProcess mfgProcess = bomMgr.getCurrentMfgProcess(); if (mfgProcess == null) { return Tag.SKIP_BODY; } pageContext.setAttribute( "processId", mfgProcess.getProcessId() == null ? "" : mfgProcess.getProcessId()); pageContext.setAttribute("processCode", mfgProcess.getProcessCode()); pageContext.setAttribute("processName", mfgProcess.getProcessName()); pageContext.setAttribute("description", mfgProcess.getDescription()); pageContext.setAttribute( "processCodeError", mfgProcess.isValid("processCode") ? "" : mfgProcess.getMessage("processCode")); pageContext.setAttribute( "processNameError", mfgProcess.isValid("processName") ? "" : mfgProcess.getMessage("processName")); pageContext.setAttribute("error", mfgProcess.hasMessage() ? mfgProcess.getMessage() : ""); pageContext.setAttribute("isSaved", mfgProcess.isSaved() ? "Y" : "N"); } catch (Exception e) { e.printStackTrace(); } return EVAL_BODY_INCLUDE; }
public int doStartTag() throws JspException { try { comQuotationMgr = (ComQuotationMgr) pageContext.getSession().getAttribute("comQuotationMgr"); iterator = comQuotationMgr.getCurrentQuotation().getCustomer().getContactList().iterator(); if (!iterator.hasNext()) { return Tag.SKIP_BODY; } } catch (Exception e) { e.printStackTrace(); } return IterationTag.EVAL_BODY_AGAIN; }
public int doStartTag() throws JspException { try { List headChargeList = ((ProcessHandleTag) getParent()).getCurrentProcessHandleFor().getHeadChargeList(); iterator = headChargeList.iterator(); if (headChargeList.size() == 0) { return SKIP_BODY; } } catch (Exception e) { e.printStackTrace(); } return IterationTag.EVAL_BODY_AGAIN; }
public int doStartTag() throws JspException { try { mttMgr = (MttMgr) pageContext.getSession().getAttribute("mttMgr"); iterator = mttMgr .getCurrentmaterialTransactionTypeMeta() .getMaterialTransactionTypeList() .iterator(); if (mttMgr.getCurrentmaterialTransactionTypeMeta().getMaterialTransactionTypeList().size() == 0) { return SKIP_BODY; } } catch (Exception e) { e.printStackTrace(); } return IterationTag.EVAL_BODY_AGAIN; }
public int doAfterBody() throws JspException { if (iterator.hasNext()) { try { setAttribute(); } catch (Exception e) { e.printStackTrace(); } return IterationTag.EVAL_BODY_AGAIN; } else { try { bodyContent.writeOut(bodyContent.getEnclosingWriter()); return SKIP_BODY; } catch (IOException ioe) { throw new JspTagException(ioe.getMessage()); } } }
private void setAttribute() { try { contact = (Contact) iterator.next(); pageContext.setAttribute( "contactId", contact.getContactId() == null ? "" : contact.getContactId()); pageContext.setAttribute( "contactName", contact.getContactPersonName() == null ? "" : contact.getContactPersonName()); pageContext.setAttribute("phone", contact.getPhone() == null ? "" : contact.getPhone()); pageContext.setAttribute("email", contact.getEmail() == null ? "" : contact.getEmail()); } catch (Exception e) { e.printStackTrace(); } }
public int doStartTag() throws JspException { try { purchaseRequisitionMgr = (PurchaseRequisitionMgr) pageContext.getSession().getAttribute("purchaseRequisitionMgr"); iterator = purchaseRequisitionMgr.getCurrentPurchaseRequest().getPrDetailList().iterator(); if (purchaseRequisitionMgr.getCurrentPurchaseRequest().getPrDetailList().size() == 0) { return Tag.SKIP_BODY; } if (!iterator.hasNext()) { return Tag.SKIP_BODY; } } catch (Exception e) { e.printStackTrace(); } return IterationTag.EVAL_BODY_AGAIN; }
private PollerConfiguration getPollerConfiguration() { PollerConfiguration pollconfig = null; try { PollerConfigFactory.init(); PollerConfigFactory.reload(); pollconfig = PollerConfigFactory.getInstance().getConfiguration(); } catch (MarshalException me) { me.printStackTrace(); } catch (ValidationException ve) { ve.printStackTrace(); } catch (IOException ioe) { ioe.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } return pollconfig; }
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 int doStartTag() throws JspException { try { gosMemberMgr = (GosMemberMgr) pageContext.getSession().getAttribute("gosMemberMgr"); if (gosMemberMgr.getMemberCardTypeMeta().getMemberCardTypeList().size() > 0) { iterator = gosMemberMgr.getMemberCardTypeMeta().getMemberCardTypeList().iterator(); } else { return Tag.SKIP_BODY; } if (!iterator.hasNext()) { return Tag.SKIP_BODY; } } catch (Exception e) { e.printStackTrace(); } return IterationTag.EVAL_BODY_AGAIN; }
private void setPollerConfiguration(PollerConfiguration pollconfig) { try { pollconfig.validate(); BufferedWriter bw = new BufferedWriter( new FileWriter( WTProperties.getValue("SNMPConfig.directory") + "poller-configuration.xml")); pollconfig.marshal(bw); bw.flush(); bw.close(); } catch (MarshalException me) { me.printStackTrace(); } catch (ValidationException ve) { ve.printStackTrace(); } catch (IOException ioe) { ioe.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } }
private void setAttribute() { try { this.materialTransactionType = (MaterialTransactionType) iterator.next(); pageContext.setAttribute( "materialId", materialTransactionType.getAttributeId() == null ? "" : materialTransactionType.getAttributeId()); pageContext.setAttribute("materialCode", materialTransactionType.getAttributeCode()); pageContext.setAttribute("materialName", materialTransactionType.getAttributeName()); pageContext.setAttribute("materialDescription", materialTransactionType.getDescription()); pageContext.setAttribute( "materialApprovedFlag", materialTransactionType.getApprovedFlag() == null ? "" : this.materialTransactionType.getApprovedFlag()); pageContext.setAttribute( "isReturn", materialTransactionType.getType() == null ? "" : materialTransactionType.getType().equals("2") ? "Retrun" : ""); pageContext.setAttribute( "isIssue", materialTransactionType.getType() == null ? "" : materialTransactionType.getType().equals("1") ? "Issue" : ""); pageContext.setAttribute( "isTransfer", materialTransactionType.getType() == null ? "" : materialTransactionType.getType().equals("3") ? "Transfer" : ""); pageContext.setAttribute( "isConsume", materialTransactionType.getType() == null ? "" : materialTransactionType.getType().equals("4") ? "Consume" : ""); } catch (Exception e) { e.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(); } }
private void setAttribute() { try { memberCardType = (MemberCardType) iterator.next(); pageContext.setAttribute( "memberCardTypeId", memberCardType.getMemberCardTypeId() == null ? "" : memberCardType.getMemberCardTypeId()); pageContext.setAttribute("memberCardTypeCode", memberCardType.getMemberCardTypeCode()); pageContext.setAttribute("memberCardTypeName", memberCardType.getMemberCardTypeName()); pageContext.setAttribute("isSaved", memberCardType.isSaved() ? "Y" : "N"); pageContext.setAttribute("note", memberCardType.getNote()); // pageContext.setAttribute("memberCardTypeCodeError", // memberCardType.isValid("memberCardTypeCode") ? "" : // memberCardType.getMessage("memberCardTypeCode")); // pageContext.setAttribute("memberCardTypeNameError", // memberCardType.isValid("selectionName") ? "" : memberCardType.getMessage("selectionName")); // pageContext.setAttribute("noteError", memberCardType.isValid("note") ? "" : // memberCardType.getMessage("note")); } catch (Exception e) { e.printStackTrace(); } }
public int doStartTag() throws JspException { try { purchaseRequisitionMgr = (PurchaseRequisitionMgr) pageContext.getSession().getAttribute("purchaseRequisitionMgr"); PurchaseRequest purchaseRequest = purchaseRequisitionMgr.getCurrentPurchaseRequest(); pageContext.setAttribute( "prId", purchaseRequest.getPrId() == null ? "" : purchaseRequest.getPrId()); pageContext.setAttribute( "creationDate", purchaseRequest.getCreationDate() == null ? "" : purchaseRequest.getCreationDate()); pageContext.setAttribute( "createdBy", purchaseRequest.getCreatedBy() == null ? "" : purchaseRequest.getCreatedBy()); pageContext.setAttribute("isSaved", purchaseRequest.isIsSaved() ? "Y" : "N"); pageContext.setAttribute("isSend", purchaseRequest.isIsSend() ? "Y" : "N"); pageContext.setAttribute("isClamant", purchaseRequest.isIsClamant() ? "Y" : "N"); pageContext.setAttribute("statusString", purchaseRequest.getStatusString()); pageContext.setAttribute( "prStatus", purchaseRequest.getPrStatus() == null ? "" : purchaseRequest.getPrStatus()); pageContext.setAttribute("modifiedReason", purchaseRequest.getModifiedReason()); pageContext.setAttribute( "modifiedReasonError", purchaseRequest.isValid("modifiedReason") ? "" : purchaseRequest.getMessage("modifiedReason")); pageContext.setAttribute( "prError", purchaseRequest.hasMessage() ? purchaseRequest.getMessage() : ""); } catch (Exception e) { e.printStackTrace(); } return Tag.EVAL_BODY_INCLUDE; }
public int doStartTag() throws JspException { try { PurReportMgr purReportMgr = (PurReportMgr) pageContext.getSession().getAttribute("purReportMgr"); ireportPurchaseOrder = purReportMgr.getCurrentIreport().getIreportPurchaseOrder(); pageContext.setAttribute( "poNo", ireportPurchaseOrder.getPoNo() == null ? "" : ireportPurchaseOrder.getPoNo()); pageContext.setAttribute( "poRefNo", ireportPurchaseOrder.getPoRefNo() == null ? "" : ireportPurchaseOrder.getPoRefNo()); pageContext.setAttribute( "creationDate", ireportPurchaseOrder.getCreationDate() == null ? "" : ireportPurchaseOrder.getCreationDate()); pageContext.setAttribute( "createdBy", ireportPurchaseOrder.getCreatedBy() == null ? "" : ireportPurchaseOrder.getCreatedBy()); } catch (Exception e) { e.printStackTrace(); } return Tag.EVAL_BODY_INCLUDE; }
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 { 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 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; 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'); out.write('\n'); try { out.write("\r\n\r\n "); String wgID = request.getParameter("wgID"); final WorkgroupManager workgroupManager = WorkgroupManager.getInstance(); Workgroup workgroup = workgroupManager.getWorkgroup(new JID(wgID)); OfflineSettingsManager offlineManager = new OfflineSettingsManager(); String redirectValue = request.getParameter("redirectToPage"); String statusMessage = ""; OfflineSettings offlineSettings = null; boolean emailConfigured = false; String property = JiveGlobals.getProperty("mail.configured"); if (ModelUtil.hasLength(property)) { emailConfigured = true; } boolean delete = request.getParameter("delete") != null; boolean save = request.getParameter("save") != null && !delete; if (save) { String emailAddress = request.getParameter("email"); String subject = request.getParameter("subject"); String header = request.getParameter("headerField"); offlineSettings = offlineManager.saveOfflineSettings( workgroup, redirectValue, emailAddress, subject, header); if (offlineSettings != null) { statusMessage = "Offline settings have been saved."; } } else if (delete) { statusMessage = "Offline settings have been deleted."; offlineSettings = offlineManager.saveOfflineSettings(workgroup, redirectValue, "", "", ""); } else { try { offlineSettings = offlineManager.getOfflineSettings(workgroup); } catch (OfflineSettingsNotFound offlineSettingsNotFound) { offlineSettings = new OfflineSettings(); } } out.write("\r\n<html>\r\n <head>\r\n <title>"); out.print("Offline Settings for " + wgID); out.write( "</title>\r\n <meta name=\"subPageID\" content=\"workgroup-offline\"/>\r\n <meta name=\"extraParams\" content=\""); out.print("wgID=" + wgID); out.write( "\"/>\r\n <!--<meta name=\"helpPage\" content=\"set_an_offline_policy_for_a_workgroup.html\"/>-->\r\n\r\n <script>\r\n function saveOfflineSettings(){\r\n var todo = document.offline.todo;\r\n if(todo[0].checked){\r\n var url = document.offline.redirectToPage.value;\r\n if(!Jtrim(url)){\r\n alert(\"Please specify the URL to forward to.\");\r\n document.offline.redirectToPage.focus();\r\n return;\r\n }\r\n document.offline.email.value = \"\";\r\n document.offline.subject.value = \"\";\r\n document.offline.headerField.value = \"\";\r\n\r\n document.offline.submit();\r\n }\r\n else if(todo[1].checked){\r\n var email = document.offline.email.value;\r\n var subject = document.offline.subject.value;\r\n var message = document.offline.headerField.value;\r\n document.offline.redirectToPage.value = '';\r\n"); out.write( "\r\n if(!Jtrim(email) || !Jtrim(subject) || !Jtrim(message)){\r\n alert(\"All fields are required.\");\r\n return;\r\n }\r\n document.offline.submit();\r\n }\r\n }\r\n\r\n\r\n\r\n function Jtrim(st) {\r\n var len = st.length;\r\n var begin = 0, end = len - 1;\r\n while (st.charAt(begin) == \" \" && begin < len) {\r\n begin++;\r\n }\r\n while (st.charAt(end) == \" \" && end > begin) {\r\n end--;\r\n }\r\n return st.substring(begin, end + 1);\r\n }\r\n </script>\r\n </head>\r\n <body>\r\n Specify action to take when this workgroup has no available agents to take incoming chat requests.\r\n "); if (statusMessage != null && !statusMessage.equals("")) { out.write("\r\n <div class=\"success\">\r\n "); out.print(statusMessage); out.write("\r\n </div>\r\n "); } out.write("\r\n\r\n "); if (!emailConfigured) { out.write( "\r\n <div class=\"error\">\r\n Email form will not be displayed until you configure your <a href=\"../../system-email.jsp\">email settings</a>.\r\n </div>\r\n "); } out.write("\r\n\r\n <div id=\"offline_message\">"); out.print(statusMessage); out.write( "</div>\r\n <p/>\r\n <form action=\"workgroup-offline.jsp\" method=\"get\" name=\"offline\">\r\n <input type=\"hidden\" name=\"wgID\" value=\""); out.print(wgID); out.write( "\" />\r\n <div>\r\n <div class=\"jive-contentBoxHeader\">\r\n Offline Workgroup Action\r\n </div>\r\n <table width=\"100%\" cellpadding=\"3\" cellspacing=\"0\" border=\"0\" class=\"jive-contentBox\">\r\n <tr valign=\"top\">\r\n "); String checked = offlineSettings.redirects() ? "checked" : ""; out.write( "\r\n <td width=\"1%\">\r\n <input type=\"radio\" name=\"todo\" value=\"redirectToPage\" "); out.print(checked); out.write( " />\r\n </td>\r\n <td nowrap><b>Redirect To Web Page</b>\r\n </td>\r\n <td class=\"c2\">\r\n <input type=\"text\" name=\"redirectToPage\" size=\"40\" value=\""); out.print(offlineSettings.getRedirectURL()); out.write( "\" /><br/>\r\n <span class=\"jive-description\">e.g. http://www.jivesoftware.com/contact.html</span>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap width=\"1%\">\r\n <input type=\"radio\" name=\"todo\" value=\"showEmailPage\" "); out.print(!offlineSettings.redirects() ? "checked" : ""); out.write( "/>\r\n <td><b>Display Email Form</b></td>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <!-- Email Address -->\r\n <tr valign=\"top\">\r\n <td> </td>\r\n <td>Email Address:</td>\r\n <td>\r\n <input type=\"text\" size=\"40\" name=\"email\" value=\""); out.print(offlineSettings.getEmailAddress()); out.write( "\" /><br/>\r\n <span class=\"jive-description\">Email address to send all offline messages to.</span>\r\n </td>\r\n </tr>\r\n <!-- End of Email Address -->\r\n <!-- Subject Line -->\r\n <tr valign=\"top\">\r\n <td> </td>\r\n <td>Subject:</td>\r\n <td>\r\n <input type=\"text\" size=\"40\" name=\"subject\" value=\""); out.print(offlineSettings.getSubject()); out.write( "\"/><br/>\r\n <span class=\"jive-description\">The subject of all offline email messages.</span>\r\n </td>\r\n </tr>\r\n <!-- End Of Subject Line -->\r\n <tr valign=\"top\">\r\n <td> </td>\r\n <td>Offline Text:</td>\r\n <td>\r\n <textarea name=\"headerField\" cols=\"40\" rows=\"5\">"); out.print(offlineSettings.getOfflineText()); out.write( "</textarea><br/>\r\n <span class=\"jive-description\">Text to display to the user in the email form.</span>\r\n </td>\r\n </tr>\r\n <input type=\"hidden\" name=\"save\" value=\"save\">\r\n <tr>\r\n </tr>\r\n "); out.write( "\r\n </table>\r\n <table><tr>\r\n <td colspan=\"1\"> <input type=\"button\" name=\"save\" value=\"Save Changes\" onclick=\"return saveOfflineSettings();\" /></td>\r\n <td colspan=\"1\"> <input type=\"submit\" name=\"delete\" value=\"Delete Changes\" /></td>\r\n </tr></table>\r\n </div>\r\n </form>\r\n\r\n</body>\r\n</html>\r\n\r\n"); } catch (Exception ex) { ex.printStackTrace(); } } 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( final javax.servlet.http.HttpServletRequest request, final javax.servlet.http.HttpServletResponse response) throws java.io.IOException, javax.servlet.ServletException { final javax.servlet.jsp.PageContext pageContext; javax.servlet.http.HttpSession session = null; final javax.servlet.ServletContext application; final javax.servlet.ServletConfig config; javax.servlet.jsp.JspWriter out = null; final java.lang.Object page = this; javax.servlet.jsp.JspWriter _jspx_out = null; javax.servlet.jsp.PageContext _jspx_page_context = null; try { response.setContentType("text/html"); pageContext = _jspxFactory.getPageContext(this, request, response, 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("\n"); org.apache.jasper.runtime.JspRuntimeLibrary.include( request, response, "sessionBoth.jsp" + (("sessionBoth.jsp").indexOf('?') > 0 ? '&' : '?') + org.apache.jasper.runtime.JspRuntimeLibrary.URLEncode( "formName", request.getCharacterEncoding()) + "=" + org.apache.jasper.runtime.JspRuntimeLibrary.URLEncode( "editItemDetails.jsp", request.getCharacterEncoding()), out, false); out.write(" \n"); out.write("\n"); out.write("\n"); int site_id = 0; DecimalFormat df = new DecimalFormat("###,###.00"); try { site_id = (Integer) session.getAttribute("GlobalSiteId"); System.out.print("In : " + site_id); } catch (Exception e) { e.printStackTrace(); } String i_code = ""; String ig_code = ""; String i_name = ""; String i_mrp = ""; String i_mrp2 = ""; String i_rate = ""; String i_rate2 = ""; String flag = ""; String paramList = ""; String changeParamList = ""; String i_tickflag = ""; String ibarcode = request.getParameter("ibarcode"); i_code = request.getParameter("icodeStartWith"); ig_code = request.getParameter("igcodeStartWith"); i_name = request.getParameter("inameStartWith"); i_mrp = request.getParameter("imrpStartWith"); i_rate = request.getParameter("irateStartWith"); i_mrp2 = request.getParameter("imrp2StartWith"); i_rate2 = request.getParameter("irate2StartWith"); flag = request.getParameter("flag"); i_tickflag = request.getParameter("i_tickflg"); item.ManageItem mi; mi = new item.ManageItem("jdbc/js"); mi.listItem( i_code, ig_code, i_name, i_mrp, i_mrp2, i_rate, i_rate2, i_tickflag, ibarcode, site_id); out.write("\n"); out.write(" <style>\n"); out.write(" #id #tr:hover td{\n"); out.write(" \t\tbackground-color: white;\n"); out.write(" \t\tcursor: pointer;\n"); out.write(" }\n"); out.write(" #id td{\n"); out.write(" \t\tpadding: 3px 0px 3px 5px;\n"); out.write(" }\n"); out.write(" </style>\n"); out.write( " <table border=\"1\" name=\"t\" id=\"id\" class=\"item3\" cellspacing = 0 cellpadding = 0 style=\"border-collapse: collapse; width: 96%;background-color: #ECFB99;\" bordercolor=black>\n"); out.write(" \n"); out.write(" \t <thead>\n"); out.write(" \t\t \t<tr align=\"left\">\n"); out.write("\t\t\t\t<td><b>Item Code</b></td>\n"); out.write("\t\t\t\t<td><b>Change Quantity</b></td>\n"); out.write("\t\t\t\t<td><b>Item Group</b></td>\n"); out.write("\t\t\t\t<td><b>Item Name</b></td>\n"); out.write("\t\t\t\t<td><b>Item Barcode</b></td>\n"); out.write("\t\t\t\t<td><b>Item Weight</b></td>\n"); out.write("\t\t\t\t<td><b>Item MRP</b></td>\n"); out.write("\t\t\t\t<td><b>Item Rate</b></td>\n"); out.write("\t\t\t\t<td><b>Deal Flag</b></td>\n"); out.write("\t\t\t\t<td><b>Ticker Flag</b></td>\n"); out.write("\t\t\t\t<td><b>Is bachka</b></td>\n"); out.write("\t\t\t\t<td><b>Mix Item</b></td>\n"); out.write("\t\t\t\t<td><b>Item History</b></td>\n"); out.write("\t\t\t</tr>\n"); out.write(" \t</thead>\t\n"); out.write("\t\t<tbody>\n"); while (mi.rs.next()) { if (flag.equals("1")) { paramList = "EditItemForm.jsp?icode=" + mi.rs.getString(1) + "&igcode=" + mi.rs.getString(7) + "&iname=" + mi.rs.getString(3) + "&iweight=" + mi.rs.getString(4) + "&imrp=" + mi.rs.getString(5) + "&irate=" + mi.rs.getString(6) + "&id_type=" + mi.rs.getString(10) + "&id_flag=" + mi.rs.getString(9) + "&id_qty=" + mi.rs.getString(11) + "&id_amt=" + mi.rs.getString(12) + "&i_comm=" + mi.rs.getString(13) + "&i_tickflag=" + mi.rs.getString(14) + "&ibarcode=" + mi.rs.getString(15) + "&box_qty=" + mi.rs.getInt(16) + "&is_bachka=" + mi.rs.getString("is_bachka") + "&is_mixture=" + mi.rs.getString("mix_item") + "&groupCodeValue=" + mi.rs.getString("item_group_code"); } else { paramList = "ItemDetails.jsp?icode=" + mi.rs.getString(1) + "&igcode=" + mi.rs.getString(7) + "&iname=" + mi.rs.getString(3) + "&iweight=" + mi.rs.getString(4) + "&imrp=" + mi.rs.getString(5); } changeParamList = "ChangeQuantityItemForm.jsp?icode=" + mi.rs.getString(1) + "&igcode=" + mi.rs.getString(7) + "&iname=" + mi.rs.getString(3) + "&iweight=" + mi.rs.getString(4) + "&imrp=" + mi.rs.getString(5) + "&irate=" + mi.rs.getString(6) + "&id_type=" + mi.rs.getString(10) + "&id_flag=" + mi.rs.getString(9) + "&id_qty=" + mi.rs.getString(11) + "&id_amt=" + mi.rs.getString(12) + "&i_comm=" + mi.rs.getString(13) + "&i_tickflag=" + mi.rs.getString(14) + "&ibarcode=" + mi.rs.getString(15); out.write("\n"); out.write("\t\t\t <tr id=\"tr\" align=\"left\">\t\t\n"); out.write("\t\t\t\t<td align=\"left\"><a href=\""); out.print(paramList); out.write('"'); out.write('>'); out.print(mi.rs.getString(1)); out.write("</a></td>\n"); out.write(" \t \t\t<td><a href=\""); out.print(changeParamList); out.write("\">Change Quantity</a></td>\n"); out.write(" \t \t\t<td>"); out.print(mi.rs.getString(7)); out.write("</td>\n"); out.write(" \t \t\t<td>"); out.print(mi.rs.getString(3)); out.write("</td>\n"); out.write(" \t \t\t<td>"); out.print(mi.rs.getString(15)); out.write("</td>\n"); out.write(" \t \t\t<td>"); out.print(mi.rs.getString(4)); out.write("</td>\n"); out.write(" \t \t\t<td>"); out.print(df.format(mi.rs.getFloat(5))); out.write("</td>\n"); out.write(" \t \t\t<td>"); out.print(df.format(mi.rs.getFloat(6))); out.write("</td>\n"); out.write(" \t \t\t"); out.write("\n"); out.write(" \t \t\t<td>\n"); String msg1 = mi.rs.getString(9); if (msg1.equals("N")) { out.println("No"); } else { out.println("Yes"); } out.write(" \n"); out.write(" \t\t</td><td>\n"); String msg2 = mi.rs.getString(14); if (msg2.equals("N")) { out.println("No"); } else { out.println("Yes"); } out.write(" \n"); out.write(" \t</td>\n"); out.write(" \t<td>"); out.print(mi.rs.getString("is_bachka")); out.write("</td>\n"); out.write(" \t<td>"); out.print(mi.rs.getString("mix_item")); out.write("</td><td> \n"); String msg = mi.rs.getString(8); if (!msg.equals("NH")) { out.write(" \n"); out.write(" \t <a href=\"ItemHistoryForm.jsp?icode="); out.print(mi.rs.getString(1)); out.write("\">history\n"); } out.write("\t\t\t\n"); out.write("\t\t\t\t\n"); out.write(" \t \n"); out.write("\t\t\t </td></tr>\n"); out.write("\t\t\t\n"); } mi.closeAll(); out.write("\n"); out.write("\t\t\t <style type=\"text/css\">\n"); out.write("\t\t\t a:link {color: blue}\n"); out.write("\t\t\t a:hover {background: blue;color: white}\n"); out.write("\t\t\t a:active {background: blue;color: white}\n"); out.write("\t\t\t </style>\n"); out.write("\n"); out.write("\t</tbody>\n"); out.write("</table>\n"); out.write("\t\t\t\n"); out.write(" \t"); } catch (java.lang.Throwable t) { if (!(t instanceof javax.servlet.jsp.SkipPageException)) { out = _jspx_out; if (out != null && out.getBufferSize() != 0) try { out.clearBuffer(); } catch (java.io.IOException e) { } if (_jspx_page_context != null) _jspx_page_context.handlePageException(t); else throw new ServletException(t); } } finally { _jspxFactory.releasePageContext(_jspx_page_context); } }
public void _jspService( final javax.servlet.http.HttpServletRequest request, final javax.servlet.http.HttpServletResponse response) throws java.io.IOException, javax.servlet.ServletException { final javax.servlet.jsp.PageContext pageContext; javax.servlet.http.HttpSession session = null; final javax.servlet.ServletContext application; final javax.servlet.ServletConfig config; javax.servlet.jsp.JspWriter out = null; final java.lang.Object page = this; javax.servlet.jsp.JspWriter _jspx_out = null; javax.servlet.jsp.PageContext _jspx_page_context = null; try { response.setContentType("text/html"); pageContext = _jspxFactory.getPageContext( this, request, response, "ReportErrorPage.jsp?page=EditTargetReportForm.jsp", true, 8192, true); _jspx_page_context = pageContext; application = pageContext.getServletContext(); config = pageContext.getServletConfig(); session = pageContext.getSession(); out = pageContext.getOut(); _jspx_out = out; out.write("\n"); out.write("\n"); out.write("\n"); out.write("\n"); out.write("\n"); org.apache.jasper.runtime.JspRuntimeLibrary.include( request, response, "header.jsp", out, false); out.write(' '); out.write('\n'); out.write("\n"); out.write("\n"); out.write("\n"); out.write("\t<!-- files for JqxWidget grid -->\n"); out.write( " <link rel=\"stylesheet\" href=\"js/jqwidgets/styles/jqx.base.css\" type=\"text/css\" />\n"); out.write( " <link rel=\"stylesheet\" href=\"js/jqwidgets/styles/jqx.darkblue.css\" type=\"text/css\" />\n"); out.write( "\t<link rel=\"stylesheet\" href=\"js/jqwidgets/styles/jqx.ui-redmond.css\" type=\"text/css\" />\n"); out.write("\t\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/gettheme.js\"></script>\n"); out.write("\t<script type=\"text/javascript\" src=\"js/jquery-1.10.2.min.js\"></script>\n"); out.write(" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxcore.js\"></script>\n"); out.write(" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxdata.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxbuttons.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxscrollbar.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxlistbox.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxcalendar.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxdatetimeinput.js\"></script>\n"); out.write(" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.filter.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.selection.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.sort.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.pager.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxmenu.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxlistbox.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxdropdownlist.js\"></script>\n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxdata.export.js\"></script> \n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.export.js\"></script> \n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.aggregates.js\"></script> \n"); out.write( " <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.grouping.js\"></script> \n"); out.write("\n"); out.write("\n"); out.write("\t\n"); out.write("\t"); session.getAttribute("UserName").toString(); // System.out.println("session bachka maapping : "+session +" \n user // "+session.getAttribute("UserName").toString()); out.write("\n"); out.write("\n"); out.write("\n"); out.write("<script src=\"js/editCustomer_details.js\"> </script> \n"); out.write("\n"); out.write("<script type=\"text/javascript\" src=\"js/popup.js\"></script>\n"); out.write("<style>\n"); out.write("hr {\n"); out.write("color: #f00;\n"); out.write("background-color: #f00;\n"); out.write("height: 3px;\n"); out.write("}\n"); out.write("#selected_order{\n"); out.write("width: 40%;\n"); out.write("max-height: 300px;\n"); out.write("border: 1px solid black; \n"); out.write("background-color: #ECFB99;\n"); out.write("float: right;\n"); out.write("margin-top: 30px;\n"); out.write("overflow: auto;\n"); out.write("margin-right: 2%;\n"); out.write("padding: 5px;\n"); out.write("}\n"); out.write("</style>\n"); out.write("<script>\n"); out.write("\t\n"); out.write("\tfunction checkField(){\n"); out.write("\t\tif(document.myform.chckall.checked==true){\n"); out.write("\t\t\tshowHint();\n"); out.write("\t\t}\n"); out.write("\t\telse{\t\tvar c_date1,c_date2,u_date2,u_date1;\n"); out.write("\t\t\t\tif(!($(\"#createDate2\").jqxDateTimeInput('disabled'))){\n"); out.write("\t\t\t\tc_date1 = $('#createDate1').jqxDateTimeInput('getText');\n"); out.write("\t\t\t\tc_date2 = $('#createDate2').jqxDateTimeInput('getText');\n"); out.write("\t\t\t}\n"); out.write("\t\t\t\n"); out.write("\t\t\tif(!($(\"#updateDate2\").jqxDateTimeInput('disabled'))){\n"); out.write("\t\t\t\tu_date1 = $('#updateDate1').jqxDateTimeInput('getText');\n"); out.write("\t\t\t\tu_date2 = $('#updateDate2').jqxDateTimeInput('getText');\n"); out.write("\t\t\t}\t \n"); out.write("\t\t showHint();\t\t \n"); out.write("\t }\n"); out.write("\t}\n"); out.write("\tfunction showMsg(){\n"); out.write("\t \t document.myform.action=\"HomeForm.jsp\";\n"); out.write("\t \t document.myform.submit();\n"); out.write("\t}\n"); out.write("\tfunction Clear(){\n"); out.write("\t\t\n"); out.write("\t\ttry{\n"); out.write("\t\t\tdocument.getElementById(\"order_number\").focus();\n"); out.write("\t\t} catch (exp){}\n"); out.write("\t\t\n"); out.write("\t\t\n"); out.write("\t\t\n"); out.write("\t\tdocument.myform.custCode.value=\"\";\n"); out.write("\t\tdocument.myform.phonenumber.value=\"\";\n"); out.write("\t\tdocument.myform.custName.value=\"\";\n"); out.write("\t\tdocument.myform.nameString.value=\"\";\t\t\n"); out.write("\t\tdocument.myform.Building.value=\"\";\n"); out.write("\t\tdocument.myform.Building_no.value=\"\";\n"); out.write("\t\tdocument.myform.wing.value=\"\";\n"); out.write("\t\tdocument.myform.block.value=\"\";\n"); out.write("\t\tdocument.myform.add1.value=\"\";\n"); out.write("\t\tdocument.myform.add2.value=\"\";\n"); out.write("\t\tdocument.myform.area.value=\"\";\n"); out.write("\t\tdocument.myform.station.value=\"\";\n"); out.write("\t\t\n"); out.write("\t\tdocument.myform.selmonth.value=\"\";\n"); out.write("\t\t\n"); out.write( "\t\t$(\"#createDate1\").jqxDateTimeInput({theme:'ui-redmond',width: '250px', height: '25px',max:new Date(),formatString: \"yyyy-MM-dd\"});\n"); out.write( "\t\t$(\"#createDate2\").jqxDateTimeInput({theme:'ui-redmond',width: '250px', height: '25px',min:new Date(),max:new Date(),formatString: \"yyyy-MM-dd\",value:new Date()});\n"); out.write("\t\t$(\"#createDate2\").jqxDateTimeInput({disabled: true});\n"); out.write("\t\t\n"); out.write("\t\t\n"); out.write( "\t\t$(\"#updateDate1\").jqxDateTimeInput({theme:'ui-redmond',width: '250px', height: '25px',max:new Date(),formatString: \"yyyy-MM-dd\"});\n"); out.write( "\t\t$(\"#updateDate2\").jqxDateTimeInput({theme:'ui-redmond',width: '250px', height: '25px',min:new Date(),max:new Date(),formatString: \"yyyy-MM-dd\",value:new Date()});\n"); out.write("\t\t$(\"#updateDate2\").jqxDateTimeInput({disabled: true});\n"); out.write("\t\t\n"); out.write("\t\t$('#createDate1').on('close', function (event) {\n"); out.write("\t\t // Some code here. \n"); out.write("\t\t \t$(\"#createDate2\").jqxDateTimeInput({disabled: false});\n"); out.write( "\t\t \t$(\"#createDate2\").jqxDateTimeInput({min: $('#createDate1').jqxDateTimeInput('getDate')});\n"); out.write(" \t\t}); \t\n"); out.write(" \t\t\n"); out.write(" \t\t$('#updateDate1').on('close', function (event) {\n"); out.write("\t\t // Some code here. \n"); out.write("\t\t \t$(\"#updateDate2\").jqxDateTimeInput({disabled: false});\n"); out.write( "\t\t \t$(\"#updateDate2\").jqxDateTimeInput({min: $('#updateDate1').jqxDateTimeInput('getDate')});\n"); out.write(" \t\t}); \t\n"); out.write("\t\t\n"); out.write("\t\tfunEnabled();\n"); out.write("\t}\n"); out.write("\t\n"); out.write("function ckeckEmpty(){\n"); out.write("\tif(document.getElementById(\"order_number\").value == \"\"){\n"); out.write("\t\talert(\"Please Enter Order Number\");\n"); out.write("\t\tdocument.getElementById(\"order_number\").focus();\n"); out.write("\t\treturn false;\n"); out.write("\t} else {\n"); out.write("\t\treturn true;\n"); out.write("\t}\n"); out.write("}\n"); out.write("\n"); out.write("\n"); out.write("</script>\n"); String call_type = request.getParameter("call_type"); if (call_type == null) { call_type = ""; } if (call_type.equals("search_payment")) { String m = "<< Show List"; out.write("\n"); out.write("\t\t\t<div id=\"selected_order\">\n"); out.write("\t\t\t\t<b>Selected orders</b>\n"); out.write( "\t\t\t\t<form action=\"PrintSelectedCustPayment.jsp\" method=\"get\" id=\"submit_form\">\n"); out.write( "\t\t\t\t<table style=\"width: 100%;border-collapse: collapse;\" border=1 id=\"selected_order_table\">\n"); out.write("\t\t\t\t<tr>\n"); out.write("\t\t\t\t\t<th style=\"width: 20%;\">Order Number</th>\n"); out.write("\t\t\t\t\t<th style=\"width: 35%;\">Cust Name</th>\n"); out.write("\t\t\t\t\t<th style=\"width: 20%;\">Balance</th>\n"); out.write("\t\t\t\t\t<th style=\"width: 25%;\"> </th>\n"); out.write("\t\t\t\t</tr>\n"); out.write("\t\t\t\t</table>\n"); out.write("\t\t\t\t<table style=\"width: 100%;\" border=1 id=\"insert_table\">\n"); out.write("\t\t\t\t</table>\n"); out.write( "\t\t\t\t <input type=\"text\" readonly=\"readonly\" name=\"order_count\" id=\"order_count_id\" size=\"3\" value=\"0\" style=\"background-color :#ECFB99 ;\"/> orders selected to print.\n"); out.write( "\t\t\t\t<input type=\"submit\" onclick=\" return printSelectedInformation()\" value=\"Print\" style=\"float: right;\"/>\n"); out.write("\t\t\t\t</form>\n"); out.write("\t\t\t</div>\n"); out.write("\t\t"); } if (!call_type.equals("search_payment") || !call_type.equals("communication")) { out.write("\n"); out.write("<center>\n"); } out.write("\n"); out.write("<fieldset style=\"width: 55%;\"><legend>\n"); String msg = request.getParameter("msg"); if (call_type.equals("receive_payment")) { out.print("<h3>Search Customer To Receive Payment</h3>"); } else if (call_type.equals("search_payment")) { out.print("<h3>Search Customer To See Pending</h3>"); } else if (call_type.equals("communication")) { out.print("<h3>Search Customer To Communicate</h3>"); } else { out.print("<h3>Search Customer</h3>"); } out.write("\n"); out.write("</legend>\n"); if (call_type.equals("receive_payment")) { out.write("\n"); out.write( "\t\t<input type = \"radio\" name = \"radio\" onclick=\"ChangeCriteria('order')\" checked=\"checked\"/>Search By Order Number\n"); out.write( "\t\t<input type = \"radio\" name = \"radio\" onclick=\"ChangeCriteria('cust')\"/>Search By Customer Detail\n"); out.write("\t"); } if (call_type.equals("receive_payment")) { out.write("\n"); out.write("\t<br/><br/>\n"); out.write("<form id=\"myform1\" action=\"SearchCustUsingOrderNo.jsp\" method=\"get\">\n"); out.write("\t"); if (msg != null) { out.print("<i><font color=red>No Matching Record Found</font></i><br/><br/>"); } out.write("\n"); out.write( "\tEnter Order Number : <input type = \"text\" name = \"order_number\" value=\"\" id =\"order_number\" onkeypress=\"return isNumberKey(event)\"/>\n"); out.write( "\t<input type = \"submit\" value=\"Search\" onclick=\"return ckeckEmpty();\"/>\n"); out.write("\n"); out.write("<br/>\n"); out.write("</form>\n"); out.write("<form name=\"myform\" method=\"post\" id=\"myform\" style=\"display: none\">\n"); } else { out.write("\n"); out.write("<form name=\"myform\" method=\"post\" id=\"myform\" >\n"); } out.write("\n"); out.write("\t<table style=\"width: 100%;\">\n"); out.write("\t\t<tr style=\"width: 100%;\">\n"); out.write( "\t\t\t<td align=\"center\" colspan=3><b><font color=\"blue\"> A</font>ll Customers List       \n"); out.write( "\t\t\t<input type=\"CheckBox\" name=\"chckall\" accesskey=\"a\" onClick=\"funEnabled();\"></td>\n"); out.write("\t\t</tr>\t\t\n"); out.write("\t\t<tr style=\"width: 100%;\">\n"); out.write("\t\t\t<td colspan=3>\n"); out.write("\t\t\t<div id=\"div4\" style=\"width: 100%;\" >\n"); out.write("\t\t\t\t<table>\t\t\t\t\n"); out.write("\t\t\t\t\t<tr>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\">\n"); out.write("\t\t\t\t\t\t\t<b><font color=\"blue\">C</font>ustomer Code</b>\n"); out.write("\t\t\t\t\t\t</td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 29%;\"><input style=\"width: 97%;\" type=\"text\" name=\"custCode\" accesskey=\"c\"></td>\n"); out.write("\t\t\t\t\t\t"); if (call_type.equals("search_payment") || call_type.equals("communication")) { out.write("\n"); out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\">\n"); out.write("\t\t\t\t\t\t\t<b>O<font color=\"blue\">r</font>der Number</b>\n"); out.write("\t\t\t\t\t\t</td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 29%;\"><input style=\"width: 97%;\" type=\"text\" name=\"ordernumber\" accesskey=\"c\"></td>\n"); out.write("\t\t\t\t\t\t"); } out.write("\n"); out.write("\t\t\t\t\t</tr>\n"); out.write("\t\t\t\t\t<tr>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Customer <font color=\"blue\">N</font>ame</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 29%;\"><input style=\"width: 97%;\" type=\"text\" name=\"custName\" align=\"right\" accesskey=\"n\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">P</font>hone Number</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 29%;\"><input style=\"width: 97%;\" type=\"text\" name=\"phonenumber\" size=\"22\" align=\"right\" colspan=\"2\" accesskey=\"p\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t</tr>\n"); out.write("\t\t\t\t\t<tr>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>M<font color=\"blue\">o</font>bile Number</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td><input style=\"width: 97%;\" type=\"text\" name=\"mobilenumber\" size=\"22\" align=\"right\" colspan=\"2\" accesskey=\"o\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Na<font color=\"blue\">m</font>e String</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td><input style=\"width: 97%;\" style=\"width: 100%;\" type=\"text\" name=\"nameString\" size=\"22\" align=\"right\" accesskey=\"m\" colspan=\"2\"></td>\n"); out.write("\t\t\t\t\t</tr>\n"); out.write("\t\t\t\t\t<tr>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">B</font>uilding</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td><input style=\"width: 97%;\" type=\"text\" name=\"Building\" accesskey=\"b\" align=\"right\"></b></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Building <font color=\"blue\">N</font>o.</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td><input style=\"width: 97%;\" type=\"text\" name=\"Building_no\" size=\"22\" accesskey=\"o\"></b></td>\n"); out.write("\t\t\t\t\t</tr>\n"); out.write("\t\t\t\t\t<tr>\n"); out.write( "\t\t\t\t\t <td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">W</font>ing</b></td>\n"); out.write("\t\t\t\t\t <td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t <td><input style=\"width: 97%;\" type =\"text\" name=\"wing\" accesskey=\"w\" ></td>\n"); out.write("\t\t\t\t\t \n"); out.write("\t\t\t\t\t <td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\t\t \n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">F</font>lat No.</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td><input style=\"width: 97%;\" type =\"text\" name=\"block\" size=\"22\" accesskey=\"f\" align=\"right\">\n"); out.write("\t\t\t\t\t\t</tr>\n"); out.write("\t\t\t\t\t<tr>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Addr<font color=\"blue\">e</font>ss1</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td><input style=\"width: 97%;\" type =\"text\" accesskey=\"e\" name=\"add1\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>A<font color=\"blue\">d</font>dress2</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t\t<td><input style=\"width: 97%;\" type =\"text\" accesskey=\"d\" name=\"add2\" size=\"22\"></td>\n"); out.write("\t\t\t\t\t</tr>\n"); out.write("\t\t\t\t\t<tr >\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>A<font color=\"blue\">r</font>ea</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write("\t\t\t\t\t\t<td>\n"); out.write("\t\t\t\t\t\t"); String name; try { Context initContext = new InitialContext(); Context envContext = (Context) initContext.lookup("java:/comp/env"); // DataSource ds = (DataSource)envContext.lookup("jdbc/js"); DataSource ds = (DataSource) envContext.lookup("jdbc/re"); Connection conn = ds.getConnection(); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery( "select value from code_table where category='AREA' order by value asc"); out.write("\n"); out.write("\t\t\t\t\t\t\t<SELECT style=\"width: 97%;\" name=\"area\">\n"); out.write("\t\t\t\t\t\t\t\t<OPTION VALUE=\"\"> Select Area </OPTION>\n"); out.write("\t\t\t\t\t\t"); while (rs.next()) { name = rs.getString(1); out.write("\n"); out.write("\t\t\t\t\t\t\t\t<OPTION VALUE=\""); out.print(name); out.write('"'); out.write('>'); out.write(' '); out.print(name); out.write(" </OPTION>\n"); out.write("\t\t\t\t\t\t"); } out.write("\n"); out.write("\t\t\t\t\t\t\t</SELECT>\n"); out.write("\t\t\t\t\t\t</td>\t\n"); out.write("\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Payment Type</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write("\t\t\t\t\t\t<td>\n"); out.write("\t\t\t\t\t\t\t<SELECT style=\"width: 97%;\" name=\"payment\" align=\"left\">\n"); out.write("\t\t\t\t\t\t\t\t<OPTION selected VALUE=\"\"> Select Type </OPTION>\n"); out.write("\t\t\t\t\t\t\t\t<OPTION VALUE=\"NoType\"> No Type </OPTION>\n"); out.write("\t\t\t\t\t\t"); ResultSet rs2 = stmt.executeQuery("SELECT payment_type_code, payment_type_desc FROM payment_type"); while (rs2.next()) { out.write("\t\n"); out.write("\t\t\t\t\t\t\t\t<OPTION VALUE=\""); out.print(rs2.getString(1)); out.write('"'); out.write('>'); out.write(' '); out.print(rs2.getString(2)); out.write(" </OPTION>\n"); out.write("\t\t\t\t\t\t"); } rs2.close(); stmt.close(); conn.close(); } catch (Exception e) { e.getMessage(); e.printStackTrace(); } out.write("\n"); out.write("\t\t\t\t\t\t\t</SELECT>\n"); out.write("\t\t\t\t\t\t</td>\n"); out.write("\t\t\t\t\t</tr>\n"); out.write("\t\t\t\t\t<tr>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Create<font color=\"blue\">D</font>ate</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write("\t\t\t\t\t\t<td>\n"); out.write( "\t\t\t\t\t\t\t<!-- <input type =\"text\" accesskey=\"d\" name=\"c_date1\" size=\"15\" style=\"width: 79%;\">\n"); out.write( "\t\t\t\t\t\t\t<input type=\"button\" onClick=\"c1.popup('c_date1');\" value=\"...\" style=\"width: 15%;\"/> -->\n"); out.write("\t\t\t\t\t\t\t<div id='createDate1'></div>\n"); out.write("\t\t\t\t\t\t</td>\n"); out.write("\t\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>And</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write("\t\t\t\t\t\t<td> \n"); out.write( "\t\t\t\t\t\t\t<!-- <input type =\"text\" name=\"c_date2\" size=\"15\" style=\"width: 79%;\">\n"); out.write( "\t\t\t\t\t\t\t<input type=\"button\" onClick=\"c1.popup('c_date2');\" value=\"...\" style=\"width: 15%;\"/> -->\n"); out.write("\t\t\t\t\t\t\t<div id='createDate2'></div>\n"); out.write("\t\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t</td>\n"); out.write("\t\t\t\t\t</tr>\n"); out.write("\t\t\t\t\t<tr>\n"); out.write( "\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">U</font>pdate Date</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write("\t\t\t\t\t\t<td>\n"); out.write( "\t\t\t\t\t\t\t<!-- <input type =\"text\" accesskey=\"u\" name=\"u_date1\" size=\"15\" style=\"width: 79%;\"/>\n"); out.write( "\t\t\t\t\t\t\t<input type=\"button\" onClick=\"c1.popup('u_date1');\" value=\"...\" style=\"width: 15%;\"/> -->\n"); out.write("\t\t\t\t\t\t\t<div id=\"updateDate1\"></div>\n"); out.write("\t\t\t\t\t\t</td>\n"); out.write("\t\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>And</b></td>\n"); out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write("\t\t\t\t\t\t<td> \n"); out.write( "\t\t\t\t\t\t\t<!-- <input type =\"text\" name=\"u_date2\" size=\"15\" style=\"width: 79%;\"/>\n"); out.write( "\t\t\t\t\t\t\t<input type=\"button\" onClick=\"c1.popup('u_date2');\" value=\"...\" style=\"width: 15%;\"/> -->\n"); out.write("\t\t\t\t\t\t\t<div id='updateDate2'></div>\n"); out.write("\t\t\t\t\t\t</td>\n"); out.write("\t\t\t\t\t</tr>\n"); out.write("\t\t\t\t\t<tr>\n"); out.write( "\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">S</font>tation</b></td>\n"); out.write("\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t<td><input style=\"width: 97%;\" type =\"text\" size=\"22\" accesskey=\"d\" name=\"station\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n"); out.write("\t\t\t\t\t\t\n"); out.write("\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Last Order Days</b></td>\n"); out.write("\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n"); out.write( "\t\t\t\t\t<td><input style=\"width: 97%;\" type=\"text\" name=\"selmonth\"/></td></tr>\n"); out.write("\t\t\t\t</table></div>\n"); out.write("\t\t\t</td>\n"); out.write("\t\t</tr>\n"); out.write("\t\t\t\n"); out.write("\t\t<tr>\n"); out.write("\t\t\t<td align=\"center\" colspan=4>\n"); out.write( "\t\t\t\t<input type=\"submit\" name=\"search\" title=\"Press <Enter>\" value=\"Search <Enter>\" accesskey=\"s\" onclick=\"checkField();return false;\"/>\n"); out.write( "\t\t\t\t<input type=\"reset\" name=\"clear\" title=\"Press <Alt+c>\" tabindex=\"1\" value=\"Clear <Alt+c>\" accesskey=\"c\" onclick=\"document.getElementById('txtHint').innerHTML='';\"/>\n"); out.write( "\t\t\t\t<INPUT type=BUTTON value=\"Cancel <Alt+c>\" accesskey=\"c\" onClick=\"showMsg();\"/></center>\n"); out.write("\t\t\t</td>\n"); out.write("\t\t</tr>\n"); out.write("\t</table>\n"); out.write("\t</fieldset>\n"); out.write("\t<input type=\"hidden\" name=\"hchckall\" value=\"1\">\n"); out.write("\t<input type=\"hidden\" name=\"call_type\" value=\""); out.print(call_type); out.write("\"/>\n"); out.write("<script>\n"); out.write("function funEnabled(){\n"); out.write("\t if (document.myform.chckall.checked==true){\n"); out.write("\t\t\tdocument.getElementById('div4').style.visibility=\"hidden\";\n"); out.write("\t\t\tdocument.myform.hchckall.value=1;\t\t\n"); out.write("\t\t\t$(\"#createDate2\").jqxDateTimeInput({disabled: true});\n"); out.write("\t\t\t$(\"#updateDate2\").jqxDateTimeInput({disabled: true});\n"); out.write("\t\t\t\n"); out.write("\t\t}\n"); out.write("\t\telse{\n"); out.write("\t\t\tdocument.getElementById('div4').style.visibility=\"visible\";\n"); out.write("\t\t\tdocument.myform.hchckall.value=0;\t\t\t\n"); out.write("\t\t}\n"); out.write("\t}\n"); out.write("window.onload =Clear;\n"); out.write("\n"); out.write("function ChangeCriteria(str){\n"); out.write("\tif(str == \"cust\"){\n"); out.write("\t\tdocument.getElementById(\"myform\").style.display='block';\n"); out.write("\t\tdocument.getElementById(\"myform1\").style.display='none';\n"); out.write("\t}else if(str == \"order\"){\n"); out.write("\t\tdocument.getElementById(\"myform\").style.display='none';\n"); out.write("\t\tdocument.getElementById(\"myform1\").style.display='block';\n"); out.write("\t\tdocument.getElementById(\"txtHint\").innerHTML=\"\";\n"); out.write("\t\tdocument.getElementById(\"order_number\").focus();\n"); out.write("\t\tdocument.getElementById(\"order_number\").value=\"\";\n"); out.write("\t}\n"); out.write("}\n"); out.write("function isNumberKey(evt) {\n"); out.write("\tvar charCode = (evt.which) ? evt.which : event.keyCode;\n"); out.write("\tif (charCode != 46 && charCode > 31 && (charCode < 48 || charCode > 57))\n"); out.write("\t\treturn false;\n"); out.write("\telse\n"); out.write("\t\treturn true;\n"); out.write("}\n"); out.write("</script>\n"); out.write( "\t<hr><center><div id=\"txtHint\" class=\"ddm1\" style=\"background-color: white;width: 100%;max-height: 400px;overflow: auto;\"></div></center>\n"); out.write("\t<br><br>\n"); out.write( "\t<p><h1><center><div id=\"waitMessage\" style=\"cursor: sw-resize;\"></center></div></h1></p>\n"); String fromFromName = ""; if (request.getParameter("fromForm") != null) fromFromName = request.getParameter("fromForm"); // CustPmtHstry out.write("\n"); out.write("\t<input type=\"hidden\" name=\"fromForm\" value=\""); out.print(fromFromName); out.write("\">\n"); out.write("</form>\n"); out.write("\n"); out.write( "<div id=\"dispdiv\" align=\"center\" style=\"border:1px solid black; padding:25px; text-align:center; display:none; background-color:#FFF; overflow:auto; height:300px; width=200px;\"> </div>\n"); out.write("</body>\n"); out.write("</html>\n"); } catch (java.lang.Throwable t) { if (!(t instanceof javax.servlet.jsp.SkipPageException)) { out = _jspx_out; if (out != null && out.getBufferSize() != 0) try { out.clearBuffer(); } catch (java.io.IOException e) { } if (_jspx_page_context != null) _jspx_page_context.handlePageException(t); else throw new ServletException(t); } } finally { _jspxFactory.releasePageContext(_jspx_page_context); } }
public void _jspService(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, null, true, 8192, true); application = pageContext.getServletContext(); config = pageContext.getServletConfig(); session = pageContext.getSession(); out = pageContext.getOut(); _jspx_out = out; out.write("\n\n"); out.write("\n"); out.write("\n"); out.write("\n"); out.write("\n"); out.write("\n"); out.write("\n"); out.write("\n"); out.write("\n"); out.write("\n"); out.write("\n\n"); // This JSP handles cross context communications from wt-monitor // to wt-core for use in accessing wt-core functionality that is // needed in WTnav-tree.jsp. // Assign a pooled DB connection handle Context ctx = new InitialContext(); DataSource ds = (DataSource) ctx.lookup(WTConstants.WATCHTOWERDB_CONN); int iIndex = 6100; GraphViewManager graphman = new GraphViewManager(ds); // Vector views = graphman.getViews(); Vector views = new Vector(); WTOrganization[] orgs = null; WTAccountCredentials ac = (WTAccountCredentials) request.getSession().getAttribute(WTAccountCredentials.SESSION_ATTRIBUTE_AC); if (ac != null) { // WTOrganization[] orgs = null; int selectedOrg = ac.getCurrentManagedId(); boolean siteUser = ac.getIsSiteUser(); int userId = ac.getUserId(); // Get list of organizations for the current user if (siteUser) { try { orgs = DAOImpl.OrgDAO.getWTOrganization(); } catch (Exception e) { e.printStackTrace(); } } else { if (!(userId < 0)) { try { orgs = DAOImpl.OrgDAO.getWTOrganizationsByUser(userId); } catch (Exception e) { e.printStackTrace(); } } } // Get the list of actively managed nodes if (selectedOrg == WTAccountCredentials.ALL_ORGS) { if (siteUser) { views = graphman.getViews(); } else { if (orgs != null) { int[] orgsIds = new int[orgs.length]; for (int i = 0; i < orgs.length; i++) { orgsIds[i] = orgs[i].getID(); } views = graphman.getViews(orgsIds); } } } else { views = graphman.getViews(selectedOrg); } } // My Graph Views is an experimental feature and is commented out until all kinks are worked // out. LS String strOutput = null; // if( views.size()==0 ) { // strOutput = "nav.add(6100, 6000, 'My Graph Views', '/wt-monitor/report/index.jsp', 'My // Customized Graph Views', 'mainContentsFrame', icon16_basedir + 'bs_chart.gif', // icon16_basedir + 'bs_chart.gif', '');\r\n"; // } else { // strOutput = "nav.add(6100, 6000, 'My Graph Views', '', 'My Customized Graph Views', // 'mainContentsFrame', icon16_basedir + 'bs_chart.gif', icon16_basedir + 'bs_chart.gif', // '');\r\n"; // } // for (int i=0; i<views.size(); i++) // { // iIndex++; // String strViewName = ((GraphViewJB)views.elementAt(i)).getName(); // int strOrgId = ((GraphViewJB)views.elementAt(i)).getOrgId(); // String orgName = null; // for(int j=0;j<orgs.length;j++){ // if(orgs[j].getID() != -1 && orgs[j].getID() == strOrgId){ // orgName = orgs[j].getName(); // } // } // // strOutput +="nav.add(" + iIndex + // ", 6100, '" + strViewName + // "', 'javascript: // PopupCenteredWindow(\\'/wt-core/jsp/sysmon/graphview/GraphView.jsp?view=" + strViewName + // "&orgname="+orgName +"&start=01&end=02" + "\\', \\'graphview\\', \\'yes\\', \\'yes\\', // \\'yes\\', \\'900\\', \\'1010\\'); location.href=\\'/wt-monitor/wt-jsp/WTnav-tree.jsp\\';', // 'Open " + strViewName + " Graph View', '', icon16_basedir + 'bs_chart.gif', icon16_basedir // + 'bs_chart.gif', '');\r\n"; // } out.write("\n\n"); out.write("\n"); out.write("\n"); out.write("\n"); out.write("\n\n"); out.print(strOutput); 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( final javax.servlet.http.HttpServletRequest request, final javax.servlet.http.HttpServletResponse response) throws java.io.IOException, javax.servlet.ServletException { final java.lang.String _jspx_method = request.getMethod(); if (!"GET".equals(_jspx_method) && !"POST".equals(_jspx_method) && !"HEAD".equals(_jspx_method) && !javax.servlet.DispatcherType.ERROR.equals(request.getDispatcherType())) { response.sendError( HttpServletResponse.SC_METHOD_NOT_ALLOWED, "JSPs only permit GET POST or HEAD"); return; } final javax.servlet.jsp.PageContext pageContext; javax.servlet.http.HttpSession session = null; final javax.servlet.ServletContext application; final javax.servlet.ServletConfig config; javax.servlet.jsp.JspWriter out = null; final java.lang.Object page = this; javax.servlet.jsp.JspWriter _jspx_out = null; javax.servlet.jsp.PageContext _jspx_page_context = null; try { response.setContentType("text/html"); pageContext = _jspxFactory.getPageContext(this, request, response, null, true, 8192, true); _jspx_page_context = pageContext; application = pageContext.getServletContext(); config = pageContext.getServletConfig(); session = pageContext.getSession(); out = pageContext.getOut(); _jspx_out = out; out.write('\r'); out.write('\n'); String username = ""; if (session.getAttribute("login") != null) { username = session.getAttribute("login").toString(); } else { out.println("Invalid session! You must log back into the system."); return; } String outputMsg = "TODO"; ResultSet employeeRevRes = null; String JDBC_DRIVER = "com.mysql.jdbc.Driver"; String DB_URL = "jdbc:mysql://localhost:3306/SilkRoad 5.0"; String USER = "******"; String PASS = "******"; Statement stmt = null; String sql = null; Connection conn = null; CallableStatement cs = null; try { // Register JDBC driver Class.forName(JDBC_DRIVER).newInstance(); // Open a connection conn = java.sql.DriverManager.getConnection(DB_URL, USER, PASS); System.out.println("HERE"); cs = conn.prepareCall("call GetEmployeeRevenues()"); cs.execute(); employeeRevRes = cs.getResultSet(); // TODO. Error handling out.write("\r\n"); out.write(" <html lang=\"en\">\r\n"); out.write(" <head>\r\n"); out.write(" <meta charset=\"utf-8\">\r\n"); out.write(" <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\r\n"); out.write( " <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\r\n"); out.write( " <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->\r\n"); out.write(" <title>Silk Road 5.0</title>\r\n"); out.write(" <!-- Bootstrap -->\r\n"); out.write(" <link href=\"css/bootstrap.min.css\" rel=\"stylesheet\">\r\n"); out.write(" "); out.write("\r\n"); out.write( " <link href=\"css/responsive.bootstrap.min.css\" rel=\"stylesheet\" type=\"text/css\">\r\n"); out.write( " <link href=\"https://cdnjs.cloudflare.com/ajax/libs/bootstrap3-dialog/1.34.5/css/bootstrap-dialog.min.css\" rel=\"stylesheet\" type=\"text/css\" />\r\n"); out.write(" <!-- Our own custom css -->\r\n"); out.write( " <link href=\"css/stylesheet.css\" rel=\"stylesheet\" type=\"text/css\">\r\n"); out.write( " <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->\r\n"); out.write( " <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->\r\n"); out.write(" <!--[if lt IE 9]>\r\n"); out.write( " <script src=\"https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js\"></script>\r\n"); out.write( " <script src=\"https://oss.maxcdn.com/respond/1.4.2/respond.min.js\"></script>\r\n"); out.write(" <![endif]-->\r\n"); out.write(" <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->\r\n"); out.write(" <script src=\"js/jquery-1.11.3.min.js\"></script>\r\n"); out.write(" <script src=\"js/jquery.validate.js\"></script>\r\n"); out.write(" "); out.write("\r\n"); out.write( " <!-- Include all compiled plugins (below), or include individual files as needed -->\r\n"); out.write(" <script src=\"js/bootstrap.min.js\"></script>\r\n"); out.write( " <script src=\"https://cdnjs.cloudflare.com/ajax/libs/bootstrap3-dialog/1.34.5/js/bootstrap-dialog.min.js\"></script>\r\n"); out.write(" <script src=\"js/pattern.js\"></script>\r\n"); out.write(" <script src=\"js/script.js\"></script>\r\n"); out.write(" <script src=\"js/editCustomer.js\"></script>\r\n"); out.write(" </head>\r\n"); out.write(" <nav class=\"navbar\">\r\n"); out.write(" <div class=\"container-fluid\">\r\n"); out.write(" <!-- Brand and toggle get grouped for better mobile display -->\r\n"); out.write(" <div class=\"navbar-header\">\r\n"); out.write( " <button type=\"button\" class=\"navbar-toggle collapsed\" data-toggle=\"collapse\" data-target=\"#bs-example-navbar-collapse-1\" aria-expanded=\"false\">\r\n"); out.write(" <span class=\"sr-only\">Toggle navigation</span>\r\n"); out.write(" <span class=\"icon-bar\"></span>\r\n"); out.write(" <span class=\"icon-bar\"></span>\r\n"); out.write(" <span class=\"icon-bar\"></span>\r\n"); out.write(" </button>\r\n"); out.write(" </div>\r\n"); out.write(" <!-- navbar-header -->\r\n"); out.write( " <!-- Collect the nav links, forms, and other content for toggling -->\r\n"); out.write(" <div class=\"myNavbar\">\r\n"); out.write(" <ul class=\"nav\">\r\n"); out.write( " <li class=\"floatLeft\"><a href=\"ManagerInformation.jsp\">Home</a></li>\r\n"); out.write( " <li class=\"dropdown navbar-right\" style=\"padding-left:125px;\">\r\n"); out.write( " <a data-target=\"#collapseHelp\" data-toggle=\"collapse\">Help<span class=\"caret\"></span></a>\r\n"); out.write(" <ul>\r\n"); out.write(" <div id=\"collapseHelp\" class=\"dropdown-menu\">\r\n"); out.write( " <li><a href=\"javascript:showEmployeeScreenHelp()\">Screens</a></li>\r\n"); out.write(" <br>\r\n"); out.write( " <li><a href=\"javascript:showAuctionHelp()\">Auctions</a></li>\r\n"); out.write(" <br>\r\n"); out.write(" </div>\r\n"); out.write(" </ul>\r\n"); out.write(" </li>\r\n"); out.write( " <li class=\"dropdown navbar-right\" style=\"padding-left:200px;\">\r\n"); out.write( " <a data-target=\"#collapseMenu\" data-toggle=\"collapse\" >Menu<span class=\"caret\"></span></a>\r\n"); out.write(" <ul>\r\n"); out.write(" <div id=\"collapseMenu\" class=\"dropdown-menu\">\r\n"); out.write(" </div>\r\n"); out.write(" </ul>\r\n"); out.write(" </li>\r\n"); out.write(" </ul>\r\n"); out.write(" <!-- .nav -->\r\n"); out.write(" </div>\r\n"); out.write(" <!-- .myNavbar -->\r\n"); out.write(" </div>\r\n"); out.write(" <!-- .container-fluid -->\r\n"); out.write(" </nav>\r\n"); out.write(" <body class=\"auctionHouseBody\">\r\n"); out.write( " <h4 class=\"auctionTableHeader\">Highest Grossing Employee</h4>\r\n"); out.write( " <table id =\"bestSellersTable\" class=\"table table-striped table-bordered dt-responsive nowrap auctionHouseTable\">\r\n"); out.write(" <thead>\r\n"); out.write(" <tr>\r\n"); out.write(" <th>Employee ID</th>\r\n"); out.write(" <th>Username</th>\r\n"); out.write(" <th>Revenue</th>\r\n"); out.write(" </tr>\r\n"); out.write(" </thead>\r\n"); out.write(" <tbody>\r\n"); out.write(" "); while (employeeRevRes.next()) { out.write("\r\n"); out.write(" <tr>\r\n"); out.write(" <td>\r\n"); out.write(" "); out.print(employeeRevRes.getString("EmployeeID")); out.write("\r\n"); out.write(" </td>\r\n"); out.write(" <td>\r\n"); out.write(" "); out.print(employeeRevRes.getString("Username")); out.write("\r\n"); out.write(" </td>\r\n"); out.write(" <td>\r\n"); out.write(" "); out.print(employeeRevRes.getDouble("Revenue")); out.write("\r\n"); out.write(" </td>\r\n"); out.write(" </tr>\r\n"); out.write(" "); } out.write("\r\n"); out.write(" </tbody>\r\n"); out.write(" </table>\r\n"); out.write(" </body>\r\n"); out.write(" </html>\r\n"); out.write("\r\n"); out.write(" "); } catch (Exception e) { e.printStackTrace(); } finally { try { conn.close(); } catch (Exception ee) { } ; } out.write('\r'); out.write('\n'); } catch (java.lang.Throwable t) { if (!(t instanceof javax.servlet.jsp.SkipPageException)) { out = _jspx_out; if (out != null && out.getBufferSize() != 0) try { if (response.isCommitted()) { out.flush(); } else { out.clearBuffer(); } } catch (java.io.IOException e) { } if (_jspx_page_context != null) _jspx_page_context.handlePageException(t); else throw new ServletException(t); } } finally { _jspxFactory.releasePageContext(_jspx_page_context); } }
public synchronized void service(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { HttpSession dbSession = request.getSession(); JspFactory _jspxFactory = JspFactory.getDefaultFactory(); PageContext pageContext = _jspxFactory.getPageContext(this, request, response, "", true, 8192, true); ServletContext dbApplication = dbSession.getServletContext(); try { HttpSession session = request.getSession(); PrintWriter out = response.getWriter(); nseer_db_backup1 fund_db = new nseer_db_backup1(dbApplication); nseer_db_backup1 fund_db1 = new nseer_db_backup1(dbApplication); if (fund_db.conn((String) dbSession.getAttribute("unit_db_name")) && fund_db1.conn((String) dbSession.getAttribute("unit_db_name"))) { counter count = new counter(dbApplication); ValidataRecordNumber vrn = new ValidataRecordNumber(); ValidataTag vt = new ValidataTag(); ValidataNumber validata = new ValidataNumber(); try { String time = ""; java.util.Date now = new java.util.Date(); SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd"); time = formatter.format(now); String apply_pay_ID = request.getParameter("apply_pay_ID"); String register_time = request.getParameter("register_time"); String register = request.getParameter("register"); String register_ID = request.getParameter("register_ID"); String bodyc = new String(request.getParameter("remark").getBytes("UTF-8"), "UTF-8"); String remark = exchange.toHtml(bodyc); String amount = request.getParameter("amount"); String[] file_kind = request.getParameterValues("file_kind"); String[] cost_price_subtotal = request.getParameterValues("cost_price_subtotal"); int p = 0; String file_kinda = ","; for (int j = 1; j < file_kind.length; j++) { file_kinda += file_kind[j] + ","; if (cost_price_subtotal[j].equals("")) cost_price_subtotal[j] = "0"; StringTokenizer tokenTO4 = new StringTokenizer(cost_price_subtotal[j], ","); String cost_price_subtotal1 = ""; while (tokenTO4.hasMoreTokens()) { cost_price_subtotal1 += tokenTO4.nextToken(); } if (!validata.validata(cost_price_subtotal1)) { p++; } } int n = 0; for (int i = 1; i <= Integer.parseInt(amount); i++) { String tem_file_kind = "file_kind" + i; String file_kind2 = request.getParameter(tem_file_kind); if (file_kinda.indexOf(file_kind2) != -1) n++; } if (n == 0) { if (p == 0) { if (vt.validata( (String) dbSession.getAttribute("unit_db_name"), "fund_apply_pay", "apply_pay_ID", apply_pay_ID, "check_tag") .equals("5") || vt.validata( (String) dbSession.getAttribute("unit_db_name"), "fund_apply_pay", "apply_pay_ID", apply_pay_ID, "check_tag") .equals("9")) { String currency_name = ""; String personal_unit = ""; String chain_ID = ""; String chain_name = ""; String funder = ""; String funder_ID = ""; String sql11 = "select * from fund_apply_pay where apply_pay_ID='" + apply_pay_ID + "'"; ResultSet rs11 = fund_db.executeQuery(sql11); while (rs11.next()) { chain_ID = rs11.getString("chain_ID"); chain_name = rs11.getString("chain_name"); funder = rs11.getString("human_name"); funder_ID = rs11.getString("human_ID"); currency_name = rs11.getString("currency_name"); personal_unit = rs11.getString("personal_unit"); } int expenses_amount = 0; String sql6 = "select count(*) from fund_apply_pay_details where apply_pay_ID='" + apply_pay_ID + "'"; ResultSet rs6 = fund_db.executeQuery(sql6); if (rs6.next()) { expenses_amount = rs6.getInt("count(*)"); } double demand_cost_price_sum = 0.0d; for (int i = 1; i <= expenses_amount; i++) { String tem_cost_price_subtotal = "cost_price_subtotal" + i; String cost_price_subtotal2 = request.getParameter(tem_cost_price_subtotal); demand_cost_price_sum += Double.parseDouble(cost_price_subtotal2); sql6 = "update fund_apply_pay_details set cost_price_subtotal='" + cost_price_subtotal2 + "' where apply_pay_ID='" + apply_pay_ID + "' and details_number='" + i + "'"; fund_db.executeUpdate(sql6); } for (int i = 1; i < file_kind.length; i++) { StringTokenizer tokenTO1 = new StringTokenizer(file_kind[i], "/"); String file_chain_ID = ""; String file_chain_name = ""; while (tokenTO1.hasMoreTokens()) { file_chain_ID = tokenTO1.nextToken(); file_chain_name = tokenTO1.nextToken(); } StringTokenizer tokenTO4 = new StringTokenizer(cost_price_subtotal[i], ","); String cost_price_subtotal1 = ""; while (tokenTO4.hasMoreTokens()) { cost_price_subtotal1 += tokenTO4.nextToken(); } demand_cost_price_sum += Double.parseDouble(cost_price_subtotal1); expenses_amount++; String sql1 = "insert into fund_apply_pay_details(apply_pay_ID,details_number,file_chain_ID,file_chain_name,cost_price_subtotal) values ('" + apply_pay_ID + "','" + expenses_amount + "','" + file_chain_ID + "','" + file_chain_name + "','" + cost_price_subtotal1 + "')"; fund_db.executeUpdate(sql1); } String sql = "update fund_apply_pay set demand_cost_price_sum='" + demand_cost_price_sum + "',check_tag='2',register_time='" + register_time + "',register='" + register + "',remark='" + remark + "' where apply_pay_ID='" + apply_pay_ID + "'"; fund_db.executeUpdate(sql); response.sendRedirect("draft/fund/applyPayExpenses_ok.jsp?finished_tag=2"); } else { response.sendRedirect("draft/fund/applyPayExpenses_ok.jsp?finished_tag=3"); } } else { response.sendRedirect("draft/fund/applyPayExpenses_ok.jsp?finished_tag=6"); } } else { response.sendRedirect("draft/fund/applyPayExpenses_ok.jsp?finished_tag=7"); } } catch (Exception ex) { ex.printStackTrace(); } fund_db.commit(); fund_db1.commit(); fund_db.close(); fund_db1.close(); } else { response.sendRedirect("error_conn.htm"); } } catch (Exception ex) { ex.printStackTrace(); } }
public synchronized void service(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { HttpSession dbSession = request.getSession(); JspFactory _jspxFactory = JspFactory.getDefaultFactory(); PageContext pageContext = _jspxFactory.getPageContext(this, request, response, "", true, 8192, true); ServletContext dbApplication = dbSession.getServletContext(); try { // 实例化 HttpSession session = request.getSession(); ServletContext context = session.getServletContext(); String path = context.getRealPath("/"); counter count = new counter(dbApplication); SmartUpload mySmartUpload = new SmartUpload(); mySmartUpload.setCharset("UTF-8"); nseer_db_backup1 qcs_db = new nseer_db_backup1(dbApplication); if (qcs_db.conn((String) dbSession.getAttribute("unit_db_name"))) { mySmartUpload.initialize(pageContext); String file_type = getFileLength.getFileType((String) session.getAttribute("unit_db_name")); long d = getFileLength.getFileLength((String) session.getAttribute("unit_db_name")); mySmartUpload.setMaxFileSize(d); mySmartUpload.setAllowedFilesList(file_type); try { mySmartUpload.upload(); String qcs_id = mySmartUpload.getRequest().getParameter("qcs_id"); String config_id = mySmartUpload.getRequest().getParameter("config_id"); String[] item = mySmartUpload.getRequest().getParameterValues("item"); if (item != null) { String[] file_name = new String[mySmartUpload.getFiles().getCount()]; String[] not_change = new String[mySmartUpload.getFiles().getCount()]; java.util.Date now = new java.util.Date(); SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd"); String time = formatter.format(now); String standard_id = mySmartUpload.getRequest().getParameter("standard_id"); String sqla = "select attachment1 from qcs_intrmanufacture where qcs_id='" + qcs_id + "' and (check_tag='5' or check_tag='9')"; ResultSet rs = qcs_db.executeQuery(sqla); if (!rs.next()) { response.sendRedirect("draft/qcs/intrmanufacture_ok.jsp?finished_tag=1"); } else { String[] attachment = mySmartUpload.getRequest().getParameterValues("attachment"); String[] delete_file_name = new String[0]; if (attachment != null) { delete_file_name = new String[attachment.length]; for (int i = 0; i < attachment.length; i++) { delete_file_name[i] = rs.getString(attachment[i]); } } for (int i = 0; i < mySmartUpload.getFiles().getCount(); i++) { com.jspsmart.upload.SmartFile file = mySmartUpload.getFiles().getFile(i); if (file.isMissing()) { file_name[i] = ""; int q = i + 1; String field_name = "attachment" + q; if (!rs.getString(field_name).equals("")) not_change[i] = "yes"; continue; } int filenum = count.read( (String) dbSession.getAttribute("unit_db_name"), "qcsAttachmentcount"); count.write( (String) dbSession.getAttribute("unit_db_name"), "qcsAttachmentcount", filenum); file_name[i] = filenum + file.getFileName(); file.saveAs(path + "qcs/file_attachments/" + filenum + file.getFileName()); } String apply_id = mySmartUpload.getRequest().getParameter("apply_id"); String product_id = mySmartUpload.getRequest().getParameter("product_id"); String product_name = mySmartUpload.getRequest().getParameter("product_name"); String qcs_amount = mySmartUpload.getRequest().getParameter("qcs_amount"); String qcs_time = mySmartUpload.getRequest().getParameter("qcs_time"); String quality_way = mySmartUpload.getRequest().getParameter("quality_way"); String quality_solution = mySmartUpload.getRequest().getParameter("quality_solution"); String sampling_standard = mySmartUpload.getRequest().getParameter("sampling_standard"); String sampling_amount = mySmartUpload.getRequest().getParameter("sampling_amount"); String accept = mySmartUpload.getRequest().getParameter("accept"); String reject = mySmartUpload.getRequest().getParameter("reject"); String qualified = mySmartUpload.getRequest().getParameter("qualified"); String unqualified = mySmartUpload.getRequest().getParameter("unqualified"); String qcs_result = mySmartUpload.getRequest().getParameter("qcs_result"); String checker = mySmartUpload.getRequest().getParameter("checker"); String checker_id = mySmartUpload.getRequest().getParameter("checker_id"); String check_time = mySmartUpload.getRequest().getParameter("check_time"); String changer = mySmartUpload.getRequest().getParameter("changer"); String changer_id = mySmartUpload.getRequest().getParameter("changer_id"); String change_time = mySmartUpload.getRequest().getParameter("change_time"); String bodyab = new String( mySmartUpload.getRequest().getParameter("remark").getBytes("UTF-8"), "UTF-8"); String remark = exchange.toHtml(bodyab); sqla = "update qcs_intrmanufacture set apply_id='" + apply_id + "',product_id='" + product_id + "',product_name='" + product_name + "',qcs_amount='" + qcs_amount + "',qcs_time='" + qcs_time + "',quality_way='" + quality_way + "',quality_solution='" + quality_solution + "',sampling_standard='" + sampling_standard + "',sampling_amount='" + sampling_amount + "',accept='" + accept + "',reject='" + reject + "',qualified='" + qualified + "',unqualified='" + unqualified + "',changer_id='" + changer_id + "',qcs_result='" + qcs_result + "',changer='" + changer + "',change_time='" + change_time + "',remark='" + remark + "',check_tag='5'"; String sqlb = " where qcs_id='" + qcs_id + "'"; if (attachment != null) { for (int i = 0; i < attachment.length; i++) { sqla = sqla + "," + attachment[i] + "=''"; java.io.File file = new java.io.File(path + "qcs/file_attachments/" + delete_file_name[i]); file.delete(); } } for (int i = 0; i < mySmartUpload.getFiles().getCount(); i++) { if (not_change[i] != null && not_change[i].equals("yes")) continue; int p = i + 1; sqla = sqla + ",attachment" + p + "='" + file_name[i] + "'"; } String sql = sqla + sqlb; qcs_db.executeUpdate(sql); sql = "delete from qcs_intrmanufacture_details where qcs_id='" + qcs_id + "'"; qcs_db.executeUpdate(sql); String[] default_basis = mySmartUpload.getRequest().getParameterValues("default_basis"); String[] ready_basis = mySmartUpload.getRequest().getParameterValues("ready_basis"); String[] quality_method = mySmartUpload.getRequest().getParameterValues("quality_method"); String[] analyse_method = mySmartUpload.getRequest().getParameterValues("analyse_method"); String[] standard_value = mySmartUpload.getRequest().getParameterValues("standard_value"); String[] standard_max = mySmartUpload.getRequest().getParameterValues("standard_max"); String[] standard_min = mySmartUpload.getRequest().getParameterValues("standard_min"); String[] quality_value = mySmartUpload.getRequest().getParameterValues("quality_value"); String[] sampling_amount_d = mySmartUpload.getRequest().getParameterValues("sampling_amount_d"); String[] qualified_d = mySmartUpload.getRequest().getParameterValues("qualified_d"); String[] unqualified_d = mySmartUpload.getRequest().getParameterValues("unqualified_d"); String[] quality_result = mySmartUpload.getRequest().getParameterValues("quality_result"); String[] unqualified_reason = mySmartUpload.getRequest().getParameterValues("unqualified_reason"); for (int i = 0; i < item.length; i++) { if (!item[i].equals("")) { sql = "insert into qcs_intrmanufacture_details(qcs_id,item,default_basis,ready_basis,quality_method,analyse_method,standard_value,standard_max,standard_min,quality_value,sampling_amount_d,qualified_d,unqualified_d,quality_result,unqualified_reason,details_number) values('" + qcs_id + "','" + item[i] + "','" + default_basis[i] + "','" + ready_basis[i] + "','" + quality_method[i] + "','" + analyse_method[i] + "','" + standard_value[i] + "','" + standard_max[i] + "','" + standard_min[i] + "','" + quality_value[i] + "','" + sampling_amount_d[i] + "','" + qualified_d[i] + "','" + unqualified_d[i] + "','" + quality_result[i] + "','" + unqualified_reason[i] + "','" + i + "')"; qcs_db.executeUpdate(sql); } } response.sendRedirect("draft/qcs/intrmanufacture_ok.jsp?finished_tag=0"); } qcs_db.commit(); qcs_db.close(); } else { response.sendRedirect("draft/qcs/intrmanufacture_ok.jsp?finished_tag=7"); } } catch (Exception ex) { response.sendRedirect("draft/qcs/intrmanufacture_ok.jsp?finished_tag=6"); } } else { response.sendRedirect("error_conn.htm"); } } catch (Exception ex) { ex.printStackTrace(); } }