public function actionAutocomplete()
{
$this->layout = false;
$criteria = new CDbCriteria();
$criteria->addSearchCondition('t.property_name_or_address', ActiveRecord::safeField($_GET['term']), true);
$criteria->compare('t.status', STATUS_ACTIVE);
$criteria->compare('t.user_id', $this->userID);
// $criteria->limit = 20;
$models = Listing::model()->findAll($criteria);
$returnVal = array();
foreach ($models as $model) {
$returnVal[] = array('label' => $model->property_name_or_address, 'value' => $model->property_name_or_address, 'Listing_property_type_1' => $model->property_type_1, 'Listing_property_type_2' => $model->property_type_2, 'Listing_unit_from' => $model->unit_from, 'Listing_unit_to' => $model->unit_to, 'Listing_price' => Listing::getformatPrice($model->price), 'Listing_office_bkank_valuation' => Listing::getformatPrice($model->office_bkank_valuation), 'Listing_of_bedroom' => $model->of_bedroom, 'Listing_floor_area' => $model->floor_area, 'Listing_hdb_town_estate' => $model->floor_area, 'Listing_developer' => $model->developer, 'Listing_tenure' => $model->tenure, 'Listing_field' => $model->postal_code, 'Listing_postal_code' => $model->postal_code, 'Listing_postal_code_xy' => $model->postal_code_xy);
}
echo CJSON::encode($returnVal);
Yii::app()->end();
}
