public function init()
{
$db = Yii::app()->db;
$folderGuid = $this->folderGuid;
$offset = $this->offset;
$limit = $this->limit;
Yii::import('application.extensions.hole.cms.*');
$cmsHelper = new HoleCmsHelper();
$sFolders = $cmsHelper->getStringRelatedFolders($folderGuid);
//$command=$db->createCommand("select * from KutuCatalog where guid in (select catalogGuid from KutuCatalogFolder where folderGuid='$folderGuid') order by createdDate desc limit $offset, $limit ");
$query = "select KutuCatalog.* from KutuCatalog, KutuCatalogFolder where KutuCatalogFolder.folderGuid IN {$sFolders} \n\t\t\t\tAND KutuCatalog.guid = KutuCatalogFolder.catalogGuid \n\t\t\t\torder by KutuCatalog.publishedDate desc limit {$offset}, {$limit}";
$query = "\tSELECT DISTINCT KutuCatalog.*\n\t\t\t\tFROM KutuCatalog, KutuCatalogFolder, KutuFolder\n\t\t\t\tWHERE KutuCatalog.guid=KutuCatalogFolder.catalogGuid \n\t\t\t\tAND KutuCatalogFolder.folderGuid=KutuFolder.guid\n\t\t\t\tAND ( KutuFolder.path LIKE '%{$folderGuid}%' OR KutuFolder.guid='{$folderGuid}') " . " order by KutuCatalog.publishedDate desc limit {$offset}, {$limit}";
$command = $db->createCommand($query);
$dataReader = $command->query();
$rows = $dataReader->readAll();
$this->_catalogFolder = $rows;
}
public function init()
{
$db = Yii::app()->db;
$folderGuid = $this->folderGuid;
$offset = $this->offset;
$limit = $this->limit;
Yii::import('application.extensions.hole.cms.*');
$cmsHelper = new HoleCmsHelper();
$sFolders = $cmsHelper->getStringRelatedFolders($folderGuid);
print_r($sFolders);
//$command=$db->createCommand("select * from KutuCatalog where guid in (select catalogGuid from KutuCatalogFolder where folderGuid='$folderGuid') order by createdDate desc limit $offset, $limit ");
$query = "select KutuCatalog.* from KutuCatalog, KutuCatalogFolder where KutuCatalogFolder.folderGuid IN {$sFolders} \n\t\t\t\tAND KutuCatalog.guid = KutuCatalogFolder.catalogGuid \n\t\t\t\torder by KutuCatalog.publishedDate desc limit {$offset}, {$limit}";
$command = $db->createCommand($query);
$dataReader = $command->query();
$rows = $dataReader->readAll();
$this->_catalogFolder = $rows;
/*
echo '<pre>';
print_r($rows);
echo '</pre>';
*/
}
public function actionFeed()
{
require_once 'Zend/Loader/Autoloader.php';
spl_autoload_unregister(array('YiiBase', 'autoload'));
spl_autoload_register(array('Zend_Loader_Autoloader', 'autoload'));
spl_autoload_register(array('YiiBase', 'autoload'));
Yii::import('application.extensions.hole.cms.*');
$cmsHelper = new HoleCmsHelper();
//$folderGuid = ($_GET['id']): $_GET['id'] ? 'ilb';
$folderGuid = $_GET['id'];
$sFolders = $cmsHelper->getStringRelatedFolders($folderGuid);
$offset = 0;
$limit = 10;
$db = Yii::app()->db;
//$command=$db->createCommand("select * from KutuCatalog where guid in (select catalogGuid from KutuCatalogFolder where folderGuid='$folderGuid') order by createdDate desc limit $offset, $limit ");
$query = "select KutuCatalog.* from KutuCatalog, KutuCatalogFolder where KutuCatalogFolder.folderGuid IN {$sFolders} \n\t\t\t\tAND KutuCatalog.guid = KutuCatalogFolder.catalogGuid \n\t\t\t\torder by KutuCatalog.publishedDate desc limit {$offset}, {$limit}";
$command = $db->createCommand($query);
$dataReader = $command->query();
$rows = $dataReader->readAll();
$catalogManager = new HoleCatalogManager();
foreach ($rows as $row) {
$rowDetail = $catalogManager->getCatalogDetails($row['guid']);
//echo $rowDetail['fixedTitle'].'<br>';
$entries[] = array('title' => $rowDetail['fixedTitle'], 'link' => CHtml::encode($this->createAbsoluteUrl('default/details', array('guid' => $row['guid']))), 'description' => $this->_getSentences(2, $rowDetail['fixedContent']), 'lastUpdate' => strtotime($row['publishedDate']));
}
//var_dump($entries);
$feed = Zend_Feed::importArray(array('title' => 'Hukumonline English RSS Feed', 'link' => $this->createUrl(''), 'charset' => 'UTF-8', 'entries' => $entries), 'rss');
$feed->send();
//echo 'test';
}
