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]);
}
