Cakephp 3:如何在queryBuilder中为关联数据添加顺序？

Question

这里我有一个事件字段，其中包含密码，我需要通过download_count DESC对所有密码进行排序。所以我尝试了下面的代码。它没有给我任何错误，但是desc不起作用。

 $event = $this->Events->get($id, [
                  'contain' => [
                      'EventPasswordAll.Passwords' => [
                          'queryBuilder' => function (Query $q) {
                              return $q->order(['download_count' => 'DESC']);
                          }
                      ]
                  ]
             ]);

我也试过

 return $q->order(['Passwords.download_count' => 'DESC']);

我得到了查询

SELECT EventPasswordAll.id AS `EventPasswordAll__id`, EventPasswordAll.event_id AS `EventPasswordAll__event_id`, EventPasswordAll.password_id AS `EventPasswordAll__password_id`, Passwords.id AS `Passwords__id`, Passwords.name AS `Passwords__name`, Passwords.collection_id AS `Passwords__collection_id`, Passwords.photo_count AS `Passwords__photo_count`, Passwords.download_count AS `Passwords__download_count`, Passwords.created AS `Passwords__created`, Passwords.expires_at AS `Passwords__expires_at`, Passwords.recommended AS `Passwords__recommended`, Passwords.accepted AS `Passwords__accepted`, Passwords.user_id AS `Passwords__user_id` FROM event_password_all EventPasswordAll INNER JOIN passwords Passwords ON Passwords.id = (EventPasswordAll.password_id) WHERE EventPasswordAll.event_id in (14)

如何在queryBuilder中添加关联数据的顺序？

Answer 1

使用EventPasswordAll belongsTo Passwords的关联，将通过连接检索passwords表记录，如查询中所示。在本例中，不存在对Passwords的查询，因此没有调用查询生成器。

您必须为EventPasswordAll查询生成器设置顺序，如下所示

$event = $this->Events->get($id, [
    'contain' => [
        'EventPasswordAll' => [
            'queryBuilder' => function (Query $q) {
                return $q->order(['Passwords.download_count' => 'DESC']);
            },
            'Passwords'
        ]
    ]
]);