Search in Laravel voyager related table

Question

There is 2 table for managing categories one for parents and another for sub-categories. When I want to search with this associated field, I can't. and get this error

Error description

Hizmetler Model (Sub-category):

    class Hizmetler extends Model
    {
        protected $primaryKey = 'hizmet_id';
        protected $table = 'hizmetler';
        public $incrementing = false;
    
        use SoftDeletes;
        protected $dates = ['deleted_at'];
        public function Hizmetler(){
            return $this->belongsTo(Hizmetler::class,'hizmet_ust_kategori');
        }
    }

UstKategori Model (Parent category):

    class UstKategori extends Model
    {
        protected $primaryKey = 'id';
        protected $table = 'ust_kategori';
        public $incrementing = false;
    
        use SoftDeletes;
        protected $dates = ['deleted_at'];
        public function UstKategori(){
            return $this->hasOne(UstKategori::class);
        }
    }

Category Table Sub Categroy Table

Is your relation type between category and subcategory one to one? or it's one to many (one category has many sub category) — A.Seddighi, May 18 '22 at 14:53

score 1 · Accepted Answer · answered May 18 '22 at 15:04

1

Your relationship is incorrect. according to your case, the relationship between the categories and their child is One to Many.

Parent Model:

class UstKategori extends Model
{
    public function childs(){
        return $this->hasMany(Hizmetler::class, 'hizmet_ust_kategori');
    }
}

Child Model:

class Hizmetler extends Model
{
    public function parent(){
        return $this->belongsTo(UstKategori::class, 'hizmet_ust_kategori');
    }
}

You can read the documentation and examples here: https://laravel.com/docs/9.x/eloquent-relationships#one-to-many

answered May 18 '22 at 15:04

A.Seddighi

1,695
1
20
43

Also, you don't need to create a new model for sub-categories if the columns are the same, you can make the relationship in the current model by adding the foreign key. – A.Seddighi May 18 '22 at 15:05
i get the same error when i change the model as you said, Do I need to operate on the bread, is the relationship type correct? `Belongs To` – JrsXcle May 18 '22 at 15:37
What is your error message? did you read the documentation and re-write your models? – A.Seddighi May 18 '22 at 15:40
yes, I do everything as you said, I get the error that the column I asked in the above question could not be found. Maybe you can check her twitter account. – JrsXcle May 18 '22 at 15:46
Please share your migration of the tables – A.Seddighi May 18 '22 at 15:55
1

I updated the topic, I shared the tables – JrsXcle May 18 '22 at 16:08
is the error message exacly the same? – A.Seddighi May 18 '22 at 16:10
yes the error message is the same – JrsXcle May 18 '22 at 16:37

gigo · Answer 2 · 2023-07-06T07:05:35.593

I solved this problem by customizing the index method in VoyagerBaseController and copying the method to my controller. The work steps are as follows.

1- Copy the public function index to your controller

2- Replacing search commands. These commands are inside the conditional command if ($search->value != '' && $search->key && $search->filter).

3- Remove the above evil content and replace it with the following content:

        if ($search->value != '' && $search->key && $search->filter) {
            if ($search->key == 'model_id' || $search->key == 'color_id')
                $query->where($search->key, $search->value);
            else if ($search->key == 'image_belongsto_color_relationship') {
                $query->whereHas('color', function ($query) use ($search) {
                    if ($search->filter == 'equals') {
                        $query->where('title', $search->value);
                    } else {
                        $query->where('title', 'LIKE', '%' . $search->value . '%');
                    }
                });
            } 
        }

Note: Don't forget to define the relationship in the desired model. For the example above, it is defined as follows:

class Images extends Model
{
    use HasFactory;
    public function color(): BelongsTo
    {
        return $this->belongsTo(Color::class, 'color_id');
    }
}

don't forget the definition of the relationship in Bread Voyager. My relationship is defined as belongTo type.

Search in Laravel voyager related table

2 Answers2