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

package org.openconcerto.modules.subscription;

import java.awt.event.ActionEvent;
import java.sql.SQLException;
import java.util.Arrays;
import java.util.List;

import javax.swing.AbstractAction;

import org.openconcerto.erp.core.sales.product.element.ReferenceArticleSQLElement;
import org.openconcerto.sql.model.DBRoot;
import org.openconcerto.sql.model.SQLRow;
import org.openconcerto.sql.model.SQLRowListRSH;
import org.openconcerto.sql.model.SQLSelect;
import org.openconcerto.sql.model.SQLTable;
import org.openconcerto.sql.model.Where;

public class CheckArticleAction extends AbstractAction {

    private DBRoot root;

    public CheckArticleAction(DBRoot root) {
        this.root = root;
    }

    @Override
    public void actionPerformed(ActionEvent e) {

        SQLTable tableDevisElt = this.root.getTable("DEVIS_ELEMENT");
        SQLTable tableCmd = this.root.getTable("COMMANDE_CLIENT_ELEMENT");
        SQLTable tableFacture = this.root.getTable("SAISIE_VENTE_FACTURE_ELEMENT");
        SQLTable tableAvoir = this.root.getTable("AVOIR_CLIENT_ELEMENT");

        List<SQLTable> tables = Arrays.asList(tableDevisElt, tableCmd, tableFacture, tableAvoir);
        for (SQLTable sqlTable : tables) {
            SQLSelect sel = new SQLSelect();

            sel.addSelect(sqlTable.getField("CODE"));
            sel.addSelect(sqlTable.getField("NOM"));

            Where w = new Where(sqlTable.getField("ID_ARTICLE"), "=", 1);
            sel.setWhere(w);
            List<SQLRow> res = SQLRowListRSH.execute(sel);
            for (SQLRow sqlRow : res) {
                int id = ReferenceArticleSQLElement.getIdForCN(sqlRow.asRowValues(), false);
                if (id > 1) {
                    try {
                        sqlRow.createEmptyUpdateRow().put("ID_ARTICLE", id).update();
                    } catch (SQLException e1) {
                        // TODO Auto-generated catch block
                        e1.printStackTrace();
                    }
                }
            }
        }

    }

}