function getConfigurationOptions() { global $osC_Language, $osC_Database, $toC_Json; include '../includes/modules/' . $_REQUEST['set'] . '/' . $_REQUEST['code'] . '.php'; $module = 'osC_' . ucfirst($_REQUEST['set']) . '_' . $_REQUEST['code']; $module = new $module(); $keys = array(); foreach ($module->getKeys() as $key) { $Qkey = $osC_Database->query('select configuration_id, configuration_key, configuration_title, configuration_value, configuration_description, use_function, set_function from :table_configuration where configuration_key = :configuration_key'); $Qkey->bindTable(':table_configuration', TABLE_CONFIGURATION); $Qkey->bindValue(':configuration_key', $key); $Qkey->execute(); $control = array(); if (!osc_empty($Qkey->value('set_function'))) { $control = osc_call_user_func($Qkey->value('set_function'), $Qkey->value('configuration_value'), $key); $field['title'] = $Qkey->value('configuration_title'); } else { $control['type'] = 'textfield'; $control['name'] = 'configuration[' . $key . ']'; } $control['id'] = $Qkey->value('configuration_id'); $control['title'] = $Qkey->value('configuration_title'); $control['value'] = $Qkey->value('configuration_value'); $control['description'] = $Qkey->value('configuration_description'); $keys[] = $control; } echo $toC_Json->encode($keys); }
function listConfigurations() { global $toC_Json, $osC_Database; $Qcfg = $osC_Database->query('select configuration_id, configuration_key, configuration_title, configuration_description, configuration_value, use_function, set_function from :table_configuration where configuration_group_id = :configuration_group_id order by sort_order'); $Qcfg->bindTable(':table_configuration', TABLE_CONFIGURATION); $Qcfg->bindInt(':configuration_group_id', $_REQUEST['gID']); $Qcfg->execute(); $keys = array(); while ($Qcfg->next()) { $cfgValue = $Qcfg->value('configuration_value'); if (!osc_empty($Qcfg->value('use_function'))) { $cfgValue = osc_call_user_func($Qcfg->value('use_function'), $Qcfg->value('configuration_value')); } $control = array(); if (!osc_empty($Qcfg->value('set_function'))) { $control = osc_call_user_func($Qcfg->value('set_function'), $Qcfg->value('configuration_value'), $Qcfg->value('configuration_key')); } else { $control['type'] = 'textfield'; $control['name'] = $Qcfg->value('configuration_key'); } $control['id'] = $Qcfg->value('configuration_id'); $control['title'] = $Qcfg->value('configuration_title'); $control['value'] = $cfgValue; $keys[] = $control; } echo $toC_Json->encode($keys); }
public static function execute($data) { $OSCOM_Database = Registry::get('PDO'); $result = array('entries' => array()); $Qcfg = $OSCOM_Database->prepare('select * from :table_configuration where configuration_group_id = :configuration_group_id order by sort_order, configuration_title'); $Qcfg->bindInt(':configuration_group_id', $data['group_id']); $Qcfg->execute(); while ($row = $Qcfg->fetch()) { $result['entries'][] = $row; if (!empty($row['use_function'])) { $result['entries'][count($result['entries']) - 1]['configuration_value'] = osc_call_user_func($row['use_function'], $row['configuration_value']); } } $result['total'] = count($result['entries']); return $result; }
public static function find($search) { global $osC_Database; $in_group = array(); foreach (osc_toObjectInfo(self::getAllGroups())->get('entries') as $group) { $in_group[] = $group['configuration_group_id']; } $result = array('entries' => array()); $Qcfg = $osC_Database->query('select * from :table_configuration where (configuration_key like :configuration_key or configuration_value like :configuration_value) and configuration_group_id in (:configuration_group_id) order by configuration_key'); $Qcfg->bindTable(':table_configuration', TABLE_CONFIGURATION); $Qcfg->bindValue(':configuration_key', '%' . $search . '%'); $Qcfg->bindValue(':configuration_value', '%' . $search . '%'); $Qcfg->bindRaw(':configuration_group_id', implode(',', $in_group)); $Qcfg->execute(); while ($Qcfg->next()) { $result['entries'][] = $Qcfg->toArray(); if (!osc_empty($Qcfg->value('use_function'))) { $result['entries'][sizeof($result['entries']) - 1]['configuration_value'] = osc_call_user_func($Qcfg->value('use_function'), $Qcfg->value('configuration_value')); } } $result['total'] = $Qcfg->numberOfRows(); $Qcfg->freeResult(); return $result; }
<p><?php echo $osC_Language->get('introduction_edit_shipping_module'); ?> </p> <?php $keys = ''; foreach ($module->getKeys() as $key) { $Qkey = $osC_Database->query('select configuration_title, configuration_value, configuration_description, use_function, set_function from :table_configuration where configuration_key = :configuration_key'); $Qkey->bindTable(':table_configuration', TABLE_CONFIGURATION); $Qkey->bindValue(':configuration_key', $key); $Qkey->execute(); $keys .= '<b>' . $Qkey->value('configuration_title') . '</b><br />' . $Qkey->value('configuration_description') . '<br />'; if (!osc_empty($Qkey->value('set_function'))) { $keys .= osc_call_user_func($Qkey->value('set_function'), $Qkey->value('configuration_value'), $key); } else { $keys .= osc_draw_input_field('configuration[' . $key . ']', $Qkey->value('configuration_value')); } $keys .= '<br /><br />'; } $keys = substr($keys, 0, strrpos($keys, '<br /><br />')); ?> <p><?php echo $keys; ?> </p> <p align="center"><?php echo osc_draw_hidden_field('subaction', 'confirm') . '<input type="submit" value="' . $osC_Language->get('button_save') . '" class="operationButton" /> <input type="button" value="' . $osC_Language->get('button_cancel') . '" onclick="document.location.href=\'' . osc_href_link_admin(FILENAME_DEFAULT, $osC_Template->getModule()) . '\';" class="operationButton" />';
public static function findEntries($search, $group_id) { $OSCOM_Database = Registry::get('Database'); $result = array('entries' => array()); $Qcfg = $OSCOM_Database->query('select * from :table_configuration where configuration_group_id = :configuration_group_id and (configuration_key like :configuration_key or configuration_value like :configuration_value) order by sort_order'); $Qcfg->bindInt(':configuration_group_id', $group_id); $Qcfg->bindValue(':configuration_key', '%' . $search . '%'); $Qcfg->bindValue(':configuration_value', '%' . $search . '%'); $Qcfg->execute(); while ($Qcfg->next()) { $result['entries'][] = $Qcfg->toArray(); if (!osc_empty($Qcfg->value('use_function'))) { $result['entries'][sizeof($result['entries']) - 1]['configuration_value'] = osc_call_user_func($Qcfg->value('use_function'), $Qcfg->value('configuration_value')); } } $result['total'] = $Qcfg->numberOfRows(); return $result; }
" method="post"> <p><?php echo OSCOM::getDef('introduction_batch_edit_configuration_parameters'); ?> </p> <fieldset> <?php $Qcfg = Registry::get('Database')->query('select configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, use_function, set_function from :table_configuration where configuration_id in (:configuration_id)'); $Qcfg->bindRaw(':configuration_id', implode(',', array_unique(array_filter($_POST['batch'], 'is_numeric')))); $Qcfg->execute(); while ($Qcfg->next()) { if (!osc_empty($Qcfg->value('set_function'))) { $value_field = osc_call_user_func($Qcfg->value('set_function'), $Qcfg->value('configuration_value'), $Qcfg->value('configuration_key')); } else { $value_field = osc_draw_input_field('configuration[' . $Qcfg->value('configuration_key') . ']', $Qcfg->value('configuration_value')); } ?> <p><label for="configuration[<?php echo $Qcfg->valueProtected('configuration_key'); ?> ]"><?php echo $Qcfg->valueProtected('configuration_title'); ?> </label><?php echo $value_field . osc_draw_hidden_field('batch[]', $Qcfg->valueInt('configuration_id')); ?> </p>
use osCommerce\OM\Core\Site\Admin\Application\Configuration\Configuration; use osCommerce\OM\Core\OSCOM; $OSCOM_ObjectInfo = new ObjectInfo(Configuration::getEntry($_GET['pID'])); ?> <h1><?php echo $OSCOM_Template->getIcon(32) . osc_link_object(OSCOM::getLink(), $OSCOM_Template->getPageTitle()); ?> </h1> <?php if ($OSCOM_MessageStack->exists()) { echo $OSCOM_MessageStack->get(); } if (!osc_empty($OSCOM_ObjectInfo->get('set_function'))) { $value_field = osc_call_user_func($OSCOM_ObjectInfo->get('set_function'), $OSCOM_ObjectInfo->get('configuration_value'), $osC_ObjectInfo->get('configuration_key')); } else { $value_field = osc_draw_input_field('configuration[' . $OSCOM_ObjectInfo->get('configuration_key') . ']', $OSCOM_ObjectInfo->get('configuration_value')); } ?> <div class="infoBox"> <h3><?php echo osc_icon('edit.png') . ' ' . $OSCOM_ObjectInfo->getProtected('configuration_title'); ?> </h3> <form name="cEdit" class="dataForm" action="<?php echo OSCOM::getLink(null, null, 'EntrySave&Process&id=' . $_GET['id']); ?> " method="post">
<form name="tEdit" action="<?php echo osc_href_link_admin(FILENAME_DEFAULT, $osC_Template->getModule() . '&template=' . $module->getCode() . '&action=save'); ?> " method="post"> <p><?php echo $osC_Language->get('introduction_edit_template'); ?> </p> <?php $keys = ''; foreach ($module->getKeys() as $key => $value) { $keys .= '<b>' . $value['title'] . '</b><br />' . $value['description'] . '<br />'; if (!empty($value['set_function'])) { $keys .= osc_call_user_func($value['set_function'], $value['value'], $key); } else { $keys .= osc_draw_input_field('configuration[' . $key . ']', $value['value']); } $keys .= '<br /><br />'; } $keys = substr($keys, 0, strrpos($keys, '<br /><br />')); ?> <p><?php echo $keys; ?> </p> <?php if ($module->getCode() != DEFAULT_TEMPLATE) {