details: https://code.openbravo.com/erp/devel/pi/rev/a80c97c10d98
changeset: 24728:a80c97c10d98
user: Reinaldo Guerra <reinaldo.guerra <at> peoplewalking.com>
date: Thu Sep 25 12:32:08 2014 -0500
summary: Fixed bug 27261: Wrong usage of to_date in two xsql files.
EditCCPMeasureValues_Values_data.xsql and ReportGuaranteeDate_data.xsql were
modified by adding specified format on function to_date.
Now when executed these process, all dates will be compared using the correct
date format.
diffstat:
src/org/openbravo/erpCommon/ad_actionButton/EditCCPMeasureValues_Values_data.xsql
| 4 ++--
src/org/openbravo/erpCommon/ad_reports/ReportGuaranteeDate_data.xsql
| 4 ++--
2 files changed, 4 insertions(+), 4 deletions(-)
diffs (42 lines):
diff -r 197fa82e1bbf -r a80c97c10d98
src/org/openbravo/erpCommon/ad_actionButton/EditCCPMeasureValues_Values_data.xsql
---
a/src/org/openbravo/erpCommon/ad_actionButton/EditCCPMeasureValues_Values_data.xsql
Thu Sep 25 10:48:33 2014 -0500
+++
b/src/org/openbravo/erpCommon/ad_actionButton/EditCCPMeasureValues_Values_data.xsql
Thu Sep 25 12:32:08 2014 -0500
@@ -12,7 +12,7 @@
* under the License.
* The Original Code is Openbravo ERP.
* The Initial Developer of the Original Code is Openbravo SLU
- * All portions are Copyright (C) 2001-2011 Openbravo SLU
+ * All portions are Copyright (C) 2001-2014 Openbravo SLU
* All Rights Reserved.
* Contributor(s): ______________________________________.
************************************************************************
@@ -34,7 +34,7 @@
and v.MA_CCP_ID = c.MA_CCP_ID
and t.MA_MEASURE_GROUP_ID = ?
union all
- select to_date('31/12/9999'), v.seqno, c.name || (CASE
c.CRITICAL WHEN 'Y' THEN ' (PC)' ELSE '' END) AS name, ' ' as value, identific,
'0' as valueid, 'hidden' as type, 'hidden' as validatetype, 'N' as valuec
+ select to_date('31/12/9999', 'DD/MM/YYYY'), v.seqno, c.name ||
(CASE c.CRITICAL WHEN 'Y' THEN ' (PC)' ELSE '' END) AS name, ' ' as value,
identific, '0' as valueid, 'hidden' as type, 'hidden' as validatetype, 'N' as
valuec
from ma_measure_time t, ma_measure_values v, ma_ccp c,
(select VALUE-1 as identific from ad_INTEGER
where VALUE<=(
diff -r 197fa82e1bbf -r a80c97c10d98
src/org/openbravo/erpCommon/ad_reports/ReportGuaranteeDate_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportGuaranteeDate_data.xsql
Thu Sep 25 10:48:33 2014 -0500
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportGuaranteeDate_data.xsql
Thu Sep 25 12:32:08 2014 -0500
@@ -12,7 +12,7 @@
* under the License.
* The Original Code is Openbravo ERP.
* The Initial Developer of the Original Code is Openbravo SLU
- * All portions are Copyright (C) 2001-2010 Openbravo SLU
+ * All portions are Copyright (C) 2001-2014 Openbravo SLU
* All Rights Reserved.
* Contributor(s): ______________________________________.
************************************************************************
@@ -47,7 +47,7 @@
]]></Sql>
<Parameter name="adUserClient" type="replace" optional="true" after="AND
S.AD_CLIENT_ID IN (" text="'1'"/>
<Parameter name="adOrgClient" type="replace" optional="true" after="AND
S.AD_ORG_ID IN (" text="'1'"/>
- <Parameter name="parDate" optional="true" after="AND 1=1"><![CDATA[ AND
COALESCE(M_ATTRIBUTESETINSTANCE.GUARANTEEDATE, TO_DATE('31/12/9999')) <
to_date(?)]]></Parameter>
+ <Parameter name="parDate" optional="true" after="AND 1=1"><![CDATA[ AND
COALESCE(M_ATTRIBUTESETINSTANCE.GUARANTEEDATE, TO_DATE('31/12/9999',
'DD/MM/YYYY')) < to_date(?)]]></Parameter>
<Parameter name="cBpartner" optional="true" after="AND 1=1"><![CDATA[ AND
C_BPARTNER.C_BPARTNER_ID = ?]]></Parameter>
<Parameter name="mWarehouse" optional="true" after="AND 1=1"><![CDATA[ AND
M_WAREHOUSE.M_WAREHOUSE_ID = ?]]></Parameter>
</SqlMethod>
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
