PHP rex_sql::getFieldnames方法代码示例

 function addSlice($I_ID, $module_id)
 {
     global $REX, $I18N;
     $MOD = new rex_sql();
     $MOD->setQuery("SELECT * FROM " . $REX['TABLE_PREFIX'] . "module WHERE id={$module_id}");
     if ($MOD->getRows() != 1) {
         $slice_content = rex_warning($I18N->msg('module_doesnt_exist'));
     } else {
         $slice_content = '
     <a name="addslice"></a>
     <form action="index.php#slice' . $I_ID . '" method="post" id="REX_FORM" enctype="multipart/form-data">
       <fieldset>
         <legend class="rex-lgnd">' . $I18N->msg('add_block') . '</legend>
         <input type="hidden" name="article_id" value="' . $this->article_id . '" />
         <input type="hidden" name="page" value="content" />
         <input type="hidden" name="mode" value="' . $this->mode . '" />
         <input type="hidden" name="slice_id" value="' . $I_ID . '" />
         <input type="hidden" name="function" value="add" />
         <input type="hidden" name="module_id" value="' . $module_id . '" />
         <input type="hidden" name="save" value="1" />
         <input type="hidden" name="clang" value="' . $this->clang . '" />
         <input type="hidden" name="ctype" value="' . $this->ctype . '" />
         <p class="rex-cnt-mdl-name">
           ' . $I18N->msg("module") . ': <span>' . htmlspecialchars($MOD->getValue("name")) . '</span>
         </p>
         <div class="rex-cnt-slc-ipt"><div class="rex-cnt-slc-ipt2">
           ' . $MOD->getValue("eingabe") . '
         </div></div>
         <p class="rex-sbmt">
           <input type="submit" name="btn_save" value="' . $I18N->msg('add_block') . '"' . rex_accesskey($I18N->msg('add_block'), $REX['ACKEY']['SAVE']) . ' />
         </p>
       </fieldset>
     </form>
   ';
         // Beim Add hier die Meldung ausgeben
         if ($this->slice_id == 0 && $this->message != '') {
             echo rex_warning($this->message);
         }
         $dummysql = new rex_sql();
         // Den Dummy mit allen Feldern aus rex_article_slice füllen
         $slice_fields = new rex_sql();
         $slice_fields->setQuery('SELECT * FROM ' . $REX['TABLE_PREFIX'] . 'article_slice LIMIT 1');
         foreach ($slice_fields->getFieldnames() as $fieldname) {
             switch ($fieldname) {
                 case 'clang':
                     $def_value = $this->clang;
                     break;
                 case 'ctype':
                     $def_value = $this->ctype;
                     break;
                 case 'modultyp_id':
                     $def_value = $module_id;
                     break;
                 case 'article_id':
                     $def_value = $this->article_id;
                     break;
                 case 'id':
                     $def_value = 0;
                     break;
                 default:
                     $def_value = '';
             }
             $dummysql->setValue($REX['TABLE_PREFIX'] . 'article_slice.' . $fieldname, $def_value);
         }
         $slice_content = $this->replaceVars($dummysql, $slice_content);
     }
     return $slice_content;
 }

 function addSlice($I_ID, $module_id)
 {
     global $REX, $I18N;
     $MOD = new rex_sql();
     $MOD->setQuery("SELECT * FROM " . $REX['TABLE_PREFIX'] . "module WHERE id={$module_id}");
     if ($MOD->getRows() != 1) {
         $slice_content = rex_warning($I18N->msg('module_doesnt_exist'));
     } else {
         $slice_content = '
     <a name="addslice"></a>
     <div class="rex-form rex-form-content-editmode-add-slice">
     <form action="index.php#slice' . $I_ID . '" method="post" id="REX_FORM" enctype="multipart/form-data">
       <fieldset class="rex-form-col-1">
         <legend><span>' . $I18N->msg('add_block') . '</span></legend>
         <input type="hidden" name="article_id" value="' . $this->article_id . '" />
         <input type="hidden" name="page" value="content" />
         <input type="hidden" name="mode" value="' . $this->mode . '" />
         <input type="hidden" name="slice_id" value="' . $I_ID . '" />
         <input type="hidden" name="function" value="add" />
         <input type="hidden" name="module_id" value="' . $module_id . '" />
         <input type="hidden" name="save" value="1" />
         <input type="hidden" name="clang" value="' . $this->clang . '" />
         <input type="hidden" name="ctype" value="' . $this->ctype . '" />
         
         <div class="rex-content-editmode-module-name">
           <h3 class="rex-hl4">
             ' . $I18N->msg("module") . ': <span>' . htmlspecialchars($MOD->getValue("name")) . '</span>
           </h3>
         </div>
           
         <div class="rex-form-wrapper">
           
           <div class="rex-form-row">
             <div class="rex-content-editmode-slice-input">
             <div class="rex-content-editmode-slice-input-2">
               ' . $MOD->getValue("eingabe") . '
             </div>
             </div>
           </div>
           
         </div>
       </fieldset>
       
       <fieldset class="rex-form-col-1">
          <div class="rex-form-wrapper">              
           <div class="rex-form-row">
             <p class="rex-form-col-a rex-form-submit">
               <input class="rex-form-submit" type="submit" name="btn_save" value="' . $I18N->msg('add_block') . '"' . rex_accesskey($I18N->msg('add_block'), $REX['ACKEY']['SAVE']) . ' />
             </p>
           </div>
         </div>
       </fieldset>
     </form>
     </div>
     <script type="text/javascript">
        <!--
       jQuery(function($) {
         $(":input:visible:enabled:not([readonly]):first", $("form#REX_FORM")).focus();
       });
        //-->
     </script>';
         // Beim Add hier die Meldung ausgeben
         if ($this->slice_id == 0) {
             if ($this->warning != '') {
                 echo rex_warning($this->warning);
             }
             if ($this->info != '') {
                 echo rex_info($this->info);
             }
         }
         $dummysql = new rex_sql();
         // Den Dummy mit allen Feldern aus rex_article_slice füllen
         $slice_fields = new rex_sql();
         $slice_fields->setQuery('SELECT * FROM ' . $REX['TABLE_PREFIX'] . 'article_slice LIMIT 1');
         foreach ($slice_fields->getFieldnames() as $fieldname) {
             switch ($fieldname) {
                 case 'clang':
                     $def_value = $this->clang;
                     break;
                 case 'ctype':
                     $def_value = $this->ctype;
                     break;
                 case 'modultyp_id':
                     $def_value = $module_id;
                     break;
                 case 'article_id':
                     $def_value = $this->article_id;
                     break;
                 case 'id':
                     $def_value = 0;
                     break;
                 default:
                     $def_value = '';
             }
             $dummysql->setValue($REX['TABLE_PREFIX'] . 'article_slice.' . $fieldname, $def_value);
         }
         $slice_content = $this->replaceVars($dummysql, $slice_content);
     }
     return $slice_content;
 }

/**
 * Erstellt eine Clang
 *
 * @param $id   Id der Clang
 * @param $name Name der Clang
 */
function rex_addCLang($id, $name)
{
    global $REX;
    $REX['CLANG'][$id] = $name;
    $content = "// --- DYN\n\r";
    foreach ($REX['CLANG'] as $cur => $val) {
        $content .= "\n\r\$REX['CLANG']['{$cur}'] = \"{$val}\";";
    }
    $content .= "\n\r// --- /DYN";
    $file = $REX['INCLUDE_PATH'] . "/clang.inc.php";
    $h = fopen($file, "r");
    $fcontent = fread($h, filesize($file));
    $fcontent = ereg_replace("(\\/\\/.---.DYN.*\\/\\/.---.\\/DYN)", $content, $fcontent);
    fclose($h);
    $h = fopen($file, "w+");
    fwrite($h, $fcontent, strlen($fcontent));
    fclose($h);
    @chmod($file, 0777);
    $add = new rex_sql();
    $add->setQuery("select * from " . $REX['TABLE_PREFIX'] . "article where clang='0'");
    $fields = $add->getFieldnames();
    $adda = new rex_sql();
    // $adda->debugsql = 1;
    for ($i = 0; $i < $add->getRows(); $i++) {
        $adda->setTable($REX['TABLE_PREFIX'] . "article");
        foreach ($fields as $key => $value) {
            if ($value == 'pid') {
                echo '';
            } else {
                if ($value == 'clang') {
                    $adda->setValue('clang', $id);
                } else {
                    if ($value == 'status') {
                        $adda->setValue('status', '0');
                    } else {
                        $adda->setValue($value, rex_addslashes($add->getValue($value)));
                    }
                }
            }
        }
        $adda->insert();
        $add->next();
    }
    $add = new rex_sql();
    $add->setQuery("insert into " . $REX['TABLE_PREFIX'] . "clang set id='{$id}',name='{$name}'");
    // ----- EXTENSION POINT
    rex_register_extension_point('CLANG_ADDED', '', array('id' => $id, 'name' => $name));
    rex_generateAll();
}

/**
 * Erstellt eine Clang
 *
 * @param $id   Id der Clang
 * @param $name Name der Clang
 */
function rex_addCLang($id, $name)
{
    global $REX;
    $REX['CLANG'][$id] = $name;
    $content = "";
    foreach ($REX['CLANG'] as $cur => $val) {
        $content .= "\$REX['CLANG']['{$cur}'] = \"{$val}\";\n";
    }
    $file = $REX['INCLUDE_PATH'] . "/clang.inc.php";
    rex_replace_dynamic_contents($file, $content);
    $add = new rex_sql();
    $add->setQuery("select * from " . $REX['TABLE_PREFIX'] . "article where clang='0'");
    $fields = $add->getFieldnames();
    $adda = new rex_sql();
    // $adda->debugsql = 1;
    for ($i = 0; $i < $add->getRows(); $i++) {
        $adda->setTable($REX['TABLE_PREFIX'] . "article");
        foreach ($fields as $key => $value) {
            if ($value == 'pid') {
                echo '';
            } else {
                if ($value == 'clang') {
                    $adda->setValue('clang', $id);
                } else {
                    if ($value == 'status') {
                        $adda->setValue('status', '0');
                    } else {
                        $adda->setValue($value, rex_addslashes($add->getValue($value)));
                    }
                }
            }
        }
        $adda->insert();
        $add->next();
    }
    $add = new rex_sql();
    $add->setQuery("insert into " . $REX['TABLE_PREFIX'] . "clang set id='{$id}',name='{$name}'");
    // ----- EXTENSION POINT
    rex_register_extension_point('CLANG_ADDED', '', array('id' => $id, 'name' => $name));
    rex_generateAll();
}

 /**
  * CLASS Function:
  * Returns an Array containing article field names
  */
 function getClassVars()
 {
     static $vars = array();
     if (empty($vars)) {
         global $REX;
         $vars = array();
         $file = $REX['INCLUDE_PATH'] . '/generated/articles/' . $REX['START_ARTICLE_ID'] . '.0.article';
         if ($REX['GG'] && file_exists($file)) {
             // Im GetGenerated Modus, die Spaltennamen aus den generated Dateien holen
             include_once $file;
             // da getClassVars() eine statische Methode ist, können wir hier nicht mit $this->getId() arbeiten!
             $genVars = OORedaxo::convertGeneratedArray($REX['ART'][$REX['START_ARTICLE_ID']], 0);
             unset($genVars['article_id']);
             unset($genVars['last_update_stamp']);
             foreach ($genVars as $name => $value) {
                 $vars[] = $name;
             }
         } else {
             // Im Backend die Spalten aus der DB auslesen / via EP holen
             $sql = new rex_sql();
             $sql->setQuery('SELECT * FROM ' . $REX['TABLE_PREFIX'] . 'article LIMIT 0');
             foreach ($sql->getFieldnames() as $field) {
                 $vars[] = $field;
             }
         }
     }
     return $vars;
 }

    $field =& $form->addSelectField('url_table');
    $field->setLabel($I18N->msg('a724_table'));
    $field->setAttribute('onchange', 'url_table(this);');
    $field->setAttribute('style', 'width: ' . $select_w4 . 'px;');
    $select =& $field->getSelect();
    $select->setSize(1);
    $select->addOption($I18N->msg('a724_no_table_selected'), '');
    $sql = new rex_sql();
    $tables = $sql->getArray("SHOW TABLES");
    $cols = array();
    foreach ($tables as $key => $value) {
        $select->addOption(current($value), current($value));
        $sqlf = new rex_sql();
        //    $sqlf->setDebug(true);
        $sqlf->setQuery('SELECT * FROM ' . current($value));
        $fieldnames = $sqlf->getFieldnames();
        foreach ($fieldnames as $fieldname) {
            $fields[current($value)][] = $fieldname;
        }
    }
    $script = '
  <script type="text/javascript">
  <!--

  (function($) {
    var currentShown = null;
    $("#' . $field->getAttribute('id') . '").change(function(){
      if(currentShown) currentShown.hide();
      
      var effectParamsId = "#rex-"+ jQuery(this).val();
      currentShown = $(effectParamsId);

/**
 * Erstellt eine Clang
 *
 * @param $id   Id der Clang
 * @param $name Name der Clang
 * 
 * @return TRUE bei Erfolg, sonst FALSE
 */
function rex_addCLang($id, $name)
{
    global $REX;
    if (isset($REX['CLANG'][$id])) {
        return FALSE;
    }
    $REX['CLANG'][$id] = $name;
    $file = $REX['INCLUDE_PATH'] . "/clang.inc.php";
    rex_replace_dynamic_contents($file, "\$REX['CLANG'] = " . var_export($REX['CLANG'], TRUE) . ";\n");
    $add = new rex_sql();
    $add->setQuery("select * from " . $REX['TABLE_PREFIX'] . "article where clang='0'");
    $fields = $add->getFieldnames();
    $adda = new rex_sql();
    // $adda->debugsql = 1;
    for ($i = 0; $i < $add->getRows(); $i++) {
        $adda->setTable($REX['TABLE_PREFIX'] . "article");
        foreach ($fields as $key => $value) {
            if ($value == 'pid') {
                echo '';
            } else {
                if ($value == 'clang') {
                    $adda->setValue('clang', $id);
                } else {
                    if ($value == 'status') {
                        $adda->setValue('status', '0');
                    } else {
                        $adda->setValue($value, $add->escape($add->getValue($value)));
                    }
                }
            }
        }
        $adda->insert();
        $add->next();
    }
    $add = new rex_sql();
    $add->setQuery("insert into " . $REX['TABLE_PREFIX'] . "clang set id='{$id}',name='{$name}'");
    // ----- EXTENSION POINT
    rex_register_extension_point('CLANG_ADDED', '', array('id' => $id, 'name' => $name));
    return TRUE;
}

/**
 * Kopieren eines Artikels von einer Kategorie in eine andere
 *
 * @param int $id          ArtikelId des zu kopierenden Artikels
 * @param int $to_cat_id   KategorieId in die der Artikel kopiert werden soll
 * 
 * @return boolean FALSE bei Fehler, sonst die Artikel Id des neue kopierten Artikels
 */
function rex_copyArticle($id, $to_cat_id)
{
    global $REX;
    $id = (int) $id;
    $to_cat_id = (int) $to_cat_id;
    $new_id = '';
    // Artikel in jeder Sprache kopieren
    foreach ($REX['CLANG'] as $clang => $clang_name) {
        // validierung der id & from_cat_id
        $from_sql = new rex_sql();
        $qry = 'select * from ' . $REX['TABLE_PREFIX'] . 'article where clang="' . $clang . '" and id="' . $id . '"';
        $from_sql->setQuery($qry);
        if ($from_sql->getRows() == 1) {
            // validierung der to_cat_id
            $to_sql = new rex_sql();
            $to_sql->setQuery('select * from ' . $REX['TABLE_PREFIX'] . 'article where clang="' . $clang . '" and startpage=1 and id="' . $to_cat_id . '"');
            if ($to_sql->getRows() == 1 || $to_cat_id == 0) {
                if ($to_sql->getRows() == 1) {
                    $path = $to_sql->getValue('path') . $to_sql->getValue('id') . '|';
                    $catname = $to_sql->getValue('name');
                } else {
                    // In RootEbene
                    $path = '|';
                    $catname = $from_sql->getValue("name");
                }
                $art_sql = new rex_sql();
                $art_sql->setTable($REX['TABLE_PREFIX'] . 'article');
                if ($new_id == "") {
                    $new_id = $art_sql->setNewId('id');
                }
                $art_sql->setValue('id', $new_id);
                // neuen auto_incrment erzwingen
                $art_sql->setValue('re_id', $to_cat_id);
                $art_sql->setValue('path', $path);
                $art_sql->setValue('catname', $art_sql->escape($catname));
                $art_sql->setValue('catprior', 0);
                $art_sql->setValue('prior', 99999);
                // Artikel als letzten Artikel in die neue Kat einfügen
                $art_sql->setValue('status', 0);
                // Kopierter Artikel offline setzen
                $art_sql->setValue('startpage', 0);
                $art_sql->addGlobalCreateFields();
                // schon gesetzte Felder nicht wieder überschreiben
                $dont_copy = array('id', 'pid', 're_id', 'catname', 'catprior', 'path', 'prior', 'status', 'createdate', 'createuser', 'startpage');
                foreach (array_diff($from_sql->getFieldnames(), $dont_copy) as $fld_name) {
                    $art_sql->setValue($fld_name, $art_sql->escape($from_sql->getValue($fld_name)));
                }
                $art_sql->setValue("clang", $clang);
                $art_sql->insert();
                // ArticleSlices kopieren
                rex_copyContent($id, $new_id, $clang, $clang);
                // Prios neu berechnen
                rex_newArtPrio($to_cat_id, $clang, 1, 0);
            } else {
                return false;
            }
        } else {
            return false;
        }
    }
    // Caches des Artikels löschen, in allen Sprachen
    rex_deleteCacheArticle($id);
    // Caches der Kategorien löschen, da sich derin befindliche Artikel geändert haben
    rex_deleteCacheArticle($to_cat_id);
    return $new_id;
}