public static function create($field_name, $structure, $module)
{
$field = new __cms_field();
$field->do_retrieve([], ['where_equals' => ['mid' => $module, 'field_name' => $field_name]]);
if (!$field->get_primary_key()) {
$field->field_name = $field_name;
$field->mid = $module;
$field->type = $structure->type;
$field->title = isset($structure->title) ? $structure->title : ucwords(str_replace('_', ' ', $field_name));
if (isset($structure->module) && $structure->module) {
$_module = new __cms_module();
$_module->do_retrieve(['mid'], ['where_equals' => ['table_name' => $structure->module]]);
$field->link_module = $_module->mid;
if (isset($structure->field) && $structure->field) {
$_field = new __cms_field();
$_field->do_retrieve(['fid'], ['where_equals' => ['field_name' => $structure->field, 'mid' => $_module->mid]]);
if ($_field->get_primary_key()) {
$field->link_field = $_field->fid;
}
}
}
$field->list = isset($structure->list) ? $structure->list : true;
$field->filter = isset($structure->filter) ? $structure->filter : true;
$field->required = isset($structure->required) ? $structure->required : true;
$field->do_save();
} else {
throw new \Exception('Field ' . $field_name . ' already exists in module ' . $module);
}
return $field;
}
public function do_submit()
{
$module = new _cms_module([], $this->mid);
$field = new field_type([], $this->type);
$type = '\\form\\field_' . $field->title;
/** @var \form\field $field_type */
$field_type = new $type('');
if ($inner = $field_type->get_database_create_query()) {
db::query('ALTER TABLE ' . $module->table_name . ' ADD `' . $this->field_name . '` ' . $field_type->get_database_create_query(), [], 1);
}
if ($field->title == 'mlink') {
$source_module = new _cms_module(['table_name', 'primary_key'], $this->link_module);
db::create_table_join(get::__class_name($this), $source_module->table_name);
}
$res = db::select('_cms_field')->retrieve('MAX(position) AS pos')->filter_field('mid', $this->mid)->execute()->fetchObject();
$insert = db::insert('_cms_field')->add_value('title', $this->title)->add_value('type', $field->title)->add_value('field_name', $this->field_name)->add_value('mid', $this->mid)->add_value('position', $res->pos + 1);
if ($field->title == 'link' || $field->title == 'mlink') {
$insert->add_value('link_module', $this->link_module)->add_value('link_field', $this->link_field);
}
$insert->execute();
table::rebuild_modules();
table::reset_module_fields($module->mid);
ajax::update($module->get_fields_list()->get());
ajax::update($this->get_html()->get());
}
public function do_submit()
{
$module = new _cms_module();
$module->do_retrieve_from_id(['mid', 'title'], $this->mid);
$module->gid = $this->gid;
$module->do_save();
ajax::add_script('$.fn.colorbox.close()');
}
public function do_submit()
{
$module = new _cms_module([], $this->mid);
if ($module->table_name != $this->table_name) {
db::rename_table($module->table_name, $this->table_name);
}
if ($module->primary_key != $this->primary_key) {
db::rename_column($this->table_name, $module->primary_key, $this->primary_key);
}
\classes\table::rebuild_modules();
$module->set_from_request();
$module->do_save();
}
public function do_submit($no_session = false)
{
if (!$no_session) {
foreach ($this->fields as $field) {
if ($field instanceof field_boolean && !$this->{$field->field_name}) {
session::un_set('cms', 'filter', $this->_mid, $field->field_name);
} else {
session::set($this->{$field->field_name}, 'cms', 'filter', $this->_mid, $field->field_name);
}
}
}
$module = new _cms_module();
$module->do_retrieve([], ['where_equals' => ['mid' => $this->_mid]]);
$list = new _cms_table_list($module, 1);
ajax::update($list->get_table());
}
/**
* @param $mid
*/
public function set_from_mid($mid)
{
$this->mid = $mid;
$this->module = new object\_cms_module([], $this->mid);
$this->current = $this->module->get_class();
$this->current->mid = $this->mid;
}
public function reprocess()
{
$_field = new _cms_field([], $this->fid);
$_module = new _cms_module([], $_field->mid);
$base_path = root . '/uploads/' . $_module->table_name . '/' . $_field->fid . '/';
/** @var table $class */
$class = $_module->get_class_name();
$objects = $class::get_all([]);
$extensions = ['png', 'jpg', 'gif'];
$objects->iterate(function (table $object) use($base_path, $extensions) {
foreach ($extensions as $extension) {
$path = $base_path . $object->get_primary_key() . '.' . $extension;
if (file_exists($path)) {
echo 'Reprocessing image ' . $object->get_primary_key() . '...';
$object->do_process_image($path, $this);
echo ' done<br/>';
}
}
});
}
public function get_module_list()
{
$modules = _cms_module::get_all(['mid', 'title', 'primary_key', '_cms_group.title', 'table_name'], ['join' => ['_cms_group' => '_cms_group.gid = _cms_module.gid']]);
if ($modules) {
$html = node::create('div', [], node::create('table.module.table.table-striped', [], node::create('thead', [], node::create('th', [], 'Module ID') . node::create('th', [], 'Group') . node::create('th', [], 'Title') . node::create('th', [], 'Table Name') . node::create('th', [], 'Primary Key')) . $modules->iterate_return(function (_cms_module $module) {
$attributes = ['href' => '/cms/admin_edit/' . $module->mid];
return node::create('tr', [], node::create('td a', $attributes, $module->mid) . node::create('td a', $attributes, $module->_cms_group->title) . node::create('td a', $attributes, $module->title) . node::create('td a', $attributes, $module->table_name) . node::create('td a', $attributes, $module->primary_key));
})));
return $html;
}
return '';
}
public function do_submit()
{
$module = new _cms_module([], $this->mid);
$field = new field_type([], $this->type);
$old_field = new _cms_field([], $this->fid);
$type = '\\form\\field_' . $field->title;
/** @var \form\field $field_type */
$field_type = new $type('');
if ($inner = $field_type->get_database_create_query()) {
db::query('ALTER TABLE ' . $module->table_name . ' MODIFY `' . $old_field->field_name . '` `' . $this->field_name . '` ' . $field_type->get_database_create_query(), [], 1);
}
if ($field->title == 'mlink' && $old_field->type !== 'mlink') {
$source_module = new _cms_module(['table_name', 'primary_key'], $this->link_module);
db::create_table_join(\classes\get::__class_name($this), $source_module->table_name);
}
$insert = db::update('_cms_field')->add_value('title', $this->title)->add_value('type', $field->title)->add_value('field_name', $this->field_name)->add_value('link_module', $this->link_module)->add_value('link_field', $this->link_field)->filter_field('fid', $this->fid);
$insert->execute();
table::rebuild_modules();
table::reset_module_fields($module->mid);
ajax::update($module->get_fields_list()->get());
ajax::update($this->get_html()->get());
}
public static function create_table_join($source, $destination)
{
$source_module = new _cms_module();
$source_module->do_retrieve(['primary_key'], ['where_equals' => ['table_name' => $source]]);
$destination_module = new _cms_module();
$destination_module->do_retrieve(['primary_key'], ['where_equals' => ['table_name' => $destination]]);
$sql = 'CREATE TABLE IF NOT EXISTS ' . $source . '_link_' . $destination . '
(
`' . $source_module->primary_key . '` INT(6) NOT NULL DEFAULT 0,
`link_' . $destination_module->primary_key . '` INT(6) NOT NULL DEFAULT 0,
`fid` INT(6) NOT NULL DEFAULT 0,
INDEX(`' . $source_module->primary_key . '`,`link_' . $destination_module->primary_key . '`,`fid`),
INDEX(`link_' . $destination_module->primary_key . '`)
)
';
$setting_strings = [];
foreach (_db::$default_table_settings as $setting => $value) {
if (is_numeric($setting)) {
$setting_strings[] = $value;
} else {
$setting_strings[] = $setting . ' = ' . $value;
}
}
$sql .= implode(',', $setting_strings);
_db::query($sql);
}
public static function do_paginate()
{
$module = new __cms_module();
$module->do_retrieve_from_id([], $_REQUEST['_mid']);
$object = new static($module, $_REQUEST['value']);
ajax::update($object->get_table());
}
/** Add user level management
* ---CMS User
* ---CMS User level
* ---CMS User --> CMS Module
* */
public function patch_v4()
{
if (!db::table_exists('_cms_user')) {
self::create_from_structure('_cms_user');
table::reload_table_definitions();
$user_level = new _cms_user_level();
$user_level->title = 'User';
$user_level->do_save();
$user_level->ulid = 0;
$user_level->title = 'Webmaster';
$user_level->do_save();
$user_level->ulid = 0;
$user_level->title = 'Admin';
$user_level->do_save();
$cms_user = new _cms_user();
$cms_user->title = 'admin';
$cms_user->password = '******';
$cms_user->ulid = 3;
$cms_user->do_save();
$_module = new _cms_module();
$_module->do_retrieve([], ['where_equals' => ['table_name' => '_cms_module']]);
$_field = new _cms_field();
$_field->do_retrieve([], ['where_equals' => ['mid' => $_module->get_primary_key(), 'field_name' => 'user_level_view']]);
static::modify_link_field($_field, '_cms_user_level', 'title');
$_field = new _cms_field();
$_field->do_retrieve([], ['where_equals' => ['mid' => $_module->get_primary_key(), 'field_name' => 'user_level_add']]);
static::modify_link_field($_field, '_cms_user_level', 'title');
$_field = new _cms_field();
$_field->do_retrieve([], ['where_equals' => ['mid' => $_module->get_primary_key(), 'field_name' => 'user_level_delete']]);
static::modify_link_field($_field, '_cms_user_level', 'title');
}
}
public static function rebuild_modules()
{
$modules = _cms_module::get_all(_cms_module::$default_fields);
$fields = _cms_field::get_all(_cms_field::$default_fields);
$json = [];
$modules->iterate(function (_cms_module $row) use(&$json) {
$result = [];
foreach (_cms_module::$default_fields as $field) {
$result[$field] = $row->{$field};
}
$json[$row->mid] = $result;
});
$fields->iterate(function (_cms_field $row) use(&$json) {
$result = [];
foreach (_cms_field::$default_fields as $field) {
$result[$field] = $row->{$field};
}
$json[$row->mid]['fields'][$row->field_name] = $result;
});
file_put_contents(root . '/.cache/.modules.json', json_encode($json));
}
