scopeUnionLike.php

<?php
    public function scopeUnionLike($query, $name, $value)
    {
        $columns = $this->getFillable();
        
        if (!in_array($name, $columns)) {
            throw new \PDOException("Column $name does not exist!");
        }
        
        $subQuery = $query->toSql();
    
        $result = Capsule::connection($this->connection)->select("select * from ($subQuery) as v WHERE v.$name LIKE :value", [":value" => "$value%"]);
        return $result;
    }
    
    public function scopeTracks($query)
    {
        $result = $query
            ->select('id', 'php_sid', 'timestamp', 'field_name', 'field_value')
            ->unionAll(Capsule::table('cpcrm.web_tracks')
                ->select('id', 'php_sid', 'timestamp', 'field_name', 'field_value')
            );
        return $result;
    }