外出人员公告牌.php

极限网络智能办公系统 - Office Automation 2.8 100％ 源码

<?php

echo "<!-------------------- 外出人员公告牌----------------------->\r\n<tr class=\"TableControl\">\r\n   <td class=\"TableHeader\" width=\"70%\"><img src=\"/images/menu/attendance.gif\" WIDTH=\"19\" HEIGHT=\"17\" align=\"absmiddle\"> 外出人员公告牌</td>\r\n   <td align=\"right\">&nbsp;</td>\r\n</tr>\r\n\r\n<tr class=\"TableData\">\r\n   <td colspan=2 height=\"50\">\r\n\r\n";
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$COUNT1 = 0;
$query = "SELECT * from USER,USER_PRIV,ATTEND_EVECTION where USER.USER_ID=ATTEND_EVECTION.USER_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV and STATUS='1' and ALLOW='1' and to_days(EVECTION_DATE1)<=to_days('{$CUR_TIME}') and to_days(EVECTION_DATE2)>=to_days('{$CUR_TIME}') order by USER_PRIV.PRIV_NO,USER.USER_NO";
$cursor = exequery( $connection, $query );
while ( $ROW1 = mysql_fetch_array( $cursor ) )
{
	++$COUNT1;
	if ( 12 < $COUNT1 )
	{
	}
	else
	{
		$USER_NAME = $ROW1['USER_NAME'];
		$EVECTION_DATE1 = substr( $ROW1['EVECTION_DATE1'], 0, 10 );
		$EVECTION_DATE2 = substr( $ROW1['EVECTION_DATE2'], 0, 10 );
		if ( $COUNT1 == 1 )
		{
			echo "  <fieldset class=\"small\">\r\n  <legend align=left>\r\n      <b>出差人员</b>\r\n  </legend>\r\n";
		}
		echo "\r\n  <u title=\"";
		echo $EVECTION_DATE1;
		echo " 至 ";
		echo $EVECTION_DATE2;
		echo "\" style=\"cursor:hand\">";
		echo $USER_NAME;
		echo "</u>\r\n\r\n";
	}
}
if ( 0 < $COUNT1 )
{
	echo "</fieldset>";
}
$COUNT2 = 0;
$query = "SELECT * from USER,USER_PRIV,ATTEND_LEAVE where USER.USER_ID=ATTEND_LEAVE.USER_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV and STATUS='1' and ALLOW='1' and LEAVE_DATE1<='{$CUR_TIME}' and LEAVE_DATE2>='{$CUR_TIME}' order by USER_PRIV.PRIV_NO,USER.USER_NO";
$cursor = exequery( $connection, $query );
while ( $ROW1 = mysql_fetch_array( $cursor ) )
{
	++$COUNT2;
	if ( 12 < $COUNT2 )
	{
	}
	else
	{
		$USER_NAME = $ROW1['USER_NAME'];
		$LEAVE_DATE1 = $ROW1['LEAVE_DATE1'];
		$LEAVE_DATE2 = $ROW1['LEAVE_DATE2'];
		if ( $COUNT2 == 1 )
		{
			echo "  <fieldset class=\"small\">\r\n  <legend align=left>\r\n      <b>请假人员</b>\r\n  </legend>\r\n";
		}
		echo "\r\n  <u title=\"";
		echo $LEAVE_DATE1;
		echo " 至 ";
		echo $LEAVE_DATE2;
		echo "\" style=\"cursor:hand\">";
		echo $USER_NAME;
		echo "</u>\r\n\r\n";
	}
}
if ( 0 < $COUNT2 )
{
	echo "</fieldset>";
}
$COUNT3 = 0;
$query = "SELECT * from USER,USER_PRIV,ATTEND_OUT where USER.USER_ID=ATTEND_OUT.USER_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV and STATUS='0' and ALLOW='1' and to_days(SUBMIT_TIME)=to_days('{$CUR_TIME}') and OUT_TIME1<='".date( "H:i", time( ) )."' and OUT_TIME2>='".date( "H:i", time( ) )."' order by USER_PRIV.PRIV_NO,USER.USER_NO";
$cursor = exequery( $connection, $query );
while ( $ROW1 = mysql_fetch_array( $cursor ) )
{
	++$COUNT3;
	if ( 12 < $COUNT3 )
	{
	}
	else
	{
		$USER_NAME = $ROW1['USER_NAME'];
		$OUT_TIME1 = $ROW1['OUT_TIME1'];
		$OUT_TIME2 = $ROW1['OUT_TIME2'];
		if ( $COUNT3 == 1 )
		{
			echo "  <fieldset class=\"small\">\r\n  <legend align=left>\r\n      <b>外出人员</b>\r\n  </legend>\r\n";
		}
		echo "\r\n  <u title=\"";
		echo $OUT_TIME1;
		echo " 至 ";
		echo $OUT_TIME2;
		echo "\" style=\"cursor:hand\">";
		echo $USER_NAME;
		echo "</u>\r\n\r\n";
	}
}
if ( 0 < $COUNT3 )
{
	echo "</fieldset>";
}
if ( $COUNT1 == 0 && $COUNT2 == 0 && $COUNT3 == 0 )
{
	echo "·无外出人员";
}
echo "\r\n </td>\r\n</tr>\r\n";
?>