\n"; /** * Tables presentes dans la base de donnees */ // Requete en fonction du type de base de donnees if (OM_DB_PHPTYPE == "mysql") { $sql = "SHOW TABLES FROM `".OM_DB_SCHEMA.OM_DB_DATABASE."`"; } elseif (OM_DB_PHPTYPE == "pgsql") { $sql = "select tablename from pg_tables where schemaname='".OM_DB_SCHEMA."'"; $sql_view = "select viewname from pg_views where schemaname='".OM_DB_SCHEMA."'"; $res_view = $f->db->query($sql_view); // Logger $f->addToLog("scr/gen.php: db->query(\"".$sql_view."\");", VERBOSE_MODE); $f->isDatabaseError($res_view); } else { $message = _("Le generateur ne prend pas en charge le type de base de donnees que vous utilisez :"); $message .= " ".OM_DB_PHPTYPE; $f->displayMessage("error", $message); die(); } // Execution de la requete $res = $f->db->query($sql); // Logger $f->addToLog("scr/gen.php: db->query(\"".$sql."\");", VERBOSE_MODE); $f->isDatabaseError($res); // echo "

\n"; // echo "\t

"; echo _("Generation")." "._("objet")." : ".OM_DB_DATABASE." ( ".OM_DB_PHPTYPE." ) "; echo "

\n"; // echo "\t

\n"; // while ($row =& $res->fetchRow()) { // les tables .seq ne sont pas affichees (mysql) if (substr($row[0],-3,3) != "seq") { echo "

"; echo ""; // echo ""; echo ""; echo _("Supprimer"); echo ""; echo ""; // echo " "; // echo ""; echo ""; echo _("Generer"); echo ""; echo ""; // echo " "; // echo $row[0]; // echo ""; echo "

\n"; } } // echo "

\n"; // echo "

\n"; if (OM_DB_PHPTYPE == "pgsql") { echo "

\n"; // echo "\t

"; echo _("Generation")." "._("vues")." : ".OM_DB_DATABASE." ( ".OM_DB_PHPTYPE." ) "; echo "

\n"; // echo "\t

\n"; // while ($row1 =& $res_view->fetchRow()) { echo "

"; echo ""; echo ""; echo ""; echo _("Supprimer"); echo ""; echo ""; // echo " "; // echo ""; echo ""; echo _("Generer"); echo ""; echo ""; // echo " "; // echo $row1[0]; // echo ""; echo "

\n"; } // echo "

\n"; // echo "

\n"; } /** * Assistants permettant la creation d'etats, sous etats, lettres types ou * l'import de ces memes elements depuis des anciennes versions d'openMairie */ // $assistants = array( 0 => array("href" => "genimport.php", "title" => _("Migration etat, sous etat, lettre type")), 1 => array("href" => "genetat.php", "title" => _("Creation etat")), 2 => array("href" => "gensousetat.php", "title" => _("Creation sous etat")), 3 => array("href" => "genlettretype.php", "title" => _("Creation lettre type")), ); // echo "

\n"; // echo "\t

"; echo _("Assistants")." : ".OM_DB_DATABASE." ( ".OM_DB_PHPTYPE." ) "; echo "

\n"; // echo "\t

\n"; // foreach ($assistants as $assistant) { echo "

"; echo ""; // echo ""; echo $assistant["title"]; echo ""; // echo ""; echo "

\n"; } // echo "

\n"; // echo "

\n"; /** * Fermeture */ // echo "