public function actionSearch() { if (Yii::app()->request->isAjaxRequest) { $criteria = new CDbCriteria(); if (isset($_GET['term']) && strlen($term = $_GET['term']) > 0) { $criteria->addCondition(array('LOWER(name) LIKE :term'), 'OR'); $params[':term'] = '%' . strtolower(strtr($term, array('%' => '\\%'))) . '%'; } $criteria->order = 'name'; $criteria->select = 'id, name'; $criteria->params = $params; $results = OphTrConsent_Leaflet::model()->active()->findAll($criteria); $return = array(); foreach ($results as $resultRow) { $return[] = array('label' => $resultRow->name, 'value' => $resultRow->name, 'id' => $resultRow->id); } echo CJSON::encode($return); } }
<?php /** * OpenEyes. * * (C) Moorfields Eye Hospital NHS Foundation Trust, 2008-2011 * (C) OpenEyes Foundation, 2011-2013 * This file is part of OpenEyes. * OpenEyes is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. * OpenEyes is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. * You should have received a copy of the GNU General Public License along with OpenEyes in a file titled COPYING. If not, see <http://www.gnu.org/licenses/>. * * @link http://www.openeyes.org.uk * * @author OpenEyes <*****@*****.**> * @copyright Copyright (c) 2008-2011, Moorfields Eye Hospital NHS Foundation Trust * @copyright Copyright (c) 2011-2013, OpenEyes Foundation * @license http://www.gnu.org/licenses/gpl-3.0.html The GNU General Public License V3.0 */ ?> <div class="element-fields"> <?php echo $form->multiSelectList($element, 'OphTrConsent_Leaflet', 'leaflets', 'leaflet_id', CHtml::listData(OphTrConsent_Leaflet::model()->findAllByCurrentFirm($element->leafletValues), 'id', 'name'), array(), array('empty' => '- Leaflets -', 'label' => 'Leaflets provided'), false, false, null, false, false, array('field' => 4)); ?> </div>