diff options
Diffstat (limited to 'jasper_reports/custom_reports/image_sales.jrxml')
| -rw-r--r-- | jasper_reports/custom_reports/image_sales.jrxml | 395 |
1 files changed, 395 insertions, 0 deletions
diff --git a/jasper_reports/custom_reports/image_sales.jrxml b/jasper_reports/custom_reports/image_sales.jrxml new file mode 100644 index 0000000..97c173d --- /dev/null +++ b/jasper_reports/custom_reports/image_sales.jrxml @@ -0,0 +1,395 @@ +<?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="image_sales" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="1bd9cf3f-928c-4633-a593-8a875697661c"> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="sale order line.jrdax"/> + <property name="com.jaspersoft.studio.unit." value="pixel"/> + <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/> + <property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/> + <property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/> + <property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/> + <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/> + <property name="ODOO_RELATIONS"> + <![CDATA[['order_id']]]> + </property> + <property name="net.sf.jasperreports.data.adapter" value="sale order line.jrdax"/> + <queryString language="XPath"> + <![CDATA[]]> + </queryString> + <field name="Product_Image-image_small" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Product_Image-image_small"/> + <fieldDescription><![CDATA[/data/record/Product_Image-image_small]]></fieldDescription> + </field> + <field name="Salesperson-user_id" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Reference-order_id/Salesperson-user_id"/> + <fieldDescription><![CDATA[/data/record/Order_Reference-order_id/Salesperson-user_id]]></fieldDescription> + </field> + <field name="Expiration-validity_date" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Reference-order_id/Expiration-validity_date"/> + <fieldDescription><![CDATA[/data/record/Order_Reference-order_id/Expiration-validity_date]]></fieldDescription> + </field> + <field name="Total-amount_total" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Reference-order_id/Total-amount_total"/> + <fieldDescription><![CDATA[/data/record/Order_Reference-order_id/Total-amount_total]]></fieldDescription> + </field> + <field name="Untaxed_Amount-amount_untaxed" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Reference-order_id/Untaxed_Amount-amount_untaxed"/> + <fieldDescription><![CDATA[/data/record/Order_Reference-order_id/Untaxed_Amount-amount_untaxed]]></fieldDescription> + </field> + <field name="Order_Reference-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Reference-order_id/Order_Reference-name"/> + <fieldDescription><![CDATA[/data/record/Order_Reference-order_id/Order_Reference-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_Reference-order_id/Order_Date-date_order"/> + <fieldDescription><![CDATA[/data/record/Order_Reference-order_id/Order_Date-date_order]]></fieldDescription> + </field> + <field name="Product-product_id" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Product-product_id"/> + <fieldDescription><![CDATA[/data/record/Product-product_id]]></fieldDescription> + </field> + <field name="Internal_Reference-default_code" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Product-product_id/Internal_Reference-default_code"/> + <fieldDescription><![CDATA[/data/record/Product-product_id/Internal_Reference-default_code]]></fieldDescription> + </field> + <field name="Description-description" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Product-product_id/Description-description"/> + <fieldDescription><![CDATA[/data/record/Product-product_id/Description-description]]></fieldDescription> + </field> + <field name="Image-image_1920" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Product-product_id/Image-image_1920"/> + <fieldDescription><![CDATA[/data/record/Product-product_id/Image-image_1920]]></fieldDescription> + </field> + <field name="Name-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Product-product_id/Name-name"/> + <fieldDescription><![CDATA[/data/record/Product-product_id/Name-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="Unit_of_Measure-product_uom" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Unit_of_Measure-product_uom"/> + <fieldDescription><![CDATA[/data/record/Unit_of_Measure-product_uom]]></fieldDescription> + </field> + <field name="Quantity-product_uom_qty" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Quantity-product_uom_qty"/> + <fieldDescription><![CDATA[/data/record/Quantity-product_uom_qty]]></fieldDescription> + </field> + <field name="Unit_Price-price_unit" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Unit_Price-price_unit"/> + <fieldDescription><![CDATA[/data/record/Unit_Price-price_unit]]></fieldDescription> + </field> + <field name="Subtotal-price_subtotal" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Subtotal-price_subtotal"/> + <fieldDescription><![CDATA[/data/record/Subtotal-price_subtotal]]></fieldDescription> + </field> + <field name="Customer-partner_id" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Reference-order_id/Customer-partner_id"/> + <fieldDescription><![CDATA[/data/record/Order_Reference-order_id/Customer-partner_id]]></fieldDescription> + </field> + <field name="Street-street" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Reference-order_id/Customer-partner_id/Street-street"/> + <fieldDescription><![CDATA[/data/record/Order_Reference-order_id/Customer-partner_id/Street-street]]></fieldDescription> + </field> + <field name="Taxes-amount_tax" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Reference-order_id/Taxes-amount_tax"/> + <fieldDescription><![CDATA[/data/record/Order_Reference-order_id/Taxes-amount_tax]]></fieldDescription> + </field> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="94" splitType="Stretch"> + <staticText> + <reportElement x="0" y="0" width="270" height="70" uuid="3afafdd6-db9d-41e4-8b61-90ecf8ee3264"/> + <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> + <columnHeader> + <band height="21" splitType="Stretch"> + <staticText> + <reportElement x="-10" y="0" width="80" height="20" uuid="85291110-2c03-45bd-a61b-ff89f9e608bb"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Item Code dan Type]]></text> + </staticText> + <staticText> + <reportElement x="70" y="0" width="40" height="20" uuid="eb16d31e-fd57-4b0f-b0a7-a27a818991c1"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3a258e3c-10cd-4b66-9918-3fc9abcac5e1"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Brand]]></text> + </staticText> + <staticText> + <reportElement x="110" y="0" width="140" height="20" uuid="fb3aa397-7ae6-46ab-a849-c1efc7cba9c2"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="69ab7207-5108-44e3-b756-df99df8c269a"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Nama Product dan Spesifikasi]]></text> + </staticText> + <staticText> + <reportElement x="250" y="0" width="40" height="20" uuid="e044b327-ff1c-49cf-9521-8c908354b5a7"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Qty Total]]></text> + </staticText> + <staticText> + <reportElement x="360" y="0" width="30" height="20" uuid="ff90e926-55d0-4905-b948-6ea13eacebf8"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[UOM]]></text> + </staticText> + <staticText> + <reportElement x="290" y="0" width="70" height="20" uuid="fe41858a-8fc0-4b44-9877-1565eb97ad1e"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="289181ee-1809-46e9-8ad9-2b44772e6161"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Harga]]></text> + </staticText> + <staticText> + <reportElement x="390" y="0" width="70" height="20" uuid="991f5dba-e858-4b95-99fc-384e32d32d6a"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Total]]></text> + </staticText> + <staticText> + <reportElement x="460" y="0" width="100" height="20" uuid="89428b2e-b9ec-469d-9b67-b01ae5e8ea8e"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Gambar]]></text> + </staticText> + </band> + </columnHeader> + <detail> + <band height="34" splitType="Stretch"> + <textField> + <reportElement x="-10" y="-1" width="80" height="35" uuid="57fc9731-ecbf-4c0d-b121-f0d1657dfe86"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="da3a8241-5139-428d-8169-83cbe68e4e76"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Internal_Reference-default_code}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="70" y="-2" width="40" height="36" uuid="de12649b-c028-4e8e-8ad1-478d8d5bad2f"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="7dc815ef-27fa-4ef0-8e7b-44ef038a97fd"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Name-x_name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="110" y="-1" width="70" height="35" uuid="d5dfa8cf-0ca8-4e36-b11f-1608da13afda"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a0baa39b-ccb8-4b0c-a392-562319adf5dc"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Name-name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="180" y="-1" width="70" height="35" uuid="7c0b9224-bc25-486f-8194-1db3f205d11e"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6fd8c0b1-2caa-458c-b624-2f93d4f1e08e"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Description-description}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="250" y="-1" width="40" height="35" uuid="187c79a0-8647-42b7-aaa6-a91709ae1201"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="eb77f130-c776-4a15-bad1-85a5f18b3d50"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Quantity-product_uom_qty}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="290" y="-2" width="70" height="36" uuid="39cc2b53-6ba5-407e-bb37-1295ded950cd"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="62bfc8db-90fc-4863-8efb-3d27060abe7a"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Unit_Price-price_unit}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="360" y="-1" width="30" height="35" uuid="e8b0a651-f658-443e-87f8-efc73e25fa3e"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="422fd1dd-889c-4149-948b-5cb9d039f738"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Unit_of_Measure-product_uom}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="390" y="-1" width="70" height="35" uuid="4491a289-7077-4e16-a635-9cb2f1d4584a"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="32401692-e12a-4897-996b-a3cf8420c4f4"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Subtotal-price_subtotal}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="460" y="-1" width="100" height="35" uuid="98ada646-de4e-41c7-8689-c55c3d51d5c0"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e0177552-280e-42c7-8636-4bf1853f3c6d"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Product_Image-image_small}]]></textFieldExpression> + </textField> + </band> + </detail> + <summary> + <band height="97" splitType="Stretch"> + <textField> + <reportElement x="240" y="60" width="40" height="20" uuid="a20bb2b6-244c-47fa-958b-604aeef6ccbc"/> + <textElement textAlignment="Right"/> + <textFieldExpression><![CDATA["Page " + $V{PAGE_NUMBER}]]></textFieldExpression> + </textField> + <textField evaluationTime="Report"> + <reportElement x="280" y="60" width="40" height="20" uuid="e90f84c4-3e7d-4c83-a6db-ed743b57248f"/> + <textElement textAlignment="Left"/> + <textFieldExpression><![CDATA[" of " + $V{PAGE_NUMBER}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="460" y="0" width="100" height="20" uuid="a03b8e0b-5646-4bea-acfe-4682b6ef2cb7"/> + <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Untaxed_Amount-amount_untaxed}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="390" y="0" width="70" height="20" uuid="0aa43a52-9384-4e6f-9836-87590758658f"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/> + </reportElement> + <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="false"/> + </textElement> + <text><![CDATA[Subtotal]]></text> + </staticText> + <textField> + <reportElement x="460" y="20" width="100" height="20" uuid="53dd52e5-2fc2-404e-a8a2-f7335838c051"/> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Taxes-amount_tax}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="390" y="20" width="70" height="20" uuid="8197540a-690b-48bf-a386-da6045a8999d"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/> + </reportElement> + <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="false"/> + </textElement> + <text><![CDATA[Taxes]]></text> + </staticText> + <staticText> + <reportElement x="390" y="40" width="70" height="20" uuid="2289c0ab-fb41-46ca-a14a-bd83350e45f7"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/> + </reportElement> + <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="false"/> + </textElement> + <text><![CDATA[Total]]></text> + </staticText> + <textField> + <reportElement x="460" y="40" width="100" height="20" uuid="035a6928-2485-4d5e-be45-5fd627991217"/> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Total-amount_total}]]></textFieldExpression> + </textField> + </band> + </summary> +</jasperReport> |