外出人员公告牌.php

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

<?php
 

echo "<!-------------------- 外出人员公告牌----------------------->\r\n<div id=\"module_";
echo $MODULE_ID;
echo "\" class=\"module listColor\">\r\n\t  <div class=\"head\">\r\n  <h4 id=\"module_";
echo $MODULE_ID;
echo "_head\" class=\"moduleHeader\">\r\n    <span id=\"module_";
echo $MODULE_ID;
echo "_title\" class=\"title\" style=\"cursor:move;\"> 外出人员</span>\r\n    <span id=\"module_";
echo $MODULE_ID;
echo "_op\" class=\"close\">&nbsp;<a href=\"javascript:_edit();\">设置</a>&nbsp;";
if ( $VIEW_TYPE != "2" )
{
	echo "<a href=\"javascript:_del(";
	echo $MODULE_ID;
	echo ");\"><img src=\"/images/close.png\" /></a>";
}
echo "</span>\r\n  </h4>\r\n    </div>\r\n  <div id=\"module_";
echo $MODULE_ID;
echo "_body\" class=\"module_body\">\r\n    <div id=\"module_";
echo $MODULE_ID;
echo "_ul\" class=\"module_div\" style=\"height:75px;\">\r\n\r\n";
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$COUNT1 = 0;
$query = "SELECT USER_NAME,EVECTION_DEST,EVECTION_DATE1,EVECTION_DATE2 from USER,USER_PRIV,ATTEND_EVECTION where USER.USER_ID=ATTEND_EVECTION.USER_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV and ALLOW='1' and to_days(EVECTION_DATE1)<=to_days('".$CUR_TIME."') and STATUS<>2 order by USER_PRIV.PRIV_NO,USER.USER_NO";
$cursor = exequery( $connection, $query );
while ( $ROW1 = mysql_fetch_array( $cursor ) )
{
	++$COUNT1;
	if ( 12 < $COUNT1 )
	{
		break;
	}
	$USER_NAME = $ROW1['USER_NAME'];
	$EVECTION_DEST = $ROW1['EVECTION_DEST'];
	$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 " 地点：";
	echo $EVECTION_DEST;
	echo "\" style=\"cursor:hand\">";
	echo $USER_NAME;
	echo "</u>\r\n\r\n";
}
if ( 0 < $COUNT1 )
{
	echo "</fieldset>";
}
$COUNT2 = 0;
$query = "SELECT USER_NAME,LEAVE_DATE1,LEAVE_DATE2 from USER,USER_PRIV,ATTEND_LEAVE where USER.USER_ID=ATTEND_LEAVE.USER_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV and STATUS<>'2' and ALLOW='1' and LEAVE_DATE1<='".$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 )
	{
		break;
	}
	$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 USER_NAME,OUT_TIME1,OUT_TIME2 from USER,USER_PRIV,ATTEND_OUT where USER.USER_ID=ATTEND_OUT.USER_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV and STATUS<>'1' and ALLOW='1' and to_days(SUBMIT_TIME)=to_days('".$CUR_TIME."') and OUT_TIME1<='".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 )
	{
		break;
	}
	$USER_NAME = $ROW1['USER_NAME'];
	$OUT_TIME1 = $ROW1['OUT_TIME1'];
	$OUT_TIME2 = $ROW1['OUT_TIME2'];
	$SUBMIT_TIME = substr( $ROW1['SUBMIT_TIME'], 0, -3 );
	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 "</div>\r\n  </div>\r\n</div>\r\n";
?>