| Line 169... |
Line 169... |
| 169 |
{
|
169 |
{
|
| 170 |
SQLSelect selCmdElt = new SQLSelect();
|
170 |
SQLSelect selCmdElt = new SQLSelect();
|
| 171 |
final SQLTable tableCmdElt = tableStock.getTable("COMMANDE_ELEMENT");
|
171 |
final SQLTable tableCmdElt = tableStock.getTable("COMMANDE_ELEMENT");
|
| 172 |
selCmdElt.addSelectStar(tableCmdElt);
|
172 |
selCmdElt.addSelectStar(tableCmdElt);
|
| 173 |
Where w = new Where(tableCmdElt.getField("RECU_FORCED"), "=", Boolean.FALSE).and(new Where(tableCmdElt.getField("RECU"), "=", Boolean.FALSE));
|
173 |
Where w = new Where(tableCmdElt.getField("RECU_FORCED"), "=", Boolean.FALSE).and(new Where(tableCmdElt.getField("RECU"), "=", Boolean.FALSE));
|
| - |
|
174 |
w = w.and(Where.createRaw(
|
| - |
|
175 |
tableCmdElt.getField("QTE_RECUE").getQuotedName() + " < (" + tableCmdElt.getField("QTE").getQuotedName() + "*" + tableCmdElt.getField("QTE_UNITAIRE").getQuotedName() + ")",
|
| - |
|
176 |
tableCmdElt.getField("QTE_UNITAIRE"), tableCmdElt.getField("QTE"), tableCmdElt.getField("QTE_RECUE")));
|
| - |
|
177 |
|
| 174 |
selCmdElt.setWhere(w);
|
178 |
selCmdElt.setWhere(w);
|
| 175 |
List<SQLRow> res = SQLRowListRSH.execute(selCmdElt);
|
179 |
List<SQLRow> res = SQLRowListRSH.execute(selCmdElt);
|
| 176 |
if (res != null && res.size() > 0) {
|
180 |
if (res != null && res.size() > 0) {
|
| 177 |
StockItemsUpdater updater = new StockItemsUpdater(new StockLabel() {
|
181 |
StockItemsUpdater updater = new StockItemsUpdater(new StockLabel() {
|
| 178 |
|
182 |
|
| Line 191... |
Line 195... |
| 191 |
{
|
195 |
{
|
| 192 |
SQLSelect selCmdElt = new SQLSelect();
|
196 |
SQLSelect selCmdElt = new SQLSelect();
|
| 193 |
final SQLTable tableCmdElt = tableStock.getTable("COMMANDE_CLIENT_ELEMENT");
|
197 |
final SQLTable tableCmdElt = tableStock.getTable("COMMANDE_CLIENT_ELEMENT");
|
| 194 |
selCmdElt.addSelectStar(tableCmdElt);
|
198 |
selCmdElt.addSelectStar(tableCmdElt);
|
| 195 |
Where w = new Where(tableCmdElt.getField("LIVRE_FORCED"), "=", Boolean.FALSE).and(new Where(tableCmdElt.getField("LIVRE"), "=", Boolean.FALSE));
|
199 |
Where w = new Where(tableCmdElt.getField("LIVRE_FORCED"), "=", Boolean.FALSE).and(new Where(tableCmdElt.getField("LIVRE"), "=", Boolean.FALSE));
|
| - |
|
200 |
w = w.and(Where.createRaw(
|
| - |
|
201 |
tableCmdElt.getField("QTE_LIVREE").getQuotedName() + " < (" + tableCmdElt.getField("QTE").getQuotedName() + "*" + tableCmdElt.getField("QTE_UNITAIRE").getQuotedName() + ")",
|
| - |
|
202 |
tableCmdElt.getField("QTE_UNITAIRE"), tableCmdElt.getField("QTE"), tableCmdElt.getField("QTE_LIVREE")));
|
| - |
|
203 |
|
| 196 |
selCmdElt.setWhere(w);
|
204 |
selCmdElt.setWhere(w);
|
| 197 |
List<SQLRow> res = SQLRowListRSH.execute(selCmdElt);
|
205 |
List<SQLRow> res = SQLRowListRSH.execute(selCmdElt);
|
| 198 |
if (res != null && res.size() > 0) {
|
206 |
if (res != null && res.size() > 0) {
|
| 199 |
StockItemsUpdater updater = new StockItemsUpdater(new StockLabel() {
|
207 |
StockItemsUpdater updater = new StockItemsUpdater(new StockLabel() {
|
| 200 |
|
208 |
|
