コード例 #1
0
ファイル: class.php プロジェクト: routexl/DB-Toolkit
 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();
 }
コード例 #2
0
ファイル: class.php プロジェクト: routexl/DB-Toolkit
 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);" />&nbsp;'.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] .= ' &nbsp;<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] .= ' &nbsp;<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] .= ' &nbsp;<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" />&nbsp;<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.'" /> &nbsp;'.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 .= '&nbsp;<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 .= '&nbsp;Width: <input type="texfield" style="width:40px;" name="Data[Content][_WidthOverride][' . $Field . ']" />&nbsp;';
             $Return .= df_alignmentSetup($Field);
             $Return .= '</span> &nbsp;' . 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;
 }