Laravel - Get values from 2 different parent table
I have 3 table :
Branch - id | name
Agent - id | branch_id
Transaction - id | Agent_id
My output has agent_id so now i want to get the name of branch as per agent_id (Transaction.Agent_id = Agent.branch_id = Branch.id)
My Controller ::
public function Search(Request $Request){
$from = $Request->input('from');
$to = $Request->input('to');
$result = Transaction::select('agent_id,'user')
->whereBetween(date,[$from, $to])
->groupBy('agent_id')
->orderBy('agent_id')
->get();
return view('report')->with(['result'=> $result]);
}
View ::
@foreach($result as $row)
{{$row->agent_id}}
{{$row->user}}
{{ ??? }} <---- branch name here, as per above $row->agent_id
@endforeach
laravel laravel-5.7
|
show 2 more comments
I have 3 table :
Branch - id | name
Agent - id | branch_id
Transaction - id | Agent_id
My output has agent_id so now i want to get the name of branch as per agent_id (Transaction.Agent_id = Agent.branch_id = Branch.id)
My Controller ::
public function Search(Request $Request){
$from = $Request->input('from');
$to = $Request->input('to');
$result = Transaction::select('agent_id,'user')
->whereBetween(date,[$from, $to])
->groupBy('agent_id')
->orderBy('agent_id')
->get();
return view('report')->with(['result'=> $result]);
}
View ::
@foreach($result as $row)
{{$row->agent_id}}
{{$row->user}}
{{ ??? }} <---- branch name here, as per above $row->agent_id
@endforeach
laravel laravel-5.7
haverelationship
this table you cant all for eloquent
– Alexander Villalobos
Dec 27 '18 at 15:26
1
Transaction::with('Agent.Branch')
assuming you have already defined these relations in your model then you can use$row->agent->id
&$row->agent->branch->id
– ahmad
Dec 27 '18 at 15:26
1
As @ahmad said but with lower case relationship names:with('agent.branch')
and then$transaction->agent->branch->name
.
– Namoshek
Dec 27 '18 at 15:28
@ahmad still not getting how to define relations in model :(
– Sant Bohara
Dec 27 '18 at 15:45
1
Use multiple calls tooptional()
:optional(optional($transaction->agent)->branch)->name
– Namoshek
Dec 27 '18 at 16:29
|
show 2 more comments
I have 3 table :
Branch - id | name
Agent - id | branch_id
Transaction - id | Agent_id
My output has agent_id so now i want to get the name of branch as per agent_id (Transaction.Agent_id = Agent.branch_id = Branch.id)
My Controller ::
public function Search(Request $Request){
$from = $Request->input('from');
$to = $Request->input('to');
$result = Transaction::select('agent_id,'user')
->whereBetween(date,[$from, $to])
->groupBy('agent_id')
->orderBy('agent_id')
->get();
return view('report')->with(['result'=> $result]);
}
View ::
@foreach($result as $row)
{{$row->agent_id}}
{{$row->user}}
{{ ??? }} <---- branch name here, as per above $row->agent_id
@endforeach
laravel laravel-5.7
I have 3 table :
Branch - id | name
Agent - id | branch_id
Transaction - id | Agent_id
My output has agent_id so now i want to get the name of branch as per agent_id (Transaction.Agent_id = Agent.branch_id = Branch.id)
My Controller ::
public function Search(Request $Request){
$from = $Request->input('from');
$to = $Request->input('to');
$result = Transaction::select('agent_id,'user')
->whereBetween(date,[$from, $to])
->groupBy('agent_id')
->orderBy('agent_id')
->get();
return view('report')->with(['result'=> $result]);
}
View ::
@foreach($result as $row)
{{$row->agent_id}}
{{$row->user}}
{{ ??? }} <---- branch name here, as per above $row->agent_id
@endforeach
laravel laravel-5.7
laravel laravel-5.7
asked Dec 27 '18 at 15:22
Sant Bohara
166
166
haverelationship
this table you cant all for eloquent
– Alexander Villalobos
Dec 27 '18 at 15:26
1
Transaction::with('Agent.Branch')
assuming you have already defined these relations in your model then you can use$row->agent->id
&$row->agent->branch->id
– ahmad
Dec 27 '18 at 15:26
1
As @ahmad said but with lower case relationship names:with('agent.branch')
and then$transaction->agent->branch->name
.
– Namoshek
Dec 27 '18 at 15:28
@ahmad still not getting how to define relations in model :(
– Sant Bohara
Dec 27 '18 at 15:45
1
Use multiple calls tooptional()
:optional(optional($transaction->agent)->branch)->name
– Namoshek
Dec 27 '18 at 16:29
|
show 2 more comments
haverelationship
this table you cant all for eloquent
– Alexander Villalobos
Dec 27 '18 at 15:26
1
Transaction::with('Agent.Branch')
assuming you have already defined these relations in your model then you can use$row->agent->id
&$row->agent->branch->id
– ahmad
Dec 27 '18 at 15:26
1
As @ahmad said but with lower case relationship names:with('agent.branch')
and then$transaction->agent->branch->name
.
– Namoshek
Dec 27 '18 at 15:28
@ahmad still not getting how to define relations in model :(
– Sant Bohara
Dec 27 '18 at 15:45
1
Use multiple calls tooptional()
:optional(optional($transaction->agent)->branch)->name
– Namoshek
Dec 27 '18 at 16:29
have
relationship
this table you cant all for eloquent– Alexander Villalobos
Dec 27 '18 at 15:26
have
relationship
this table you cant all for eloquent– Alexander Villalobos
Dec 27 '18 at 15:26
1
1
Transaction::with('Agent.Branch')
assuming you have already defined these relations in your model then you can use $row->agent->id
& $row->agent->branch->id
– ahmad
Dec 27 '18 at 15:26
Transaction::with('Agent.Branch')
assuming you have already defined these relations in your model then you can use $row->agent->id
& $row->agent->branch->id
– ahmad
Dec 27 '18 at 15:26
1
1
As @ahmad said but with lower case relationship names:
with('agent.branch')
and then $transaction->agent->branch->name
.– Namoshek
Dec 27 '18 at 15:28
As @ahmad said but with lower case relationship names:
with('agent.branch')
and then $transaction->agent->branch->name
.– Namoshek
Dec 27 '18 at 15:28
@ahmad still not getting how to define relations in model :(
– Sant Bohara
Dec 27 '18 at 15:45
@ahmad still not getting how to define relations in model :(
– Sant Bohara
Dec 27 '18 at 15:45
1
1
Use multiple calls to
optional()
: optional(optional($transaction->agent)->branch)->name
– Namoshek
Dec 27 '18 at 16:29
Use multiple calls to
optional()
: optional(optional($transaction->agent)->branch)->name
– Namoshek
Dec 27 '18 at 16:29
|
show 2 more comments
active
oldest
votes
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%2f53947277%2flaravel-get-values-from-2-different-parent-table%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53947277%2flaravel-get-values-from-2-different-parent-table%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
have
relationship
this table you cant all for eloquent– Alexander Villalobos
Dec 27 '18 at 15:26
1
Transaction::with('Agent.Branch')
assuming you have already defined these relations in your model then you can use$row->agent->id
&$row->agent->branch->id
– ahmad
Dec 27 '18 at 15:26
1
As @ahmad said but with lower case relationship names:
with('agent.branch')
and then$transaction->agent->branch->name
.– Namoshek
Dec 27 '18 at 15:28
@ahmad still not getting how to define relations in model :(
– Sant Bohara
Dec 27 '18 at 15:45
1
Use multiple calls to
optional()
:optional(optional($transaction->agent)->branch)->name
– Namoshek
Dec 27 '18 at 16:29