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 run()
{
Yii::import('application.extensions.hole.cms.*');
$manager = new HoleCatalogManager();
$helper = new HoleCmsHelper();
$catalogRows = $manager->getCatalogInFolder('lt481074ef14e7a', 0, 3);
//var_dump($catalogRows);die;
$catalogDetails = array();
$i = 0;
foreach ($catalogRows as $catalog) {
$catalogDetails[$i]['catalog'] = $catalog;
$catalogDetails[$i]['details'] = $manager->getCatalogDetails($catalog['guid']);
$catalogDetails[$i]['image'] = $helper->getImageFromHtml($catalogDetails[$i]['details']['fixedContent']);
$i++;
}
//var_dump($catalogDetails);die;
$this->render('newsslider', array('catalogs' => $catalogDetails));
}
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';
}
<?php
} else {
?>
<div class="bigTitle"><a href="/hole/clinic/list"><?php
echo $this->title;
?>
</a></div>
<?php
}
?>
<div style="padding-top:5px"></div>
<?php
$db = Yii::app()->db;
Yii::import('application.extensions.hole.cms.*');
$catalogManager = new HoleCatalogManager();
$catalogHelper = new HoleCmsHelper();
foreach ($catalogs as $catalog) {
$tmpGuid = $catalog['guid'];
//$command=$db->createCommand("select t1.value title, t2.value subTitle, t3.value description, t4.value content from ((select * from KutuCatalogAttribute where catalogGuid='$tmpGuid' and attributeGuid='fixedTitle') as t1) LEFT JOIN ((select * from KutuCatalogAttribute where catalogGuid='$tmpGuid' and attributeGuid='fixedSubTitle') as t2) ON t1.catalogGuid=t2.catalogGuid LEFT JOIN ((select * from KutuCatalogAttribute where catalogGuid='$tmpGuid' and attributeGuid='fixedDescription') as t3) ON t2.catalogGuid=t3.catalogGuid LEFT JOIN ((select * from KutuCatalogAttribute where catalogGuid='$tmpGuid' and attributeGuid='fixedContent') as t4) ON t3.catalogGuid=t4.catalogGuid");
//$row=$command->queryRow();
$row = $catalogManager->getClinicDetails($tmpGuid);
?>
<h2><a href="<?echo Yii::app()->baseUrl;?>/pages/<?php
echo $tmpGuid;
?>
"><?php
echo $row['fixedTitle'];
?>
</a></h2>
<div class="date"><?php
echo $catalogHelper->formatDateTimeFromMysql($catalog['createdDate']);
<?php
Yii::import('application.extensions.hole.cms.*');
$catalogHelper = new HoleCmsHelper();
?>
<div class="boxDetailArticle">
<h1><?php
echo $catalog['attribute']['fixedTitle'];
?>
</h1>
<div style="padding-top:5px"></div>
<span class="date"><?php
echo $catalogHelper->formatDateTimeFromMysql($catalog['catalog']['publishedDate']);
?>
</span>
<div style="padding-top:5px">
<!-- AddThis Button BEGIN>
<div class="addthis_toolbox addthis_default_style">
<a href="http://www.addthis.com/bookmark.php?v=250&username=xa-4c23437801c0b05a" class="addthis_button_compact">Share</a>
<span class="addthis_separator">|</span>
<a class="addthis_button_facebook"></a>
<a class="addthis_button_myspace"></a>
<a class="addthis_button_google"></a>
<a class="addthis_button_twitter"></a>
</div>
<script type="text/javascript" src="http://s7.addthis.com/js/250/addthis_widget.js#username=xa-4c23437801c0b05a"></script>
< AddThis Button END -->
<!-- AddThis Button BEGIN -->
<div class="addthis_toolbox addthis_default_style">
<a class="addthis_button_facebook"></a>
<?php
Yii::import('application.extensions.hole.auth.*');
Yii::import('application.extensions.hole.cms.*');
if ($sso->getInfo() || ($_SERVER['REQUEST_METHOD'] == 'POST' && $sso->login()))
{
$this->redirect(Yii::app()->user->returnUrl);
exit;
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') $errmsg = "Login failed";
$catalogHelper = new HoleCmsHelper();
?>
<div class="unit horizontal-center layout on-2 columns" style="padding-top:20px;">
<div class="fixed column" style="width:640px;padding-right:20px;">
<p><?=$catalogHelper->getCatalogAttribute($rows[0]['guid'], 'fixedContent'); ?></p>
</div>
<div class="fixed column" style="width:300px;">
<div id="sidecontent">
<div style="text-align:center;">Masuk dengan Hukumonline<br>
<img src="<?=Yii::app()->theme->baseUrl;?>/images/holid2.jpg" height="25" border="0" align="middle"> Akun
</div><br>
<?php
$my_access = new CAuthReader();
$my_access->login_reader();
if (isset($errmsg)): ?><div style="color:red"><?= $errmsg ?></div><? endif; ?>
<form action="<?php $_SERVER['PHP_SELF'];?>" method="post" class="niceform">
<fieldset>
<dl>
