stat_realt.inc.php

phpcms2007很好的cms内容管理系统,操作方便

<?php
defined('IN_PHPCMS') or exit('Access Denied');
$stat = array();
$res = $db -> query("SELECT COUNT(*) AS numpv,COUNT(DISTINCT vip) AS numip FROM ".TABLE_STAT_VISITOR." WHERE TO_DAYS(etime)=TO_DAYS(CURDATE())");
$row = $db -> fetch_array($res);
$stat['tday_pv'] = $row['numpv'];
$stat['tday_ip'] = $row['numip'];
$res = $db -> query("SELECT COUNT(*) AS numpv FROM ".TABLE_STAT_VISITOR." WHERE TO_DAYS(etime)=TO_DAYS(CURDATE()) AND times>1");
$stat['old'] = $row['numpv'];
$res = $db -> query("SELECT COUNT(*) AS numpv,COUNT(DISTINCT vip) AS numip FROM ".TABLE_STAT_VISITOR." WHERE TO_DAYS(etime)=TO_DAYS(CURDATE())-1");
$row = $db -> fetch_array($res);
$stat['yday_pv'] = $row['numpv'];
$stat['yday_ip'] = $row['numip'];
$fdate = date("Ymd", mktime(0, 0, 0, date("m"), date("d") - date("w"), date("Y")));
$res = $db -> query("SELECT COUNT(*) AS numpv,COUNT(DISTINCT vip) AS numip FROM ".TABLE_STAT_VISITOR." WHERE TO_DAYS(etime) BETWEEN TO_DAYS('$fdate') AND TO_DAYS(CURDATE())");
$row = $db -> fetch_array($res);
$stat['tweek_pv'] = $row['numpv'];
$stat['tweek_ip'] = $row['numip'];
$fdate = date("Ymd", mktime(0, 0, 0, date("m"), date("d") - date("w") - 7, date("Y")));
$ldate = date("Ymd", mktime(0, 0, 0, date("m"), date("d") - date("w") - 1, date("Y")));
$res = $db -> query("SELECT COUNT(*) AS numpv,COUNT(DISTINCT vip) AS numip FROM ".TABLE_STAT_VISITOR." WHERE TO_DAYS(etime) BETWEEN TO_DAYS('$fdate') AND TO_DAYS('$ldate')");
$row = $db -> fetch_array($res);
$stat['lweek_pv'] = $row['numpv'];
$stat['lweek_ip'] = $row['numip'];
$fdate = date("Ymd", mktime(0, 0, 0, date("m"), 1, date("Y")));
$res = $db -> query("SELECT COUNT(*) AS numpv,COUNT(DISTINCT vip) AS numip FROM ".TABLE_STAT_VISITOR." WHERE TO_DAYS(etime) BETWEEN TO_DAYS('$fdate') AND TO_DAYS(CURDATE())");
$row = $db -> fetch_array($res);
$stat['tmonth_pv'] = $row['numpv'];
$stat['tmonth_ip'] = $row['numip'];
$fdate = date("Ymd", mktime(0, 0, 0, date("m") - 1, 1, date("Y")));
$ldate = date("Ymd", mktime(0, 0, 0, date("m"), 0, date("Y")));
$res = $db -> query("SELECT COUNT(*) AS numpv,COUNT(DISTINCT vip) AS numip FROM ".TABLE_STAT_VISITOR." WHERE TO_DAYS(etime) BETWEEN TO_DAYS('$fdate') AND TO_DAYS('$ldate')");
$row = $db -> fetch_array($res);
$stat['lmonth_pv'] = $row['numpv'];
$stat['lmonth_ip'] = $row['numip'];
$res = $db -> query("SELECT COUNT(*) AS numpv,COUNT(DISTINCT vip) AS numip,(TO_DAYS(MAX(etime))-TO_DAYS(MIN(etime))+1) AS days,PERIOD_DIFF(DATE_FORMAT(MAX(etime),'%Y%m'),DATE_FORMAT(MIN(etime),'%Y%m')) AS months,DATE_FORMAT(MAX(etime),'%Y-%m-%d') AS ldate,DATE_FORMAT(MIN(etime),'%Y-%m-%d') AS fdate FROM ".TABLE_STAT_VISITOR);
$row = $db -> fetch_array($res);
$total_pv = $row['numpv'];
$total_ip = $row['numip'];
$days = $row['days'];
$months = $row['months'] + 1;
$ldate = $row['ldate'];
$fdate = $row['fdate'];
$stat['davg_pv'] = $days ? ceil($total_pv / $days) : 0;
$stat['davg_ip'] = $days ? ceil($total_ip / $days) : 0;
$weeks = ceil($days / 7);
$stat['wavg_pv'] = $weeks ? ceil($total_pv / $weeks) : 0;
$stat['wavg_ip'] = $weeks ? ceil($total_ip / $weeks) : 0;
$stat['mavg_pv'] = ceil($total_pv / $months);
$stat['mavg_ip'] = ceil($total_ip / $months);
$res = $db -> query("SELECT COUNT(*) AS numpv,COUNT(DISTINCT vip) AS numip FROM ".TABLE_STAT_VISITOR." WHERE YEAR(etime)=YEAR(CURDATE())");
$row = $db -> fetch_array($res);
$stat['year_pv'] = $row['numpv'];
$stat['year_ip'] = $row['numip'];
$res = $db -> query("SELECT COUNT(*) AS maxpv,DATE_FORMAT(etime,'%Y-%m-%d') AS mdate FROM ".TABLE_STAT_VISITOR." GROUP BY mdate ORDER BY maxpv DESC LIMIT 1");
$row = $db -> fetch_array($res);
$stat['maxd_pv'] = $row['maxpv'];
$stat['mdate_pv'] = $row['mdate'];
$res = $db -> query("SELECT COUNT(DISTINCT vip) AS maxip,DATE_FORMAT(etime,'%Y-%m-%d') AS mdate FROM ".TABLE_STAT_VISITOR." GROUP BY mdate ORDER BY maxip DESC LIMIT 1");
$row = $db -> fetch_array($res);
$stat['maxd_ip'] = $row['maxip'];
$stat['mdate_ip'] = $row['mdate'];
$res = $db -> query("SELECT COUNT(*) AS maxpv,DATE_FORMAT(MIN(etime),'%Y-%m-%d') AS fdate FROM ".TABLE_STAT_VISITOR." GROUP BY tweek ORDER BY maxpv DESC LIMIT 1");
$row = $db -> fetch_array($res);
include(MOD_ROOT."/include/weekofdate.class.php");
$row['fdate'] = isset($row['fdate']) ? $row['fdate'] : date('Y-m-d');
$weekdate = new weekOfDate($row['fdate']);
$stat['maxw_pv'] = isset($row['maxpv']) ? $row['maxpv'] : 0;
$stat['fdate_pv'] = $weekdate -> startDate($row['fdate']);
$stat['ldate_pv'] = $weekdate -> endDate($row['fdate']);
$res = $db -> query("SELECT COUNT(DISTINCT VIP) AS maxip,DATE_FORMAT(MIN(etime),'%Y-%m-%d') AS fdate FROM ".TABLE_STAT_VISITOR." GROUP BY tweek ORDER BY maxip DESC LIMIT 1");
$row = $db -> fetch_array($res);
$stat['maxw_ip'] = $row['maxip'];
$stat['fdate_ip'] = $weekdate -> startDate($row['fdate']);
$stat['ldate_ip'] = $weekdate -> endDate($row['fdate']);
$res = $db -> query("SELECT COUNT(*) AS maxpv,DATE_FORMAT(etime,'%Y-%m') AS mdate FROM ".TABLE_STAT_VISITOR." GROUP BY mdate ORDER BY maxpv DESC LIMIT 1");
$row = $db -> fetch_array($res);
$stat['maxm_pv'] = $row['maxpv'];
$stat['mmonth_pv'] = $row['mdate'];
$res = $db -> query("SELECT COUNT(DISTINCT vip) AS maxip,DATE_FORMAT(etime,'%Y-%m') AS mdate FROM ".TABLE_STAT_VISITOR." GROUP BY mdate ORDER BY maxip DESC LIMIT 1");
$row = $db -> fetch_array($res);
$stat['maxm_ip'] = $row['maxip'];
$stat['mmonth_ip'] = $row['mdate'];
?>