⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 hrms.php

📁 极限网络智能办公系统 - Office Automation 2.8 100％ 源码
💻 PHP
字号:
🔍 
<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
echo "\r\n<html>\r\n<head>\r\n<title>人员档案</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$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'];
	$BIRTHDAY = $ROW['BIRTHDAY'];
	$BIRTHDAY = substr( $BIRTHDAY, 0, 10 );
	if ( $SEX == "0" )
	{
		$SEX_DESC = "男";
	}
	else if ( $SEX == "1" )
	{
		$SEX_DESC = "女";
	}
	else
	{
		$SEX_DESC = "";
	}
	if ( $BIRTHDAY == "0000-00-00" || $BIRTHDAY == "1900-01-01" )
	{
		$BIRTHDAY = "";
	}
}
if ( $BIRTHDAY != "" )
{
	$AGE = date( "Y", time( ) ) - substr( $BIRTHDAY, 0, 4 ) - 1;
	if ( substr( $BIRTHDAY, 5 ) <= date( "m-d", time( ) ) )
	{
		++$AGE;
	}
}
$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'];
	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 = "未建档";
}
echo "\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n  <tr>\r\n    <td class=\"Big\"><img src=\"/images/menu/hrms.gif\" HEIGHT=\"20\">";
echo "<s";
echo "pan class=\"big3\"> 人员档案（";
echo $USER_NAME;
echo "）- ";
echo $STATUS;
echo "</span>\r\n    </td>\r\n  </tr>\r\n</table>\r\n\r\n <table align=\"center\" border=\"0\" width=\"90%\" cellpadding=\"2\" cellspacing=\"1\" align=\"center\" bgcolor=\"#000000\" class=\"small\">\r\n    <tr>\r\n      <td nowrap class=\"TableHeader\" colspan=\"3\"><b>&nbsp;基本信息</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\" width=\"80\"> 编号：</td>\r\n      <td class=\"TableData\" width=\"280\">\r\n        ";
echo $NO;
echo "      </td>\r\n      <td class=\"TableData\" width=\"100\" rowspan=\"7\">\r\n";
if ( $PHOTO == "" )
{
	echo "<center>暂无照片</center>";
}
else
{
	echo "<img src='/inc/hrms_pic.php?PHOTO={$PHOTO}' width='100' border=1>";
}
echo "</td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 民族：</td>\r\n      <td class=\"TableData\">\r\n          ";
echo $NATION;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 性别：</td>\r\n      <td class=\"TableData\">\r\n        ";
echo $SEX_DESC;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 年龄：</td>\r\n      <td class=\"TableData\">\r\n          ";
echo $AGE;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 出生日期：</td>\r\n      <td class=\"TableData\" nowrap>\r\n        ";
echo $BIRTHDAY;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 婚姻状况：</td>\r\n      <td class=\"TableData\">\r\n        ";
if ( $MARRY == "0" )
{
	echo "未婚";
}
else if ( $MARRY == "1" )
{
	echo "已婚";
}
else if ( $MARRY == "2" )
{
	echo "离异";
}
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 身份证号码：</td>\r\n      <td class=\"TableData\">\r\n        ";
echo $CARD_NO;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 籍贯：</td>\r\n      <td class=\"TableData\" colspan=\"2\">\r\n        ";
echo $NATIVE_PLACE;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 户口所在地：</td>\r\n      <td class=\"TableData\" colspan=\"2\">\r\n        ";
echo $HUKOU_PLACE;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 学历：</td>\r\n      <td class=\"TableData\" colspan=\"2\">\r\n        ";
if ( $EDUCATION == 1 )
{
	echo "小学";
}
else if ( $EDUCATION == 2 )
{
	echo "初中";
}
else if ( $EDUCATION == 3 )
{
	echo "高中";
}
else if ( $EDUCATION == 4 )
{
	echo "中专";
}
else if ( $EDUCATION == 5 )
{
	echo "大专";
}
else if ( $EDUCATION == 6 )
{
	echo "大本";
}
else if ( $EDUCATION == 7 )
{
	echo "硕士";
}
else if ( $EDUCATION == 8 )
{
	echo "博士";
}
else if ( $EDUCATION == 9 )
{
	echo "博士后";
}
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 专业：</td>\r\n      <td class=\"TableData\" colspan=\"2\">\r\n        ";
echo $SPECIALITY;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 毕业院校：</td>\r\n      <td class=\"TableData\" colspan=\"2\">\r\n        ";
echo $SCHOOL;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 参加工作时间：</td>\r\n      <td class=\"TableData\" nowrap colspan=\"2\">\r\n        ";
echo $WORK_DATE;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 加入本单位时间：</td>\r\n      <td class=\"TableData\" nowrap colspan=\"2\">\r\n        ";
echo $JOIN_DATE;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 部门：</td>\r\n      <td class=\"TableData\" colspan=\"2\">\r\n        ";
echo $DEPARTMENT;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 职务：</td>\r\n      <td class=\"TableData\" colspan=\"2\">\r\n        ";
echo $POST;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 职称：</td>\r\n      <td class=\"TableData\" colspan=\"2\">\r\n        ";
echo $TECH_POST;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 政治面貌：</td>\r\n      <td class=\"TableData\" colspan=\"2\">\r\n          ";
if ( $POLITICS == 1 )
{
	echo "群众";
}
else if ( $POLITICS == 2 )
{
	echo "团员";
}
else if ( $POLITICS == 3 )
{
	echo "党员";
}
else if ( $POLITICS == 4 )
{
	echo "预备党员";
}
echo "        </select>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 家庭住址：</td>\r\n      <td class=\"TableData\" colspan=\"2\">\r\n        ";
echo $HOME_ADDR;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 家庭电话：</td>\r\n      <td class=\"TableData\" colspan=\"2\">\r\n        ";
echo $HOME_TEL;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableData\"> 电子邮件：</td>\r\n      <td class=\"TableData\" colspan=\"2\">\r\n        ";
echo $EMAIL;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableHeader\" colspan=\"3\"><b>&nbsp;岗位变动情况：</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableData\" colspan=\"3\">\r\n        ";
echo str_replace( "\n", "<br>", $POST_CHANGE );
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableHeader\" colspan=\"3\"><b>&nbsp;教育背景</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableData\" colspan=\"3\">\r\n        ";
echo str_replace( "\n", "<br>", $EDU );
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableHeader\" colspan=\"3\"><b>&nbsp;工作简历</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableData\" colspan=\"3\">\r\n        ";
echo str_replace( "\n", "<br>", $WORK );
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableHeader\" colspan=\"3\"><b>&nbsp;社会关系</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableData\" colspan=\"3\">\r\n        ";
echo str_replace( "\n", "<br>", $SOCIATY );
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableHeader\" colspan=\"3\"><b>&nbsp;奖惩记录</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableData\" colspan=\"3\">\r\n        ";
echo str_replace( "\n", "<br>", $REWARD );
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableHeader\" colspan=\"3\"><b>&nbsp;职务情况</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableData\" colspan=\"3\">\r\n        ";
echo str_replace( "\n", "<br>", $CERTIFICATE );
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableHeader\" colspan=\"3\"><b>&nbsp;培训记录</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableData\" colspan=\"3\">\r\n        ";
echo str_replace( "\n", "<br>", $TRAIN );
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableHeader\" colspan=\"3\"><b>&nbsp;担保记录</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableData\" colspan=\"3\">\r\n        ";
echo str_replace( "\n", "<br>", $SURETY );
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableHeader\" colspan=\"3\"><b>&nbsp;劳动合同签订情况</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableData\" colspan=\"3\">\r\n        ";
echo str_replace( "\n", "<br>", $CONTRACT );
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableHeader\" colspan=\"3\"><b>&nbsp;社保缴纳情况</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableData\" colspan=\"3\">\r\n        ";
echo str_replace( "\n", "<br>", $INSURE );
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableHeader\" colspan=\"3\"><b>&nbsp;体检记录</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableData\" colspan=\"3\">\r\n        ";
echo str_replace( "\n", "<br>", $BODY_EXAMIM );
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableHeader\" colspan=\"3\"><b>&nbsp;备 注</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableData\" colspan=\"3\">\r\n        ";
echo str_replace( "\n", "<br>", $RESUME );
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableHeader\" colspan=\"3\"><b>&nbsp;附件文档</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableData\" colspan=\"3\">\r\n";
if ( $ATTACHMENT_NAME == "" )
{
	echo "无";
}
else
{
	$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
	$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
	$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
	$I = 0;
	for ( ;	$I < $ARRAY_COUNT;	++$I	)
	{
		if ( $ATTACHMENT_ID_ARRAY[$I] == "" )
		{
		}
		else
		{
			$ATTACH_SIZE = attach_size( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
			$ATTACH_SIZE = number_format( $ATTACH_SIZE, 0, ".", "," );
			echo "       <img src=\"/images/email_atta.gif\" align=\"absmiddle\"><a href=\"/inc/attach.php?ATTACHMENT_ID=";
			echo $ATTACHMENT_ID_ARRAY[$I] * 3 + 2;
			echo "&ATTACHMENT_NAME=";
			echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
			echo "\" target=\"_blank\">";
			echo $ATTACHMENT_NAME_ARRAY[$I];
			echo "</a>\r\n";
			if ( stristr( $ATTACHMENT_NAME_ARRAY[$I], ".doc" ) || stristr( $ATTACHMENT_NAME_ARRAY[$I], ".ppt" ) || stristr( $ATTACHMENT_NAME_ARRAY[$I], ".xls" ) )
			{
				echo "\t     <input type=\"button\" value=\"阅读\" class=\"SmallButton\" onClick=\"window.open('/module/OC?ATTACHMENT_ID=";
				echo $ATTACHMENT_ID_ARRAY[$I] * 3 + 2;
				echo "&ATTACHMENT_NAME=";
				echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
				echo "&OP=5',null,'menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');\">&nbsp;\r\n";
			}
			echo "       (";
			echo $ATTACH_SIZE;
			echo "字节)<br>\r\n";
		}
	}
}
echo "      </td>\r\n    </tr>\r\n    <tr class=\"TableControl\">\r\n      <td nowrap colspan=\"3\" align=\"center\">\r\n        <input type=\"button\" value=\"打印\" class=\"BigButton\" onclick=\"document.execCommand('Print');\">&nbsp;&nbsp;\r\n        <input type=\"button\" value=\"返回\" class=\"BigButton\" onclick=\"location='blank.php'\">\r\n      </td>\r\n    </tr>\r\n    </table>\r\n\r\n</body>\r\n</html>";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -