hrms.php
来自「通达OA官方提供的30源代码,感觉很实在」· PHP 代码 · 共 441 行
PHP
441 行
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
include_once("inc/utility_field.php");
?>
<script>
function myprint()
{
document.execCommand('Print');
}
</script>
<html>
<head>
<title>人员基本信息</title>
</head>
<body leftmargin="0" topmargin="0">
<?
$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"];
$CONTRACTTYPE=$ROW["CONTRACTTYPE"];
$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="未建档";
}
$query1="SELECT USER_NAME,DEPT_NAME from USER a
LEFT OUTER JOIN DEPARTMENT b
ON a.DEPT_ID = b.DEPT_ID
where a.USER_ID='$USER_ID'";
$cursor1 = exequery($connection, $query1);
if($ROW=mysql_fetch_array($cursor1))
{
$DEPT_NAME=$ROW["DEPT_NAME"];
}
?>
<table width="190" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height=5> </td>
</tr>
</table>
<table width="650" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<table width="100%" class="TableBlock">
<tr>
<td class="TableHeader" colspan="6"> 基本信息</td>
</tr>
<tr>
<td width="100" height="30" class="TableData">
<div align="center">姓 名： </div></td>
<td height="30" width="100" class="TableData"><div align="center"> <?=$USER_NAME?></div></td>
<td width="100" height="30" class="TableData">
<div align="center">编 号：</div></td>
<td height="30" width="100" class="TableData"><div align="center"> <?=$NO?></div></td>
<td colspan="2" rowspan="4" class="TableData">
<div align="center">
<?
if($PHOTO=="")
echo "<center>暂无照片</center>";
else
echo "<img src='/inc/hrms_pic.php?PHOTO=$PHOTO' width='100' border=1>";
?>
</div>
<div align="center"></div>
</td>
</tr>
<tr>
<td width="100" height="30" align="center" class="TableData"><div align="center">性 别：</div></td>
<td height="30" class="TableData"><div align="center"> <?=$SEX_DESC?></div></td>
<td width="100" align="center" class="TableData"><div align="center">出生日期：</div></td>
<td height="30" class="TableData"><div align="center"> <?=$HR_BIRTHDAY?></div></td>
</tr>
<tr>
<td width="100" height="30" align="center"class="TableData"><div align="center">民 族：</div></td>
<td height="30"class="TableData"><div align="center"> <?=$NATION?></div></td>
<td width="100" align="center" class="TableData"><div align="center">籍 贯：</div></td>
<td height="30" width="100" align="center" class="TableData"><div align="center"> <? echo get_code_name($NATIVE_PLACE,"AREA");?></div></td>
</tr>
<tr>
<td width="100" height="30" align="center"class="TableData"><div align="center">政治面貌：</div></td>
<td class="TableData"><div align="center"> <? echo hrms_field_value("POLITICS",$POLITICS);?></div></td>
<td width="100" class="TableData"><div align="center">婚姻状况：</div></td>
<td height="30" width="100" class="TableData"><div align="center"> <? echo hrms_field_value("MARRY",$MARRY);?></div></td>
</tr>
<tr>
<td width="100" height="30" align="center" class="TableData"><div align="center">学 历：</div></td>
<td class="TableData"><div align="center"> <? echo hrms_field_value("EDUCATION",$EDUCATION);?></div></td>
<td width="100" class="TableData"><div align="center">毕业院校：</div></td>
<td height="30" width="100" class="TableData">
<div align="center"> <?=$SCHOOL?></div>
</td>
<td width="50" height="30" class="TableData" nowrap><div align="center">专业：</div></td>
<td height="30" class="TableData">
<div align="center"> <?=$SPECIALITY?></div></td>
</tr>
<tr>
<td width="100" height="30" align="center" nowrap class="TableData"><div align="center">身份证号码：</div></td>
<td height="30" class="TableData"><div align="center"> <?=$CARD_NO?></div></td>
<td width="100" class="TableData" nowrap><div align="center">户口所在地：</div></td>
<td height="30" width="120" class="TableData" colspan="3">
<div align="center"> <?=$HUKOU_PLACE?>
</div></td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" class="TableBlock">
<tr>
<td class="TableHeader" colspan="4"> 联系方式</td>
</tr>
<tr>
<td width="100" height="30" class="TableData">
<div align="center">家庭电话：</div></td>
<td height="30" class="TableData"><div align="center"> <?=$HOME_TEL?></div></td>
<td width="100" height="30" class="TableData">
<div align="center">电子邮箱：</div></td>
<td height="30" class="TableData"><div align="center"> <?=$EMAIL?></div></td>
</tr>
<tr>
<td width="100" height="30" align="center" class="TableData"><div align="center">家庭住址：</div></td>
<td height="30" class="TableData" colspan="3"><div align="center"> <?=$HOME_ADDR?></div></td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" class="TableBlock">
<tr>
<td class="TableHeader" colspan="6"> 工作情况</td>
</tr>
<tr>
<td width="100" height="30" class="TableData"><div align="center">所在部门：</div></td>
<td height="30" colspan="2" class="TableData"><div align="center"> <?=$DEPT_NAME?></div></td>
<td width="100" height="30" class="TableData"><div align="center">员工类型：</div></td>
<td height="30" colspan="2" class="TableData"><div align="center"> <? echo get_code_name($CONTRACTTYPE,"CONTRACTTYPE");?></div></td>
</tr>
<tr>
<td width="100" height="30" class="TableData"><div align="center">职 务：</div></td>
<td height="30" colspan="2" class="TableData"><div align="center"> <?=$POST?></div></td>
<td width="100" height="30" class="TableData"><div align="center">职 称：</div></td>
<td height="30" colspan="2" class="TableData"><div align="center"> <? echo get_code_name($TECH_POST,"TECH_POST");?></div></td>
</tr>
<tr>
<td width="100" height="30" class="TableData"><div align="center">参加工作时间：</div></td>
<td height="30" colspan="2" class="TableData"><div align="center"> <?=$WORK_DATE?></div></td>
<td width="100" height="30" class="TableData"><div align="center">进入单位时间：</div></td>
<td height="30" colspan="2" class="TableData"><div align="center"> <?=$JOIN_DATE?></div></td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" class="TableBlock">
<tr>
<td class="TableHeader"> 岗位变动情况</td>
</tr>
<tr>
<td height="40" class="TableData"><?=str_replace("\n","<br>",$POST_CHANGE)?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" class="TableBlock">
<tr>
<td class="TableHeader"> 教育背景</td>
</tr>
<tr>
<td height="30" class="TableData"><?=str_replace("\n","<br>",$EDU)?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" class="TableBlock">
<tr>
<td class="TableHeader" valign="bottom" > 工作简历</td>
</tr>
<tr>
<td height="30" class="TableData"><?=str_replace("\n","<br>",$WORK)?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" class="TableBlock">
<tr>
<td class="TableHeader"> 社会关系</td>
</tr>
<tr>
<td height="30" class="TableData"><?=str_replace("\n","<br>",$SOCIATY)?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" class="TableBlock">
<tr>
<td class="TableHeader"> 奖惩记录</td>
</tr>
<tr>
<td height="30" class="TableData"><?=str_replace("\n","<br>",$REWARD)?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" class="TableBlock">
<tr>
<td class="TableHeader"> 职务情况</td>
</tr>
<tr>
<td height="30" class="TableData"><?=str_replace("\n","<br>",$CERTIFICATE)?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" class="TableBlock">
<tr>
<td class="TableHeader"> 培训记录</td>
</tr>
<tr>
<td height="30" class="TableData"><?=str_replace("\n","<br>",$TRAIN)?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" class="TableBlock">
<tr>
<td class="TableHeader"> 担保记录</td>
</tr>
<tr>
<td height="30" class="TableData"><?=str_replace("\n","<br>",$SURETY)?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" class="TableBlock">
<tr>
<td class="TableHeader"> 劳动合同签订情况</td>
</tr>
<tr>
<td height="30" class="TableData"><?=str_replace("\n","<br>",$CONTRACT)?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" class="TableBlock">
<tr>
<td class="TableHeader"> 社保缴纳情况</td>
</tr>
<tr>
<td height="30" class="TableData"><?=str_replace("\n","<br>",$INSURE)?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" class="TableBlock">
<tr>
<td class="TableHeader"> 体检记录</td>
</tr>
<tr>
<td height="30" class="TableData"><?=str_replace("\n","<br>",$BODY_EXAMIM)?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" class="TableBlock">
<tr>
<td class="TableHeader"> 备注</td>
</tr>
<tr>
<td height="30" class="TableData"> <?=str_replace("\n","<br>",$RESUME)?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" class="TableBlock">
<tr>
<td class="TableHeader" colspan="2"> 自定义字段</td>
</tr>
<?=get_hrm_table(get_field_text("HRMS", $USER_ID))?>
</table>
</td>
</tr>
</table>
<div id=MyWebBrowser></div>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?