<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*" %>
<jsp:useBean id="AS_ASSIGN_KKB" class="com.csc.library.system.Task" scope="page" />
<%
AS_ASSIGN_KKB.setChannel(request,response);
//dbxml
UIManager screen = (UIManager) AS_ASSIGN_KKB.process("MultiEntry","AS_ASSIGN_KKB");
//set where clause
screen.getRecord().set("ASSIGNID","1");
screen.getRecord().set("COMPANYID","100");
//retrieve
screen.getRecord().search();
//out.println("<br><br>==============>"+screen.getRecord().getTableName());
//out.println("==============>"+screen.getRecord().getRelationInfo());
//table detail
MultiLine multi = screen.getMultiLine("MASSIGN_KKB1");
multi.setLabelBox("check box");
multi.goFirst();
CheckNull chkNull=new CheckNull();
ThaiUtilities thatUtils = new ThaiUtilities();
%>
<html>
<head><title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<script language="JavaScript" src="../JS/SCREEN.js"></script>
<script language="javascript">setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script type='text/javascript' src='../JS/DATEINPUT.js'></script>
<script type='text/javascript' src='../JS/VIEWCALENDAR.js'></script>
<script type='text/javascript' src="../JS/ICONSMENU.js"></script>
</head>
<body leftmargin="0" topmargin="0">
<form name="cscform" method="post" action="">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__calendar">
<script language="javascript">getInputFormatDate();</script>
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__notNull" value='<%=screen.getRequire()%>'>
<input type="hidden" name="__screen" value="AS_ASSIGN_KKB">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__childMulti" value="MASSIGN_KKB1">
<input type="hidden" name="__gorec" value="">
<input type="hidden" name="__ack" value="">
<input type="hidden" name="__multiTable" value="MASSIGN_KKB1">
<input type="hidden" name="__helpReturn" value="">
<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
<input type="hidden" name="__cmdchild" value="">
<input type="hidden" name="__fixCon" value="">
<input type="hidden" name="__listAdd" value="">
<input type="hidden" name="__deleteItem" value="">
<input type="hidden" name="__assignid" value="1">
<div align='center'>
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<script src="../JS/HOTKEY.js"></script>
<script language="javascript">
var titlename=swap2String('ASSIGN LIST');
document.write(Icons("ASSIGN LIST,"+titlename));
function goHelp(helpName,inputName){
var helpReturn;
var fcon = document.cscform.__fixCon.value;
with (document.cscform) {
if(inputName=="__positionid1" ) {
helpReturn="__positionid1:positionid,__position1:tdesc";
if (!conPosition1.checked) conPosition1.checked = true;
document.cscform.__fixCon.value =" (positionid>='P08') ";
}else if(inputName=="__positionid2" ) {
helpReturn="__positionid2:positionid,__position2:tdesc";
if (!conPosition2.checked) conPosition2.checked = true;
document.cscform.__fixCon.value =" (positionid>='P08') ";
}
linkHelp_Return(helpName,helpReturn);
}//end with
document.cscform.__fixCon.value = fcon;
}//end function
function checkAll(){
with(document.cscform){
for(i=0;i<elements.length;i++){
if(elements[i].type=="checkbox"
&& elements[i].name != "conPosition1"
&& elements[i].name != "conPosition2")
elements[i].checked=true;
}//end for
}//end with
}//end function
function decheckAll(){
with(document.cscform){
for(i=0;i<elements.length;i++){
if(elements[i].type=="checkbox"
&& elements[i].name != "conPosition1"
&& elements[i].name != "conPosition2")
elements[i].checked=false;
}//end for
}//end with
}//end function
function linkList(){
with(document.cscform){
//ให้มันเปิดและใฃ้งานได้จากหลายๆ หน้า
//ใช้ QuiryString ชื่อ __openwith
window.open("SIMASSIGN_KKB1.jsp?__openwith=AS_ASSIGN_KKB&__employeeid=''&__vote1id=''"
,"","width=700,height=300,left=5,top=10,width=1000,height=600,toolbar=no,status=yes,scrollbars=yes,resizable=no");
}
}
function setCheckBox() {
with (document.cscform) {
if (__positionid1.value != "") conPosition1.checked = true;
if (__positionid2.value != "") conPosition2.checked = true;
}
}
function deleteMulti(){
with(document.cscform){
bCon=confirm(MyCode[4]);
if (bCon) {
__deleteItem.value = "";
for(i=0;i<elements.length;i++){
if(elements[i].type=="checkbox"
&& elements[i].name != "conPosition1"
&& elements[i].name != "conPosition2") {
if (elements[i].checked) {
if (__deleteItem.value != ""){
__deleteItem.value = __deleteItem.value+","+elements[i].name;
}else{
__deleteItem.value = elements[i].name;
}//end if
}//end if
}//end if
}//end for
//alert("__deleteItem is: "+__deleteItem.value);
__cmd.value="del";
submit();
//confirmSave();
}//end if bcon
}//end with
}//end function
function searchAssign(){
with(document.cscform){
__cmd.value="search";
submit();
}//end with
}//end funtion
function clearCon(strCon) {
with (document.cscform){
if (strCon=="__positionid1" && !conPosition1.checked) { __positionid1.value = ""; __position1.value = ""; }
if (strCon=="__positionid2" && !conPosition2.checked) { __positionid2.value = ""; __position2.value = ""; }
}//end with
}//end function
function linkVote1(employeeid) {
window.open("AS_VOTE1_KKB.jsp?__employeeid="+employeeid
,"","left=5,top=5,width=1000,height=650,toolbar=no,status=yes,scrollbars=yes,resizable=no");
}//end if
</script>
<!--Display header color tab-->
<table border='0' cellpadding="0" cellspacing="0" class='largest'>
<tr>
<td class="header" colspan="2"> AS_ASSIGN,
<script language="javascript">swapLang("ASSIGN LIST");</script>
</td>
</tr>
</table>
<!--Search Condition-->
<table id='searchAS_ASSIGN_KKB' border='0' cellpadding="0" cellspacing="0" class='largest'>
<tr>
<td colspan="1" align="right"><b><script language="javascript">swapLang("Condition");</script>: </b></td>
<td><INPUT TYPE="checkbox" NAME="conPosition1" ONCLICK="clearCon('__positionid1')"></td>
<td align="right"><b><script language="javascript">swapLang("Position");</script>: </b></td>
<td><INPUT TYPE="text" NAME="__positionid1" SIZE="10" VALUE = '<%=chkNull.chkNullString(thatUtils.ASCII2Unicode(request.getParameter("__positionid1")))%>' READONLY>
<A href="javascript: goHelp('MPOSITIONHELP','__positionid1');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('__group_quesid_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)">
<img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__group_quesid_image" width="20" height="20" border="0" align="absmiddle" >
</a>
<INPUT TYPE="text" NAME="__position1" SIZE="50"
VALUE = '<%=chkNull.chkNullString(thatUtils.ASCII2Unicode(request.getParameter("__position1")))%>' READONLY>
</td>
</tr>
<tr>
<td colspan="1" align="right"><b><script language="javascript">swapLang("Condition");</script>: </b></td>
<td><INPUT TYPE="checkbox" NAME="conPosition2" ONCLICK="clearCon('__positionid2')"></td>
<td align="right"><b><script language="javascript">swapLang("Position");</script>: </b></td>
<td><INPUT TYPE="text" NAME="__positionid2" SIZE="10" VALUE = '<%=chkNull.chkNullString(thatUtils.ASCII2Unicode(request.getParameter("__positionid2")))%>' READONLY>
<A href="javascript: goHelp('MPOSITIONHELP','__positionid2');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('__group_quesid_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)">
<img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__group_quesid_image" width="20" height="20" border="0" align="absmiddle" >
</a>
<INPUT TYPE="text" NAME="__position2" SIZE="50"
VALUE = '<%=chkNull.chkNullString(thatUtils.ASCII2Unicode(request.getParameter("__position2")))%>' READONLY>
</td>
</tr>
<tr>
<td colspan="1"></td>
<td colspan="3" ><span><a href="javascript:searchAssign();"><img src="../IMAGES/BUTTON/SEARCH.gif" border="0"></a></span></td>
</tr>
</table>
<!--Sdearch Button-->
<!--Display data from Table AS_ASSIGN_KKB-->
<table id='tblAS_ASSIGN_KKB' width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#666666" class='largest'>
<thead>
<tr>
<td width="2%" class="row3"><div align="center"><B>
<script language="javascript">swapLang("Select");</script></B></div>
</td>
<td width="3%" class="row3"><div align="center"><B>
<script language="javascript">swapLang("Seq");</script></B></div>
</td>
<td width="8%" class="row3"><div align="center"><%=multi.getLabel("MASSIGN_KKB1","EMPLOYEEID")%></div></td>
<td width="20%" class="row3"><div align="center"><B>
<script language="javascript">swapLang("Full Name Assign");</script></B></div>
</td>
<td width="7%" class="row3"><div align="center"><B>
<script language="javascript">swapLang("Nick Name");</script></B></div>
</td>
<td width="20%" class="row3"><div align="center"><b>
<script language="javascript">swapLang("BU1");</script></b></div></td>
<td width="20%" class="row3"><div align="center"><b>
<script language="javascript">swapLang("BU2");</script></b></div></td>
<td width="20%" class="row3"><div align="center"><b>
<script language="javascript">swapLang("Position");</script></b></div></td>
<td width="10%" class="row3"><div align="center"><b>
<script language="javascript">swapLang("Work Age");</script></b></div></td>
</tr>
</thead>
<tbody>
<%
String[] PositionAllow ={"P08","P09","P10","P11","P11/1","P12","P12/1","P13","P13/1","P13/2","P14","P15","P16"};
boolean allow = false;
screen.getTable("MASSIGN_KKB1").first();
int row=1;
if(request.getParameter("__cmd") != null
&& ( request.getParameter("__cmd").equals("search")|| request.getParameter("__cmd").equals("del")||
request.getParameter("__cmd").equals("save"))) {
//set Filte ระบุ ช่วง Position ?
if(request.getParameter("__cmd").equals("search")){
//out.print("__positionid1 is: "+request.getParameter("__positionid1"));
//out.print("__positionid2 is: "+request.getParameter("__positionid2"));
String curPositionId1 = request.getParameter("__positionid1");
String curPositionId2 = request.getParameter("__positionid2");
if(!curPositionId1.equals("")&&!curPositionId2.equals("")){
//out.print("ระบุ 2 เงื่อนไข");
int startIndex=0;
int stopIndex=0;
//หาช่วงการระบุ position
for(int ii=0;ii<PositionAllow.length;ii++){
if(PositionAllow[ii].toString().equalsIgnoreCase(curPositionId1)){
startIndex = ii;
}//end if
if(PositionAllow[ii].toString().equalsIgnoreCase(curPositionId2)){
stopIndex=ii;
}//end if
}//end for
int start=0;
int stop=0;
if(startIndex<=stopIndex){
//ปกติ
start=startIndex;
stop=stopIndex;
}else{
//ระบุช่วงสิ้นสุด น้อยกว่า ช่วงเริ่มต้น
start=stopIndex;
stop=startIndex;
}//end if
//out.print("start is:"+start+"\n stop is:"+stop);
String[] tmpPositionAllow =new String[(stop-start)+1];
//out.print("length is:"+tmpPositionAllow.length);
int indexTmp=0;
for (int jj=start;jj<=stop;jj++){
tmpPositionAllow[indexTmp]=PositionAllow[jj];
//out.print("in tmp is:"+tmpPositionAllow[indexTmp]);
indexTmp++;
}//end for
PositionAllow =new String[tmpPositionAllow.length];
PositionAllow = tmpPositionAllow;
}else if(!curPositionId1.equals("")&&curPositionId2.equals("")){
//out.print("ระบุ ช่วงเริ่มต้น");
PositionAllow =new String[1];
PositionAllow[0] = curPositionId1;
}else if(curPositionId1.equals("")&&!curPositionId2.equals("")){
//out.print("ระบุ ช่วงสิ้นสุด");
PositionAllow =new String[1];
PositionAllow[0] = curPositionId2;
}else{
//out.print("ไม่ระบุเงื่อนไข");
}//end if
}//end if
for(int i=1;!multi.eof();i++){
//setFilter ไม่แสดง ผู้assign ที่ลาออกไปแล้ว (ตอนได้รับการระบุเป็นผู้Assign อาจยังทำงานอยู่)
if(multi.getDataLabel("MEMPLOYEE","STATUS").equalsIgnoreCase("A")){
String curPosition = multi.getDataLabel("MPOSITION","POSITIONID");
for(int ii=0;ii<PositionAllow.length;ii++){
if(PositionAllow[ii].toString().equalsIgnoreCase(curPosition)){
allow = true;
break;
}//end if
}//end for
if(allow){
%>
<tr>
<td><div align="center">
<input type="checkbox" name="<%=multi.getDataLabel("MASSIGN_KKB1","EMPLOYEEID")%>"></div>
</td>
<td><div align="center"><%=row%></div></td>
<td><div align="center"><%=multi.getDataLabel("MASSIGN_KKB1","EMPLOYEEID")%></div></td>
<td>
<div align="center">
<a href="javascript:linkVote1('<%=multi.getDataLabel("MASSIGN_KKB1","EMPLOYEEID")%>')">
<%=multi.getDataLabel("MEMPLOYEE","FULLNAME")%>
</a>
</div>
</td>
<td><div align="center"><%=multi.getDataLabel("MEMPLOYEE","NICKNAME")%></div></td>
<td><div align="center"><%=multi.getDataLabel("MBU1","TDESC")%></div></td>
<td><div align="center"><%=multi.getDataLabel("MBU2","TDESC")%></div></td>
<td><div align="center"><%=multi.getDataLabel("MPOSITION","TDESC")%></div></td>
<td><div align="center"><%
String thWorkAge = multi.getDataLabel("MEMPLOYEE","empworkages");
String newWorkAge = thWorkAge.replace(" ปี ","/");
newWorkAge = newWorkAge.replace(" เดือน ","/");
newWorkAge = newWorkAge.replace("วัน","");
String[] workage= newWorkAge.split("/");
out.print(workage[0]+"/"+workage[1]);
%>
</td></div>
<!--td><div align="center"><%=multi.getDataLabel("MPOSITION","POSITIONID")%></div></td-->
</tr>
<%
row++;
}//end if
allow = false;
}//end if
multi.next();
}//end for
}
%>
</tbody>
</table>
<table id='controlBtn' class='largest'>
<tr>
<td class="blankspace">
<div align="center" >
<a href="#" onClick="checkAll()"><img src="../IMAGES/BUTTON/SELECTALL.gif" border="0"></a>
<a href="#" onClick="decheckAll()"><img src="../IMAGES/BUTTON/DESELECTALL.gif" border="0"></a>
<a href="javascript:linkList();"><img src="../IMAGES/BUTTON/ADD.gif" border="0"></a>
<a href="javascript:deleteMulti();"><img src="../IMAGES/BUTTON/DELETE.gif" border="0"></a>
</div>
</td>
</tr>
<tr bordercolor="0069B3">
<td class="bottom"></td>
</tr>
<!--========== SCRIPT SET VALUE ============-->
<script language="javascript">setCheckBox();</script>
<!--========== SCRIPT SET VALUE ============-->
</table>
<!----------BEGIN CSC ENDING ZONE ------------------------>
<%=screen.endJSP()%>
<!----------END CSC ENDING ZONE -------------------------->
<!--Nuiss Debug Zone>
<div id='nuissCheck' style='border:1px solid green;width:200px;height:70px'>
<input id='getTableName' value='<%=multi.getTable().getTableName()%>'/>
<input id='recCount' value='<%=multi.getTable().recCount()%>'/>
<input id='getChildTable' value='<%=multi.getDataLabel("MEMPLOYEE","FNAME")%>'/>
<input id='getChildTable' value='<%=multi.getDataLabel("MPOSITION","POSITIONID")%>'/>
</div>
<Nuiss Debug Zone-->
</form>
</body>
</html>