where(function($query) use ($params){ $type = isset($params['type'])? $params['type'] : 0; if($type){ $query->where('type', $type); } }) ->field($field) ->order('create_time desc') ->limit($pageSize) ->select() ->each(function($item, $k){ if(isset($item['name'])){ $item['name'] = $item['name']? formatName($item['name']) : '游客'; } $item['address'] = isset($item['address'])? $item['address'] : ''; $item['address'] = $item['address']? $item['address'] : (isset($item['ip'])? IpService::getAddress($item['ip']) : '未知地区'); return $item; }); $dataList = $dataList ? $dataList->toArray() : []; if ($dataList) { RedisService::set($cacheKey, $dataList, 1 * 3600); } return $dataList; } /** * 获取今天提交次数 * @param $where */ public static function getTodyCount($where){ $todaytime = strtotime(date('Y-m-d')); $cacheKey = "cache:messages:count_".date('Ymd'); $data = RedisService::get($cacheKey); if ($data) { return $data; } $data = Db::name('message') ->where($where) ->where('create_time','gt',$todaytime) ->count(); if($data){ RedisService::set($cacheKey, $data, 6 * 3600); } return $data; } /** * 获取本周提交次数 * @param $where */ public static function getWeekCount($where){ // 当前日期 $sdefaultDate = date("Y-m-d"); // $first =1 表示每周星期一为开始日期 0表示每周日为开始日期 $first=1; // 获取当前周的第几天 周日是0 周一到周六是 1 - 6 $w = date('w', strtotime($sdefaultDate)); // 获取本周开始日期，如果$w是0，则表示周日，减去 6 天 $week_start=strtotime("$sdefaultDate -".($w ? $w - $first : 6).' days'); return Db::name('message') ->where($where) ->where('create_time','gt',$week_start) ->count(); } }