Laravel子查询有关自定义Manuttomany关系数量
假设在我拥有的帖子模型中
public function followers()
{
return $this->belongsToMany(User::class, 'post_followers', 'post_id', 'user_id')
->as('follower')
->withTimestamps();
}
，我现在喜欢做一个我在这种关系上应用子查询的数量：
$post = Post::with('followers')
->withCount([
'followers as followers_count_total',
'followers as followers_count_this_month' => function ($q) {
$q->where('follower.created_at', '>', now()->addDays(30)); // This doesn't work
},
])
->firstOrFail();
我认为$ q-＆gt; wherepivot（'create_at'''＆gt;'，现在（） - ＆gt; adddays（30））;因为关系具有自定义名称而行不通吗？
Let's say in a Post model I have
public function followers()
{
return $this->belongsToMany(User::class, 'post_followers', 'post_id', 'user_id')
->as('follower')
->withTimestamps();
}
And I now like to do a count where I apply a subquery on that relationship:
$post = Post::with('followers')
->withCount([
'followers as followers_count_total',
'followers as followers_count_this_month' => function ($q) {
$q->where('follower.created_at', '>', now()->addDays(30)); // This doesn't work
},
])
->firstOrFail();
I think that $q->wherePivot('created_at', '>', now()->addDays(30)); doesn't work because the relationship has a custom name?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论