public function addUrls($urls, $id, $type)
{
$pageTypeModel = new Default_Model_PageTypes();
$type = $pageTypeModel->getId($type);
$this->removeFeeds($id, $type);
foreach ($urls as $url) {
if (!$this->feedExists($url, $id, $type)) {
$rssUrl = $this->createRow();
$rssUrl->url_rss = $url;
$rssUrl->id_target_rss = $id;
$rssUrl->type_rss = $type;
$rssUrl->created_rss = new Zend_Db_Expr('NOW()');
$rssUrl->modified_rss = new Zend_Db_Expr('NOW()');
$rssUrl->save();
}
}
}
public function read($id, $type)
{
$rssModel = new Default_Model_RssFeeds();
$pageTypeModel = new Default_Model_PageTypes();
$type = $pageTypeModel->getId($type);
$urls = $rssModel->getUrls($id, $type);
$feeds = array();
foreach ($urls as $url) {
try {
$feed = Zend_Feed_Reader::import($url['url_rss']);
//echo $feed->getEncoding();
$feeds[] = $feed;
} catch (Exception $e) {
echo "Error with feed";
}
}
if (count($feeds) != 0) {
$data = $this->sortFeed($feeds);
} else {
return false;
}
return $data;
}
/**
*
* returns id of type
* @param mixed $type string ("content") or int(2).
* @return int id_type
*/
private function getTypeId($type)
{
$ptpModel = new Default_Model_PageTypes();
$id_type = $ptpModel->getId($type);
return $id_type;
}
public static function hasFeeds($id, $type)
{
$feedModel = new Default_Model_RssFeeds();
$pageTypeModel = new Default_Model_PageTypes();
return $feedModel->hasFeeds($id, $pageTypeModel->getId($type));
}
private function getCommentType($type)
{
$ptpModel = new Default_Model_PageTypes();
return $ptpModel->getId($type);
}
/**
* getFlagsByContentId
* Get all comment flags by content id
*
* @param int id_cnt Id of the content
* @author Mikko Korpinen
*/
public function getFlagsByContentId($id_cnt)
{
$pageTypeModel = new Default_Model_PageTypes();
$select = $this->_db->select()->from(array('cmf' => 'comment_flags_cmf'), array('id_cmf'))->joinLeft(array('cmt' => 'comments_cmt'), 'cmf.id_comment_cmf = cmt.id_cmt')->where('cmt.type_cmt = ?', $pageTypeModel->getId("content"))->where('cmt.id_target_cmt = ?', (int) $id_cnt);
$results = $this->getAdapter()->fetchAll($select);
$finalresult = '';
foreach ($results as $result) {
$finalresult[] = $result['id_cmf'];
}
return $finalresult;
}
/**
* getTypeFromDatabase
*
* @param string $id, type of the comments
* @return int
*/
private function getTypeFromDatabase($id)
{
$pageTypeModel = new Default_Model_PageTypes();
return $pageTypeModel->getId($id);
}
public function getFilenames($id_cnt, $type)
{
$fliModel = new Default_Model_FileLinks();
$ptpModel = new Default_Model_PageTypes();
$id_type = $ptpModel->getId($type);
$ids = $fliModel->getFileIds($id_cnt, $id_type);
$result = $this->find($ids);
$rows = array();
foreach ($result as $row) {
$rows[$row->id_fil] = $row->filename_fil;
}
return $rows;
}
