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