Laravel: select pivot column with scopeInsert into … values ( SELECT … FROM … )How do I perform an IF…THEN in an SQL SELECT?Add a column with a default value to an existing table in SQL ServerHow can I SELECT rows with MAX(Column value), DISTINCT by another column in SQL?How do I UPDATE from a SELECT in SQL Server?Using group by on multiple columnsSelect first row in each GROUP BY group?SQL select only rows with max value on a columnLaravel 5.x whereHas many-to-many with an extra pivot columnGet results from pivot table based on the combination of two IDs in Laravel Project
Why is consensus so controversial in Britain?
Are the number of citations and number of published articles the most important criteria for a tenure promotion?
What are these boxed doors outside store fronts in New York?
Convert two switches to a dual stack, and add outlet - possible here?
Does detail obscure or enhance action?
Arrow those variables!
NMaximize is not converging to a solution
How to determine what difficulty is right for the game?
If human space travel is limited by the G force vulnerability, is there a way to counter G forces?
Is there a name for fork-protected pieces?
What's the point of deactivating Num Lock on login screens?
Do I have a twin with permutated remainders?
Has there ever been an airliner design involving reducing generator load by installing solar panels?
Why is Minecraft giving an OpenGL error?
Filter any system log file by date or date range
Why doesn't H₄O²⁺ exist?
Why is 150k or 200k jobs considered good when there's 300k+ births a month?
What's the output of a record needle playing an out-of-speed record
Can a vampire attack twice with their claws using Multiattack?
What does the "remote control" for a QF-4 look like?
How much of data wrangling is a data scientist's job?
"You are your self first supporter", a more proper way to say it
Important Resources for Dark Age Civilizations?
How can bays and straits be determined in a procedurally generated map?
Laravel: select pivot column with scope
Insert into … values ( SELECT … FROM … )How do I perform an IF…THEN in an SQL SELECT?Add a column with a default value to an existing table in SQL ServerHow can I SELECT rows with MAX(Column value), DISTINCT by another column in SQL?How do I UPDATE from a SELECT in SQL Server?Using group by on multiple columnsSelect first row in each GROUP BY group?SQL select only rows with max value on a columnLaravel 5.x whereHas many-to-many with an extra pivot columnGet results from pivot table based on the combination of two IDs in Laravel Project
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I Wanna Show Details, It's Simple!
I use ScopeFilter function in my model (Estate):
public function scopeFilter($query, $zone = null, $type = null)
$query->whereHas('types',function ($query) use ($type)
$query->whereTitle($type);
)->whereHas('zone',function ($query) use ($zone)
$query->whereSlug($zone);
);
return $query;
`enter code here`
were is my controller (estate controller):
$estates = Estate::filter($zone,$type)->latest()->paginate(12);
and here is my relation :
public function types()
return $this->belongsToMany(Type::class)->withPivot('slug');
I have an additional column in my many to many table like:
estate_id| type_id | slug |
------------------------------
a | b | a_b |
c | d | c_d |
I do everything fine
just need show details with where on 'slug' column in my many to many table.
php sql laravel
edited Mar 9 at 4:25
Udhav Sarvaiya
2,52382131
asked Mar 9 at 1:28
Fardin MoradiFardin Moradi
147
add a comment |
I Wanna Show Details, It's Simple!
I use ScopeFilter function in my model (Estate):
public function scopeFilter($query, $zone = null, $type = null)
$query->whereHas('types',function ($query) use ($type)
$query->whereTitle($type);
)->whereHas('zone',function ($query) use ($zone)
$query->whereSlug($zone);
);
return $query;
`enter code here`
were is my controller (estate controller):
$estates = Estate::filter($zone,$type)->latest()->paginate(12);
and here is my relation :
public function types()
return $this->belongsToMany(Type::class)->withPivot('slug');
I have an additional column in my many to many table like:
estate_id| type_id | slug |
------------------------------
a | b | a_b |
c | d | c_d |
I do everything fine
just need show details with where on 'slug' column in my many to many table.
php sql laravel
edited Mar 9 at 4:25
Udhav Sarvaiya
2,52382131
asked Mar 9 at 1:28
Fardin MoradiFardin Moradi
147
whereHas('types',function ($query) use ($type) $query->where('estate_type.slug',$type); )Find It
– Fardin Moradi
Mar 9 at 2:34
add a comment |
I Wanna Show Details, It's Simple!
I use ScopeFilter function in my model (Estate):
public function scopeFilter($query, $zone = null, $type = null)
$query->whereHas('types',function ($query) use ($type)
$query->whereTitle($type);
)->whereHas('zone',function ($query) use ($zone)
$query->whereSlug($zone);
);
return $query;
`enter code here`
were is my controller (estate controller):
$estates = Estate::filter($zone,$type)->latest()->paginate(12);
and here is my relation :
public function types()
return $this->belongsToMany(Type::class)->withPivot('slug');
I have an additional column in my many to many table like:
estate_id| type_id | slug |
------------------------------
a | b | a_b |
c | d | c_d |
I do everything fine
just need show details with where on 'slug' column in my many to many table.
php sql laravel
edited Mar 9 at 4:25
Udhav Sarvaiya
2,52382131
asked Mar 9 at 1:28
Fardin MoradiFardin Moradi
147
I Wanna Show Details, It's Simple!
I use ScopeFilter function in my model (Estate):
public function scopeFilter($query, $zone = null, $type = null)
$query->whereHas('types',function ($query) use ($type)
$query->whereTitle($type);
)->whereHas('zone',function ($query) use ($zone)
$query->whereSlug($zone);
);
return $query;
`enter code here`
were is my controller (estate controller):
$estates = Estate::filter($zone,$type)->latest()->paginate(12);
and here is my relation :
public function types()
return $this->belongsToMany(Type::class)->withPivot('slug');
I have an additional column in my many to many table like:
estate_id| type_id | slug |
------------------------------
a | b | a_b |
c | d | c_d |
I do everything fine
just need show details with where on 'slug' column in my many to many table.
php sql laravel
php sql laravel
edited Mar 9 at 4:25
Udhav Sarvaiya
2,52382131
asked Mar 9 at 1:28
Fardin MoradiFardin Moradi
147
edited Mar 9 at 4:25
Udhav Sarvaiya
2,52382131
asked Mar 9 at 1:28
Fardin MoradiFardin Moradi
147
edited Mar 9 at 4:25
Udhav Sarvaiya
2,52382131
edited Mar 9 at 4:25
Udhav Sarvaiya
2,52382131
edited Mar 9 at 4:25
Udhav Sarvaiya
2,52382131
2,52382131
asked Mar 9 at 1:28
Fardin MoradiFardin Moradi
147
asked Mar 9 at 1:28
Fardin MoradiFardin Moradi
147
asked Mar 9 at 1:28
Fardin MoradiFardin Moradi
147
147
whereHas('types',function ($query) use ($type) $query->where('estate_type.slug',$type); )Find It
– Fardin Moradi
Mar 9 at 2:34
add a comment |
whereHas('types',function ($query) use ($type) $query->where('estate_type.slug',$type); )Find It
– Fardin Moradi
Mar 9 at 2:34
whereHas('types',function ($query) use ($type) $query->where('estate_type.slug',$type); ) Find It– Fardin Moradi
Mar 9 at 2:34
whereHas('types',function ($query) use ($type) $query->where('estate_type.slug',$type); ) Find It– Fardin Moradi
Mar 9 at 2:34
add a comment |
1 Answer
1
active
oldest
votes
whereHas('types',function ($query) use ($type) $query->where('estate_type.slug',$type); )
Find It
answered Mar 9 at 21:47
Fardin MoradiFardin Moradi
147
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55073118%2flaravel-select-pivot-column-with-scope%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
whereHas('types',function ($query) use ($type) $query->where('estate_type.slug',$type); )
Find It
answered Mar 9 at 21:47
Fardin MoradiFardin Moradi
147
add a comment |
whereHas('types',function ($query) use ($type) $query->where('estate_type.slug',$type); )
Find It
answered Mar 9 at 21:47
Fardin MoradiFardin Moradi
147
add a comment |
whereHas('types',function ($query) use ($type) $query->where('estate_type.slug',$type); )
Find It
answered Mar 9 at 21:47
Fardin MoradiFardin Moradi
147
whereHas('types',function ($query) use ($type) $query->where('estate_type.slug',$type); )
Find It
answered Mar 9 at 21:47
Fardin MoradiFardin Moradi
147
answered Mar 9 at 21:47
Fardin MoradiFardin Moradi
147
answered Mar 9 at 21:47
Fardin MoradiFardin Moradi
147
answered Mar 9 at 21:47
Fardin MoradiFardin Moradi
147
147
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55073118%2flaravel-select-pivot-column-with-scope%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
whereHas('types',function ($query) use ($type) $query->where('estate_type.slug',$type); )Find It– Fardin Moradi
Mar 9 at 2:34