doudou3935 2014-08-06 15:20
浏览 62
已采纳

Doctrine 2 - 如何将SQL ORDER连接表连接到另一个表

I want to retrieve from database news and comments tables. This tables are related correctly. The problem is that I also want to ORDER comments table. Everything works include ordering(with ASC and DESC).

PHP CODE

$query = $doctrine->getManager()
->createQuery(
      'SELECT news FROM BlogAdminBundle:News news
       JOIN news.comments comments
       WHERE news.id = :id
       AND news.date_active < :date ORDER BY comments.dateAdd DESC'
)->setParameters(array('date' => new \DateTime(), 'id' => $news_id));

$fetched_news = $query->getSingleResult();
return array('fetched_news' => $fetched_news); 

TWIG CODE

{% for comment in fetched_news.comments %}
//displaying data
{% endfor %}

I know that I can retrieve separately news table and comments table, but idea to include this in one request is better idea.

Anyone want to help ?:)

  • 写回答

1条回答 默认 最新

  • dougaxing8673 2014-08-06 20:45
    关注

    This may work, assuming...

    News entity looks something like this:

    /**
     * News
     *
     * @ORM\Table(name="News")
     * @ORM\Entity()
     */
    class News {
    ...
        /**
         * @ORM\OneToMany(targetEntity="comment", mappedBy="news", cascade={"persist", "remove"})
         * @ORM\OrderBy({"dateAdd" = "DESC"})
         */
        protected $comments;
    ...
    }
    

    Controller includes $news = $em->getRepository("YourBundle:News")->find($id);

    And template includes (assumes column named item in News entity and column named comment in Comment entity):

    {% for event in news %}
        {{ event.item }}
        {% for piece in event.comments %}
            {{ piece.comment }}
        {% endfor %}
    {% endfor %}
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥200 如何使用postGis实现最短领规划?
  • ¥15 pyinstaller打包错误
  • ¥20 cesm的气溶胶排放文件
  • ¥15 逐月累计,月份不连续,补齐月份
  • ¥15 应用简单的Python代码完成一个学生成绩管理系统
  • ¥15 用matlab求微分方程初值问题
  • ¥15 vscode下编写第三方库opencv与pcl代码时没有代码提示
  • ¥15 能够跑通不报错,如何解决?(标签-matlab)
  • ¥15 MOS在RDS较大,频率高时开关波形异常
  • ¥15 SCENIC分析报错求解答