I believe your relationships are looking for the columns reviewable_id and reviewable_type. So to get it to work, you need to change the Photo.php relationship so it can find the columns:

public function review()
    {
        return $this->morphOne(App\Models\Reviewable::class,  'review');
    }

Then you can call $photo->review.

There seems to be some confusion about the terms review and reviewable.

To me it looks like a photo is one model type that can have a Review, so the model should have been named Review, rather than Reviewable.

A photo is then a reviewable model, i.e. it is a model that can have a review. This would then make sense that the columns should be reviewable_id and reviewable_type.

Still nothing

Updated code: Photo.php

public function review()
    {
        return $this->morphOne('App\Models\Review', 'review');
    }

Review.php

public function review()
  {
      return $this->morphTo();
  }

API Resource collection

'photo' => $photo->review,

Property [review] does not exist on this collection instance.

Where are you getting $photo from in your API Resource?

@aleahy Correct, in the API resource.

The resource pulls a full profile and all the "reviewables" is the intention. Idea is i can then once "review" the photo also delete it's review.id. I could be going about it all wrong. I just trying to get the review record first before having it wrong and going to much deeper into the project

@movepixels Can you post the full api resource, as well as the query you use to get the data?

DashboardProfilePageResource.php

namespace App\Http\Resources\Pages\Dashboard\Profile;

use Illuminate\Http\Resources\Json\JsonResource;

// INDIVIDUAL MODULES
use App\Http\Resources\Modules\Profile\ProfileResource;

class DashboardProfilePageResource extends JsonResource
{
  /**
   * Transform the resource into an array.
   *
   * @param  \Illuminate\Http\Request  $request
   * @return array
   */
  public function toArray($request)
  {
    $response = [
      'type' => 'DashboardProfilePageResource',
      'id' => $this->user->id,
      'attributes' => [],
      'relationships' => [
        'profile' => new ProfileResource($this),
        'user' => $this->user,
        'photo' => $this->photo,
      ],
    ];
    return $response;
  }
}

ProfilesController.php

public function show(Profile $profile){
    DashboardProfilePageResource::withoutWrapping();
	return new DashboardProfilePageResource($profile);
  }

I just verified the model files are placed in exact folder structure on both sites. So the user in the front uploads a photo the reviewable db table shows App\Models\Profile\Photo

So in the admin backend there is a folder to match that structure so when attempting to get the relationships they match

@movepixels So if it has many photos, you have a collection of photos rather than a single photo. That would be why it doesn't have a review.

When i view the response the photo key is an object of "photo" records. I can see all the images the user uploaded in the loop thru photo key, Basically i am trying to include the "review" record with the photo

Manually i can take the photo.id and query the reviewable table and see its matching record.

For sake of it I have an uploaded photo id => f1bcf118-f5c7-11ec-bb31-a760af6730a8

The reviews table has:

id, profile_id, review_id, review_type, note, created_at, updated_at

'f1beba16-f5c7-11ec-be0e-6d8c6a8cc2b3', '89ab1306-d368-11ec-8854-99bb1c7971be', 'f1bcf118-f5c7-11ec-bb31-a760af6730a8', 'App\Models\Profile\Photo', NULL, '2022-06-27 00:49:24', '2022-06-27 00:49:24'

So what i am trying to accomplish is to get this reviewable record that match's the photo.id so when i say yes this photo has been reviewed i can delete the reviewable record since its no longer needed

@movepixels The data you get back when you put

'photo' => $this->photo

is an array of photos, isn't it? It may only have one photo, but if a profile has many photos, then it will be an array.

You need to load your Review relationship in your controller for the photos. This way your photos will include the review when they are obtained from the database.

Eg:

$profile->load('photo.review');

Ok i will give it a try. And yes the API resource returns an array of photos. In the admin section i can visually see all the images the user uploaded in a loop as intended.

Will try the

$profile->load('photo.review');

Update once tested

Maybe Model directory structure?

Models folder

- Review.php
- Profile folder
-- Profile.php
-- Photo.php

Have you changed the relationship on Photo?

Is it still

public function review()
{
    return $this->morphOne(App\Models\Reviewable::class,  'review');
}

If you open up php artisan tinker and get a photo which has a Reviewable (or is it Review now?)

Can you call $photo->find('f1bcf118-f5c7-11ec-bb31-a760af6730a8')->review

The photo has:

public function review()
    {
        return $this->morphMany('App\Models\Review', 'review');
    }

Only thing new is there is a review key in the photo array, but blank / empty

"review": []

There are photos since i am getting a photo array of $profile->photo but still no reviewable records included with each photo

Nice tool, i knew but never used.

But i get the review that way

 App\Models\Review {#3505
         id: "f1beba16-f5c7-11ec-be0e-6d8c6a8cc2b3",
         profile_id: "89ab1306-d368-11ec-8854-99bb1c7971be",
         review_id: "f1bcf118-f5c7-11ec-bb31-a760af6730a8",
         review_type: "App\Models\Profile\Photo",
         note: null,
         created_at: "2022-06-27 00:49:24",
         updated_at: "2022-06-27 00:49:24",
       },
     ],
   }

Try a few things to see if you get the data you want:

Photo::with('review')->find('f1bcf118-f5c7-11ec-bb31-a760af6730a8');

$profile = Profile::find('89ab1306-d368-11ec-8854-99bb1c7971be');
$profile->load('photo.review');

in tinker this one is what i want

$profile->load('photo.review');

You need to do the two lines to define $profile.

If that works in tinker, then it should work in your controller. You should be passing a profile which has the data you want to your API resource.

Its fine in tinker, but how to relate that into the controller / API response?

Tinker spits out exacly the array structure the api respose is returning but missing the review info

But in the controller I am simply passing $profile, there is no photo id or any param to pass like we are doing in tinker.

Think i got lost somewhere along the way.

Tinker these examples asa you kindly provided:

Photo::with('review')->find('f1bcf118-f5c7-11ec-bb31-a760af6730a8');

$profile = Profile::find('89ab1306-d368-11ec-8854-99bb1c7971be');
$profile->load('photo.review');

But i do not follow where these go in relation to the controller / API resource? I have no id to pass or grab from somewhere.

I used the id as an example to say i went to mysql db and pulled a record that exists and pasted it into laracast to say yes there is a record. But that was me and the mouse getting the id, the Controller / API has no clue about this id

This is all the controller has:

public function show(Profile $profile){

    $q = Profile::find($profile->id);
    $q->load('photo.review');

    DashboardProfilePageResource::withoutWrapping();
		return new DashboardProfilePageResource($q);
  }

But still no review data.

I see what you did in tinker example so I tried to mimic it but still empty