📄 retire.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" );
include_once( "check_priv.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>\r\nfunction operate(USER_ID)\r\n{\r\n window.opener.location=\"hrms.php?USER_ID=\"+USER_ID+\"&SOURCE=remind\";\r\n window.close();\r\n}\t\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
$query1 = "select * from HRMS a \r\n LEFT OUTER JOIN USER b ON a.USER_ID = b.USER_ID\r\n LEFT OUTER JOIN DEPARTMENT f ON b.DEPT_ID=f.DEPT_ID\r\n LEFT OUTER JOIN USER_PRIV g ON b.USER_PRIV=g.USER_PRIV";
$query1 .= " where 1=1";
$query1 .= $query.$WHERE_STR;
$cursor = exequery( $connection, $query1 );
$HRMS_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$DEPT_ID = $ROW['DEPT_ID'];
$USER_ID = $ROW['USER_ID'];
$SEX = $ROW['SEX'];
$HR_BIRTHDAY = $ROW['HR_BIRTHDAY'];
if ( !( $HR_BIRTHDAY == "0000-00-00" ) )
{
if ( $HR_BIRTHDAY == "1900-01-01" )
{
break;
}
}
else
{
continue;
}
if ( $QUERY_DATE1 != "" )
{
if ( $SEX == "0" )
{
$YEAR_MIN = date( "Y", strtotime( $QUERY_DATE1 ) ) - 60;
$YEAR_MIN .= date( "-m-d", strtotime( $QUERY_DATE1 ) );
if ( compare_date( $YEAR_MIN, $HR_BIRTHDAY ) != "-1" )
{
break;
}
}
else
{
$YEAR_MIN = date( "Y", strtotime( $QUERY_DATE1 ) ) - 55;
$YEAR_MIN .= date( "-m-d", strtotime( $QUERY_DATE1 ) );
}
}
if ( compare_date( $YEAR_MIN, $HR_BIRTHDAY ) != "-1" || $QUERY_DATE2 != "" )
{
if ( $SEX == "0" )
{
$YEAR_MAX = date( "Y", strtotime( $QUERY_DATE2 ) ) - 60;
$YEAR_MAX .= date( "-m-d", strtotime( $QUERY_DATE2 ) );
if ( compare_date( $YEAR_MAX, $HR_BIRTHDAY ) == "-1" )
{
break;
}
}
else
{
$YEAR_MAX = date( "Y", strtotime( $QUERY_DATE2 ) ) - 55;
$YEAR_MAX .= date( "-m-d", strtotime( $QUERY_DATE2 ) );
}
}
if ( !( compare_date( $YEAR_MAX, $HR_BIRTHDAY ) == "-1" ) )
{
++$HRMS_COUNT;
}
}
if ( $HRMS_COUNT != 0 )
{
echo "<br>\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\"><span class=\"big3\"> 退休人员</span><br>\r\n </td>\r\n <td valign=\"bottom\" align=\"right\"><span class=\"small1\">共 <span class=\"big4\">";
echo $HRMS_COUNT;
echo "</span> 条信息</span>\r\n </td>\r\n </tr>\r\n</table>\r\n";
$HRMS_COUNT = 0;
$query1 = "select * from HRMS a \r\n LEFT OUTER JOIN USER b ON a.USER_ID = b.USER_ID\r\n LEFT OUTER JOIN DEPARTMENT f ON b.DEPT_ID=f.DEPT_ID\r\n LEFT OUTER JOIN USER_PRIV g ON b.USER_PRIV=g.USER_PRIV";
$query1 .= " where 1=1";
$query1 .= $query.$WHERE_STR;
$cursor = exequery( $connection, $query1 );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$NATIVE_PLACENAME = "";
$USER_ID = $ROW['USER_ID'];
$USER_NAME = $ROW['USER_NAME'];
$DEPT_NAME = $ROW['DEPT_NAME'];
$DEPT_ID = $ROW['DEPT_ID'];
$SEX = $ROW['SEX'];
$HR_BIRTHDAY = $ROW['HR_BIRTHDAY'];
$CONTRACT_DATE1 = $ROW['CONTRACT_DATE1'];
$CONTRACT_DATE2 = $ROW['CONTRACT_DATE2'];
$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'];
}
if ( $SEX == "0" )
{
$SEX_DESC = "男";
}
else if ( $SEX == "1" )
{
$SEX_DESC = "女";
}
else
{
$SEX_DESC = "";
}
if ( !( $HR_BIRTHDAY == "0000-00-00" ) )
{
if ( $HR_BIRTHDAY == "1900-01-01" )
{
break;
}
}
else
{
continue;
}
if ( $QUERY_DATE1 != "" )
{
if ( $SEX == "0" )
{
$YEAR_MIN = date( "Y", strtotime( $QUERY_DATE1 ) ) - 60;
$YEAR_MIN .= date( "-m-d", strtotime( $QUERY_DATE1 ) );
if ( compare_date( $YEAR_MIN, $HR_BIRTHDAY ) != "-1" )
{
break;
}
}
else
{
$YEAR_MIN = date( "Y", strtotime( $QUERY_DATE1 ) ) - 55;
$YEAR_MIN .= date( "-m-d", strtotime( $QUERY_DATE1 ) );
}
}
if ( compare_date( $YEAR_MIN, $HR_BIRTHDAY ) != "-1" || $QUERY_DATE2 != "" )
{
if ( $SEX == "0" )
{
$YEAR_MAX = date( "Y", strtotime( $QUERY_DATE2 ) ) - 60;
$YEAR_MAX .= date( "-m-d", strtotime( $QUERY_DATE2 ) );
if ( compare_date( $YEAR_MAX, $HR_BIRTHDAY ) == "-1" )
{
break;
}
}
else
{
$YEAR_MAX = date( "Y", strtotime( $QUERY_DATE2 ) ) - 55;
$YEAR_MAX .= date( "-m-d", strtotime( $QUERY_DATE2 ) );
}
}
if ( !( compare_date( $YEAR_MAX, $HR_BIRTHDAY ) == "-1" ) )
{
++$HRMS_COUNT;
if ( $HRMS_COUNT == 1 )
{
echo "<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";
}
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\">\r\n <a href=\"#\" onClick=\"operate('";
echo $USER_ID;
echo "')\"> 详情</a>\r\n </td>\r\n </tr>\r\n";
}
}
echo "</table>\r\n";
}
else
{
message( "", "无符合条件的记录!" );
}
echo "<br>\r\n<div align=\"center\">\r\n <input type=\"button\" class=\"SmallButton\" value=\"关闭\" onClick=\"window.close();\">\r\n</div> \r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -