sys_admin_user_tj.php
5.23 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
<?php
/**
* 获取用户的统计信息
*
* @version $Id: sys_admin_user_edit.php 1 16:22 2010年7月20日Z tianya $
* @package DedeCMS.Administrator
* @copyright Copyright (c) 2007 - 2010, DesDev, Inc.
* @license http://help.dedecms.com/usersguide/license.html
* @link http://www.dedecms.com
*/
require_once(dirname(__FILE__)."/config.php");
CheckPurview('sys_User');
if(isset($dopost) && $dopost=='getone')
{
$row = $dsql->GetOne("SELECT userid FROM `#@__admin` WHERE id='$uid'; ");
$userid = $row['userid'];
$y = intval(MyDate('Y', time()));
$m = intval(MyDate('m', time()));
$d = intval(MyDate('d', time()));
//全部
$sql="SELECT addtable FROM `#@__channeltype` WHERE issystem='-1'";
$dsql->Execute('me', $sql);
while($frow = $dsql->GetArray('me'))
{
$dd=empty($dd)? "0" : $dd;
$cc=empty($cc)? "0" : $cc;
$row = $dsql->GetOne("SELECT COUNT(aid) AS dd,SUM(click) AS cc FROM `{$frow['addtable']}` WHERE mid='$uid'; ");
$dd += $row['dd'];
$cc += $row['cc'];
}
$row = $dsql->GetOne("SELECT COUNT(id) AS dd,SUM(click) AS cc FROM `#@__archives` WHERE mid='$uid'; ");
$dd = $row['dd'] + $dd;
$cc = $row['cc'] + $cc;
//季度
$starttime = 0;
if( preg_match("#[123]#", $m) && $m < 10) $starttime = $y."-01-01 00:00:00";
else if( preg_match("#[456]#", $m) ) $starttime = $y."-04-01 00:00:00";
else if( preg_match("#[789]#", $m) ) $starttime = $y."-07-01 00:00:00";
else $starttime = $y."-10-01 00:00:00";
$istarttime = GetMkTime($starttime);
$sql="SELECT addtable FROM `#@__channeltype` WHERE issystem='-1'";
$dsql->Execute('me', $sql);
while($frow = $dsql->GetArray('me'))
{
$dds = empty($dds)? "0" : $dds;
$ccs = empty($ccs)? "0" : $ccs;
$row = $dsql->GetOne("SELECT COUNT(aid) AS dd,SUM(click) AS cc FROM `{$frow['addtable']}` WHERE senddate>$istarttime AND mid='$uid'; ");
$dds += $row['dd'];
$ccs += $row['cc'];
}
$row = $dsql->GetOne("SELECT COUNT(id) AS dd,SUM(click) AS cc FROM `#@__archives` WHERE senddate>$istarttime AND mid='$uid'; ");
$dds = $row['dd'] + $dds;
$ccs = $row['cc'] + $ccs;
//当月
$starttime = $y."-{$m}-01 00:00:00";
$istarttime = GetMkTime($starttime);
$sql="SELECT addtable FROM `#@__channeltype` WHERE issystem='-1'";
$dsql->Execute('me', $sql);
while($frow = $dsql->GetArray('me'))
{
$ddm = empty($ddm)? "0" : $ddm;
$ccm = empty($ccm)? "0" : $ccm;
$row = $dsql->GetOne("SELECT COUNT(aid) AS dd,SUM(click) AS cc FROM `{$frow['addtable']}` WHERE senddate>$istarttime AND mid='$uid'; ");
$ddm += $row['dd'];
$ccm += $row['cc'];
}
$row = $dsql->GetOne("SELECT COUNT(id) AS dd,SUM(click) AS cc FROM `#@__archives` WHERE senddate>$istarttime AND mid='$uid'; ");
$ddm = $row['dd'] + $ddm;
$ccm = $row['cc'] + $ccm;
//本周
$starttime = $y."-{$m}-{$d} 00:00:00";
$istarttime = GetMkTime($starttime) - (7*24*3600);
$sql="SELECT addtable FROM `#@__channeltype` WHERE issystem='-1'";
$dsql->Execute('me', $sql);
while($frow = $dsql->GetArray('me'))
{
$ddw=empty($ddw)? "0" : $ddw;
$ccw=empty($ccw)? "0" : $ccw;
$row = $dsql->GetOne("SELECT COUNT(aid) AS dd,SUM(click) AS cc FROM `{$frow['addtable']}` WHERE senddate>$istarttime AND mid='$uid'; ");
$ddw += $row['dd'];
$ccw += $row['cc'];
}
$row = $dsql->GetOne("SELECT COUNT(id) AS dd,SUM(click) AS cc FROM `#@__archives` WHERE senddate>$istarttime AND mid='$uid'; ");
$ddw = $row['dd'] + $ddw;
$ccw = $row['cc'] + $ccw;
//当天
$starttime = $y."-{$m}-{$d} 00:00:00";
$istarttime = GetMkTime($starttime);
$sql="SELECT addtable FROM `#@__channeltype` WHERE issystem='-1'";
$dsql->Execute('me', $sql);
while($frow = $dsql->GetArray('me'))
{
$ddd=empty($ddd)? "0" : $ddd;
$ccd=empty($ccd)? "0" : $ccd;
$row = $dsql->GetOne("SELECT COUNT(aid) AS dd,SUM(click) AS cc FROM `{$frow['addtable']}` WHERE senddate>$istarttime AND mid='$uid'; ");
$ddd += $row['dd'];
$ccd += $row['cc'];
}
$row = $dsql->GetOne("SELECT COUNT(id) AS dd,SUM(click) AS cc FROM `#@__archives` WHERE senddate>$istarttime AND mid='$uid'; ");
$ddd = $row['dd'] + $ddd;
$ccd = $row['cc'] + $ccd;
$msg = "<table width='96%' border='0' align='center' cellpadding='3' cellspacing='1' bgcolor='#cfcfcf'>
<tr align='center' bgcolor='#FBFCE2'>
<td width='18%' height='26'><strong>管理员↓|统计信息→</strong></td>
<td width='18%'><strong>全部(文档|点击)</strong></td>
<td width='16%'><strong>季度</strong></td>
<td width='16%'><strong>当月</strong></td>
<td width='16%'><strong>近七天</strong></td>
<td width='16%'><strong>当天</strong></td>
</tr>
<tr align='center' bgcolor='#FFFFFF'>
<td height='26'>{$userid}</td>
<td>{$dd} | {$cc}</td>
<td>{$dds} | {$ccs}</td>
<td>{$ddm} | {$ccm}</td>
<td>{$ddw} | {$ccw}</td>
<td>{$ddd} | {$ccd}</td>
</tr>
</table><br style='clear:both'/>\r\n";
AjaxHead();
echo $msg;
exit();
}
include DedeInclude('templets/sys_admin_user_tj.htm');