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,
              "ErrorPage.jsp?page=OrderProcessingSend.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");
      out.write("\t\t<script type=\"text/javascript\" src=\"js/jquery-1.10.2.min.js\"></script>\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(' ');
      out.write('\n');

      // DecimalFormat df = new DecimalFormat("###,###.00");
      int cnt = 1;
      String orderNo = "";
      String custCode = "";
      String custName = "";
      String buildingNo = "";
      String block = "";
      String wing = "";
      String building = "";
      String area = "";
      String orderDate = "";
      String lastModifiedDate = "";
      String totalItems = "";
      String totalValueMrp = "";
      String totalValuePrice = "";
      String bagsNo = "";
      String discountAmt = "";
      String advanceAmt = "";
      String balanceAmt = "";
      String changeAmt = "";
      String paidAmt = "";
      String expectedAmt = "";
      String deliveryStaffName = "";
      String statusCode = "";
      String delchgs = "";
      String payment = "";
      double adamt = 0.0f;
      String ord_comm_amt = "";
      String submitTypeValue = "",
          startTime = "",
          orderNoArr = "",
          code = "",
          desc = "",
          deliveryPerson = "",
          divCount = "";
      String coinArray = "", commArray = "";
      boolean subFlag = true;
      int divId = 0, count = 0;
      submitTypeValue = request.getParameter("subValue");
      String sendValue = request.getParameter("send");
      DecimalFormat df = new DecimalFormat("###,###.00");
      order.ManageOrder mo;
      mo = new order.ManageOrder("jdbc/js");
      if (submitTypeValue.equals("Submitted3")) {
        mo.submittedOrdersList(submitTypeValue);
      } else if (submitTypeValue.equals("Checked3")) {
        mo.checkedOrdersList(submitTypeValue);
      } else if (submitTypeValue.equals("Both")) {
        mo.bothOrdersList();
      }

      mo.getDeliveryStaffList();

      out.write("\n");
      out.write("<center><h4>Orders List</h4>\n");
      out.write("\n");
      out.write("\t\n");
      out.write("      \n");
      out.write("<table >\n");
      out.write("\t<tr>\n");
      out.write("\t<td>\n");
      out.write("\t<table align=\"left\">\n");
      out.write(
          "\t\t<tr><td><font size=2 color=\"red\">Total Orders :</td><td><font size=2 color=\"red\"><b><div id=\"divtonosend\"></div></b></td></font></b></tr>\n");
      out.write(
          "\t\t<tr><td><font size=2 color=\"red\">Total Change :</td><td><font size=2 color=\"red\"><b><div id=\"divtotchange\"></div></td></tr>\n");
      out.write(
          "\t\t<tr><td><font size=2 color=\"red\">Total Comm.  :</td><td><font size=2 color=\"red\"><b><div id=\"divtotcomm\"></div></td></tr>\n");
      out.write(
          "\t\t<tr><td><font size=2 color=\"red\">Total  Bags   :</td><td><font size=2 color=\"red\"><b><div id=\"divtotbags\"></div></td></tr>\n");
      out.write("\t</table>\n");
      out.write("    </td>\n");
      out.write("    <td>\n");
      out.write("\t<table align=\"right\">\n");
      out.write("\t<tr>\n");
      out.write(
          "\t\t<td width=\"25%\" ><b><font size=2 color=\"red\">Delivery Person :</b></font></td>\n");
      out.write("\t\t<td>\n");
      out.write("\t\t\t<SELECT name=\"d_staff\" >\n");
      out.write("\t\t\t\t<OPTION VALUE='select' >Select staff\n");

      while (mo.rs1.next()) {
        code = mo.rs1.getString(1);
        desc = mo.rs1.getString(2);

        out.write("\n");
        out.write("\t\t\t\t<OPTION VALUE=\"");
        out.print(code);
        out.write('"');
        out.write(' ');
        out.write('>');
        out.print(desc);
        out.write('\n');
      }

      out.write("\t\t\n");
      out.write("\t\t</td>\n");
      out.write("\t\t<td>\n");
      out.write(
          "\t\t\t<INPUT type=BUTTON value='Send <Alt+n>' accesskey='n' onclick='funsend();'>\n");
      out.write("\t\t</td>\t\t\t\n");
      out.write("\t\t<td>\t\t\n");
      out.write(
          "\t\t\t<INPUT type=BUTTON value=\"Cancel <Alt+c>\" accesskey=\"c\" onClick=\"cancel();\"></center>\n");
      out.write("\t\t</td>\n");
      out.write("\t\t<td>\t\t\n");
      out.write(
          "\t\t\t<INPUT type=BUTTON value=\"Denomination <Alt+d>\" accesskey=\"d\" onClick=\"calculate();\"></center>\n");
      out.write("\t\t</td>\t\t\t\n");
      out.write("\t</tr>\n");
      out.write("\t</table>\n");
      out.write("\t</td>\n");
      out.write("</tr>\n");
      out.write("</table><br>\n");
      out.write("\n");
      out.write("<div>\n");
      out.write(
          "\t<table border=\"1\" id=\"sendid\" style=\"width=100%;display:none;border-collapse: collapse;\" >\n");
      out.write("\t<thead>\n");
      out.write("\t\t<tr>\t\n");
      out.write("\t\t\t    <td ><b>Area</b></td>\n");
      out.write("\t\t\t    <td ><b>Order</b></td>\t\t\n");
      out.write("\t\t\t\t<td><b>Customer</b></td>\t\t\t\t\t\n");
      out.write("\t\t\t\t<td ><b>Order Date</b></td>\t\t\t\n");
      out.write("\t\t\t\t<td ><b>Items</b></td>\n");
      out.write("\t\t\t\t<td><b>Payment</b></td>\n");
      out.write("\t\t\t\t\n");
      out.write("\t\t\t\n");
      out.write("\t\t\t\t\n");
      out.write("\t\t\t\t<td> <b>Total</b></td>\n");
      out.write("\t\t\t\t<td><b>Advance/Discount</b></td>\n");
      out.write("\t\t\t\t<td><b>Del Chgs</b></td>\n");
      out.write("\t\t\t\t<td><b>Balance</b></td>\t\n");
      out.write("\t\t\t\t<td><b>Change</b></td>\t\n");
      out.write("\t\t\t\t<td><b>Expected</b></td>\n");
      out.write("\t\t\t\t<td><b>Total Bags</b></td>\n");
      out.write("\t\t\t\t<td colspan=\"2\"><b>Action</b></td>\t\n");
      out.write("\t\t\t\t<td colspan=\"1\"><b>Comm Amt</b></td>\t\n");
      out.write("\t\t\t</tr>\n");
      out.write("\t</thead>\n");
      out.write("\t<tbody>\n");
      out.write("\t</tbody>\n");
      out.write("</table>\n");
      out.write("</div>\n");
      out.write("\n");
      out.write("\n");
      out.write("<br><hr color=\"red\">\n");
      out.write("<div id=\"searchTable\">        \n");
      out.write("<table >\n");
      out.write(
          "\t<tr><td width=\"25%\"><font size=2 color=\"red\">Total Orders :  <b><div id=\"divtono\"></div></b></font></b></td>\n");
      out.write("\t\n");
      out.write(
          "\t\t<td width=\"25%\" ><b><font size=2 color=\"red\">Order Number :</font></b></td>\n");
      out.write("\t\t<td>\n");
      out.write("\t\t\t <input type=\"text\" name=\"search\" size=\"7\" value=''>\n");
      out.write("\t\t</td>\t\n");
      out.write("\n");
      out.write("\t\t<td>\n");
      out.write(
          "\t\t\t<INPUT type=BUTTON value=\"Search <Alt+S>\" accesskey=\"s\" onClick=\"searchOno();\">\n");
      out.write("\t\t</td>\n");
      out.write("\t\t<td>\n");
      out.write(
          "\t\t\t<input type=\"reset\" name=\"clear\" accesskey=\"r\" value=\"Clear <Alt+r>\">\n");
      out.write("\t\t</td>\t\t\t\n");
      out.write("\t\t<td>\t\t\n");
      out.write(
          "\t\t\t<INPUT type=BUTTON value=\"Cancel <Alt+c>\" accesskey=\"c\" onClick=\"cancel();\"></center>\n");
      out.write("\t\t</td>\t\t\n");
      out.write("\t</tr>\n");
      out.write("</table><br>\n");
      out.write("</div>\n");
      out.write("<table border=\"1\" name=\"t\" id=\"id\" style=\"width=100%;\" >\n");
      out.write("\n");
      out.write("\t\t\t <tr>\t\n");
      out.write("\t\t\t    <td ><b>Area</b></td>\n");
      out.write("\t\t\t    <td ><b>Order</b></td>\t\t\n");
      out.write("\t\t\t\t<td><b>Customer</b></td>\t\t\t\t\t\n");
      out.write("\t\t\t\t<td ><b>Order Date</b></td>\t\t\t\n");
      out.write("\t\t\t\t<td ><b>Items</b></td>\n");
      out.write("\t\t\t\t<td><b>Payment</b></td>\n");
      out.write(
          "\t\t\t\t<td colspan=\"6\" align=\"center\"><b>Amounts</b></td>\t\t\t\t\t\t\t\t\t\t\t\n");
      out.write("\t\t\t</tr>\n");
      out.write("\t\t\t\t<tr>\n");
      out.write("\t\t\t\t<td colspan=\"6\"></td>\n");
      out.write("\t\t\t\t<td> <b>Total</b></td>\n");
      out.write("\t\t\t\t<td><b>Advance/Discount</b></td>\n");
      out.write("\t\t\t\t<td><b>Del Chgs</b></td>\n");
      out.write("\t\t\t\t<td><b>Balance</b></td>\t\n");
      out.write("\t\t\t\t<td><b>Change</b></td>\t\n");
      out.write("\t\t\t\t<td><b>Expected</b></td>\n");
      out.write("\t\t\t\t<td><b>Bags</b></td>\n");
      out.write("\t\t\t\t<td colspan=\"2\"><b>Action</b></td>\t\n");
      out.write("\t\t\t</tr>\n");
      out.write("\t\t\t<tbody>\n");

      int i = 0, rowID = 0;
      while (mo.rs.next()) {
        i = 1;
        count++;
        divCount = count + "#";
        orderNo = mo.rs.getString("order_num");
        custCode = mo.rs.getString("custcode");
        custName = mo.rs.getString("custname");
        buildingNo = mo.rs.getString("building_no");
        block = mo.rs.getString("block");
        wing = mo.rs.getString("wing");
        building = mo.rs.getString("building");
        area = mo.rs.getString("area");
        orderDate = mo.rs.getString("order_date");
        lastModifiedDate = mo.rs.getString("lastmodifieddate");
        totalItems = mo.rs.getString("total_items");
        totalValueMrp = mo.rs.getString("total_value_mrp");
        totalValuePrice = mo.rs.getString("total_value");
        bagsNo = mo.rs.getString("bags");
        // System.out.println("bagsNo is:"+bagsNo);
        discountAmt = mo.rs.getString("discount_amt");
        advanceAmt = mo.rs.getString("advance_amt");
        balanceAmt = mo.rs.getString("balance_amt");
        changeAmt = mo.rs.getString("change_amt");
        paidAmt = mo.rs.getString("paid_amt");
        expectedAmt = mo.rs.getString("expected_amt");
        deliveryStaffName = mo.rs.getString("dstaff_name");
        statusCode = mo.rs.getString("status_code");

        delchgs = mo.rs.getString("other_charges");
        payment = mo.rs.getString("payment_type_desc");
        ord_comm_amt = df.format(mo.rs.getFloat("ord_comm_amt"));
        cnt = cnt + 1;
        // System.out.println("value of ord_comm_amt in jsp"+ord_comm_amt);
        // System.out.println("comm amt "+ord_comm_amt);

        out.write("      \t\n");
        out.write("\t\t\t<input type=\"hidden\" name=\"hcommAmt");
        out.print(cnt);
        out.write("\" value=\"");
        out.print(ord_comm_amt);
        out.write("\">\n");
        out.write("\t\t\t\n");
        out.write("  \t\t \t<tr id=\"row");
        out.print(rowID);
        out.write("\" class=\"");
        out.print(orderNo);
        out.write("\">\n");
        out.write("  \t\t \t\t<td align=\"center\" title=\"");
        out.print(mo.rs.getString(12));
        out.write(',');
        out.print(mo.rs.getString(13));
        out.print(mo.rs.getString(14));
        out.write(',');
        out.print(mo.rs.getString(15));
        out.write(',');
        out.print(mo.rs.getString(8));
        out.write('"');
        out.write('>');
        out.write('\n');

        out.println(area);

        out.write("    \n");
        out.write("     \t\t\t</td>\n");
        out.write("\t      \t\t\t<td id=\"orderNum");
        out.print(rowID);
        out.write("\" align=\"center\" title=\"");
        out.print(mo.rs.getString(12));
        out.write(',');
        out.print(mo.rs.getString(13));
        out.print(mo.rs.getString(14));
        out.write(',');
        out.print(mo.rs.getString(15));
        out.write(',');
        out.print(mo.rs.getString(8));
        out.write("\">\n");
        out.write("\t      \t\t\t<a href=\"Javascript:AddRow('");
        out.print(custName);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(orderNo);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(area);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(orderDate);
        out.write("',\n");
        out.write("\t      \t\t\t'");
        out.print(totalItems);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(totalValuePrice);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(advanceAmt);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(discountAmt);
        out.write("',\n");
        out.write("\t      \t\t\t'");
        out.print(balanceAmt);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(delchgs);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(adamt);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(payment);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(changeAmt);
        out.write("',\n");
        out.write("\t      \t\t\t'");
        out.print(expectedAmt);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(bagsNo);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(cnt);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(statusCode);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(ord_comm_amt);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(rowID);
        out.write("');\">\n");

        out.println(orderNo);

        out.write("\n");
        out.write("\t\t\t\t</td><td align=\"center\" >\t\n");

        out.println(custName);

        out.write("\n");
        out.write("\t\t\t\t</td><td align=\"center\" >\t\n");

        out.println(orderDate);

        out.write("       \t      \t\t      \t\t\t\t\t\t\t\n");
        out.write("\t      \t\t</td><td align=\"center\" >\n");

        out.println(totalItems);

        out.write("\n");
        out.write("\t      \t\t</td><td align=\"center\">\n");
        if (payment.equals("Credit")) {

          out.write("\t\n");
          out.write("\t\t\t\t<a href=\"ChangePaymentTypeForm.jsp?orderNo=");
          out.print(orderNo);
          out.write('"');
          out.write('>');
          out.write('\n');

          out.println(payment);

          out.write("\n");
          out.write("\t\t\t\t</a>\n");

        } else {
          out.println(payment);
        }

        out.write("\n");
        out.write("\t      \t\t</td><td align=\"center\" >\n");

        out.println(totalValuePrice);

        out.write("    \t\t\t\t\t\n");
        out.write("\t      \t\t</td><td align=\"center\" >\n");

        if (advanceAmt != null && discountAmt != null) {
          adamt = Double.parseDouble(advanceAmt) - Double.parseDouble(discountAmt);
        }
        out.println(adamt);

        out.write("\n");
        out.write("\t\t\t\t</td><td align=\"center\" >\n");

        out.println(delchgs);

        out.write("      \t\n");
        out.write("\t \t\t\t</td><td align=\"center\" >\n");

        out.println(balanceAmt);

        out.write("      \t\n");
        out.write("\t \t\t\t</td><td align=\"center\" id=\"change");
        out.print(rowID);
        out.write("\" >\n");

        out.println(changeAmt);

        out.write("      \t\n");
        out.write("\t \t\t\t</td><td align=\"center\" >\n");

        out.println(expectedAmt);

        out.write("      \t\n");
        out.write("\t \t\t\t</td><td align=\"center\" id=\"bag");
        out.print(rowID);
        out.write('"');
        out.write('>');
        out.write('\n');

        out.println(bagsNo);

        out.write("      \t\n");
        out.write("\t \t\t\t</td>\n");
        out.write("\t \t\t\t\n");
        out.write("\t \t\t\t<td align=\"center\" id=\"send");
        out.print(rowID);
        out.write("\">\n");
        out.write("\t  \t\t\t\t<a href=\"Javascript:AddRow('");
        out.print(custName);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(orderNo);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(area);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(orderDate);
        out.write("',\n");
        out.write("\t  \t\t\t\t'");
        out.print(totalItems);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(totalValuePrice);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(advanceAmt);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(discountAmt);
        out.write("',\n");
        out.write("\t  \t\t\t\t'");
        out.print(balanceAmt);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(delchgs);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(adamt);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(payment);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(changeAmt);
        out.write("',\n");
        out.write("\t  \t\t\t\t'");
        out.print(expectedAmt);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(bagsNo);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(cnt);
        out.write("',\n");
        out.write("\t  \t\t\t\t'");
        out.print(statusCode);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(ord_comm_amt);
        out.write('\'');
        out.write(',');
        out.write('\'');
        out.print(rowID);
        out.write("');\">\n");
        out.write("\t  \t\t\t\t\n");

        out.println("Send");

        out.write("\t\t\t\t\n");
        out.write("\t\t\t\t</td><td align=\"center\" id=\"TA");
        out.print(rowID);
        out.write("\">\n");
        out.write("\t\t\t\t<a href=\"DeliveryDetailsForm.jsp?orderNo=");
        out.print(orderNo);
        out.write("&subValue=");
        out.print(statusCode);
        out.write("\" title=\"");
        out.print(mo.rs.getString(12));
        out.write(',');
        out.print(mo.rs.getString(13));
        out.print(mo.rs.getString(14));
        out.write(',');
        out.print(mo.rs.getString(15));
        out.write(',');
        out.print(mo.rs.getString(8));
        out.write("\" >\n");

        out.println("T.A.");

        if (divId == 0) {
          orderNoArr = orderNo;
          commArray = orderNo + "|" + ord_comm_amt;

        } else {
          orderNoArr = orderNoArr + "|" + orderNo;
          commArray = commArray + "|" + orderNo + "|" + ord_comm_amt;
        }
        divId++;
        rowID++;

        out.write("\n");
        out.write("\t \t  </a></td><td style=\"display: none;\">\n");
        out.write("\t \t  ");
        out.print(ord_comm_amt);
        out.write("\t\n");
        out.write("\t \t  </td>\n");
        out.write("\t \t  </tr>\n");
        out.write("\t \t  ");
      }
      mo.getcoininfo();
      while (mo.rs2.next()) {
        coinArray = coinArray + "|" + mo.rs2.getString(1);
      }

      mo.closeAll();
      System.out.println("\n\n row ID " + rowID);

      out.write("\n");
      out.write("               \n");
      out.write("</tbody>\n");
      out.write("\n");
      out.write("<input type=\"hidden\" name=\"horderArray\">\n");
      out.write("<input type=\"hidden\" name=\"hcommArray\"  value=\"");
      out.print(commArray);
      out.write("\">\n");
      out.write("<input type=\"hidden\" name=\"hcoinArray\" value=\"");
      out.print(coinArray);
      out.write("\">\n");
      out.write("<input type=\"hidden\" name=\"horderArr\" value=\"");
      out.print(orderNoArr);
      out.write("\">\t\n");
      out.write("<input type=\"hidden\" name=\"hchangeArray\" value=\"\">\t\t\n");
      out.write("<input type=\"hidden\" name=\"hcountorder\" value=\"");
      out.print(count);
      out.write("\">\t\n");
      out.write("\t\n");
      out.write("\t\n");
      out.write("<input type=\"hidden\" name=\"htotalchangeamt\" value=\"\">\n");
      out.write("<input type=\"hidden\" name=\"htotalordercnt\" value=\"\">\n");
      out.write("<input type=\"hidden\" name=\"htotalpaidamt\" value=\"\">\t\t\n");
      out.write("</table>\t  \n");
      out.write("\n");
      out.write("\n");
      out.write("\t      \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, 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);
    }
  }
Example #3
0
  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; charset=utf-8");
      pageContext = _jspxFactory.getPageContext(this, request, response, null, true, 8192, true);
      _jspx_page_context = pageContext;
      application = pageContext.getServletContext();
      config = pageContext.getServletConfig();
      session = pageContext.getSession();
      out = pageContext.getOut();
      _jspx_out = out;

      out.write("\r\n");
      out.write("\r\n");
      out.write("\r\n");

      // エンコーディング
      response.setContentType("text/html; charset=utf-8");
      request.setCharacterEncoding("utf-8");
      DecimalFormat exFormat = new DecimalFormat("#,###,###,##0");

      Bean bean = new Bean();
      String searchitem = null;
      String searchcategory = null;

      if ((request.getAttribute("searchitem")) != null) {
        bean = (Bean) request.getAttribute("searchitem");
        searchitem = bean.getSearchitem();
      }

      if ((request.getAttribute("searchcategory")) != null) {
        bean = (Bean) request.getAttribute("searchcategory");
        searchcategory = bean.getSearchcategory();
      }

      out.write("\r\n");
      out.write("\r\n");

      if (session.getAttribute("login") == null) {
        response.sendRedirect("/toranoan/logout.jsp");
      }

      out.write("\r\n");
      out.write("\r\n");
      out.write("<html>\r\n");
      out.write("<head>\r\n");
      out.write("\t<title>出前出張サービス◆虎乃庵◆</title>\r\n");
      out.write(
          "\t<script type=\"text/javascript\" src=\"/toranoan/jquery-1.11.1.js\"></script>\r\n");
      out.write(
          "\t<script type=\"text/javascript\" src=\"/toranoan/jquery.validate.min.js\"></script>\r\n");
      out.write(
          "\t<script type=\"text/javascript\" src=\"/toranoan/controlledjquery.js\"></script>\r\n");
      out.write("<!-- <script src=\"http://code.jquery.com/jquery-1.11.1.min.js\"></script>\r\n");
      out.write(
          "\t <script src=\"http://jqueryvalidation.org/files/dist/jquery.validate.min.js\"></script> -->\r\n");
      out.write("<!-- <script type=\"text/javascript\">\r\n");
      out.write("\t\t$( \"#btn_sub\" ).validate({\r\n");
      out.write("\t\t  rules: {\r\n");
      out.write("\t\t    number: {\r\n");
      out.write("\t\t      // required: true,\r\n");
      out.write("\t\t      number: true\r\n");
      out.write("\t\t    }\r\n");
      out.write("\t\t  }\r\n");
      out.write("\t\t});\r\n");
      out.write("\t</script> -->\r\n");
      out.write("</head>\r\n");
      out.write("<body>\r\n");
      out.write(
          "<form action=\"logout\" method=\"POST\" name=\"logout\" id=\"submitform_logout\">\r\n");
      out.write("\t<input type=\"button\" value=\"ログアウト\" id=\"btn_logout\">\r\n");
      out.write("</form>\r\n");
      out.write("<h1>虎乃庵</h1>\r\n");
      out.write(
          "<form action=\"search\" method=\"GET\" name=\"search\"  id=\"submitform_search\">\r\n");
      out.write("\t<table>\r\n");
      out.write("\t\t<tr>\r\n");
      out.write("\t\t\t<td>お品書き</td>\r\n");
      out.write("\t\t\t<td><input type=\"text\" name=\"searchitem\" size=\"40\"></td>\r\n");
      out.write("\t\t</tr>\r\n");
      out.write("\t\t<tr>\r\n");
      out.write("\t\t\t<td>カテゴリ</td>\r\n");
      out.write("\t\t\t<td>\r\n");
      out.write("\t\t\t<input type=\"radio\" name=\"searchcategory\" value=\"そば\">そば\r\n");
      out.write("\t\t\t<input type=\"radio\" name=\"searchcategory\" value=\"うどん\">うどん\r\n");
      out.write("\t\t\t<input type=\"radio\" name=\"searchcategory\" value=\"飲み物\">飲み物\r\n");
      out.write("\t\t\t</td>\r\n");
      out.write("\t\t</tr>\r\n");
      out.write("\t</table>\r\n");
      out.write("\t<br>\r\n");
      out.write("\t<input type=\"button\" value=\"検索\" id=\"btn_search\">\r\n");
      out.write("</form>\r\n");
      out.write("<div id=\"loading\"></div>\r\n");
      out.write("<div id=\"result\"></div>\r\n");
      out.write("\r\n");
      out.write("<!-- ");

      if (searchitem == null && searchcategory == null) {
        searchitem = "指定なし";
        searchcategory = "指定なし";
      } else {
        if ("".equals(searchitem)) {
          if (searchcategory == null) {
            searchitem = "指定なし";
            searchcategory = "指定なし";
          } else {
            searchitem = "指定なし";
          }
        } else {
          if (searchcategory == null) {
            searchcategory = "指定なし";
          } else {
          }
        }

        out.write("\r\n");
        out.write("<br>\r\n");
        out.write("<h2>検索結果</h2>\r\n");
        out.write("----------------------------------------\r\n");
        out.write("<table>\r\n");
        out.write("\t<tr>\r\n");
        out.write("\t\t<td align=\"center\">");
        out.print("検索ワード: ");
        out.write("</td>\r\n");
        out.write("\t\t<td>");
        out.print(searchitem);
        out.write("</td>\r\n");
        out.write("\t</tr>\r\n");
        out.write("\t<tr>\r\n");
        out.write("\t\t<td align=\"center\">");
        out.print("カテゴリ: ");
        out.write("</td>\r\n");
        out.write("\t\t<td>");
        out.print(searchcategory);
        out.write("</td>\r\n");
        out.write("\t</tr>\r\n");
        out.write("</table>\r\n");
        out.write("----------------------------------------\r\n");
        out.write("<br>\r\n");
        out.write(
            "<form action=\"order\" method=\"POST\" name=\"order\" id=\"submitform_order\">\r\n");
        out.write(
            "\t<table border=\"1\" cellspacing=\"0\" cellpadding=\"5\" bordercolor=\"#333333\">\r\n");
        out.write("\t\t<tr bgcolor=\"#EE0000\">\r\n");
        out.write("\t\t\t<th><font color=\"#FFFFFF\">メニュー</font></th>\r\n");
        out.write("\t\t\t<th><font color=\"#FFFFFF\">値段</font></th>\r\n");
        out.write("\t\t\t<th><font color=\"#FFFFFF\">カテゴリー</font></th>\r\n");
        out.write("\t\t\t<th><font color=\"#FFFFFF\">温・冷</font></th>\r\n");
        out.write("\t\t\t<th><font color=\"#FFFFFF\">数量</font></th>\r\n");
        out.write("\t\t</tr>\r\n");

        List resultlist = (List) session.getAttribute("itemresult");
        for (int i = 0; i < resultlist.size(); i++) {

          out.write("\r\n");
          out.write("\t\t<tr>\r\n");

          Bean s = (Bean) resultlist.get(i);
          out.println(
              "<td>"
                  + s.getItem()
                  + "</td> <td align=\"right\">\\"
                  + exFormat.format(s.getPrice())
                  + "</td> <td align=\"center\">"
                  + s.getCategory()
                  + "</td> <td align=\"center\">"
                  + s.getHotcold()
                  + "</td><td><input type=\"number\" min=\"0\" name=\""
                  + s.getId()
                  + "_"
                  + s.getItem()
                  + "_"
                  + s.getPrice()
                  + "\"></td>");
        }

        out.write("\r\n");
        out.write("\t\t</tr>\r\n");
        out.write("\t</table>\r\n");
        out.write("\t<input type=\"button\" value=\"注文\" id=\"btn_order\">\r\n");
        out.write("</form>\r\n");
        out.write("<form action=\"./order.jsp\" method=\"GET\" id=\"submitform_check\">\r\n");
        out.write("\t\t<input type=\"button\" value=\"確認画面へ\" id=\"btn_check\">\r\n");
        out.write("</form>\r\n");
      }

      out.write(" -->\r\n");
      out.write("</body>\r\n");
      out.write("</html>");
    } 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);
    }
  }