Advertisement
boynedmaster

Untitled

Oct 5th, 2015
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.06 KB | None | 0 0
  1. public function statsAction() {
  2. /** @var Modreview_Model_DbTable_ReviewTasks $tasksTable */
  3. $tasksTable = Engine_Api::_()->getDbtable('reviewTasks', 'modreview');
  4. $avgResponseSelect = $tasksTable->select()
  5. ->from($tasksTable, array('response' => 'AVG(TIMESTAMPDIFF(MINUTE, `create_time`, `reviewed_time`))'))
  6. ->where('reviewed = 1');
  7. $avgResponse = $tasksTable->fetchRow($avgResponseSelect);
  8. $this->view->avgResponse = $avgResponse->response;
  9. $rankingSelect = $tasksTable->select()
  10. ->from($tasksTable, array('score' => 'COUNT(1)', 'reviewer_id'))
  11. ->where('reviewed = 1')
  12. ->group('reviewer_id')
  13. ->order('score desc');
  14. $rankingRows = $tasksTable->fetchAll($rankingSelect);
  15. $rankings = array();
  16. foreach ($rankingRows as $ranking) {
  17. $rankings[] = array('score' => $ranking->score, 'user' => Engine_Api::_()->getItem('user', $ranking->reviewer_id));
  18. }
  19. $this->view->rankings = $rankings;
  20. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement