retire.php
来自「通达OA官方提供的30源代码,感觉很实在」· PHP 代码 · 共 197 行
PHP
197 行
<?
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");
?>
<html>
<head>
<title>退休人员</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
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 a
LEFT OUTER JOIN USER b ON a.USER_ID = b.USER_ID
LEFT OUTER JOIN DEPARTMENT f ON b.DEPT_ID=f.DEPT_ID
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);//echo $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"||$HR_BIRTHDAY=="1900-01-01")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")
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!=0)
{
?>
<br>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/hrms.gif" HEIGHT="20"><span class="big3"> 退休人员</span><br>
</td>
<td valign="bottom" align="right"><span class="small1">共 <span class="big4"><?=$HRMS_COUNT?></span> 条信息</span>
</td>
</tr>
</table>
<?
$HRMS_COUNT=0;
$query1="select * from HRMS a
LEFT OUTER JOIN USER b ON a.USER_ID = b.USER_ID
LEFT OUTER JOIN DEPARTMENT f ON b.DEPT_ID=f.DEPT_ID
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);//echo $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"||$HR_BIRTHDAY=="1900-01-01")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")
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)
{
?>
<table width="100%" class="TableList">
<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>
<?
}
?>
<tr class="TableData">
<td nowrap align="center"><?=$DEPT_NAME?></td>
<td nowrap align="center"><?=$USER_NAME?></td>
<td nowrap align="center"><?=$SEX_DESC?></td>
<td nowrap align="center"><?=$HR_BIRTHDAY?></td>
<td nowrap align="center">
<a href="#" onClick="operate('<?=$USER_ID?>')"> 详情</a>
</td>
</tr>
<?
}
?>
</table>
<?
}
else
{
Message("","无符合条件的记录!");
}
?>
<br>
<div align="center">
<input type="button" class="SmallButton" value="关闭" onClick="window.close();">
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?