summaryrefslogtreecommitdiff
path: root/jasper_reports
diff options
context:
space:
mode:
Diffstat (limited to 'jasper_reports')
-rw-r--r--jasper_reports/custom_reports/DunningRun.jrxml431
1 files changed, 431 insertions, 0 deletions
diff --git a/jasper_reports/custom_reports/DunningRun.jrxml b/jasper_reports/custom_reports/DunningRun.jrxml
new file mode 100644
index 0000000..27755fd
--- /dev/null
+++ b/jasper_reports/custom_reports/DunningRun.jrxml
@@ -0,0 +1,431 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!-- Created with Jaspersoft Studio version 6.20.0.final using JasperReports Library version 6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad -->
+<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="DunningRun" 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="Dunning Run"/>
+ <property name="ODOO_RELATIONS">
+ <![CDATA[['dunning_line']]]>
+ </property>
+ <queryString language="XPath">
+ <![CDATA[]]>
+ </queryString>
+ <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="customer_name" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Customer-partner_id/Name-name"/>
+ <fieldDescription><![CDATA[/data/record/Customer-partner_id/Name-name]]></fieldDescription>
+ </field>
+ <field name="customer_name_line" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Dunning_Lines-dunning_line/Customer-partner_id/Name-name"/>
+ <fieldDescription><![CDATA[/data/record/Dunning_Lines-dunning_line/Customer-partner_id/Name-name]]></fieldDescription>
+ </field>
+ <field name="invoice_number" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Dunning_Lines-dunning_line/Invoice-invoice_id/Number-name"/>
+ <fieldDescription><![CDATA[/data/record/Dunning_Lines-dunning_line/Invoice-invoice_id/Number-name]]></fieldDescription>
+ </field>
+ <field name="invoice_date" class="java.sql.Date">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Dunning_Lines-dunning_line/Invoice-invoice_id/Invoice_Bill_Date-invoice_date"/>
+ <fieldDescription><![CDATA[/data/record/Dunning_Lines-dunning_line/Invoice-invoice_id/Invoice_Bill_Date-invoice_date]]></fieldDescription>
+ </field>
+ <field name="eFaktur_Number-name" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Dunning_Lines-dunning_line/Invoice-invoice_id/Faktur_Pajak-efaktur_id/eFaktur_Number-name"/>
+ <fieldDescription><![CDATA[/data/record/Dunning_Lines-dunning_line/Invoice-invoice_id/Faktur_Pajak-efaktur_id/eFaktur_Number-name]]></fieldDescription>
+ </field>
+ <field name="Reference-ref" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Dunning_Lines-dunning_line/Invoice-invoice_id/Reference-ref"/>
+ <fieldDescription><![CDATA[/data/record/Dunning_Lines-dunning_line/Invoice-invoice_id/Reference-ref]]></fieldDescription>
+ </field>
+ <field name="Total-amount_total" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Dunning_Lines-dunning_line/Invoice-invoice_id/Total-amount_total"/>
+ <fieldDescription><![CDATA[/data/record/Dunning_Lines-dunning_line/Invoice-invoice_id/Total-amount_total]]></fieldDescription>
+ </field>
+ <field name="Outstanding_Amount-outstanding_amount" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Dunning_Lines-dunning_line/Invoice-invoice_id/Outstanding_Amount-outstanding_amount"/>
+ <fieldDescription><![CDATA[/data/record/Dunning_Lines-dunning_line/Invoice-invoice_id/Outstanding_Amount-outstanding_amount]]></fieldDescription>
+ </field>
+ <field name="Due_Date-invoice_date_due" class="java.sql.Date">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Dunning_Lines-dunning_line/Invoice-invoice_id/Due_Date-invoice_date_due"/>
+ <fieldDescription><![CDATA[/data/record/Dunning_Lines-dunning_line/Invoice-invoice_id/Due_Date-invoice_date_due]]></fieldDescription>
+ </field>
+ <field name="open_amt_line" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Dunning_Lines-dunning_line/Open_Amount-open_amt"/>
+ <fieldDescription><![CDATA[/data/record/Dunning_Lines-dunning_line/Open_Amount-open_amt]]></fieldDescription>
+ </field>
+ <field name="total_amt_line" class="java.lang.String">
+ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Dunning_Lines-dunning_line/Total_Amount-total_amt"/>
+ <fieldDescription><![CDATA[/data/record/Dunning_Lines-dunning_line/Total_Amount-total_amt]]></fieldDescription>
+ </field>
+ <variable name="total" class="java.math.BigDecimal">
+ <variableExpression><![CDATA[new BigDecimal($F{total_amt_line})]]></variableExpression>
+ </variable>
+ <variable name="outstanding" class="java.math.BigDecimal">
+ <variableExpression><![CDATA[new BigDecimal($F{open_amt_line})]]></variableExpression>
+ </variable>
+ <variable name="total_outstanding" class="java.math.BigDecimal" calculation="Sum">
+ <variableExpression><![CDATA[$V{outstanding}]]></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="110" width="550" height="30" uuid="e40afd9c-a77c-43cc-bbda-2e4651a833cc"/>
+ <textElement textAlignment="Center" verticalAlignment="Top">
+ <font size="16" isBold="true"/>
+ </textElement>
+ <text><![CDATA[Tanda Terima Faktur]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="390" y="10" width="140" height="80" uuid="25d02f1d-cc50-4b6f-9ce0-209951f96d7f"/>
+ <box>
+ <topPen lineWidth="0.5"/>
+ <leftPen lineWidth="0.5"/>
+ <bottomPen lineWidth="0.5"/>
+ <rightPen lineWidth="0.5"/>
+ </box>
+ <textElement textAlignment="Center" verticalAlignment="Top">
+ <font size="8" isBold="true"/>
+ </textElement>
+ <text><![CDATA[Note:
+Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto untuk dikirimkan ke kami melalui email finance@indoteknik.co.id atau melalui WA di +62 882-1961-6220]]></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="Left" verticalAlignment="Top">
+ <font isBold="true"/>
+ </textElement>
+ <text><![CDATA[Tagihan Ke : ]]></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{customer_name}]]></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>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement verticalAlignment="Middle">
+ <font size="8" isBold="true"/>
+ </textElement>
+ <text><![CDATA[No]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="20" y="0" width="80" height="20" uuid="bb1978fb-f5ab-4c6e-9967-9164b8406d8a">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/>
+ </reportElement>
+ <box>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement verticalAlignment="Middle">
+ <font size="8" isBold="true"/>
+ </textElement>
+ <text><![CDATA[Invoice]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="100" y="0" width="60" height="20" uuid="c07c62fa-9d20-4f87-98ee-9765952b1e6d">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3a258e3c-10cd-4b66-9918-3fc9abcac5e1"/>
+ </reportElement>
+ <box>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement verticalAlignment="Middle">
+ <font size="8" isBold="true"/>
+ </textElement>
+ <text><![CDATA[Invoice Date]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="160" y="0" width="100" height="20" uuid="fd89030d-6c15-45d1-9b22-1801e7b46d69">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="69ab7207-5108-44e3-b756-df99df8c269a"/>
+ </reportElement>
+ <box>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement verticalAlignment="Middle">
+ <font size="8" isBold="true"/>
+ </textElement>
+ <text><![CDATA[Faktur]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="260" y="0" width="80" height="20" uuid="4b8b5ced-c7d1-4553-add0-a96f016d9204">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/>
+ </reportElement>
+ <box>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement verticalAlignment="Middle">
+ <font size="8" isBold="true"/>
+ </textElement>
+ <text><![CDATA[Reference]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="400" y="0" width="70" height="20" uuid="4b55a424-baaa-4c60-90a6-fb87db30dc88">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/>
+ </reportElement>
+ <box>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement textAlignment="Right" verticalAlignment="Middle">
+ <font size="8" isBold="true"/>
+ </textElement>
+ <text><![CDATA[Total]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="340" 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>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement verticalAlignment="Middle">
+ <font size="8" isBold="true"/>
+ </textElement>
+ <text><![CDATA[Due]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="470" y="0" width="80" height="20" uuid="d1815f0c-d3fe-412f-a92f-e33ddfc65f7f">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c2e05b8e-e9c7-4c0a-80c8-9592982cd2a4"/>
+ </reportElement>
+ <box>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement textAlignment="Right" verticalAlignment="Middle">
+ <font size="8" isBold="true"/>
+ </textElement>
+ <text><![CDATA[Outstanding]]></text>
+ </staticText>
+ </band>
+ </columnHeader>
+ <detail>
+ <band height="20" splitType="Stretch">
+ <textField>
+ <reportElement x="0" y="0" width="20" height="20" uuid="630906d2-6d59-4224-ba90-fdc6e07dec7b"/>
+ <box>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement verticalAlignment="Middle">
+ <font size="8"/>
+ </textElement>
+ <textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression>
+ </textField>
+ <textField>
+ <reportElement x="20" y="0" width="80" height="20" uuid="0a33350c-f826-4f92-b409-7f2b1eea58c6">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/>
+ </reportElement>
+ <box>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement verticalAlignment="Middle">
+ <font size="8"/>
+ </textElement>
+ <textFieldExpression><![CDATA[$F{invoice_number}]]></textFieldExpression>
+ </textField>
+ <textField pattern="MMM d, yyyy">
+ <reportElement x="100" y="0" width="60" height="20" uuid="b9715916-74c1-4892-8883-b681f7baf4cb">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3a258e3c-10cd-4b66-9918-3fc9abcac5e1"/>
+ </reportElement>
+ <box>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement verticalAlignment="Middle">
+ <font size="8"/>
+ </textElement>
+ <textFieldExpression><![CDATA[$F{invoice_date}]]></textFieldExpression>
+ </textField>
+ <textField>
+ <reportElement x="160" y="0" width="100" height="20" uuid="4830ecbf-9739-4431-b0b8-3f1feb3b1f4d">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="69ab7207-5108-44e3-b756-df99df8c269a"/>
+ </reportElement>
+ <box>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement textAlignment="Left" verticalAlignment="Middle">
+ <font size="8"/>
+ </textElement>
+ <textFieldExpression><![CDATA[$F{eFaktur_Number-name}]]></textFieldExpression>
+ </textField>
+ <textField>
+ <reportElement x="260" y="0" width="80" height="20" uuid="8c5d0138-c176-487d-9d12-1cb2b77a6609">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/>
+ </reportElement>
+ <box>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement verticalAlignment="Middle">
+ <font size="8"/>
+ </textElement>
+ <textFieldExpression><![CDATA[$F{Reference-ref}]]></textFieldExpression>
+ </textField>
+ <textField pattern="#,#00.00#;(#,#00.00#-)">
+ <reportElement x="400" y="0" width="70" height="20" uuid="5d81a73c-3e98-45c0-a541-e5c299e2b8cd">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/>
+ </reportElement>
+ <box>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement textAlignment="Right" verticalAlignment="Middle">
+ <font size="8"/>
+ </textElement>
+ <textFieldExpression><![CDATA[$V{total}]]></textFieldExpression>
+ </textField>
+ <textField pattern="MMM d, yyyy">
+ <reportElement x="340" 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>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement verticalAlignment="Middle">
+ <font size="8"/>
+ </textElement>
+ <textFieldExpression><![CDATA[$F{Due_Date-invoice_date_due}]]></textFieldExpression>
+ </textField>
+ <textField pattern="#,#00.00#;(#,#00.00#-)">
+ <reportElement x="470" y="0" width="80" height="20" uuid="e8bea303-7a64-4452-8cbd-2ae15b382da3">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="fad2b8be-b9d1-4265-8d32-1982c00d5eb8"/>
+ </reportElement>
+ <box>
+ <bottomPen lineWidth="0.5"/>
+ </box>
+ <textElement textAlignment="Right" verticalAlignment="Middle">
+ <font size="8"/>
+ </textElement>
+ <textFieldExpression><![CDATA[$V{outstanding}]]></textFieldExpression>
+ </textField>
+ </band>
+ </detail>
+ <pageFooter>
+ <band height="10" splitType="Stretch">
+ <textField evaluationTime="Report">
+ <reportElement x="520" 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="501" y="0" width="19" height="10" uuid="0c34157a-cc68-4789-aef9-957a96ab8a97"/>
+ <textElement>
+ <font size="8"/>
+ </textElement>
+ <text><![CDATA[dari]]></text>
+ </staticText>
+ <textField>
+ <reportElement x="471" 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="432" y="0" width="39" height="10" uuid="aefef729-4eae-4f92-9c66-30a7a53f55d0"/>
+ <textElement>
+ <font size="8"/>
+ </textElement>
+ <text><![CDATA[Halaman]]></text>
+ </staticText>
+ </band>
+ </pageFooter>
+ <summary>
+ <band height="160" splitType="Stretch">
+ <textField pattern="#,#00.###;(#,#00.###-)">
+ <reportElement x="470" y="0" width="80" height="20" uuid="12f22b10-d8f4-4f94-b2d0-993fda701e9e"/>
+ <box>
+ <leftPen lineWidth="0.0"/>
+ <bottomPen lineWidth="0.0"/>
+ <rightPen lineWidth="0.0"/>
+ </box>
+ <textElement textAlignment="Right" verticalAlignment="Middle">
+ <font size="8"/>
+ </textElement>
+ <textFieldExpression><![CDATA[$V{total_outstanding}]]></textFieldExpression>
+ </textField>
+ <staticText>
+ <reportElement x="0" y="0" width="470" height="20" uuid="4a2c174b-a7a3-4620-8bd3-6dd57eee600d">
+ <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/>
+ </reportElement>
+ <box>
+ <leftPen lineWidth="0.0"/>
+ <bottomPen lineWidth="0.0"/>
+ <rightPen lineWidth="0.0"/>
+ </box>
+ <textElement textAlignment="Right" verticalAlignment="Middle">
+ <font size="8" isBold="true"/>
+ </textElement>
+ <text><![CDATA[Total]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="10" y="30" width="199" height="130" uuid="7d2dc014-9b7c-404a-a476-e78ae798ee4e"/>
+ <box>
+ <topPen lineWidth="0.0"/>
+ <leftPen lineWidth="0.0"/>
+ <bottomPen lineWidth="0.0"/>
+ <rightPen lineWidth="0.0"/>
+ </box>
+ <textElement textAlignment="Left" verticalAlignment="Top">
+ <font size="10"/>
+ </textElement>
+ <text><![CDATA[Pembayaran melalui Transfer ke :
+
+BCA
+PT. Indoteknik Dotcom Gemilang
+8870-4000-81
+
+Mandiri
+PT. Indoteknik Dotcom Gemilang
+155-0067-6869-75]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="440" y="31" width="90" height="107" uuid="a5d971ef-fa8e-4ced-b7b9-cf3861e26a2d"/>
+ <text><![CDATA[Yang menerima,
+
+
+
+
+( )
+ Nama Jelas]]></text>
+ </staticText>
+ <staticText>
+ <reportElement x="240" y="31" width="110" height="108" uuid="2d02021f-ffd3-4694-917d-0bf584038278"/>
+ <text><![CDATA[Yang menyerahkan,
+
+
+
+
+( )
+ Nama Jelas]]></text>
+ </staticText>
+ </band>
+ </summary>
+</jasperReport>
generated by cgit v1.2.3 (git 2.25.1) at 2026-04-17 18:59:53 +0000