function df_tableFormSetup($Table, $Config = false) { $Defaults = false; if (!empty($Config)) { $Defaults = $Config['Content']['_Field']; } //include('configs/upc.cfg.php'); ob_start(); echo '<span class="captions">Required</span>'; $result = mysql_query("SHOW COLUMNS FROM `" . $Table . "`"); if (mysql_num_rows($result) > 0) { $Row = 'list_row2'; while ($row = mysql_fetch_assoc($result)) { $FieldSet = explode('_', $Defaults[$row['Field']]); $Row = dais_rowSwitch($Row); $Field = $row['Field']; $name = df_parseCamelCase($Field); //REquired Check $Sel = ''; if (!empty($Config['Content']['_Required'][$Field])) { $Sel = 'checked="checked"'; } echo '<div id="Field_' . $Field . '" class="list_row1 table_sorter" style="padding:3px;"><img src="' . WP_PLUGIN_DIR . '/db-toolkit/data_report/arrow_out.png" align="absmiddle" class="OrderSorter" /><input type="checkbox" name="Data[Content][_Required][' . $Field . ']" id="required_' . $Field . '" ' . $Sel . ' /> ' . ucwords($name) . ' : ' . df_fieldTypes($Field, $Table, $row, $Defaults) . '<span class="list_row3" id="ExtraSetting_' . $Field . '">'; if (!empty($FieldSet[1])) { if (file_exists(WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes/' . $FieldSet[0] . '/conf.php')) { include WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes/' . $FieldSet[0] . '/conf.php'; if ($FieldTypes[$FieldSet[1]]['func'] != 'null') { echo $FieldTypes[$FieldSet[1]]['func']($Field, $Table, $Config); } } } echo '</span></div>'; } } return ob_get_clean(); }
function df_tableReportSetup($Table, $EID, $Config = false, $Column = 'M') { $PreReturn = array(); if (empty($Table)) { return; } global $wpdb; if ($Column == 'Linking') { $result = mysql_query("SHOW COLUMNS FROM `" . $Table . "`"); if (mysql_num_rows($result) > 0) { $Row = 'list_row4'; while ($row = mysql_fetch_assoc($result)) { //$Row = dais_rowSwitch($Row); $FieldList[] = $row['Field']; } } $Field = '__' . uniqid(); $name = df_parseCamelCase($Field); $name = df_parseCamelCase($Field); //echo '<div id="Field_'.$Field.'" class="'.$Row.' table_sorter" style="padding:3px;"><input type="checkbox" name="null" id="use_'.$Field.'" checked="checked" onclick="dr_enableDisableField(this);" /> '.ucwords($name).' : '.df_FilterTypes($Field, $Table, $row).'<span id="ExtraSetting_'.$Field.'"></span></div>'; $PreReturn[$Field] .= '<div id="Field_' . $Field . '" class="admin_list_row3 table_sorter postbox cloned" style="width:550px;"><img src="' . WP_PLUGIN_URL . '/db-toolkit/images/cancel.png" align="absmiddle" onclick="jQuery(\'#Field_' . $Field . '\').remove();" style="float:right; padding:5px;" /><img src="' . WP_PLUGIN_URL . '/db-toolkit/images/cog.png" align="absmiddle" onclick="jQuery(\'#overide_' . $Field . '\').toggle();" style="float:right; padding:5px;" /><h3 class="fieldTypeHandle">' . df_parseCamelCase($Field) . '</h3>'; // Linking Master $PreReturn[$Field] .= '<div style="padding:5px;">'; $PreReturn[$Field] .= 'Master Field: <select name="Data[Content][_CloneField][' . $Field . '][Master]" id="master_' . $Field . '">'; foreach ($FieldList as $MasterField) { // add default here $PreReturn[$Field] .= '<option value="' . $MasterField . '">' . $MasterField . '</option>'; } $PreReturn[$Field] .= '</select>'; $PreReturn[$Field] .= '</div>'; $PreReturn[$Field] .= '<div id="overide_' . $Field . '" class="admin_config_panel" style="display:none; position:reletive;">'; //New Options $Justify = ''; $Width = ''; $Title = df_parseCamelCase($Field); $Caption = ''; $inlineSel = ''; $SSel = ''; $SClass = 'button'; $USel = ''; $UClass = 'button'; $RSel = ''; $RClass = 'button'; if (!empty($Config)) { if (!empty($Defaults['_WidthOverride'][$Field])) { $Width = $Defaults['_WidthOverride'][$Field]; } if (!empty($Config['Content']['_Required'][$Field])) { $RSel = 'checked="checked"'; $RClass = 'button-primary'; } if (empty($Config['Content']['_Sortable'][$Field])) { $SSel = 'checked="checked"'; $SClass = 'button-primary'; } if (!empty($Config['Content']['_Unique'][$Field])) { $USel = 'checked="checked"'; $UClass = 'button-primary'; } if (!empty($Config['Content']['_FieldTitle'][$Field])) { $Title = $Config['Content']['_FieldTitle'][$Field]; } if (!empty($Config['Content']['_FieldCaption'][$Field])) { $Caption = $Config['Content']['_FieldCaption'][$Field]; } if (!empty($Config['Content']['_InlineEdit'][$Field])) { $inlineSel = 'checked="checked"'; } if (!empty($Config['Content']['_Justify'][$Field])) { $Justify = $Config['Content']['_Justify'][$Field]; } } $PreReturn[$Field] .= '<div style="padding:3px;">Title: <input type="text" value="' . $Title . '" name="Data[Content][_FieldTitle][' . $Field . ']" /> '; $PreReturn[$Field] .= 'Caption: <input type="text" value="' . $Caption . '" name="Data[Content][_FieldCaption][' . $Field . ']" />'; $PreReturn[$Field] .= df_FormWidthSetup($Field, $fieldFormWidth); $PreReturn[$Field] .= '</div>'; $PreReturn[$Field] .= '<div style="padding:3px;">List Column Width: <input type="text" style="width:40px;" value="' . $Width . '" name="Data[Content][_WidthOverride][' . $Field . ']" /> '; $PreReturn[$Field] .= df_alignmentSetup($Field, $Justify) . '</div>'; //$PreReturn[$Field] .= '<div class="admin_list_row2">Unique: <input type="checkbox" name="Data[Content][_Unique]['.$Field.']" id="unique_'.$Field.'" '.$USel.' /></div>'; //$PreReturn[$Field] .= '<div class="admin_list_row1">Reguired: </div>'; //$PreReturn[$Field] .= '<div class="admin_list_row2">Sortable: </div>'; //$PreReturn[$Field] .= '<div style="padding:3px;">Inline Editing: <input type="checkbox" name="Data[Content][_InlineEdit]['.$Field.']" id="sortable_'.$Field.'" '.$inlineSel.' /></div>'; $PreReturn[$Field] .= '</div>'; $PreReturn[$Field] .= '<div class="admin_config_toolbar"> <div style="float:left; width:180px;">' . df_fieldTypes($Field, $Table, $row, $Defaults['_Field']) . '</div>' . dr_reportListTypes($Field, $Defaults['_IndexType'][$Field]); $PreReturn[$Field] .= ' <span class="' . $UClass . '" id="unique_' . $Field . '" onclick="df_setToggle(\'unique_' . $Field . '\');" title="Unique"><span style="background: url(' . WP_PLUGIN_URL . '/db-toolkit/data_report/unique.png) left center no-repeat; padding:5px 8px;"></span></span>'; $PreReturn[$Field] .= ' <span class="' . $RClass . '" id="required_' . $Field . '" onclick="df_setToggle(\'required_' . $Field . '\');" title="Required"><span style="background: url(' . WP_PLUGIN_URL . '/db-toolkit/data_report/required.png) left center no-repeat; padding:5px 8px;"></span></span>'; $PreReturn[$Field] .= ' <span class="' . $SClass . '" id="issortable_' . $Field . '" onclick="df_setToggle(\'issortable_' . $Field . '\');" title="Sortable"><span style="background: url(' . WP_PLUGIN_URL . '/db-toolkit/data_report/table_sort.png) left center no-repeat; padding:5px 8px;"></span></span>'; $PreReturn[$Field] .= '<input style="display:none;" type="checkbox" name="Data[Content][_Unique][' . $Field . ']" id="unique_' . $Field . '_check" ' . $USel . ' />'; $PreReturn[$Field] .= '<input style="display:none;" type="checkbox" name="Data[Content][_Required][' . $Field . ']" id="required_' . $Field . '_check" ' . $RSel . ' />'; $PreReturn[$Field] .= '<input style="display:none;" type="checkbox" name="Data[Content][_Sortable][' . $Field . ']" id="issortable_' . $Field . '_check" ' . $SSel . ' />'; $PreReturn[$Field] .= '<div class="widefat" id="' . $Field . '_FieldTypePanel" style="display:none; text-align:left;"></div>'; $PreReturn[$Field] .= '</div><div class="admin_config_panel" style="text-align:right;" id="ExtraSetting_' . $Field . '">'; unset($Types); $Types = explode('_', $Defaults['_Field'][$Field]); if (file_exists(WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes/' . $Types[0] . '/conf.php')) { include WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes/' . $Types[0] . '/conf.php'; $func = $FieldTypes[$Types[1]]['func']; if ($func != 'null') { if ($func != '') { $PreReturn[$Field] .= '<div class="admin_list_row3" id="' . $Field . '_configPanel" style="display:none; text-align:left;">'; $PreReturn[$Field] .= '<h3>' . $Field . ' Config</h3><div class="admin_config_panel">'; $PreReturn[$Field] .= $func($Field, $Table, $Config); $PreReturn[$Field] .= '</div></div>'; $PreReturn[$Field] .= '<input type="button" class="button" style="margin-top:5px;" value="Setup" onclick="toggle(\'' . $Field . '_configPanel\');" />'; } } } $PreReturn[$Field] .= '</div></div>'; return $PreReturn[$Field]; } if ($EID == 'false') { $Defaults = $Config['Content']; $Config['Content']['_main_table'] = $Table; //dump($Defaults); if (!empty($Defaults['_FormLayout'])) { parse_str($Defaults['_FormLayout'], $Columns); } $Return = ''; $result = mysql_query("SHOW COLUMNS FROM `" . $Table . "`"); if (mysql_num_rows($result) > 0) { $Row = 'list_row4'; while ($row = mysql_fetch_assoc($result)) { //$Row = dais_rowSwitch($Row); $FieldList[] = $row['Field']; $Field = $row['Field']; $PreReturn[$Field] = df_makeFieldConfigBox($Field, $Config, $Defaults); } } if (!empty($Defaults['_Field']) && $Column != 'N') { foreach ($Defaults['_Field'] as $Key => $Value) { if (!empty($PreReturn[$Key])) { $Return .= $PreReturn[$Key]; unset($PreReturn[$Key]); } else { //if(substr($Key,0,2) == '__'){ $Return .= df_makeFieldConfigBox($Key, $Config, $Defaults); //} } } } if (!empty($PreReturn)) { foreach ($PreReturn as $Key => $newFields) { $Return .= $newFields; } } } else { $Ref = getelement($EID); $Return = ''; $Row = 'list_row2'; foreach ($Ref['Content']['_Field'] as $Field => $FieldSet) { $Row = dais_rowswitch($Row); //$Return .= '<div id="Field_'.$Field.'" class="'.$Row.' table_sorter" style="padding:3px;"><img src="'.WP_PLUGIN_DIR.'/db-toolkit/data_report/arrow_out.png" align="absmiddle" class="OrderSorter" /> <img src="'.WP_PLUGIN_DIR.'/db-toolkit/data_report/tag.png" align="absmiddle" onclick="jQuery(\'#overide_'.$Field.'\').toggle();" /><input type="texfield" style="width:40px; display:none;" name="Data[Content][_WidthOverride]['.$Field.']" id="overide_'.$Field.'" /> '.df_parseCamelCase($Field).' : '.df_FilterTypes($Field, $Table, $row).'<span id="ExtraSetting_'.$Field.'"></span></div>'; $Return .= '<div id="Field_' . $Field . '" class="' . $Row . ' table_sorter" style="padding:3px;"><img src="' . WP_PLUGIN_DIR . '/db-toolkit/data_report/arrow_out.png" align="absmiddle" class="OrderSorter" />'; $Return .= ' <img src="' . WP_PLUGIN_DIR . '/db-toolkit/data_report/tag.png" align="absmiddle" onclick="jQuery(\'#overide_' . $Field . '\').toggle();" /><span id="overide_' . $Field . '" style="display:none;">'; //New Options $Return .= ' Width: <input type="texfield" style="width:40px;" name="Data[Content][_WidthOverride][' . $Field . ']" /> '; $Return .= df_alignmentSetup($Field); $Return .= '</span> ' . df_parseCamelCase($Field) . ' : ' . dr_reportListTypes($Field, $Ref['Content']['_IndexType']) . df_fieldTypes($Field, $Table, $row, $Ref['Content']['_Field']) . '<span id="ExtraSetting_' . $Field . '">'; $Types = explode('_', $FieldSet); if (file_exists(WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes/' . $Types[0] . '/conf.php')) { include WP_PLUGIN_DIR . '/db-toolkit/data_form/fieldtypes/' . $Types[0] . '/conf.php'; $func = $FieldTypes[$Types[1]]['func']; if ($func != 'null') { $Return .= '<div style="padding:3px; text-align:right;"><input type="button" class="button" style="margin-top:5px;" value="Setup" onclick="toggle(\'' . $Field . '_configPanel\');" /></div>'; $Return .= '<blockquote id="' . $Field . '_configPanel">'; $Return .= '<h3>' . $Field . ' Config</h3>'; $Return .= $func($Field, $Table, $Ref); $Return .= '</blockquote>'; } } $Return .= '</span></div>'; //df_fieldTypes($Field, $Table, $row, $Defaults) } $Return .= '<input type="hidden" id="referencePage" style="width:40px;" name="Data[Content][_ReferencePage]" value="' . $Ref['ParentDocument'] . '" />'; } return $Return; }