📄 sytjb.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>";
}
if(($rad=='1') && ($gldz==''))
{echo "<script language='javascript'>";
echo 'alert("请填写管理地址！");';
echo "javascript:history.go(-1);";
echo "</script>";
}
if(($rad=='2') && ($nasip==''))
{echo "<script language='javascript'>";
echo 'alert("请填写NAS的IP地址！");';
echo "javascript:history.go(-1);";
echo "</script>";
}
//运算实体
if($rad=='1')
{//1
//判断统计深度
if(($tjsd=='')||($tjsd<strlen($gldz)))
{$tjsd=strlen($gldz);
}//动此得到正确的唯一统计深度数字1开始
//把日期相符的记录ID号加入数组成 $a[]
$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="sytj.php" class="nmisall">重新统计</a> </div>';
}else
{
$nn=0;
//查询$a[] 以管理地址正确的加入数组 $b[]
$gldzn=strlen($gldz);//$gldzn 输入的地址的长度
//echo "管理地址本身长度:".$gldzn;
for($m=0;$m<$n;$m++)
{$fuck=$a[$m];
$sql="select * from use_record where AutoId=$fuck";
$relust=mysql_query($sql);
while ($row=mysql_fetch_row($relust))
{$aad=NULL;
$admin_address=$row[11];
for($tt=0;$tt<$gldzn;$tt++)
{$aad=$aad.$admin_address[$tt];//字串连接
}
if($gldz==$aad)
{$b[$nn]=$row[0];
$nn=$nn+1;
}
}
}//for($m=0;$m<$n;$m++) 最后的$b[$nn]为满足所有条件的记录ID号 1-n
/*for($k=0;$k<$nn;$k++)
{echo $b[$k];
echo " ";
}*/
$ppp=0;
$nm=0;
//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
//为显示求的最后值
for($k=0;$k<$nn;$k++)
{
$nofuck=$b[$k];
$sql="select * from use_record where AutoId=$nofuck";
$relust=mysql_query($sql);
while ($row=mysql_fetch_row($relust))
{ $sddz=NULL;//地址名
$dz=$row[11];
for($u=0;$u<$tjsd;$u++)
{$sddz=$sddz.$dz[$u];
}//得到了新的管理地址名
if($ppp==0)
{$drname[$ppp]=$sddz;
$acctnumber[$ppp]=1;
$accttime[$ppp]=$row[7];
$alloc[$ppp]=$row[8]+$row[9];
$logoandport[$ppp]=1;
$logoname[$nm]=$row[2];
$acctnumber_sum=1;
$accttime_sum=$row[7];
$alloc_sum=$row[8]+$row[9];
$logoandport_sum=1;
$nm=$nm+1;
$ppp=$ppp+1;
}
else
{$flag=0;
//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
for($bad=0;$bad<$ppp;$bad++)
{
if($drname[$bad]==$sddz)//判断地址名是否等.然后在判断帐号是否等
{
$acctnumber[$bad]=$acctnumber[$bad]+1;
$accttime[$bad]=$accttime[$bad]+$row[7];
$alloc[$bad]=$alloc[$bad]+$row[8]+$row[9];
$nt=0;
for($han=0;$han<$nm;$han++)
{if($logoname[$han]==$row[2])
{
$nt=1;
}
}
if($nt==0)
{
$logoandport[$bad]=$logoandport[$bad]+1;
$logoandport_sum=$logoandport_sum+1;
$logoname[$nm]=$row[2];
$nm=$nm+1;
}
$acctnumber_sum=$acctnumber_sum+1;
$accttime_sum=$accttime_sum+$row[7];
$alloc_sum=$alloc_sum+$row[8]+$row[9];
$flag=1;
}
}
if($flag==0)
{
$drname[$ppp]=$sddz;
$acctnumber[$ppp]=1;
$accttime[$ppp]=$row[7];
$alloc[$ppp]=$row[8]+$row[9];
$logoandport[$ppp]=1;
$logoandport_sum=$logoandport_sum+1;
$acctnumber_sum=$acctnumber_sum+1;
$accttime_sum=$accttime_sum+$row[7];
$alloc_sum=$alloc_sum+$row[8]+$row[9];
$logoname[$nm]=$row[2];
$nm=$nm+1;
}
$ppp=$ppp+1;
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
}//143else
}//while ($row=mysql_fetch_row($relust)) 每一条记录的处理
}//for($k=0;$k<$nn;$k++)求显示直循环开始
echo '<p> </p>
<p align="center">网络使用管理地址分类汇总统计结果</p>
<p> </p>
<table border="1" align="center">
<tr>
<td><div align="center">管理地址</div></td>
<td><div align="center">连接次数</div></td>
<td><div align="center">连接时间</div></td>
<td><div align="center">帐号</div></td>
<td><div align="center">端口数 </div></td>
<td><div align="center">总流量(GBytes)</div></td>
</tr>';
for($danger=0;$danger<$ppp;$danger++)
{
$ffen=intval($accttime[$danger]/60);
$mmiao=$accttime[$danger]%60;
if(($ffen==0)&&($mmiao==0))
{
}else
{echo '<tr>
<td><div align="center">'.$drname[$danger].'</div></td>
<td><div align="center">'.$acctnumber[$danger].'</div></td>
<td><div align="center">'.$ffen.'分'.$mmiao.'秒</div></td>
<td><div align="center">'.$logoandport[$danger].'</div></td>
<td><div align="center">'.$logoandport[$danger].'</div></td>
<td><div align="center">'.$alloc[$danger].'</div></td>
</tr>';}
}
$fen=intval($accttime_sum/60);
$miao=$accttime_sum%60;
echo '<tr>
<td><div align="center">合计</div></td>
<td><div align="center">'.$acctnumber_sum.'</div></td>
<td><div align="center">'.$fen.'分'.$miao.'秒</div></td>
<td><div align="center">'.$logoandport_sum.'</div></td>
<td><div align="center">'.$logoandport_sum.'</div></td>
<td><div align="center">'.$alloc_sum.'</div></td>
</tr>';
echo '</table>';
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
}//if ($a[0]==NULL) 有记录
}//if($rad=='1') 传递方式
//&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
if($rad=='2')
{
$tjsd=15;
//把日期相符的记录ID号加入数组成 $a[]
$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="sytj.php" class="nmisall">重新统计</a> </div>';
}else
{
$nn=0;
//查询$a[] 以管理地址正确的加入数组 $b[]
$gldzn=strlen($nasip);//$gldzn 输入的地址的长度
//echo "管理地址本身长度:".$gldzn;
for($m=0;$m<$n;$m++)
{$fuck=$a[$m];
$sql="select * from use_record where AutoId=$fuck";
$relust=mysql_query($sql);
while ($row=mysql_fetch_row($relust))
{$aad=NULL;
$nas_ip=$row[3];
for($tt=0;$tt<$gldzn;$tt++)
{$aad=$aad.$nas_ip[$tt];//字串连接
}
if($nasip==$aad)
{$b[$nn]=$row[0];
$nn=$nn+1;
}
}
}//for($m=0;$m<$n;$m++) 最后的$b[$nn]为满足所有条件的记录ID号 1-n
/*for($k=0;$k<$nn;$k++)
{echo $b[$k];
echo " ";
}*/
$ppp=0;
$nm=0;
//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
//为显示求的最后值
for($k=0;$k<$nn;$k++)
{
$nofuck=$b[$k];
$sql="select * from use_record where AutoId=$nofuck";
$relust=mysql_query($sql);
while ($row=mysql_fetch_row($relust))
{ $sddz=NULL;//地址名
$dz=$row[3];
for($u=0;$u<$tjsd;$u++)
{$sddz=$sddz.$dz[$u];
}//得到了新的管理地址名
if($ppp==0)
{$drname[$ppp]=$sddz;
$acctnumber[$ppp]=1;
$accttime[$ppp]=$row[7];
$alloc[$ppp]=$row[8]+$row[9];
$logoandport[$ppp]=1;
$logoname[$nm]=$row[2];
$acctnumber_sum=1;
$accttime_sum=$row[7];
$alloc_sum=$row[8]+$row[9];
$logoandport_sum=1;
$nm=$nm+1;
$ppp=$ppp+1;
}
else
{$flag=0;
//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
for($bad=0;$bad<$ppp;$bad++)
{
if($drname[$bad]==$sddz)//判断地址名是否等.然后在判断帐号是否等
{
$acctnumber[$bad]=$acctnumber[$bad]+1;
$accttime[$bad]=$accttime[$bad]+$row[7];
$alloc[$bad]=$alloc[$bad]+$row[8]+$row[9];
$nt=0;
for($han=0;$han<$nm;$han++)
{if($logoname[$han]==$row[2])
{
$nt=1;
}
}
if($nt==0)
{
$logoandport[$bad]=$logoandport[$bad]+1;
$logoandport_sum=$logoandport_sum+1;
$logoname[$nm]=$row[2];
$nm=$nm+1;
}
$acctnumber_sum=$acctnumber_sum+1;
$accttime_sum=$accttime_sum+$row[7];
$alloc_sum=$alloc_sum+$row[8]+$row[9];
$flag=1;
}
}
if($flag==0)
{
$drname[$ppp]=$sddz;
$acctnumber[$ppp]=1;
$accttime[$ppp]=$row[7];
$alloc[$ppp]=$row[8]+$row[9];
$logoandport[$ppp]=1;
$logoandport_sum=$logoandport_sum+1;
$acctnumber_sum=$acctnumber_sum+1;
$accttime_sum=$accttime_sum+$row[7];
$alloc_sum=$alloc_sum+$row[8]+$row[9];
$logoname[$nm]=$row[2];
$nm=$nm+1;
}
$ppp=$ppp+1;
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
}//143else
}//while ($row=mysql_fetch_row($relust)) 每一条记录的处理
}//for($k=0;$k<$nn;$k++)求显示直循环开始
echo '<p> </p>
<p align="center">网络使用NAD IP地址分类汇总统计结果</p>
<p> </p>
<table border="1" align="center">
<tr>
<td><div align="center">NAS设备IP地址</div></td>
<td><div align="center">连接次数</div></td>
<td><div align="center">连接时间</div></td>
<td><div align="center">帐号</div></td>
<td><div align="center">端口数 </div></td>
<td><div align="center">总流量(GBytes)</div></td>
</tr>';
for($danger=0;$danger<$ppp;$danger++)
{
$ffen=intval($accttime[$danger]/60);
$mmiao=$accttime[$danger]%60;
if(($ffen==0)&&($mmiao==0))
{
}else
{echo '<tr>
<td><div align="center">'.$drname[$danger].'</div></td>
<td><div align="center">'.$acctnumber[$danger].'</div></td>
<td><div align="center">'.$ffen.'分'.$mmiao.'秒</div></td>
<td><div align="center">'.$logoandport[$danger].'</div></td>
<td><div align="center">'.$logoandport[$danger].'</div></td>
<td><div align="center">'.$alloc[$danger].'</div></td>
</tr>';}
}
$fen=intval($accttime_sum/60);
$miao=$accttime_sum%60;
echo '<tr>
<td><div align="center">合计</div></td>
<td><div align="center">'.$acctnumber_sum.'</div></td>
<td><div align="center">'.$fen.'分'.$miao.'秒</div></td>
<td><div align="center">'.$logoandport_sum.'</div></td>
<td><div align="center">'.$logoandport_sum.'</div></td>
<td><div align="center">'.$alloc_sum.'</div></td>
</tr>';
echo '</table>';
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
}//if ($a[0]==NULL) 有记录
}//if($rad=='1') 传递方式
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -