private function _getContentInfo($updatedCounts) { //print_r($updatedCounts);die; $uniqueContents = array(); $contentsToFetch = array(); $contents = array(); foreach ($updatedCounts as $k => $arrayBin) { foreach ($arrayBin as $bin => $arrayContent) { if (is_array($arrayContent)) { foreach ($arrayContent as $cnt_id => $count) { $uniqueContents[$k][$cnt_id] = 1; $contentsToFetch[$cnt_id] = 1; } } } } $contentsToFetch = array_keys($contentsToFetch); $contentModel = new Default_Model_Content(); $contentInfo = $contentModel->getContentRows($contentsToFetch); foreach ($contentInfo as $k => $content) { foreach ($uniqueContents as $l => $arrayContents) { if (isset($arrayContents[$content['id_cnt']])) { $contents[$l][$content['id_cnt']] = $content; continue 2; } } } return $contents; }
public function getUserViewedContents($id_usr, $limit = 10) { $select = $this->select()->from($this, 'id_cnt_vws')->setIntegrityCheck(false)->joinLeft('cnt_has_usr', 'id_cnt_vws = id_cnt', array())->where('id_usr != ?', $id_usr)->where('id_usr_vws = ?', $id_usr)->where('modified_vws is not null')->order('modified_vws DESC')->limit($limit); $rowset = $this->fetchAll($select); $contentModel = new Default_Model_Content(); return $contentModel->getContentRows($rowset->toArray(), 'id_cnt_vws', true); }