CakePHP，可容纳，分组依据

发布于 2024-11-24 03:57:37 字数 7641 浏览 3 评论 0 原文

我有一个场景，我尝试在与我的主模型关联的模型上使用可包含的分组。

这是我的输出：

我想按 SubFirmDetail 进行分组，并且仅根据 subFirmDetailType 显示最新的 SubFirmDetail。这是我当前在控制器中使用的代码：

function view($id = null) {
                $this->Subfirm->recursive = -1;
                $data = $this->Subfirm->find('first', array(
                    'contain' => array(
                        'Subfirmdetail' => array(
                            'Subfirmdetailtype' => array(
                                'Datatype',
                            ),
                        ),
                        'Firm' => array(
                            'Firmtype',
                        ),
                    ),
                    'conditions' => array('Subfirm.id' => $id),
                ));
        $this->set('subfirm', $data);
        if (!$id) {
            $this->Session->setFlash(__('Invalid subfirm', true));
            $this->redirect(array('action' => 'index'));
        }
    }

原文

I've got a scenario where I am trying to use group by on a model associated with my main model using containable.

Here is my output:

I'd like to group by SubFirmDetail and only show the newest SubFirmDetail depending on subFirmDetailType. Here is the code I'm currently using in my controller:

function view($id = null) {
                $this->Subfirm->recursive = -1;
                $data = $this->Subfirm->find('first', array(
                    'contain' => array(
                        'Subfirmdetail' => array(
                            'Subfirmdetailtype' => array(
                                'Datatype',
                            ),
                        ),
                        'Firm' => array(
                            'Firmtype',
                        ),
                    ),
                    'conditions' => array('Subfirm.id' => $id),
                ));
        $this->set('subfirm', $data);
        if (!$id) {
            $this->Session->setFlash(__('Invalid subfirm', true));
            $this->redirect(array('action' => 'index'));
        }
    }

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

输什么也不输骨气 2024-12-01 03:57:37

我最终不得不在数据库中创建一个视图并输出一个数组，该数组包含在我的条件子句中......对于那些尝试相同的人。

回复收藏 0 原文

谁的新欢旧爱 2024-12-01 03:57:37

试试这个：

function view($id = null) {
                $this->Subfirm->recursive = -1;
                $data = $this->Subfirm->find('first', array(
                    'contain' => array(
                        'Subfirmdetail' => array(
                            'Subfirmdetailtype' => array(
                                'Datatype',
                            ),
                        ),
                        'Firm' => array(
                            'Firmtype',
                        ),
                    ),
                    'conditions' => array('Subfirm.id' => $id),
                    'group' => 'Subfirmdetail',
                    'order' => 'date',
                ));
        $this->set('subfirm', $data);
        if (!$id) {
            $this->Session->setFlash(__('Invalid subfirm', true));
            $this->redirect(array('action' => 'index'));
        }
    }

或者查看这个链接：

http://debuggable.com/posts/how-to-group-by-in-cakephps-new-release-part-2:4850d2c9-edbc-4f0e-9e0e-07d64834cda3
<一个href="http://nuts-and-bolts-of-cakephp.com/2008/06/03/new-way-to-group-by-in-cakephp" rel="nofollow">http://nuts -and-bolts-of-cakephp.com/2008/06/03/new-way-to-group-by-in-cakephp

Try this:

function view($id = null) {
                $this->Subfirm->recursive = -1;
                $data = $this->Subfirm->find('first', array(
                    'contain' => array(
                        'Subfirmdetail' => array(
                            'Subfirmdetailtype' => array(
                                'Datatype',
                            ),
                        ),
                        'Firm' => array(
                            'Firmtype',
                        ),
                    ),
                    'conditions' => array('Subfirm.id' => $id),
                    'group' => 'Subfirmdetail',
                    'order' => 'date',
                ));
        $this->set('subfirm', $data);
        if (!$id) {
            $this->Session->setFlash(__('Invalid subfirm', true));
            $this->redirect(array('action' => 'index'));
        }
    }

Or see this links: