OpenConcerto

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

svn://code.openconcerto.org/openconcerto

Rev

Rev 177 | Rev 182 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
18 ilm 1 
/*
2 
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
3 
 *
4 
 * Copyright 2011 OpenConcerto, by ILM Informatique. All rights reserved.
5 
 *
6 
 * The contents of this file are subject to the terms of the GNU General Public License Version 3
7 
 * only ("GPL"). You may not use this file except in compliance with the License. You can obtain a
8 
 * copy of the License at http://www.gnu.org/licenses/gpl-3.0.html See the License for the specific
9 
 * language governing permissions and limitations under the License.
10 
 *
11 
 * When distributing the software, include this License Header Notice in each file.
12 
 */
13 
 
14 
 package org.openconcerto.erp.config;
15 
 
16 
import static java.util.Arrays.asList;
132 ilm 17 
 
18 ilm 18 
import org.openconcerto.erp.core.common.element.AdresseCommonSQLElement;
19 
import org.openconcerto.erp.core.common.element.AdresseSQLElement;
83 ilm 20 
import org.openconcerto.erp.core.common.element.BanqueSQLElement;
18 ilm 21 
import org.openconcerto.erp.core.common.element.DepartementSQLElement;
19 ilm 22 
import org.openconcerto.erp.core.common.element.LangueSQLElement;
18 ilm 23 
import org.openconcerto.erp.core.common.element.MoisSQLElement;
24 
import org.openconcerto.erp.core.common.element.NumerotationAutoSQLElement;
25 
import org.openconcerto.erp.core.common.element.PaysSQLElement;
156 ilm 26 
import org.openconcerto.erp.core.common.element.SocieteCommonSQLElement;
18 ilm 27 
import org.openconcerto.erp.core.common.element.StyleSQLElement;
28 
import org.openconcerto.erp.core.common.element.TitrePersonnelSQLElement;
180 ilm 29 
import org.openconcerto.erp.core.customerrelationship.customer.element.AgenceSQLElement;
93 ilm 30 
import org.openconcerto.erp.core.customerrelationship.customer.element.ClientDepartementSQLElement;
174 ilm 31 
import org.openconcerto.erp.core.customerrelationship.customer.element.ComptaContactSQLElement.ContactAdministratifSQLElement;
32 
import org.openconcerto.erp.core.customerrelationship.customer.element.ComptaContactSQLElement.ContactFournisseurSQLElement;
33 
import org.openconcerto.erp.core.customerrelationship.customer.element.ComptaContactSQLElement.ContactSQLElement;
34 
import org.openconcerto.erp.core.customerrelationship.customer.element.ComptaContactSQLElement.ContactSalarieSQLElement;
142 ilm 35 
import org.openconcerto.erp.core.customerrelationship.customer.element.CompteClientTransactionSQLELement;
18 ilm 36 
import org.openconcerto.erp.core.customerrelationship.customer.element.CourrierClientSQLElement;
93 ilm 37 
import org.openconcerto.erp.core.customerrelationship.customer.element.CustomerCategorySQLElement;
38 
import org.openconcerto.erp.core.customerrelationship.customer.element.CustomerSQLElement;
18 ilm 39 
import org.openconcerto.erp.core.customerrelationship.customer.element.ModeleCourrierClientSQLElement;
40 
import org.openconcerto.erp.core.customerrelationship.customer.element.ReferenceClientSQLElement;
41 
import org.openconcerto.erp.core.customerrelationship.customer.element.RelanceSQLElement;
42 
import org.openconcerto.erp.core.customerrelationship.customer.element.TypeLettreRelanceSQLElement;
174 ilm 43 
import org.openconcerto.erp.core.customerrelationship.mail.EmailTemplateSQLElement;
142 ilm 44 
import org.openconcerto.erp.core.edm.AttachmentSQLElement;
18 ilm 45 
import org.openconcerto.erp.core.finance.accounting.element.AssociationAnalytiqueSQLElement;
46 
import org.openconcerto.erp.core.finance.accounting.element.AssociationCompteAnalytiqueSQLElement;
93 ilm 47 
import org.openconcerto.erp.core.finance.accounting.element.AxeAnalytiqueSQLElement;
156 ilm 48 
import org.openconcerto.erp.core.finance.accounting.element.CategorieComptableSQLElement;
18 ilm 49 
import org.openconcerto.erp.core.finance.accounting.element.ComptePCESQLElement;
50 
import org.openconcerto.erp.core.finance.accounting.element.ComptePCGSQLElement;
93 ilm 51 
import org.openconcerto.erp.core.finance.accounting.element.DeviseHistoriqueSQLElement;
18 ilm 52 
import org.openconcerto.erp.core.finance.accounting.element.EcritureSQLElement;
53 
import org.openconcerto.erp.core.finance.accounting.element.ExerciceCommonSQLElement;
156 ilm 54 
import org.openconcerto.erp.core.finance.accounting.element.FraisDocumentSQLElement;
18 ilm 55 
import org.openconcerto.erp.core.finance.accounting.element.JournalSQLElement;
56 
import org.openconcerto.erp.core.finance.accounting.element.MouvementSQLElement;
57 
import org.openconcerto.erp.core.finance.accounting.element.NatureCompteSQLElement;
58 
import org.openconcerto.erp.core.finance.accounting.element.PieceSQLElement;
59 
import org.openconcerto.erp.core.finance.accounting.element.PosteAnalytiqueSQLElement;
60 
import org.openconcerto.erp.core.finance.accounting.element.RepartitionAnalytiqueSQLElement;
61 
import org.openconcerto.erp.core.finance.accounting.element.SaisieKmItemSQLElement;
62 
import org.openconcerto.erp.core.finance.accounting.element.SaisieKmSQLElement;
63 
import org.openconcerto.erp.core.finance.accounting.element.TypeComptePCGSQLElement;
142 ilm 64 
import org.openconcerto.erp.core.finance.accounting.model.Currency;
18 ilm 65 
import org.openconcerto.erp.core.finance.payment.element.ChequeAEncaisserSQLElement;
66 
import org.openconcerto.erp.core.finance.payment.element.ChequeAvoirClientSQLElement;
67 
import org.openconcerto.erp.core.finance.payment.element.ChequeFournisseurSQLElement;
156 ilm 68 
import org.openconcerto.erp.core.finance.payment.element.DepotChequeElementSQLElement;
69 
import org.openconcerto.erp.core.finance.payment.element.DepotChequeSQLElement;
18 ilm 70 
import org.openconcerto.erp.core.finance.payment.element.EncaisserMontantElementSQLElement;
71 
import org.openconcerto.erp.core.finance.payment.element.EncaisserMontantSQLElement;
72 
import org.openconcerto.erp.core.finance.payment.element.ModeDeReglementSQLElement;
80 ilm 73 
import org.openconcerto.erp.core.finance.payment.element.ReglerMontantElementSQLElement;
18 ilm 74 
import org.openconcerto.erp.core.finance.payment.element.ReglerMontantSQLElement;
151 ilm 75 
import org.openconcerto.erp.core.finance.payment.element.SDDMessageSQLElement;
76 
import org.openconcerto.erp.core.finance.payment.element.SEPAMandateSQLElement;
18 ilm 77 
import org.openconcerto.erp.core.finance.payment.element.TypeReglementSQLElement;
78 
import org.openconcerto.erp.core.finance.tax.element.EcoTaxeSQLElement;
142 ilm 79 
import org.openconcerto.erp.core.finance.tax.element.TaxeComplementaireSQLElement;
18 ilm 80 
import org.openconcerto.erp.core.finance.tax.element.TaxeSQLElement;
81 
import org.openconcerto.erp.core.humanresources.employe.element.CommercialSQLElement;
82 
import org.openconcerto.erp.core.humanresources.employe.element.EtatCivilSQLElement;
61 ilm 83 
import org.openconcerto.erp.core.humanresources.employe.element.ObjectifSQLElement;
156 ilm 84 
import org.openconcerto.erp.core.humanresources.employe.element.SituationFamilialeSQLElement;
18 ilm 85 
import org.openconcerto.erp.core.humanresources.payroll.element.AcompteSQLElement;
142 ilm 86 
import org.openconcerto.erp.core.humanresources.payroll.element.AyantDroitContratPrevSQLElement;
87 
import org.openconcerto.erp.core.humanresources.payroll.element.AyantDroitSQLElement;
88 
import org.openconcerto.erp.core.humanresources.payroll.element.AyantDroitTypeSQLElement;
89 
import org.openconcerto.erp.core.humanresources.payroll.element.CaisseCotisationRenseignentSQLElement;
18 ilm 90 
import org.openconcerto.erp.core.humanresources.payroll.element.CaisseCotisationSQLElement;
142 ilm 91 
import org.openconcerto.erp.core.humanresources.payroll.element.CaisseModePaiementSQLElement;
18 ilm 92 
import org.openconcerto.erp.core.humanresources.payroll.element.ClassementConventionnelSQLElement;
177 ilm 93 
import org.openconcerto.erp.core.humanresources.payroll.element.CodeAmenagementPartielSQLElement;
132 ilm 94 
import org.openconcerto.erp.core.humanresources.payroll.element.CodeBaseAssujettieSQLElement;
95 
import org.openconcerto.erp.core.humanresources.payroll.element.CodeCaisseTypeRubriqueSQLElement;
18 ilm 96 
import org.openconcerto.erp.core.humanresources.payroll.element.CodeCaractActiviteSQLElement;
97 
import org.openconcerto.erp.core.humanresources.payroll.element.CodeContratTravailSQLElement;
142 ilm 98 
import org.openconcerto.erp.core.humanresources.payroll.element.CodeCotisationEtablissementSQLElement;
99 
import org.openconcerto.erp.core.humanresources.payroll.element.CodeCotisationIndividuelleSQLElement;
18 ilm 100 
import org.openconcerto.erp.core.humanresources.payroll.element.CodeDroitContratSQLElement;
101 
import org.openconcerto.erp.core.humanresources.payroll.element.CodeEmploiSQLElement;
102 
import org.openconcerto.erp.core.humanresources.payroll.element.CodeIdccSQLElement;
142 ilm 103 
import org.openconcerto.erp.core.humanresources.payroll.element.CodePenibiliteContratSQLElement;
104 
import org.openconcerto.erp.core.humanresources.payroll.element.CodePenibiliteSQLElement;
18 ilm 105 
import org.openconcerto.erp.core.humanresources.payroll.element.CodeRegimeSQLElement;
41 ilm 106 
import org.openconcerto.erp.core.humanresources.payroll.element.CodeStatutCategorielConventionnelSQLElement;
18 ilm 107 
import org.openconcerto.erp.core.humanresources.payroll.element.CodeStatutCategorielSQLElement;
108 
import org.openconcerto.erp.core.humanresources.payroll.element.CodeStatutProfSQLElement;
177 ilm 109 
import org.openconcerto.erp.core.humanresources.payroll.element.CodeSuspensionSQLElement;
132 ilm 110 
import org.openconcerto.erp.core.humanresources.payroll.element.CodeTypeRubriqueBrutSQLElement;
111 
import org.openconcerto.erp.core.humanresources.payroll.element.CoefficientPrimeSQLElement;
112 
import org.openconcerto.erp.core.humanresources.payroll.element.ContratDetacheExpatrieSQLElement;
113 
import org.openconcerto.erp.core.humanresources.payroll.element.ContratDispositifPolitiqueSQLElement;
114 
import org.openconcerto.erp.core.humanresources.payroll.element.ContratModaliteTempsSQLElement;
115 
import org.openconcerto.erp.core.humanresources.payroll.element.ContratMotifRecoursSQLElement;
142 ilm 116 
import org.openconcerto.erp.core.humanresources.payroll.element.ContratPrevoyanceRubriqueNetSQLElement;
117 
import org.openconcerto.erp.core.humanresources.payroll.element.ContratPrevoyanceRubriqueSQLElement;
118 
import org.openconcerto.erp.core.humanresources.payroll.element.ContratPrevoyanceSQLElement;
119 
import org.openconcerto.erp.core.humanresources.payroll.element.ContratPrevoyanceSalarieSQLElement;
132 ilm 120 
import org.openconcerto.erp.core.humanresources.payroll.element.ContratRegimeMaladieSQLElement;
121 
import org.openconcerto.erp.core.humanresources.payroll.element.ContratRegimeVieillesseSQLElement;
18 ilm 122 
import org.openconcerto.erp.core.humanresources.payroll.element.ContratSalarieSQLElement;
123 
import org.openconcerto.erp.core.humanresources.payroll.element.CumulsCongesSQLElement;
124 
import org.openconcerto.erp.core.humanresources.payroll.element.CumulsPayeSQLElement;
132 ilm 125 
import org.openconcerto.erp.core.humanresources.payroll.element.DSNNatureSQLElement;
180 ilm 126 
import org.openconcerto.erp.core.humanresources.payroll.element.DiplomePrepareSQLElement;
18 ilm 127 
import org.openconcerto.erp.core.humanresources.payroll.element.FichePayeElementSQLElement;
128 
import org.openconcerto.erp.core.humanresources.payroll.element.FichePayeSQLElement;
129 
import org.openconcerto.erp.core.humanresources.payroll.element.ImpressionRubriqueSQLElement;
130 
import org.openconcerto.erp.core.humanresources.payroll.element.InfosSalariePayeSQLElement;
131 
import org.openconcerto.erp.core.humanresources.payroll.element.ModeReglementPayeSQLElement;
132 ilm 132 
import org.openconcerto.erp.core.humanresources.payroll.element.MotifArretTravailSQLElement;
133 
import org.openconcerto.erp.core.humanresources.payroll.element.MotifFinContratSQLElement;
134 
import org.openconcerto.erp.core.humanresources.payroll.element.MotifRepriseArretTravailSQLElement;
156 ilm 135 
import org.openconcerto.erp.core.humanresources.payroll.element.PasSQLElement;
18 ilm 136 
import org.openconcerto.erp.core.humanresources.payroll.element.PeriodeValiditeSQLElement;
137 
import org.openconcerto.erp.core.humanresources.payroll.element.ProfilPayeElementSQLElement;
138 
import org.openconcerto.erp.core.humanresources.payroll.element.ProfilPayeSQLElement;
139 
import org.openconcerto.erp.core.humanresources.payroll.element.RegimeBaseSQLElement;
140 
import org.openconcerto.erp.core.humanresources.payroll.element.ReglementPayeSQLElement;
141 
import org.openconcerto.erp.core.humanresources.payroll.element.RubriqueBrutSQLElement;
142 
import org.openconcerto.erp.core.humanresources.payroll.element.RubriqueCommSQLElement;
143 
import org.openconcerto.erp.core.humanresources.payroll.element.RubriqueCotisationSQLElement;
144 
import org.openconcerto.erp.core.humanresources.payroll.element.RubriqueNetSQLElement;
145 
import org.openconcerto.erp.core.humanresources.payroll.element.SalarieSQLElement;
142 ilm 146 
import org.openconcerto.erp.core.humanresources.payroll.element.TypeComposantBaseAssujettieSQLElement;
147 
import org.openconcerto.erp.core.humanresources.payroll.element.TypePreavisSQLElement;
18 ilm 148 
import org.openconcerto.erp.core.humanresources.payroll.element.TypeRubriqueBrutSQLElement;
149 
import org.openconcerto.erp.core.humanresources.payroll.element.TypeRubriqueNetSQLElement;
156 ilm 150 
import org.openconcerto.erp.core.humanresources.payroll.element.TypeTauxPasSQLElement;
18 ilm 151 
import org.openconcerto.erp.core.humanresources.payroll.element.VariablePayeSQLElement;
152 
import org.openconcerto.erp.core.humanresources.payroll.element.VariableSalarieSQLElement;
153 
import org.openconcerto.erp.core.humanresources.timesheet.element.PointageSQLElement;
90 ilm 154 
import org.openconcerto.erp.core.project.element.CalendarItemGroupSQLElement;
155 
import org.openconcerto.erp.core.project.element.CalendarItemSQLElement;
18 ilm 156 
import org.openconcerto.erp.core.sales.credit.element.AvoirClientElementSQLElement;
157 
import org.openconcerto.erp.core.sales.credit.element.AvoirClientSQLElement;
158 
import org.openconcerto.erp.core.sales.invoice.element.EcheanceClientSQLElement;
159 
import org.openconcerto.erp.core.sales.invoice.element.SaisieVenteFactureItemSQLElement;
160 
import org.openconcerto.erp.core.sales.invoice.element.SaisieVenteFactureSQLElement;
73 ilm 161 
import org.openconcerto.erp.core.sales.invoice.element.TransferInvoiceSQLElement;
144 ilm 162 
import org.openconcerto.erp.core.sales.order.element.ChiffrageCommandeClientSQLElement;
18 ilm 163 
import org.openconcerto.erp.core.sales.order.element.CommandeClientElementSQLElement;
164 
import org.openconcerto.erp.core.sales.order.element.CommandeClientSQLElement;
144 ilm 165 
import org.openconcerto.erp.core.sales.order.element.FacturationCommandeClientSQLElement;
73 ilm 166 
import org.openconcerto.erp.core.sales.order.element.TransferCustomerOrderSQLElement;
144 ilm 167 
import org.openconcerto.erp.core.sales.pos.element.CaisseJournalSQLElement;
18 ilm 168 
import org.openconcerto.erp.core.sales.pos.element.CaisseTicketSQLElement;
144 ilm 169 
import org.openconcerto.erp.core.sales.pos.element.ClôtureCaisseSQLElement;
18 ilm 170 
import org.openconcerto.erp.core.sales.pos.element.SaisieVenteComptoirSQLElement;
171 
import org.openconcerto.erp.core.sales.pos.element.TicketCaisseSQLElement;
142 ilm 172 
import org.openconcerto.erp.core.sales.pos.io.BarcodeReader;
19 ilm 173 
import org.openconcerto.erp.core.sales.price.element.DeviseSQLElement;
18 ilm 174 
import org.openconcerto.erp.core.sales.price.element.TarifSQLElement;
156 ilm 175 
import org.openconcerto.erp.core.sales.product.element.ArticleCatComptableSQLElement;
144 ilm 176 
import org.openconcerto.erp.core.sales.product.element.ArticleCodeClientSQLElement;
19 ilm 177 
import org.openconcerto.erp.core.sales.product.element.ArticleDesignationSQLElement;
156 ilm 178 
import org.openconcerto.erp.core.sales.product.element.ArticleFournisseurSecondaireSQLElement;
19 ilm 179 
import org.openconcerto.erp.core.sales.product.element.ArticleTarifSQLElement;
156 ilm 180 
import org.openconcerto.erp.core.sales.product.element.CoutRevientSQLElement;
180 ilm 181 
import org.openconcerto.erp.core.sales.product.element.CustomerProductFamilyQtyPriceSQLElement;
174 ilm 182 
import org.openconcerto.erp.core.sales.product.element.CustomerProductQtyPriceSQLElement;
142 ilm 183 
import org.openconcerto.erp.core.sales.product.element.EcoContributionSQLElement;
18 ilm 184 
import org.openconcerto.erp.core.sales.product.element.FamilleArticleSQLElement;
142 ilm 185 
import org.openconcerto.erp.core.sales.product.element.FamilleEcoContributionSQLElement;
18 ilm 186 
import org.openconcerto.erp.core.sales.product.element.MetriqueSQLElement;
187 
import org.openconcerto.erp.core.sales.product.element.ModeVenteArticleSQLElement;
94 ilm 188 
import org.openconcerto.erp.core.sales.product.element.ProductItemSQLElement;
189 
import org.openconcerto.erp.core.sales.product.element.ProductQtyPriceSQLElement;
18 ilm 190 
import org.openconcerto.erp.core.sales.product.element.ReferenceArticleSQLElement;
94 ilm 191 
import org.openconcerto.erp.core.sales.product.element.ReliquatSQLElement;
192 
import org.openconcerto.erp.core.sales.product.element.ReliquatSQLElement.ReliquatBRSQLElement;
156 ilm 193 
import org.openconcerto.erp.core.sales.product.element.SupplierPriceListSQLElement;
61 ilm 194 
import org.openconcerto.erp.core.sales.product.element.UniteVenteArticleSQLElement;
18 ilm 195 
import org.openconcerto.erp.core.sales.quote.element.DevisItemSQLElement;
149 ilm 196 
import org.openconcerto.erp.core.sales.quote.element.DevisLogMailSQLElement;
18 ilm 197 
import org.openconcerto.erp.core.sales.quote.element.DevisSQLElement;
198 
import org.openconcerto.erp.core.sales.quote.element.EtatDevisSQLElement;
73 ilm 199 
import org.openconcerto.erp.core.sales.quote.element.TransferQuoteSQLElement;
18 ilm 200 
import org.openconcerto.erp.core.sales.shipment.element.BonDeLivraisonItemSQLElement;
201 
import org.openconcerto.erp.core.sales.shipment.element.BonDeLivraisonSQLElement;
73 ilm 202 
import org.openconcerto.erp.core.sales.shipment.element.TransferShipmentSQLElement;
18 ilm 203 
import org.openconcerto.erp.core.supplychain.credit.element.AvoirFournisseurSQLElement;
204 
import org.openconcerto.erp.core.supplychain.order.element.CommandeElementSQLElement;
205 
import org.openconcerto.erp.core.supplychain.order.element.CommandeSQLElement;
144 ilm 206 
import org.openconcerto.erp.core.supplychain.order.element.DemandeAchatItemSQLElement;
207 
import org.openconcerto.erp.core.supplychain.order.element.DemandePrixItemSQLElement;
208 
import org.openconcerto.erp.core.supplychain.order.element.DemandePrixSQLElement;
209 
import org.openconcerto.erp.core.supplychain.order.element.EtatDemandeAchatItemSQLElement;
210 
import org.openconcerto.erp.core.supplychain.order.element.EtatDemandePrixSQLElement;
211 
import org.openconcerto.erp.core.supplychain.order.element.FabricantSQLElement;
80 ilm 212 
import org.openconcerto.erp.core.supplychain.order.element.FactureFournisseurElementSQLElement;
213 
import org.openconcerto.erp.core.supplychain.order.element.FactureFournisseurSQLElement;
18 ilm 214 
import org.openconcerto.erp.core.supplychain.order.element.SaisieAchatSQLElement;
73 ilm 215 
import org.openconcerto.erp.core.supplychain.order.element.TransferPurchaseSQLElement;
216 
import org.openconcerto.erp.core.supplychain.order.element.TransferSupplierOrderSQLElement;
83 ilm 217 
import org.openconcerto.erp.core.supplychain.product.element.ArticleFournisseurSQLElement;
218 
import org.openconcerto.erp.core.supplychain.product.element.FamilleArticleFounisseurSQLElement;
18 ilm 219 
import org.openconcerto.erp.core.supplychain.receipt.element.BonReceptionElementSQLElement;
220 
import org.openconcerto.erp.core.supplychain.receipt.element.BonReceptionSQLElement;
67 ilm 221 
import org.openconcerto.erp.core.supplychain.receipt.element.CodeFournisseurSQLElement;
73 ilm 222 
import org.openconcerto.erp.core.supplychain.receipt.element.TransferReceiptSQLElement;
156 ilm 223 
import org.openconcerto.erp.core.supplychain.stock.element.DepotStockSQLElement;
224 
import org.openconcerto.erp.core.supplychain.stock.element.EtatStockItemSQLElement;
225 
import org.openconcerto.erp.core.supplychain.stock.element.EtatStockSQLElement;
18 ilm 226 
import org.openconcerto.erp.core.supplychain.stock.element.MouvementStockSQLElement;
227 
import org.openconcerto.erp.core.supplychain.stock.element.StockSQLElement;
228 
import org.openconcerto.erp.core.supplychain.supplier.element.EcheanceFournisseurSQLElement;
229 
import org.openconcerto.erp.core.supplychain.supplier.element.FournisseurSQLElement;
21 ilm 230 
import org.openconcerto.erp.generationDoc.element.ModeleSQLElement;
231 
import org.openconcerto.erp.generationDoc.element.TypeModeleSQLElement;
67 ilm 232 
import org.openconcerto.erp.generationDoc.provider.AdresseFullClientValueProvider;
233 
import org.openconcerto.erp.generationDoc.provider.AdresseRueClientValueProvider;
234 
import org.openconcerto.erp.generationDoc.provider.AdresseVilleCPClientValueProvider;
235 
import org.openconcerto.erp.generationDoc.provider.AdresseVilleClientValueProvider;
236 
import org.openconcerto.erp.generationDoc.provider.AdresseVilleNomClientValueProvider;
144 ilm 237 
import org.openconcerto.erp.generationDoc.provider.ArticleCodeClientProvider;
174 ilm 238 
import org.openconcerto.erp.generationDoc.provider.ArticleCodeFournisseurProvider;
149 ilm 239 
import org.openconcerto.erp.generationDoc.provider.ConditionsReglementDetailsProvider;
93 ilm 240 
import org.openconcerto.erp.generationDoc.provider.DateBLProvider;
142 ilm 241 
import org.openconcerto.erp.generationDoc.provider.DateProvider;
80 ilm 242 
import org.openconcerto.erp.generationDoc.provider.FacturableValueProvider;
177 ilm 243 
import org.openconcerto.erp.generationDoc.provider.FichePayeHeureSupTotalProvider;
244 
import org.openconcerto.erp.generationDoc.provider.FichePayeHeureTotalProvider;
245 
import org.openconcerto.erp.generationDoc.provider.FichePayePlafondAProvider;
246 
import org.openconcerto.erp.generationDoc.provider.FichePayeSmicHProvider;
80 ilm 247 
import org.openconcerto.erp.generationDoc.provider.FormatedGlobalQtyTotalProvider;
177 ilm 248 
import org.openconcerto.erp.generationDoc.provider.IbanProvider;
80 ilm 249 
import org.openconcerto.erp.generationDoc.provider.LabelAccountInvoiceProvider;
250 
import org.openconcerto.erp.generationDoc.provider.MergedGlobalQtyTotalProvider;
73 ilm 251 
import org.openconcerto.erp.generationDoc.provider.ModeDeReglementDetailsProvider;
149 ilm 252 
import org.openconcerto.erp.generationDoc.provider.PaiementRemainedDevisProvider;
83 ilm 253 
import org.openconcerto.erp.generationDoc.provider.PaiementRemainedProvider;
254 
import org.openconcerto.erp.generationDoc.provider.PrixUVProvider;
255 
import org.openconcerto.erp.generationDoc.provider.PrixUnitaireProvider;
63 ilm 256 
import org.openconcerto.erp.generationDoc.provider.PrixUnitaireRemiseProvider;
174 ilm 257 
import org.openconcerto.erp.generationDoc.provider.QteTotalDocProvider;
67 ilm 258 
import org.openconcerto.erp.generationDoc.provider.QteTotalProvider;
132 ilm 259 
import org.openconcerto.erp.generationDoc.provider.RecapFactureProvider;
73 ilm 260 
import org.openconcerto.erp.generationDoc.provider.RefClientValueProvider;
90 ilm 261 
import org.openconcerto.erp.generationDoc.provider.RemiseProvider;
132 ilm 262 
import org.openconcerto.erp.generationDoc.provider.RemiseTotalProvider;
263 
import org.openconcerto.erp.generationDoc.provider.RestantAReglerProvider;
264 
import org.openconcerto.erp.generationDoc.provider.SaledTotalNotDiscountedProvider;
265 
import org.openconcerto.erp.generationDoc.provider.StockLocationProvider;
80 ilm 266 
import org.openconcerto.erp.generationDoc.provider.TotalAcompteProvider;
267 
import org.openconcerto.erp.generationDoc.provider.TotalCommandeClientProvider;
63 ilm 268 
import org.openconcerto.erp.generationDoc.provider.UserCreateInitialsValueProvider;
269 
import org.openconcerto.erp.generationDoc.provider.UserCurrentInitialsValueProvider;
270 
import org.openconcerto.erp.generationDoc.provider.UserModifyInitialsValueProvider;
73 ilm 271 
import org.openconcerto.erp.generationEcritures.provider.SalesCreditAccountingRecordsProvider;
67 ilm 272 
import org.openconcerto.erp.generationEcritures.provider.SalesInvoiceAccountingRecordsProvider;
73 ilm 273 
import org.openconcerto.erp.generationEcritures.provider.SupplyOrderAccountingRecordsProvider;
65 ilm 274 
import org.openconcerto.erp.injector.AchatAvoirSQLInjector;
19 ilm 275 
import org.openconcerto.erp.injector.ArticleCommandeEltSQLInjector;
142 ilm 276 
import org.openconcerto.erp.injector.BonFactureEltSQLInjector;
18 ilm 277 
import org.openconcerto.erp.injector.BonFactureSQLInjector;
94 ilm 278 
import org.openconcerto.erp.injector.BonReceptionFactureFournisseurSQLInjector;
180 ilm 279 
import org.openconcerto.erp.injector.BrEltFactEltSQLInjector;
18 ilm 280 
import org.openconcerto.erp.injector.BrFactureAchatSQLInjector;
180 ilm 281 
import org.openconcerto.erp.injector.CmdEltFactEltSQLInjector;
18 ilm 282 
import org.openconcerto.erp.injector.CommandeBlEltSQLInjector;
283 
import org.openconcerto.erp.injector.CommandeBlSQLInjector;
156 ilm 284 
import org.openconcerto.erp.injector.CommandeBrEltSQLInjector;
18 ilm 285 
import org.openconcerto.erp.injector.CommandeBrSQLInjector;
19 ilm 286 
import org.openconcerto.erp.injector.CommandeCliCommandeSQLInjector;
18 ilm 287 
import org.openconcerto.erp.injector.CommandeFactureAchatSQLInjector;
288 
import org.openconcerto.erp.injector.CommandeFactureClientSQLInjector;
174 ilm 289 
import org.openconcerto.erp.injector.CommandeFactureEltSQLInjector;
290 
import org.openconcerto.erp.injector.CommandeFactureFournisseurSQLInjector;
156 ilm 291 
import org.openconcerto.erp.injector.DevisBlEltSQLInjector;
292 
import org.openconcerto.erp.injector.DevisBlSQLInjector;
19 ilm 293 
import org.openconcerto.erp.injector.DevisCommandeFournisseurSQLInjector;
18 ilm 294 
import org.openconcerto.erp.injector.DevisCommandeSQLInjector;
295 
import org.openconcerto.erp.injector.DevisEltFactureEltSQLInjector;
296 
import org.openconcerto.erp.injector.DevisFactureSQLInjector;
144 ilm 297 
import org.openconcerto.erp.injector.DmdAchatDmdPrixEltSQLInjector;
156 ilm 298 
import org.openconcerto.erp.injector.DmdPrixCmdSQLInjector;
18 ilm 299 
import org.openconcerto.erp.injector.EcheanceEncaisseSQLInjector;
80 ilm 300 
import org.openconcerto.erp.injector.EcheanceRegleSQLInjector;
18 ilm 301 
import org.openconcerto.erp.injector.FactureAvoirSQLInjector;
19 ilm 302 
import org.openconcerto.erp.injector.FactureBonSQLInjector;
303 
import org.openconcerto.erp.injector.FactureCommandeSQLInjector;
156 ilm 304 
import org.openconcerto.erp.modules.ModuleManager;
18 ilm 305 
import org.openconcerto.erp.preferences.DefaultNXProps;
142 ilm 306 
import org.openconcerto.erp.preferences.GestionClientPreferencePanel;
307 
import org.openconcerto.erp.preferences.GestionCommercialeGlobalPreferencePanel;
25 ilm 308 
import org.openconcerto.erp.preferences.TemplateNXProps;
61 ilm 309 
import org.openconcerto.erp.storage.CloudStorageEngine;
310 
import org.openconcerto.erp.storage.StorageEngines;
177 ilm 311 
import org.openconcerto.erp.utils.TM;
18 ilm 312 
import org.jopendocument.link.OOConnexion;
313 
import org.openconcerto.sql.ShowAs;
41 ilm 314 
import org.openconcerto.sql.element.SQLElement;
18 ilm 315 
import org.openconcerto.sql.element.SQLElementDirectory;
316 
import org.openconcerto.sql.element.SharedSQLElement;
317 
import org.openconcerto.sql.model.DBRoot;
94 ilm 318 
import org.openconcerto.sql.model.DBStructureItemNotFound;
18 ilm 319 
import org.openconcerto.sql.model.DBSystemRoot;
73 ilm 320 
import org.openconcerto.sql.model.FieldMapper;
18 ilm 321 
import org.openconcerto.sql.model.SQLDataSource;
322 
import org.openconcerto.sql.model.SQLRow;
323 
import org.openconcerto.sql.model.SQLServer;
80 ilm 324 
import org.openconcerto.sql.model.SQLSystem;
18 ilm 325 
import org.openconcerto.sql.model.SQLTable;
142 ilm 326 
import org.openconcerto.sql.preferences.SQLPreferences;
18 ilm 327 
import org.openconcerto.task.TacheActionManager;
328 
import org.openconcerto.task.config.ComptaBasePropsConfiguration;
94 ilm 329 
import org.openconcerto.task.element.FWKListPrefs;
330 
import org.openconcerto.task.element.FWKSessionState;
142 ilm 331 
import org.openconcerto.utils.BaseDirs;
18 ilm 332 
import org.openconcerto.utils.DesktopEnvironment;
333 
import org.openconcerto.utils.ExceptionHandler;
149 ilm 334 
import org.openconcerto.utils.ExceptionUtils;
41 ilm 335 
import org.openconcerto.utils.NetUtils;
336 
import org.openconcerto.utils.ProductInfo;
337 
import org.openconcerto.utils.StringInputStream;
18 ilm 338 
 
61 ilm 339 
import java.awt.Color;
340 
import java.awt.Font;
341 
import java.awt.Graphics;
342 
import java.awt.Graphics2D;
81 ilm 343 
import java.awt.GraphicsEnvironment;
61 ilm 344 
import java.awt.Image;
345 
import java.awt.RenderingHints;
346 
import java.awt.geom.Rectangle2D;
347 
import java.awt.image.BufferedImage;
18 ilm 348 
import java.io.File;
349 
import java.io.FileInputStream;
350 
import java.io.IOException;
351 
import java.io.InputStream;
352 
import java.sql.SQLException;
28 ilm 353 
import java.text.DateFormat;
354 
import java.text.SimpleDateFormat;
18 ilm 355 
import java.util.ArrayList;
356 
import java.util.Arrays;
41 ilm 357 
import java.util.Collection;
18 ilm 358 
import java.util.List;
359 
import java.util.Properties;
360 
 
61 ilm 361 
import javax.imageio.ImageIO;
41 ilm 362 
import javax.swing.JFrame;
18 ilm 363 
import javax.swing.JOptionPane;
364 
import javax.swing.SwingUtilities;
365 
 
366 
/***************************************************************************************************
367 
 * Configuration de la gestion: Une base commune "Common" --> société, user, tasks. Une base
368 
 * par défaut pour créer une société "Default". Un fichier mapping.xml pour la base commune.
369 
 * Un fichier mappingCompta.xml pour les bases sociétés.
370 
 **************************************************************************************************/
371 
// final so we can use setupLogging(), see the constructor comment
144 ilm 372 
public class ComptaPropsConfiguration extends ComptaBasePropsConfiguration {
18 ilm 373 
 
41 ilm 374 
    public static final ProductInfo productInfo = ProductInfo.getInstance();
375 
    public static final String APP_NAME = productInfo.getName();
18 ilm 376 
    private static final String DEFAULT_ROOT = "Common";
80 ilm 377 
 
378 
    static final Properties createDefaults() {
379 
        final Properties defaults = new Properties();
380 
        defaults.setProperty("base.root", DEFAULT_ROOT);
381 
        return defaults;
382 
    }
383 
 
18 ilm 384 
    // the properties path from this class
385 
    private static final String PROPERTIES = "main.properties";
386 
 
387 
    public static final String DATA_DIR_VAR = "${data.dir}";
388 
 
144 ilm 389 
    protected String version = "";
18 ilm 390 
    private static OOConnexion conn;
391 
 
392 
    public static OOConnexion getOOConnexion() {
393 
        if (conn == null || conn.isClosed()) {
394 
            try {
395 
                conn = OOConnexion.create();
396 
 
397 
                if (conn == null) {
398 
                    SwingUtilities.invokeLater(new Runnable() {
399 
 
400 
                        @Override
401 
                        public void run() {
402 
                            JOptionPane.showMessageDialog(null, "Impossible de trouver une installation d'OpenOffice sur votre ordinateur.\nMerci d'installer OpenOffice (http://fr.openoffice.org).");
403 
                        }
404 
                    });
405 
                }
406 
 
407 
            } catch (IllegalStateException e) {
408 
                JOptionPane.showMessageDialog(null, "Impossible d'obtenir une connexion avec openoffice. Contactez votre revendeur.");
409 
                e.printStackTrace();
410 
                conn = null;
411 
            }
412 
        }
413 
 
414 
        return conn;
415 
    }
416 
 
417 
    public static void closeOOConnexion() {
418 
        if (conn != null) {
419 
            conn.closeConnexion();
420 
        }
421 
    }
422 
 
423 
    public static ComptaPropsConfiguration create() {
424 
        return create(false);
425 
    }
426 
 
427 
    public static ComptaPropsConfiguration create(final boolean nullAllowed) {
142 ilm 428 
        return create(nullAllowed, getConfFile(productInfo));
18 ilm 429 
    }
430 
 
431 
    public static ComptaPropsConfiguration create(final boolean nullAllowed, final File confFile) {
432 
        // Log pour debug demarrage
94 ilm 433 
        System.out.println("Loading configuration from: " + (confFile == null ? "null" : confFile.getAbsolutePath()));
18 ilm 434 
        final boolean inWebStart = Gestion.inWebStart();
80 ilm 435 
        final Properties defaults = createDefaults();
18 ilm 436 
        // Ordre de recherche:
437 
        // a/ fichier de configuration
438 
        // b/ dans le jar
439 
        try {
440 
            final Properties props;
441 
            // webstart should be self-contained, e.g. if a user launches from the web it shoudln't
442 
            // read an old preference file but should always read its own configuration.
61 ilm 443 
            if (confFile != null && confFile.exists() && !inWebStart) {
18 ilm 444 
                props = create(new FileInputStream(confFile), defaults);
445 
            } else {
446 
                final InputStream stream = ComptaPropsConfiguration.class.getResourceAsStream(PROPERTIES);
447 
                if (stream != null)
448 
                    props = create(stream, defaults);
449 
                else if (nullAllowed)
450 
                    return null;
451 
                else
452 
                    throw new IOException("found neither " + confFile + " nor embedded " + PROPERTIES);
453 
            }
80 ilm 454 
            return new ComptaPropsConfiguration(props, inWebStart, true);
18 ilm 455 
        } catch (final IOException e) {
456 
            e.printStackTrace();
83 ilm 457 
            String title = "Logiciel non configuré";
458 
            String message = "Impossible de lire le fichier de configuration.\nIl est nécessaire d'utiliser le logiciel de Configuration pour paramétrer le logiciel.";
459 
            JOptionPane.showMessageDialog(new JFrame(), message, title, JOptionPane.ERROR_MESSAGE);
460 
            System.exit(2);
18 ilm 461 
            // never reached since we're already dead
462 
            return null;
463 
        }
464 
 
465 
    }
466 
 
467 
    // *** instance
468 
 
80 ilm 469 
    private final boolean isMain;
18 ilm 470 
    private final boolean inWebstart;
471 
    private final boolean isServerless;
41 ilm 472 
    private boolean isOnCloud;
94 ilm 473 
    private boolean isPortable;
474 
    private File portableDir = null;
142 ilm 475 
    private Currency currency = null;
156 ilm 476 
    private final ModuleManager moduleMngr = new ModuleManager();
18 ilm 477 
 
144 ilm 478 
    public ComptaPropsConfiguration(Properties props, final ProductInfo productInfo) {
479 
        super(props, productInfo);
480 
        this.isServerless = false;
481 
        this.isMain = true;
482 
        this.inWebstart = false;
483 
    }
484 
 
80 ilm 485 
    // isMain=true also set up some VM wide settings
142 ilm 486 
    public ComptaPropsConfiguration(Properties props, final boolean inWebstart, final boolean main) {
41 ilm 487 
        super(props, productInfo);
80 ilm 488 
        this.isMain = main;
18 ilm 489 
        this.inWebstart = inWebstart;
94 ilm 490 
        this.isPortable = Boolean.parseBoolean(this.getProperty("portable", "false"));
491 
        String pDir = this.getProperty("portableDir", null);
492 
        if (isPortable) {
493 
            if (pDir == null) {
494 
                System.out.println("Portable mode, using current directory");
495 
                portableDir = new File(".");
496 
            } else {
497 
                System.out.println("Portable mode, using provided directory : " + pDir);
498 
                portableDir = new File(pDir);
499 
            }
500 
            if (!portableDir.exists()) {
501 
                System.out.println("Error: portable dir missing : " + portableDir);
502 
                portableDir = new File(".");
503 
            }
504 
            System.out.println("Portable mode in : " + portableDir.getAbsolutePath());
505 
            if (this.getProperty("portableDirMessage", "true").equalsIgnoreCase("true")) {
506 
                if (!GraphicsEnvironment.isHeadless()) {
507 
                    System.out.println("Add portableDirMessage=false in your " + PROPERTIES + " to prevent the popup message.");
508 
                    JOptionPane.showMessageDialog(null, "Portable version :\n" + portableDir.getAbsolutePath());
509 
                }
510 
            }
511 
        }
512 
        if (isPortable) {
513 
            this.setProperty("wd", new File(portableDir, "UserData").getAbsolutePath());
514 
        } else {
515 
            this.setProperty("wd", DesktopEnvironment.getDE().getDocumentsFolder().getAbsolutePath() + File.separator + this.getAppName());
516 
        }
18 ilm 517 
        if (this.getProperty("version.date") != null) {
518 
            this.version = this.getProperty("version.date");
519 
        }
41 ilm 520 
 
521 
        //
61 ilm 522 
        String token = getToken();
41 ilm 523 
        if (token != null) {
524 
            this.isServerless = false;
525 
            this.isOnCloud = true;
61 ilm 526 
            if (this.getProperty("storage.server") == null) {
527 
                InProgressFrame progress = new InProgressFrame();
528 
                progress.show("Connexion sécurisée au cloud en cours");
529 
                String result = NetUtils.getHTTPContent("https://cloud.openconcerto.org/getAuthInfo?token=" + token, false);
530 
                if (result != null && !result.contains("ERROR")) {
531 
                    Properties cProperty = new Properties();
532 
                    try {
533 
                        cProperty.loadFromXML(new StringInputStream(result));
534 
                        setProperty("server.wan.only", "true");
535 
                        setProperty("server.wan.port", "22");
536 
                        // SSH
537 
                        setProperty("server.wan.addr", cProperty.getProperty("ssh.server"));
538 
                        setProperty("server.wan.user", cProperty.getProperty("ssh.login"));
539 
                        setProperty("server.wan.password", cProperty.getProperty("ssh.pass"));
540 
                        // DB
541 
                        setProperty("server.ip", "127.0.0.1:5432");
542 
                        setProperty("server.driver", "postgresql");
543 
                        setProperty("server.login", cProperty.getProperty("db.login"));
544 
                        setProperty("server.password", cProperty.getProperty("db.pass"));
545 
                        setProperty("systemRoot", cProperty.getProperty("db.name"));
546 
                        // Storage
547 
                        props.put("storage.server", cProperty.getProperty("storage.server"));
65 ilm 548 
 
61 ilm 549 
                    } catch (Exception e) {
550 
                        e.printStackTrace();
149 ilm 551 
                        String s = ExceptionUtils.getStackTrace(e);
156 ilm 552 
                        JOptionPane.showMessageDialog(new JFrame(),
553 
                                "Impossible récupérer les informations de connexion\n" + s + "\ntoken: " + token + "\nr: " + result + "\nMerci de vérifier votre connexion internet.");
61 ilm 554 
                        System.exit(1);
555 
                    }
556 
 
557 
                } else if (result != null && result.contains("not paid")) {
558 
                    JOptionPane.showMessageDialog(new JFrame(), "Compte Cloud non crédité");
41 ilm 559 
                    System.exit(1);
61 ilm 560 
                } else {
561 
                    JOptionPane.showMessageDialog(new JFrame(), "Connexion impossible au Cloud");
562 
                    System.exit(1);
41 ilm 563 
                }
65 ilm 564 
                progress.dispose();
41 ilm 565 
            }
61 ilm 566 
            StorageEngines.getInstance().addEngine(new CloudStorageEngine());
41 ilm 567 
        } else {
132 ilm 568 
            // FIXME
41 ilm 569 
            // Local database
132 ilm 570 
            {
142 ilm 571 
                if (getProperty("server.login") == null) {
572 
                    setProperty("server.login", "openconcerto");
573 
                }
574 
                if (getProperty("server.password") == null) {
575 
                    setProperty("server.password", "openconcerto");
576 
                }
132 ilm 577 
            }
80 ilm 578 
            this.setProperty("server.ip", getProperty("server.ip").replace(DATA_DIR_VAR, getDataDir().getPath()));
579 
            final SQLSystem system = getSystem();
580 
            this.isServerless = system == SQLSystem.H2 && system.getHostname(getServerIp()) == null;
18 ilm 581 
        }
80 ilm 582 
        if (this.isMain) {
583 
            // ATTN this works because this is executed last (i.e. if you put this in a superclass
584 
            // this won't work since e.g. app.name won't have its correct value)
93 ilm 585 
            try {
586 
                this.setupLogging("logs");
587 
            } catch (Exception e) {
588 
                System.err.println("ComptaPropsConfiguration() error in log setup : " + e.getMessage());
589 
            }
80 ilm 590 
            registerAccountingProvider();
591 
            registerCellValueProvider();
592 
        }
18 ilm 593 
    }
594 
 
177 ilm 595 
    public final TM getERP_TM() {
596 
        return TM.getERP_TM(this.getLocale());
597 
    }
598 
 
67 ilm 599 
    private void registerAccountingProvider() {
600 
        SalesInvoiceAccountingRecordsProvider.register();
73 ilm 601 
        SalesCreditAccountingRecordsProvider.register();
602 
        SupplyOrderAccountingRecordsProvider.register();
67 ilm 603 
    }
604 
 
63 ilm 605 
    private void registerCellValueProvider() {
606 
        UserCreateInitialsValueProvider.register();
607 
        UserModifyInitialsValueProvider.register();
608 
        UserCurrentInitialsValueProvider.register();
609 
        PrixUnitaireRemiseProvider.register();
83 ilm 610 
        PrixUnitaireProvider.register();
611 
        PrixUVProvider.register();
80 ilm 612 
        TotalAcompteProvider.register();
144 ilm 613 
        ArticleCodeClientProvider.register();
149 ilm 614 
        ConditionsReglementDetailsProvider.register();
80 ilm 615 
        FacturableValueProvider.register();
616 
        TotalCommandeClientProvider.register();
617 
        LabelAccountInvoiceProvider.register();
93 ilm 618 
        DateBLProvider.register();
67 ilm 619 
        AdresseRueClientValueProvider.register();
620 
        AdresseVilleClientValueProvider.register();
621 
        AdresseVilleCPClientValueProvider.register();
622 
        AdresseVilleNomClientValueProvider.register();
623 
        AdresseFullClientValueProvider.register();
624 
        QteTotalProvider.register();
174 ilm 625 
        QteTotalDocProvider.register();
132 ilm 626 
        StockLocationProvider.register();
73 ilm 627 
        RefClientValueProvider.register();
628 
        ModeDeReglementDetailsProvider.register();
80 ilm 629 
        FormatedGlobalQtyTotalProvider.register();
177 ilm 630 
        FichePayeHeureSupTotalProvider.register();
631 
        FichePayeHeureTotalProvider.register();
632 
        FichePayePlafondAProvider.register();
633 
        FichePayeSmicHProvider.register();
80 ilm 634 
        MergedGlobalQtyTotalProvider.register();
83 ilm 635 
        PaiementRemainedProvider.register();
149 ilm 636 
        PaiementRemainedDevisProvider.register();
90 ilm 637 
        RemiseProvider.register();
142 ilm 638 
        DateProvider.register();
132 ilm 639 
        RemiseTotalProvider.register();
640 
        RecapFactureProvider.register();
641 
        RestantAReglerProvider.register();
642 
        SaledTotalNotDiscountedProvider.register();
174 ilm 643 
        ArticleCodeFournisseurProvider.register();
177 ilm 644 
        IbanProvider.register();
63 ilm 645 
    }
646 
 
647 
    @Override
648 
    protected void initDS(SQLDataSource ds) {
649 
        super.initDS(ds);
650 
        ds.setInitialSize(3);
651 
        ds.setMinIdle(2);
652 
        ds.setMaxActive(4);
177 ilm 653 
        ds.setMaxWait(30000);
63 ilm 654 
    }
655 
 
61 ilm 656 
    public String getToken() {
657 
        return getProperty("token");
658 
    }
659 
 
18 ilm 660 
    public final boolean isServerless() {
661 
        return this.isServerless;
662 
    }
663 
 
41 ilm 664 
    public final boolean isOnCloud() {
665 
        return this.isOnCloud;
666 
    }
667 
 
18 ilm 668 
    public final String getVersion() {
669 
        return this.version;
670 
    }
671 
 
672 
    @Override
142 ilm 673 
    public String getAppVariant() {
18 ilm 674 
        if (inWebstart())
25 ilm 675 
            // so we don't remove files of a normal GestionNX
142 ilm 676 
            return super.getAppVariant() + "-webstart";
18 ilm 677 
        else
142 ilm 678 
            return super.getAppVariant();
18 ilm 679 
    }
680 
 
681 
    @Override
142 ilm 682 
    protected BaseDirs createBaseDirs() {
683 
        if (isPortable()) {
684 
            return BaseDirs.createPortable(getPortableDir(), this.getProductInfo(), this.getAppVariant());
685 
        } else {
686 
            return super.createBaseDirs();
687 
        }
688 
    }
689 
 
690 
    @Override
691 
    protected final File getOldConfDir() {
94 ilm 692 
        if (isPortable) {
693 
            return getWD();
694 
        } else {
142 ilm 695 
            return Gestion.MAC_OS_X ? new File(System.getProperty("user.home") + "/Library/Application Support/" + getAppID()) : super.getOldConfDir();
94 ilm 696 
        }
18 ilm 697 
    }
698 
 
94 ilm 699 
    public boolean isPortable() {
700 
        return isPortable;
701 
    }
702 
 
703 
    public File getPortableDir() {
704 
        return portableDir;
705 
    }
706 
 
18 ilm 707 
    private boolean inWebstart() {
708 
        return this.inWebstart;
709 
    }
710 
 
142 ilm 711 
    @Deprecated
712 
    public File getOldDataDir() {
713 
        return new File(this.getOldConfDir(), "DBData");
714 
    }
715 
 
18 ilm 716 
    public File getDataDir() {
142 ilm 717 
        return new File(this.getBaseDirs().getAppDataFolder(), "DBData");
18 ilm 718 
    }
719 
 
83 ilm 720 
    private final void createDB(final DBSystemRoot sysRoot) {
18 ilm 721 
        if (!this.isServerless())
722 
            return;
723 
        try {
724 
            // H2 create the database on connection
83 ilm 725 
            // don't create if root explicitly excluded (e.g. map no roots just to quickly test
726 
            // connection)
727 
            if (sysRoot.shouldMap(getRootName()) && !sysRoot.contains(getRootName())) {
728 
                Log.get().warning("Creating DB");
19 ilm 729 
                String createScript = null;
730 
                try {
731 
                    createScript = this.getResource("/webstart/create.sql");
732 
                } catch (Exception e) {
733 
                    e.printStackTrace();
734 
                }
18 ilm 735 
                if (createScript == null)
736 
                    throw new IllegalStateException("Couldn't find database creation script");
737 
                final SQLDataSource ds = sysRoot.getDataSource();
83 ilm 738 
                ds.execute("RUNSCRIPT from '" + createScript + "' CHARSET 'UTF-8' ;");
739 
                sysRoot.refetch();
740 
                this.setupSystemRoot(sysRoot);
18 ilm 741 
            }
83 ilm 742 
        } catch (RuntimeException e) {
743 
            throw e;
744 
        } catch (Exception e) {
745 
            throw new IllegalStateException("Couldn't create database", e);
18 ilm 746 
        }
747 
    }
748 
 
749 
    @Override
750 
    protected DBSystemRoot createSystemRoot() {
83 ilm 751 
        final DBSystemRoot res = super.createSystemRoot();
752 
        // Don't create a separate server for createDB() as on normal databases just setting up a
753 
        // data source can take 2 seconds (e.g. validateConnectionFactory()). And this is for every
754 
        // boot.
755 
        this.createDB(res);
756 
        return res;
18 ilm 757 
    }
758 
 
759 
    @Override
760 
    public String getDefaultBase() {
761 
        return super.getDefaultBase();
762 
 
763 
    }
764 
 
765 
    @Override
766 
    protected SQLElementDirectory createDirectory() {
767 
        final SQLElementDirectory dir = super.createDirectory();
156 ilm 768 
        final DBRoot root = getRoot();
769 
        dir.addSQLElement(new AdresseCommonSQLElement(root));
770 
        dir.addSQLElement(new ExerciceCommonSQLElement(root));
771 
        dir.addSQLElement(DeviseSQLElement.class, root);
772 
        dir.addSQLElement(TypeModeleSQLElement.class, root);
773 
        dir.addSQLElement(new SocieteCommonSQLElement(root));
132 ilm 774 
 
775 
        // DSN
156 ilm 776 
        dir.addSQLElement(CaisseCotisationRenseignentSQLElement.class, root);
777 
        dir.addSQLElement(CodeBaseAssujettieSQLElement.class, root);
778 
        dir.addSQLElement(ContratModaliteTempsSQLElement.class, root);
779 
        dir.addSQLElement(CodeCaisseTypeRubriqueSQLElement.class, root);
780 
        dir.addSQLElement(CodeTypeRubriqueBrutSQLElement.class, root);
781 
        dir.addSQLElement(MotifArretTravailSQLElement.class, root);
782 
        dir.addSQLElement(ContratDispositifPolitiqueSQLElement.class, root);
783 
        dir.addSQLElement(ContratDetacheExpatrieSQLElement.class, root);
784 
        dir.addSQLElement(ContratRegimeMaladieSQLElement.class, root);
785 
        dir.addSQLElement(ContratMotifRecoursSQLElement.class, root);
786 
        dir.addSQLElement(ContratRegimeVieillesseSQLElement.class, root);
787 
        dir.addSQLElement(MotifFinContratSQLElement.class, root);
788 
        dir.addSQLElement(MotifRepriseArretTravailSQLElement.class, root);
789 
        dir.addSQLElement(TypePreavisSQLElement.class, root);
790 
        dir.addSQLElement(DSNNatureSQLElement.class, root);
791 
        dir.addSQLElement(TypeTauxPasSQLElement.class, root);
177 ilm 792 
        dir.addSQLElement(CodeAmenagementPartielSQLElement.class, root);
793 
        dir.addSQLElement(CodeSuspensionSQLElement.class, root);
180 ilm 794 
        dir.addSQLElement(DiplomePrepareSQLElement.class, root);
132 ilm 795 
 
142 ilm 796 
        // ECO
156 ilm 797 
        dir.addSQLElement(FamilleEcoContributionSQLElement.class, root);
798 
        dir.addSQLElement(EcoContributionSQLElement.class, root);
142 ilm 799 
 
156 ilm 800 
        dir.addSQLElement(new RubriqueCotisationSQLElement(root));
801 
        dir.addSQLElement(new RubriqueCommSQLElement(root));
802 
        dir.addSQLElement(new RubriqueNetSQLElement(root));
803 
        dir.addSQLElement(new RubriqueBrutSQLElement(root));
804 
 
805 
        dir.addSQLElement(new CaisseCotisationSQLElement(root));
806 
        dir.addSQLElement(new ProfilPayeSQLElement(root));
807 
        dir.addSQLElement(new ProfilPayeElementSQLElement(root));
808 
        dir.addSQLElement(new PeriodeValiditeSQLElement(root));
809 
 
810 
        dir.addSQLElement(new TypeRubriqueBrutSQLElement(root));
811 
        dir.addSQLElement(new TypeRubriqueNetSQLElement(root));
812 
 
813 
        dir.addSQLElement(AyantDroitTypeSQLElement.class, root);
814 
        dir.addSQLElement(TypeComposantBaseAssujettieSQLElement.class, root);
815 
        dir.addSQLElement(CaisseModePaiementSQLElement.class, root);
816 
        dir.addSQLElement(CodeCotisationIndividuelleSQLElement.class, root);
817 
        dir.addSQLElement(CodeCotisationEtablissementSQLElement.class, root);
818 
        dir.addSQLElement(CodePenibiliteSQLElement.class, root);
819 
        dir.addSQLElement(new ImpressionRubriqueSQLElement(root));
820 
 
821 
        dir.addSQLElement(new VariablePayeSQLElement(root));
822 
 
18 ilm 823 
        return dir;
824 
    }
825 
 
826 
    private void setSocieteDirectory() {
94 ilm 827 
        try {
149 ilm 828 
            // Check 1.5.3 updated
829 
            if (!this.getRootSociete().getTable("SAISIE_VENTE_FACTURE").contains("T_ACOMPTE")) {
830 
                throw new DBStructureItemNotFound("Base de données non à jour");
831 
            }
156 ilm 832 
            // Check 1.6 updated
833 
            if (!this.getRootSociete().contains("ETAT_STOCK")) {
834 
                throw new DBStructureItemNotFound("Base de données non à jour");
835 
            }
94 ilm 836 
            SQLElementDirectory dir = this.getDirectory();
93 ilm 837 
 
142 ilm 838 
            dir.addSQLElement(AttachmentSQLElement.class);
839 
 
174 ilm 840 
            dir.addSQLElement(CustomerProductQtyPriceSQLElement.class);
180 ilm 841 
            dir.addSQLElement(CustomerProductFamilyQtyPriceSQLElement.class);
156 ilm 842 
            dir.addSQLElement(EtatStockSQLElement.class);
843 
            dir.addSQLElement(EtatStockItemSQLElement.class);
94 ilm 844 
            dir.addSQLElement(ArticleTarifSQLElement.class);
156 ilm 845 
            dir.addSQLElement(CoutRevientSQLElement.class);
94 ilm 846 
            dir.addSQLElement(ReliquatBRSQLElement.class);
847 
            dir.addSQLElement(ReliquatSQLElement.class);
848 
            dir.addSQLElement(ProductQtyPriceSQLElement.class);
849 
            dir.addSQLElement(ProductItemSQLElement.class);
156 ilm 850 
            dir.addSQLElement(CategorieComptableSQLElement.class);
851 
            dir.addSQLElement(ArticleCatComptableSQLElement.class);
852 
            dir.addSQLElement(ArticleFournisseurSecondaireSQLElement.class);
853 
            dir.addSQLElement(SupplierPriceListSQLElement.class);
854 
            dir.addSQLElement(FraisDocumentSQLElement.class);
94 ilm 855 
            dir.addSQLElement(ArticleDesignationSQLElement.class);
856 
            dir.addSQLElement(BanqueSQLElement.class);
857 
            dir.addSQLElement(ClientDepartementSQLElement.class);
132 ilm 858 
            dir.addSQLElement(CoefficientPrimeSQLElement.class);
94 ilm 859 
            dir.addSQLElement(ContactFournisseurSQLElement.class);
860 
            dir.addSQLElement(ContactAdministratifSQLElement.class);
174 ilm 861 
            dir.addSQLElement(ContactSalarieSQLElement.class);
94 ilm 862 
            dir.addSQLElement(new TitrePersonnelSQLElement());
863 
            dir.addSQLElement(new ContactSQLElement());
180 ilm 864 
            dir.addSQLElement(new AgenceSQLElement(this.getRootSociete()));
94 ilm 865 
            dir.addSQLElement(new SaisieKmItemSQLElement());
866 
            dir.addSQLElement(new EcritureSQLElement());
18 ilm 867 
 
156 ilm 868 
            dir.addSQLElement(new SharedSQLElement(this, "EMPLOYEUR_MULTIPLE", "humanresources.multipleEmployer"));
94 ilm 869 
            dir.addSQLElement(PosteAnalytiqueSQLElement.class);
156 ilm 870 
            dir.addSQLElement(new SharedSQLElement(this, "CLASSE_COMPTE", "finance.accounting.accountClass"));
18 ilm 871 
 
94 ilm 872 
            dir.addSQLElement(CaisseTicketSQLElement.class);
18 ilm 873 
 
94 ilm 874 
            dir.addSQLElement(ModeleSQLElement.class);
21 ilm 875 
 
94 ilm 876 
            dir.addSQLElement(new AdresseSQLElement());
144 ilm 877 
            dir.addSQLElement(ArticleCodeClientSQLElement.class);
94 ilm 878 
            dir.addSQLElement(ReferenceArticleSQLElement.class);
879 
            dir.addSQLElement(ArticleFournisseurSQLElement.class);
880 
            dir.addSQLElement(FamilleArticleFounisseurSQLElement.class);
18 ilm 881 
 
94 ilm 882 
            dir.addSQLElement(new AssociationCompteAnalytiqueSQLElement());
883 
            dir.addSQLElement(new AvoirClientSQLElement());
884 
            dir.addSQLElement(new AvoirClientElementSQLElement());
885 
            dir.addSQLElement(AvoirFournisseurSQLElement.class);
886 
            dir.addSQLElement(new AcompteSQLElement());
18 ilm 887 
 
94 ilm 888 
            dir.addSQLElement(new AxeAnalytiqueSQLElement());
18 ilm 889 
 
94 ilm 890 
            dir.addSQLElement(new BonDeLivraisonItemSQLElement());
891 
            dir.addSQLElement(new BonDeLivraisonSQLElement());
892 
            dir.addSQLElement(new TransferShipmentSQLElement());
73 ilm 893 
 
94 ilm 894 
            dir.addSQLElement(new BonReceptionElementSQLElement());
895 
            dir.addSQLElement(new BonReceptionSQLElement());
896 
            dir.addSQLElement(new TransferReceiptSQLElement());
897 
            dir.addSQLElement(new ChequeAEncaisserSQLElement());
156 ilm 898 
            dir.addSQLElement(DepotChequeSQLElement.class);
899 
            dir.addSQLElement(DepotChequeElementSQLElement.class);
94 ilm 900 
            dir.addSQLElement(new ChequeAvoirClientSQLElement());
901 
            dir.addSQLElement(new ChequeFournisseurSQLElement());
902 
                dir.addSQLElement(new CustomerCategorySQLElement());
903 
                dir.addSQLElement(new CustomerSQLElement());
142 ilm 904 
                dir.addSQLElement(new CompteClientTransactionSQLELement());
94 ilm 905 
            dir.addSQLElement(new CourrierClientSQLElement());
18 ilm 906 
 
94 ilm 907 
            dir.addSQLElement(new ClassementConventionnelSQLElement());
908 
            dir.addSQLElement(CodeFournisseurSQLElement.class);
909 
            dir.addSQLElement(new CommandeSQLElement());
910 
            dir.addSQLElement(new TransferSupplierOrderSQLElement());
911 
            dir.addSQLElement(new CommandeElementSQLElement());
912 
            dir.addSQLElement(new TransferCustomerOrderSQLElement());
913 
            dir.addSQLElement(new CommandeClientSQLElement());
144 ilm 914 
            dir.addSQLElement(FacturationCommandeClientSQLElement.class);
94 ilm 915 
            dir.addSQLElement(new CommandeClientElementSQLElement());
18 ilm 916 
 
144 ilm 917 
            dir.addSQLElement(DemandeAchatItemSQLElement.class);
918 
            dir.addSQLElement(EtatDemandeAchatItemSQLElement.class);
919 
            dir.addSQLElement(EtatDemandePrixSQLElement.class);
920 
            dir.addSQLElement(DemandePrixSQLElement.class);
921 
            dir.addSQLElement(DemandePrixItemSQLElement.class);
922 
            dir.addSQLElement(FabricantSQLElement.class);
923 
            dir.addSQLElement(ChiffrageCommandeClientSQLElement.class);
924 
 
156 ilm 925 
            dir.addSQLElement(new CommercialSQLElement());
926 
 
94 ilm 927 
            dir.addSQLElement(ObjectifSQLElement.class);
928 
            dir.addSQLElement(new ComptePCESQLElement());
929 
            dir.addSQLElement(new ComptePCGSQLElement());
18 ilm 930 
 
94 ilm 931 
            dir.addSQLElement(new ContratSalarieSQLElement());
142 ilm 932 
            dir.addSQLElement(ContratPrevoyanceSQLElement.class);
933 
            dir.addSQLElement(ContratPrevoyanceRubriqueSQLElement.class);
934 
            dir.addSQLElement(ContratPrevoyanceRubriqueNetSQLElement.class);
935 
            dir.addSQLElement(ContratPrevoyanceSalarieSQLElement.class);
936 
            dir.addSQLElement(AyantDroitSQLElement.class);
937 
            dir.addSQLElement(AyantDroitContratPrevSQLElement.class);
18 ilm 938 
 
94 ilm 939 
            dir.addSQLElement(new CodeRegimeSQLElement());
940 
            dir.addSQLElement(new CodeEmploiSQLElement());
941 
            dir.addSQLElement(new CodeContratTravailSQLElement());
942 
            dir.addSQLElement(new CodeDroitContratSQLElement());
943 
            dir.addSQLElement(new CodeCaractActiviteSQLElement());
18 ilm 944 
 
94 ilm 945 
            dir.addSQLElement(new CodeStatutCategorielSQLElement());
946 
            dir.addSQLElement(CodeStatutCategorielConventionnelSQLElement.class);
947 
            dir.addSQLElement(new CodeStatutProfSQLElement());
142 ilm 948 
            dir.addSQLElement(CodePenibiliteContratSQLElement.class);
949 
 
156 ilm 950 
            dir.addSQLElement(PasSQLElement.class);
951 
 
94 ilm 952 
            dir.addSQLElement(new CumulsCongesSQLElement());
953 
            dir.addSQLElement(new CumulsPayeSQLElement());
18 ilm 954 
 
94 ilm 955 
            dir.addSQLElement(new DepartementSQLElement());
156 ilm 956 
            dir.addSQLElement(new DevisSQLElement());
94 ilm 957 
            dir.addSQLElement(new TransferQuoteSQLElement());
958 
            dir.addSQLElement(new DevisItemSQLElement());
18 ilm 959 
 
94 ilm 960 
            dir.addSQLElement(new EcheanceClientSQLElement());
961 
            dir.addSQLElement(new EcheanceFournisseurSQLElement());
962 
            dir.addSQLElement(EncaisserMontantSQLElement.class);
963 
            dir.addSQLElement(EncaisserMontantElementSQLElement.class);
964 
            dir.addSQLElement(EcoTaxeSQLElement.class);
18 ilm 965 
 
94 ilm 966 
            dir.addSQLElement(new EtatCivilSQLElement());
967 
            dir.addSQLElement(new EtatDevisSQLElement());
18 ilm 968 
 
94 ilm 969 
            dir.addSQLElement(new FamilleArticleSQLElement());
970 
            dir.addSQLElement(new FichePayeSQLElement());
971 
            dir.addSQLElement(new FichePayeElementSQLElement());
18 ilm 972 
 
94 ilm 973 
            dir.addSQLElement(new FournisseurSQLElement());
18 ilm 974 
 
94 ilm 975 
            dir.addSQLElement(new CodeIdccSQLElement());
18 ilm 976 
 
94 ilm 977 
            dir.addSQLElement(new InfosSalariePayeSQLElement());
18 ilm 978 
 
94 ilm 979 
            dir.addSQLElement(new JournalSQLElement());
18 ilm 980 
 
94 ilm 981 
            dir.addSQLElement(LangueSQLElement.class);
19 ilm 982 
 
94 ilm 983 
            dir.addSQLElement(new MetriqueSQLElement());
984 
            dir.addSQLElement(new ModeleCourrierClientSQLElement());
985 
            dir.addSQLElement(new ModeVenteArticleSQLElement());
986 
            dir.addSQLElement(new ModeDeReglementSQLElement());
987 
            dir.addSQLElement(new ModeReglementPayeSQLElement());
988 
            dir.addSQLElement(new MoisSQLElement());
989 
            dir.addSQLElement(new MouvementSQLElement());
990 
            dir.addSQLElement(new MouvementStockSQLElement());
156 ilm 991 
            dir.addSQLElement(DepotStockSQLElement.class);
18 ilm 992 
 
94 ilm 993 
            dir.addSQLElement(new NatureCompteSQLElement());
18 ilm 994 
 
94 ilm 995 
            dir.addSQLElement(new NumerotationAutoSQLElement());
18 ilm 996 
 
94 ilm 997 
            dir.addSQLElement(new PaysSQLElement());
18 ilm 998 
 
94 ilm 999 
            dir.addSQLElement(new PieceSQLElement());
18 ilm 1000 
 
94 ilm 1001 
            dir.addSQLElement(ReferenceClientSQLElement.class);
1002 
            dir.addSQLElement(new RegimeBaseSQLElement());
1003 
            dir.addSQLElement(new RelanceSQLElement());
1004 
            dir.addSQLElement(new ReglementPayeSQLElement());
1005 
            dir.addSQLElement(new ReglerMontantSQLElement());
1006 
            dir.addSQLElement(ReglerMontantElementSQLElement.class);
1007 
            dir.addSQLElement(RepartitionAnalytiqueSQLElement.class);
18 ilm 1008 
 
94 ilm 1009 
            dir.addSQLElement(new SaisieAchatSQLElement());
1010 
            dir.addSQLElement(new FactureFournisseurSQLElement());
1011 
            dir.addSQLElement(new FactureFournisseurElementSQLElement());
1012 
            dir.addSQLElement(new TransferPurchaseSQLElement());
1013 
            dir.addSQLElement(new SaisieKmSQLElement());
1014 
            dir.addSQLElement(new SaisieVenteComptoirSQLElement());
1015 
            dir.addSQLElement(new SaisieVenteFactureSQLElement());
1016 
            dir.addSQLElement(new TransferInvoiceSQLElement());
1017 
            // at the end since it specifies action which initialize foreign keys
1018 
            dir.addSQLElement(AssociationAnalytiqueSQLElement.class);
156 ilm 1019 
                dir.addSQLElement(new SaisieVenteFactureItemSQLElement(this));
18 ilm 1020 
 
94 ilm 1021 
            dir.addSQLElement(SituationFamilialeSQLElement.class);
1022 
            dir.addSQLElement(new StockSQLElement());
1023 
            dir.addSQLElement(new StyleSQLElement());
18 ilm 1024 
 
94 ilm 1025 
            dir.addSQLElement(new SalarieSQLElement());
18 ilm 1026 
 
94 ilm 1027 
            dir.addSQLElement(TarifSQLElement.class);
1028 
            dir.addSQLElement(new TaxeSQLElement());
142 ilm 1029 
            dir.addSQLElement(TaxeComplementaireSQLElement.class);
94 ilm 1030 
            dir.addSQLElement(TicketCaisseSQLElement.class);
144 ilm 1031 
            dir.addSQLElement(ClôtureCaisseSQLElement.class);
1032 
            dir.addSQLElement(CaisseJournalSQLElement.class);
18 ilm 1033 
 
94 ilm 1034 
            dir.addSQLElement(new TypeComptePCGSQLElement());
1035 
            dir.addSQLElement(new TypeLettreRelanceSQLElement());
1036 
            dir.addSQLElement(new TypeReglementSQLElement());
151 ilm 1037 
            dir.addSQLElement(new SDDMessageSQLElement(this));
1038 
            dir.addSQLElement(new SEPAMandateSQLElement(this));
18 ilm 1039 
 
94 ilm 1040 
            dir.addSQLElement(new VariableSalarieSQLElement());
1041 
            dir.addSQLElement(UniteVenteArticleSQLElement.class);
73 ilm 1042 
 
94 ilm 1043 
            dir.addSQLElement(CalendarItemSQLElement.class);
1044 
            dir.addSQLElement(CalendarItemGroupSQLElement.class);
1045 
            dir.addSQLElement(DeviseHistoriqueSQLElement.class);
174 ilm 1046 
            dir.addSQLElement(EmailTemplateSQLElement.class);
94 ilm 1047 
 
1048 
            if (getRootSociete().contains("FWK_LIST_PREFS")) {
1049 
                dir.addSQLElement(new FWKListPrefs(getRootSociete()));
1050 
            }
1051 
            if (getRootSociete().contains("FWK_SESSION_STATE")) {
1052 
                dir.addSQLElement(new FWKSessionState(getRootSociete()));
1053 
            }
1054 
 
1055 
            // check that all codes are unique
1056 
            Collection<SQLElement> elements = dir.getElements();
1057 
            String s = "";
1058 
            for (SQLElement sqlElement : elements) {
1059 
                try {
1060 
                    SQLElement e = dir.getElementForCode(sqlElement.getCode());
1061 
                    if (e != sqlElement) {
1062 
                        s += "Error while retrieving element from code " + sqlElement.getCode() + "\n";
1063 
                    }
1064 
                } catch (Throwable e) {
1065 
                    s += "Error while retrieving element from code " + sqlElement.getCode() + " :\n " + e.getMessage() + "\n";
57 ilm 1066 
                }
1067 
            }
94 ilm 1068 
            if (!s.trim().isEmpty()) {
1069 
                ExceptionHandler.handle(s);
1070 
            }
1071 
        } catch (DBStructureItemNotFound e) {
144 ilm 1072 
            if (!GraphicsEnvironment.isHeadless()) {
1073 
 
149 ilm 1074 
                if (this.getServer().getSQLSystem().equals(SQLSystem.H2)) {
1075 
                    JOptionPane.showMessageDialog(null,
1076 
                            "Une table ou un champ est manquant dans la base de données.\nMettez à jour la base de données si vous venez de changer de version d'Openconcerto.");
1077 
 
1078 
                    final JFrame f = new JFrame("Mise à jour de la base de données");
1079 
                    f.setContentPane(new InstallationPanel(null));
1080 
                    f.pack();
1081 
                    f.setVisible(true);
1082 
                    f.setLocationRelativeTo(null);
1083 
                    f.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
1084 
 
1085 
                } else {
1086 
                    JOptionPane.showMessageDialog(null,
1087 
                            "Une table ou un champ est manquant dans la base de données. Mettez à jour votre base de données via l'outil de configuration si vous venez de changer de version d'Openconcerto.");
1088 
 
1089 
                }
1090 
 
144 ilm 1091 
            }
94 ilm 1092 
            throw e;
57 ilm 1093 
        }
18 ilm 1094 
    }
1095 
 
1096 
    private void setSocieteSQLInjector() {
1097 
        final DBRoot rootSociete = getRootSociete();
73 ilm 1098 
        setSocieteSQLInjector(rootSociete);
1099 
 
1100 
    }
1101 
 
1102 
    public static void setSocieteSQLInjector(final DBRoot rootSociete) {
65 ilm 1103 
        new AchatAvoirSQLInjector(rootSociete);
174 ilm 1104 
        new CommandeFactureEltSQLInjector(rootSociete);
19 ilm 1105 
        new ArticleCommandeEltSQLInjector(rootSociete);
1106 
        new CommandeCliCommandeSQLInjector(rootSociete);
18 ilm 1107 
        new FactureAvoirSQLInjector(rootSociete);
19 ilm 1108 
        new FactureBonSQLInjector(rootSociete);
1109 
        new FactureCommandeSQLInjector(rootSociete);
18 ilm 1110 
        new DevisFactureSQLInjector(rootSociete);
1111 
        new DevisCommandeSQLInjector(rootSociete);
19 ilm 1112 
        new DevisCommandeFournisseurSQLInjector(rootSociete);
156 ilm 1113 
        new DevisBlEltSQLInjector(rootSociete);
1114 
        new DevisBlSQLInjector(rootSociete);
18 ilm 1115 
        new CommandeBlEltSQLInjector(rootSociete);
180 ilm 1116 
        new CmdEltFactEltSQLInjector(rootSociete);
1117 
        new BrEltFactEltSQLInjector(rootSociete);
156 ilm 1118 
        new CommandeBrEltSQLInjector(rootSociete);
18 ilm 1119 
        new CommandeBlSQLInjector(rootSociete);
1120 
        new BonFactureSQLInjector(rootSociete);
142 ilm 1121 
        new BonFactureEltSQLInjector(rootSociete);
18 ilm 1122 
        new CommandeFactureClientSQLInjector(rootSociete);
1123 
        new CommandeBrSQLInjector(rootSociete);
94 ilm 1124 
        new BonReceptionFactureFournisseurSQLInjector(rootSociete);
18 ilm 1125 
        new CommandeFactureAchatSQLInjector(rootSociete);
174 ilm 1126 
        new CommandeFactureFournisseurSQLInjector(rootSociete);
18 ilm 1127 
        new EcheanceEncaisseSQLInjector(rootSociete);
80 ilm 1128 
        new EcheanceRegleSQLInjector(rootSociete);
18 ilm 1129 
        new BrFactureAchatSQLInjector(rootSociete);
1130 
        new DevisEltFactureEltSQLInjector(rootSociete);
144 ilm 1131 
 
1132 
        if (rootSociete.contains("DEMANDE_PRIX_ACHAT_ELEMENT")) {
1133 
            new DmdAchatDmdPrixEltSQLInjector(rootSociete);
156 ilm 1134 
            new DmdPrixCmdSQLInjector(rootSociete);
144 ilm 1135 
        }
1136 
 
18 ilm 1137 
    }
1138 
 
1139 
 
1140 
    private void setSocieteShowAs() {
19 ilm 1141 
        final ShowAs showAs = this.getShowAs();
94 ilm 1142 
        final DBRoot root = this.getRootSociete();
18 ilm 1143 
        showAs.setRoot(getRootSociete());
83 ilm 1144 
 
18 ilm 1145 
        showAs.show("AXE_ANALYTIQUE", "NOM");
1146 
 
83 ilm 1147 
        List<String> lEcr = new ArrayList<String>();
1148 
 
1149 
        lEcr.add("ID_MOUVEMENT");
1150 
        lEcr.add("ID_JOURNAL");
1151 
        lEcr.add("ID_COMPTE_PCE");
1152 
        lEcr.add("DATE");
1153 
 
1154 
        showAs.show(root.getTable("ASSOCIATION_ANALYTIQUE").getField("ID_ECRITURE"), lEcr);
1155 
 
18 ilm 1156 
        showAs.show("CHEQUE_A_ENCAISSER", "MONTANT", "ID_CLIENT");
142 ilm 1157 
 
41 ilm 1158 
                if (getRootSociete().getTable("CLIENT").getFieldsName().contains("LOCALISATION")) {
1159 
                    showAs.show("CLIENT", "NOM", "LOCALISATION");
1160 
                } else {
174 ilm 1161 
                    SQLPreferences prefs = SQLPreferences.getMemCached(root);
142 ilm 1162 
                    if (prefs.getBoolean(GestionClientPreferencePanel.DISPLAY_CLIENT_PCE, false)) {
1163 
                        showAs.show("CLIENT", "ID_PAYS", "GROUPE", "NOM", "ID_COMPTE_PCE");
1164 
                    } else {
1165 
                        showAs.show("CLIENT", "ID_PAYS", "GROUPE", "NOM");
1166 
                    }
41 ilm 1167 
                }
18 ilm 1168 
 
83 ilm 1169 
        showAs.show(BanqueSQLElement.TABLENAME, "NOM");
1170 
 
18 ilm 1171 
        showAs.show("CLASSEMENT_CONVENTIONNEL", "NIVEAU", "COEFF");
1172 
        showAs.show("CODE_EMPLOI", SQLRow.toList("CODE,NOM"));
1173 
        showAs.show("CODE_CONTRAT_TRAVAIL", SQLRow.toList("CODE,NOM"));
1174 
        showAs.show("CODE_DROIT_CONTRAT", SQLRow.toList("CODE,NOM"));
1175 
        showAs.show("CODE_CARACT_ACTIVITE", SQLRow.toList("CODE,NOM"));
1176 
        showAs.show("CODE_STATUT_PROF", SQLRow.toList("CODE,NOM"));
1177 
        showAs.show("CODE_STATUT_CATEGORIEL", SQLRow.toList("CODE,NOM"));
1178 
        showAs.show("CODE_REGIME", SQLRow.toList("CODE,NOM"));
156 ilm 1179 
 
149 ilm 1180 
        showAs.show("COMMANDE", "NUMERO", "DATE", "DATE_RECEPTION_DEMANDEE", "NOM", "ID_FOURNISSEUR");
156 ilm 1181 
        if (root.getTable("COMMANDE_CLIENT").contains("ID_AFFAIRE")) {
151 ilm 1182 
            showAs.show("COMMANDE_CLIENT", "NUMERO", "DATE", "ID_CLIENT", "ID_AFFAIRE", "NOM", "T_HT");
144 ilm 1183 
        } else {
156 ilm 1184 
            showAs.show("COMMANDE_CLIENT", "NUMERO", "ID_CLIENT", "DATE", "NOM", "T_HT");
144 ilm 1185 
        }
156 ilm 1186 
 
18 ilm 1187 
        showAs.show("COMPTE_PCE", "NUMERO", "NOM");
1188 
        showAs.show("COMPTE_PCG", "NUMERO", "NOM");
1189 
        showAs.show("CONTACT", "NOM");
1190 
        showAs.show("CONTRAT_SALARIE", "NATURE");
1191 
 
41 ilm 1192 
        List<String> listFieldDevisElt = new ArrayList<String>();
1193 
        listFieldDevisElt.add("NUMERO");
1194 
        listFieldDevisElt.add("DATE");
1195 
        listFieldDevisElt.add("ID_CLIENT");
93 ilm 1196 
 
1197 
        listFieldDevisElt.add("ID_ETAT_DEVIS");
41 ilm 1198 
        showAs.showField("DEVIS_ELEMENT.ID_DEVIS", listFieldDevisElt);
1199 
 
18 ilm 1200 
        showAs.show("DEPARTEMENT", "NUMERO", "NOM");
1201 
 
1202 
        showAs.show("ECRITURE", SQLRow.toList("NOM,DATE,ID_COMPTE_PCE,DEBIT,CREDIT"));
1203 
        showAs.show("ECHEANCE_CLIENT", SQLRow.toList("ID_CLIENT,ID_MOUVEMENT"));
83 ilm 1204 
        final List<String> lEchFact = new ArrayList<String>();
1205 
        lEchFact.add("NUMERO");
1206 
        lEchFact.add("DATE");
174 ilm 1207 
        lEchFact.add("ID_MODE_REGLEMENT");
149 ilm 1208 
        lEchFact.add("ID_COMMERCIAL");
83 ilm 1209 
        SQLTable tableEch = root.getTable("ECHEANCE_CLIENT");
1210 
        showAs.show(tableEch.getField("ID_SAISIE_VENTE_FACTURE"), lEchFact);
18 ilm 1211 
 
1212 
        showAs.show("ECHEANCE_FOURNISSEUR", SQLRow.toList("ID_FOURNISSEUR,ID_MOUVEMENT"));
174 ilm 1213 
        showAs.show("FICHE_PAYE", SQLRow.toList("ID_MOIS,ANNEE,ID_PROFIL_PAYE"));
1214 
 
19 ilm 1215 
        showAs.show("FOURNISSEUR", "NOM");
18 ilm 1216 
 
1217 
        showAs.show("IDCC", "NOM");
1218 
 
1219 
        showAs.show("JOURNAL", "NOM");
1220 
        showAs.show("MOIS", "NOM");
1221 
        showAs.show("MOUVEMENT", "NUMERO", "ID_PIECE");
1222 
        showAs.show("MODE_VENTE_ARTICLE", "NOM");
1223 
        showAs.show("MODE_REGLEMENT", "ID_TYPE_REGLEMENT", "AJOURS");
1224 
        showAs.show("MODE_REGLEMENT_PAYE", "NOM");
1225 
        showAs.show("MODELE_COURRIER_CLIENT", "NOM", "CONTENU");
1226 
 
1227 
        showAs.show("NATURE_COMPTE", "NOM");
93 ilm 1228 
        showAs.show("POSTE_ANALYTIQUE", "NOM", "ID_AXE_ANALYTIQUE");
18 ilm 1229 
        showAs.show("PAYS", "CODE", "NOM");
1230 
        showAs.show("PIECE", "ID", "NOM");
1231 
 
19 ilm 1232 
        final SQLElementDirectory directory = this.getDirectory();
18 ilm 1233 
        showAs.show("REPARTITION_ANALYTIQUE", "NOM");
1234 
        showAs.show("REGIME_BASE", "ID_CODE_REGIME_BASE");
177 ilm 1235 
        showAs.show("REGLEMENT_PAYE", "NOM_BANQUE", "IBAN", "BIC");
18 ilm 1236 
 
1237 
        List<String> listFieldModReglMontant = new ArrayList<String>();
1238 
        listFieldModReglMontant.add("ID_TYPE_REGLEMENT");
177 ilm 1239 
        listFieldModReglMontant.add("ID_" + BanqueSQLElement.TABLENAME);
18 ilm 1240 
 
1241 
        showAs.showField("REGLER_MONTANT.ID_MODE_REGLEMENT", listFieldModReglMontant);
1242 
        showAs.showField("ENCAISSER_MONTANT.ID_MODE_REGLEMENT", listFieldModReglMontant);
1243 
 
1244 
        List<String> listFieldFactureElt = new ArrayList<String>();
1245 
        listFieldFactureElt.add("NUMERO");
1246 
        listFieldFactureElt.add("DATE");
149 ilm 1247 
        listFieldFactureElt.add("ID_COMMERCIAL");
18 ilm 1248 
        listFieldFactureElt.add("ID_CLIENT");
1249 
        showAs.showField("SAISIE_VENTE_FACTURE_ELEMENT.ID_SAISIE_VENTE_FACTURE", listFieldFactureElt);
1250 
 
1251 
        showAs.show("SALARIE", SQLRow.toList("CODE,NOM,PRENOM"));
1252 
 
1253 
        showAs.show("SITUATION_FAMILIALE", "NOM");
156 ilm 1254 
        if (root.getTable("STOCK").contains("ID_ARTICLE")) {
1255 
            List<String> listFieldArtElt = new ArrayList<String>();
1256 
            listFieldArtElt.add("CODE");
1257 
            listFieldArtElt.add("NOM");
1258 
            listFieldArtElt.add("ID_FAMILLE_ARTICLE");
1259 
            showAs.showField("STOCK.ID_ARTICLE", listFieldArtElt);
1260 
        }
18 ilm 1261 
        showAs.show("STYLE", "NOM");
1262 
 
1263 
        showAs.show("TAXE", "TAUX");
1264 
 
1265 
        showAs.show(directory.getElement("TITRE_PERSONNEL").getTable(), asList("NOM"));
1266 
 
1267 
        showAs.show("TYPE_COMPTE_PCG", "NOM");
1268 
        showAs.show("TYPE_LETTRE_RELANCE", "NOM");
1269 
        showAs.show("TYPE_REGLEMENT", "NOM");
1270 
 
1271 
    }
1272 
 
80 ilm 1273 
    public String setUpSocieteStructure(int base) {
18 ilm 1274 
        setRowSociete(base);
1275 
 
1276 
        // find customer
1277 
        String customerName = "openconcerto";
80 ilm 1278 
        final String dbMD = getRootSociete().getMetadata("CUSTOMER");
18 ilm 1279 
        if (dbMD != null && !dbMD.equals(customerName))
1280 
            throw new IllegalStateException("customer is '" + customerName + "' but db says '" + dbMD + "'");
80 ilm 1281 
        return customerName;
1282 
    }
1283 
 
93 ilm 1284 
    @Override
80 ilm 1285 
    public void setUpSocieteDataBaseConnexion(int base) {
1286 
        final String customerName = setUpSocieteStructure(base);
1287 
        final DBRoot rootSociete = this.getRootSociete();
174 ilm 1288 
 
1289 
        try {
1290 
            // create table if necessary
1291 
            SQLPreferences.getPrefTable(rootSociete);
1292 
            SQLPreferences.startMemCached(rootSociete);
1293 
        } catch (Exception e) {
1294 
            // don't die now, we might not need them
1295 
            ExceptionHandler.handle("Impossible d'accéder aux préférences", e);
1296 
        }
1297 
 
18 ilm 1298 
        closeSocieteConnexion();
1299 
        setSocieteDirectory();
1300 
        NumerotationAutoSQLElement.addListeners();
73 ilm 1301 
        loadTranslations(this.getTranslator(), rootSociete, Arrays.asList("mappingCompta", "mapping-" + customerName));
18 ilm 1302 
        setSocieteShowAs();
1303 
        setSocieteSQLInjector();
83 ilm 1304 
        configureGlobalMapper();
1305 
        setFieldMapper(new FieldMapper(this.getRootSociete()));
1306 
        getFieldMapper().addMapperStreamFromClass(Gestion.class);
25 ilm 1307 
        TemplateNXProps.getInstance();
67 ilm 1308 
        // Prefetch undefined
1309 
        rootSociete.getTables().iterator().next().getUndefinedID();
144 ilm 1310 
 
156 ilm 1311 
        this.getModuleManager().addFactories(Gestion.MODULES_DIR);
1312 
        this.getModuleManager().setup(this.getRootSociete(), this);
144 ilm 1313 
    }
1314 
 
156 ilm 1315 
    public final ModuleManager getModuleManager() {
1316 
        return this.moduleMngr;
1317 
    }
1318 
 
144 ilm 1319 
    public void setupBarCodeIfNeeded() {
1320 
        final DBRoot rootSociete = this.getRootSociete();
174 ilm 1321 
        SQLPreferences pref = SQLPreferences.getMemCached(rootSociete);
142 ilm 1322 
        if (pref.getBoolean(GestionCommercialeGlobalPreferencePanel.BARCODE_INSERTION, false)) {
1323 
            this.barcodeReader = new BarcodeReader(80);
1324 
            this.barcodeReader.start();
1325 
        }
18 ilm 1326 
    }
1327 
 
142 ilm 1328 
    private BarcodeReader barcodeReader = null;
1329 
 
1330 
    public BarcodeReader getBarcodeReader() {
1331 
        return barcodeReader;
1332 
    }
1333 
 
83 ilm 1334 
    private void configureGlobalMapper() {
1335 
 
80 ilm 1336 
        FieldMapper fieldMapper = new FieldMapper(this.getRootSociete());
73 ilm 1337 
        fieldMapper.addMapperStreamFromClass(Gestion.class);
83 ilm 1338 
 
25 ilm 1339 
    }
1340 
 
18 ilm 1341 
    private void closeSocieteConnexion() {
1342 
 
1343 
    }
1344 
 
1345 
    public String getServerIp() {
1346 
        return getProperty("server.ip");
1347 
    }
19 ilm 1348 
 
28 ilm 1349 
    @Override
1350 
    protected DateFormat getLogDateFormat() {
1351 
        return new SimpleDateFormat("yyyy-MM/dd_HH-mm EEEE");
1352 
    }
1353 
 
41 ilm 1354 
    @Override
1355 
    protected SQLServer createServer() {
81 ilm 1356 
        if (GraphicsEnvironment.isHeadless()) {
156 ilm 1357 
            return super.createServer();
81 ilm 1358 
        }
41 ilm 1359 
        InProgressFrame progress = new InProgressFrame();
156 ilm 1360 
        if (isOnCloud) {
1361 
            progress.show("Connexion au cloud en cours");
1362 
        } else {
1363 
            progress.show("Connexion à la base de données en cours");
1364 
        }
73 ilm 1365 
        try {
1366 
            SQLServer server = super.createServer();
1367 
            return server;
1368 
        } catch (Throwable e) {
156 ilm 1369 
            if (isOnCloud) {
1370 
                JOptionPane.showMessageDialog(null, "Impossible de se connecter au cloud.\n\nVérifiez votre connexion internet.", "Erreur", JOptionPane.ERROR_MESSAGE);
1371 
            } else {
1372 
                JOptionPane.showMessageDialog(null, "Impossible de se connecter à la base de données.\n\nVérifiez votre connexion.", "Erreur réseau", JOptionPane.ERROR_MESSAGE);
1373 
            }
1374 
            System.exit(1);
73 ilm 1375 
            return null;
1376 
        } finally {
1377 
            progress.dispose();
1378 
        }
1379 
 
41 ilm 1380 
    }
61 ilm 1381 
 
1382 
    public static ComptaPropsConfiguration getInstanceCompta() {
1383 
        return (ComptaPropsConfiguration) getInstance();
1384 
    }
1385 
 
1386 
    public String getStorageServer() {
1387 
        return this.getProperty("storage.server");
1388 
    }
1389 
 
1390 
    public Image getCustomLogo() {
142 ilm 1391 
        final File dir = new File(getConfFile(getProductInfo()).getParent());
61 ilm 1392 
        final File file = new File(dir, "logo.png");
1393 
 
1394 
        BufferedImage im = null;
1395 
        if (file.exists()) {
1396 
            try {
1397 
                im = ImageIO.read(file);
1398 
                if (im.getHeight() < 16) {
1399 
                    JOptionPane.showMessageDialog(new JFrame(), "Logo too small (height < 16 pixels)");
1400 
                    return null;
1401 
                }
1402 
                if (im.getWidth() < 200) {
1403 
                    JOptionPane.showMessageDialog(new JFrame(), "Logo too small (width < 200 pixels)");
1404 
                    return null;
1405 
                }
1406 
                final Graphics g = im.getGraphics();
1407 
 
1408 
                g.setFont(new Font(Font.SANS_SERIF, Font.ITALIC, 11));
1409 
                ((Graphics2D) g).setRenderingHint(RenderingHints.KEY_TEXT_ANTIALIASING, RenderingHints.VALUE_TEXT_ANTIALIAS_ON);
1410 
                final String str = "Powered by OpenConcerto";
1411 
                final Rectangle2D r = g.getFontMetrics().getStringBounds(str, g);
1412 
                g.setColor(new Color(255, 255, 255, 200));
1413 
                g.fillRect(0, im.getHeight() - (int) r.getHeight() - 2, (int) r.getWidth() + 8, (int) r.getHeight() + 4);
1414 
                g.setColor(Color.BLACK);
1415 
                g.drawString(str, 4, im.getHeight() - 4);
1416 
                g.dispose();
1417 
            } catch (IOException e) {
1418 
                e.printStackTrace();
1419 
            }
1420 
 
1421 
        }
1422 
        return im;
1423 
    }
142 ilm 1424 
 
1425 
    public synchronized Currency getCurrency() {
1426 
        if (currency == null) {
1427 
            String code = getRowSociete().getForeign("ID_DEVISE").getString("CODE");
1428 
            currency = new Currency(code);
1429 
        }
1430 
        return currency;
1431 
    }
144 ilm 1432 
 
1433 
    public static void checkJava() {
1434 
        final String javaversion = System.getProperty("java.version");
1435 
        if (javaversion != null && javaversion.startsWith("1.")) {
1436 
            final String v = javaversion.substring(2);
1437 
            final StringBuilder b = new StringBuilder();
1438 
            for (int i = 0; i < v.length(); i++) {
1439 
                final char c = v.charAt(i);
1440 
                if (Character.isDigit(c)) {
1441 
                    b.append(c);
1442 
                } else {
1443 
                    break;
1444 
                }
1445 
            }
1446 
            final int version = Integer.parseInt(b.toString());
1447 
            if (version < 8) {
1448 
                System.err.println("Java " + javaversion + " not supported, please upgrade your java from https://www.java.com");
1449 
                if (GraphicsEnvironment.isHeadless()) {
1450 
                    JOptionPane.showMessageDialog(null, "Please upgrade your Java.\n\nMerci de mettre à jour votre Java.\n\n https://www.java.com", "Java version", JOptionPane.ERROR_MESSAGE);
1451 
                }
1452 
                System.exit(666);
1453 
            }
1454 
        }
1455 
    }
1456 
 
18 ilm 1457 
}