本範例示範如何統計文章的總點擊、月點擊、週點擊、日點擊,並自動重置跨期計數器。程式碼直接操作 dede_tongji 資料表,可整合進 DedeCMS 或類似系統。
CREATE TABLE `dede_tongji` (
`aid` int(11) NOT NULL,
`cid` smallint(5) NOT NULL,
`tid` smallint(5) NOT NULL,
`m_total` int(11) NOT NULL DEFAULT '1',
`w_total` int(11) NOT NULL DEFAULT '1',
`d_total` int(11) NOT NULL DEFAULT '1',
`t_total` int(11) NOT NULL DEFAULT '1',
`lasttime` int(12) NOT NULL,
PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
countdown($aid)<?php
function countdown($field_id) {
date_default_timezone_set('Asia/Shanghai');
global $dsql;
$now = getdate(time());
$table = '#@__tongji';
$sql = "SELECT * FROM `$table` WHERE aid=$field_id";
$rs = $dsql->ExecuteNoneQuery2($sql);
if ($rs <= 0) { // 首次點擊,新增記錄
$typeid = $dsql->GetOne("SELECT typeid FROM `#@__archives` WHERE id=$field_id");
$query = "INSERT INTO `$table` VALUES($field_id, {$typeid['typeid']}, 1, 1, 1, 1, {$now[0]})";
$dsql->ExecNoneQuery($query);
return 1;
}
$row = $dsql->GetOne($sql);
$old = getdate($row['lasttime']);
$m_total = $row['m_total'];
$w_total = $row['w_total'];
$d_total = $row['d_total'];
$t_total = $row['t_total'];
// 月份變更重置
if (!($now['year'] == $old['year'] && $now['mon'] == $old['mon'])) $m_total = 1;
else $m_total++;
// 週變更重置(以週日為週起始)
$weekStart = mktime(0,0,0,$now['mon'],$now['mday'],$now['year']) - $now['wday']*86400;
$weekEnd = mktime(23,59,59,$now['mon'],$now['mday'],$now['year']) + (6-$now['wday'])*86400;
if ($row['lasttime'] >= $weekStart && $row['lasttime'] <= $weekEnd) $w_total++;
else $w_total = 1;
// 日變更重置
$dayStart = mktime(0,0,0,$now['mon'],$now['mday'],$now['year']);
$dayEnd = mktime(23,59,59,$now['mon'],$now['mday'],$now['year']);
if ($row['lasttime'] >= $dayStart && $row['lasttime'] <= $dayEnd) $d_total++;
else $d_total = 1;
$t_total++;
$dsql->ExecuteNoneQuery("UPDATE $table SET m_total=$m_total,w_total=$w_total,d_total=$d_total,t_total=$t_total,lasttime={$now[0]} WHERE aid=$field_id");
$dsql->ExecuteNoneQuery("UPDATE dede_archives SET click=$t_total WHERE id=$field_id");
return $t_total;
}
// 呼叫範例
countdown($aid);
?>
getdate() 取得結構化時間陣列,方便比對年/月/週/日wday(0=週日)為基準,向前推算週日 00:00 至週六 23:59dede_archives.click 供前台排序使用此函數可放入通用函式庫,在文章顯示頁面頂部引入即可自動統計。