OpenConcerto

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

svn://code.openconcerto.org/openconcerto

Rev

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

Rev 174 Rev 177
Line 15... Line 15...
15
 
15
 
16
import org.openconcerto.erp.config.ComptaPropsConfiguration;
16
import org.openconcerto.erp.config.ComptaPropsConfiguration;
17
import org.openconcerto.erp.config.Gestion;
17
import org.openconcerto.erp.config.Gestion;
18
import org.openconcerto.erp.core.finance.accounting.model.SommeCompte;
18
import org.openconcerto.erp.core.finance.accounting.model.SommeCompte;
19
import org.openconcerto.sql.Configuration;
19
import org.openconcerto.sql.Configuration;
-
 
20
import org.openconcerto.sql.model.SQLField;
20
import org.openconcerto.sql.model.SQLRow;
21
import org.openconcerto.sql.model.SQLRow;
-
 
22
import org.openconcerto.sql.model.Where;
21
import org.openconcerto.utils.GestionDevise;
23
import org.openconcerto.utils.GestionDevise;
22
 
24
 
23
import java.text.DateFormat;
25
import java.text.DateFormat;
24
import java.text.SimpleDateFormat;
26
import java.text.SimpleDateFormat;
25
import java.util.Date;
27
import java.util.Date;
26
import java.util.HashMap;
28
import java.util.HashMap;
-
 
29
import java.util.List;
27
import java.util.Map;
30
import java.util.Map;
28
 
31
 
-
 
32
import javax.swing.JOptionPane;
29
import javax.swing.JProgressBar;
33
import javax.swing.JProgressBar;
30
import javax.swing.SwingUtilities;
34
import javax.swing.SwingUtilities;
31
 
35
 
32
public class Map2033B extends Thread {
36
public class Map2033B extends Thread {
33
    private Map<String, String> m;
37
    private Map<String, String> m;
Line 80... Line 84...
80
        // 215
84
        // 215
81
        long v215 = 0;
85
        long v215 = 0;
82
        this.m.put("PRODUIT1.1", GestionDevise.currencyToString(v215, false));
86
        this.m.put("PRODUIT1.1", GestionDevise.currencyToString(v215, false));
83
 
87
 
84
        // 214 -SommeSolde( 700, 705* )-SommeSolde( 7090, 7095* )
88
        // 214 -SommeSolde( 700, 705* )-SommeSolde( 7090, 7095* )
85
        long v214 = -this.sommeCompte.soldeCompte(700, 705, true, this.dateDeb, this.dateFin) - this.sommeCompte.soldeCompte(7090, 7095, true, this.dateDeb, this.dateFin);
89
        long v214 = -this.sommeCompte.soldeCompte(700, 705, true, this.dateDeb, this.dateFin) - this.sommeCompte.soldeCompte("709", this.dateDeb, this.dateFin)
-
 
90
                - this.sommeCompte.soldeCompte(7090, 7095, true, this.dateDeb, this.dateFin);
-
 
91
 
86
        this.m.put("PRODUIT2.1", GestionDevise.currencyToString(v214, false));
92
        this.m.put("PRODUIT2.1", GestionDevise.currencyToString(v214, false));
87
 
93
 
88
        // 201
94
        // 201
89
        this.m.put("PRODUIT3.1", "");
95
        this.m.put("PRODUIT3.1", "");
90
 
96
 
Line 367... Line 373...
367
 
373
 
368
        /*******************************************************************************************
374
        /*******************************************************************************************
369
         * PRODUITS EXCEPTIONNELS
375
         * PRODUITS EXCEPTIONNELS
370
         ******************************************************************************************/
376
         ******************************************************************************************/
371
        // 290 -SommeSolde( 77, 77* )-SommeSolde( 787, 789* )-SommeSolde( 797, 799* )
377
        // 290 -SommeSolde( 77, 77* )-SommeSolde( 787, 789* )-SommeSolde( 797, 799* )
372
        long v290 = -this.sommeCompte.soldeCompte(770, 772, true, this.dateDeb, this.dateFin) - this.sommeCompte.soldeCompte(775, 778, true, this.dateDeb, this.dateFin)
378
        long v290 = -this.sommeCompte.soldeCompte(77, 77, true, this.dateDeb, this.dateFin) - this.sommeCompte.soldeCompte(787, 787, true, this.dateDeb, this.dateFin)
373
                - this.sommeCompte.soldeCompte(787, 787, true, this.dateDeb, this.dateFin) - this.sommeCompte.soldeCompte(797, 797, true, this.dateDeb, this.dateFin);
379
                - this.sommeCompte.soldeCompte(797, 797, true, this.dateDeb, this.dateFin);
374
        this.m.put("PCHARGES3.22", GestionDevise.currencyToString(v290, false));
380
        this.m.put("PCHARGES3.22", GestionDevise.currencyToString(v290, false));
375
 
381
 
376
        // 245
382
        // 245
377
        this.m.put("PCHARGES4.22", "");
383
        this.m.put("PCHARGES4.22", "");
378
 
384
 
Line 482... Line 488...
482
        this.m.put("T2.41", "");
488
        this.m.put("T2.41", "");
483
        this.m.put("T3.41", "");
489
        this.m.put("T3.41", "");
484
        this.m.put("T4.41", "");
490
        this.m.put("T4.41", "");
485
        this.m.put("T2.42", "");
491
        this.m.put("T2.42", "");
486
 
492
 
-
 
493
        final SQLField field = ComptaPropsConfiguration.getInstanceCompta().getRootSociete().getTable("COMPTE_PCE").getField("NUMERO");
-
 
494
        Where where = new Where(field, "LIKE", "6%");
-
 
495
        where = where.or(new Where(field, "LIKE", "7%"));
-
 
496
        List<String> unused = this.sommeCompte.getNonUsedCompte(where, this.dateDeb, this.dateFin);
-
 
497
        if (unused != null && !unused.isEmpty()) {
-
 
498
            JOptionPane.showMessageDialog(null, "Certains comptes n'ont pas été intégré : " + unused);
-
 
499
        }
-
 
500
 
487
        // final SQLField field =
501
        // final SQLField field =
488
        // ComptaPropsConfiguration.getInstanceCompta().getRootSociete().getTable("COMPTE_PCE").getField("NUMERO");
502
        // ComptaPropsConfiguration.getInstanceCompta().getRootSociete().getTable("COMPTE_PCE").getField("NUMERO");
489
        // Where where = new Where(field, "LIKE", "6%");
503
        // Where where = new Where(field, "LIKE", "6%");
490
        // where = where.or(new Where(field, "LIKE", "7%"));
504
        // where = where.or(new Where(field, "LIKE", "7%"));
491
        // this.sommeCompte.getNonUsedCompte(where, this.dateDeb, this.dateFin);
505
        // this.sommeCompte.getNonUsedCompte(where, this.dateDeb, this.dateFin);