From bef2c06923d3ba6727654f734bb93d5a09855dc5 Mon Sep 17 00:00:00 2001 From: colly_wyx <wangyixiong_007@163.com> Date: Thu, 14 Jun 2018 09:50:43 +0800 Subject: [PATCH] 增加女声 --- Yfs/Domain/DataDaily.php | 62 +++++++++++++++++++++++++++++-- 1 files changed, 58 insertions(+), 4 deletions(-) diff --git a/Yfs/Domain/DataDaily.php b/Yfs/Domain/DataDaily.php index 57cf6f7..8586c3b 100644 --- a/Yfs/Domain/DataDaily.php +++ b/Yfs/Domain/DataDaily.php @@ -7,7 +7,8 @@ public function __construct(){ //DI()->redis = new Redis_Lite(DI()->config->get('app.redis.servers')); $this->model = new Model_DataDaily(); - $this->hourly_model = new Model_DataHourly(); + $this->data_three_hourly_model = new Model_DataThreeHourly(); + $this->data_hourly_model = new Model_DataHourly(); } /** @@ -23,21 +24,74 @@ if($end_time > $start_time){ $diff_days = ($end_time - $start_time) / 86400; $total_days = $diff_days + 1;//��������������������� - $step = ($total_days - $total_days % 7) / 7; + //$step = ($total_days - $total_days % 7) / 7; $days_arr= array(); - for($i = 0; $i < 7*$step ; $i+=$step){ + for($i = 0; $i < $total_days ; $i+=1){ $days_arr[] = date('Y-m-d', strtotime('+'.$i.' day', $start_time)); } $result = $this->model->getList(array('user_id' => $user_id, 'date' => array('$in' => $days_arr))); } else{ - $result = $this->hourly_model->getList(array('user_id' => $user_id, 'date' => $start_time), array(), array('time_level' => 1)); + $result = $this->data_three_hourly_model->get(array('user_id' => $user_id, 'date' => date('Y-m-d', $start_time))); + $_result = array(); + if($result){ + for($i = 1; $i <=8 ; $i++){ + array_push($_result, array('hour_avg' => $result['time_slot_'.$i], 'time_level' => $i)); + } + } + else{ + $_result = null; + } + return $_result; } return $result; } /** + * ������������������������������������������ + * @param [type] $user_id [description] + * @param [type] $start_time [description] + * @param [type] $end_time [description] + * @return [type] [description] + */ + public function getUserDataAvg($user_id, $start_time, $end_time){ + + // if($start_time == $end_time){ + // $result = $this->data_hourly_model->get(array('date' => $start_time)); + // if($result){ + // $sum = 0; + // for($i = 1; $i <= 8; $i++){ + // $sum += $result['time_slot_'.$i]; + // } + + // $result[0]['day_avg'] = $sum/8; + // } + // else{ + // $result[0]['day_avg'] = 0; + // } + + // } + // else{ + $result = $this->data_hourly_model->aggregate( + array( + array( + '$match' => array('date' => array('$gte' => $start_time, '$lte' => $end_time), 'user_id' => $user_id) + ), + array( + '$group' => array('_id' => '$user_id', 'day_avg' => array('$avg' => '$value')) + ), + array( + '$project' => array('_id' => 0, 'day_avg' => 1) + ) + ) + ); + //} + + return isset($result[0]['day_avg'])?floatval(substr($result[0]['day_avg'], 0, 5)):0; + } + + /** * ������������ * @param [type] $start_time [description] * @param [type] $end_time [description] -- Gitblit v1.8.0