/** * Key-value pairs of all categories * @return array [category_id => category_name] */ public static function all() { static $result; if (!is_null($result)) { return $result; } $command = Yii::app()->db; /* @var CDbConnection $command */ $rows = $command->createCommand()->select('id, name')->from(CvCategories::model()->tableName())->queryAll(); $result = []; foreach ($rows as $row) { $result[$row['id']] = $row['name']; } asort($result); return $result; }
?> <?php echo $form->textAreaControlGroup($model, 'recruiter_comments', array('rows' => 2, 'span' => 8)); ?> <table class="table"> <tr> <td> <?php echo $form->labelEx($model, 'categoryIds'); ?> <input type="text" name="categoryFilter" class="filter" size="10" /> <div class="div-overflow"> <?php echo $form->checkBoxList($model, 'categoryIds', CHtml::listData(CvCategories::model()->findAll(array('order' => 'name')), 'id', 'name')); ?> </div> </td> <td> <?php echo $form->labelEx($model, 'positionsIds'); ?> <input type="text" name="positionsFilter" class="filter" size="10" /> <div class="div-overflow"> <?php echo $form->checkBoxList($model, 'positionsIds', CHtml::listData(CvPositions::model()->findAll(array('order' => 'name')), 'id', 'name')); ?> </div> </td> </tr>
echo CHtml::checkBoxList('residencies', $residenciesFilter, CHtml::listData(CitiesList::model()->findAll(array('order' => getOrder($residenciesFilter, 'city_index') . 'city_name ASC')), 'city_index', 'city_name'), array('template' => '{beginLabel}{input} {labelTitle}{endLabel}', 'separator' => '')); ?> </div> </td> <td class="<?php echo getClassName($categoriesFilter); ?> "> <strong><?php echo CHtml::encode(CvList::model()->getAttributeLabel('categoryIds')); ?> </strong><br /> <input type="text" name="categoryFilter" class="filter" size="10" /> <div class="div-overflow narrow"> <?php echo CHtml::checkBoxList('categories', $categoriesFilter, CHtml::listData(CvCategories::model()->findAll(array('order' => getOrder($categoriesFilter) . 'name ASC')), 'id', 'name'), array('template' => '{beginLabel}{input} {labelTitle}{endLabel}', 'separator' => '')); ?> </div> </td> <td class="<?php echo getClassName($positionsFilter); ?> "> <strong><?php echo CHtml::encode(CvList::model()->getAttributeLabel('positionsIds')); ?> </strong><br /> <input type="text" name="positionsFilter" class="filter" size="10" /> <div class="div-overflow narrow"> <?php echo CHtml::checkBoxList('positions', $positionsFilter, CHtml::listData(CvPositions::model()->findAll(array('order' => getOrder($positionsFilter) . 'name ASC')), 'id', 'name'), array('template' => '{beginLabel}{input} {labelTitle}{endLabel}', 'separator' => ''));