WebSVN - OpenConcerto - Diff - Rev 180 and 182 - /trunk/OpenConcerto/src/org/openconcerto/erp/config/update/Updater_1

 /*
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
+ *
- * Copyright 2011 OpenConcerto, by ILM Informatique. All rights reserved.
+ * Copyright 2011-2019 OpenConcerto, by ILM Informatique. All rights reserved.
+ *
  * The contents of this file are subject to the terms of the GNU General Public License Version 3
  * only ("GPL"). You may not use this file except in compliance with the License. You can obtain a
  * copy of the License at http://www.gnu.org/licenses/gpl-3.0.html See the License for the specific
  * language governing permissions and limitations under the License.
 import org.openconcerto.erp.core.sales.quote.element.DevisLogMailSQLElement;
 import org.openconcerto.erp.core.supplychain.stock.element.ComposedItemStockUpdater;
 import org.openconcerto.erp.core.supplychain.stock.element.DepotStockSQLElement;
 import org.openconcerto.erp.core.supplychain.stock.element.StockItem;
 import org.openconcerto.sql.changer.convert.AddMDFields;
+import org.openconcerto.sql.changer.convert.SetFKDefault;
 import org.openconcerto.sql.model.AliasedTable;
 import org.openconcerto.sql.model.DBRoot;
 import org.openconcerto.sql.model.SQLField;
 import org.openconcerto.sql.model.SQLField.Properties;
 import org.openconcerto.sql.model.SQLName;
 import org.openconcerto.sql.model.SQLRowValues;
 import org.openconcerto.sql.model.SQLSelect;
 import org.openconcerto.sql.model.SQLSyntax;
 import org.openconcerto.sql.model.SQLSystem;
 import org.openconcerto.sql.model.SQLTable;
+import org.openconcerto.sql.model.SQLUpdate;
 import org.openconcerto.sql.model.Where;
 import org.openconcerto.sql.preferences.SQLPreferences;
 import org.openconcerto.sql.request.UpdateBuilder;
 import org.openconcerto.sql.utils.AlterTable;
 import org.openconcerto.sql.utils.ChangeTable;
             tClient.getBase().getDataSource().execute(alterClient.asString());
             tClient.getSchema().updateVersion();
             tClient.fetchFields();
+        }
+        if (!tClient.contains("ALERTE")) {
+            final AlterTable alterClient = new AlterTable(tClient);
+            alterClient.addVarCharColumn("ALERTE", 4096);
+            tClient.getBase().getDataSource().execute(alterClient.asString());
+            tClient.getSchema().updateVersion();
+            tClient.fetchFields();
+        }
         final SQLTable tCompteClient = root.getTable("COMPTE_CLIENT_TRANSACTION");
         if (!tCompteClient.contains("ID_MOUVEMENT")) {
             final AlterTable alterClient = new AlterTable(tCompteClient);
             alterClient.addForeignColumn("ID_MOUVEMENT", root.getTable("MOUVEMENT"));
             tClient.getBase().getDataSource().execute(alterClient.asString());
             for (org.openconcerto.sql.model.SQLField sqlField : tableVarSal.getContentFields()) {
                 String field = sqlField.getName();
                 if (!field.equalsIgnoreCase("ID_USER_COMMON_CREATE") && !field.equalsIgnoreCase("ID_USER_COMMON_MODIFY") && !field.equalsIgnoreCase("MODIFICATION_DATE")
-                        && !field.equalsIgnoreCase("CREATION_DATE") && !field.equalsIgnoreCase("HEURE_TRAV")) {
+                        && !field.equalsIgnoreCase("CREATION_DATE") && !field.equalsIgnoreCase("HEURE_TRAV") && !tableVarSal.contains(field + "_DEFAULT_VAL")) {
                     alterB.addColumn(field + "_DEFAULT_VAL", "real DEFAULT 0");
+                }
+            }
             root.getBase().getDataSource().execute(alterB.asString());
             root.getBase().getDataSource().execute(alterB.asString());
             root.refetchTable("FICHE_PAYE");
             root.getSchema().updateVersion();
+        }
+        if (!tableFpaye.contains("PERTE_TPT")) {
+            final AlterTable alterB = new AlterTable(tableFpaye);
+            alterB.addDecimalColumn("PERTE_TPT", 16, 2, BigDecimal.ZERO, false);
+            root.getBase().getDataSource().execute(alterB.asString());
+            root.refetchTable("FICHE_PAYE");
+            root.getSchema().updateVersion();
+        }
         SQLTable tableCpaye = root.findTable("CUMULS_PAYE");
         if (!tableCpaye.contains("TAXE_CM_SAL_C")) {
             final AlterTable alterB = new AlterTable(tableCpaye);
             alterB.addDecimalColumn("TAXE_CM_SAL_C", 16, 2, BigDecimal.ZERO, false);
             alterB.addDecimalColumn("TAXE_CM_PAT_C", 16, 2, BigDecimal.ZERO, false);
             alterArticle.addColumn("DLC", "date");
             tableArticle.getBase().getDataSource().execute(alterArticle.asString());
             tableArticle.getSchema().updateVersion();
             tableArticle.fetchFields();
+        }
+        if (!tableArticle.contains("OPTION")) {
+            final AlterTable alterArticle = new AlterTable(tableArticle);
+            alterArticle.addBooleanColumn("OPTION", Boolean.FALSE, false);
+            tableArticle.getBase().getDataSource().execute(alterArticle.asString());
+            tableArticle.getSchema().updateVersion();
+            tableArticle.fetchFields();
+        }
         SQLTable tableFournisseur = root.getTable("FOURNISSEUR");
         if (!tableFournisseur.contains("NUMERO_TVA")) {
             final AlterTable alter = new AlterTable(tableFournisseur);
             alter.addVarCharColumn("NUMERO_TVA", 128);
             alter.addVarCharColumn("SIRET", 128);
             tableFournisseur.getBase().getDataSource().execute(alter.asString());
             tableFournisseur.getSchema().updateVersion();
             tableFournisseur.fetchFields();
+        }
+        if (!tableFournisseur.contains("CONDITIONS_PORT")) {
+            final AlterTable alter = new AlterTable(tableFournisseur);
+            alter.addVarCharColumn("CONDITIONS_PORT", 128);
+            tableFournisseur.getBase().getDataSource().execute(alter.asString());
+            tableFournisseur.getSchema().updateVersion();
+            tableFournisseur.fetchFields();
+        }
         // POS
         final SQLTable caisseT = root.getTable("CAISSE");
         final String registerLogTableName = "CAISSE_JOURNAL";
         if (!root.contains(registerLogTableName)) {
             root.getBase().getDataSource().execute(alterF.asString());
             root.refetchTable("SAISIE_VENTE_FACTURE");
             root.getSchema().updateVersion();
+        }
+        SQLTable tableCommandeAcompte = root.getTable("COMMANDE_CLIENT");
+        if (!tableCommandeAcompte.contains("T_ACOMPTE")) {
+            final AlterTable alterB = new AlterTable(tableCommandeAcompte);
+            alterB.addLongColumn("T_ACOMPTE", 0L, false);
+            root.getBase().getDataSource().execute(alterB.asString());
+            root.refetchTable("COMMANDE_CLIENT");
+            root.getSchema().updateVersion();
+            SQLTable tableEncaisse = root.getTable("ENCAISSER_MONTANT");
+            final AlterTable alterC = new AlterTable(tableEncaisse);
+            alterC.addForeignColumn("ID_COMMANDE_CLIENT", tableDevisAcompte);
+            root.getBase().getDataSource().execute(alterC.asString());
+            root.refetchTable("ENCAISSER_MONTANT");
+            root.getSchema().updateVersion();
+        }
+        if (!tableDevisAcompte.contains("DATE_LIVRAISON")) {
+            final AlterTable alterB = new AlterTable(tableDevisAcompte);
+            alterB.addColumn("DATE_LIVRAISON", "date");
+            alterB.addVarCharColumn("TRANSFORMATION", 200);
+            root.getBase().getDataSource().execute(alterB.asString());
+            root.refetchTable("DEVIS");
+            root.getSchema().updateVersion();
+        }
         // Paye Simplifiée
         if (!tableFpaye.contains("ALLEGEMENT_COTISATION")) {
             final AlterTable alterB = new AlterTable(tableFpaye);
             alterB.addDecimalColumn("ALLEGEMENT_COTISATION", 16, 2, BigDecimal.ZERO, false);
             alterB.addDecimalColumn("CICE", 16, 2, BigDecimal.ZERO, false);
             root.refetchTable(root.getTable("ARTICLE").getName());
             root.getSchema().updateVersion();
+        }
         // Gestion multidepot
+        final SQLTable userT = root.findTable("USER_COMMON");
+        {
             // Ajout table depot
             if (!root.contains("DEPOT_STOCK")) {
                 final SQLCreateTable createTable = new SQLCreateTable(root, "DEPOT_STOCK");
                 createTable.addVarCharColumn("CODE", 25);
                 createTable.addVarCharColumn("NOM", 256);
                 createTable.addVarCharColumn("UI_LOCK", 256);
-                createTable.addForeignColumn("ID_USER_UI_LOCK", root.findTable("USER_COMMON"));
+                createTable.addForeignColumn("ID_USER_UI_LOCK", userT);
                 // sqlRowValues.put("UI_LOCK", "ro");
                 // sqlRowValues.put("ID_USER_UI_LOCK", 2);
                 try {
                     root.getBase().getDataSource().execute(createTable.asString());
             for (org.openconcerto.sql.model.SQLField sqlField : tableVarSal.getContentFields()) {
                 String field = sqlField.getName();
                 if (!field.equalsIgnoreCase("ID_USER_COMMON_CREATE") && !field.equalsIgnoreCase("ID_USER_COMMON_MODIFY") && !field.equalsIgnoreCase("MODIFICATION_DATE")
-                        && !field.equalsIgnoreCase("CREATION_DATE") && !field.endsWith("_DEFAULT_VAL")) {
+                        && !field.equalsIgnoreCase("CREATION_DATE") && !field.endsWith("_DEFAULT_VAL") && !tableVarSal.contains(field + "_CUMUL_VAL")) {
                     alterB.addColumn(field + "_CUMUL_VAL", "real DEFAULT 0");
+                }
+            }
             root.getBase().getDataSource().execute(alterB.asString());
             root.getBase().getDataSource().execute(alterB.asString());
             root.refetchTable("BON_DE_LIVRAISON");
             root.getSchema().updateVersion();
+        }
+        if (!tableBL.contains("VERROU_FACTURATION")) {
+            final AlterTable alterB = new AlterTable(tableBL);
+            alterB.addBooleanColumn("VERROU_FACTURATION", Boolean.FALSE, false);
+            root.getBase().getDataSource().execute(alterB.asString());
+            root.refetchTable("BON_DE_LIVRAISON");
+            root.getSchema().updateVersion();
+        }
         // fix stock
+        {
             SQLTable tableStock = root.getTable("STOCK");
             // Doublon depot stock
+                    }
+                }
+            }
+            // Remove useless since 1.7.1
-            SQLSelect selArt = new SQLSelect();
+            // SQLSelect selArt = new SQLSelect();
-            selArt.addSelectStar(tableArt);
+            // selArt.addSelectStar(tableArt);
-            Where w = new Where(tableArt.getField("ID_STOCK"), "=", 1);
+            // Where w = new Where(tableArt.getField("ID_STOCK"), "=", 1);
-            selArt.setWhere(w);
+            // selArt.setWhere(w);
-            List<SQLRow> badStock = SQLRowListRSH.execute(selArt);
+            // List<SQLRow> badStock = SQLRowListRSH.execute(selArt);
-            for (SQLRow sqlRow : badStock) {
+            // for (SQLRow sqlRow : badStock) {
-                initStock(sqlRow);
+            // initStock(sqlRow);
-            }
+            // }
+        }
         // Tarification client par quantite
         if (root.getTable("TARIF_ARTICLE_CLIENT") == null) {
             final SQLCreateTable createTableQtyTarif = new SQLCreateTable(root, "TARIF_ARTICLE_CLIENT");
             root.getSchema().updateVersion();
+        }
         final SQLTable tableSalarie = root.getTable("SALARIE");
         if (!tableSalarie.contains("ID_USER_COMMON")) {
             final AlterTable alter = new AlterTable(tableSalarie);
-            alter.addForeignColumn("ID_USER_COMMON", root.findTable("USER_COMMON"));
+            alter.addForeignColumn("ID_USER_COMMON", userT);
             exec(alter);
             root.refetchTable(tableSalarie.getName());
             root.getSchema().updateVersion();
+        }
             tableFactureF.getBase().getDataSource().execute(alter.asString());
             tableFactureF.getSchema().updateVersion();
             tableVF.fetchFields();
+        }
+        SQLTable tableNumAuto = root.getTable("NUMEROTATION_AUTO");
+        if (!tableNumAuto.contains("ARTICLE_FORMAT")) {
+            final AlterTable alterNumero = new AlterTable(tableNumAuto);
+            alterNumero.addVarCharColumn("ARTICLE_FORMAT", 128);
+            alterNumero.addIntegerColumn("ARTICLE_START", 1);
+            root.getBase().getDataSource().execute(alterNumero.asString());
+            root.refetchTable("NUMEROTATION_AUTO");
+            root.getSchema().updateVersion();
+        }
+        if (!tableArticle.contains("VIRTUEL")) {
+            final SQLCreateTable createTableDeclinaisonCouleur = new SQLCreateTable(root, "ARTICLE_DECLINAISON_COULEUR");
+            createTableDeclinaisonCouleur.addVarCharColumn("NOM", 256);
+            root.getBase().getDataSource().execute(createTableDeclinaisonCouleur.asString());
+            InstallationPanel.insertUndef(createTableDeclinaisonCouleur);
+            root.refetchTable("ARTICLE_DECLINAISON_COULEUR");
+            root.getSchema().updateVersion();
+            final SQLCreateTable createTableDeclinaisonTaille = new SQLCreateTable(root, "ARTICLE_DECLINAISON_TAILLE");
+            createTableDeclinaisonTaille.addVarCharColumn("NOM", 256);
+            root.getBase().getDataSource().execute(createTableDeclinaisonTaille.asString());
+            InstallationPanel.insertUndef(createTableDeclinaisonTaille);
+            root.refetchTable("ARTICLE_DECLINAISON_TAILLE");
+            root.getSchema().updateVersion();
+            final AlterTable alter = new AlterTable(tableArticle);
+            alter.addBooleanColumn("VIRTUEL", false, false);
+            alter.addForeignColumn("ID_ARTICLE_VIRTUEL_PERE", tableArticle);
+            alter.addForeignColumn("ID_ARTICLE_DECLINAISON_TAILLE", root.getTable("ARTICLE_DECLINAISON_TAILLE"));
+            alter.addForeignColumn("ID_ARTICLE_DECLINAISON_COULEUR", root.getTable("ARTICLE_DECLINAISON_COULEUR"));
+            tableArticle.getBase().getDataSource().execute(alter.asString());
+            tableArticle.getSchema().updateVersion();
+            tableArticle.fetchFields();
+        }
+        for (String string : achatItems) {
+            boolean alter = false;
+            SQLTable tableItems = root.getTable(string);
+            final AlterTable t = new AlterTable(tableItems);
+            if (!tableItems.getFieldsName().contains("ID_ARTICLE_DECLINAISON_TAILLE")) {
+                t.addForeignColumn("ID_ARTICLE_DECLINAISON_TAILLE", root.getTable("ARTICLE_DECLINAISON_TAILLE"));
+                alter = true;
+            }
+            if (!tableItems.getFieldsName().contains("ID_ARTICLE_DECLINAISON_COULEUR")) {
+                t.addForeignColumn("ID_ARTICLE_DECLINAISON_COULEUR", root.getTable("ARTICLE_DECLINAISON_COULEUR"));
+                alter = true;
+            }
+            if (alter) {
+                tableItems.getBase().getDataSource().execute(t.asString());
+                tableItems.getSchema().updateVersion();
+                tableItems.fetchFields();
+            }
+        }
+        for (String tableName : tableElementWithTable) {
+            final SQLTable tableToDecl = root.getTable(tableName);
+            boolean alter = false;
+            final AlterTable alterDecl = new AlterTable(tableToDecl);
+            if (!tableToDecl.getFieldsName().contains("ID_ARTICLE_DECLINAISON_TAILLE")) {
+                alterDecl.addForeignColumn("ID_ARTICLE_DECLINAISON_TAILLE", root.getTable("ARTICLE_DECLINAISON_TAILLE"));
+                alter = true;
+            }
+            if (!tableToDecl.getFieldsName().contains("ID_ARTICLE_DECLINAISON_COULEUR")) {
+                alterDecl.addForeignColumn("ID_ARTICLE_DECLINAISON_COULEUR", root.getTable("ARTICLE_DECLINAISON_COULEUR"));
+                alter = true;
+            }
+            if (alter) {
+                tableToDecl.getBase().getDataSource().execute(alterDecl.asString());
+                tableToDecl.getSchema().updateVersion();
+                tableToDecl.fetchFields();
+            }
+        }
+        // Création de la table Tarif promotion
+        if (!root.contains("TARIF_PROMOTION")) {
+            SQLCreateTable createTarif = new SQLCreateTable(root, "TARIF_PROMOTION");
+            createTarif.addVarCharColumn("NOM", 256);
+            createTarif.addColumn("START", "date");
+            createTarif.addColumn("END", "date");
+            root.getBase().getDataSource().execute(createTarif.asString());
+            InstallationPanel.insertUndef(createTarif);
+            tableDevis.getSchema().updateVersion();
+            root.refetchTable(createTarif.getName());
+        }
+        // Création de la table article Tarif promotion
+        if (!root.contains("ARTICLE_TARIF_PROMOTION")) {
+            SQLCreateTable createTarif = new SQLCreateTable(root, "ARTICLE_TARIF_PROMOTION");
+            createTarif.addForeignColumn("ID_DEVISE", root.findTable("DEVISE", true));
+            createTarif.addForeignColumn("ID_TAXE", root.findTable("TAXE", true));
+            createTarif.addForeignColumn("ID_TARIF_PROMOTION", root.findTable("TARIF_PROMOTION", true));
+            createTarif.addForeignColumn("ID_ARTICLE", root.findTable("ARTICLE", true));
+            createTarif.addIntegerColumn("QTE", 1);
+            createTarif.addDecimalColumn("PV_HT", 16, 6, BigDecimal.ZERO, false);
+            createTarif.addDecimalColumn("PV_TTC", 16, 6, BigDecimal.ZERO, false);
+            createTarif.addDecimalColumn("PRIX_METRIQUE_VT_1", 16, 6, BigDecimal.ZERO, false);
+            createTarif.addDecimalColumn("PRIX_METRIQUE_VT_2", 16, 6, BigDecimal.ZERO, false);
+            createTarif.addDecimalColumn("PRIX_METRIQUE_VT_3", 16, 6, BigDecimal.ZERO, false);
+            root.getBase().getDataSource().execute(createTarif.asString());
+            InstallationPanel.insertUndef(createTarif);
+            tableDevis.getSchema().updateVersion();
+            root.refetchTable(createTarif.getName());
+        }
+        if (!root.contains("TAXE_CATEGORIE_COMPTABLE")) {
+            final SQLCreateTable createTableTaxeCat = new SQLCreateTable(root, "TAXE_CATEGORIE_COMPTABLE");
+            createTableTaxeCat.addForeignColumn("ID_CATEGORIE_COMPTABLE", root.getTable("CATEGORIE_COMPTABLE"));
+            createTableTaxeCat.addForeignColumn("ID_TAXE", root.getTable("TAXE"));
+            createTableTaxeCat.addForeignColumn("ID_COMPTE_PCE_VENTE", root.getTable("COMPTE_PCE"));
+            createTableTaxeCat.addForeignColumn("ID_COMPTE_PCE_ACHAT", root.getTable("COMPTE_PCE"));
+            try {
+                root.getBase().getDataSource().execute(createTableTaxeCat.asString());
+                InstallationPanel.insertUndef(createTableTaxeCat);
+                root.refetchTable("TAXE_CATEGORIE_COMPTABLE");
+                root.getSchema().updateVersion();
+            } catch (SQLException ex) {
+                throw new IllegalStateException("Erreur lors de la création de la table " + "TAXE_CATEGORIE_COMPTABLE", ex);
+            }
+        }
+        if (!root.contains("LOT_RECEPTION")) {
+            SQLCreateTable createLotReception = new SQLCreateTable(root, "LOT_RECEPTION");
+            createLotReception.addDateAndTimeColumn("DATE_RECEPTION");
+            createLotReception.addVarCharColumn("FOURNISSEUR", 256);
+            createLotReception.addVarCharColumn("ARTICLE", 256);
+            createLotReception.addForeignColumn("ID_ARTICLE", root.findTable("ARTICLE", true));
+            createLotReception.addForeignColumn("ID_DEPOT_STOCK", root.findTable("DEPOT_STOCK", true));
+            createLotReception.addDecimalColumn("QUANTITE", 16, 6, BigDecimal.ONE, false);
+            createLotReception.addVarCharColumn("NUMERO_LOT", 256);
+            createLotReception.addVarCharColumn("NUMERO_SERIE", 256);
+            createLotReception.addDateAndTimeColumn("DLC");
+            createLotReception.addDateAndTimeColumn("DLUO");
+            createLotReception.addForeignColumn("ID_BON_RECEPTION_ELEMENT", root.findTable("BON_RECEPTION_ELEMENT", true));
+            root.getBase().getDataSource().execute(createLotReception.asString());
+            InstallationPanel.insertUndef(createLotReception);
+            SQLCreateTable createLotLivraison = new SQLCreateTable(root, "LOT_LIVRAISON");
+            createLotLivraison.addDateAndTimeColumn("DATE_LIVRAISON");
+            createLotLivraison.addVarCharColumn("CLIENT", 256);
+            createLotLivraison.addVarCharColumn("ARTICLE", 256);
+            createLotLivraison.addForeignColumn("ID_ARTICLE", root.findTable("ARTICLE", true));
+            createLotLivraison.addForeignColumn("ID_DEPOT_STOCK", root.findTable("DEPOT_STOCK", true));
+            createLotLivraison.addDecimalColumn("QUANTITE", 16, 6, BigDecimal.ONE, false);
+            createLotLivraison.addVarCharColumn("NUMERO_LOT", 256);
+            createLotLivraison.addVarCharColumn("NUMERO_SERIE", 256);
+            createLotLivraison.addDateAndTimeColumn("DLC");
+            createLotLivraison.addDateAndTimeColumn("DLUO");
+            createLotLivraison.addForeignColumn("ID_BON_DE_LIVRAISON_ELEMENT", root.findTable("BON_DE_LIVRAISON_ELEMENT", true));
+            root.getBase().getDataSource().execute(createLotLivraison.asString());
+            InstallationPanel.insertUndef(createLotLivraison);
+        }
+        if (!root.contains("LOT")) {
+            SQLCreateTable createLot = new SQLCreateTable(root, "LOT");
+            createLot.addForeignColumn("ID_STOCK", root.findTable("STOCK", true));
+            createLot.addDecimalColumn("QUANTITE", 16, 6, BigDecimal.ONE, false);
+            createLot.addVarCharColumn("NUMERO_LOT", 256);
+            createLot.addVarCharColumn("NUMERO_SERIE", 256);
+            createLot.addDateAndTimeColumn("DLC");
+            createLot.addDateAndTimeColumn("DLUO");
+            root.getBase().getDataSource().execute(createLot.asString());
+            InstallationPanel.insertUndef(createLot);
+            SQLCreateTable createTransfertStock = new SQLCreateTable(root, "TRANSFERT_STOCK");
+            createTransfertStock.addDateAndTimeColumn("DATE");
+            createTransfertStock.addForeignColumn("ID_ARTICLE", root.findTable("ARTICLE", true));
+            createTransfertStock.addForeignColumn("ID_DEPOT_STOCK_SOURCE", root.findTable("DEPOT_STOCK", true));
+            createTransfertStock.addForeignColumn("ID_DEPOT_STOCK_DEST", root.findTable("DEPOT_STOCK", true));
+            createTransfertStock.addDecimalColumn("QUANTITE", 16, 6, BigDecimal.ONE, false);
+            createTransfertStock.addVarCharColumn("NUMEROS_SERIE", 50000);
+            createTransfertStock.addVarCharColumn("NUMEROS_LOT", 50000);
+            createTransfertStock.addVarCharColumn("CONTEXTE", 256);
+            root.getBase().getDataSource().execute(createTransfertStock.asString());
+            InstallationPanel.insertUndef(createTransfertStock);
+            final AlterTable alterArticle = new AlterTable(tableArticle);
+            alterArticle.addBooleanColumn("NUMERO_LOT_REQUIS", false, false);
+            alterArticle.addBooleanColumn("NUMERO_SERIE_REQUIS", false, false);
+            alterArticle.addBooleanColumn("DLC_REQUIS", false, false);
+            alterArticle.addBooleanColumn("DLUO_REQUIS", false, false);
+            tableArticle.getBase().getDataSource().execute(alterArticle.asString());
+            tableArticle.getSchema().updateVersion();
+            tableArticle.fetchFields();
+            final AlterTable alterBonReceptionElement = new AlterTable(root.getTable("BON_RECEPTION_ELEMENT"));
+            alterBonReceptionElement.addForeignColumn("ID_LOT", createLot);
+            tableArticle.getBase().getDataSource().execute(alterBonReceptionElement.asString());
+            final AlterTable alterBonLivraisonElement = new AlterTable(root.getTable("BON_DE_LIVRAISON"));
+            alterBonLivraisonElement.addForeignColumn("ID_LOT", createLot);
+            tableArticle.getBase().getDataSource().execute(alterBonLivraisonElement.asString());
+            tableArticle.getSchema().updateVersion();
+            root.refetch();
+        }
+        SQLTable tableBR = root.getTable("BON_RECEPTION");
+        SQLTable tableModele = root.getTable("MODELE");
+        if (!tableBR.contains("ID_MODELE")) {
+            AlterTable a = new AlterTable(tableBR);
+            a.addForeignColumn("ID_MODELE", tableModele);
+            root.getBase().getDataSource().execute(a.asString());
+            tableBR.getSchema().updateVersion();
+            root.refetchTable(tableBR.getName());
+        }
+        SQLTable typeModele = tableModele.getForeignTable("ID_TYPE_MODELE");
+        SQLSelect sel = new SQLSelect();
+        sel.addSelect(typeModele.getKey());
+        sel.setWhere(new Where(typeModele.getField("TABLE"), "=", "BON_RECEPTION"));
+        List<SQLRow> l = SQLRowListRSH.execute(sel);
+        if (l.isEmpty()) {
+            SQLRowValues rowVals = new SQLRowValues(typeModele);
+            rowVals.put("TABLE", "BON_RECEPTION");
+            rowVals.put("NOM", "Bon de réception");
+            rowVals.put("DEFAULT_MODELE", "BonReception");
+            rowVals.commit();
+        }
+        // Fix undefined
+        new SetFKDefault(root.getDBSystemRoot()).changeAll(root);
+        List<SQLUpdate> ups = new ArrayList<>();
+        if (userT.getUndefinedIDNumber() != null) {
+            for (SQLField userF : root.getDBSystemRoot().getGraph().getReferentKeys(userT)) {
+                if (userF.getTable().getDBRoot() == root) {
+                    SQLUpdate up = new SQLUpdate(Where.isNull(userF));
+                    up.add(userF, userT.getUndefinedIDNumber());
+                    ups.add(up);
+                }
+            }
+        }
+        if (!ups.isEmpty()) {
+            SQLUpdate.executeMultipleWithBatch(root.getDBSystemRoot(), ups);
+            System.err.println("Updater_1_5.update() fixed " + ups.size() + " error(s) on FK to USER_COMMON");
+        } else {
+            System.err.println("Updater_1_5.update() no error on FK to USER_COMMON");
+        }
+    }
     public static void initStock(SQLRow rowArticle, int idDepot) {
         SQLSelect selStock = new SQLSelect();

Dépôt officiel du code source de l'ERP OpenConcerto

svn://code.openconcerto.org/openconcerto

(root)/trunk/OpenConcerto/src/org/openconcerto/erp/config/update/Updater_1_5.java - Rev 180 → 182