From b8a82d561917a4336214225f65f4488d977c5fb1 Mon Sep 17 00:00:00 2001 From: colly_wyx <wangyixiong_007@163.com> Date: Thu, 03 May 2018 09:28:00 +0800 Subject: [PATCH] 调整平均值 --- Yfs/Domain/DataDaily.php | 37 +++++++++++++++++++------------------ 1 files changed, 19 insertions(+), 18 deletions(-) diff --git a/Yfs/Domain/DataDaily.php b/Yfs/Domain/DataDaily.php index de8fc57..8586c3b 100644 --- a/Yfs/Domain/DataDaily.php +++ b/Yfs/Domain/DataDaily.php @@ -8,6 +8,7 @@ //DI()->redis = new Redis_Lite(DI()->config->get('app.redis.servers')); $this->model = new Model_DataDaily(); $this->data_three_hourly_model = new Model_DataThreeHourly(); + $this->data_hourly_model = new Model_DataHourly(); } /** @@ -56,38 +57,38 @@ */ public function getUserDataAvg($user_id, $start_time, $end_time){ - if($start_time == $end_time){ - $result = $this->data_three_hourly_model->get(array('date' => $start_time)); - if($result){ - $sum = 0; - for($i = 1; $i <= 8; $i++){ - $sum += $result['time_slot_'.$i]; - } + // 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; - } + // $result[0]['day_avg'] = $sum/8; + // } + // else{ + // $result[0]['day_avg'] = 0; + // } - } - else{ - $result = $this->model->aggregate( + // } + // 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' => '$day_avg')) + '$group' => array('_id' => '$user_id', 'day_avg' => array('$avg' => '$value')) ), array( '$project' => array('_id' => 0, 'day_avg' => 1) ) ) ); - } + //} - return isset($result[0]['day_avg'])?$result[0]['day_avg']:0; + return isset($result[0]['day_avg'])?floatval(substr($result[0]['day_avg'], 0, 5)):0; } /** -- Gitblit v1.8.0