Yii 查询 搜索

一、视图

<div class="form-horizontal">

    <?php $form = $this->beginWidget('CActiveForm', array('id' => 'course', 'action' => '/admin/mp/')); ?>

    <div class="form-group">

        <div class="col-md-2">

            <?php echo $form->textField($model, 'title', array('class' => 'form-control', 'placeholder' => '标题')); ?>

        </div>

        <div class="col-md-2">

            <?php echo $form->textField($model, 'name', array('class' => 'form-control', 'placeholder' => '名字')); ?>

        </div>

        <div class="col-md-2">

            <?php echo $form->dropDownList($model, 'type', array('' => '类别') + $model->getTypeList(), array('class' => 'form-control', 'placeholder' => '类别')); ?>

        </div>

        <div class="col-md-1">

            <?php echo CHtml::submitButton('查询', array('class' => 'btn btn-default btn-primary')); ?>

        </div>

        <div class="col-md-1">

            <a href="/admin/user/edit" class="btn btn-default">添加矩阵</a>

        </div>

    </div>

    <?php $this->endWidget(); ?>

</div>

二、模型

class Mp extends CActiveRecord

{

    const AFFAIRS  = 1;

    const BUSINESS = 2;

    public function tableName()

    {

        return 'mp';

    }

    public static function model($className = __CLASS__)

    {

        return parent::model($className);

    }

    public function getTypeList()

    {

        return array(

            self::AFFAIRS => '政务',

            self::BUSINESS => '商业',

        );

    }

    public function getTypeName()

    {

        $arr = $this->getTypeList();

        if (isset($arr[$this->type])) {

            return $arr[$this->type];

        }

        return '未知';

    }

    public function rules()

    {

        return array(

            array('title,name,type', 'safe', 'on' => 'search'),

        );

    }

}

三、控制器

 public function actionIndex()

    {

        $model = new Mp('search');

        if (isset($_POST['Mp'])) {

            $model->setAttributes($_POST['Mp']);

        }

        $criteria = new CDbCriteria();

        $criteria->addSearchCondition('title', $model->title);

        $criteria->addSearchCondition('name', $model->name);

        $criteria->addSearchCondition('type', $model->type);

        $count = Mp::model()->count($criteria);

        $pager = new CPagination($count);

        $pager->pageSize = $this->pageSize;

        $pager->applyLimit($criteria);

        $list = Mp::model()->findAll($criteria);

        $this->render('index',array('model'=>$model,'list'=>$list,'pager'=>$pager));

    }