Filtering by URL route

@tjsherrill You mean the datbase schema? Its above, but I'll post it again:

 Schema::create('components', function (Blueprint $table) {
            $table->id();
            $table->foreignId('company_id')->nullable();
            $table->foreignId('parent_id')->nullable()->references('id')->on('components');
            $table->foreignId('component_category_id')->nullable();
            $table->timestamps();
        });

I'm just reading what you wrote, and I think it makes sense, what no it is a bit weird like you said but that's the URL I want for this :D I guess though it makes sense to do it in show, starting to get a better idea - I though it would be more like using some relationship to get them not querying or filtering like that, but fair enough.

Just decoding what you wrote :D

I'm just reading what you wrote and docs

Maybe something like this

    public function show($componentCategoryID) 
    {
        $components = DB::table('component_categories')
            ->where('components_category_id', '=', $componentCategoryID)
            ->get();

        return view('inspiration.components.show', [
            "components" => $components
        ]);
    }

Not working yet but yeah still trying

@tjsherrill This works so far, ish not quite but

 public function show($slug) 
    {
        
        // dd(ComponentCategory::find($slug));
        // dd($slug);
        
        $categoryID = DB::table('component_categories')
            ->where('slug', '=', $slug)
            ->get();
            // dd($categoryID[0]->id);


        $components = DB::table('components')
            ->where('component_category_id', '=', $categoryID[0]->id)
            ->get();

        return view('inspiration.components.show', [
            "components" => $components
        ]);
    }

Getting there

@MichalOravec How would you refactor the code above?

I know what I'm doing, learning! ^^

Managed to make the above work.

I'm passing the slug via here

Route::controller(ComponentController::class)->group(function() {
    Route::get('/components', 'index')->name('components.index');
    Route::get('/components/{component:slug}', 'show')->name('components.show');
});

And want to show only a specific component. So then, I do the code above your reply to get all components/{type} and display just these.

@aurelianspodarec Use relationships.

Route::controller(ComponentController::class)->group(function() {
    Route::get('/components/{componentCategory:slug}', 'show')->name('components.show');
});

public function show(ComponentCategory $componentCategory) 
{
    $components = $componentCategory->components;
    
    return view('inspiration.components.show', compact('components'));
}

@MichalOravec Bit confused. I did try that didn't work.

How does it know what to filer? Since we want to get the slug id, and then get the component by category_id, which we can only get by slug id.

This is components category

Schema::create('component_categories', function (Blueprint $table) {
            $table->id();
            
            $table->string('name');
            $table->string('slug');

            $table->timestamps();
        });

So we need to get its ID, by slug, and then use that ID to look what component has that ID and get all of them.

What does this do? $componentCategory->components;

I get this error

foreach() argument must be of type array|object, null given

Which means we aren't getting the components

@aurelianspodarec Show your models.

components is just an example of your relationship...

@MichalOravec

Here are the models

class Component extends Model
{
    use HasFactory;

    public function content()
    {
        return $this->hasOne(ComponentContent::class, 'component_id');
    }

    public function category()
    {
        return $this->belongsTo(ComponentCategory::class, 'component_category_id');
    }
}

class ComponentContent extends Model
{
    use HasFactory;

    protected $table = 'components_content';
}

class ComponentCategory extends Model
{
    use HasFactory;
}

@aurelianspodarec Add a relationship to ComponentCategory model and the code above will work.

class ComponentCategory extends Model
{
    use HasFactory;

    public function components()
    {
        return $this->hasMany(Component::class, 'component_category_id');
    }
}

@MichalOravec I think this makes sense kinda.

Does the Route need to be named componentCategory? Or can it be named anything?

Then in the show function, we are passing the ComponentCategory model, and then getting all of the components via the model relationship.

I'm confused on how does it know on what to do with the slug. When we write "x:slug" how does it umm..

How does this filter by slug?

@aurelianspodarec You are asking things which are in the documentation.

https://laravel.com/docs/9.x/routing#route-model-binding