details:   https://code.openbravo.com/erp/devel/pi/rev/b45167e7c675
changeset: 33341:b45167e7c675
user:      David Miguelez <david.miguelez <at> openbravo.com>
date:      Thu Feb 01 12:16:41 2018 +0100
summary:   Fixes Issue 37796. Selector for Product in Work Effort and 
Production Run Windows
does not filter Products by non stocked. It is possible to select a product
regardless of having stock of it. If there is stock, it is possible to select
the specific stock.

diffstat:

 src-db/database/sourcedata/OBUISEL_SELECTOR.xml |  2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diffs (12 lines):

diff -r 5ae490fd3146 -r b45167e7c675 
src-db/database/sourcedata/OBUISEL_SELECTOR.xml
--- a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml   Fri Feb 02 09:09:39 
2018 +0100
+++ b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml   Thu Feb 01 12:16:41 
2018 +0100
@@ -353,7 +353,7 @@
 <!--4C8BC3E8E56441F4B8C98C684A0C9212-->  
<AD_REFERENCE_ID><![CDATA[800011]]></AD_REFERENCE_ID>
 <!--4C8BC3E8E56441F4B8C98C684A0C9212-->  
<AD_TABLE_ID><![CDATA[FF8080812E381D1E012E3898C5DD0010]]></AD_TABLE_ID>
 <!--4C8BC3E8E56441F4B8C98C684A0C9212-->  
<WHERECLAUSE><![CDATA[e.active='Y']]></WHERECLAUSE>
-<!--4C8BC3E8E56441F4B8C98C684A0C9212-->  <FILTER_EXPRESSION><![CDATA["( 
(\'"+OB.getWindowId()+"\' in (\'800051\', \'800052\', \'800053\', 
\'FF808181323E504701323E57E08D0017\', \'800096\') and e.product.production = 
true and e.stocked = false) or (\'"+OB.getWindowId()+"\' in (\'170\') and 
e.product.stocked = true) or (\'"+OB.getWindowId()+"\' in (\'800092\') and 
e.product.purchase = true) or (\'"+OB.getWindowId()+"\' in (\'169\') and 
(e.warehouse.id is null or e.warehouse.id in (select ow.warehouse.id from 
OrganizationWarehouse ow where ow.organization.id = \'"+ 
OB.getParameters().get("inpadOrgId")+"\'))) or \'"+OB.getWindowId()+"\' not in 
(\'800051\', \'800052\', \'800053\', \'FF808181323E504701323E57E08D0017\', 
\'800096\',\'170\',\'800092\',\'169\'))"]]></FILTER_EXPRESSION>
+<!--4C8BC3E8E56441F4B8C98C684A0C9212-->  <FILTER_EXPRESSION><![CDATA["( 
(\'"+OB.getWindowId()+"\' in (\'800051\', \'800052\', \'800096\') and 
e.product.production = true and e.stocked = false) or (\'"+OB.getWindowId()+"\' 
in (\'800053\', \'FF808181323E504701323E57E08D0017\') and e.product.production 
= true) or (\'"+OB.getWindowId()+"\' in (\'170\') and e.product.stocked = true) 
or (\'"+OB.getWindowId()+"\' in (\'800092\') and e.product.purchase = true) or 
(\'"+OB.getWindowId()+"\' in (\'169\') and (e.warehouse.id is null or 
e.warehouse.id in (select ow.warehouse.id from OrganizationWarehouse ow where 
ow.organization.id = \'"+ OB.getParameters().get("inpadOrgId")+"\'))) or 
\'"+OB.getWindowId()+"\' not in (\'800051\', \'800052\', \'800053\', 
\'FF808181323E504701323E57E08D0017\', 
\'800096\',\'170\',\'800092\',\'169\'))"]]></FILTER_EXPRESSION>
 <!--4C8BC3E8E56441F4B8C98C684A0C9212-->  
<OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
 <!--4C8BC3E8E56441F4B8C98C684A0C9212-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--4C8BC3E8E56441F4B8C98C684A0C9212-->  
<VALUEFIELD_ID><![CDATA[D5CD42F686A14DFA949052B99900D679]]></VALUEFIELD_ID>

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to