public function getClinicDetails($catalogGuid)
{
Yii::import('application.extensions.hole.cms.*');
$catalogManager = new HoleCatalogManager();
$row = $catalogManager->getClinicDetails($catalogGuid);
return $row;
}
?>
</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']);
?>
<!--a href="<?echo Yii::app()->baseUrl;?>/hole/default/info/guid/<?php
echo $tmpGuid;
?>
