Viewing file:  updatePersonDept.php (7.93 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
set_time_limit(0);
include_once "template.php";
include_once "../class/clsTable.php";
include_once "../class/clsDepartment.php";
include_once "../class/clsPerson.php";
include_once "../link/function.php";
include_once "../class/clsUmuser.php";
include_once "../class/clsadmin.php";
include_once "../class/clshire.php";
$oC = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_EPERSON'], $GLOBALS['DBUSER_EPERSON'], $GLOBALS['DBPASS_EPERSON']);
$oUs = new clsConnection($GLOBALS['DBHOST'], $GLOBALS['DBNAME_UMS'], $GLOBALS['DBUSER_UMS'], $GLOBALS['DBPASS_UMS']);
$oDP = new Department($oC);
$oDP2 = new Department($oC);
$oDP3 = new Department($oC);
$oPS = new Person($oC);
$oPS2 = new Person($oC);
$oPS3 = new Person($oC);
$oUms= new umuser($oUs);
$oUms2= new umuser($oUs);
$oAd = new admin($oC);
$oHr = new hire($oC);
include_once "getPrefix.php";
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<link href="../source/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<br>
<table width=703 align="center">
<tr><td height="150">
<fieldset>
<legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="?mm=1">จัดการข้อมูลบุคลากร</a>
<img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle"><a href="updatePerson.php">แก้ไขข้อมูลบุคลากรรายบุคคล
</a><img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle"> แก้ไขข้อมูลหน่วยงานที่สังกัดรายกลุ่ม
</font>
</legend>
<form name="ff" METHOD="POST" action="processUpdatePersonDept.php">
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr><td height="30"><strong><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_2"];?>"><img src="../picture/sendusers.gif" border="0" > แก้ไขข้อมูลหน่วยงานที่สังกัดรายกลุ่ม</font></strong></td></tr>
<tr><td>
<table width="99%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="silver">
<tr><td colspan="6" align="center" bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_9"];?>" height="24"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>ข้อมูลบุคลากร</b></font></td></tr>
<tr align="center" bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_9"];?>">
<td width="6%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>#</b></font></td>
<td width="7%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>
คำนำหน้า<br>ชื่อ</b></font></td>
<td width="16%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>ชื่อ</b></font></td>
<td width="18%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>นามสกุล</b></font></td>
<td width="42%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>สังกัดหน่วยงานใหม่</b></font></font></td>
<td width="5%" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><b>เลือก<br>แก้ไข</b></font></font></td>
</tr>
<? $oDP->RSDeptByMaxdeptDate2();
while($oDP->GetRecord()){
?>
<tr><td colspan="6" bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_12"]; ?>" height="22"> <strong><? echo $oDP->deptName; ?></strong></td></tr>
<?
$oPS->RSPersonf1dept($oDP->deptId);
$i=0;
while($oPS->GetRecord()){
if(($i%2) == 0)
echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TD_5"]."\">";
else
echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TD_11"]."\">";
?>
<td align="center" height="22"><? echo $i+1; ?></td>
<td align="left"> <? echo GetPrefixshow($oPS->prefixId); ?></td>
<td align="left"> <? echo $oPS->fName; ?></td>
<td align="left"> <? echo $oPS->lName; ?></td>
<td align="left">
<select name="deptId[<? echo $oPS->personId; ?>]" >
<? $oDP2->RSDeptByMaxdeptDate3();
while($oDP2->GetRecord()){?>
<option value="<? echo $oDP2->deptId;?>" <? if($oDP->deptId==$oDP2->deptId){ echo "selected"; }?>><? echo $oDP2->deptName; ?></option>
<? } ?>
</select>
</td>
<td align="center"><input name="selectdept[<? echo $oPS->personId; ?>]" type="checkbox" value="Y"></td>
</tr>
<? $i++; }
if($i==0){
?>
<tr><td colspan="6" align="center" bgcolor="#FFFFFF" height="22"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2">** ไม่มีข้อมูลบุคลากร **</font></td></tr>
<? }
$j++;
}
//--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
if($oPS3->SearchCountByNodeptNamedocGroup($oDP3->MaxDate())!='0'){
?>
<tr><td bgcolor="#FFFFFF" colspan="6"> </td></tr>
<tr><td colspan="6" bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_12"]; ?>" height="22"> <strong>ไม่มีหน่วยงานที่สังกัด</strong></td></tr>
<?
$oPS2->SearchByNodeptNamedocGroup($oDP3->MaxDate());
$z=0;
while($oPS2->GetRecord()){
if(($i%2) == 0)
echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TD_5"]."\">";
else
echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TD_11"]."\">";
?>
<td align="center" height="22"><? echo $z+1; ?></td>
<td align="left"> <? echo GetPrefixshow($oPS2->prefixId); ?></td>
<td align="left"> <? echo $oPS2->fName; ?></td>
<td align="left"> <? echo $oPS2->lName; ?></td>
<td align="left"><select name="deptIdno[<? echo $oPS2->personId; ?>]" >
<option value="0" selected>ไม่มีหน่วยงานที่สังกัด</option>
<? $oDP2->RSDeptByMaxdeptDate3();
while($oDP2->GetRecord()){?>
<option value="<? echo $oDP2->deptId;?>"><? echo $oDP2->deptName; ?></option>
<? } ?>
</select></td>
<td align="center"><input name="selectdept2[<? echo $oPS2->personId; ?>]" type="checkbox" value="Y"></td>
</tr>
<? $z++; }
if($z==0){
?>
<tr><td colspan="6" align="center" bgcolor="#FFFFFF" height="22"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2">** ไม่มีข้อมูลบุคลากร **</font></td></tr>
<? } }
//------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
?>
<?
if($j==0){
?>
<tr><td colspan="6" align="center" bgcolor="#FFFFFF" height="22"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2">** ไม่มีข้อมูลบุคลากร **</font></td></tr>
<? } ?>
</table>
</td></tr>
<tr><td> </td></tr>
<tr><td align="center"><input type="submit" name="jj" value="บันทึก" onClick="return checkFormat();">
<input type="reset" name="clear" value="เคลียร์ข้อมูล">
<input type="button" name="cancel" value="กลับหน้าหลัก" <? echo "onClick=\"location.href = 'updatePerson.php'\""; ?>>
</td></tr>
</table>
</form>
</fieldset>
<table width="704" border="0" align="center">
<tr>
<td width="89" align="left"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2"> <strong>หมายเหตุ
: </strong> </font></td>
<td width="605" align="left"><font color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>" size="2">
คลิกที่รายชื่อบุคลากรที่ต้องการแก้ไขข้อมูลบุคลากร</font></td>
</tr>
</table> <br><br>
</td>
</tr>
</table>
</body>
</html>
<script language="javascript">
function checkFormat(){
var agree=confirm("คุณต้องการแก้ไขข้อมูลบุคลากรใช่หรือไม่ ?");
if (agree){
return true ;
}else{
return false ;
}
}
</script>
|