PHP Database::get_current_seq Examples

Example #1

File: dossier.inc.php Project: Kloadut/noalyss_ynh

         alert(_('Désolé vous devez migrer ce modèle en unicode'));
         echo '<span class="error">';
         echo _('le modele ') . domaine . 'mod' . $_POST["FMOD_ID"] . _(" doit être migré en unicode.");
         echo _('Pour le passer en unicode, faites-en un backup puis restaurez le fichier reçu') . '</span>';
         echo HtmlInput::button_anchor('Retour', 'admin_repo.php?action=dossier_mgt');
         return;
     }
 }
 /*
  * Insert new dossier with description
  */
 $desc = HtmlInput::default_value_post("DESCRIPTION", "");
 try {
     $repo->start();
     $Res = $repo->exec_sql("insert into ac_dossier(dos_name,dos_description)\n                           values (\$1,\$2)", array($dos, $desc));
     $l_id = $repo->get_current_seq('dossier_id');
     $repo->commit();
 } catch (Exception $e) {
     $msg = _("Desole la creation de ce dossier a echoue,\n la cause la plus probable est" . ' deux fois le même nom de dossier');
     alert($msg);
     $l_id = 0;
     $repo->rollback();
 }
 // If the id is not null, name successfully inserted
 // Database created
 if ($l_id != 0) {
     /*
      * We don't create  and empty database
      */
     if ($template != 0) {
         //--

Example #2

File: modele.inc.php Project: Kloadut/noalyss_ynh

// IF FMOD_NAME is posted then must add a template
if (isset($_POST["FMOD_NAME"])) {
    $encoding = $cn->get_value("select encoding from pg_database  where " . " datname='" . domaine . 'dossier' . sql_string($_POST["FMOD_DBID"]) . "'");
    if ($encoding != 6) {
        alert(_('Désolé vous devez migrer ce modèle en unicode'));
        echo '<span class="error">' . _('la base de donnée') . " " . domaine . 'mod' . $_POST["FMOD_DBID"] . " " . _("doit être migrée en unicode") . "</span>";
        echo '<span class="error"> ' . _("Pour le passer en unicode, faites-en un backup puis restaurez le fichier reçu") . '</span>';
        echo HtmlInput::button_anchor(_('Retour'), 'admin_repo.php?action=dossier_mgt');
        return;
    }
    $mod_name = sql_string($_POST["FMOD_NAME"]);
    $mod_desc = sql_string($_POST["FMOD_DESC"]);
    if ($mod_name != null) {
        $Res = $cn->exec_sql("insert into modeledef(mod_name,mod_desc)\n                           values ('" . $mod_name . "'," . "'" . $mod_desc . "')");
        // get the mod_id
        $l_id = $cn->get_current_seq('s_modid');
        if ($l_id != 0) {
            $Sql = sprintf("CREATE DATABASE %sMOD%d encoding='UTF8' TEMPLATE %sDOSSIER%s", domaine, $l_id, domaine, $_POST["FMOD_DBID"]);
            ob_start();
            if ($cn->exec_sql($Sql) == false) {
                ob_end_clean();
                echo "<h2 class=\"error\"> Base de donn&eacute;e " . domaine . "dossier" . $_POST['FMOD_DBID'] . "  " . _("est accèd&eacute;e, d&eacute;connectez-vous en d'abord") . "</h2>";
                $Res = $cn->exec_sql("delete from modeledef where mod_id=" . $l_id);
                exit;
            }
        }
    }
    // if $mod_name != null
    $cn_mod = new Database($l_id, 'mod');
    // Clean some tables
    $Res = $cn_mod->exec_sql("select distinct jr_pj from jrn where jr_pj is not null ");