Example #1
0
File: User.php Project: jannev/site
 /**
  * sortUsersByContentInfo
  * 
  * Sorts $userIdList by $sort
  * 
  * @param ZEND SQL search query returning array of user id:s
  * @param string $sort
  * @return $resultList
  * @author Jari Korpela
  */
 public function sortUsersByContentInfo($search, $sort, $list, $limit)
 {
     $content = new Default_Model_ContentHasUser();
     $select = $content->select()->from('cnt_has_usr', array('id_usr'))->where('id_usr IN (?)', $search)->order(array($sort, 'id_usr'))->group('id_usr');
     if ($limit) {
         $select->limit($limit, 0);
     }
     //print_r($select->assemble());echo "\n";
     $result = $this->simplifyArray($content->_db->fetchAll($select), 'id_usr');
     if ($list) {
         $result = $this->addMissingIdsToResult($result, $this->simplifyArray($content->_db->fetchAll($search), 'id_usr'), $list);
     }
     return $result;
 }