Aleksanderdevelop

How to optimize php code yii

Mar 6th, 2016
236
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 6.77 KB | None | 0 0
  1. $this->aData['saleCpanelItems'] = Menu::getMenuItems(true, 1);
  2.  
  3.         $idRegion = Yii::app()->controller->geoUserCityId;
  4.         $countAp = Apartment::model()->count('loc_region=:loc_region and type = 2 and obj_type_id = 1', array(':loc_region' => $idRegion));
  5.         $countrooms = Apartment::model()->count('loc_region=:loc_region and type = 2 and obj_type_id = 5', array(':loc_region' => $idRegion));
  6.         $countlots = Apartment::model()->count('loc_region=:loc_region and type = 2 and obj_type_id = 4', array(':loc_region' => $idRegion));
  7.         $countcottages = Apartment::model()->count('loc_region=:loc_region and type = 2 and obj_type_id = 11', array(':loc_region' => $idRegion));
  8.         $counthouses = Apartment::model()->count('loc_region=:loc_region and type = 2 and obj_type_id = 2', array(':loc_region' => $idRegion));
  9.         $countoffice = Apartment::model()->count('loc_region=:loc_region and type = 2 and obj_type_id = 3', array(':loc_region' => $idRegion));
  10.         $countwrhouses = Apartment::model()->count('loc_region=:loc_region and type = 2 and obj_type_id = 8', array(':loc_region' => $idRegion));
  11.         $countbigroom = Apartment::model()->count('loc_region=:loc_region and type = 2 and obj_type_id = 9', array(':loc_region' => $idRegion));
  12.         $countgarages = Apartment::model()->count('loc_region=:loc_region and type = 2 and obj_type_id = 10', array(':loc_region' => $idRegion));
  13.        
  14.         $this->aData['saleCpanelItems'][] = array(
  15.                 'label' => tc('Apartments').' <span>'.$countAp.'</span>',
  16.                 'url' => array('/quicksearch/main/mainsearch', 'apType' => '1', 'objType' => '1', 'region' => $idRegion),              
  17.         );
  18.         $this->aData['saleCpanelItems'][] = array(
  19.                 'label' => tc('rooms').' <span>'.$countrooms.'</span>',
  20.                 'url' => array('/quicksearch/main/mainsearch', 'apType' => '1', 'objType' => '5', 'region' => $idRegion),              
  21.         );
  22.         $this->aData['saleCpanelItems'][] = array(
  23.                 'label' => tc('lots').' <span>'.$countlots.'</span>',
  24.                 'url' => array('/quicksearch/main/mainsearch', 'apType' => '1', 'objType' => '4', 'region' => $idRegion),              
  25.         );
  26.         $this->aData['saleCpanelItems'][] = array(
  27.                 'label' => tc('cottages').' <span>'.$countcottages.'</span>',
  28.                 'url' => array('/quicksearch/main/mainsearch', 'apType' => '1', 'objType' => '11', 'region' => $idRegion),             
  29.         );
  30.         $this->aData['saleCpanelItems'][] = array(
  31.                 'label' => tc('private houses').' <span>'.$counthouses.'</span>',
  32.                 'url' => array('/quicksearch/main/mainsearch', 'apType' => '1', 'objType' => '2', 'region' => $idRegion),              
  33.         );
  34.         $this->aData['saleCpanelItems'][] = array(
  35.                 'label' => tc('office').' <span>'.$countoffice.'</span>',
  36.                 'url' => array('/quicksearch/main/mainsearch', 'apType' => '1', 'objType' => '3', 'region' => $idRegion),              
  37.         );
  38.         $this->aData['saleCpanelItems'][] = array(
  39.                 'label' => tc('warehouses').' <span>'.$countwrhouses.'</span>',
  40.                 'url' => array('/quicksearch/main/mainsearch', 'apType' => '1', 'objType' => '8', 'region' => $idRegion),              
  41.         );
  42.         $this->aData['saleCpanelItems'][] = array(
  43.                 'label' => tc('bigroom').' <span>'.$countbigroom.'</span>',
  44.                 'url' => array('/quicksearch/main/mainsearch', 'apType' => '1', 'objType' => '9', 'region' => $idRegion),              
  45.         );     
  46.         $this->aData['saleCpanelItems'][] = array(
  47.                 'label' => tc('garages').' <span>'.$countgarages.'</span>',
  48.                 'url' => array('/quicksearch/main/mainsearch', 'apType' => '1', 'objType' => '10', 'region' => $idRegion),             
  49.         );
  50.        
  51.         $this->aData['rentCpanelItems'] = Menu::getMenuItems(true, 1);
  52.         $idRegion = Yii::app()->controller->geoUserCityId;
  53.         $countAp = Apartment::model()->count('loc_region=:loc_region and type = 1 and obj_type_id = 1', array(':loc_region' => $idRegion));
  54.         $countrooms = Apartment::model()->count('loc_region=:loc_region and type = 1 and obj_type_id = 5', array(':loc_region' => $idRegion));
  55.         $countlots = Apartment::model()->count('loc_region=:loc_region and type = 1 and obj_type_id = 4', array(':loc_region' => $idRegion));
  56.         $countcottages = Apartment::model()->count('loc_region=:loc_region and type = 1 and obj_type_id = 11', array(':loc_region' => $idRegion));
  57.         $counthouses = Apartment::model()->count('loc_region=:loc_region and type = 1 and obj_type_id = 2', array(':loc_region' => $idRegion));
  58.         $countoffice = Apartment::model()->count('loc_region=:loc_region and type = 1 and obj_type_id = 3', array(':loc_region' => $idRegion));
  59.         $countwrhouses = Apartment::model()->count('loc_region=:loc_region and type = 1 and obj_type_id = 8', array(':loc_region' => $idRegion));
  60.         $countbigroom = Apartment::model()->count('loc_region=:loc_region and type = 1 and obj_type_id = 9', array(':loc_region' => $idRegion));
  61.         $countgarages = Apartment::model()->count('loc_region=:loc_region and type = 1 and obj_type_id = 10', array(':loc_region' => $idRegion));
  62.        
  63.         $this->aData['rentCpanelItems'][] = array(
  64.                 'label' => tc('Apartments').' <span>'.$countAp.'</span>',
  65.                 'url' => array('/quicksearch/main/mainsearch', 'apType' => '5', 'objType' => '1', 'region' => $idRegion),              
  66.         );
  67.         $this->aData['rentCpanelItems'][] = array(
  68.                 'label' => tc('rooms').' <span>'.$countrooms.'</span>',
  69.                 'url' => array('/quicksearch/main/mainsearch', 'apType' => '5', 'objType' => '5', 'region' => $idRegion),              
  70.         );
  71.         $this->aData['rentCpanelItems'][] = array(
  72.                 'label' => tc('lots').' <span>'.$countlots.'</span>',
  73.                 'url' => array('/quicksearch/main/mainsearch', 'apType' => '5', 'objType' => '4', 'region' => $idRegion),              
  74.         );
  75.         $this->aData['rentCpanelItems'][] = array(
  76.                 'label' => tc('cottages').' <span>'.$countcottages.'</span>',
  77.                 'url' => array('/quicksearch/main/mainsearch', 'apType' => '5', 'objType' => '11', 'region' => $idRegion),             
  78.         );
  79.         $this->aData['rentCpanelItems'][] = array(
  80.                 'label' => tc('private houses').' <span>'.$counthouses.'</span>',
  81.                 'url' => array('/quicksearch/main/mainsearch', 'apType' => '5', 'objType' => '2', 'region' => $idRegion),              
  82.         );
  83.         $this->aData['rentCpanelItems'][] = array(
  84.                 'label' => tc('office').' <span>'.$countoffice.'</span>',
  85.                 'url' => array('/quicksearch/main/mainsearch', 'apType' => '5', 'objType' => '3', 'region' => $idRegion),              
  86.         );
  87.         $this->aData['rentCpanelItems'][] = array(
  88.                 'label' => tc('warehouses').' <span>'.$countwrhouses.'</span>',
  89.                 'url' => array('/quicksearch/main/mainsearch', 'apType' => '5', 'objType' => '8', 'region' => $idRegion),              
  90.         );
  91.         $this->aData['rentCpanelItems'][] = array(
  92.                 'label' => tc('bigroom').' <span>'.$countbigroom.'</span>',
  93.                 'url' => array('/quicksearch/main/mainsearch', 'apType' => '5', 'objType' => '9', 'region' => $idRegion),              
  94.         );     
  95.         $this->aData['rentCpanelItems'][] = array(
  96.                 'label' => tc('garages').' <span>'.$countgarages.'</span>',
  97.                 'url' => array('/quicksearch/main/mainsearch', 'apType' => '5', 'objType' => '10', 'region' => $idRegion),             
  98.         );
Advertisement
Add Comment
Please, Sign In to add comment