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="c0828ef76ab61" language="groovy" pageWidth="595" pageHeight="421" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="b1181ec5-add5-43b0-8b6d-6f596fa99b21">
- <property name="ireport.zoom" value="1.1269722013523664"/>
- <property name="ireport.x" value="0"/>
- <property name="ireport.y" value="122"/>
- <parameter name="logo" class="java.lang.String" isForPrompting="false">
- <defaultValueExpression><![CDATA[]]></defaultValueExpression>
- </parameter>
- <queryString>
- <![CDATA[select transbeli2.nama, transbeli2.harga, transbeli2.tpr, transbeli2.tgl, transbeli2.nofaktur, transbeli2.qty, transbeli2.disc, transbeli2.disc2, transbeli2.qtysat, transbeli2.unitsat, transbeli2.hargasat, transbeli2.gudang, vendor.nama as namasupp, stock.konversi, vendor.supp, stock.sat1, transbeli2.kode, transbeli2.discrabat, vendor.al, transbeli2.memo, transbeli2.nb
- from transbeli2 inner join stock on transbeli2.kode=stock.kode inner join vendor on transbeli2.supp=vendor.supp
- order by transbeli2.itemno]]>
- </queryString>
- <field name="nama" class="java.lang.String"/>
- <field name="harga" class="java.math.BigDecimal"/>
- <field name="tpr" class="java.math.BigDecimal"/>
- <field name="tgl" class="java.sql.Timestamp"/>
- <field name="nofaktur" class="java.lang.String"/>
- <field name="qty" class="java.math.BigDecimal"/>
- <field name="disc" class="java.math.BigDecimal"/>
- <field name="disc2" class="java.math.BigDecimal"/>
- <field name="qtysat" class="java.math.BigDecimal"/>
- <field name="unitsat" class="java.lang.String"/>
- <field name="hargasat" class="java.math.BigDecimal"/>
- <field name="gudang" class="java.lang.String"/>
- <field name="namasupp" class="java.lang.String"/>
- <field name="konversi" class="java.math.BigDecimal"/>
- <field name="supp" class="java.lang.String"/>
- <field name="sat1" class="java.lang.String"/>
- <field name="kode" class="java.lang.String"/>
- <field name="discrabat" class="java.math.BigDecimal"/>
- <field name="al" class="java.lang.String"/>
- <field name="memo" class="java.lang.String"/>
- <field name="nb" class="java.lang.String"/>
- <variable name="row" class="java.lang.Integer" calculation="Sum">
- <variableExpression><![CDATA[1]]></variableExpression>
- <initialValueExpression><![CDATA[0]]></initialValueExpression>
- </variable>
- <variable name="vjumlah" class="java.math.BigDecimal" resetType="Column" incrementType="Column" calculation="Sum">
- <variableExpression><![CDATA[($F{qty} * $F{harga}) - ($F{qty} * $F{harga} * $F{discrabat} / 100 ) - $F{tpr}]]></variableExpression>
- </variable>
- <variable name="vjumlah_1" class="java.math.BigDecimal" calculation="Sum">
- <variableExpression><![CDATA[$V{vjumlah}]]></variableExpression>
- <initialValueExpression><![CDATA[BigDecimal.valueOf(0)]]></initialValueExpression>
- </variable>
- <variable name="vdisc_1" class="java.math.BigDecimal" resetType="None">
- <variableExpression><![CDATA[$V{vjumlah_1} * $F{disc} / 100]]></variableExpression>
- <initialValueExpression><![CDATA[BigDecimal.valueOf(0)]]></initialValueExpression>
- </variable>
- <variable name="vdisc2_1" class="java.math.BigDecimal" resetType="None">
- <variableExpression><![CDATA[($V{vjumlah_1} - $V{vdisc_1}) * $F{disc2} / 100]]></variableExpression>
- <initialValueExpression><![CDATA[BigDecimal.valueOf(0)]]></initialValueExpression>
- </variable>
- <variable name="vtotal_1" class="java.math.BigDecimal" resetType="None">
- <variableExpression><![CDATA[$V{vjumlah_1} - $V{vdisc_1} - $V{vdisc2_1}]]></variableExpression>
- <initialValueExpression><![CDATA[BigDecimal.valueOf(0)]]></initialValueExpression>
- </variable>
- <background>
- <band splitType="Stretch"/>
- </background>
- <pageHeader>
- <band height="114" splitType="Stretch">
- <staticText>
- <reportElement x="310" y="44" width="76" height="16" uuid="36b48c0d-a952-4c64-a217-da31d82af59f"/>
- <textElement verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <text><![CDATA[No Faktur:]]></text>
- </staticText>
- <staticText>
- <reportElement x="310" y="27" width="76" height="16" uuid="66395713-f8ca-49f5-a1f5-df4cd02bb080"/>
- <textElement verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <text><![CDATA[Tgl Faktur:]]></text>
- </staticText>
- <staticText>
- <reportElement x="310" y="61" width="76" height="16" uuid="892ca14f-133e-4c36-953c-27af067889ca"/>
- <textElement verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <text><![CDATA[Kepada Yth:]]></text>
- </staticText>
- <textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
- <reportElement x="392" y="44" width="160" height="16" uuid="3f5fbd4d-ceda-4f1a-8115-3f11a9466091"/>
- <textElement verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{nofaktur}]]></textFieldExpression>
- </textField>
- <textField pattern="dd-MMM-yyyy" isBlankWhenNull="true">
- <reportElement x="392" y="27" width="160" height="16" uuid="669f1ba4-b9db-408d-a62e-65d4b5d5a870"/>
- <textElement verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{tgl}]]></textFieldExpression>
- </textField>
- <textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
- <reportElement x="392" y="61" width="160" height="16" uuid="7171a395-107c-4926-a392-c42db55599f9"/>
- <textElement verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{namasupp}]]></textFieldExpression>
- </textField>
- <textField isStretchWithOverflow="true" pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
- <reportElement x="392" y="79" width="160" height="16" uuid="08516829-31ac-4f41-95f1-6675f224ff53"/>
- <textElement verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{al}]]></textFieldExpression>
- </textField>
- <image scaleImage="RetainShape">
- <reportElement x="2" y="27" width="280" height="68" uuid="be6d7349-b41f-407b-8745-e125c6d5cf76"/>
- <imageExpression><![CDATA[$P{logo}]]></imageExpression>
- </image>
- <staticText>
- <reportElement x="2" y="1" width="192" height="18" uuid="e356ee47-52c2-47eb-941d-66fbda816897"/>
- <textElement verticalAlignment="Middle">
- <font size="14" isBold="true"/>
- </textElement>
- <text><![CDATA[FAKTUR BELI]]></text>
- </staticText>
- <line>
- <reportElement x="0" y="21" width="555" height="1" uuid="d00b7296-5666-4d30-859a-343a89f7287d"/>
- <graphicElement>
- <pen lineWidth="1.0" lineStyle="Solid"/>
- </graphicElement>
- </line>
- <textField pattern="" isBlankWhenNull="true">
- <reportElement x="310" y="79" width="76" height="16" uuid="ea3f9c8f-85e5-4856-ae10-60616f23a12a"/>
- <textElement verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{al}.length()>0?"Alamat":""]]></textFieldExpression>
- </textField>
- <textField pattern="" isBlankWhenNull="true">
- <reportElement x="387" y="79" width="5" height="16" uuid="2de8cba2-6953-4dfe-b047-942c538dea19"/>
- <textElement verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{al}.length()>0?":":""]]></textFieldExpression>
- </textField>
- <staticText>
- <reportElement x="387" y="27" width="5" height="16" uuid="17435bb6-9753-498b-8c80-1bd34a456ac9"/>
- <textElement verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="387" y="44" width="5" height="16" uuid="b59f7d83-e471-4f25-abd2-4400b0a2925c"/>
- <textElement verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <text><![CDATA[:]]></text>
- </staticText>
- <staticText>
- <reportElement x="387" y="62" width="5" height="16" uuid="f9daefc1-1413-426c-91b6-7b5a5421e80b"/>
- <textElement verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <text><![CDATA[:]]></text>
- </staticText>
- <textField>
- <reportElement x="451" y="2" width="80" height="14" uuid="2ff8f4c7-0497-4904-a2b7-1175e1b3dc0b"/>
- <textElement textAlignment="Right">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
- </textField>
- <textField evaluationTime="Report">
- <reportElement x="534" y="2" width="18" height="14" uuid="775d29c9-8126-4daa-9039-f1bdc7f8f084"/>
- <textElement>
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
- </textField>
- </band>
- </pageHeader>
- <columnHeader>
- <band height="22" splitType="Stretch">
- <line>
- <reportElement x="0" y="1" width="555" height="1" uuid="712c0b48-1aa7-423e-8d6c-7a1df08ee0cd"/>
- <graphicElement>
- <pen lineWidth="3.0" lineStyle="Double"/>
- </graphicElement>
- </line>
- <line>
- <reportElement x="0" y="20" width="555" height="1" uuid="18368983-e278-4a9a-8dd6-7a4530841c1d"/>
- </line>
- <staticText>
- <reportElement x="27" y="3" width="192" height="16" uuid="b2f8fb88-ca9d-4bd2-a328-1078ccf9a8a9"/>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <text><![CDATA[Nama Barang]]></text>
- </staticText>
- <staticText>
- <reportElement x="305" y="3" width="65" height="16" uuid="69fd651a-bb42-4dbb-b4fd-03b0703ec85d"/>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <text><![CDATA[Harga (Rp)]]></text>
- </staticText>
- <staticText>
- <reportElement x="374" y="3" width="40" height="16" uuid="e2177dc2-8bfa-40ff-b72b-68d350829d5b"/>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <text><![CDATA[Disc]]></text>
- </staticText>
- <staticText>
- <reportElement x="417" y="3" width="65" height="16" uuid="53f77b7a-72ea-4f1e-a5ba-a484bb90d733"/>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <text><![CDATA[TPR]]></text>
- </staticText>
- <staticText>
- <reportElement x="485" y="3" width="65" height="16" uuid="4d2b1100-e299-4ca2-ae59-2f9d718bcc29"/>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <text><![CDATA[Jumlah (Rp)]]></text>
- </staticText>
- <staticText>
- <reportElement x="2" y="3" width="22" height="16" uuid="cc759ff5-3029-4f6d-89fc-6b7ab9b1768a"/>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <text><![CDATA[No]]></text>
- </staticText>
- <staticText>
- <reportElement x="222" y="3" width="80" height="16" uuid="38ecdec7-e4a6-41ed-accb-b71c6f7468b3"/>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <text><![CDATA[Qty]]></text>
- </staticText>
- </band>
- </columnHeader>
- <detail>
- <band height="14" splitType="Stretch">
- <textField pattern="" isBlankWhenNull="false">
- <reportElement x="27" y="0" width="192" height="14" uuid="0ab35af8-f7ff-414d-81d6-eb781b1c0a81"/>
- <textElement verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{nama}]]></textFieldExpression>
- </textField>
- <textField pattern="" isBlankWhenNull="false">
- <reportElement x="263" y="0" width="39" height="14" uuid="0b55f266-ae6f-4344-8886-49452dc26b20"/>
- <textElement verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{unitsat}]]></textFieldExpression>
- </textField>
- <textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="false">
- <reportElement x="222" y="0" width="40" height="14" uuid="c77dca68-b121-493d-93fd-7f69f63bd8ab"/>
- <textElement textAlignment="Right" verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{qtysat}]]></textFieldExpression>
- </textField>
- <textField pattern="#,##0;-#,##0" isBlankWhenNull="false">
- <reportElement x="305" y="0" width="65" height="14" uuid="b2b77e07-fa58-44ce-9224-2d11bc11c9a7"/>
- <textElement textAlignment="Right" verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{hargasat}]]></textFieldExpression>
- </textField>
- <textField pattern="#,##0.00 %" isBlankWhenNull="false">
- <reportElement x="374" y="0" width="40" height="14" uuid="47c8524a-a9fb-462a-9024-7172a12a6a97"/>
- <textElement textAlignment="Right" verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{discrabat} / 100]]></textFieldExpression>
- </textField>
- <textField pattern="#,##0;-#,##0" isBlankWhenNull="false">
- <reportElement x="417" y="0" width="65" height="14" uuid="beb06fec-e4b4-4fcd-a26e-c3611fe6f3e6"/>
- <textElement textAlignment="Right" verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{tpr}]]></textFieldExpression>
- </textField>
- <textField pattern="#,##0;-#,##0" isBlankWhenNull="false">
- <reportElement x="485" y="0" width="65" height="14" uuid="b20eb9a6-7f03-4f95-99c7-b0bdf111ebd8"/>
- <textElement textAlignment="Right" verticalAlignment="Middle">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$V{vjumlah}]]></textFieldExpression>
- </textField>
- <textField pattern="" isBlankWhenNull="false">
- <reportElement x="2" y="0" width="22" height="14" uuid="2509d8e8-ce9c-4671-b345-8b6ff5565844"/>
- <textElement textAlignment="Center" verticalAlignment="Middle">
- <font size="8"/>
- </textElement>
- <textFieldExpression><![CDATA[$V{row}]]></textFieldExpression>
- </textField>
- </band>
- </detail>
- <lastPageFooter>
- <band height="128">
- <staticText>
- <reportElement x="372" y="5" width="80" height="16" uuid="ef397246-f84a-41dc-a887-5607c40382b8"/>
- <textElement>
- <font size="9"/>
- </textElement>
- <text><![CDATA[Sub Total]]></text>
- </staticText>
- <staticText>
- <reportElement x="372" y="22" width="80" height="16" uuid="2e176f29-b9af-4841-a2f7-c8e97c4c8135"/>
- <textElement>
- <font size="9"/>
- </textElement>
- <text><![CDATA[Disc I]]></text>
- </staticText>
- <staticText>
- <reportElement x="372" y="39" width="80" height="16" uuid="7bd63482-eb19-46be-9ce1-3e83c7a28666"/>
- <textElement>
- <font size="9"/>
- </textElement>
- <text><![CDATA[Disc II]]></text>
- </staticText>
- <staticText>
- <reportElement x="372" y="56" width="80" height="16" uuid="6ba40473-9efb-42e3-8b49-0d2c32ba84bd"/>
- <textElement>
- <font size="9"/>
- </textElement>
- <text><![CDATA[Total (Rp)]]></text>
- </staticText>
- <textField pattern="#,##0;-#,##0" isBlankWhenNull="false">
- <reportElement x="453" y="5" width="97" height="16" uuid="39e60371-53d2-42ff-a1b3-fa289ccc5faa"/>
- <textElement textAlignment="Right" verticalAlignment="Top">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$V{vjumlah_1}]]></textFieldExpression>
- </textField>
- <textField pattern="#,##0;-#,##0" isBlankWhenNull="false">
- <reportElement x="453" y="22" width="97" height="16" uuid="e3279093-5beb-490a-9954-aad866ed208c"/>
- <textElement textAlignment="Right" verticalAlignment="Top">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$V{vdisc_1}]]></textFieldExpression>
- </textField>
- <textField pattern="#,##0;-#,##0" isBlankWhenNull="false">
- <reportElement x="453" y="39" width="97" height="16" uuid="dee8ff0b-0d27-477a-863e-db5b99439845"/>
- <textElement textAlignment="Right" verticalAlignment="Top">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$V{vdisc2_1}]]></textFieldExpression>
- </textField>
- <textField pattern="#,##0;-#,##0" isBlankWhenNull="false">
- <reportElement x="453" y="56" width="97" height="16" uuid="ec2611a0-cf0f-4d7a-a2e8-5e6118a057cd"/>
- <textElement textAlignment="Right" verticalAlignment="Top">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$V{vtotal_1}]]></textFieldExpression>
- </textField>
- <textField pattern="#,##0.00 %" isBlankWhenNull="false">
- <reportElement x="411" y="22" width="41" height="16" uuid="965e2945-b343-460a-828b-eac780c28ca8"/>
- <textElement textAlignment="Right" verticalAlignment="Top">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{disc} / 100]]></textFieldExpression>
- </textField>
- <textField pattern="#,##0.00 %" isBlankWhenNull="false">
- <reportElement x="411" y="39" width="41" height="16" uuid="a28f67a4-9bb2-449d-9792-ef888234d4c2"/>
- <textElement textAlignment="Right" verticalAlignment="Top">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{disc2} / 100]]></textFieldExpression>
- </textField>
- <line>
- <reportElement x="0" y="1" width="555" height="1" uuid="7218a967-5775-4e45-a4e9-c7917c119aa7"/>
- </line>
- <staticText>
- <reportElement x="7" y="5" width="80" height="16" uuid="bd570a03-b519-47d2-9b59-154ce7f94bd6"/>
- <textElement textAlignment="Center">
- <font size="9"/>
- </textElement>
- <text><![CDATA[Tanda Terima]]></text>
- </staticText>
- <staticText>
- <reportElement x="120" y="6" width="80" height="16" uuid="8d7bc0ef-168b-4d05-a504-9b1f66264f87"/>
- <textElement textAlignment="Center">
- <font size="9"/>
- </textElement>
- <text><![CDATA[Hormat Kami]]></text>
- </staticText>
- <staticText>
- <reportElement x="241" y="72" width="80" height="16" uuid="2cd0a1f6-ef37-42ad-a8f5-745fb91c51ec"/>
- <textElement textAlignment="Center">
- <font size="9"/>
- </textElement>
- <text><![CDATA[KA Gudang]]></text>
- </staticText>
- <line>
- <reportElement x="230" y="69" width="100" height="1" uuid="95aa3efa-3cf2-40f4-ba46-0a4a7fddaea0"/>
- </line>
- <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
- <reportElement x="2" y="88" width="173" height="14" uuid="84d3ae37-de0c-472d-b800-b0a25c9eee81"/>
- <textElement verticalAlignment="Top">
- <font size="9"/>
- </textElement>
- <textFieldExpression><![CDATA[$F{memo}==null || $F{memo}.equals("") ? "" : "MEMO: " + $F{memo}]]></textFieldExpression>
- </textField>
- </band>
- </lastPageFooter>
- </jasperReport>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement