class.arStatement.php

Go to the documentation of this file.

<?php

abstract class arStatement
{
    protected string $table_name_as = '';

    abstract public function asSQLStatement(ActiveRecord $activeRecord, ilDBInterface $db): string;

    public function getTableNameAs(): string
    {
        return $this->table_name_as;
    }

    public function setTableNameAs(string $table_name_as): void
    {
        $this->table_name_as = $table_name_as;
    }

    protected function wrapFields(array $fields, ilDBInterface $db): array
    {
        $wrapped_fields = [];

        foreach ($fields as $field) {
            $wrapped_fields[] = $this->wrapField($field, $db);
        }

        return $wrapped_fields;
    }

    protected function wrapField(string $field, ilDBInterface $db): string
    {
        $slitted = explode('.', $field);

        if (count($slitted) === 1 && $slitted[0] === '*') {
            return $field;
        }

        if (count($slitted) === 2) {
            return $db->quoteIdentifier($slitted[0]) . '.' . $db->quoteIdentifier($slitted[1]);
        }

        return $db->quoteIdentifier($field);
    }
}