$items[] = $item;
$item = [];
$item['label'] = rex_i18n::msg('yform_manager_tableset') . ' ' . rex_i18n::msg('yform_manager_import');
$item['url'] = $context->getUrl(['func' => 'tableset_import']);
$item['attributes']['class'][] = 'btn-default';
if ($func == 'tableset_import') {
$item['attributes']['class'][] = 'active';
}
$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, 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'));
$tdIcon = '<i class="rex-icon rex-icon-table"></i>';
$thIcon = '<a href="' . $list->getUrl(['func' => 'add']) . '"' . rex::getAccesskey($this->i18n('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, ['func' => 'edit', 'table_id' => '###id###']);
$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'));
static function checkMediaInUse($params)
{
$warning = $params['subject'];
$sql = rex_sql::factory();
$sql->setQuery('SELECT `table_name`, `type_name`, `name` FROM `' . rex_yform_manager_field::table() . '` WHERE `type_id`="value" AND `type_name` IN("be_medialist","be_mediapool","mediafile")');
$rows = $sql->getRows();
if ($rows == 0) {
return $warning;
}
$where = array();
$filename = addslashes($params['filename']);
while ($sql->hasNext()) {
$table = $sql->getValue('table_name');
switch ($sql->getValue('type_name')) {
case 'be_mediapool':
case 'mediafile':
$where[$table][] = $sql->getValue('name') . '="' . $filename . '"';
break;
case 'be_medialist':
$where[$table][] = 'FIND_IN_SET("' . $filename . '", ' . $sql->getValue('name') . ')';
break;
default:
trigger_error('Unexpected fieldtype "' . $sql->getValue('type_name') . '"!', E_USER_ERROR);
}
$sql->next();
}
$tupel = '';
foreach ($where as $table => $cond) {
$sql->setQuery('SELECT id FROM ' . $table . ' WHERE ' . implode(' OR ', $cond));
while ($sql->hasNext()) {
$sql_tupel = rex_sql::factory();
$sql_tupel->setQuery('SELECT name FROM `' . rex_yform_manager_table::table() . '` WHERE `table_name`="' . $table . '"');
$tupel .= '<li><a href="javascript:openPage(\'index.php?page=yform/manager/data_edit&table_name=' . $table . '&data_id=' . $sql->getValue('id') . '&func=edit\')">' . $sql_tupel->getValue('name') . ' [id=' . $sql->getValue('id') . ']</a></li>';
$sql->next();
}
}
if ($tupel != '') {
$warning[] = 'Tabelle<br /><ul>' . $tupel . '</ul>';
}
return $warning;
}
public static function removeTable($table_name)
{
$table = rex_yform_manager_table::get($table_name);
$t = rex_sql::factory();
$t->debugsql = self::$debug;
$t->setQuery('delete from ' . rex_yform_manager_table::table() . ' where table_name="' . mysql_real_escape_string($table_name) . '"');
if ($table) {
foreach ($table->getFields() as $remove_field) {
self::removeTablefield($table_name, $remove_field->getName());
}
}
}
