$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');
