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'; }