📄 syjlb.php

📁 辅助radius软件的管理程序web平台下的程序代码自己还没有测试过
💻 PHP
字号:
<?
include "../check.php"
?>
<?
include "../sql.php" 
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>

<body>
<?

/*计算时间开始<结束 并且开始和结束大都要小于当前时间*/
$now=date("Y-m-d H:i:s",time());
$startdate=$qsrq." ".$qssj;
$stopdate=$zzrq." ".$zzsj;
$startdate=strtotime($startdate);
$stopdate=strtotime($stopdate);
$now=strtotime($now);
if($startdate>$now)
{echo "<script language='javascript'>"; 
echo 'alert("查询起始日期不能大于当前日期！");';
echo "javascript:history.go(-1);";
echo "</script>";
}
if($stopdate>$now)
{echo "<script language='javascript'>"; 
echo 'alert("查询终止日期不能大于当前日期！");';
echo "javascript:history.go(-1);";
echo "</script>";
}
if($startdate>$stopdate)
{echo "<script language='javascript'>"; 
echo 'alert("起始日期不能大于结束日期！");';
echo "javascript:history.go(-1);";
echo "</script>";
}

//时间段内有记录判断  
 $n=0;
$sql="select * from use_record";
$relust=mysql_query($sql);
echo mysql_error();
	while ($row=mysql_fetch_row($relust))
	{
	$datetime=$row[5];
	$datetime=strtotime($datetime);
		if(($datetime>$startdate) && ($datetime<$stopdate))
		{$a[$n]=$row[0];
		//echo $a[$n];
		//echo "   ";
		$n=$n+1; }
	}
if ($a[0]==NULL) 
      {
	 // echo mysql_error()."<br>";
	    echo '<p align="center">无满足条件的记录.</p>';
		echo '<div align="center"><a href="syjl.php" class="nmisall">重新查询</a> </div>';
	   }else
{
 
 
if($yhls!="")//流水号判断唯一条件查询
{
 $sql="select * from use_record where user_serialno=$yhls";
 $result = mysql_query($sql);
  if (!$row = mysql_fetch_row($result)) 
      {
	    echo "<script language='javascript'>"; 
		echo 'alert("无所填流水号用户,请重新选择！");';
		echo "javascript:history.go(-1);";
		echo "</script>";
	   }else
	{$sql="select * from user where user_serialno=$yhls";
 $result = mysql_query($sql); 
	while ($row=mysql_fetch_row($result))
		 {$name=$row[1];
		 }
		 echo '<p align="center">使用统计</p>
			<table border="1" align="center">
			  <tr> 
				<td rowspan="2"><div align="center">用户名</div></td>
				<td colspan="2"><div align="center">NAS</div></td>
				<td rowspan="2"><div align="center">登录时间</div></td>
				<td rowspan="2"><div align="center">注销时间</div></td>
				<td rowspan="2"><div align="center">使用时间</div></td>
				<td colspan="2"><div align="center">流量(Bytes)</div></td>
			  </tr>
			   <tr> 
				<td><div align="center">IP</div></td>
				<td><div align="center">PORT</div></td>
				<td><div align="center">接收</div></td>
				<td><div align="center">发送</div></td>
			  </tr>';
			  for($pp=0;$pp<$n;$pp++)
			  {
					  $sqlt="select * from use_record where AutoId='$a[$pp]' and user_serialno=$yhls";
						$relustt=mysql_query($sqlt);
						echo mysql_error();
						while ($rowt=mysql_fetch_row($relustt))
					  {echo '<tr> 
							<td><div align="center">'.$name.'</div></td>
							<td><div align="center">'.$rowt[3].'</div></td>
							<td><div align="center">'.$rowt[4].'</div></td>
							<td><div align="center">'.$rowt[5].'</div></td>
							<td><div align="center">'.$rowt[6].'</div></td>
							<td><div align="center">'.$rowt[7].'</div></td>
							<td><div align="center">'.$rowt[8].'</div></td>
							<td><div align="center">'.$rowt[9].'</div></td>
						  </tr>';
					  }
			  }
			   	 echo '</table>
				<p align="center">&nbsp;</p>';
	  }      
}//if($yhls!="")
else//yhls 等于空
{
if($gldz=='')
   {$c="";}
   else
    {$c=" and admin_address like binary '%$gldz%'";}
if($nasip=='')
   {$d=" ";
   }else
   {$d=" and NASIPAddress like binary '%$nasip%'";}


	
 echo '<p align="center">使用统计</p>
			<table border="1" align="center">
			  <tr> 
				<td rowspan="2"><div align="center">用户名</div></td>
				<td colspan="2"><div align="center">NAS</div></td>
				<td rowspan="2"><div align="center">登录时间</div></td>
				<td rowspan="2"><div align="center">注销时间</div></td>
				<td rowspan="2"><div align="center">使用时间</div></td>
				<td colspan="2"><div align="center">流量(Bytes)</div></td>
			  </tr>
			   <tr> 
				<td><div align="center">IP</div></td>
				<td><div align="center">PORT</div></td>
				<td><div align="center">接收</div></td>
				<td><div align="center">发送</div></td>
			  </tr>';
			  for($pp=0;$pp<$n;$pp++)
			  {
					  $sqlt=sprintf("select * from use_record where AutoId='$a[$pp]'%s%s",$c,$d);
					 	$relustt=mysql_query($sqlt);
						echo mysql_error();
						while ($rowt=mysql_fetch_row($relustt))
					  {
					   $ttt=$rowt[1];
					   $sql="select * from user where user_serialno=$ttt";
						 $result = mysql_query($sql); 
							while ($row=mysql_fetch_row($result))
								 {;
								 
					  echo '<tr> 
							<td><div align="center">'.$row[1].'</div></td>
							<td><div align="center">'.$rowt[3].'</div></td>
							<td><div align="center">'.$rowt[4].'</div></td>
							<td><div align="center">'.$rowt[5].'</div></td>
							<td><div align="center">'.$rowt[6].'</div></td>
							<td><div align="center">'.$rowt[7].'</div></td>
							<td><div align="center">'.$rowt[8].'</div></td>
							<td><div align="center">'.$rowt[9].'</div></td>
						  </tr>';
						  }
					  }
			  }
			   	 echo '</table>
				<p align="center">&nbsp;</p>';	
	
	
	
	
}
 
 }//else



		






?>

 
  

</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -