在线时长排行榜.php

来自「极限网络智能办公系统 - Office Automation 2.8 100％ 」· PHP 代码 · 共 32 行

<?php

echo "<!-------------------- 在线时长排行榜 ----------------------->\r\n\r\n <tr class=\"TableControl\">\r\n   <td class=\"TableHeader\" width=\"70%\"><img src=\"/images/node_user.gif\" align=\"absmiddle\"> 在线时长排行榜</td>\r\n   <td align=\"right\"><a href=\"/general/info/user/\"> <img src=\"/images/green_arrow.gif\" border=\"0\" align=\"absmiddle\"> 详情</a>&nbsp;</td>\r\n </tr>\r\n <tr class=\"TableData\">\r\n   <td colspan=2 height=\"50\">\r\n";
$query = "SELECT * from USER order by ONLINE desc";
$cursor = exequery( $connection, $query );
$ONLINE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$ONLINE_COUNT;
	$USER_NAME = $ROW['USER_NAME'];
	$ONLINE = $ROW['ONLINE'];
	$DEPT_ID = $ROW['DEPT_ID'];
	$DEPT_NAME = dept_long_name( $DEPT_ID );
	$MIN = floor( $ONLINE / 60 );
	$HOUR = floor( $MIN / 60 );
	$MIN = $MIN % 60;
	$ONLINE_DESC = "在线时长：".$HOUR."小时".$MIN."分";
	echo "    <u title=\"";
	echo $DEPT_NAME;
	echo " ";
	echo $ONLINE_DESC;
	echo "\" style=\"cursor:hand\">";
	echo $USER_NAME;
	echo "</u>\r\n";
	if ( 10 <= $ONLINE_COUNT )
	{
		break;
	}
}
echo " </td>\r\n</tr>\r\n";
?>