mongo模糊查询

最新推荐文章于 2024-12-03 18:12:42 发布

翻译最新推荐文章于 2024-12-03 18:12:42 发布 · 1.3k 阅读

symfony学习专栏收录该内容

36 篇文章

订阅专栏

$params = array();
if (!empty($distributorId)) {
    $params['distributor.id'] = $distributorId;
}
if (!empty($serverId)) {
    $params['server.id'] = $serverId;
}
$params['type'] = $type;
$qb = $this->documentManager->createQueryBuilder('AppBundle:Customer');
foreach ($params as $k => $v) {
    $qb->field($k)->equals($v);
}
$qb->field('status')->notEqual(Customer::STATUS_DELETED);
if ($pageSize != 0) {
    $qb->limit($pageSize);
    if ($page != 0) {
        $qb->skip($pageSize * ($page-1));
    }
}
if (isset($keywords)) {
    $keywords = StringUtil::escapeString($keywords);
    $qb->addOr($qb->expr()->field('name')->equals(new \MongoRegex('/.*'.$keywords.'.*/i')));
    $qb->addOr($qb->expr()->field('mobile')->equals(new \MongoRegex('/.*'.$keywords.'.*/i')));
}
$qb->sort('create_time','DESC');
$customerList = $qb->getQuery()->execute();