details: https://code.openbravo.com/erp/stable/2.50/rev/0716e5f3ec64
changeset: 9575:0716e5f3ec64
user: Ioritz Cia <ioritz.cia <at> openbravo.com>
date: Fri Jul 15 09:33:38 2011 +0200
summary: Issue 17547: Order and Invoice reports have 'Price' column always in
English and another problems.
diffstat:
src/org/openbravo/erpReports/C_OrderJR.jrxml | 70 +++++++++-
src/org/openbravo/erpReports/C_OrderLinesJR.jrxml | 123 +++++++++--------
src/org/openbravo/erpReports/RptC_Invoice.jrxml | 121 ++++++++++++----
src/org/openbravo/erpReports/RptC_Invoice_Lines.jrxml | 64 +++-----
src/org/openbravo/erpReports/RptC_OrderPO.jrxml | 40 +++++-
src/org/openbravo/erpReports/RptC_OrderPO_Lines.jrxml | 43 ++---
6 files changed, 298 insertions(+), 163 deletions(-)
diffs (truncated from 786 to 300 lines):
diff -r 892c4c05a535 -r 0716e5f3ec64
src/org/openbravo/erpReports/C_OrderJR.jrxml
--- a/src/org/openbravo/erpReports/C_OrderJR.jrxml Thu Jul 14 14:14:53
2011 +0200
+++ b/src/org/openbravo/erpReports/C_OrderJR.jrxml Fri Jul 15 09:33:38
2011 +0200
@@ -160,7 +160,7 @@
COALESCE(TO_CHAR(ADDRESS1), '') || CASE WHEN ADDRESS1 IS null THEN '' ELSE
CHR(13) END || COALESCE(TO_CHAR(POSTAL), '') || CASE WHEN POSTAL IS null THEN
'' ELSE CHR(13) END ||
COALESCE(TO_CHAR(C_BPARTNER_LOCATION.PHONE), '') || CASE WHEN
C_BPARTNER_LOCATION.PHONE IS null THEN '' ELSE CHR(13) END ||
COALESCE(TO_CHAR(C_BPARTNER_LOCATION.FAX), '') ||
CASE WHEN C_BPARTNER_LOCATION.FAX IS null THEN '' ELSE CHR(13) END) AS
BP_DATA, AD_ORGINFO.TAXID AS ORG_TAXID, SHOWLOGO, SHOWCOMPANYDATA, HEADERMARGIN,
-AD_ORG.NAME AS ORG_NAME, DELIVERYRULE.NAME AS DELIVERYTERM, PAYMENTTERM.TERM
AS PAYMENTTERM, C_POC_DOCTYPE_TEMPLATE.NAME AS DOC_TYPE
+AD_ORG.NAME AS ORG_NAME, DELIVERYRULE.NAME AS DELIVERYTERM, PAYMENTTERM.TERM
AS PAYMENTTERM, C_POC_DOCTYPE_TEMPLATE.NAME AS DOC_TYPE, C_CURRENCY.ISO_CODE as
CURRENCY_ISO
FROM C_BPARTNER_LOCATION left join C_LOCATION L on
C_BPARTNER_LOCATION.C_LOCATION_ID = L.C_LOCATION_ID
left join C_REGION R on L.C_REGION_ID = R.C_REGION_ID,
AD_USER right join C_ORDER on AD_USER.AD_USER_ID = C_ORDER.AD_USER_ID
@@ -172,7 +172,7 @@
AND AD_LANGUAGE IN ($P{LANGUAGE})) DELIVERYRULE,
(SELECT C_PAYMENTTERM.C_PAYMENTTERM_ID, COALESCE( C_PAYMENTTERM_TRL.NAME,
C_PAYMENTTERM.NAME) AS TERM
FROM C_PAYMENTTERM LEFT JOIN C_PAYMENTTERM_TRL ON
C_PAYMENTTERM.C_PAYMENTTERM_ID = C_PAYMENTTERM_TRL.C_PAYMENTTERM_ID
- AND C_PAYMENTTERM_TRL.AD_LANGUAGE IN ($P{LANGUAGE})) PAYMENTTERM
+ AND C_PAYMENTTERM_TRL.AD_LANGUAGE IN ($P{LANGUAGE})) PAYMENTTERM,
C_CURRENCY
WHERE C_ORDER.C_BPARTNER_LOCATION_ID =
C_BPARTNER_LOCATION.C_BPARTNER_LOCATION_ID
AND C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID
AND AD_ORG.ad_org_id = AD_ORGINFO.ad_org_id
@@ -182,7 +182,8 @@
AND C_ORDER.AD_CLIENT_ID = AD_CLIENT.AD_CLIENT_ID
AND C_ORDER.C_ORDER_ID IN ($P{DOCUMENT_ID})
AND C_ORDER.DELIVERYRULE = DELIVERYRULE.VALUE
-AND C_ORDER.C_PAYMENTTERM_ID = PAYMENTTERM.C_PAYMENTTERM_ID]]></queryString>
+AND C_ORDER.C_PAYMENTTERM_ID = PAYMENTTERM.C_PAYMENTTERM_ID
+AND C_CURRENCY.C_CURRENCY_ID=C_ORDER.C_CURRENCY_ID]]></queryString>
<field name="C_ORDER_ID" class="java.lang.String"/>
<field name="NAME" class="java.lang.String"/>
@@ -207,6 +208,7 @@
<field name="DELIVERYTERM" class="java.lang.String"/>
<field name="PAYMENTTERM" class="java.lang.String"/>
<field name="DOC_TYPE" class="java.lang.String"/>
+ <field name="CURRENCY_ISO" class="java.lang.String"/>
<group name="PrintLarge" isReprintHeaderOnEachPage="true" >
@@ -389,19 +391,73 @@
</textElement>
<textFieldExpression
class="java.lang.String"><![CDATA[($F{LOCATION}==null ? $F{ORG_NAME} + "\n" +
$F{ORG_TAXID} + "\n" : $F{ORG_NAME} + "\n" + $F{ORG_TAXID} + "\n" +
$F{LOCATION})]]></textFieldExpression>
</textField>
+ <staticText>
+ <reportElement
+ style="Group_Data_Label"
+ x="210"
+ y="214"
+ width="150"
+ height="18"
+ forecolor="#999999"
+ backcolor="#FFFFFF"
+ key="staticText-11"/>
+ <box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+ <leftPen lineWidth="0.0"
lineStyle="Solid" lineColor="#000000"/>
+ <bottomPen lineWidth="0.0"
lineColor="#000000"/>
+ <rightPen lineWidth="0.0"
lineStyle="Solid" lineColor="#000000"/>
+</box>
+ <textElement textAlignment="Left"
verticalAlignment="Top">
+ <font pdfFontName="Helvetica"
size="11" isBold="true"/>
+ </textElement>
+ <text><![CDATA[Currency]]></text>
+ </staticText>
<textField isStretchWithOverflow="false"
isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"
hyperlinkTarget="Self" >
<reportElement
+ x="210"
+ y="234"
+ width="150"
+ height="20"
+ key="textField-24"/>
+ <box>
<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+ <leftPen lineWidth="0.0"
lineStyle="Solid" lineColor="#000000"/>
+ <bottomPen lineWidth="0.0"
lineColor="#000000"/>
+ <rightPen lineWidth="0.0"
lineStyle="Solid" lineColor="#000000"/>
+</box>
+ <textElement>
+ <font/>
+ </textElement>
+ <textFieldExpression
class="java.lang.String"><![CDATA[$F{CURRENCY_ISO}]]></textFieldExpression>
+ </textField>
+ <staticText>
+ <reportElement
x="0"
y="6"
- width="250"
+ width="310"
height="37"
- key="textField-23"/>
+ key="staticText-12">
+
<printWhenExpression><![CDATA[new
Boolean($F{DOC_TYPE}.equalsIgnoreCase("Purchase Order Report
template"))]]></printWhenExpression>
+ </reportElement>
<box></box>
<textElement>
<font size="26"/>
</textElement>
- <textFieldExpression
class="java.lang.String"><![CDATA[($F{DOC_TYPE}.equalsIgnoreCase("Purchase
Order Report template")) == true ? "PURCHASE ORDER" : "SALES
ORDER"]]></textFieldExpression>
- </textField>
+ <text><![CDATA[PURCHASE ORDER]]></text>
+ </staticText>
+ <staticText>
+ <reportElement
+ x="0"
+ y="6"
+ width="310"
+ height="37"
+ key="staticText-13">
+
<printWhenExpression><![CDATA[new
Boolean($F{DOC_TYPE}.equalsIgnoreCase("Purchase Order Report template") ==
false)]]></printWhenExpression>
+ </reportElement>
+ <box></box>
+ <textElement>
+ <font size="26"/>
+ </textElement>
+ <text><![CDATA[SALES ORDER]]></text>
+ </staticText>
</band>
</groupHeader>
<groupFooter>
diff -r 892c4c05a535 -r 0716e5f3ec64
src/org/openbravo/erpReports/C_OrderLinesJR.jrxml
--- a/src/org/openbravo/erpReports/C_OrderLinesJR.jrxml Thu Jul 14 14:14:53
2011 +0200
+++ b/src/org/openbravo/erpReports/C_OrderLinesJR.jrxml Fri Jul 15 09:33:38
2011 +0200
@@ -82,34 +82,31 @@
<parameter name="LOCALE" isForPrompting="false"
class="java.util.Locale"/>
<queryString><![CDATA[SELECT 1 AS ISBOM, C_ORDERLINE.LINE,
COALESCE(M_PRODUCT.NAME, C_ORDERLINE.DESCRIPTION) AS PRODUCT_NAME,
C_ORDERLINE.QTYORDERED AS QUANTITY,
TO_CHAR(C_UOM.NAME) AS UOM, C_ORDERLINE.PRICEACTUAL, TO_NUMBER(NULL)
AS BASE, C_ORDERLINE.LINENETAMT, TO_NUMBER(NULL) AS TAXLINE,
- TO_CHAR(C_CURRENCY.CURSYMBOL) as CURRENCY, C_ORDER.docstatus AS
STATUS, C_CURRENCY.ISO_CODE as CURRENCY_ISO, TO_CHAR(M_PRODUCT.VALUE) AS VALUE
+ C_ORDER.docstatus AS STATUS, TO_CHAR(M_PRODUCT.VALUE) AS VALUE
FROM C_ORDERLINE left join M_PRODUCT on C_ORDERLINE.M_PRODUCT_ID =
M_PRODUCT.M_PRODUCT_ID
left join C_UOM on C_ORDERLINE.C_UOM_ID =
C_UOM.C_UOM_ID,
- C_ORDER, C_CURRENCY
+ C_ORDER
WHERE C_ORDERLINE.C_ORDER_ID = $P{C_ORDER_ID}
AND C_ORDERLINE.C_ORDER_ID=C_ORDER.C_ORDER_ID
- AND C_CURRENCY.C_CURRENCY_ID=C_ORDER.C_CURRENCY_ID
UNION
SELECT 2 AS ISBOM, C_ORDERLINE.LINE, M_PRODUCT.NAME AS PRODUCT_NAME,
C_ORDERLINE.QTYORDERED*M_PRODUCT_BOM.BOMQTY AS QUANTITY,
TO_CHAR(C_UOM.NAME) AS UOM, TO_NUMBER(NULL) AS PRICEACTUAL,
TO_NUMBER(NULL) AS BASE, TO_NUMBER(NULL) AS LINENETAMT, TO_NUMBER(NULL) AS
TAXLINE,
- TO_CHAR(C_CURRENCY.ISO_CODE) as CURRENCY, C_ORDER.docstatus AS STATUS,
C_CURRENCY.ISO_CODE as CURRENCY_ISO, TO_CHAR(M_PRODUCT.VALUE) AS VALUE
- FROM M_PRODUCT_BOM, M_PRODUCT, C_ORDERLINE, C_UOM, C_ORDER, C_CURRENCY
+ C_ORDER.docstatus AS STATUS, TO_CHAR(M_PRODUCT.VALUE) AS VALUE
+ FROM M_PRODUCT_BOM, M_PRODUCT, C_ORDERLINE, C_UOM, C_ORDER
WHERE C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT_BOM.M_PRODUCT_ID
AND M_PRODUCT_BOM.M_PRODUCTBOM_ID = M_PRODUCT.M_PRODUCT_ID
AND M_PRODUCT.C_UOM_ID = C_UOM.C_UOM_ID
AND C_ORDERLINE.C_ORDER_ID = $P{C_ORDER_ID}
AND C_ORDERLINE.C_ORDER_ID=C_ORDER.C_ORDER_ID
- AND C_CURRENCY.C_CURRENCY_ID=C_ORDER.C_CURRENCY_ID
UNION
SELECT 3 AS ISBOM, TO_NUMBER(null) AS LINE, C_TAX.NAME AS
PRODUCT_NAME, TO_NUMBER(NULL) AS QUANTITY, '' AS UOM, TO_NUMBER(NULL) AS
PRICEACTUAL,
- C_ORDERTAX.TAXBASEAMT AS BASE, C_ORDERTAX.TAXAMT AS LINENETAMT,
C_ORDERTAX.LINE AS TAXLINE, TO_CHAR(C_CURRENCY.CURSYMBOL) as CURRENCY,
C_ORDER.docstatus AS STATUS,
- C_CURRENCY.ISO_CODE as CURRENCY_ISO, '' AS VALUE
- FROM C_ORDER, C_ORDERTAX, C_TAX, C_CURRENCY
+ C_ORDERTAX.TAXBASEAMT AS BASE, C_ORDERTAX.TAXAMT AS LINENETAMT,
C_ORDERTAX.LINE AS TAXLINE, C_ORDER.docstatus AS STATUS,
+ '' AS VALUE
+ FROM C_ORDER, C_ORDERTAX, C_TAX
WHERE C_ORDER.C_ORDER_ID = C_ORDERTAX.C_ORDER_ID
AND C_TAX.C_TAX_ID = C_ORDERTAX.C_TAX_ID
AND C_ORDERTAX.TAXAMT <> 0
AND C_ORDER.C_ORDER_ID = $P{C_ORDER_ID}
- AND C_CURRENCY.C_CURRENCY_ID=C_ORDER.C_CURRENCY_ID
ORDER BY LINE,ISBOM, TAXLINE]]></queryString>
<field name="ISBOM" class="java.lang.Integer"/>
@@ -121,9 +118,7 @@
<field name="BASE" class="java.math.BigDecimal"/>
<field name="LINENETAMT" class="java.math.BigDecimal"/>
<field name="TAXLINE" class="java.math.BigDecimal"/>
- <field name="CURRENCY" class="java.lang.String"/>
<field name="STATUS" class="java.lang.String"/>
- <field name="CURRENCY_ISO" class="java.lang.String"/>
<field name="VALUE" class="java.lang.String"/>
<variable name="SUM_LINENETAMT" class="java.math.BigDecimal"
resetType="Report" calculation="Sum">
@@ -140,7 +135,7 @@
mode="Opaque"
x="235"
y="3"
- width="55"
+ width="60"
height="17"
forecolor="#FFFFFF"
backcolor="#666666"
@@ -193,51 +188,71 @@
</textElement>
<text><![CDATA[PRODUCT NAME]]></text>
</staticText>
- <textField isStretchWithOverflow="false"
isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"
hyperlinkTarget="Self" >
+ <staticText>
<reportElement
style="Detail_Header"
- x="290"
+ x="1"
y="3"
width="65"
height="17"
- key="textField-3"/>
+ key="staticText-1"/>
+ <box></box>
+ <textElement verticalAlignment="Top">
+ <font isBold="false"/>
+ </textElement>
+ <text><![CDATA[REFERENCE]]></text>
+ </staticText>
+ <staticText>
+ <reportElement
+ style="Detail_Header"
+ x="295"
+ y="3"
+ width="60"
+ height="17"
+ forecolor="#FFFFFF"
+ backcolor="#666666"
+ key="staticText-2"/>
<box></box>
<textElement textAlignment="Right"
verticalAlignment="Top">
- <font size="10" isBold="false"/>
+ <font pdfFontName="Helvetica"
isBold="false"/>
</textElement>
- <textFieldExpression
class="java.lang.String"><![CDATA["PRICE (" + $F{CURRENCY_ISO} +
")"]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="false"
isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"
hyperlinkTarget="Self" >
+ <text><![CDATA[PRICE]]></text>
+ </staticText>
+ <staticText>
<reportElement
style="Detail_Header"
x="355"
y="3"
width="60"
height="17"
- key="textField-4"/>
+ forecolor="#FFFFFF"
+ backcolor="#666666"
+ key="staticText-3"/>
<box></box>
<textElement textAlignment="Right"
verticalAlignment="Top">
- <font size="10" isBold="false"/>
+ <font pdfFontName="Helvetica"
isBold="false"/>
</textElement>
- <textFieldExpression
class="java.lang.String"><![CDATA["BASE (" + $F{CURRENCY_ISO} +
")"]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="false"
isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"
hyperlinkTarget="Self" >
+ <text><![CDATA[BASE]]></text>
+ </staticText>
+ <staticText>
<reportElement
style="Detail_Header"
x="415"
y="3"
width="60"
height="17"
- key="textField-5"/>
+ forecolor="#FFFFFF"
+ backcolor="#666666"
+ key="staticText-4"/>
<box></box>
<textElement textAlignment="Right"
verticalAlignment="Top">
- <font size="10" isBold="false"/>
+ <font pdfFontName="Helvetica"
isBold="false"/>
</textElement>
- <textFieldExpression
class="java.lang.String"><![CDATA["NET (" + $F{CURRENCY_ISO} +
")"]]></textFieldExpression>
- </textField>
+ <text><![CDATA[NET]]></text>
+ </staticText>
<line direction="TopDown">
<reportElement
- x="290"
+ x="295"
y="3"
width="0"
height="17"
@@ -305,20 +320,6 @@
key="line-20"/>
<graphicElement
stretchType="NoStretch"/>
</line>
- <staticText>
- <reportElement
- style="Detail_Header"
- x="1"
- y="3"
- width="65"
- height="17"
- key="staticText-1"/>
- <box></box>
- <textElement verticalAlignment="Top">
- <font isBold="false"/>
- </textElement>
- <text><![CDATA[REFERENCE]]></text>
- </staticText>
<line direction="TopDown">
<reportElement
x="65"
@@ -371,7 +372,7 @@
style="default"
x="235"
y="0"
- width="55"
+ width="60"
height="16"
forecolor="#000000"
key="textField"/>
------------------------------------------------------------------------------
AppSumo Presents a FREE Video for the SourceForge Community by Eric
Ries, the creator of the Lean Startup Methodology on "Lean Startup
Secrets Revealed." This video shows you how to validate your ideas,
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
