remind.php

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

{
	$PARA_NAME = $ROW['PARA_NAME'];
	$PARA_VALUE = $ROW['PARA_VALUE'];
}
$AGE_ARRAY = explode( ",", $PARA_VALUE );
$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 .= $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 ( $SEX == "0" )
	{
		$YEAR_MIN = date( "Y", time( ) ) - $AGE_ARRAY[0];
		$YEAR_BIRTHDAY = date( "Y", strtotime( $HR_BIRTHDAY ) );
		$MONTH_MIN = date( "n", time( ) );
		$MONTH_BIRTHDAY = date( "n", strtotime( $HR_BIRTHDAY ) );
		if ( !( $YEAR_MIN != $YEAR_BIRTHDAY ) )
		{
			if ( $MONTH_MIN != $MONTH_BIRTHDAY )
			{
				break;
				if ( $MONTH_MIN != $MONTH_BIRTHDAY )
				{
					break;
				}
			}
		}
	}
	else
	{
		$YEAR_MIN = date( "Y", time( ) ) - $AGE_ARRAY[1];
		$YEAR_BIRTHDAY = date( "Y", strtotime( $HR_BIRTHDAY ) );
		$MONTH_MIN = date( "n", time( ) );
		$MONTH_BIRTHDAY = date( "n", strtotime( $HR_BIRTHDAY ) );
		if ( $YEAR_MIN != $YEAR_BIRTHDAY || $MONTH_MIN != $MONTH_BIRTHDAY )
		{
		}
	}
	++$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>&nbsp;&nbsp;<span class=\"small1\"><a href=\"javascript:set_age()\">设定退休年龄</a></span><br>\r\n    </td>\r\n    <td valign=\"bottom\" align=\"right\"><span class=\"small1\">共&nbsp;<span class=\"big4\">";
	echo $HRMS_COUNT;
	echo "</span>&nbsp;条信息</span>\r\n    </td>\r\n  </tr>\r\n</table>\r\n";
	$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 ( $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 ( $SEX == "0" )
		{
			$YEAR_MIN = date( "Y", time( ) ) - $AGE_ARRAY[0];
			$YEAR_BIRTHDAY = date( "Y", strtotime( $HR_BIRTHDAY ) );
			$MONTH_MIN = date( "n", time( ) );
			$MONTH_BIRTHDAY = date( "n", strtotime( $HR_BIRTHDAY ) );
			if ( !( $YEAR_MIN != $YEAR_BIRTHDAY ) )
			{
				if ( $MONTH_MIN != $MONTH_BIRTHDAY )
				{
					break;
					if ( $MONTH_MIN != $MONTH_BIRTHDAY )
					{
						break;
					}
				}
			}
		}
		else
		{
			$YEAR_MIN = date( "Y", time( ) ) - $AGE_ARRAY[1];
			$YEAR_BIRTHDAY = date( "Y", strtotime( $HR_BIRTHDAY ) );
			$MONTH_MIN = date( "n", time( ) );
			$MONTH_BIRTHDAY = date( "n", strtotime( $HR_BIRTHDAY ) );
			if ( $YEAR_MIN != $YEAR_BIRTHDAY || $MONTH_MIN != $MONTH_BIRTHDAY )
			{
			}
		}
		++$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=\"hrms.php?USER_ID=";
		echo $USER_ID;
		echo "&SOURCE=remind\"> 详情</a>\r\n      </td>\r\n    </tr>\r\n";
	}
	echo "</table>\r\n";
}
else
{
	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>&nbsp;&nbsp;<span class=\"small1\"><a href=\"javascript:set_age()\">设定退休年龄</a></span><br>\r\n    </td>\r\n  </tr>\r\n</table>\r\n<br>\r\n<div align=\"center\">\r\n";
	message( "", "本月无退休人员!" );
	echo "\t\r\n</div>\t\r\n";
}
echo "</body>\r\n</html>\r\n";
?>