duanhui4160 2016-05-12 09:32
浏览 276
已采纳

Yii到Yii2中的Search()函数

I'm new to the Yii framework and now I need to create a search function in Yii2. I already have found a search function in Yii which looks exactly like the funciton I need.


Here is the code:

public function searchDocuments($documentModel, $query, $content=false, $content_only=false) {

    $criteria = new CDbCriteria();
    $criteria->with = array(
        'tags' // Tabel tbl_tag toevoegen via de relations.
    );
    $criteria->compare('content', $query, true, "OR");
    $criteria->compare('description', $query, true, "OR");
    $criteria->compare('year', $query, true, "OR");
    $criteria->compare('title', $query, true, "OR");
    $criteria->compare('tags.slug', $query, true, "OR");
    $criteria->compare('title', $documentModel->title, true, "AND");
    $criteria->compare('description', $documentModel->description, true, "AND");
    $criteria->compare('tags.slug', $documentModel->tag_search, true, "AND");
    $criteria->compare('year', $documentModel->year, true, "AND");
    $criteria->compare('tags.state', 1 , false, "AND");
    $criteria->group = 't.id';

    $criteria->together = true;

    return new CActiveDataProvider( $documentModel, array(
            'pagination'=>array('pageSize'=>25),
            'criteria'  => $criteria,
            'sort'=>array(
                'attributes'=>array(
                    'tag_search'=>array(
                        'asc'=>'tags.slug',
                        'desc'=>'tags.slug DESC',
                    ),
                    '*',
                ),
            ),
        ) 
    );

} 
  • 写回答

2条回答 默认 最新

  • dragon0118 2016-05-12 10:15
    关注

    Use Yii2 Gii to generate CRUD for your Model. Its generates ModelSearch model and its code contains good example of search code.

    upd. Use model relations and $query->joinWith() method and filter by related table.

    // model
    
    public function getTags()
    {
        return $this->hasMany(Tags::className(), ['id' => 'document_id']);
    }
    
    // search model 
    
    public function search($params) 
    {
        ...
        $query->joinWith(['tags' => function ($q) {
            $q->where('tags.slug LIKE "%' . $this->tag . '%"');
        }]);
        ...
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 我下载图形界面重启完就变成这样了,打字也打不了,动也动不了,该怎么解决(操作系统-centos)
  • ¥15 VBA中在窗体中遍历所有checkbox控件,提取出被选中的checkbox的caption值
  • ¥15 在Ubuntu上有什么命令,或者是系统文件能告诉我链接nvme ssd的pcie槽位是不是支持热插拔功能?
  • ¥15 ansys license许可证问题
  • ¥20 QQ号和密码都能正常登录微信 QQ号和密码登录微信显示密码错误
  • ¥15 qiankun主应用注册子应用提示跨域
  • ¥15 单片机RTOS Kernel与应用分离开发,Kernel如何调起应用?
  • ¥15 快手小店商家版APP怎么第三方APP跳转到指定用户聊天界面
  • ¥15 为什么AVL fire软件仿真时的步长改变了,仿真结果也会改变
  • ¥100 如何帮我写一个java小游戏