Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
tree: 748ed1db67
Fetching contributors…

Cannot retrieve contributors at this time

106 lines (105 sloc) 4.246 kb
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="simple_invoice_telco_events" pageWidth="540" pageHeight="802" columnWidth="540" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
<parameter name="invoiceId" class="java.lang.Integer"/>
<queryString>
<![CDATA[select * from mediation_record_line where order_line_id in (select id from order_line where order_id = (select order_id from order_process where invoice_id = $P{invoiceId} and is_review = 0)) order by id;]]>
</queryString>
<field name="event_date" class="java.sql.Timestamp"/>
<field name="description" class="java.lang.String"/>
<field name="quantity" class="java.math.BigDecimal"/>
<field name="amount" class="java.math.BigDecimal"/>
<background>
<band/>
</background>
<title>
<band height="36">
<staticText>
<reportElement x="6" y="8" width="528" height="22"/>
<textElement textAlignment="Left">
<font fontName="Arial" size="16" isBold="true"/>
</textElement>
<text><![CDATA[Appendix: Events]]></text>
</staticText>
<break>
<reportElement x="0" y="2" width="100" height="1"/>
</break>
</band>
</title>
<pageHeader>
<band/>
</pageHeader>
<columnHeader>
<band height="18">
<staticText>
<reportElement mode="Opaque" x="0" y="0" width="125" height="18" forecolor="#FFFFFF" backcolor="#999999"/>
<textElement verticalAlignment="Middle">
<font size="12"/>
</textElement>
<text><![CDATA[ Event Date]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="125" y="0" width="249" height="18" forecolor="#FFFFFF" backcolor="#999999"/>
<textElement verticalAlignment="Middle">
<font size="12"/>
</textElement>
<text><![CDATA[ Description]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="374" y="0" width="85" height="18" forecolor="#FFFFFF" backcolor="#999999"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="12"/>
</textElement>
<text><![CDATA[Quantity]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="459" y="0" width="81" height="18" forecolor="#FFFFFF" backcolor="#999999"/>
<textElement textAlignment="Right" verticalAlignment="Middle">
<font size="12"/>
</textElement>
<text><![CDATA[Amount ]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="18">
<textField>
<reportElement x="0" y="0" width="125" height="18"/>
<textElement verticalAlignment="Middle">
<font size="11"/>
</textElement>
<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{event_date}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement x="125" y="0" width="249" height="18"/>
<textElement verticalAlignment="Middle">
<font size="11"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{description}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="374" y="0" width="85" height="18">
<printWhenExpression><![CDATA[new Boolean($F{quantity} != null)]]></printWhenExpression>
</reportElement>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="11"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[(new DecimalFormat("#,##0.00")).format($F{quantity})]]></textFieldExpression>
</textField>
<textField>
<reportElement x="459" y="0" width="81" height="18">
<printWhenExpression><![CDATA[new Boolean($F{amount} != null)]]></printWhenExpression>
</reportElement>
<textElement textAlignment="Right" verticalAlignment="Middle">
<font size="11"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[(new DecimalFormat("#,##0.00")).format($F{amount})]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band/>
</columnFooter>
<summary>
<band/>
</summary>
</jasperReport>
Jump to Line
Something went wrong with that request. Please try again.