Mixing
Using pagination in Eloquent resource throws Undefined Property $id error in Laravel
0
I'm trying to build a application in Laravel 5.7 where I am having a model named CompanyBehaviour:
protected $table = 'company_behaviour';
protected $guarded= ;
public function companies()
{
return $this->belongsTo('NoeticPluginsConxnModelsCompany','company_id','id');
}
public function companyRole()
{
return $this->belongsTo('NoeticPluginsConxnModelsVariablesCompanyRole', 'company_role_id', 'id');
}
public function companySpecialisation()
{
return $this->belongsTo('NoeticPluginsConxnModelsVariablesCompanyRole', 'company_specialisation_id', 'id');
}
I'm having a resource file for this:
class CompanyBehaviourResource extends JsonResource
{
/**
* Transform the resource into an array.
*
* @param IlluminateHttpRequest $request
* @return array
*/
public function toArray($request)
{
return [
'id' => $this->id,
'company' => $this->company->name,
'company_role' => $this->companyRole->name,
'company_specialisation' => $this->companySpecialisation->name,
];
}
}
Which I need to use while fetching the data in my controller:
public function index(Request $request)
{
return new CompanyBehaviourResource(CompanyBehaviour::whereHas('companies', function ($q) use($request) {
$q->where('name', 'like', '%'.$request->search.'%');
})->orderBy('created_at', 'desc')
->paginate(20)
);
}
But when I called this I'm getting pagination error:
Undefined property: IlluminatePaginationLengthAwarePaginator::$id
And the trace represents that:
class: "IlluminateHttpResourcesJsonJsonResource"
file: "D:~ResourceCompanyBehaviourResource.php"
function: "__get"
line: 17
type: "->"
Stating the 'id' => $this->id, this line. I've gone through the documentation of Laravel Resource API I'm couldn't find where I'm doing wrong. Help me out with this. Thanks.
php laravel laravel-5.7 laravel-pagination laravel-resource
edited Jan 2 at 19:34
niklaz
1,99511217
asked Jan 2 at 19:12
Nitish KumarNitish Kumar
1,93942964
add a comment |
0
I'm trying to build a application in Laravel 5.7 where I am having a model named CompanyBehaviour:
protected $table = 'company_behaviour';
protected $guarded= ;
public function companies()
{
return $this->belongsTo('NoeticPluginsConxnModelsCompany','company_id','id');
}
public function companyRole()
{
return $this->belongsTo('NoeticPluginsConxnModelsVariablesCompanyRole', 'company_role_id', 'id');
}
public function companySpecialisation()
{
return $this->belongsTo('NoeticPluginsConxnModelsVariablesCompanyRole', 'company_specialisation_id', 'id');
}
I'm having a resource file for this:
class CompanyBehaviourResource extends JsonResource
{
/**
* Transform the resource into an array.
*
* @param IlluminateHttpRequest $request
* @return array
*/
public function toArray($request)
{
return [
'id' => $this->id,
'company' => $this->company->name,
'company_role' => $this->companyRole->name,
'company_specialisation' => $this->companySpecialisation->name,
];
}
}
Which I need to use while fetching the data in my controller:
public function index(Request $request)
{
return new CompanyBehaviourResource(CompanyBehaviour::whereHas('companies', function ($q) use($request) {
$q->where('name', 'like', '%'.$request->search.'%');
})->orderBy('created_at', 'desc')
->paginate(20)
);
}
But when I called this I'm getting pagination error:
Undefined property: IlluminatePaginationLengthAwarePaginator::$id
And the trace represents that:
class: "IlluminateHttpResourcesJsonJsonResource"
file: "D:~ResourceCompanyBehaviourResource.php"
function: "__get"
line: 17
type: "->"
Stating the 'id' => $this->id, this line. I've gone through the documentation of Laravel Resource API I'm couldn't find where I'm doing wrong. Help me out with this. Thanks.
php laravel laravel-5.7 laravel-pagination laravel-resource
edited Jan 2 at 19:34
niklaz
1,99511217
asked Jan 2 at 19:12
Nitish KumarNitish Kumar
1,93942964
You need to retrieve your id from request
– niklaz
Jan 2 at 19:16
@niklaz what do you mean? My request doesn't hold any id, it only holds search string.
– Nitish Kumar
Jan 2 at 19:20
I apologize, I should have looked a bit closer. This means that your eloquent call doesn't return object that holds 'id' property.
– niklaz
Jan 2 at 19:27
add a comment |
0
0
0
I'm trying to build a application in Laravel 5.7 where I am having a model named CompanyBehaviour:
protected $table = 'company_behaviour';
protected $guarded= ;
public function companies()
{
return $this->belongsTo('NoeticPluginsConxnModelsCompany','company_id','id');
}
public function companyRole()
{
return $this->belongsTo('NoeticPluginsConxnModelsVariablesCompanyRole', 'company_role_id', 'id');
}
public function companySpecialisation()
{
return $this->belongsTo('NoeticPluginsConxnModelsVariablesCompanyRole', 'company_specialisation_id', 'id');
}
I'm having a resource file for this:
class CompanyBehaviourResource extends JsonResource
{
/**
* Transform the resource into an array.
*
* @param IlluminateHttpRequest $request
* @return array
*/
public function toArray($request)
{
return [
'id' => $this->id,
'company' => $this->company->name,
'company_role' => $this->companyRole->name,
'company_specialisation' => $this->companySpecialisation->name,
];
}
}
Which I need to use while fetching the data in my controller:
public function index(Request $request)
{
return new CompanyBehaviourResource(CompanyBehaviour::whereHas('companies', function ($q) use($request) {
$q->where('name', 'like', '%'.$request->search.'%');
})->orderBy('created_at', 'desc')
->paginate(20)
);
}
But when I called this I'm getting pagination error:
Undefined property: IlluminatePaginationLengthAwarePaginator::$id
And the trace represents that:
class: "IlluminateHttpResourcesJsonJsonResource"
file: "D:~ResourceCompanyBehaviourResource.php"
function: "__get"
line: 17
type: "->"
Stating the 'id' => $this->id, this line. I've gone through the documentation of Laravel Resource API I'm couldn't find where I'm doing wrong. Help me out with this. Thanks.
php laravel laravel-5.7 laravel-pagination laravel-resource
edited Jan 2 at 19:34
niklaz
1,99511217
asked Jan 2 at 19:12
Nitish KumarNitish Kumar
1,93942964
I'm trying to build a application in Laravel 5.7 where I am having a model named CompanyBehaviour:
protected $table = 'company_behaviour';
protected $guarded= ;
public function companies()
{
return $this->belongsTo('NoeticPluginsConxnModelsCompany','company_id','id');
}
public function companyRole()
{
return $this->belongsTo('NoeticPluginsConxnModelsVariablesCompanyRole', 'company_role_id', 'id');
}
public function companySpecialisation()
{
return $this->belongsTo('NoeticPluginsConxnModelsVariablesCompanyRole', 'company_specialisation_id', 'id');
}
I'm having a resource file for this:
class CompanyBehaviourResource extends JsonResource
{
/**
* Transform the resource into an array.
*
* @param IlluminateHttpRequest $request
* @return array
*/
public function toArray($request)
{
return [
'id' => $this->id,
'company' => $this->company->name,
'company_role' => $this->companyRole->name,
'company_specialisation' => $this->companySpecialisation->name,
];
}
}
Which I need to use while fetching the data in my controller:
public function index(Request $request)
{
return new CompanyBehaviourResource(CompanyBehaviour::whereHas('companies', function ($q) use($request) {
$q->where('name', 'like', '%'.$request->search.'%');
})->orderBy('created_at', 'desc')
->paginate(20)
);
}
But when I called this I'm getting pagination error:
Undefined property: IlluminatePaginationLengthAwarePaginator::$id
And the trace represents that:
class: "IlluminateHttpResourcesJsonJsonResource"
file: "D:~ResourceCompanyBehaviourResource.php"
function: "__get"
line: 17
type: "->"
Stating the 'id' => $this->id, this line. I've gone through the documentation of Laravel Resource API I'm couldn't find where I'm doing wrong. Help me out with this. Thanks.
php laravel laravel-5.7 laravel-pagination laravel-resource
php laravel laravel-5.7 laravel-pagination laravel-resource
edited Jan 2 at 19:34
niklaz
1,99511217
asked Jan 2 at 19:12
Nitish KumarNitish Kumar
1,93942964
edited Jan 2 at 19:34
niklaz
1,99511217
asked Jan 2 at 19:12
Nitish KumarNitish Kumar
1,93942964
edited Jan 2 at 19:34
niklaz
1,99511217
edited Jan 2 at 19:34
niklaz
1,99511217
edited Jan 2 at 19:34
niklaz
1,99511217
1,99511217
asked Jan 2 at 19:12
Nitish KumarNitish Kumar
1,93942964
asked Jan 2 at 19:12
Nitish KumarNitish Kumar
1,93942964
asked Jan 2 at 19:12
Nitish KumarNitish Kumar
1,93942964
1,93942964
You need to retrieve your id from request
– niklaz
Jan 2 at 19:16
@niklaz what do you mean? My request doesn't hold any id, it only holds search string.
– Nitish Kumar
Jan 2 at 19:20
I apologize, I should have looked a bit closer. This means that your eloquent call doesn't return object that holds 'id' property.
– niklaz
Jan 2 at 19:27
add a comment |
You need to retrieve your id from request
– niklaz
Jan 2 at 19:16
@niklaz what do you mean? My request doesn't hold any id, it only holds search string.
– Nitish Kumar
Jan 2 at 19:20
I apologize, I should have looked a bit closer. This means that your eloquent call doesn't return object that holds 'id' property.
– niklaz
Jan 2 at 19:27
You need to retrieve your id from request
– niklaz
Jan 2 at 19:16
You need to retrieve your id from request
– niklaz
Jan 2 at 19:16
@niklaz what do you mean? My request doesn't hold any id, it only holds search string.
– Nitish Kumar
Jan 2 at 19:20
@niklaz what do you mean? My request doesn't hold any id, it only holds search string.
– Nitish Kumar
Jan 2 at 19:20
I apologize, I should have looked a bit closer. This means that your eloquent call doesn't return object that holds 'id' property.
– niklaz
Jan 2 at 19:27
I apologize, I should have looked a bit closer. This means that your eloquent call doesn't return object that holds 'id' property.
– niklaz
Jan 2 at 19:27
add a comment |
1 Answer
1
active
oldest
votes
2
Your call returns eloquent collection, instead of single result, thus not holding $id property.
You should call collection method instead:
public function index(Request $request)
{
return new CompanyBehaviourResource::collection(CompanyBehaviour::whereHas('companies', function ($q) use($request) {
$q->where('name', 'like', '%'.$request->search.'%');
})->orderBy('created_at', 'desc')
->paginate(20)
);
}
answered Jan 2 at 19:29
niklazniklaz
1,99511217
@NitishKumar, try to debug the object, I think that you should usecompaniesinstead ofcompanyaccording to the model that you have provided
– niklaz
Jan 2 at 19:36
Yaah got it. Thanks..
– Nitish Kumar
Jan 2 at 19:36
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
});
}
});
draft saved
draft discarded
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%2f54011913%2fusing-pagination-in-eloquent-resource-throws-undefined-property-id-error-in-lar%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
2
Your call returns eloquent collection, instead of single result, thus not holding $id property.
You should call collection method instead:
public function index(Request $request)
{
return new CompanyBehaviourResource::collection(CompanyBehaviour::whereHas('companies', function ($q) use($request) {
$q->where('name', 'like', '%'.$request->search.'%');
})->orderBy('created_at', 'desc')
->paginate(20)
);
}
answered Jan 2 at 19:29
niklazniklaz
1,99511217
@NitishKumar, try to debug the object, I think that you should usecompaniesinstead ofcompanyaccording to the model that you have provided
– niklaz
Jan 2 at 19:36
Yaah got it. Thanks..
– Nitish Kumar
Jan 2 at 19:36
add a comment |
2
Your call returns eloquent collection, instead of single result, thus not holding $id property.
You should call collection method instead:
public function index(Request $request)
{
return new CompanyBehaviourResource::collection(CompanyBehaviour::whereHas('companies', function ($q) use($request) {
$q->where('name', 'like', '%'.$request->search.'%');
})->orderBy('created_at', 'desc')
->paginate(20)
);
}
answered Jan 2 at 19:29
niklazniklaz
1,99511217
@NitishKumar, try to debug the object, I think that you should usecompaniesinstead ofcompanyaccording to the model that you have provided
– niklaz
Jan 2 at 19:36
Yaah got it. Thanks..
– Nitish Kumar
Jan 2 at 19:36
add a comment |
2
2
2
Your call returns eloquent collection, instead of single result, thus not holding $id property.
You should call collection method instead:
public function index(Request $request)
{
return new CompanyBehaviourResource::collection(CompanyBehaviour::whereHas('companies', function ($q) use($request) {
$q->where('name', 'like', '%'.$request->search.'%');
})->orderBy('created_at', 'desc')
->paginate(20)
);
}
answered Jan 2 at 19:29
niklazniklaz
1,99511217
Your call returns eloquent collection, instead of single result, thus not holding $id property.
You should call collection method instead:
public function index(Request $request)
{
return new CompanyBehaviourResource::collection(CompanyBehaviour::whereHas('companies', function ($q) use($request) {
$q->where('name', 'like', '%'.$request->search.'%');
})->orderBy('created_at', 'desc')
->paginate(20)
);
}
answered Jan 2 at 19:29
niklazniklaz
1,99511217
answered Jan 2 at 19:29
niklazniklaz
1,99511217
answered Jan 2 at 19:29
niklazniklaz
1,99511217
answered Jan 2 at 19:29
niklazniklaz
1,99511217
1,99511217
@NitishKumar, try to debug the object, I think that you should usecompaniesinstead ofcompanyaccording to the model that you have provided
– niklaz
Jan 2 at 19:36
Yaah got it. Thanks..
– Nitish Kumar
Jan 2 at 19:36
add a comment |
@NitishKumar, try to debug the object, I think that you should usecompaniesinstead ofcompanyaccording to the model that you have provided
– niklaz
Jan 2 at 19:36
Yaah got it. Thanks..
– Nitish Kumar
Jan 2 at 19:36
@NitishKumar, try to debug the object, I think that you should use
companies instead of company according to the model that you have provided– niklaz
Jan 2 at 19:36
@NitishKumar, try to debug the object, I think that you should use
companies instead of company according to the model that you have provided– niklaz
Jan 2 at 19:36
Yaah got it. Thanks..
– Nitish Kumar
Jan 2 at 19:36
Yaah got it. Thanks..
– Nitish Kumar
Jan 2 at 19:36
add a comment |
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f54011913%2fusing-pagination-in-eloquent-resource-throws-undefined-property-id-error-in-lar%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
You need to retrieve your id from request
– niklaz
Jan 2 at 19:16
@niklaz what do you mean? My request doesn't hold any id, it only holds search string.
– Nitish Kumar
Jan 2 at 19:20
I apologize, I should have looked a bit closer. This means that your eloquent call doesn't return object that holds 'id' property.
– niklaz
Jan 2 at 19:27