/** * @Author: ANH DUNG Dec 02, 2014 * @Todo: get array listing id by property name * @Param: $property_name_or_address */ public static function GetArrListingIdByPropertyName($property_name_or_address) { $criteria = new CDbCriteria(); Listing::GetConditionSearchListing($criteria, $property_name_or_address); $models = Listing::model()->findAll($criteria); return CHtml::listData($models, "id", "id"); }
* @Author: ANH DUNG Apr 24, 2014 * @Todo: search autocomplete landlord and tenant at FE create new transaction */ public function actionSearchLandlordTenant() { if (!isset($_GET['term']) || !Yii::app()->request->isAjaxRequest) { throw new CHttpException(404, "Invalid request"); } $role = ROLE_LANDLORD; $aCheck = array(ROLE_LANDLORD, ROLE_TENANT); if (isset($_GET['role']) && in_array($_GET['role'], $aCheck)) { $role = $_GET['role']; } $criteria = new CDbCriteria(); $criteria->compare(" t.role_id", $role); $criteria->addSearchCondition('CONCAT(t.first_name, " " ,t.last_name, " " ,t.nric_passportno_roc)', $_GET['term'], true); // true ==> LIKE '%...%' $criteria->limit = 30; $models = Users::model()->findAll($criteria); $returnVal = array(); $cmsFormat = new CmsFormatter(); foreach ($models as $model) { $label = $cmsFormat->formatFullNameRegisteredUsers($model); $returnVal[] = array('label' => $label, 'value' => $label, 'id' => $model->id, 'row_class_id' => "row_class_id{$model->id}", 'full_name' => $label, 'email' => $model->email_not_login, 'nric_passportno_roc' => $model->nric_passportno_roc, 'contact_no' => $model->contact_no, 'address' => $model->address, 'postal_code' => $model->postal_code, 'id_type' => $model->id_type, 'pass_expiry_date' => $cmsFormat->formatDatePickerInput($model->pass_expiry_date), 'upload_employment_pass_passport' => $model->upload_employment_pass_passport, 'scanned_passport' => $model->scanned_passport, 'postal_code' => $model->postal_code); } echo CJSON::encode($returnVal); Yii::app()->end(); } /** * @Author: ANH DUNG Apr 24, 2014 * @Todo: search autocomplete landlord and tenant at FE create new transaction