summaryrefslogtreecommitdiff
path: root/jasper_reports/custom_reports/saleorderimage.jrxml
diff options
context:
space:
mode:
Diffstat (limited to 'jasper_reports/custom_reports/saleorderimage.jrxml')
-rw-r--r--jasper_reports/custom_reports/saleorderimage.jrxml609
1 files changed, 609 insertions, 0 deletions
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>