yf_manage_revisions admin module

    public function add($object_name, $ids = [], $action = null, $extra = [])
    {
        if ( ! $this->ENABLED) {
            return false;
        }
        if (is_array($object_name)) {
            $extra = (array) $extra + $object_name;
            $object_name = '';
        }
        $object_name = ($extra['object_name'] ?? null) ?: ($object_name ?: ($_GET['object'] ?? null));
        if (($allowed_objects = $this->ALLOWED_OBJECTS)) {
            if ( ! in_array($object_name, $allowed_objects)) {
                return false;
            }
        }
        $ids = ($extra['object_id'] ?? null) ?: (($extra['ids'] ?? null) ?: $ids);
        if ($ids && ! is_array($ids)) {
            $ids = [$ids];
        }
        $items = [];
        if (is_array($extra['items'])) {
            $items = $extra['items'];
            if ( ! $items) {
                return false;
            }
        } elseif (is_array($ids) && ! empty($ids)) {
            if (isset($extra['old']) || isset($extra['new'])) {
                foreach ((array) $ids as $id) {
                    $items[$id] = [];
                }
            } else {
                $records = (array) db()->from($object_name)->whereid($ids)->get_all();
                foreach ((array) $ids as $id) {
                    $a = $records[$id];
                    if ($a) {
                        $items[$id] = [
                            'new' => $a,
                            'locale' => $a['locale'],
                        ];
                    }
                }
            }
            if ( ! $items) {
                return false;
            }
        }
        $action = ($extra['action'] ?? null) ?: $action;
        if ( ! $action) {
            $action = 'update';
        }
        $to_insert = [
            'action' => $action,
            'object_name' => $object_name,
            'date' => date('Y-m-d H:i:s'),
            'user_id' => main()->ADMIN_ID,
            'site_id' => conf('SITE_ID'),
            'server_id' => conf('SERVER_ID'),
            'ip' => common()->get_ip(),
            'url' => (main()->is_https() ? 'https://' : 'http://') . ($_SERVER['HTTP_HOST'] ?? null) . ($_SERVER['REQUEST_URI'] ?? null),
            'user_agent' => ($_SERVER['HTTP_USER_AGENT'] ?? null),
        ];
        foreach ((array) $items as $object_id => $data) {
            if ( ! $object_id) {
                continue;
            }
            $data_old = ($data['old'] ?? null) ?: (($extra['data_old'] ?? null) ?: $extra['old']);
            $data_new = ($data['new'] ?? null) ?: (($extra['data_new'] ?? null) ?: $extra['new']);
            if ( ! $data_old && ! $data_new) {
                continue;
            }
            if ($data_old && $data_old == $data_new) {
                // TODO: do not save same data as new revision
                //				continue;
            }
            $sql = db()->insert_safe(self::table, $to_insert + [
                'object_id' => $object_id,
                'locale' => (is_array($data_old) ? $data_old['locale'] : '') ?: $extra['locale'],
                'data_old' => is_array($data_old) ? 'json:' . json_encode($data_old) : (string) $data_old,
                'data_new' => is_array($data_new) ? 'json:' . json_encode($data_new) : (string) $data_new,
                'comment' => ($data['comment'] ?? null) ?: $extra['comment'],
            ], $only_sql = true);
            db()->_add_shutdown_query($sql);
        }
        return true;
    }

    public function filter_save()
    {
        return _class('admin_methods')->filter_save();
    }

    public function show()
    {
        return table(db()->from(self::table), [
                'filter' => true,
                'filter_params' => [
                    'date' => 'daterange_dt_between',
                    '__default_order' => 'date DESC',
                ],
                'hide_empty' => 1,
            ])
            ->text('id', ['link' => url('/@object/view/%id')])
            ->date('date', ['format' => 'long'])
            ->func('object_id', function ($in, $e, $a) {
                return $a['object_name'] . ' | ' . $a['object_id'] . ' | ' . $a['action'];
            })
            ->func('ip', function ($ip) {
                return html()->ip($ip);
            })
            ->admin('user_id', ['desc' => 'Editor']);
        //			->btn_view(array('btn_no_text' => 1))
    }

    public function show_for_admin()
    {
        $_GET['page'] = 'clear';
        $_GET['filter'] = 'user_id:' . (int) (($_GET['id'] ?? null));
        return $this->filter_save();
    }

    public function view()
    {
        $id = (int) $_GET['id'];
        $a = null;
        if ($id) {
            $a = db()->from(self::table)->whereid($id)->get();
        }
        if ( ! $a) {
            return _404();
        }
        $all = db()->select('id, date, action')->from(self::table)
            ->where('object_name', $a['object_name'])
            ->where('object_id', $a['object_id'])
            ->order_by('id ASC')
            ->get_all();
        $prefix = 'json:';
        $plen = strlen('json:');
        if (substr($a['data_old'], 0, 1) === '{') {
            $a['data_old'] = json_decode($a['data_old'], true);
        } elseif (substr($a['data_old'], 0, $plen) === $prefix) {
            $a['data_old'] = json_decode(substr($a['data_old'], $plen), true);
        }
        if (substr($a['data_new'], 0, 1) === '{') {
            $a['data_new'] = json_decode($a['data_new'], true);
        } elseif (substr($a['data_new'], 0, $plen) === $prefix) {
            $a['data_new'] = json_decode(substr($a['data_new'], $plen), true);
        }

        $prev_id = 0;
        $next_id = 0;
        foreach ($all as $rinfo) {
            $rid = $rinfo['id'];
            if ($rid < $id) {
                $prev_id = $rid;
            } elseif ($rid > $id) {
                $next_id = $rid;
                break;
            }
        }
        css('pre.black { color: #ccc; background: black; font-weight: bold; font-family: inherit; margin: 0; display: inline-block; width: auto; padding: 2px; border: 0; }');
        $admin_objects = [
            'static_pages' => 'static_pages',
            'news' => 'manage_news',
            'faq' => 'manage_faq',
            'tips' => 'manage_tips',
        ];
        $url_object = $admin_objects[$a['object_name']];
        $object_info = $a['object_name'] . ' | ' . $a['object_id'];
        $diff = [];
        if (is_array($a['data_old']) || is_array($a['data_new'])) {
            $diff = array_diff((array) $a['data_old'], (array) $a['data_new']);
        }
        $a = [
            'navigation' => ''
                . ($prev_id ? a('/@object/@action/' . $prev_id, 'Prev: ' . $prev_id, 'fa fa-backward', null, null, false) . ' ' : '')
                . '<big><b> ' . $id . ' </b></big> '
                . ($next_id ? a('/@object/@action/' . $next_id, 'Next: ' . $next_id, 'fa fa-forward', null, null, false) : ''),
            'object' => ($url_object ? a('/' . $url_object . '/edit/' . $a['object_id'], $object_info, 'fa fa-edit') : $object_info)
                . ' | ' . $a['action'] . ($a['locale'] ? ' | locale: ' . $a['locale'] : ''),
            'date' => $a['date'],
            'url' => a($a['url']),
            'editor' => a('/admin/edit/' . $a['user_id'], db()->from('admin')->get_one('login') . ' [' . $a['user_id'] . ']', 'fa fa-user') . ' '
                . html()->ip($a['ip']) . '<br /><small>' . $a['user_agent'] . '</small>',
            'data_old' => $a['data_old'] ? '<pre class="black">' . _prepare_html(is_array($a['data_old']) ? var_export($a['data_old'], 1) : $a['data_old']) . '</pre>' : '',
            'data_new' => $a['data_new'] ? '<pre class="black">' . _prepare_html(is_array($a['data_new']) ? var_export($a['data_new'], 1) : $a['data_new']) . '</pre>' : '',
            'diff' => $diff ? '<pre class="black">' . _prepare_html(var_export($diff, 1)) . '</pre>' : '',
        ];
        foreach ($a as $k => $v) {
            if (empty($v)) {
                unset($a[$k]);
            }
        }
        return html()->simple_table($a);
    }

    public function _hook_side_column()
    {
    }

    public function _show_filter()
    {
        if ( ! in_array(($_GET['action'] ?? null), ['show'])) {
            return false;
        }
        $min_date = db()->from(self::table)->min('date');
        $min_date = strtotime($min_date);

        $r = null;
        $order_fields = [];
        foreach (explode('|', 'id|date|object_name|object_id|action|user_id|locale|site_id|server_id|ip') as $f) {
            $order_fields[$f] = $f;
        }
        return form([], [
                'filter' => true,
            ])
            ->daterange('date', [
                'format' => 'DD.MM.YYYY',
                'min_date' => date('d.m.Y', $min_date ?: (time() - 86400 * 30)),
                'max_date' => date('d.m.Y', time() + 86400),
                'autocomplete' => 'off',
            ])
            ->number('id')
            ->number('user_id')
            ->text('object_name')
            ->text('object_id')
            ->text('action')
            ->select_box('order_by', $order_fields, ['no_translate' => 1, 'show_text' => 1])
            ->order_box()
            ->save_and_clear();
    }