$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; ?> " rel="facebox"><img src="<?echo Yii::app()->theme->baseUrl;?>/images/quickview_icon.gif"> Quick View</a--> </div> <?php if ($this->showLongDescription != -1) { ?> <?php if ($this->showLongDescription) { ?>
<?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>