add custom report collective

1 files changed, 370 insertions, 0 deletions

diff --git a/jasper_reports/custom_reports/invoice12%.jrxml b/jasper_reports/custom_reports/invoice12%.jrxml
new file mode 100644
index 0000000..10d2a6e
--- /dev/null
+++ b/jasper_reports/custom_reports/invoice12%.jrxml
@@ -0,0 +1,370 @@
+<?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="invoice12%" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="12f67cdd-0b84-4892-a94d-f7483f2af7b2">
+	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="invoice12%.jrdax"/>
+	<property name="ODOO_RELATIONS">
+		<![CDATA[['invoice_line_ids']]]>
+	</property>
+	<queryString language="XPath">
+		<![CDATA[]]>
+	</queryString>
+	<field name="Nama Customer" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Partner-partner_id/Display_Name-display_name"/>
+		<fieldDescription><![CDATA[/data/record/Partner-partner_id/Display_Name-display_name]]></fieldDescription>
+	</field>
+	<field name="Alamat Customer" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Partner-partner_id/Street-street"/>
+		<fieldDescription><![CDATA[/data/record/Partner-partner_id/Street-street]]></fieldDescription>
+	</field>
+	<field name="No Dokumen" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Display_Name-display_name"/>
+		<fieldDescription><![CDATA[/data/record/Display_Name-display_name]]></fieldDescription>
+	</field>
+	<field name="Invoice Date" class="java.sql.Date">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Invoice_Bill_Date-invoice_date"/>
+		<fieldDescription><![CDATA[/data/record/Invoice_Bill_Date-invoice_date]]></fieldDescription>
+	</field>
+	<field name="Invoice Due Date" class="java.sql.Date">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Due_Date-invoice_date_due"/>
+		<fieldDescription><![CDATA[/data/record/Due_Date-invoice_date_due]]></fieldDescription>
+	</field>
+	<field name="Source" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Origin-invoice_origin"/>
+		<fieldDescription><![CDATA[/data/record/Origin-invoice_origin]]></fieldDescription>
+	</field>
+	<field name="Reference" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Reference-ref"/>
+		<fieldDescription><![CDATA[/data/record/Reference-ref]]></fieldDescription>
+	</field>
+	<field name="Product" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Invoice_lines-invoice_line_ids/Product-product_id/Display_Name-display_name"/>
+		<fieldDescription><![CDATA[/data/record/Invoice_lines-invoice_line_ids/Product-product_id/Display_Name-display_name]]></fieldDescription>
+	</field>
+	<field name="Quantity" class="java.lang.Integer">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Invoice_lines-invoice_line_ids/Quantity-quantity"/>
+		<fieldDescription><![CDATA[/data/record/Invoice_lines-invoice_line_ids/Quantity-quantity]]></fieldDescription>
+	</field>
+	<field name="Price Unit" class="java.math.BigDecimal">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Invoice_lines-invoice_line_ids/Unit_Price-price_unit"/>
+		<fieldDescription><![CDATA[/data/record/Invoice_lines-invoice_line_ids/Unit_Price-price_unit]]></fieldDescription>
+	</field>
+	<field name="Amount" class="java.math.BigDecimal">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Invoice_lines-invoice_line_ids/Subtotal-price_subtotal"/>
+		<fieldDescription><![CDATA[/data/record/Invoice_lines-invoice_line_ids/Subtotal-price_subtotal]]></fieldDescription>
+	</field>
+	<field name="Amount Untaxed" class="java.math.BigDecimal">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Untaxed_Amount-amount_untaxed"/>
+		<fieldDescription><![CDATA[/data/record/Untaxed_Amount-amount_untaxed]]></fieldDescription>
+	</field>
+	<field name="Taxes" class="java.math.BigDecimal">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Tax_amount_by_group-amount_by_group"/>
+		<fieldDescription><![CDATA[/data/record/Tax_amount_by_group-amount_by_group]]></fieldDescription>
+	</field>
+	<field name="Total" class="java.math.BigDecimal">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Total-amount_total"/>
+		<fieldDescription><![CDATA[/data/record/Total-amount_total]]></fieldDescription>
+	</field>
+	<field name="Discount" class="java.math.BigDecimal">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Invoice_lines-invoice_line_ids/Discount____-discount"/>
+		<fieldDescription><![CDATA[/data/record/Invoice_lines-invoice_line_ids/Discount____-discount]]></fieldDescription>
+	</field>
+	<variable name="Subtotal" class="java.math.BigDecimal">
+		<variableExpression><![CDATA[new BigDecimal($F{Amount Untaxed})]]></variableExpression>
+	</variable>
+	<variable name="Taxes" class="java.math.BigDecimal">
+		<variableExpression><![CDATA[new BigDecimal($F{Taxes})]]></variableExpression>
+	</variable>
+	<variable name="Total" class="java.math.BigDecimal">
+		<variableExpression><![CDATA[new BigDecimal($F{Total})]]></variableExpression>
+	</variable>
+	<background>
+		<band splitType="Stretch"/>
+	</background>
+	<title>
+		<band height="254" splitType="Stretch">
+			<staticText>
+				<reportElement x="0" y="35" width="270" height="70" uuid="ee1a68f8-cba4-4c99-ac0d-3988cca4506f"/>
+				<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>
+			<image>
+				<reportElement x="0" y="1" width="126" height="33" uuid="b45877a5-889b-4222-aa95-84d91f27cef4"/>
+				<imageExpression><![CDATA["https://erp.indoteknik.com/api/image/ir.attachment/datas/2135765"]]></imageExpression>
+			</image>
+			<line>
+				<reportElement x="-3" y="34" width="560" height="1" uuid="bb509eb2-3502-4be6-952b-1f8cc66258ba"/>
+			</line>
+			<textField>
+				<reportElement x="345" y="81" width="210" height="30" uuid="7a3bb07d-f22b-40b3-8864-163e63163362"/>
+				<textElement verticalAlignment="Bottom"/>
+				<textFieldExpression><![CDATA[$F{Nama Customer}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="345" y="111" width="210" height="78" uuid="99034a07-cd1f-4d30-91d3-6d4d0dd5f8dd"/>
+				<textFieldExpression><![CDATA[$F{Alamat Customer}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="449" y="209" width="104" height="20" forecolor="#3D5959" uuid="1bd92276-ed2c-4c85-830e-8d5df41e04f0"/>
+				<textElement verticalAlignment="Middle">
+					<font size="11" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Reference:]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="1" y="209" width="107" height="20" forecolor="#3D5959" uuid="68cfcd6b-e1d9-4ecb-9764-2bf42a00832e"/>
+				<textElement verticalAlignment="Bottom">
+					<font size="11" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Invoice Date:]]></text>
+			</staticText>
+			<textField>
+				<reportElement x="0" y="179" width="332" height="30" forecolor="#AF171D" uuid="a849583d-2f6f-4eb8-a81f-26faed78d942"/>
+				<textElement verticalAlignment="Bottom">
+					<font size="22" isBold="true"/>
+				</textElement>
+				<textFieldExpression><![CDATA["Invoice " + $F{No Dokumen}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="159" y="209" width="100" height="20" forecolor="#3D5959" uuid="1de6e68c-8af3-47b8-8627-a2d2345d7436"/>
+				<textElement verticalAlignment="Bottom">
+					<font size="11" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Due Date:]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="311" y="209" width="88" height="20" forecolor="#3D5959" uuid="e5cddada-b4c1-41a9-9b18-38ff90dfc43b"/>
+				<textElement verticalAlignment="Middle">
+					<font size="11" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Source:]]></text>
+			</staticText>
+			<textField>
+				<reportElement x="1" y="229" width="107" height="19" uuid="6d64e91c-132e-406a-a8a6-0d039adeaed2"/>
+				<textFieldExpression><![CDATA[$F{Invoice Date}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="159" y="229" width="100" height="19" uuid="b5b826a2-774c-4f69-b214-13c8ddc959bd"/>
+				<textFieldExpression><![CDATA[$F{Invoice Due Date}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="311" y="229" width="88" height="18" uuid="8cf741c1-bec0-408e-8984-64db247eb3b9"/>
+				<textFieldExpression><![CDATA[$F{Source}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="449" y="229" width="104" height="18" uuid="d14138c6-4482-40ce-940a-f7a20a27d3c3"/>
+				<textFieldExpression><![CDATA[$F{Reference}]]></textFieldExpression>
+			</textField>
+		</band>
+	</title>
+	<columnHeader>
+		<band height="19" splitType="Stretch">
+			<staticText>
+				<reportElement x="0" y="0" width="270" height="19" uuid="76e11c5e-d2bc-432c-b350-349d46de0ef7">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="60995252-3988-4f0d-bc68-83b9bc10f01c"/>
+				</reportElement>
+				<box>
+					<bottomPen lineWidth="0.75"/>
+				</box>
+				<textElement verticalAlignment="Middle"/>
+				<text><![CDATA[Product]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="270" y="0" width="50" height="19" uuid="978fced3-3525-453b-a810-ff6934d6e0d6">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e612dd81-4096-4ae5-b167-e18439b2bfd5"/>
+				</reportElement>
+				<box>
+					<bottomPen lineWidth="0.75"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle"/>
+				<text><![CDATA[Quantity]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="320" y="0" width="78" height="19" uuid="5fbdf785-5ee9-4180-a4a0-6beef269a709">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="1aacac79-a85d-4272-bb0a-4c52db86ef09"/>
+				</reportElement>
+				<box>
+					<bottomPen lineWidth="0.75"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<text><![CDATA[Price Unit]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="455" y="0" width="100" height="19" uuid="bd6cf75f-4609-48b7-97b9-434992b34089">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6fda57fb-49cc-4fb8-a4fd-b8d2022ec535"/>
+				</reportElement>
+				<box>
+					<bottomPen lineWidth="0.75"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle"/>
+				<text><![CDATA[Amount]]></text>
+			</staticText>
+		</band>
+	</columnHeader>
+	<detail>
+		<band height="30" splitType="Stretch">
+			<textField>
+				<reportElement x="0" y="0" width="270" height="30" uuid="54404cbf-dfa4-4570-aeb6-3335b2a7bf41">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="60995252-3988-4f0d-bc68-83b9bc10f01c"/>
+				</reportElement>
+				<box>
+					<bottomPen lineWidth="0.75"/>
+				</box>
+				<textElement verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$F{Product}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="270" y="0" width="50" height="30" uuid="9ff32015-2be0-4602-a890-587865499204">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e612dd81-4096-4ae5-b167-e18439b2bfd5"/>
+				</reportElement>
+				<box>
+					<bottomPen lineWidth="0.75"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$F{Quantity} + "Unit"]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="320" y="0" width="78" height="30" uuid="a30f8464-2fa5-4114-806c-d78df998592c">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="1aacac79-a85d-4272-bb0a-4c52db86ef09"/>
+				</reportElement>
+				<box>
+					<bottomPen lineWidth="0.75"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$F{Price Unit}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="455" y="0" width="100" height="30" uuid="d8fa0de3-35fc-4599-9bd2-e2841b4876f1">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6fda57fb-49cc-4fb8-a4fd-b8d2022ec535"/>
+				</reportElement>
+				<box>
+					<bottomPen lineWidth="0.75"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$F{Amount}]]></textFieldExpression>
+			</textField>
+		</band>
+	</detail>
+	<pageFooter>
+		<band height="48">
+			<staticText>
+				<reportElement x="156" y="4" width="243" height="14" uuid="8d609c15-3723-4087-b514-7d43b70038ad"/>
+				<textElement textAlignment="Center"/>
+				<text><![CDATA[t@fixcomart.co.id https://Indoteknik.com]]></text>
+			</staticText>
+			<textField>
+				<reportElement x="198" y="18" width="100" height="30" uuid="16ee2b78-5ed9-4f47-ac6c-73095a6dd98f"/>
+				<textElement textAlignment="Right"/>
+				<textFieldExpression><![CDATA["Page " + $V{PAGE_NUMBER}]]></textFieldExpression>
+			</textField>
+			<textField evaluationTime="Report">
+				<reportElement x="298" y="18" width="100" height="30" uuid="77ddd83d-d2a9-4de3-80b9-2086ae571d4f"/>
+				<textElement textAlignment="Left"/>
+				<textFieldExpression><![CDATA[" of " + $V{PAGE_NUMBER}]]></textFieldExpression>
+			</textField>
+		</band>
+	</pageFooter>
+	<summary>
+		<band height="260" splitType="Stretch">
+			<staticText>
+				<reportElement x="1" y="80" width="270" height="20" uuid="d30c96dd-12af-45b6-9c72-f01de596c48f"/>
+				<text><![CDATA[Please use the following communication for your payment :]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="1" y="100" width="310" height="160" uuid="cf9f626b-1a40-4227-a43a-54f38864fd37"/>
+				<text><![CDATA[1. Kirimkan Data NPWP & SPPKP pada saat pertama kali melakukan pemesanan ke finance@indoteknik.co.id.
+2. Penawaran ini memiliki jangka waktu, harga dan stok tidak mengikat.
+3. Pembelian tidak dapat dikembalikan.
+
+
+Data Bank PT. INDOTEKNIK DOTCOM GEMILANG
+BCA CAB. PURI BOTANICAL Acc. No. 8870 4000 81
+Pembayaran giro/cek dinyatakan lunas hanya setelah pencairan.
+Biaya administrasi bank dibebankan ke konsumen]]></text>
+			</staticText>
+			<line>
+				<reportElement x="379" y="3" width="176" height="1" uuid="3114fdf4-cd60-4120-9fd2-9453fd573334"/>
+				<graphicElement>
+					<pen lineWidth="1.0"/>
+				</graphicElement>
+			</line>
+			<staticText>
+				<reportElement x="379" y="53" width="56" height="20" uuid="534a85cf-894f-441f-9542-e0c8335c0cb5">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0" lineStyle="Solid"/>
+					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle">
+					<font size="10" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Taxes :]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="379" y="13" width="56" height="20" forecolor="#AF171D" uuid="9a000aae-fbc4-4d85-9430-3b4274d189c7">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0" lineStyle="Solid"/>
+					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle">
+					<font size="10" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Subtotal :]]></text>
+			</staticText>
+			<line direction="BottomUp">
+				<reportElement x="379" y="43" width="176" height="1" uuid="8a1f5dfe-9c31-43b3-b08d-b3a6cfd381fb"/>
+				<graphicElement>
+					<pen lineWidth="0.5"/>
+				</graphicElement>
+			</line>
+			<line>
+				<reportElement x="379" y="83" width="176" height="1" uuid="0b48d0af-37da-430e-aa34-534fb72a0dbb"/>
+				<graphicElement>
+					<pen lineWidth="1.0"/>
+				</graphicElement>
+			</line>
+			<staticText>
+				<reportElement x="379" y="93" width="56" height="20" forecolor="#AF171D" uuid="564fe1e9-19c6-4cbd-af29-ce7add3054b8">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0" lineStyle="Solid"/>
+					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle">
+					<font size="10" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Total :]]></text>
+			</staticText>
+			<textField>
+				<reportElement x="453" y="13" width="102" height="20" uuid="13129153-42c8-4cbf-8878-3406bd5638eb"/>
+				<textElement verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA["Rp " + $V{Subtotal}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="453" y="50" width="102" height="23" uuid="beaf842a-22d6-4691-b76a-e82e8c11c752"/>
+				<textElement verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA["Rp " + $V{Taxes}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="453" y="93" width="102" height="20" uuid="9063b2f2-40a2-4839-b429-54f24b5c35e8"/>
+				<textElement verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA["Rp" + $V{Total}]]></textFieldExpression>
+			</textField>
+		</band>
+	</summary>
+</jasperReport>