[Noalyss-commit] [noalyss] 08/16: Administration : add information about system update all the databases + account_repository

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit ba45ecfa47e758f85bc9a9b67802f651f1d55126
Author: Dany De Bontridder <address@hidden>
Date:   Mon Oct 19 16:17:06 2015 +0200

    Administration : add information about system
    update all the databases + account_repository
---
 include/upgrade.inc.php |  107 +++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 107 insertions(+), 0 deletions(-)

diff --git a/include/upgrade.inc.php b/include/upgrade.inc.php
new file mode 100644
index 0000000..877a5f3
--- /dev/null
+++ b/include/upgrade.inc.php
@@ -0,0 +1,107 @@
+<?php
+
+/*
+ *   This file is part of PhpCompta.
+ *
+ *   PhpCompta is free software; you can redistribute it and/or modify
+ *   it under the terms of the GNU General Public License as published by
+ *   the Free Software Foundation; either version 2 of the License, or
+ *   (at your option) any later version.
+ *
+ *   PhpCompta is distributed in the hope that it will be useful,
+ *   but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *   GNU General Public License for more details.
+ *
+ *   You should have received a copy of the GNU General Public License
+ *   along with PhpCompta; if not, write to the Free Software
+ *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+ */
+// Copyright (2014) Author Dany De Bontridder <address@hidden>
+
+if (!defined('ALLOWED'))
+    die('Appel direct ne sont pas permis');
+
+/**
+ * @file
+ * @brief Upgrade all the database : the central repository , the templates and
+ * the folder
+ * @param $rep db connection to central repository
+ */
+?>
+<form method="get" id="frm_upg_all" onsubmit="return 
confirm_box('frm_upg_all','<?php echo _('Confirmez')?>')">
+    <input type="hidden" name="sb" value="upg_all">
+    <input type="hidden" name="action" value="upgrade">
+    <input type="submit" class="button" name="submit_upg_all" 
id="submit_upg_all" value="<?php echo _('Tout mettre à jour')?>">
+</form>
+
+<?php
+$sb= HtmlInput::default_value_get("sb", "none");
+if ($sb === "upg_all" && (!defined('MULTI')||(defined('MULTI')&&MULTI==1)))
+{
+    /* If multi folders */
+    $Resdossier=$rep->exec_sql("select dos_id, dos_name from ac_dossier");
+    $MaxDossier=$rep->size($Resdossier);
+
+    //----------------------------------------------------------------------
+    // Upgrade the folders
+    //----------------------------------------------------------------------
+    for ($e=0; $e<$MaxDossier; $e++)
+    {
+        $db_row=Database::fetch_array($Resdossier, $e);
+        echo "<h3>Patching ".$db_row['dos_name'].'</h3>';
+
+        $name=$rep->format_name($db_row['dos_id'], 'dos');
+
+        if ($rep->exist_database($name)>0)
+        {
+            $db=new Database($db_row['dos_id'], 'dos');
+            $db->apply_patch($db_row['dos_name']);
+            Dossier::synchro_admin($db_row['dos_id']);
+        }
+        else
+        {
+            echo_warning(_("Dossier inexistant")." $name");
+        }
+    }
+
+    //----------------------------------------------------------------------
+    // Upgrade the template
+    //----------------------------------------------------------------------
+    $Resdossier=$rep->exec_sql("select mod_id, mod_name from modeledef");
+    $MaxDossier=$rep->size();
+    echo "<h2>"._("Mise à modèle")."</h2>";
+
+    for ($e=0; $e<$MaxDossier; $e++)
+    {
+        $db_row=Database::fetch_array($Resdossier, $e);
+        echo "<h3>Patching ".$db_row['mod_name']."</h3>";
+        $name=$rep->format_name($db_row['mod_id'], 'mod');
+
+        if ($rep->exist_database($name)>0)
+        {
+            $db=new Database($db_row['mod_id'], 'mod');
+            $db->apply_patch($db_row['mod_name']);
+        }
+        else
+        {
+            echo_warning(_("Modèle inexistant")." $name");
+        }
+    }
+    //----------------------------------------------------------------------
+    // Upgrade the account_repository
+    //----------------------------------------------------------------------
+    echo "<h2>"._("Mise à jour de la base de données principale")."</h2>";
+    $cn=new Database();
+    if (DEBUG==false)
+        ob_start();
+    $MaxVersion=DBVERSIONREPO-1;
+    for ($i=4; $i<=$MaxVersion; $i++)
+    {
+        if ($cn->get_version()<=$i)
+        {
+            $cn->execute_script('sql/patch/ac-upgrade'.$i.'.sql');
+        }
+    }
+}
+?>