function df_buildFieldTypesMenu($Field, $Table)
{
global $wpdb;
$existingFields = $wpdb->get_results("SHOW FIELDS FROM `" . $Table . "`", ARRAY_A);
$fields = array();
foreach ($existingFields as $curField) {
$fields[$curField['Field']] = $curField['Type'];
}
$Types = loadFolderContents(WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes');
//$Return = '<select name="Data[Content][_Field]['.$Field.']" id="Fieldtype_'.$Field.'" >';
//$Return = '<select name="Data[Content][_Field]['.$Field.']" id="Fieldtype_'.$Field.'" >'
//$Return .= '<optgroup label="Auto Increment">';
//$Return .= '<option value="hidden" onclick="df_noOptions(\''.$Field.'\');">Auto</option>';
//$Return .= '</optgroup>';
$Return = '';
if (!empty($fields[$Field])) {
//$Return .= '<div class="warning" style="font-weight:normal;">Changing FieldTypes on existing data may result in data loss. <div style="padding:3px; cursor:pointer;"><a onclick="jQuery(\'.inComp\').toggle(); return false;">Show All FieldTypes</a></div></div>';
}
$Return .= '<div style="width:33.33333%; float:left;">';
//$Return .= '<div style="">';
$Return .= '<div style="padding:3px; cursor:default" class="admin_config_toolbar">Default / Auto Increment</div>';
$Return .= '<div style="" id="_default_' . $Field . '">';
$Icon = WP_PLUGIN_URL . '/db-toolkit/data_form/wand.png';
$Return .= '<div style="padding:3px;">';
$Return .= '<a href="#" id="' . $Field . '_hidden" onclick="return df_setOptions(\'' . $Field . '\', \'null\', \'hidden\');"><span style="background: url(' . $Icon . ') left center no-repeat; padding:5px 18px;"> Ignore Field</span></a>';
$Return .= '</div>';
$Return .= '</div>';
$Return .= '</div>';
//sort($Types[0]);
foreach ($Types[0] as $Type) {
if (file_exists(WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes/' . $Type[1] . '/conf.php')) {
include WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes/' . $Type[1] . '/conf.php';
//$Return .= '<optgroup label="'.$FieldTypeTitle.'">';
$CIcon = WP_PLUGIN_URL . '/db-toolkit/data_form/fieldtype.png';
if (file_exists(WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes/' . $Type[1] . '/icon.png')) {
$CIcon = WP_PLUGIN_URL . '/db-toolkit/data_form/fieldtypes/' . $Type[1] . '/icon.png';
}
$Return .= '<div style="width:33.33333%; float:left;">';
//$Return .= '<div style="">';
$Return .= '<div style="padding:3px; cursor:default;" class="admin_config_toolbar"><span style="background: url(' . $CIcon . ') left center no-repeat; padding:5px 20px;"> ' . $FieldTypeTitle . '</span></div>';
$Return .= '<div id="folder_' . $Type[1] . '_' . $Field . '" style="padding-left:5px;">';
ksort($FieldTypes);
$used = 0;
foreach ($FieldTypes as $Key => $FieldSet) {
$fieldDisplay = "block";
$fieldClass = '';
/*
$fieldDisplay = "none";
$fieldClass = 'inComp';
if(!empty($fields[$Field])){
if(strtolower($FieldSet['baseType']) == strtolower($fields[$Field])){
$fieldDisplay = "block";
$fieldClass = '';
$used++;
}
}else{
$fieldDisplay = "block";
$fieldClass = '';
$used++;
}
*/
$Icon = WP_PLUGIN_URL . '/db-toolkit/data_form/insert.png';
if (file_exists(WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes/' . $Type[1] . '/' . $Type[1] . '_' . $Key . '.png')) {
$Icon = WP_PLUGIN_URL . '/db-toolkit/data_form/fieldtypes/' . $Type[1] . '/' . $Type[1] . '_' . $Key . '.png';
}
$Return .= '<div style="padding:4px; display:' . $fieldDisplay . ';" class="' . $fieldClass . '">';
$Return .= '<a href="#" id="' . $Field . '_' . $Type[1] . '_' . $Key . '" onclick="return df_setOptions(\'' . $Field . '\', \'' . $FieldSet['func'] . '\', \'' . $Type[1] . '_' . $Key . '\');"><span style="background: url(' . $Icon . ') left center no-repeat; padding:5px 20px;"> ' . $FieldSet['name'] . '</span></a>';
$Return .= '</div>';
}
//if(empty($used)){
// $Return .= '<div style="padding:4px;" class="inComp">';
// $Return .= '<span class="description">No compatible fieldtypes</span>';
// $Return .= '</div>';
//}
$Return .= '</div>';
$Return .= '</div>';
}
}
$Return .= '<div style="clear:both;"></div>';
//$Return .= '</select>';
return $Return;
}
<?php
$Types = loadFolderContents(WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes');
foreach ($Types[0] as $Type) {
if (file_exists(WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes/' . $Type[1] . '/footer.php')) {
include WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes/' . $Type[1] . '/footer.php';
}
}
if (!empty($_SESSION['DF_Post'])) {
$Messages = implode('<br />', $_SESSION['DF_Post']);
$ReturnID = false;
$ElementID = false;
if (!empty($_SESSION['DF_Post_returnID'])) {
$ReturnID = $_SESSION['DF_Post_returnID'];
$ElementID = $_SESSION['DF_Post_EID'];
}
?>
<script>
jQuery(document).ready(function(){
df_dialog('<?php
echo $Messages;
?>
', '<?php
echo $ReturnID;
?>
', '<?php
echo $ElementID;
?>
');
// setTimeout($.unblockUI, 2000);
});
function dt_styles($preIs = false)
{
if (!is_admin()) {
global $post;
$isBound = get_option('_dbtbinding_' . $post->ID);
if (!empty($isBound)) {
$preIs[] = $isBound;
}
$pattern = get_shortcode_regex();
$texts = get_option('widget_text');
if (empty($preIs)) {
$preIs = array();
}
foreach ($texts as $text) {
$ilc_widget_active = get_option('sidebars_widgets');
unset($ilc_widget_active['wp_inactive_widgets']);
if ($ilc_widget_active) {
foreach ($ilc_widget_active as $sidebar) {
if (is_array($sidebar)) {
foreach ($sidebar as $widget) {
if (substr($widget, 0, 5) == 'text-') {
/// filter each item
//vardump($text['text']);
preg_match_all('/' . $pattern . '/s', $texts[substr($widget, 5)]['text'], $matches);
//vardump($matches);
if (!empty($matches[3])) {
foreach ($matches[3] as $preInterface) {
$preIs[] = shortcode_parse_atts($preInterface);
}
}
}
}
}
}
}
}
if (!empty($ilc_widget_active)) {
foreach ($ilc_widget_active as $sidebar => $widgets) {
if (is_array($widgets)) {
foreach ($widgets as $widget) {
if (is_active_sidebar($sidebar)) {
if (substr($widget, 0, 10) == 'interface-') {
$interfaces = get_option('widget_interface');
$preIs[] = $interfaces[substr($widget, 10)]['Interface'];
}
}
}
}
}
}
if (!empty($post)) {
preg_match_all('/' . $pattern . '/s', $post->post_content, $matches);
$shortCodes = array('interface');
global $wpdb;
$customShortCodes = $wpdb->get_results("SELECT `option_name`, `option_value` FROM {$wpdb->options} WHERE `option_name` LIKE 'dt_intfc%' AND `option_value` LIKE '%_shortCode%' ", ARRAY_A);
foreach ($customShortCodes as $shortCodesIn) {
$data = unserialize($shortCodesIn['option_value']);
if (!empty($data['_shortCode'])) {
if (in_array($data['_shortCode'], $matches[2])) {
$preIs[] = $shortCodesIn['option_name'];
}
}
}
if (in_array('interface', $matches[2])) {
$i = 0;
foreach ($matches[2] as $candidate) {
if ($candidate === 'interface') {
$args = shortcode_parse_atts($matches[3][$i]);
$op = get_option($args['id']);
if (!empty($op)) {
$preIs[] = $args['id'];
}
}
$i++;
}
}
}
}
if (!empty($preIs) || is_admin()) {
// add styles for reports grid
$themeDir = get_theme_root() . '/' . get_template();
$themeURL = get_bloginfo('template_url');
if (!file_exists($themeDir . '/uicustom')) {
wp_register_style('jqueryUI-core', WP_PLUGIN_URL . '/db-toolkit/jqueryui/jquery-ui.css');
} else {
wp_register_style('jqueryUI-core', $themeURL . '/uicustom/jquery-ui.css');
}
wp_register_style('jquery-multiselect', WP_PLUGIN_URL . '/db-toolkit/libs/ui.dropdownchecklist.css');
wp_register_style('jquery-validate', WP_PLUGIN_URL . '/db-toolkit/libs/validationEngine.jquery.css');
wp_enqueue_style('jqueryUI-core');
wp_enqueue_style('jquery-multiselect');
wp_enqueue_style('jquery-validate');
//picker
wp_enqueue_style('datepicker-bs', DBT_URL . "/data_form/fieldtypes/date/css/datepicker.css");
// report
if (file_exists($themeDir . '/table.css') && !is_admin()) {
wp_register_style('interface_table_styles', $themeURL . '/table.css');
} else {
wp_register_style('interface_table_styles', WP_PLUGIN_URL . '/db-toolkit/data_report/css/table.css');
}
wp_enqueue_style('interface_table_styles');
if (file_exists($themeDir . '/toolbar.css') && !is_admin()) {
wp_register_style('custom_toolbar_style', $themeURL . '/toolbar.css');
} else {
wp_register_style('custom_toolbar_style', WP_PLUGIN_URL . '/db-toolkit/data_report/css/style.css');
}
wp_enqueue_style('custom_toolbar_style');
// form
if (file_exists($themeDir . '/form.css') && !is_admin()) {
wp_register_style('form_style', $themeURL . '/form.css');
wp_enqueue_style('form_style');
} else {
wp_register_style('form_style', WP_PLUGIN_URL . '/db-toolkit/data_form/css/form.css');
wp_enqueue_style('form_style');
}
/*
//<link rel="stylesheet" type="text/css" media="screen" href="<?php echo WP_PLUGIN_URL; ?>/db-toolkit/data_form/css/ui.timepickr.css" />
<script type="text/javascript" src="<?php echo WP_PLUGIN_URL; ?>/db-toolkit/data_form/js/ui.timepickr.js"></script>
*/
$Types = loadFolderContents(WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes');
foreach ($Types[0] as $Type) {
if (file_exists(WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes/' . $Type[1] . '/header.php')) {
include_once WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes/' . $Type[1] . '/header.php';
}
}
}
// load interface specifics
if (is_admin()) {
if (!empty($_GET['page'])) {
if (substr($_GET['page'], 0, 4) == 'app_' || substr($_GET['page'], 0, 8) == 'dt_intfc') {
wp_register_style('interface_setup_styles', WP_PLUGIN_URL . '/db-toolkit/data_report/css/launcher.css');
} else {
wp_register_style('interface_setup_styles', WP_PLUGIN_URL . '/db-toolkit/data_report/css/setup.css');
}
}
wp_enqueue_style('interface_setup_styles');
if (!empty($_GET['page']) || !empty($_GET['renderinterface'])) {
if (!empty($_GET['page'])) {
if (substr($_GET['page'], 0, 8) == 'dt_intfc') {
$isInterface = $_GET['page'];
}
}
if (!empty($_GET['renderinterface'])) {
if (substr($_GET['renderinterface'], 0, 8) == 'dt_intfc') {
$isInterface = $_GET['renderinterface'];
}
}
if (substr($_GET['page'], 0, 4) == 'app_') {
$app = get_option('_' . substr($_GET['page'], 4) . '_app');
if (!empty($app['landing'])) {
$isInterface = $app['landing'];
} else {
foreach ($app['interfaces'] as $interface => $access) {
$isInterface = $interface;
}
}
}
if (!empty($isInterface)) {
$preInterface = get_option($isInterface);
if (!empty($preInterface['_CustomCSSSource'])) {
// load scripts
// setup scripts and styles
foreach ($preInterface['_CustomCSSSource'] as $handle => $CSS) {
wp_register_style($handle, $CSS['source']);
wp_enqueue_style($handle);
}
}
$Config = unserialize(base64_decode($preInterface['Content']));
if (!empty($Config['_ViewProcessors'])) {
foreach ($Config['_ViewProcessors'] as $viewProcess) {
if (file_exists(DB_TOOLKIT . 'data_report/processors/' . $viewProcess['_process'] . '/styles.php')) {
include_once DB_TOOLKIT . 'data_report/processors/' . $viewProcess['_process'] . '/styles.php';
}
}
}
}
}
} else {
if (!empty($preIs)) {
$stylesAdded = array();
foreach ($preIs as $interface) {
if (!is_array($interface)) {
$preInterface = get_option($interface);
if (!empty($preInterface['_CustomCSSSource'])) {
// load scripts
// setup scripts and styles
foreach ($preInterface['_CustomCSSSource'] as $handle => $CSS) {
if (array_search($CSS['source'], $stylesAdded) === false) {
wp_register_style($handle, $CSS['source']);
wp_enqueue_style($handle);
$stylesAdded[] = $CSS['source'];
}
}
}
$Config = unserialize(base64_decode($preInterface['Content']));
if (!empty($Config['_ViewProcessors'])) {
foreach ($Config['_ViewProcessors'] as $viewProcess) {
if (file_exists(DB_TOOLKIT . 'data_report/processors/' . $viewProcess['_process'] . '/styles.php')) {
include_once DB_TOOLKIT . 'data_report/processors/' . $viewProcess['_process'] . '/styles.php';
}
}
}
}
}
}
}
}
echo dr_toolbarButton('Select All', 'dr_selectAll(\'' . $Media['ID'] . '\');', 'selectall');
echo dr_toolbarSeperator();
echo dr_toolbarButton('Unselect All', 'dr_deSelectAll(\'' . $Media['ID'] . '\');', 'unselectall');
echo dr_toolbarSeperator();
}
echo dr_toolbarButton('Delete Selected', 'dr_deleteEntries(\'' . $Media['ID'] . '\');"', 'delete');
echo dr_toolbarSeperator();
}
if (!empty($Config['_Show_Export'])) {
if (empty($Global)) {
$Global = false;
}
echo dr_toolbarButton('Export PDF', 'dr_exportReport(\'?format_' . $Media['ID'] . '=pdf\', \'' . $Media['ID'] . '\',\'' . $Global . '\');', 'export');
echo dr_toolbarSeperator();
echo dr_toolbarButton('Export CSV', 'dr_exportReport(\'?format_' . $Media['ID'] . '=csv\', \'' . $Media['ID'] . '\',\'' . $Global . '\');', 'export');
echo dr_toolbarSeperator();
}
//echo '<div class="btnseparator ui-dialog-tile" style="display:none;"></div>';
//echo '<div class="fbutton ui-dialog-tile" style="display:none;"><div class="button add-new-h2"><span class="selectall" onclick="dialog_tile();">Tile Dialogs</span></div></div>';
if (!empty($Config['_Show_Plugins'])) {
$ListButtons = loadFolderContents(WP_PLUGIN_DIR . '/db-toolkit/data_report/plugins');
foreach ($ListButtons as $PlugButton) {
foreach ($PlugButton as $Button) {
include WP_PLUGIN_DIR . '/db-toolkit/data_report/plugins/' . $Button[1] . '/button.php';
}
}
}
echo '<div style="clear:both;"></div></div>';
}
}
//echo $Buttons;
