WebSVN - OpenConcerto - Diff - Rev 180 and 182 - /trunk/OpenConcerto/src/org/openconcerto/erp/core/finance/accounting/model/PointageModel.java


/*
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
 * 
 * Copyright 2011-2019 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.model;
 
import org.openconcerto.erp.config.ComptaPropsConfiguration;
import org.openconcerto.erp.core.common.ui.DeviseField;
import org.openconcerto.erp.core.finance.accounting.ui.PointagePanel;
import org.openconcerto.sql.Configuration;
import org.openconcerto.sql.model.SQLBase;
import org.openconcerto.sql.model.SQLRow;
import org.openconcerto.sql.model.SQLRowValues;
import org.openconcerto.sql.model.SQLSelect;
import org.openconcerto.sql.model.SQLTable;
import org.openconcerto.sql.model.Where;
import org.openconcerto.sql.view.list.IListe;
import org.openconcerto.sql.view.list.ITableModel;
 
import java.util.Date;
import java.util.List;
 
import javax.swing.SwingWorker;
import javax.swing.table.AbstractTableModel;
 
import org.apache.commons.dbutils.handlers.ArrayListHandler;
 
public class PointageModel extends AbstractTableModel {
 
    private String[] titresCol;
    private String[] titresRow;
    private PointagePanel panel;
    private long debitListe, creditListe, debitTotal, creditTotal, debitPointe, creditPointe, debitNonPointe, creditNonPointe, creditSelection, debitSelection;
 
    private static final SQLBase base = ((ComptaPropsConfiguration) Configuration.getInstance()).getSQLBaseSociete();
    private static final SQLTable tableEcr = base.getTable("ECRITURE");
    int idCpt;
 
    public PointageModel(int idCpt, PointagePanel panel) {
        this.creditNonPointe = 0;
        this.creditTotal = 0;
        this.creditPointe = 0;
        this.creditSelection = 0;
 
        this.panel = panel;
 
        this.debitNonPointe = 0;
        this.debitPointe = 0;
        this.debitTotal = 0;
        this.debitSelection = 0;
 
        this.idCpt = idCpt;
        this.titresCol = new String[6];
        this.titresCol[0] = "Totaux période";
        this.titresCol[1] = "Pointé";
        this.titresCol[2] = "Relevé courant";
        this.titresCol[3] = "Total";
 
        this.titresCol[4] = "Sélection";
        this.titresCol[5] = "Liste";
 
        this.titresRow = new String[3];
        this.titresRow[0] = "Débit";
        this.titresRow[1] = "Crédit";
        this.titresRow[2] = "Solde";
 
        updateTotauxCompte();
    }
 
    public void setIdCompte(int id) {
        this.idCpt = id;
        updateTotauxCompte();
        updateSelection(null);
    }
 
    public void updateSelection(int[] rowIndex) {
        this.creditSelection = 0;
        this.debitSelection = 0;
 
        if (rowIndex != null) {
            for (int i = 0; i < rowIndex.length; i++) {
 
                SQLRow row = tableEcr.getRow(rowIndex[i]);
 
                if (row != null) {
 
                    // if (row.getString("POINTEE").trim().length() == 0) {
                    this.debitSelection += ((Long) row.getObject("DEBIT")).longValue();
                    this.creditSelection += ((Long) row.getObject("CREDIT")).longValue();
                    // }
                    /*
                     * else {
                     * 
                     * this.debitSelection -= row.getFloat("DEBIT"); this.creditSelection -=
                     * row.getFloat("CREDIT"); }
                     */
                }
            }
        }
        this.fireTableDataChanged();
    }
 
    private SwingWorker<String, Object> workerUpdater;
 
    public void updateTotauxCompte() {
        updateTotauxCompte(null, null, null);
    }
 
    public void updateTotauxCompte(final DeviseField depart, final DeviseField arrive, final DeviseField ecart) {
 
        final Date deb = panel.getDateDeb();
        final Date fin = panel.getDateFin();
 
        if (workerUpdater != null) {
            workerUpdater.cancel(true);
        }
 
        workerUpdater = new SwingWorker<String, Object>() {
 
            @Override
            protected String doInBackground() throws Exception {
 
                SQLSelect sel = new SQLSelect();
                sel.addSelect(tableEcr.getField("CREDIT"), "SUM");
                sel.addSelect(tableEcr.getField("DEBIT"), "SUM");
 
                Where w = new Where(tableEcr.getField("ID_COMPTE_PCE"), "=", PointageModel.this.idCpt);
 
                if (deb != null && fin != null) {
                    w = w.and(new Where(tableEcr.getField("DATE"), deb, fin));
                } else if (deb != null) {
                    w = w.and(new Where(tableEcr.getField("DATE"), ">=", deb));
                } else if (fin != null) {
                    w = w.and(new Where(tableEcr.getField("DATE"), "<=", fin));
                }
                sel.setWhere(w.and(new Where(tableEcr.getField("POINTEE"), "!=", "")));
 
                String reqPointee = sel.toString();
 
                Object obPointee = base.getDataSource().execute(reqPointee, new ArrayListHandler());
 
                List myListPointee = (List) obPointee;
 
                PointageModel.this.creditPointe = 0;
                PointageModel.this.debitPointe = 0;
                if (!myListPointee.isEmpty()) {
 
                    for (int i = 0; i < myListPointee.size(); i++) {
                        Object[] objTmp = (Object[]) myListPointee.get(i);
 
                        if (objTmp[0] != null) {
                            PointageModel.this.creditPointe += ((Number) objTmp[0]).longValue();
                        }
                        if (objTmp[1] != null) {
                            PointageModel.this.debitPointe += ((Number) objTmp[1]).longValue();
                        }
                    }
                }
 
                sel.setWhere(w.and(new Where(tableEcr.getField("POINTEE"), "=", panel.getCodePointage())));
                String reqReleveCourant = sel.toString();
 
                Object obReleveCourant = base.getDataSource().execute(reqReleveCourant, new ArrayListHandler());
 
                List myListReleveCourant = (List) obReleveCourant;
 
                PointageModel.this.creditNonPointe = 0;
                PointageModel.this.debitNonPointe = 0;
                if (!myListReleveCourant.isEmpty()) {
 
                    for (int i = 0; i < myListReleveCourant.size(); i++) {
                        Object[] objTmp = (Object[]) myListReleveCourant.get(i);
 
                        if (objTmp[0] != null) {
                            PointageModel.this.creditNonPointe += ((Number) objTmp[0]).longValue();
                        }
 
                        if (objTmp[1] != null) {
                            PointageModel.this.debitNonPointe += ((Number) objTmp[1]).longValue();
                        }
                    }
                }
 
                sel.setWhere(w);
                String reqReleveTotal = sel.toString();
 
                Object obReleveTotal = base.getDataSource().execute(reqReleveTotal, new ArrayListHandler());
 
                List myListReleveTotal = (List) obReleveTotal;
 
                PointageModel.this.creditTotal = 0;
                PointageModel.this.debitTotal = 0;
                if (!myListReleveTotal.isEmpty()) {
 
                    for (int i = 0; i < myListReleveTotal.size(); i++) {
                        Object[] objTmp = (Object[]) myListReleveTotal.get(i);
 
                        if (objTmp[0] != null) {
                            PointageModel.this.creditTotal += ((Number) objTmp[0]).longValue();
                        }
 
                        if (objTmp[1] != null) {
                            PointageModel.this.debitTotal += ((Number) objTmp[1]).longValue();
                        }
                    }
                }
 
                PointageModel.this.creditListe = 0;
                PointageModel.this.debitListe = 0;
                IListe listeEcr = panel.getEcriturePanel().getListe();
                for (int i = 0; i < listeEcr.getRowCount(); i++) {
 
                    final SQLRowValues rowAt = ITableModel.getLine(listeEcr.getModel(), i).getRow();
                    if (rowAt.getObject("CREDIT") != null) {
                        PointageModel.this.creditListe += rowAt.getLong("CREDIT");
                    }
 
                    if (rowAt.getObject("DEBIT") != null) {
                        PointageModel.this.debitListe += rowAt.getLong("DEBIT");
                    }
                }
 
                return null;
            }
 
            @Override
            protected void done() {
 
                if (isCancelled()) {
                    return;
                }
                if (arrive != null && depart != null && ecart != null) {
                    final Long valueArrive = arrive.getValue();
                    final Long valueDepart = depart.getValue();
                    if (valueArrive != null && valueDepart != null) {
                        ecart.setValue(valueArrive - valueDepart - PointageModel.this.debitNonPointe + PointageModel.this.creditNonPointe);
                    } else {
                        ecart.setValue(null);
                    }
                }
                PointageModel.this.fireTableDataChanged();
            }
        };
        workerUpdater.execute();
 
    }
 
    @Override
    public String getColumnName(int column) {
 
        return this.titresCol[column];
    }
 
    public int getColumnCount() {
 
        return this.titresCol.length;
    }
 
    public int getRowCount() {
 
        return this.titresRow.length;
    }
 
    @Override
    public Class<?> getColumnClass(int columnIndex) {
        if (columnIndex == 0) {
            return String.class;
        } else {
            return Long.class;
        }
    }
 
    public Object getValueAt(int rowIndex, int columnIndex) {
 
        if (columnIndex == 0) {
            return this.titresRow[rowIndex];
        }
 
        if (columnIndex == 1) {
            if (rowIndex == 0) {
                return Long.valueOf(this.debitPointe);
            }
            if (rowIndex == 1) {
                return Long.valueOf(this.creditPointe);
            }
            if (rowIndex == 2) {
                return Long.valueOf(this.debitPointe - this.creditPointe);
            }
        }
 
        if (columnIndex == 2) {
            if (rowIndex == 0) {
                return Long.valueOf(this.debitNonPointe);
            }
            if (rowIndex == 1) {
                return Long.valueOf(this.creditNonPointe);
            }
            if (rowIndex == 2) {
                return Long.valueOf(this.debitNonPointe - this.creditNonPointe);
            }
        }
 
        if (columnIndex == 3) {
            if (rowIndex == 0) {
                return Long.valueOf(this.debitTotal);
            }
            if (rowIndex == 1) {
                return Long.valueOf(this.creditTotal);
            }
            if (rowIndex == 2) {
                return Long.valueOf(this.debitTotal - this.creditTotal);
            }
        }
 
        if (columnIndex == 4) {
            if (rowIndex == 0) {
                return Long.valueOf(this.debitSelection);
            }
            if (rowIndex == 1) {
                return Long.valueOf(this.creditSelection);
            }
            if (rowIndex == 2) {
                return Long.valueOf(this.debitSelection - this.creditSelection);
            }
        }
 
        if (columnIndex == 5) {
            if (rowIndex == 0) {
                return Long.valueOf(this.debitListe);
            }
            if (rowIndex == 1) {
                return Long.valueOf(this.creditListe);
            }
            if (rowIndex == 2) {
                return Long.valueOf(this.debitListe - this.creditListe);
            }
        }
 
        return null;
    }
}

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/model/PointageModel.java - Rev 180 → 182

Rev 180		Rev 182
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.`
10	`*`	10	`*`
11	`* When distributing the software, include this License Header Notice in each file.`	11	`* When distributing the software, include this License Header Notice in each file.`
12	`*/`	12	`*/`
13		13
14	`package org.openconcerto.erp.core.finance.accounting.model;`	14	`package org.openconcerto.erp.core.finance.accounting.model;`
15		15
16	`import org.openconcerto.erp.config.ComptaPropsConfiguration;`	16	`import org.openconcerto.erp.config.ComptaPropsConfiguration;`
17	`import org.openconcerto.erp.core.common.ui.DeviseField;`	17	`import org.openconcerto.erp.core.common.ui.DeviseField;`
18	`import org.openconcerto.erp.core.finance.accounting.ui.PointagePanel;`	18	`import org.openconcerto.erp.core.finance.accounting.ui.PointagePanel;`
19	`import org.openconcerto.sql.Configuration;`	19	`import org.openconcerto.sql.Configuration;`
20	`import org.openconcerto.sql.model.SQLBase;`	20	`import org.openconcerto.sql.model.SQLBase;`
21	`import org.openconcerto.sql.model.SQLRow;`	21	`import org.openconcerto.sql.model.SQLRow;`
22	`import org.openconcerto.sql.model.SQLRowValues;`	22	`import org.openconcerto.sql.model.SQLRowValues;`
23	`import org.openconcerto.sql.model.SQLSelect;`	23	`import org.openconcerto.sql.model.SQLSelect;`
24	`import org.openconcerto.sql.model.SQLTable;`	24	`import org.openconcerto.sql.model.SQLTable;`
25	`import org.openconcerto.sql.model.Where;`	25	`import org.openconcerto.sql.model.Where;`
26	`import org.openconcerto.sql.view.list.IListe;`	26	`import org.openconcerto.sql.view.list.IListe;`
27	`import org.openconcerto.sql.view.list.ITableModel;`	27	`import org.openconcerto.sql.view.list.ITableModel;`
28		28
29	`import java.util.Date;`	29	`import java.util.Date;`
30	`import java.util.List;`	30	`import java.util.List;`
31		31
32	`import javax.swing.SwingWorker;`	32	`import javax.swing.SwingWorker;`
33	`import javax.swing.table.AbstractTableModel;`	33	`import javax.swing.table.AbstractTableModel;`
34		34
35	`import org.apache.commons.dbutils.handlers.ArrayListHandler;`	35	`import org.apache.commons.dbutils.handlers.ArrayListHandler;`
36		36
37	`public class PointageModel extends AbstractTableModel {`	37	`public class PointageModel extends AbstractTableModel {`
38		38
39	`private String[] titresCol;`	39	`private String[] titresCol;`
40	`private String[] titresRow;`	40	`private String[] titresRow;`