WebSVN - OpenConcerto - Diff - Rev 151 and 156 - /trunk/OpenConcerto/src/org/openconcerto/erp/core/sales/invoice/element/EcheanceClientSQLElement.java


/*
 * 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.sales.invoice.element;
 
import org.openconcerto.erp.config.ComptaPropsConfiguration;
import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;
import org.openconcerto.erp.core.common.element.NumerotationAutoSQLElement;
import org.openconcerto.erp.core.common.ui.DeviseField;
import org.openconcerto.erp.core.customerrelationship.customer.element.RelanceSQLElement;
import org.openconcerto.erp.core.finance.accounting.element.MouvementSQLElement;
import org.openconcerto.erp.core.sales.invoice.report.MailRelanceCreator;
import org.openconcerto.erp.core.sales.invoice.report.VenteFactureXmlSheet;
import org.openconcerto.erp.rights.ComptaUserRight;
import org.openconcerto.sql.Configuration;
import org.openconcerto.sql.element.BaseSQLComponent;
import org.openconcerto.sql.element.SQLComponent;
import org.openconcerto.sql.element.SQLElement;
import org.openconcerto.sql.model.FieldPath;
import org.openconcerto.sql.model.SQLBase;
import org.openconcerto.sql.model.SQLField;
import org.openconcerto.sql.model.SQLRow;
import org.openconcerto.sql.model.SQLRowAccessor;
import org.openconcerto.sql.model.SQLRowValues;
import org.openconcerto.sql.model.SQLTable;
import org.openconcerto.sql.model.graph.Path;
import org.openconcerto.sql.model.graph.PathBuilder;
import org.openconcerto.sql.request.ListSQLRequest;
import org.openconcerto.sql.sqlobject.ElementComboBox;
import org.openconcerto.sql.users.rights.UserRightsManager;
import org.openconcerto.sql.view.EditFrame;
import org.openconcerto.sql.view.EditPanel.EditMode;
import org.openconcerto.sql.view.list.BaseSQLTableModelColumn;
import org.openconcerto.sql.view.list.IListe;
import org.openconcerto.sql.view.list.IListeAction.IListeEvent;
import org.openconcerto.sql.view.list.RowAction;
import org.openconcerto.sql.view.list.RowAction.PredicateRowAction;
import org.openconcerto.sql.view.list.SQLTableModelSource;
import org.openconcerto.ui.DefaultGridBagConstraints;
import org.openconcerto.ui.EmailComposer;
import org.openconcerto.ui.JDate;
import org.openconcerto.utils.CollectionUtils;
import org.openconcerto.utils.ExceptionHandler;
import org.openconcerto.utils.GestionDevise;
import org.openconcerto.utils.ListMap;
 
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.event.ActionEvent;
import java.io.File;
import java.io.IOException;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Locale;
import java.util.Set;
 
import javax.swing.AbstractAction;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.SwingUtilities;
 
public class EcheanceClientSQLElement extends ComptaSQLConfElement {
 
    SimpleDateFormat dateFormat = new SimpleDateFormat("dd MMMM yyyy", Locale.ENGLISH);
 
    public EcheanceClientSQLElement() {
        super("ECHEANCE_CLIENT", "une échéance client", "échéances clients");
        {
            PredicateRowAction action = new PredicateRowAction(new AbstractAction("Détails client") {
 
                @Override
                public void actionPerformed(ActionEvent arg0) {
 
                    SQLElement eltClient = Configuration.getInstance().getDirectory().getElement(((ComptaPropsConfiguration) Configuration.getInstance()).getRootSociete().getTable("CLIENT"));
 
                    EditFrame edit = new EditFrame(eltClient, EditMode.MODIFICATION);
 
                    edit.selectionId(IListe.get(arg0).getSelectedRow().asRow().getInt("ID_CLIENT"));
                    edit.setVisible(true);
                }
            }, false);
            action.setPredicate(IListeEvent.getSingleSelectionPredicate());
            getRowActions().add(action);
        }
        {
            PredicateRowAction action = new PredicateRowAction(new AbstractAction("Voir la source") {
 
                @Override
                public void actionPerformed(ActionEvent arg0) {
 
                    SQLRow row = IListe.get(arg0).fetchSelectedRow();
                    MouvementSQLElement.showSource(row.getInt("ID_MOUVEMENT"));
                }
            }, false);
            action.setPredicate(IListeEvent.getSingleSelectionPredicate());
            getRowActions().add(action);
        }
 
        {
            PredicateRowAction action = new PredicateRowAction(new AbstractAction("Envoyer un mail") {
 
                @Override
                public void actionPerformed(ActionEvent arg0) {
 
                    SQLRow row = IListe.get(arg0).fetchSelectedRow();
                    sendMail(row);
                }
            }, false);
            action.setPredicate(IListeEvent.getSingleSelectionPredicate());
            getRowActions().add(action);
        }
 
        if (UserRightsManager.getCurrentUserRights().haveRight(ComptaUserRight.MENU)) {
            RowAction actionCancel = new RowAction(new AbstractAction("Annuler la régularisation en comptabilité") {
 
                public void actionPerformed(ActionEvent e) {
 
                    int answer = JOptionPane.showConfirmDialog(null, "Etes vous sûr de vouloir annuler la régularisation ?");
                    if (answer == JOptionPane.YES_OPTION) {
                        SQLRow row = IListe.get(e).getSelectedRow().asRow();
                        SQLRowValues rowVals = row.createEmptyUpdateRow();
                        rowVals.put("REG_COMPTA", Boolean.FALSE);
                        try {
                            rowVals.commit();
                        } catch (SQLException e1) {
                            // TODO Auto-generated catch block
                            e1.printStackTrace();
                        }
                    }
                }
            }, false) {
                @Override
                public boolean enabledFor(List<SQLRowValues> selection) {
                    if (selection != null && selection.size() == 1) {
                        SQLRowAccessor row = selection.get(0);
                        return row.getBoolean("REG_COMPTA");
                    } else {
                        return true;
                    }
                }
            };
            getRowActions().add(actionCancel);
 
            RowAction actionRegul = new RowAction(new AbstractAction("Régularisation en comptabilité") {
 
                public void actionPerformed(ActionEvent e) {
 
                    SQLRow row = IListe.get(e).fetchSelectedRow();
                    String price = GestionDevise.currencyToString(row.getLong("MONTANT"));
                    SQLRow rowClient = row.getForeignRow("ID_CLIENT");
                    String nomClient = rowClient.getString("NOM");
                    String piece = "";
                    SQLRow rowMvt = row.getForeignRow("ID_MOUVEMENT");
                    if (rowMvt != null) {
                        SQLRow rowPiece = rowMvt.getForeignRow("ID_PIECE");
                        piece = rowPiece.getString("NOM");
                    }
                    int answer = JOptionPane.showConfirmDialog(null,
                            "Etes vous sûr de vouloir régulariser l'échéance de " + nomClient + " d'un montant de " + price + "€ avec une saisie au kilometre?\nNom de la piéce : " + piece + ".");
                    if (answer == JOptionPane.YES_OPTION) {
 
                        SQLRowValues rowVals = row.createEmptyUpdateRow();
                        rowVals.put("REG_COMPTA", Boolean.TRUE);
                        try {
                            rowVals.commit();
                        } catch (SQLException e1) {
                            // TODO Auto-generated catch block
                            e1.printStackTrace();
                        }
                    }
                }
            }, false) {
                @Override
                public boolean enabledFor(List<SQLRowValues> selection) {
                    if (selection != null && selection.size() == 1) {
                        SQLRowAccessor row = selection.get(0);
                        return !row.getBoolean("REG_COMPTA");
                    } else {
                        return true;
                    }
                }
            };
            getRowActions().add(actionRegul);
        }
 
    }
 
 
    private void sendMail(final SQLRow row) {
 
        SQLBase base = ((ComptaPropsConfiguration) Configuration.getInstance()).getSQLBaseSociete();
 
        if (row != null) {
 
            int idMvtSource = MouvementSQLElement.getSourceId(row.getInt("ID_MOUVEMENT"));
            SQLRow rowMvtSource = base.getTable("MOUVEMENT").getRow(idMvtSource);
 
            if (!rowMvtSource.getString("SOURCE").equalsIgnoreCase("SAISIE_VENTE_FACTURE")) {
                // this.relancer.setEnabled(false);
                return;
            }
            int idFact = rowMvtSource.getInt("IDSOURCE");
            SQLRow rowFacture = base.getTable("SAISIE_VENTE_FACTURE").getRow(idFact);
 
            final VenteFactureXmlSheet sheet = new VenteFactureXmlSheet(rowFacture);
 
            Set<SQLField> setContact = null;
            SQLTable tableContact = Configuration.getInstance().getRoot().findTable("CONTACT");
            setContact = row.getTable().getForeignKeys(tableContact);
 
            Set<SQLField> setClient = null;
            SQLTable tableClient = ((ComptaPropsConfiguration) Configuration.getInstance()).getSQLBaseSociete().getTable("CLIENT");
            setClient = row.getTable().getForeignKeys(tableClient);
 
            // Récupération du mail du client
            String mail = "";
            for (SQLField field : setContact) {
                if (mail == null || mail.trim().length() == 0) {
                    mail = row.getForeignRow(field.getName()).getString("EMAIL");
                }
            }
 
            for (SQLField field : setClient) {
                SQLRow rowCli = row.getForeignRow(field.getName());
                if (mail == null || mail.trim().length() == 0) {
                    mail = rowCli.getString("MAIL");
                }
            }
            final String adresseMail = mail;
 
            MailRelanceCreator creator = new MailRelanceCreator();
            final String references = creator.getObject(row);
            final String text = creator.getValue(row);
 
            final Thread t = new Thread() {
                @Override
                public void run() {
 
                    final File f;
                    try {
                        f = sheet.getOrCreatePDFDocumentFile(true);
 
                        EmailComposer.getInstance().compose(adresseMail, references, text, f.getAbsoluteFile());
 
                        // Création d'une relance
                        String numero = NumerotationAutoSQLElement.getNextNumero(RelanceSQLElement.class);
                        SQLRowValues rowValsR = new SQLRowValues(row.getTable().getTable("RELANCE"));
                        rowValsR.put("DATE", new Date());
                        rowValsR.put("NUMERO", numero);
                        rowValsR.put("ID_CLIENT", row.getForeignID("ID_CLIENT"));
                        rowValsR.put("ID_SAISIE_VENTE_FACTURE", row.getForeignID("ID_SAISIE_VENTE_FACTURE"));
                        rowValsR.put("MONTANT", row.getObject("MONTANT"));
                        rowValsR.put("INFOS", "Email");
                        rowValsR.put("ID_ECHEANCE_CLIENT", row.getID());
                        try {
                            rowValsR.insert();
 
                            SQLTable tableNum = getTable().getBase().getTable("NUMEROTATION_AUTO");
                            SQLRowValues rowVals = new SQLRowValues(tableNum);
                            int val = tableNum.getRow(2).getInt("RELANCE_START");
                            val++;
                            rowVals.put("RELANCE_START", Integer.valueOf(val));
 
                            rowVals.update(2);
 
                            // Incrémentation du nombre de relance
                            int nbRelance = row.getInt("NOMBRE_RELANCE");
                            nbRelance++;
 
                            SQLRowValues rowValsEch = new SQLRowValues(row.getTable());
                            rowValsEch.put("NOMBRE_RELANCE", nbRelance);
                            rowValsEch.put("DATE_LAST_RELANCE", new Date());
 
                            rowValsEch.update(row.getID());
 
                        } catch (SQLException e) {
 
                            e.printStackTrace();
                        }
                    } catch (IOException exn) {
                        exn.printStackTrace();
                    } catch (InterruptedException exn) {
                        exn.printStackTrace();
                    } catch (Exception e1) {
                        // TODO Auto-generated catch block
                        e1.printStackTrace();
                    }
 
                }
            };
 
            t.start();
        }
    }
 
    @Override
    public ListMap<String, String> getShowAs() {
        ListMap<String, String> map = new ListMap<String, String>();
        return map;
    }
 
    protected List<String> getListFields() {
        final List<String> l = new ArrayList<String>();
 
 
            l.add("ID_SAISIE_VENTE_FACTURE");
            l.add("DATE");
            l.add("ID_CLIENT");
            l.add("MONTANT");
            l.add("ID_MOUVEMENT");
                l.add("NOMBRE_RELANCE");
            l.add("INFOS");
            l.add("DATE_LAST_RELANCE");
        return l;
    }
 
    protected List<String> getComboFields() {
        final List<String> l = new ArrayList<String>();
        l.add("DATE");
        l.add("ID_CLIENT");
        l.add("MONTANT");
        return l;
    }
 
    @Override
    protected void _initListRequest(ListSQLRequest req) {
        super._initListRequest(req);
        req.addToGraphToFetch("REG_COMPTA", "REGLE");
    }
 
    /*
     * (non-Javadoc)
     * 
     * @see org.openconcerto.devis.SQLElement#getComponent()
     */
    public SQLComponent createComponent() {
        return new BaseSQLComponent(this) {
 
            private DeviseField montant;
            private JTextField nbRelance;
            private JDate date;
            private JTextField idMouvement;
            private ElementComboBox comboClient;
 
            public void addViews() {
                this.setLayout(new GridBagLayout());
                final GridBagConstraints c = new DefaultGridBagConstraints();
 
                this.montant = new DeviseField();
                this.nbRelance = new JTextField();
                this.date = new JDate();
                this.idMouvement = new JTextField();
                this.comboClient = new ElementComboBox();
 
                // Mouvement
                JLabel labelMouvement = new JLabel("Mouvement");
                this.add(labelMouvement, c);
 
                c.weightx = 1;
                c.gridx++;
                this.add(this.idMouvement, c);
 
                // Date
                JLabel labelDate = new JLabel("Date");
                c.gridx++;
                this.add(labelDate, c);
 
                c.gridx++;
                c.weightx = 1;
                this.add(this.date, c);
 
                // Client
                JLabel labelClient = new JLabel("Client");
                c.gridy++;
                c.gridx = 0;
 
                this.add(labelClient, c);
 
                c.gridx++;
                c.weightx = 1;
                c.gridwidth = GridBagConstraints.REMAINDER;
                this.add(this.comboClient, c);
 
                // libellé
                JLabel labelRelance = new JLabel("Nombre de relance");
                c.gridy++;
                c.gridx = 0;
                c.gridwidth = 1;
                this.add(labelRelance, c);
 
                c.gridx++;
                c.weightx = 1;
                this.add(this.nbRelance, c);
 
                // montant
                c.gridwidth = 1;
                JLabel labelMontant = new JLabel("Montant");
                c.gridx++;
                this.add(labelMontant, c);
 
                c.gridx++;
                c.weightx = 1;
                this.add(this.montant, c);
 
                this.addSQLObject(this.montant, "MONTANT");
                this.addRequiredSQLObject(this.date, "DATE");
                this.addSQLObject(this.nbRelance, "NOMBRE_RELANCE");
                this.addRequiredSQLObject(this.comboClient, "ID_CLIENT");
                this.addSQLObject(this.idMouvement, "ID_MOUVEMENT");
            }
        };
    }
 
    @Override
    protected String createCode() {
        return createCodeOfPackage() + ".commitment";
    }
 
}

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

svn://code.openconcerto.org/openconcerto

(root)/trunk/OpenConcerto/src/org/openconcerto/erp/core/sales/invoice/element/EcheanceClientSQLElement.java - Rev 151 → 156

Rev 151		Rev 156
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 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.sales.invoice.element;`	14	`package org.openconcerto.erp.core.sales.invoice.element;`
15		15
16	`import org.openconcerto.erp.config.ComptaPropsConfiguration;`	16	`import org.openconcerto.erp.config.ComptaPropsConfiguration;`
17	`import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;`	17	`import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;`
18	`import org.openconcerto.erp.core.common.element.NumerotationAutoSQLElement;`	18	`import org.openconcerto.erp.core.common.element.NumerotationAutoSQLElement;`
19	`import org.openconcerto.erp.core.common.ui.DeviseField;`	19	`import org.openconcerto.erp.core.common.ui.DeviseField;`
20	`import org.openconcerto.erp.core.customerrelationship.customer.element.RelanceSQLElement;`	20	`import org.openconcerto.erp.core.customerrelationship.customer.element.RelanceSQLElement;`
21	`import org.openconcerto.erp.core.finance.accounting.element.MouvementSQLElement;`	21	`import org.openconcerto.erp.core.finance.accounting.element.MouvementSQLElement;`
22	`import org.openconcerto.erp.core.sales.invoice.report.MailRelanceCreator;`	22	`import org.openconcerto.erp.core.sales.invoice.report.MailRelanceCreator;`
23	`import org.openconcerto.erp.core.sales.invoice.report.VenteFactureXmlSheet;`	23	`import org.openconcerto.erp.core.sales.invoice.report.VenteFactureXmlSheet;`
24	`import org.openconcerto.erp.rights.ComptaUserRight;`	24	`import org.openconcerto.erp.rights.ComptaUserRight;`
25	`import org.openconcerto.sql.Configuration;`	25	`import org.openconcerto.sql.Configuration;`
26	`import org.openconcerto.sql.element.BaseSQLComponent;`	26	`import org.openconcerto.sql.element.BaseSQLComponent;`
27	`import org.openconcerto.sql.element.SQLComponent;`	27	`import org.openconcerto.sql.element.SQLComponent;`
28	`import org.openconcerto.sql.element.SQLElement;`	28	`import org.openconcerto.sql.element.SQLElement;`
29	`import org.openconcerto.sql.model.FieldPath;`	29	`import org.openconcerto.sql.model.FieldPath;`
30	`import org.openconcerto.sql.model.SQLBase;`	30	`import org.openconcerto.sql.model.SQLBase;`
31	`import org.openconcerto.sql.model.SQLField;`	31	`import org.openconcerto.sql.model.SQLField;`
32	`import org.openconcerto.sql.model.SQLRow;`	32	`import org.openconcerto.sql.model.SQLRow;`
33	`import org.openconcerto.sql.model.SQLRowAccessor;`	33	`import org.openconcerto.sql.model.SQLRowAccessor;`
34	`import org.openconcerto.sql.model.SQLRowValues;`	34	`import org.openconcerto.sql.model.SQLRowValues;`
35	`import org.openconcerto.sql.model.SQLTable;`	35	`import org.openconcerto.sql.model.SQLTable;`
36	`import org.openconcerto.sql.model.graph.Path;`	36	`import org.openconcerto.sql.model.graph.Path;`
37	`import org.openconcerto.sql.model.graph.PathBuilder;`	37	`import org.openconcerto.sql.model.graph.PathBuilder;`
38	`import org.openconcerto.sql.request.ListSQLRequest;`	38	`import org.openconcerto.sql.request.ListSQLRequest;`
39	`import org.openconcerto.sql.sqlobject.ElementComboBox;`	39	`import org.openconcerto.sql.sqlobject.ElementComboBox;`
40	`import org.openconcerto.sql.users.rights.UserRightsManager;`	40	`import org.openconcerto.sql.users.rights.UserRightsManager;`