mysql - 如何在 findOneBy 中使用 'compare' 句子？

Question

$em = $this->getDoctrine()->getEntityManager();
$repository = $em->getRepository('UserBundle:items');
$items = $repository->findOneBy(
    array('isCancel' => false,
          'user' => $username,
          array('toDate' => 'ASC'));

我想添加比较功能

  where registeredtime > now()

我可以使用 findOneBy 来比较句子吗？

或者我必须写整个sql？

Answer 1

您可以按如下方式执行此操作

$em = $this->getDoctrine()->getEntityManager();
$repository = $em->getRepository('UserBundle:items');
$items = $repository->findOneBy(
    array('isCancel' => false,
    'user' => $username,
    array('toDate' => 'ASC'));
$criteria = Criteria::create()->where(Criteria::expr()->gt("registeredtime", now()));
$filteredItems = $items->matching($criteria);