details:   /erp/stable/2.50/rev/4bb343280438
changeset: 9300:4bb343280438
user:      Adrián Romero <adrianromero <at> openbravo.com>
date:      Fri Mar 18 15:42:42 2011 +0100
summary:   Fixes issue 0016063: Sales order line selector not working fine 
working together a standard process
It has been added the new separator sequence for all SQL order lines and has 
been modified also the javacript code that analises this separator sequence

diffstat:

 src/org/openbravo/erpCommon/info/SalesOrderLine.html      |  2 +-
 src/org/openbravo/erpCommon/info/SalesOrderLine_data.xsql |  2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diffs (24 lines):

diff -r 1b165bcfba0b -r 4bb343280438 
src/org/openbravo/erpCommon/info/SalesOrderLine.html
--- a/src/org/openbravo/erpCommon/info/SalesOrderLine.html      Fri Mar 18 
09:56:53 2011 +0100
+++ b/src/org/openbravo/erpCommon/info/SalesOrderLine.html      Fri Mar 18 
15:42:42 2011 +0100
@@ -64,7 +64,7 @@
        var pos; var keys;  var key; var text; var parameter;
        if(action == "SAVE") {
            pos = getSelectedPos();
-           keys = getSelectedValues().split("#")
+           keys = getSelectedValues().split("@_##_@")
            key = keys[0];
            text = keys[1];
     }    
diff -r 1b165bcfba0b -r 4bb343280438 
src/org/openbravo/erpCommon/info/SalesOrderLine_data.xsql
--- a/src/org/openbravo/erpCommon/info/SalesOrderLine_data.xsql Fri Mar 18 
09:56:53 2011 +0100
+++ b/src/org/openbravo/erpCommon/info/SalesOrderLine_data.xsql Fri Mar 18 
15:42:42 2011 +0100
@@ -121,7 +121,7 @@
           SELECT ol.C_ORDERLINE_ID, b.NAME AS BPARTNER_NAME, p.NAME AS 
PRODUCT_NAME, ol.DATEORDERED, o.DOCUMENTNO, 
           o.ISSOTRX, ol.QTYORDERED AS QTY, ol.PRICEACTUAL, ol.LINENETAMT, 
           (o.DOCUMENTNO || ' - ' || ol.DATEORDERED || ' - ' || o.GRANDTOTAL || 
' - ' || ol.LINE || ' - ' || ol.LINENETAMT) AS LINE_TEXT,
-                         ol.C_ORDERLINE_ID || '#' || o.DOCUMENTNO || ' - ' || 
ol.DATEORDERED || ' - ' || o.GRANDTOTAL || ' - ' || ol.LINE || ' - ' || 
ol.LINENETAMT as rowkey
+                         ol.C_ORDERLINE_ID || '@_##_@' || o.DOCUMENTNO || ' - 
' || ol.DATEORDERED || ' - ' || o.GRANDTOTAL || ' - ' || ol.LINE || ' - ' || 
ol.LINENETAMT as rowkey
           FROM C_ORDERLINE ol left join M_MATCHPO mp on ol.C_ORDERLINE_ID = 
mp.C_ORDERLINE_ID 
                                                     AND mp.C_INVOICELINE_ID IS 
NOT NULL
                               left join M_MATCHPO mp2 on ol.C_ORDERLINE_ID = 
mp2.C_ORDERLINE_ID

------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to