📄 hrms.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>人员档案</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<?
$query="select * from USER where USER_ID='$USER_ID'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$USER_NAME=$ROW["USER_NAME"];
$SEX=$ROW["SEX"];
if($SEX=="0")
$SEX_DESC="男";
else if($SEX=="1")
$SEX_DESC="女";
else
$SEX_DESC="";
}
//-- 首先查询是否已录入过数据 --
$query="select * from HRMS where USER_ID='$USER_ID'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$CARD_NO=$ROW["CARD_NO"];
$MARRY=$ROW["MARRY"];
$WORK_DATE=$ROW["WORK_DATE"];
$WORK_DATE=strtok($WORK_DATE," ");
$JOIN_DATE=$ROW["JOIN_DATE"];
$JOIN_DATE=strtok($JOIN_DATE," ");
$EDUCATION=$ROW["EDUCATION"];
$POLITICS=$ROW["POLITICS"];
$REWARD=$ROW["REWARD"];
$CERTIFICATE=$ROW["CERTIFICATE"];
$TRAIN=$ROW["TRAIN"];
$RESUME=$ROW["RESUME"];
$PHOTO=$ROW["PHOTO"];
$NO=$ROW["NO"];
$NATION=$ROW["NATION"];
$NATIVE_PLACE=$ROW["NATIVE_PLACE"];
$SPECIALITY=$ROW["SPECIALITY"];
$SCHOOL=$ROW["SCHOOL"];
$DEPARTMENT=$ROW["DEPARTMENT"];
$POST=$ROW["POST"];
$HOME_ADDR=$ROW["HOME_ADDR"];
$HOME_TEL=$ROW["HOME_TEL"];
$EMAIL=$ROW["EMAIL"];
$EDU=$ROW["EDU"];
$WORK=$ROW["WORK"];
$SOCIATY=$ROW["SOCIATY"];
$ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
$ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
$TECH_POST=$ROW["TECH_POST"];
$HUKOU_PLACE=$ROW["HUKOU_PLACE"];
$POST_CHANGE=$ROW["POST_CHANGE"];
$SURETY=$ROW["SURETY"];
$CONTRACT=$ROW["CONTRACT"];
$INSURE=$ROW["INSURE"];
$BODY_EXAMIM=$ROW["BODY_EXAMIM"];
$HR_BIRTHDAY=$ROW["HR_BIRTHDAY"];
$USERDEF11=$ROW["USERDEF1"];
$USERDEF21=$ROW["USERDEF2"];
$USERDEF31=$ROW["USERDEF3"];
$USERDEF41=$ROW["USERDEF4"];
$USERDEF51=$ROW["USERDEF5"];
if($HR_BIRTHDAY=="0000-00-00"||$HR_BIRTHDAY=="1900-01-01")
$HR_BIRTHDAY="";
if($HR_BIRTHDAY!="")
{
$AGE=date("Y",time())-substr($HR_BIRTHDAY,0,4)-1;
if(date("m-d",time())>=substr($HR_BIRTHDAY,5))
$AGE++;
}
if($JOIN_DATE=="1900-01-01" || $JOIN_DATE=="0000-00-00")
$JOIN_DATE="";
if($WORK_DATE=="1900-01-01" || $WORK_DATE=="0000-00-00")
$WORK_DATE="";
$OPERATION=2;
$STATUS="已建档";
}
else
{
$OPERATION=1;
$STATUS="未建档";
}
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/hrms.gif" HEIGHT="20"><span class="big3"> 人员档案（<?=$USER_NAME?>）- <?=$STATUS?></span>
</td>
</tr>
</table>
<table align="center" border="0" width="90%" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<tr>
<td nowrap class="TableHeader" colspan="3"><b> 基本信息</b></td>
</tr>
<tr>
<td nowrap class="TableData" width="80"> 编号：</td>
<td class="TableData" width="280">
<?=$NO?>
</td>
<td class="TableData" width=103 align="center" rowspan="7">
<?
if($PHOTO=="")
echo "<center>暂无照片</center>";
else
echo "<img src='/inc/hrms_pic.php?PHOTO=$PHOTO' width='100' border=1>";
?></td>
</tr>
<tr>
<td nowrap class="TableData"> 民族：</td>
<td class="TableData">
<?=$NATION?>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 性别：</td>
<td class="TableData">
<?=$SEX_DESC?>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 年龄：</td>
<td class="TableData">
<?=$AGE?>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 出生日期：</td>
<td class="TableData" nowrap>
<?=$HR_BIRTHDAY?>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 婚姻状况：</td>
<td class="TableData">
<?
if($MARRY=="0") echo "未婚";
elseif($MARRY=="1") echo "已婚";
elseif($MARRY=="2") echo "离异";
?>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 身份证号码：</td>
<td class="TableData">
<?=$CARD_NO?>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 籍贯：</td>
<td class="TableData" colspan="2">
<?=$NATIVE_PLACE?>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 户口所在地：</td>
<td class="TableData" colspan="2">
<?=$HUKOU_PLACE?>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 学历：</td>
<td class="TableData" colspan="2">
<?
if($EDUCATION==1) echo "小学";
elseif($EDUCATION==2) echo "初中";
elseif($EDUCATION==3) echo "高中";
elseif($EDUCATION==4) echo "中专";
elseif($EDUCATION==5) echo "大专";
elseif($EDUCATION==6) echo "大本";
elseif($EDUCATION==7) echo "硕士";
elseif($EDUCATION==8) echo "博士";
elseif($EDUCATION==9) echo "博士后";
?>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 专业：</td>
<td class="TableData" colspan="2">
<?=$SPECIALITY?>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 毕业院校：</td>
<td class="TableData" colspan="2">
<?=$SCHOOL?>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 参加工作时间：</td>
<td class="TableData" nowrap colspan="2">
<?=$WORK_DATE?>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 加入本单位时间：</td>
<td class="TableData" nowrap colspan="2">
<?=$JOIN_DATE?>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 部门：</td>
<td class="TableData" colspan="2">
<?=$DEPARTMENT?>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 职务：</td>
<td class="TableData" colspan="2">
<?=$POST?>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 职称：</td>
<td class="TableData" colspan="2">
<?=$TECH_POST?>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 政治面貌：</td>
<td class="TableData" colspan="2">
<?
if($POLITICS==1) echo "群众";
elseif($POLITICS==2) echo "团员";
elseif($POLITICS==3) echo "党员";
elseif($POLITICS==4) echo "预备党员";
?>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 家庭住址：</td>
<td class="TableData" colspan="2">
<?=$HOME_ADDR?>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 家庭电话：</td>
<td class="TableData" colspan="2">
<?=$HOME_TEL?>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 电子邮件：</td>
<td class="TableData" colspan="2">
<?=$EMAIL?>
</td>
</tr>
<tr>
<td nowrap class="TableHeader" colspan="3"><b> 岗位变动情况：</b></td>
</tr>
<tr>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -