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 21... Line 21...
21
import org.openconcerto.erp.core.sales.pos.model.Paiement;
21
import org.openconcerto.erp.core.sales.pos.model.Paiement;
22
import org.openconcerto.erp.core.sales.pos.model.ReceiptCode;
22
import org.openconcerto.erp.core.sales.pos.model.ReceiptCode;
23
import org.openconcerto.erp.core.sales.pos.model.Ticket;
23
import org.openconcerto.erp.core.sales.pos.model.Ticket;
24
import org.openconcerto.sql.Configuration;
24
import org.openconcerto.sql.Configuration;
25
import org.openconcerto.sql.element.SQLElement;
25
import org.openconcerto.sql.element.SQLElement;
-
 
26
import org.openconcerto.sql.element.SQLElementDirectory;
26
import org.openconcerto.sql.model.SQLRow;
27
import org.openconcerto.sql.model.SQLRow;
-
 
28
import org.openconcerto.sql.model.SQLRowListRSH;
-
 
29
import org.openconcerto.sql.model.SQLSelect;
27
import org.openconcerto.ui.DefaultGridBagConstraints;
30
import org.openconcerto.ui.DefaultGridBagConstraints;
28
import org.openconcerto.utils.DecimalUtils;
31
import org.openconcerto.utils.DecimalUtils;
29
 
32
 
30
import java.awt.GridBagConstraints;
33
import java.awt.GridBagConstraints;
31
import java.awt.GridBagLayout;
34
import java.awt.GridBagLayout;
32
import java.awt.event.ActionEvent;
35
import java.awt.event.ActionEvent;
33
import java.awt.event.ActionListener;
36
import java.awt.event.ActionListener;
34
import java.math.BigDecimal;
37
import java.math.BigDecimal;
35
import java.text.ParseException;
38
import java.text.ParseException;
-
 
39
import java.util.HashMap;
36
import java.util.List;
40
import java.util.List;
-
 
41
import java.util.Map;
37
 
42
 
38
import javax.swing.JButton;
43
import javax.swing.JButton;
39
import javax.swing.JPanel;
44
import javax.swing.JPanel;
40
import javax.swing.JSeparator;
45
import javax.swing.JSeparator;
41
 
46
 
Line 75... Line 80...
75
 
80
 
76
        ticket.print(comp, conf.getTicketPrinterConfiguration1().getTicketWidth());
81
        ticket.print(comp, conf.getTicketPrinterConfiguration1().getTicketWidth());
77
    }
82
    }
78
 
83
 
79
    private Ticket createTicket(SQLRow row) {
84
    private Ticket createTicket(SQLRow row) {
-
 
85
        // TODO merger ce code avec CaissepPanel.loadArticles si possible
80
        final Ticket t;
86
        final Ticket t;
81
        try {
87
        try {
82
            t = new Ticket(new ReceiptCode(row.getString("NUMERO")), row.getDate("DATE"), row.getString("FILE_HASH_PREVIOUS"));
88
            t = new Ticket(new ReceiptCode(row.getString("NUMERO")), row.getDate("DATE"), row.getString("FILE_HASH_PREVIOUS"));
83
        } catch (ParseException e) {
89
        } catch (ParseException e) {
84
            throw new IllegalStateException("Couldn't parse " + row, e);
90
            throw new IllegalStateException("Couldn't parse " + row, e);
85
        }
91
        }
86
 
92
 
-
 
93
        final SQLElementDirectory directory = Configuration.getInstance().getDirectory();
87
        SQLElement eltEncaisser = Configuration.getInstance().getDirectory().getElement("ENCAISSER_MONTANT");
94
        SQLElement eltEncaisser = directory.getElement("ENCAISSER_MONTANT");
88
        List<SQLRow> l = row.getReferentRows(eltEncaisser.getTable());
95
        List<SQLRow> l = row.getReferentRows(eltEncaisser.getTable());
89
        for (SQLRow row2 : l) {
96
        for (SQLRow row2 : l) {
90
            long montant = row2.getLong("MONTANT");
97
            long montant = row2.getLong("MONTANT");
91
            SQLRow rowMode = row2.getForeign("ID_MODE_REGLEMENT");
98
            SQLRow rowMode = row2.getForeign("ID_MODE_REGLEMENT");
92
            int type = Paiement.CB;
99
            int type = Paiement.CB;
Line 104... Line 111...
104
            Paiement p = new Paiement(type);
111
            Paiement p = new Paiement(type);
105
            p.setMontantInCents((int) montant);
112
            p.setMontantInCents((int) montant);
106
            t.addPaiement(p);
113
            t.addPaiement(p);
107
        }
114
        }
108
 
115
 
109
        SQLElement eltArticle = Configuration.getInstance().getDirectory().getElement("SAISIE_VENTE_FACTURE_ELEMENT");
116
        SQLElement eltArticle = directory.getElement("SAISIE_VENTE_FACTURE_ELEMENT");
-
 
117
 
-
 
118
        final SQLSelect selUniteVente = new SQLSelect();
-
 
119
        selUniteVente.addSelectStar(directory.getElement("UNITE_VENTE").getTable());
-
 
120
        final Map<Integer, String> mapUniteVenteName = new HashMap<>();
-
 
121
        for (SQLRow rowUniteVente : SQLRowListRSH.execute(selUniteVente)) {
-
 
122
            mapUniteVenteName.put(rowUniteVente.getID(), rowUniteVente.getString("CODE"));
-
 
123
        }
-
 
124
 
110
        List<SQLRow> l2 = row.getReferentRows(eltArticle.getTable());
125
        List<SQLRow> l2 = row.getReferentRows(eltArticle.getTable());
111
        Categorie c = new Categorie("");
126
        Categorie c = new Categorie("");
112
        for (SQLRow row2 : l2) {
127
        for (SQLRow row2 : l2) {
113
            Article a = new Article(c, row2.getString("NOM"), row2.getInt("ID_ARTICLE"));
128
            Article a = new Article(c, row2.getString("NOM"), row2.getInt("ID_ARTICLE"));
-
 
129
            if (row2.getInt("ID_UNITE_VENTE") != 2) {
-
 
130
                a.setSalesUnit(mapUniteVenteName.get(row2.getInt("ID_UNITE_VENTE")));
-
 
131
            }
114
            BigDecimal ht = (BigDecimal) row2.getObject("PV_HT");
132
            BigDecimal ht = (BigDecimal) row2.getObject("PV_HT");
115
            a.setPriceWithoutTax(ht);
133
            a.setPriceWithoutTax(ht);
116
            int idTaxe = row2.getInt("ID_TAXE");
134
            int idTaxe = row2.getInt("ID_TAXE");
117
            float tva = TaxeCache.getCache().getTauxFromId(idTaxe);
135
            float tva = TaxeCache.getCache().getTauxFromId(idTaxe);
118
            a.setPriceWithTax(ht.multiply(new BigDecimal(1.0 + (tva / 100.0D)), DecimalUtils.HIGH_PRECISION));
136
            a.setPriceWithTax(ht.multiply(BigDecimal.valueOf(1.0 + (tva / 100.0D)), DecimalUtils.HIGH_PRECISION));
119
            a.setIdTaxe(idTaxe);
137
            a.setIdTaxe(idTaxe);
120
            t.addArticle(a);
138
            t.addArticle(a);
-
 
139
            if (a.getSalesUnit() == null) {
121
            t.setArticleCount(a, row2.getInt("QTE"));
140
                t.setArticleCount(a, new BigDecimal(row2.getInt("QTE")));
-
 
141
            } else {
-
 
142
                t.setArticleCount(a, row2.getBigDecimal("QTE_UNITAIRE"));
-
 
143
            }
122
        }
144
        }
123
 
145
 
124
        return t;
146
        return t;
125
    }
147
    }
126
}
148
}