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

package org.openconcerto.modules.project.panel;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.Insets;

import java.math.BigDecimal;

import java.math.RoundingMode;

import java.text.DecimalFormat;

import java.util.Collection;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.SwingConstants;

import javax.swing.SwingUtilities;

import org.openconcerto.erp.modules.ModuleFactory;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.sql.model.SQLRowValues;

import org.openconcerto.sql.view.list.IListe;

import org.openconcerto.sql.view.list.ITableModel;

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.utils.GestionDevise;

public class HistoriqueAffaireBilanPanel extends JPanel {

    private DecimalFormat decimalFormat = new DecimalFormat("0.00");

    private double pourcentCommande = 0;

    private final JLabel labelPourcentCommande = new JLabel("", SwingConstants.RIGHT);

    private long montantCommandeClient = 0;

    private final JLabel labelCommandeClient = new JLabel("", SwingConstants.RIGHT);

    private long montantBudget = 0;

    private final JLabel labelBudget = new JLabel("", SwingConstants.RIGHT);

    private long montantCommande = 0;

    private final JLabel labelCommande = new JLabel("", SwingConstants.RIGHT);

    private long montantCommandeP = 0;

    private final JLabel labelCommandeP = new JLabel("", SwingConstants.RIGHT);

    private long montantFacturer = 0;

    private final JLabel labelFacturer = new JLabel("", SwingConstants.RIGHT);

    private long montantRegler = 0;

    private final JLabel labelMontantRegler = new JLabel("", SwingConstants.RIGHT);

    private long montantRemise = 0;

    private long montantRestantFacturer = 0;

    private final JLabel labelRestantFacturer = new JLabel("", SwingConstants.RIGHT);

    private final JLabel labelAvoir = new JLabel("");

    private String motifAvoir = "";

    private long montantAchat = 0;

    private final JLabel labelAchat = new JLabel("", SwingConstants.RIGHT);

    private final JLabel labelPercentBilan = new JLabel("", SwingConstants.RIGHT);

    private final JLabel labelPercentMargeHT = new JLabel("", SwingConstants.RIGHT);

    private final JLabel labelPercentMBBilan = new JLabel("", SwingConstants.RIGHT);

    private final JLabel labelPercentMBAchat = new JLabel("", SwingConstants.RIGHT);

    private static ModuleFactory factory;

    public HistoriqueAffaireBilanPanel() {

        super();

        setLayout(new GridBagLayout());

        GridBagConstraints c = new DefaultGridBagConstraints();

        c.insets = new Insets(2, 2, 2, 75);

        c.gridx = GridBagConstraints.RELATIVE;

        c.gridwidth = GridBagConstraints.REMAINDER;

        add(this.labelAvoir, c);

        c.gridy++;

        c.gridwidth = 1;

        add(this.labelCommandeClient, c);

        // add(this.labelCommandeP, c);

        add(this.labelPercentMargeHT, c);

        add(this.labelFacturer, c);

        c.gridy++;

        // add(this.labelPourcentCommande, c);

        add(this.labelBudget, c);

        add(this.labelCommande, c);

        add(this.labelPercentMBBilan, c);

        // add(this.labelMontantRegler, c);

        c.gridy++;

        // add(this.labelPercentBilan, c);

        // add(this.labelPourcentCommande, c);

        // add(this.labelAchat, c);

        // add(this.labelPercentMBAchat, c);

        // add(this.labelRestantFacturer, c);

        // add(this.labelDemande);

        //

        // add(this.labelDemandeM);

        //

        // add(this.labelDemandeT);

        //

        // add(this.labelCommande);

        //

        // add(this.labelCommandeMonteur);

        //

        // add(this.labelCommandeTransporteur);

    }

    public synchronized void updateBilanPreBilan(final IListe listeCmdF) {

        // if (rowAffaire == null || rowAffaire.isUndefined()) {

        // this.montantCommande = 0;

        // this.montantCommandeP = 0;

        // return;

        // }

        long montant = 0;

        if (listeCmdF != null) {

            // Commande F

            for (int i = 0; i < listeCmdF.getRowCount(); i++) {

                final SQLRowValues rowAt = ITableModel.getLine(listeCmdF.getModel(), i).getRow();

                montant += rowAt.getLong("T_HT");

            }

        }

        this.montantCommande = montant;

        updateLabels();

    }

    public synchronized void updateFacturer(final IListe liste, final IListe listeAvoir) {

        // List<SQLRowAccessor> rows =

        // liste.getSource().getLine(viewIndex)SelectedRows()Model().get;

        if (liste == null || listeAvoir == null) {

            return;

        }

        String motif = "";

        long montant = 0;

        BigDecimal montantRegler = BigDecimal.ZERO;

        long montantRemise = 0;

        for (int i = 0; i < liste.getRowCount(); i++) {

            final SQLRowValues rowAt = ITableModel.getLine(liste.getModel(), i).getRow();

            long ht = rowAt.getLong("T_HT");

            long ttc = rowAt.getLong("T_TTC");

            montant += ht;

            // BigDecimal regler = new

            // BigDecimal(calc.getReglement(rowAt.getForeign("ID_MOUVEMENT").getInt("ID_PIECE"),

            // null));

            // if (ht != ttc) {

            // if (rowAt.getDate("DATE").getTime().compareTo(date2014) <= 0) {

            // regler = regler.divide(new BigDecimal(1.196D), MathContext.DECIMAL128);

            // } else {

            // regler = regler.divide(new BigDecimal(1.2D), MathContext.DECIMAL128);

            // }

            // // regler = regler.divide(new BigDecimal(1.2D), MathContext.DECIMAL128);

            // }

            // montantRegler = montantRegler.add(regler);

        }

        // EncoursCalculator calc = new EncoursCalculator();

        for (int i = 0; i < listeAvoir.getRowCount(); i++) {

            final SQLRowValues rowAt = ITableModel.getLine(listeAvoir.getModel(), i).getRow();

            if (rowAt.getBoolean("A_DEDUIRE")) {

                montant -= rowAt.getLong("MONTANT_HT");

                // montantRegler -= rowAt.getLong("MONTANT_TTC");

            }

            // else {

            // long long1 = calc.getMontantAvoir(rowAt);

            // montant -= long1;

            // montantRemise += long1;

            // motif += rowAt.getString("MOTIF") + "(-" + GestionDevise.currencyToString(long1,

            // true) + " €)";

            // }

        }

        this.motifAvoir = motif;

        this.montantFacturer = montant;

        this.montantRemise = montantRemise;

        this.montantRegler = montantRegler.setScale(0, RoundingMode.HALF_UP).longValue();

        updateLabels();

    }

    public synchronized void updateAchat(final IListe listeAchat, final IListe listeAchatAvoir) {

        if (listeAchat == null) {

            return;

        }

        final ITableModel model = listeAchat.getModel();

        final ITableModel modelAvoir = listeAchatAvoir.getModel();

        final Runnable r = new Runnable() {

            @Override

            public void run() {

                // TODO Raccord de méthode auto-généré

                long m = 0;

                for (int i = 0; i < model.getRowCount(); i++) {

                    final SQLRowValues rowAt = model.getRow(i).getRow();

                    m += rowAt.getLong("MONTANT_HT");

                }

                for (int i = 0; i < modelAvoir.getRowCount(); i++) {

                    final SQLRowValues rowAt = modelAvoir.getRow(i).getRow();

                    m -= rowAt.getLong("MONTANT_HT");

                }

                montantAchat = m;

                SwingUtilities.invokeLater(new Runnable() {

                    @Override

                    public void run() {

                        updateLabels();

                    }

                });

            }

        };

        model.invokeLater(r);

        modelAvoir.invokeLater(r);

    }

    public synchronized void updateCommandeClient(SQLRowAccessor rowAff) {

        if (rowAff != null) {

            Collection<? extends SQLRowAccessor> rowCmd = rowAff.getReferentRows(rowAff.getTable().getTable("COMMANDE_CLIENT"));

            long cmd = 0;

            long b = 0;

            for (SQLRowAccessor r : rowCmd) {

                cmd += r.getLong("T_HT");

                Collection<? extends SQLRowAccessor> ref = r.getReferentRows(rowAff.getTable().getTable("CHIFFRAGE_COMMANDE_CLIENT"));

                for (SQLRowAccessor sqlRowAccessor : ref) {

                    b += sqlRowAccessor.getBigDecimal("T_PA_HT").setScale(0, RoundingMode.HALF_UP).longValue();

                }

            }

            this.montantBudget = b;

            this.montantCommandeClient = cmd;

            updateLabels();

        }

    }

    public synchronized void updateDevis(SQLRowAccessor rowAff) {

        if (rowAff != null) {

            Collection<? extends SQLRowAccessor> rowCmd = rowAff.getReferentRows(rowAff.getTable().getTable("DEVIS"));

            long cmd = 0;

            for (SQLRowAccessor r : rowCmd) {

                cmd += r.getLong("T_HA");

            }

            // this.montantBudget = cmd;

            updateLabels();

        }

    }

    private void updateLabels() {

        long mbP = this.montantCommandeClient - this.montantCommandeP;

        final long mbB = this.montantCommandeClient - this.montantCommande;

        long mbA = this.montantFacturer - this.montantAchat;

        final double percentMBPreBilan = Math.round((this.montantCommandeClient == 0 ? 0 : (double) mbP / (double) this.montantCommandeClient) * 10000.0D) / 100.0D;

        final double percentMBBilan = Math.round((this.montantCommandeClient == 0 ? 0 : (double) mbB / (double) this.montantCommandeClient) * 10000.0D) / 100.0D;

        final double percentMBAchat = Math.round((this.montantFacturer == 0 || this.montantAchat == 0 ? 0 : (double) mbA / (double) this.montantFacturer) * 10000.0D) / 100.0D;

        SwingUtilities.invokeLater(new Runnable() {

            public void run() {

                HistoriqueAffaireBilanPanel.this.labelAvoir.setText(motifAvoir);

                HistoriqueAffaireBilanPanel.this.labelPourcentCommande.setText(decimalFormat.format(pourcentCommande) + "% des commandes livrées");

                // HistoriqueAffaireBilanPanel.this.labelPercentMBPreBilan.setText(decimalFormat.format(percentMBPreBilan)

                // + "% MB Prébilan");

                HistoriqueAffaireBilanPanel.this.labelPercentMBBilan.setText(decimalFormat.format(percentMBBilan) + "% MB sur commande");

                HistoriqueAffaireBilanPanel.this.labelPercentMBAchat.setText(decimalFormat.format(percentMBAchat) + "% MB Achats");

                HistoriqueAffaireBilanPanel.this.labelCommandeClient.setText("Montant du marché : " + GestionDevise.currencyToString(montantCommandeClient) + "€");

                HistoriqueAffaireBilanPanel.this.labelFacturer.setText("Montant facturé : " + GestionDevise.currencyToString(montantFacturer) + "€");

                HistoriqueAffaireBilanPanel.this.labelAchat.setText("Total Achats : " + GestionDevise.currencyToString(montantAchat) + "€");

                HistoriqueAffaireBilanPanel.this.labelCommandeP.setText("Total PréBilan : " + GestionDevise.currencyToString(montantCommandeP) + "€");

                HistoriqueAffaireBilanPanel.this.labelCommande.setText("Total Commandes F. : " + GestionDevise.currencyToString(montantCommande) + "€");

                HistoriqueAffaireBilanPanel.this.labelBudget.setText("Budget chiffré à : " + GestionDevise.currencyToString(montantBudget) + "€");

                HistoriqueAffaireBilanPanel.this.labelMontantRegler.setText("Règlements effectués : " + GestionDevise.currencyToString(montantRegler) + "€");

                HistoriqueAffaireBilanPanel.this.labelRestantFacturer.setText("Reste à facturer : " + GestionDevise.currencyToString(montantCommandeClient - montantFacturer - montantRemise) + "€");

                HistoriqueAffaireBilanPanel.this.labelPercentMargeHT.setText("Marge HT : " + GestionDevise.currencyToString(mbB) + "€");

            }

        });

    }

}