public void _jspService(
javax.servlet.http.HttpServletRequest request,
javax.servlet.http.HttpServletResponse response)
throws java.io.IOException, javax.servlet.ServletException {
javax.servlet.http.HttpSession session = request.getSession(true);
com.caucho.server.webapp.WebApp _jsp_application = _caucho_getApplication();
com.caucho.jsp.PageContextImpl pageContext =
_jsp_pageManager.allocatePageContext(
this, _jsp_application, request, response, null, session, 8192, true, false);
TagState _jsp_state = null;
try {
_jspService(request, response, pageContext, _jsp_application, session, _jsp_state);
} catch (java.lang.Throwable _jsp_e) {
pageContext.handlePageException(_jsp_e);
} finally {
_jsp_pageManager.freePageContext(pageContext);
}
}
private void _jspService(
javax.servlet.http.HttpServletRequest request,
javax.servlet.http.HttpServletResponse response,
com.caucho.jsp.PageContextImpl pageContext,
javax.servlet.ServletContext application,
javax.servlet.http.HttpSession session,
TagState _jsp_state)
throws Throwable {
javax.servlet.jsp.JspWriter out = pageContext.getOut();
final javax.el.ELContext _jsp_env = pageContext.getELContext();
javax.servlet.ServletConfig config = getServletConfig();
javax.servlet.Servlet page = this;
javax.servlet.jsp.tagext.JspTag _jsp_parent_tag = null;
com.caucho.jsp.PageContextImpl _jsp_parentContext = pageContext;
response.setContentType("text/html");
response.setCharacterEncoding("utf-8");
out.write(_jsp_string0, 0, _jsp_string0.length);
CP_Classes.EthnicGroup ethnic;
synchronized (pageContext.getSession()) {
ethnic = (CP_Classes.EthnicGroup) pageContext.getSession().getAttribute("ethnic");
if (ethnic == null) {
ethnic = new CP_Classes.EthnicGroup();
pageContext.getSession().setAttribute("ethnic", ethnic);
}
}
out.write(_jsp_string1, 0, _jsp_string1.length);
CP_Classes.Login logchk;
synchronized (pageContext.getSession()) {
logchk = (CP_Classes.Login) pageContext.getSession().getAttribute("logchk");
if (logchk == null) {
logchk = new CP_Classes.Login();
pageContext.getSession().setAttribute("logchk", logchk);
}
}
out.write(_jsp_string1, 0, _jsp_string1.length);
CP_Classes.Translate trans;
synchronized (pageContext.getSession()) {
trans = (CP_Classes.Translate) pageContext.getSession().getAttribute("trans");
if (trans == null) {
trans = new CP_Classes.Translate();
pageContext.getSession().setAttribute("trans", trans);
}
}
out.write(_jsp_string1, 0, _jsp_string1.length);
// added to check whether organisation is a consulting company
// Mark Oei 09 Mar 2010
out.write(_jsp_string1, 0, _jsp_string1.length);
CP_Classes.Organization Org;
synchronized (pageContext.getSession()) {
Org = (CP_Classes.Organization) pageContext.getSession().getAttribute("Org");
if (Org == null) {
Org = new CP_Classes.Organization();
pageContext.getSession().setAttribute("Org", Org);
}
}
out.write(_jsp_string1, 0, _jsp_string1.length);
CP_Classes.Create_Edit_Survey CE_Survey;
synchronized (pageContext.getSession()) {
CE_Survey =
(CP_Classes.Create_Edit_Survey) pageContext.getSession().getAttribute("CE_Survey");
if (CE_Survey == null) {
CE_Survey = new CP_Classes.Create_Edit_Survey();
pageContext.getSession().setAttribute("CE_Survey", CE_Survey);
}
}
out.write(_jsp_string2, 0, _jsp_string2.length);
// by lydia Date 05/09/2008 Fix jsp file to support Thai language
out.write(_jsp_string3, 0, _jsp_string3.length);
out.print((trans.tslt("Delete Ethnic Group")));
out.write(_jsp_string4, 0, _jsp_string4.length);
out.print((trans.tslt("Edit Ethnic Group")));
out.write(_jsp_string5, 0, _jsp_string5.length);
out.print((trans.tslt("Please enter Ethnic Group")));
out.write(_jsp_string6, 0, _jsp_string6.length);
out.print((trans.tslt("Add Ethnic Group")));
out.write(_jsp_string7, 0, _jsp_string7.length);
out.print((trans.tslt("Please enter Ethnic Group")));
out.write(_jsp_string8, 0, _jsp_string8.length);
String username = (String) session.getAttribute("username");
if (!logchk.isUsable(username)) {
out.write(_jsp_string9, 0, _jsp_string9.length);
} else {
if (request.getParameter("proceed") != null) {
int PKOrg = new Integer(request.getParameter("proceed")).intValue();
logchk.setOrg(PKOrg);
}
if (request.getParameter("Delete") != null) {
int Ethnic_ID = new Integer(request.getParameter("ethnic_ID")).intValue();
boolean bIsDeleted = ethnic.deleteRecord(Ethnic_ID, logchk.getPKUser());
if (bIsDeleted) {
out.write(_jsp_string10, 0, _jsp_string10.length);
}
}
if (request.getParameter("Edit") != null) {
int Ethnic_ID = new Integer(request.getParameter("ethnic_ID")).intValue();
String txtEthnic = request.getParameter("txtEthnic");
boolean bIsEdited =
ethnic.editRecord(Ethnic_ID, txtEthnic, logchk.getOrg(), logchk.getPKUser());
if (bIsEdited) {
out.write(_jsp_string11, 0, _jsp_string11.length);
} else {
out.write(_jsp_string12, 0, _jsp_string12.length);
}
}
if (request.getParameter("Add") != null) {
String txtEthnic = request.getParameter("txtEthnic");
boolean bExist = ethnic.existRecord(txtEthnic, logchk.getOrg());
if (!bExist) {
boolean bIsAdded = ethnic.addRecord(txtEthnic, logchk.getOrg(), logchk.getPKUser());
if (bIsAdded) {
out.write(_jsp_string13, 0, _jsp_string13.length);
}
} else {
out.write(_jsp_string14, 0, _jsp_string14.length);
}
}
out.write(_jsp_string15, 0, _jsp_string15.length);
out.print((trans.tslt("Ethnic Group")));
out.write(_jsp_string16, 0, _jsp_string16.length);
out.print((trans.tslt("To Add, click on the Add button")));
out.write(_jsp_string17, 0, _jsp_string17.length);
out.print(
(trans.tslt("To Edit, click on the relevant radio button and click on the Edit button")));
out.write(_jsp_string17, 0, _jsp_string17.length);
out.print(
(trans.tslt(
"To Delete, click on the relevant radio button and click on the Delete button")));
out.write(_jsp_string18, 0, _jsp_string18.length);
out.print((trans.tslt("Organisation")));
out.write(_jsp_string19, 0, _jsp_string19.length);
// Added to check whether organisation is also a consulting company
// if yes, will display a dropdown list of organisation managed by this company
// else, it will display the current organisation only
// Mark Oei 09 Mar 2010
String[] UserDetail = new String[14];
UserDetail = CE_Survey.getUserDetail(logchk.getPKUser());
boolean isConsulting = true;
isConsulting =
Org.isConsulting(UserDetail[10]); // check whether organisation is a consulting company
if (isConsulting) {
Vector vOrg = logchk.getOrgList(logchk.getCompany());
for (int i = 0; i < vOrg.size(); i++) {
votblOrganization vo = (votblOrganization) vOrg.elementAt(i);
int PKOrg = vo.getPKOrganization();
String OrgName = vo.getOrganizationName();
if (logchk.getOrg() == PKOrg) {
out.write(_jsp_string20, 0, _jsp_string20.length);
out.print((PKOrg));
out.write(_jsp_string21, 0, _jsp_string21.length);
out.print((OrgName));
out.write(_jsp_string22, 0, _jsp_string22.length);
} else {
out.write(_jsp_string20, 0, _jsp_string20.length);
out.print((PKOrg));
out.write('>');
out.print((OrgName));
out.write(_jsp_string22, 0, _jsp_string22.length);
}
}
} else {
out.write(_jsp_string23, 0, _jsp_string23.length);
out.print((logchk.getSelfOrg()));
out.write('>');
out.print((UserDetail[10]));
out.write(_jsp_string24, 0, _jsp_string24.length);
} // End of isConsulting
out.write(_jsp_string25, 0, _jsp_string25.length);
out.print((trans.tslt("Ethnic Group")));
out.write(_jsp_string26, 0, _jsp_string26.length);
/** ****************** Edited by James 17 Oct 2007 ********************** */
Vector v = ethnic.getAllEthnics(logchk.getOrg());
for (int i = 0; i < v.size(); i++) {
voEthnic vo = (voEthnic) v.elementAt(i);
int ethnic_ID = vo.getPKEthnic();
String ethnic_Desc = vo.getEthnicDesc();
out.write(_jsp_string27, 0, _jsp_string27.length);
out.print((ethnic_ID));
out.write(_jsp_string28, 0, _jsp_string28.length);
out.print((ethnic_Desc));
out.write(_jsp_string29, 0, _jsp_string29.length);
out.print((ethnic_Desc));
out.write(_jsp_string30, 0, _jsp_string30.length);
}
out.write(_jsp_string31, 0, _jsp_string31.length);
out.print((trans.tslt("Ethnic Group")));
out.write(_jsp_string32, 0, _jsp_string32.length);
out.print((trans.tslt("Add")));
out.write(_jsp_string33, 0, _jsp_string33.length);
out.print((trans.tslt("Edit")));
out.write(_jsp_string34, 0, _jsp_string34.length);
out.print((trans.tslt("Delete")));
out.write(_jsp_string35, 0, _jsp_string35.length);
}
out.write(_jsp_string36, 0, _jsp_string36.length);
// by lydia Date 05/09/2008 Fix jsp file to support Thai language
out.write(_jsp_string37, 0, _jsp_string37.length);
Calendar c = Calendar.getInstance();
int year = c.get(Calendar.YEAR);
out.write(_jsp_string38, 0, _jsp_string38.length);
// Denise 05/01/2010 update new email address
out.write(_jsp_string39, 0, _jsp_string39.length);
out.print((year));
out.write(_jsp_string40, 0, _jsp_string40.length);
}
public void _jspService(
javax.servlet.http.HttpServletRequest request,
javax.servlet.http.HttpServletResponse response)
throws java.io.IOException, javax.servlet.ServletException {
javax.servlet.http.HttpSession session = request.getSession(true);
com.caucho.server.webapp.Application _jsp_application = _caucho_getApplication();
javax.servlet.ServletContext application = _jsp_application;
com.caucho.jsp.PageContextImpl pageContext =
com.caucho.jsp.QJspFactory.allocatePageContext(
this, _jsp_application, request, response, "/error.jsp", session, 8192, true);
javax.servlet.jsp.JspWriter out = pageContext.getOut();
javax.servlet.ServletConfig config = getServletConfig();
javax.servlet.Servlet page = this;
response.setContentType("text/html");
try {
out.write(_jsp_string0, 0, _jsp_string0.length);
out.print(((String) session.getAttribute("user")));
out.write(_jsp_string1, 0, _jsp_string1.length);
out.print(((String) session.getAttribute("db")));
out.write(_jsp_string2, 0, _jsp_string2.length);
// get all tables in the database
ConDB dbcon = (ConDB) session.getAttribute("dbcon");
Connection conn = dbcon.get();
int total_rec = 0;
int total_table = 0;
String sql = "show tables";
PreparedStatement pstm = null;
ResultSet rs = null;
try {
pstm = conn.prepareStatement(sql);
rs = pstm.executeQuery();
} catch (SQLException e) {
out.println(e);
}
// count the records of each table
while (rs.next()) {
String curr_tb = rs.getString(1);
int curr_rec = 0;
PreparedStatement pstm_rec = null;
ResultSet rs_rec = null;
sql = "select count(*) from " + curr_tb;
try {
pstm_rec = conn.prepareStatement(sql);
rs_rec = pstm_rec.executeQuery();
} catch (SQLException e) {
out.println(e);
}
try {
if (rs_rec.next()) {
curr_rec = rs_rec.getInt(1);
total_rec += curr_rec;
}
} catch (SQLException e) {
out.println(e.getErrorCode() + "---" + e.getSQLState());
}
total_table++;
out.write(_jsp_string3, 0, _jsp_string3.length);
out.print((total_table & 1));
out.write(_jsp_string4, 0, _jsp_string4.length);
out.print((curr_tb));
out.write(_jsp_string5, 0, _jsp_string5.length);
out.print((curr_tb));
out.write(_jsp_string6, 0, _jsp_string6.length);
out.print((curr_tb));
out.write(_jsp_string7, 0, _jsp_string7.length);
out.print((curr_tb));
out.write(_jsp_string8, 0, _jsp_string8.length);
out.print((curr_tb));
out.write(_jsp_string9, 0, _jsp_string9.length);
out.print((curr_rec));
out.write(_jsp_string10, 0, _jsp_string10.length);
}
out.write(_jsp_string11, 0, _jsp_string11.length);
out.print((total_table));
out.write(_jsp_string12, 0, _jsp_string12.length);
out.print((total_rec));
out.write(_jsp_string13, 0, _jsp_string13.length);
out.print((session.getAttribute("db")));
out.write(_jsp_string14, 0, _jsp_string14.length);
} catch (java.lang.Throwable _jsp_e) {
pageContext.handlePageException(_jsp_e);
} finally {
com.caucho.jsp.QJspFactory.freePageContext(pageContext);
}
}
public void _jspService(
final javax.servlet.http.HttpServletRequest request,
final javax.servlet.http.HttpServletResponse response)
throws java.io.IOException, javax.servlet.ServletException {
final 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);
}
}
private void _jspService(
javax.servlet.http.HttpServletRequest request,
javax.servlet.http.HttpServletResponse response,
com.caucho.jsp.PageContextImpl pageContext,
javax.servlet.ServletContext application,
javax.servlet.http.HttpSession session,
TagState _jsp_state)
throws Throwable {
javax.servlet.jsp.JspWriter out = pageContext.getOut();
final javax.el.ELContext _jsp_env = pageContext.getELContext();
javax.servlet.ServletConfig config = getServletConfig();
javax.servlet.Servlet page = this;
javax.servlet.jsp.tagext.JspTag _jsp_parent_tag = null;
com.caucho.jsp.PageContextImpl _jsp_parentContext = pageContext;
response.setContentType("text/html");
response.setCharacterEncoding("utf-8");
out.write(_jsp_string0, 0, _jsp_string0.length);
CP_Classes.Login logchk;
synchronized (pageContext.getSession()) {
logchk = (CP_Classes.Login) pageContext.getSession().getAttribute("logchk");
if (logchk == null) {
logchk = new CP_Classes.Login();
pageContext.getSession().setAttribute("logchk", logchk);
}
}
out.write(_jsp_string1, 0, _jsp_string1.length);
CP_Classes.Create_Edit_Survey CE_Survey;
synchronized (pageContext.getSession()) {
CE_Survey =
(CP_Classes.Create_Edit_Survey) pageContext.getSession().getAttribute("CE_Survey");
if (CE_Survey == null) {
CE_Survey = new CP_Classes.Create_Edit_Survey();
pageContext.getSession().setAttribute("CE_Survey", CE_Survey);
}
}
out.write(_jsp_string2, 0, _jsp_string2.length);
CP_Classes.Translate trans;
synchronized (pageContext.getSession()) {
trans = (CP_Classes.Translate) pageContext.getSession().getAttribute("trans");
if (trans == null) {
trans = new CP_Classes.Translate();
pageContext.getSession().setAttribute("trans", trans);
}
}
out.write(_jsp_string2, 0, _jsp_string2.length);
CP_Classes.RatingTask RT;
synchronized (pageContext.getSession()) {
RT = (CP_Classes.RatingTask) pageContext.getSession().getAttribute("RT");
if (RT == null) {
RT = new CP_Classes.RatingTask();
pageContext.getSession().setAttribute("RT", RT);
}
}
out.write(_jsp_string2, 0, _jsp_string2.length);
CP_Classes.RatingScale RS;
synchronized (pageContext.getSession()) {
RS = (CP_Classes.RatingScale) pageContext.getSession().getAttribute("RS");
if (RS == null) {
RS = new CP_Classes.RatingScale();
pageContext.getSession().setAttribute("RS", RS);
}
}
out.write(_jsp_string2, 0, _jsp_string2.length);
CP_Classes.Purpose PRP;
synchronized (pageContext.getSession()) {
PRP = (CP_Classes.Purpose) pageContext.getSession().getAttribute("PRP");
if (PRP == null) {
PRP = new CP_Classes.Purpose();
pageContext.getSession().setAttribute("PRP", PRP);
}
}
out.write(_jsp_string2, 0, _jsp_string2.length);
CP_Classes.SurveyRating SVR;
synchronized (pageContext.getSession()) {
SVR = (CP_Classes.SurveyRating) pageContext.getSession().getAttribute("SVR");
if (SVR == null) {
SVR = new CP_Classes.SurveyRating();
pageContext.getSession().setAttribute("SVR", SVR);
}
}
out.write(_jsp_string3, 0, _jsp_string3.length);
// by lydia Date 05/09/2008 Fix jsp file to support Thai language
out.write(_jsp_string4, 0, _jsp_string4.length);
out.print((trans.tslt("Please choose a rating task")));
out.write(_jsp_string5, 0, _jsp_string5.length);
response.setHeader("Pragma", "no-cache");
response.setHeader("Cache-Control", "no-cache");
response.setDateHeader("expires", 0);
String username = (String) session.getAttribute("username");
if (!logchk.isUsable(username)) {
out.write(_jsp_string6, 0, _jsp_string6.length);
} else {
if (request.getParameter("purpose") != null) {
int var1 = new Integer(request.getParameter("purpose")).intValue();
CE_Survey.setPurpose(var1);
System.out.println("Purpose ID" + var1);
} else {
// Edited by Eric Lu 22/5/08
// Resets purpose if first time accessing this page
CE_Survey.setPurpose(0);
}
if (request.getParameter("add") != null) {
String rating = "";
String scale = "";
boolean RequiredChosen = false;
String[] chkSelect = new String[10];
String[] ScaleDesc = new String[10];
String[] radioSelect = new String[10];
int SurveyID = CE_Survey.getSurvey_ID();
ScaleDesc = request.getParameterValues("selScaleDesc");
chkSelect = request.getParameterValues("chkRat");
radioSelect = request.getParameterValues("radioRat");
int count = 0; // count shifted, Mark Oei 16 April 2010
/*------------------------------------------------- for checkbox ------------------------------------------------*/
// Changed by Ha 28/05/09 to pop out message when action is done successfully
if (chkSelect != null) {
boolean added = false;
count = 0; // change to declare variable outside if statement, Mark Oei 16 April 2010
for (int i = 0; i < chkSelect.length; i++) {
rating = chkSelect[i];
if (rating != null) {
String RatName = " ";
RatName = RT.getRatingTask(Integer.parseInt(rating));
ScaleDesc = new String[10];
ScaleDesc = request.getParameterValues("selScaleDesc" + rating);
for (int j = 0; j < ScaleDesc.length; j++) {
scale = ScaleDesc[j];
CE_Survey.editPurpose(SurveyID, CE_Survey.getPurpose());
added = CE_Survey.addRating(SurveyID, scale, rating, RatName);
if (added) count++;
}
}
}
// Added to insert default values into database when rating tasks are added
// Mark Oei 16 April 2010
int lLimit = 0;
int uLimit = 0;
int scaleRange = CE_Survey.getRatScale();
int taskCount = (Integer) session.getAttribute("taskCount") + count;
if ((taskCount == 1 && Integer.parseInt(rating) == 1)) {
lLimit = scaleRange / 2 - 1;
uLimit = scaleRange / 2 + 1;
} else {
lLimit = -1;
uLimit = 1;
}
boolean isSuccessful = CE_Survey.setMinPassScore(SurveyID, lLimit, uLimit);
if (isSuccessful) {
System.out.println(
"Default Limits " + lLimit + ", " + uLimit + " has been inserted successfully");
}
if (count == chkSelect.length) {
out.write(_jsp_string7, 0, _jsp_string7.length);
}
}
/*-------------------------------------------------------- for radiobox ----------------------------------------------*/
rating = "";
if (radioSelect != null) {
for (int i = 0; i < radioSelect.length; i++) {
rating = radioSelect[i];
if (rating != null) {
String RatName = RT.getRatingTask(Integer.parseInt(rating));
ScaleDesc = new String[10];
ScaleDesc = request.getParameterValues("selScaleDesc" + rating);
for (int j = 0; j < ScaleDesc.length; j++) {
scale = ScaleDesc[j];
CE_Survey.addRating(SurveyID, scale, rating, RatName);
}
}
}
}
out.write(_jsp_string8, 0, _jsp_string8.length);
}
out.write(_jsp_string9, 0, _jsp_string9.length);
out.print((trans.tslt("To Select Rating Task, checked on the provided boxes under Select")));
out.write(_jsp_string10, 0, _jsp_string10.length);
out.print((trans.tslt("Purpose of Survey")));
out.write(_jsp_string11, 0, _jsp_string11.length);
out.print((trans.tslt("Choose one")));
out.write(_jsp_string12, 0, _jsp_string12.length);
Vector v = PRP.getAllPurpose();
for (int i = 0; i < v.size(); i++) {
votblPurpose vo = (votblPurpose) v.elementAt(i);
int PurposeID = vo.getPurposeID();
String PurposeName = vo.getPurposeName();
if (CE_Survey.getPurpose() == PurposeID) {
out.write(_jsp_string13, 0, _jsp_string13.length);
out.print((PurposeID));
out.write(_jsp_string14, 0, _jsp_string14.length);
out.print((PurposeName));
out.write(_jsp_string12, 0, _jsp_string12.length);
} else {
out.write(_jsp_string15, 0, _jsp_string15.length);
out.print((PurposeID));
out.write('>');
out.print((PurposeName));
out.write(_jsp_string12, 0, _jsp_string12.length);
}
}
out.write(_jsp_string16, 0, _jsp_string16.length);
out.print((trans.tslt("Scale Range Chosen")));
out.write(_jsp_string17, 0, _jsp_string17.length);
out.print((CE_Survey.getRatScale()));
out.write(_jsp_string18, 0, _jsp_string18.length);
out.print((trans.tslt("Rating Task")));
out.write(_jsp_string19, 0, _jsp_string19.length);
out.print((trans.tslt("Select")));
out.write(_jsp_string20, 0, _jsp_string20.length);
out.print((trans.tslt("Rating Task")));
out.write(_jsp_string21, 0, _jsp_string21.length);
out.print((trans.tslt("Scale Description")));
out.write(_jsp_string22, 0, _jsp_string22.length);
String query2 = "";
boolean dunAddPR = false;
int iRatingTaskID = SVR.getRatingTaskID(CE_Survey.getSurvey_ID());
if (iRatingTaskID != 0) dunAddPR = true;
boolean anyRecord = false;
boolean anyscale = false;
Vector vRT = RT.getRatingTask(CE_Survey.getSurvey_ID(), dunAddPR, CE_Survey.getPurpose());
for (int i = 0; i < vRT.size(); i++) {
anyRecord = true;
votblRatingTask vo = (votblRatingTask) vRT.elementAt(i);
int RatID = vo.getRatingTaskID();
String RatName = vo.getRatingTask();
String ScaleType = vo.getScaleType();
out.write(_jsp_string23, 0, _jsp_string23.length);
if (CE_Survey.getPurpose() != 9) {
out.write(_jsp_string24, 0, _jsp_string24.length);
out.print((RatID));
out.write(_jsp_string25, 0, _jsp_string25.length);
} else {
if (RatID != 2 && RatID != 3) {
out.write(_jsp_string26, 0, _jsp_string26.length);
out.print((RatID));
out.write(_jsp_string27, 0, _jsp_string27.length);
} else {
out.write(_jsp_string28, 0, _jsp_string28.length);
out.print((RatID));
out.write(_jsp_string29, 0, _jsp_string29.length);
}
}
out.write(_jsp_string30, 0, _jsp_string30.length);
out.print((RatName));
out.write(_jsp_string31, 0, _jsp_string31.length);
out.print(("selScaleDesc" + RatID));
out.write(_jsp_string32, 0, _jsp_string32.length);
Vector vScale =
RS.getRatingScale(CE_Survey.getRatScale(), ScaleType, CE_Survey.get_survOrg());
for (int j = 0; j < vScale.size(); j++) {
votblScale voS = (votblScale) vScale.elementAt(j);
anyscale = true;
int ScaleID = voS.getScaleID();
String ScaleDesc = voS.getScaleDescription();
out.write(_jsp_string33, 0, _jsp_string33.length);
out.print((ScaleID));
out.write('>');
out.print((ScaleDesc));
out.write(_jsp_string34, 0, _jsp_string34.length);
}
out.write(_jsp_string35, 0, _jsp_string35.length);
}
if (anyRecord == false && CE_Survey.getPurpose() != 0) {
out.write(_jsp_string36, 0, _jsp_string36.length);
out.print(
(trans.tslt("All the rating tasks under this purpose of survey have been added")));
out.write(_jsp_string37, 0, _jsp_string37.length);
}
out.write(_jsp_string38, 0, _jsp_string38.length);
if (anyRecord && anyscale) {
out.write(_jsp_string39, 0, _jsp_string39.length);
out.print((trans.tslt("Add")));
out.write(_jsp_string40, 0, _jsp_string40.length);
}
out.write(_jsp_string41, 0, _jsp_string41.length);
out.print((trans.tslt("Close")));
out.write(_jsp_string42, 0, _jsp_string42.length);
}
out.write(_jsp_string43, 0, _jsp_string43.length);
}
private void _jspService(
javax.servlet.http.HttpServletRequest request,
javax.servlet.http.HttpServletResponse response,
com.caucho.jsp.PageContextImpl pageContext,
javax.servlet.ServletContext application,
javax.servlet.http.HttpSession session,
TagState _jsp_state)
throws Throwable {
javax.servlet.jsp.JspWriter out = pageContext.getOut();
final javax.el.ELContext _jsp_env = pageContext.getELContext();
javax.servlet.ServletConfig config = getServletConfig();
javax.servlet.Servlet page = this;
javax.servlet.jsp.tagext.JspTag _jsp_parent_tag = null;
com.caucho.jsp.PageContextImpl _jsp_parentContext = pageContext;
response.setContentType("text/html");
response.setCharacterEncoding("utf-8");
// Author: Dai Yong in June 2013
out.write(_jsp_string0, 0, _jsp_string0.length);
CP_Classes.Database Database;
synchronized (pageContext.getSession()) {
Database = (CP_Classes.Database) pageContext.getSession().getAttribute("Database");
if (Database == null) {
Database = new CP_Classes.Database();
pageContext.getSession().setAttribute("Database", Database);
}
}
out.write(_jsp_string1, 0, _jsp_string1.length);
CP_Classes.Login logchk;
synchronized (pageContext.getSession()) {
logchk = (CP_Classes.Login) pageContext.getSession().getAttribute("logchk");
if (logchk == null) {
logchk = new CP_Classes.Login();
pageContext.getSession().setAttribute("logchk", logchk);
}
}
out.write(_jsp_string2, 0, _jsp_string2.length);
Coach.LoginStatus LoginStatus;
synchronized (pageContext.getSession()) {
LoginStatus = (Coach.LoginStatus) pageContext.getSession().getAttribute("LoginStatus");
if (LoginStatus == null) {
LoginStatus = new Coach.LoginStatus();
pageContext.getSession().setAttribute("LoginStatus", LoginStatus);
}
}
out.write(_jsp_string1, 0, _jsp_string1.length);
Coach.Coach Coach;
synchronized (pageContext.getSession()) {
Coach = (Coach.Coach) pageContext.getSession().getAttribute("Coach");
if (Coach == null) {
Coach = new Coach.Coach();
pageContext.getSession().setAttribute("Coach", Coach);
}
}
out.write(_jsp_string3, 0, _jsp_string3.length);
String username = (String) session.getAttribute("username");
if (!logchk.isUsable(username)) {
out.write(_jsp_string4, 0, _jsp_string4.length);
} else {
if (request.getParameter("add") != null) {
if (request.getParameter("Name") != null) {
String name = request.getParameter("Name");
String link = "";
if (request.getParameter("Link") != "") {
link = request.getParameter("Link");
}
// check whether SlotGroup name already exists in database
Boolean Exist = false;
Vector v = Coach.getAllCoach();
for (int i = 0; i < v.size(); i++) {
voCoach vo = (voCoach) v.elementAt(i);
String coachName = vo.getCoachName();
// System.out.println("Existing Schedule Name:"+slotGroupName);
if (name.trim().equalsIgnoreCase((coachName.trim()))) {
Exist = true;
System.out.println("Same Coach Name");
}
}
if (!Exist) {
try {
boolean add = Coach.addCoach(name, link);
if (add) {
out.write(_jsp_string5, 0, _jsp_string5.length);
} else {
}
} catch (Exception SE) {
System.out.println(SE);
}
} else {
out.write(_jsp_string6, 0, _jsp_string6.length);
}
}
}
out.write(_jsp_string7, 0, _jsp_string7.length);
}
out.write(_jsp_string8, 0, _jsp_string8.length);
}
public void _jspService(
javax.servlet.http.HttpServletRequest request,
javax.servlet.http.HttpServletResponse response)
throws java.io.IOException, javax.servlet.ServletException {
javax.servlet.http.HttpSession session = request.getSession(true);
com.caucho.server.webapp.Application _jsp_application = _caucho_getApplication();
javax.servlet.ServletContext application = _jsp_application;
com.caucho.jsp.PageContextImpl pageContext =
com.caucho.jsp.QJspFactory.allocatePageContext(
this, _jsp_application, request, response, null, session, 8192, true, false);
javax.servlet.jsp.JspWriter out = pageContext.getOut();
javax.servlet.ServletConfig config = getServletConfig();
javax.servlet.Servlet page = this;
response.setContentType("text/html");
try {
uk.ac.dundee.computing.stewarttaylor.UserBean userBean;
synchronized (session) {
userBean = (uk.ac.dundee.computing.stewarttaylor.UserBean) session.getAttribute("userBean");
if (userBean == null) {
userBean = new uk.ac.dundee.computing.stewarttaylor.UserBean();
session.setAttribute("userBean", userBean);
}
}
out.write(_jsp_string0, 0, _jsp_string0.length);
uk.ac.dundee.computing.stewarttaylor.UserBean userBean2;
synchronized (session) {
userBean2 =
(uk.ac.dundee.computing.stewarttaylor.UserBean) session.getAttribute("userBean2");
if (userBean2 == null) {
userBean2 = new uk.ac.dundee.computing.stewarttaylor.UserBean();
session.setAttribute("userBean2", userBean2);
}
}
out.write(_jsp_string1, 0, _jsp_string1.length);
uk.ac.dundee.computing.stewarttaylor.UserBean uBean2 =
(uk.ac.dundee.computing.stewarttaylor.UserBean) session.getAttribute("userBean");
String sName = uBean2.getUsername();
out.write(_jsp_string2, 0, _jsp_string2.length);
out.print(sName);
out.write(_jsp_string3, 0, _jsp_string3.length);
out.print(sName);
out.write(_jsp_string4, 0, _jsp_string4.length);
uk.ac.dundee.computing.stewarttaylor.MessageBean msgBean;
synchronized (session) {
msgBean =
(uk.ac.dundee.computing.stewarttaylor.MessageBean) session.getAttribute("msgBean");
if (msgBean == null) {
msgBean = new uk.ac.dundee.computing.stewarttaylor.MessageBean();
session.setAttribute("msgBean", msgBean);
}
}
out.write(_jsp_string5, 0, _jsp_string5.length);
try {
String[] names = msgBean.getUsername();
String[] dates = msgBean.getDate();
String[] messages = msgBean.getMessage();
String[] images = msgBean.getImage();
boolean[] canDelete = msgBean.getCanDelete();
int[] id = msgBean.getID();
for (int i = 0; i < names.length; i++) {
out.write(_jsp_string6, 0, _jsp_string6.length);
out.println(names[i]);
out.write(_jsp_string3, 0, _jsp_string3.length);
out.println(names[i]);
out.write(_jsp_string7, 0, _jsp_string7.length);
if (canDelete[i] == true) {
out.write(_jsp_string8, 0, _jsp_string8.length);
out.println(id[i]);
out.write(_jsp_string9, 0, _jsp_string9.length);
}
out.write(_jsp_string10, 0, _jsp_string10.length);
out.println(images[i]);
out.write(_jsp_string11, 0, _jsp_string11.length);
out.println(dates[i]);
out.write(_jsp_string12, 0, _jsp_string12.length);
out.println(messages[i]);
out.write(_jsp_string13, 0, _jsp_string13.length);
}
} catch (Exception E) {
out.println("<h3> No Posts Retrieved</h3>");
}
out.write(_jsp_string14, 0, _jsp_string14.length);
} catch (java.lang.Throwable _jsp_e) {
pageContext.handlePageException(_jsp_e);
} finally {
com.caucho.jsp.QJspFactory.freePageContext(pageContext);
}
}
public void _jspService(
final javax.servlet.http.HttpServletRequest request,
final javax.servlet.http.HttpServletResponse response)
throws java.io.IOException, javax.servlet.ServletException {
final java.lang.String _jspx_method = request.getMethod();
if (!"GET".equals(_jspx_method)
&& !"POST".equals(_jspx_method)
&& !"HEAD".equals(_jspx_method)
&& !javax.servlet.DispatcherType.ERROR.equals(request.getDispatcherType())) {
response.sendError(
HttpServletResponse.SC_METHOD_NOT_ALLOWED, "JSPs only permit GET POST or HEAD");
return;
}
final javax.servlet.jsp.PageContext pageContext;
javax.servlet.http.HttpSession session = null;
final javax.servlet.ServletContext application;
final javax.servlet.ServletConfig config;
javax.servlet.jsp.JspWriter out = null;
final java.lang.Object page = this;
javax.servlet.jsp.JspWriter _jspx_out = null;
javax.servlet.jsp.PageContext _jspx_page_context = null;
try {
response.setContentType("text/html");
pageContext = _jspxFactory.getPageContext(this, request, response, null, true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write('\r');
out.write('\n');
String username = "";
if (session.getAttribute("login") != null) {
username = session.getAttribute("login").toString();
} else {
out.println("Invalid session! You must log back into the system.");
return;
}
String outputMsg = "TODO";
ResultSet employeeRevRes = null;
String JDBC_DRIVER = "com.mysql.jdbc.Driver";
String DB_URL = "jdbc:mysql://localhost:3306/SilkRoad 5.0";
String USER = "******";
String PASS = "******";
Statement stmt = null;
String sql = null;
Connection conn = null;
CallableStatement cs = null;
try {
// Register JDBC driver
Class.forName(JDBC_DRIVER).newInstance();
// Open a connection
conn = java.sql.DriverManager.getConnection(DB_URL, USER, PASS);
System.out.println("HERE");
cs = conn.prepareCall("call GetEmployeeRevenues()");
cs.execute();
employeeRevRes = cs.getResultSet();
// TODO. Error handling
out.write("\r\n");
out.write(" <html lang=\"en\">\r\n");
out.write(" <head>\r\n");
out.write(" <meta charset=\"utf-8\">\r\n");
out.write(" <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\r\n");
out.write(
" <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\r\n");
out.write(
" <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->\r\n");
out.write(" <title>Silk Road 5.0</title>\r\n");
out.write(" <!-- Bootstrap -->\r\n");
out.write(" <link href=\"css/bootstrap.min.css\" rel=\"stylesheet\">\r\n");
out.write(" ");
out.write("\r\n");
out.write(
" <link href=\"css/responsive.bootstrap.min.css\" rel=\"stylesheet\" type=\"text/css\">\r\n");
out.write(
" <link href=\"https://cdnjs.cloudflare.com/ajax/libs/bootstrap3-dialog/1.34.5/css/bootstrap-dialog.min.css\" rel=\"stylesheet\" type=\"text/css\" />\r\n");
out.write(" <!-- Our own custom css -->\r\n");
out.write(
" <link href=\"css/stylesheet.css\" rel=\"stylesheet\" type=\"text/css\">\r\n");
out.write(
" <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->\r\n");
out.write(
" <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->\r\n");
out.write(" <!--[if lt IE 9]>\r\n");
out.write(
" <script src=\"https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js\"></script>\r\n");
out.write(
" <script src=\"https://oss.maxcdn.com/respond/1.4.2/respond.min.js\"></script>\r\n");
out.write(" <![endif]-->\r\n");
out.write(" <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->\r\n");
out.write(" <script src=\"js/jquery-1.11.3.min.js\"></script>\r\n");
out.write(" <script src=\"js/jquery.validate.js\"></script>\r\n");
out.write(" ");
out.write("\r\n");
out.write(
" <!-- Include all compiled plugins (below), or include individual files as needed -->\r\n");
out.write(" <script src=\"js/bootstrap.min.js\"></script>\r\n");
out.write(
" <script src=\"https://cdnjs.cloudflare.com/ajax/libs/bootstrap3-dialog/1.34.5/js/bootstrap-dialog.min.js\"></script>\r\n");
out.write(" <script src=\"js/pattern.js\"></script>\r\n");
out.write(" <script src=\"js/script.js\"></script>\r\n");
out.write(" <script src=\"js/editCustomer.js\"></script>\r\n");
out.write(" </head>\r\n");
out.write(" <nav class=\"navbar\">\r\n");
out.write(" <div class=\"container-fluid\">\r\n");
out.write(" <!-- Brand and toggle get grouped for better mobile display -->\r\n");
out.write(" <div class=\"navbar-header\">\r\n");
out.write(
" <button type=\"button\" class=\"navbar-toggle collapsed\" data-toggle=\"collapse\" data-target=\"#bs-example-navbar-collapse-1\" aria-expanded=\"false\">\r\n");
out.write(" <span class=\"sr-only\">Toggle navigation</span>\r\n");
out.write(" <span class=\"icon-bar\"></span>\r\n");
out.write(" <span class=\"icon-bar\"></span>\r\n");
out.write(" <span class=\"icon-bar\"></span>\r\n");
out.write(" </button>\r\n");
out.write(" </div>\r\n");
out.write(" <!-- navbar-header -->\r\n");
out.write(
" <!-- Collect the nav links, forms, and other content for toggling -->\r\n");
out.write(" <div class=\"myNavbar\">\r\n");
out.write(" <ul class=\"nav\">\r\n");
out.write(
" <li class=\"floatLeft\"><a href=\"ManagerInformation.jsp\">Home</a></li>\r\n");
out.write(
" <li class=\"dropdown navbar-right\" style=\"padding-left:125px;\">\r\n");
out.write(
" <a data-target=\"#collapseHelp\" data-toggle=\"collapse\">Help<span class=\"caret\"></span></a>\r\n");
out.write(" <ul>\r\n");
out.write(" <div id=\"collapseHelp\" class=\"dropdown-menu\">\r\n");
out.write(
" <li><a href=\"javascript:showEmployeeScreenHelp()\">Screens</a></li>\r\n");
out.write(" <br>\r\n");
out.write(
" <li><a href=\"javascript:showAuctionHelp()\">Auctions</a></li>\r\n");
out.write(" <br>\r\n");
out.write(" </div>\r\n");
out.write(" </ul>\r\n");
out.write(" </li>\r\n");
out.write(
" <li class=\"dropdown navbar-right\" style=\"padding-left:200px;\">\r\n");
out.write(
" <a data-target=\"#collapseMenu\" data-toggle=\"collapse\" >Menu<span class=\"caret\"></span></a>\r\n");
out.write(" <ul>\r\n");
out.write(" <div id=\"collapseMenu\" class=\"dropdown-menu\">\r\n");
out.write(" </div>\r\n");
out.write(" </ul>\r\n");
out.write(" </li>\r\n");
out.write(" </ul>\r\n");
out.write(" <!-- .nav -->\r\n");
out.write(" </div>\r\n");
out.write(" <!-- .myNavbar -->\r\n");
out.write(" </div>\r\n");
out.write(" <!-- .container-fluid -->\r\n");
out.write(" </nav>\r\n");
out.write(" <body class=\"auctionHouseBody\">\r\n");
out.write(
" <h4 class=\"auctionTableHeader\">Highest Grossing Employee</h4>\r\n");
out.write(
" <table id =\"bestSellersTable\" class=\"table table-striped table-bordered dt-responsive nowrap auctionHouseTable\">\r\n");
out.write(" <thead>\r\n");
out.write(" <tr>\r\n");
out.write(" <th>Employee ID</th>\r\n");
out.write(" <th>Username</th>\r\n");
out.write(" <th>Revenue</th>\r\n");
out.write(" </tr>\r\n");
out.write(" </thead>\r\n");
out.write(" <tbody>\r\n");
out.write(" ");
while (employeeRevRes.next()) {
out.write("\r\n");
out.write(" <tr>\r\n");
out.write(" <td>\r\n");
out.write(" ");
out.print(employeeRevRes.getString("EmployeeID"));
out.write("\r\n");
out.write(" </td>\r\n");
out.write(" <td>\r\n");
out.write(" ");
out.print(employeeRevRes.getString("Username"));
out.write("\r\n");
out.write(" </td>\r\n");
out.write(" <td>\r\n");
out.write(" ");
out.print(employeeRevRes.getDouble("Revenue"));
out.write("\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write(" ");
}
out.write("\r\n");
out.write(" </tbody>\r\n");
out.write(" </table>\r\n");
out.write(" </body>\r\n");
out.write(" </html>\r\n");
out.write("\r\n");
out.write(" ");
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (Exception ee) {
}
;
}
out.write('\r');
out.write('\n');
} catch (java.lang.Throwable t) {
if (!(t instanceof javax.servlet.jsp.SkipPageException)) {
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
try {
if (response.isCommitted()) {
out.flush();
} else {
out.clearBuffer();
}
} catch (java.io.IOException e) {
}
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
else throw new ServletException(t);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}
public void _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);
}
}