php - 如何在两个字符串值之间绑定(bind)日期时间字段

Question

我有这样的方法:

public function getCustomDateOrders(string $startDay,string $endDay,string $food) :array
{
    $result = $this->_em->createQueryBuilder()
        ->select
        (
            'OrderEntity.name'
            'OrderEntity.created'
        )
        ->from($this->entityClass , 'OrderEntity')
        ->leftJoin(
            'Directory\Food',
            'Food',
            'with',
            'Food.id = OrderEntity.FoodId '
        )
        ->where("Food.id =:food")
        ->andWhere("OrderEntity.status =:active")
        ->andWhere("startDate<:OrderEntity.orderCreated >:endDay")
        ->getQuery()
        ->setParameters([
            "food"    =>       $food,
            "active"        =>  1,
            "startDate"     =>  $startDay,
            "endDay"        =>  $endDay
        ])
        ->getScalerResult();

        ->getScalarResult();

}

我有几个值:

$startDay 等于 "2016-010-17 00:00:00" (字符串)

$endDay 等于 "2016-10-03 00:00:00" (字符串)

order.created(order 的字段之一)也是datetime。

我想从订单实体中获取订单，该订单实体创建的字段在 $startDay 和 $endDay 之间。如何解决？

Answer 1

在之间使用:

public function getCustomDateOrders(string $startDay,string $endDay,string $food) :array
{
    $result = $this->_em->createQueryBuilder()
        ->select
        (
            'OrderEntity.name'
            'OrderEntity.created'
        )
        ->from($this->entityClass , 'OrderEntity')
        ->leftJoin(
            'Directory\Food',
            'Food',
            'with',
            'Food.id = OrderEntity.FoodId '
        )
        ->where("Food.id =:food")
        ->andWhere("OrderEntity.status =:active")
        ->andWhere("OrderEntity.orderCreated between :startDay and :endDay")
        ->setParameters([
            "food"    =>       $food,
            "active"        =>  1,
            "startDay"     =>  $startDay,
            "endDay"        =>  $endDay
        ])
       ->getQuery()
       ->getScalerResult();
}