doctrine-orm - Doctrine DBAL 查询构建器省略了一些连接

Question

PHP 代码:

    $xCodesQueryBuilder = $conn->createQueryBuilder();

    $xCodesQueryBuilder->select("l.id","mdsh.xcode","mdso.xcode")
            ->from("location_tree","l")
            ->join("l","location_tree_pos","p","l.id = p.tree_id")
            ->rightJoin("l","hotel","h","h.location_id = l.id")
            ->leftJoin("l","offer_location","ol","l.id=ol.location_id")
            ->leftJoin("ol","mds_offer","mdso","ol.offer_id = mdso.offer_id")
            ->leftJoin("h","mds_hotel","mdsh","h.id = mdsh.hotel_id")
            ->where("p.parent_id IN (:ids)")
            ->andWhere("(mdso.xcode IS NOT NULL OR mdsh.xcode IS NOT NULL)");

    var_dump($xCodesQueryBuilder->getSQL());exit;

结果:

SELECT l.id, mdsh.xcode, mdso.xcode
FROM location_tree l 
INNER JOIN location_tree_pos p ON l.id = p.tree_id 
RIGHT JOIN hotel h ON h.location_id = l.id 
LEFT JOIN offer_location ol ON l.id=ol.location_id 
WHERE (p.parent_id IN (:ids)) 
AND ((mdso.xcode IS NOT NULL OR mdsh.xcode IS NOT NULL))

为什么省略了最后两个连接的任何想法？

Answer 1

我刚刚得到了这个为我工作。不得不修改函数getSQLForSelect()在 QueryBuilder.php .

我开了一个 ticket并向 DBAL 提交了拉取请求，但同时，请随意使用 my patched copy .

更新:

刚刚意识到解决此问题的另一种方法是始终使用 FROM表别名作为第一个参数( $fromAlias )在任何 join() 中方法。

在您的情况下，您可以将代码更改为如下所示:

$xCodesQueryBuilder = $conn->createQueryBuilder();

$xCodesQueryBuilder->select("l.id","mdsh.xcode","mdso.xcode")
        ->from("location_tree","l")
        ->join("l","location_tree_pos","p","l.id = p.tree_id")
        ->rightJoin("l","hotel","h","h.location_id = l.id")
        ->leftJoin("l","offer_location","ol","l.id=ol.location_id")
        ->leftJoin("l","mds_offer","mdso","ol.offer_id = mdso.offer_id")
        ->leftJoin("l","mds_hotel","mdsh","h.id = mdsh.hotel_id")
        ->where("p.parent_id IN (:ids)")
        ->andWhere("(mdso.xcode IS NOT NULL OR mdsh.xcode IS NOT NULL)");

var_dump($xCodesQueryBuilder->getSQL());exit;