|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /var/www/html/eoffice/application/document/user/ |
Upload File : |
<?
/*****************************************************************************
Function : แก้ไขข้อมูลของ epm_staff
Version : 1.0
Last Modified : 16/8/2548
Changes :
*****************************************************************************/
include "epm.inc.php";
$report_title = "บุคลากร";
$mname = array("","มกราคม", "กุมภาพันธ์", "มีนาคม", "เมษายน", "พฤษภาคม", "มิถุนายน", "กรกฎาคม", "สิงหาคม", "กันยายน", "ตุลาคม", "พฤศจิกายน", "ธันวาคม");
//$office_id = "13000200";
//$hr_db = "hr";
$org_id = intval($org_id);
$msg = "";
function mk_username($ename,$esurname){
global $uid,$menuitem,$defaulturl,$epm_db,$table_staff,$table_main_menu,$table_staffgroup,$table_groupmember,$type;
$uname = strtolower($ename . "." . substr($esurname,0,3));
$lastuname = $uname;
$n = 3; $k=0;
while (Query1("select count(*) from $table_staff where username='$uname';") > 0){
$n++;
if (strlen($esurname) > $n){
$uname = strtolower($ename . "." . substr($esurname,0,$n));
$lastuname = $uname;
}else{
$k++;
$uname = $lastuname . $k;
} //if
} // while
return $uname;
}
if ($_SERVER[REQUEST_METHOD] == "POST" && $step == "confirm"){
/*
// remove slashes from variable
foreach ($_POST as $key => $value){
if (!is_array($value) && !is_numeric($value)){
$_POST[$key] = stripslashes($value);
}
}
*/
//เปลี่ยนปี พ.ศ.ให้เป็นปี ค.ศ.
if($date_s != "" and $date_e != ""){
$arr_s = explode("/",$date_s);
$arr_e = explode("/",$date_e);
$yy_s = $arr_s[2]-543;
$yy_e = $arr_e[2]-543;
$date_start= $yy_s."-".$arr_s[1]."-".$arr_s[0];// วันเริ่มต้น
$date_end=$yy_e."-".$arr_e[1]."-".$arr_e[0]; //วันที่สิ้นสุด
}
$time_start=$h_start.":".$m_start.":".$sc_start;// เวลาเริ่มต้น
$time_end=$h_end.":".$m_end.":".$sc_end;// เวลาสิ้นสุด
if ($staffname == ""){
$msg = "กรุณาระบุชื่อ - นามสกุล";
}else{
if ($action == "new"){
$sql = "insert into $table_staff( prename,staffname,staffsurname,engprename,engname,engsurname, email,comment,sex,title,telno,address,username,password,org_id,status,std_cost,card_id,weight,date_start,date_end,time_start,time_end) values ('$prename','$staffname','$staffsurname','$engprename','$engname','$engsurname', '$email','$comment','$sex','$title', '$telno','$address','$xusername','$xpassword','$org_id','$status','$std_cost','$card_id','$weight','$date_start','$date_end','$time_start','$time_end');";
}else if ($action == "edit"){
$sql = " update $table_staff set prename='$prename',staffname='$staffname',staffsurname='$staffsurname', engprename='$engprename',engname='$engname',engsurname='$engsurname', email='$email', comment='$comment', sex='$sex',title='$title', telno='$telno',address='$address',status='$status', std_cost='$std_cost',card_id='$card_id',weight='$weight',date_start='$date_start',date_end='$date_end',time_start='$time_start',time_end='$time_end' where staffid = '$id'; ";
}else{
header("Location : ?org_id=$org_id?type=$type");
exit;
}
@mysql_query($sql);
if (mysql_errno() != 0){
$msg = "ไม่สามารถบันทึกลงฐานข้อมูลได้<BR>$sql<BR><BR>" . mysql_error() ;
}else{
// SUCCESS
if ($action == "new"){
//add ลง group Guest อัตโนมัติ
$staffid = mysql_insert_id();
$gid = Query1("select gid from $table_staffgroup where org_id='$org_id' and groupname='Guest' limit 1;");
$gid = intval($gid);
if ($gid > 0) mysql_query("insert into $table_groupmember(gid,staffid) values('$gid','$staffid');");
}
echo "<script>alert('บันทึกข้อมูลเรียบร้อยแล้ว'); if (parent.leftFrame) {parent.leftFrame.location=parent.leftFrame.location;} location.href='?org_id=$org_id&type=$type';</script>";
//header("Location: ?org_id=$org_id");
exit;
}
}
$action = "";
}else if ($_SERVER[REQUEST_METHOD] == "POST" && $action == "import"){
if($date_s != "" and $date_e != ""){
$arr_s = explode("/",$date_s);
$arr_e = explode("/",$date_e);
$yy_s = $arr_s[2]-543;
$yy_e = $arr_e[2]-543;
$date_start= $yy_s."-".$arr_s[1]."-".$arr_s[0];// วันเริ่มต้น
$date_end=$yy_e."-".$arr_e[1]."-".$arr_e[0]; //วันที่สิ้นสุด
}
$time_start=$h_start.":".$m_start.":".$sc_start;// เวลาเริ่มต้น
$time_end=$h_end.":".$m_end.":".$sc_end;// เวลาสิ้นสุด
foreach ($_POST[hr_id] as $k => $xid){
//echo "$k = $xid<BR>";
$result = mysql_query("select * from $hr_db.general where id='$xid';");
$rs = mysql_fetch_assoc($result);
//เชคเลขบัตรประชาชน
if ($rs[idcard] > ""){
$result2 = mysql_query("select * from epm_staff where card_id = '$rs[idcard]';");
$rs2 = mysql_fetch_assoc($result2);
if ($rs[card_id] == $rs2[idcard]){
echo "<FONT COLOR='RED'>ข้อมูลซ้ำ</FONT> :$rs[idcard] $rs[prename_th] $rs[name_th] $rs[surname_th] <BR>";
continue; //skip
}
}//if
//เชคชื่อ + นามสกุล
$result2 = mysql_query("select * from $table_staff where staffname='$rs[name_th]' and staffsurname='$rs[surname_th]';");
if (mysql_num_rows($result2) > 0){
echo "<FONT COLOR='RED'>ข้อมูลซ้ำ</FONT> : $rs[prename_th] $rs[name_th] $rs[surname_th] <BR>";
continue; //skip
}
//gen username
//$uname = mk_username($rs[name_en],$rs[surname_en]);
$x = explode(" ",$rs[birthday]);
$x = explode("-",$x[0]);
$uname = "$x[2]$x[1]$x[0]";
$pwd = $rs[idcard];
//convert sex
if ($rs[sex] == "ชาย") {
$sex = "M";
}else if ($rs[sex] == "หญิง"){
$sex="F";
}else{
$sex="";
}
//add into epm_staff
$sql = "insert into $table_staff (prename,staffname,staffsurname,engprename,engname,engsurname,sex,org_id,title,telno, address,username,password,card_id,hr_id,date_start,date_end,time_start,time_end) values('$rs[prename_th]','$rs[name_th]','$rs[surname_th]', '$rs[prename_en]','$rs[name_en]', '$rs[surname_en]','$sex','$org_id','$rs[position_now]','$rs[telno]','$rs[address]','$uname','$pwd','$rs[idcard]','$rs[id]','$date_start','$date_end','$time_start','$time_end');";
//echo "insert : $sql <BR><BR>";
mysql_query($sql);
echo "<FONT COLOR='GREEN'>นำเข้า</FONT> : $rs[prename_th] $rs[name_th] $rs[surname_th] <BR>";
} // foreach
exit;
}else if ($action == "delete" && $id > ""){
/*
$nproject = Query1("select count(*) from epm_detail where owner_id='$id';");
$relate_project = Query1("select count(*) from epm_project_staff where staffid='$id';");
$nactivity = Query1("select count(*) from epm_activity2 where act_owner_id='$id';");
$relate_activity = Query1("select count(*) from epm_activity_staff where staffid='$id';");
if ($nproject > 0 || $relate_project > 0 || $nactivity > 0 || $relate_activity > 0){
echo "<script>alert('ไม่สามารถลบข้อมูลได้\\nเพราะบุคลากรผู้นี้ได้มีส่วนเกี่ยวข้องกับโครงการต่างๆ'); history.back();</script>";
exit;
}
*/
@mysql_query("delete from $table_staff where staffid='$id';");
if (mysql_errno() > 0){
$msg = "ไม่สามารถลบข้อมูลได้";
}else{
//ลบจาก group
mysql_query("delete from $table_groupmember where staffid='$id';");
echo "<script>alert('ลบข้อมูลเรียบร้อยแล้ว'); if (parent.leftFrame) {parent.leftFrame.location=parent.leftFrame.location;} location.href='?org_id=$org_id&type=$type';</script>";
exit;
}
$action = "";
}else if ($action == "resetpwd" && $id > ""){
@mysql_query("update $table_staff set password='logon' where staffid='$id';");
if (mysql_errno() > 0){
$msg = "ไม่สามารถ Reset Passwordได้";
}
$action = "";
}
//include("index_top.php");
?>
<HTML>
<HEAD>
<TITLE><?=$report_title?></TITLE>
<META http-equiv="Content-Type" content="text/html; charset=windows-874">
<LINK href="../../../common/style.css" rel=StyleSheet type="text/css">
<SCRIPT language='javascript' src='daily_popcalendar.js'></SCRIPT>
<SCRIPT language=JavaScript>
function checkFields() {
missinginfo1 = "";
missinginfo = "";title
if (document.form1.title.value == "") { missinginfo1 += "\n- ช่องตำแหน่ง ไม่สามารถเป็นค่าว่าง"; }
if (document.form1.staffname.value == "") { missinginfo1 += "\n- ช่องชื่อ ไม่สามารถเป็นค่าว่าง"; }
if (document.form1.staffsurname.value == "") { missinginfo1 += "\n- ช่องนามสกุล ไม่สามารถเป็นค่าว่าง"; }
if (document.form1.engname.value == "") { missinginfo1 += "\n- ช่องชื่อ(อังกฤษ) ไม่สามารถเป็นค่าว่าง"; }
if (document.form1.engsurname.value == "") { missinginfo1 += "\n- ช่องนามสกุล(อังกฤษ) ไม่สามารถเป็นค่าว่าง"; }
if (missinginfo1 != "") {
missinginfo += "ไม่สามารถเพิ่มข้อมูลได้ เนื่องจาก \n";
missinginfo +="_____________________________\n";
missinginfo = missinginfo + missinginfo1 ;
missinginfo += "\n___________________________";
missinginfo += "\nกรุณาตรวจสอบ อีกครั้ง";
alert(missinginfo);
return false;
}
}
</SCRIPT>
</HEAD>
<BODY bgcolor="#FFFFFF">
<?
if ($_GET[action] == "edit" || $_GET[action] == "new" || $step == "start"){
if ($_GET[action] == "edit" && $step == ""){
$sql = "select * from $table_staff where staffid='$id';";
$result = mysql_query($sql);
$rs = mysql_fetch_assoc($result);
$title="แก้ไข";
$uname= $rs[username];
$pwd = $rs[password];
}else{
$rs = array();
$rs[weight] = 1;
$title = "เพิ่ม";
}
$lock = "";
if ($step == ""){
$step = "start";
}else if ($step == "start"){
if ($action == "edit"){
$pwd = $_POST[xpassword];
$uname = $_POST[xusername];
}else{
$pwd = "logon";
$uname = mk_username($_POST[engname],$_POST[engsurname]);
} // if
$step = "confirm";
$rs = $_POST;
$lock = " ONFOCUS='blur();' ";
$title = "ยืนยัน";
}
?>
<FORM action="?" method="POST" NAME="form1" ONSUBMIT="Javascript:return (checkFields());">
<INPUT TYPE="hidden" NAME="id" VALUE="<?=$id?>" >
<INPUT TYPE="hidden" NAME="step" VALUE="<?=$step?>" >
<INPUT TYPE="hidden" NAME="org_id" VALUE="<?=$org_id?>" >
<INPUT TYPE="hidden" NAME="action" VALUE="<?=$action?>" >
<INPUT TYPE="hidden" NAME="xusername" VALUE="<?=$uname?>" >
<INPUT TYPE="hidden" NAME="xpassword" VALUE="<?=$pwd?>" >
<INPUT NAME="type" TYPE="hidden" id="type" VALUE="<?=$type?>" >
<TABLE border=0 align=center cellspacing=1 cellpadding=3 bgcolor="#DDDDDD" width="98%">
<TR bgcolor="#a3b2cc">
<TD colspan=2> <FONT COLOR="WHITE" style="font-size:14pt;"><B><?=$title?>ข้อมูล<?=$report_title?></B></FONT></TD>
</TR>
<?
if ($step == "confirm" || $action == "edit"){
if($rs[date_start] != "0000-00-00"){
if(($rs[date_start] != NULL)){
$arr_s1 = explode("-",$rs[date_start]);
$yy_s1 = $arr_s1[0]+543;
$date_s=$arr_s1[2]."/".$arr_s1[1]."/".$yy_s1;
}
}
// วันสิ้นสุด
if($rs[date_end] != "0000-00-00"){
if($rs[date_end] != NULL){
$arr_e1 = explode("-",$rs[date_end]);
$yy_e1 = $arr_e1[0]+543;
$date_e=$arr_e1[2]."/".$arr_e1[1]."/".$yy_e1;
}
}
// เวลาเริ่มต้น
$arr_st=explode(":",$rs[time_start]);
$h_st=$arr_st[0];
$m_st=$arr_st[1];
$sc_st=$arr_st[2];
// เวลาสิ้นสุด
$arr_et=explode(":",$rs[time_end]);
$h_et=$arr_et[0];
$m_et=$arr_et[1];
$sc_et=$arr_et[2];
?>
<TR bgcolor="#EFEFFF" valign=top> <TD class="link_back"> Username </TD> <TD> <U><?=$uname?></U> </TD> </TR>
<TR bgcolor="#EFEFFF" valign=top> <TD class="link_back"> Password </TD> <TD> <U><?=$pwd?></U> </TD> </TR>
<TR bgcolor="#808080" height=10><TD colspan=2></TD> </TR>
<?
}
?>
<TR bgcolor=white valign=top>
<TD class="link_back">ตำแหน่ง <FONT COLOR="RED">*</FONT></TD>
<TD> <INPUT TYPE="text" NAME="title" VALUE="<?=$rs[title]?>" size="60" maxlength=200 class=inputbox <?=$lock?>> </TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">คำนำหน้า (ไทย) </TD>
<TD>
<INPUT TYPE="text" NAME="prename" VALUE="<?=$rs[prename]?>" size="30" maxlength=50 class=inputbox <?=$lock?>> </TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">ชื่อ (ไทย) <FONT COLOR="RED">*</FONT></TD>
<TD>
<INPUT TYPE="text" NAME="staffname" VALUE="<?=$rs[staffname]?>" size="60" maxlength=200 class=inputbox <?=$lock?>> </TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">นามสกุล (ไทย) <FONT COLOR="RED">*</FONT></TD>
<TD>
<INPUT TYPE="text" NAME="staffsurname" VALUE="<?=$rs[staffsurname]?>" size="60" maxlength=200 class=inputbox <?=$lock?>> </TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">คำนำหน้า (อังกฤษ) </TD>
<TD>
<INPUT TYPE="text" NAME="engprename" VALUE="<?=$rs[engprename]?>" size="30" maxlength=50 class=inputbox <?=$lock?>> </TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">ชื่อ (อังกฤษ) <FONT COLOR="RED">*</FONT></TD>
<TD>
<? if(!$rs[engname]){$rs[engname]=$codename_1st;}?>
<INPUT TYPE="text" NAME="engname" VALUE="<?=$rs[engname]?>" size="60" maxlength=200 class=inputbox <?=$lock?>>
<BR>
ชื่อผู้ใช้ตามด้วยรหัส Username ส่วนหน้า แล้วตามด้วยเครื่องหมายจุด "<b>.</b>" และเป็น username ส่วยหลัง เช่น <I>eoffice.001</I> </TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">นามสกุล (อังกฤษ) <FONT COLOR="RED">*</FONT></TD>
<TD>
<INPUT TYPE="text" NAME="engsurname" VALUE="<?=$rs[engsurname]?>" size="60" maxlength=200 class=inputbox <?=$lock?>> </TD>
</TR>
<!-- <TR bgcolor=white valign=top>
<TD class="link_back">เลขบัตรประจำตัว</TD>
<TD><INPUT TYPE="text" NAME="card_id" VALUE="<?//=$rs[card_id]?>" size="20" maxlength=30 class=inputbox <?//=$lock?>> </TD>
</TR>-->
<TR bgcolor=white valign=top>
<TD class="link_back">Email Address</TD>
<TD> <INPUT TYPE="text" NAME="email" VALUE="<?=$rs[email]?>" size="60" maxlength=200 class=inputbox <?=$lock?>> </TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">เพศ</TD>
<TD>
<SELECT name="sex" <?=$lock?> style="width:150px;">
<?
$sex_array = array("M"=>"ชาย","F"=>"หญิง");
foreach ($sex_array as $sex=>$caption){
if ($rs[sex] == $sex) $sel="SELECTED"; else $sel="";
echo "<option value='$sex' $sel>$caption";
}
?>
</SELECT> </TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">สถานะ</TD>
<TD>
<SELECT name="status" <?=$lock?> style="width:150px;">
<?
$status_array = array("0"=>"เข้าระบบได้ตามปกติ","1"=>"ระงับการเข้าระบบ");
foreach ($status_array as $status=>$caption){
if ($rs[status] == $status) $sel="SELECTED"; else $sel="";
echo "<option value='$status' $sel>$caption";
}
?>
</SELECT> </TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">ปี/เดือน/วัน เริ่มต้น</TD>
<TD><INPUT name="date_s" type="text" onFocus="blur();" value="<?=$date_s?>" size="15" readonly>
<INPUT name="button2" type="button" style='font-size:11px; width:80px;' onClick="popUpCalendar(this, form1.date_s, 'dd/mm/yyyy')" value='ปีเดือนวัน'></TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">ปี/เดือน/วัน สิ้นสุด</TD>
<TD><INPUT name="date_e" type="text" onFocus="blur();" value="<?=$date_e?>" size="15" readonly>
<INPUT name="button" type="button" style='font-size:11px; width:80px;' onClick="popUpCalendar(this, form1.date_e, 'dd/mm/yyyy')" value='ปีเดือนวัน'></TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">เวลา เริ่มต้น</TD>
<TD>
ชั่วโมง
<SELECT name="h_start" >
<?
for ($i=0;$i<=23;$i++){
if($step == "confirm"){
if(intval($h_start) == $i){ $sel = "SELECTED";}else{ $sel = "";}
}else{
if(intval($h_st) == $i){ $sel = "SELECTED";}else{ $sel = "";}
}
echo "<option value='".sprintf("%02d",$i)."' $sel>" . sprintf("%02d",$i) . "</option>";
}
?>
</SELECT>
นาที
<SELECT name="m_start" >
<?
for ($i=0;$i<=59;$i++){
if($step == "confirm"){
if(intval($m_start) == $i){ $sel = "SELECTED";}else{ $sel = "";}
}else{
if(intval($m_st) == $i){ $sel = "SELECTED";}else{ $sel = "";}
}
echo "<option value='".sprintf("%02d",$i)."' $sel>" . sprintf("%02d",$i) . "</option>";
}
?>
</SELECT>
วินาที
<SELECT name="sc_start" >
<?
for ($i=0;$i<=59;$i++){
if($step == "confirm"){
if(intval($sc_start) == $i){ $sel = "SELECTED";}else{ $sel = "";}
}else{
if(intval($sc_st) == $i){ $sel = "SELECTED";}else{ $sel = "";}
}
echo "<option value='".sprintf("%02d",$i)."' $sel>" . sprintf("%02d",$i) . "</option>";
}
?>
</SELECT></TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">เวลา สิ้นสุด</TD>
<TD> ชั่วโมง
<SELECT name="h_end" >
<?
for ($i=0;$i<=23;$i++){
if($step == "confirm"){
if(intval($h_end) == $i){ $sel = "SELECTED";}else{ $sel = "";}
}else{
if(intval($h_et) == $i){ $sel = "SELECTED";}else{ $sel = "";}
}
echo "<option value='".sprintf("%02d",$i)."' $sel>" . sprintf("%02d",$i) . "</option>";
}
?>
</SELECT>
นาที
<SELECT name="m_end" >
<?
for ($i=0;$i<=59;$i++){
if($step == "confirm"){
if(intval($m_end) == $i){ $sel = "SELECTED";}else{ $sel = "";}
}else{
if(intval($m_et) == $i){ $sel = "SELECTED";}else{ $sel = "";}
}
echo "<option value='".sprintf("%02d",$i)."' $sel>" . sprintf("%02d",$i) . "</option>";
}
?>
</SELECT>
วินาที
<SELECT name="sc_end" >
<?
for ($i=0;$i<=59;$i++){
if($step == "confirm"){
if(intval($sc_end) == $i){ $sel = "SELECTED";}else{ $sel = "";}
}else{
if(intval($sc_et) == $i){ $sel = "SELECTED";}else{ $sel = "";}
}
echo "<option value='".sprintf("%02d",$i)."' $sel>" . sprintf("%02d",$i) . "</option>";
}
?>
</SELECT></TD>
</TR>
<!--
<TR bgcolor=white valign=top>
<TD class="link_back">อัตราค่าแรง / วัน</TD>
<TD> <INPUT TYPE="text" NAME="std_cost" VALUE="<?//=$rs[std_cost]?>" size="10" maxlength=10 class=inputbox <?//=$lock?>> บาท</TD>
</TR>-->
<!-- <TR bgcolor=white valign=top>
<TD class="link_back">น้ำหนักความสำคัญ</TD>
<TD> <INPUT TYPE="text" NAME="weight" VALUE="<?//=$rs[weight]?>" size="10" maxlength=10 class=inputbox <?//=$lock?>> </TD>
</TR>
-->
<!-- <TR bgcolor=white valign=top>
<TD class="link_back">ที่อยู่</TD>
<TD><TEXTAREA NAME="address" ROWS="3" COLS="60" <?//=$lock?>><?//=$rs[address]?></TEXTAREA></TD>
</TR>
-->
<TR bgcolor=white valign=top>
<TD class="link_back">โทรศัพท์</TD>
<TD> <INPUT TYPE="text" NAME="telno" VALUE="<?=$rs[telno]?>" size="60" maxlength=100 class=inputbox <?=$lock?>> </TD>
</TR>
<?
if ($hr_db){
?>
<TR bgcolor=white valign=top>
<TD class="link_back">เชื่อมโยงกับบุคลากร CMSS</TD>
<TD>
<SELECT name="hr_id">
<OPTION value=""> - ไม่ระบุ - </OPTION>
<?
$hresult = mysql_query("select * from $hr_db.general where unit='$office_id';");
while ($hrs = mysql_fetch_assoc($hresult)){
if ($rs[hr_id] == $hrs[id]) $sel="SELECTED"; else $sel="";
echo "<option value='$hrs[id]' $sel>$hrs[name_th] $hrs[surname_th]</option>";
}
?>
</SELECT> </TD>
</TR>
<?
}
?>
<TR bgcolor=white valign=top>
<TD class="link_back">หมายเหตุ</TD>
<TD><TEXTAREA NAME="comment" ROWS="3" COLS="60" <?=$lock?>><?=$rs[comment]?></TEXTAREA></TD>
</TR>
<TR bgcolor="#888899" valign=top>
<TD colspan=2 align=right>
<INPUT TYPE="submit" VALUE=" บันทึก " CLASS=xbutton>
<INPUT TYPE="reset" VALUE=" ยกเลิก " class=xbutton ONCLICK="location.href='?org_id=<?=$org_id?>&type=<?=$type?>';"> </TD>
</TR>
</TABLE>
</FORM>
<?
//====================================================================
}else if ($_GET[action] == "show" ){
$sql = "select * from $table_staff where staffid='$id';";
$result = mysql_query($sql);
$rs = mysql_fetch_assoc($result);
if ($rs[sex] == "M") $sex = "man"; else $sex="girl";
?>
<BR>
<TABLE border=0 align=center cellspacing=1 cellpadding=3 bgcolor="#808080" width="98%">
<TR bgcolor="#a3b2cc">
<TD width="150"><FONT COLOR="WHITE" style="font-size:14pt;"><IMG src="images/<?=$sex?>.gif" align=middle> <B>ข้อมูล<?=$report_title?></B></FONT></TD>
<TD align=right>
<? if(($db_mode=="self") && ($type=="system")){ ?>
<INPUT TYPE="reset" VALUE=" แก้ไข " class=xbutton ONCLICK="location.href='?org_id=<?=$org_id?>&id=<?=$id?>&action=edit&type=<?=$type?>';">
<? } ?> </TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">Username </TD>
<TD> <?=$rs[username]?> <!--<INPUT type=button value=" Reset Password" onClick="if(confirm('ต้องการ reset รหัสผ่านของผู้ใช้คนนี้กลับไปเป็น logon ใช่หรือไม่?')) location.href='?org_id=<?=$org_id?>&id=<?=$id?>&action=resetpwd';">--></TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">ตำแหน่ง</TD>
<TD><?=$rs[title]?></TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">ชื่อ - นามสกุล </TD>
<TD><?=$rs[prename]?> <?=$rs[staffname]?> <?=$rs[staffsurname]?> </TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">Email Address</TD>
<TD><?=$rs[email]?></TD>
</TR>
<!-- <TR bgcolor=white valign=top>
<TD class="link_back">เลขบัตรประจำตัวประชาชน</TD>
<TD><?//=$rs[card_id]?></TD>
</TR>
-->
<TR bgcolor=white valign=top>
<TD class="link_back">สถานะ</TD>
<TD>
<?
$status_array = array("0"=>"เข้าระบบได้ตามปกติ","1"=>"ระงับการเข้าระบบ");
echo $status_array[intval($rs[status])];
?>
</select> </TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">ปี/เดือน/วัน เริ่มต้น</TD>
<TD>
<?
$arr_sd1 = explode("-",$rs[date_start]);
$yy_sd1 = (intval($arr_sd1[0])+543);
if($yy_sd1 > 543){
echo intval($arr_sd1[2])." ".$mname[intval($arr_sd1[1])]." ".$yy_sd1;
}
?>
</TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">ปี/เดือน/วัน สิ้นสุด</TD>
<TD>
<?
$arr_ed = explode("-",$rs[date_end]);
$yy_ed = (intval($arr_ed[0])+543);
if($yy_ed > 543){
echo intval($arr_ed[2])." ".$mname[intval($arr_ed[1])]." ".$yy_ed;
}
?>
</TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">เวลา เริ่มต้น</TD>
<TD>
<?
if($rs[time_start] != "00:00:00" and $rs[time_start] != NULL){
echo "$rs[time_start] น.";
}
?>
</TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">เวลา สิ้นสุด</TD>
<TD>
<?
if($rs[time_end] != "00:00:00" and $rs[time_end] != NULL){
echo "$rs[time_end] น.";
}
?>
</TD>
</TR>
<!-- <TR bgcolor=white valign=top>
<TD class="link_back">ที่อยู่</TD>
<TD><?//=nl2br($rs[address])?></TD>
</TR>-->
<TR bgcolor=white valign=top>
<TD class="link_back">โทรศัพท์</TD>
<TD> <?=$rs[telno]?></TD>
</TR>
<TR bgcolor=white valign=top>
<TD class="link_back">หมายเหตุ</TD>
<TD><?=nl2br($rs[comment])?></TD>
</TR>
<TR bgcolor="#DDDDEE" >
<TD class="link_back" colspan=2><IMG src="images/users.gif" align=middle> สังกัดกลุ่ม</TD>
</TR>
<TR bgcolor="white" valign=top>
<TD colspan=2>
<?
//echo " <img src='dtree/img/users.gif' > (ทั่วไป) <BR>";
$sql = "select t2.* from $table_groupmember t1 inner join $table_staffgroup t2 on t1.gid=t2.gid where t1.staffid='$id';";
$xresult = mysql_query($sql);
while ($xrs=mysql_fetch_assoc($xresult)){
echo " <img src='dtree/img/users.gif' > $xrs[groupname] <BR>";
}
?> </TD>
</TR>
</TABLE>
<?
//====================================================================
}else if ($_GET[action] == "import" ){
?>
<H3>นำเข้าข้อมูลจากระบบ Competency</H3>
<FORM METHOD=POST ACTION="">
<INPUT TYPE="hidden" NAME="action" VALUE="<?=$action?>">
<INPUT TYPE="hidden" NAME="org_id" VALUE="<?=$org_id?>">
<TABLE border=0 align=center cellspacing=1 cellpadding=2 bgcolor=black width="98%" class="sortable" id="unique_id">
<TR bgcolor="#a3b2cc">
<TH width=72>ลำดับ</TH>
<TH width="342">ชื่อ - นามสกุล</TH>
<TH width="464">ตำแหน่ง</TH>
<TH width=40>เลือก</TH>
</TR>
<?
$n = 0;
$sql = "select * from $hr_db.general where unit='$office_id';";
$result = mysql_query($sql);
while ($rs = mysql_fetch_assoc($result)){
if ($n++ % 2) $bgcolor = "#F0F0F0"; else $bgcolor = "#FFFFFF";
?>
<TR BGCOLOR="<?=$bgcolor?>">
<TD ALIGN=CENTER><?=$n?></TD>
<TD ALIGN=LEFT> <?=$rs[prename_th]?> <?=$rs[name_th]?> <?=$rs[surname_th]?></TD>
<TD ALIGN=CENTER><?=$rs[position_now]?></TD>
<TD ALIGN=CENTER><INPUT TYPE="checkbox" NAME="hr_id[]" value="<?=$rs[id]?>"></TD>
</TR>
<?
} //while
?>
</TABLE>
<P align=right>
<INPUT TYPE="submit" VALUE=" นำเข้าข้อมูลที่เลือก ">
</P>
</FORM>
<?
}else{//ไม่ระบุ action
//====================================================================
?>
<BR>
<TABLE border=0 align=center cellspacing=1 cellpadding=2 width="98%">
<TR><TD width=35><IMG src="images/user_icon.gif"></TD>
<TD> <B style="font-size: 12pt;">
<?
if ($org_id > 0){
?>
บุคลากรในหน่วยงาน <?=Query1("select NLABEL from main_menu where NID='$org_id';")?>
<?
}else{
?>
บุคลากรไม่สังกัดหน่วยงาน
<?
}
?>
</B>
</TD></TR>
<TR valign=top height=1 bgcolor="#808080"><TD colspan=2></TD></TR>
<TR valign=top><TD colspan=2>
<BR><BR>
<? if(($db_mode=="self") && ($type=="system")){ ?>
<IMG src="images/profile_collapsed.gif"> <A HREF="?action=new&org_id=<?=$org_id?>&type=<?=$type?>">เพิ่มข้อมูลใหม่</A>
<?if ($hr_db){?>
<IMG src="images/profile_collapsed.gif"> <A HREF="?action=import&org_id=<?=$org_id?>&type=<?=$type?>">นำเข้าข้อมูลจากระบบ competency</A>
<?}?>
<?}?>
</TD>
</TR>
</TABLE>
<TABLE border=0 align=center cellspacing=1 cellpadding=2 bgcolor=black width="98%" class="sortable" id="unique_id">
<TR bgcolor="#a3b2cc">
<TH width=50>ลำดับ</TH>
<TH width="172">Username</TH>
<TH width="605">ชื่อ - นามสกุล</TH>
<BR><BR>
<? if(($db_mode=="self") && ($type=="system")){ ?>
<TH width=91> </TH>
<? }?>
</TR>
<?
$sql = "select * from $table_staff where org_id='$org_id'";
$result = mysql_query($sql);
while ($rs=mysql_fetch_assoc($result)){
$prename_th[$rs[staffid]] = $rs[prename]; // คำนำหน้าชื่อ
$name_th[$rs[staffid]] = $rs[staffname]; // ชื่อ
$surname_th[$rs[staffid]] = $rs[staffsurname]; // นามสกุล
$user_name[$rs[staffid]] = $rs[username];
$tel[$rs[staffid]] = $rs[telno]; // เบอร์โทร
}// end while(){
th_asort($name_th);
$n = 0;
foreach($name_th as $key => $val){
if ($n++ % 2){
$bgcolor = "#F0F0F0";
}else{
$bgcolor = "#FFFFFF";
}
?>
<TR valign=top bgcolor="<?=$bgcolor?>">
<TD align=center ><?=$n?></TD>
<TD ><?=$user_name[$key]?></TD>
<TD ><?=$prename_th[$key]?> <?=$name_th[$key]?> <?=$surname_th[$key]?></TD>
<? if(($db_mode=="self") && ($type=="system")){ ?>
<TD align=center><A href="?action=edit&id=<?=$key?>&org_id=<?=$org_id?>&type=<?=$type?>"><IMG src="../../../images/b_edit.png" alt="แก้ไข" width="16" height="16" border="0"></A>
<A href="#" ONCLICK="if (confirm('ต้องการลบข้อมูลนี้ใช่หรือไม่?')) location.href='?action=delete&id=<?=$key?>&org_id=<?=$org_id?>&type=<?=$type?>';">
<IMG src="../../../images/b_drop.png" alt="ลบข้อมูล" width="16" height="16" border="0"></A></TD>
<? }?>
</TR>
<?
}// end foreach(){
?>
</TABLE>
<?
}
?>
<BR><BR>
</BODY>
</HTML>