douzhui1972 2014-10-24 17:35
浏览 61
已采纳

Yii:相关表格的默认排序模型

I have a three tables, "pets", "species" and "homes." Homes have multiple pets, each of which has a species. The species can be mixed in a home.

Is it possible to use findByPk() on a house and have the associated pets sorted by species then name?

Hendersons
--------------
Cat "Hairball"
Cat "Princess"
Dog "Ace"
Dog "Killer"

This is probably blindingly obvious to someone, but I'm not finding an answer.

  • 写回答

1条回答 默认 最新

  • duan1983 2014-10-24 19:41
    关注

    With Carlos' help, here's the functional code, in "homes" model:

    'pets' => array(self::MANY_MANY, 'Pets', 'home_id',
                    'order'=>'species.name ASC',
                    'with'=>'species')
    

    Pretty simple. Thanks, Carlos.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 STM32F103上电短路问题
  • ¥15 关于#单片机#的问题:以ATMEGA128或相近型号单片机为控制器设计直流电机调速的闭环控制系统(相关搜索:设计报告|软件设计|流程图)
  • ¥15 打开软件提示错误:failed to get wglChoosePixelFormatARB
  • ¥15 (标签-python|关键词-char)
  • ¥15 python+selenium,在新增时弹出了一个输入框
  • ¥15 苹果验机结果的api接口哪里有??单次调用1毛钱及以下。
  • ¥20 学生成绩管理系统设计
  • ¥15 来一个cc穿盾脚本开发者
  • ¥15 CST2023安装报错
  • ¥15 使用diffusionbert生成文字 结果是PAD和UNK怎么办