0036940: Unneeded query executed on the orderloader process

Description

During the orderloader process a query to set one attributeset is executed when there is not stock and the product has an attribute set defined.
It is setting on the new shipment line the same attributesetvalue than in the last one, what has not sense.

Steps To Reproduce

-Define a product with an attribute set.
-Create on the terminal a ticket with that prodduct.
-Check that a query on the m_inoutline table is executed.
The query:

https://docs.google.com/document/d/1pWsaB-yj2pzBWU3v9R0nGYNpv4k1iXZXmCw6qGJ_kh0/edit [^]

Proposed Solution

REview the following code on the orderload process:

[12:48:20] Egoitz: if (!foundStockProposed && orderLine.getProduct().getAttributeSet() != null) {
            // M_GetStock couldn't find any valid stock, and the product has an attribute set. We
            // will
            // attempt to find an old transaction for this product, and get the attribute values
            // from
            // there
            OBCriteria<ShipmentInOutLine> oldLines = OBDal.getInstance().createCriteria(
                ShipmentInOutLine.class);
            oldLines
                .add(Restrictions.eq(ShipmentInOutLine.PROPERTY_PRODUCT, orderLine.getProduct()));
            oldLines.setMaxResults(1);
            oldLines.addOrderBy(ShipmentInOutLine.PROPERTY_CREATIONDATE, false);
            List<ShipmentInOutLine> oldLine = oldLines.list();
            if (oldLine.size() > 0) {
              oldAttributeSetValues = oldLine.get(0).getAttributeSetValue();
            }

          }

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0036840

closed

ranjith_qualiantech_com

Unneeded query executed on the orderloader process

Notes
(0099569) hgbot (developer) 2017-09-26 08:15	Repository: retail/backports/3.0RR17Q3.1/org.openbravo.retail.posterminal Changeset: dfd342f5149381a125487d83861de934e0807140 Author: Ranjith S R <ranjith <at> qualiantech.com> Date: Tue Sep 26 11:27:15 2017 +0530 URL: http://code.openbravo.com/retail/backports/3.0RR17Q3.1/org.openbravo.retail.posterminal/rev/dfd342f5149381a125487d83861de934e0807140 [^] Fixed issue 36940 : Removed unused logic in OrderLoader * Following condition is removed, if the stock is not present and product doesn't have attribute set, then attribute set is fetched from last transaction --- M src/org/openbravo/retail/posterminal/OrderLoader.java ---

Issue History
Date Modified	Username	Field	Change
2017-09-25 11:33	marvintm	Type	defect => backport
2017-09-25 11:33	marvintm	Target Version	=> RR17Q3.1
2017-09-26 08:15	hgbot	Checkin
2017-09-26 08:15	hgbot	Note Added: 0099569
2017-09-26 08:15	hgbot	Status	scheduled => resolved
2017-09-26 08:15	hgbot	Resolution	open => fixed
2017-09-26 08:15	hgbot	Fixed in SCM revision	http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/1aa6dec4e0ad4c1354194ef1796e5d195017920c [^] => http://code.openbravo.com/retail/backports/3.0RR17Q3.1/org.openbravo.retail.posterminal/rev/dfd342f5149381a125487d83861de934e0807140 [^]
2017-10-31 09:19	marvintm	Status	resolved => closed
2017-10-31 09:19	marvintm	Fixed in Version	=> RR17Q3.1