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

📄 search.php

📁 通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(
💻 PHP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
	$DEPT_ID = $ROW['DEPT_ID'];
	$SEX = $ROW['SEX'];
	$HR_BIRTHDAY = $ROW['HR_BIRTHDAY'];
	$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'];
	$query1 = "SELECT CODE_NAME from SYS_CODE where PARENT_NO='AREA' and CODE_NO='".$NATIVE_PLACE."'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$NATIVE_PLACENAME = $ROW['CODE_NAME'];
	}
	++$HRMS_COUNT;
	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 ( $HR_BIRTHDAY == "0000-00-00" || $HR_BIRTHDAY == "1900-01-01" )
	{
		$HR_BIRTHDAY = "";
	}
	if ( $HRMS_COUNT == 1 )
	{
		echo "<table width=\"100%\" class=\"TableList\">\r\n  <tr class=\"TableHeader\">\r\n  \t  <td nowrap align=\"center\"><a href=\"search.php?";
		echo $urlstr;
		echo "&ORDERFIELD=DEPT_NAME&ORDERSIGN=";
		if ( $ORDERSIGN == "DOWN" )
		{
			echo "UP";
		}
		if ( $ORDERSIGN == "UP" )
		{
			echo "DOWN";
		}
		if ( $ORDERSIGN == "" )
		{
			if ( $ORDERTYPE == "ASC" )
			{
				echo "UP";
			}
			else
			{
				echo "DOWN";
			}
		}
		echo "&ORDERTYPE=";
		echo $ORDERTYPE;
		echo "&CUR_PAGE=";
		echo $CUR_PAGE;
		echo "\">部门&nbsp;";
		if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "DEPT_NAME" )
		{
			echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
		}
		if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "DEPT_NAME" )
		{
			echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
		}
		echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"search.php?";
		echo $urlstr;
		echo "&ORDERFIELD=USER_NAME&ORDERSIGN=";
		if ( $ORDERSIGN == "DOWN" )
		{
			echo "UP";
		}
		if ( $ORDERSIGN == "UP" )
		{
			echo "DOWN";
		}
		if ( $ORDERSIGN == "" )
		{
			if ( $ORDERTYPE == "ASC" )
			{
				echo "UP";
			}
			else
			{
				echo "DOWN";
			}
		}
		echo "&ORDERTYPE=";
		echo $ORDERTYPE;
		echo "&CUR_PAGE=";
		echo $CUR_PAGE;
		echo "\">姓名&nbsp;";
		if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "USER_NAME" )
		{
			echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
		}
		if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "USER_NAME" )
		{
			echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
		}
		echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"search.php?";
		echo $urlstr;
		echo "&ORDERFIELD=HRMS.SEX&ORDERSIGN=";
		if ( $ORDERSIGN == "DOWN" )
		{
			echo "UP";
		}
		if ( $ORDERSIGN == "UP" )
		{
			echo "DOWN";
		}
		if ( $ORDERSIGN == "" )
		{
			if ( $ORDERTYPE == "ASC" )
			{
				echo "UP";
			}
			else
			{
				echo "DOWN";
			}
		}
		echo "&ORDERTYPE=";
		echo $ORDERTYPE;
		echo "&CUR_PAGE=";
		echo $CUR_PAGE;
		echo "\">性别&nbsp;";
		if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "HRMS.SEX" )
		{
			echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
		}
		if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "HRMS.SEX" )
		{
			echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
		}
		echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"search.php?";
		echo $urlstr;
		echo "&ORDERFIELD=HR_BIRTHDAY&ORDERSIGN=";
		if ( $ORDERSIGN == "DOWN" )
		{
			echo "UP";
		}
		if ( $ORDERSIGN == "UP" )
		{
			echo "DOWN";
		}
		if ( $ORDERSIGN == "" )
		{
			if ( $ORDERTYPE == "ASC" )
			{
				echo "UP";
			}
			else
			{
				echo "DOWN";
			}
		}
		echo "&ORDERTYPE=";
		echo $ORDERTYPE;
		echo "&CUR_PAGE=";
		echo $CUR_PAGE;
		echo "\">出生年月&nbsp;";
		if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "HR_BIRTHDAY" )
		{
			echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
		}
		if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "HR_BIRTHDAY" )
		{
			echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
		}
		echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"search.php?";
		echo $urlstr;
		echo "&ORDERFIELD=NATION&ORDERSIGN=";
		if ( $ORDERSIGN == "DOWN" )
		{
			echo "UP";
		}
		if ( $ORDERSIGN == "UP" )
		{
			echo "DOWN";
		}
		if ( $ORDERSIGN == "" )
		{
			if ( $ORDERTYPE == "ASC" )
			{
				echo "UP";
			}
			else
			{
				echo "DOWN";
			}
		}
		echo "&ORDERTYPE=";
		echo $ORDERTYPE;
		echo "&CUR_PAGE=";
		echo $CUR_PAGE;
		echo "\">民族&nbsp;";
		if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "NATION" )
		{
			echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
		}
		if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "NATION" )
		{
			echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
		}
		echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"search.php?";
		echo $urlstr;
		echo "&ORDERFIELD=NATIVE_PLACE&ORDERSIGN=";
		if ( $ORDERSIGN == "DOWN" )
		{
			echo "UP";
		}
		if ( $ORDERSIGN == "UP" )
		{
			echo "DOWN";
		}
		if ( $ORDERSIGN == "" )
		{
			if ( $ORDERTYPE == "ASC" )
			{
				echo "UP";
			}
			else
			{
				echo "DOWN";
			}
		}
		echo "&ORDERTYPE=";
		echo $ORDERTYPE;
		echo "&CUR_PAGE=";
		echo $CUR_PAGE;
		echo "\">籍贯&nbsp;";
		if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "NATIVE_PLACE" )
		{
			echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
		}
		if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "NATIVE_PLACE" )
		{
			echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
		}
		echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"search.php?";
		echo $urlstr;
		echo "&ORDERFIELD=POLITICS&ORDERSIGN=";
		if ( $ORDERSIGN == "DOWN" )
		{
			echo "UP";
		}
		if ( $ORDERSIGN == "UP" )
		{
			echo "DOWN";
		}
		if ( $ORDERSIGN == "" )
		{
			if ( $ORDERTYPE == "ASC" )
			{
				echo "UP";
			}
			else
			{
				echo "DOWN";
			}
		}
		echo "&ORDERTYPE=";
		echo $ORDERTYPE;
		echo "&CUR_PAGE=";
		echo $CUR_PAGE;
		echo "\">政治面貌&nbsp;";
		if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "POLITICS" )
		{
			echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
		}
		if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "POLITICS" )
		{
			echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
		}
		echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"search.php?";
		echo $urlstr;
		echo "&ORDERFIELD=CARD_NO&ORDERSIGN=";
		if ( $ORDERSIGN == "DOWN" )
		{
			echo "UP";
		}
		if ( $ORDERSIGN == "UP" )
		{
			echo "DOWN";
		}
		if ( $ORDERSIGN == "" )
		{
			if ( $ORDERTYPE == "ASC" )
			{
				echo "UP";
			}
			else
			{
				echo "DOWN";
			}
		}
		echo "&ORDERTYPE=";
		echo $ORDERTYPE;
		echo "&CUR_PAGE=";
		echo $CUR_PAGE;
		echo "\">身份证号码&nbsp;";
		if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "CARD_NO" )
		{
			echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
		}
		if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "CARD_NO" )
		{
			echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
		}
		echo "</a></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 $HR_BIRTHDAY;
	echo "</td>\r\n      <td nowrap align=\"center\">";
	echo $NATION;
	echo "</a></td>\r\n      <td nowrap align=\"left\">";
	echo $NATIVE_PLACENAME;
	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 "</table>\r\n<br><center>\r\n";
if ( $HRMS_COUNT != "" && $HRMS_COUNT != 0 )
{
	echo "\t\r\n\t<input type=\"button\" class=\"BigButton\" value=\"全部删除\" onClick=\"delete_all('";
	echo urlencode( $condition_query );
	echo "')\">&nbsp;&nbsp;\r\n";
}
echo "\t\r\n<input type=\"button\" class=\"BigButton\" value=\"返回\" onClick=\"location='query.php'\"></center>\r\n</body>\r\n</html>\r\n";
?>
12

⌨️ 快捷键说明

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