如何通过引用另一个模型来创建新模型对象

Question

I have a function in which I take model as parameter to create slug value from that model values and after creating slug i want to check existence of that in same table.

public static function slug_it($model = null)
{
  if(!empty($model)) {
    #from model
    $keys = [/*priority => key to find*/
        1 => 'name', 2 => 'item', 4 => 'title', 3 => 'code', 5 => 'company', 6 => 'code_name', 7 => 'country', 8 => 'city', 9 => 'state', 10 => 'username', 11 => 'first_name', 12 => 'last_name',];
    /* suppose i have slug */
    $slug = 'item_erp5511'; 

    /*slug or sku*/
  } else {

  }
}

Suppose Model is of item table and I want to find slug in "slug" col of that table but i only have Model Object of that table.

Answer 1

You can try something like the following, presumption, $model = Item::class instance and you want to find something from the slugs table.

// $model = Item::find(1);
$model->getQuery()->from('slugs')->where('slug', $slug)->get();

Alternatively if slug_it is inside a model you can try:

self::getQuery()->from('slugs')->....->get();

Update after your latest comment

Inside the method to do a check you can do:

if (self::where('slug', $slug)->exists()) {
    // Do what you need
}