dougui4325 2015-11-12 09:18
浏览 42
已采纳

first()和take()在Eager Load laravel中无法正常工作

I have a Post Model that have a hasMany relation to post_pics and belongsToMany relation to Category Model.

I want to fetch All Posts and All their Categories but First post_pics of each Post.

For that I write this Eager Load Constraints :

Post::with([
                'post_pics'  => function ($query) {
                    $query->select(['pic_id', 'pic_name', 'post_id'])->first()->get();
                },
                'categories' => function ($query) {
                    $query->select(['categories.cat_id', 'name']);
                }
            ])
                ->take(12)->orderBy('created_at', 'desc')
                ->get(['post_id', 'post_title', 'post_alias', 'post_content', 'comments_count', 'created_at']);

        return $latestPosts;

When I remove first() method after select() method all things works and returns all pictures of each Post but when I use first() method, only returns first picture of Models that have more than one picture.

I try to take(1) Constraints but it does not work too.

What is Problem and How Can I do that?

  • 写回答

1条回答 默认 最新

报告相同问题?

悬赏问题

  • ¥60 pb数据库修改或者求完整pb库存系统,需为pb自带数据库
  • ¥15 spss统计中二分类变量和有序变量的相关性分析可以用kendall相关分析吗?
  • ¥15 拟通过pc下指令到安卓系统,如果追求响应速度,尽可能无延迟,是不是用安卓模拟器会优于实体的安卓手机?如果是,可以快多少毫秒?
  • ¥20 神经网络Sequential name=sequential, built=False
  • ¥16 Qphython 用xlrd读取excel报错
  • ¥15 单片机学习顺序问题!!
  • ¥15 ikuai客户端多拨vpn,重启总是有个别重拨不上
  • ¥20 关于#anlogic#sdram#的问题,如何解决?(关键词-performance)
  • ¥15 相敏解调 matlab
  • ¥15 求lingo代码和思路