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

/*

 * 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.order.action;

import org.openconcerto.erp.action.CreateIListFrameAbstractAction;

import org.openconcerto.erp.config.ComptaPropsConfiguration;

import org.openconcerto.erp.core.common.ui.IListFilterDatePanel;

import org.openconcerto.erp.core.common.ui.IListTotalPanel;

import org.openconcerto.erp.core.common.ui.IListTotalPanel.Type;

import org.openconcerto.erp.core.common.ui.ListeViewPanel;

import org.openconcerto.erp.core.sales.order.element.CommandeClientElementSQLElement;

import org.openconcerto.sql.element.SQLElement;

import org.openconcerto.sql.model.FieldPath;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.sql.model.Where;

import org.openconcerto.sql.model.graph.Path;

import org.openconcerto.sql.view.IListFrame;

import org.openconcerto.sql.view.IListPanel;

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

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

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

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

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.utils.Tuple2;

import java.awt.GridBagConstraints;

import java.math.BigDecimal;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.List;

import java.util.Set;

public class ListeDesCommandesClientItemsAction extends CreateIListFrameAbstractAction<CommandeClientElementSQLElement> {

    public ListeDesCommandesClientItemsAction(final ComptaPropsConfiguration conf) {

        super(conf, CommandeClientElementSQLElement.class);

    }

    @Override

    protected SQLTableModelSource createTableSource() {

        final SQLTableModelSource res = super.createTableSource();

        res.getReq().setWhere(new Where(getElem().getTable().getField("ID_COMMANDE_CLIENT"), ">", 1));

        return res;

    }

    @Override

    protected IListPanel instantiateListPanel(final SQLTableModelSource tableSource, String panelVariant) {

        return new ListeViewPanel(tableSource.getElem(), new IListe(tableSource));

    }

    @Override

    protected void initFrame(IListFrame frame) {

        super.initFrame(frame);

        final SQLElement element = getElem();

        final IListPanel listeAddPanel = frame.getPanel();

        final SQLTableModelSource tableSource = listeAddPanel.getListe().getSource();

        final Set<FieldPath> paths = FieldPath.create(new Path(getElem().getTable()), Arrays.asList("QTE", "QTE_UNITAIRE", "QTE_LIVREE"));

        BaseSQLTableModelColumn colStockR = new BaseSQLTableModelColumn("Qté restante à livrer", BigDecimal.class) {

            @Override

            protected Object show_(SQLRowAccessor r) {

                BigDecimal qteAlivrer = r.getBigDecimal("QTE_UNITAIRE").multiply(new BigDecimal(r.getInt("QTE")));

                BigDecimal qteLivree = BigDecimal.ZERO;

                if (r.getObject("QTE_LIVREE") != null) {

                    qteLivree = r.getBigDecimal("QTE_LIVREE");

                }

                return qteAlivrer.subtract(qteLivree);

            }

            @Override

            public Set<FieldPath> getPaths() {

                return paths;

            }

        };

        tableSource.getColumns().add(colStockR);

        List<Tuple2<? extends SQLTableModelColumn, Type>> listField = new ArrayList<Tuple2<? extends SQLTableModelColumn, Type>>();

        listField.add(Tuple2.create(tableSource.getColumn(element.getTable().getField("QTE")), IListTotalPanel.Type.SOMME_QTE));

        listField.add(Tuple2.create(colStockR, IListTotalPanel.Type.SOMME_QTE));

        listField.add(Tuple2.create(tableSource.getColumn(element.getTable().getField("T_PA_HT")), IListTotalPanel.Type.SOMME));

        listField.add(Tuple2.create(tableSource.getColumn(element.getTable().getField("T_PV_HT")), IListTotalPanel.Type.SOMME));

        listField.add(Tuple2.create(tableSource.getColumn(element.getTable().getField("T_PV_TTC")), IListTotalPanel.Type.SOMME));

        IListTotalPanel total = new IListTotalPanel(listeAddPanel.getListe(), listField, null, "Total");

        GridBagConstraints c = new DefaultGridBagConstraints();

        c.gridy = 2;

        c.weightx = 0;

        c.weighty = 0;

        c.anchor = GridBagConstraints.EAST;

        c.fill = GridBagConstraints.NONE;

        listeAddPanel.add(total, c);

        frame.setTextTitle(String.valueOf(getValue(NAME)));

        frame.getPanel().getListe().setModificationAllowed(false);

        frame.getPanel().setAddVisible(false);

        frame.getPanel().setSearchFullMode(true);

        // Date panel

        IListFilterDatePanel datePanel = new IListFilterDatePanel(frame.getPanel().getListe(), element.getTable().getTable("COMMANDE_CLIENT").getField("DATE"), IListFilterDatePanel.getDefaultMap());

        c.gridy++;

        c.anchor = GridBagConstraints.CENTER;

        frame.getPanel().add(datePanel, c);

    }

}