"._("generateur")." -> "._("om_lettretype")
);
/**
* Description de la page
*/
$description = _("cet assistant vous permet de creer des lettres type ".
"directement a partir de vos tables ");
$f->displayDescription($description);
/**
*
*/
set_time_limit(3600);
$DEBUG=0;
if (isset($_POST['choice-import']) and $_POST['choice-import'] != "---") {
$obj = $_POST['choice-import'];
} elseif(isset($_GET['obj'])) {
$obj = $_GET['obj'];
} else {
$obj = "";
}
if(isset($_GET['validation'])) {
$validation = $_GET['validation'];
} else {
$validation = 0;
}
if (isset($_POST['choice-field'])){
$field=$_POST['choice-field'];
}else{
$field='';
}
/**
* On liste les tables
*/
// tab
$tab = array();
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='".$f -> schema.
"' UNION select (viewname||' [vue]') from pg_views where schemaname='".$f -> schema."'"; // ***
}
$res1 = $f -> db -> query ($sql);
$f->isDatabaseError($res1);
$k=0;
while ($row=& $res1->fetchRow()){
if(substr($row[0],-3,3)!= "seq" ){
$k++;
array_push($tab, $f->tablebase[$k]= $row[0]);
}
}
asort($tab);
echo "\n\n";
/**
* choix des champs
*/
if ($obj != "" and $field=='') {
//
echo "\n
\n";
echo "
";
echo "";
echo "";
echo "\n";
}
/**
* transfert dans la base
*/
if ($obj != "" and $field!='') {
//
$f->db->autoCommit(false);
//
echo "\n
";
echo "";
//
$f->db->commit();
}
?>