From 7ee60bcc36502ee3528902d061b14c91b7d3ca0b Mon Sep 17 00:00:00 2001
From: root <root@prod-erp-indoteknikcom.c.project-indoteknik-com.internal>
Date: Wed, 3 Jul 2024 14:47:55 +0700
Subject: mod jasper report only

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

(limited to 'jasper_reports/custom_reports/saleorderimage.jrxml')

diff --git a/jasper_reports/custom_reports/saleorderimage.jrxml b/jasper_reports/custom_reports/saleorderimage.jrxml
new file mode 100644
index 0000000..791aedc
--- /dev/null
+++ b/jasper_reports/custom_reports/saleorderimage.jrxml
@@ -0,0 +1,609 @@
+<?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="saleorderimage" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="bcb140b6-15b9-47fa-9abe-df16274d5a7c">
+	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="saleorderlokal.jrdax"/>
+	<property name="ODOO_RELATIONS">
+		<![CDATA[['order_line']]]>
+	</property>
+	<queryString language="XPath">
+		<![CDATA[]]>
+	</queryString>
+	<field name="Order_Lines-order_line" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line"/>
+		<fieldDescription><![CDATA[/data/record/Order_Lines-order_line]]></fieldDescription>
+	</field>
+	<field name="Product_Image-image_small" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Product_Image-image_small"/>
+		<fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Product_Image-image_small]]></fieldDescription>
+	</field>
+	<field name="Name-name" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Product-product_id/Name-name"/>
+		<fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Product-product_id/Name-name]]></fieldDescription>
+	</field>
+	<field name="Manufactures-x_manufacture" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Product-product_id/Manufactures-x_manufacture/Name-x_name"/>
+		<fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Product-product_id/Manufactures-x_manufacture/Name-x_name]]></fieldDescription>
+	</field>
+	<field name="Product_Type-type" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Product-product_id/Product_Type-type"/>
+		<fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Product-product_id/Product_Type-type]]></fieldDescription>
+	</field>
+	<field name="Internal_Reference-default_code" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Product-product_id/Internal_Reference-default_code"/>
+		<fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Product-product_id/Internal_Reference-default_code]]></fieldDescription>
+	</field>
+	<field name="Quantity-product_uom_qty" class="java.math.BigDecimal">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Quantity-product_uom_qty"/>
+		<fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Quantity-product_uom_qty]]></fieldDescription>
+	</field>
+	<field name="Unit_of_Measure-product_uom" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Unit_of_Measure-product_uom"/>
+		<fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Unit_of_Measure-product_uom]]></fieldDescription>
+	</field>
+	<field name="Total-price_total" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Total-price_total"/>
+		<fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Total-price_total]]></fieldDescription>
+	</field>
+	<field name="Unit_Price-price_unit" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Unit_Price-price_unit"/>
+		<fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Unit_Price-price_unit]]></fieldDescription>
+	</field>
+	<field name="Description_for_the_website-website_description" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Product-product_id/Description_for_the_website-website_description"/>
+		<fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Product-product_id/Description_for_the_website-website_description]]></fieldDescription>
+	</field>
+	<field name="Total-amount_total" class="java.lang.String">
+		<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="Taxes-amount_tax" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Taxes-amount_tax"/>
+		<fieldDescription><![CDATA[/data/record/Taxes-amount_tax]]></fieldDescription>
+	</field>
+	<field name="Untaxed_Amount-amount_untaxed" class="java.lang.String">
+		<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="Manufacture-x_product_manufacture" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Product-product_id/Manufacture-x_product_manufacture"/>
+		<fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Product-product_id/Manufacture-x_product_manufacture]]></fieldDescription>
+	</field>
+	<field name="Order_Reference-name" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Reference-name"/>
+		<fieldDescription><![CDATA[/data/record/Order_Reference-name]]></fieldDescription>
+	</field>
+	<field name="Name-name_1" 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="Street-street" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Customer-partner_id/Street-street"/>
+		<fieldDescription><![CDATA[/data/record/Customer-partner_id/Street-street]]></fieldDescription>
+	</field>
+	<field name="Customer_Reference-client_order_ref" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Customer_Reference-client_order_ref"/>
+		<fieldDescription><![CDATA[/data/record/Customer_Reference-client_order_ref]]></fieldDescription>
+	</field>
+	<field name="Name-name_2" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Salesperson-user_id/Name-name"/>
+		<fieldDescription><![CDATA[/data/record/Salesperson-user_id/Name-name]]></fieldDescription>
+	</field>
+	<field name="Display_Name-display_name" 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="Order_Date-date_order" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Date-date_order"/>
+		<fieldDescription><![CDATA[/data/record/Order_Date-date_order]]></fieldDescription>
+	</field>
+	<field name="Unit_of_Measure-name" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Unit_of_Measure-product_uom/Unit_of_Measure-name"/>
+		<fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Unit_of_Measure-product_uom/Unit_of_Measure-name]]></fieldDescription>
+	</field>
+	<field name="Name-x_name" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Product-product_id/Manufactures-x_manufacture/Name-x_name"/>
+		<fieldDescription><![CDATA[/data/record/Product-product_id/Manufactures-x_manufacture/Name-x_name]]></fieldDescription>
+	</field>
+	<field name="Subtotal-price_subtotal" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Subtotal-price_subtotal"/>
+		<fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Subtotal-price_subtotal]]></fieldDescription>
+	</field>
+	<field name="pricewithtax" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Price_Reduce_Tax_inc-price_reduce_taxinc"/>
+		<fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Price_Reduce_Tax_inc-price_reduce_taxinc]]></fieldDescription>
+	</field>
+	<field name="pricewithouttax" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Price_Reduce_Tax_excl-price_reduce_taxexcl"/>
+		<fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Price_Reduce_Tax_excl-price_reduce_taxexcl]]></fieldDescription>
+	</field>
+	<field name="Included_in_Price-price_include" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Tax-sales_tax_id/Included_in_Price-price_include"/>
+		<fieldDescription><![CDATA[/data/record/Tax-sales_tax_id/Included_in_Price-price_include]]></fieldDescription>
+	</field>
+	<field name="Display_Name-display_name_1" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Product-product_id/Display_Name-display_name"/>
+		<fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Product-product_id/Display_Name-display_name]]></fieldDescription>
+	</field>
+	<field name="Description-name" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Description-name"/>
+		<fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Description-name]]></fieldDescription>
+	</field>
+	<variable name="subtotal" class="java.math.BigDecimal">
+		<variableExpression><![CDATA[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"
+	?$F{Taxes-amount_tax}.equals("")?new BigDecimal("0"):new BigDecimal($F{Taxes-amount_tax})
+	:$F{Taxes-amount_tax}.equals("")?new BigDecimal("0"):new BigDecimal($F{Taxes-amount_tax})]]></variableExpression>
+	</variable>
+	<variable name="grand_total" class="java.math.BigDecimal">
+		<variableExpression><![CDATA[new BigDecimal($F{Total-amount_total})]]></variableExpression>
+	</variable>
+	<variable name="price_subtotal" class="java.math.BigDecimal">
+		<variableExpression><![CDATA[$F{Included_in_Price-price_include}=="True"
+	?$F{Total-price_total}.equals("")?new BigDecimal("0"):new BigDecimal($F{Total-price_total})
+	:$F{Subtotal-price_subtotal}.equals("")?new BigDecimal("0"):new BigDecimal($F{Subtotal-price_subtotal})]]></variableExpression>
+	</variable>
+	<variable name="PriceUnit" class="java.math.BigDecimal">
+		<variableExpression><![CDATA[$F{Included_in_Price-price_include}=="True"
+	?$F{pricewithtax}.equals("")?new BigDecimal("0"):new BigDecimal($F{pricewithtax})
+	:$F{pricewithouttax}.equals("")?new BigDecimal("0"):new BigDecimal($F{pricewithouttax})]]></variableExpression>
+	</variable>
+	<variable name="Amount" class="java.math.BigDecimal">
+		<variableExpression><![CDATA[$F{Included_in_Price-price_include}=="True"
+	?$F{Total-price_total}.equals("")?new BigDecimal("0"):new BigDecimal($F{Total-price_total})
+	:$F{Subtotal-price_subtotal}.equals("")?new BigDecimal("0"):new BigDecimal($F{Subtotal-price_subtotal})]]></variableExpression>
+	</variable>
+	<background>
+		<band splitType="Stretch"/>
+	</background>
+	<title>
+		<band height="251" splitType="Stretch">
+			<staticText>
+				<reportElement x="0" y="35" width="270" height="70" uuid="c5cca9a5-34d9-4754-bf83-dbbef02d1e16"/>
+				<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="6d862bb5-8132-4c49-bba6-0d4e66f7c2c7"/>
+				<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="7ca9f9f3-8916-424b-b710-da4efc4cc7e6"/>
+			</line>
+			<textField>
+				<reportElement x="0" y="179" width="380" height="30" forecolor="#AF171D" uuid="33527582-6dbc-42d4-8745-e62770210912"/>
+				<textElement verticalAlignment="Bottom">
+					<font size="22" isBold="true"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Display_Name-display_name}]]></textFieldExpression>
+			</textField>
+			<textField isBlankWhenNull="true">
+				<reportElement x="390" y="89" width="176" height="30" uuid="348377cf-189b-44fc-a1b2-34d4b9d637af"/>
+				<textElement verticalAlignment="Bottom"/>
+				<textFieldExpression><![CDATA[$F{Name-name_1}]]></textFieldExpression>
+			</textField>
+			<textField isBlankWhenNull="true">
+				<reportElement x="390" y="119" width="176" height="60" uuid="ce4985af-6361-4160-be08-22ad85b244df"/>
+				<textFieldExpression><![CDATA[$F{Street-street}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="2" y="210" width="198" height="20" forecolor="#3D5959" uuid="849c6c33-d49c-4eaf-a822-3b3faf1502c4"/>
+				<textElement verticalAlignment="Bottom">
+					<font size="11" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Your Reference:]]></text>
+			</staticText>
+			<textField pattern="M/d/yy h:mm a" isBlankWhenNull="true">
+				<reportElement x="200" y="230" width="132" height="20" uuid="d1ad6fd3-a9a5-4f37-baf1-7f161a5227ea"/>
+				<textElement verticalAlignment="Top"/>
+				<textFieldExpression><![CDATA[$F{Order_Date-date_order}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="392" y="210" width="164" height="20" forecolor="#3D5959" uuid="903ee404-bd44-412f-bcee-884cfadf3662"/>
+				<textElement verticalAlignment="Middle">
+					<font size="11" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Salesperson:]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="200" y="210" width="132" height="20" forecolor="#3D5959" uuid="9b3ef29d-5603-4f2c-ace3-e337056c711c"/>
+				<textElement verticalAlignment="Bottom">
+					<font size="11" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Order Date:]]></text>
+			</staticText>
+			<textField isBlankWhenNull="true">
+				<reportElement x="392" y="230" width="164" height="20" uuid="2d1d41ad-5435-4961-8a72-37d2b13df6d3"/>
+				<textElement verticalAlignment="Top"/>
+				<textFieldExpression><![CDATA[$F{Name-name_2}]]></textFieldExpression>
+			</textField>
+			<textField isBlankWhenNull="true">
+				<reportElement x="2" y="230" width="198" height="20" uuid="7138d167-f59f-44d2-b711-a7aaa57128d6"/>
+				<textElement verticalAlignment="Top"/>
+				<textFieldExpression><![CDATA[$F{Customer_Reference-client_order_ref}]]></textFieldExpression>
+			</textField>
+		</band>
+	</title>
+	<columnHeader>
+		<band height="21" splitType="Stretch">
+			<staticText>
+				<reportElement x="126" y="1" width="70" height="20" forecolor="#3D5959" backcolor="#DEE2E6" uuid="32b70c17-8a3c-42e3-b64c-044e01391eb4">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0" lineStyle="Solid" lineColor="#DEE2E6"/>
+					<topPen lineWidth="0.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="Left" verticalAlignment="Middle">
+					<font size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Item Code]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="196" y="1" width="50" height="20" forecolor="#3D5959" uuid="198dcc67-d7b4-485d-bbab-0e62844651e9">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3a258e3c-10cd-4b66-9918-3fc9abcac5e1"/>
+				</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="1.0" lineStyle="Solid" lineColor="#000000"/>
+					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+				</box>
+				<textElement textAlignment="Left" verticalAlignment="Middle">
+					<font size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Brand]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="246" y="1" width="54" height="20" forecolor="#3D5959" uuid="39d12e92-0464-4c79-a430-4e9d73225a8a">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/>
+				</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="1.0" lineStyle="Solid" lineColor="#000000"/>
+					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Quantity]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="300" y="1" width="72" height="20" forecolor="#3D5959" uuid="b07e0e71-d652-448f-8901-e60b70f894a4">
+					<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="1.0" lineStyle="Solid" lineColor="#000000"/>
+					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle">
+					<font size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Unit Price]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="460" y="1" width="96" height="20" forecolor="#3D5959" uuid="eb2db65e-36ab-4cdc-ad98-2d0a2b6d5c83">
+					<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="1.0" lineStyle="Solid" lineColor="#000000"/>
+					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+				</box>
+				<textElement textAlignment="Center" verticalAlignment="Middle">
+					<font size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Gambar]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="372" y="1" width="88" height="20" forecolor="#3D5959" uuid="4a4b093a-6a76-41bc-97e2-948104309393">
+					<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="1.0" lineStyle="Solid" lineColor="#000000"/>
+					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle">
+					<font size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Total]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="0" y="1" width="126" height="20" forecolor="#3D5959" uuid="395e9288-dad6-44a2-b131-1dbd448bf490">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="69ab7207-5108-44e3-b756-df99df8c269a"/>
+				</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="1.0" lineStyle="Solid" lineColor="#000000"/>
+					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+				</box>
+				<textElement textAlignment="Left" verticalAlignment="Middle">
+					<font size="8" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Nama Product]]></text>
+			</staticText>
+		</band>
+	</columnHeader>
+	<detail>
+		<band height="51" splitType="Stretch">
+			<image hAlign="Center" onErrorType="Blank">
+				<reportElement x="460" y="0" width="96" height="50" isRemoveLineWhenBlank="true" uuid="a9b50876-65d5-4e35-8b7f-7ef9e216dbb7">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="cc4a5789-2434-434e-b7f5-03f64145e6ad"/>
+					<property name="com.jaspersoft.studio.unit.width" value="px"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0" lineStyle="Solid"/>
+					<topPen lineWidth="1.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>
+				<imageExpression><![CDATA[$F{Product_Image-image_small}]]></imageExpression>
+			</image>
+			<textField isBlankWhenNull="false">
+				<reportElement x="126" y="0" width="70" height="50" uuid="0ce11ea3-eb06-4a3a-aa2a-9542c27a8f4f">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="dadf5eab-a8f3-4f55-b718-dcdd6449d2a2"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0" lineStyle="Solid"/>
+					<topPen lineWidth="1.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="Left" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$F{Internal_Reference-default_code}]]></textFieldExpression>
+			</textField>
+			<textField isBlankWhenNull="false">
+				<reportElement x="276" y="0" width="24" height="50" uuid="1aa08123-9a3b-4d26-8831-02ef3e3fae51"/>
+				<box>
+					<topPen lineWidth="1.0"/>
+					<bottomPen lineWidth="0.0"/>
+				</box>
+				<textElement textAlignment="Left" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$F{Unit_of_Measure-name}]]></textFieldExpression>
+			</textField>
+			<textField isBlankWhenNull="false">
+				<reportElement x="196" y="0" width="50" height="50" uuid="15ea9ab0-a0a1-4d3e-a27c-96d98485be62"/>
+				<box>
+					<topPen lineWidth="1.0"/>
+					<bottomPen lineWidth="0.0"/>
+				</box>
+				<textElement textAlignment="Left" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$F{Manufactures-x_manufacture}]]></textFieldExpression>
+			</textField>
+			<textField pattern="#,##0.00#;(#,##0.00#-)">
+				<reportElement x="300" y="0" width="72" height="50" uuid="3bb4eedf-c149-4391-8099-cd17b035ecfd"/>
+				<box>
+					<pen lineWidth="1.0"/>
+					<topPen lineWidth="1.0"/>
+					<leftPen lineWidth="0.0"/>
+					<bottomPen lineWidth="0.0"/>
+					<rightPen lineWidth="0.0"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$V{PriceUnit}]]></textFieldExpression>
+			</textField>
+			<textField pattern="#,###.00#;(#,###.00#-)">
+				<reportElement x="372" y="0" width="88" height="50" uuid="c1d4f8e9-bb8f-40be-ad3f-61e93928df3b"/>
+				<box>
+					<pen lineWidth="1.0"/>
+					<topPen lineWidth="1.0"/>
+					<leftPen lineWidth="0.0"/>
+					<bottomPen lineWidth="0.0"/>
+					<rightPen lineWidth="0.0"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$V{Amount}]]></textFieldExpression>
+			</textField>
+			<textField isBlankWhenNull="true">
+				<reportElement x="246" y="0" width="30" height="50" uuid="cbad73db-a978-4e1e-9a79-3d434f0ff51c">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="4a3a7752-dc0e-4af0-9883-7f049412b89e"/>
+				</reportElement>
+				<box>
+					<topPen lineWidth="1.0"/>
+				</box>
+				<textElement verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$F{Quantity-product_uom_qty}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="0" y="0" width="126" height="50" uuid="ac174790-d132-4f88-88e3-a814c4191de8">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="56b97ace-7223-4ae6-ba51-39cdb8d179e3"/>
+				</reportElement>
+				<box>
+					<topPen lineWidth="1.0"/>
+				</box>
+				<textElement verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$F{Description-name}]]></textFieldExpression>
+			</textField>
+		</band>
+	</detail>
+	<pageFooter>
+		<band height="39">
+			<staticText>
+				<reportElement x="231" y="5" width="120" height="14" uuid="64fded97-ed54-4055-8256-4266e96eff70"/>
+				<text><![CDATA[https://Indoteknik.com]]></text>
+			</staticText>
+			<textField evaluationTime="Report">
+				<reportElement x="286" y="18" width="40" height="20" uuid="ecca9a9f-4ed5-4731-970a-e5717a472e2c"/>
+				<textElement textAlignment="Left"/>
+				<textFieldExpression><![CDATA[" of " + $V{PAGE_NUMBER}]]></textFieldExpression>
+			</textField>
+			<line>
+				<reportElement x="-1" y="2" width="560" height="1" uuid="a1a17ab1-3e8e-4e16-9237-513a7c646906"/>
+			</line>
+			<textField>
+				<reportElement x="246" y="18" width="40" height="20" uuid="debb9eb2-8e91-46f4-99b5-b1b7a485d6b6"/>
+				<textElement textAlignment="Right"/>
+				<textFieldExpression><![CDATA["Page " + $V{PAGE_NUMBER}]]></textFieldExpression>
+			</textField>
+		</band>
+	</pageFooter>
+	<summary>
+		<band height="264">
+			<line>
+				<reportElement x="381" y="3" width="176" height="1" uuid="f9d3c5a2-8321-4b76-81e6-66d70abeb0aa"/>
+				<graphicElement>
+					<pen lineWidth="1.0"/>
+				</graphicElement>
+			</line>
+			<staticText>
+				<reportElement x="381" y="93" width="56" height="20" forecolor="#AF171D" uuid="93c62d9c-a1bf-4433-a928-a0444e8fb242">
+					<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>
+			<staticText>
+				<reportElement x="2" y="120" width="556" height="40" uuid="698ac1df-f661-4e72-8166-37bde455c352"/>
+				<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.
+]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="437" y="53" width="43" height="20" uuid="67b996f7-8233-45c1-ab3a-9c4f7debde8c">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/>
+				</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="false"/>
+				</textElement>
+				<text><![CDATA[Rp]]></text>
+			</staticText>
+			<textField pattern="#,###.00#;(#,###.00#-)" isBlankWhenNull="true">
+				<reportElement x="480" y="13" width="76" height="20" uuid="47a95556-dad6-4b82-902f-98e84869af86"/>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$V{subtotal}]]></textFieldExpression>
+			</textField>
+			<line direction="BottomUp">
+				<reportElement x="381" y="43" width="176" height="1" uuid="6f5ae847-0aed-401f-8454-4c41e92b02cd"/>
+				<graphicElement>
+					<pen lineWidth="0.5"/>
+				</graphicElement>
+			</line>
+			<line>
+				<reportElement x="381" y="83" width="176" height="1" uuid="fe5bba9f-3ca7-48b5-b553-e17c89f4a75f"/>
+				<graphicElement>
+					<pen lineWidth="1.0"/>
+				</graphicElement>
+			</line>
+			<staticText>
+				<reportElement x="1" y="170" width="556" height="40" uuid="9d700a0d-5d35-4eb5-97d7-eddcd069c1dd"/>
+				<text><![CDATA[Data Bank PT. INDOTEKNIK DOTCOM GEMILANG
+BCA CAB. PURI BOTANICAL Acc. No. 8870 4000 81
+Pembayaran giro/cek dinyatakan lunas hanya setelah pencairan.
+]]></text>
+			</staticText>
+			<textField pattern="#,###.00#;(#,###.00#-)" isBlankWhenNull="false">
+				<reportElement x="480" y="53" width="76" height="20" uuid="bd23120c-46ba-4860-b819-53c7d034ff88"/>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$V{taxes}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="437" y="93" width="43" height="20" uuid="f6f2526b-b820-4127-9174-2894b4bc2edb">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/>
+				</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="false"/>
+				</textElement>
+				<text><![CDATA[Rp]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="381" y="53" width="56" height="20" uuid="7be591e6-712d-4ef2-b299-a74867fafac3">
+					<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="381" y="13" width="56" height="20" forecolor="#AF171D" uuid="ed88011f-ed01-4682-9620-3c16d7d208d6">
+					<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>
+			<staticText>
+				<reportElement x="437" y="13" width="43" height="20" uuid="bd4d3945-73e1-4778-8130-9c819ccdfe4a">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/>
+				</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="false"/>
+				</textElement>
+				<text><![CDATA[Rp]]></text>
+			</staticText>
+			<textField pattern="#,###.00#;(#,###.00#-)" isBlankWhenNull="true">
+				<reportElement x="480" y="93" width="76" height="20" uuid="cf0d483a-dc98-412c-b1a6-32651a4eff2f"/>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$V{grand_total}]]></textFieldExpression>
+			</textField>
+		</band>
+	</summary>
+</jasperReport>
-- 
cgit v1.2.3