details: https://code.openbravo.com/erp/devel/pi/rev/be0721cf3497
changeset: 17847:be0721cf3497
user: David Miguelez <david.miguelez <at> openbravo.com>
date: Mon Sep 03 13:50:57 2012 +0200
summary: Fixes issue 21535: Fixed call to SQL procedure.
diffstat:
src/org/openbravo/costing/CostingBackground.java | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diffs (30 lines):
diff -r 288baadd3b3c -r be0721cf3497
src/org/openbravo/costing/CostingBackground.java
--- a/src/org/openbravo/costing/CostingBackground.java Mon Sep 03 12:44:29
2012 +0200
+++ b/src/org/openbravo/costing/CostingBackground.java Mon Sep 03 13:50:57
2012 +0200
@@ -59,7 +59,7 @@
where.append(" as o");
where.append(" where exists (");
where.append(" select 1 from " + CostingRule.ENTITY_NAME + " as cr");
- where.append(" where ad_is_orgincluded(o.id, cr." +
CostingRule.PROPERTY_ORGANIZATION
+ where.append(" where ad_isorgincluded(o.id, cr." +
CostingRule.PROPERTY_ORGANIZATION
+ ".id, " + CostingRule.PROPERTY_CLIENT + ".id) <> -1 ");
where.append(" and cr." + CostingRule.PROPERTY_VALIDATED + " is
true");
where.append(" )");
@@ -128,7 +128,7 @@
where.append(" and p." + Product.PROPERTY_PRODUCTTYPE + " = 'I'");
where.append(" and p." + Product.PROPERTY_STOCKED + " = true");
where.append(" and trx." +
MaterialTransaction.PROPERTY_TRANSACTIONPROCESSDATE + " <= :now");
- where.append(" and trx." + MaterialTransaction.PROPERTY_ORGANIZATION + "
in (:orgs)");
+ where.append(" and trx." + MaterialTransaction.PROPERTY_ORGANIZATION +
".id in (:orgs)");
where.append(" order by trx." +
MaterialTransaction.PROPERTY_TRANSACTIONPROCESSDATE);
OBQuery<MaterialTransaction> trxQry = OBDal.getInstance().createQuery(
MaterialTransaction.class, where.toString());
@@ -153,7 +153,7 @@
where.append(" and p." + Product.PROPERTY_PRODUCTTYPE + " = 'I'");
where.append(" and p." + Product.PROPERTY_STOCKED + " = true");
where.append(" and trx." +
MaterialTransaction.PROPERTY_TRANSACTIONPROCESSDATE + " <= :now");
- where.append(" and trx." + MaterialTransaction.PROPERTY_ORGANIZATION + "
in (:orgs)");
+ where.append(" and trx." + MaterialTransaction.PROPERTY_ORGANIZATION +
".id in (:orgs)");
where.append(" order by trx." +
MaterialTransaction.PROPERTY_TRANSACTIONPROCESSDATE);
OBQuery<MaterialTransaction> trxQry = OBDal.getInstance().createQuery(
MaterialTransaction.class, where.toString());
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
