jsps with html

gayatridevi · #1 (**permalink**) 12-19-2007, 12:06 PM

<%@ page import="java.io.IOException,java.net.URLDecoder,ja va.sql.SQLException,com.knowgate.jdc.*,com.knowgat e.dataobjs.*,com.knowgate.acl.*,com.knowgate.hiper gate.*,com.knowgate.crm.*" language="java" session="false" contentType="text/html;charset=UTF-8" %>
<jsp:useBean id="GlobalCacheClient" scope="application" class="com.knowgate.cache.DistributedCachePeer"/>
<%@ include file="../methods/dbbind.jsp" %><%@ include file="../methods/cookies.jspf" %><%@ include file="../methods/authusrs.jspf" %><%@ include file="../methods/clientip.jspf" %><%@ include file="../methods/nullif.jspf" %><%

if (autenticateSession(GlobalDBBind, request, response)<0) return;

response.addHeader ("Pragma", "no-cache");
response.addHeader ("cache-control", "no-store");
response.setIntHeader("Expires", 0);

String sSkin = getCookie(request, "skin", "xp");
String sLanguage = getNavigatorLanguage(request);
int iAppMask = Integer.parseInt(getCookie(request, "appmask", "0"));

String id_domain = request.getParameter("id_domain");
String gu_workarea = request.getParameter("gu_workarea");
String gu_order = nullif(request.getParameter("gu_order"));

String sLocationLookUp="", sStatusLookUp="", sPaymentLookUp="", sShipingLookUp="", sBillingLookUp="", sCardsLookUp="";

Order oOrdr = new Order();
int iShops = 0;
DBSubset oShops = new DBSubset(DB.k_shops, DB.gu_shop + "," + DB.nm_shop + "," + DB.gu_root_cat, DB.gu_workarea + "=? AND " + DB.bo_active + "=1", 10);
DBSubset oLines = null;
DBSubset oAddrs = null;
String sAddrs = "<OPTION VALUE=\"\"></OPTION>";
int iLines = 0;

JDCConnection oConn = null;

boolean bIsGuest = true;

try {

bIsGuest = isDomainGuest (GlobalCacheClient, GlobalDBBind, request, response);

oConn = GlobalDBBind.getConnection("order_edit");

if (gu_order.length()>0) {
oOrdr.load (oConn, new Object[]{gu_order});
oLines = oOrdr.getLines(oConn);
iLines = oLines.getRowCount();

if (!oOrdr.isNull(DB.gu_contact))
oAddrs = new Contact(oOrdr.getString(DB.gu_contact)).getAddress es(oConn);
else if (!oOrdr.isNull(DB.gu_company))
oAddrs = new Company(oOrdr.getString(DB.gu_company)).getAddress es(oConn);

if (null!=oAddrs)
for (int a=0; a<oAddrs.getRowCount(); a++)
sAddrs += "<OPTION VALUE=\"" + oAddrs.getString(DB.gu_address,a) + "\">" + oAddrs.getStringNull(DB.nm_street,a,"") + " " + oAddrs.getStringNull(DB.nu_street,a,"") + " (" + oAddrs.getStringNull(DB.mn_city,a,"") + ")</OPTION>";

} // fi (gu_order!="")

iShops = oShops.load(oConn, new Object[]{gu_workarea});

sLocationLookUp= DBLanguages.getHTMLSelectLookUp (GlobalCacheClient, oConn, DB.k_orders_lookup, gu_workarea, DB.tx_location, sLanguage);
sStatusLookUp = DBLanguages.getHTMLSelectLookUp (GlobalCacheClient, oConn, DB.k_orders_lookup, gu_workarea, DB.id_status, sLanguage);
sPaymentLookUp = DBLanguages.getHTMLSelectLookUp (GlobalCacheClient, oConn, DB.k_orders_lookup, gu_workarea, DB.id_pay_status, sLanguage);
sShipingLookUp = DBLanguages.getHTMLSelectLookUp (GlobalCacheClient, oConn, DB.k_orders_lookup, gu_workarea, DB.id_ship_method, sLanguage);
sBillingLookUp = DBLanguages.getHTMLSelectLookUp (GlobalCacheClient, oConn, DB.k_orders_lookup, gu_workarea, DB.tp_billing, sLanguage);
sCardsLookUp = DBLanguages.getHTMLSelectLookUp (GlobalCacheClient, oConn, DB.k_orders_lookup, gu_workarea, DB.tp_card, sLanguage);

oConn.close("order_edit");
}
catch (SQLException e) {
if (oConn!=null)
if (!oConn.isClosed()) oConn.close("order_edit");
response.sendRedirect (response.encodeRedirectUrl ("../common/errmsg.jsp?title=Error&desc=" + e.getLocalizedMessage() + "&resume=_close"));
}
oConn = null;
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML LANG="<% out.write(sLanguage); %>">
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
<TITLE>hipergate;;;;;;;;;;;;;;;;; :: Edit Orderrrrrrrrrrrrrrrrrrr</TITLE>
<SCRIPT LANGUAGE="JavaScript" SRC="../javascript/cookies.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript" SRC="../javascript/setskin.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript" SRC="../javascript/getparam.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript" SRC="../javascript/usrlang.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript" SRC="../javascript/combobox.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript" SRC="../javascript/trim.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript" SRC="../javascript/datefuncs.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript" SRC="../javascript/layer.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript" SRC="../javascript/grid.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript" SRC="../javascript/simplevalidations.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript" DEFER="defer">

</SCRIPT>
<SCRIPT LANGUAGE="JavaScript1.2" TYPE="text/javascript">

</SCRIPT>
</HEAD>
<BODY TOPMARGIN="8" MARGINHEIGHT="8" onLoad="setCombos()">
<% if (gu_order.length()>0) { %>
<DIV class="cxMnu1" style="width:340px"><DIV class="cxMnu2">
<SPAN class="hmMnuOff" onMouseOver="this.className='hmMnuOn'" onMouseOut="this.className='hmMnuOff'" onClick="location.reload(true)"><IMG src="../images/images/toolmenu/locationreload.gif" width="16" style="vertical-align:middle" height="16" border="0" alt="Update"> Update</SPAN>
<SPAN class="hmMnuOff" onMouseOver="this.className='hmMnuOn'" onMouseOut="this.className='hmMnuOff'" onClick="window.print()"><IMG src="../images/images/toolmenu/windowprint.gif" width="16" height="16" style="vertical-align:middle" border="0" alt="Print"> Print</SPAN>
<SPAN class="hmMnuOff" onMouseOver="this.className='hmMnuOn'" onMouseOut="this.className='hmMnuOff'" onClick="top.location='order_preview.jsp?gu_order= <%=gu_order%>'"><IMG src="../images/images/viewtxt.gif" width="16" height="16" style="vertical-align:middle" border="0" alt="Preview"> Preview</SPAN>
</DIV></DIV>
<% } %>
<TABLE WIDTH="100%">
<TR><TD><IMG SRC="../images/images/spacer.gif" HEIGHT="4" WIDTH="1" BORDER="0"></TD></TR>
<TR><TD CLASS="striptitle"><FONT CLASS="title1">Edit Order <% if (!oOrdr.isNull(DB.pg_order)) out.write(String.valueOf(oOrdr.getInt(DB.pg_order) )); %></FONT></TD></TR>
</TABLE>
<DIV ID="dek" STYLE="width:200;height:20;z-index:200;visibility:hidden;position:absolute"></DIV>
<SCRIPT LANGUAGE="JavaScript1.2" SRC="../javascript/popover.js"></SCRIPT>
<FORM METHOD="post" ACTION="order_edit_store.jsp" onSubmit="return validate()">
<INPUT TYPE="hidden" NAME="id_domain" VALUE="<%=id_domain%>">
<INPUT TYPE="hidden" NAME="gu_workarea" VALUE="<%=gu_workarea%>">
<INPUT TYPE="hidden" NAME="gu_order" VALUE="<%=gu_order%>">
<INPUT TYPE="hidden" NAME="pg_order" VALUE="<% if (!oOrdr.isNull(DB.pg_order)) out.write(String.valueOf(oOrdr.getInt(DB.pg_order) )); %>">
<INPUT TYPE="hidden" NAME="bo_active" VALUE="<% if (oOrdr.isNull(DB.bo_active)) out.write("1"); else out.write(String.valueOf(oOrdr.getShort(DB.bo_acti ve))); %>">

<INPUT TYPE="hidden" NAME="id_currency" VALUE="">
<INPUT TYPE="hidden" NAME="tx_lines" VALUE="">
<INPUT TYPE="hidden" NAME="gu_shop">

<TABLE CLASS="formback">
<TR><TD>
<TABLE WIDTH="100%" CLASS="formfront">
<TR>
<TD ALIGN="right" WIDTH="120"><FONT CLASS="formstrong">Description:</FONT></TD>
<TD ALIGN="left" WIDTH="370"><INPUT TYPE="text" NAME="de_order" MAXLENGTH="100" SIZE="70" VALUE="<% out.write(oOrdr.getStringNull(DB.de_order,"")); %>"></TD>
</TR>
<TR>
<TD ALIGN="right" WIDTH="120"><FONT CLASS="formstrong">Client:</FONT></TD>
<TD ALIGN="left" WIDTH="560">
<INPUT TYPE="text" NAME="nm_client" MAXLENGTH="200" SIZE="40" VALUE="<% out.write(oOrdr.getStringNull("nm_client","")); %>" onchange="completeClient()" onkeypress="document.forms[0].gu_company.value='';document.forms[0].gu_contact.value='';document.images['clientwarning'].src = '../images/images/warn16.gif'"><SPAN onmouseover="if (document.forms[0].gu_company.value.length==0 && document.forms[0].gu_contact.value.length==0) popover('Must specify a valid name of Company or Individual'); else popover('View customer data');" onmouseout="popout()"><A HREF="#" onclick="viewClient()"><IMG NAME="clientwarning" ID="clientwarning" HSPACE="2" SRC="../images/images/spacer.gif" WIDTH="16" HEIGHT="16" BORDER="0"></A></SPAN>  <A HREF="#" CLASS="linkplain" onclick="reference(7)" ACCESSKEY="p" TITLE="ALT+p">View Companies</A>  <A HREF="#" CLASS="linkplain" onclick="reference(8)" ACCESSKEY="i" TITLE="ALT+i">View Individuals</A>
<INPUT TYPE="hidden" NAME="gu_company" VALUE="<% out.write(oOrdr.getStringNull(DB.gu_company,"")); %>">
<INPUT TYPE="hidden" NAME="gu_contact" VALUE="<% out.write(oOrdr.getStringNull(DB.gu_contact,"")); %>">
</TD>
</TR>
<TR>
<TD ALIGN="right" WIDTH="120"></TD>
<TD ALIGN="left" WIDTH="370"><INPUT TYPE="text" NAME="id_legal" MAXLENGTH="16" SIZE="16" VALUE="<% out.write(oOrdr.getStringNull(DB.id_legal,"")); %>" onchange="completeLegalId()"> <FONT CLASS="formplain">Legal Id.</FONT></TD>
</TR>

<TR>
<TD ALIGN="right" WIDTH="120"><FONT CLASS="formplain">Reference:</FONT></TD>
<TD ALIGN="left" WIDTH="370">
<INPUT TYPE="text" NAME="id_ref" MAXLENGTH="50" SIZE="20" VALUE="<% out.write(oOrdr.getStringNull(DB.id_ref,"")); %>">
    <FONT CLASS="formplain">Catalog</FONT><SELECT NAME="sel_shop"><% for (int s=0; s<iShops; s++) out.write("<OPTION VALUE=\"" + oShops.getString(0,s) + "\">" + oShops.getString(1,s) + "</OPTION>"); %></SELECT>
</TD>
</TR>
<TR>
<TD ALIGN="right" WIDTH="120"><FONT CLASS="formplain">Subsidiary</FONT></TD>
<TD ALIGN="left" WIDTH="560">
<INPUT TYPE="hidden" NAME="tx_location">
<SELECT NAME="sel_location" STYLE="width:300px"><OPTION VALUE=""></OPTION><% out.write(sLocationLookUp); %></SELECT> 
<A HREF="javascript:lookup(1)"><IMG SRC="../images/images/find16.gif" HEIGHT="16" BORDER="0" ALT="View Subsidiaries List"></A>
</TD>
</TR>
<TR>
<TD ALIGN="right" CLASS="strip1"><A HREF="#" CLASS="linkplain" ACCESSKEY="t" TITLE="ALT+t" onclick="listAllProducts()">List All</A></TD>
<TD CLASS="strip1"><SELECT NAME="sel_product" STYLE="width:300px" ondblclick="addProduct()"></SELECT><INPUT TYPE="text" NAME="nm_product" MAXLENGTH="100" SIZE="25"> <A HREF="#" CLASS="linkplain" ACCESSKEY="l" TITLE="ALT+l" onclick="seekProducts()">Search</A></TD>
</TR>
<TR>
<TD CLASS="strip1" VALIGN="top" ALIGN="right">
<A HREF="#" CLASS="linkplain" ACCESSKEY="a" TITLE="ALT+a" onclick="addProduct()">Add Product</A>
<BR>
<A HREF="#" CLASS="linkplain" ACCESSKEY="n" TITLE="ALT+n" onclick="createProduct()">New Product</A>
</TD>
<TD CLASS="strip1"><DIV ID="orderlines"></DIV></TD>
</TR>
<TR>
<TD ALIGN="right" WIDTH="120"><FONT CLASS="formplain">Shipping Costs:</FONT></TD>
<TD ALIGN="left" WIDTH="560">
<INPUT TYPE="text" NAME="im_shipping" VALUE="<% if (!oOrdr.isNull(DB.im_shipping)) out.write(oOrdr.getDecimal(DB.im_shipping).toStrin g()); %>" MAXLENGTH="7" SIZE="7" onchange="computeTotal()">
   
<FONT CLASS="formplain">Discount:</FONT>
<INPUT TYPE="text" NAME="im_discount" VALUE="<% if (!oOrdr.isNull(DB.im_discount)) out.write(oOrdr.getDecimal(DB.im_discount).toStrin g()); %>" MAXLENGTH="7" SIZE="7" onchange="computeTotal()">
   
<FONT CLASS="formplain">Taxes:</FONT>
<INPUT TYPE="text" NAME="im_taxes" VALUE="<% if (!oOrdr.isNull(DB.im_taxes)) out.write(oOrdr.getDecimal(DB.im_taxes).toString() ); %>" MAXLENGTH="7" SIZE="7" onchange="computeTotal()">
   
<FONT CLASS="formstrong">Total:</FONT>
<INPUT TYPE="text" NAME="im_total" MAXLENGTH="10" SIZE="10">
<A HREF="#" onclick="computeTotal()" ACCESSKEY="r" TITLE="Recalcular [ALT+r]"><IMG SRC="../images/images/calc16.gif" HSPACE="2" WIDTH="16" HEIGHT="12" BORDER="0" ALT="Recalculate [ALT+r]"></A>
</TD>
</TR>

<TR>
<TD ALIGN="right" WIDTH="120"><FONT CLASS="formplain">Status:</FONT></TD>
<TD ALIGN="left" WIDTH="560">
<INPUT TYPE="hidden" NAME="id_status">
<TABLE WIDTH="100%">
<TR>
<TD WIDTH="40%">
<SELECT NAME="sel_status"><OPTION VALUE=""></OPTION><% out.write(sStatusLookUp); %></SELECT> 
<A HREF="javascript:lookup(2)"><IMG SRC="../images/images/find16.gif" HEIGHT="16" BORDER="0" ALT="Edit Status List"></A>
</TD>
<TD WIDTH="60%">
<FONT CLASS="formplain">Shipment Method:</FONT>
<INPUT TYPE="hidden" NAME="id_ship_method">
<SELECT NAME="sel_ship_method"><OPTION VALUE=""></OPTION><% out.write(sShipingLookUp); %></SELECT> 
<A HREF="javascript:lookup(4)"><IMG SRC="../images/images/find16.gif" HEIGHT="16" BORDER="0" ALT="Edit Shiping Methods"></A>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<TR>
<TD ALIGN="right" WIDTH="120"><FONT CLASS="formplain">Send Address</FONT></TD>
<TD ALIGN="left" WIDTH="560">
<INPUT TYPE="hidden" NAME="gu_ship_addr">
<SELECT NAME="sel_ship_addr"><% out.write (sAddrs); %></SELECT> <A HREF="#" onclick="createAddress()" TITLE="New Address" ACCESSKEY="d"><IMG SRC="../images/images/new16x16.gif" WIDTH="16" HEIGHT="16" BORDER="0" ALT="New Address"></A>
</TD>
</TR>
<TR>
<TD ALIGN="right" WIDTH="120"><FONT CLASS="formplain">Billing Address</FONT></TD>
<TD ALIGN="left" WIDTH="560">
<INPUT TYPE="hidden" NAME="gu_bill_addr">
<SELECT NAME="sel_bill_addr"><% out.write (sAddrs); %></SELECT> <A HREF="#" onclick="createAddress()" TITLE="New Address"><IMG SRC="../images/images/new16x16.gif" WIDTH="16" HEIGHT="16" BORDER="0" ALT="New Address"></A>
</TD>
</TR>
<TR>
<TD ALIGN="right" WIDTH="120"><FONT CLASS="formplain">Delivery Notes:</FONT></TD>
<TD ALIGN="left" WIDTH="560">
<TEXTAREA CLASS="textplain" NAME="tx_ship_notes" ROWS="2" COLS="80"></TEXTAREA>
</TD>
</TR>
<TR>
<TD ALIGN="right" WIDTH="120"><FONT CLASS="formplain">Payment Method:</FONT></TD>
<TD ALIGN="left" WIDTH="560">
<INPUT TYPE="hidden" NAME="tp_billing">
<SELECT NAME="sel_billing"><OPTION VALUE=""></OPTION><% out.write(sBillingLookUp); %></SELECT> 
<A HREF="javascript:lookup(5)"><IMG SRC="../images/images/find16.gif" HEIGHT="16" BORDER="0" ALT="Edit payment methods"></A>
</TD>
</TR>
<TR>
<TD ALIGN="right" WIDTH="120"><FONT CLASS="formplain">Paydate:</FONT></TD>
<TD ALIGN="left" WIDTH="560">
<TABLE WIDTH="100%">
<TR>
<TD WIDTH="40%">
<INPUT TYPE="hidden" NAME="id_pay_status">
<SELECT NAME="sel_pay_status"><OPTION VALUE=""></OPTION><% out.write(sPaymentLookUp); %></SELECT> 
<A HREF="javascript:lookup(3)"><IMG SRC="../images/images/find16.gif" HEIGHT="16" BORDER="0" ALT="Edit Payment Status"></A>
</TD>
<TD WIDTH="60%">
<FONT CLASS="formplain">Due Date:</FONT>
 
<INPUT TYPE="text" NAME="dt_payment" MAXLENGTH="10" SIZE="10" VALUE="<% if (!oOrdr.isNull(DB.dt_payment)) out.write(oOrdr.getDateFormated(DB.dt_payment, "yyyy-MM-dd")); %>">
<A HREF="javascript:showCalendar('dt_payment')"><IMG SRC="../images/images/datetime16.gif" WIDTH="16" HEIGHT="16" BORDER="0" ALT="Show Calendar"></A>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<TR>
<TD ALIGN="right" WIDTH="120"><FONT CLASS="formplain">Bank Account:</FONT></TD>
<TD ALIGN="left" WIDTH="560">
<INPUT TYPE="text" NAME="nu_bank" MAXLENGTH="20" SIZE="32" VALUE="<% out.write(oOrdr.getStringNull(DB.nu_bank,"")); %>" onkeypress="return acceptOnlyNumbers();">
   
<FONT CLASS="formplain">Heading:</FONT>
<INPUT TYPE="text" NAME="nm_cardholder" MAXLENGTH="100" SIZE="36" VALUE="<% out.write(oOrdr.getStringNull("nm_cardholder","")) ; %>">
</TD>
</TR>
<TR>
<TD ALIGN="right" WIDTH="120"><FONT CLASS="formplain">Card Type:</FONT></TD>
<TD ALIGN="left" WIDTH="560">
<INPUT TYPE="hidden" NAME="tp_card">
<SELECT NAME="sel_card"><OPTION VALUE=""></OPTION><% out.write(sCardsLookUp); %></SELECT> 
<A HREF="javascript:lookup(6)"><IMG SRC="../images/images/find16.gif" HEIGHT="16" BORDER="0" ALT="Edit payment methods"></A>
   
<FONT CLASS="formplain">Num</FONT> <INPUT TYPE="text" NAME="nu_card" MAXLENGTH="16" SIZE="17" onkeypress="return acceptOnlyNumbers();">
  
<FONT CLASS="formplain">Expires:</FONT>
<INPUT TYPE="hidden" NAME="tx_expire">
<SELECT NAME="sel_month"><OPTION VALUE=""></OPTION><OPTION VALUE="01">01</OPTION><OPTION VALUE="02">02</OPTION><OPTION VALUE="03">03</OPTION><OPTION VALUE="04">04</OPTION><OPTION VALUE="05">05</OPTION><OPTION VALUE="06">06</OPTION><OPTION VALUE="07">07</OPTION><OPTION VALUE="08">08</OPTION><OPTION VALUE="09">09</OPTION><OPTION VALUE="10">10</OPTION><OPTION VALUE="11">11</OPTION><OPTION VALUE="12">12</OPTION></SELECT>
<SELECT NAME="sel_year"><OPTION VALUE=""></OPTION><OPTION VALUE="2003">2003</OPTION><OPTION VALUE="2004">2004</OPTION><OPTION VALUE="2005">2005</OPTION><OPTION VALUE="2006">2006</OPTION><OPTION VALUE="2007">2007</OPTION><OPTION VALUE="2008">2008</OPTION><OPTION VALUE="2009">2009</OPTION><OPTION VALUE="2010">2010</OPTION></SELECT>
</TD>
</TR>
<TR>
<TD ALIGN="right" WIDTH="120"><FONT CLASS="formplain">Comments:</FONT></TD>
<TD ALIGN="left" WIDTH="560">
<TEXTAREA CLASS="textplain" NAME="tx_comments" ROWS="2" COLS="80"></TEXTAREA>
</TD>
</TR>
<TR>
<TD COLSPAN="2"><HR></TD>
</TR>
<TR>
<TD COLSPAN="2" ALIGN="center">
<% if (bIsGuest) { %>
<INPUT TYPE="button" ACCESSKEY="s" VALUE="Save" CLASS="pushbutton" STYLE="width:80" TITLE="ALT+s" onclick="alert('Your credential level as Guest does not allow you to perform this action')">
<% } else { %>
<INPUT TYPE="submit" ACCESSKEY="s" VALUE="Save" CLASS="pushbutton" STYLE="width:80" TITLE="ALT+s">
<% } %>
   <INPUT TYPE="button" ACCESSKEY="c" VALUE="Cancel" CLASS="closebutton" STYLE="width:80" TITLE="ALT+c" onclick="window.parent.close()">
<BR><BR>
</TD>
</TABLE>
</TD></TR>
</TABLE>
</FORM>
</BODY>
</HTML>

this is my page. in this

<TITLE>hipergate;;;;;;;;;;;;;;;;; :: Edit Orderrrrrrrrrrrrrrrrrrr</TITLE>

if any changes i did those are not reflected in the application. what happened i cant understand. In my application all pages r reflected with their changes. this page only gives the problem. actually what happened. any one understand this problem. pls keep the reply.