hrms.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 398 行
PHP
398 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '<s';
echo 'cript>
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') OR ($HR_BIRTHDAY == '1900-01-01')))
{
$HR_BIRTHDAY = '';
}
if (($HR_BIRTHDAY != ''))
{
$AGE = ((date ('Y', time ()) - substr ($HR_BIRTHDAY, 0, 4)) - 1);
if ((substr ($HR_BIRTHDAY, 5) <= date ('m-d', time ())))
{
++$AGE;
}
}
if ((($JOIN_DATE == '1900-01-01') OR ($JOIN_DATE == '0000-00-00')))
{
$JOIN_DATE = '';
}
if ((($WORK_DATE == '1900-01-01') OR ($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'];
}
echo '
<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%" border="0" cellspacing="0" cellpadding="0" align="center" class="table_bg">
<tr>
<td width="18" class="table_left"> </td>
<td wid';
echo 'th="797" class="title_text" valign="bottom" >基本信息</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" class="border14-1">
<tr>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="110" height="30" class="border14-2">
';
echo '<div align="right">姓 名： </div></td>
<td height="30" class="border14-2"><div align="center"> ';
echo $USER_NAME;
echo '</div></td>
<td width="110" height="30" class="border14-2">
<div align="right">编 号：</div></td>
<td height="30" class="border14-2">
<div align="center"> ';
echo $NO;
echo '</div></td>
<td colspan="2" rowspan="4" class="border14-3">
<div align="center">
';
if (($PHOTO == ''))
{
echo '<center>暂无照片</center>';
}
else
{
echo (((''.'<img src=\'/inc/hrms_pic.php?PHOTO=').$PHOTO).'\' width=\'100\' height=\'145\' border=1>');
}
echo ' </div>
<div align="center"></div>
</td>
</tr>
<tr>
<td width="110" height="30" align="center" class="border14-2"><div align="right">性 别：</div></td>
<td width="110" height="30" class="border14-2"><div align="center"> ';
echo $SEX_DESC;
echo '</div></td>
<td width="110" align="center" class="border14-2"><div align="right">出生日期：</div></td>
<td height="30" width="110" align="center" class="border14-2"><div align="center"> ';
echo $HR_BIRTHDAY;
echo '</div></td>
</tr>
<tr>
<td width="110" height="30" align="center"class="border14-2"><div align="right">民 族：</div></td>
<td width="110" height="30"class="border14-2"><div align="center"> ';
echo $NATION;
echo '</div></td>
<td width="110" align="center" class="border14-2"><div align="right">籍 贯：</div></td>
<td height="30" width="110" align="center" class="border14-2"><div align="center"> ';
echo get_code_name ($NATIVE_PLACE, 'AREA');
echo '</div></td>
</tr>
<tr>
<td width="110" height="30" align="center"class="border14-2"><div align="right">政治面貌：</div></td>
<td class="border14-2"><div align="center">
';
echo hrms_field_value ('POLITICS', $POLITICS);
echo '
</div></td>
<td width="110" class="border14-2"><div align="right">婚姻状况：</div></td>
<td height="30" class="border14-2"><div align="center">
';
echo hrms_field_value ('MARRY', $MARRY);
echo '
</div></td>
</tr>
<tr>
<td width="110" height="30" align="center" class="border14-2"><div align="right">学 历：</div></td>
<td class="border14-2"><div align="center">
';
echo hrms_field_value ('EDUCATION', $EDUCATION);
echo '
</div></td>
<td width="110" class="border14-2"><div align="right">毕业院校：</div></td>
<td height="30" class="border14-2">
<div align="center"> ';
echo $SCHOOL;
echo '</div>
<!--<div align="center"></div>--></td>
<td width="110" height="30" class="border14-2"><div align="right">专 业：</div></td>
<td height="30" class="border14-3">
<div align="center"> ';
echo $SPECIALITY;
echo '</div></td>
</tr>
<tr>
<td width="120" height="30" align="center" nowrap class="border14-4"><div align="right">身份证号码：</div></td>
<td height="30" class="border14-4"><div align="center"> ';
echo $CARD_NO;
echo '</div></td>
<td width="120" class="border14-4" nowrap><div align="center">户口所在地：</div></td>
<td height="30" width="120" class="border14-0" colspan="3">
<div align="center"> ';
echo $HUKOU_PLACE;
echo ' </div></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" class="table_bg">
<tr>
<td width="18" class="table_left"> </td>
<td width="797" class="title_text" va';
echo 'lign="bottom" >联系方式</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" class="border14-1">
<tr>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="110" height="30" class="border14-2">
<div align="right">家庭电话：</d';
echo 'iv></td>
<td height="30" class="border14-2"><div align="center"> ';
echo $HOME_TEL;
echo '</div></td>
<td width="110" height="30" class="border14-2">
<div align="right">电子邮箱：</div></td>
<td height="30" class="border14-3"><div align="center"> ';
echo $EMAIL;
echo '</div></td>
</tr>
<tr>
<td width="110" height="30" align="center" class="border14-4"><div align="right">家庭住址：</div></td>
<td height="30" class="border14-0" colspan="3"><div align="center"> ';
echo $HOME_ADDR;
echo '</div></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" class="table_bg">
<tr>
<td width="18" class="table_left"> </td>
<td width="797" class="title_text" valign="bottom" >工';
echo '作情况</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" class="border14-1">
<tr>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="110" height="30" class="border14-2"><div align="center">所在部门：</div></td>
<td height="';
echo '30" colspan="2" class="border14-2"><div align="center"> ';
echo $DEPT_NAME;
echo '</div></td>
<td width="110" height="30" class="border14-2"><div align="center">用工类型：</div></td>
<td height="30" colspan="2" class="border14-3"><div align="center">';
echo get_code_name ($CONTRACTTYPE, 'CONTRACTTYPE');
echo '</div></td>
</tr>
<tr>
<td width="110" height="30" class="border14-2"><div align="center">职 务：</div></td>
<td height="30" colspan="2" class="border14-2"><div align="center"> ';
echo $POST;
echo '</div></td>
<td width="110" height="30" class="border14-2"><div align="center">职 称：</div></td>
<td height="30" colspan="2" class="border14-3"><div align="center"> ';
echo get_code_name ($TECH_POST, 'TECH_POST');
echo '</div></td>
</tr>
<tr>
<td width="110" height="30" class="border14-4"><div align="center">参加工作时间：</div></td>
<td height="30" colspan="2" class="border14-4"><div align="center"> ';
echo $WORK_DATE;
echo '</div></td>
<td width="110" height="30" class="border14-4"><div align="center">进入单位时间：</div></td>
<td height="30" colspan="2" class="border14-0"><div align="center"> ';
echo $JOIN_DATE;
echo '</div></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" class="table_bg">
<tr>
<td width="18" class="table_left"> </td>
<td width="797" class="title_text" valign="bottom"';
echo ' >岗位变动情况</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" class="border14-1">
<tr>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="40" class="border14-0" align="center">';
echo str_replace ('
', '<br>', $POST_CHANGE);
echo '</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" class="table_bg">
<tr>
<td width="18" class="table_left"> </td>
<td width="797" class="title_text" valign="bottom" >教育背';
echo '景</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" class="border14-1">
<tr>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="30" class="border14-0" align="center">';
echo str_replace ('
', '<br>', $EDU);
echo '</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" class="table_bg">
<tr>
<td width="18" class="table_left"> </td>
<td width="797" class="title_text" valign="bottom" >工作⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?