我想创建一个 Doctrine 查询:(Doctrine 2.3)
SELECT * FROM `car` WHERE `plate` like '%' AND (`datetime` BETWEEN '2013-03-13 22:20:18' AND '2013-03-13 22:20:20') OR (`datetime` BETWEEN '2013-03-13 15:10:18' AND '2013-03-13 15:10:16')
我尝试了以下方法,但它不起作用:
$qry = $this->manager()->createQueryBuilder()
->from($this->entity, 'e')
->select('e');
$qry->where('e.plate like :plate');
$qry->setParameter('plate', $plate);
$qry->andWhere(
qry->expr()->between(
'e.datetime',
':dateFrom',
':dateTo'
)
)
->setParameter('dateFrom', $fromdate)
->setParameter('dateTo', $todate);
$qry->orWhere(
$qry->expr()->between(
'e.datetime',
':dateFrom',
':dateTo'
)
)
->setParameter('dateFrom1', $fromdate1)
->setParameter('dateTo1', $todate1);
上述查询的输出:
SELECT e FROM user e WHERE (e.plate like :plate AND (e.datetime BETWEEN :dateFrom AND :dateTo)) OR (e.datetime BETWEEN :dateFrom AND :dateTo)
我想检查同一列中的两个日期,如何检查?语法正确吗?
目前是这样的:
(Plate AND (Date)) OR Date)
Case 1
但为了获得良好的输出,它应该如下所示。
(Plate) AND ((Date) OR (Date))
Case 2
在其他情况下,它应该是这样的:
((Plate) or (Plate)) AND ((Date) OR (Date))
有人可以帮助我吗?我不是教义专家,我是一名学习者!