details:   https://code.openbravo.com/erp/devel/pi/rev/407350b7255b
changeset: 21061:407350b7255b
user:      Carlos Aristu <carlos.aristu <at> openbravo.com>
date:      Tue Sep 03 12:48:56 2013 +0200
summary:   related to issue 24636: code improved to use entity properties

diffstat:

 src/org/openbravo/materialmgmt/InventoryCountProcess.java |  3 ++-
 1 files changed, 2 insertions(+), 1 deletions(-)

diffs (13 lines):

diff -r 521d66167db4 -r 407350b7255b 
src/org/openbravo/materialmgmt/InventoryCountProcess.java
--- a/src/org/openbravo/materialmgmt/InventoryCountProcess.java Tue Sep 03 
12:15:31 2013 +0200
+++ b/src/org/openbravo/materialmgmt/InventoryCountProcess.java Tue Sep 03 
12:48:56 2013 +0200
@@ -198,7 +198,8 @@
     insert.append(" and asi.id = COALESCE(e." + 
InventoryCountLine.PROPERTY_ATTRIBUTESETVALUE
         + ".id , '0')");
     // Non Stockable Products should not generate warehouse transactions
-    insert.append(" and e.product.id = p.id and p.stocked = 'Y' and 
p.productType = 'I'");
+    insert.append(" and e." + InventoryCountLine.PROPERTY_PRODUCT + ".id = 
p.id and p."
+        + Product.PROPERTY_STOCKED + " = 'Y' and p." + 
Product.PROPERTY_PRODUCTTYPE + " = 'I'");
 
     Query queryInsert = 
OBDal.getInstance().getSession().createQuery(insert.toString());
     queryInsert.setString("inv", inventory.getId());

------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to