/ * 會員統計
*/
public function member_count(){
$data1 = D('member')->total();
$data2 = D('member')->where(array('status'=>1))->total();
$data3 = D('member')->where(array('status'=>2))->total();
$data4 = D('member')->where(array('vip'=>1))->total();
$data5 = D('member')->where(array('lastdate>'=>strtotime(date('Y-m-d', strtotime('-1 week')))))->total();
$data6 = D('member')->where(array('email_status'=>1))->total();
//近一周統計開始時間
$starttime = strtotime(date('Y-m-d'))-7*24*3600;
//近一周統計結束時間
$endtime = strtotime(date('Y-m-d'));
$where = "regdate > $starttime"; //無需加結束條件,否則統計不到今日數據
$data = D('member')->field("COUNT(*) AS num,FROM_UNIXTIME(regdate, '%m/%d') AS gap")->where($where)->group('gap')->select();
$arr = array();
foreach ($data as $val){
$arr[$val['gap']] = intval($val['num']);
}
$result1 = array();
for($i=$starttime; $i<=$endtime; $i = $i+24*3600){
$num = isset($arr[date('m/d',$i)]) ? $arr[date('m/d',$i)] : 0;
$result1['day'][] = date('m/d',$i);
$result1['num'][] = $num;
}
$result1 = json_encode($result1);
// 會員組人員統計
$result2 = array();
foreach(get_groupinfo() as $val){
$result2[] = array(
'name' => $val['name'],
'value' => D('member')->where(array('groupid'=>$val['groupid']))->total()
);
}
$result2 = json_encode($result2);
include template('index', $template);
}
以上內容需要在首頁中讀取顯示數據里該如何修改,謝謝
這個首頁里的該如何寫???