| | |
|---|
| | | $time_slot_arr = array(); |
|---|
| | | for($time_slot = 1; $time_slot<=8 ; $time_slot++){ |
|---|
| | | |
|---|
| | | $hour = ($time_slot - 1)*3; |
|---|
| | | $start_hour = $hour.':00:00'; |
|---|
| | | $end_hour = ($hour + 3).':00:00'; |
|---|
| | | if($hour < 10 ){ |
|---|
| | | $start_hour = '0'.$start_hour; |
|---|
| | | } |
|---|
| | | if($hour + 2 < 10){ |
|---|
| | | $end_hour = '0'.$end_hour; |
|---|
| | | } |
|---|
| | | echo '日期：'.$day.' 时间段：'.$start_hour.'---'.$end_hour."======".$user_id."<br />"; |
|---|
| | | $min_hour = ($time_slot - 1)*3; |
|---|
| | | $max_hour = $time_slot * 3; |
|---|
| | | // $start_hour = $hour.':00:00'; |
|---|
| | | // $end_hour = ($hour + 3).':00:00'; |
|---|
| | | // if($hour < 10 ){ |
|---|
| | | // $start_hour = '0'.$start_hour; |
|---|
| | | // } |
|---|
| | | // if($hour + 2 < 10){ |
|---|
| | | // $end_hour = '0'.$end_hour; |
|---|
| | | // } |
|---|
| | | echo '日期：'.$day.' 时间段：'.$min_hour.'---'.$max_hour."======".$user_id."<br />"; |
|---|
| | | $hourly_data = $hourly_model->aggregate( |
|---|
| | | array( |
|---|
| | | array( |
|---|
| | | '$match' => array('create_time' => array('$gte' => $day.' '.$start_hour, '$lt' => $day.' '.$end_hour), 'user_id' => $user_id) |
|---|
| | | '$match' => array('hour' => array('$gte' => $min_hour, '$lt' => $max_hour), 'user_id' => $user_id, 'date' => $day) |
|---|
| | | ), |
|---|
| | | array( |
|---|
| | | '$group' => array('_id' => '$user_id', 'avg' => array('$avg' => '$value')) |
|---|
