Symfony 5 Doctrine ORM :从现在开始获取最近的日期

use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity
 */
class Date
{
    /**
     * @ORM\Id
     * @ORM\GeneratedValue
     * @ORM\Column(type="integer")
     */
    private $id;

    /**
     * @ORM\Column(type="date")
     */
    private $date;

    // Getter and setter methods
}

use Doctrine\ORM\EntityManagerInterface;

class YourController
{
    private $entityManager;

    public function __construct(EntityManagerInterface $entityManager)
    {
        $this->entityManager = $entityManager;
    }

    public function getNearestDate()
    {
        $queryBuilder = $this->entityManager->createQueryBuilder();
        $queryBuilder->select('d')
            ->from(Date::class, 'd')
            ->orderBy('d.date', 'ASC')
            ->setMaxResults(1);

        $result = $queryBuilder->getQuery()->getOneOrNullResult();

        if ($result) {
            return $result->getDate();
        }

        return null;
    }
}

use Symfony\Component\HttpFoundation\Response;

class YourController
{
    // ...

    public function yourAction()
    {
        $nearestDate = $this->getNearestDate();

        // 处理最近的日期

        return new Response('Nearest date: ' . $nearestDate->format('Y-m-d'));
    }
}