Класс Table

class Table extends \Cms\Site\Base { … }

    var $name;

    var $title;

    var $plural;

    var $create;

    var $item;

    var $public;

    var $enable;

    var $sitemap;

    var $order;

    var $sort;

    var $fieldList = array();

    var $root;

    var $site;

    var $data = array();

    var $primary;

    var $_enabledFieldList;

    function __construct($name = null) {
        $this->name = $this->data['name'] = $name;
    }

    function get($key, $default = null) {
        return isset($this->$key) ? $this->$key : $default;
    }

    function set($key, $value) {
        if ($key[0] === '_' || $key === 'root' || $key === 'site') $this->$key = $value;
        else $this->$key = $this->data[$key] = $value;
        if ($key === 'item') {
            $this->Main()->Storage()->resetItemTableList();
        }
        if ($key === 'enabled') {
            $this->Main()->Storage()->resetItemTableList();
            $this->Main()->Storage()->resetEnabledTableList();
        }
    }

    function getName() {
        return $this->name;
    }

    function getTitle() {
        return $this->title ? $this->title : $this->name;
    }

    function displayTitle() {
        return htmlspecialchars($this->getTitle());
    }

    function getPlural() {
        return $this->plural;
    }

    function getCreate() {
        return $this->create;
    }

    function isItem() {
        return $this->item ? true : false;
    }

    function isPublic() {
        return $this->public ? true : false;
    }

    function isEnabled() {
        return $this->enable ? true : false;
    }

    function isSitemap() {
        return $this->sitemap ? true : false;
    }

    function getOrder() {
        return $this->order;
    }

    function getOrderList() {
        if (is_string($this->order) && strlen($this->order)) {
            $r = array();
            foreach (explode(',', $this->order) as $order) if (strlen($order = trim($order))) {
                if ($order[0] !== '-') $r[$order] = 'ASC';
                else $r[substr($order, 1)] = 'DESC';
            }
            return $r;
        } elseif (is_array($this->order)) {
            return $this->order;
        }
        if ($Field = $this->getField('order')) if ($Field->isEnabled()) return array( 'order' => 'ASC' );
        return array();
    }

    function getSort() {
        return $this->sort;
    }

    function getSortList() {
        if (is_string($this->sort) && strlen($this->sort)) {
            $r = array();
            foreach (explode('|', strtr($this->sort, ',', '|')) as $order) if (strlen($order = trim($order))) {
                if ($order[0] !== '-') $r[$order] = 'ASC';
                else $r[substr($order, 1)] = 'DESC';
            }
            return $r;
        } elseif (is_array($this->sort)) {
            return $this->sort;
        }
        if ($Field = $this->getField('title')) if ($Field->isEnabled()) return array( 'title' => 'ASC' );
        return array();
    }

    function addField(Field $Field) {
        $this->fieldList[$Field->getName()] = $Field;
        $this->resetEnabledFieldList();
    }

    function deleteField($field) {
        if (is_object($field)) {
            $Field = $field;
            unset($this->fieldList[$Field->getName()]);
        } else {
            unset($this->fieldList[$field]);
        }
        $this->resetEnabledFieldList();
        return true;
    }

    function getField($field) {
        return $this->fieldList[$field];
    }

    function getEnabledField($field) {
        if ($Field = $this->getField($field)) if ($Field->isEnabled()) return $Field;
    }

    function getFieldList() {
        return $this->fieldList;
    }

    function getEnabledFieldList() {
        if (isset($this->_enabledFieldList)) return $this->_enabledFieldList;
        $r = array();
        foreach ($this->getFieldList() as $field => $Field) {
            if ($Field->isEnabled()) $r[$field] = $Field;
        }
        return $this->_enabledFieldList = $r;
    }

    function resetEnabledFieldList() {
        unset($this->_enabledFieldList);
    }

    function getStorageFields() {
        $r = array();
        foreach ($this->getEnabledFieldList() as $Field) {
            $name = $Field->getName();
            if ($name === 'id' || $name === 'stamp') continue;
            $r[] = $name;
        }
        return $r;
    }

    function isRoot() {
        return $this->root ? true : false;
    }

    function isSite() {
        return $this->site ? true : false;
    }

    function getPrimaryKey() {
        $r = array();
        foreach ($this->getEnabledFieldList() as $Field) {
            if ($Field->isPrimary()) {
                $r[] = $Field->getName();
            }
        }
        if (isset($this->primary)) {
            if (is_string($this->primary)) $r[] = $this->primary;
            elseif (is_array($this->primary)) foreach ($this->primary as $primary) $r[] = $primary;
        }
        switch (count($r)) {
            case 0:
                return;
            case 1:
                return $r[0];
            default:
                return $r;
        }
    }

    function addTableData(array $tableData, $override = true) {
        foreach ($tableData as $k => $v) {
            if ($k === 'fields') {
                if (is_array($v)) {
                    $fieldClass = $this->App()->getClass('data_field');
                    foreach ($v as $fieldData) {
                        if (is_string($fieldData)) {
                            $fieldName = $fieldData;
                            if (!$Field = $this->getField($fieldName)) {
                                $Field = new $fieldClass($this->getName(), $fieldName);
                                if ($fieldData = $Field->defaultFieldData()) $Field->addFieldData($fieldData, $override);
                            }
                            $fieldData = array( 'enable' => 'Y' );
                            $Field->addFieldData($fieldData, $override);
                        } elseif (is_array($fieldData)) {
                            if (!$Field = $this->getField($fieldData['name'])) $Field = new $fieldClass($this->getName(), $fieldData['name']);
                            $Field->addFieldData($fieldData, $override);
                        }
                        $this->addField($Field);
                    }
                }
            } elseif ($override || !isset($this->$k)) {
                $this->set($k, $v);
            }
        }
    }

    function getTableData() {
        $r = $this->data;
        $r['site'] = 'Y';
        $r['fields'] = array();
        foreach ($this->getFieldList() as $Field) if ($Field->isSite()) {
            $r['fields'][$Field->getName()] = $Field->getFieldData();
        }
        return $r;
    }

    function getPanel() {
        return array(
            'edit' => array(
                'href' => $this->Main()->href('/admin/storage') . '?a=table&table=' . rawurldecode($this->getName()),
                'image' => 'edit',
            ),
            'open' => array(
                'href' => $this->Main()->href('/admin/storage') . '?table=' . rawurlencode($this->getName()),
                'image' => 'angle-right',
                'modal' => false,
            ),
        );
    }

    function displayPageForm($form = 'data_table') {
        if (!isset($form)) return;
        $Main = $this->Main();
        $Form = $this->Form();
        $Table = $this;
        $document = $Form->load($form, $Table);
        if ($Form->store($document)) {
            if ($_POST['delete']) {
                if ($Table->delete()) {
                    return $Main->href('/admin/storage');
                } else {
                    $Form->addError($this->getError());
                }
            } else {
                if ($Table->save()) {
                    return $Table->href();
                } else {
                    $Form->addError($this->getError());
                }
            }
        }
        return $document;
    }

    function href() {
        return $this->Main()->href('/admin/storage') . '?table=' . rawurlencode($this->getName());
    }

    function save() {
        $Storage = $this->Main()->Storage();
        if (!$Storage->getTable($this->getName())) $Storage->addTable($this);
        $this->set('site', 'Y');
        if ($Storage->saveData()) {
            if ($this->saveData()) {
                return true;
            }
        }
    }

    function delete() {
        $Storage = $this->Main()->Storage();
        $Storage->deleteTable($this);
        if ($Storage->saveData()) {
            if ($this->deleteData()) {
                return true;
            }
        }
    }

    function saveData() {
        $Data = $this->Data();
        if (!$this->getEnabledFieldList()) return true;
        if ($Data->tableExists($this)) {
            if ($Data->tableAlter($this)) {
                return true;
            } else {
                $this->addError($Data->getError());
            }
        } else {
            if ($Data->tableCreate($this)) {
                return true;
            } else {
                $this->addError($Data->getError());
            }
        }
    }

    function deleteData() {
        $Data = $this->Data();
        if ($Data->tableExists($this)) {
            if ($Data->tableDrop($this)) {
                return true;
            } else {
                $this->addError($Data->getError());
            }
        } else {
            return true;
        }
    }