diff options
Diffstat (limited to 'jasper_reports/custom_reports')
| -rw-r--r-- | jasper_reports/custom_reports/BReceipt.jrxml | 413 |
1 files changed, 413 insertions, 0 deletions
diff --git a/jasper_reports/custom_reports/BReceipt.jrxml b/jasper_reports/custom_reports/BReceipt.jrxml new file mode 100644 index 0000000..546cef0 --- /dev/null +++ b/jasper_reports/custom_reports/BReceipt.jrxml @@ -0,0 +1,413 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- Created with Jaspersoft Studio version 6.20.5.final using JasperReports Library version 6.20.5-3efcf2e67f959db3888d79f73dde2dbd7acb4f8e --> +<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="BillReceipt" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="720bbad4-adde-4374-87d8-52060d7fa3c7"> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Revisi Bill Receipt1"/> + <property name="ODOO_RELATIONS"> + <![CDATA[['bill_line']]]> + </property> + <queryString language="XPath"> + <![CDATA[]]> + </queryString> + <field name="Total_Amount-total_amt" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Total_Amount-total_amt"/> + <fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Total_Amount-total_amt]]></fieldDescription> + </field> + <field name="Open_Amount-open_amt" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Open_Amount-open_amt"/> + <fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Open_Amount-open_amt]]></fieldDescription> + </field> + <field name="Reference-ref" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Reference-ref"/> + <fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Reference-ref]]></fieldDescription> + </field> + <field name="Invoice_Bill_Date-invoice_date" class="java.sql.Date"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Invoice_Bill_Date-invoice_date"/> + <fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Invoice_Bill_Date-invoice_date]]></fieldDescription> + </field> + <field name="Due_Date-invoice_date_due" class="java.sql.Date"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Due_Date-invoice_date_due"/> + <fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Due_Date-invoice_date_due]]></fieldDescription> + </field> + <field name="Outstanding_Amount-outstanding_amount" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Outstanding_Amount-outstanding_amount"/> + <fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Outstanding_Amount-outstanding_amount]]></fieldDescription> + </field> + <field name="Number-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Number-name"/> + <fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Number-name]]></fieldDescription> + </field> + <field name="Name-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Customer-partner_id/Name-name"/> + <fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Customer-partner_id/Name-name]]></fieldDescription> + </field> + <field name="Total-amount_total" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Total-amount_total"/> + <fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Total-amount_total]]></fieldDescription> + </field> + <field name="eFaktur_Number-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Faktur_Pajak-efaktur_id/eFaktur_Number-name"/> + <fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Faktur_Pajak-efaktur_id/eFaktur_Number-name]]></fieldDescription> + </field> + <field name="Name-name_1" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Vendor-partner_id/Name-name"/> + <fieldDescription><![CDATA[/data/record/Vendor-partner_id/Name-name]]></fieldDescription> + </field> + <field name="Document_No-number" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Document_No-number"/> + <fieldDescription><![CDATA[/data/record/Document_No-number]]></fieldDescription> + </field> + <field name="Jadwal_Pembayaran-payment_schedule" class="java.sql.Date"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Jadwal_Pembayaran-payment_schedule"/> + <fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Jadwal_Pembayaran-payment_schedule]]></fieldDescription> + </field> + <field name="Jadwal_Pembayaran-payment_schedule_1" class="java.sql.Date"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Jadwal_Pembayaran-payment_schedule"/> + <fieldDescription><![CDATA[/data/record/Bill_Receipt_Lines-bill_line/Invoice-invoice_id/Jadwal_Pembayaran-payment_schedule]]></fieldDescription> + </field> + <variable name="total" class="java.math.BigDecimal"> + <variableExpression><![CDATA[new BigDecimal($F{Total_Amount-total_amt})]]></variableExpression> + </variable> + <variable name="grand_total" class="java.math.BigDecimal" calculation="Sum"> + <variableExpression><![CDATA[$V{total}]]></variableExpression> + </variable> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="140" splitType="Stretch"> + <staticText> + <reportElement x="0" y="0" width="280" height="70" uuid="a8a7304c-4b3e-49e1-b120-a5482251cfbf"/> + <text><![CDATA[PT. INDOTEKNIK DOTCOM GEMILANG +Jl. Bandengan Utara 85A No 8-9 RT 3/RW 16 +Penjaringan, Kec. Penjaringan, Jakarta +JK 14440 +Indonesia]]></text> + </staticText> + <staticText> + <reportElement x="0" y="80" width="550" height="30" uuid="e40afd9c-a77c-43cc-bbda-2e4651a833cc"/> + <textElement textAlignment="Center" verticalAlignment="Top"> + <font size="16" isBold="true"/> + </textElement> + <text><![CDATA[Tanda Tukar Faktur]]></text> + </staticText> + <staticText> + <reportElement x="0" y="110" width="550" height="30" uuid="5a989cb1-5c5d-449f-bc25-ca27fd30e4dd"/> + <textElement textAlignment="Center" verticalAlignment="Top"> + <font size="12" isBold="true"/> + </textElement> + <text><![CDATA[PT. INDOTEKNIK DOTCOM GEMILANG]]></text> + </staticText> + </band> + </title> + <pageHeader> + <band height="30" splitType="Stretch"> + <staticText> + <reportElement x="0" y="0" width="70" height="30" uuid="1f1275e3-7af0-4c59-88d9-26d4b35588ae"/> + <textElement textAlignment="Center" verticalAlignment="Top"> + <font isBold="true"/> + </textElement> + <text><![CDATA[Vendor : ]]></text> + </staticText> + <textField> + <reportElement x="70" y="0" width="290" height="30" uuid="04c27126-9fe1-4408-8dbf-cfced8e02aca"/> + <textElement textAlignment="Left" verticalAlignment="Top"> + <font isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[$F{Name-name_1}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="360" y="0" width="70" height="30" uuid="7fc8428e-9d84-46bc-a596-d2b1b1b2d911"/> + <textElement textAlignment="Right" verticalAlignment="Top"/> + <text><![CDATA[Document No : ]]></text> + </staticText> + <textField> + <reportElement x="430" y="0" width="120" height="30" uuid="39b75cc4-fa56-4c67-9896-ee9eafbbc638"/> + <textElement textAlignment="Right" verticalAlignment="Top"/> + <textFieldExpression><![CDATA[$F{Document_No-number}]]></textFieldExpression> + </textField> + </band> + </pageHeader> + <columnHeader> + <band height="20" splitType="Stretch"> + <staticText> + <reportElement x="0" y="0" width="20" height="20" uuid="c3f04a2c-0071-4f3a-9027-fbba4d0fc428"/> + <box> + <pen lineWidth="1.0"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[No]]></text> + </staticText> + <staticText> + <reportElement x="20" y="0" width="90" height="20" uuid="bb1978fb-f5ab-4c6e-9967-9164b8406d8a"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/> + </reportElement> + <box> + <pen lineWidth="1.0"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Invoice]]></text> + </staticText> + <staticText> + <reportElement x="110" y="0" width="70" height="20" uuid="c07c62fa-9d20-4f87-98ee-9765952b1e6d"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3a258e3c-10cd-4b66-9918-3fc9abcac5e1"/> + </reportElement> + <box> + <pen lineWidth="1.0"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Invoice Date]]></text> + </staticText> + <staticText> + <reportElement x="180" y="0" width="110" height="20" uuid="4b8b5ced-c7d1-4553-add0-a96f016d9204"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/> + </reportElement> + <box> + <pen lineWidth="1.0"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Reference]]></text> + </staticText> + <staticText> + <reportElement x="460" y="0" width="90" height="20" uuid="4b55a424-baaa-4c60-90a6-fb87db30dc88"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/> + </reportElement> + <box> + <pen lineWidth="1.0"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Total]]></text> + </staticText> + <staticText> + <reportElement x="290" y="0" width="60" height="20" uuid="ae0915e4-83a8-4945-9ce1-d560303bf41c"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="289181ee-1809-46e9-8ad9-2b44772e6161"/> + </reportElement> + <box> + <pen lineWidth="1.0"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Due]]></text> + </staticText> + <staticText> + <reportElement x="350" y="0" width="110" height="20" uuid="9149a1c2-4f0e-4b92-a2a1-75298c9f3528"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/> + </reportElement> + <box> + <pen lineWidth="0.5"/> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Payment Schedule]]></text> + </staticText> + </band> + </columnHeader> + <detail> + <band height="21" splitType="Stretch"> + <textField> + <reportElement x="0" y="0" width="20" height="20" uuid="630906d2-6d59-4224-ba90-fdc6e07dec7b"/> + <box> + <pen lineWidth="1.0"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="20" y="0" width="90" height="20" uuid="0a33350c-f826-4f92-b409-7f2b1eea58c6"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/> + </reportElement> + <box> + <pen lineWidth="1.0"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Number-name}]]></textFieldExpression> + </textField> + <textField pattern="MMM d, yyyy"> + <reportElement x="110" y="0" width="70" height="20" uuid="b9715916-74c1-4892-8883-b681f7baf4cb"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3a258e3c-10cd-4b66-9918-3fc9abcac5e1"/> + </reportElement> + <box> + <pen lineWidth="1.0"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Invoice_Bill_Date-invoice_date}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="180" y="0" width="110" height="20" uuid="8c5d0138-c176-487d-9d12-1cb2b77a6609"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/> + </reportElement> + <box> + <pen lineWidth="1.0"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Reference-ref}]]></textFieldExpression> + </textField> + <textField pattern="#,#00.00#;(#,#00.00#-)"> + <reportElement x="460" y="0" width="90" height="20" uuid="5d81a73c-3e98-45c0-a541-e5c299e2b8cd"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/> + </reportElement> + <box> + <pen lineWidth="1.0"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$V{total}]]></textFieldExpression> + </textField> + <textField pattern="MMM d, yyyy"> + <reportElement x="290" y="0" width="60" height="20" uuid="ce215c7b-d245-4bbd-9f91-01a07b09c8e7"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="289181ee-1809-46e9-8ad9-2b44772e6161"/> + </reportElement> + <box> + <pen lineWidth="1.0"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Due_Date-invoice_date_due}]]></textFieldExpression> + </textField> + <textField pattern="MMM d, yyyy"> + <reportElement x="350" y="0" width="110" height="20" uuid="8a069a2b-e5e7-4664-9ca4-e8ede6b1c664"/> + <box> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Jadwal_Pembayaran-payment_schedule_1}]]></textFieldExpression> + </textField> + </band> + </detail> + <pageFooter> + <band height="10" splitType="Stretch"> + <textField evaluationTime="Report"> + <reportElement x="470" y="0" width="30" height="10" uuid="b4e2c64a-ca50-4b8e-b38e-5ff236c9cf4f"/> + <textElement textAlignment="Center"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="451" y="0" width="19" height="10" uuid="0c34157a-cc68-4789-aef9-957a96ab8a97"/> + <textElement textAlignment="Center"> + <font size="8"/> + </textElement> + <text><![CDATA[dari]]></text> + </staticText> + <textField> + <reportElement x="421" y="0" width="30" height="10" uuid="9deade00-e339-411d-9187-5e18dbba9d24"/> + <textElement textAlignment="Center"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="382" y="0" width="39" height="10" uuid="aefef729-4eae-4f92-9c66-30a7a53f55d0"/> + <textElement textAlignment="Center"> + <font size="8"/> + </textElement> + <text><![CDATA[Halaman]]></text> + </staticText> + </band> + </pageFooter> + <summary> + <band height="160" splitType="Stretch"> + <textField pattern="#,#00.###;(#,#00.###-)"> + <reportElement x="460" y="0" width="90" height="20" uuid="12f22b10-d8f4-4f94-b2d0-993fda701e9e"/> + <box> + <pen lineWidth="1.0"/> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$V{grand_total}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="400" y="0" width="60" height="20" uuid="4a2c174b-a7a3-4620-8bd3-6dd57eee600d"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/> + </reportElement> + <box> + <pen lineWidth="0.5"/> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Total]]></text> + </staticText> + <staticText> + <reportElement x="60" y="31" width="90" height="107" uuid="a5d971ef-fa8e-4ced-b7b9-cf3861e26a2d"/> + <text><![CDATA[Yang menyerahkan + + + + +( ) + Nama Jelas]]></text> + </staticText> + <staticText> + <reportElement x="370" y="31" width="110" height="19" uuid="2d02021f-ffd3-4694-917d-0bf584038278"/> + <text><![CDATA[Yang menerima, + + + + +]]></text> + </staticText> + <image> + <reportElement x="361" y="51" width="126" height="59" uuid="7ddbd82e-5e16-4e91-8220-26b35cef48db"/> + <imageExpression><![CDATA["https://erp.indoteknik.com/api/image/ir.attachment/datas/2011786"]]></imageExpression> + </image> + <staticText> + <reportElement x="378" y="110" width="82" height="28" uuid="526748bf-97a4-470e-a0a9-4530098f3048"/> + <textElement textAlignment="Center"/> + <text><![CDATA[( ) Nama Jelas]]></text> + </staticText> + </band> + </summary> +</jasperReport> |