📄 search.php

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

include_once( "inc/auth.php" );
include_once( "inc/check_type.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\r\n";
echo "<s";
echo "cript>\r\nfunction hrms_detail(USER_ID)\r\n{\r\n URL=\"hrms.php?USER_ID=\"+USER_ID;\r\n myleft=(screen.availWidth-500)/2;\r\n window.open(URL,\"read_notify\",\"height=500,width=600,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n}\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$CUR_DATE = date( "Y-m-d", time( ) );
$query = "";
if ( $BIRTHDAY_MIN != "" )
{
	$TIME_OK = is_date( $BIRTHDAY_MIN );
	if ( !$TIME_OK )
	{
		message( "错误", "\"生日\"的\"开始日期\"格式不对，应形如 ".$CUR_DATE );
		button_back( );
		exit( );
	}
	$query .= " and BIRTHDAY>='{$BIRTHDAY_MIN}'";
}
if ( $BIRTHDAY_MAX != "" )
{
	$TIME_OK = is_date( $BIRTHDAY_MAX );
	if ( !$TIME_OK )
	{
		message( "错误", "\"生日\"的\"结束日期\"格式不对，应形如 ".$_obfuscate_Q1VSX0RBVEWk );
		button_back( );
		exit( );
	}
	$query .= " and BIRTHDAY<='{$BIRTHDAY_MAX}'";
}
if ( $WORK_DATE_MIN != "" )
{
	$TIME_OK = is_date( $WORK_DATE_MIN );
	if ( !$TIME_OK )
	{
		message( "错误", "\"参加工作时间\"的\"开始日期\"格式不对，应形如 ".$CUR_DATE );
		button_back( );
		exit( );
	}
	$query .= " and WORK_DATE>='{$WORK_DATE_MIN}'";
}
if ( $WORK_DATE_MAX != "" )
{
	$TIME_OK = is_date( $WORK_DATE_MAX );
	if ( !$TIME_OK )
	{
		message( "错误", "\"参加工作时间\"的\"结束日期\"格式不对，应形如 ".$CUR_DATE );
		button_back( );
		exit( );
	}
	$query .= " and WORK_DATE<='{$WORK_DATE_MAX}'";
}
if ( $JOIN_DATE_MIN != "" )
{
	$TIME_OK = is_date( $JOIN_DATE_MIN );
	if ( !$TIME_OK )
	{
		message( "错误", "\"加入本单位时间\"的\"开始日期\"格式不对，应形如 ".$CUR_DATE );
		button_back( );
		exit( );
	}
	$query .= " and JOIN_DATE>='{$JOIN_DATE_MIN}'";
}
if ( $JOIN_DATE_MAX != "" )
{
	$TIME_OK = is_date( $JOIN_DATE_MAX );
	if ( !$TIME_OK )
	{
		message( "错误", "\"加入本单位时间\"的\"结束日期\"格式不对，应形如 ".$CUR_DATE );
		button_back( );
		exit( );
	}
	$query .= " and JOIN_DATE<='{$JOIN_DATE_MAX}'";
}
if ( $AGE_MIN != "" )
{
	$AGE = intval( $AGE_MIN );
	if ( !is_int( $AGE ) || $AGE <= 0 )
	{
		message( "错误", "年龄应为正整数！" );
		button_back( );
		exit( );
	}
	$YEAR_MIN = date( "Y", time( ) ) - $AGE;
	$YEAR_MIN .= date( "-m-d", time( ) );
	$query .= " and BIRTHDAY<='{$YEAR_MIN}'";
}
if ( $AGE_MAX != "" )
{
	$AGE = intval( $AGE_MAX );
	if ( !is_int( $AGE ) || $AGE <= 0 )
	{
		message( "错误", "年龄应为正整数！" );
		button_back( );
		exit( );
	}
	$YEAR_MAX = date( "Y", time( ) ) - $AGE;
	$YEAR_MAX .= date( "-m-d", time( ) );
	$query .= " and BIRTHDAY>='{$YEAR_MAX}'";
}
if ( $BIRTHDAY_MIN != "" || $BIRTHDAY_MAX != "" || $AGE_MIN != "" || $AGE_MAX != "" )
{
	$query .= " and BIRTHDAY!='0000-00-00' and BIRTHDAY!='1900-01-01'";
}
if ( $DEPT_ID != "" )
{
	$query .= " and USER.DEPT_ID={$DEPT_ID}";
}
if ( $SEX != "" )
{
	$query .= " and SEX='{$SEX}'";
}
if ( $MARRY != "" )
{
	$query .= " and MARRY='{$MARRY}'";
}
if ( $EDUCATION != "" )
{
	$query .= " and EDUCATION='{$EDUCATION}'";
}
if ( $POLITICS != "" )
{
	$query .= " and POLITICS='{$POLITICS}'";
}
if ( $NO != "" )
{
	$query .= " and NO like '%".$NO."%'";
}
if ( $NATION != "" )
{
	$query .= " and NATION like '%".$NATION."%'";
}
if ( $CARD_NO != "" )
{
	$query .= " and CARD_NO like '%".$CARD_NO."%'";
}
if ( $NATIVE_PLACE != "" )
{
	$query .= " and NATIVE_PLACE like '%".$NATIVE_PLACE."%'";
}
if ( $HUKOU_PLACE != "" )
{
	$query .= " and HUKOU_PLACE like '%".$HUKOU_PLACE."%'";
}
if ( $SPECIALITY != "" )
{
	$query .= " and SPECIALITY like '%".$SPECIALITY."%'";
}
if ( $SCHOOL != "" )
{
	$query .= " and SCHOOL like '%".$SCHOOL."%'";
}
if ( $DEPARTMENT != "" )
{
	$query .= " and DEPARTMENT like '%".$DEPARTMENT."%'";
}
if ( $POST != "" )
{
	$query .= " and POST like '%".$POST."%'";
}
if ( $TECH_POST != "" )
{
	$query .= " and TECH_POST like '%".$TECH_POST."%'";
}
if ( $HOME_ADDR != "" )
{
	$query .= " and HOME_ADDR like '%".$HOME_ADDR."%'";
}
if ( $HOME_TEL != "" )
{
	$query .= " and HOME_TEL like '%".$HOME_TEL."%'";
}
if ( $EMAIL != "" )
{
	$query .= " and EMAIL like '%".$EMAIL."%'";
}
if ( $POST_CHANGE != "" )
{
	$query .= " and POST_CHANGE like '%".$POST_CHANGE."%'";
}
if ( $EDU != "" )
{
	$query .= " and EDU like '%".$EDU."%'";
}
if ( $WORK != "" )
{
	$query .= " and WORK like '%".$WORK."%'";
}
if ( $SOCIATY != "" )
{
	$query .= " and SOCIATY like '%".$SOCIATY."%'";
}
if ( $REWARD != "" )
{
	$query .= " and REWARD like '%".$REWARD."%'";
}
if ( $CERTIFICATE != "" )
{
	$query .= " and CERTIFICATE like '%".$CERTIFICATE."%'";
}
if ( $TRAIN != "" )
{
	$query .= " and TRAIN like '%".$TRAIN."%'";
}
if ( $SURETY != "" )
{
	$query .= " and SURETY like '%".$SURETY."%'";
}
if ( $CONTRACT != "" )
{
	$query .= " and CONTRACT like '%".$CONTRACT."%'";
}
if ( $INSURE != "" )
{
	$query .= " and INSURE like '%".$INSURE."%'";
}
if ( $BODY_EXAMIM != "" )
{
	$query .= " and BODY_EXAMIM like '%".$BODY_EXAMIM."%'";
}
if ( $RESUME != "" )
{
	$query .= " and RESUME like '%".$RESUME."%'";
}
$query1 = "select count(*) from HRMS,USER,USER_PRIV";
if ( $DEPT_ID != "0" )
{
	$query1 .= ",DEPARTMENT";
}
$query1 .= " where HRMS.USER_ID=USER.USER_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV";
if ( $DEPT_ID != "0" )
{
	$query1 .= " and USER.DEPT_ID=DEPARTMENT.DEPT_ID";
}
$query1 .= $query;
$cursor = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$HRMS_COUNT = $ROW[0];
}
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/infofind.gif\" width=\"24\" height=\"24\">";
echo "<s";
echo "pan class=\"big3\"> 人事档案查询结果</span><br>\r\n    </td>\r\n    <td valign=\"bottom\">";
echo "<s";
echo "pan class=\"small1\">共&nbsp;";
echo "<s";
echo "pan class=\"big4\">";
echo $HRMS_COUNT;
echo "</span>&nbsp;条信息</span>\r\n    </td>\r\n  </tr>\r\n</table>\r\n\r\n";
$HRMS_COUNT = 0;
$query1 = "select * from HRMS,USER,USER_PRIV";
if ( $DEPT_ID != "0" )
{
	$query1 .= ",DEPARTMENT";
}
$query1 .= " where HRMS.USER_ID=USER.USER_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV";
if ( $DEPT_ID != "0" )
{
	$query1 .= " and USER.DEPT_ID=DEPARTMENT.DEPT_ID";
}
$query1 .= $query." order by";
if ( $DEPT_ID != "0" )
{
	$query1 .= " DEPARTMENT.DEPT_NO,";
}
$query1 .= " USER_PRIV.PRIV_NO,USER.USER_NO";
$cursor = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$HRMS_COUNT;
	$USER_ID = $ROW['USER_ID'];
	$USER_NAME = $ROW['USER_NAME'];
	$DEPT_NAME = $ROW['DEPT_NAME'];
	$SEX = $ROW['SEX'];
	$BIRTHDAY = $ROW['BIRTHDAY'];
	$BIRTHDAY = substr( $BIRTHDAY, 0, 10 );
	$CARD_NO = $ROW['CARD_NO'];
	$NO = $ROW['NO'];
	$NATION = $ROW['NATION'];
	$NATIVE_PLACE = $ROW['NATIVE_PLACE'];
	$TECH_POST = $ROW['TECH_POST'];
	$HUKOU_PLACE = $ROW['HUKOU_PLACE'];
	$POLITICS = $ROW['POLITICS'];
	if ( $SEX == "0" )
	{
		$SEX_DESC = "男";
	}
	else if ( $SEX == "1" )
	{
		$SEX_DESC = "女";
	}
	else
	{
		$SEX_DESC = "";
	}
	if ( $POLITICS == 1 )
	{
		$POLITICS = "群众";
	}
	else if ( $POLITICS == 2 )
	{
		$POLITICS = "团员";
	}
	else if ( $POLITICS == 3 )
	{
		$POLITICS = "党员";
	}
	else if ( $POLITICS == 4 )
	{
		$POLITICS = "预备党员";
	}
	if ( $BIRTHDAY == "0000-00-00" || $BIRTHDAY == "1900-01-01" )
	{
		$BIRTHDAY = "";
	}
	if ( $HRMS_COUNT == 1 )
	{
		echo "<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n  <tr class=\"TableHeader\">\r\n      <td nowrap align=\"center\">部门</td>\r\n      <td nowrap align=\"center\">姓名</td>\r\n      <td nowrap align=\"center\">性别</td>\r\n      <td nowrap align=\"center\">出生年月</td>\r\n      <td nowrap align=\"center\">民族</td>\r\n      <td nowrap align=\"center\">籍贯</td>\r\n      <td nowrap align=\"cent";
		echo "er\"> 政治面貌</td>\r\n      <td nowrap align=\"center\">身份证号码</td>\r\n      <td nowrap align=\"center\">操作</td>\r\n    </tr>\r\n";
	}
	echo " <tr class=\"TableData\">\r\n      <td nowrap align=\"center\">";
	echo $DEPT_NAME;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $USER_NAME;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $SEX_DESC;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $BIRTHDAY;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $NATION;
	echo "</a></td>\r\n      <td nowrap align=\"left\">";
	echo $NATIVE_PLACE;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $POLITICS;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $CARD_NO;
	echo "</td>\r\n      <td nowrap align=\"center\">\r\n      <a href=\"javascript:hrms_detail('";
	echo $USER_ID;
	echo "');\"> 详情</a>\r\n      </td>\r\n    </tr>\r\n";
}
if ( $HRMS_COUNT == 0 )
{
	message( "", "无符合条件的人事档案信息" );
	button_back( );
	exit( );
}
echo "\r\n</table>\r\n<br><center><input type=\"button\" class=\"BigButton\" value=\"返回\" onclick=\"location='query.php'\"></center>\r\n</body>\r\n\r\n</html>\r\n";
?>
⌨️ 快捷键说明

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