$rex_file_category_name = rex_i18n::msg('pool_kats_no'); } else { $rex_file_category_name = $gc->getValue('name'); } rex_set_session('media[rex_file_category]', $rex_file_category); // -------------- PERMS $PERMALL = rex::getUser()->getComplexPerm('media')->hasCategoryPerm(0); // -------------- Header $subline = rex_be_controller::getPageObject('mediapool')->getSubpages(); foreach ($subline as $sp) { $sp->setHref(rex_url::backendPage($sp->getFullKey(), $arg_url, false)); } echo rex_view::title(rex_i18n::msg('pool_media'), $subline); // -------------- Messages if ($success != '') { echo rex_view::info($success); $success = ''; } if ($error != '') { echo rex_view::error($error); $error = ''; } // -------------- Javascripts ?> <script type="text/javascript"> <!-- function selectMedia(filename, alt) { <?php if ($opener_input_field != '') {
<?php $message = ''; $content = ''; if ($func == 'delete') { $sql = rex_sql::factory(); $sql->setQuery('DELETE FROM ' . rex::getTable('user_role') . ' WHERE id = ? LIMIT 1', [$id]); $message = rex_view::info(rex_i18n::msg('user_role_deleted')); $func = ''; } if ($func == '') { $title = rex_i18n::msg('user_role_caption'); $list = rex_list::factory('SELECT id, name FROM ' . rex::getTablePrefix() . 'user_role'); $list->addTableAttribute('class', 'table-striped'); $tdIcon = '<i class="rex-icon rex-icon-userrole"></i>'; $thIcon = '<a href="' . $list->getUrl(['func' => 'add', 'default_value' => 1]) . '"' . rex::getAccesskey(rex_i18n::msg('create_user_role'), 'add') . ' title="' . rex_i18n::msg('create_user_role') . '"><i class="rex-icon rex-icon-add-userrole"></i></a>'; $list->addColumn($thIcon, $tdIcon, 0, ['<th>###VALUE###</th>', '<td>###VALUE###</td>']); $list->setColumnParams($thIcon, ['func' => 'edit', 'id' => '###id###']); $list->setColumnLabel('id', rex_i18n::msg('id')); $list->setColumnLayout('id', ['<th>###VALUE###</th>', '<td>###VALUE###</td>']); $list->setColumnLabel('name', rex_i18n::msg('name')); $list->setColumnLayout('name', ['<th>###VALUE###</th>', '<td>###VALUE###</td>']); $list->setColumnParams('name', ['func' => 'edit', 'id' => '###id###']); $list->addColumn('edit', '<i class="rex-icon rex-icon-edit"></i> ' . rex_i18n::msg('edit')); $list->setColumnLabel('edit', rex_i18n::msg('user_functions')); $list->setColumnLayout('edit', ['<th colspan="2">###VALUE###</th>', '<td>###VALUE###</td>']); $list->setColumnParams('edit', ['func' => 'edit', 'id' => '###id###']); $list->addColumn('funcs', '<i class="rex-icon rex-icon-delete"></i> ' . rex_i18n::msg('user_role_delete')); $list->setColumnLabel('funcs', rex_i18n::msg('user_functions')); $list->setColumnLayout('funcs', ['', '<td>###VALUE###</td>']); $list->setColumnParams('funcs', ['func' => 'delete', 'id' => '###id###']);
$title = rex_i18n::msg('yform_manager_edit_table'); } else { $title = rex_i18n::msg('yform_manager_add_table'); } $fragment = new rex_fragment(); $fragment->setVar('class', 'edit', false); $fragment->setVar('title', $title); $fragment->setVar('body', $form, false); // $fragment->setVar('buttons', $buttons, false); $form = $fragment->parse('core/page/section.php'); echo $form; echo rex_view::info('<a href="index.php?page=' . $page . '"><b>« ' . rex_i18n::msg('yform_back_to_overview') . '</b></a>'); $show_list = false; } else { if ($func == 'edit') { echo rex_view::info(rex_i18n::msg('yform_manager_table_updated')); } elseif ($func == 'add') { $table_name = $yform->objparams['value_pool']['sql']['table_name']; $table = rex_yform_manager_table::get($table_name); if ($table) { $t = new rex_yform_manager(); $t->setTable($table); $t->generateAll(); echo rex_view::success(rex_i18n::msg('yform_manager_table_added')); } } } } } if ($func == 'delete' && rex::getUser()->isAdmin()) { $table_name = rex_request('table_name', 'string');
<?php $plugin = rex_plugin::get('out5', 'wartungsarbeiten'); $content = ''; if (rex_post('config-submit', 'boolean')) { $plugin->setConfig(rex_post('config', [['url', 'string']])); $content .= rex_view::info('Änderung gespeichert'); } $content .= ' <div class="rex-form"> <form action="' . rex_url::currentBackendPage() . '" method="post"> <fieldset>'; $formElements = []; $n = []; $n['label'] = '<label for="rex-out5-wartungsarbeiten-url">URL</label>'; $n['field'] = '<input class="form-control" type="text" id="rex-out5-wartungsarbeiten-url" name="config[url]" value="' . $plugin->getConfig('url') . '"/>'; $formElements[] = $n; $fragment = new rex_fragment(); $fragment->setVar('elements', $formElements, false); $content .= $fragment->parse('core/form/form.php'); $content .= ' </fieldset> <fieldset class="rex-form-action">'; $formElements = []; $n = []; $n['field'] = '<div class="btn-toolbar"><button id="rex-out5-wartungsarbeiten-save" type="submit" name="config-submit" class="btn btn-save rex-form-aligned" value="1">Einstellungen speichern</button></div>'; $formElements[] = $n; $fragment = new rex_fragment(); $fragment->setVar('elements', $formElements, false); $content .= $fragment->parse('core/form/submit.php');
$yform->setObjectparams('form_showformafterupdate', 1); $yform->setHiddenField('page', $page); $yform->setValueField('select', array('table_name', rex_i18n::msg('yform_table'), $missing_tables)); $yform->setValueField('checkbox', array('convert_id', rex_i18n::msg('yform_manager_migrate_table_id_convert'))); $form = $yform->getForm(); if ($yform->objparams['actions_executed']) { $table_name = $yform->objparams['value_pool']['sql']['table_name']; $convert_id = $yform->objparams['value_pool']['sql']['convert_id']; try { rex_yform_manager_table_api::migrateTable($table_name, $convert_id); // with convert id / auto_increment finder echo rex_view::success(rex_i18n::msg('yform_manager_table_migrated_success')); unset($missing_tables[$table_name]); $yform = new rex_yform(); $yform->setObjectparams('form_showformafterupdate', 1); $yform->setHiddenField('page', $page); $yform->setValueField('select', array('table_name', rex_i18n::msg('yform_table'), $missing_tables)); $yform->setValueField('checkbox', array('convert_id', rex_i18n::msg('yform_manager_migrate_table_id_convert'))); $form = $yform->getForm(); } catch (Exception $e) { echo rex_view::warning(rex_i18n::msg('yform_manager_table_migrated_failed', $table_name, $e->getMessage())); } } echo rex_view::info(rex_i18n::msg('yform_manager_table_migrate_info')); $fragment = new rex_fragment(); $fragment->setVar('class', 'edit', false); $fragment->setVar('title', rex_i18n::msg('yform_manager_table_migrate')); $fragment->setVar('body', $form, false); // $fragment->setVar('buttons', $buttons, false); $form = $fragment->parse('core/page/section.php'); echo $form;
$error = ''; } elseif ($error != '') { echo rex_view::error($error); $error = ''; } if (is_array($success)) { if (count($success) > 0) { echo rex_view::success(implode('<br />', $success)); } $success = ''; } elseif ($success != '') { echo rex_view::success($success); $success = ''; } if (!empty($args['types'])) { echo rex_view::info(rex_i18n::msg('pool_file_filter') . ' <code>' . $args['types'] . '</code>'); } //deletefilelist und cat change $panel = ' <form action="' . rex_url::currentBackendPage() . '" method="post" enctype="multipart/form-data"> <fieldset> <input type="hidden" id="media_method" name="media_method" value="" /> ' . $arg_fields . ' <table class="table table-striped table-hover"> <thead> <tr> <th class="rex-table-icon"><a href="' . rex_url::backendController(['page' => 'mediapool/upload']) . '"' . rex::getAccesskey(rex_i18n::msg('pool_file_insert'), 'add') . ' title="' . rex_i18n::msg('pool_file_insert') . '"><i class="rex-icon rex-icon-add-media"></i></a></th> <th class="rex-table-thumbnail">' . rex_i18n::msg('pool_file_thumbnail') . '</th> <th>' . rex_i18n::msg('pool_file_info') . ' / ' . rex_i18n::msg('pool_file_description') . '</th>
if (($sql->getValue('postsavemode') & $var) == $var) { $postsavemode[] = $value; } } $content .= ' <tr> <td class="rex-table-icon"><a href="' . rex_url::currentBackendPage(['action_id' => $sql->getValue('id'), 'function' => 'edit']) . '" title="' . htmlspecialchars($sql->getValue('name')) . '"><i class="rex-icon rex-icon-action"></i></a></td> <td class="rex-table-id" data-title="' . rex_i18n::msg('id') . '">' . $sql->getValue('id') . '</td> <td data-title="' . rex_i18n::msg('action_name') . '"><a href="' . rex_url::currentBackendPage(['action_id' => $sql->getValue('id'), 'function' => 'edit']) . '">' . htmlspecialchars($sql->getValue('name')) . '</a></td> <td data-title="' . rex_i18n::msg('action_header_preview') . '">' . implode('/', $previewmode) . '</td> <td data-title="' . rex_i18n::msg('action_header_presave') . '">' . implode('/', $presavemode) . '</td> <td data-title="' . rex_i18n::msg('action_header_postsave') . '">' . implode('/', $postsavemode) . '</td> <td class="rex-table-action"><a href="' . rex_url::currentBackendPage(['action_id' => $sql->getValue('id'), 'function' => 'edit']) . '"><i class="rex-icon rex-icon-edit"></i> ' . rex_i18n::msg('change') . '</a></td> <td class="rex-table-action"><a href="' . rex_url::currentBackendPage(['action_id' => $sql->getValue('id'), 'function' => 'delete']) . '" data-confirm="' . rex_i18n::msg('action_delete') . ' ?"><i class="rex-icon rex-icon-delete"></i> ' . rex_i18n::msg('delete') . '</a></td> </tr> '; $sql->next(); } $content .= '</tbody>' . "\n"; } $content .= ' </table>'; if ($rows < 1) { $content .= rex_view::info(rex_i18n::msg('actions_not_found')); } echo $message; $fragment = new rex_fragment(); $fragment->setVar('title', rex_i18n::msg('action_caption'), false); $fragment->setVar('content', $content, false); echo $fragment->parse('core/page/section.php'); }
/** * @param rex_context $context * * @return string * * @package redaxo\structure */ function rex_structure_searchbar(rex_context $context) { $message = ''; $search_result = ''; // ------------ Parameter $clang = $context->getParam('clang', 1); $category_id = $context->getParam('category_id', 0); $article_id = $context->getParam('article_id', 0); $search_article_name = rex_request('search_article_name', 'string'); // ------------ Suche via ArtikelId if (preg_match('/^[0-9]+$/', $search_article_name, $matches)) { if ($OOArt = rex_article::get($matches[0], $clang)) { rex_response::sendRedirect($context->getUrl(['page' => 'content/edit', 'article_id' => $OOArt->getId()], false)); } } // Auswahl eines normalen Artikels => category holen if ($article_id != 0) { $OOArt = rex_article::get($article_id, $clang); // Falls Artikel gerade geloescht wird, gibts keinen rex_article if ($OOArt) { $category_id = $OOArt->getCategoryId(); } } // ------------ Suche via ArtikelName if (rex_request('search_start', 'bool')) { // replace LIKE wildcards $search_article_name_like = str_replace(['_', '%'], ['\\_', '\\%'], $search_article_name); $qry = ' SELECT id FROM ' . rex::getTablePrefix() . 'article WHERE clang_id = ' . $clang . ' AND ( name LIKE "%' . $search_article_name_like . '%" OR catname LIKE "%' . $search_article_name_like . '%" )'; if (rex_addon::get('structure')->getConfig('searchmode', 'local') != 'global') { // Suche auf aktuellen Kontext eingrenzen if ($category_id != 0) { $qry .= ' AND path LIKE "%|' . $category_id . '|%"'; } } $search = rex_sql::factory(); // $search->setDebug(); $search->setQuery($qry); $foundRows = $search->getRows(); // Suche ergab nur einen Treffer => Direkt auf den Treffer weiterleiten if ($foundRows == 1) { $OOArt = rex_article::get($search->getValue('id'), $clang); if (rex::getUser()->getComplexPerm('structure')->hasCategoryPerm($OOArt->getCategoryId())) { rex_response::sendRedirect($context->getUrl(['page' => 'content/edit', 'article_id' => $search->getValue('id')], false)); } } elseif ($foundRows > 0) { $needle = htmlspecialchars($search_article_name); $search_result .= '<div class="list-group">'; for ($i = 0; $i < $foundRows; ++$i) { $breadcrumb = []; $OOArt = rex_article::get($search->getValue('id'), $clang); $label = $OOArt->getName(); if (rex::getUser()->getComplexPerm('structure')->hasCategoryPerm($OOArt->getCategoryId())) { $label .= ' [' . $search->getValue('id') . ']'; $highlightHit = function ($string, $needle) { return preg_replace('/(.*)(' . preg_quote($needle, '/') . ')(.*)/i', '\\1<mark>\\2</mark>\\3', $string); }; foreach ($OOArt->getParentTree() as $treeItem) { $treeLabel = $treeItem->getName(); if (rex::getUser()->hasPerm('advancedMode[]')) { $treeLabel .= ' [' . $treeItem->getId() . ']'; } $treeLabel = htmlspecialchars($treeLabel); $treeLabel = $highlightHit($treeLabel, $needle); $e = []; $e['title'] = $treeLabel; $e['href'] = $context->getUrl(['page' => 'structure', 'category_id' => $treeItem->getId()]); $breadcrumb[] = $e; } $label = htmlspecialchars($label); $label = $highlightHit($label, $needle); $e = []; $e['title'] = $label; $e['href'] = $context->getUrl(['page' => 'content/edit', 'article_id' => $treeItem->getId()]); $breadcrumb[] = $e; $fragment = new rex_fragment(); $fragment->setVar('items', $breadcrumb, false); $search_result .= '<div class="list-group-item">' . $fragment->parse('core/navigations/breadcrumb.php') . '</div>'; } $search->next(); } $search_result .= '</div>'; $fragment = new rex_fragment(); $fragment->setVar('title', rex_i18n::msg('be_search_result'), false); $fragment->setVar('content', $search_result, false); $search_result = $fragment->parse('core/page/section.php'); } else { $message = rex_view::info(rex_i18n::msg('be_search_no_results')); } } $select_name = 'category_id'; $add_homepage = true; if (rex_be_controller::getCurrentPagePart(1) == 'content') { $select_name = 'article_id'; $add_homepage = false; } $category_select = new rex_category_select(false, false, true, $add_homepage); $category_select->setName($select_name); $category_select->setSize('1'); $category_select->setAttribute('onchange', 'this.form.submit();'); $category_select->setSelected($category_id); $select = $category_select->get(); $doc = new DOMDocument(); $doc->loadHTML('<?xml encoding="UTF-8">' . $select); $options = $doc->getElementsByTagName('option'); $droplistContext = new rex_context(['page' => 'structure', 'category_id' => 0]); $button_label = ''; $items = []; foreach ($options as $option) { $value = ''; $item = []; if ($option->hasAttributes()) { foreach ($option->attributes as $attribute) { if ($attribute->name == 'value') { $value = $attribute->value; $droplistContext->setParam('category_id', $value); if ($attribute->value == $category_id) { $button_label = str_replace(" ", '', $option->nodeValue); $item['active'] = true; } } } } $item['title'] = preg_replace('/\\[([0-9]+)\\]$/', '<small class="rex-primary-id">$1</small>', $option->nodeValue); $item['href'] = $droplistContext->getUrl(); $items[] = $item; } $fragment = new rex_fragment(); $fragment->setVar('button_prefix', rex_i18n::msg('be_search_quick_navi')); $fragment->setVar('button_label', $button_label); $fragment->setVar('items', $items, false); $droplist = '<div class="navbar-btn navbar-right">' . $fragment->parse('core/dropdowns/dropdown.php'); $formElements = []; $n = []; $n['field'] = '<input class="form-control" type="text" name="search_article_name" value="' . htmlspecialchars($search_article_name) . '" placeholder="' . htmlspecialchars(rex_i18n::msg('be_search_article_name') . '/' . rex_i18n::msg('be_search_article_id')) . '" />'; $n['right'] = '<button class="btn btn-search" type="submit" name="search_start" value="1">' . rex_i18n::msg('be_search_start') . '</button>'; $formElements[] = $n; $fragment = new rex_fragment(); $fragment->setVar('elements', $formElements, false); $toolbar = $fragment->parse('core/form/input_group.php'); $toolbar = ' <form action="' . rex_url::currentBackendPage() . '" method="post"> ' . $context->getHiddenInputFields() . ' <div class="navbar-form navbar-left"> <div class="form-group"> ' . $toolbar . ' </div> </div> </form>'; $toolbar = rex_view::toolbar($toolbar . $droplist, rex_i18n::msg('be_search_search')); return $toolbar . $search_result; }
$out = rex_get_file_contents($REX['INCLUDE_PATH'] . '/addons/yform/plugins/setup/module/module_out.inc'); $mi = rex_sql::factory(); // $mi->debugsql = 1; $mi->setTable('rex_module'); $mi->setValue('eingabe', addslashes($in)); $mi->setValue('ausgabe', addslashes($out)); if (isset($_REQUEST['module_id']) && $module_id == $_REQUEST['module_id']) { $mi->setWhere('id="' . $module_id . '"'); $mi->update(); echo rex_view::info('Modul "' . $module_name . '" wurde aktualisiert'); } else { $mi->setValue('name', $yform_module_name); $mi->insert(); $module_id = (int) $mi->getLastId(); $module_name = $yform_module_name; echo rex_view::info('yform Modul wurde angelegt unter "' . $yform_module_name . '"'); } } echo ' <div class="rex-addon-output"> <h2 class="rex-hl2">' . rex_i18n::msg('yform_setup_install_modul') . '</h2> <div class="rex-addon-content"> <p>' . rex_i18n::msg('yform_setup_install_modul_description') . '</p> <p class="rex-button"><a href="index.php?page=yform&subpage=setup&install=1" class="rex-button">' . rex_i18n::msg('yform_setup_install_yform_modul') . '</a></p>'; if ($module_id > 0) { echo '<p class="rex-button"><a href="index.php?page=yform&subpage=setup&install=1&module_id=' . $module_id . '" class="rex-button">' . rex_i18n::msg('yform_setup_update_following_modul', htmlspecialchars($module_name)) . '</a></p>'; } echo ' </div>
$error = $i->getError(); if ($error == '') { $icounter++; } else { $dcounter++; echo rex_view::warning(rex_i18n::msg('yform_manager_import_error_dataimport', $error)); } } } } $show_list = true; } rex_extension::registerPoint(new rex_extension_point('yform_DATASET_IMPORTED', '', array('divider' => $div, 'table' => $this->table, 'filename' => $filename, 'replacefield' => $replacefield, 'missing_columns' => $missing_columns, 'debug' => $debug, 'data_imported' => $counter, 'data_not_imported' => $dcounter, 'data_empty_rows' => $ecounter, 'data_replaced' => $rcounter, 'data_inserted' => $icounter, 'data_errors' => $errorcounter))); echo rex_view::info(rex_i18n::msg('yform_manager_import_error_dataimport', $icounter + $rcounter, $icounter, $rcounter)); } else { echo rex_view::info(rex_i18n::msg('yform_manager_import_error_not_started')); } if ($dcounter > 0) { echo rex_view::warning(rex_i18n::msg('yform_manager_import_info_data_imported', $dcounter)); } } } if ($show_importform) { ?> <div class="rex-addon-output"><h3 class="rex-hl2"><?php echo rex_i18n::msg('yform_manager_import_csv'); ?> </h3><div class="rex-addon-content"><div id="rex-yform-import" class="yform"> <form action="index.php" method="post" enctype="multipart/form-data">
} $sel_startpage->setSelected($userperm_startpage); if ($adduser->getRows()) { $warnings[] = rex_i18n::msg('user_login_exists'); } if (!$userlogin) { $warnings[] = rex_i18n::msg('user_missing_login'); } if (!$userpsw) { $warnings[] = rex_i18n::msg('user_missing_password'); } } } // ---------------------------------- ERR MSG if ($info != '') { $message .= rex_view::info($info); } if (!empty($warnings)) { $message .= rex_view::warning(implode('<br/>', $warnings)); } // --------------------------------- FORMS $SHOW = true; if ($FUNC_ADD != '' || $user_id > 0) { $SHOW = false; if ($FUNC_ADD != '') { $statuschecked = 'checked="checked"'; } $buttons = ''; if ($user_id > 0) { // User Edit $form_label = rex_i18n::msg('edit_user');
/** * @package redaxo5 */ echo rex_view::title(rex_i18n::msg('addons'), ''); $content = ''; // -------------- RequestVars $subpage = rex_request('subpage', 'string'); // ----------------- HELPPAGE if ($subpage == 'help') { $package = rex_package::get(rex_request('package', 'string')); $name = $package->getPackageId(); $version = $package->getVersion(); $author = $package->getAuthor(); $supportPage = $package->getSupportPage(); if (!is_file($package->getPath('help.php'))) { $content .= rex_view::info(rex_i18n::msg('package_no_help_file')); } else { ob_start(); $package->includeFile('help.php'); $content .= ob_get_clean(); } $fragment = new rex_fragment(); $fragment->setVar('title', rex_i18n::msg('package_help') . ' ' . $name, false); $fragment->setVar('body', $content, false); echo $fragment->parse('core/page/section.php'); $credits = ''; $credits .= '<dl class="dl-horizontal">'; $credits .= '<dt>' . rex_i18n::msg('credits_name') . '</dt><dd>' . htmlspecialchars($name) . '</dd>'; if ($version) { $credits .= '<dt>' . rex_i18n::msg('credits_version') . '</dt><dd>' . $version . '</dd>'; }
<?php /** * Media Manager Addon. * * @author office[at]vscope[dot]at Wolfgang Hutteger * @author markus.staab[at]redaxo[dot]de Markus Staab * @author jan.kristinus[at]yakmara[dot]de Jan Kristinus * @author dh[at]daveholloway[dot]co[dot]uk Dave Holloway * * @package redaxo5 */ $subpage = rex_be_controller::getCurrentPagePart(2); $func = rex_request('func', 'string'); echo rex_view::title(rex_i18n::msg('media_manager')); if ($func == 'clear_cache') { $c = rex_media_manager::deleteCache(); echo rex_view::info(rex_i18n::msg('media_manager_cache_files_removed', $c)); $func = ''; } include rex_be_controller::getCurrentPageObject()->getSubPath();
/** * This file is part of the Sprog package. * * @author (c) Thomas Blum <*****@*****.**> * * For the full copyright and license information, please view the LICENSE * file that was distributed with this source code. */ namespace Sprog; $content = ''; $func = rex_request('func', 'string'); if ($func == 'update') { // clang_switch wird in der boot.php neu gesetzt echo \rex_view::info($this->i18n('settings_config_saved')); \rex_config::set('sprog', 'wildcard_open_tag', rex_request('open_tag', 'string')); \rex_config::set('sprog', 'wildcard_close_tag', rex_request('close_tag', 'string')); } $content .= ' <fieldset> <input type="hidden" name="func" value="update" /> '; $formElements = []; $n = []; $n['label'] = '<label for="wildcard-open-tag">' . $this->i18n('settings_wildcard_open_tag') . '</label>'; $n['field'] = '<input class="form-control" type="text" id="wildcard-open-tag" name="open_tag" value="' . htmlspecialchars(Wildcard::getOpenTag()) . '" />'; $formElements[] = $n; $n = []; $n['label'] = '<label for="wildcard-close-tag">' . $this->i18n('settings_wildcard_close_tag') . '</label>'; $n['field'] = '<input class="form-control" type="text" id="wildcard-close-tag" name="close_tag" value="' . htmlspecialchars(Wildcard::getCloseTag()) . '" />';
<?php echo rex_view::info($this->i18n('default_text'));
* @package redaxo5 * * @var rex_addon $this */ // rex_request(); $content = ''; $func = rex_request('func', 'string'); $jpg_quality = rex_request('jpg_quality', 'int'); if ($func == 'update') { if ($jpg_quality > 100) { $jpg_quality = 100; } elseif ($jpg_quality < 0) { $jpg_quality = 0; } $this->setConfig('jpg_quality', $jpg_quality); echo rex_view::info($this->i18n('config_saved')); } $inputGroups = []; $n = []; $n['class'] = 'rex-range-input-group'; $n['left'] = '<input id="rex-js-rating-source-jpg-quality" type="range" min="0" max="100" step="1" value="' . htmlspecialchars($this->getConfig('jpg_quality')) . '" />'; $n['field'] = '<input class="form-control" id="rex-js-rating-text-jpg-quality" type="text" id="rex-jpg-quality" name="jpg_quality" value="' . htmlspecialchars($this->getConfig('jpg_quality')) . '" />'; $n['right'] = '%'; $inputGroups[] = $n; $fragment = new rex_fragment(); $fragment->setVar('elements', $inputGroups, false); $inputGroup = $fragment->parse('core/form/input_group.php'); $formElements = []; $n = []; $n['label'] = '<label for="rex-js-rating-text-jpg-quality">' . $this->i18n('jpg_quality') . ' [0-100]</label>'; $n['field'] = $inputGroup;
/** * yform * @author jan.kristinus[at]redaxo[dot]org Jan Kristinus * @author <a href="http://www.yakamara.de">www.yakamara.de</a> */ echo rex_view::title(rex_i18n::msg('yform_email_templates')); $table = rex::getTablePrefix() . 'yform_email_template'; $bezeichner = rex_i18n::msg('yform_email_template'); $csuchfelder = array('name', 'mail_from', 'mail_subject', 'body'); $func = rex_request('func', 'string', ''); $page = rex_request('page', 'string', ''); $template_id = rex_request('template_id', 'int'); $content = ''; $show_list = true; if ($func == 'edit' || $func == 'add') { echo rex_view::info(rex_i18n::rawMsg('yform_email_info_text')); $form_data = []; $form_data[] = 'text|name|translate:yform_email_key'; $form_data[] = 'validate|empty|name|Bitte key eintragen'; $form_data[] = 'text|mail_from|translate:yform_email_from'; $form_data[] = 'text|mail_from_name|translate:yform_email_from_name'; $form_data[] = 'text|subject|translate:yform_email_subject'; $form_data[] = 'textarea|body|translate:yform_email_body'; $form_data[] = 'textarea|body_html|translate:yform_email_body_html'; $form_data[] = 'be_medialist|attachments|translate:yform_email_attachments'; $form_data[] = 'action|showtext|Vielen Dank|||1'; $yform = rex_yform::factory(); $yform->setObjectparams('form_action', 'index.php?page=yform/email/index&func=' . $func); $yform->setFormData(implode("\n", $form_data)); if ($func == 'edit') { $yform->setObjectparams('submit_btn_label', rex_i18n::msg('yform_save'));
function rex_yform_hidden_col($params) { $list = $params['list']; return $list->getValue('hidden') == 1 ? '<span style="color:grey;">' . rex_i18n::msg('yform_hidden') . '</span>' : '<span>' . rex_i18n::msg('yform_visible') . '</span>'; } function rex_yform_list_translate($params) { return rex_i18n::translate($params['subject']); } $table_echo = '<p><b>'; $table_echo .= rex_i18n::msg('yform_manager_table') . ': <a href=index.php?page=' . $page . '&func=add>' . rex_i18n::msg('yform_manager_create') . '</a>'; $table_echo .= ' | <a href=index.php?page=' . $page . '&func=migrate><b>' . rex_i18n::msg('yform_manager_migrate') . '</a>'; $table_echo .= ' ' . rex_i18n::msg('yform_manager_tableset') . ':</b> <a href=index.php?page=' . $page . '&func=tableset_export>' . rex_i18n::msg('yform_manager_export') . '</a>'; $table_echo .= ' | <a href=index.php?page=' . $page . '&func=tableset_import>' . rex_i18n::msg('yform_manager_import') . '</a>'; $table_echo .= '</b></p>'; echo rex_view::info($table_echo); $sql = 'select id, prio, name, table_name, status, hidden from `' . rex_yform_manager_table::table() . '` order by prio,table_name'; $list = rex_list::factory($sql); $list->addParam('start', rex_request('start', 'int')); $list->removeColumn('id'); $list->setColumnLabel('prio', rex_i18n::msg('yform_manager_table_prio_short')); $list->setColumnLabel('name', rex_i18n::msg('yform_manager_name')); $list->setColumnFormat('name', 'custom', 'rex_yform_list_translate'); $list->setColumnLabel('table_name', rex_i18n::msg('yform_manager_table_name')); $list->setColumnParams('table_name', array('table_id' => '###id###', 'func' => 'edit')); $list->setColumnLabel('status', rex_i18n::msg('yform_manager_table_status')); $list->setColumnFormat('status', 'custom', 'rex_yform_status_col'); $list->setColumnLabel('hidden', rex_i18n::msg('yform_manager_table_hidden')); $list->setColumnFormat('hidden', 'custom', 'rex_yform_hidden_col'); $list->addColumn(rex_i18n::msg('yform_edit'), rex_i18n::msg('yform_edit')); $list->setColumnParams(rex_i18n::msg('yform_edit'), array('table_id' => '###id###', 'func' => 'edit'));
} } $sel_lang = new rex_select(); $sel_lang->setStyle('class="form-control"'); $sel_lang->setName('settings[lang]'); $sel_lang->setId('rex-id-lang'); $sel_lang->setSize(1); $sel_lang->setSelected(rex::getProperty('lang')); foreach (rex_i18n::getLocales() as $l) { $sel_lang->addOption($l, $l); } if (!empty($error)) { echo rex_view::error(implode('<br />', $error)); } if ($info != '') { echo rex_view::info($info); } if ($success != '') { echo rex_view::success($success); } $dbconfig = rex::getProperty('db'); $version = rex_path::src(); if (strlen($version) > 21) { $version = substr($version, 0, 8) . '..' . substr($version, strlen($version) - 13); } $content = []; $content[] = ' <h3>' . rex_i18n::msg('delete_cache') . '</h3> <p>' . rex_i18n::msg('delete_cache_description') . '</p> <p><a class="btn btn-delete" href="' . rex_url::currentBackendPage(['func' => 'generate']) . '">' . rex_i18n::msg('delete_cache') . '</a></p>
/** * Erstellt den Tabellen Quellcode. * * @return string */ public function get() { $s = "\n"; // Form vars $this->addFormAttribute('action', $this->getUrl()); $this->addFormAttribute('method', 'post'); // Table vars $caption = $this->getCaption(); $tableColumnGroups = $this->getTableColumnGroups(); $class = 'table'; if (isset($this->tableAttributes['class'])) { $class .= ' ' . $this->tableAttributes['class']; } $this->addTableAttribute('class', $class); // Columns vars $columnFormates = []; $columnNames = []; foreach ($this->getColumnNames() as $columnName) { if (!in_array($columnName, $this->columnDisabled)) { $columnNames[] = $columnName; } } // List vars $sortColumn = $this->getSortColumn(); $sortType = $this->getSortType(); $warning = $this->getWarning(); $message = $this->getMessage(); $nbRows = $this->getRows(); $header = $this->getHeader(); $footer = $this->getFooter(); if ($warning != '') { $s .= rex_view::warning($warning) . "\n"; } elseif ($message != '') { $s .= rex_view::info($message) . "\n"; } if ($header != '') { $s .= $header . "\n"; } $s .= '<form' . $this->_getAttributeString($this->getFormAttributes()) . '>' . "\n"; $s .= ' <table' . $this->_getAttributeString($this->getTableAttributes()) . '>' . "\n"; if ($caption != '') { $s .= ' <caption>' . htmlspecialchars($caption) . '</caption>' . "\n"; } if (count($tableColumnGroups) > 0) { foreach ($tableColumnGroups as $tableColumnGroup) { $tableColumns = $tableColumnGroup['columns']; unset($tableColumnGroup['columns']); $s .= ' <colgroup' . $this->_getAttributeString($tableColumnGroup) . '>' . "\n"; foreach ($tableColumns as $tableColumn) { $s .= ' <col' . $this->_getAttributeString($tableColumn) . ' />' . "\n"; } $s .= ' </colgroup>' . "\n"; } } $s .= ' <thead>' . "\n"; $s .= ' <tr>' . "\n"; foreach ($columnNames as $columnName) { $columnHead = $this->getColumnLabel($columnName); if ($this->hasColumnOption($columnName, REX_LIST_OPT_SORT)) { if ($columnName == $sortColumn) { $columnSortType = $sortType == 'desc' ? 'asc' : 'desc'; } else { $columnSortType = $this->getColumnOption($columnName, REX_LIST_OPT_SORT_DIRECTION, 'asc'); } $columnHead = '<a href="' . $this->getUrl(['start' => $this->pager->getCursor(), 'sort' => $columnName, 'sorttype' => $columnSortType]) . '">' . $columnHead . '</a>'; } $layout = $this->getColumnLayout($columnName); $s .= ' ' . str_replace('###VALUE###', $columnHead, $layout[0]) . "\n"; // Formatierungen hier holen, da diese Schleife jede Spalte nur einmal durchläuft $columnFormates[$columnName] = $this->getColumnFormat($columnName); } $s .= ' </tr>' . "\n"; $s .= ' </thead>' . "\n"; if ($footer != '') { $s .= ' <tfoot>' . "\n"; $s .= $footer; $s .= ' </tfoot>' . "\n"; } if ($nbRows > 0) { $maxRows = $nbRows - $this->pager->getCursor(); $s .= ' <tbody>' . "\n"; for ($i = 0; $i < $this->pager->getRowsPerPage() && $i < $maxRows; ++$i) { $s .= ' <tr>' . "\n"; foreach ($columnNames as $columnName) { $columnValue = $this->formatValue($this->getValue($columnName), $columnFormates[$columnName], !isset($this->customColumns[$columnName]), $columnName); if (!$this->isCustomFormat($columnFormates[$columnName]) && $this->hasColumnParams($columnName)) { $columnValue = $this->getColumnLink($columnName, $columnValue); } $layout = $this->getColumnLayout($columnName); $columnValue = str_replace('###VALUE###', $columnValue, $layout[1]); $columnValue = $this->replaceVariables($columnValue); $s .= ' ' . $columnValue . "\n"; } $s .= ' </tr>' . "\n"; $this->sql->next(); } $s .= ' </tbody>' . "\n"; } else { $s .= '<tr class="table-no-results"><td colspan="' . count($columnNames) . '">' . $this->getNoRowsMessage() . '</td></tr>'; } $s .= ' </table>' . "\n"; $s .= '</form>' . "\n"; return $s; }
/** * @return string */ public function get() { $this->init(); $this->setApplyUrl($this->getUrl(['func' => ''], false)); if (($controlElement = $this->getControlElement()) !== null) { if ($controlElement->saved()) { $this->processPostValues(); // speichern und umleiten // Nachricht in der Liste anzeigen if (($result = $this->validate()) === true && ($result = $this->save()) === true) { $this->redirect(rex_i18n::msg('form_saved')); } elseif (is_int($result) && isset($this->errorMessages[$result])) { $this->setWarning($this->errorMessages[$result]); } elseif (is_string($result) && $result != '') { $this->setWarning($result); } else { $this->setWarning(rex_i18n::msg('form_save_error')); } } elseif ($controlElement->applied()) { $this->processPostValues(); // speichern und wiederanzeigen // Nachricht im Formular anzeigen if (($result = $this->validate()) === true && ($result = $this->save()) === true) { $this->setMessage(rex_i18n::msg('form_applied')); } elseif (is_int($result) && isset($this->errorMessages[$result])) { $this->setWarning($this->errorMessages[$result]); } elseif (is_string($result) && $result != '') { $this->setWarning($result); } else { $this->setWarning(rex_i18n::msg('form_save_error')); } } elseif ($controlElement->deleted()) { // speichern und wiederanzeigen // Nachricht in der Liste anzeigen if (($result = $this->delete()) === true) { $this->redirect(rex_i18n::msg('form_deleted')); } elseif (is_string($result) && $result != '') { $this->setWarning($result); } else { $this->setWarning(rex_i18n::msg('form_delete_error')); } } elseif ($controlElement->resetted()) { // verwerfen und wiederanzeigen // Nachricht im Formular anzeigen $this->setMessage(rex_i18n::msg('form_resetted')); } elseif ($controlElement->aborted()) { // verwerfen und umleiten // Nachricht in der Liste anzeigen $this->redirect(rex_i18n::msg('form_resetted')); } } $actionParams = []; if ('get' == strtolower($this->method)) { // Parameter dem Formular hinzufügen foreach ($this->getParams() as $name => $value) { $this->addHiddenField($name, $value, ['internal::useArraySyntax' => 'none']); } } else { $actionParams = $this->getParams(); } $s = "\n"; $warning = $this->getWarning(); $message = $this->getMessage(); if ($warning != '') { $s .= ' ' . rex_view::warning($warning) . "\n"; } elseif ($message != '') { $s .= ' ' . rex_view::info($message) . "\n"; } $i = 0; $addHeaders = true; $fieldsets = $this->getFieldsetElements(); $last = count($fieldsets); $s .= '<form id="' . $this->divId . '" action="' . rex_url::backendController($actionParams) . '" method="' . $this->method . '">' . "\n"; foreach ($fieldsets as $fieldsetName => $fieldsetElements) { $s .= '<fieldset>' . "\n"; if ($fieldsetName != '') { $s .= '<legend>' . htmlspecialchars($fieldsetName) . '</legend>' . "\n"; } // Die HeaderElemente nur im 1. Fieldset ganz am Anfang einfügen if ($i == 0 && $addHeaders) { foreach ($this->getHeaderElements() as $element) { // Callback $element->setValue($this->preView($fieldsetName, $element->getFieldName(), $element->getValue())); // HeaderElemente immer ohne <p> $s .= $element->formatElement(); } $addHeaders = false; } foreach ($fieldsetElements as $element) { // Callback $element->setValue($this->preView($fieldsetName, $element->getFieldName(), $element->getValue())); $s .= $element->get(); } // Die FooterElemente nur innerhalb des letzten Fieldsets if ($i + 1 == $last) { foreach ($this->getFooterElements() as $element) { // Callback $element->setValue($this->preView($fieldsetName, $element->getFieldName(), $element->getValue())); $s .= $element->get(); } } $s .= '</fieldset>' . "\n"; ++$i; } $s .= '</form>' . "\n"; return $s; }
try { $sql->delete(); $info = rex_i18n::msg('media_manager_effect_deleted'); } catch (rex_sql_exception $e) { $warning = $sql->getError(); } $func = ''; } if ($info != '') { echo rex_view::info($info); } if ($warning != '') { echo rex_view::warning($warning); } if ($func == '' && $type_id > 0) { echo rex_view::info(rex_i18n::msg('media_manager_effect_list_header', htmlspecialchars($typeName))); $query = 'SELECT * FROM ' . rex::getTablePrefix() . 'media_manager_type_effect WHERE type_id=' . $type_id . ' ORDER BY priority'; $list = rex_list::factory($query); $list->addTableAttribute('class', 'table-striped'); $list->addParam('effects', 1); $list->setNoRowsMessage(rex_i18n::msg('media_manager_effect_no_effects')); $list->removeColumn('id'); $list->removeColumn('type_id'); $list->removeColumn('parameters'); $list->removeColumn('updatedate'); $list->removeColumn('updateuser'); $list->removeColumn('createdate'); $list->removeColumn('createuser'); $list->setColumnLabel('effect', rex_i18n::msg('media_manager_type_name')); $list->setColumnLabel('priority', rex_i18n::msg('media_manager_type_priority')); $list->setColumnLayout('priority', ['<th class="rex-table-priority">###VALUE###</th>', '<td class="rex-table-priority">###VALUE###</td>']);
function getFieldPage() { // ********************************************* FIELD ADD/EDIT/LIST $func = rex_request('func', 'string', 'list'); $type_id = rex_request('type_id', 'string'); $type_name = rex_request('type_name', 'string'); $field_id = rex_request('field_id', 'int'); $link_vars = ''; foreach ($this->getLinkVars() as $k => $v) { $link_vars .= '&' . urlencode($k) . '=' . urlencode($v); } $TYPE = array('value' => rex_i18n::msg('yform_values'), 'validate' => rex_i18n::msg('yform_validates'), 'action' => rex_i18n::msg('yform_action')); // ********************************** TABELLE HOLEN $table = $this->table; $table_info = '<b>' . rex_i18n::translate($table->getName()) . ' [' . $table->getTableName() . ']</b> '; echo rex_view::info($table_info); // ********************************************* Missing Fields $mfields = $table->getMissingFields(); // ksort($mfields); $type_real_field = rex_request('type_real_field', 'string'); if ($type_real_field != '' && !array_key_exists($type_real_field, $mfields)) { $type_real_field = ''; } if ($type_real_field != '') { $panel = ''; $panel .= '<dl class="dl-horizontal text-left">'; $rfields = $this->table->getColumns(); foreach ($rfields[$type_real_field] as $k => $v) { $panel .= '<dt>' . ucfirst($k) . ':</dt><dd>' . $v . '</dd>'; } $panel .= '</dl>'; $fragment = new rex_fragment(); $fragment->setVar('class', 'info'); $fragment->setVar('title', 'Folgendes Feld wird verwendet: ' . $type_real_field); $fragment->setVar('body', $panel, false); echo $fragment->parse('core/page/section.php'); } // ********************************************* CHOOSE FIELD $types = rex_yform::getTypeArray(); if ($func == 'choosenadd') { $link = 'index.php?' . $link_vars . '&table_name=' . $table->getTableName() . '&func=add&'; $content = []; $panels = []; if (!$table->hasId()) { $content[] = rex_i18n::msg('yform_id_is_missing') . '' . rex_i18n::msg('yform_id_missing_info'); } else { if ($type_real_field == '' && count($mfields) > 0) { $tmp = ''; $d = 0; foreach ($mfields as $k => $v) { $d++; $l = 'index.php?' . $link_vars . '&table_name=' . $table->getTableName() . '&func=choosenadd&type_real_field=' . $k . '&type_layout=t'; $tmp .= '<a class="btn btn-default" href="' . $l . '">' . $k . '</a> '; } $fragment = new rex_fragment(); $fragment->setVar('class', 'info'); $fragment->setVar('title', 'Es gibt noch Felder in der Tabelle welche nicht zugewiesen sind.'); $fragment->setVar('body', $tmp, false); echo $fragment->parse('core/page/section.php'); } $tmp = ''; if (isset($types['value'])) { ksort($types['value']); $tmp .= '<table class="table table-hover">'; foreach ($types['value'] as $k => $v) { $tmp .= '<tr><th><a class="btn btn-default btn-block" href="' . $link . 'type_id=value&type_name=' . $k . '&type_real_field=' . $type_real_field . '"><code>' . $k . '</code></a></th><td class="vertical-middle">' . $v['description'] . '</td></tr>'; } $tmp .= '</table>'; } $fragment = new rex_fragment(); $fragment->setVar('title', $TYPE['value']); $fragment->setVar('content', $tmp, false); $panels[] = $fragment->parse('core/page/section.php'); $tmp = ''; if (isset($types['validate'])) { ksort($types['validate']); $tmp .= '<table class="table table-hover">'; foreach ($types['validate'] as $k => $v) { $tmp .= '<tr><th><a class="btn btn-default btn-block" href="' . $link . 'type_id=validate&type_name=' . $k . '"><code>' . $k . '</code></a></th><td class="vertical-middle">' . $v['description'] . '</td></tr>'; } $tmp .= '</table>'; } $fragment = new rex_fragment(); $fragment->setVar('title', $TYPE['validate']); $fragment->setVar('content', $tmp, false); $panels[] = $fragment->parse('core/page/section.php'); } $fragment = new rex_fragment(); $fragment->setVar('title', rex_i18n::msg('yform_choosenadd')); $fragment->setVar('body', rex_i18n::msg('yform_choosenadd_description'), false); echo $fragment->parse('core/page/section.php'); $fragment = new rex_fragment(); $fragment->setVar('content', $panels, false); echo $fragment->parse('core/page/grid.php'); $table_echo = '<a class="btn btn-default" href="index.php?' . $link_vars . '&table_name=' . $table->getTableName() . '">' . rex_i18n::msg('yform_back_to_overview') . '</a>'; $fragment = new rex_fragment(); $fragment->setVar('footer', $table_echo, false); echo $fragment->parse('core/page/section.php'); } // ********************************************* FORMULAR if (($func == 'add' || $func == 'edit') && isset($types[$type_id][$type_name])) { $yform = new rex_yform(); $yform->setDebug(false); foreach ($this->getLinkVars() as $k => $v) { $yform->setHiddenField($k, $v); } $yform->setHiddenField('func', $func); $yform->setHiddenField('table_name', $table->getTableName()); $yform->setHiddenField('type_real_field', $type_real_field); $yform->setHiddenField('list', rex_request('list', 'string')); $yform->setHiddenField('sort', rex_request('sort', 'string')); $yform->setHiddenField('sorttype', rex_request('sorttype', 'string')); $yform->setHiddenField('start', rex_request('start', 'string')); $yform->setValueField('hidden', array('table_name', $table->getTableName())); $yform->setValueField('hidden', array('type_name', $type_name, 'REQUEST')); $yform->setValueField('hidden', array('type_id', $type_id, 'REQUEST')); $yform->setValueField('prio', array('prio', 'Prioritaet', array('name', 'type_id', 'type_name'), array('table_name'))); $selectFields = array(); $i = 1; foreach ($types[$type_id][$type_name]['values'] as $k => $v) { $field = $this->getFieldName($k, $type_id); $selectFields['f' . $i] = $field; $i++; switch ($v['type']) { case 'name': if ($func == 'edit') { $yform->setValueField('showvalue', array($field, 'Name')); } else { if (!isset($v['value']) && $type_real_field != '') { $v['value'] = $type_real_field; } elseif (!isset($v['value'])) { $v['value'] = ''; } $yform->setValueField('text', array($field, 'Name', $v['value'])); $yform->setValidateField('empty', array($field, rex_i18n::msg('yform_validatenamenotempty'))); $yform->setValidateField('preg_match', array($field, "/(([a-zA-Z])+([a-zA-Z0-9\\_])*)/", rex_i18n::msg('yform_validatenamepregmatch'))); $yform->setValidateField('customfunction', array($field, 'rex_yform_manager_checkField', array('table_name' => $table->getTableName()), rex_i18n::msg('yform_validatenamecheck'))); } break; case 'no_db': if (!isset($v['default']) || $v['default'] != 1) { $v['default'] = 0; } $yform->setValueField('checkbox', array($field, rex_i18n::msg('yform_donotsaveindb'), 'no_db', $v['default'])); break; case 'boolean': // checkbox|check_design|Bezeichnung|Value|1/0|[no_db] if (!isset($v['default'])) { $v['default'] = ''; } $yform->setValueField('checkbox', array($field, $v['label'], '', $v['default'])); break; case 'select': // select|gender|Geschlecht *|Frau=w;Herr=m|[no_db]|defaultwert|multiple=1 $yform->setValueField('select', array($field, $v['label'], $v['options'], '', $v['default'], 0)); break; case 'table': // ist fest eingetragen, damit keine Dinge durcheinandergehen if ($func == 'edit') { $yform->setValueField('showvalue', array($field, $v['label'])); } else { $_tables = rex_yform_manager_table::getAll(); $_options = array(); if (isset($v['empty_option']) && $v['empty_option']) { $_options[0] = '–='; } foreach ($_tables as $_table) { $_options[$_table['table_name']] = str_replace('=', '-', rex_i18n::translate($_table['name']) . ' [' . $_table['table_name'] . ']') . '=' . $_table['table_name']; $_options[$_table['table_name']] = str_replace(',', '.', $_options[$_table['table_name']]); } if (!isset($v['default'])) { $v['default'] = ''; } $yform->setValueField('select', array($field, $v['label'], implode(',', $_options), '', $v['default'], 0)); } break; case 'textarea': $yform->setValueField('textarea', array($field, $v['label'])); break; case 'table.field': // Todo: // Todo: case 'select_name': $_fields = array(); foreach ($table->getValueFields() as $_k => $_v) { $_fields[] = $_k; } $yform->setValueField('select', array($field, $v['label'], implode(',', $_fields), '', '', 0)); break; case 'select_names': $_fields = array(); foreach ($table->getValueFields() as $_k => $_v) { $_fields[] = $_k; } $yform->setValueField('select', array($field, $v['label'], implode(',', $_fields), '', '', 1, 5)); break; default: // nur beim "Bezeichnungsfeld" if ($field == 'label' && $type_real_field != '' && !isset($v['value'])) { $v['value'] = $type_real_field; } elseif (!isset($v['value'])) { $v['value'] = ''; } $yform->setValueField('text', array($field, $v['label'], $v['value'])); } } $yform->setActionField('showtext', array('', '<p>' . rex_i18n::msg('yform_thankyouforentry') . '</p>')); $yform->setObjectparams('main_table', rex_yform_manager_field::table()); if ($func == 'edit') { $yform->setObjectparams('submit_btn_label', rex_i18n::msg('yform_save')); $yform->setHiddenField('field_id', $field_id); $yform->setActionField('manage_db', array(rex_yform_manager_field::table(), "id={$field_id}")); $yform->setObjectparams('main_id', $field_id); $yform->setObjectparams('main_where', "id={$field_id}"); $sql = rex_sql::factory(); $sql->setQuery('SELECT * FROM ' . rex_yform_manager_field::table() . " WHERE id={$field_id}"); foreach ($selectFields as $alias => $field) { if ($alias != $field) { if ((!$sql->hasValue($field) || null === $sql->getValue($field) || '' === $sql->getValue($field)) && $sql->hasValue($alias)) { $sql->setValue($field, $sql->getValue($alias)); } $yform->setValueField('hidden', array($alias, '')); } } $yform->setObjectparams('sql_object', $sql); $yform->setObjectparams('getdata', true); } elseif ($func == 'add') { $yform->setObjectparams('submit_btn_label', rex_i18n::msg('yform_add')); $yform->setActionField('manage_db', array(rex_yform_manager_field::table())); } if ($type_id == 'value') { $yform->setValueField('checkbox', array('list_hidden', rex_i18n::msg('yform_hideinlist'), 1, '1')); $yform->setValueField('checkbox', array('search', rex_i18n::msg('yform_useassearchfieldalidatenamenotempty'), 1, '1')); } elseif ($type_id == 'validate') { $yform->setValueField('hidden', array('list_hidden', 1)); } $form = $yform->getForm(); if ($yform->objparams['form_show']) { if ($func == 'add') { $title = rex_i18n::msg('yform_addfield') . ' "' . $type_name . '"'; } else { $title = rex_i18n::msg('yform_editfield') . ' "' . $type_name . '"'; } $fragment = new rex_fragment(); $fragment->setVar('class', 'edit', false); $fragment->setVar('title', $title); $fragment->setVar('body', $form, false); // $fragment->setVar('buttons', $buttons, false); $form = $fragment->parse('core/page/section.php'); echo $form; $table_echo = '<a class="btn btn-default" href="index.php?' . $link_vars . '&table_name=' . $table->getTableName() . '">' . rex_i18n::msg('yform_back_to_overview') . '</a>'; $fragment = new rex_fragment(); $fragment->setVar('footer', $table_echo, false); echo $fragment->parse('core/page/section.php'); $func = ''; } else { if ($func == 'edit') { $this->generateAll(); echo rex_view::success(rex_i18n::msg('yform_thankyouforupdate')); } elseif ($func == 'add') { $this->generateAll(); echo rex_view::success(rex_i18n::msg('yform_thankyouforentry')); } $func = 'list'; } } // ********************************************* LOESCHEN if ($func == 'delete') { $sf = rex_sql::factory(); $sf->debugsql = self::$debug; $sf->setQuery('select * from ' . rex_yform_manager_field::table() . ' where table_name="' . $table->getTableName() . '" and id=' . $field_id); $sfa = $sf->getArray(); if (count($sfa) == 1) { $query = 'delete from ' . rex_yform_manager_field::table() . ' where table_name="' . $table->getTableName() . '" and id=' . $field_id; $delsql = rex_sql::factory(); $delsql->debugsql = self::$debug; $delsql->setQuery($query); echo rex_view::success(rex_i18n::msg('yform_tablefielddeleted')); $this->generateAll(); } else { echo rex_view::warning(rex_i18n::msg('yform_tablefieldnotfound')); } $func = 'list'; } // ********************************************* CREATE/UPDATE FIELDS if ($func == 'updatetable') { $this->generateAll(); echo rex_view::info(rex_i18n::msg('yform_tablesupdated')); $func = 'list'; } if ($func == 'updatetablewithdelete') { $this->generateAll(array('delete_fields' => true)); echo rex_view::info(rex_i18n::msg('yform_tablesupdated')); $func = 'list'; } if ($func == 'show_form_notation') { $formbuilder_fields = $table->getFields(); $notation_php = ''; $notation_pipe = ''; $notation_email = ''; $notation_php_pre = array('$yform = new rex_yform();', '$yform->setObjectparams(\'form_skin\', \'default\');', '$yform->setObjectparams(\'form_showformafterupdate\', 0);', '$yform->setObjectparams(\'real_field_names\', true);'); $notation_php .= implode("\n", $notation_php_pre) . "\n"; $notation_pipe_pre = array('objparams|form_skin|bootstrap', 'objparams|form_showformafterupdate|0', 'objparams|real_field_names|true'); $notation_pipe .= implode("\n", $notation_pipe_pre) . "\n"; foreach ($formbuilder_fields as $field) { $class = 'rex_yform_' . $field->getType() . '_' . $field->getTypeName(); $cl = new $class(); $definitions = $cl->getDefinitions(); $values = array(); $i = 1; foreach ($definitions['values'] as $key => $_) { $key = $this->getFieldName($key, $field['type_id']); if (isset($field[$key])) { $values[] = $field[$key]; } elseif (isset($field['f' . $i])) { $values[] = $field['f' . $i]; } else { $values[] = ''; } $i++; } if ($field['type_id'] == 'value') { $notation_php .= "\n" . '$yform->setValueField(\'' . $field['type_name'] . '\', array("' . rtrim(implode('","', $values), '","') . '"));'; $notation_pipe .= "\n" . $field['type_name'] . '|' . rtrim(implode('|', $values), '|') . '|'; $notation_email .= "\n" . $field['label'] . ': ###' . $field['name'] . '###'; } elseif ($field['type_id'] == 'validate') { $notation_php .= "\n" . '$yform->setValidateField(\'' . $field['type_name'] . '\', array("' . rtrim(implode('","', $values), '","') . '"));'; $notation_pipe .= "\n" . $field['type_id'] . '|' . $field['type_name'] . '|' . rtrim(implode('|', $values), '|') . '|'; } elseif ($field['type_id'] == 'action') { $notation_php .= "\n" . '$yform->setActionField(\'' . $field['type_name'] . '\', array("' . rtrim(implode('","', $values), '","') . '"));'; $notation_pipe .= "\n" . $field['type_id'] . '|' . $field['type_name'] . '|' . rtrim(implode('|', $values), '|') . '|'; } } $notation_php .= "\n\n" . '$yform->setActionField(\'email\', array(\'emailtemplate\', \'emaillabel\', \'email@domain.de\'));'; $notation_php .= "\n" . 'echo $yform->getForm();'; $notation_pipe .= "\n\n" . 'action|email|emailtemplate|emaillabel|email@domain.de'; $fragment = new rex_fragment(); $fragment->setVar('title', 'PHP'); $fragment->setVar('body', '<pre class="pre-scrollable">' . $notation_php . '</pre>', false); $content = $fragment->parse('core/page/section.php'); echo $content; $fragment = new rex_fragment(); $fragment->setVar('title', 'Pipe'); $fragment->setVar('body', '<pre class="pre-scrollable">' . $notation_pipe . '</pre>', false); $content = $fragment->parse('core/page/section.php'); echo $content; $fragment = new rex_fragment(); $fragment->setVar('title', 'E-Mail'); $fragment->setVar('body', '<pre class="pre-scrollable">' . $notation_email . '</pre>', false); $content = $fragment->parse('core/page/section.php'); echo $content; $func = 'list'; } // ********************************************* LIST if ($func == 'list') { $show_list = true; $show_list = rex_extension::registerPoint(new rex_extension_point('YFORM_MANAGER_TABLE_FIELD_FUNC', $show_list, ['table' => $table, 'link_vars' => $this->getLinkVars()])); if ($show_list) { function rex_yform_list_format($p, $value = '') { if ($value != '') { $p['value'] = $value; } switch ($p['list']->getValue('type_id')) { case 'validate': $style = 'color:#aaa;'; // background-color:#cfd9d9; break; case 'action': $style = 'background-color:#cfd9d9;'; break; default: $style = 'background-color:#eff9f9;'; break; } return '<td style="' . $style . '">' . $p['value'] . '</td>'; } function rex_yform_list_edit_format($p) { return rex_yform_list_format($p, $p['list']->getColumnLink(rex_i18n::msg('yform_function'), '<i class="rex-icon rex-icon-edit"></i> ' . rex_i18n::msg('yform_edit'))); } function rex_yform_list_delete_format($p) { return rex_yform_list_format($p, $p['list']->getColumnLink(rex_i18n::msg('yform_delete'), '<i class="rex-icon rex-icon-delete"></i> ' . rex_i18n::msg('yform_delete'))); } $context = new rex_context($this->getLinkVars()); $items = []; $item = []; $item['label'] = rex_i18n::msg('yform_manager_show_form_notation'); $item['url'] = $context->getUrl(['table_name' => $table->getTableName(), 'func' => 'show_form_notation']); $item['attributes']['class'][] = 'btn-default'; if (rex_request('func', 'string') == 'show_form_notation') { $item['attributes']['class'][] = 'active'; } $items[] = $item; $item = []; $item['label'] = rex_i18n::msg('yform_updatetable'); $item['url'] = $context->getUrl(['table_name' => $table->getTableName(), 'func' => 'updatetable']); $item['attributes']['class'][] = 'btn-default'; if (rex_request('func', 'string') == 'updatetable') { $item['attributes']['class'][] = 'active'; } $items[] = $item; $item = []; $item['label'] = rex_i18n::msg('yform_updatetable_with_delete'); $item['url'] = $context->getUrl(['table_name' => $table->getTableName(), 'func' => 'updatetablewithdelete']); $item['attributes']['class'][] = 'btn-default'; if (rex_request('func', 'string') == 'updatetablewithdelete') { $item['attributes']['class'][] = 'active'; } $item['attributes']['onclick'][] = 'return confirm(\'' . rex_i18n::msg('yform_updatetable_with_delete_confirm') . '\')'; $items[] = $item; $fragment = new rex_fragment(); $fragment->setVar('buttons', $items, false); $fragment->setVar('size', 'xs', false); $panel_options = $fragment->parse('core/buttons/button_group.php'); $sql = 'select id, prio, type_id, type_name, name from ' . rex_yform_manager_field::table() . ' where table_name="' . $table->getTableName() . '" order by prio'; $list = rex_list::factory($sql, 30); // $list->debug = 1; // $list->setColumnFormat('id', 'Id'); $tdIcon = '<i class="rex-icon rex-icon-table"></i>'; $thIcon = '<a href="' . $list->getUrl(['table_name' => $table->getTableName(), 'func' => 'choosenadd']) . '"' . rex::getAccesskey(rex_i18n::msg('add'), 'add') . '><i class="rex-icon rex-icon-add"></i></a>'; $list->addColumn($thIcon, $tdIcon, 0, ['<th class="rex-table-icon">###VALUE###</th>', '<td class="rex-table-icon">###VALUE###</td>']); $list->setColumnParams($thIcon, ['field_id' => '###id###', 'func' => 'edit', 'type_name' => '###type_name###', 'type_id' => '###type_id###']); foreach ($this->getLinkVars() as $k => $v) { $list->addParam($k, $v); } $list->addParam('start', rex_request('start', 'int')); $list->addParam('table_name', $table->getTableName()); $list->removeColumn('id'); $list->setColumnLabel('prio', rex_i18n::msg('yform_manager_table_prio_short')); //$list->setColumnLayout('prio', ['<th class="rex-table-priority">###VALUE###</th>', '<td class="rex-table-priority" data-title="' . rex_i18n::msg('yform_manager_table_prio_short') . '">###VALUE###</td>']); $list->setColumnLayout('prio', array('<th>###VALUE###</th>', '###VALUE###')); $list->setColumnFormat('prio', 'custom', 'rex_yform_list_format'); $list->setColumnLabel('type_id', rex_i18n::msg('yform_manager_type_id')); $list->setColumnLayout('type_id', array('<th>###VALUE###</th>', '###VALUE###')); $list->setColumnFormat('type_id', 'custom', 'rex_yform_list_format'); $list->setColumnLabel('type_name', rex_i18n::msg('yform_manager_type_name')); $list->setColumnLayout('type_name', array('<th>###VALUE###</th>', '###VALUE###')); $list->setColumnFormat('type_name', 'custom', 'rex_yform_list_format'); $list->setColumnLabel('name', rex_i18n::msg('yform_manager_name')); $list->setColumnLayout('name', array('<th>###VALUE###</th>', '###VALUE###')); // ###VALUE### $list->setColumnFormat('name', 'custom', 'rex_yform_list_format'); $list->addColumn(rex_i18n::msg('yform_function'), '<i class="rex-icon rex-icon-edit"></i> ' . rex_i18n::msg('yform_edit')); $list->setColumnParams(rex_i18n::msg('yform_function'), array('field_id' => '###id###', 'func' => 'edit', 'type_name' => '###type_name###', 'type_id' => '###type_id###')); $list->setColumnLayout(rex_i18n::msg('yform_function'), array('<th class="rex-table-action" colspan="2">###VALUE###</th>', '###VALUE###')); $list->setColumnFormat(rex_i18n::msg('yform_function'), 'custom', 'rex_yform_list_edit_format'); $list->addColumn(rex_i18n::msg('yform_delete'), '<i class="rex-icon rex-icon-delete"></i> ' . rex_i18n::msg('yform_delete')); $list->setColumnParams(rex_i18n::msg('yform_delete'), array('field_id' => '###id###', 'func' => 'delete')); $list->setColumnLayout(rex_i18n::msg('yform_delete'), array('', '###VALUE###')); $list->setColumnFormat(rex_i18n::msg('yform_delete'), 'custom', 'rex_yform_list_delete_format'); $list->addLinkAttribute(rex_i18n::msg('yform_delete'), 'onclick', 'return confirm(\' [###type_id###, ###type_name###, ###name###] ' . rex_i18n::msg('yform_delete') . ' ?\')'); $content = $list->get(); $fragment = new rex_fragment(); $fragment->setVar('title', rex_i18n::msg('yform_manager_tablefield_overview')); $fragment->setVar('options', $panel_options, false); $fragment->setVar('content', $content, false); $content = $fragment->parse('core/page/section.php'); echo $content; } } }
$yform->setObjectparams('main_table', $table); $yform->setFormData(implode("\n", $form_data)); $content = $yform->getForm(); $fragment = new rex_fragment(); $fragment->setVar('class', 'edit', false); $fragment->setVar('title', rex_i18n::msg('yform_email_create')); $fragment->setVar('body', $content, false); $content = $fragment->parse('core/page/section.php'); echo $content; } else { if ($func == 'delete') { $query = "delete from {$table} where id='" . $template_id . "' "; $delsql = rex_sql::factory(); $delsql->debugsql = 0; $delsql->setQuery($query); $message = rex_view::info(rex_i18n::msg('yform_email_info_template_deleted')); } } if ($show_list) { $add_sql = ' ORDER BY name'; $link = ''; $sql = "select * from {$table} " . $add_sql; $list = rex_list::factory($sql); $list->setCaption(rex_i18n::msg('yform_email_header_template_caption')); $list->addTableAttribute('summary', rex_i18n::msg('yform_email_header_template_summary')); $list->addTableAttribute('class', 'table-striped'); $list->addTableColumnGroup(array(40, 40, '*', 153, 153)); $tdIcon = '<i class="rex-icon rex-icon-template"></i>'; $thIcon = '<a href="' . $list->getUrl(['func' => 'add']) . '"' . rex::getAccesskey(rex_i18n::msg('create_template'), 'add') . ' title="' . rex_i18n::msg('create_template') . '"><i class="rex-icon rex-icon-add-template"></i></a>'; $list->addColumn($thIcon, $tdIcon, 0, ['<th class="rex-table-icon">###VALUE###</th>', '<td class="rex-table-icon">###VALUE###</td>']); $list->setColumnLabel('id', 'ID');