<?php
define('EmpireCMSAdmin','1');
require("../class/connect.php");
require("../class/db_sql.php");
require("../class/functions.php");
require("../data/dbcache/class.php");
$link=db_connect();
$empire=new mysqlquery();
//验证用户
$lur=is_login();
$logininid=$lur['userid'];
$loginin=$lur['username'];
$loginrnd=$lur['rnd'];
$loginlevel=$lur['groupid'];
$loginadminstyleid=$lur['adminstyleid'];
//ehash
$ecms_hashur=hReturnEcmsHashStrAll();
//验证权限
CheckLevel($logininid,$loginin,$classid,"totaldata");
$totaltype=(int)$_POST['totaltype'];
$classid=(int)$_POST['classid'];
$tbname=RepPostVar($_POST['tbname']);
$startday=RepPostVar($_POST['startday']);
$endday=RepPostVar($_POST['endday']);
$userid=(int)$_POST['userid'];
$onclick=0;
$allnum=0;
$nochecknum=0;
$checknum=0;
$bfb=0;
$and=' where ';
//按类别统计
if($totaltype==0)
{
$tbname='';
if($classid&&!$class_r[$classid][tbname])
{
printerror("ErrorUrl","history.go(-1)");
}
//未审核
$query="select count(*) as total from {$dbtbpre}ecms_".$class_r[$classid][tbname]."_check";
//已审核
$query1="select count(*) as total from {$dbtbpre}ecms_".$class_r[$classid][tbname];
//点击
$onclickquery="select avg(onclick) as total from {$dbtbpre}ecms_".$class_r[$classid][tbname];
if($classid)
{
//中级类别
if(empty($class_r[$classid][islast]))
{
$where=ReturnClass($class_r[$classid][sonclass]);
}
//终极类别
else
{
$where="classid='$classid'";
}
$query.=" where ".$where;
$query1.=" where ".$where;
$onclickquery.=" where ".$where;
$and=' and ';
}
}
//按表统计
elseif($totaltype==1)
{
$classid=0;
if(!$tbname)
{
printerror("ErrorUrl","history.go(-1)");
}
//未审核
$query="select count(*) as total from {$dbtbpre}ecms_".$tbname."_check";
//已审核
$query1="select count(*) as total from {$dbtbpre}ecms_".$tbname;
//点击
$onclickquery="select avg(onclick) as total from {$dbtbpre}ecms_".$tbname;
}
else
{
printerror("ErrorUrl","history.go(-1)");
}
//时间
if($startday&&$endday)
{
$start=$startday." 00:00:00";
$end=$endday." 23:59:59";
$timeadd=$and."(newstime>='".to_time($start)."' and newstime<='".to_time($end)."')";
$query.=$timeadd;
$query1.=$timeadd;
$onclickquery.=$timeadd;
$and=' and ';
}
//用户
if($userid)
{
$useradd=$and."userid='$userid'";
$query.=$useradd;
$query1.=$useradd;
$onclickquery.=$useradd;
$and=' and ';
}
//数据表
$htb=0;
$tbsql=$empire->query("select tbname,tname from {$dbtbpre}enewstable order by tid");
while($tbr=$empire->fetch($tbsql))
{
$select="";
if($tbr[tbname]==$tbname)
{
$htb=1;
$select=" selected";
}
$tbstr.="<option value='".$tbr[tbname]."'".$select.">".$tbr[tname]."</option>";
}
if($totaltype==1&&$htb==0)
{
printerror('ErrorUrl','');
}
if($classid||$tbname)
{
//审核
$checknum=$empire->gettotal($query1);
//未审核
$nochecknum=$empire->gettotal($query);
//总信息数
$allnum=$checknum+$nochecknum;
//点击率
$onclick=$empire->gettotal($onclickquery);
}
//栏目
$fcfile="../data/fc/ListEnews.php";
$class="<script src=../data/fc/cmsclass.js></script>";
if(!file_exists($fcfile))
{$class=ShowClass_AddClass("",$classid,0,"|-",0,0);}
//用户
$usersql=$empire->query("select userid,username from {$dbtbpre}enewsuser order by userid");
while($userr=$empire->fetch($usersql))
{
if($userr[userid]==$userid)
{$select=" selected";}
else
{$select="";}
$user.="<option value='".$userr[userid]."'".$select.">".$userr[username]."</option>";
}
db_close();
$empire=null;
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>统计数据</title>
<link href="adminstyle/<?=$loginadminstyleid?>/adminstyle.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="ecmseditor/js/jstime/WdatePicker.js"></script>
</head>
<body>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1">
<tr>
<td height="25">位置：<a href="TotalData.php<?=$ecms_hashur['whehref']?>">统计数据</a></td>
</tr>
</table>
<form name="form1" method="post" action="TotalData.php">
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
<?=$ecms_hashur['eform']?>
<tr class="header">
<td height="25" colspan="2">统计数据
<input name="enews" type="hidden" id="enews" value="TotalData"> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="19%" height="25"><input name="totaltype" type="radio" value="0"<?=$totaltype==0?' checked':''?>>
按栏目统计</td>
<td width="81%" height="25"><select name="classid" id="classid">
<?=$class?>
</select>
（如选择父栏目，将统计于所有子栏目） </td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25"><input name="totaltype" type="radio" value="1"<?=$totaltype==1?' checked':''?>>
按数据表统计</td>
<td height="25"><select name="tbname" id="tbname">
<?=$tbstr?>
</select></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25">录入者：</td>
<td height="25"><select name="userid" id="userid">
<option value="0">所有录入者</option>
<?=$user?>
</select></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25">时间范围：</td>
<td height="25">从
<input name="startday" type="text" value="<?=$startday?>" size="15" class="Wdate" onClick="WdatePicker({skin:'default',dateFmt:'yyyy-MM-dd'})">
到
<input name="endday" type="text" value="<?=$endday?>" size="15" class="Wdate" onClick="WdatePicker({skin:'default',dateFmt:'yyyy-MM-dd'})">
之间的数据(两边为空则为不限制日期)</td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25"> </td>
<td height="25"><input type="submit" name="Submit" value="开始统计"> <input type="reset" name="Submit2" value="重置"></td>
</tr>
</table>
</form>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
<tr bgcolor="#FFFFFF">
<td height="25" colspan="4"> <div align="center">统计时间：
<?=date("Y-m-d H:i:s")?>
</div></td>
</tr>
<tr class="header">
<td width="23%" height="25"><div align="center">总信息数</div></td>
<td width="23%" height="25"> <p align="center">未审核数</p></td>
<td width="23%" height="25"> <div align="center">已审核数</div></td>
<td width="15%"><div align="center">平均点击数</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="25"><div align="center"><font color=red>
<?=$allnum?>
</font></div></td>
<td height="25"><div align="center">
<?=$nochecknum?>
</div></td>
<td height="25"><div align="center">
<?=$checknum?>
</div></td>
<td><div align="center">
<?=$onclick?>
</div></td>
</tr>
</table>
<p> </p>
</body>
</html>