Query in phpmyadmin 1

Level 1

It seems that the issue lies in the way you are retrieving the note using the with() method in your controller. The where clause 'type', Note::getTypeIndex('note') is correctly filtering the notes based on the type, but you're not retrieving the related model correctly.

To retrieve the note, you need to modify your code slightly. Instead of using with(), you can use the load() method to eagerly load the relationship and apply the necessary constraints.

$plans = Plan::query() ->whereHas('note', function ($query) { $query->where('type', Note::getTypeIndex('note')); }) ->with(['note' => function ($query) { $query->where('type', Note::getTypeIndex('note')); }]) ->get();

Level 122

Do you have notes with ids 18,19,and 21, and are these alll of type 6 ?

Level 1

@Snapey Yes, I have attached two images in the links with the question Query in phpmyadmin 1 & 2.

Level 122

anything strange in the plan model with the primary key

Level 1

@Snapey This is the plan model migration.

Schema::create('plans', function (Blueprint $table) {
            $table->id();
            $table->string('title')->unique();
            $table->string('slug')->unique();
            $table->integer('type');
            $table->boolean('live');
            $table->bigInteger('order');
            $table->timestamps();
            $table->softDeletes();
        });

This is the plan model

class Plan extends Model
{
    use HasFactory, HasLive, SoftDeletes, ContentType, HasSlug,HasOrder, HasNote;

    protected $fillable = [
        'title',
        'info',
        'type',
        'live',
    ];

    protected $casts = [
        'live' => 'boolean'
    ];

    public function contents(): \Illuminate\Database\Eloquent\Relations\HasMany
    {
        return $this->hasMany(PlanContent::class);
    }

    public function exercises(): \Illuminate\Database\Eloquent\Relations\HasMany
    {
        return $this->hasMany(PlanContent::class);
    }

    protected array $types = [
        'exercise',
        'resource'
    ];

    public function getSlugOptions() : SlugOptions
    {
        return SlugOptions::create()
            ->generateSlugsFrom('title')
            ->saveSlugsTo('slug')
            ->doNotGenerateSlugsOnUpdate();
    }

}

Level 122

use note is a trait containing the morph relation?

Level 1

@Snapey yes.

trait HasNote
{
    public function note(): \Illuminate\Database\Eloquent\Relations\MorphOne
    {
        return $this->morphOne(Note::class,'notable');
    }

}

Level 122

@yeasirarafat-dev might seem a daft question, but the Note model does not include this trait?

Level 1

@Snapey no. This is Note model

class Note extends Model
{
    use ContentType;

    protected $fillable = [
        'note',
        'live',
        'type',
        'notable_type',
        'notable_id',
    ];

    protected $casts = [
        'live' => 'boolean'
    ];

    protected array $types  = [
        'index',
        'score',
        'wheel',
        'introduction',
        'info',
        'info_bar',
        'note',
    ];
   public function notable(): \Illuminate\Database\Eloquent\Relations\MorphTo
   {
       return $this->morphTo();
   }
}

Best Answer

Level 122

The only thing I can see that might be an issue is the name of the relationship, but the query seems fine.

Not sure if notable is correct or if it should be noteable and then columns of noteable_id and noteable_type

The docs use image and imageable not imagable

Level 1

@Snapey The query seems fine to me also. But When I execute this query in the phpmyadmin it also fetch 0 row. But if remove the `notes`.`notable_type` = 'App\Models\Plan' from query it works fine. So, Is there is any issue with this?

Level 122

@yeasirarafat-dev Whats the column type? Also check if the column contains any extra spaces.

presumably select * from notes where notable_type = 'App\Models\Plan' also returns no records?

Level 1

@Snapey I have checked about the spaces there is no space. And yes this query also returns no records.

Level 122

@yeasirarafat-dev what column type and what database collation?

Level 1

@Snapey Oh, I will store different kinds of notes on the table. So for that, I'm using the below array and storing the index as type in the database.

 protected array $types  = [
        'index',
        'score',
        'wheel',
        'introduction',
        'info',
        'info_bar',
        'note',
    ];