上善 edwardNotes 若水: 2013

<%@ page errorPage="index.jsp" %>

<%@ page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page import="java.util.*" %>
<%@ page import="java.text.DateFormat" %>
<%@ page import="java.text.DateFormat" %>
<%@ page import="java.text.DateFormat" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.SQLException" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.*" %>

<%
if (session.isNew() || session.getAttribute("Login") == null ){
response.sendRedirect("index.jsp");
}
%>
<jsp:useBean scope="session" id="bean" class="com.erp.utils.CompanyProfile" />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<META http-equiv=Content-Type content="text/html; charset=UTF-8">
<link rel="shortcut icon" href="images/ezHR.png" type="image/x-icon" />

<script src="http://code.jquery.com/jquery-1.9.1.js"></script>
<script src="js/udf2.js"></script>
<script>
var moduleACLS="";
var roleS="";
</script>
<link rel="stylesheet" href="css/responsivemobilemenu.css" type="text/css"/>
<script type="text/javascript" src="js/responsivemobilemenu.js"></script>
<%String http="";%>
<%if (request.getParameter("http")!=null) {http=request.getParameter("http");}
%>
<%String moduleACLS="";%>
<%String roleS="";%>
<%String _input=request.getParameter("input");%>
<%String _config=request.getParameter("config");%>
<%String FocusBackGroundColor="#abcdef";%>
<%String contentMarginTop="2";%>
<%String marginRight="6";%>
<%String moduleMenuFont="Verdana, Helvetica, sans-serif";%>
<%String mainMenuFont="Verdana, Helvetica, sans-serif";%>
<%String subMenuFont="Verdana, Helvetica, sans-serif";%>
<%String subMenuFontSize="16px";%>
<%String bodyBackkGroundColor="#b0c4de";%>
<%String subMenuBackGroundColor="rgb(118,166,212)";%>
<%String mainMarginTop="40px";%>
<%String helpMarginTop="42px";%>
<%String formHeight="740px";%>
<%String menu1Style="";%>
<%String menu2Style="";%>
<%String menu3Style="";%>
<%String menu4Style="";%>
<%String menu5Style="";%>
<%String menu6Style="";%>
<%String HelpIconHeight="30px";%>
<%String iframeForm=http;%>
<%String MODE="INPUT";
if (request.getParameter("mode") == null) {} else {MODE=request.getParameter("mode");}%>
<% String MENU="menu1";
if (request.getParameter("menu") == null) {} else {MENU=request.getParameter("menu");}
if (MENU.equals("menu1")){menu1Style="style='background:rgb(189,209,234);color:#000;'";}
if (MENU.equals("menu2")){menu2Style="style='background:rgb(189,209,234);color:#000;'";}
if (MENU.equals("menu3")){menu3Style="style='background:rgb(189,209,234);color:#000;'";}
if (MENU.equals("menu4")){menu4Style="style='background:rgb(189,209,234);color:#000;'";}
if (MENU.equals("menu5")){menu5Style="style='background:rgb(189,209,234);color:#000;'";}
if (MENU.equals("menu6")){menu6Style="style='background:rgb(189,209,234);color:#000;'";}
%>
<head>
<script src="SpryAssets/SpryAccordion.js" type="text/javascript"></script>
<link href="SpryAssets/SpryAccordion.css" rel="stylesheet" type="text/css" />
<script language="JavaScript">
var contentWidth="80";
var input="employeeInput.txt";
var config="employeeInputConfig.txt";
//var http=<%=http%>
//alert(http);
// highLight When Focus
$( ".focusContent" ).delegate( "*", "focus blur", function( event ) {
var elem = $( this );
setTimeout(function() {elem.toggleClass( "focused", elem.is( ":focus" ) );}, 0);
});

</script>

<link rel="stylesheet" href="http://code.jquery.com/ui/1.10.3/themes/smoothness/jquery-ui.css" />
<script src="http://code.jquery.com/jquery-1.9.1.js"></script>
<script src="http://code.jquery.com/ui/1.10.3/jquery-ui.js"></script>
<link rel="stylesheet" href="/resources/demos/style.css" />

<meta http-equiv="Content-Type" content="text/html;charset=big5" />
<title>title Name</title>
<style type="text/css">
.focused {background: <%=FocusBackGroundColor%>;}
body{background-color:<%=bodyBackkGroundColor%>;}

.AccordionFocused .AccordionPanelTab { background-color:rgb(216,233,214);}
.AccordionFocused .AccordionPanelOpen .AccordionPanelTab { background-color: rgb(192,224,230);}
.AccordionPanelTab {
background-color: rgb(190,225,246);
border-top: solid 1px black;
border-bottom: solid 1px gray;
margin: 0px;
padding: 2px;
cursor: pointer;
-moz-user-select: none;
-khtml-user-select: none;
}

.AccordionPanelContent {
overflow: auto;
margin: 0px;
padding: 0px;
height: 200px;
}

.AccordionPanelContent a {
color : rgb(67,120,182);
}

/* ==================== layout ==================== */
/*.menuHeader {font-size: 20px;font-family: Verdana, Helvetica, sans-serif;}*/

.menuHeader {float:left; margin-top:5px;}
.tab_content {font-size:<%=subMenuFontSize%> ;}

#container {width: 100%;
margin: auto;}

#main {width: 100%; float: left; margin-right: -200px;}
#content {width: 100%; float: right; margin: <%=contentMarginTop%>px 0; margin-left: -200px;}
#content_inner {margin-left:125px; margin-right: <%=marginRight%>px;}
#sidebar01 {width: 120px;
float: left;
margin: <%=contentMarginTop%>px 0;
font-family:<%=subMenuFont%>;
font-size:10px;
}

#sidebar02 {width: 200px;
float: right;
margin:<%=contentMarginTop%>px 0;}

#foot {clear: both;}

/* ==================== header ==================== */

#header_inner {padding: 0px;}

#header h1 {margin: 0;
font-size: 2em;
font-family: Verdana, Helvetica, sans-serif;
color: white;}

#header p {margin: 0;
margin-top: 2px;
font-size: 1em;
color: white;}

/* ==================== content ==================== */

.post {width: auto;}

.post h2 {font-size: 1em;
margin: 0;
margin-bottom: 15px;
background-color: #ded217;
line-height: 32px;
padding-left: 10px;}

.posttext {font-size: 0.875em;
line-height: 1.5}

.posttext p {margin: 0;
margin-bottom: 20px;}

/* ==================== sidebar ==================== */

.menu {width: auto;
overflow: hidden;}

.menu li {margin-bottom: 0;
list-style-type: none;
line-height: 0;
border-bottom: solid 1px #ffffff;}

.menu li a {display: block;
line-height: 30px;
padding-left: 10px;
background-color:<%=subMenuBackGroundColor%>;
color: #ffffff;
font-size: 1em;
text-decoration: none;}

.menu li a:hover {background-color: #0ce0c0}

.menu ul {margin: 0; padding: 0; border-top: solid 1px #ffffff;}

/* ==================== footer ==================== */

#footer {width: auto;
border-top: solid 5px rgb(67,120,182);
padding-top: 10px;
padding-bottom: 20px;}

#footer p {color: #000000;
font-size: 0.75em;
margin: 0;}

</style>
<style type="text/css">
ul.tabs li {background: #e1e1e1;
/*border-bottom: 6px solid #036*/
}
ul.tabs li.active {color: rgb(117,193,221);background: #ffe1e1;
/*border-bottom: 6px solid rgb(117,193,221); */
}

.Hmenu li a {font-size: 0.5 em;padding: .2em 1em;color: #fff;background-color: #036; text-decoration: none;}
.Hmenu li a:hover{color: rgb(117,193,221);}
.Hmenu li {display: inline; list-style-type: none; margin-right: 4px;}
.Hmenu ul {margin: 0; padding: 0;}

.Hmenu2 li a {font-size: 0.1 em;padding: .2em 1em; text-decoration: none;}
.Hmenu2 li {display: inline; list-style-type: none; margin-right: 4px;}
.Hmenu2 ul {margin: 0; padding: 0;}
</style>
</head>
<body>
<div id="container">

<div id="head" style="line-height: 1.2;padding-bottom:0px">
<div style="float:left; width:125px;height:52px; overflow:hidden;">
<img style="float:right;margin=0;padding-right:3px;" src="images/Database-bottomlogo.jpg" width="123" height="52" ;
alt="logo" style="float:left;">
</div>
<div id="header" style="width:ratio;height:32px">
<div id="header_inner" style="display:block; border:0px solid black;">
<span>

<div style="border:0px solid black; height:<%=HelpIconHeight%>; padding-top:0px; color:#0000FF;font-size: 20px;font-family:<%=moduleMenuFont%>;">
<span><%=bean.getCompanyName()%>:<%=bean.getDatabase()%></span>
<%if (1==2){ // turn off the help button%>

<input type="image" style="float:right;" src="images/Settings-icon.png" alt="Setting" width="30" height="<%=HelpIconHeight%>"
onClick="messagebox('#userSetting',900,600,'Send');">

<input type="image" style="float:right;" src="images/Email-icon.png" alt="email" width="30" height="<%=HelpIconHeight%>"
onClick="messagebox('#userEmail',900,600,'Save');">

<a href="menu2.jsp?menu=menu6&http=welcome.jsp">
<img border="0" style="float:right;" src="images/Home-icon.png" width="30" height="<%=HelpIconHeight%>">
</a>

<a href="#">
<img border="0" style="float:right;" src="images/help-icon.png" width="30" ;
height="<%=HelpIconHeight%>" value=100 onclick="

if (contentWidth==''){
$('#content_inner').css({width:'80%'});contentWidth='80';$('#helpColumn').css({display:'inline'});}
else
{$('#content_inner').css({width: ''});contentWidth='';$('#helpColumn').css({display:'none'});}
setCookie('VcontentWidth',contentWidth,80);
"> 
</a>
<div style="float:right;vertical-align: middle;margin-right:10px; border:0px solid black;padding:0;">
<a
href="#"
style="color: black; text-decoration: none;vertical-align: middle;"
onclick="alert('change to English');return false;"
title="English">English</a><span>|</span>
<a
href="#"
style="color: black; text-decoration: none;vertical-align: middle;"
onclick="alert('change to ??');return false;"
title="??">??
</a>
<span>|</span>
<a
href="#"
style="color: black; text-decoration: none;vertical-align: middle;"
onclick="alert('change to ??');return false;"
title="??">??
</a>
</div>
<%}%>
</div>
</span>


<div class="rmm" data-menu-style='sapphire' style="float:left;border:0px solid black;">
<ul class="tabs"style="font-family:<%=mainMenuFont%>">



<li class="menuHeader">
<a <%=menu2Style%>href="menu2.jsp?menu=menu2&http=input.jsp&input=companyProfileInput.txt&config=companyProfileInputConfig.txt&mode=VIEW">Master Data</a></li>

<li class="menuHeader" >
<a <%=menu1Style%> href="menu2.jsp?menu=menu1&http=input.jsp&input=employeeList.txt&config=employeeListConfig.txt&mode=LIST">Pre Sales</a>
</li>
<li class="menuHeader">
<a <%=menu3Style%> href="menu2.jsp?menu=menu3&http=input.jsp&input=payrollEntryList.txt&config=payrollEntryListConfig.txt&mode=LIST">Sales Agreement</a></li>

<li class="menuHeader">
<a <%=menu5Style%> title="" href="menu2.jsp?menu=menu5&http=input.jsp&input=taxFilingsList.txt&config=taxFilingsListConfig.txt&mode=LIST">Filings</a></li>

<li class="menuHeader">
<a <%=menu6Style%> href="menu2.jsp?menu=menu6&http=adminStatus.jsp">Report</a></li>




</ul>
</div>
<div style="clear:both;float:right;border:0px solid black">


</div>

<div style="float:right;border:0px solid black">
<span style="float :right; padding-right:5px">

<input title="Change Password" type="image" style="float:right;" src="images/Settings-icon.png" alt="Setting" width="30" height="<%=HelpIconHeight%>"
onClick=" messagebox('#userSetting',900,600,'');_setfocus('oldPassword');">


<input title="Logout" type="image" src="images/LogOut2.png" alt="LogOut" width="30" height="<%=HelpIconHeight%>"
onClick="messagebox('#userLogout',900,600,'');">


<input title="Add User" type="image" src="images/Plus-icon.png" alt="Add User" width="30" height="<%=HelpIconHeight%>"
onClick="messagebox('#userAdd',900,600,'');">


<input title="User Management"
type="image" src="images/Key-icon.png" alt="User Management" width="30"
height="<%=HelpIconHeight%>"
onClick="messagebox('#userRole',900,600,'');">

</Span>

</div>

</div>
</div>
<div id="helpColumn" style='clear:both;float:right;margin-top:<%=helpMarginTop%>;margin-right:10px;
width:9%;
padding:3px 3px 3px 3px; border:1px solid white;
background-color:<%=subMenuBackGroundColor%>; color:#fff;font-size:20px;
display:none;
'>
it is help content it is help content it is help content it is help content
</div>

<div id="main" style="padding-top:0px;margin-top:<%=mainMarginTop%>;">
<div id="content">
<div id="content_inner">


<% if (http.equals("input.jsp")) {%>
<iframe height="<%=formHeight%>" width=100%" src="<%=http%>?input=<%=_input%>&config=<%=_config%>&mode=<%=MODE%>" ></iframe>
<%} else {%>
<iframe height="<%=formHeight%>" width=100%" src="<%=http%>" ></iframe>
<%}%>


</div>

</div>

<div id="sidebar01">
<div id="menu1" class="tab_content">
<div class="menu">
<ul>

<li><a href="menu2.jsp?menu=menu1&http=input.jsp&input=employeeList.txt&config=employeeListConfig.txt&mode=Quotation">Quotation</a></li>
<li><a href= "menu2.jsp?http=input.jsp&menu=menu1&input=filedServiceContractList.txt&config=filedServiceContractListConfig.txt&mode=LIST"
>Contract</a></li>
<li><a href="menu2.jsp?menu=menu1&http=input.jsp&input=terminateInput.txt&config=terminateInputConfig.txt">Job Order </a></li>
</ul>
</div>
</div>

<div id="Xmenu1" class="tab_content">
<div class="menu">

</div>

<div id="Accordion1" class="Accordion" tabindex="0" value="123">
<div class="AccordionPanel">
<div class="AccordionPanelTab">New Hire</div>
<div class="AccordionPanelContent">
<a href="menu2.jsp?http=input.jsp&input=employeeInput.txt&config=employeeInputConfig.txt">List</a><br />
<a href="menu2.jsp?http=input.jsp&input=employeeInput.txt&config=employeeInputConfig.txt">New Hire</a><br />
<a href="menu2.jsp?http=input.jsp&input=employeeInput.txt&config=employeeInputConfig.txt">Prepare</a><br />
<a href="menu2.jsp?http=input.jsp&input=employeeInput.txt&config=employeeInputConfig.txt">Review</a><br />
<a href="menu2.jsp?http=input.jsp&input=employeeInput.txt&config=employeeInputConfig.txt">Approve</a><br />
<a href="menu2.jsp?http=input.jsp&input=employeeInput.txt&config=employeeInputConfig.txt">IR56E</a><br />
<a href="menu2.jsp?http=input.jsp&input=employeeInput.txt&config=employeeInputConfig.txt">Bank</a><br />
<a href="menu2.jsp?http=input.jsp&input=employeeInput.txt&config=employeeInputConfig.txt">MPF</a><br />
</div>
</div>

<div class="AccordionPanel">
<div class="AccordionPanelTab">Update Renumeration</div>
<div class="AccordionPanelContent">
<a href="menu2.jsp?http=input.jsp&input=employeeInput.txt&config=employeeInputConfig.txt">Prepare</a><br />
<a href="menu2.jsp?http=input.jsp&input=employeeInput.txt&config=employeeInputConfig.txt">Review</a><br />
<a href="menu2.jsp?http=input.jsp&input=employeeInput.txt&config=employeeInputConfig.txt">Approve</a><br />
</div>
</div>

<div class="AccordionPanel">
<div class="AccordionPanelTab">Termination</div>
<div class="AccordionPanelContent">
<a href="menu2.jsp?http=input.jsp&input=employeeInput.txt&config=employeeInputConfig.txt">Prepare</a><br />
<a href="menu2.jsp?http=input.jsp&input=employeeInput.txt&config=employeeInputConfig.txt">Review</a><br />
<a href="menu2.jsp?http=input.jsp&input=employeeInput.txt&config=employeeInputConfig.txt">Approve</a><br />
<a href="menu2.jsp?http=input.jsp&input=employeeInput.txt&config=employeeInputConfig.txt">IR56F\/G</a><br />
<a href="menu2.jsp?http=input.jsp&input=employeeInput.txt&config=employeeInputConfig.txt">Bank Transfer</a><br />
<a href="menu2.jsp?http=input.jsp&input=employeeInput.txt&config=employeeInputConfig.txt">Last Pay Slip</a><br />
<a href="menu2.jsp?http=input.jsp&input=employeeInput.txt&config=employeeInputConfig.txt">MPF</a><br />
<a href="menu2.jsp?http=input.jsp&input=employeeInput.txt&config=employeeInputConfig.txt">Print</a><br />
</div>
</div>
</div>
<div style="border:1px solid black; background:rgb(216,233,214); " >Form Properties</div>
</div>

<div id="menu2" class="tab_content">
<div class="menu">
<ul>
<li><a href="menu2.jsp?http=input.jsp&menu=menu2&input=companyProfileInput.txt&config=companyProfileInputConfig.txt">Company (R)</a></li>




<li><a href="menu2.jsp?http=input.jsp&menu=menu2&input=changeLogList.txt&config=changeLogListConfig.txt&mode=LIST" title="Payment Terms">Change Log</a></li>
<li><a href="menu2.jsp?http=input.jsp&menu=menu2&input=paymentTermsList.txt&config=paymentTermsListConfig.txt&mode=LIST">Pay Terms</a></li>

<li><a href="menu2.jsp?http=input.jsp&menu=menu2&input=paymentMethodList.txt&config=paymentMethodListConfig.txt&mode=LIST" title="Payment Method">Pay Method</a></li>

<li><a href="menu2.jsp?http=input.jsp&menu=menu2&input=currencyList.txt&config=currencyListConfig.txt&mode=LIST" title="Currency">Currency</a></li>

<li><a href="menu2.jsp?http=input.jsp&menu=menu2&input=customerList.txt&config=customerListConfig.txt&mode=LIST" title="Customer Inut">Customer</a></li>
<li><a href="menu2.jsp?http=input.jsp&menu=menu2&input=vendorList.txt&config=vendorListConfig.txt&mode=LIST" title="Vendor">Vendor</a></li>
<li><a href="menu2.jsp?http=input.jsp&menu=menu2&input=resourceList.txt&config=resourceListConfig.txt&mode=LIST" title="Resource">Resource</a></li>
<li><a href="menu2.jsp?http=input.jsp&menu=menu2&input=itemList.txt&config=itemListConfig.txt&mode=LIST" title="Item">Item</a></li>
</ul>
</div>
</div>

<div id="menu3" class="tab_content">
<div class="menu">
<ul>
<li><a href="menu2.jsp?menu=menu3&http=input.jsp&input=payrollEntryList.txt&config=payrollEntryListConfig.txt&mode=LIST">Payroll</a></li>
<li><a href="menu2.jsp?menu=menu3&http=input.jsp&input=payrollArchieveList.txt&config=payrollArchieveListConfig.txt&mode=LIST">Archieve</a></li>



</ul>
</div>
</div>
<div id="menu4" class="tab_content">
<div class="menu">
<ul>
<li><a href="#">Input MPF Inf</a></li>
<li><a href="#">Approval</a></li>
</ul>
</div>
</div>

<div id="menu5" class="tab_content">
<div class="menu">
<ul>

<li><a href="menu2.jsp?menu=menu5&http=input.jsp&input=taxFilingsList.txt&config=taxFilingsListConfig.txt&mode=LIST">Tax Filing</a></li>
<li><a href="menu2.jsp?menu=menu5&http=input.jsp&input=bankFilingList.txt&config=bankFilingListConfig.txt&mode=LIST">Bank</a></li>
<li><a href="menu2.jsp?menu=menu5&http=input.jsp&input=MPFFilingList.txt&config=MPFFilingListConfig.txt&mode=LIST">MPF</a></li>
<li><a href="menu2.jsp?menu=menu5&http=input.jsp&input=payrollSlip.txt&config=payrollSlipConfig.txt&mode=LIST">Payroll Slip</a></li>


</ul>

</div>
</div>

<div id="Xmenu6" class="tab_content">
<div class="menu">
<ul>
<li><a href="menu2.jsp?menu=menu6&http=adminStatus.jsp">Admin</a></li>
<li><a href="menu2.jsp?menu=menu6&http=managementDashBoard.jsp">Management (M)</a></li>
<li><a href="menu2.jsp?menu=menu6&http=approvalDashBoard.jsp">Approval (M)</a></li>
</ul>
</div>
</div>

<div id="menu6" class="tab_content">
<div class="menu">
<ul>





<li><a href="menu2.jsp?menu=menu6&http=input.jsp&input=MPFReport.txt&config=MPFReportConfig.txt&mode=LIST">MPF List</a></li>
<li><a href="menu2.jsp?menu=menu6&http=input.jsp&input=EmployeeReport.txt&config=EmployeeReportConfig.txt&mode=LIST">Staff List</a></li>
<li><a href="menu2.jsp?menu=menu6&http=input.jsp&input=payrollAnnualReport.txt&config=payrollAnnualReportConfig.txt&mode=LIST">AutoPay Transaction</a></li>
<li><a href="menu2.jsp?menu=menu6&http=input.jsp&input=PayrollReport.txt&config=PayrollReportConfig.txt&mode=LIST">Payroll Report</a></li>
</ul>
</div>
</div>

</div>
</div>

<div id="foot">
<div id="footer">
<p>Copyright © Top Level Corp Ltd, All Rights Reserved.

</p>
</div>
</div>

</div>
</div>

<div id="dialog" title="Messagebox">
<p>...</p>
</div>
<script>
$(function() {
$( "#dialog" ).dialog({ autoOpen: false });
});
</script>

<div id="dialog-message" title="Download complete" style="display:none;">
<p>
<span class="ui-icon ui-icon-circle-check" style="float: left; margin: 0 7px 50px 0;"></span>
Your files have downloaded successfully into the My Downloads folder.
</p>
<p>
Currently using <b>36% of your storage space</b>.
</p>
</div>

<div id="userEmail" title="Internal Email" style="display:none;height:680px;width:80%;border:1px solid black;">
<table style="width:100%">
<colgroup>
<col span="1" style="width: 20%; margin-right:10px;"> 
<col span="1" style="width: 80%;margin-right:10px">
</colgroup>
<tr><td>To</td><td> <input type="text" style="padding-right; width:80%;"> </input></td></tr>
<tr><td>Subject</td><td><input type="text" style="width:80%;"> </td></tr>
</table>
<DIV style="margin-top:10px;">
<textarea rows="30" cols="98%">it is the internal email
</textarea>
</DIV>
</div>

<div id="userLogout" title="Logout" style="display:none;height:680px;width:80%;border:1px solid black;">
<div class="logoCenter" style="height:160px; width:120px; margin:auto; margin-top:100px;">
<img style="margin=0;" src="images/ezHR.png" ;
alt="logo" style="float:left;">
</div>
<div id="content" class="_center" style="height:100px; width:60%; margin:auto; margin-top:100px;">
<center>
<p style="margin:auto;"><strong>Thank you for using ezERP</strong> </p>
</center>
<br>
</div>
<div id="content" style="height:100px; width:60%; margin:auto; ">
<center>
<a href="RemoveSession.jsp">Return to Logon</a>
</center>
<br>
</div>
</div>





<div id="userSetting" title="User Setting" style="display:none;height:680px;width:80%;border:1px solid black;">
<form method="post"
action="#"
id="myform" class="focusContent" onsubmit="return validateForm()">
<p>
<label for="com" >Login ID</label>
<input readonly type="text" id="eMail" name="eMail" style="width:30%" value="<% out.println(bean.getLoginId());%>" />
</p>

<p>
<label for="com" > Current Password </label>
<input type="password" id="oldPassword" name="oldPassword" style="width:21%" />
</p>
<p>
<label for="com" > Password </label>
<input type="password" id="newPassword" name="newPassword" style="width:21%" />
</p>
<p>
<label for="com" > Confirm Password </label>
<input type="password" id="confirmPassword" name="confirmPassword" style="width:21%"/>
</p>
<p>
<input type="Submit" id="SubmitPassword" name="SubmitPassword" style="width:21%" value="save" />
</p>
</form>
</div>



<div id="userAdd" title="User Add" style="display:none;height:680px;width:80%;border:1px solid black;">
<form method="post"
action="#"
id="myform" class="focusContent"
onsubmit="return addUserValidateForm()">
<p>
<label for="com" > Login ID (email)</label>
<input type="text" id="newUsereMail" name="newUsereMail" style="width:30%" value="" />
</p>
<p>
<label for="com" > Password </label>
<input type="password" id="newUserPassword" name="newUserPassword" style="width:21%" />
</p>
<p>
<label for="com"> Confirm Password </label>
<input type="password" id="newUserConfirmPassword" name="newUserConfirmPassword" style="width:21%"/>
</p>
<p>
<input type="Submit" id="SubmitPassword" name="SubmitPassword" style="width:21%" value="save" />
</p>
</form>
</div>



<div id="userRole" title="User Role" style="display:none;height:680px;width:80%;border:1px solid black;">
<form method="post"
action="#"
id="myform" class="focusContent" onsubmit="return addUserValidateForm()">
<p>
<label for="com" > Login ID (email)</label>
<select name="userRoleUserID" id="userRoleUserID" onchange="alert(this.value);"></select>
<input id='moduleACL' value='' style='display:none;'>
<input id='moduleACLChoice' value=''>

</p>
<input id='roleACL' value='_' style='display:none;'>
<input id='roleChoice' value='_'>

<div style="border: solid 1px black; float: left; height: 200px; width: 80%;">
<span style="background-color: #4378b6; color: white; float: left; height: 20px; margin-bottom: 0; margin-left: 2px; width: 100%;">Module</span>
<div style="margin-right:16px;">
<table cellpadding="0" cellspacing="0" frame="border" rules="all" style="margin: auto; width: 100%;">
<colgroup>
<col span="1" style="width: 80%;"></col>
<col span="1" style="width: 10%;"></col>
<col span="1" style="width: 10%;"></col>
</colgroup>
<thead>
<tr>
<th>Module</th>
<th>Read</th>
<th>Write</th>
</tr>
</thead>
</table>
</div>
<DIV STYLE="overflow-y: scroll; width:100%; height:160px;
border-left: 1px gray solid; border-bottom: 1px gray solid; background: #fff;
border-top: 1px gray solid;
padding:0px; margin: 0px; ">
<table cellpadding="0" cellspacing="0" frame="border" rules="all" style="margin: auto; width: 100%;">
<colgroup>
<col span="1" style="width: 80%;"></col>
<col span="1" style="width: 10%;"></col>
<col span="1" style="width: 10%;"></col>
</colgroup>
<tbody>
<%
String mDATABASE="erp";
String connectionURL = "jdbc:mysql://localhost/"+mDATABASE+"?useUnicode=true&characterEncoding=UTF8";
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection(connectionURL, "root", "root");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("SELECT DESCRIPTION,RECORDID FROM MODULE;");
String delimiter="";
while(rs.next()) {
out.println("<tr>");
out.println("<td>");
out.println(rs.getString(1).trim());
moduleACLS=moduleACLS+delimiter+"R"+rs.getString(2).trim();
delimiter=",";
moduleACLS=moduleACLS+delimiter+"W"+rs.getString(2).trim();
out.println("<td><input id='R"+rs.getString(2).trim()+"' type='checkbox' onclick='getChoices()'></td>");
out.println("<td><input id='W"+rs.getString(2).trim()+"' type='checkbox' onclick='getChoices()'></td>");
out.println("</td>");
out.println("</tr>");
}
}catch(Exception e1){}
%>
</tbody>
</table>
</DIV>
</div>

<div style="margin-top:20px; border: solid 1px black; float: left; height: 200px; width: 80%;">
<span style="background-color: #4378b6; color: white; float: left; height: 20px; margin-bottom: 0; margin-left: 2px; width: 100%;">Role</span>
<div style="margin-right:16px;">
<table cellpadding="0" cellspacing="0" frame="border" rules="all" style="margin: auto; width: 100%;">
<colgroup>
<col span="1" style="width: 60%;"></col>
<col span="1" style="width: 20%;"></col>
<col span="1" style="width: 20%;"></col>
</colgroup>
<thead>
<tr>
<th>Role</th>
<th>Input</th>
<th>Approval</th>
</tr>
</thead>
</table>
</div>
<DIV STYLE="overflow-y: scroll; width:100%; height:160px;
border-left: 1px gray solid; border-bottom: 1px gray solid; background: #fff;
border-top: 1px gray solid;
padding:0px; margin: 0px; ">
<table cellpadding="0" cellspacing="0" frame="border" rules="all" style="margin: auto; width: 100%;">
<colgroup>
<col span="1" style="width: 60%;"></col>
<col span="1" style="width: 20%;"></col>
<col span="1" style="width: 20%;"></col>
</colgroup>
<tbody>
<%
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection(connectionURL, "root", "root");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("SELECT DESCRIPTION,RECORDID FROM ROLE;");
String delimiter="";
while(rs.next()) {
roleS=roleS+delimiter+"I"+rs.getString(2).trim();
delimiter=",";
roleS=roleS+delimiter+"A"+rs.getString(2).trim();
out.println("<tr>");
out.println("<td>");
out.println(rs.getString(1).trim());
out.println("<td><input id='I"+rs.getString(2).trim()+"' type='checkbox' onclick='getChoices()' /></td>");
out.println("<td><input id='A"+rs.getString(2).trim()+"' type='checkbox' onclick='getChoices()'/></td>");
out.println("</td>");
out.println("</tr>");
}
}catch(Exception e1){}
%>
</tbody>
</table>
</DIV>
</div>

<p>
<input type="Submit" id="SubmitPassword" name="SubmitPassword" style="width:21%" value="save" />
</p>
</form>
</div>

</body>
<script>
moduleACLS='<%=moduleACLS%>';
_refreshv('moduleACL',moduleACLS);
roleS='<%=roleS%>';
_refreshv('roleACL',roleS);
$.ajaxSetup({ async: false });

var obj_field=document.getElementById('userRoleUserID');
obj_field.options[0] = new Option('','');
s='tableRead?table=USER&fields=RECORDID,LOGIN_ID&where=where db:`<%=bean.getDatabase()%>` &format=S,S&callback=?&db=erp'
$.getJSON(s,
function(data) {
if (data[0]){
for (r=0 ; r<data.length; r++)
{
$(obj_field).append($('<option></option>').val(data[r][0]).html(data[r][1]));
}
}
}
)

function getChoices(){
now = new Date();hours = now.getHours();minutes = now.getMinutes();seconds = now.getSeconds();
timeValue = hours+':'+((minutes < 10) ? "0":"") + minutes + ":"+((seconds < 10) ? "0":"") + seconds ;
s="";dl="";
s3=moduleACLS.split(",");
for (x in s3){s1=s3[x];if ($('#'+s1).is(":checked")){s=s+dl+s1;dl=",";}}
_refreshv("moduleACLChoice",s);

s="";dl="";
s3=roleS.split(",");
for (x in s3){s1=s3[x];if ($('#'+s1).is(":checked")){s=s+dl+s1;dl=",";}}
_refreshv("roleChoice",s);

/*
s="";dl="";
s3=DIVISIONs.split(",");
for (x in s3){s1=s3[x];if ($('#'+s1).is(":checked")){s=s+dl+s1;dl=",";}}
_refreshv("divisionPermit",s);

s="";dl="";
s3=COMPANYs.split(",");
for (x in s3){s1=s3[x];if ($('#'+s1).is(":checked")){s=s+dl+s1;dl=",";}}
_refreshv("companyPermit",s);
*/

//setTimeout("getChoices()",30000);
}
//getChoices();

/*
$(function(){
//$('#newUserPassword').click{alert('newUserPassword');}
)}
*/

function addUserValidateForm()
{

var x=_lookup('newUsereMail');
var atpos=x.indexOf('@');
var dotpos=x.lastIndexOf('.');
if (atpos<1 || dotpos<atpos+2 || dotpos+2>=x.length)
{
$("#dialog").dialog( "open" );
$("#dialog").dialog('option', 'title', 'User Add Message');
if(x) {
$("#dialog p").html("Not a valid e-mail address");
} else {
$("#dialog p").html("E-mail address cannot been empty");
}
return false;
}

s1=_lookup("newUserPassword").trim();
s2=_lookup("newUserConfirmPassword").trim();
s3=milliseconds = new Date().getTime(); //generate datetimer for master generate.datetimer
s4=_lookup("newUsereMail").trim();
s5='<%=bean.getDatabase()%>'
s6='<%=bean.getCompanyName()%>'
if (s1 != s2){
$("#dialog").dialog( "open" );
$("#dialog").dialog('option', 'title', 'User Add Message');
$("#dialog p").html("New Password Not Match Confirm Password!!");
return false;
}
if (! s1){
$("#dialog").dialog("open" );
$("#dialog").dialog('option', 'title', 'User Add Message');
$("#dialog p").html("Password cannot be empty!!");
return false;
}

s= "tableWrite?"+
"db=erp&"+
"table=USER&"+
"fields=login_id,recordid, db, company_name,password&"+
"values="+
"'"+s4+"'"+","+
"'"+s3+"'"+","+
"'"+s5+"'"+","+
"'"+s6+"'"+","+
"'"+s1+"'"+
"&callback=?";
//document.write(s);
$.getJSON(s, function(){document.write(s);});
/*
$.getJSON(s,
function(data) {
document.write(data);
if (data[0]){
document.write(data[0][0]);
} else {
}
}
);
*/
//endofgetJson
alert("User Had Add")

//$("#dialog").dialog("open" );
//$("#dialog").dialog('option', 'title', 'User Add Message');
//$("#dialog p").html(s);
//$("#dialog p").html("User had add !");
//return true;

}

function validateForm()
{
s=_lookup("oldPassword");

s0='<%=bean.getPassword().trim()%>';

if (s != s0){
$("#dialog").dialog( "open" );
$("#dialog").dialog('option', 'title', 'Password Message');
$("#dialog p").html(" Old password not Match");
return false;
}

s1=_lookup("newPassword").trim();
s2=_lookup("confirmPassword").trim();
s3=<%=bean.getRecordid().trim()%>;

s4=_lookup("eMail").trim();

if (s1 != s2){
$("#dialog").dialog( "open" );
$("#dialog").dialog('option', 'title', 'Password Message');
$("#dialog p").html("New Password Not Match Confirm Password!!");
return false;
}
if (! s1){
$("#dialog").dialog( "open" );
$("#dialog").dialog('option', 'title', 'Password Message');
$("#dialog p").html("Password cannot be empty!!");
return false;
}
/*20131127*/
s= "tableWrite?"+
"db=hr&"+
"table=USER&"+
"fields=login_id,password&"+
"values='"+s4+"'"+","+"'"+s1+"'"+
"&key=recordID&value="+s3+
"&callback=?";
//document.write(s);
$.getJSON(s,
function(data) {
if (data[0]){
} else {
}
}
); //endofgetJson

alert("Password Had Change")
}

function messagebox(divName,divWidth,divHeight,Button1){
if (Button1==""){
$(function() {
$(divName).dialog({
modal: true,
minHeight: divHeight,
minWidth: divWidth,
});
});}
else {
$(function() {
$(divName).dialog({
modal: true,
minHeight: divHeight,
minWidth: divWidth,
buttons: {Save: function() {$( this ).dialog( 'close' );}
}
});
});}
}

$(function(){
$('#newUsereMail').blur(function() {
s5='<%=bean.getDatabase()%>'
s="tableRead?"
s=s+"db=erp&table=USER&"
s=s+"fields=login_id&"+
"key=login_id&"+
"value='"+this.value+"'&"
s=s+"where= where login_id:`"+this.value+"` and db: `"+s5+"` &" +
"format=S&callback=?";
$.getJSON(s,
function(data) {
if (data[0]){
_setfocus("newUsereMail");
$("#dialog").dialog( "open" );
$("#dialog").dialog('option', 'title', 'User Add Message');
$("#dialog p").html("This user account had created !!");
_refreshv('newUsereMail','');
_setfocus("newUsereMail");
return false;
}
}
)

//***************
x=this.value
atpos=x.indexOf('@');
dotpos=x.lastIndexOf('.');
if (atpos<1 || dotpos<atpos+2 || dotpos+2>=x.length)
{
$("#dialog").dialog( "open" );
$("#dialog").dialog('option', 'title', 'User Add Message');
$("#dialog p").html("Not a valid e-mail address");
return false;
}

}
);

$('ul.tabs li').click(function() { //click|mouseover
var $this = $(this), _clickTab = $this.find('a').attr('href');
$this.addClass('active').siblings('.active').removeClass('active');
$(_clickTab).stop(false, true).fadeIn().siblings().hide();// fade out menuhead
return false;
}).find('a').focus(function(){
this.blur();
});
$("#<%=MENU%>").stop(false, true).fadeIn().siblings().hide(); // set default menu working 20130729
});

</script>

<script>
$(function() {

var icons = {
header: "ui-icon-circle-arrow-e",
activeHeader: "ui-icon-circle-arrow-s"
};
$( "#accordion" ).accordion({
icons: icons
});
$( "#toggle" ).button().click(function() {
if ( $( "#accordion" ).accordion( "option", "icons" ) ) {
$( "#accordion" ).accordion( "option", "icons", null );
} else {
$( "#accordion" ).accordion( "option", "icons", icons );
}
});

//dummy=getCookie("VcontentWidth");
//if (dummy) {contentWidth=dummy;}
//alert(contentWidth);
//alert(getCookie('VcontentWidth'));
contentWidth=getCookie('VcontentWidth')
if (contentWidth!=''){

//$('#content_inner').css({width:'80%'});contentWidth='80';$('#helpColumn').css({display:'inline'});} // change from inline to none
{$('#content_inner').css({width: ''});contentWidth='';$('#helpColumn').css({display:'none'});}
else
{$('#content_inner').css({width: ''});contentWidth='';$('#helpColumn').css({display:'none'});}

});
</script>

<script language="JavaScript">

</script>

<script>
// Popup window code

function newWindow(url) {
popupWindow = window.open(
url,
'popUpWindow','height=500,width=650,left=10,top=100,resizable=yes,scrollbars=yes,toolbar=yes,menubar=no,location=no,directories=no,status=yes')
}

function closeWindow()
{
if(false == popupWindow.closed)
{
popupWindow.close ();
}
else
{
alert('That window is already closed. Open the window first and try again!');
}
}
var Accordion1 = new Spry.Widget.Accordion("Accordion1");
</script>


</html>

上善 edwardNotes 若水

2013年12月30日星期一

html-table-row generator-row generator-thisRow table-css 20160112

2013年12月29日星期日

html-checker-read; control html-checker-readonly

2013年12月27日星期五

menu2.asp

我的網誌清單

2013年12月30日 星期一