Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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="FormSalesInvoice" language="groovy" pageWidth="612" pageHeight="792" columnWidth="572" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="0017974d-4699-46e0-b319-29b156a382be">
- <property name="ireport.zoom" value="1.5"/>
- <property name="ireport.x" value="0"/>
- <property name="ireport.y" value="0"/>
- <parameter name="partner_name" class="java.lang.String"/>
- <parameter name="doc_no" class="java.lang.String"/>
- <parameter name="ou_name" class="java.lang.String"/>
- <parameter name="partner_cp_phone1" class="java.lang.String"/>
- <parameter name="partner_cp_fax1" class="java.lang.String"/>
- <parameter name="partner_cp_email" class="java.lang.String"/>
- <parameter name="tax_amount" class="java.lang.String"/>
- <parameter name="base_amount" class="java.lang.String"/>
- <queryString>
- <![CDATA[SELECT ROW_NUMBER() OVER(ORDER BY A.line_no) AS num, A.product_code, A.product_desc AS product_name, B.curr_code, A.remark,
- COALESCE(SUM(A.qty)) AS qty, COALESCE(SUM(A.sell_price)) AS sell_price, COALESCE(SUM(A.amount)) AS total_amount
- FROM sl_quotation_item A
- INNER JOIN sl_quotation B ON A.quotation_id = B.quotation_id
- WHERE B.quotation_id = 18
- GROUP BY A.product_code, A.product_desc, B.curr_code, A.remark, A.line_no
- ORDER BY A.line_no;]]>
- </queryString>
- <field name="num" class="java.lang.Long"/>
- <field name="product_code" class="java.lang.String"/>
- <field name="product_name" class="java.lang.String"/>
- <field name="curr_code" class="java.lang.String"/>
- <field name="remark" class="java.lang.String"/>
- <field name="qty" class="java.math.BigDecimal"/>
- <field name="sell_price" class="java.math.BigDecimal"/>
- <field name="total_amount" class="java.math.BigDecimal"/>
- <variable name="number" class="java.lang.Long" calculation="Sum">
- <variableExpression><![CDATA[1]]></variableExpression>
- <initialValueExpression><![CDATA[1]]></initialValueExpression>
- </variable>
- <pageHeader>
- <band height="94" splitType="Stretch">
- <textField>
- <reportElement x="436" y="0" width="80" height="10" uuid="a06befdb-96d9-4b39-9bb9-78cfeda2bf97"/>
- <textElement textAlignment="Right">
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
- </textField>
- <textField evaluationTime="Report">
- <reportElement x="516" y="0" width="40" height="10" uuid="a1a8a2fb-b5e0-462d-a2e4-9ef24ffb8d53"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement x="436" y="17" width="131" height="10" uuid="fa29e30c-cde2-49be-9b3e-3de425277367"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$P{doc_no}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement x="436" y="27" width="131" height="10" uuid="8c1a7e98-42b9-48dd-abc3-acc5300f85c9"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$P{ou_name}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement positionType="FixRelativeToBottom" stretchType="RelativeToBandHeight" x="436" y="47" width="131" height="10" uuid="5acb0b62-8e02-420b-896d-5cecc3c83137"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$P{partner_cp_phone1}+ "/" +$P{partner_cp_fax1}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement x="436" y="37" width="131" height="10" uuid="ece11bca-976e-4ddf-9e84-695dee7f41ed"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$P{partner_name}]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement x="422" y="17" width="14" height="10" uuid="4ebe99b2-55a5-439a-b194-75f575717079"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="422" y="37" width="14" height="10" uuid="8b9a2ab6-1f0e-4d57-82ea-bf94583f3c4e"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="422" y="27" width="14" height="10" uuid="ddbfec6f-8465-4815-a1b9-efb7ebf64e58"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="422" y="47" width="14" height="10" uuid="ff7e6426-c1a3-44af-befa-046602c22f0c"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="349" y="47" width="73" height="10" uuid="604943c0-f260-41e9-9c11-897173a1ce8b"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[Phone / Fax]]></text>
- </staticText>
- <staticText>
- <reportElement x="349" y="27" width="73" height="10" uuid="6b04f5be-92af-4438-b7b2-450013e0d5bb"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[Company]]></text>
- </staticText>
- <staticText>
- <reportElement x="349" y="37" width="73" height="10" uuid="2941b0ee-267f-4e6f-9b7b-9508e5651fd4"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[Person]]></text>
- </staticText>
- <staticText>
- <reportElement x="349" y="17" width="73" height="10" uuid="1eece6ca-e086-4711-995c-42e8746533c0"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[No. Quotation]]></text>
- </staticText>
- <staticText>
- <reportElement x="422" y="57" width="14" height="10" uuid="7ed74c79-fdc2-413b-bf9a-b1e0995ae607"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="349" y="57" width="73" height="10" uuid="3d8040c1-fda2-4600-9215-48bf8697dd2c"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[E-mail]]></text>
- </staticText>
- <textField isStretchWithOverflow="true">
- <reportElement x="436" y="57" width="131" height="10" uuid="7e900003-c130-468e-a444-b21e8c929f68"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$P{partner_cp_email}]]></textFieldExpression>
- </textField>
- </band>
- </pageHeader>
- <columnHeader>
- <band height="10">
- <staticText>
- <reportElement x="33" y="0" width="91" height="10" uuid="1b029e6f-1b18-46d8-8dee-1f959bacf44d"/>
- <box topPadding="0" leftPadding="4" bottomPadding="0" rightPadding="4">
- <topPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Center">
- <font fontName="DejaVu Sans" size="8" isBold="true" isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[Part No #]]></text>
- </staticText>
- <staticText>
- <reportElement x="124" y="0" width="167" height="10" uuid="a6458b43-44e9-4a33-98e5-a3d52d7293c9"/>
- <box topPadding="0" leftPadding="4" bottomPadding="0" rightPadding="4">
- <topPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Center">
- <font fontName="DejaVu Sans" size="8" isBold="true" isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[Description]]></text>
- </staticText>
- <staticText>
- <reportElement x="291" y="0" width="60" height="10" uuid="ab445865-3a5f-45f8-816e-29fb359b3f6b"/>
- <box topPadding="0" leftPadding="4" bottomPadding="0" rightPadding="4">
- <topPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Center">
- <font fontName="DejaVu Sans" size="8" isBold="true" isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[Qty]]></text>
- </staticText>
- <staticText>
- <reportElement x="351" y="0" width="98" height="10" uuid="476785e0-d8d9-4c42-962e-3478b26e35aa"/>
- <box topPadding="0" leftPadding="4" bottomPadding="0" rightPadding="4">
- <topPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Center">
- <font fontName="DejaVu Sans" size="8" isBold="true" isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[Price / Unit]]></text>
- </staticText>
- <staticText>
- <reportElement x="1" y="0" width="32" height="10" uuid="0997a210-67d9-4220-9124-ef60be0fd745"/>
- <box topPadding="0" leftPadding="4" bottomPadding="0" rightPadding="4">
- <topPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Center">
- <font fontName="DejaVu Sans" size="8" isBold="true" isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[No]]></text>
- </staticText>
- <staticText>
- <reportElement x="449" y="0" width="118" height="10" uuid="3a55ad88-4c4d-4183-84d3-0b749bb10f8f"/>
- <box topPadding="0" leftPadding="4" bottomPadding="0" rightPadding="4">
- <topPen lineWidth="1.0"/>
- <bottomPen lineWidth="1.0"/>
- </box>
- <textElement textAlignment="Center">
- <font fontName="DejaVu Sans" size="8" isBold="true" isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[Price / Total]]></text>
- </staticText>
- </band>
- </columnHeader>
- <detail>
- <band height="29" splitType="Stretch">
- <textField isStretchWithOverflow="true">
- <reportElement x="32" y="0" width="91" height="10" uuid="a56d0274-f9c6-466f-8592-85444559ecbf"/>
- <box topPadding="0" leftPadding="4" bottomPadding="0" rightPadding="4"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{product_code}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true">
- <reportElement positionType="FixRelativeToBottom" stretchType="RelativeToBandHeight" x="124" y="0" width="167" height="10" uuid="b584e553-7199-47f3-8cf1-221fa80c6cd2"/>
- <box topPadding="0" leftPadding="4" bottomPadding="0" rightPadding="4"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{product_name}]]></textFieldExpression>
- </textField>
- <textField pattern="#,##0.00">
- <reportElement x="290" y="0" width="60" height="10" uuid="daae3e2c-08cb-44ff-b902-7bea08b2946e"/>
- <box topPadding="0" leftPadding="4" bottomPadding="0" rightPadding="4"/>
- <textElement textAlignment="Right">
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{qty}]]></textFieldExpression>
- </textField>
- <textField pattern="#,##0.00">
- <reportElement x="350" y="0" width="98" height="10" uuid="4da9c168-f69a-45fe-b99c-8ef51a22bd7d"/>
- <box topPadding="0" leftPadding="4" bottomPadding="0" rightPadding="4"/>
- <textElement textAlignment="Right">
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{sell_price}]]></textFieldExpression>
- </textField>
- <textField pattern="#,##0.00">
- <reportElement x="448" y="0" width="119" height="10" uuid="1b9ba3ae-c387-4247-be86-e632673132a9"/>
- <box topPadding="0" leftPadding="4" bottomPadding="0" rightPadding="0"/>
- <textElement textAlignment="Right">
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{total_amount}]]></textFieldExpression>
- </textField>
- <textField>
- <reportElement x="0" y="0" width="32" height="10" uuid="b1f1270d-36a0-45b2-bf1f-bed2ac304393"/>
- <box topPadding="0" leftPadding="4" bottomPadding="0" rightPadding="4"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$V{number}]]></textFieldExpression>
- </textField>
- </band>
- </detail>
- <columnFooter>
- <band height="91">
- <textField pattern="#,##0.00">
- <reportElement x="460" y="16" width="107" height="10" uuid="f5eb8cd7-821a-4ca1-8a8f-1996eb68e241"/>
- <textElement textAlignment="Right">
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$P{base_amount}]]></textFieldExpression>
- </textField>
- <textField pattern="#,##0.00">
- <reportElement x="460" y="26" width="107" height="10" uuid="51b57301-efd7-4845-9e11-06ab617aae77"/>
- <textElement textAlignment="Right">
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$P{base_amount}]]></textFieldExpression>
- </textField>
- <textField pattern="#,##0.00">
- <reportElement x="460" y="36" width="107" height="10" uuid="73de7b3c-5f1f-4f2b-ba91-0fbd75fcc65a"/>
- <textElement textAlignment="Right">
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <textFieldExpression><![CDATA[$P{tax_amount}]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement x="362" y="16" width="98" height="10" uuid="d025a8c2-53f5-4295-af7d-02cee839b021"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[Sub Total]]></text>
- </staticText>
- <staticText>
- <reportElement x="362" y="26" width="98" height="10" uuid="38ff1d87-84df-426d-9311-e09b8599baff"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[PPn]]></text>
- </staticText>
- <staticText>
- <reportElement x="362" y="36" width="98" height="10" uuid="3309fb33-bc8e-41ba-b8c8-3fbc0957c166"/>
- <textElement>
- <font fontName="DejaVu Sans" size="8" isPdfEmbedded="true"/>
- </textElement>
- <text><![CDATA[Additional Cost]]></text>
- </staticText>
- <line>
- <reportElement x="6" y="15" width="566" height="1" uuid="8ab578c2-d687-4bbd-904e-0d558d494634"/>
- </line>
- </band>
- </columnFooter>
- </jasperReport>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement