OpenConcerto

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

svn://code.openconcerto.org/openconcerto

Rev

Rev 180 | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 180 Rev 182
Line 1... Line 1...
1 
/*
 1 
/*
2 
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
 2 
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
3 
 *
3 
 *
4 
 * Copyright 2011 OpenConcerto, by ILM Informatique. All rights reserved.
 4 
 * Copyright 2011-2019 OpenConcerto, by ILM Informatique. All rights reserved.
5 
 *
5 
 *
6 
 * The contents of this file are subject to the terms of the GNU General Public License Version 3
 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
 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
 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.
 9 
 * language governing permissions and limitations under the License.
Line 20... Line 20...
20 
import org.openconcerto.sql.model.SQLField;
 20 
import org.openconcerto.sql.model.SQLField;
21 
import org.openconcerto.sql.model.SQLRow;
 21 
import org.openconcerto.sql.model.SQLRow;
22 
import org.openconcerto.sql.model.Where;
 22 
import org.openconcerto.sql.model.Where;
23 
import org.openconcerto.utils.GestionDevise;
 23 
import org.openconcerto.utils.GestionDevise;
24 
 
 24 
 
- 
 
 25 
import java.io.File;
25 
import java.text.DateFormat;
 26 
import java.text.DateFormat;
26 
import java.text.SimpleDateFormat;
 27 
import java.text.SimpleDateFormat;
27 
import java.util.Date;
 28 
import java.util.Date;
28 
import java.util.HashMap;
 29 
import java.util.HashMap;
29 
import java.util.List;
 30 
import java.util.List;
Line 184... Line 185...
184 
        // Racine = "260D, 261, 266-268, 270-272, 274-275, 2760-2761, 27680,
 185 
        // Racine = "260D, 261, 266-268, 270-272, 274-275, 2760-2761, 27680,
185 
        // 27682, 27684-27685,
 186 
        // 27682, 27684-27685,
186 
        // 27688, 277"
 187 
        // 27688, 277"
187 
        // S040=261+266...268+271+272+27682+274+27684+275+2761+27685+27688
 188 
        // S040=261+266...268+271+272+27682+274+27684+275+2761+27685+27688
188 
        long v040 = this.sommeCompte.sommeCompteFils("261", this.dateDebut, this.dateFin) + this.sommeCompte.soldeCompte(266, 268, true, this.dateDebut, this.dateFin)
 189 
        long v040 = this.sommeCompte.sommeCompteFils("261", this.dateDebut, this.dateFin) + this.sommeCompte.soldeCompte(266, 268, true, this.dateDebut, this.dateFin)
189 
                + this.sommeCompte.soldeCompte(271, 275, true, this.dateDebut, this.dateFin) + this.sommeCompte.soldeCompte(2761, 2761, true, this.dateDebut, this.dateFin)
 190 
                + this.sommeCompte.soldeCompte(270, 275, true, this.dateDebut, this.dateFin) + this.sommeCompte.soldeCompte(2761, 2761, true, this.dateDebut, this.dateFin)
190 
                + this.sommeCompte.sommeCompteFils("27682", this.dateDebut, this.dateFin) + this.sommeCompte.soldeCompte(27684, 27685, true, this.dateDebut, this.dateFin)
 191 
                + this.sommeCompte.sommeCompteFils("27682", this.dateDebut, this.dateFin) + this.sommeCompte.soldeCompte(27684, 27685, true, this.dateDebut, this.dateFin)
191 
                + this.sommeCompte.sommeCompteFils("27688", this.dateDebut, this.dateFin);
 192 
                + this.sommeCompte.sommeCompteFils("27688", this.dateDebut, this.dateFin);
192 
 
 193 
 
193 
        this.m.put("ACTIF1.3", GestionDevise.currencyToString(v040, false));
 194 
        this.m.put("ACTIF1.3", GestionDevise.currencyToString(v040, false));
194 
 
 195 
 
Line 683... Line 684...
683 
         * this.sommeCompte.sommeCompteFils("5186") ;
 684 
         * this.sommeCompte.sommeCompteFils("5186") ;
684 
         */
 685 
         */
685 
        long v156 = -this.sommeCompte.sommeCompteFils("160", this.dateDebut, this.dateFin) - this.sommeCompte.sommeCompteFils("161", this.dateDebut, this.dateFin)
 686 
        long v156 = -this.sommeCompte.sommeCompteFils("160", this.dateDebut, this.dateFin) - this.sommeCompte.sommeCompteFils("161", this.dateDebut, this.dateFin)
686 
                - this.sommeCompte.soldeCompte(163, 166, true, this.dateDebut, this.dateFin) - this.sommeCompte.soldeCompte(1680, 1681, true, this.dateDebut, this.dateFin)
 687 
                - this.sommeCompte.soldeCompte(163, 166, true, this.dateDebut, this.dateFin) - this.sommeCompte.soldeCompte(1680, 1681, true, this.dateDebut, this.dateFin)
687 
                - this.sommeCompte.soldeCompte(1682, 1682, true, this.dateDebut, this.dateFin) - this.sommeCompte.soldeCompte(1684, 1689, true, this.dateDebut, this.dateFin)
 688 
                - this.sommeCompte.soldeCompte(1682, 1682, true, this.dateDebut, this.dateFin) - this.sommeCompte.soldeCompte(1684, 1689, true, this.dateDebut, this.dateFin)
688 
                - this.sommeCompte.sommeCompteFils("17", this.dateDebut, this.dateFin) - this.sommeCompte.sommeCompteFils("426", this.dateDebut, this.dateFin)
 689 
                - this.sommeCompte.sommeCompteFils("19", this.dateDebut, this.dateFin) - this.sommeCompte.sommeCompteFils("17", this.dateDebut, this.dateFin)
689 
                + this.sommeCompte.soldeCompteCrediteur(450, 454, true, this.dateDebut, this.dateFin) + this.sommeCompte.soldeCompteCrediteur(456, 456, true, this.dateDebut, this.dateFin)
 690 
                - this.sommeCompte.sommeCompteFils("426", this.dateDebut, this.dateFin) + this.sommeCompte.soldeCompteCrediteur(450, 454, true, this.dateDebut, this.dateFin)
690 
                + this.sommeCompte.soldeCompteCrediteur(458, 459, true, this.dateDebut, this.dateFin) + this.sommeCompte.soldeCompteCrediteur(512, 517, true, this.dateDebut, this.dateFin)
 691 
                + this.sommeCompte.soldeCompteCrediteur(456, 456, true, this.dateDebut, this.dateFin) + this.sommeCompte.soldeCompteCrediteur(458, 459, true, this.dateDebut, this.dateFin)
691 
                + this.sommeCompte.soldeCompteCrediteur(518, 518, true, this.dateDebut, this.dateFin) - this.sommeCompte.sommeCompteFils("519", this.dateDebut, this.dateFin);
 692 
                + this.sommeCompte.soldeCompteCrediteur(512, 517, true, this.dateDebut, this.dateFin) + this.sommeCompte.soldeCompteCrediteur(518, 518, true, this.dateDebut, this.dateFin)
- 
 
 693 
                - this.sommeCompte.sommeCompteFils("519", this.dateDebut, this.dateFin);
692 
        this.m.put("PASSIF3.25", GestionDevise.currencyToString(v156, false));
 694 
        this.m.put("PASSIF3.25", GestionDevise.currencyToString(v156, false));
693 
 
 695 
 
694 
        // 151
 696 
        // 151
695 
        this.m.put("PASSIF4.25", "");
 697 
        this.m.put("PASSIF4.25", "");
696 
 
 698 
 
Line 872... Line 874...
872 
            }
 874 
            }
873 
        });
 875 
        });
874 
 
 876 
 
875 
        SwingUtilities.invokeLater(new Runnable() {
 877 
        SwingUtilities.invokeLater(new Runnable() {
876 
            public void run() {
 878 
            public void run() {
- 
 
 879 
                final File generatedFile = p.getGeneratedFile();
- 
 
 880 
                if (generatedFile != null) {
877 
                Gestion.openPDF(p.getGeneratedFile());
 881 
                    Gestion.openPDF(generatedFile);
- 
 
 882 
                } else {
878 
                Map2033A.this.bar.setValue(100);
 883 
                    Map2033A.this.bar.setValue(100);
879 
            }
 884 
                }
- 
 
 885 
            }
880 
        });
 886 
        });
881 
 
 887 
 
882 
    }
 888 
    }
883 
 
 889 
 
884 
    public Map2033A(JProgressBar bar, Date dateDeb, Date dateFin) {
 890 
    public Map2033A(JProgressBar bar, Date dateDeb, Date dateFin) {