duande1985 2017-09-18 12:55
浏览 40
已采纳

在Symfony中进行多重过滤

I added a filter to my project that works with symfony.

I have the ID (numbers to be searched) and the client name. When I constructed my query with one parameter, it works, just like that

public function findFilter($filter)
    {
        return $this->createQueryBuilder("a")
            ->andWhere('a.id like :id')
            ->setParameter('id', '%' . $filter . '%')
            ->getQuery()
            ;
    }

and when I add one more parameter, the search doesn't happen.

public function findFilter($filter)
    {
        return $this->createQueryBuilder("a")
            ->andWhere('a.id like :id')
            ->setParameter('id', '%' . $filter . '%')
            ->andWhere('a.client like :client')
            ->setParameter('client', '%' . $filter . '%')
            ->getQuery()
            ;
    }

and here is my view where the filter can be entered

<form action="" method="get">
        <input name="filter" type="text">
        <button type="submit" class="btn btn-default">Filtrer</button>
 </form>

So maybe I'm not sticking them right? Anyone got an idea on how to add more parameters for the filter bar?

  • 写回答

3条回答 默认 最新

  • dsbifvcxr458755493 2017-09-18 13:12
    关注

    If you want to filter on multiple columns with an unique value, you've to use an array of OR filters.

    use Doctrine\ORM\Query\Expr;
    
    [...]
    
    $orX = new Expr\Orx(); 
    $orX->add($qb->expr()->orx($qb->expr()->like('a.id', ':filter'));
    $orX->add($qb->expr()->orx($qb->expr()->like('a.client', ':filter'));
    
    $qb
        ->andWhere($orx)
        ->setParameter('filter', '%'.$filter.'%')
    ;
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 在获取boss直聘的聊天的时候只能获取到前40条聊天数据
  • ¥20 关于URL获取的参数,无法执行二选一查询
  • ¥15 液位控制,当液位超过高限时常开触点59闭合,直到液位低于低限时,断开
  • ¥15 marlin编译错误,如何解决?
  • ¥15 有偿四位数,节约算法和扫描算法
  • ¥15 VUE项目怎么运行,系统打不开
  • ¥50 pointpillars等目标检测算法怎么融合注意力机制
  • ¥20 Vs code Mac系统 PHP Debug调试环境配置
  • ¥60 大一项目课,微信小程序
  • ¥15 求视频摘要youtube和ovp数据集