retire.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 270 行
PHP
270 行
<?
include_once 'inc/auth.php';
include_once 'inc/check_type.php';
include_once 'inc/utility_all.php';
echo '<html>
<head>
<title>退休人员</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript>
function operate(USER_ID)
{
window.opener.location="hrms.php?USER_ID="+USER_ID+"&SOURCE=remind";
window.close();
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
$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');
}
$cursor = exequery ($connection, $query1);
$HRMS_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
$DEPT_ID = $ROW['DEPT_ID'];
$USER_ID = $ROW['USER_ID'];
if ((is_dept_priv ($DEPT_ID) == 0))
{
continue;
}
else
{
$SEX = $ROW['SEX'];
$HR_BIRTHDAY = $ROW['HR_BIRTHDAY'];
if ((($HR_BIRTHDAY == '0000-00-00') OR ($HR_BIRTHDAY == '1900-01-01')))
{
continue;
}
else
{
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'))
{
continue;
}
}
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'))
{
continue;
}
}
}
if (($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'))
{
continue;
}
}
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'))
{
continue;
}
}
}
++$HRMS_COUNT;
continue;
}
continue;
}
}
if (($HRMS_COUNT != 0))
{
echo '<br>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/hrms.gif" HEIGHT="20">';
echo '<s';
echo 'pan class="big3"> 退休人员</span><br>
</td>
<td valign="bottom" align="right">';
echo '<s';
echo 'pan class="small1">共 ';
echo '<s';
echo 'pan class="big4">';
echo $HRMS_COUNT;
echo '</span> 条信息</span>
</td>
</tr>
</table>
';
$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');
}
$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 ((is_dept_priv ($DEPT_ID) == 0))
{
continue;
}
else
{
if (($SEX == '0'))
{
$SEX_DESC = '男';
}
else
{
if (($SEX == '1'))
{
$SEX_DESC = '女';
}
else
{
$SEX_DESC = '';
}
}
if ((($HR_BIRTHDAY == '0000-00-00') OR ($HR_BIRTHDAY == '1900-01-01')))
{
continue;
}
else
{
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'))
{
continue;
}
}
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'))
{
continue;
}
}
}
if (($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'))
{
continue;
}
}
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'))
{
continue;
}
}
}
++$HRMS_COUNT;
if (($HRMS_COUNT == 1))
{
echo '<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center">部门</td>
<td nowrap align="center">姓名</td>
<td nowrap align="center">性别</td>
<td nowrap align="center">出生日期</td>
<td nowrap align="center">操作</td>
</tr>
';
}
echo ' <tr class="TableData">
<td nowrap align="center">';
echo $DEPT_NAME;
echo '</td>
<td nowrap align="center">';
echo $USER_NAME;
echo '</td>
<td nowrap align="center">';
echo $SEX_DESC;
echo '</td>
<td nowrap align="center">';
echo $HR_BIRTHDAY;
echo '</td>
<td nowrap align="center">
<a href="#" onclick="operate(\'';
echo $USER_ID;
echo '\')"> 详情</a>
</td>
</tr>
';
continue;
}
continue;
}
}
echo '</table>
';
}
else
{
message ('', '无符合条件的纪录!');
}
echo '<br>
<div align="center">
<input type="button" class="SmallButton" value="关闭" onclick="window.close();">
</div>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?