Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function statsAction() {
- /** @var Modreview_Model_DbTable_ReviewTasks $tasksTable */
- $tasksTable = Engine_Api::_()->getDbtable('reviewTasks', 'modreview');
- $avgResponseSelect = $tasksTable->select()
- ->from($tasksTable, array('response' => 'AVG(TIMESTAMPDIFF(MINUTE, `create_time`, `reviewed_time`))'))
- ->where('reviewed = 1');
- $avgResponse = $tasksTable->fetchRow($avgResponseSelect);
- $this->view->avgResponse = $avgResponse->response;
- $rankingSelect = $tasksTable->select()
- ->from($tasksTable, array('score' => 'COUNT(1)', 'reviewer_id'))
- ->where('reviewed = 1')
- ->group('reviewer_id')
- ->order('score desc');
- $rankingRows = $tasksTable->fetchAll($rankingSelect);
- $rankings = array();
- foreach ($rankingRows as $ranking) {
- $rankings[] = array('score' => $ranking->score, 'user' => Engine_Api::_()->getItem('user', $ranking->reviewer_id));
- }
- $this->view->rankings = $rankings;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement