OpenConcerto

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

svn://code.openconcerto.org/openconcerto

Rev

Rev 156 | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 156 Rev 174
Line 20... Line 20...
20
import org.openconcerto.erp.core.sales.account.VenteFactureSituationSQLComponent;
20
import org.openconcerto.erp.core.sales.account.VenteFactureSituationSQLComponent;
21
import org.openconcerto.erp.core.sales.account.VenteFactureSoldeSQLComponent;
21
import org.openconcerto.erp.core.sales.account.VenteFactureSoldeSQLComponent;
22
import org.openconcerto.erp.core.sales.order.component.CommandeClientSQLComponent;
22
import org.openconcerto.erp.core.sales.order.component.CommandeClientSQLComponent;
23
import org.openconcerto.erp.core.sales.order.report.CommandeClientXmlSheet;
23
import org.openconcerto.erp.core.sales.order.report.CommandeClientXmlSheet;
24
import org.openconcerto.erp.core.sales.order.ui.EtatCommandeClient;
24
import org.openconcerto.erp.core.sales.order.ui.EtatCommandeClient;
25
import org.openconcerto.erp.core.sales.product.element.ReferenceArticleSQLElement;
25
import org.openconcerto.erp.core.sales.product.element.UniteVenteArticleSQLElement;
-
 
26
import org.openconcerto.erp.core.sales.product.model.ProductComponent;
-
 
27
import org.openconcerto.erp.core.sales.product.model.ProductHelper;
26
import org.openconcerto.erp.core.sales.shipment.component.BonDeLivraisonSQLComponent;
28
import org.openconcerto.erp.core.sales.shipment.component.BonDeLivraisonSQLComponent;
27
import org.openconcerto.erp.core.supplychain.stock.element.MouvementStockSQLElement;
29
import org.openconcerto.erp.core.supplychain.stock.element.MouvementStockSQLElement;
28
import org.openconcerto.erp.core.supplychain.stock.element.StockSQLElement;
30
import org.openconcerto.erp.core.supplychain.stock.element.StockSQLElement;
29
import org.openconcerto.erp.model.MouseSheetXmlListeListener;
31
import org.openconcerto.erp.model.MouseSheetXmlListeListener;
30
import org.openconcerto.erp.preferences.GestionCommercialeGlobalPreferencePanel;
32
import org.openconcerto.erp.preferences.GestionCommercialeGlobalPreferencePanel;
Line 34... Line 36...
34
import org.openconcerto.sql.element.SQLElementLink.LinkType;
36
import org.openconcerto.sql.element.SQLElementLink.LinkType;
35
import org.openconcerto.sql.element.SQLElementLinksSetup;
37
import org.openconcerto.sql.element.SQLElementLinksSetup;
36
import org.openconcerto.sql.element.TreesOfSQLRows;
38
import org.openconcerto.sql.element.TreesOfSQLRows;
37
import org.openconcerto.sql.model.ConnectionHandlerNoSetup;
39
import org.openconcerto.sql.model.ConnectionHandlerNoSetup;
38
import org.openconcerto.sql.model.SQLDataSource;
40
import org.openconcerto.sql.model.SQLDataSource;
39
import org.openconcerto.sql.model.SQLField;
-
 
40
import org.openconcerto.sql.model.SQLInjector;
41
import org.openconcerto.sql.model.SQLInjector;
41
import org.openconcerto.sql.model.SQLRow;
42
import org.openconcerto.sql.model.SQLRow;
42
import org.openconcerto.sql.model.SQLRowAccessor;
43
import org.openconcerto.sql.model.SQLRowAccessor;
43
import org.openconcerto.sql.model.SQLRowListRSH;
44
import org.openconcerto.sql.model.SQLRowListRSH;
44
import org.openconcerto.sql.model.SQLRowValues;
45
import org.openconcerto.sql.model.SQLRowValues;
Line 577... Line 578...
577
     * @param commandeID
578
     * @param commandeID
578
     */
579
     */
579
    public void transfertCommande(int commandeID, boolean useCommandeEnCours) {
580
    public void transfertCommande(int commandeID, boolean useCommandeEnCours) {
580
 
581
 
581
        SQLElement elt = Configuration.getInstance().getDirectory().getElement("COMMANDE_CLIENT_ELEMENT");
582
        SQLElement elt = Configuration.getInstance().getDirectory().getElement("COMMANDE_CLIENT_ELEMENT");
582
        SQLTable tableCmdElt = Configuration.getInstance().getDirectory().getElement("COMMANDE_ELEMENT").getTable();
-
 
583
        SQLElement eltArticle = Configuration.getInstance().getDirectory().getElement("ARTICLE");
-
 
584
        SQLRow rowCmd = getTable().getRow(commandeID);
583
        SQLRow rowCmd = getTable().getRow(commandeID);
585
        List<SQLRow> rows = rowCmd.getReferentRows(elt.getTable());
584
        List<SQLRow> rows = rowCmd.getReferentRows(elt.getTable());
586
        final ListMap<SQLRow, SQLRowValues> map = new ListMap<SQLRow, SQLRowValues>();
-
 
587
        for (SQLRow sqlRow : rows) {
585
        transfertEltToCommandeF(rows);
588
            // on récupére l'article qui lui correspond
-
 
589
            SQLRowValues rowArticle = new SQLRowValues(eltArticle.getTable());
-
 
590
            for (SQLField field : eltArticle.getTable().getFields()) {
-
 
591
                if (sqlRow.getTable().getFieldsName().contains(field.getName())) {
-
 
592
                    rowArticle.put(field.getName(), sqlRow.getObject(field.getName()));
-
 
593
                }
586
    }
-
 
587
 
-
 
588
    public void transfertEltToCommandeF(List<? extends SQLRowAccessor> rowsItems) {
-
 
589
        ComptaPropsConfiguration.getInstanceCompta().getNonInteractiveSQLExecutor().execute(new Runnable() {
-
 
590
 
-
 
591
            @Override
-
 
592
            public void run() {
-
 
593
                ProductHelper helper = new ProductHelper(getTable().getDBRoot());
-
 
594
                List<ProductComponent> productComp = new ArrayList<>();
-
 
595
                helper.fillProductComponent(rowsItems, productComp, 1, 0, 1);
-
 
596
 
-
 
597
                List<ProductComponent> leafItems = helper.getChildWithQtyFrom(productComp);
-
 
598
 
-
 
599
                final ListMap<SQLRow, SQLRowValues> map = new ListMap<SQLRow, SQLRowValues>();
-
 
600
                final Set<Integer> stockChecked = new HashSet<Integer>();
-
 
601
                for (ProductComponent comp : leafItems) {
-
 
602
                    SQLRowAccessor rowArticleFind = comp.getProduct();
-
 
603
 
-
 
604
                    SQLRow row = rowArticleFind.asRow();
-
 
605
                    SQLRowAccessor rowStock = comp.getStock();
-
 
606
                    int value = 0;
-
 
607
                    if (row.getBoolean("GESTION_STOCK") && !stockChecked.contains(rowStock.getID())) {
-
 
608
                        stockChecked.add(rowStock.getID());
-
 
609
 
-
 
610
                        value = -Math.round(rowStock.getFloat("QTE_TH") - rowStock.getFloat("QTE_MIN"));
-
 
611
                    } else if (!row.getBoolean("GESTION_STOCK")) {
-
 
612
                        value = comp.getQty().intValue();
-
 
613
                    }
-
 
614
                    if (value > 0) {
-
 
615
 
-
 
616
                        SQLInjector inj = SQLInjector.getInjector(row.getTable(), row.getTable().getTable("COMMANDE_ELEMENT"));
-
 
617
                        SQLRowValues rowValsElt = new SQLRowValues(inj.createRowValuesFrom(row));
-
 
618
 
-
 
619
                        int qte = 1;
-
 
620
                        BigDecimal qteUV = BigDecimal.ONE;
-
 
621
 
-
 
622
                        if (row.getObject("ID_UNITE_VENTE") != null && row.getForeignID("ID_UNITE_VENTE") != UniteVenteArticleSQLElement.A_LA_PIECE) {
-
 
623
                            qteUV = comp.getQty();
-
 
624
                        } else {
-
 
625
                            qte = comp.getQty().setScale(0, RoundingMode.HALF_UP).intValue();
594
            }
626
                        }
595
 
627
 
596
            int idArticle = ReferenceArticleSQLElement.getIdForCNM(rowArticle, true);
-
 
597
            SQLRow rowArticleFind = eltArticle.getTable().getRow(idArticle);
-
 
598
            if (rowArticleFind != null && !rowArticleFind.isUndefined()) {
-
 
599
                SQLInjector inj = SQLInjector.getInjector(rowArticle.getTable(), tableCmdElt);
-
 
600
                SQLRowValues rowValsElt = new SQLRowValues(inj.createRowValuesFrom(rowArticleFind));
-
 
601
                rowValsElt.put("ID_STYLE", sqlRow.getObject("ID_STYLE"));
628
                        rowValsElt.put("QTE", qte);
602
                rowValsElt.put("QTE", sqlRow.getObject("QTE"));
629
                        rowValsElt.put("QTE_UNITAIRE", qteUV);
-
 
630
 
603
                rowValsElt.put("T_POIDS", rowValsElt.getLong("POIDS") * rowValsElt.getInt("QTE"));
631
                        rowValsElt.put("T_POIDS", rowValsElt.getLong("POIDS") * rowValsElt.getInt("QTE"));
604
                rowValsElt.put("T_PA_HT", ((BigDecimal) rowValsElt.getObject("PA_HT")).multiply(new BigDecimal(rowValsElt.getInt("QTE")), DecimalUtils.HIGH_PRECISION));
632
                        rowValsElt.put("T_PA_HT", ((BigDecimal) rowValsElt.getObject("PA_HT")).multiply(new BigDecimal(rowValsElt.getInt("QTE")), DecimalUtils.HIGH_PRECISION));
605
                rowValsElt.put("T_PA_TTC",
-
 
606
                        ((BigDecimal) rowValsElt.getObject("T_PA_HT")).multiply(new BigDecimal((rowValsElt.getForeign("ID_TAXE").getFloat("TAUX") / 100.0 + 1.0)), DecimalUtils.HIGH_PRECISION));
633
                        rowValsElt.put("T_PA_TTC", ((BigDecimal) rowValsElt.getObject("T_PA_HT")).multiply(new BigDecimal((rowValsElt.getForeign("ID_TAXE").getFloat("TAUX") / 100.0 + 1.0)),
607
                final SQLRow foreignRow = rowArticleFind.getForeignRow("ID_FOURNISSEUR");
-
 
608
                if (foreignRow != null && !foreignRow.isUndefined()) {
634
                                DecimalUtils.HIGH_PRECISION));
609
                    rowValsElt.put("ID_DEVISE", foreignRow.getForeignID("ID_DEVISE"));
635
                        // rowValsElt.put("ID_DEVISE",
610
                } else {
-
 
611
                    rowValsElt.put("ID_DEVISE", rowCmd.getForeignRow("ID_TARIF").getForeignID("ID_DEVISE"));
636
                        // rowCmd.getForeignRow("ID_TARIF").getForeignID("ID_DEVISE"));
612
                }
-
 
613
                map.add(rowArticleFind.getForeignRow("ID_FOURNISSEUR"), rowValsElt);
637
                        map.add(rowArticleFind.getForeign("ID_FOURNISSEUR").asRow(), rowValsElt);
614
            }
638
                    }
615
 
639
 
616
        }
640
                }
617
        MouvementStockSQLElement.createCommandeF(map, rowCmd.getForeignRow("ID_TARIF").getForeignRow("ID_DEVISE"), rowCmd.getString("NUMERO") + " - " + rowCmd.getString("NOM"), useCommandeEnCours);
641
                MouvementStockSQLElement.createCommandeF(map, null, "");
-
 
642
            }
-
 
643
        });
618
    }
644
    }
619
 
645
 
620
    /**
646
    /**
621
     * Transfert en BL
647
     * Transfert en BL
622
     * 
648
     *