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

📄 hrms.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 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";
$connection = openconnection( );
$query = "select * from USER where USER_ID='{$USER_ID}'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$USER_NAME = $ROW['USER_NAME'];
	$USER_ACCOUNTS = $ROW['USER_ACCOUNTS'];
}
if ( $_REQUEST['ID'] != "" )
{
	$query = "select * from HRMS where ID=".$_REQUEST['ID']."";
}
else
{
	$query = "select * from HRMS where USER_ID='".$_REQUEST['USER_ID']."'";
}
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$id = $ROW['ID'];
	$CARD_NO = $ROW['CARD_NO'];
	$MARRY = $ROW['MARRY'];
	$WORK_DATE = $ROW['WORK_DATE'];
	$WORK_DATE = strtok( $WORK_DATE, " " );
	$USER_ID = $ROW['USER_ID'];
	$TRUE_NAME = $ROW['TRUE_NAME'];
	$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'];
	$CORP_TEL = $ROW['CORP_TEl'];
	$CORP_FAX = $ROW['CORP_FAX'];
	$EMAIL = $ROW['EMAIL'];
	$EDU = $ROW['EDU'];
	$WORK = $ROW['WORK'];
	$SOCIATY = $ROW['SOCIATY'];
	$OPERATION = 2;
	$STATUS = "已建档";
	$BIRTHDAY = $ROW['BIRTHDAY'];
	$BIRTHDAY = strtok( $BIRTHDAY, " " );
	$OTHERS = $ROW['OTHERS'];
	$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
	if ( $USER_NAME == "" )
	{
		$USER_NAME = $ROW['TRUE_NAME'];
	}
	if ( $USER_ID != "" && $TRUE_NAME == "" )
	{
		$query = "SELECT USER_NAME FROM USER WHERE USER_ID = '".$USER_ID."'";
		$cursor1 = exequery( $connection, $query );
		if ( $result = mysql_fetch_array( $cursor1 ) )
		{
			$USER_NAME = $result['USER_NAME'];
		}
	}
	if ( $USER_ID != "" )
	{
		$query = "SELECT USER_ACCOUNTS FROM USER WHERE USER_ID = '".$USER_ID."'";
		$cursor1 = exequery( $connection, $query );
		if ( $result = mysql_fetch_array( $cursor1 ) )
		{
			$USER_ACCOUNTS = $result['USER_ACCOUNTS'];
		}
	}
}
else
{
	$OPERATION = 1;
	$STATUS = "未建档";
}
if ( $USER_ID )
{
	$query2 = "select SEX from user where USER_ID='".$USER_ID."'";
	$cursor2 = exequery( $connection, $query2 );
	if ( $row2 = mysql_fetch_row( $cursor2 ) )
	{
		$sex = $row2[0];
	}
}
else
{
	$query2 = "select SEX from hrms where ID='".$id."'";
	$cursor2 = exequery( $connection, $query2 );
	if ( $row2 = mysql_fetch_row( $cursor2 ) )
	{
		$sex = $row2[0];
	}
}
if ( $sex == 0 )
{
	$sex = "男";
}
if ( $sex == 1 )
{
	$sex = "女";
}
if ( $sex == 2 )
{
	$sex = "";
}
echo "\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\">\r\n  <tr class=\"tablehead1\">\r\n    <td ><img src=\"/images/menu/hrms.gif\" align=\"absmiddle\">员工档案（";
echo $USER_NAME;
echo "）- ";
echo $STATUS;
echo "    </td>\r\n  </tr>\r\n</table>\r\n\r\n <table border=\"0\" width=\"100%\" cellpadding=\"5\" cellspacing=\"1\" class=\"small\">\r\n    <tr>\r\n      <td nowrap class=\"TableHeader\" colspan=\"3\"><b>&nbsp;基本信息</b></td>\r\n    </tr>\r\n\t";
if ( $USER_ID == "guest" )
{
	$query = "select * from HRMS where USER_ID='{$USER_ID}'";
	$cursor = exequery( $connection, $query );
	echo "\t<tr><td nowrap class=\"TableLine2\" colspan=\"3\">\r\n\t";
	while ( $res = mysql_fetch_array( $cursor ) )
	{
		echo "\t<a href=\"hrms.php?USER_ID=";
		echo $USER_ID;
		echo "&ID=";
		echo $res['ID'];
		echo "\">";
		echo $res['TRUE_NAME'];
		echo "</a>\r\n\t";
	}
	echo "</td></tr>";
}
echo "    <tr>\r\n      <td width=\"20%\" nowrap class=\"TableLine2\"> 编号：</td>\r\n      <td width=\"65%\" class=\"TableLine1\">\r\n        ";
echo $NO;
echo "      </td>\r\n      <td rowspan=\"8\" style=\"width:144px;height:200px;\" class=\"TableLine1\">\r\n";
if ( $PHOTO == "" )
{
	echo "<center>暂无照片</center>";
}
else
{
	echo "<img src='/attachment/hrms_pic/{$PHOTO}' width='144' height='200'>";
}
echo "      </td>\r\n    </tr>\r\n\t<tr>\r\n      <td nowrap class=\"TableLine2\"> 姓名：</td>\r\n      <td class=\"TableLine1\">";
if ( $USER_ID != "" )
{
	echo "<a href=\"/general/info/user/user.php?USER_ID={$USER_ID}\" target=_blank>{$USER_NAME}</a>";
}
else
{
	echo $USER_NAME;
}
echo "         </td>\r\n    </tr>\r\n\t<tr>\r\n      <td nowrap class=\"TableLine2\"> 用户名：</td>\r\n      <td class=\"TableLine1\">\r\n        <input type=\"hidden\" name=\"USER_ID\" size=\"20\" maxlength=\"100\"  value=\"";
echo $USER_ID;
echo "\" class=\"inputborder\" readonly>   \r\n\t\t<input type=\"text\" name=\"USER_ACCOUNTS\" size=\"20\" maxlength=\"100\"  value=\"";
echo $USER_ACCOUNTS;
echo "\" class=\"inputborder\" readonly> \r\n\t\t</td>\r\n    </tr>\r\n\t<tr>\r\n\t  <td nowrap class=\"TableLine2\">性别：</td>\r\n\t  <td class=\"TableLine1\">";
echo $sex;
echo "</td>\r\n   </tr>\r\n\t<tr>\r\n\t  <td nowrap class=\"TableLine2\">部门：</td>\r\n\t  <td class=\"TableLine1\">";
echo $DEPARTMENT;
echo "</td>\r\n   </tr>\r\n\t<tr>\r\n\t  <td nowrap class=\"TableLine2\">民族：</td>\r\n\t  <td class=\"TableLine1\">";
echo $NATION;
echo "</td>\r\n   </tr>\r\n\t<tr>\r\n\t  <td nowrap class=\"TableLine2\">身份证号码：</td>\r\n\t  <td class=\"TableLine1\">";
echo $CARD_NO;
echo "</td>\r\n   </tr>\r\n\t<tr>\r\n\t  <td nowrap class=\"TableLine2\">籍贯：</td>\r\n\t  <td class=\"TableLine1\">";
echo $NATIVE_PLACE;
echo "</td>\r\n   </tr>\r\n\t<tr>\r\n      <td nowrap class=\"TableLine2\">出生年月：</td>\r\n      <td class=\"TableLine1\" colspan=\"2\">";
echo $BIRTHDAY;
echo "</td>\r\n    </tr>\r\n\t<tr>\r\n\t  <td nowrap class=\"TableLine2\">学历：</td>\r\n\t  <td class=\"TableLine1\" colspan=\"2\">";
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=\"TableLine2\" >婚姻状况：</td>\r\n      <td class=\"TableLine1\" colspan=\"2\">";
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=\"TableLine2\">专业：</td>\r\n      <td class=\"TableLine1\" colspan=\"2\">";
echo $SPECIALITY;
echo "</td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableLine2\"> 毕业院校：</td>\r\n      <td class=\"TableLine1\" colspan=\"2\">\r\n        ";
echo $SCHOOL;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableLine2\"> 参加工作时间：</td>\r\n      <td class=\"TableLine1\" nowrap colspan=\"2\">\r\n        ";
echo $WORK_DATE;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableLine2\"> 加入本单位时间：</td>\r\n      <td class=\"TableLine1\" nowrap colspan=\"2\">\r\n        ";
echo $JOIN_DATE;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableLine2\"> 岗位：</td>\r\n      <td class=\"TableLine1\" colspan=\"2\">\r\n        ";
echo $POST;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableLine2\"> 政治面貌：</td>\r\n      <td class=\"TableLine1\" colspan=\"2\">\r\n          ";
if ( $POLITICS == 1 )
{
	echo "群众";
}
else if ( $POLITICS == 2 )
{
	echo "团员";
}
else if ( $POLITICS == 3 )
{
	echo "党员";
}
echo "        </select>      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableLine2\"> 职称：</td>\r\n      <td class=\"TableLine1\" colspan=\"2\">\r\n      ";
echo $CERTIFICATE;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableLine2\"> 家庭住址：</td>\r\n      <td class=\"TableLine1\" colspan=\"2\">\r\n        ";
echo $HOME_ADDR;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableLine2\"> 家庭电话：</td>\r\n      <td class=\"TableLine1\" colspan=\"2\">\r\n        ";
echo $HOME_TEL;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableLine2\"> 电子邮件：</td>\r\n      <td class=\"TableLine1\" colspan=\"2\">\r\n        ";
echo $EMAIL;
echo "      </td>\r\n    </tr>\r\n\t<pre>\r\n    <tr>\r\n      <td nowrap class=\"TableLine2\" colspan=\"3\"><b>&nbsp;奖惩情况：</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableLine1\" colspan=\"3\">\r\n      ";
echo $REWARD;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableLine2\" colspan=\"3\"><b>&nbsp;培训情况：</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableLine1\" colspan=\"3\">\r\n        ";
echo $TRAIN;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableLine2\" colspan=\"3\"><b>&nbsp;教育背景</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableLine1\" colspan=\"3\">\r\n        ";
echo $EDU;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableLine2\" colspan=\"3\"><b>&nbsp;工作简历</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableLine1\" colspan=\"3\">\r\n        ";
echo $WORK;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableLine2\" colspan=\"3\"><b>&nbsp;社会关系</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableLine1\" colspan=\"3\">\r\n        ";
echo $SOCIATY;
echo "      </td>\r\n    </tr>\r\n    <tr>\r\n      <td nowrap class=\"TableLine2\" colspan=\"3\"><b>&nbsp;备 注</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableLine1\" colspan=\"3\">\r\n        ";
echo $RESUME;
echo "<br>      </td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableLine2\" colspan=\"3\"><b>&nbsp;其 它</b></td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableLine1\" colspan=\"3\">";
echo $OTHERS;
echo "<br>      </td>\r\n    </tr>\r\n    <tr>\r\n      <td class=\"TableLine2\">附件：</td><td class=\"TableLine1\" colspan=\"2\">";
echo "<s";
echo "pan class=\"TableData\">\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\"><a href=\"/inc/attach.php?ATTACHMENT_ID=";
			echo $ATTACHMENT_ID_ARRAY[$I] * 3 + 2;
			echo "&ATTACHMENT_NAME=";
			echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
			echo "\">\r\n        ";
			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 "        <input name=\"button\" type=\"button\" class=\"SmallButton\" onClick=\"window.open('/iWebOffice/DocumentEdit.php?RecordID=";
				echo $EMAIL_ID;
				echo "&EditType=0&UserName=";
				echo $_SESSION['LOGIN_USER_ID'];
				echo ";&ATTACHMENT_ID=";
				echo $ATTACHMENT_ID_ARRAY[$I] * 3 + 2;
				echo "&ATTACHMENT_NAME=";
				echo urlencode( $ATTACHMENT_NAME_ARRAY[$I] );
				echo "',null,'menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');\" value=\"阅读\">\r\n        &nbsp;&nbsp;\r\n        ";
			}
			echo "        \r\n(\r\n";
			echo $ATTACH_SIZE;
			echo "字节)<br>\r\n";
		}
	}
}
echo "      </span></td>\r\n    </tr>\r\n    </table>\r\n\r\n\r\n</body>\r\n</html>";
?>

⌨️ 快捷键说明

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