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);
|