JsonField.php

<?php

namespace ProcessMaker\Query;

use Illuminate\Database\Query\Grammars\MySqlGrammar;
use Illuminate\Database\Query\Grammars\SQLiteGrammar;
use Illuminate\Support\Facades\DB;
use ProcessMaker\Query\Exceptions\UnsupportedQueryGrammarException;

class JsonField extends BaseField
{
    public function toArray()
    {
        return [
            'JsonField' => $this->field,
        ];
    }

    public function toEloquent($connection = null)
    {
        if (!$connection) {
            $connection = DB::connection();
        }
        $grammar = $connection->getQueryGrammar();
        // Convert to Laravel Database Json Syntax
        $value = str_replace('.', '->', $this->field);
        if (is_a($grammar, MySqlGrammar::class)) {
            return $connection->raw((new Grammars\MySqlGrammar($connection))->wrapJsonSelector($value));
        } elseif (is_a($grammar, SQLiteGrammar::class)) {
            return $connection->raw((new Grammars\SQLiteGrammar($connection))->wrapJsonSelector($value));
        } else {
            throw new UnsupportedQueryGrammarException();
        }
    }
}