Example usage for org.apache.commons.dbutils.handlers ArrayListHandler ArrayListHandler

Introduction

In this page you can find the example usage for org.apache.commons.dbutils.handlers ArrayListHandler ArrayListHandler.

Prototype

public ArrayListHandler() 

Source Link

Document

Creates a new instance of ArrayListHandler using a BasicRowProcessor for conversions.

Usage

From source file:org.openconcerto.erp.graph.GraphFamilleArticlePanel.java

protected BigDecimal updateDataset(List<String> labels, List<Number> values) {

    final SQLTable tableVFElement = Configuration.getInstance().getDirectory()
            .getElement("SAISIE_VENTE_FACTURE_ELEMENT").getTable();
    final SQLTable tableVF = tableVFElement.getTable("SAISIE_VENTE_FACTURE");
    final SQLTable tableArticle = tableVFElement.getTable("ARTICLE");

    final SQLSelect sel = new SQLSelect();
    final String field = "ID_FAMILLE_ARTICLE";

    sel.addSelect(tableArticle.getField(field));

    sel.addSelect(tableVFElement.getField("T_PA_HT"), "SUM");
    sel.addSelect(tableVFElement.getField("T_PV_HT"), "SUM");
    sel.addSelect(tableVFElement.getField("QTE"), "SUM");

    Where w = new Where(tableVF.getKey(), "=", tableVFElement.getField("ID_SAISIE_VENTE_FACTURE"));
    w = w.and(new Where(tableVF.getField("DATE"), this.d1, this.d2));
    w = w.and(new Where(tableArticle.getKey(), "=", tableVFElement.getField("ID_ARTICLE")));
    sel.setWhere(w);/*ww  w . j  a va2 s  . c  om*/

    final List<Object[]> rowsArticle = (List<Object[]>) Configuration.getInstance().getBase().getDataSource()
            .execute(sel.asString() + " GROUP BY \"ARTICLE\".\"" + field + "\"", new ArrayListHandler());

    Collections.sort(rowsArticle, new Comparator<Object[]>() {
        @Override
        public int compare(Object[] o1, Object[] o2) {

            BigDecimal pa1 = (BigDecimal) o1[1];
            BigDecimal pv1 = (BigDecimal) o1[2];
            BigDecimal qte1 = new BigDecimal(o1[3].toString());

            BigDecimal pa2 = (BigDecimal) o2[1];
            BigDecimal pv2 = (BigDecimal) o2[2];
            BigDecimal qte2 = new BigDecimal(o2[3].toString());

            BigDecimal marge1 = pv1.subtract(pa1).multiply(qte1, DecimalUtils.HIGH_PRECISION);
            BigDecimal marge2 = pv2.subtract(pa2).multiply(qte2, DecimalUtils.HIGH_PRECISION);
            return pv1.compareTo(pv2);
        }
    });

    SQLTable tableFamille = tableVFElement.getTable("FAMILLE_ARTICLE");

    BigDecimal total = BigDecimal.ZERO;
    for (int i = 0; i < rowsArticle.size(); i++) {
        Object[] o = rowsArticle.get(i);

        BigDecimal pv2 = (BigDecimal) o[2];
        total = total.add(pv2);
    }
    if (total.signum() > 0) {

        for (int i = 0; i < 12 && i < rowsArticle.size(); i++) {
            Object[] o = rowsArticle.get(i);
            BigDecimal pa2 = (BigDecimal) o[1];
            BigDecimal pv2 = (BigDecimal) o[2];
            BigDecimal qte2 = new BigDecimal(o[3].toString());
            BigDecimal marge2 = pv2.subtract(pa2).multiply(qte2, DecimalUtils.HIGH_PRECISION);

            String s = "Indfini";
            if (o[0] != null) {
                int id = ((Number) o[0]).intValue();
                s = tableFamille.getRow(id).getString("NOM");
            }
            values.add(pv2);
            labels.add(s + "(" + decFormat.format(pv2.setScale(2, RoundingMode.HALF_UP).doubleValue())
                    + " soit " + pv2.divide(total, DecimalUtils.HIGH_PRECISION).movePointRight(2).setScale(2,
                            RoundingMode.HALF_UP)
                    + "%)");
        }
    }
    return total;
}

---

From source file:org.openconcerto.erp.model.EditionFichePayeModel.java

/**
 * Charge les donnes du model/*from  w  w w.  j  a v a2  s .  c  om*/
 * 
 */
private void fill() {

    // on recupere la lsite des salaries
    SQLElement eltSal = Configuration.getInstance().getDirectory().getElement("SALARIE");
    SQLSelect sel = new SQLSelect(eltSal.getTable().getBase());
    sel.addSelect(eltSal.getTable().getField("ID"));

    this.vData.removeAllElements();
    List l = (List) eltSal.getTable().getBase().getDataSource().execute(sel.asString(), new ArrayListHandler());
    if (l != null) {
        for (int i = 0; i < l.size(); i++) {
            int idSal = ((Number) ((Object[]) l.get(i))[0]).intValue();

            Map<String, Object> m = new HashMap<String, Object>();
            m.put("A_CREER", Boolean.TRUE);
            m.put("NOM", new Integer(i));
            m.put("BRUT", new Integer(i));
            m.put("NET", new Integer(i));
            m.put("VISU", Boolean.FALSE);
            m.put("IMPRESSION", Boolean.TRUE);
            m.put("ID_SALARIE", new Integer(idSal));

            this.vData.add(m);
        }
    }
}

---

From source file:org.openconcerto.erp.model.FamilleArticleTree.java

/**
 * Chargement de toutes les familles/*from  ww  w. j a  v  a2s.c  om*/
 */
private void loadTree() {
    SQLSelect sel = new SQLSelect(familleElt.getTable().getBase());

    sel.addSelect(familleElt.getTable().getField("ID"));
    sel.addSelect(familleElt.getTable().getField("ID_FAMILLE_ARTICLE_PERE"));

    List l = (List) familleElt.getTable().getBase().getDataSource().execute(sel.asString(),
            new ArrayListHandler());

    if (l != null) {
        for (int i = 0; i < l.size(); i++) {
            Object[] tmp = (Object[]) l.get(i);
            addFamille(((Number) tmp[0]).intValue(), ((Number) tmp[1]).intValue());
        }
    }
}

---

From source file:org.openconcerto.erp.model.FichePayeModel.java

public void loadAllElements() {

    System.err.println("Start At " + new Date());
    if (this.idFiche <= 1) {
        System.err.println("Aucune fiche associe");
        return;//from   w  w  w  .  j a v  a2  s  .c  om
    }

    // RAZ
    resetValueFiche();

    /*
     * this.threadUpdate = new Thread("Update Fiche Paye") { public void run() {
     */
    this.vectRubrique = new Vector<SQLRowValues>();

    SQLRow rowFiche = tableFichePaye.getRow(this.idFiche);

    this.javaEdit.setSalarieID(rowFiche.getInt("ID_SALARIE"));

    // lments de la fiche de paye
    SQLSelect selAllIDFicheElt = new SQLSelect();

    selAllIDFicheElt.addSelect(tableFichePayeElt.getField("ID"));
    selAllIDFicheElt.addSelect(tableFichePayeElt.getField("POSITION"));
    selAllIDFicheElt.setWhere(new Where(tableFichePayeElt.getField("ID_FICHE_PAYE"), "=", this.idFiche));

    selAllIDFicheElt.setDistinct(true);

    selAllIDFicheElt.addRawOrder("\"FICHE_PAYE_ELEMENT\".\"POSITION\"");
    String reqAllIDFichelElt = selAllIDFicheElt.asString();

    System.err.println("Request " + reqAllIDFichelElt);

    Object[] objIDFicheElt = ((List) base.getDataSource().execute(reqAllIDFichelElt, new ArrayListHandler()))
            .toArray();

    System.err.println(objIDFicheElt.length + " elements to load");

    for (int i = 0; i < objIDFicheElt.length; i++) {
        SQLRow row = tableFichePayeElt.getRow(Integer.parseInt(((Object[]) objIDFicheElt[i])[0].toString()));

        String source = row.getString("SOURCE");
        int idSource = row.getInt("IDSOURCE");

        if (source.trim().length() != 0) {

            // System.err.println("Source != null");

            if (this.mapTableSource.get(source) != null) {
                SQLRow rowSource = this.mapTableSource.get(source).getRow(idSource);

                if (rowSource.getTable().getName().equalsIgnoreCase("RUBRIQUE_BRUT")) {
                    loadElementBrut(rowSource, row);
                }

                if (rowSource.getTable().getName().equalsIgnoreCase("RUBRIQUE_COTISATION")) {
                    loadElementCotisation(rowSource, row);
                }

                if (rowSource.getTable().getName().equalsIgnoreCase("RUBRIQUE_NET")) {
                    loadElementNet(rowSource, row);
                }

                if (rowSource.getTable().getName().equalsIgnoreCase("RUBRIQUE_COMM")) {
                    loadElementComm(rowSource, row);
                }

            } else {
                System.err.println("Table " + source + " non rfrence");
            }
        }
    }
    System.err.println(this.vectRubrique.size() + " elements ADDed ");

    fireTableDataChanged();
    /*
     * } }; this.threadUpdate.start();
     */

    System.err.println("End At " + new Date());
}

---

From source file:org.openconcerto.erp.model.FichePayeModel.java

public void loadFromProfil(final int idProfil) {

    System.err.println("Load from profil");

    resetValueFiche();//  w  w  w.j  a  v a2 s . com

    /*
     * this.threadUpdate = new Thread("Update Fiche Paye") { public void run() {
     */
    // On supprime les anciennes lignes de la fiche
    while (this.vectRubrique.size() > 0) {

        this.vectRowValsToDelete.add(this.vectRubrique.remove(0));
    }

    // this.vectRubrique = new Vector();

    // Listes des rubriques du profil
    SQLSelect selAllIDProfilElt = new SQLSelect();

    selAllIDProfilElt.addSelect(tableProfilElt.getField("ID"));
    selAllIDProfilElt.addSelect(tableProfilElt.getField("POSITION"));
    selAllIDProfilElt.setWhere(new Where(tableProfilElt.getField("ID_PROFIL_PAYE"), "=", idProfil));
    selAllIDProfilElt.addRawOrder("\"PROFIL_PAYE_ELEMENT\".\"POSITION\"");

    String reqAllIDProfilElt = selAllIDProfilElt.asString();

    Object[] objIDProfilElt = ((List) Configuration.getInstance().getBase().getDataSource()
            .execute(reqAllIDProfilElt, new ArrayListHandler())).toArray();

    for (int i = 0; i < objIDProfilElt.length; i++) {
        SQLRow rowTmp = tableProfilElt.getRow(Integer.parseInt(((Object[]) objIDProfilElt[i])[0].toString()));

        String source = rowTmp.getString("SOURCE");
        int idSource = rowTmp.getInt("IDSOURCE");

        if (this.mapTableSource.get(source) != null) {
            SQLRow row = this.mapTableSource.get(source).getRow(idSource);

            if (row.getTable().getName().equalsIgnoreCase("RUBRIQUE_BRUT")) {
                loadElementBrut(row, null);
            }
            if (row.getTable().getName().equalsIgnoreCase("RUBRIQUE_COTISATION")) {
                loadElementCotisation(row, null);
            }
            if (row.getTable().getName().equalsIgnoreCase("RUBRIQUE_NET")) {
                loadElementNet(row, null);
            }
            if (row.getTable().getName().equalsIgnoreCase("RUBRIQUE_COMM")) {
                loadElementComm(row, null);
            }

        } else {
            System.err.println(
                    "FichePayeModel.java --> Table non rfrence dans la Map. Table name : " + source);
        }
    }

    // this.vectRubrique = new Vector();

    // updateFields(this.idFiche);
    fireTableDataChanged();

    /*
     * } }; this.threadUpdate.start();
     */
}

---

From source file:org.openconcerto.erp.model.RubriquePayeTree.java

private static void loadNodeComm() {
    // Rubrique Comm
    nodeComm = new DefaultMutableTreeNode("Commentaires");

    // on liste l'ensemble des rubriques de comm
    SQLSelect selAllCodeCommName = new SQLSelect(Configuration.getInstance().getBase());
    selAllCodeCommName.addSelect(tableComm.getField("ID"));
    selAllCodeCommName.addRawOrder("\"RUBRIQUE_COMM\".\"CODE\"");
    String reqAllCodeCommName = selAllCodeCommName.asString();
    System.err.println("REquest load node brut :: " + reqAllCodeCommName);
    Object[] objCodeCommID = ((List) Configuration.getInstance().getBase().getDataSource()
            .execute(reqAllCodeCommName, new ArrayListHandler())).toArray();

    for (int i = 0; i < objCodeCommID.length; i++) {

        SQLRow rowTmp = tableComm.getRow(Integer.parseInt(((Object[]) objCodeCommID[i])[0].toString()));
        VariableRowTreeNode nodeVar = new VariableRowTreeNode(rowTmp);
        addNode(nodeVar, nodeComm);/*w w w . j  a v a 2  s .com*/
    }
}

---

From source file:org.openconcerto.erp.model.RubriquePayeTree.java

private static void loadNodeNet() {

    nodeNet = new DefaultMutableTreeNode("Net");

    // on liste l'ensemble des rubriques de net
    SQLSelect selAllCodeNetName = new SQLSelect(Configuration.getInstance().getBase());
    selAllCodeNetName.addSelect(tableNet.getField("ID"));
    selAllCodeNetName.addRawOrder("\"RUBRIQUE_NET\".\"CODE\"");
    String reqAllCodeNetName = selAllCodeNetName.asString();
    System.err.println("REquest load node brut :: " + reqAllCodeNetName);
    Object[] objCodeNetID = ((List) Configuration.getInstance().getBase().getDataSource()
            .execute(reqAllCodeNetName, new ArrayListHandler())).toArray();

    for (int i = 0; i < objCodeNetID.length; i++) {
        SQLRow rowTmp = tableNet.getRow(Integer.parseInt(((Object[]) objCodeNetID[i])[0].toString()));
        VariableRowTreeNode nodeVar = new VariableRowTreeNode(rowTmp);
        addNode(nodeVar, nodeNet);//from   w  ww  . j  a v  a2  s .  c o  m
    }
}

---

From source file:org.openconcerto.erp.model.RubriquePayeTree.java

private static void loadNodeCot() {
    nodeCotisation = new DefaultMutableTreeNode("Cotisation");

    // on liste l'ensemble des rubriques de cotisation
    SQLSelect selAllCodeCotisName = new SQLSelect(Configuration.getInstance().getBase());
    selAllCodeCotisName.addSelect(tableCotis.getField("ID"));
    selAllCodeCotisName.addRawOrder("\"RUBRIQUE_COTISATION\".\"CODE\"");
    String reqAllCodeCotisName = selAllCodeCotisName.asString();
    System.err.println("REquest load node brut :: " + reqAllCodeCotisName);
    Object[] objCodeCotisID = ((List) Configuration.getInstance().getBase().getDataSource()
            .execute(reqAllCodeCotisName, new ArrayListHandler())).toArray();

    for (int i = 0; i < objCodeCotisID.length; i++) {
        SQLRow rowTmp = tableCotis.getRow(Integer.parseInt(((Object[]) objCodeCotisID[i])[0].toString()));

        if (mapNodeCotisation.get(rowTmp.getObject("ID_CAISSE_COTISATION")) == null) {
            SQLRow rowCaisseCotis = tableCaisseCotis.getRow(rowTmp.getInt("ID_CAISSE_COTISATION"));
            DefaultMutableTreeNode nodeCot = new DefaultMutableTreeNode(rowCaisseCotis.getString("NOM"));
            mapNodeCotisation.put(rowTmp.getObject("ID_CAISSE_COTISATION"), nodeCot);
            nodeCotisation.add(nodeCot);
        }//from www .  jav a  2  s.  c  o m

        DefaultMutableTreeNode node = (DefaultMutableTreeNode) mapNodeCotisation
                .get(rowTmp.getObject("ID_CAISSE_COTISATION"));
        VariableRowTreeNode nodeVar = new VariableRowTreeNode(rowTmp);
        addNode(nodeVar, node);
    }

}

---

From source file:org.openconcerto.erp.model.RubriquePayeTree.java

private static void loadNodeBrut() {

    nodeBrut = new DefaultMutableTreeNode("Brut");

    // on liste l'ensemble des rubriques de brut
    SQLSelect selAllCodeBrutName = new SQLSelect(Configuration.getInstance().getBase());
    selAllCodeBrutName.addSelect(tableBrut.getField("ID"));
    selAllCodeBrutName.addRawOrder("\"RUBRIQUE_BRUT\".\"CODE\"");
    String reqAllCodeBrutName = selAllCodeBrutName.asString();
    System.err.println("REquest load node brut :: " + reqAllCodeBrutName);
    Object[] objCodeBrutID = ((List) Configuration.getInstance().getBase().getDataSource()
            .execute(reqAllCodeBrutName, new ArrayListHandler())).toArray();

    for (int i = 0; i < objCodeBrutID.length; i++) {
        SQLRow rowTmp = tableBrut.getRow(Integer.parseInt(((Object[]) objCodeBrutID[i])[0].toString()));
        VariableRowTreeNode nodeVar = new VariableRowTreeNode(rowTmp);
        addNode(nodeVar, nodeBrut);/*from w w  w .j ava 2s  . com*/
    }

}

---

From source file:org.openconcerto.erp.panel.compta.ExportEBP_ComptaPro.java

@Override
protected int fetchData(Date from, Date to, SQLRow selectedJournal, boolean onlyNew) {
    final SQLTable tableEcriture = getEcritureT();
    final SQLTable tableMouvement = tableEcriture.getForeignTable("ID_MOUVEMENT");
    final SQLTable tableCompte = tableEcriture.getForeignTable("ID_COMPTE_PCE");
    final SQLTable tableJrnl = tableEcriture.getForeignTable("ID_JOURNAL");

    final SQLSelect sel = createSelect(from, to, selectedJournal, onlyNew);
    sel.addSelect(tableJrnl.getField("CODE"));
    sel.addSelect(tableJrnl.getField("NOM"));
    sel.addSelect(tableEcriture.getField("DATE"));
    sel.addSelect(tableCompte.getField("NUMERO"));
    sel.addSelect(tableCompte.getField("NOM"));
    // width wider than 15, so replace with MOUVEMENT
    // sel.addSelect(tablePiece.getField("NOM"));
    sel.addSelect(tableMouvement.getField("NUMERO"));
    sel.addSelect(tableEcriture.getField("NOM"));
    sel.addSelect(tableEcriture.getField("DEBIT"));
    sel.addSelect(tableEcriture.getField("CREDIT"));

    sel.addFieldOrder(tableJrnl.getField("CODE"));
    sel.addFieldOrder(tableEcriture.getField("DATE"));
    sel.addFieldOrder(tableMouvement.getField("NUMERO"));

    @SuppressWarnings("unchecked")
    final List<Object[]> l = (List<Object[]>) this.getRootSociete().getDBSystemRoot().getDataSource()
            .execute(sel.asString(), new ArrayListHandler());
    this.data = l;
    return l == null ? 0 : l.size();
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• »