连接实体结果的问题:Doctrine/ORM/UnitOfWork.php中的未定义索引:id

几周前我遇到了一个类似的问题，我可以这样解决:

    $em = $this->getEntityManager();
    $rsm = new 'Doctrine'ORM'Query'ResultSetMapping();
    $rsm->addEntityResult('MyBundle:Actor', 'a');
    $rsm->addFieldResult('a', 'id', 'id');
    $rsm->addFieldResult('a', 'name', 'name');
    $rsm->addFieldResult('a', 'surname', 'surname');
    $rsm->addMetaResult('a', 'presentation_id', 'presentation_id');
    $query = $em->createNativeQuery(
            'SELECT a.id, a.name, a.surname, a.presentation_id
             FROM actors AS a 
             INNER JOIN presentations AS p 
             WHERE p.id = a.presentation_id 
             AND p.finished = 0
             AND p.id IN (?)', $rsm);
    $query->setParameter(1, $presentations);
    $actors = $query->getResult();

与您的代码有一些差异，但也许您可以调整它以获得您想要的。

注意addMetaResult()函数，它用于外键或鉴别符列。您可以在官方Doctrine文档http://doctrine-orm.readthedocs.org/en/latest/reference/native-sql.html的17.3.5章中阅读到这一点。在这个函数中，我将presentation_id作为参数传递，这是演员表中Presentation的外键字段。注意，我没有请求表示的信息，但是，Doctrine对对象进行了润色，我可以通过以下方式从结果的Actor实体访问表示的所有信息:

    foreach($actors as $a){
        //
        // Some code here
        //
        $actorId        = $a->getId();
        $actorName      = $a->getName();
        $actorSurname   = $a->getSurname();
        $preTitle       = $a->getPresentation()->getTitle();
        $preDesc        = $a->getPresentation()->getDescription();
        $preDirector    = $a->getPresentation()->getDirector()->getFullName();
        //
        // Some code here
        //   
    }

    $rsm = new ResultSetMapping();
    $rsm->addEntityResult('App'MainBundle'Entity'InstagramShopPicture', 'p');
    $rsm->addFieldResult('p', 'id', 'id');
    $rsm->addFieldResult('p','lowresimageurl','lowresimageurl');
    $rsm->addFieldResult('p','medresimageurl','medresimageurl');
    $rsm->addFieldResult('p','highresimageurl','highresimageurl');
    $rsm->addFieldResult('p','caption','caption');
    $rsm->addFieldResult('p','numberoflikes','numberoflikes');
    $rsm->addFieldResult('p','numberofdislikes','numberofdislikes');
    $rsm->addMetaResult('p', 'shop_id', 'shop_id');
    $query = $em->createNativeQuery('SELECT picture.id, picture.lowresimageurl, picture.medresimageurl, picture.highresimageurl, picture.caption, picture.numberoflikes, picture.numberofdislikes
            FROM App_instagram_picture_category AS category
            INNER JOIN App_instagram_shop_picture AS p ON category.picture_id = p.id
            INNER JOIN App_instagram_shop AS shop ON shop.id = p.shop_id
            WHERE category.first_level_category_id = ?
            AND p.deletedAt IS NULL
            AND shop.deletedAt IS NULL
            AND shop.isLocked = 0
            AND shop.expirydate IS NOT NULL 
            AND shop.expirydate >  ?
            AND shop.owner_id IS NOT NULL 
            GROUP BY shop.id
            LIMIT ?'
            , $rsm);
    $query->setParameter(1, 10);
    $query->setParameter(2, '2014-05-20');
    $query->setParameter(3, 10);
    $itemsFromDifferentShops = $query->getResult();

这样，你就可以得到图片，通过这些，你可以得到你需要的商店的信息。

问题在于

$rsm->addFieldResult('s', 'id', 'id');

根据定义

/**
 * Adds a field result that is part of an entity result or joined entity result.
 *
 * @param string $alias The alias of the entity result or joined entity result.
 * @param string $columnName The name of the column in the SQL result set.
 * @param string $fieldName The name of the field on the (joined) entity.
 */
public function addFieldResult($alias, $columnName, $fieldName)

第二个参数必须是SQL result set NOT table

shop.id AS shop_id

使用$rsm->addFieldResult('s', 'shop_id', 'id');