public static function getBannerByCategory($position, $firmId) { $cout = ""; $DBParams = DBQueryParamsClass::CreateParams()->setConditions("position_id=:position_id AND firm_id=:firmId AND active=1")->setParams(array(":position_id" => $position, ":firmId" => $firmId))->setOrderBy("col")->setLimit(1)->setCache(0); $bannerArray = CatalogFirmsBanners::fetchAll($DBParams); if (sizeof($bannerArray) > 0 && $bannerArray[0]->file) { $banner = $bannerArray[0]; $banner->col = $banner->col + 1; if (!$banner->save()) { print_r($banner->getErrors()); } $cout = '<div class="banerBlock">'; if ($banner->type_id->id == 1) { if ($banner->link) { $cout .= '<a href="' . $banner->link . '" title="">'; } $cout .= '<img src="' . $banner->file . '" alt="" />'; if ($banner->link) { $cout .= '</a>'; } } else { $width = $banner->width ? ' width="' . $banner->width . '"' : ' width="800"'; $height = $banner->height ? ' height="' . $banner->height . '"' : ' height="90"'; $cout .= '<br/><a href="' . $banner->href . '" title=""> <object ' . $width . ' ' . $height . ' classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"> <param value="' . $banner->image . '" name="movie"/> <embed ' . $width . ' ' . $height . ' src="' . $banner->file . '" type="application/x-shockwave-flash"/> </object> </a>'; } $cout .= '</div>'; } return $cout; }
<div id="innerPage"> <?php $this->widget('addressLineWidget', array('links' => array(Yii::t("user", "мои фирмы") => SiteHelper::createUrl("/user/firms"), Yii::t("page", "Описание")))); $listComments = CatalogFirmsComments::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("firm_id=:firm_id")->setParams(array(":firm_id" => $item->id))->setOrderBy("id DESC")->setLimit(50)->setCache(0)); $listService = CatalogFirmsService::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("firm_id=:firm_id")->setParams(array(":firm_id" => $item->id))->setLimit(50)->setCache(0)); $listItems = CatalogFirmsItems::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("firm_id=:firm_id")->setParams(array(":firm_id" => $item->id))->setLimit(50)->setCache(0)); $listBanners = CatalogFirmsBanners::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("firm_id=:firm_id")->setParams(array(":firm_id" => $item->id))->setLimit(50)->setCache(0)); $listTours = CatalogTours::fetchAll(DBQueryParamsClass::CreateParams()->setConditions("firm_id=:firm_id")->setParams(array(":firm_id" => $item->id))->setLimit(50)->setCache(0)); $tab = Yii::app()->request->getParam("tab", "description"); $tabArray = array("description", "ptours", "items", "service", "reclame", "pcomments", "counter"); if (!in_array($tab, $tabArray)) { $tab = "description"; } ?> <div class="sovetBlock"><a href="<?php echo SiteHelper::createUrl("/site/addFirm"); ?> " title="<?php echo Yii::t("user_firm", "Как правильно добавить фирму?"); ?> "><?php echo Yii::t("user_firm", "Как правильно добавить фирму?"); ?> </a></div> <h1><font><?php echo Yii::t("user_firm", "Описание туристического агенства"); ?> </font> <?php echo $item->id > 0 ? " - " . $item->name : ""; ?> </h1>