php - 如何在 Symfony2 上编写查询

Question

如何将其写入我的存储库中以便能够在我的 Controller 中使用它？

SELECT COUNT(id_pnc) 
FROM programmevol p
WHERE p.id_pnc IN (
    SELECT id_pnc 
    FROM programmevol A 
    WHERE p.id_pnc=A.id_pnc
    HAVING COUNT(*)>1
);

Answer 1

试试这个:

public function findWhateverYouWant()
{
    $em = $this->getEntityManager();

    $rsm = new ResultSetMappingBuilder($em);

    $sql = sprintf('SELECT COUNT(id_pnc) 
                    FROM programmevol p
                    WHERE p.id_pnc IN ( SELECT id_pnc 
                                        FROM programmevol A 
                                        WHERE p.id_pnc=A.id_pnc
                                        HAVING COUNT(*)>1
                                       )', 
                    $rsm->generateSelectClause()
                   );

    $query = $em->createNativeQuery($sql, $rsm);

    return $query->getResult();
}