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

package org.openconcerto.modules.operation;

import java.awt.GridLayout;

import java.beans.PropertyChangeEvent;

import java.beans.PropertyChangeListener;

import java.util.Arrays;

import java.util.Calendar;

import java.util.Date;

import java.util.HashMap;

import java.util.HashSet;

import java.util.List;

import java.util.Map;

import java.util.Set;

import java.util.concurrent.ExecutionException;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JSpinner;

import javax.swing.SpinnerNumberModel;

import javax.swing.SwingWorker;

import javax.swing.event.ChangeEvent;

import javax.swing.event.ChangeListener;

import org.openconcerto.erp.config.ComptaPropsConfiguration;

import org.openconcerto.erp.core.reports.history.ui.ListeHistoriquePanel;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.model.SQLBase;

import org.openconcerto.sql.model.SQLField;

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.request.ComboSQLRequest;

import org.openconcerto.sql.users.rights.JListSQLTablePanel;

import org.openconcerto.sql.view.IListPanel;

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

import org.openconcerto.utils.cc.ITransformer;

public class OperationHistoryPanel extends JPanel {

    OperationHistoryPanel() {

        this.setLayout(new GridLayout(1, 1));

        final SQLBase b = ((ComptaPropsConfiguration) Configuration.getInstance()).getSQLBaseSociete();

        final Map<String, List<String>> mapList = new HashMap<>();

        mapList.put("Interventions", Arrays.asList("OPERATION"));

        final Map<SQLTable, SQLField> map = new HashMap<>();

        final ComboSQLRequest comboRequest = JListSQLTablePanel.createComboRequest(Configuration.getInstance().getDirectory().getElement(b.getTable("SITE")), true);

        JPanel panel = new JPanel();

        panel.add(new JLabel("Année"));

        int year = Calendar.getInstance().get(Calendar.YEAR);

        final JSpinner spiner = new JSpinner(new SpinnerNumberModel(year, 1000, year + 20, 1));

        panel.add(spiner);

        final ListeHistoriquePanel listHistoriquePanel = new ListeHistoriquePanel("Interventions", comboRequest, mapList, panel, map, null);

        final IListe list = listHistoriquePanel.getListe(0);

        updateWhere(comboRequest, list, year, listHistoriquePanel);

        spiner.addChangeListener(new ChangeListener() {

            @Override

            public void stateChanged(ChangeEvent e) {

                final int selectedYear = ((Number) spiner.getValue()).intValue();

                updateWhere(comboRequest, list, selectedYear, listHistoriquePanel);

            }

        });

        list.addSelectionDataListener(new PropertyChangeListener() {

            @Override

            public void propertyChange(PropertyChangeEvent evt) {

                final List<SQLRowValues> selectedRows = list.getSelectedRows();

                final IListPanel listePanel = listHistoriquePanel.getListePanel(0);

                if (selectedRows != null && !selectedRows.isEmpty()) {

                    final Set<Long> idsCalendarItemGroup = new HashSet<>();

                    for (SQLRowValues sqlRowValues : selectedRows) {

                        idsCalendarItemGroup.add(Long.valueOf(sqlRowValues.getForeign("ID_CALENDAR_ITEM_GROUP").getID()));

                    }

                    final SQLTable table = ((ComptaPropsConfiguration) Configuration.getInstance()).getRootSociete().getTable("CALENDAR_ITEM");

                    final SQLField flag = table.getField("FLAGS");

                    final SQLField group = table.getField("ID_CALENDAR_ITEM_GROUP");

                    final SQLSelect select = new SQLSelect();

                    select.addSelect(flag);

                    select.addSelect(group);

                    Where where = new Where(group, idsCalendarItemGroup).and(new Where(flag, "LIKE", "%locked%"));

                    select.setWhere(where);

                    final SwingWorker<Boolean, String> w = new SwingWorker<Boolean, String>() {

                        @Override

                        protected Boolean doInBackground() throws Exception {

                            @SuppressWarnings("rawtypes")

                            final List l = b.getDataSource().execute(select.asString());

                            return l.isEmpty();

                        }

                        @Override

                        protected void done() {

                            Boolean b;

                            try {

                                b = get();

                                listePanel.setModifyVisible(b);

                                listePanel.setDeleteVisible(b);

                            } catch (InterruptedException e) {

                                e.printStackTrace();

                            } catch (ExecutionException e) {

                                e.printStackTrace();

                            }

                        }

                    };

                    w.execute();

                }

            }

        });

        this.add(listHistoriquePanel);

    }

    public void updateWhere(final ComboSQLRequest comboRequest, final IListe list, final int selectedYear, final ListeHistoriquePanel panel) {

        try {

            list.getRequest().setSelectTransf(new ITransformer<SQLSelect, SQLSelect>() {

                @Override

                public SQLSelect transformChecked(SQLSelect input) {

                    if (panel.getSelectedRow() == null) {

                        return input;

                    }

                    try {

                        Calendar cal = Calendar.getInstance();

                        cal.clear();

                        cal.set(Calendar.YEAR, selectedYear);

                        Date dStart = cal.getTime();

                        cal.set(Calendar.YEAR, selectedYear + 1);

                        Date dEnd = cal.getTime();

                        final SQLTable groupT = comboRequest.getPrimaryTable().getTable("CALENDAR_ITEM_GROUP");

                        final SQLTable calItemT = comboRequest.getPrimaryTable().getTable("CALENDAR_ITEM");

                        final List<?> dateGroupIDs;

                        {

                            final SQLSelect copy = new SQLSelect(input);

                            copy.clearSelect();

                            copy.addSelect(copy.getAlias(groupT.getKey()));

                            copy.setWhere(copy.getAlias(comboRequest.getPrimaryTable().getTable("OPERATION").getField("ID_SITE")), "=", panel.getSelectedRow().getID());

                            final List<?> allGroupIDs = calItemT.getDBSystemRoot().getDataSource().executeCol(copy.asString());

                            final SQLSelect selIDGroup = new SQLSelect();

                            selIDGroup.addSelect(calItemT.getField("ID_CALENDAR_ITEM_GROUP"));

                            final Where where = new Where(calItemT.getField("START"), dStart, true, dEnd, true);

                            selIDGroup.setWhere(where).andWhere(new Where(calItemT.getField("ID_CALENDAR_ITEM_GROUP"), allGroupIDs));

                            dateGroupIDs = calItemT.getDBSystemRoot().getDataSource().executeCol(selIDGroup.asString());

                        }

                        input.setWhere(new Where(input.getAlias(groupT.getKey()), dateGroupIDs));

                    } catch (Throwable e) {

                        e.printStackTrace();

                    }

                    return input;

                }

            });

        } catch (Throwable ex) {

            ex.printStackTrace();

        }

    }

}