$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();
mongo模糊查询
最新推荐文章于 2024-12-03 18:12:42 发布