From 3c5e28c22b032de39bf8969c7ddc83a0fa7218a9 Mon Sep 17 00:00:00 2001
From: root <root@prod-erp-indoteknikcom.c.project-indoteknik-com.internal>
Date: Wed, 5 Oct 2022 15:02:34 +0700
Subject: add proforma invoice

---
 .../custom_reports/proforma_invoice.jrxml          | 391 +++++++++++++++++++++
 1 file changed, 391 insertions(+)
 create mode 100644 jasper_reports/custom_reports/proforma_invoice.jrxml

diff --git a/jasper_reports/custom_reports/proforma_invoice.jrxml b/jasper_reports/custom_reports/proforma_invoice.jrxml
new file mode 100644
index 0000000..cfaf829
--- /dev/null
+++ b/jasper_reports/custom_reports/proforma_invoice.jrxml
@@ -0,0 +1,391 @@
+<?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="sales_without_disc" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="5569a288-a46f-49ec-91b2-f60f77ccdd63">
+	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="Sale Order Dev XML"/>
+	<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="261"/>
+	<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="733"/>
+	<property name="ODOO_RELATIONS">
+		<![CDATA[['order_line']]]>
+	</property>
+	<queryString language="XPath">
+		<![CDATA[/data/record]]>
+	</queryString>
+	<field name="customername" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Customer-partner_id/Name-name"/>
+		<fieldDescription><![CDATA[Customer-partner_id/Name-name]]></fieldDescription>
+	</field>
+	<field name="customeraddress" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Customer-partner_id/Complete_Address-contact_address"/>
+		<fieldDescription><![CDATA[Customer-partner_id/Complete_Address-contact_address]]></fieldDescription>
+	</field>
+	<field name="documentno" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Order_Reference-name"/>
+		<fieldDescription><![CDATA[Order_Reference-name]]></fieldDescription>
+	</field>
+	<field name="custreference" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Customer_Reference-client_order_ref"/>
+		<fieldDescription><![CDATA[Customer_Reference-client_order_ref]]></fieldDescription>
+	</field>
+	<field name="dateorder" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Order_Date-date_order"/>
+		<fieldDescription><![CDATA[Order_Date-date_order]]></fieldDescription>
+	</field>
+	<field name="salesname" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Salesperson-user_id/Name-name"/>
+		<fieldDescription><![CDATA[Salesperson-user_id/Name-name]]></fieldDescription>
+	</field>
+	<field name="productdisplayname" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Order_Lines-order_line/Product-product_id/Display_Name-display_name"/>
+		<fieldDescription><![CDATA[Order_Lines-order_line/Product-product_id/Display_Name-display_name]]></fieldDescription>
+	</field>
+	<field name="qty" class="java.math.BigDecimal">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Order_Lines-order_line/Quantity-product_uom_qty"/>
+		<fieldDescription><![CDATA[Order_Lines-order_line/Quantity-product_uom_qty]]></fieldDescription>
+	</field>
+	<field name="pricewithouttax" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Order_Lines-order_line/Price_Reduce_Tax_excl-price_reduce_taxexcl"/>
+		<fieldDescription><![CDATA[Order_Lines-order_line/Price_Reduce_Tax_excl-price_reduce_taxexcl]]></fieldDescription>
+	</field>
+	<field name="pricewithtax" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Order_Lines-order_line/Price_Reduce_Tax_inc-price_reduce_taxinc"/>
+		<fieldDescription><![CDATA[Order_Lines-order_line/Price_Reduce_Tax_inc-price_reduce_taxinc]]></fieldDescription>
+	</field>
+	<field name="Price_Reduce-price_reduce" class="java.math.BigDecimal">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Order_Lines-order_line/Price_Reduce-price_reduce"/>
+		<fieldDescription><![CDATA[Order_Lines-order_line/Price_Reduce-price_reduce]]></fieldDescription>
+	</field>
+	<field name="Subtotal-price_subtotal" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Order_Lines-order_line/Subtotal-price_subtotal"/>
+		<fieldDescription><![CDATA[Order_Lines-order_line/Subtotal-price_subtotal]]></fieldDescription>
+	</field>
+	<field name="Total_Tax-price_tax" class="java.math.BigDecimal">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Order_Lines-order_line/Total_Tax-price_tax"/>
+		<fieldDescription><![CDATA[Order_Lines-order_line/Total_Tax-price_tax]]></fieldDescription>
+	</field>
+	<field name="Total-price_total" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Order_Lines-order_line/Total-price_total"/>
+		<fieldDescription><![CDATA[Order_Lines-order_line/Total-price_total]]></fieldDescription>
+	</field>
+	<field name="Unit_Price-price_unit" class="java.math.BigDecimal">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Order_Lines-order_line/Unit_Price-price_unit"/>
+		<fieldDescription><![CDATA[Order_Lines-order_line/Unit_Price-price_unit]]></fieldDescription>
+	</field>
+	<field name="Taxes-amount_tax" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Taxes-amount_tax"/>
+		<fieldDescription><![CDATA[Taxes-amount_tax]]></fieldDescription>
+	</field>
+	<field name="Total-amount_total" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Total-amount_total"/>
+		<fieldDescription><![CDATA[Total-amount_total]]></fieldDescription>
+	</field>
+	<field name="Untaxed_Amount-amount_untaxed" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Untaxed_Amount-amount_untaxed"/>
+		<fieldDescription><![CDATA[Untaxed_Amount-amount_untaxed]]></fieldDescription>
+	</field>
+	<field name="Included_in_Price-price_include" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Tax-sales_tax_id/Included_in_Price-price_include"/>
+		<fieldDescription><![CDATA[Tax-sales_tax_id/Included_in_Price-price_include]]></fieldDescription>
+	</field>
+	<field name="Status-state" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Status-state"/>
+		<fieldDescription><![CDATA[Status-state]]></fieldDescription>
+	</field>
+	<field name="uomname" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Order_Lines-order_line/Unit_of_Measure-product_uom/Display_Name-display_name"/>
+		<fieldDescription><![CDATA[Order_Lines-order_line/Unit_of_Measure-product_uom/Display_Name-display_name]]></fieldDescription>
+	</field>
+	<field name="Discount____-discount" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Order_Lines-order_line/Discount____-discount"/>
+		<fieldDescription><![CDATA[Order_Lines-order_line/Discount____-discount]]></fieldDescription>
+	</field>
+	<field name="CustomerDisplayName" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Customer-partner_id/Display_Name-display_name"/>
+		<fieldDescription><![CDATA[Customer-partner_id/Display_Name-display_name]]></fieldDescription>
+	</field>
+	<field name="Street-street" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Customer-partner_id/Street-street"/>
+		<fieldDescription><![CDATA[Customer-partner_id/Street-street]]></fieldDescription>
+	</field>
+	<field name="Street2-street2" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Customer-partner_id/Street2-street2"/>
+		<fieldDescription><![CDATA[Customer-partner_id/Street2-street2]]></fieldDescription>
+	</field>
+	<variable name="UnitPrice" class="java.math.BigDecimal">
+		<variableExpression><![CDATA[$F{Included_in_Price-price_include}=="True"?new BigDecimal($F{pricewithtax}):new BigDecimal($F{pricewithouttax})]]></variableExpression>
+	</variable>
+	<variable name="Amount" class="java.math.BigDecimal">
+		<variableExpression><![CDATA[$F{Included_in_Price-price_include}=="True"?new BigDecimal($F{Total-price_total}):new BigDecimal($F{Subtotal-price_subtotal})]]></variableExpression>
+	</variable>
+	<variable name="Total" class="java.math.BigDecimal">
+		<variableExpression><![CDATA[new BigDecimal($F{Total-amount_total})]]></variableExpression>
+	</variable>
+	<variable name="Subtotal" class="java.math.BigDecimal">
+		<variableExpression><![CDATA[$F{Included_in_Price-price_include}=="True"?new BigDecimal($F{Total-amount_total}):new BigDecimal($F{Untaxed_Amount-amount_untaxed})]]></variableExpression>
+	</variable>
+	<variable name="Taxes" class="java.math.BigDecimal">
+		<variableExpression><![CDATA[$F{Included_in_Price-price_include}=="True"?new BigDecimal($F{Taxes-amount_tax}):new BigDecimal($F{Taxes-amount_tax})]]></variableExpression>
+	</variable>
+	<variable name="SubTitle" class="java.lang.String">
+		<variableExpression><![CDATA[$F{Status-state}.toString().equals("sale")?"Pro-Forma Invoice # "+$F{documentno}:"Pro-Forma Invoice # "+$F{documentno}]]></variableExpression>
+		<initialValueExpression><![CDATA[$F{Status-state}.toString().equals("sale")?"Pro-Forma Invoice # "+$F{documentno}:"Pro-Forma Invoice # "+$F{documentno}]]></initialValueExpression>
+	</variable>
+	<background>
+		<band splitType="Stretch"/>
+	</background>
+	<title>
+		<band height="90" splitType="Stretch">
+			<image>
+				<reportElement x="0" y="0" width="90" height="30" uuid="2f408c9c-457b-4a54-bb9a-bd90a7eca43e"/>
+				<imageExpression><![CDATA["/odoo14/images/logo_indoteknik.jpeg"]]></imageExpression>
+			</image>
+			<line>
+				<reportElement x="0" y="30" width="555" height="1" uuid="1d24b28a-0d98-4f26-bea9-0496e11ce30d">
+					<property name="com.jaspersoft.studio.unit.width" value="px"/>
+				</reportElement>
+			</line>
+			<staticText>
+				<reportElement x="0" y="30" width="280" height="60" uuid="267a2a0b-0a31-4a7a-8dd6-87525c411589"/>
+				<textElement textAlignment="Left" verticalAlignment="Middle"/>
+				<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>
+		</band>
+	</title>
+	<pageHeader>
+		<band height="100" splitType="Stretch">
+			<textField>
+				<reportElement x="0" y="80" width="200" height="20" uuid="a53c450f-7fc7-415a-9738-8e79eb98fe96"/>
+				<textFieldExpression><![CDATA[$F{custreference}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="200" y="80" width="190" height="20" uuid="94a7e77d-6f56-44e8-8605-de94ec847777"/>
+				<textFieldExpression><![CDATA[$F{dateorder}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="390" y="80" width="165" height="20" uuid="bcdda2af-f85b-4cd6-ab4f-a9ec867f09aa"/>
+				<textFieldExpression><![CDATA[$F{salesname}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="0" y="0" width="280" height="60" forecolor="#990000" uuid="2438177a-77fc-4cc7-aa10-9141c88f0ab5"/>
+				<textElement verticalAlignment="Bottom" markup="none">
+					<font size="14" isBold="false"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$V{SubTitle}.toString()]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="0" y="60" width="200" height="20" forecolor="#000066" uuid="fa08614c-b9fb-4b7d-a993-cb7f8e73db33"/>
+				<textElement verticalAlignment="Middle"/>
+				<text><![CDATA[Your Reference :]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="200" y="60" width="190" height="20" forecolor="#000066" uuid="56c38753-fa73-416e-a136-fb2ff4efb5e0"/>
+				<textElement verticalAlignment="Middle"/>
+				<text><![CDATA[Order Date :]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="390" y="60" width="165" height="20" forecolor="#000066" uuid="80a59fcc-2592-43f8-8085-88d06012285e"/>
+				<textElement verticalAlignment="Middle"/>
+				<text><![CDATA[Salesperson :]]></text>
+			</staticText>
+			<textField>
+				<reportElement x="280" y="0" width="275" height="20" uuid="f479f74f-3834-4df7-b59f-431b722b9ec0"/>
+				<textFieldExpression><![CDATA[$F{customername}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="280" y="20" width="275" height="40" uuid="7e7d81ad-fb57-4528-bbd2-88f4d15f3ccc"/>
+				<textFieldExpression><![CDATA[$F{Street-street}]]></textFieldExpression>
+			</textField>
+		</band>
+	</pageHeader>
+	<columnHeader>
+		<band height="20" splitType="Stretch">
+			<staticText>
+				<reportElement x="0" y="0" width="265" height="20" forecolor="#000066" uuid="d3c73a17-1a25-4dfb-9072-96bd673f1574">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a14cd5e1-8456-4ddb-9362-01aa96837ebc"/>
+				</reportElement>
+				<box>
+					<topPen lineWidth="0.0" lineColor="#030303"/>
+					<bottomPen lineWidth="0.25" lineColor="#030303"/>
+				</box>
+				<textElement verticalAlignment="Middle"/>
+				<text><![CDATA[Description]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="265" y="0" width="90" height="20" forecolor="#000066" uuid="f64894c9-b7b4-4380-acf0-c2eb6b38c0da">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a799cdde-15df-4f44-a5d1-e148a3ec898b"/>
+				</reportElement>
+				<box>
+					<topPen lineWidth="0.0" lineColor="#030303"/>
+					<bottomPen lineWidth="0.25" lineColor="#030303"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle"/>
+				<text><![CDATA[Quantity]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="355" y="0" width="100" height="20" forecolor="#000066" uuid="d5240e05-f50e-4f2b-96b3-6e8c16ddfef9">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a799cdde-15df-4f44-a5d1-e148a3ec898b"/>
+				</reportElement>
+				<box>
+					<topPen lineWidth="0.0" lineColor="#030303"/>
+					<bottomPen lineWidth="0.25" lineColor="#030303"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<text><![CDATA[Unit Price]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="455" y="0" width="100" height="20" forecolor="#000066" uuid="0a41170a-9966-4033-8ad8-60033fba323e">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a799cdde-15df-4f44-a5d1-e148a3ec898b"/>
+				</reportElement>
+				<box>
+					<topPen lineWidth="0.0" lineColor="#030303"/>
+					<bottomPen lineWidth="0.25" lineColor="#030303"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<text><![CDATA[Amount]]></text>
+			</staticText>
+		</band>
+	</columnHeader>
+	<detail>
+		<band height="20" splitType="Stretch">
+			<textField>
+				<reportElement x="0" y="0" width="265" height="20" uuid="a0af1b59-8f1c-496a-b6ce-84fcd8b694ea">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a14cd5e1-8456-4ddb-9362-01aa96837ebc"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="0.0"/>
+					<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 verticalAlignment="Middle" markup="none">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{productdisplayname}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="265" y="0" width="40" height="20" uuid="9ea04257-114c-4a32-a57c-825bff2fb289">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a799cdde-15df-4f44-a5d1-e148a3ec898b"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="0.0"/>
+					<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"/>
+				<textFieldExpression><![CDATA[$F{qty}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="305" y="0" width="50" height="20" uuid="0f0b8830-f25a-4fb0-9db3-e2c24d43edf9">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ae4680ee-5de0-468d-9294-75cb0dd03490"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="0.0"/>
+					<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="Center" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$F{uomname}]]></textFieldExpression>
+			</textField>
+			<textField pattern="#,##0.00#;(#,##0.00#-)">
+				<reportElement x="355" y="0" width="100" height="20" uuid="93441816-7747-40d0-aae8-1b71df8c2a12"/>
+				<box>
+					<pen lineWidth="0.0"/>
+					<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"/>
+				<textFieldExpression><![CDATA[$V{UnitPrice}]]></textFieldExpression>
+			</textField>
+			<textField pattern="#,##0.00#;(#,##0.00#-)">
+				<reportElement x="455" y="0" width="100" height="20" uuid="1769c5ba-1cc0-4053-965a-6a2af93d4e1b"/>
+				<box>
+					<pen lineWidth="0.0"/>
+					<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"/>
+				<textFieldExpression><![CDATA[$V{Amount}]]></textFieldExpression>
+			</textField>
+		</band>
+	</detail>
+	<summary>
+		<band height="159" splitType="Stretch">
+			<staticText>
+				<reportElement x="355" y="0" width="100" height="20" forecolor="#990000" uuid="5d24d045-af9a-4c2c-82f6-bc10f5190234"/>
+				<box>
+					<topPen lineWidth="0.5" lineColor="#030303"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<text><![CDATA[Subtotal]]></text>
+			</staticText>
+			<textField pattern="#,##0.00#;(#,##0.00#-)">
+				<reportElement x="455" y="0" width="100" height="20" uuid="c656e205-49a4-4d17-91b3-eb18d7c8d13f"/>
+				<box>
+					<topPen lineWidth="0.5" lineColor="#030303"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$V{Subtotal}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="355" y="20" width="100" height="20" uuid="765e77bf-9975-4304-aa3f-622709c23948"/>
+				<box>
+					<topPen lineWidth="0.0"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<text><![CDATA[Taxes]]></text>
+			</staticText>
+			<textField pattern="#,##0.00#;(#,##0.00#-)">
+				<reportElement x="455" y="20" width="100" height="20" uuid="5a7b0aa0-6ac8-49d0-9292-ef69436c6147"/>
+				<box>
+					<topPen lineWidth="0.0"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$V{Taxes}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="355" y="40" width="100" height="20" forecolor="#990000" uuid="b694fce6-60f6-460a-8c24-9ce2f9613d7c"/>
+				<box>
+					<pen lineWidth="0.0"/>
+					<topPen lineWidth="1.0" lineColor="#030303"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<text><![CDATA[Total]]></text>
+			</staticText>
+			<textField pattern="#,##0.00#;(#,##0.00#-)">
+				<reportElement x="455" y="40" width="100" height="20" uuid="7bde8222-dce6-4e18-a6ad-517ab5dbc9f0"/>
+				<box>
+					<topPen lineWidth="1.0"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$V{Total}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="0" y="60" width="555" height="99" uuid="f561a33c-50e8-4bfb-b0b3-f4d1628d6bb7"/>
+				<textElement verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<text><![CDATA[1. Harga sudah berikut Pajak Pertambahan Nilai (Ppn)
+2. Kirimkan Data NPWP & SPPKP pada saat pertama kali melakukan pemesanan ke finance@indoteknik.co.id
+3. Penawaran ini memiliki jangka waktu, harga, dan stock tidak mengikat
+4. 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>
+		</band>
+	</summary>
+</jasperReport>
-- 
cgit v1.2.3


From 4353da78776bd7a6017d08a968bd68af94d1ec07 Mon Sep 17 00:00:00 2001
From: root <root@prod-erp-indoteknikcom.c.project-indoteknik-com.internal>
Date: Wed, 5 Oct 2022 21:42:29 +0700
Subject: change customer name to dynamic variable

---
 jasper_reports/custom_reports/proforma_invoice.jrxml   | 15 +++++++++++----
 jasper_reports/custom_reports/sales_without_disc.jrxml | 15 +++++++++++----
 2 files changed, 22 insertions(+), 8 deletions(-)

diff --git a/jasper_reports/custom_reports/proforma_invoice.jrxml b/jasper_reports/custom_reports/proforma_invoice.jrxml
index cfaf829..3ee83a1 100644
--- a/jasper_reports/custom_reports/proforma_invoice.jrxml
+++ b/jasper_reports/custom_reports/proforma_invoice.jrxml
@@ -110,6 +110,10 @@
 		<property name="net.sf.jasperreports.xpath.field.expression" value="Customer-partner_id/Street2-street2"/>
 		<fieldDescription><![CDATA[Customer-partner_id/Street2-street2]]></fieldDescription>
 	</field>
+	<field name="Parent_name-parent_name" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Customer-partner_id/Parent_name-parent_name"/>
+		<fieldDescription><![CDATA[Customer-partner_id/Parent_name-parent_name]]></fieldDescription>
+	</field>
 	<variable name="UnitPrice" class="java.math.BigDecimal">
 		<variableExpression><![CDATA[$F{Included_in_Price-price_include}=="True"?new BigDecimal($F{pricewithtax}):new BigDecimal($F{pricewithouttax})]]></variableExpression>
 	</variable>
@@ -129,6 +133,9 @@
 		<variableExpression><![CDATA[$F{Status-state}.toString().equals("sale")?"Pro-Forma Invoice # "+$F{documentno}:"Pro-Forma Invoice # "+$F{documentno}]]></variableExpression>
 		<initialValueExpression><![CDATA[$F{Status-state}.toString().equals("sale")?"Pro-Forma Invoice # "+$F{documentno}:"Pro-Forma Invoice # "+$F{documentno}]]></initialValueExpression>
 	</variable>
+	<variable name="customer_name" class="java.lang.String">
+		<initialValueExpression><![CDATA[$F{Parent_name-parent_name}.isEmpty()?$F{customername}:$F{Parent_name-parent_name}]]></initialValueExpression>
+	</variable>
 	<background>
 		<band splitType="Stretch"/>
 	</background>
@@ -190,14 +197,14 @@ Indonesia]]></text>
 				<textElement verticalAlignment="Middle"/>
 				<text><![CDATA[Salesperson :]]></text>
 			</staticText>
-			<textField>
-				<reportElement x="280" y="0" width="275" height="20" uuid="f479f74f-3834-4df7-b59f-431b722b9ec0"/>
-				<textFieldExpression><![CDATA[$F{customername}]]></textFieldExpression>
-			</textField>
 			<textField>
 				<reportElement x="280" y="20" width="275" height="40" uuid="7e7d81ad-fb57-4528-bbd2-88f4d15f3ccc"/>
 				<textFieldExpression><![CDATA[$F{Street-street}]]></textFieldExpression>
 			</textField>
+			<textField>
+				<reportElement x="280" y="0" width="275" height="20" uuid="85b92ba9-a425-421e-bf69-6bc6b1018099"/>
+				<textFieldExpression><![CDATA[$V{customer_name}]]></textFieldExpression>
+			</textField>
 		</band>
 	</pageHeader>
 	<columnHeader>
diff --git a/jasper_reports/custom_reports/sales_without_disc.jrxml b/jasper_reports/custom_reports/sales_without_disc.jrxml
index c293008..a897ab7 100644
--- a/jasper_reports/custom_reports/sales_without_disc.jrxml
+++ b/jasper_reports/custom_reports/sales_without_disc.jrxml
@@ -110,6 +110,10 @@
 		<property name="net.sf.jasperreports.xpath.field.expression" value="Customer-partner_id/Street2-street2"/>
 		<fieldDescription><![CDATA[Customer-partner_id/Street2-street2]]></fieldDescription>
 	</field>
+	<field name="Parent_name-parent_name" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="Customer-partner_id/Parent_name-parent_name"/>
+		<fieldDescription><![CDATA[Customer-partner_id/Parent_name-parent_name]]></fieldDescription>
+	</field>
 	<variable name="UnitPrice" class="java.math.BigDecimal">
 		<variableExpression><![CDATA[$F{Included_in_Price-price_include}=="True"?new BigDecimal($F{pricewithtax}):new BigDecimal($F{pricewithouttax})]]></variableExpression>
 	</variable>
@@ -129,6 +133,9 @@
 		<variableExpression><![CDATA[$F{Status-state}.toString().equals("sale")?"Order # "+$F{documentno}:"Quotation # "+$F{documentno}]]></variableExpression>
 		<initialValueExpression><![CDATA[$F{Status-state}.toString().equals("sale")?"Order # "+$F{documentno}:"Quotation # "+$F{documentno}]]></initialValueExpression>
 	</variable>
+	<variable name="customer_name" class="java.lang.String">
+		<initialValueExpression><![CDATA[$F{Parent_name-parent_name}.isEmpty()?$F{customername}:$F{Parent_name-parent_name}]]></initialValueExpression>
+	</variable>
 	<background>
 		<band splitType="Stretch"/>
 	</background>
@@ -190,14 +197,14 @@ Indonesia]]></text>
 				<textElement verticalAlignment="Middle"/>
 				<text><![CDATA[Salesperson :]]></text>
 			</staticText>
-			<textField>
-				<reportElement x="280" y="0" width="275" height="20" uuid="f479f74f-3834-4df7-b59f-431b722b9ec0"/>
-				<textFieldExpression><![CDATA[$F{customername}]]></textFieldExpression>
-			</textField>
 			<textField>
 				<reportElement x="280" y="20" width="275" height="40" uuid="7e7d81ad-fb57-4528-bbd2-88f4d15f3ccc"/>
 				<textFieldExpression><![CDATA[$F{Street-street}]]></textFieldExpression>
 			</textField>
+			<textField>
+				<reportElement x="280" y="0" width="275" height="20" uuid="f5c9f6ff-5207-4521-8418-7bb0b0058add"/>
+				<textFieldExpression><![CDATA[$V{customer_name}]]></textFieldExpression>
+			</textField>
 		</band>
 	</pageHeader>
 	<columnHeader>
-- 
cgit v1.2.3