首页 \ 问答 \ 如何使用Scope在Eloquent ORM中选择除（A和B）之外的所有行？(How to select all rows except (A and B) in Eloquent ORM using Scope?)

如何使用Scope在Eloquent ORM中选择除（A和B）之外的所有行？(How to select all rows except (A and B) in Eloquent ORM using Scope?)

 我试图弄清楚如何在Eloquent ORM模式中获得除少数（A和B）之外的所有行。  
 用户模型  
public function notifications()
{
    return $this->hasMany('notification','listener_id','id');
}
 
 型号通知  
public function scopeFriendship($query)
{
    return $query->where('object_type', '=', 'Friendship Request');
}

public function scopeSent($query)
{
    return $query->where('verb', '=', 'sent');
}
 
 在这里，除了（友谊和已发送）范围之外，我如何获得用户的所有通知。  
Something like:- all rows except !(Friendship AND Sent)

I'm trying to figure out how to get all rows except few (A and B) in Eloquent ORM modal. 
User Model 
public function notifications()
{
    return $this->hasMany('notification','listener_id','id');
}
 
Model Notification 
public function scopeFriendship($query)
{
    return $query->where('object_type', '=', 'Friendship Request');
}

public function scopeSent($query)
{
    return $query->where('verb', '=', 'sent');
}
 
Here how can I get all notifications of a user except other than (Friendship and Sent) scope. 
Something like:- all rows except !(Friendship AND Sent)

原文：https://stackoverflow.com/questions/27881105

更新时间：2022-04-30 07:04

最满意答案

 由于这是8个小时没有回答，让我给你一个粗略（不准确）的答案，你可能想要遵循几个选项：  
 您可以只使用一个模板并对该模板中的逻辑（要显示的字段/内容）进行编码，而不是您的portlet。 这可能会或可能不是将可维护条件纳入的好点，但在我能想到的所有情况下，我更喜欢这种操作模式。 这样做的好处可能取决于您对所选模板语言的体验以及该环境的强大功能（您使用xsl，velocity还是freemarker？）  
 如果你的决定不同，一篇文章基本上是一个xml文档 - 所以，给定文章你总是可以得到xml内容并显示/转换它或访问部分（例如xpath）。 你可能想要逃避内容 - 但这取决于你。  
 另外，正如你所提到的，在6.0.2之前忽略了templateId并且你正在使用6.0 EE：请确保6.0.2早于6.0 EE，所以 - 根据引用的语句 - templateId 不被忽略，你应该没问题 ，不需要悲伤。 

As this went 8 hours without answer, let me give you a rough (unprecise) answer with a few options that you might want to follow: 
You could use just one template and code the logic (what field/content to display) in that template, instead of your portlet. This might or might not be a good point to put maintainable conditions into, but in all scenarios that I can think of, I'd prefer this mode of operation. The ease to do this might depend on your experience with the template language chosen and the power of that environment (do you use xsl, velocity or freemarker?) 
If you decide differently, an article is basically an xml document - so, given the article you can always get the xml content and display/transform this or access parts (e.g. xpath). You might want to escape the contents - but that's up to you. 
Also, as you mention that templateId is ignored prior to 6.0.2 and you're using 6.0 EE: Be assured that 6.0.2 predates 6.0 EE, so - according to the referenced statement - templateId is not ignored, you should be fine, no need for sadface.

如何使用Scope在Eloquent ORM中选择除（A和B）之外的所有行？(How to select all rows except (A and B) in Eloquent ORM using Scope?)

最满意答案

相关问答

liferay内容管理系统和用作外部内容源(liferay content management system and use as external content source)[2023-01-15]

如何在Liferay Portlet中按结构名称获取Web内容？(How to get Web Content by Structure name in Liferay Portlet?)[2022-10-19]

在Liferay中重载Web内容Portlet(Overloading web content Portlet in Liferay)[2022-01-16]

在Liferay 6中呈现文章的JSP(JSPs that render articles in Liferay 6)[2022-09-13]

Liferay Web内容portlet中使用了哪种技术？(Which technology is used in a Liferay web content portlet?)[2023-08-07]

如何在JSP中访问Liferay中的部分Web内容(How to access partial Web Content in Liferay within JSP)[2023-07-02]

如何将大量XML内容导入Liferay？(How to import a huge list of content in XML into Liferay?)[2022-08-13]

使用钩子覆盖Liferay JSP(Overriding Liferay JSP using a hook)[2022-07-20]

按日期排序Liferay 6.2中的文档和媒体与Web内容(Sort Documents And Media & Web Content in Liferay 6.2 by date)[2022-04-22]

将JSP添加到Portlet Liferay(Add JSP to portlet Liferay)[2022-10-09]

相关文章

最新问答