Dépôt officiel du code source de l'ERP OpenConcerto
svn://code.openconcerto.org/openconcerto
(root)/trunk/OpenConcerto/src/org/openconcerto/erp/core/finance/accounting/report/Map2033B.java @ 174 - Rev 177
Rev 174 | Rev 180 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed
/** DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.** Copyright 2011 OpenConcerto, by ILM Informatique. All rights reserved.** The contents of this file are subject to the terms of the GNU General Public License Version 3* only ("GPL"). You may not use this file except in compliance with the License. You can obtain a* copy of the License at http://www.gnu.org/licenses/gpl-3.0.html See the License for the specific* language governing permissions and limitations under the License.** When distributing the software, include this License Header Notice in each file.*/package org.openconcerto.erp.core.finance.accounting.report;import org.openconcerto.erp.config.ComptaPropsConfiguration;import org.openconcerto.erp.config.Gestion;import org.openconcerto.erp.core.finance.accounting.model.SommeCompte;import org.openconcerto.sql.Configuration;import org.openconcerto.sql.model.SQLField;import org.openconcerto.sql.model.SQLRow;import org.openconcerto.sql.model.Where;import org.openconcerto.utils.GestionDevise;import java.text.DateFormat;import java.text.SimpleDateFormat;import java.util.Date;import java.util.HashMap;import java.util.List;import java.util.Map;import javax.swing.JOptionPane;import javax.swing.JProgressBar;import javax.swing.SwingUtilities;public class Map2033B extends Thread {private Map<String, String> m;private final DateFormat format = new SimpleDateFormat("ddMMyyyy");private JProgressBar bar;private Date dateDeb, dateFin;SommeCompte sommeCompte;public void run() {final PdfGenerator_2033B p = new PdfGenerator_2033B();this.m = new HashMap<String, String>();SQLRow rowSociete = ((ComptaPropsConfiguration) Configuration.getInstance()).getRowSociete();this.m.put("NOM", rowSociete.getString("TYPE") + " " + rowSociete.getString("NOM"));// SQLRow rowExercice =// Configuration.getInstance().getBase().getTable("EXERCICE_COMMON").getRow(rowSociete.getInt("ID_EXERCICE_COMMON"));// Date dateFin = (Date) rowExercice.getObject("DATE_FIN");// Date dateDeb = (Date) rowExercice.getObject("DATE_DEB");this.m.put("CLOS1", format.format(this.dateFin));this.m.put("CLOS2", "");/******************************************************************************************** A - RESULTAT COMPTABLE******************************************************************************************//******************************************************************************************** PRODUITS D'EXPLOITATION******************************************************************************************//******************************************************************************************** VENTES DE MARCHANDISES******************************************************************************************/// 209long v209 = 0;this.m.put("PRODUIT1.0", GestionDevise.currencyToString(v209, false));// 210 -SommeSolde( 707, 707* )-SommeSolde( 7097, 7097* )long v210 = -this.sommeCompte.soldeCompte(707, 707, true, this.dateDeb, this.dateFin) - this.sommeCompte.soldeCompte(7097, 7097, true, this.dateDeb, this.dateFin);this.m.put("PRODUIT2.0", GestionDevise.currencyToString(v210, false));// 200this.m.put("PRODUIT3.0", "");/******************************************************************************************** PRODUCTION VENDUE ---> BIEN******************************************************************************************/// 215long v215 = 0;this.m.put("PRODUIT1.1", GestionDevise.currencyToString(v215, false));// 214 -SommeSolde( 700, 705* )-SommeSolde( 7090, 7095* )long v214 = -this.sommeCompte.soldeCompte(700, 705, true, this.dateDeb, this.dateFin) - this.sommeCompte.soldeCompte("709", this.dateDeb, this.dateFin)- this.sommeCompte.soldeCompte(7090, 7095, true, this.dateDeb, this.dateFin);this.m.put("PRODUIT2.1", GestionDevise.currencyToString(v214, false));// 201this.m.put("PRODUIT3.1", "");/******************************************************************************************** PRODUCTION VENDUE ---> SERVICES******************************************************************************************/// 217long v217 = 0;this.m.put("PRODUIT1.2", GestionDevise.currencyToString(v217, false));// 218 -SommeSolde( 706, 706* )-SommeSolde( 708, 708* )-SommeSolde( 7096, 7096*// )-SommeSolde( 7098, 7099* )long v218 = -this.sommeCompte.soldeCompte(706, 706, true, this.dateDeb, this.dateFin) - this.sommeCompte.soldeCompte(708, 708, true, this.dateDeb, this.dateFin)- this.sommeCompte.soldeCompte(7096, 7096, true, this.dateDeb, this.dateFin) - this.sommeCompte.soldeCompte(7098, 7099, true, this.dateDeb, this.dateFin);this.m.put("PRODUIT2.2", GestionDevise.currencyToString(v218, false));// 202this.m.put("PRODUIT3.2", "");SwingUtilities.invokeLater(new Runnable() {public void run() {Map2033B.this.bar.setValue(10);}});/******************************************************************************************** PRODUCTION STOCKEE******************************************************************************************/// 222 -SommeSolde( 710, 719* )long v222 = -this.sommeCompte.soldeCompte(713, 713, true, this.dateDeb, this.dateFin);this.m.put("PRODUIT2.3", GestionDevise.currencyToString(v222, false));// 203this.m.put("PRODUIT3.3", "");/******************************************************************************************** PRODUCTION IMMOBILISEE******************************************************************************************/// 224 -SommeSolde( 72, 72* )long v224 = -this.sommeCompte.soldeCompte(72, 73, true, this.dateDeb, this.dateFin);this.m.put("PRODUIT2.4", GestionDevise.currencyToString(v224, false));// 204this.m.put("PRODUIT3.4", "");/******************************************************************************************** SUBVENTION D'EXPLOITATION******************************************************************************************/// 226 -SommeSolde( 74, 74* )long v226 = -this.sommeCompte.soldeCompte(74, 74, true, this.dateDeb, this.dateFin);this.m.put("PRODUIT2.5", GestionDevise.currencyToString(v226, false));// 205this.m.put("PRODUIT3.5", "");/******************************************************************************************** AUTRES PRODUITS******************************************************************************************/// 230 -SommeSolde( 73, 73* )-SommeSolde( 75, 75* )-SommeSolde( 780, 785* )-SommeSolde( 790,// 795* )long v230 = -this.sommeCompte.soldeCompte(75, 75, true, this.dateDeb, this.dateFin) - this.sommeCompte.soldeCompte(780, 785, true, this.dateDeb, this.dateFin)- this.sommeCompte.soldeCompte(790, 795, true, this.dateDeb, this.dateFin);this.m.put("PRODUIT2.6", GestionDevise.currencyToString(v230, false));// 206this.m.put("PRODUIT3.6", "");SwingUtilities.invokeLater(new Runnable() {public void run() {Map2033B.this.bar.setValue(20);}});/******************************************************************************************** TOTAL I******************************************************************************************/// 232 v210+v214+v218+v222+v224+v226+v230long v232 = v210 + v214 + v218 + v222 + v224 + v226 + v230;this.m.put("PRODUIT2.7", GestionDevise.currencyToString(v232, false));// 207this.m.put("PRODUIT3.7", "");/******************************************************************************************** CHARGES D'EXPLOITATION******************************************************************************************//******************************************************************************************** ACHATS DE MARCHANDISES******************************************************************************************/// 234 SommeSolde( 607, 608* )+SommeSolde( 6097, 6097* )long v234 = this.sommeCompte.soldeCompte(607, 607, true, this.dateDeb, this.dateFin) + this.sommeCompte.soldeCompte(6097, 6097, true, this.dateDeb, this.dateFin)+ this.sommeCompte.soldeCompte(6087, 6087, true, this.dateDeb, this.dateFin);this.m.put("CHARGES3.8", GestionDevise.currencyToString(v234, false));// 208this.m.put("CHARGES4.8", "");/******************************************************************************************** VARIATION DE STOCK******************************************************************************************/// 236 SommeSolde( 6037, 6039* )long v236 = this.sommeCompte.soldeCompte(6037, 6037, true, this.dateDeb, this.dateFin);this.m.put("CHARGES3.9", GestionDevise.currencyToString(v236, false));// 211this.m.put("CHARGES4.9", "");/******************************************************************************************** ACHATS DE MATIERE PREMIERE******************************************************************************************/// 238 SommeSolde( 600, 602* )+SommeSolde( 6090, 6092* )// S238=601+602+6091+6092// FIX Abaque ajout 609long v238 = this.sommeCompte.soldeCompte(601, 602, true, this.dateDeb, this.dateFin) + this.sommeCompte.soldeCompte(609, 609, true, this.dateDeb, this.dateFin)- this.sommeCompte.soldeCompte(6093, 6099, true, this.dateDeb, this.dateFin) + this.sommeCompte.soldeCompte(6081, 6082, true, this.dateDeb, this.dateFin);this.m.put("CHARGES3.10", GestionDevise.currencyToString(v238, false));// 212this.m.put("CHARGES4.10", "");SwingUtilities.invokeLater(new Runnable() {public void run() {Map2033B.this.bar.setValue(40);}});/******************************************************************************************** VARIATION DE STOCK******************************************************************************************/// 240 SommeSolde( 6030, 6036* )long v240 = this.sommeCompte.soldeCompte(6031, 6036, true, this.dateDeb, this.dateFin);this.m.put("CHARGES3.11", GestionDevise.currencyToString(v240, false));// 213this.m.put("CHARGES4.11", "");/******************************************************************************************** AUTRES CHARGES EXTERNES******************************************************************************************/// S242M=6122this.m.put("CBAIL_MO12", GestionDevise.currencyToString(this.sommeCompte.sommeCompteFils("6122", this.dateDeb, this.dateFin), false));// S242I=6125this.m.put("CBAIL_IMMO12", GestionDevise.currencyToString(this.sommeCompte.sommeCompteFils("6125", this.dateDeb, this.dateFin), false));// 242 SommeSolde( 604, 606* )+SommeSolde( 6093, 6096* )+SommeSolde( 6098, 6099*// )+SommeSolde( 61, 62* )// S242=604...606+6094...6096+6098+611+6122+6125+613...619+621...629long v242 = this.sommeCompte.soldeCompte(604, 606, true, this.dateDeb, this.dateFin) + this.sommeCompte.soldeCompte(6084, 6086, true, this.dateDeb, this.dateFin)+ this.sommeCompte.soldeCompte(6094, 6096, true, this.dateDeb, this.dateFin) + this.sommeCompte.soldeCompte(61, 62, true, this.dateDeb, this.dateFin);this.m.put("CHARGES3.12", GestionDevise.currencyToString(v242, false));// 216this.m.put("CHARGES4.12", "");/******************************************************************************************** IMPOTS, TAXES******************************************************************************************/// 243this.m.put("CHARGES1.13", "");// 244 SommeSolde( 63, 63* )long v244 = this.sommeCompte.soldeCompte(63, 63, true, this.dateDeb, this.dateFin);this.m.put("CHARGES2.13", GestionDevise.currencyToString(v244, false));// 219this.m.put("CHARGES3.13", "");SwingUtilities.invokeLater(new Runnable() {public void run() {Map2033B.this.bar.setValue(50);}});/******************************************************************************************** REMUNERATION Du PERSONNEL******************************************************************************************/// 250 SommeSolde( 640, 644* )+SommeSolde( 648, 649* )long v250 = this.sommeCompte.soldeCompte(644, 644, true, this.dateDeb, this.dateFin) + this.sommeCompte.soldeCompte(648, 649, true, this.dateDeb, this.dateFin)+ this.sommeCompte.soldeCompte(641, 641, true, this.dateDeb, this.dateFin) + this.sommeCompte.soldeCompte(642, 642, true, this.dateDeb, this.dateFin);this.m.put("CHARGES3.14", GestionDevise.currencyToString(v250, false));// 220this.m.put("CHARGES4.14", "");/******************************************************************************************** CHARGES SOCIALES******************************************************************************************/// 252 SommeSolde( 645, 647* )long v252 = this.sommeCompte.soldeCompte(645, 647, true, this.dateDeb, this.dateFin);this.m.put("CHARGES3.15", GestionDevise.currencyToString(v252, false));// 221this.m.put("CHARGES4.15", "");/******************************************************************************************** DOTATIONS AUX AMMORTISSEMENTS******************************************************************************************/// 254 SommeSolde( 6800, 6814* )long v254 = this.sommeCompte.soldeCompte(6811, 6812, true, this.dateDeb, this.dateFin) + this.sommeCompte.soldeCompte(6816, 6817, true, this.dateDeb, this.dateFin);this.m.put("CHARGES3.16", GestionDevise.currencyToString(v254, false));// 221this.m.put("CHARGES4.16", "");SwingUtilities.invokeLater(new Runnable() {public void run() {Map2033B.this.bar.setValue(60);}});/******************************************************************************************** DOTATIONS AUX PROVISIONS******************************************************************************************/// 256 SommeSolde( 6815, 6859* )long v256 = this.sommeCompte.soldeCompte(6815, 6815, true, this.dateDeb, this.dateFin);this.m.put("CHARGES3.17", GestionDevise.currencyToString(v256, false));// 222this.m.put("CHARGES4.17", "");/******************************************************************************************** AUTRES CHARGES******************************************************************************************/// 259this.m.put("CHARGES1.18", "");// 262 SommeSolde( 65, 65* )long v262 = this.sommeCompte.soldeCompte(65, 65, true, this.dateDeb, this.dateFin);this.m.put("CHARGES2.18", GestionDevise.currencyToString(v262, false));// 228this.m.put("CHARGES3.18", "");SwingUtilities.invokeLater(new Runnable() {public void run() {Map2033B.this.bar.setValue(70);}});/******************************************************************************************** TOTAL II******************************************************************************************/// 264 v234+v236+v238+v240+v242+v244+v250+v252+v254+v256+v262long v264 = v234 + v236 + v238 + v240 + v242 + v244 + v250 + v252 + v254 + v256 + v262;this.m.put("PCHARGES3.19", GestionDevise.currencyToString(v264, false));// 231this.m.put("PCHARGES4.19", "");/******************************************************************************************** RESULTAT D'EXPLOTATION******************************************************************************************/// 270 v232-v264long v270 = v232 - v264;this.m.put("PCHARGES3.20", GestionDevise.currencyToString(v270, false));// 235this.m.put("PCHARGES4.20", "");/******************************************************************************************** PRODUITS ET CHARGES DIVERS******************************************************************************************//******************************************************************************************** PRODUITS FINANCIERS******************************************************************************************/// 280 -SommeSolde( 760, 769* )-SommeSolde( 786, 786* )-SommeSolde( 796, 796* )long v280 = -this.sommeCompte.soldeCompte(760, 768, true, this.dateDeb, this.dateFin) - this.sommeCompte.soldeCompte(786, 786, true, this.dateDeb, this.dateFin)- this.sommeCompte.soldeCompte(796, 796, true, this.dateDeb, this.dateFin);this.m.put("PCHARGES3.21", GestionDevise.currencyToString(v280, false));// 237this.m.put("PCHARGES4.21", "");SwingUtilities.invokeLater(new Runnable() {public void run() {Map2033B.this.bar.setValue(80);}});/******************************************************************************************** PRODUITS EXCEPTIONNELS******************************************************************************************/// 290 -SommeSolde( 77, 77* )-SommeSolde( 787, 789* )-SommeSolde( 797, 799* )long v290 = -this.sommeCompte.soldeCompte(77, 77, true, this.dateDeb, this.dateFin) - this.sommeCompte.soldeCompte(787, 787, true, this.dateDeb, this.dateFin)- this.sommeCompte.soldeCompte(797, 797, true, this.dateDeb, this.dateFin);this.m.put("PCHARGES3.22", GestionDevise.currencyToString(v290, false));// 245this.m.put("PCHARGES4.22", "");/******************************************************************************************** CHARGES FINANCIERES******************************************************************************************/// 294 SommeSolde( 66, 66* )+SommeSolde( 686, 686* )long v294 = this.sommeCompte.soldeCompte(661, 661, true, this.dateDeb, this.dateFin) + this.sommeCompte.soldeCompte(686, 686, true, this.dateDeb, this.dateFin)+ this.sommeCompte.soldeCompte(664, 668, true, this.dateDeb, this.dateFin);this.m.put("PCHARGES3.23", GestionDevise.currencyToString(v294, false));// 246this.m.put("PCHARGES4.23", "");/******************************************************************************************** CHARGES EXCEPTIONNELLES******************************************************************************************/// 300 SommeSolde( 67, 67* )+SommeSolde( 687, 689* )long v300 = this.sommeCompte.soldeCompte(67, 67, true, this.dateDeb, this.dateFin) + this.sommeCompte.soldeCompte(687, 687, true, this.dateDeb, this.dateFin);this.m.put("PCHARGES3.24", GestionDevise.currencyToString(v300, false));// 247this.m.put("PCHARGES4.24", "");SwingUtilities.invokeLater(new Runnable() {public void run() {Map2033B.this.bar.setValue(90);}});/******************************************************************************************** IMPOTS SUR LES BENEFICES******************************************************************************************/// 306 SommeSolde( 69, 69* )long v306 = this.sommeCompte.soldeCompte(697, 699, true, this.dateDeb, this.dateFin) + this.sommeCompte.soldeCompte(695, 695, true, this.dateDeb, this.dateFin)+ this.sommeCompte.soldeCompte(689, 689, true, this.dateDeb, this.dateFin) + this.sommeCompte.soldeCompte(789, 789, true, this.dateDeb, this.dateFin);this.m.put("PCHARGES3.25", GestionDevise.currencyToString(v306, false));// 257this.m.put("PCHARGES4.25", "");/******************************************************************************************** BENEFICE OU PERTE******************************************************************************************/// 310 v232+v280+v290-v264-v294-v300-v306long v310 = v232 + v280 + v290 - v264 - v294 - v300 - v306;this.m.put("PCHARGES3.26", GestionDevise.currencyToString(v310, false));// 267this.m.put("PCHARGES4.26", "");/******************************************************************************************** RESULTAT FISCAL******************************************************************************************/// 312// 374 SommeSoldeDebit( 4457, 4457* )// TODO répartir les comptes débiteurslong v374 = this.sommeCompte.soldeCompteCrediteur(4457, 4457, true, this.dateDeb, this.dateFin);this.m.put("T1.41", GestionDevise.currencyToString(v374, false));// 378 SommeSoldeCredit( 44566 )long v378 = this.sommeCompte.soldeCompteDebiteur(44566, 44566, true, this.dateDeb, this.dateFin);this.m.put("T1.42", GestionDevise.currencyToString(v378, false));SwingUtilities.invokeLater(new Runnable() {public void run() {Map2033B.this.bar.setValue(95);}});/******************************************************************************************** VALEURS NON CONNUES******************************************************************************************/this.m.put("PCHARGES3.27", "");this.m.put("PCHARGES4.27", "");this.m.put("REINT3.28", "");this.m.put("REINT3.29", "");this.m.put("REINT3.30", "");this.m.put("REINT3.31", "");this.m.put("REINT1.32", "");this.m.put("REINT2.32", "");this.m.put("REINT3.32", "");this.m.put("DEDUC1.33", "");this.m.put("DEDUC2.33", "");this.m.put("DEDUC3.33", "");this.m.put("DEDUC1.34", "");this.m.put("DEDUC2.34", "");this.m.put("DEDUC3.34", "");this.m.put("DEDUC4.34", "");this.m.put("DEDUC2.35", "");this.m.put("DEDUC3.35", "");this.m.put("DEDUC4.35", "");this.m.put("RES3.36", "");this.m.put("RES4.36", "");this.m.put("DEF3.37", "");this.m.put("DEF4.38", "");this.m.put("RES3.39", "");this.m.put("RES4.39", "");this.m.put("COT1.40", "");this.m.put("COT2.40", "");this.m.put("COT3.40", "");this.m.put("T2.41", "");this.m.put("T3.41", "");this.m.put("T4.41", "");this.m.put("T2.42", "");final SQLField field = ComptaPropsConfiguration.getInstanceCompta().getRootSociete().getTable("COMPTE_PCE").getField("NUMERO");Where where = new Where(field, "LIKE", "6%");where = where.or(new Where(field, "LIKE", "7%"));List<String> unused = this.sommeCompte.getNonUsedCompte(where, this.dateDeb, this.dateFin);if (unused != null && !unused.isEmpty()) {JOptionPane.showMessageDialog(null, "Certains comptes n'ont pas été intégré : " + unused);}// final SQLField field =// ComptaPropsConfiguration.getInstanceCompta().getRootSociete().getTable("COMPTE_PCE").getField("NUMERO");// Where where = new Where(field, "LIKE", "6%");// where = where.or(new Where(field, "LIKE", "7%"));// this.sommeCompte.getNonUsedCompte(where, this.dateDeb, this.dateFin);p.generateFrom(this.m);SwingUtilities.invokeLater(new Runnable() {public void run() {Gestion.openPDF(p.getGeneratedFile());Map2033B.this.bar.setValue(100);}});}public Map2033B(JProgressBar bar, Date dateDeb, Date dateFin) {this(bar, dateDeb, dateFin, null);}public Map2033B(JProgressBar bar, Date dateDeb, Date dateFin, SQLRow rowPosteAnalytique) {this.bar = bar;if (dateDeb == null && dateFin == null) {SQLRow rowSociete = ((ComptaPropsConfiguration) Configuration.getInstance()).getRowSociete();SQLRow rowExercice = Configuration.getInstance().getBase().getTable("EXERCICE_COMMON").getRow(rowSociete.getInt("ID_EXERCICE_COMMON"));dateFin = (Date) rowExercice.getObject("DATE_FIN");dateDeb = (Date) rowExercice.getObject("DATE_DEB");}this.dateDeb = dateDeb;this.dateFin = dateFin;this.sommeCompte = new SommeCompte(rowPosteAnalytique);}public Map2033B(JProgressBar b) {this(b, null, null);}public void generateMap() {this.start();}}