统计用户某段时间的发帖量，展示图片如图：
可以排除某些用户ID
可以调整选择页的选项个数，我的是12个月
当然，你也可以自己设置时间比如：像我这样访问，改”|”分割的两个日期就行，”https://www.kekc.cn/postnum.php?act=2021-01-01|2021-12-31″，这样就是统计2021一整年（从一月一号到十二月三十一号）的数据，而非一个月。postnum.php是我的PHP脚本，www.vience.cn是我的网站，需要修改为自己的信息。
代码如下，保存为PHP并保存到wordpress网站根目录，其他目录需要改第二行的wp-load.php位置：
<?php
include_once("wp-load.php");
global $wpdb;
function userpostnum($userid,$startdate,$enddate){//返回某人某天的文章数
global $wpdb;
$num = $wpdb->get_var(
$wpdb->prepare("SELECT COUNT(ID) FROM `wp_posts` WHERE
`post_author` = $userid
AND post_type= 'post'
AND post_status= 'publish'
AND post_date between '$startdate' and '$enddate';")
);
return $num;
}
//成员
$useridname = $wpdb->get_results("SELECT ID,display_name FROM `wp_users`");
$useridnamenum = count($useridname);
$chengyuan=array();
for ($i = 0; $i < $useridnamenum; $i++) {
$userid = $useridname[$i] -> ID;
$username = $useridname[$i] -> display_name;
if( $userid == 1 or $userid == 4 or $userid == 16 or $userid == 13 or $userid ==18 or $userid == 5 or $userid == 6 or $userid == 8 or $userid == 3 or $userid == 14 or $userid == 12 or $userid == 9){
echo "";//排除人员
}else{
array_push($chengyuan,$useridname[$i]);
}
}
//成员
$userpostnum= null;
$userspostnum= null;
$act = $_REQUEST["act"];
if($act == "shangyue"){
$starttime = date('Y-m-01', strtotime('-1 month'));//上月一号
$endtime = date('Y-m-t', strtotime('-1 month'));//上月最后一天
}elseif($act == "benyue"){
$starttime = date('Y-m-01');//本月一号
$endtime = date('Y-m-d', strtotime("+1 month -1 day"));//本月最后一天
}elseif($act){
$date = explode("|",$act);
$starttime = $date[0];//本月一号
$endtime = $date[1];//本月最后一天
}else{
echo "<title>统计选择页</title>";
$starttime = date('Y-m-01');//本月一号
$endtime = date('Y-m-t');//本月最后一天
for ($i = 0; $i < 12; $i++) {
echo "<a href = 'postsnum.php?act=${starttime}|${endtime}'>${starttime}至${endtime}文章统计</a><br>";
$starttime = date('Y-m-01', strtotime($starttime .'-1 month'));
$endtime = date('Y-m-t', strtotime($starttime));//本月最后一天
}
exit("<a href = 'https://vience.dift.cn/'>返回文曦博客（www.vience.cn）首页</a>");
}
$title = $starttime."至".$endtime."的学习详情";
for ($i = 0; $i < count($chengyuan); $i++) {
$userid = $chengyuan[$i]->ID;
$username = $chengyuan[$i]->display_name;
$userpostnum[$i] = userpostnum($userid,$starttime." 00:00:00",$endtime." 23:59:59");
$userspostnum[$i] = array("value"=>$userpostnum[$i],"name"=>$username." ".$userpostnum[$i]);
}
function multi_dimension_sort(...$args){
$arr = array_shift($args); // 取到要排序的数组，剩下的为要排序的键和排序类型
$sort_arg = [];
foreach($args as $arg){
// 这里主要是为了得到排序的key对应的值
$sort = $arr;
if(is_string($arg)){
$arg = explode('.', $arg); // 我设定参数里面多维数组下的键，用‘.’连接下级的键，这里得到键，然后下面循环取得数组$arr里面该键对应的值
foreach($arg as $key){
$sort = array_column($sort, $key); // 每次循环$sort的维度就会减一
}
$sort_arg[] = $sort;
}else{
$sort_arg[] = $arg; // 排序方法SORT_ASC、SORT_DESC等
}
}
$sort_arg[] = &$arr; // 这个数组大致结构为：[$sort, SORT_ASC, $sort2, SORT_DESC,$arr]
call_user_func_array('array_multisort', $sort_arg); // 因为参数不确定数量，所以不能直接array_multisort($sort, SORT_ASC, $sort2, SORT_DESC,$arr)，用call_user_func_array执行
return($arr);
}
$info = multi_dimension_sort($userspostnum, 'value', SORT_DESC);
$info = json_encode($info,JSON_UNESCAPED_UNICODE);
?>
<!--
THIS EXAMPLE WAS DOWNLOADED FROM https://echarts.apache.org/examples/zh/editor.html?c=pie-roseType-simple
-->
<!DOCTYPE html>
<html style="height: 100%">
<head>
<meta charset="utf-8">
<title><?php echo $title?></title>
</head>
<body style="height: 100%; margin: 0">
<div id="container" style="height: 100%"></div>
<script type="text/javascript" src="https://cdn.jsdelivr.net/npm/echarts/dist/echarts.min.js"></script>
<!-- Uncomment this line if you want to dataTool extension
<script type="text/javascript" src="https://cdn.jsdelivr.net/npm/echarts@{{version}}/dist/extension/dataTool.min.js"></script>
-->
<!-- Uncomment this line if you want to use gl extension
<script type="text/javascript" src="https://cdn.jsdelivr.net/npm/echarts-gl@2/dist/echarts-gl.min.js"></script>
-->
<!-- Uncomment this line if you want to echarts-stat extension
<script type="text/javascript" src="https://cdn.jsdelivr.net/npm/echarts-stat@latest/dist/ecStat.min.js"></script>
-->
<!-- Uncomment this line if you want to use map
<script type="text/javascript" src="https://cdn.jsdelivr.net/npm/echarts@{{version}}/map/js/china.js"></script>
<script type="text/javascript" src="https://cdn.jsdelivr.net/npm/echarts@{{version}}/map/js/world.js"></script>
-->
<!-- Uncomment these two lines if you want to use bmap extension
<script type="text/javascript" src="https://api.map.baidu.com/api?v=2.0&ak=<Your Key Here>"></script>
<script type="text/javascript" src="https://cdn.jsdelivr.net/npm/echarts@{{version}}/dist/extension/bmap.min.js"></script>
-->
<script type="text/javascript">
var dom = document.getElementById("container");
var myChart = echarts.init(dom);
var app = {};
var option;
option = {
legend: {
top: 'bottom'
},
toolbox: {
show: true,
feature: {
mark: { show: true },
dataView: { show: true, readOnly: false },
restore: { show: true },
saveAsImage: { show: true }
}
},
series: [
{
name: 'Nightingale Chart',
type: 'pie',
radius: [50, 250],
center: ['50%', '50%'],
roseType: 'area',
itemStyle: {
borderRadius: 9
},
data: <?php echo($info);?>
}
]
};
if (option && typeof option === 'object') {
myChart.setOption(option);
}
</script>
</body>
</html>© 版权声明
THE END
暂无评论内容