The followings are the available columns in table:
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>
