📄 remind1.php

📁 通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含通达OA2008增強版接近完美破解补丁20081216集及最新通达OA2008ADV(

💻 PHP

字号:

<?php

include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_org.php" );
echo "<html>\r\n<head>\r\n<title>离职人员</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script src=\"/inc/js/module.js\"></script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
$query = "SELECT HRMS.USER_ID,USER.USER_NAME,HRMS.SEX,HR_BIRTHDAY,HRMS.DEPT_ID FROM HRMS,USER WHERE USER.USER_ID=HRMS.USER_ID AND USER.DEPT_ID=0";
$cursor = exequery( $connection, $query );
$COUNT = mysql_num_rows( $cursor );
if ( 0 < $COUNT )
{
	echo "<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\"><span class=\"big3\"> 离职人员</span><br>\r\n    </td>\r\n    <td valign=\"bottom\" align=\"right\"><span class=\"small1\">共&nbsp;<span class=\"big4\">";
	echo $COUNT;
	echo "</span>&nbsp;条信息</span>\r\n    </td>\r\n  </tr>\r\n</table>\r\n<table width=\"100%\" class=\"TableList\">\r\n  <tr class=\"TableHeader\">\r\n  \t  <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    </tr>\r\n";
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$USER_ID = $ROW['USER_ID'];
		$USER_NAME = $ROW['USER_NAME'];
		$DEPT_ID = $ROW['DEPT_ID'];
		if ( $ROW['SEX'] == 0 )
		{
			$SEX_DESC = "男";
		}
		if ( $ROW['SEX'] == 1 )
		{
			$SEX_DESC = "女";
		}
		$HR_BIRTHDAY = $ROW['HR_BIRTHDAY'];
		if ( $HR_BIRTHDAY == "0000-00-00" )
		{
			$HR_BIRTHDAY = "";
		}
		$DEPT_NAME = dept_long_name( $DEPT_ID );
		if ( $DEPT_NAME == "" )
		{
			$DEPT_NAME = "未记录";
		}
		echo " <tr class=\"TableData\">\r\n      <td>";
		echo $DEPT_NAME;
		echo "</td>\r\n      <td align=\"center\">";
		echo $USER_NAME;
		echo "</td>\r\n      <td align=\"center\">";
		echo $SEX_DESC;
		echo "</td>\r\n      <td align=\"center\">";
		echo $HR_BIRTHDAY;
		echo "</td>\r\n      <td align=\"center\">\r\n        <a href=\"hrms.php?USER_ID=";
		echo $USER_ID;
		echo "&SOURCE=remind1\"> 详情</a>\r\n      </td>\r\n    </tr>\r\n";
	}
	echo "</table>\r\n";
}
else
{
	echo "<div align=\"center\">\r\n";
	message( "", "本月无退休人员!" );
	echo "\t\r\n</div>\t\r\n";
}
echo "</body>\r\n</html>\r\n";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -