EloquentNamesTrait.php

<?php

namespace App\Models;

use Illuminate\Support\Facades\DB;

trait EloquentNamesTrait
{

    protected static $tableName = null;

    public static function name()
    {
        if (static::$tableName === null) {
            return static::$tableName = ((new self)->getTable());
        } else {
            return static::$tableName;
        }
    }

    public static function field($name)
    {
        return static::name() . '.' . $name;
    }

    public static function alias($name, $aliasName)
    {
        return DB::raw(static::field($name) . ' as ' . $aliasName);
    }

    public static function getValue($id, $fieldName = 'name')
    {
        if ($id) {
            $entity = self::find($id);
            if (isset($entity[$fieldName])) {
                return $entity[$fieldName];
            }
        }

        return null;
    }

}