Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $this->aData['saleCpanelItems'] = Menu::getMenuItems(true, 1);
- $idRegion = Yii::app()->controller->geoUserCityId;
- $countAp = Apartment::model()->count('loc_region=:loc_region and type = 2 and obj_type_id = 1', array(':loc_region' => $idRegion));
- $countrooms = Apartment::model()->count('loc_region=:loc_region and type = 2 and obj_type_id = 5', array(':loc_region' => $idRegion));
- $countlots = Apartment::model()->count('loc_region=:loc_region and type = 2 and obj_type_id = 4', array(':loc_region' => $idRegion));
- $countcottages = Apartment::model()->count('loc_region=:loc_region and type = 2 and obj_type_id = 11', array(':loc_region' => $idRegion));
- $counthouses = Apartment::model()->count('loc_region=:loc_region and type = 2 and obj_type_id = 2', array(':loc_region' => $idRegion));
- $countoffice = Apartment::model()->count('loc_region=:loc_region and type = 2 and obj_type_id = 3', array(':loc_region' => $idRegion));
- $countwrhouses = Apartment::model()->count('loc_region=:loc_region and type = 2 and obj_type_id = 8', array(':loc_region' => $idRegion));
- $countbigroom = Apartment::model()->count('loc_region=:loc_region and type = 2 and obj_type_id = 9', array(':loc_region' => $idRegion));
- $countgarages = Apartment::model()->count('loc_region=:loc_region and type = 2 and obj_type_id = 10', array(':loc_region' => $idRegion));
- $this->aData['saleCpanelItems'][] = array(
- 'label' => tc('Apartments').' <span>'.$countAp.'</span>',
- 'url' => array('/quicksearch/main/mainsearch', 'apType' => '1', 'objType' => '1', 'region' => $idRegion),
- );
- $this->aData['saleCpanelItems'][] = array(
- 'label' => tc('rooms').' <span>'.$countrooms.'</span>',
- 'url' => array('/quicksearch/main/mainsearch', 'apType' => '1', 'objType' => '5', 'region' => $idRegion),
- );
- $this->aData['saleCpanelItems'][] = array(
- 'label' => tc('lots').' <span>'.$countlots.'</span>',
- 'url' => array('/quicksearch/main/mainsearch', 'apType' => '1', 'objType' => '4', 'region' => $idRegion),
- );
- $this->aData['saleCpanelItems'][] = array(
- 'label' => tc('cottages').' <span>'.$countcottages.'</span>',
- 'url' => array('/quicksearch/main/mainsearch', 'apType' => '1', 'objType' => '11', 'region' => $idRegion),
- );
- $this->aData['saleCpanelItems'][] = array(
- 'label' => tc('private houses').' <span>'.$counthouses.'</span>',
- 'url' => array('/quicksearch/main/mainsearch', 'apType' => '1', 'objType' => '2', 'region' => $idRegion),
- );
- $this->aData['saleCpanelItems'][] = array(
- 'label' => tc('office').' <span>'.$countoffice.'</span>',
- 'url' => array('/quicksearch/main/mainsearch', 'apType' => '1', 'objType' => '3', 'region' => $idRegion),
- );
- $this->aData['saleCpanelItems'][] = array(
- 'label' => tc('warehouses').' <span>'.$countwrhouses.'</span>',
- 'url' => array('/quicksearch/main/mainsearch', 'apType' => '1', 'objType' => '8', 'region' => $idRegion),
- );
- $this->aData['saleCpanelItems'][] = array(
- 'label' => tc('bigroom').' <span>'.$countbigroom.'</span>',
- 'url' => array('/quicksearch/main/mainsearch', 'apType' => '1', 'objType' => '9', 'region' => $idRegion),
- );
- $this->aData['saleCpanelItems'][] = array(
- 'label' => tc('garages').' <span>'.$countgarages.'</span>',
- 'url' => array('/quicksearch/main/mainsearch', 'apType' => '1', 'objType' => '10', 'region' => $idRegion),
- );
- $this->aData['rentCpanelItems'] = Menu::getMenuItems(true, 1);
- $idRegion = Yii::app()->controller->geoUserCityId;
- $countAp = Apartment::model()->count('loc_region=:loc_region and type = 1 and obj_type_id = 1', array(':loc_region' => $idRegion));
- $countrooms = Apartment::model()->count('loc_region=:loc_region and type = 1 and obj_type_id = 5', array(':loc_region' => $idRegion));
- $countlots = Apartment::model()->count('loc_region=:loc_region and type = 1 and obj_type_id = 4', array(':loc_region' => $idRegion));
- $countcottages = Apartment::model()->count('loc_region=:loc_region and type = 1 and obj_type_id = 11', array(':loc_region' => $idRegion));
- $counthouses = Apartment::model()->count('loc_region=:loc_region and type = 1 and obj_type_id = 2', array(':loc_region' => $idRegion));
- $countoffice = Apartment::model()->count('loc_region=:loc_region and type = 1 and obj_type_id = 3', array(':loc_region' => $idRegion));
- $countwrhouses = Apartment::model()->count('loc_region=:loc_region and type = 1 and obj_type_id = 8', array(':loc_region' => $idRegion));
- $countbigroom = Apartment::model()->count('loc_region=:loc_region and type = 1 and obj_type_id = 9', array(':loc_region' => $idRegion));
- $countgarages = Apartment::model()->count('loc_region=:loc_region and type = 1 and obj_type_id = 10', array(':loc_region' => $idRegion));
- $this->aData['rentCpanelItems'][] = array(
- 'label' => tc('Apartments').' <span>'.$countAp.'</span>',
- 'url' => array('/quicksearch/main/mainsearch', 'apType' => '5', 'objType' => '1', 'region' => $idRegion),
- );
- $this->aData['rentCpanelItems'][] = array(
- 'label' => tc('rooms').' <span>'.$countrooms.'</span>',
- 'url' => array('/quicksearch/main/mainsearch', 'apType' => '5', 'objType' => '5', 'region' => $idRegion),
- );
- $this->aData['rentCpanelItems'][] = array(
- 'label' => tc('lots').' <span>'.$countlots.'</span>',
- 'url' => array('/quicksearch/main/mainsearch', 'apType' => '5', 'objType' => '4', 'region' => $idRegion),
- );
- $this->aData['rentCpanelItems'][] = array(
- 'label' => tc('cottages').' <span>'.$countcottages.'</span>',
- 'url' => array('/quicksearch/main/mainsearch', 'apType' => '5', 'objType' => '11', 'region' => $idRegion),
- );
- $this->aData['rentCpanelItems'][] = array(
- 'label' => tc('private houses').' <span>'.$counthouses.'</span>',
- 'url' => array('/quicksearch/main/mainsearch', 'apType' => '5', 'objType' => '2', 'region' => $idRegion),
- );
- $this->aData['rentCpanelItems'][] = array(
- 'label' => tc('office').' <span>'.$countoffice.'</span>',
- 'url' => array('/quicksearch/main/mainsearch', 'apType' => '5', 'objType' => '3', 'region' => $idRegion),
- );
- $this->aData['rentCpanelItems'][] = array(
- 'label' => tc('warehouses').' <span>'.$countwrhouses.'</span>',
- 'url' => array('/quicksearch/main/mainsearch', 'apType' => '5', 'objType' => '8', 'region' => $idRegion),
- );
- $this->aData['rentCpanelItems'][] = array(
- 'label' => tc('bigroom').' <span>'.$countbigroom.'</span>',
- 'url' => array('/quicksearch/main/mainsearch', 'apType' => '5', 'objType' => '9', 'region' => $idRegion),
- );
- $this->aData['rentCpanelItems'][] = array(
- 'label' => tc('garages').' <span>'.$countgarages.'</span>',
- 'url' => array('/quicksearch/main/mainsearch', 'apType' => '5', 'objType' => '10', 'region' => $idRegion),
- );
Advertisement
Add Comment
Please, Sign In to add comment