// +---------------------------------------------------------------------- namespace app\admin\model\store; use traits\ModelTrait; use basic\ModelBasic; use app\admin\model\user\User; /** * 商品浏览分析 * Class StoreOrder * @package app\admin\model\store */ class StoreVisit extends ModelBasic { use ModelTrait; /** * @param $where * @return array */ public static function getVisit($date,$class=[]){ $model=new self(); switch ($date){ case null:case 'today':case 'week':case 'year': if($date==null) $date='month'; $model=$model->whereTime('add_time',$date); break; case 'quarter': list($startTime,$endTime)=User::getMonth('n'); $model = $model->where('add_time','>',$startTime); $model = $model->where('add_time','<',$endTime); break; default: list($startTime,$endTime)=explode('-',$date); $model = $model->where('add_time','>',strtotime($startTime)); $model = $model->where('add_time','<',strtotime($endTime)); break; } $list=$model->group('type')->field('sum(count) as sum,product_id,cate_id,type,content')->order('sum desc')->limit(0,10)->select()->toArray(); $view=[]; foreach ($list as $key=>$val){ $now_list['name']=$val['type']=='viwe'?'浏览量':'搜索'; $now_list['value']=$val['sum']; $now_list['class']=isset($class[$key])?$class[$key]:''; $view[]=$now_list; } if(empty($list)){ $view=[['name'=>'暂无数据', 'value'=>100, 'class'=>'']]; } return $view; } }