echo Apartment::model()->count('type=:typeId AND owner_id=:userId', [':typeId' => (int) $_GET['type'], ':userId' => $user->id]); ?> </span></li> <li><a href="#">Избранные</a><span>3</span></li> <li><a href="/usercpanel/main/rentorders">Разместить</a></li> <li><a href="/usercpanel/xmlfeed">XML-фид</a></li> </ul> </li> <li id="lm2"><a href="#">Заявки</a> <ul class="sub-menu"> <li><a href="/usercpanel/main/rentsdisplay/?type=1">Аренда</a><span><?php echo !is_null(ApartmentsRents::model()->findByAttributes(['type' => [1, 2], 'userFrom' => Yii::app()->user->id])) ? ApartmentsRents::model()->findByAttributes(['type' => [1, 2], 'userFrom' => Yii::app()->user->id])->count() : 0; ?> </span></li> <li><a href="/usercpanel/main/rentsdisplay/?type=3">Продажа</a><span><?php echo !is_null(ApartmentsRents::model()->findByAttributes(['type' => 3, 'userFrom' => Yii::app()->user->id])) ? ApartmentsRents::model()->findByAttributes(['type' => 3, 'userFrom' => Yii::app()->user->id])->count() : 0; ?> </span></li> <li><a href="/usercpanel/main/rents">Разместить</a></li> </ul> </li> <li id="lm5"><a href="#">Клиенты</a> <ul class="sub-menu"> <li><a href="#">Мои клиенты</a><span>2</span></li> <li><a href="/usercpanel/main/clients">Поиск клиентов</a></li> <li><a href="#">Комментарии</a><span>0</span></li> <li><a href="/usercpanel/main/negatives">Жалобы</a></li> </ul> </li> <li id="lm6"><a href="#">Архив</a></li> <li id="lm3"><a href="#">Сообщения</a>
public function actionClients() { $this->layout = '//layouts/clients'; $country = Yii::app()->request->getParam('country'); $city = Yii::app()->request->getParam('city'); $objType = Yii::app()->request->getParam('objType'); $renttype = !is_null(Yii::app()->request->getParam('renttype')) ? Yii::app()->request->getParam('renttype') : 1; $sql = 'SELECT * FROm `bt_apartments_rents` WHERE `type`=' . $renttype; if (!is_null($country)) { $sql .= ' AND `loc_country_id`=' . $country; } if (!is_null($city)) { $sql .= ' AND `loc_city_id`=' . $city; } if (!is_null($objType)) { $sql .= ' AND `objTypeId`=' . $objType; } $rentorders = ApartmentsRents::model()->findAllBySql($sql); $this->render('clients', ['rentorders' => $rentorders]); }