/** * 首页 * */ public function actionIndex() { parent::_acl('house_index'); $model = new House(); $criteria = new CDbCriteria(); $condition = '1'; $city_id = $this->_gets->getParam('city_id'); $district_id = $this->_gets->getParam('district_id'); //$investType_id = $this->_gets->getParam( 'investType_id' ); $propertyType_id = $this->_gets->getParam('propertyType_id'); $h_name = trim($this->_gets->getParam('h_name')); $is_recommend = $this->_gets->getParam('is_recommend'); $city_id && ($condition .= ' AND city_id= ' . $city_id); $district_id && ($condition .= ' AND district_id= ' . $district_id); //$investType_id && $condition .= ' AND investType_id= ' . $investType_id; if ($propertyType_id == 1) { $propertyType_id && ($condition .= ' AND type_own1_out="Detached" '); } elseif ($propertyType_id == 2) { $propertyType_id && ($condition .= ' AND type_own1_out="Townhouse" or type_own1_out="Att∕Row∕Twnhouse" or type_own1_out="Triplex" or type_own1_out="Fourplex" or type_own1_out="Multiplex"'); } elseif ($propertyType_id == 3) { $propertyType_id && ($condition .= ' AND lp_dol>3000000'); } elseif ($propertyType_id == 4) { $propertyType_id && ($condition .= ' AND type_own1_out="Semi-Detached" or type_own1_out="Link" or type_own1_out="Duplex"'); } elseif ($propertyType_id == 5) { $propertyType_id && ($condition .= ' AND type_own1_out="Cottage" or type_own1_out="Rural Resid"'); } elseif ($propertyType_id == 6) { $propertyType_id && ($condition .= ' AND type_own1_out="Farm"'); } elseif ($propertyType_id == 7) { $propertyType_id && ($condition .= ' AND type_own1_out="Vacant Land"'); } elseif ($propertyType_id == 8) { $propertyType_id && ($condition .= ' AND type_own1_out="Mobile/Trailer" or type_own1_out="Det W/Com Elements" or type_own1_out="Store W/Apt/offc"'); } $h_name && ($condition .= ' AND addr LIKE \'%' . $h_name . '%\' or ml_num LIKE \'%' . $h_name . '%\''); $is_recommend && ($condition .= ' AND recommend= ' . $is_recommend); $criteria->condition = $condition; $criteria->order = 't.id DESC'; $count = $model->count($criteria); $pages = new CPagination($count); $pages->pageSize = 10; $pageParams = XUtils::buildCondition($_GET, array('city_id, district_id, type_own1_out, addr, recommend')); $pages->params = is_array($pageParams) ? $pageParams : array(); $criteria->limit = $pages->pageSize; $criteria->offset = $pages->currentPage * $pages->pageSize; $result = $model->findAll($criteria); $this->subject_list = parent::_groupList('subject'); $this->city_list = parent::_groupList('city'); $this->district_list = parent::_groupList('district'); $this->investType_list = parent::_groupList('investType'); $this->propertyType_list = parent::_groupList('propertyType'); $this->render('index', array('datalist' => $result, 'pagebar' => $pages)); }